Answered

Delegation warning on date compare

(0) Share

Report

Posted on by leeboygp

HI Experts,

I have been battling with this date issue for far to long now and need some assistance. I am trying to compare two dates (date in SQL table with

Istoday()

and depending on the result, get that items ID. The code I currently have now works, but is giving me a delegation warning.

Set(SessionID,LookUp(tblTimeSheet_Data,ANumber = varCurrentUser && IsToday(StartDayDate),Id));

The delegation warning comes from the

istoday

part of the formula. I have tried other ways, but I am just not getting it right.

I also tried the below formula, but this one is not returning anything.

Set(Comparedate,DateAdd( Today(),1,TimeUnit.Days));
Set(SessionID,LookUp(tblTimeSheet_Data,ANumber = varCurrentUser && StartDay < Comparedate,Id));

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

leeboygp 15 on at

Like (0)

Report
Copy link

Link copied!

What else can I use instead of isToday()?

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @leeboygp

Try this:
Set(SessionID, With( { _tblTimeSheet_Data: LookUp( tblTimeSheet_Data, ANumber = varCurrentUser ) }, Filter( _tblTimeSheet_Data, IsToday(StartDayDate) ), Id ) );

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
leeboygp 15 on at

Like (0)

Report
Copy link

Link copied!

Hi @SpongYe

Its not working.

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (0)

Report
Copy link

Link copied!
You could try using this?
StartDayDate = Today()

Was this reply helpful? Yes No
leeboygp 15 on at

Like (0)

Report
Copy link

Link copied!

Hi @Chris-D ,

I tried this, but got nothing back. No errors, but it brings no results. the date format on SQL is 2023-09-05

Was this reply helpful? Yes No
leeboygp 15 on at

Like (0)

Report
Copy link

Link copied!

date format on SQL

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
HI @leeboygp

This should work:
Set(SessionID, With( { _tblTimeSheet_Data: LookUp( tblTimeSheet_Data, ANumber = varCurrentUser ) }, Filter( _tblTimeSheet_Data, IsToday(StartDayDate) ).Id ) );
I forget that the comma has to be a dot before the Id.
If that doesnt work try this:

Set(SessionID, With( { _tblTimeSheet_Data: LookUp( tblTimeSheet_Data, ANumber = varCurrentUser ) }, LookUp( _tblTimeSheet_Data, IsToday(StartDayDate), Id ) ) );

Was this reply helpful? Yes No
leeboygp 15 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, I'm getting an error with both formulas.

not sure whats next 😞

Was this reply helpful? Yes No
Verified answer

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @leeboygp

We are using the IsToday() function the wrong way. Thats why its giving a error.
A filter or Lookup need to match a record and IsToday() returns a Boolean.

This should work:
Set(SessionID, With( { _tblTimeSheet_Data: LookUp( tblTimeSheet_Data, ANumber = varCurrentUser ) }, Filter( _tblTimeSheet_Data, Text(StartDayDate) = Text(Today(), "yyyy-mm-dd") ).Id ) );

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
leeboygp 15 on at

Like (0)

Report
Copy link

Link copied!

This code still gives me errors. However, I have managed to resolve my issue by using sort instead. Like below:

Set(SessionID,LookUp(Sort(tblTimeSheet_Data,Id,SortOrder.Descending),ANumber = varCurrentUser,Id));

Thank you so much for your assistance, i really appreciate it.

Was this reply helpful? Yes No