Delegation Warning

[Jayant2]

Hi All,

i am trying to create a Attendance system and i have a check out button to store the checkout time of employee. But i am facing a delegation warning in the below code. can anyone please help me in that.

[rsaikrishna]

@Jayant2 

Check @RezaDorrani video on delegation on Date Values

https://www.youtube.com/watch?v=yXvDj60-3YQ&ab_channel=RezaDorrani

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[Jayant2]

@rsaikrishna in that video he says that date values are now delegable but in my code with lookup date values are not delegable. how do I get around that?

[gabibalaban]

Hi @Jayant2 

From my undestanding you want to select the today's record. 

If so, here is my solution to avoid delegation warning :

LookUp(yourShareppointList,Created>Today(),Created<=DateAdd(Today(),1,Days)) 

Of course, this formula need to be adapt to your needs with other condition, I only put a way to avoid delegation warning on Created condition.

Hope it helps !

[Jayant2]

@gabibalaban my condition basically wants to check if the logged in user has created a record today. now how do I get that through lookup condition without delegation warning?

\below is the code that I am currently using with delegation warning.
 !IsBlank(LookUp('Attendance System','Employee Email'=useremail && Text(Created,"[$-en-US]mm/dd/yyyy")=Text(Now(),"[$-en-US]mm/dd/yyyy")))

[gabibalaban · Accepted solution]

@Jayant2 

 !IsBlank(LookUp('Attendance System','Employee Email'=useremail && Created>Today() && Created<=DateAdd(Today(),1,Days)