Suggestions for SharePoint delegation issues?

Looking for feedback on a Power App that will connect to a SharePoint list that could grow above 10,000 records.

I found out the hard way that a ClearCollect combined with DropColumns was a no-go for a big list in SharePoint. The hard way, naturally, once it was already in production. "Why was this working and now it's not??!!" (sigh). 🤦🏻‍♂️

I changed the code from this:

ClearCollect(

colMyLinks,

Sort(

Filter(

DropColumns('My Quick Links',

"{VersionNumber}",

"Modified"),

'Created By'.Email=gblUserProfile.mail),

SOrder

)

To this:

ClearCollect(

colMyLinks,

Sort(

Filter('My Quick Links', 'Created By'.Email=gblUserProfile.mail),

SOrder

)

);

ClearCollect(

colMyLinks,

DropColumns(colMyLinks,

"{VersionNumber}",

"Modified"

)

I know, I know - converting to dataverse would likely make for a better solution.

But will I hit any issues with the new approach? It seems to be working. The collection getting pulled in is only about 10-20 rows from the SharePoint list, so the app itself doesn't need to work with very much data. I figured the collection approach would be efficient. But obviously it comes with issues of it's own.

5 comments