Requirement: Collection more than limit in Canvas app
Create canvas app Add button to the screen and gallery to display the collections from sharepoint. Here Sharepoint list “Large Data” where the list had 7000+ items, On power apps for creating collection, add button. Here the colLargeData1,2,3,4 are the names of the collection where it has 7000+ items in it, Each collection takes 2000 items, so using concurrent to merge and display all in one collection named as colLarge.
colLarge(button)-On OnSelect Property:
Concurrent(ClearCollect(colLargeData1,Sort('Large data',ID,SortOrder.Ascending)),ClearCollect(colLargeData2,Sort('Large data',ID,SortOrder.Descending)),ClearCollect(colLargeData3,Sort('Large data',ID,SortOrder.Ascending)),ClearCollect(colLargeData4,Sort('Large data',ID,SortOrder.Descending)));
ClearCollect(colLarge,colLargeData1,Filter(colLargeData2,Not(ID in colLargeData1.ID)),colLargeData3,Filter(colLargeData4,Not(ID in colLargeData3.ID)));
Gallery On Items Property: Search(collectionname, Textinput.Text, "Columnname")


