Unanswered

HOW TO SOLVE DELEGATION LIMIT ISSUE IN POWER APP?-FOR 30000 RECORDS Using SQL connector

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have gone through lot of blogs on this but nothing seems to be suited for my requirement, I have 30000+ records in my SQL table SOX_ISP. I want filter my gallery items on the basis of three selection (User().Email, Status dropDown and Resource list dropDown controls). but in Resource List dropdown I'm not able to receive resource names which occurs after 2000 in the SQL table. (attached screenshot for the same), can anyone please help.

Resource List DD: Sort(Distinct(Filter(SOX_ISP , LINE_MANAGER_EMAIL = User().Email),REGISTRATION_NAME),Result)
Gallery: Filter (SOX_ISP,REQUEST_STATUS = Dropdown1_9.SelectedText.Value && REGISTRATION_NAME = Dropdown2_4.SelectedText.Value)

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
I'm not sure if this will fix all of your issues, but you need to replace the user().Email in the Filter with a Variable. Functions like User().Email are not delegable, but the value generated by them is. You can use the following in the OnStart and then use the variable in your filter.

Set(currentEmail,User().Email)

That may not solve your entire problem because Distinct() also isn't delegable. If changing the User().Email doesn't filter things below the data row limit you may have to use Power Automate to use a Stored Procedure to get the distinct resources and return them.
mogulman 764 on at

Like
a
(2)

Report
Copy link

Link copied!
I don't know if this helps but can you create a View of distinct USERS and use the View in your equation.

CREATE VIEW [dbo].[LineManagerEmailV] AS SELECT DISTINCT LINE_MANAGER_EMAIL FROM dbo.SOX_ISP GO
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

That is a good solution to the problem of Distinct() not being delegable. Then use the currentUserEmail variable to make the filter of that view Delegable.