I need to filter a sharepoint list with the condition "Contains" multiple times.
How do i do this?
"If column X contain Y or column Z contain V or column T contains R, Then print out the list of the remaining result"
How do i do this?
Solved! Go to Solution.
Hi @Oskarkuus ,
Filter Query does not support this type of filtering if you use contains as a filter.
You can use the Filter array and then add multiple conditions in the Edit in advanced mode.
@or(contains(item()?['Column1'], 'test'),contains(item()?['Column2'], 'test2'),contains(item()?['Column3'], 'test3'))
Like:
https://docs.microsoft.com/en-us/power-automate/use-expressions-in-conditions
Hope it helps.
Best Regards,
Hi @Oskarkuus ,
Filter Query does not support this type of filtering if you use contains as a filter.
You can use the Filter array and then add multiple conditions in the Edit in advanced mode.
@or(contains(item()?['Column1'], 'test'),contains(item()?['Column2'], 'test2'),contains(item()?['Column3'], 'test3'))
Like:
https://docs.microsoft.com/en-us/power-automate/use-expressions-in-conditions
Hope it helps.
Best Regards,
User | Count |
---|---|
38 | |
36 | |
16 | |
13 | |
12 |
User | Count |
---|---|
24 | |
20 | |
18 | |
13 | |
13 |