web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps DateDiff delegation in...

Power Apps

Answered

DateDiff delegation in CDS

(0) Share

Report

Report

Posted on by CNT

10,921 Super User 2024 Season 1

Hello

The doc (https://docs.microsoft.com/en-us/connectors/commondataservice/) says, that DateTime delegable in CDS. But when I use the DateDiff function to Filter a CDS Entity I am getting a warning. Any idea why? Is it just a general delegation warning or is it that DateDiff is non-delegable on CDS. Any help would be much appreciated.

Thanks.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CNT :
Firstly,let me explain why you encounted a delegation warning.
The point is datediff function is not delegable for CDS.
Secondly,I suggest you to use delegateable functions instead of Datediff.
for example:

Filter(Accounts,DateDiff('Created On',Date(2020,5,29),Days)>5)

is not delegable,but

Filter(Accounts,'Created On'<DateAdd(Date(2020,5,29),5,Days))

is delegalbe.(Because DateAdd(Date(2020,5,29),5,Days) is a constant, it does not involve delegation.)
Best Regards,
Bof
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft Thanks. It Works

Join the conversation