I am trying to create a conditon in Flow where I look at a field in a sharepoint list and if the data in the field is either "open' or "pending" the conditon is true.
However, I an struggling to understand the "or" expresion syntax within flow
Can someone help explain what is needed in the expression1 and expression2?
thanks,
Todd
Hi @thanke,
Could you please share a screenshot of your flow’s configuration?
Which data type does the field that you mentioned belong to in your SharePoint list?
Further, could you please show a bit more about expression1 and expression2?
I have created a SharePoint list on my side and the list include the filed which is a Choice type column. The value of Choice type column includes “Open”, “Pending” and “Complete”.
I have made a test on my side and please take a try with the following workaround:
Within Condition box, click “Edit in advanced mode”, type the following formula:
@or(equals(items('Apply_to_each')?['Status']?['Value'], 'Open'),equals(items('Apply_to_each')?['Status']?['Value'], 'Pending'))
The flow works successfully as below:
More details about Or expression, please check the following article:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language
Best regards,
Kris