cancel
Showing results for 
Search instead for 
Did you mean: 

Get Resource Calendar Events from Office 365 Connector

Make it possible to get events from resource calendars (e.g. meeting rooms) in Office 365. Looking at the current connectors, only a few tweaks are neccessary.

 

The call in the Office 365 connector, GetCalendarTables, needs to provide an argument so we can specify the email address of the meeting room, rather than just returning the calendar ids of the current user.

 

Then (presumably) we can use the GetEventsCalendarViewV2 call to get the events for a given date range. This call requires the calendar id of the calendar to look up. So using the calendar id of the resource calendar obtained in GetCalendarTables we can then look the events.

 

Alternatively, make another method like GetEventsCalendarViewV2, but one that accepts the email of the resource calendar, rather than the calendar id specifically.

Status: Under Review

Adding @LanceDelano to see if we can offer an easy way to reverse the existing query (find open rooms vs. find all events booked to a room).

 

Thank you for your patience and clarifications,

Audrie

Comments
Flow Staff
Status changed to: Completed

Unless I have misunderstood your request, this is possible today leveraging the Outlook and Office 365 user connectors. I recommend that your take a look at the following templates in order to review how this is accomplished. 

 

These templates are found on the home page of your web authoring experience (web.powerapps.com)

  1. Book a Room
  2. Leave Request
  3. Out of Office

Let me know if this helps, and/or private message me for assistance.

 

Thank you,

Audrie

Level 8

Hi Audrie,

 

Happy to be proven wrong, but I believe what I am asking for is not possible using the current connectors.

 

What we are asking for is being able to get a current list of events of a resource calendar in Office 365 (e.g. a meeting room). I have looked at the templates and they are concerned with the current users's calendar or the free busy time of meeting room calendars.

 

We need to be able specify a date, a meeting room and then get a list of "what's on" for the specified date.

 

Could you please update the status of this request back to what is was (not completed).

 

Thanks,

Richard

 

 

 

 

Flow Staff

@rmmcgr This should be possible because you can "Get rooms" and "Get rooms in rooms list"  from the Office 365 Outlook Connector (see Book a Room Template). The return value of that includes the email address of the room (which is used to reserve it). At that point you can use that email to return calendar events booked for it (treating it like a user). Again, I have not tried this yet - just considering it should work in theory. Have you tried this approach?

 

Here are the parameters and keys I am seeing under Get Rooms and return values:

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

 

Let me know if this works for you, or if you'd like to me try it with you,

Audrie

 

Flow Staff
Status changed to: Under Review

Adding @LanceDelano to see if we can offer an easy way to reverse the existing query (find open rooms vs. find all events booked to a room).

 

Thank you for your patience and clarifications,

Audrie

Flow Staff

@rmmcgr I was able to confirm that the connector OOB doesn't not surface the events for contacts other than the profile user running the app (unless it's a shared calendar scenario).

 

So I will leave it under review and no longer completed. Lance is working on extending our connectors so adding him here to comment on feasibility for this idea. In the meantime, although I don't see this on the current roadmap, you can create a Custom Connector to extend the Outlook Connector which may expedite your project.

 

Thank you again for your patience, and for giving me time to test the assumption.

 

Audrie

 

@LanceDelano

 

Helpful references:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/register-custom-api

https://msdn.microsoft.com/en-us/office/office365/api/calendar-rest-operations

https://blogs.msdn.microsoft.com/devkeydet/2018/04/30/calling-an-azure-ad-secured-rest-api-from-powe...

 

Level 8

Hi Audrie,

 

Thank you for you help.

 

I did find a work around to display the meeting room events, but it was a bit convoluted and involved Azure functions exposing an API that I used in PowerApps.

 

I blogged about it here: http://www.richardmcgrath.io/

 

It would be great if all the complexity could be removed by OOTB connectors.

 

Regards,

Richard

Flow Staff

@rmmcgr Would you like to do a webinar with me to showcase your Azure Functions usage with PowerApps?

Level: Powered On

has there been any movement on extending the connectors to surface meeting room events?  This would open up a host of applications the least being resource calendars for public display and interaction.

Level: Powered On

Plus one on this one, this would indeed be a great help

Level: Powered On

Yes, add my vote too.  I've been trying for over a year now asking to get a way to use flow to generate an email for an upcoming event on a resource calendar.  The use case here is I want to generate an email to I.T. Staff that an upcoming computer is reserved and to make sure it's updated by I.T. before the user checks it out.

 

I try to use the simple Flow of "When and upcooming event is starting soon" but it won't accept any calendar except for the user of who is logged in.  Resources don't have logins, and specifying a custom Calendar ID does not work either.  To be able to access resource calendars would be extremely useful in these flows.