cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DBG_Wiehl
Level: Powered On

Another time issue with Book A Room App

Hello 
Yes, I am an absolute beginner in using PowerApps, so please don't blame me for my question - please 🙂

Here we go:
The Book A Room - App shows available time slots in a 30min grid. I changed that in 5min slots by adjusting the initial settings to:

 

[..]
ClearCollect(Times;{Text: "07:00";Minutes: 420};
{Text: "07:05";Minutes: 425};
[..]

I also changed the settings where the MOD is calculated to

 

Set(DateSelected; Today());;
Set(DateTimeRoomChange; true);;
If(
Mod(Minute(Now()); 5) <= 2;
Set(StartDateTime; DateAdd(Now(); -Mod(Minute(Now()); 5); Minutes));;
Set(EndDateTime; DateAdd(StartDateTime; 5; Minutes));
Mod(Minute(Now()); 5) >= 3;
Set(StartDateTime; DateAdd(Now(); -Mod(Minute(Now()); 5) + 5; Minutes));;
Set(EndDateTime; DateAdd(StartDateTime; 5; Minutes));
Set(StartDateTime; Now());;
Set(EndDateTime; DateAdd(Now(); -Mod(Minute(Now()); 5) + 5; Minutes))
);;

 

In my understanding this calculates times by checking if the MOD of 'Actual Minutes' / 5 is equal less 2 or equal more than 3. Afterwards adjusting the start time in parts of 5min. Works all well, as far as I can see.

But when it comes to select a start time, the query always sends a 'No rooms available' back, when the start time is unequal to a full hour or half hour (like 09:25). When the start time is equal to a full or half hour (like 09:00 or 09:30), available rooms are shown properly.

I really cannot find any other variables or settings, where I can adjust that 30min grid to a 5min grid.

Any help appreciated 🙂

 

1 REPLY 1
TopShelf-MSFT
Level 10

Re: Another time issue with Book A Room App

Hi @DBG_Wiehl welcome to the PowerApps community and thanks for your question. I am going to bump this so the community can review and assist. 

 

@TopShelf-MSFT 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,738)