Check if user checked in for today

(0) Share

Report

Posted on by julijazas

820

I have an app where users must check in on tablet. Users scan NFC tag and their data is returned to some textinputs.

What i want to do is to check if a user today has already checked in and disable the button. I have written a formula but it gives delegation warning that i don't want to keep. Can you help with this formula? MY datasource is dataverse. Action field is a Choice.

I have delegation warning on IsToday part and on && part.

If(LookUp(Filter(Entrances,'Employee code'.'Darbuotojo kodas'=inpEmployeeNumber.Text),
IsToday(Date) && Action=[@Action].IN,true),
DisplayMode.Disabled,DisplayMode.Edit)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

If(IsBlank(LookUp(YourListName, EmployeeCode = EMployeeNumber.Text)), DispalyMode.Edit, DisplayMode.Disabled)

This will look for a row where EmployeeCode = the text field. If it finds one it will return the object/row and the IsBlank function will return false which will make the display mode be in disabled mode. If the row/object returned is Blank() meaning no entry was found then it will result in the IsBlank being true and therefor be in edit mode.

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmollet
But i also need to check this against today date and also an action if he Checked IN. Your formula will just search for EmployeeCode nomatter of Date. I need to check if user checked in today

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

So then use the And operator to string together your logic. Easy fix!
If(IsBlank(LookUp(YourListName, EmployeeCode = EMployeeNumber.Text And **check date here** And **check in/out status here**)), DispalyMode.Edit, DisplayMode.Disabled)

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmollet
With your formula provided i get same delegation warning problem on IsToday(date) part

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

can you post the code you are using?

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmollet
Hi
This is the code i am trying according your example:
If(IsBlank(LookUp(Entrances,'Employee code'.'Darbuotojo kodas'=inpEmployeeNumber.Text And IsToday(Date) And Action=[@Action].IN)),DisplayMode.Edit,DisplayMode.Disabled)

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh your using the IsToday function which cannot be delegated if I remember correctly. This will have to be changed. Cant you use something like:
First(Approvals).StartTime = Date(Year(Now()), Month(Now()), Day(Now()))
Instead of first just use the row from your data source. This is comparing the first rows start time to the current day (can use Today() as well and might be easier that way) and will return a boolean value like you need.

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmollet
I try something liek you suggested but anyway i get warning

Was this reply helpful? Yes No