JSON Array in Power Automate - Walkthrough lesson with examples #PowerAutomate #JSON #Array

Learn how to visualize a JSON Array using an online tool, retrieve key values, filter an array, discover the length, and retrieve a list of all values for a particular key e.g. Email. I will walk you through with a demonstration by building a Cloud Flow in Power Automate.

00:00 Intro
00:32 Example Array
02:00 Cloud Flow Demos
02:35 Retrieve single key from Array (Elements cannot only be selected with integer index)
07:48 Filtering an Array
10:00 Apply To Each on Results of Filter Array
11:38 Length of an Array
13:12 List of all Emails from Array
14:51 Other Demo Links and Summary

[johnMpawson]

Thank you - that was so clear and concise.

[csmith]

Amazing video, learned a ton of stuff. Thank you, so much good stuff here!!

[Franklinvaz]

Nice and easy Damo... Love it! Thanks...

[akashjain]

Thanks buddy this was really helpful :)

[PedrodaSilva-id]

Very clear explanations, great content, thank you. I wonder, have you made any content showing how to change properties within the arrays (for example to keep track of a yes/no state for a specific object)? At first thought sounds like something i would only be able to do using array variables.

[ravennasantos]

Excellent! Thank you for sharing this valuable knowledge. It really helped me.

[Keepfaith]

This video was super helpful thank you! I subscribed

[parranoic]

Thank you, I was pulling my hair out. You saved me from a nasty call tomorrow.

[jaggyjut]

Thanks. What if we have a xls file with property attributes like rent, address, no of bedrooms. How can we convert this into an json array pls. I’m trying to use this json in adobe doc generation api to create a table from the json array.

[shiferaw]

I have a question on reading Excel file from OneDrive Busisness. When I use List rows Present in a Table, however, when I upload a new file, it reads the old data. Is there any best way to read from Excel stored from OneDrive to SQL?

[gigibuffon]

Hi, thank you for this video. It has really help me a lot. One question when you iterate to give you all emails the output is an array of all emails. How can I change that instead of returning a array with all email can return a simple text with all emails?

[michaelwaxman]

I would like to take your last step, List All Emails from Array, and use that for a similar flow store each IMAGE URL from my array to a separate field on a Sharepoint list. I need each URL to be in a separate field because my next step is to Populate a Word Document, where I will Get Content from each URL and save it to a distinct Word QuickPart field. How would I handle this, and is it the correct approach? Thank you!

[rajnishrajput]

Thanks for detailed video

I am trying to export data from Power BI Report to CSV which contains a date field and the formatting of date is 2004-01-14T18:30:00.000Z like this instead of dd-mm-yyyy. Is there a way to format a field in the array?

[shaniapereira]

i want to know how to sort array elements in descending order.

[mgtd]

Hi, great video. Attempting to extract a value based on an ID value. If I'm trying to pull the "Current State" only for ID 123, what's the best practice?

{
"ID": 123,
"Current State": "The state is really bad.",
}

[stevenhampson]

Thanks for the quick but effective examples and going into the expressions, explaining what they are doing. Your finger was pointing in the right direction, and now, after watching this, I am also heading in the right direction. Cheers

[alanjwells]

Excellent, I was scratching my head on this one for a while.

[jasonthedogcatcher]

This was fantastic. I was able to sort out my flow in no time with your excellent tutorial. Keep up the great work.

[fayefouladi]

Thank you so much. This worked for me.

[kurthenderson]

Hi Damien, Excellent video, good pace and great information. I was able to follow everything without issue but I'm dealing with a more complex array. One that gets returned from the Get Items SharePoint action. I'm trying to get to a list of emails like what you were doing but the column I'm getting these email values from is a people column with multi select enabled. In looking at the object that comes from the Get Items action, what I'm trying to get to is Object -> body -> value -> PeopleColumn -> Email. I just want to get a list of these emails so I can use them in a CC of an email. Any suggestions?