cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JB0007
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
Pstork1
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.

Hi @Pstork1 , thanks for the reply.

 

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

Pstork1
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.
Max44
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.

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. 

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

 

Thanks.

RezaDorrani
Dual Super User II
Dual Super User II

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (30,756)