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.



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!




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.




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


Can things get any easier?


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




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




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







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.





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? 






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?



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.  

Meet Our Blog Authors
  • Working daily with Microsoft Cloud to deliver the needs of my company, my customers and various Microsoft communities and forums. | Office 365 | Flow | PowerShell | PowerApps | SharePoint |
  • Co-founder of, Office 365 and SharePoint expert. Passionate about design and development of easy to use, convenient and flexible products.
  • Microsoft Business Apps MVP. Owner of ThriveFast, an Office 365 consulting company.
  • 7x Microsoft Business Solutions MVP (CRM)
  • I'm keen in MS technologies, SharePoint, Office 365 and development for them
  • Daniel is a Business Productivity Consultant & Microsoft Business Solutions MVP who is very enthusiastic about all things Office 365, Microsoft Flow, PowerApps, Azure & SharePoint (Online). Since the preview, Daniel has been working with Microsoft Flow and later on with Microsoft PowerApps. That led to him being awarded an MVP Award for Business Solutions. He loves to blog, present and evangelize about improving productivity in the modern workspace with these amazing tools!
  • Michelle is an Office 365 solution architect in Twin Cities, MN. She has been delivering business collaboration solutions for years with her focus on SharePoint and Office 365. Michelle is a recent board member of the Minnesota Office 365 User Group and has been a member of the SharePoint community since 2009. She is a frequent speaker at MNSPUG and SharePoint Saturday and co-chaired the Legal SharePoint User Group for 4 years. Her most frequent projects have involved rolling out a large deployment of Office 365, SharePoint Online intranet, build of a "CHAMPS" Office 365 user adoption program and most recently, SharePoint On-Premise to Online Migration. Michelle is very excited about cloud technology as it is shifting her IT Pro focus to collaboration strategy and technical adoption.
  • I'm a Microsoft Office Servers and Services MVP with a special interest in SharePoint, Office 365, Microsoft Flow, Microsoft Teams and PowerApps. I work at Triad Group Plc (
  • Passionate #Programmer #SharePoint #SPFx #Office365 #MSFlow | C-sharpCorner MVP | SharePoint StackOverflow, Github, PnP contributor