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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Giraldoj 895 Moderator on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No