cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Craig-G
Level: Powered On

Clearcollect + Filter + CDS

Hi All - I'm having a strange problem getting my CDS records into collections, not all the column data is been pulled through and stored.

 

E.g.

 

 

ClearCollect(ColTripRecords,
    Filter(
        Trips,
        Requestor = VarUserDetails.Email And Date >= OTFIlterStartDate_3.SelectedDate And Date <= OTFilterEndDate_3.SelectedDate And ('Record Status' = [@Status].Pending Or 'Record Status' = [@Status].Approved Or 'Record Status' = [@Status].Rejected Or 'Record Status' = [@Status].'Sent for Payment' Or 'Record Status' = [@Status].'Sent to Payroll')
    )
)

 

 

I end up with the requestor field, ID field and very little else. Any suggestions?

 

Annotation 2020-01-20 083315.pngCDSData.png

1 ACCEPTED SOLUTION

Accepted Solutions
Craig-G
Level: Powered On

Re: Clearcollect + Filter + CDS

I figured this one out, for anyone having similar problems, there is a setting called Explicit Column Selection which tries to reduce the memory consumption by only fetching columns used in the app.

 

This can be turned off by going to File --> Settings --> "Explicit column selection" to off.

Close the app reopen and all your column data will be returned.

View solution in original post

1 REPLY 1
Craig-G
Level: Powered On

Re: Clearcollect + Filter + CDS

I figured this one out, for anyone having similar problems, there is a setting called Explicit Column Selection which tries to reduce the memory consumption by only fetching columns used in the app.

 

This can be turned off by going to File --> Settings --> "Explicit column selection" to off.

Close the app reopen and all your column data will be returned.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Users online (4,707)