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 / How to get collection ...
Power Automate
Answered

How to get collection data and parse to Json using flow and powerapps

(0) ShareShare
ReportReport
Posted on by 825

Hi All, 

I'm trying to create a flow using power apps and power automate, how ever  I tried to find some solution using the forum and google posts but I'm unable to figure out what ways can the object be converted to Json, as the error says expected Object but received string. 

The workflow goes as such, 

Firstly, I'm creating a collection in power apps, and sending all that collection to flow and then converting it to CSV and adding that to the SharePoint document folder. I tried it to do this step by step it by first get the data from power apps and use COMPOSE action to create a Schema, and then add to Parse JSON but i get the error saying expected Object but received Array. 

Can anyone give me any idea what I m doing wrong or missing the key factor here? Thank you all experts in advance. 🙂
Please see the screen shot below: 

Tapesh_0-1605611463542.png

Tapesh_1-1605611491278.png

Also, it is trying to create multiple files for the collection whereas I want to create one file for each one when the flow triggers.  

Tapesh_2-1605611573687.png

 





Thanks 

 

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,026 Most Valuable Professional on at

    Can you show the error message associated with the ParseJSON step in the flow?

  • Verified answer
    Tapesh Profile Picture
    825 on at

    Hi @Pstork1 

    Thanks for the help and response and also sorry for the delay in reply, I actually found the solution to this, that what was the missing puzzle. 


    Solution:

     

    There was an error in the collection (PowerApps) when getting the data, the formate was not converted to JSON as below and this worked fine. 

    Set(VarFormatJSON, JSON(ExportColGal4, JSONFormat.IndentFour ));

    Regards 

    Tapesh 

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard