cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Filter and delegation warning

Hi Power Apps community, 

 

I am trying to sum the total days that a specific employee have used, the data is stored in sharepoint list.

I have the following code:  Sum(Filter('Vacation Request',Value(lblEmpID.Text) = EmployeeID), Total_x0020_Days). The formula gives me the "Yellow Triangle" with a delegation warning and that the Sum operation is not supported by this connector. I want to break the formula down in order to clear the "Yellow Triangle".

 

Can someone help me clear the delegation warning?

7 REPLIES 7
Highlighted
Dual Super User III
Dual Super User III

The delegation warning is just that, its a warning.  In this particular instance I don't think there is a need to worry about it.  As long as the Filter() based on UserID doesn't return more than 500 items (can be expanded to 2,000) you'll never have an issue.  Will an individual employee ever get more than 500-2,000 entries?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted

Hi @Pstork1 , thanks for the reply.

 

There is a chance that the entries of the employees can be more than 2000 overtime.

Highlighted
Dual Super User III
Dual Super User III

If that is the case then your only choice will be to pull the filtered set of records into a local collection and calculate the SUM from that collection.  Either that or figure out how to break your current filter into smaller chunks to get them under 2,000, Sum those and then add those sums together.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Helper V
Helper V

Delegation in Power Apps means process of retrieving data to the data source itself. This means Power Apps will retrieve small amount of data to make sure the performance is consistent. We often get delegation warning when we filter huge data source in Power Apps.

Highlighted

Hi @Max44  thanks for the reply. My concern was that if my entries is set up to 2000 items and I have 2001, when i am filtering I wouldn't be able to see or retrieve item 2001. 

Highlighted

@Pstork1, I will try it and I will let you know if it works.

 

Thanks.

Highlighted

Hi @JB0007,

 

I came across a useful API in SharePoint to get aggregate function values like Sum,Average etc.

We can call a flow from Power Apps to get the aggregate values.

Check it out:

https://youtu.be/qsIn0mytC_8

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,813)