Introduction to Parse JSON in Power Apps | ParseJSON Arrays as Table; Return Array from flow

[@AnilKumar-fr9jo]

I become your fan of study styles & explanation of critical topics in a very simple way. Big thank to you Reza... keep sharing more good videos... :)

[@RezaDorrani]

Thanks a ton

[@Ethan-dd4ln]

You know KZbin is paying well now that Reza is rocking Balmain now!! Love to see it!

[@RezaDorrani]

Balmain is my favorite 🤩

[@DavidPrenticeJr]

This was badly needed for so long!

[@RezaDorrani]

+1

[@noorsyyed]

thanks for the detailed walk through of ParseJson function, this is going to be very useful function

[@RezaDorrani]

Thanks for watching

[@Paul___L]

Thank you, very helpful content I was struggling with the ms guide alone. I'll feel a lot more confident about the data security when I know its only accesssible via a flow, but coming back as an array saves a huge amount of work and keeps if flexible for changes.

[@RezaDorrani]

Great to hear!

[@MikeHatheway]

This is amazing Reza. Great examples with the group memembers and surveys! I can think of so many uses for this.

[@RezaDorrani]

Glad it was helpful!

[@ayushchaudhary6750]

This is working very smoothly. Thanks for sharing this. keep sharing more good videos.

[@RezaDorrani]

Glad to hear that! Thanks for watching

[@frenamakenson9844]

Hi Reza, I’m pretty Shure that was one of the thing that you request to Microsoft 🎉 This is one of the most important feature for power apps…. So many project was waiting for this feature Thx for your Demo man, you’re the master !

[@RezaDorrani]

Thank You! I have a lot of requests :)

[@girlontheswing3942]

Thank you sharing your amazing knowledge on PowerApps.

[@RezaDorrani]

My pleasure!

[@harry44008]

This is exceptional. Very nicely explained. Thank you very much for creating this video.

[@RezaDorrani]

Thanks

[@TheShalabh]

Very well described in concise and real time scenarios. Thanks.

[@RezaDorrani]

You're most welcome!

[@marianaamancio6543]

I love you sincerely and deeply! You save my business life ervey single day!

[@RezaDorrani]

💖

[@stuandrews1618]

Awesome Reza, this has so many use cases, I'm glad MS have spent sometime making this Power FX formula!

[@RezaDorrani]

Glad you like it!

[@ThePayanazo]

As always, high quality content. Thanks Reza keep it up.

[@RezaDorrani]

Appreciate it!

[@tristangeoffroy9286]

Very instructional vid, as always with you. Thank you very much.

[@RezaDorrani]

Most welcome

[@oluwatobiyusuf]

Awesome video Reza. Thanks for the amazing use case

[@RezaDorrani]

Glad to know you liked the use case. Thanks.

[@damiandelgado9872]

Thanks so so so much. You're my hero

[@RezaDorrani]

Thanks Damian

[@nagarajanmm8523]

I was struggling to find a right sample. I should make a habit to check your video for the solution fist. Thanks much.

[@RezaDorrani]

You’re most welcome

[@sharonpaul4925]

Very helpful tutorial

[@RezaDorrani]

Glad it was helpful!

[@MortenSchouenborg]

Great walkthrough, appreciate it!

[@RezaDorrani]

Most welcome

[@juja2819]

Thank you, Reza! :)

[@RezaDorrani]

Most welcome

[@frenamakenson9844]

Amazing demonstration reza

[@RezaDorrani]

Thanks

[@venumadhavravulapalli1463]

Hi Reza, you are amazing with your content quality. Looking for a video on Custom Connectors from scratch in PowerApps

[@RezaDorrani]

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@sundrapillay6668]

Amazing Reza thanks

[@RezaDorrani]

My pleasure

[@frenamakenson9844]

Next step will be calling rest api directly with power fx 🎉

[@RezaDorrani]

+1

[@yakirrabinue3889]

Great explanation! Thanks

[@RezaDorrani]

You're welcome!

[@anantchirmade600]

Edit - Got it it was "select", thank you Hi, in the flow, where it says "Select Member emails" - What is the exact name of the action? is it "Create CSV Table", Create HTML Table, Filter array or Parse JSON? sorry this might be a very dumb question.

[@RezaDorrani]

👍

[@busyshah]

Every thing looks amazing in PowerApps on surface. But then you meet reality where all you do will be of no use given the scalability issues and delegation warnings. I really don't know why one should learn PowerApps in first place. I feel betrayed investing a lot of my precious time learning this.

