Unanswered

Training app - See my bookings and the other that are training within the hour

(0) Share

Report

Posted on by Baiaz

Hello
we create an app where the employees can book the training room. On the first page, they should be able to see their bookings and also whether there are others training right now and within an hour. In this way, we want to create a community at work where people want to train and use our space.

The top field in the picture on the left should show my bookings and below they should be able to see who or if there are others training now or within an hour.
we have completed the actual booking and would like to see the result in the figure on the left. Can someone help us on our way?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Baiaz ,

I'm going to assume you have a SharePoint list where each item has a datetime-type column containing both the date and the time of the booking.

The formula below should help you:

Filter( datasource, datetimeColumn <= selectedDateTime, selectedDateTuime <= DateAdd(datetimeColumn, 1, TimeUnit.Hours) )

This "Filter()" should return every record whose time is either equal to the selected hour or within the next hour.

Also, I couldn't help but notice your calendar stretches from 0 to 41. Is everything okay?

Was this reply helpful? Yes No
Baiaz 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes - I do have a Sharepoint list that all the bookings are recorded.. thanks!!!

Was this reply helpful? Yes No
Baiaz 20 on at

Like
a
(0)

Report
Copy link

Link copied!

So the List is listed under the screen
and I want to see all my bookings in the field

So I have added a text boks and tried to make it to work. But no luck. The list is called Treningsapp

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
If you want to see all your bookings without filtering, then you just have to put the datasource inside the "Items" property of your gallery without "Filter()".

Gallery.Items: datasource

If you want to see only your bookings, then you can filter on the "Created By" column to show only records created by the current user:

Filter( datasource, 'Created by'.Email = User().Email )

Also, have you tried implementing the formula sample I gave you earlier?

Was this reply helpful? Yes No