Power Automate Tutorial - Expressions 301

Hello Friends!

Welcome to a brand new episode of the Expression series by myself and Reza Dorrani!
This topic will be 301 level and guide you through some advanced expression work, by using real world examples!

As always, I am joined by Business Apps MVP Reza Dorrani who will be walking us through all of the material and teaching us how to get started with expressions!

00:00 - Introduction
01:17 - What to expect from 301 level content
02:00 - Introduction to JSON and how it works
12:35 - First Real World Example - Dynamic Approvals
30:25 - Second Real World Example Example - Splitting Email Body
38:56 - Third Real world Example - Parsing through items
44:50 - Conclusion
46:00 - Get Subscribed to Reza and myself!

Expressions (SAMPLE ONLY - WILL NOT WORK)
outputs('JSON')?['data']?[0]?['address'] - Get first array object column value

length(body('Filter_JSON')) - Get number of items in array

decodeUriComponent('%0A') - New Line character

split(body('your text column'),outputs('NewLine')) - split text by new line character - returns an array

startsWith('your text','Assigned By') - check to see if your text value starts with "Assigned By"

int('your text value') - convert text to integer

convertFromUtc('Your date time value','Pacific Standard Time','M/dd/yyyy h:mm tt') - convert to your time zone and format date

if(equals(item()?['approverResponse'],'Approve'),'✔️ Approved','❌ Rejected') - Check if approvers response is Approve or Reject. This function is running in a for loop. Loop iterates over Responses array from Approval action output

div(div(mul(sub(ticks(items('For_each_approval_response')?['responseDate']),ticks(items('For_each_approval_response')?['requestDate'])),100),1000000000),60) - Duration in mins of approval action taken by the approver

Ticks function blog
https://powerusers.microsoft.com/t5/P...

Visit Reza's upcoming 2 day workshop "Power Automate Master Class" - Mon Oct 05, 9:00 AM - Tue Oct 06, 5:00 PM CDT
https://www.dynamiccommunities.com/ev...

Approvals Cookbook Playlist
   • Dynamic Approvers & log history with ...  

Subscribe to Reza on YouTube:    / rezadurrani21  
Follow Reza on Twitter:   / rezadorrani  

To find the expressions documentation visit: https://docs.microsoft.com/en-us/azur...

To watch our previous videos in the series check out:    • Power Automate Tutorial - Expressions...  

To get started with Microsoft Flow head over to http://flow.microsoft.com

Visit the Power Automate community: http:aka.ms/pacomm

To follow me on Twitter -   / jonjlevesque  

Want to make videos like mine?!
Check out all of my gear on my Amazon Shop! https://www.amazon.com/shop/jonlevesque

As ALWAYS , PLEASE LIKE & SUBSCRIBE

Later friends!

- Jon