Answered

Color fill time slots - booking schedule

(1) Share

Report

Posted on by SteveBouten

Good afternoon all,

I'm trying to create an availability screen for our car bookings (see attached) based on the start date/time & end date/time.

All the booking info is available in a SharePoint list (see attached)

Test booking: 07/04/2021 10:00 - 08/04/2021 11:30 // Duration is 1530 minutes.

The lookup searches the list for the Start Date, Allocated vehicle (VBE08) & Start Time and then gives the "DurationMin" column value in the corresponding label.

I'd like it to color all the labels from the start date/time until the end date/time, including the next date when it's a long booking.

This formula is currently in the fill for 10:30: If(lblAsset1_6-30>=0,Red, lblAsset1_7-30>=0,Red,Transparent)

lblAsset1_6 = label next to 10:00

lblAsset1_7 = label next to 10:30

Any help would be much appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SteveBouten :

Do you want to get something like this?

I've made a test for your reference:
1\My data source (SteveBoutenList)

Column (click to edit) Type

Title Single line of text

StartDate Date and Time(Date Only)

StartTime Single line of text

EndDate Date and Time(Date Only)

EndTime Single line of text

2\Add a date picker control(DatePicker1)

3\Add a gallery and set it's items property to

ForAll( Sequence(21,0,1), DateAdd( DatePicker1.SelectedDate + Time(7,30,0), 30 * Value, Minutes ) )

4\Add a label control in to the gallery

Text

Text(ThisItem.Value,"[$-en]HH:mm")

BorderThickness

1

5\Add an other label control control in to the gallery

Fill

With( { TheTable: Filter(SteveBoutenList,Title = "VBE08") }, If( CountRows( Filter( TheTable, ThisItem.Value >= DateTimeValue(Text(StartDate,"[$-en]yyyy/mm/dd") & " " & StartTime) && ThisItem.Value <= DateTimeValue(Text(EndDate,"[$-en]yyyy/mm/dd") & " " & EndTime)) ) > 0, Red, RGBA(0,0,0,0) ) )

BorderThickness

1

Best Regards,

Bof

Was this reply helpful? Yes No
SteveBouten 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof,

That's exactly what I was looking for. Thank you so much!!

Kind regards,

Was this reply helpful? Yes No
Suresh_Pune_91 16 on at

Like
a
(0)

Report
Copy link

Link copied!

where we are using StartDate,EndDate, StartTime,EndTime in the gallery/form?

Was this reply helpful? Yes No
SteveBouten 24 on at

Like
a
(0)

Report
Copy link

Link copied!

The input comes from a form and the results are showing in a gallery as shown below.

Was this reply helpful? Yes No
Suresh_Pune_91 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,
Can we fill the slots automatically based on the start time and end time?
For example, I have a selected a specific date and time , let say, 17/02/2023. Start Time: 10:00 , End Time 12:30.
I need to fill the calendar with red color On change of Time slots instantly. Is this possible? if yes, Kindly guide me how to achieve this? Thanks in advance

Was this reply helpful? Yes No
SteveBouten 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
That's the same as how I do it, if you follow Bof's tutorial above you'll be able to do that.

Kind regards,

Was this reply helpful? Yes No
Suresh_Pune_91 16 on at

Like
a
(0)

Report
Copy link

Link copied!

The above formula is changing the color of the filled slots by filtering the Table data. But I need to change the color when an user select the date and time slot in the form.
The selected time slot should be replaced with Red Color on change of StartTime & EndTime.
Please help me on this.

Regards,
Suresh

Was this reply helpful? Yes No
SteveBouten 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Suresh,
On my app the user has already completed the Start date/time & End date/time. When we allocated a vehicle to it and submit the form the booked time becomes red. Is that what you want? Because the above solution is linked to the input form.
Before allocating a vehicle After allocating a vehicle
Kind regards,

Was this reply helpful? Yes No