FILTER GALLERY WITH DROPDOWN BY CHOICE FIELD IN SHAREPOINT LIST

%3CLINGO-SUB%20id%3D%22lingo-sub-1742770%22%20slang%3D%22en-US%22%3EFILTER%20GALLERY%20WITH%20DROPDOWN%20BY%20CHOICE%20FIELD%20IN%20SHAREPOINT%20LIST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742770%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20an%20app%20and%20want%20to%20filter%26nbsp%3Bdata%20in%26nbsp%3Bcolumn%20that%20is%20a%20%22choice%22%20field%20in%20SharePoint%20list.%20Made%20a%20dropdown%20box%20where%20Items%20%3D%20Choices(List.Column).%26nbsp%3B%20The%20Dropdown%20displays%20all%20items%20in%20that%20column%20with%20no%20problem.%20However%2C%20cannot%20figure%20out%20the%20filter%20function%20for%20the%20gallery.%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20can%20get%20is%3A%26nbsp%3B%20Filter(ListName%2C.%26nbsp%3B%26nbsp%3B%20Every%20combination%20that%20I%20try%2C%20the%20gallery%20returns%20blank.%3CBR%20%2F%3EDoes%20anyone%20have%20any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1742770%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742950%22%20slang%3D%22en-US%22%3ERe%3A%20FILTER%20GALLERY%20WITH%20DROPDOWN%20BY%20CHOICE%20FIELD%20IN%20SHAREPOINT%20LIST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742950%22%20slang%3D%22en-US%22%3EFilter(list%20name%2C%20columninlisttofilter%20%3D%20dropdowncontrolname.selected.value)%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Have an app and want to filter data in column that is a "choice" field in SharePoint list. Made a dropdown box where Items = Choices(List.Column).  The Dropdown displays all items in that column with no problem. However, cannot figure out the filter function for the gallery. 

As far as I can get is:  Filter(ListName,.   Every combination that I try, the gallery returns blank.
Does anyone have any ideas?

 

Thanks!

 

5 Replies
Highlighted
Filter(list name, columninlisttofilter = dropdowncontrolname.selected.value)

Highlighted

Hey @chudson002 ,

look at Chris Webbs filter formula up here and enter this in the items event of your gallery. 

 

Highlighted
Highlighted
Highlighted

@chudson002 ... and pls. give a thumbs up to us. Thanx.