Answered

ClearCollect on SharePoint data sources - columns are populated but rows are empty

(0) Share

Report

Posted on by Ryan_B

446

So I have an app with 15 SharePoint data source connections. I know the recommended limit is no more than 30 data source connections, but there was no specification for any specific types. With that in mind, here's my problem:

I connected all 15 of my sources and attempted to do a simple ClearCollect on the 1st one. The columns are brought in properly but there are no rows of data. When I then add a 16th source from a different SharePoint site, I can perform the ClearCollect on this without issue. I then remove the 16th and 1st source, add the 1st source back in, perform the ClearCollect again, and it doesn't work.

I had an initial "prototype" of the app where I am able to use the exact same data source and ClearCollect it properly, although it doesn't have the other 14 sources as well. But if that were the case, then adding the 16th one shouldn't have worked either.

I'm at my wits end trying to figure this out. I've tried different methods to get it to work, such as turning off "Explicit column selection," using Refresh-Clear-Collect formulas in order, adding in ShowColumns to the ClearCollect formula, restarting my browser, refreshing data sources, removing all data sources and re-adding them, running the app to see if the problem persisted outside of edit mode, etc.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

BenMunk 114 on at

Like (0)

Report

Long shot...
Are you just adding the collection, then going to View Collections?

Or are you actually using the collection? (eg. inserting a data table and adding the collection).

I have seen weird behaviour when a collection is not actually in use.

BTW - I have 40 data sources (all Sharepoint Lists) running in my app. No problems so far.

Was this reply helpful? Yes No
Ryan_B 446 on at

Like (0)

Report
@BenMunk

I'm not entirely sure I follow. I add all my data sources and do:
ClearCollect(DocumentsFolders, Documents)

I then check DocumentsFolders by highlighting it and going to View > Collections and it's empty. I'm also using this collection in a gallery, which is also blank. But if I literally remove the data source called Documents, add another data source from a different SharePoint site with the same name, the data appears.

Was this reply helpful? Yes No
Verified answer

Ryan_B 446 on at

Like (0)

Report

So after clearing my head and starting off fresh this morning, I discovered why everything is empty. The original site I was basing all this on has a different structure than the others. It actually has all of its folders contained in the Documents section of the site, whereas for the ones that aren't working they are all separate document libraries...

Such a silly oversight on my part.

Was this reply helpful? Yes No