cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP4249
Helper II
Helper II

Filter Gallery Using Distinct Dropdown

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
wyotim
Resident Rockstar
Resident Rockstar

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.

 

 

View solution in original post

5 REPLIES 5
iAm_ManCat
Super User
Super User

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


wyotim
Resident Rockstar
Resident Rockstar

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.

 

 

View solution in original post

wyotim
Resident Rockstar
Resident Rockstar

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

No worries!

 

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

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Thanks!

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,481)