Deny add items after specific hour

(0) Share

Report

Posted on by ciprianpopovici

159

Hello

We have an app for adding food orders. Users add every day food orders. Orders must be taken everyday by 10 am . After this hour they cannot order and must receive an message when they try to add a new item.

It's that possible in PowerApps?

Thank you

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

On your submit code write this:

If(Hour(Now())>10,Notify("Order can not be placed after 10:00 A.M.",NotificationType.Error),"Your Submit Code")

This code Hour(Now()) gives hour as number in 24 hour format. for eg. if it's 3 in the afternoon output will be 15. So, click on the submit button will first check if it's past 10 AM. if it is true it will display above message in the error form. If it is false it will add item
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @ciprianpopovici,

Have you solved your problem?

Do you want to deny order after 10 am everyday?

Could you please if there is need to re-trigger the order after 24:00?

I agree with @zmansuri that you could use the Hour() function to get the hour number with 24 hour format. However, if you just want to deny order from 10:00 to 24:00 and re-order by 10:00 next day, I think you should add something different.

If( Hour(Now()) > 10 && Hour(Now()) <= 24, Notify( "No order after 10:00 am!", Error ), Patch( Product, {Title: "NewItem"} )// Here replace with your Patch() formula )

Hope this could help you at some degree.
ciprianpopovici 159 on at

Like
a
(0)

Report
Copy link

Link copied!

hello, Sorry for my late response . Thank you for the support. I have little modification on the formula , I try to find why not working, but no luck. So i need to block adding items if the hours is later than 10.30 AM. I have to use minutes also. I use this formula , but all the time a have return false, even if hour it's 10.20 or 10.15... I adapt the formula in Excel and in Excel it's working. Can you give a clue?

And(And(Hour(Now())>=10,Hour(Now()<11)),Minute(Now()<30))
Verified answer

ciprianpopovici 159 on at

Like
a
(0)

Report
Copy link

Link copied!

I think i managed to find a solution. The first formula was wrong.
I add a new formula that seems to work in tests

If(Hour(Now())<10,"OK hour",If(And(Hour(Now())=10,Minute(Now())<30),"OK Minute","NO"))