cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kaos
Frequent Visitor

Dataverse Collect with filters gives empty table/collection

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

1 ACCEPTED SOLUTION

Accepted Solutions
kaos
Frequent Visitor

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

View solution in original post

2 REPLIES 2
rampprakash
Super User
Super User

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
Frequent Visitor

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

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,363)