Power Platform Community Forum Thread Details

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

Categories:

Building Power Apps