Contents
In this post, I’ll show condition syntax for common SharePoint column types when building a Microsoft Flow. To demonstrate this, I’ll show five frequently used column types and how to use them in a condition – something you’ll find yourself routinely needing to do.
Considering the example of “When an item is created or modified” trigger, you use this trigger to run the FLOW when a new item is added in your list or when the item is modified by the end user. You want the FLOW to run only when Status columns has value “In Progress” or “Done”.
Why does the flow always return a false result?
For a reason I don’t quite understand the condition was not accepting a numerical value as a true statement. Even though my SharePoint list was identical and the condition set to ‘equals’. Anyway I changed this from solely numerical to a string of text and the flow is now operating correctly.
How to set trigger conditions for flow in SharePoint?
There is a Trigger Conditions section in the settings as shown below >> Click on +Add button to add your rule or condition. If this condition satisfies then only FLOW triggers otherwise not. Run the FLOW only when Task Status is Done.
For a date column, the choices are a little different. A date column will only give you three choices. By default, each one in relative to today, but you can click the drop-down on each, to change it to a specific date instead. For a Yes/No boolean column, it’s only going to have two choices obviously, one color for Yes, and one color for No.
Can a list have more than one choice?
I have a list I am building that has one column (A) (Divisions) with 8 choices and another column (B) (Branches) that has 42 choices. Is it possible to set it so that the choices in column (B) are limited to just a few choices based on what is selected in column (A)?
Do you need JSON for column formatting in SharePoint?
There’s a new wizard based, easy user interface for column conditional formatting in SharePoint Online!! That means you don’t have to know JSON code in order to do some conditional formatting on your columns!!!!!! This doesn’t work on every column type, there are still limitations, but it does give some basic options.