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.
MSGraph API: Error on adding row(s) to workbook table if not all columns are passed
Yannick Einsweiler
96
Reputation points
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.
Accepted answer
-
Yannick Einsweiler 96 Reputation points
2021-07-14T12:21:11.163+00:00