web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Delegation error on Fi...

Power Apps

Answered

Delegation error on Filter

(0) Share

Report

Report

Posted on by janineb

Good day

I have a gallery that filters via a text box on 4 different fields. The datasource is a Excel table. This is my formula:

Please see the delegation warning on the gallery:

Can you please assist me to fix the formula so that I don't get the delegation error?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Gochix 1,937 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @janineb ,

How many rows of data do you keep in your Excel file?
Would you consider to make a new collection from Excel file?

SortByColumns(Search(ZPR_BP_31May22, SearchTermTxt.Text , "GRP BP name","BP Name","GRP BP number","BP number"), "GRP BP name", Ascending)

Was this reply helpful? Yes No
janineb on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your guidance. Although the delegation warning disappeared, the filter does not work now. The number of records will exceed 500, but not more than 3000 maximum

Was this reply helpful? Yes No
Verified answer

Gochix 1,937 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Try to collect a new collection.
ClearCollect(TestCol,ZPR_BP_31May22);

Then apply the code below for gallery and see if this works.
SortByColumns(Search(TestCol, SearchTermTxt.Text , "GRP BP name","BP Name","GRP BP number","BP number"), "GRP BP name", Ascending)

Was this reply helpful? Yes No

Join the conversation