Checked in at least 1 hour before scheduled time

(0) Share

Report

Posted on by kinghnvn

Hi all,

I have a SharePoint list below

Could you please help to set up CheckIn button as below?

If start date = today and start time < today time - 1 hour -> DisplayMode is Edit

else -> DisplayMode is Disabled

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

WarrenBelz 153,427 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
HI @kinghnvn ,

This should be the structure.

If( Text('Checkout From',"mm/dd/yyyy") = Text(Today(),"mm/dd/yyyy") && DateDiff( 'Checkout From' Now(), Hours ) > 1, DisplayMode.Edit, DisplayMode.Disabled )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

seems the code doesn't work.
ThisItem.'Check Out From' -> it show full time (date & hour). How can split it?

Was this reply helpful? Yes No
WarrenBelz 153,427 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@kinghnvn

I am assuming that is a date and time field - if so, this makes it a date (as posted)

Text('Checkout From',"mm/dd/yyyy")

then

Text('Checkout From',"mm/dd/yyyy")

converts the current date to the same format and they should compare

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

it works if booked date is different from current date (3rd line - screenshot) but if it's the same day and different time (hours / minutes), it won't work. Please advise. Thanks.

If(
Text(
ThisItem.'Check Out From',
"mm/dd/yyyy"
) = Text(
Today(),
"mm/dd/yyyy"
) && DateDiff(
ThisItem.'Check Out From',
Now(),
Hours
) > 1,
DisplayMode.Edit,
DisplayMode.Disabled
)

Was this reply helpful? Yes No
WarrenBelz 153,427 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@kinghnvn ,

You need to add the date comparison I posted

Text('Checkout From',"mm/dd/yyyy") = Text(Today(),"mm/dd/yyyy")

see a test I did below

Then within an hour

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

thanks @WarrenBelz ,
How to hide the check-in button if more than 15 minutes?

Was this reply helpful? Yes No
WarrenBelz 153,427 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@kinghnvn ,

Different question, but you would need a timer control started at screen OnVisible then set a Variable at OnTimerEnd

UpdateContext({varHide:true})

then your button DisplayMode

If( !varHide && Text('Checkout From',"mm/dd/yyyy") = Text(Today(),"mm/dd/yyyy") && DateDiff( 'Checkout From' Now(), Hours ) > 1, DisplayMode.Edit, DisplayMode.Disabled )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

if I set Visible is UpdateContext({varHide:true}), all CheckIn button hidden and cannot see it.

Was this reply helpful? Yes No
WarrenBelz 153,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@kinghnvn ,

That code is for OnTimerEnd of the timer control, not the Visible for the button. Here is a document on Timer operation.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No