Filter Gallery Using Distinct Dropdown

[MP4249]

Hi,

Still very new to this and cannot seem to figure out how to do it!

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)

The issue is that the options in the dropdowns themselves contain multiple values where I only need to display one.

I tried using the following Distinct formula on each dropdown box which works fine:

Distinct(Stories_1,County)

Problem is this then breaks the gallery filter formula - what do I need to change here?

Thanks in advance!

[iAm_ManCat]

Heya,

When you make them distinct, they dont have other values like YOB, they are just a list of distinct values, so they will probably be Dropdown1.Selected.Result etc etc

Cheers,

ManCat

[wyotim · Accepted solution]

When using the Distinct function, it changes the resulting column name to Result instead of what it used to be. That means that for each Dropdown that uses a Distinct formula, the reference would end in “Result”. So for Dropdown1, it would be Dropdown1.Selected.Result instead of Dropdown1.Selected.Country. Changing this for each Dropdown that uses a Distinct function should get your Filter working.

[wyotim]

Oops! I should have refreshed before posting! Sorry for the echoed answer there @iAm_ManCat and @MP4249. 

[iAm_ManCat]

No worries!

And yeah I forgot that it's .Result not .Value - Have updated my first answer to .Result 🙂

[MP4249]

Thanks!