Unanswered

json Invalid expression

(0) Share

Report

Posted on by andriii

Hi,

I'm trying to update the workbook via http request. It is some kind of a registry file. When some file is uploaded to the folder the registry file is updated.

I use the "Compose" action to create a JSON object that will hold the parameters for the HTTP request. The JSON object looks like this:

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

I get Invalid expression error. Please advice!

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @andriii,

The expression in the row property of the json object looks invalid. I see you are combining an indexOf and a variable with the name AccountName.

Can you share more details about what you want to achieve in that specific expression? This way we can make a suggestion for a valid expression.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @andriii,

I just spotted your other thread, which has a bit more context. It is a Excel file formula 😁

My suggestion would be to use string variables for the rest of the Excel formula.

Try something like below instead:

{ "table": "registry", "column": "L", "row": "@{variables('IndexOf')}@{variables('AccountName')} @{variables('PostIndexOf')}", "value": "uploaded" }

Was this reply helpful? Yes No
andriii 16 on at

Like (0)

Report

Thank you for your time and effort!

Was this reply helpful? Yes No