Share
ReportI 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
You’re offline. This is a read only version of the page.
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
Where you able to achieve this? I am trying to loop through a spreadsheet to create separate JSON messages per row.
How can I now push the rows of the JSON array into PAD to use with a loop through each separate row?
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.
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
All responses (
Answers (