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 Apps / Trying to get parseJSO...
Power Apps
Unanswered

Trying to get parseJSON saved in a array variable in power automate

(0) ShareShare
ReportReport
Posted on by 18

So, I have a flow where I made a query that gives the value from a list rows action I am trying to parse the JSON so it gives the station names in a an array that I can then use and loop through the array to list out the station names in an email. 

Here is my list rows
Bacon1_1-1707920158684.png

Then here is my parseJSON that follows

Bacon1_2-1707920205672.png

Then the step that follows the parseJSON

Bacon1_3-1707920242109.png

 

I guess where I am confused, and still trying to figure out is what the value of the variable in the apply to each is going to be? When the schema was set up as an object instead of an array I had access to pod_names but because the schema is an array I only have body that it lets me use from the parse JSON step. Any help would be appreciated. 

 
 

 



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

    Hi Bacon1,

     

    The value of the ParseJson [body] will return a parsed JSON string.

     

    An approach you can take, is to get the values from List Rows in the Apply to each and then adding the JSON schema as the value for Append to array variable. It should then be possible to map the Dynamic Content from List Rows to the JSON objects in the schema.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 316 Most Valuable Professional

#2
11manish Profile Picture

11manish 242

#3
Valantis Profile Picture

Valantis 198

Last 30 days Overall leaderboard