Filter Gallery - Show 'All' within multiple dropdowns

(0) Share

Report

Posted on by MP4249

Hi again,

Still learning and finding this quite confusing so bear with me!

So I have a single gallery displaying data from a sharepoint list. I can filter that gallery using four dropdown boxes using the following formula which works fine:

Filter(SPList,County = Dropdown1.Selected.County,YOB = Dropdown2.Selected.YOB,Ethnicity = Dropdown3.Selected.Ethnicity,Connection = Dropdown4.Selected.Connection)

How do I add an 'All' option to each dropdown as default so the user can leave it selected and only filter on one or more of the other options?

For example They may want to see results from all the 'Counties' but only for other specified criteria. Likewise they may want to leave all filters set to 'All' as default so the gallery shows everything.

Hope this makes sense,

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MP4249 ,

Are all these fields text column type in SharePoint list?

Assume that they are all text fields then:

Please add a "" value in these 3 dropdown controls. For example, set below formulas in the Dropdown1 control:

["Choice 1","Choice 2","Choice 3",""]

Then set below formula in the Items property of the gallery:

If(Dropdown1.Selected.Value="",Filter(SPList,YOB = Dropdown2.Selected.Value,Ethnicity = Dropdown3.Selected.Value,Connection = Dropdown4.Selected.Value),Dropdown2.Selected.Value="",Filter(SPList,County = Dropdown1.Selected.Value,Ethnicity = Dropdown3.Selected.Value,Connection = Dropdown4.Selected.Value),Dropdown3.Selected.Value="",
Filter(SPList,County = Dropdown1.Selected.Value,YOB = Dropdown2.Selected.Value,Connection = Dropdown4.Selected.Value),Dropdown4.Selected.Value="",Filter(SPList,County = Dropdown1.Selected.Value,YOB = Dropdown2.Selected.Value,Ethnicity = Dropdown3.Selected.Value),Filter(SPList,County = Dropdown1.Selected.Value,YOB = Dropdown2.Selected.Value,Ethnicity = Dropdown3.Selected.Value,Connection = Dropdown4.Selected.Value))

Regards,

Mona

Was this reply helpful? Yes No
MP4249 63 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-monli-msft

Hi Mona,

Thanks very much for your reply - yes all fields are text column types in sharepoint.
However, in this case the dropdowns are displaying the distinct items from the sharepoint list column for example:

Distinct(SPList, County)

How would I format in this case?
Thanks again

Was this reply helpful? Yes No