cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SymmetryLtd
Frequent Visitor

Change times on book a room app to show just 8am to 6pm

Hi

 

I was wondering if someone could help me. I'm using the book a room template to make a booking system. I would like to remove the times when the office when the of is closed. So i just want the drop down to show 8am to 6pm.

 

I did give it ago but ended up breaking the app 😀

 

 

Any help will be very much appreciated!

 

Thanks

 

B

1 REPLY 1
TheRobRush
Impactful Individual
Impactful Individual

Set your dropdown for start/end items to

 

Filter(Times,And(Hour(DateTimeValue(Text))>=8,Hour(DateTimeValue(Text))<=17))
_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,425)