[@siddharthsaxena4429]

Hi Shahnawaz , Could you please elaborate more on the scalability issue or a document that you can point me to. With this ParseJSON function available , one of our use cases are met and are thinking to create our app in Power apps

[@busyshah]

@@siddharthsaxena4429 kzbin.info/aero/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

[@tristangeoffroy9286]

@@siddharthsaxena4429 Humm… I’m not far from sharing your view. I invested so much on powerapps …then I met the delegation wall,.. so I fall back on model-driven app to save my project. It looks great but response time is often unbearable.

[@RezaDorrani]

Learning about the data source one is connecting to and understanding its delegation limits upfront is more important than directly jumping in to build an app or flow.

[@adedaporh]

There are techniques you can use in working with large data sets on SP. In fact this video hints at one such techniques. Do your research and just keep at it.

[@bonnyboy23]

Thank you so much for this!

[@RezaDorrani]

You're most welcome!

[@maksimdmitrenko]

Thanks Reza. That is real useful function!

[@RezaDorrani]

Glad it was useful!

[@giampaolocarli4728]

Thanks Reza a lot🙏🙏🙏 - I dont see how you trasform the immage from JSON on this Exercise from parse JSON in your gallery- What is the Type of convert ?

[@RezaDorrani]

I have not tested with image but as long as the base64 data is in the json, it should work.

[@ericzheng4838]

Been waiting for it forever!!

[@RezaDorrani]

👍

[@shaikhfirdos2723]

Most useful information.. Thanks Reza..😇

[@RezaDorrani]

Welcome

[@jimmyjohn7490]

Thank you for all the wonderful videos, they have been very helpful on my Powerapps and JSON Journey. I cant sort out a couple of things. I don't want user to have to cut and paste the JSON. How can I set it up so the input is a JSON/text file the user selects and output the table array to a collection rather than a gallery? You say it can be saved as a collection in the video, but I am missing some key steps I think. Thank you!

[@RezaDorrani]

Copy paste was only to demo an example. You can call flow, get json data and send it back to power apps. Many of my recent videos on graph api showcases this.

[@jimmyjohn7490]

@@RezaDorrani thanks. I dont have access to graph api through my organization. Admins don't allow permission for it.

[@RezaDorrani]

@@jimmyjohn7490 You dont need to access graph. You can see the pattern used in video where it sends json back and then traverses through it.

[@iamintractable1805]

Great video. Thanks!!! Seems like ParseJson is a patch to a more fundamental need to be able to pass strongly typed JSON to and from Power Automate in PowerApps. Where is the JSON data type on Respond To action and PowerApps V2 trigger???? This command is not very low code and not citizen developer friendly.

[@RezaDorrani]

In fullness of time. Respond action does not have that option.

[@iamintractable1805]

@@RezaDorrani How will change happen if its not called out...

[@RezaDorrani]

@@iamintractable1805 What change?

[@rakshithsubraj2262]

Thank you for the video. I have one query I have gallery inside a gallery, I need to filter the inside gallery with the outer gallery item. I am using json for the item property in the galleries. Please let me know if this is possible thank you 🙂🙂

[@RezaDorrani]

Most welcome! I do not have a video reference on the mentioned scenario and would have to try it out to know its feasibility or provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@kishorekrishna83]

Helpful

[@RezaDorrani]

Glad to hear that

[@danielwu8660]

Anothet very informative video Reza! A question out of curiorsity, since there are too many that can only be done by those experimental features, do you normally enable them in your actual DEV / PROD environment since they're unsupported?

[@RezaDorrani]

I do not recommend using experimental in production. Microsoft documentation clearly highlights what experimental vs preview vs GA means.

[@mp.p.7096]

wow, thanks

[@RezaDorrani]

👍

[@GergelyCsermely]

Thanks

[@RezaDorrani]

Welcome

[@gejdoss]

Great! This was very helpful. Thank you!

[@RezaDorrani]

Glad it was helpful!

[@asadmehmood7430]

This is a really helpful post. But I am thinking that ParseJSON is an experimental feature and it is not recommended to use such features in Production. Is there any other workaround which can be used in Production?

[@RezaDorrani]

I am not aware of any

[@jiteshdhumal2353]

