How to get Resource room's Calendar ID

(2) Share

Report

Posted on by AndiRodi

133

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

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
AndiRodi 133 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
AndiRodi 133 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
AndiRodi 133 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
AndiRodi 133 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AndiRodi 133 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

i did it by creating a custom connector and using the call /users/{id | userPrincipalName}/calendar, where userPrincipalName is the email address of your room. anyway you can do it without creating a custom connector just using HTTP Request action in MS PowerAutomate.
in the second way:
-select the http request action and set as call https://graph.microsoft.com/v1.0//users/{id | userPrincipalName}/calendar (do not forget to pass as userprincipalName the email address of your desired room).
Than Save and Test the flow.
Copy the output got from the HTTP action
Then as second action of your flow, use JSON Analyzer and set in "content" field the "Body" comes from the HTTP request action, and in Schema (get from sample) paste the output got from the HTTP request action that you copied in the setp above.
Then by using the action "return data to poweApps" pass to you app the Calendar ID.
I hope I have helped you.

BR
Andi

Was this reply helpful? Yes No