I try to create a flow in Power Automate from an article I found on the internet: John Liu article But I get an error saying: bad format JSON-stream

What I try to do is: Change a value from the metadata column "Modified By" of a certain row in a Sharepoint list with PowerAutomate.

But it seems the JSON-code isn't correct:

enter image description here

little question about the uri:

enter image description here

Does "items(1)" refer to the first row of the sharepoint list?

Greetings, Peter

  • Not sure if this is it, but the "k" in "Key" is capitalized in John's blog post but it is not in the JSON you posted. Apr 1, 2021 at 14:31
  • Also, John used a Compose action for the user value and a second Compose for the FieldName/FieldValue pairs. I've found that this is sometimes required for string composition to work correctly in Power Automate. Apr 1, 2021 at 14:33

1 Answer 1


Items(1) is not the first line of the shared point list, and "1" is the unique ID of the list item.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.