Dataverse Collect with filters gives empty table/collection

[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))

[rampprakash]

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

[kaos · Accepted solution]

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/4...