Friday Functions | Leveraging simple oData Queries and the new Condition action
Today I discuss two personal learnings:
1. oData queries are dependent upon what the data source will allow. So some operations or patterns that might be available in SP, might not be available in Excel.
2. The new condition action allows for AND or OR statements, so be sure to use the one that best fits your scenario! learn more on conditions here: https://flow.microsoft.com/en-us/blog...
Note: You may have used the old condition control to do this using the expression below. You may still choose to take this approach if you use the Filter Array action:
or(equals(item()?['status'], 'unnecessary'), equals(item()?['status'], 'completed'))
See also:
https://docs.microsoft.com/en-us/flow...
https://docs.microsoft.com/en-us/flow...
oData Query Operators:
eq - equal to
lt - less than
gt - greater than
ge - greater than or equal to
le - less than or equal to
ne - Not equal to