Unanswered

We have a Delegation warning on that Gallery in power apps canvas.

(0) Share

Report

Posted on by krishnach11 Microsoft Employee

We have two Gallery objects in our application GalParentItems and GalChildItems and both of them are giving a Delegation Warning in the PowerApps Canvas. Also, we are seeing the behavior in our application which is that incomplete data is displayed when the Data Row Limit is reached.

We are using the Filter function which should be delegable, and we are using SharePoint as a data source which should support delegation. And yet, behavior is as if delegation is not occurring. We do not know why. Our formulas are as follows:

GalParentItems

Filter(Opportunities,'Opportunity Owner'.Email=User().Email && 'Sales Stage'.Value <> "Won" && 'Sales Stage'.Value <> "Lost" && 'Sales Stage'.Value <> "Moved Out")

GalChildItems

Filter (OpportunityItems, Opportunity_x0020_ID.Id=varParentItem.ID)

And I am unable to see records more than 500 when data row limit is set to 500, I can see them when it is set to 2000. Now in future I will get more than 2000 records what can I do to fix this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 69,129 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
The problem in GalParentItems is the use of User().Email in the filter. YOu can't embed a function inside the filter it you want it to be delegable. The fix is to store the User().Email in a variable and use the variable. Put the following in your OnStart for the app

Set(userEmail, User().email)

and then use userEmail in the filter.

For the GalChildItems it would be better if you just show the Child items for a selected Parent record instead of trying to get them all. Use the following filter

Filter(OpportunityItems, Opportunity_x0020_ID.Id=GalParentItems.Selected.ID)

Was this reply helpful? Yes No
krishnach11 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

On the GalChildItems we are still facing an issue,
The issue doesn’t have to do with varParentItems but it has to do with the .Id part of Filter (OpportunityItems, Opportunity_x0020_ID.Id=varParentItem.ID). It would seem that this part of the formula is not delegable. We would still be requesting assistance to find a different way to express what we are trying to achieve, or a work-around.

Sir this is the reply from customer, any additional help would be greatly appreciated.

Was this reply helpful? Yes No