Unlock the Full Potential of Parse JSON in Power Automate

Рет қаралды 2,015

Күн бұрын

In this video we dive into the extensive capabilities of the Parse JSON action in Power Automate. The Parse JSON action is often underutilized. This video will shed light on the lesser-known functionalities and provide you with the knowledge to enhance your flows significantly.
Video Chapters:
00:00 Introduction: Introducing the Parse JSON action, outlining its importance and the purpose of our guide.
00:38 Example of Normal Usage: Get started with a basic example, demonstrating the standard way to use the Parse JSON action in Power Automate.
02:30 Adding Titles and Descriptions to JSON Objects: Learn how to make your JSON objects more understandable and maintainable by adding titles and descriptions.
05:12 Specifying Required Fields: Discover how to define certain fields as required in your JSON schema to ensure data integrity.
06:16 Solving the 'Invalid Type' Error: We tackle the common error of receiving an 'Invalid Type' message, showing you how to expect the correct data types and handle null values effectively.
09:30 Specifying Ranges for Values: Find out how to set minimum and maximum value constraints for numerical data in your JSON schema, adding another layer of data validation.
12:44 Multiples Validation with the multipleOf Keyword: Explore how to verify that a number is a multiple of another number, a useful check for various numerical inputs.
16:20 String Length Constraints: Learn to use the minLength and maxLength keywords to specify acceptable string lengths, ensuring your data meets predefined criteria.
18:16 Email Address Validation: Utilize the format specifier to validate email addresses within your JSON data, a critical step for data collection processes.
19:13 Conclusion
This video is perfect for users who are familiar with the basics of Power Automate and looking to leverage the Parse JSON action to its full potential. By the end of this guide, you'll be equipped with the knowledge to implement advanced JSON validation, enhancing your automation projects and ensuring data accuracy.
Be sure to check out: json-schema.org/understanding... to further understand what is possible!
If you found this video useful, please consider making a donation to the channel:
www.buymeacoffee.com/paulie

Пікірлер: 44

@FullRewardMinistries 10 күн бұрын

I wasn't one minute in before I figured out how to do something I'd been trying to do for 12 hours!!! Power Automate didn't give me any helpful tips, and I knew what I was doing was super simple. I had been trying to extract all of the values in one list and migrate it to another. I had some lists with friendly text that I could not preserve without separating the friendly text from the URL. Now that I have the first step down all I need to do is learn how to pull the friendly text and URL out and put them back together! Thank you!!!!!

@PaulieM 4 күн бұрын

Brilliant to hear! Lot of hidden gems in that action!

@Sloal 5 ай бұрын

That is the best intro to a KZfaq video ever!!! Super useful tips. Thanks for sharing.

@jibbsautomations 4 ай бұрын

Paul, your videos on JSON in PA have been super helpful for me, thank you!

@PaulieM 4 ай бұрын

I appreciate that. Thank you 🙏

@JumpUpJumpUpandPowerPlatform 2 ай бұрын

This may well be the first Power Platform video I've watched the entire way through without skipping. Very very cool.

@PaulieM 2 ай бұрын

Glad it was helpful. I felt like I’d unlocked a cheat code when I found that functionality 😂

@jamesclark2020 5 ай бұрын

This definitely opens up a lot of possibilities to explore.

@trl_lrt 4 ай бұрын

Great video! These details and foundation are needed for anyone working with json data. It would be great to dive into the pros and cons of using parse json vs not using it. I've been testing flows that respond back to powerapps and I have the same api output sent back as raw variable outputs['HTTPS']?['body'] (not using parse json) and then the same but using the dynamic content generated from parse json step that is just the variable reference of 'body'. But then back in powerapps attempting to work with even basic data is complex. Understanding how to access nested child nodes depending on the different formats of json received back into powerapps would be really great to understand more detail.

5 ай бұрын

I liked that video before the warning message started ❤

@365g 5 ай бұрын

Classic Paulie M... loads of valuable nuggets, loved the intro :)

@fogila 5 ай бұрын

Thanks Paul, good stuff.

@franknielsen3219 5 ай бұрын

You are a truly wizard with Power Auotmate 👌👌👌👌

@chrisnicol8175 5 ай бұрын

Love the intro Paul! And thanks, I know this will be super useful.

@avinoamrothenberg1244 4 ай бұрын

😊 Great explanation as always

@antonioskokiantonis7051 5 ай бұрын

Great stuff!

@PaulieM 5 ай бұрын

Yeah - some interesting nuggets in there. Glad you enjoyed

@temidayolonge4566 5 ай бұрын

