Unanswered

Book a Room template app - view all bookings by date

(0) Share

Report

Posted on by Kizmiester10

Hi, I am using the book a room template as a room/desk booking app which works great. I would like to add a screen to view a list of all room/desk bookings by a selected date. The aim is that with blended working colleagues would like to see who is in the office any given day. Any idea’s for the best way of doing this?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Lewis B 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kizmiester10 , Sounds like you need to do a filter on a gallery which references a date picker.

If you've already got a screen which shows a list of bookings, then you can duplicate this screen and select the gallery. Make sure you add a date picker input control to the screen. Then select the items property of the gallery and add a filter such as the one below:

Filter(Datasource, Date = DatePicker1)

Something like that should help hopefully!

Datasource = the name of your list/table
Date = the name of your date column
Kizmiester10 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @lowcodelewis I don't have a list of bookings. I'm trying to achieve a solution to create a list where all users can view details of all bookings (made by all users) for all of the rooms calendars in our 365 rooms list on a selected date. This way we would be able to see who is in an office at any given time. Looking at similar queries I'm not sure if a straight forward solution is possible, or maybe I request the room calendars be shared with me and then have a work around where I'm able to automatically extract and then feed the event data back onto a table in the app for others to view and filter. Hope this makes sense.
Lewis B 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you got any experience using Microsoft Graph and the HTTP action in Power Automate?

This might help you - Get shared or delegated Outlook calendar and its events - Microsoft Graph | Microsoft Learn

You can then write a flow using the HTTP step and the api from graph to get a shared calendars events, then take the JSON output and use the content to put into a Dataverse table.

Let me know if you need more help with this and I'll break it down in further steps in a blog post or something 🙂