Power Platform Community Forum Thread Details

Hi All ,

I have a combo box and a Gallery on my app and based on the selection in the combo box values filtered results will be shown in the gallery, however, I am getting a delegation warning that might affect the dataset. The database is connect to the dataverse table

Formula - Filter(
Skill_Tables,
serviceHubLocation in Gallery2.Selected.Value & skillCategory in ComboBox3.SelectedItems && skillName in ComboBox3_1.SelectedItems
)

Categories:

Building Power Apps

Hi @Hit_23

Try this formula,

With({
Filt:Filter(
Skill_Tables,
serviceHubLocation = Gallery2.Selected.Value &&
skillCategory in ComboBox3.SelectedItems &&
skillName in ComboBox3_1.SelectedItems
)
},Filt
)

You can use collection also to avoid delegation, In App OnStart, or Screen OnVisible or any other controls OnSelect properties.

ClearCollect(collectionname,Skill_Tables)

Gallery Item: 

Filter(
collectionname,
serviceHubLocation = Gallery2.Selected.Value &&
skillCategory in ComboBox3.SelectedItems &&
skillName in ComboBox3_1.SelectedItems
)

Refer this blog.

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.