cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

How to get Resource room's Calendar ID

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to get Resource room's Calendar ID

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:13.JPG

 

14.JPG

 

15.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Highlighted
Community Support
Community Support

Re: How to get Resource room's Calendar ID

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: How to get Resource room's Calendar ID

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

Highlighted
Community Support
Community Support

Re: How to get Resource room's Calendar ID

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:13.JPG

 

14.JPG

 

15.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Advocate II
Advocate II

Re: How to get Resource room's Calendar ID

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?

Highlighted
Advocate II
Advocate II

Re: How to get Resource room's Calendar ID

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 proprietyCattura.PNG

Thanks

Highlighted
Community Support
Community Support

Re: How to get Resource room's Calendar ID

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: How to get Resource room's Calendar ID

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
Highlighted
Advocate I
Advocate I

Re: How to get Resource room's Calendar ID


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

Helpful resources

Announcements
secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,593)