ClearCollect not pulling down all columns.

(0) Share

Report

Posted on by rprahalad

377

Hello All,

I have a table in DataVerse named Events. I have built a canvas app and am trying to work with that table. I just do a simple call like this in my Canvas app.

ClearCollect(colEvents, Events);

When I go and View the collection, I can only see one column pulled in to the collection, even though the Events table has around 15 columns.

Is there a setting in my Dataverse table that I should flip on, so that I can pull all the columns into my canvas app? I have ensured that 'Searchable' flag is on on most columns. The only column that it is pulling up is a Choice column.

Is it some form of a permission issue? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@rprahalad

In general, creating a local collection of your datasource is going to be a performance drag on your app. But, that aside, please consider turning off the 'Explicit Column Selection' feature in your app settings.

I hope this is helpful for you.

Was this reply helpful? Yes No
rprahalad 377 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response, @RandyHayes ! I turned it off, logged out, logged back in, refreshed the Events table again and I still see the same behavior: Only one column picked up by the collection.

Was this reply helpful? Yes No
rprahalad 377 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes , before I click on the button and I go see the columns, its all there but once I fire the ClearCollect call, all other columns disappear from the collection and ONLY the choice column shows up.

Does it have to do with the fact that that table has User Or Team permission in DataVerse and not Org level permission? That is strange too because I was the Creator of the table to begin with and it should have recognized that fact. Let me change the table name to hit an Org Level permission table and see if all columns shows up then..

Was this reply helpful? Yes No
rprahalad 377 on at

Like (0)

Report
Copy link

Link copied!

That was not it either. I pulled in another User Or Team level table and I can see all columns. ONLY this table seems to have an issue and it maybe because it has more data.

Plus, I had imported the data over on the events table from the Dynamics old interface "Import" feature. Those are the only 2 differences between the Events table and other tables. One of the 2 is not making it work. I was expecting it to fetch the first 500 rows with all columns. This is a bug I feel.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@rprahalad

Have you attempted to create a new test app and then connect to the datasource?

Place a Gallery in the test app and set its Items to the dataverse table.

Was this reply helpful? Yes No
rprahalad 377 on at

Like (2)

Report
Copy link

Link copied!

@RandyHayes , It does show up all the columns in the Gallery BUT on that debug panel where we view the collection, it just shows one column like I mentioned. Its weird BUT when I use ClearCollect + ShowColumns, it shows up everywhere.

But I will still mark your reply as 'Acceped Solution' because frankly I was stuck wondering why its not pulling the data and If I had to recreate my tables all over again. It didn't strike me to actually put a gallery and point it to that collection.

Plus, I had no idea there was this hidden toggle else where that allows me to explicitly pull in columns vs not and so thanks for mentioning that.

It is frustrating these little things BUT glad I can move on. Thanks again @RandyHayes !!

Was this reply helpful? Yes No
MartinLingstuyl 12 on at

Like (0)

Report
Copy link

Link copied!

This helped in my case, thanks!

Was this reply helpful? Yes No