MSGraph API: Error on adding row(s) to workbook table if not all columns are passed

Yannick Einsweiler 96 Reputation points
2021-07-13T22:03:42.73+00:00

Consider a workbook with a table and a dynamic array formula in column 3 e.g. a =HYPERLINK() formula based on the value of column 1 and 2.
When adding values for the first 2 columns in desktop or web, table gets automatically expanded and column 3 shows the hyperlink.

However doing the same through the Graph API returns The number of rows or columns in the input array doesn't match the size or dimensions of the range. Basically, the API requires all values to be passed including column 3, which supersedes/overwrites the array formula.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,017 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yannick Einsweiler 96 Reputation points
    2021-07-14T12:21:11.163+00:00

    Well, answering my own question: just pass null for the columns you don't want to fill as '' clears the cell. With null, dynamic array function is applied as expected.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.