Тёмный

Unlock the Full Potential of Parse JSON in Power Automate 

Paul Murana
Подписаться 6 тыс.
Просмотров 1,7 тыс.
50% 1

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

Хобби

Опубликовано:

 

4 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 42   
@JumpUpJumpUpandPowerPlatform
@JumpUpJumpUpandPowerPlatform Месяц назад
This may well be the first Power Platform video I've watched the entire way through without skipping. Very very cool.
@PaulieM
@PaulieM Месяц назад
Glad it was helpful. I felt like I’d unlocked a cheat code when I found that functionality 😂
@Sloal
@Sloal 4 месяца назад
That is the best intro to a RU-vid video ever!!! Super useful tips. Thanks for sharing.
@chrisnicol8175
@chrisnicol8175 4 месяца назад
Love the intro Paul! And thanks, I know this will be super useful.
@jibbsautomations
@jibbsautomations 3 месяца назад
Paul, your videos on JSON in PA have been super helpful for me, thank you!
@PaulieM
@PaulieM 3 месяца назад
I appreciate that. Thank you 🙏
@fogila
@fogila 4 месяца назад
Thanks Paul, good stuff.
@jamesclark2020
@jamesclark2020 4 месяца назад
This definitely opens up a lot of possibilities to explore.
@nguyenmanhtuan1772
@nguyenmanhtuan1772 4 месяца назад
Yes I did learn many new things about Parse JSON, thank you very much, Sir :)
@PaulieM
@PaulieM 4 месяца назад
You are most welcome
@trl_lrt
@trl_lrt 3 месяца назад
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.
@avinoamrothenberg1244
@avinoamrothenberg1244 3 месяца назад
😊 Great explanation as always
4 месяца назад
I liked that video before the warning message started ❤
@365g
@365g 4 месяца назад
Classic Paulie M... loads of valuable nuggets, loved the intro :)
@karolzareba9003
@karolzareba9003 4 месяца назад
Man! Why i didn't saw this 1y ago!
@PaulieM
@PaulieM 4 месяца назад
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!
@ukm365
@ukm365 4 месяца назад
Someone has fallen asleep on the keyboard with the JSON schema site loaded up!! 😏
@franknielsen3219
@franknielsen3219 4 месяца назад
You are a truly wizard with Power Auotmate 👌👌👌👌
@antonioskokiantonis7051
@antonioskokiantonis7051 4 месяца назад
Great stuff!
@PaulieM
@PaulieM 4 месяца назад
Yeah - some interesting nuggets in there. Glad you enjoyed
@temidayolonge4566
@temidayolonge4566 4 месяца назад
Hello Paul. Happy New Year. This is gold. Thanks as always
@PaulieM
@PaulieM 4 месяца назад
Thank you! 🙏
@ukm365
@ukm365 4 месяца назад
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
@PaulieM 4 месяца назад
yeah, that part is really cool. Quite a lot of things you can unearth there.
@AdiCristea
@AdiCristea 4 месяца назад
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
@PaulieM 4 месяца назад
I could have gone on and on! 😂
@AdiCristea
@AdiCristea 4 месяца назад
@@PaulieM the resource is gold also, just going through it as we speak
@AdiCristea
@AdiCristea 4 месяца назад
@@PaulieM PS. good bye Select (in some cases), which actually applies to the other video from today too :)
@PaulieM
@PaulieM 4 месяца назад
@@AdiCristea yes, lots of good stuff in there. Let me know what you find that is useful!
@PaulieM
@PaulieM 4 месяца назад
@@AdiCristea check out enum, I really should have included that in the video!
@juliusm367
@juliusm367 14 дней назад
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.
@janvanhaver6970
@janvanhaver6970 4 месяца назад
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
@PaulieM 4 месяца назад
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!
@ukm365
@ukm365 4 месяца назад
hahaha ... This is what I say before most things I talk about ... about anything!
@geralddahl9159
@geralddahl9159 4 месяца назад
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
@PaulieM 4 месяца назад
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
@geralddahl9159 4 месяца назад
@@PaulieM thanks!
@yaynative
@yaynative 4 месяца назад
I thought I knew something about JSON 🤦‍♂️
@PaulieM
@PaulieM 4 месяца назад
Now you know a bit more 😀
Далее
How To Visualize JSON Files
0:28
Просмотров 126 тыс.
Et toi ? Joue-la comme Pavard ! 🤪#shorts
00:11
Просмотров 2,1 млн
Power Automate - Extracting Values from JSON Array
9:22
But What Is Cloud Native Really All About?
7:32
Просмотров 140 тыс.
How to parse a CSV file with Power Automate
8:04
Просмотров 34 тыс.
File Reference Snippets
2:25
Просмотров 8
ПОДВОДКА ДЛЯ 6 ЛЕТ💅💄
0:20
Просмотров 797 тыс.
easy game filter 😎
0:12
Просмотров 7 млн