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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,630)