How to get Resource room's all bookings to table or gallery

(0) Share

Report

Posted on by WW-25090315-0

Hello everyone,

This is scenario,

Set the Items proeprty of the RoomDropdown (Dropdown1) box to following:

Office365.GetRoomsV2().value

set the Items property of the CalendarDropdown (Dropdown2) box to following:

Office365.CalendarGetTablesV2().value

Add a Data Table, set the Items proeprty to following:

Filter(
    Office365Outlook.V2CalendarGetItems(Dropdown2.Selected.Name).value,
    (Location = Dropdown1.Selected.Name || IsBlank(Dropdown1.Selected.Name)) &&
    (Start <= Now() || End >= Now())
)
 
I need to view all the bookings for the selected room, but the current implementation only shows a few bookings. Can anyone help me fix this issue, please?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WW-25090315-0

The first one should be
Office365Outlook.GetRoomsV2().value

and the second one is correct as you have it (ensure you display name, not id in the dropdown) and gives you a list of your Calendars.
Office365Outlook.CalendarGetTablesV2().value

Your Gallery (much more flexible than a Data Table) display would be (although I am not sure on the logic of the last line) - note Lower Case n in name
Filter( Office365Outlook.V2CalendarGetItems(Dropdown2.Selected.name).value, (Location = Dropdown1.Selected.name || Len(Dropdown1.Selected.name) = 0) && (Start <= Now() || End >= Now()) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@WW-25090315-0

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No