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

Filter Items for DropDown list based on SharePoint list

I have a Gallery linked to a SharePointList that I want to show, but I need this gallery to be filterable based on a multi-select dropdown. One column that I want to filter on is a text column that can be empty, so I have the following code to create a collection based on the column from the SharePoint list, and then filter that column down to only entries that are not blank, empty, or null. However this isn't working and I'm still getting the full list, which means the dropdown has empty values inserted into it.

 

 

Refresh('MySPList')
ClearCollect(FilterCollection,'MySPList'.'Name');
Filter(FilterCollection, Not(IsBlank('Name')));

 

 

Am I doing something wrong? This code is located in the OnVisible method of the screen the gallery and search box are contained in. I would also like to go further and only get distinct, non-empty values to display in the dropdown. Is this possible?

 

10 REPLIES 10

You're a life saver! I had a typo in my code but your answer cleared it up. 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 (2,840)