Unanswered

is the Today() function not delegable?

(0) Share

Report

Posted on by CharlieK Microsoft Employee

Hi,

I've written a Lookup which searches a SQL Azure db, filters by key then sorts using SortByColumns, of which I then use date <= Today() to return the top record. This works fine however I am getting the blue squiggle under <= Today() so assuming this will break after 500 records, is there any way around this?

"Last Date: " & LookUp((SortByColumns(Filter('[dbo].[SQLDB]'; abcID = ThisItem.PID); "abcDate"; Descending)); abcDate <= Today(); abcDate)

Cheers

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

carlosag Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Could you try capturing the result of Today() in a context variable and use that instead?
For example, in the OnVisible of the screen add
UpdateContext({today: Today() })

And then use today in your expression above like abcDate<today
CharlieK Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Carlos,

Tried this and the context captures the date (can display using a Text box) however I get an error saying invalid mashup, cannot apply operator < to types DateTimeZone and Date. abcDate is a date column in SQL Azure.

Cheers
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Any insight on how to delegate Today()? I also tried passingas a contextual variable with Date() or DateValue() to no avail.