Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Best Practices to avoid delegation (addcolumns function tip)

Hi guys,


I have some questions about the best practices to avoid delegation using dataverse lookup columns. Cause when I have a relationship between two tables and wanna filter in a gallery by id, the app is giving me delegation problem.


So, I learned a time ago, one thing that helps me to avoid the delegation alert likes add a AddColumns function (Solved: Filtering a gallery based on a second level relati... - Power Platform Community (microsoft....) and all my apps i used this.


But, I made some tests decreasing the delegation row limits and I noticed that the delegation problem continue, but the app don't show me message error.


Someone can test this and confirm to me, please? And if is correct, is there some way to know all place of my app that having this problem, like using monitor or debugging?



@Pinguito This is because of a Preview feature seen below,



When this is ON, it will load only columns that are explicitly used. Because you are not using the Valor column explicitly its value is blank and when it's all added up it just returns 0.

@CNT thank you very much! Now I think it's all correct (:

Helper I
Helper I

@CNT  one last question, please. If we need to get all register of a 3rd entity but using the first, how would you do?


In your last example is like: Events > EventAttendance > WeekDay

So, I want to return all week days created by selecting the event.

@Pinguito Unfortunately we can't go more than 1 level. We will have to do a LookUp to do that. Hope the Product Team will change that someday. 

@Pinguito Hope you got is all sorted!


Please remember to give a 👍 and accept the solution as it will help others in the future.

@CNT What do you do in this case? Create a LookUp Column between Events and WeekDay? I need to access this data in 3rd relationship entity without have delegate warn 😕

@Pinguito yes, when we want to more than 1 level deep, we have to query that separately with Search, Filter or LookUp.

Helper I
Helper I

@CNT could u give me example pls? using id column

Helper I
Helper I

@CNT I would like to get all "Despesas" of all items in my gallery, like this:


What is the best way? Please help meee

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,182)