Hello Reza, I have a scenario where I passed an array to a gallery in my PowerApps application. Within this gallery, I have added two labels and assigned formulas to their Text properties: For Label 1, the formula ThisItem.Value.ColumnName works perfectly well. However, for Label 2, the formula ThisItem.Value.LookUp(MappingMaster, AgentName = Dropdown2.Selected.Value).ColumnName is not functioning correctly. My question is: Can we add a condition-based column after ThisItem.Value? I would appreciate your guidance on how to address this issue.

[@RezaDorrani]

This is something I would have to recreate to know what options are available. I would suggest posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@nawazpathan6099]

Hi Reza it's treat to watch your videos. Need your help on this I'm getting response from power automate to power apps from SharePoint back end one of my column is hyperlink link I need to make that parse JSON text colum should be clickable and launch that url how can we do that any guidance from your side. Response will appreciated 👍 Thanks in advance.. that column value currently is(Text(This item.Value.Link) Showing in gallery)

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@nawazpathan6099]

@@RezaDorrani Thanks 🙏

[@GoWstingray]

Great video as usual Reza, are you going to be doing a video on Named Formulas soon? Thanks

[@RezaDorrani]

I keep my upcoming video ideas under wraps :) Not sure, let's c!

[@satyanarayanach3038]

Hello Reza. Thanks for the great session. I have a question is there any way to brand the PowerApps using JSON file or other things?

[@RezaDorrani]

Possible but not something I have tried

[@satyanarayanach3038]

@@RezaDorrani Thanks for your response. We can do it using custom components but is it possible using JSON file??

[@RezaDorrani]

@@satyanarayanach3038 Yes

[@satyanarayanach3038]

@@RezaDorrani Okay. But unfortunately I am not able to find any reference for this☹️!

[@RezaDorrani]

@@satyanarayanach3038 And I have not tried this either. You will need to attempt this and see what happens. You could also post about this on forums powerusers.microsoft.com

[@rashimalhotra8642]

Hi Reza, I tried this approach for my powerapp, but it's giving an error - JSON parsing error, Expected string but got array. In your video you are also sending array from flow to powerapps.

[@RezaDorrani]

I have not come experienced this issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@jean-philippecharlets3899]

Great explanations. I am just wondering if it is possible to sort the fields in the Gallery based on a column value? Thanks,

[@RezaDorrani]

Possible! In one of the sections of the video, I convert the data into a collection (strongly typed). You could simply sort that collection).

[@jean-philippecharlets3899]

@@RezaDorrani Great. Indeed I applied a sort instead of a filter (at 10:18 in your video): Sort(Table(ParseJSON(Label6.Text)),Text(ThisRecord.Value.Mycolumntosort)). Thanks.

[@popcorn_TM]

Sorry, deleted my previous question, but asking the same thing here again, which data type do I cast a JSON object? ie. JSON that does not start with the square brackets but rather just have the curly brackets. I tried casting it to text and table but it doesn't like either.

[@RezaDorrani]

I believe it would be an Untyped object. May be you could leverage the JSON function. Sorry but this is the best I can do here on chat :) I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@djpowerage]

i am trying to follow along, but when you say "plug in my JSON code" into the textinput control, how?? On the screen I can see Default property of the control is empty, but you have the record type text/JSON schema in the textinput control as text. #confused

[@RezaDorrani]

Simply type it into the text input control. Preview the app and type it in.

[@djpowerage]

@RezaDorrani oh Reza,of course! I got it in my head that you had used a property. Well, I followed the rest of it, and it worked. Thank you so much. I have lots of client folders in SP, and within a specific client record in my canvas app, I am using this Parsejson to pull in all the files & folders from SP to a gallery in my app. Again, thanks

[@dougydoe]

Another excellent Demo as usual. I watched this 2 days ago but realised my tenant hasn't received the ParseJSON function as yet. Checked today and it was in plus changes in the Maker Studio layout as well which was nice. Worked through it as usual and it was good practice. Last week, I worked through something where I used the HTTP Response Premium connector to Parse JSON data from Power Automate into PowerApps. I would imagine I can now use this function to do the same thing instead, and not use the Premium connector. Your thoughts? Thanks again for sharing.

[@RezaDorrani]

You could use this to return data without using Response premium connector.

[@dougydoe]

@@RezaDorrani I though so. Thank you

[@rahulchitte763]

Thanks Reza! ParseJson and untyped objects feature is not available in settings in the latest version. However I can use ParseJson function in powerapps but if I try to read the json response returned from the custom connector into the global variable but it is giving me an untyped error. My json contains a simple key value pair. I tried the method explained in your video but still getting an untyped object error. Any suggestions would be helpful.

[@RezaDorrani]

ParseJSON and untyped objects are now GA and hence the step to enable is not needed. As for your error, I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@gouthamarul3848]

Will be possible to dynamically pass json to datatble .. with dynamic field

[@RezaDorrani]

Not sure about that

[@akhilgopi8991]

But how to see the selected record in a form. I tried, it's not working.

[@RezaDorrani]

I have not tried that. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@krishnamurthyelumalai3751]

Hi Sir- Experimental feature is recommended to use for PROD? And will that impact in future....

[@RezaDorrani]

learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-experimental-preview

[@ResponsibleXI]

Off topic. When is your training portal going live? I am waiting eagerly for advanced topics on Model Driven apps and Dataverse

[@RezaDorrani]

I was planning for it this year but that is not happening. Next year it would be. But not sure when.

[@ianalexandertorres6189]

Hi Rezza, i just found this video. What is the difference when fetching a data using power automate (json) vs a direct connection?

[@RezaDorrani]

Can you give me an Example scenario?

[@ianalexandertorres6189]

from your example, you can fetch the data via power automate and used it on a gallery when you can already connect direclty to a list.

[@RezaDorrani]

@@ianalexandertorres6189 The example showcased is to get SharePoint group members and there is no action in Power App that gets that. I am not querying a list.

[@djpowerage]

Hi Reza, can you or anyone else in the comments, point me in the right direction, on this topic. I now successfully used Flow to bring in the files, store them in a collection, and display them in a gallery. The selected gallery file thumbnail shows in a separate image control. My next step is to select a photo from the gallery, and patch it to my Dataverse table, photo column.

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@djpowerage]

I've now used a multi line text field in my Dataverse table, and it now displays. Is that the best way of getting an image saved to a record?

[@RezaDorrani]

@@djpowerage There is an Image type column

[@kiruthikas1073]

Hi Reza..great video..i have one doubt ..i have a embedurl in the json and i store it in collection..but i am unable to patch it in the sharepoint hyperlink column because embedurl is of type text ..how should store the embedurl as hyperlink in collection instead of text

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@kiruthikas1073]

@@RezaDorrani thank you for your reply.. I have another doubt..If i include a form and connect it to SP list which has hyperlink column then that hyperlink column is coming as text data card only..and the update property is datacardvalue.text ..if here it is patching text property to hyperlink column then why not outside of the form when using patch it is throwing invalid operation due to mismatch?

[@RezaDorrani]

@@kiruthikas1073 I have done no work with hyperlink column hence not sure of exactly how it works with power apps. I recommend checking on forums.

[@jcolehatcher]

I'm trying to do an http request from graph API and I'm successful and I'm loading it into a variable. it's using groups to list group members. But I'm having trouble getting that variable to show in a text box without copying and just pasting the JSON. Then I am able to traverse through like your video shows. But I would like for it to show in a textbox then I will hide the textbox. To have a dynamic members gallery essentially.

[@RezaDorrani]

Im not sure what trouble you are facing with copying it.

[@jcolehatcher]

Disregard I finally got it to work by following another video you did by setting the gallery directly as the JSON variable!! 🙌🏼🙌🏼🙌🏼

[@jcolehatcher]

Is it possible to access the @odata.nextlink and store it in a variable? I can't seem to access it within the JSON.

[@RezaDorrani]

@@jcolehatcherI have not tried this so not sure

[@Escillo]

Hello Reza, is there a way to write JSON in the component parameters (on the right) without having to multiply the " for the writing to be recognized? please

[@RezaDorrani]

" escaping will be a pain. I dont know of an easy way around it.

[@eyoborelvis8224]

Hello Sir, Thannks for sharing, How do i go about somenting as this: what if i am trying to sum the datas in a json

[@RezaDorrani]

Depends on structure of JSON. You would need to get/parse to array of dates from jaon and then use sum function. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com

[@eyoborelvis8224]

​@@RezaDorrani Thanks for the tips, I parsed/looped through the array with the FORALL function and got the sum.. Thanks Boss

[@RezaDorrani]

@@eyoborelvis8224 Awesome!

[@alifpurnama3298]

I have problem to encrypt fields from powerapps to sharepoint list. For example, in powerapps I have a name field and when I input a name, the name stored in the sharepoint is in the form of encryption. And when it's done, then when I call the data back from sharepoint to powerapps it's already decrypted. how do i do it?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@hudsonquay]

Is it possible to get the keys from a JSON string using parseJSON? The keys in the JSON string may change so I want to be able to perform an operation to get the keys into variables or a collection. Ultimately I want to display the JSON string returned to Power Apps in a gallery but as the keys change I need a way of changing the keys to names of my choice. I thought maybe if I could extract the keys I could then use AddColumns or RenameColumns to change them to my consistent naming convention. Example JSON string below: { "surveyTitle": "Incident Reporting", "questions": [ { "question": "What type of incident occurred?", "questionType": "dropdown", "options": ["Workplace injury", "Near-miss incident", "Property damage", "Security breach"] }, { "question": "When did the incident occur?", "questionType": "dateTime", "options": [] }, { "question": "Where did the incident occur?", "questionType": "text", "options": [] }, { "question": "What caused the incident?", "questionType": "text", "options": [] }, { "question": "Did anyone witness the incident?", "questionType": "radio", "options": ["Yes", "No"] } ] }

[@RezaDorrani]

I have not tried with a dynamic key’s scenario. Not sure what the options are. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@hudsonquay]

@@RezaDorrani Thanks Reza. I’ve put a post on there. This ties in with your latest ChatGPT tutorial. I’ve added a facility to get ChatGPT to create a survey on various topics but the output keys aren’t consistent.

[@RezaDorrani]

@@hudsonquay Let me know if you find something. I would like to know the possibilities with dynamic keys as well.

[@hudsonquay]

@@RezaDorrani I’ll report back if I find a solution. May need to resort to text manipulation.

[@vignesh.v7298]

How to handle if i have special characters?

[@RezaDorrani]

Not sure as I have not come across this scenario

[@paulinedahne]

Hi Reza - thanks for all your videos - you are always very clear and produce helpful content. I have a situation where I need to use PowerApps to access some existing data in a SharePoint list but the previous developer used React javascript code and compressed some data in a multiline text column using LZSTRING.compressToEncodedURIComponent(JSON.stringify(Assets)) - (Assets being the name of the SharePoint column). Do you know if there is anyway of decompressing this data using either PowerApps, Power Automate or Logic Apps? The javascript code use JSON.parse(LZSTRING.decompressFromEncodedURIComponent(compressed)) to decompress the string but my new solution should be based on Microsoft technology. I would be very grateful for any feedback on this - thanks again

[@RezaDorrani]

I have not done any work with reactcode or decompressing string data. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@v75tan]

Any plan E2E- Microsoft Power Pages Tutorial

[@RezaDorrani]

No plans for now. Check community tab on my channel. I posted list of upcoming videos.

[@williamsharpe2393]

Good video! I have my JSON in a SharePoint list, and this allows me to bring it into PA and put it into a collection. Would you happen to know how to patch the data back to the JSON column in Sharepoint? For example, the user changed a field from 'Y' to 'N'. I would need to save that change.

[@RezaDorrani]

SharePoint does not have a column of type JSON. You are probably storing the data in a text column. You can work with JSON in Power Apps, store it in collection, make updates to collection, then use JSON function to convert it back to JSON and patch it to your SharePoint list.

[@williamsharpe2393]

@@RezaDorrani It works perfectly, thanks!

[@RezaDorrani]

@@williamsharpe2393 That was a wild guess :)

[@krish3210]

I dont have any option like ParseJson

[@RezaDorrani]

ParseJSON is generally available

[@pochampallyvamshikrishna9483]

Hi Reza, Please let me know if any detailed video on converting a list from Sharepoint to a Vertical chart in PowerApps. Thanks in advance :)

[@RezaDorrani]

I do not have a video on charts in power apps. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@edjk6278]

Greetings... quick question. Is it possible to convert AI builder output (string) with the int( ) command. I cannot seem to get this to work. Is it possible?

[@RezaDorrani]

I have not tried this, so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@matthewludwig8113]

Thank you for your video. So I am trying to parse through the following JSON and I am hoping you can help. I am trying to get the region, state and Object ID in a gallery. I would greatly appreciate any insight you can offer. I can get the row count of three, but I can't seem to crack the nut of going inside of the "atrributes" to get the data I need. { "features" : [ { "attributes" : { "Region" : "NE", "State" : "MA", "ObjectId" : 1 } }, { "attributes" : { "Region" : "NE", "State" : "MA", "ObjectId" : 2 } }, { "attributes" : { "Region" : "NE", "State" : "MA", "ObjectId" : 3 } } } ] }

[@RezaDorrani]

I will have to try this out to know the steps. I recommend posting your issue on forums at powerusers.microsoft.com

[@matthewludwig8113]

@@RezaDorrani I found the solution. First I accidentally added one too many "}" to my JSON. After fixing that, the following worked: In the gallery Items: Table(ParseJSON(json.Text).features) and in the text of the gallery item: ThisItem.Value.attributes.Region (for region) ThisItem.Value.attributes.State (for State) ThisItem.Value.attributes.ObjectId (for ObjectId) PS: I joined the Altanta Power Platform Community. Thank you for the link and the recommendation.

[@sharekhan5568]

Can this be a game changer and eliminate connectors?

[@RezaDorrani]

Will not eliminate connectors. Connectors are used to connect to data sources or APIs which could return JSON. This is a function which helps to Parse JSON in Power Apps.

[@johnfromireland7551]

The Send HTTP Request, in Power automate, does eliminate the need for a Power App connector.

[@jumanamahmoud2349]

hello , please can you help me in this case: model driven dataverse app wand choice field depend on Yes or No field?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@jumanamahmoud2349]

@@RezaDorrani thank you so much 👍

[@XuejiaoRen-lq2vg]

What if i want to display the img

[@RezaDorrani]

Not sure about that

[@XuejiaoRen-lq2vg]

@@RezaDorrani thank you bro for answering . ^^. By the way love all your Video!!

[@RezaDorrani]

Helpful links 🔗: powerapps.microsoft.com/en-us/blog/power-fx-introducing-parsejson/ docs.microsoft.com/power-platform/power-fx/working-with-json docs.microsoft.com/power-platform/power-fx/reference/function-parsejson docs.microsoft.com/en-us/power-platform/power-fx/untyped-object mofumofupower.hatenablog.com/entry/2022/09/07/201957

[@moneyodsg]

Thanks for this, helped alot. I have one question though, hope you can assist. How do I query a json field like this example: { "sometitle": [{ "topic1": "text string", "topic2": "text string"}]}. I want to query the topic1 and topic2 fields. I have a button that populate a collection with the Response of the custom api configured, I can see the fields in the description section when setting up the custom api, but cannot seem to query it when trying this in a data table within PowerApps: ThisItem.sometitle.topic1 Maybe Im doing something wrong, to give a better understanding, ThisItem.sometitle.topic1 will work if this was the Response: { "sometitle": { "topic1": "text string"}} I think im basically asking how to query fields inside the [ ] space

[@RezaDorrani]

Idea would be to get the array within the object key sometitle. I would have to try this out to give exact steps. Il recommend to post your query on forums at powerusers.microsoft.com in case someone has done something similar

[@michaelpetersen1165]

@@RezaDorrani Thanks, i managed to get it working using a flow

[@shubhamkoolwal139]

Hey Raze can we parse this type of input [ { "moduelName": "test module", "instructorinfo": [ { "instructorName": "test test", "instructorId": "1931dec0-c1ba-ee11-9078-6045bdd0ed08" } ], "trainingVehicleInfo": [] }, { "moduelName": "test module1", "instructorinfo": [ { "instructorName": "Test1 Test1", "instructorId": "b93c560b-f3b9-ee11-9078-6045bdd0ed08" }, { "instructorName": "test test", "instructorId": "1931dec0-c1ba-ee11-9078-6045bdd0ed08" } ], "trainingVehicleInfo": [ { "LicensePlate": "LIC02234", "Model": "Demo" }, { "LicensePlate": null, "Model": "ford" } ] } ]

[@RezaDorrani]

I cannot try it out on chat :) I would recommend posting your query on forums at powerusers.microsoft.com

[@ankitmatoria2496]

HI Reza Sir, Thanks for the explanation with great examples really appreciate your efforts. I have a query I wanted to concatenate JSON Property Value let's say : [ { "IndexField" : 1, "Title" : "One" }, { "IndexField" : 2, "Title" : "Two" } ] In the above example I wanted output One,Two based on 'Title' key. In my JSON i was able to fetch first Value but struggling to concatenate all available in the JSON array object. - Thanks a lot

[@RezaDorrani]

Look into using the Concat function.

[@ankitmatoria2496]

Hi Reza Sir, I was able to achieve the same in a gallery Label using below formula. Thought this could help others. Concat(Table(ParseJSON(ThisItem.myJSONSTRING)),Concatenate(Text(Value.Title)," "),", ")

[@maricarmenjimenez4877]

AMAZING video. Thank you for your time and help 🙏

[@RezaDorrani]

Glad it was helpful!

[@MorsugioJr]

I work with power platform dev for almost 10 years already and I must say... if the presenter have indian accent, he is a good teacher... great video m8 !

[@RezaDorrani]

Thanks

[@anjanchidige]

HI Reza, I have a JSON string returning from Flow to Canvas App. I would like to show the columns into the Table control i.e. "Title" and "Description" columns. I keep getting an error. "JSON parser error. expected 'string' but got 'array'" Here is the JSON { "issues": [ { "Title": "Requesting Additional Resources", "Description": "*As a* Project Manager *I want to* submit a request for additional resources *So that* I can secure the necessary skills and manpower to complete my project on time." }, { "Title": "Viewing Resource Availability", "Description": "*As a* Resource Manager *I want to* view the availability of all resources across projects *So that* I can allocate resources efficiently and avoid overbooking" }, { "Title": "Assigning Resources to Projects", "Description": "*As a* Project Manager *I want to* assign available resources to my project tasks *So that* I can ensure the project is adequately staffed with the required skills." } ] } Any help on this is much appreciated.

[@RezaDorrani]

Idea would be to supply “issues” array to items property. This video is the best reference I have. I recommend posting your issue on forums at powerusers.microsoft.com

[@Facts_Unveiled536]

Hi Reza, can you please help me on this, i want to retrieve text and links which is present inside json file which is like this{ "session_id": "string", "answer": { "text": "string", "links": [ "string" ] } } when i am doing this i can fetch the text inside answer from below query Set(varResponse,askSRE.GetAnswer({db:Dbvar,msg:'Pass your Query'.Text,session_id:CurrentSessionID})); Patch(DataTable,{SessionID:CurrentSessionID,Question:'Pass your Query'.Text,Answer:varResponse.answer.text}); But when i am trying to perform operation i see json parsing error expected object but got string.....can you please help on this

[@RezaDorrani]

I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@paddysheeran]

Hi Reza, how do you convert the value of an Array variable into a format that the response to the power app can use? My array looks like this: [ { "Shift Name": "WFH", "Shift Day": "2024-02-09", "Open Slots": 2 }, { "Shift Name": "WFH", "Shift Day": "2024-02-10", "Open Slots": 2 }, { "Shift Name": "WFH", "Shift Day": "2024-02-11", "Open Slots": 0 } ] the respond to powerapp action body shows like this once run: { "response": "[{\"Shift Name\":\"WFH\",\"Shift Day\":\"2024-02-09\",\"Open Slots\":2},{\"Shift Name\":\"WFH\",\"Shift Day\":\"2024-02-10\",\"Open Slots\":2},{\"Shift Name\":\"WFH\",\"Shift Day\":\"2024-02-11\",\"Open Slots\":0}]" } so when using Text(ThisItem.Value.ShiftName) in the gallery I get a message stating this formula uses Scope which is not supported for evaluation. any advice you can provide please?

[@RezaDorrani]

use ParseJSON function as shown in video to data in response part.

[@bobbyanderson1906]

Thank you so much Reza, I've been struggling with receiving JSON response from Flow and converting it to a collection. For some reason, the Response action in Flow wasn't sending the data. This was a very helpful workaround.

[@RezaDorrani]

👍

[@michaela3709]

How do you read sub arrays? If I had this json : "[ { ""Name"": ""Heba Kamal"", ""Age"": 22, ""Active"": false, ""ReleaseDate"": ""2022-09-01"", ""MedicalDetails"":[ { ""Appointment"": ""2022-09-01"", ""CoolText"": ""CoolText"" } ] }, { ""Name"": ""samerKamal"", ""Age"": 27, ""Active"": true, ""ReleaseDate"": ""2022-09-21"" }]" and I wanted to Read the MedicalDetails Appointment or CoolText. I tried this: Text(LookUp(Table(ParseJSON(JsonLabel.Text)),Value(Value.Age) = 22).Value.MedicalDetails.CoolText) And while it doesnt return an error it returns Blank. Any thoughts?

[@RezaDorrani]

I would have to try this out to know the steps. I recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com

[@DorkSlayeRLoL]

Hello, I'm trying to work with JSON with power automate "Respond to a PowerApp or flow". However, my data is automatically changes to have slashes. I also noticed that this automatically happens within PowerApps. I used a text input control like you did in the video and all that worked. However, if I try to write the input from the text input control to a text variable the slashes are automatically added. I understand that this has something to do with PowerApps and the use of quotations ("). I see in this video that you use "Respond to a PowerApp or flow" and it seems to work for you, so I'm wondering how managed to do that? Data sent to PowerApp: [{\"Title\":\"Onboarding HR\",\"Include\":false,\"Complete\":false}, ... From my array in Power Automate: {"Title":"Onboarding HR","Include":true,"Complete":true}, Slashes are added before every ".

[@RezaDorrani]

My steps are as shown in the video. I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@servicenowaccount1610]

Hi reza.. Great video.. Do you keep any repository like zip files of all the apps which you are showing us in your videos.(showcase apps). Would helpful for us to download and have a look. Thanks

[@RezaDorrani]

github.com/rdorrani Not all apps or flows are shared.

[@mmm-me4kk]

Hello Reza thank you for the video, is it possible to create such a table in a gallery control in a dynamic way, so suppose the 1st element in the array has a field called "organization", then i want that the first column of the table is organization, but if none of the elements contains the field organization, it should not show it, i think i can kinda do this but then i need to hardcode values, but is there a way to make it dynamic without hardcoding it

[@RezaDorrani]

Im not sure if there is a dynamic option

[@bujjibabukj9616]

Hi Sir Request you help me to extract the data directly from Sharepoint List to gallery Data is patching in JSON format from Canvas app to Sharepoint list Ex: Record -1 [{"Date":"2023-02-20","Employee_ID":"500","Employee_Name":"H DHARMENDER","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"12","Shift":"A"}] Record - 2 [{"Date":"2023-02-20","Employee_ID":"501","Employee_Name":"S BALARAJU","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"123","Shift":"B"}] Each record is having square brackets [ ] in Sharepoint List Thanks & Regards

[@RezaDorrani]

I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@bujjibabukj9616]

@@RezaDorrani Thank You

[@Mal501]

I've been SO waiting for this functionality. Thanyou you Reza for all your videos.

[@RezaDorrani]

My pleasure!

[@alifpurnama3298]

i have error in parse json with array of objects, the message is unexpected number in json at position 79. how to solve it?

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@CNich90]

Thanks Reza for putting this together! Question, in the example where you showed the survey records being stored in a single text field in json format, is there performance benefits to storing the data this way rather than in normal share point fields?

[@RezaDorrani]

There is no performance advantage unless there are 100s of fields.

[@CNich90]

@@RezaDorrani appreciate the quick response, thanks a lot!

[@fadiahdab]

finally , I can use it in standard connectors ,thank you the presented scenarios have covered everything

[@RezaDorrani]

Most welcome

[@jamesclark2020]

Thank you again sir for explaining this so well This is an absolute game changer if you ask me 🎉

[@RezaDorrani]

Thanks James

[@DataisKing]

Is there a way to UnPivot specific columns in a SharePoint List using this technique?

[@RezaDorrani]

Not sure what unpivot means. This is purely a function to parse json.

[@DataisKing]

@@RezaDorrani UnPivot is when you transform columns into rows or rows into columns. In my case, I'm trying to transform specific SharePoint columns into rows.

[@RezaDorrani]

@@DataisKing Im not sure if json is an option for that. This is not something I have done a video about or attempted. Best place would to be to check on the forums.

[@TheAu4812555]

Hi Mr Zera i hv another issue about “ Fail the response is not in Json format” what should I do? Plz advise and thanks

[@RezaDorrani]

I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@TheAu4812555]

@@RezaDorrani thank you very much

[@tuyoexcelypowerbi]

You are the Best!!!!

[@RezaDorrani]

Thanks

[@charanravichandran8334]

Hi Reza , thanks for the video..is it possible to pass dynamic property to parse json in power apps? Example : I have name, age ,state as field property in json, I should read this field from template file as key and to pass dynamically in parse json. Thanks in advance

[@RezaDorrani]

Possible but not something I have done

[@charanravichandran8334]

@@RezaDorrani I have tried articles and fourm but couldn't find dynamic property. I tried to append value using variables in powerapps but doesn't work.If you have any thoughts or references , kindly help me..Thanks Reza for your videos and instant reply.

[@RezaDorrani]

@@charanravichandran8334 I do not have any references. Forums will be your best bet.

[@charanravichandran8334]

Thank you for you reply@@RezaDorrani

[@franknielsen3219]

Amazing video Reza 👏👏👏👏👏👏

[@RezaDorrani]

Thank you