Start a timer in canvas app on button click

(0) Share

Report

Posted on by LostMary

Hi there.

I am new to canvas apps, and have this currently in my OnSelect property for a button.

I need to add to it to start a timer control on the same button click. So I have put the Start property of the timer to a variable called timerStart, and then I tried to add (in the true bit of the If statement), the code of Set(timerStart, true) but a whole host of errors came up. How can I set this variable to true, or otherwise start the timer control on the OnSelect, but only if the If statement = true?

Thanks

 If(
 IsBlank(
 LookUp(
 Drivers, 
 'Driver Email' = User().Email && 
 'Check In Date/Time' >= DateAdd(Today(), -1) &&
 'Check In Date/Time' < DateValue(Today(), "dd/mm/yyyy")
 )
 ),
 Patch(
 Drivers, 
 Defaults(Drivers), 
 {Name: User().FullName}, 
 {'Driver Email': User().Email}, 
 {'Check In Date/Time': Now()}
 ), 
 Notify("You have already checked-in Today. Select "&Char(34)&"Trips"&Char(34)&"from the bottom menu to resume.",NotificationType.Information)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
You can put multiple statements within an If() statement if you separate each with a ;

In addition, let's fix up your Patch() a bit:

If( IsBlank( LookUp( Drivers, 'Driver Email' = User().Email && 'Check In Date/Time' >= DateAdd(Today(), -1) && 'Check In Date/Time' < DateValue(Today(), "dd/mm/yyyy") ) ), Patch( Drivers, Defaults(Drivers), { Name: User().FullName, 'Driver Email': User().Email, 'Check In Date/Time': Now() } ); Set(timerStart, true); , Notify("You have already checked-in Today. Select "&Char(34)&"Trips"&Char(34)&"from the bottom menu to resume.",NotificationType.Information) )

Hope that helps,

Bryan

Was this reply helpful? Yes No
LostMary 42 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for your help. This is great. One other thing, in the same formula...

The column of Check In Date/Time in my Dataverse table of Drivers is of type Date/Time set as Time Zone Independent and appear in Dataverse in dd/MM/yyyy hh:mm:ss.

My formula is meant to Patch them to the table, but only if they don't already exist with today's date (ignoring the time part), but this doesn't seem to work. I, for example, do not have a row with my email address in it, and it is bringing through the false Notify code. Any ideas what I am doing wrong here?

Here is my code:

If( IsBlank( LookUp( Drivers, 'Driver Email' = User().Email && 'Check In Date/Time' >= DateAdd(Today(), -1) && 'Check In Date/Time' < DateValue(Today(), "dd/mm/yyyy") ) ), Patch( Drivers, Defaults(Drivers), { Name: User().FullName, 'Driver Email': User().Email, 'Check In Date/Time': Now() } ); Set(timerStart, true); , Notify("You have already checked-in Today. Select "&Char(34)&"Trips"&Char(34)&"from the bottom menu to resume.",NotificationType.Information) )

Thanks in advance,

LM

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I suspect the logic is going sideways with this condition in the LookUp():

'Check In Date/Time' < DateValue(Today(), "dd/mm/yyyy")

Today() produces a datetime that corresponds to 12:00am on this day. The only values of a datetime that would be less than this are values from yesterday. Consider replacing Today() with Now() and removing the DateValue() function:

'Check In Date/Time' < Now()

This should help capture check ins that have previously happened in the same day

Hope that helps,

Bryan

Was this reply helpful? Yes No
LostMary 42 on at

Like
a
(1)

Report
Copy link

Link copied!

You are a genius. Thanks so much.

Was this reply helpful? Yes No