cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DaftNewb
Frequent Visitor

Use multiple filters (contains) in the same column

Hello experts, in the past weeks i've been building a flow that is activated at powerapps by pressing a button, the flow gather the thousands of data from 2 sharepoint lists wich one of the lists have the same person multiple times (wich it's fixed by the flow and each person has its own row), and transform it into an excel file, all working properly.

 

But now it's time to automate some filters that i plan to gather from powerapps since some of the columns have lots of data separated by comma,  some have lots of data on the specific column wich i think the filter "contains" would work well at this point, but i can only apply 1 "contain filter" by column so if i want to see people on that column wich have for example: "excel", "word", "power automate" and "english" on that same column impossible to track.

 

I've tried to use Filter query odata but it works only for one criteria, i've been looking for a way to write an excel (online excel for business) script, but the max amount of criteria i could use on the "applyCustomFilter" where 2. I've also tried to build a condition to pick up the persons who have the desired criterias but i don't know if there is a way to make it "less hard coded" since the user can use different amounts of filters.

 

The  primary idea it's to let the user put the amount of filters it deems necessary (even if it return nothing at the end lol)

 

Since i'm quite new at power automate i'm having a hard time with that is there a better way of doing it? since i'm collecting what the user want as "filter" on power apps it's possible that people try to use even more than this amount of filters. And no i can't do any alterations on sharepoint.

 

I hope my question has been clear and thanks in advance for all the support everyone.

1 ACCEPTED SOLUTION

Accepted Solutions
DaftNewb
Frequent Visitor

I've found the answer on this post in case anyone else is wondering how to do it Solved: Filter Excel Multiple Variables - Power Platform Community (microsoft.com)

i've just used the same column name multiple times and it worked well.

View solution in original post

1 REPLY 1
DaftNewb
Frequent Visitor

I've found the answer on this post in case anyone else is wondering how to do it Solved: Filter Excel Multiple Variables - Power Platform Community (microsoft.com)

i've just used the same column name multiple times and it worked well.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (4,078)