Power Platform Community Forum Thread Details

There is a SharePoint list with one of string column holding a JSON format string.

Here are the fields:

ID, Title, JSONText

The JSONText have a JSON value like below:

[{"Project":"Project X","Task":"Task Y","Total":20}]

I understand Power Automate provide "Parse JSON" action to break down JSON into values by providing the JSON schema.

However, how can I get "each sharepoint item", "break down JSONText value to multiple values", then return a table like this:

ID, Title, Project, Task, Total

We have about 1000 items in SharePoint list. So I would like to avoid using "For each" loop unless it is the only approach.

My final action is export above table to a CSV file. Could you please give me some idea? Thank you.

Categories:

Building flows

If your JSON data is always formatted as shown above and only the values for project, task and total change, do the following:

Initialize an array variable.
Follow it with a Parse JSON action and create the scheme from the sample data above.
You will then be able to access the values from the dynamic content.

I do have a concern about setting the variable from the SharePoint field, but if it returns exactly what you showed, I think you should be okay. I asked Copilot, and it agrees that as long as your SharePoint list returns the data as shown, it should work.

This is the result of running the flow with your data: