Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community 20-22nd - Dublin Microsoft Power Platform Conference – Oct.
#Parse json array javascript series
This episode premiered live on our YouTube at 12pm PST on Thursday 15th June 2023. Video series available at Power Platform Community YouTube channel.Įuropean Power Platform conference – Jun.
#Parse json array javascript free
Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show.Ġ0:00 Cold Open 00:25 Show Intro 01:02 Angeliki Patsiavou Interview 27:10 Blogs & Articles 42:45 Outro & BloopersĬheck out the blogs and articles featured in this week’s requested: Feel free to provide feedback on how we can make our community more inclusive and diverse. If you like my response, please give it a Thumbs Up.Įpisode Fifteen of Power Platform Connections sees David Warner and Hugo Bernier talk to Microsoft Business Applications MVP, Angeliki Patsiavou, alongside the latest news and community blogs. If I have answered your question, please mark the post as Solved. You could also reference the Activity properties in the same way without using ParseJSON : If you are happy to enter expressions, then you can reference each property of the Activity_SLA directly without using ParseJSON action and the flow could be simplified: I think the key to the flow is getting the data into the ComposeObject action, and then adding the expression to the Apply to Each loop. Here is the runtime output using both datasets, the JSON object and JSON Array: this is the sample data to generate the schema: The Parse JSON uses the following extract to generate the schema - i.e. I tried a few other ways to create the array from different data types (such as object, string, array variables) but using this expression with the output from the compose action seemed to work. This is the expression used in the Apply to each loop:Īrray(outputs('ComposeObject')?)Įven if the data is already an array, the expression still seems to work. If we can convert the Activity_SLA property containing the single JSON object into an array, we should then be able to use the same Apply to each actions to loop through each JSON object in the array. The problem is that the Activity_SLA property can sent as either a JSON Object or a JSON Array: Is there a best practice to handle such situations? I could try one and in case of an error try the other, unfortunately there are more 1.n relationships in my data. My Parse JSON step can only cater for one of these schemas, in the other case I get an error. However in the case of multiple SLAs I get an Activity_SLA array instead: When there is only one SLA, the message includes an Activity_SLA object: The data contains an activity and 1.n activity SLA records. I need to parse a JSON message from an external system.
0 kommentar(er)
