Answered

Items formula delegation issue

(0) Share

Report

Posted on by tagustin

Hello,

I'm wondering if I can get some advice on how to fix a delegation warning. I have over 1000 entries in my Daily Log so it is starting to become an issue. Below is the Items formula both as text and as a screenshot so you can see exactly where I am getting the blue squigglies. I would appreciate any advice on how to get around this since I am currently testing this app out on myself, but would like to eventually roll it out to the entire department as a project time tracking solution. Let me know if there is any other information you need. Thank you! Teresa

Sort(Filter('Project Time Spent', 'Admin Email'=varUser.Email && Text('Start Time', ShortDate) = Text(dpDailyLog.SelectedDate, ShortDate)),'Start Time', Ascending)

Blue Lines SS.png

Daily Log SS.png

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@tagustin

Hi Teresa!

You are trying to perform a Text function on a field in your datasource in the filter...this will not be delegable as the datasource will not be able to take a PowerApp function and process it on the source side. Thus, the delegation warning!

Consider changing to:

Sort( Filter('Project Time Spent', 'Admin Email'=varUser.Email && 'Start Time' >= dpDailyLog.SelectedDate && 'Start Time' < DateAdd(dpDailyLog.SelectedDate, 1, Days) ), 'Start Time', Ascending )

This will do all the PowerApps function on the App side prior to the source. It will be able to delegate that because the DateAdd is done prior to the query being generated and you are instead just comparing greater and less than...which is all delegable.

I hope this is helpful for you.
tagustin on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes

Thanks Randy! That worked perfectly! Have a great day!

Teresa
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@tagustin

Excellent!! Always happy to help! Have a great day too!