Power Automate flow Expressions Tutorial

This video is a step-by-step tutorial on Microsoft Power Automate flow expressions.
Step 1 - Introduction to expressions for beginners: What are expressions, syntax, expression editors, where can we use expressions, demos etc.
Step 2 - Expression functions walkthrough (Beginner to Intermediate) : Types of functions, working with string, dates, converting time zones, working with collection functions, logical & math functions, working with JSON, demos, etc.
Step 3 - Expressions in Trigger Conditions: Save API Calls, avoid loops, using nested functions, demos, etc.
Step 4 - Advanced Scenarios with Expressions: Email body message parsing, Send email attachments to folders in SharePoint, Calculate business days for a given date range, Get flow run link and handle exceptions, Send Overdue Task Reminders, demos, etc.

Topics covered:
✔️ Flow Expressions Basics
✔️ Classic Vs Modern Expression Editor
✔️ Expression Functions List - String, Date, Arrays, JSON, Logical & Math functions
✔️ Trigger Conditions
✔️ Examples: Calculate working days, send reminder emails, avoid for loops, send email attachments to SharePoint Library Folders, dynamic email body parsing, etc.
✔️ Power Automate Expressions Best Practices

#PowerAutomate #MicrosoftFlow #Expressions

🤝 Let’s connect on social:

Table of Contents:
00:00 - Introduction
00:27 - Introduction to Power Automate flow Expressions
03:25 - Walkthrough demo of flow expressions
07:55 - Modern Expression Editor
09:48 - String Functions
11:52 - Logical & Math Functions
13:49 - Date Functions
15:19 - Collection / Array Functions
16:29 - Working with JSON
21:07 - Avoid for loops in flow with expressions
23:31 - Flow Trigger Conditions
26:47 - Get flow run URL
29:10 - Send Task Reminder Emails
30:20 - Email body parsing & save email attachments to SharePoint Library Folders
32:51 - Calculate business days
34:30 - Best Practices for flow expressions
35:32 - Subscribe to Reza Dorrani channel

[robofski]

Another great video Reza, will be directing all the folks who want to start using Power Automate here! I watched another video recently talking about trigger conditions and they had a great tip of using the filter array option to build your trigger condition expression, really simple and switching from basic to advanced view gives you the trigger condition expression you need (including the @)

[jameslawrence]

He does a great job - gets right to the point - doesn't waste any time - very concise - very knowledgeable.

[ellios]

Almost a year later after this video and you're still helping out beginners like me. Thank you, Reza!

[sergiizelenko]

Amazing video! Thank you so much!!!
I was searching for a good content that explains how to build expressions for months and finally found answers to most of my questions in your single video :)

[jameschisolm]

Thank you sooo much!!! I'm not even sure you realize how helpful your videos are. You have a multitude of tips and helps in this video alone. I've been struggling with 1 thing... I was not able to see the add dynamic content/expression editor button. After trying several things and numerous searches, I was feeling defeated. But you casually mentioned it in this video. I am grateful! That's only 1 example. There are many more!!! Thank you!

[cvkealey]

Thank you for FINALLY explaining the use of the ? in traversing json! I've seen/read dozens of blog posts or videos where they just give the notation without explaining it.

[ashleyprobert]

Hi Reza. I just had to share this with you. I used your video named "Power Apps Save Pictures to SharePoint - Camera Control Tutorial" . The comments were turned off, so I am using this video's comments section. Whenever I wanted to submit the attachments I kept on getting a warning that the "Id" was needed for the form submit. It took me nearly 5 hours of swearing and crying to realize, after watching your video over and over again, that I had used "ID", instead of "Id" in the JSON schema. The warning message was telling me the fault all along. Now I am laughing at myself. Thanks for all your help, I and I sure many others, really appreciate it.

[HareKrsn]

Honestly - Whenever I face any challenge anywhere in Power Platform, Preferably I always look for your videos because of you pick complex tasks in your videos which covers other multiple scenarios....You helped me a lot. Thank you Reza...Cheers!

[g]

Massive thanks Reza! - I always found myself going back to the 101, 201.... series you had done w/ Jon L.... but I now have new supercharged, super-concise reference for PA expressions!..

With a vast array:) of excellent use cases - Well and truly bookmarked! 🔖

[muhammadusmankhan]

Absolutely awesome, no one can explain that better than you.

[RevusDeonauth]

Reza your videos are Awesome! All facts! Thank you

[dougydoe]

Excellent tutorial. Very timely as I'm currently working on flows where I'm having to use a lot of expression. Thanks for sharing.

[Worrelpa]

Thanks Reza, a gold mine of information there as usual.

I struggle with the new editor, I probably just need to get used to it and practice more.
Always find myself going back to the classic one. Sure the expressions are harder to edit, but I drop them out to an editor first then copy paste them back in. Something about that makes it easier to compare expressions and see those silly errors. Quotes, comma, brackets missing etc.

One of the things I have started to do with expressions is when I have collected data is to create an array of items I need and use on the flow. Then inside that array use expressions to do any conversions or processing I can do against them to save on compose and variable steps. e.g. from SharePoint get item, take any date / time fields and convert into various formats and have them as their own items directly further down the flow. With those items I also add expressions inside If(Empty(Item), 'no value', converttimezone) etc In cases where fields are not required fields to avoid some failures.

Looking forward to the next one. This video will be in my video reference library. ;)

[robertoel-hajjboutros]

Best Power Platform Developer ever, thank you for your amazing videos ❤️

[snorrefjeldbo]

Excellent! Exactly what I was looking for. Thank you!

[pw.]

Reza, you have shown me so much and answered many questions - thank-you!

[zhuoshentan]

Thank you very much for such detailed explanation step by step! 👍

[arshad]

Thanks Reza for sharing your knowledge..please keep up the good work you are doing for the community.

[AlexJann]

Hi Reza, thank you for all your efforts in creating videos. You're the best in terms of the content and making each steps understandable, dare I say better than Jon Levesque and Jon is great!

[gouravbagora]

Like always BRILLANT!!
Thanks, Reza