web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows JSON output Apply to e...

Power Automate - Building Flows

Unanswered

JSON output Apply to each help

(0) Share

Report

Report

Posted on by BenConway

38

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:

Business Process Flows

I have the same question (0)

All responses Img

All responses (2)

Answers Img

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

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 691 Super User 2025 Season 2

#2

Tomac 431 Moderator

#3

developerAJ 266

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans