How to get collections more then limit in power apps

Loading

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")

Leave a Reply

Your email address will not be published. Required fields are marked *