Collection from Dataverse Table Not Showing All Data

(1) Share

Report

Posted on by NoobPower

I am new to using Dataverse with teams as I have used SharePoint before.

When I create a collection from a Dataverse table I am having a couple of issues, and this is for all tables.

If you see the below code this works fine. It brings in all 44 records with no problems at all.

ClearCollect(coll_Districts, ShowColumns(Districts, 'District Name', 'District Short Name'));

The main issue is when I try to bring in more than 2 columns of data. If I use the below code, both the District Name and District Short Name columns go blank and the Division Name is all that has data.

ClearCollect(coll_Districts, ShowColumns(Districts, 'District Name', 'District Short Name','Division Name'));

These are all text fields and the same thing happens if I just do this.

ClearCollect(coll_Districts,'Districts');

Only the Division Name shows data.

All responses (2)

Answers (0)

ivan_apps 2,187 Super User 2025 Season 1 on at

Like (0)

Report

Re: Collection from Dataverse Table Not Showing All Data

Do they happen to be formula columns that resolve to text fields? Or calculated columns?

i can only think that perhaps its not calculating correctly or you may need to remove and re-add your data source
Giraldoj 561 Super User 2025 Season 1 on at

Like (0)

Report
Re: Collection from Dataverse Table Not Showing All Data

Hi @NoobPower

your code looks correct, so lets follow the next steps to find out where the problem is.

First, try retrieving all columns to see if any specific column is causing the issue: Check the collection coll_Districts to see if all columns have data.

ClearCollect(coll_Districts, Districts);

Retrieve Specific Columns: Then, retrieve the specific columns one by one to identify the problematic column.
Ensure Data Types are Text: Verify that the data types for 'District Name', 'District Short Name', and 'Division Name' are text fields.
If everything looks correct and your clearcollect actions is still not retrieving all your data, try one of these workarounds.

use a combination of Filter and Collect to manually build your collection.

ClearCollect( coll_Districts, AddColumns( Districts, "DistrictName", 'District Name', "DistrictShortName", 'District Short Name', "DivisionName", 'Division Name' ) );

Fetching Columns Incrementally:

ClearCollect(coll_Districts, ShowColumns(Districts, 'District Name', 'District Short Name')); ClearCollect(coll_Districts, ShowColumns(Districts, 'District Name', 'Division Name')); ClearCollect(coll_Districts, ShowColumns(Districts, 'District Short Name', 'Division Name'));

If my response resolved your issue, please feel free to mark it as the solution by clicking "Accept as solution." This helps others find the answer more easily. If you found the content helpful in any other way, a "Thumbs Up" would be greatly appreciated. Thank you!