Power Automate

Get rooms bookings

(0) Share

Report

Posted on by RH-07080703-0

118

Hello,

The goal of my flow is to have all the rooms booking in a sharepoint list.

I've already another flow with getRooms and have now every room in a shpt list with the email address.

Now, in my flow, for each room, I make an http request with this URI:

concat(
  'https://graph.microsoft.com/v1.0/users/',
  items('Apply_to_each')?['AdresseOutlook'],
  '/calendar/events?$filter=start/dateTime ge ''',
  variables('Début jour'),
  ''' and start/dateTime le ''',
  variables('Fin du jour'),
  ''''
)

It works fine but as soon as there is a private appointment, it fails with the error "Resource not found".

I search for solutions since 1 week with Copilot but we turn around and find any no premium solution.

Is there any way without premium connectors to avoid private appointment at least?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

It's because private appointments in Outlook calendars require special mailbox level permissions that are not automatically granted by Graph API permissions alone.

It is also documented here: https://learn.microsoft.com/en-us/graph/api/calendar-list-events?view=graph-rest-1.0&tabs=http.

In that box.

Even if your app registration has Calendars.Read or Calendars.Read.All application permissions, Graph will fail when it encounters a private event.

The caller needs:

1. FullAccess mailbox permission (via Add-MailboxPermission cmdlet)

or
2. Delegate + CanViewPrivateItems flags (via Add-MailboxFolderPermission cmdlet)

Example:

Connect-ExchangeOnline

and then

Add-MailboxPermission -Identity "room@domain.com" -User "<ServicePrincipalAppId>" -AccessRights FullAccess -InheritanceType All

If you don't need private bookings you can skip them using "Run After" settings to skip failed HTTP requests and continue processing other rooms.

Let me know if it worked!

Was this reply helpful? Yes No
RH-07080703-0 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @chiaraalina,

Of course, I can make a treatment in a run after but it's not a solution to obtain the public bookings for the same room when it fails.

Was this reply helpful? Yes No