cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft Flow - Expressions and how to use them

In this post I'm looking at the coding part of the low-coding solution that Microsoft Flow is. 

 

For every Action, or condition or switch you can use expressions. Expressions are coparable to functions, procedures or methods in traditionalprogramming languagas.

 

Expressions.PNG

When you initially look at expressions you will find that Mcirosoft Flow offers you about 30 expressions and you migth be quite disappointed. Don't be!

 

When you look a bit further and you start typing oin the search box ( just after the fx) then you will find out that there is more. A lot more!

 

moreExpressions.PNG

 

Ok, in this post I could go through all of them, but I'm not going to do that. ?I would probably only bore you to death anyway!

 

So just by typing ahead I found fucntions like substring.

 

substringExpression.PNG

 

Then when you coplete the word substring after the first bracket Microsoft Flow offers you a syntax and a description of the Expression.

substringDetails.PNG

Can things get any easier?

 

you can even build some logic in using an if expression.

 

iflogic.PNG

 

And if you are still not happy. There is more! You can even use Dynamic content in your expressions.

 

DynamicIf.PNG

 

Do you have any dificulties using Expressions? Or do you need some help then please leave a comment below or  post your question on the Microsoft Flow Community Boards

 

 

 

Comments

Hi,

 

I am facing difficulties while using OR expression in one of my first attempt to create a flow. I posted on community boards, here is the link to full story.

 

https://powerusers.microsoft.com/t5/Building-Flows/Query-Using-OR-Logical-Function/td-p/95547

 

 

Anonymous

Hi, 

I want to insert the value of an array type variable to a Sharepoint list item.

In the dynamic content, I can see all the variables except for the Array types.

Is there any specific method to do so ?

 

Hi @Anonymous,

Are you trying to create a list item for each item in teh array? Or are you trying to add the full array to a single list item? 

 

 

 

 

Anonymous

Hi @Pieter_Veenstra ,

I am adding a full array to a list item. Though, the array will always contain one element.

Also, I am now able to find the array alue through the expressions but the result is the complete array not the value of the array item.

Hello @Pieter_Veenstra.  The flow interface  seems to have been updated (it looks very nice) but I can no longer see where to enter expressions.  Do you have any pointers?

Hi @PhilipGoodfello,

 

I have had this myself a few time. Could it be that you are running on a low resolution or a small browser window?

 

Do your actions look like this?

 

NoExpressions.PNG

Thank you.  I was zooming in on the web broswer to increase magnification - ironically to see the text of expressions more clearly.  Zoom out and the expected interface returns.  

I want to Update a list from another list.

I'm using a filter query and hereafter the expression equals(length(body('Get_items')?['value']),0) to be able to update one list from another.

When the item does not exist the result of the filter query is { value [] } so it is empty, but the condition Value equals to the expression does always result in false - why?

I have also tried the empty expression with same result. can anyone help ? I need to create an item, when it doesn't exist - in my flow only update is working.

Meet Our Blog Authors
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • SharePoint, Microsoft 365 and Power Platform Developer | Contributor on SharePoint StackExchange
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #Office365 #MSFlow | C-sharpCorner MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/