Share
Report
2Looking 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 ) ) )
All responses (
Answers (
