I have a few simple flows. When it's straightforward, filtering by one variable, it's working beautifully! When I try to add one more filter to the mix it falls apart.
I've included images for what is working...
How do I filter by two items?
Then
Merge all into one html table...
I hope this question makes semse
Solved! Go to Solution.
Hi @Ks75 ,
Do you want to apply multiple condition in the Filter array Action?
You could try to use advanced mode of Filter array Action to integrate multiple conditions.
I have made a test for your reference.
1. Here is my Excel.
2. Here is my Flow.
@and(condition1, condition2, condition3,...)
Result Screenshot:
In addition, here are some links that might help you:
https://tomriha.com/how-to-apply-multiple-conditions-in-the-filter-array-power-automate-action/
https://powerusers.microsoft.com/t5/Building-Flows/Fitler-array-multiple-conditions/td-p/287857
Best Regards,
Charlie Choi
apologies, I thought they did attach.
Hi @Ks75 ,
Do you want to apply multiple condition in the Filter array Action?
You could try to use advanced mode of Filter array Action to integrate multiple conditions.
I have made a test for your reference.
1. Here is my Excel.
2. Here is my Flow.
@and(condition1, condition2, condition3,...)
Result Screenshot:
In addition, here are some links that might help you:
https://tomriha.com/how-to-apply-multiple-conditions-in-the-filter-array-power-automate-action/
https://powerusers.microsoft.com/t5/Building-Flows/Fitler-array-multiple-conditions/td-p/287857
Best Regards,
Charlie Choi
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
28 | |
28 | |
20 | |
11 |