Unanswered

Dataverse Collect with filters gives empty table/collection

(0) Share

Report

Posted on by kaos

With a SP list all works as expected, but when filtering a Dataverse table in a Collection, the collection remains empty except for the filtered column, but all the columns attributes is populated but without records.

Whats wrong ?

This is my formula:

ClearCollect(colLegs;Filter(Legs;Distance>1700))

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @kaos,

Your code seems to be fine.

is Legs a table from Dataverse or collection?

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Verified answer

kaos 17 on at

Like (2)

Report

Legs is a table from Dataverse. Seams like the problem was due to the "Explicit column selection" preview feature.
Looks okey no. I believe SP list is not supported with this feature, thereby not a problem with that source.

This helped me out:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Collection-not-collecting-all-columns/td-p/418763

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

Like (0)

Report

I was facing the same Issue. With a SharePoint List it worked, when switching to Dataverse Table with the same Formula i get an empty Table. After disabling the Option Explicit column selection it worked.

Was this reply helpful? Yes No