Date Formulas

(0) Share

Report

Posted on by MrAutomate

206

HI,

Today is 4/11/2022...

Have a question about some code I have. Why does line 1 produce records from last Friday, 4/1/2022,

and line 2 obviously produces today records as expected?

LINE 1 : //Filter(dvDailyTeamss, WorkDate=First(Sort(Distinct(dvDailyTeamss,WorkDate),Result,Descending)).Result)
Line 2: //Filter(dvDailyTeamss, WorkDate=Today())

I would have thought if I am sorting Line 1 (descending) , and using the FIRST function, it would pick up the latest date, which is today, 4/11/2022?

See attached PNG file for dataverse table columns being referenced.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

MrAutomate 206 on at

Like
a
(0)

Report
Copy link

Link copied!

apologies for the typo:
Why does line 1 produce records from last Friday, 4/8/2022,

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@MrAutomate

Most likely, this is because Distinct isn't delegable, so line 1 picks up the latest date based on the first batch of 500 records (or whatever you've set the "data row limit" to be in the settings)

I imagine you can remove the call to Distinct, and it should logically return the intended results.

Was this reply helpful? Yes No
MrAutomate 206 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, Tim, that was it.

I changed from 500 to 2000 and todays rows showed up. Changing from the SP list to the dv Table today, I suspected it was something not so obvious. I may throw a view on that dv table to get around the delegation issue. Thanks again

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

You're welcome @MrAutomate - glad that solved the problem!

Was this reply helpful? Yes No