You’re offline. This is a read only version of the page.
15
I have a SharePoint list where one of the columns is a multi-line text column containing a JSON formatted string of data. The data is flat. For example:
Share
Report[
{
"name1": "123",
"name2": "456",
"name3": "789"
}
]
There are currently 36 name:value pairs in the real data. The names are static now but can be changed, removed, or added down the road.
My flow successfully reads a different SharePoint list to determine which name to look at in the JSON data then reads and parses the data and gets the appropriate value. So it is referencing the name to look at by a Compose "variable". All great so far.
In the flow, I need to update a value for one of the names, again referenced by a Compose "variable", in the JSON data then update the SharePoint list JSON data. I was hoping to use setProperty, but that is for objects and I can't get an object to work because Initialize Variable must be in the top level and Set Variable in my Apply To Each won't update from a string or array.
At this point I'm going to have to try using string manipulation to update the original JSON string from the SharePoint list then send it back. Am I missing something?
Hi @MattPawlak ,
I've made a test for your reference:
My flow:
All responses (
Answers (
array(setProperty(variables('tampArray')[0], 'name3', 'NewValue'))Result:
Best Regards,
Bof
