Power Platform Community Forum Thread Details

Hello,

We use the Book a Room template app to reservate our meeting rooms.
Now im making a app next to it where i can see the upcoming events for each meeting room.
So the idea is to place a tablet on the wall of each meeting room where u can see who have a reservation right now an the 4 upcoming reservations. like the screenshot but then without the book button.

The only thing i dont know is how i can see the 5 upcoming events and what connector do i have to use for it?
Btw i dont want the see the title of the meeting but i want to see the persons who booked it. So that not the whole company can see what meeting it is.

Can u guys help me further?

Categories:

Building Power Apps

Hello @BasvandenBerg ,

As I have no idea how you created your app, all I can do is give you a few tips to help you progress on your own.

Basically, you should have a table (let's say you have a SharePoint list) where all events are listed with their location, their duration and their starting date & hour.

You want to list only the events related to the meeting room, the current or next events as well as the five or less next events following the first.

First, you want to get a list of all events of the meeting room, hopefully only the ones who will happen in the future while ignore the ones that already happened.

Second, you must somehow get the current event. For that you need to set a datetime as a starting point in your search and return the first event occurring after given datetime.

Finally, in addition to the current event, you also want to get the five upcoming events.

Now that each point has been clearly established, you can start writing the corresponding formula in PowerApps.

1. Get all future events of the meeting room

Filter(Events, MeetingRoom = "NameOfMeetingRoom", StartDate >= Now())

2. Only the next event

First(Sort(Filter(Events, MeetingRoom = "NameOfMeetingRoom", StartDate >= Now()), StartDate))

3. The next event and the five upcoming events

Firstn(Sort(Filter(Events, MeetingRoom = "NameOfMeetingRoom", StartDate >= Now()), StartDate), 6)

On another note, you want to use the connector corresponding to your database. If you're using a SharePoint list, you should use the "SharePoint" connector. If you're using an Excel Sheet, you should use the "Excel" connector. etc.

Hope this was helpful to you.