Unanswered

Collection not loading with all fields of records from CDS entity

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Unable to load all records from CDS entity into collection, and is getting empty records inside the fields in Collection, so that the functionality is getting difficult to achieve.

Also the LookUp Columns i not saving proper records into CDS while using in ForAll Loop

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous :
Could you tell me:
Whether the current problem is the loss of records or the loss of the value of some fields?
How many records are in your data source?
I assum the current problem is the loss of records.I guess the problem is caused by a delegation problem.
The point is "Collect" and "ForAll" are all not delegable.
If so,there are two situations:
Case1:The Number of records is greater than 500 but less than 2000
set the value of Data row limit for non-delegable queries to 2000
Case2:The Number of records is greater than 2000.
The data source can be segmented and saved in batches to a collection.I assume "Kind" is a text type field in the your CDS entity.
Please try:

Clear(TheCollection) Collect(TheCollection,Filter(YourEntity,Kind="Kind1")); Collect(TheCollection,Filter(YourEntity,Kind="Kind2")); ……

Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Bof, @v-bofeng-msft,

The Issue is with loss of values in fields while fetching into collection.
I am taking my records into one collection from CDS entity and is not having any delegation error in the code.

NB: My CDS Entity has records less than 500.
Eg: ClearCollect(CollectionName, myCDSentity);

This collection loads with the fields (uniqueIdentifier and the primary field), and the remaining fields are empty (no values are loaded).

If a Filter is applied while fetching into collection, the field name given inside filter will be taken and remaining fields will be empty in collection.
I have raised a Support Ticket in Microsoft be mentioning the same issue, and any help from you or Microsoft regarding this will be highly appreciated.

Thank You!

Regards,
Ashish

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous :
Could you try to turn off "Explicit column selection" preview feature and try again?
Best Regards,
Bof

Was this reply helpful? Yes No
Gyllentid 894 on at

Like (0)

Report
Copy link

Link copied!

I am having similar issues. I don't really need to fetch all columns, but I do need certain columns. The ones that doesn't come through is a phone number field, a text field (just the surname). The table doesn't contain many records and I tried to switch off the explicit column selection and reloading the app and it's still not fetching these fields. It's rather content In fetching a few others.

I got ClearCollect(colname, LookUp(Table, Column = This item.ColumnName.ColumnName))

Was this reply helpful? Yes No