How to get Resource room's Calendar ID

[AndiRodi]

Hi everyone,

Just a question. is there any way to get Calendar Id for a Meeting room resource?

Through this ID i would want to get the event occurred on Meeting Room Calendar and show all detials of current event in a gallery.

What i want to realize is a Viewr which show to the employee the current meeting room's status (red if there is an event in progress, green if the meeting room is free).

Thanks

Andi

[v-xida-msft]

Hi @AndiRodi ,

Do you want to get the Calendar Id value for a Meeting room resource?

If you want to get the Calendar Id value for a Meeting room resource, I afraid that there is no way to achieve your needs in PowerApps currently.

Currently, the result the Office365.GetRoomsV2(), Office365.GetRooms(), Office365.GetRoomListsV2() , Office365.GetRoomLists() function returned only contains name and address property, it could not contain a Calendar Id proeprty.

More details about the actions provided by Office 365 Outlook connector, please check the following article:

https://docs.microsoft.com/en-us/connectors/office365/

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

[AndiRodi]

Hi @v-xida-msft 

Thanks for your answer. 
There is a way to show the resource meeting room calendar or/and gets all its events?
I want check if the a meeting room calendar is free for a specific booking time.

Thanks,

Andi

[v-xida-msft · Accepted solution]

Hi @AndiRodi ,

Do you want to get all events occured within a specific Meeting Room?

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:

Set the Items proeprty of the RoomDropdown box to following:

Office365.GetRoomsV2().value

set the Items property of the CalendarDropdown box to following:

Office365.CalendarGetTablesV2().value

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

Filter(
       Office365.V2CalendarGetItems(CalendarDropdown.Selected.id).value, 
       Location= RoomDropdown.Selected.name
)

enable correspondiong columns you want to show within the Data Table control.

You could select different Room resource from the RoomDropdown box, then the Data Table would show all Calendar events belong to the selected Room resource.

Please consider take a try with above solution, check if the issue.

Best regards,

[AndiRodi]

It is a good way, but not exactly what i need. I Need to get all Room's Events regardless of the logged in user.

This solution, is a good idea, but it show just the Room's Events related to the logged user. 

If there is an occured event from another user to the same Room, i can't see it on my list/table . quite Right?

[AndiRodi]

anyway I am testing your solution, but my powerApps Studio doesn't show me the both codes:

Office365.V2CalendarGetItems(CalendarDropdown.Selected.id).value, 

Office365.CalendarGetTablesV2().value

 and more, i get this in the table's item propriety

Thanks

[v-xida-msft]

Hi @AndiRodi ,

Yeah, you are right.

If you want to show all Room's Events regardless of the logged in user, I afraid that there is no way to achieve your needs in PowerApps currenlty.

Best regards,

[AndiRodi]

hi @v-xida-msft ,

From PowerShell i got the Room ID (the same format that is expected by the Office365.GetEventsCalendarViewV2()  function. 

But when i run the code

Set(ResourceRoomCalendar;"AAMkADEzODVlYTFjLWNiZDQtNGQ0Ny04YzM5LTE3NmMyNzBmNWU4NQBGAAAAAABvOOuOugWHQYg9uQ6HPFPoBwAPhyYHCPgxR5JEdn5q0_8uAAAAAAEGAAAPhyYHCPgxR5JEdn5q0_8uAAAWfns3AAA=");;
ClearCollect(MyRoomCalendarEvents; Office365.GetEventsCalendarViewV2(ResourceRoomCalendar; Text(_minDate; UTC); Text(_maxDate; UTC)).value)

i get this error

"status": 404,

"message": "The specified object was not found in the store.\r\nclientRequestId: 60121a27-0c7a-4587-ba98-c9fc0f89c46a\r\nserviceRequestId: e39bfc1a-2826-47ef-90fd-360bb098a59d",

"source": "office365-we.azconn-we-01.p.azurewebsites.net"

I guess it's about some Exchange permission. 

Do you know some workaround to bypass this error from Admin Congiguration?

otherwise, some one on the powerApps community told me to think about a custom connector to resolve it. Do you have some doc materials (tutorials or deep and clear documentation) which are explaining me how to create one of this custom connectors? 

Thanks,

Andi

[Anonymous]

---

@AndiRodi wrote:

hi @v-xida-msft ,

From PowerShell i got the Room ID (the same format that is expected by the Office365.GetEventsCalendarViewV2()  function. 

But when i run the code

Set(ResourceRoomCalendar;"AAMkADEzODVlYTFjLWNiZDQtNGQ0Ny04YzM5LTE3NmMyNzBmNWU4NQBGAAAAAABvOOuOugWHQYg9uQ6HPFPoBwAPhyYHCPgxR5JEdn5q0_8uAAAAAAEGAAAPhyYHCPgxR5JEdn5q0_8uAAAWfns3AAA=");;
ClearCollect(MyRoomCalendarEvents; Office365.GetEventsCalendarViewV2(ResourceRoomCalendar; Text(_minDate; UTC); Text(_maxDate; UTC)).value)

i get this error

"status": 404,

"message": "The specified object was not found in the store.\r\nclientRequestId: 60121a27-0c7a-4587-ba98-c9fc0f89c46a\r\nserviceRequestId: e39bfc1a-2826-47ef-90fd-360bb098a59d",

"source": "office365-we.azconn-we-01.p.azurewebsites.net"

I guess it's about some Exchange permission. 

Do you know some workaround to bypass this error from Admin Congiguration?

otherwise, some one on the powerApps community told me to think about a custom connector to resolve it. Do you have some doc materials (tutorials or deep and clear documentation) which are explaining me how to create one of this custom connectors? 

Thanks,

Andi

---

How did you get the ID from PowerShell? I can find multiple Id's but not one that fits the format.

[Anonymous]

Did you find any solution to this? Im looking for the same thing too.