Unanswered

Collection not loading with all fields of records from CDS entity

Like (0) Share

Report

Posted on 26 Aug 2020 13:42:18 by Community Power Pla...

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

I have the same question (0)

All responses (4)

Answers (0)

Gyllentid 892 on 04 Feb 2022 at 10:19:25

Like (0)

Report

Re: Collection not loading with all fields of records from CDS entity

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
v-bofeng-msft on 28 Aug 2020 at 01:28:04

Like (0)

Report

Re: Collection not loading with all fields of records from CDS entity

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
Community Power Pla... on 27 Aug 2020 at 14:00:37

Like (0)

Report

Re: Collection not loading with all fields of records from CDS entity

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

Collection Snap.PNG

Total Records - M...

Was this reply helpful? Yes No
v-bofeng-msft on 27 Aug 2020 at 07:34:50

Like (0)

Report
Re: Collection not loading with all fields of records from CDS entity

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