cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PAB
Level: Powered On

Multiple Filters for Browse Screen

Hi,

 

I just started creating a new App and I want to change the default Browse Screen1 so that I can have multiple filters on this column that consist of dropdowns and not an open text field. How do I incorporate all the columns I want to filter by and what is the formula to have them all filter together?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
hpkeong
Level 10

Re: Multiple Filters for Browse Screen

Hi @PAB

 

In fact, they are repeating questions on this part and you can search in the forum and I have posted before.

Anyway, you are right that PA sample provides Text Search by default and this is common.

 

But app maker like us make wish to have multiple search or filter functions.

 

So, please have this conditions in your mind and you can play with it anytime.

Example:

- You have a datasource called Table1

- You have a gallery

- You want to fileter by: Dropdown, ListBox or even Text Field (Label)

 

1. OnScreen,Visible = ClearCollect(Anyname, Table1) This means it will collect your Table1 data into a collection called Anyname

2. Set the Gallery.Items = Anyname - This will populate your gallery with data from Table1 thru Anyname

3. OK, now you have playaround with it using any method to filter.

Dropdown.Items = Distinct(Table1, Field1)

Dropdown.Onchange = ClearCollect(AnyName, Filter(Table1,  Field1 = Dropdown1.Selected.Result))

 

The same, applies to anyother filtering method

- TextInput

- ListBox

- Another Gallery,....

 

The trick is to use ClearCollect(Temporary Collection Table, based on your Filtering Results) and then populate into a Gallery or Data Table.

 

I hope this posts can help again on those who ask the same questions.

 

I hope it helps and you enjoy playing around with this.

 

TQ

hpkeong

View solution in original post

4 REPLIES 4
Highlighted
Fatima
Level: Powered On

Re: Multiple Filters for Browse Screen

Hi PAB,

 

In the normal situation, the "items" field of the Gallery is set up to your datasource. In your situation, you can tweak that a little bit and add filter functions on the columns you would like to filter the datasource by.

 

For example, if your gallery is reading data from a sharePOint list called "Scores", then the items attribute of the gallery is set to "Scores". Thats the normal situation.

In your case, you can say, Filter(Scores, "Yes" in ScoredStatus) -- where ScoredStatus is a column in the scores table and is of type boolean.

 

Hope that helps as a starting point. If you have a specific scenrio that you would like to discuss, please post back. 

hpkeong
Level 10

Re: Multiple Filters for Browse Screen

Hi @PAB

 

In fact, they are repeating questions on this part and you can search in the forum and I have posted before.

Anyway, you are right that PA sample provides Text Search by default and this is common.

 

But app maker like us make wish to have multiple search or filter functions.

 

So, please have this conditions in your mind and you can play with it anytime.

Example:

- You have a datasource called Table1

- You have a gallery

- You want to fileter by: Dropdown, ListBox or even Text Field (Label)

 

1. OnScreen,Visible = ClearCollect(Anyname, Table1) This means it will collect your Table1 data into a collection called Anyname

2. Set the Gallery.Items = Anyname - This will populate your gallery with data from Table1 thru Anyname

3. OK, now you have playaround with it using any method to filter.

Dropdown.Items = Distinct(Table1, Field1)

Dropdown.Onchange = ClearCollect(AnyName, Filter(Table1,  Field1 = Dropdown1.Selected.Result))

 

The same, applies to anyother filtering method

- TextInput

- ListBox

- Another Gallery,....

 

The trick is to use ClearCollect(Temporary Collection Table, based on your Filtering Results) and then populate into a Gallery or Data Table.

 

I hope this posts can help again on those who ask the same questions.

 

I hope it helps and you enjoy playing around with this.

 

TQ

hpkeong

View solution in original post

AndreasKurzman
Level: Powered On

Re: Multiple Filters for Browse Screen

Hello

 

Why is the data source name important.. mine called Tabelle1 because of my mother language German!

hpkeong
Level 10

Re: Multiple Filters for Browse Screen

Ok u can whatever your table name, I am only giving example.

Tq
hpkeong

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,912)