Power Automate Tutorial - Expressions 101

No video

Power Automate Tutorial - Expressions 101

Рет қаралды 37,212

Күн бұрын

Hello Friends!
Welcome to a brand new introduction to Expressions in Power Automate.
This topic will be 101 level and introduce you to the various concepts that make expressions work!
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:25 - What Are Expressions
03:33 - Anatomy of Expressions
05:17 - Types of Expressions
07:46 - Where can expressions be used?
10:16 - The Expression Editor(s)
13:35 - Demo Time
29:30 - Conclusion
30:46 - Subscribe to the channel
Subscribe to Reza on KZfaq: / rezadurrani28
Follow Reza on Twitter: / rezadorrani
To find the expressions documentation visit: docs.microsoft.com/en-us/azur...
To watch our Trigger Conditions video, head to • Power Automate Tutoria...
To get started with Microsoft Flow head over to 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! www.amazon.com/shop/jonlevesque
As ALWAYS , PLEASE LIKE & SUBSCRIBE
Later friends!
- Jon

Пікірлер: 47

@juansepowerplatform 4 жыл бұрын

the new expression editor is God sent. thanks

@GeorgeKlucsarits 4 жыл бұрын

Hey, Jon, thanks for having Reza on your show. Really enjoyed your lesson on trigger conditions and that led me to some other great content on Reza's channel. This tutorial has been very timely and super helpful. Been a fan of Power Automate since seeing your demo at MBAS in Seattle the other year. Keep up the great work!

@SenzoDlomo 4 жыл бұрын

Thank you guys, this is super helpful, saved my life!

@yehunlavolontededieu322 4 жыл бұрын

Reza is cool & humble, I like his technique of teaching ...Bro glad to have you in the community

@RezaDorrani 4 жыл бұрын

Thank you so much for your kind words

@davidadams421 3 жыл бұрын

Very good. A great introduction, demystifying this very powerful component of flow.

@krishnabairi1581 3 жыл бұрын

Loved it. Thank you both 😊

@ufffyegaane-onlyforyou9837 3 жыл бұрын

Gonna start today about expression. This was the savior.

@JonJLevesque 3 жыл бұрын

Yes! Awesome!!

@babajidebantale 3 жыл бұрын

The modern editor is really good. Thanks Jon and Reza

@RezaDorrani 3 жыл бұрын

Thanks for watching

@mikesmith2315 2 жыл бұрын

brilliant learned so much from this thankyou

@SS-cd1dl 4 жыл бұрын

Most useful vid yet, brilliant thanks guys great work, looking forward to 201, 301 sessions, boom!

@JonJLevesque 4 жыл бұрын

Boom! ❤️

@ExcelExciting 4 жыл бұрын

Awesome 👏🏻

@bobblandeburgo3842 9 ай бұрын

More than three years later, the modern editor is still an experimental feature. Oh, Microsoft.

@JonJLevesque 9 ай бұрын

Bahahahah 😂😂😬😬

@E1knight 4 жыл бұрын

Thank you.... You are the MVP

@JonJLevesque 4 жыл бұрын

Reza is really rad, isn’t he?!

@dhubach1 2 жыл бұрын

Reza is a Power Platform God. Did you all ever do 201?

@dhubach1 2 жыл бұрын

Nvm found it! kzfaq.info/get/bejne/fJ2cfLll2NbWo4E.html for anyone else looking

@JonJLevesque 2 жыл бұрын

All the way up to 401

@sundrapillay6668 4 жыл бұрын

Thank you excellent

@JonJLevesque 4 жыл бұрын

You’re welcome!

@dmdleiteagmailcom 3 жыл бұрын

Awesome video, thank you. I need to compare dates between two lists in Sharepoint. Any help is much appreciated.

@TheAsterii 4 жыл бұрын

As always, thanks for the tutorial. I wanted to point out that we really need the "EXCEPT" function. We have the "INTERSECTION" function which takes two arrays and gives us the values that are present in both of the array (i.e. the matches or intersections). An "EXCEPT" function should provide the exact opposite, i.e. listing the values that are included in array1 but are missing from array2. This would really enhance performance for some complex scenarios because the only way to achieve this atm is to loop against the array you want to compare with - on a large dataset this results in unbearable performance. Therefore, I am asking you Jon, if you could reach out to the product team and propose this function to be included. It really is a crucial functionality which unfortunately is still missing ...

@HugoHorta 4 жыл бұрын

Seria muito bom a criação dessa funcionalidade. Estou precisando exatamente disso para finalizar um produto que estou criando. Enquanto não há essa função "EXCEPT", como posso encontrar o que há de diferente em 2 campos?

@DavidPrenticeJr 3 жыл бұрын

How do I enable the new expression editor if I'm using a personal account? I don't have a cogwheel. I do have a cogwheel when using my organizational account for work.

@diogorrm 2 жыл бұрын

Hi, is possible use a string as an expression? for exemple calculate a date from a role (pa expression) that is stored in sharepoint list?

@MohammadAli-ts2ev 2 жыл бұрын

In Power automate/Flow, how can we set the value of any single cell (i.e cell A2) of a table (of Excel Online for Business) to a variable?

@Rayyankhantheboss 4 жыл бұрын

What I really wanted to see wa how to incorporate dynamic elements into the expression. for example I have an int variable from a previous action, how do I convert it into a string using expressions

@RezaDorrani 4 жыл бұрын

We have 201 coming up soon. We do cover adding dynamic content into expressions.

@alexchavez-huerta8908 3 жыл бұрын

Can someone help me make a flow work a certain way? Basically, make a flow send an email from a data driven alert to a certain email address within the power BI dataset. Example: Customer reaches a certain numeric value and it triggers a flow to send them an email.

@abhisoulstormer 4 жыл бұрын

How you know i listened till the end attentively ... Expressions 102 will be coming out soon :P but maybe 201 sometime too :D

@RezaDorrani 4 жыл бұрын

Yes, we have 201 coming soon

@JonJLevesque 4 жыл бұрын

Next week!

@peroron2000 2 жыл бұрын

I requested the discount code for the Udemy course but when I received it it was already expired. I received it 8/28/2021 The discount expired 8/27/2021. How can I get a code that has not expired.

@DanielBowne 4 жыл бұрын

Why not standard regex? Why do we need to do a paid serviced like "Plumsail Actions" to do regex. Very frustrating....

@alexscott473 3 жыл бұрын

This could be because I'm still a newbie that I don't understand this. But I don't get why you can't just enter an expression and immediately see its output. Surely a little sandbox area somewhere for writing and evaluating an expression to immediately see the output would be a good idea? A bit like excel when you enter a formula into a cell and see it's output in real time. Instead you have to enter the expression, hope you've got the logic right, run the flow and then if something doesn't work you've got to output the value of the expression in order to see what you got wrong. It is also a little confusing why these are called expressions in Power Automate, and functions in Power Apps and whether both have the same set of functions available or if they are different?

@JonJLevesque 3 жыл бұрын

i wish i could answer - its a limitation of flow =/