tikidune's avatar
tikidune
Copper Contributor
Oct 22, 2021
Status:
New

MSGraph API Create TableRow with Formulas

https://docs.microsoft.com/en-us/graph/api/table-post-rows?view=graph-rest-1.0&tabs=http

The MS graph api supports creating rows. The issue I ran into is if I created multiple rows at the same time the last formula used in the column would update all the rest. So using the data below all the rows in the first column would have 342.  I tried it with =Concat as well. Once this is done all the rows now appear to be linked. If I manually entry one at a time via the online interface it works..  I even tried to group them so I would do 2 entries and it still updated all.

{

"values":[

["=Text(\"1235486\", \"?\")", "rest"]

["=Text(\"1235486\", \"?\")", "rest"]

["=Text(\"342\", \"?\")", "rest"]

]

}

No CommentsBe the first to comment