web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Convert JSON output to...
Power Automate
Unanswered

Convert JSON output to excel/.csv

(0) ShareShare
ReportReport
Posted on by

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!

Categories:
I have the same question (0)
  • PrasadAthalye Profile Picture
    on at

    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard