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?
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.
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.
This is my workaround for my case: SQL Table, need a filter by date, and data entry via PowerApps too.
Filter('[dbo].[ProductReleases]', ReleaseDateText = Text(ReleaseDatePicker_ListForm.SelectedDate,"[$-en-US]yyyymmdd")
My two cents!
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021