cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jayant2
Helper V
Helper V

Delegation Warning

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.

Jayant2_0-1604582411124.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Jayant2 

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

View solution in original post

5 REPLIES 5
rsaikrishna
Dual Super User
Dual Super User

@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 SolutionMarking 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.

@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?

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 !

@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")))

@Jayant2 

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

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (70,209)