Hello Paul. Happy New Year. This is gold. Thanks as always

@PaulieM 5 ай бұрын

Thank you! 🙏

@karolzareba9003 5 ай бұрын

Man! Why i didn't saw this 1y ago!

@PaulieM 5 ай бұрын

I guess because I only made it a week ago? But still I am glad you enjoyed it. Keep your eyes peeled for another video this week!

@nguyenmanhtuan1772 5 ай бұрын

Yes I did learn many new things about Parse JSON, thank you very much, Sir :)

@PaulieM 5 ай бұрын

You are most welcome

@ukm365 5 ай бұрын

I think that last one is the REAL hack, here. I didn't know that you could lean on the Parse JSON to validate in the middle of a flow. It stands to reason, and that email thing is SOOOOOOOOOOOOOOOOOOOOOOO required by so many things. I predict me using it in answers on the community about ... I dunno ... a bazillion times. XD

@PaulieM 5 ай бұрын

yeah, that part is really cool. Quite a lot of things you can unearth there.

@ukm365 5 ай бұрын

Someone has fallen asleep on the keyboard with the JSON schema site loaded up!! 😏

@AdiCristea 5 ай бұрын

Paul: "we're going to embark on a 20 mins journey about JSON and it's going to be tedious" Me, at the end of the video: "wait, is that it? I need mooooooooooooore!!" This was exceptional, thank you, Paul!!!

@PaulieM 5 ай бұрын

I could have gone on and on! 😂

@AdiCristea 5 ай бұрын

@@PaulieM the resource is gold also, just going through it as we speak

@AdiCristea 5 ай бұрын

@@PaulieM PS. good bye Select (in some cases), which actually applies to the other video from today too :)

@PaulieM 5 ай бұрын

@@AdiCristea yes, lots of good stuff in there. Let me know what you find that is useful!

@PaulieM 5 ай бұрын

@@AdiCristea check out enum, I really should have included that in the video!

@janvanhaver6970 5 ай бұрын

I've definitely watched 1 hour Power Automate videos that have brought me less value than these 20 minutes 😅 Super useful tips! One question, though: why did you not release this 6 months ago? 😉 (We have a D365 on prem to online migration running this weekend)

@PaulieM 5 ай бұрын

I only recently discovered the hidden potential in the action (which has since led me to find other stuff). Apologies! Glad you for it useful!

@geralddahl9159 5 ай бұрын

Thx for sharing this - not boring at all. First question: Why the need to tweek the output of the Send an HTTP Request to SharePoint around the 1:34 - 1:47 mark of video? Second question: I can't wrap my head around how at the 3:34 mark one has the ability to adjust the schema of the Parse JSON such that the output is passed on to the subsequent compose step as a highly delineated object with nuanced reference to firstName, email etc. My tiny chip brain gets stuck when it tries to imagine the Parse JSON step in Power Automate studying what it receives from the HTTP response step - it only sees field_1 field_2 etc. From what I see you doing, it appears one has the 'power' to input one's own preference within the Parse JSON step so as to suggest that, going forward, Power Automate append the structure/definition that the user wants as part of the way it outputs the payload going forward. I'm probably not clearly explaining the concept that my mind envisions is happening around all of this. It seems incongruent/dissonant - I would have imagined that a declaration like that would have caused an error. If you are able to understand what I'm chewing on and then confirm that I'm understanding things rightly, or rephrase how I should be understanding, your feedback would be welcome. Finally, two takeaways I did get: (1) never knew that a description could be added that would appear as part of the dynamic choice interface; (2) love your treatment on nulls, especially the one that allows the affected object to continue to show as a displayed dynamic option in the interface.

@PaulieM 5 ай бұрын

First Question: I could have done it without tweaking the output but that would have made the parsing more complex. I was simply accessing the "Value" output of the HTTP action, because it could also return the nextlink property at the same level. Second Question: The JSON Schema provided to the Parse JSON action is still aware of the original field names (Field_1 etc) but we have decorated the schema with more details. Internally it will still be accessing the data via the original field names, but subsequent actions will output the more user friendly details we have provided in the schema. The treatment of the nulls is a great solution to a long standing problem. It was actually someone else that commented on another of my videos that provided that solution and the inspiration for this video.

@geralddahl9159 5 ай бұрын

@@PaulieM thanks!

@juliusm367 Ай бұрын

Hi Paul, can you please help create an automated event triggered by an email. The start and end times of the event must be as stipulated in the body of the email. the subject of the event must be the subject of the email.

@ukm365 5 ай бұрын

hahaha ... This is what I say before most things I talk about ... about anything!