Forum Discussion

Robbert-Jan van Velzen's avatar
Robbert-Jan van Velzen
Copper Contributor
May 12, 2020

Sharepoint list 'filter pane' webpart

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 metada...
RobElliott's avatar
RobElliott
Silver Contributor
May 12, 2020

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).

 

 

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)

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.

 

Resources