Filter array in Advanced Mode
Quiz question
When do you switch Filter array to Advanced Mode?
Solution
- A) When several conditions belong in one filterCorrect. In Advanced Mode you write the condition as an expression and combine several checks with and() or or().
- B) When you want to sort the items by a fieldWrong. Filter array removes items but does not sort them. The order stays the same.
- C) When the filter should run directly in SharePointWrong. Filter array works inside the flow on an array that is already loaded, not in the data source.
What it is about
In basic mode, the Filter array action offers one condition with a field, an operator and a value. In many cases that is not enough: two conditions at once, an OR combination or a comparison with a calculated value. Instead of chaining several filters, you switch to Advanced Mode. There you write the condition as an expression and combine functions such as equals(), contains(), and() and or(). You can also include dynamic content from earlier actions. Everything stays in a single action, and the flow becomes easier to read. The designer still shows simple comparisons as fields.
When to use it, when not
Use it
When you want to combine several conditions or compare against calculated values.
Better not
When a single comparison is enough. Basic mode then stays easier to read.
Most common mistake
Chaining several Filter array actions when one expression with and() does the same in a single step.
License
Standard Runs without a premium connector, so the license from Microsoft 365 is enough. Source on Microsoft Learn: Power Automate licensing FAQ. For your whole flow: License check.
Share
Short link: powerautomate.ninja/en/3
Source: PowerPlatformTip #3, Microsoft Learn: Use data operations in Power Automate.