data is not populating when filtering in powerapps using CDS

(0) Share

Report

Posted on by Hasini

Hello all,

I am filtering the CDS based on the one condition, and i am collecting the records in a collection

where the collection contains data only for the primary field .

ClearCollect(
colAttachmentReq,
SortByColumns(Filter(
User Uploads,
'Workitem ID'.'WorkItem ID' = galWorkItemDetails.Selected.'WorkItem ID'),"createdon",Descending))

this is happening even when i try to save the same filter condition in a local or global variable

Please help me to resolve this issue

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,373 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Hasini ,
I am not sure what you mean by a Global or Local Variable when the code is making a Collection, but for the purposes of elimination only, do you get a full data set with the below code?
ClearCollect( colAttachmentReq, Filter( 'FAT_T_User Uploads', 'Workitem ID'.'WorkItem ID' = galWorkItemDetails.Selected.'WorkItem ID' ) )

Was this reply helpful? Yes No
Hasini 46 on at

Like
a
(0)

Report
Copy link

Link copied!

do you get a full data set with the below code?
---------------------------------------------------------
am getting the no of records which satifies the given condition but the data is populated only for the primary field , for all the remaining fields data is empty

Was this reply helpful? Yes No
WarrenBelz 156,373 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Hasini
Only one thing I can see - which does not necessarily explain it, but
'Workitem ID'.'WorkItem ID'
naming a field the same as the parent list is not a good idea

Was this reply helpful? Yes No
WarrenBelz 156,373 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hasini ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No