Unanswered

JSON output Apply to each help

(0) Share

Report

Posted on by BenConway

Hi I have a flow where Chat GPT extracts fields from a PDF and outputs them in JSON to be added to an excel table. This is the section of the flow in question.

With some PDFs it extract multiple rows and so the output is:

[

{},

}

How do I use this in an Apply to each loop so that I can do the necessary data manipulation and input each row into excel?

Thanks for your help ahead!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Geeks_D 1,169 on at

Like (0)

Report

Re: JSON output Apply to each help

Use a select function to get each record from the Parse JSON body
Then use an apply to each for the body of the select to input the records in your excel

Was this reply helpful? Yes No
Henderson87 83 on at

Like (0)

Report
Re: JSON output Apply to each help

@BenConway
You should be able to do the following. Which really just helps power automate understand everything is an array.

initialize array variable (leave contents blank)
Append to array variable(JSON contents)
Apply to each on the variable
You can then use the Items() function to sort through the JSON.

Was this reply helpful? Yes No