Answered

Book a room - fixed time-slots

(1) Share

Report

Posted on by Community Power Pla...

Hi guys,

First off, I'm fairly new with using PowerApps so in case this is a dumb question... please bare with me. One of our customers asked me if it's possible to create an app from where the employees can book desks at the office. They would like to use it during this ongoing Covid crisis. I've managed to design the 'Book a room' PowerApp for most of their needs.

I've figured out how to filter which rooms (desks) should be available for bookings. What I can't figure out if the following. In stead of letting the employees choose their own 30 min time-slots I'd like to set it up so that they automatically book desks from 08:00am to 18:00pm. So basicly the employee can only book a desk for a full day.

I suppose I have to set this up under the 'Landingscreen --> ButtonNoMeeting' code but do not know how to do so. I've filtered out the 'ButtonMeeting' by the way.

The default code looks like this:

Set(DateSelected; Today());;
Set(DateTimeRoomChange; true);;
If(Mod(Minute(Now()); 30) <= 14;
Set(StartDateTime; DateAdd(Now(); -Mod(Minute(Now()); 30); Minutes));;
Set(EndDateTime; DateAdd(StartDateTime; 30; Minutes));
Mod(Minute(Now()); 30) >= 15;
Set(StartDateTime; DateAdd(Now(); -Mod(Minute(Now()); 30) + 0; Minutes));;
Set(EndDateTime; DateAdd(StartDateTime; 30; Minutes));
Set(StartDateTime; Now());;
Set(EndDateTime; DateAdd(Now(); -Mod(Minute(Now()); 30) + 0; Minutes))
);;

Set(StartDateTimeUTC; Text(DateAdd(StartDateTime; TimeZoneOffset(); Minutes); "[$-en-US]yyyy-mm-ddThh:mm") & ":00.000Z");;
Set(EndDateTimeUTC; Text(DateAdd(EndDateTime; TimeZoneOffset(); Minutes); "[$-en-US]yyyy-mm-ddThh:mm") & ":00.000Z");;

Set(BookForMeeting; false);;

If(NoRoomsList;

Navigate(RoomSelectScreen; Cover);

Navigate(RoomListSelectScreen; Cover)

)

Any help on how to edit this would be greatly appreciated.

Thanks in advance.

Andy

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Community Power Pla... on at

Like (1)

Report

Must be because it's monday morning but I can't figure out how to remove the previous post. Managed to fix it by adding the following:

Set(StartDateTime; DateAdd(Today();8;Hours)
);
Set(EndDateTime; DateAdd(Today();18;Hours)
);

Cheers
Andy

Was this reply helpful? Yes No
jasonberndt 2 on at

Like (0)

Report

Hi Andy,

I have zero experience with Power Apps and have been asked to do the same exact thing regarding booking times. Are you able to share more details regarding how you got this working? I added the lines from your solution but received unexpected character errors.

Thanks in advance,
Jason

Was this reply helpful? Yes No
RobinAllware 12 on at

Like (0)

Report

Hi Andy
Any chance you could elaborate or share how you did this? Where did you put this code and what other code did you remove to get the result?
Thanks

Was this reply helpful? Yes No
Nollzie 45 on at

Like (0)

Report

Hello, I would like to add the option to book a room for the entire day or multiple days, I am using this to manage 8 pool cars. I would like to add a button that would allow users to select a day or days from a calendar. Way beyond my current abilities.

Thanks in advance.

Was this reply helpful? Yes No
Nollzie 45 on at

Like (0)

Report

Hi Andy, can you please tell us exactly where to add the provided code, I want to use the App to manage Pool cars, so users need to be able to book 1 or more days.

Was this reply helpful? Yes No