Delegation warning in gallery

(0) Share

Report

Posted on by Matt383

407

Hi,

My data source is sharepoint, on the items of my gallery i have,

Sort(Filter(EngineTimeSheet,Name=User().FullName,Or(StartsWith(JobNumber,TextSearchBox2),StartsWith(Date,TextSearchBox2),StartsWith(Customer,TextSearchBox2)),
DateValue(Date) >= Dropdown1.Selected.StartDate && DateValue(Date) <= Dropdown1.Selected.EndDate),Date,SortOrder.Descending)

Any ideas of a workaround to remove the delegation warning would be much appreciated.

Image below is the gallery, Dropdown1 allows the user to filter their timesheets.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Matt383

Is your delegation warning on the Filter function?
Maybe you could try the following ways:
OnStart/OnVisible event of the screen, use collect functions to fetch records as a variable with the following syntax:
Collect(YourCollectionNameWithoutQuotes,DataSourceName)
Then, Use "YourCollectionNameWithoutQuotes" as DataSource to operate on PowerApps control which would help to remove the delegation warning message.
Hope it helps.

Best regards,
Sylvia

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Thanks Sylvia, that has removed the delegation warning.

Was this reply helpful? Yes No