Power Platform Community Forum Thread Details

I have a gallery that is connected to sharepoint list, the gallery have the following formula for the items:-

Switch(DashBoarSortBy.Selected.Value,



"Network",
SortByColumns(Filter('Work Orders',
('Work Order Status'.Value = "Assigned" Or 'Work Order Status'.Value="New") And
((Created >= colSelectedDateCreated And Created <= colSelectedDateCreated2 ) Or IsBlank(colSelectedDateCreated)) And
(('Start Date.' >= colSelectedDateStartDate And 'Start Date.' <= colSelectedDateStartDate2 ) Or IsBlank(colSelectedDateStartDate)) And
(('End Date.' >= colSelectedDateEndDate And 'End Date.' < colSelectedDateEndDate2 ) Or IsBlank(colSelectedDateEndDate)) And
(Street = colSelectedStreetName Or IsBlank(colSelectedStreetName)) And
(Direction = colSelectedDirectionName Or IsBlank(colSelectedDirectionName)) And
('Location Name' = colSelectedLocationName Or IsBlank(colSelectedLocationName)) And
('Work Order Type'.Value = colSelectedTypeName Or IsBlank(colSelectedTypeName)) And
('Technician Name'.Email = colSelectedTechnicianName Or IsBlank(colSelectedTechnicianName) Or 'Work Order Type'.Value ="Posting"
Or 'Work Order Type'.Value ="UnPosting" Or 'Work Order Type'.Value ="Campaigns Photos" ) And
(Brand = colSelectedBrandName Or IsBlank(colSelectedBrandName)) And
('Work Order Status'.Value = colSelectedTStatusName Or IsBlank(colSelectedTStatusName))
),"NetworkName",SortOrder.Ascending,"SequenceNumber",SortOrder.Ascending),
"Created",
SortByColumns(Filter('Work Orders',
('Work Order Status'.Value = "Assigned" Or 'Work Order Status'.Value="New") And
((Created >= colSelectedDateCreated And Created <= colSelectedDateCreated2 ) Or IsBlank(colSelectedDateCreated)) And
(('Start Date.' >= colSelectedDateStartDate And 'Start Date.' <= colSelectedDateStartDate2 ) Or IsBlank(colSelectedDateStartDate)) And
(('End Date.' >= colSelectedDateEndDate And 'End Date.' < colSelectedDateEndDate2 ) Or IsBlank(colSelectedDateEndDate)) And
(Street = colSelectedStreetName Or IsBlank(colSelectedStreetName)) And
(Direction = colSelectedDirectionName Or IsBlank(colSelectedDirectionName)) And
('Location Name' = colSelectedLocationName Or IsBlank(colSelectedLocationName)) And
('Work Order Type'.Value = colSelectedTypeName Or IsBlank(colSelectedTypeName)) And
('Technician Name'.Email = colSelectedTechnicianName Or IsBlank(colSelectedTechnicianName) Or 'Work Order Type'.Value ="Posting"
Or 'Work Order Type'.Value ="UnPosting" Or 'Work Order Type'.Value ="Campaigns Photos" ) And
(Brand = colSelectedBrandName Or IsBlank(colSelectedBrandName)) And
('Work Order Status'.Value = colSelectedTStatusName Or IsBlank(colSelectedTStatusName))
),"Created",SortOrder.Descending),
"SequenceNumber",
SortByColumns(Filter('Work Orders',
('Work Order Status'.Value = "Assigned" Or 'Work Order Status'.Value="New") And
((Created >= colSelectedDateCreated And Created <= colSelectedDateCreated2 ) Or IsBlank(colSelectedDateCreated)) And
(('Start Date.' >= colSelectedDateStartDate And 'Start Date.' <= colSelectedDateStartDate2 ) Or IsBlank(colSelectedDateStartDate)) And
(('End Date.' >= colSelectedDateEndDate And 'End Date.' < colSelectedDateEndDate2 ) Or IsBlank(colSelectedDateEndDate)) And
(Street = colSelectedStreetName Or IsBlank(colSelectedStreetName)) And
(Direction = colSelectedDirectionName Or IsBlank(colSelectedDirectionName)) And
('Location Name' = colSelectedLocationName Or IsBlank(colSelectedLocationName)) And
('Work Order Type'.Value = colSelectedTypeName Or IsBlank(colSelectedTypeName)) And
('Technician Name'.Email = colSelectedTechnicianName Or IsBlank(colSelectedTechnicianName) Or 'Work Order Type'.Value ="Posting"
Or 'Work Order Type'.Value ="UnPosting" Or 'Work Order Type'.Value ="Campaigns Photos" ) And
(Brand = colSelectedBrandName Or IsBlank(colSelectedBrandName)) And
('Work Order Status'.Value = colSelectedTStatusName Or IsBlank(colSelectedTStatusName))
),"SequenceNumber",SortOrder.Ascending,"NetworkName",SortOrder.Ascending))

now the sort will only work if i select "Created", while SequenceNumber or "NetworkName" will not show any data.. this problem start to happen when the "Work Order" list exceeds 5,000 items. although the Created + Sequenceumber + Networkame are added as indexes inside the list.. now if i remove the second sort field this will work for all the options.. so why i can not do multiple sorts for the gallery items, even if those fields are been indxed?

here are the indexes:-

Thanks

Categories:

Building Power Apps

That is not good practice to have more than 5000 items to scroll. Any single call in PowerApps cannot exceed more than 2000 records to begin with. If you are going to be doing large datasets of data you will want to look into fluentUI datalist / grid custom controls and utilize paging.

But back to the original question, the only work around that might help in this case utilizing built in 100 record paging gallery controls SP might require a double index for that if only one column is working, in SharePoint when you create index you can pick a 2nd column on an index, not sure if you can pick those two columns, but that might the only option, outside of that you might be hitting delegation / datasource constraints.