cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gmaasz
Helper IV
Helper IV

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @gmaasz,

 

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

Screenshot 2021-01-08 164721.jpg

 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.

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @gmaasz,

 

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

Screenshot 2021-01-08 164721.jpg

 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.

View solution in original post

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (76,867)