Good day to all!
I have a sharepoint list with around 3000 rows of employee data which I need to fetch for my application. Since the number of rows are guaranteed to not exceed 4000 rows, I would like to combine 2 collections into one and fetch data from there (using this method https://www.practicalpowerapps.com/delegation/power-apps-delegation-sharepoint/#Bigger). While my code does run, it is only able to fetch 2000 rows.
With(
{
asc: Sort(
'List of employees',
EmployeeID
),
desc: Sort(
'List of employees',
EmployeeID,
SortOrder.Descending
)
},
ClearCollect(
employeeFullDetails,
asc,
Filter(
desc,
(!EmployeeID in asc.EmployeeID)
)
)
)
Any help would be much appreciated.