Sharepoint list 'filter pane' webpart

%3CLINGO-SUB%20id%3D%22lingo-sub-1382073%22%20slang%3D%22en-US%22%3ESharepoint%20list%20'filter%20pane'%20webpart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382073%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20sure%20where%20to%20start%20but%20is%20there%20a%20way%20to%20make%20the%20Listview%20webpart%20show%20the%20filter%20pane%20by%20default%3F%20Or%20is%20there%20a%20filter-pane%20webpart%20to%20dynamically%20filter%20down%20a%20modern%20sharepoint%20list's%20metadata%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20already%20exist%20or%20would%20it%20be%20possible%20to%20create%20this%20using%20a%20PowerApp%20and%20use%20the%20powerapp%20webpart%20instead%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1383154%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20list%20'filter%20pane'%20webpart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1383154%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F39914%22%20target%3D%22_blank%22%3E%40Robbert-Jan%20van%20Velzen%3C%2FA%3E%26nbsp%3Bthe%20List%20web%20part%20can't%20display%20the%20filter%20pane%20and%20there%20is%20no%20filter%20pane%20web%20part.%20So%2C%20as%20you've%20said%2C%20a%20Power%20Apps%20app%20displayed%20with%20the%20Microsoft%20Power%20Apps%20web%20part%20is%20one%20way%20to%20filter%20a%20list%20embedded%20on%20a%20page%2C%20providing%20your%20list%20has%20less%20than%202000%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20example%20I%20have%20a%20combobox%20so%20multiple%20items%20can%20be%20selected%20and%20it%20gets%20the%20items%20from%20the%20Counties%20list.%20The%20main%20gallery%20initially%20gets%20items%20from%20the%20Towns%20list%20(columns%3A%20Title%20%3D%20town%20and%20County%20%3D%20County).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22app.png%22%20style%3D%22width%3A%20778px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190987i0D8CB10E79D6987D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22app.png%22%20alt%3D%22app.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ECollection%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EcolTowns%20gets%20up%20to%202000%20items%20from%20Town%20list%3C%2FP%3E%3CP%3E%3CSTRONG%3ECombobox%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EcbCounties%3A%20Items%20%3D%20Counties%2C%20OnSelect%20%3D%26nbsp%3BClearCollect(colTowns%2C%20Towns)%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3ECounties%20Selected%3C%2FSTRONG%3E%3CBR%20%2F%3ElblSelectedCounties%3A%26nbsp%3BConcat(cbCounties.SelectedItems%2C%20Title%2C%22%2C%20%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EGallery%3C%2FSTRONG%3E%3CBR%20%2F%3EgalTowns%3A%20Items%20%3D%26nbsp%3BIf(IsEmpty(colTowns)%2C%20Sort(Towns%2C%20Title%2C%20Ascending)%2C%20Sort(Filter(colTowns%2C%20County%20in%20cbCounties.SelectedItems.Name)%2CTitle%2CAscending))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EClear%20Button%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EReset(cbCounties)%3B%20Reset(galTowns)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filterListCombobox.gif%22%20style%3D%22width%3A%20723px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190988i1A2FAC67AF3F82EB%2Fimage-dimensions%2F723x382%3Fv%3D1.0%22%20width%3D%22723%22%20height%3D%22382%22%20title%3D%22filterListCombobox.gif%22%20alt%3D%22filterListCombobox.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Not sure where to start but is there a way to make the Listview webpart show the filter pane by default? Or is there a filter-pane webpart to dynamically filter down a modern sharepoint list's metadata?

 

Does this already exist or would it be possible to create this using a PowerApp and use the powerapp webpart instead? 

1 Reply
Highlighted

@Robbert-Jan van Velzen the List web part can't display the filter pane and there is no filter pane web part. So, as you've said, a Power Apps app displayed with the Microsoft Power Apps web part is one way to filter a list embedded on a page, providing your list has less than 2000 items.

 

In my example I have a combobox so multiple items can be selected and it gets the items from the Counties list. The main gallery initially gets items from the Towns list (columns: Title = town and County = County).

 

app.png

 

Collection:
colTowns gets up to 2000 items from Town list

Combobox:
cbCounties: Items = Counties, OnSelect = ClearCollect(colTowns, Towns)

Counties Selected
lblSelectedCounties: Concat(cbCounties.SelectedItems, Title,", ")

 

Gallery
galTowns: Items = If(IsEmpty(colTowns), Sort(Towns, Title, Ascending), Sort(Filter(colTowns, County in cbCounties.SelectedItems.Name),Title,Ascending))

 

Clear Button:
Reset(cbCounties); Reset(galTowns)

 

filterListCombobox.gif

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.