cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
csm
Helper I
Helper I

CDS Delegation not working on date field types

Hello all,

 

We have built an app using CDS that contains about 15,000 records for scheduling operations. 

 

These records are presented to the ops team as work orders filtered to due today, however it seems that delegation doesnt work on filtering fields formatted as a date on CDS. 

 

Is it possible to filter records to todays date without breaking delegation? I have tried a number of ways, including using "Today()", writing today's date to a context variable, and even hardcoding todays date, however I always get the warning under "=" that "Part of this Filter formula cannot be evaluated remotely due to service limitations". 

 

The formula I am using is

Filter('Production Work Orders', TargetDate = Today())

Currently I am replicating the entire database to a local collection, however this is no longer an option as the database increases in size.

 

Does anyone have any ideas on how to get delegation working in this situation?

 

Thanks 

7 REPLIES 7
v-yamao-msft
Community Support
Community Support

Hi Csm,

 

I can reproduce this issue by creating an app based on a CDS entity. In the app, add a gallery control and set its Items property to Filter(DataSource,FinalDate=Today()). The date can be filtered by the date, but there is a warning under “=Today()”.

 

The warning message is shown as below:
Suggestion: Part of this Filter formula cannot be evaluated remotely due to service limitations. The local evaluation may produce suboptimal or partial results. If possible, please simplify the formula. For more information, please see the filter function documentation.

 

I also try with other operator such as “in”. I set the Items property of the gallery control as Filter(DataSource,TextBox1.Text in FinalDate). But I get the same result with “=”.

 

Thanks for your feedback. I will report this from my side and involve others to look into this.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

hello Mabel

 

any update on this?

 

thanks 

v-yamao-msft
Community Support
Community Support

Hi Csm,

 

I am not sure if CDS support filtering on date fields, I am still confirming this issue with PGs. I will back once I got the updates.
Thanks for your patience and understanding.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yamao-msft Has this issue being resolved? Last mention of this issue was on 6/22/2016. My entire app depends on date filtering on CDS.

bump

trietho
Regular Visitor

Hello,

 

This is my workaround for my case: SQL Table, need a filter by date, and data entry via PowerApps too.

  • Create an additional TEXT column, e.g: ReleaseDateText
  • On EditForm, make ReleaseDateText card as hidden and its Text properties should be: 
  • Text(ReleaseDatePicker.SelectedDate,"[$-en-US]yyyymmdd")
  • Now, you can filter on Gallery: 
    Filter('[dbo].[ProductReleases]', ReleaseDateText = Text(ReleaseDatePicker_ListForm.SelectedDate,"[$-en-US]yyyymmdd")

 

My two cents!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

Top Solution Authors
Top Kudoed Authors
Users online (79,058)