Although "Parse JSON" is not made to process complex JSON objects, we can always break the complex object into simple ones and use it effectively. This video shows you how :)
@lymitutit3046
3 жыл бұрын
Hello , I've watched some of your vides. They are very clear and understandable, but for my intermediate level in Power Automate , Array. I'm struggling with a simple selecting ( filtering out) some values from an array variable. I'm not very familiar witht he indexs in Arrays. If you have any idea how to do it, it would be very helpful for me. Thank you for your understanding.
@AlirezaAliabadi
3 жыл бұрын
@@lymitutit3046 Message me on LinkedIn and I will give you some advice on working with arrays :)
@pauljoneseyboy9615
10 ай бұрын
I have looked at dozens of videos on this subject but only grasped it from this one! Thanks so much man
@LapaConsult_Ex_Macraris
3 жыл бұрын
Thank you! Great insight
@cBadArsBiker1579
Жыл бұрын
the parse json variables are all string, not integer. How do you get the integer values from the JSON Array?
@rare3197
3 жыл бұрын
Thank you for excellent video. Is there anyway to get the json object from weblink instead of pasting the actual json object into value field?
@alanmonaghan9194
2 жыл бұрын
Yes please. Me too.
@TomaszMalkiewicz
2 жыл бұрын
Thanks for very informative video. I have one issue that I am trying to resolve. I am getting my json data from http response. The api I am connecting to sends response back paginated. I know how many objects are in total as well as I know the page size. I can actually include it in a url parameter items per page. Would you have a solution on how to iterate through all pages and produce one json with all items in it? Need it for my powerBi project. Thank you in advance
@StephenPryke
3 жыл бұрын
With the Sascha Baron Cohen example at the beginning, how would you get the children? These seem to be objects within the json each surrounded by {}
@AlirezaAliabadi
3 жыл бұрын
You follow the same rule with expressions. Object.property.property and same way goes on to any level while with Parse JSON parsing a multi level object is quite a challenge.
@georgeadamopoulos3415
Ай бұрын
Thank you for the informative video. Just started using Power Automate and your videos were very helpful to familiarize myself with different methods of parsing JSON (watched your other video too where you just select and create csv table) and the syntax and commands to use. I was playing with the Parse JSON action today at work and couldn't get it to work. Now realize my sample schema was incorrect. Look forward to applying this knowledge. Thanks again.
@manipathak7721
2 ай бұрын
Hey ali, i have a problem statement. Can you please guide me on that? "' I have input json having different schema which can change based on client, and we need to convert incoming json to different json format which will be standard and fixed. Can we have a azure AI solutiin to generate the code in c# or any other language?
@vmanikandhar8295
2 жыл бұрын
Such a pathetic Powerapps. Parsing JSON is basic operation we need in today's world.
@Dinkleberg106
Жыл бұрын
Just wanted you to know that you absolutely made the day of an absolute stranger almost 3 years later
@dreambymana4981
3 жыл бұрын
Can you upload videos where you can parse e-mail body which is in table format and upload the data to excel please.
@jaggyjut
Жыл бұрын
What if we want to create a json with nested array from excel
@aaaaa601
2 жыл бұрын
👏👏👏👍👍👍🙋♂️🙋♂️🙋♂️🙋♂️
@juliantagell1891
3 жыл бұрын
Great one Alireza, such a clear explanation... Happy to show you how I ended up doing it, in the end. Slightly differently to yourself
@eladiobardelli3001
3 жыл бұрын
Gracias Alireza que gran video, saludos desde Chile.
@ousselg1509
Жыл бұрын
If you don't want to use apply to each how would you do it? I really dislike apply to each as it ruins the flow sometimes and takes ages to complete complex flows. Can you maybe do a video about selecting complex array object (like attachment name when using get emails for example). The only way I know how to do it is either apply to each or using first expression but sometimes you don't want just the first but want all names and then separate them. I hope you can make something akin to this
@pradeepjamkhandi143
2 жыл бұрын
Very nice explaination, I have question though, if I have the value lets say 'Aliabadi', then I want to know whther it is a Last name or First Name? from the current JSON list. can you please help with that.
@bharanbopanna9910
2 жыл бұрын
Thank you for making this process easy to understand. The JSON file that I'm working with has >100000 lines, and when I copy this to Power Automate the program turns unresponsive. Is there a way around this?
@robertopolo3073
3 жыл бұрын
Hello I hope you are well. I require your help in a challenge that is costing me more than I thought. I am doing 3 HTTP queries that return a JSON as a response with the same structure for all 3 queries. The challenge I have is that I need the 3 queries to be a single one and then send them to Powerapps and I have not managed to get a single JSON that I can send to the application and store it in a collection. I don't know how to join all those queries in a single JSON. Could someone give me a hand? That each query is performed within a Do until, that is, each query must be stored in a variable or something to get all the queries at the end of the "Do until" loop. I apologize for my english.
@antonioskokiantonis7051
7 ай бұрын
Great!
@juliancrentz4485
2 жыл бұрын
Hi Alireza, thank you for this insightful tutorial, I tried this 'trick‘ you mentioned with simplifiying the json, so far Azure accepts the simplified schema, but when I actually run it with sample payload it takes the whole payload and uses that while parsing. It just skips the simplified one I provide. That‘s so weird, I need to escape json arrays, but this doesnt work somehow
@EugeneNaumenko_Music
3 жыл бұрын
Thanks for the video. I did it in the same way but Add a row activity displays error that result is object but required array
@rishiagrawal9613
Жыл бұрын
Thanks!
@wairya
2 жыл бұрын
Thankyou so much Alireza for explaining in depth the drawback as well as the process
@mehdielghozail9633
3 жыл бұрын
Thank you for this video ! I'm wondering if it's possible to populate images (from an image column type in SharePoint list) in word with power automate.
@ThomasBrunkard
2 жыл бұрын
The first three minutes of this video saved me tonight! Thank you so much!
@donnamareepakinga1269
2 жыл бұрын
This is amazing! Thank you so much for this video, it was excellent.
@kazazaj
2 жыл бұрын
THANK YOU! Great video, super helpful.
@AlexBohlen
3 жыл бұрын
Thank you big time for this video! Very clear and super helpful! (now i feel much smarter :) )
@rafaelchavesquaresma8652
Жыл бұрын
Congrats for this great class! Thank u very much!
@shobhanamuralidharan7819
3 жыл бұрын
How can we convert the date field? I have a field Date and when I add the row with this data, it updates with a whole number.
@MsJanaka2010
3 жыл бұрын
Thank you and can I know how to select value from payments array as well.
@mogoodi1
2 жыл бұрын
Thanks, very instructive and concise!
@arshad801
3 жыл бұрын
What an amazing way of explaining this feature. I have been using logic apps and flow for over an year but by far the best video..thank you so much
Пікірлер: 42