web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation error help ...
Power Apps
Unanswered

Delegation error help required

(0) ShareShare
ReportReport
Posted on by 2

Looking for some help. Have a list about 2k worth of records. I want to initially filter by the column Archive = False and then run the switch below. Issue facing is I only see 5 records due to delegation error in PowerApps. Can someone please help?

 

 

 

Switch( varRequestSortColumn, "DMIID", SortByColumns( If( ToggleHideArchieve.Value, If( isDMIUser, Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && (Status.Value <> "ARCHIVE: Completed" && Status.Value <> "ARCHIVE: Cancelled by Requestor" && Status.Value <> "ARCHIVE: Cancelled by DMI team" && Status.Value <> "ARCHIVE: Splitted" && Archive = "False") ), Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && (Status.Value <> "ARCHIVE: Completed" && Status.Value <> "ARCHIVE: Cancelled by Requestor" && Status.Value <> "ARCHIVE: Cancelled by DMI team" && Status.Value <> "ARCHIVE: Splitted" && Archive = "False") && ('Created By'.Email = User().Email || User().Email in ShowColumns( InformedPeople, "Email" )) ) ), If( isDMIUser, Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && Archive = "False" ), Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && Archive = "False" && ('Created By'.Email = User().Email || User().Email in ShowColumns( InformedPeople, "Email" )) ) ) ), "DMIID", If( varRequestSortDirection = SortOrder.Ascending, SortOrder.Ascending, SortOrder.Descending ) ), "Title", SortByColumns( If( ToggleHideArchieve.Value, If( isDMIUser, Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && (Status.Value <> "ARCHIVE: Completed" && Status.Value <> "ARCHIVE: Cancelled by Requestor" && Status.Value <> "ARCHIVE: Cancelled by DMI team" && Status.Value <> "ARCHIVE: Splitted" && Archive = "False") ), Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && (Status.Value <> "ARCHIVE: Completed" && Status.Value <> "ARCHIVE: Cancelled by Requestor" && Status.Value <> "ARCHIVE: Cancelled by DMI team" && Status.Value <> "ARCHIVE: Splitted" && Archive = "False") && ('Created By'.Email = User().Email || User().Email in ShowColumns( InformedPeople, "Email" )) ) ), If( isDMIUser, Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && Archive = "False" ), Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && Archive = "False" && ('Created By'.Email = User().Email || User().Email in ShowColumns( InformedPeople, "Email" )) ) ) ), "Title", If( varRequestSortDirection = SortOrder.Ascending, SortOrder.Ascending, SortOrder.Descending ) ), "Created", SortByColumns( If( ToggleHideArchieve.Value, If( isDMIUser, Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && (Status.Value <> "ARCHIVE: Completed" && Status.Value <> "ARCHIVE: Cancelled by Requestor" && Status.Value <> "ARCHIVE: Cancelled by DMI team" && Status.Value <> "ARCHIVE: Splitted" && Archive = "False") ), Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && (Status.Value <> "ARCHIVE: Completed" && Status.Value <> "ARCHIVE: Cancelled by Requestor" && Status.Value <> "ARCHIVE: Cancelled by DMI team" && Status.Value <> "ARCHIVE: Splitted" && Archive = "False") && ('Created By'.Email = User().Email || User().Email in ShowColumns( InformedPeople, "Email" )) ) ), If( isDMIUser, Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && Archive = "False" ), Filter( Requests, txtFDMIID_1.Text in DMIID && (Status.Value = cmbFStatus_1.Selected.Value || cmbFStatus_1.Selected.Value = Blank()) && (Priority.Value = cmbFPriority_1.Selected.Value || cmbFPriority_1.Selected.Value = Blank()) && Archive = "False" && ('Created By'.Email = User().Email || User().Email in ShowColumns( InformedPeople, "Email" )) ) ) ), "DMIID", If( varRequestSortDirection = SortOrder.Ascending, SortOrder.Ascending, SortOrder.Descending ) ) )

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard