
Announcements
Hi, I was trying to create a flow to export Team members from a Team group to an excel/.csv file. I used the List group Members Action with the Instant cloud flow. Once I run the flow, I get the output in the JSON format in the flow. I am a beginner in using Power Automate so as of now, I copy the JSON output manually and go to json-csv.com and convert it into an excel/.csv file. I do not want to do that manually. Is there any way to add a few more steps in this flow and convert the same JSON output to an excel/.csv file? Is there any simple way to convert it via flow?
Thanks a lot!
You can use Parse JSON and then open your excel and use Add Row in a table... Refer following thread...
https://powerusers.microsoft.com/t5/Building-Flows/JSON-to-Excel-or-CSV-to-Excel/td-p/443890