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?
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!
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.
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.
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.
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?
Great video. Short and to the point. Easy to understand, minimal fluff.
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...
Coincido contigo!
Simple, un tema importante y bien resuelto
Amazing tip. I really needed some help getting JSON data out of a tricky nested array, and your video helped me do it. Top Marks.
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
I love your style. Very clear! I hope you can make more Power Automate videos.
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 vedio！
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.
I hear you, K. I am hoping to find more time to do more.
Hi Alex,
Thank you for this Power Automate video. It's really helpful.
Can you please add a few more videos like this in the future as well?
Thanks, Anis! I will try to make time.
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!
@@ricci.hidalgo can you share video, please?
Very useful, thank you!
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.
What if you wanted to extract all the yearsactive objects. What would you do? [0-4]?
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.
you're genial !!
Thanks, this helped
Could you make a video on automating onenotebook which contain different sections, pages and content
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.
very usful!
Awesome dude!
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?
Did Microsoft change the interface of picking the variable at 2:26? I can't seem to get that part to work. I dont have the "fx" button like you do.
Hi will, you just have to turn on experimental features from the settings wheel on top right hand corner.
How to get a list of values from an array of objects?
Thanks! What if you have several entries in your json, not just Alex?..
In that case you would have a JSON array, like so:
[
{"firstName": "Alex"},
{"firstName": "Michael"}
]
I removed the other properties for brevity.
@@AlexTofan how to get an array of names from that?