Forum Discussion
Sharepoint list 'filter pane' webpart
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.