question

YannickEinsweiler-5677 avatar image
0 Votes"
YannickEinsweiler-5677 asked YannickEinsweiler-5677 edited

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

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-sdk
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YannickEinsweiler-5677 avatar image
0 Votes"
YannickEinsweiler-5677 answered YannickEinsweiler-5677 edited

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.