Hi,
Please help in working filter pane option as it is unable to filter gallery when the new collection is added to the existing one,When I try to choose any option in 'AB' filter it is not filtering based on chosen option in filter pane
Filter code:Sort(Distinct(Collection1,'AB'),Value
Item Gallery:
Search( Filter( Datasource, IsBlank(ABDrop.Selected.Result) || 'AB' = ABDrop.Selected.Result, IsBlank(MADrop.Selected.Result) || 'MA' = MADrop.Selected.Result, IsBlank(KVDrop.Selected.Result) || 'KV’ = KVDrop.Selected.Result, IsBlank(SPDrop.Selected.Result) || 'SP' = SPDrop.Selected.Result, IsBlank(PDrop.Selected.Result) || 'P' = PGroupDrop.Selected.Result, AB.Yes || User().FullName in userlist.<EXEMPTUSERFULLNAME?> 'MA' in Filter( userlist, 'primary name column' = user().FullName, AB.Yes || User().FullName in <EXEMPTUSERFULLNAME?>, ).MA ), SearchBox.Text, "Itemdescp", "ProdID" );
@BCBuizer Can you please look into this as it is continuation of filtering gallery based on user list.This will be really helpful
Many Thanks,
Sai
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional