Power Apps - Error Handling

How to solve Delegation errors in PowerApps?

Like (0) Share

Report

Posted on 4 Apr 2025 09:20:32 by AM-27021731-0

I am dealing with a large set of data and currently using in,&& , || and <> inside my filter functions.

I currently set my Data row limit to 2000, which is a temporary fix.

Is there any solution to solve these issues?

i have given an example formula below

SortByColumns(
    Filter(
        'DDM Workorders Internal KPI Tracking',
        ('Internal Status'.Value in ["Assigned", "WIP", "Sent for QC", "Hold", "Internal Rework","Internal Completed"]) &&
        Office365Users.MyProfile().Mail = Executer.Email
    ),
    "ID",
    SortOrder.Descending
)
 
In this example im getting issue in "in" part.

All responses (5)

Answers (0)

vipuljain03 417 on 05 Apr 2025 at 16:42:43

Like (0)

Report

How to solve Delegation errors in PowerApps?

For Delegation => Replace the "in" with || for individual checks.

Additionally, try to reduce the number of columns retrieved by using ShowColumns() or AddColumns() to reduce the size of data being handled and this will also potentially improve app performance.
ronaldwalcott 2,427 on 04 Apr 2025 at 20:07:38

Like (0)

Report

How to solve Delegation errors in PowerApps?

Your best solution is to consider a redesign. If you provide some more information on your application someone here will provide some suggestions.
Suggested answer

tamint 2 on 04 Apr 2025 at 14:47:09

Like (0)

Report

How to solve Delegation errors in PowerApps?

because in is not delegable.

If you use Sharepoint as Datasource, then show on Link:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-sharepoint-online#power-apps-delegable-functions-and-operations-for-sharepoint
Suggested answer

MS.Ragavendar 1,232 on 04 Apr 2025 at 13:04:50

Like (0)

Report
How to solve Delegation errors in PowerApps?

@AM-27021731-0,

PowerApps has delegation limits when working with large data sources like SharePoint, SQL, and Dataverse. Your current data row limit of 2000 is a temporary fix but does not solve the issue for large datasets.

Power Fx
SortByColumns( Filter( 'DDM Workorders Internal KPI Tracking', ('Internal Status'.Value = "Assigned" || 'Internal Status'.Value = "WIP" || 'Internal Status'.Value = "Sent for QC" || 'Internal Status'.Value = "Hold" || 'Internal Status'.Value = "Internal Rework" || 'Internal Status'.Value = "Internal Completed") && Office365Users.MyProfile().Mail = Executer.Email ), "ID", SortOrder.Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item
DJ_Jamba 2,774 Super User 2025 Season 1 on 04 Apr 2025 at 10:23:54

Like (0)

Report
How to solve Delegation errors in PowerApps?

Try something like this:

With( { userEmail: Office365Users.MyProfileV2().mail, statusVals: ["Assigned","WIP","Sent for QC","Hold","Internal Rework","Internal Completed"] }, With( { qFilter: Filter( 'DDM Workorders Internal KPI Tracking', Executer.Email = userEmail ) }, SortByColumns( Filter( qFilter, 'Internal Status'.Value in statusVals ), "ID", SortOrder.Descending ) ) )

OR

With( { userEmail: Office365Users.MyProfileV2().mail }, SortByColumns( Filter( 'DDM Workorders Internal KPI Tracking', And( Executer.Email = userEmail, Or( 'Internal Status'.Value = "Assigned", 'Internal Status'.Value = "WIP", 'Internal Status'.Value = "Sent for QC", 'Internal Status'.Value = "Hold", 'Internal Status'.Value = "Internal Rework", 'Internal Status'.Value = "Internal Completed" ) ) ), "ID", SortOrder.Descending ) )