News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows COnvert excel table to...

Power Automate - Building Flows

Answered

COnvert excel table to json format to parse through to Power Automate Desktop flow

Like (0) Share

Report

Report

Posted on 7 Jan 2021 13:50:20 by Community Power Pla...

I have an excel file which I get the rows of in a cloud flow, but I want the table and columns to be converted to json

All responses Img

All responses (3)

Answers Img

Answers (1)

ChrisWhite23 4 on 03 May 2022 at 21:49:39

Like (1)

Report

Re: COnvert excel table to json format to parse through to Power Automate Desktop flow

Where you able to achieve this? I am trying to loop through a spreadsheet to create separate JSON messages per row.
Community Power Pla... on 19 Jan 2021 at 06:23:57

Like (1)

Report

Re: COnvert excel table to json format to parse through to Power Automate Desktop flow

How can I now push the rows of the JSON array into PAD to use with a loop through each separate row?
Verified answer

v-litu-msft on 08 Jan 2021 at 08:50:01

Like (0)

Report

Re: COnvert excel table to json format to parse through to Power Automate Desktop flow

Hi @Anonymous,

After you get rows of an Excel file, you could use Select action converts the rows to a JSON array, for example:

For more information, you could refer to this document:

Understand data operations - Power Automate | Microsoft Docs

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

Leaderboard > Power Automate - Building Flows

#1

Michael E. Gernaey 179 Super User 2025 Season 1

#2

David_MA 161 Super User 2025 Season 1

#3

stampcoin 143

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans