How to get data from JSON objects using expressions in Power Automate. If you want me to create a tutorial about something related to Power Platform, please leave a comment below.
This helped sort out calling array items for me, thank you. Was surprisingly hard to find this exact info. Ended up using a get items with odata filter to pick an array of 1 that maps to the when a file is created trigger, then a get item with the ID from the [0] index of the get items array. handy for getting out of apply to eaches when I know my array has only 1 value. Anyways hoping this comment helps with people searching for this kind of thing...
Thank you a lot. Very simple explanation. Please , keep up uploading more VD on Power automate/expression/variables/ dataOperation , with real business use-case. Thanks
Learnt very basics about JSON from this and previous video of yours. Please continue doing more videos. Can you come up with any real time case or solution that can give us a better use of JSON?
Great video. I was wondering about if you could make one about taking an array of complex json objects with many properties and creating a new array of objects with just a select few properties. Thanks.
What if you wanted to do this to create lines in a excel table, but you want to create a line with each active year and it just repeats the information for the other columns… so the stuff not in a array repeats but it iterates through the array on a new line…. To make it more dynamic where different entries have a different number of items in the array.
Very useful video, however, One quick question: suppose the json keys were like first.name or system.firstname: can you check if your method works? When you do [‘first.name’], flow gives an error saying invalid expression.
Would love how to see how you would pull data out of the Search User v2 connector (or anything pre-made like that) in the same way you are using your demo here with your JSON object! For example, the Mail value out of a JSON object from the Search User v2 connector, and use it within an "Assign to" field. There are tons of scenarios I am discovering like this.
Excellent Alex, you explain clearly so everything looks easy. Can you make another video working on a JSON file with multiple records instead a JSON object variable? That would be really handy! Thanks!
OK, I just discovered how to do the same as shown in this video but using JSON files; use first a file content step with the "Get File Content" action. Next, as the input of the "Parse JSON" action, it is necessary to do two conversions including from base 64 to string as Power Automate manage files as binary even if they are flat files. For example, if the step is called "FileContent", then the conversions for that input would be: base64ToString(base64(outputs('FileContent')?['body'])). It works!
When trying to delete a file in Sharepoint, and action triggered by another deletion in Sharepoint, the error, even though it is a basic one step template action, is "The response is not in a JSON format". Do you know how to fix the problem?
Alex - Thanks for this - It unlocked for me how to access the values of a collection of multi-select choice items (think server names in a SharePoint list column called Servers). I went from getting the entire object to getting the Value of a specific item . item()?['Servers']?[0].Value gets me >> SERVER01. This is good I need to a way to get ALL of the selected item Values dynamically using a similar expression/function call while I am getting the other columns for the row via a select can you help?
