Power Platform Community Forum Thread Details

Hello, I'm trying to update a worksheet with a http patch request.

https://graph.microsoft.com/v1.0/sites/root/drives/b****4/root:/BS Reconciliations/2023/May/Trial-Balance.xlsm:/workbook/tables('TrialBalance')/rows/itemAt(rowIndex=(match('100500', TrialBalance.[A])), columnId='L')/values

Body:

{
"table": "TrialBalance",
"column": "L",
"row": "=@indexOf({A}, '" & variables('Accountname') & "') + 1",
"value": "uploaded"
}

code": "BadRequest",

"message": "Syntax error at position 42 in 'rowIndex=(match('100500', TrialBalance.[A])), columnId='L''.",

please advice.

Categories:

URI Syntax error