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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Convert JSON to CSV Ta...
Power Automate
Answered

Convert JSON to CSV Table.

(0) ShareShare
ReportReport
Posted on by 70
Hi All,

I have some JSON data that looks like this, I would need to put this data into a CSV table.
{
    "body": [
        {
            "DeviceID""d01addee-3863-40df-8414-5839f38e3906",
            "Serial""03155760",
            "Reading"948,
            "Date and time""2025-05-01 11:00:12"
        },
        {
            "DeviceID""aef4e76c-da9b-4033-849a-53c71ada2daf",
            "Serial""03155824",
            "Reading"4003,
            "Date and time""2025-05-01 11:00:12"
        },
        {
            "DeviceID""e26dd458-3db3-42c7-8f1d-b108f9c07da2",
            "Serial""03155801",
            "Reading"2264,
            "Date and time""2025-05-02 22:00:12"
        }
    ]
}
However above is the error I am getting when trying to do this, 

This is how my flow looks, it is trying to get the data from the Parse JSON object (copied how the data looks from this above) how would I convert this to an array so that I can use split Item to fill out a CSV table for this data? Or is there something else I can do here?

Hopefully makes sense what I am trying to achieve here. 

Thanks,
B
Categories:
I have the same question (0)
  • Verified answer
    Vejai SH Profile Picture
    560 on at
     
    From your Json object you need to use only the array. No need to parse for this 
     

    Thanks,
    Vejai SH
  • Watkins Profile Picture
    70 on at
    Hi, @

    Thanks, what had confused me was that the values were not showing as an available option when using the select from previous step option, but manually typing them out as a function seems to have worked. 

    I have removed the Parse JSON and done what you've said and it is working now.

    Thanks,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 822

#3
Haque Profile Picture

Haque 482

Last 30 days Overall leaderboard