cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
clau0289
Kudo Collector
Kudo Collector

ForAll function not giving delegation warning

Hello everyone, I am working hard to correct many of my PowerApps to avoid delegation problems and a doubt came to my mind.

I have seen in documentation + other threads that the ForAll function is not delegable. In my app I have something like this:

 

ForAll(Filter(Resource_Allocation; ResAlloc_Prj_ID = ComboBox1.Selected.ID And ResAlloc_Long = 0);
Collect(Alloc_Chart;{
Person_ID: ResAlloc_Res_ID;
Ini_Date: ResAlloc_Start;
End_Date: ResAlloc_End;
}))

 

Where Resource_Allocation is a SharePoint list. In this case I have no delegation warning! Should I be confident that this code will not have delegation problems?

 

Thank you for your feed back!

 

Claudia.

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hey @clau0289 

 

If you are not getting any delegation warning, then you are good to go. You can update one of the setting just be more confident.

App Settings -> Advanced Settings -> Data Row Limit for Non-Delegable queries -> 2000.

Also, sometimes the delegation warning occurs when you have a hierarchical level of dynamic content, which is not the case in your formula. Until your logical implementation is correct, the formula will work without any problem.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

2 REPLIES 2
yashag2255
Dual Super User II
Dual Super User II

Hey @clau0289 

 

If you are not getting any delegation warning, then you are good to go. You can update one of the setting just be more confident.

App Settings -> Advanced Settings -> Data Row Limit for Non-Delegable queries -> 2000.

Also, sometimes the delegation warning occurs when you have a hierarchical level of dynamic content, which is not the case in your formula. Until your logical implementation is correct, the formula will work without any problem.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Hello @yashag2255  thank you for your answer,

 

I don't think I will increase the number of delegable queries as I have noticed that it makes the app much slower.

I hope I can be confident with this, in any case I will double check when we get over the 500 records (it happen sooner o later).

 

Thank you again,

 

Claudia.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,354)