cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Motty_25
Helper I
Helper I

Multiple Filters

Hi,

I am fairly new to PowerApps and have set up an app (from a SharePoint list) where I want to be able to filter by several different fields, as follows:

Current Owner (Person or Group)

Asset Type (Choice)
Location (Choice)
Status (Choice)

Model (Choice)

 

Can anybody provide any pointers as to what the best way to go about this?

Many thanks

1 ACCEPTED SOLUTION

Accepted Solutions

That is easy then...

 

Filter( YourDataSource; 

Current Owner = DropdDown1.Selected.Value;

Asset Type (Choice) = DropdDown2.Selected.Value;
Location (Choice) = DropdDown3.Selected.Value;
Status (Choice) = DropdDown4.Selected.Value;

Model (Choice) = DropdDown5.Selected.Value)

 

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

View solution in original post

4 REPLIES 4
Nogueira1306
Community Champion
Community Champion

Hey... It depends how you want to filter... If you want to search, if you want to show only something from the user, if you want every parameter filled or not.... We need more info...

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn! 

Hi @Nogueira1306 

Thanks for your reply.

My preference, if it's possible, would be to have a dropdown menu for each of the columns I mentioned above.

I wouldn't want every parameter to be filled. For example, in some cases I might just want to filter by Asset Type and Status, or another time I might just want to filter by Location or Current Owner.

That is easy then...

 

Filter( YourDataSource; 

Current Owner = DropdDown1.Selected.Value;

Asset Type (Choice) = DropdDown2.Selected.Value;
Location (Choice) = DropdDown3.Selected.Value;
Status (Choice) = DropdDown4.Selected.Value;

Model (Choice) = DropdDown5.Selected.Value)

 

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

View solution in original post

Thanks for this and sorry for delay in replying.
The only slight issue I'm having at the moment is that, if I leave any of the Combo Boxes blank, the search fails. Do you know how I can prevent this?

I'm still having a couple of problems regarding the Current Owner.

The Current Owner field is a Person/Group field which searches the Office 365 directory.
I have successfully set up a Combo Box that brings up the list of names. (using the Office365Users datasource)

 

However, where I'm having an issue is that I'm struggling to get the Browse Gallery to filter by the names I have selected in the combo box mentioned above.
Any idea how I can do this?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,104)