SOLVED

Integration of bookings with Flow and PowerApps

%3CLINGO-SUB%20id%3D%22lingo-sub-393085%22%20slang%3D%22en-US%22%3EIntegration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393085%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20use%20bookings%20functionality%20in%20a%20PowerApp.%20I%20am%20looking%20for%20a%20solution%20that%20will%20support%20the%20booking%20of%20resources%20in%20an%20online%20examination%20room%2C%20asking%20the%20person%20to%20do%20a%20reservation%20for%20each%20student%20is%20too%20time%20consuming%2C%20is%20there%20a%20way%20to%20using%20the%20bookings%20app.%20to%20define%20the%20resource%20capacity%20and%20availability%20but%20use%20an%20app%20to%20create%20the%20(multiple)%20reservations%3F%20There%20does%20not%20seem%20to%20be%20a%20connector%20in%20Flow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-393085%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebookings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-688515%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-688515%22%20slang%3D%22en-US%22%3EI%20am%20completely%20puzzled%20and%20angry%20with%20Microsoft%20for%20not%20including%20a%20Flow%20Connector%20for%20Microsoft%20bookings%20%3A(%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20come%20it%20allows%20any%20products%20in%20Office%20365%20without%20including%20a%20connector%20to%20Flow%2C%20PowerApps%20or%20Power%20BI%2C%20it%20should%20be%20a%20minimum%20engineering%20requirements.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1217778%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1217778%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F118758%22%20target%3D%22_blank%22%3E%40Paul%20Dewhurst%3C%2FA%3E%26nbsp%3BI%20have%20created%20a%20flow%20that%20is%20using%20the%20trigger%26nbsp%3B%20%22When%20a%20new%20event%20is%20created%20(V3)%22%20(Office%20365%20Outlook)%20and%20used%20the%20bookings%20%22user%22email%20for%20the%20connection%20%2C%20so%20now%20when%20a%20booking%20is%20made%20I%20can%20automatically%20do%20other%20%22flow%22%20actions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222961%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551952%22%20target%3D%22_blank%22%3E%40_MichaelVD_%3C%2FA%3E%26nbsp%3B%20This%20sounds%20exactly%20like%20what%20I'm%20looking%20for!%20How%20do%20you%20point%20the%20flow%20trigger%20to%20the%20booking%20calendar%20alias%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1224641%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1224641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383375%22%20target%3D%22_blank%22%3E%40David_Swenson%3C%2FA%3E%26nbsp%3BI%20searched%20for%20the%20bookings%20mail%20in%20my%20O365%20users%20and%20set%20a%20password%20for%20this%20email%20adress%20.%20Then%20in%20the%20Flow%20I%20added%20the%20action%26nbsp%3B%26nbsp%3B%3CSPAN%3E%22When%20a%20new%20event%20is%20created%20(V3)%22%20(Office%20365%20Outlook)%26nbsp%3B%3C%2FSPAN%3Eclicked%20the%203%20dots%20of%20this%20block%20and%20added%20a%20new%20connection%20with%20the%20email%20adres%20%26amp%3B%20password%20of%20the%20bookings%20mail%20adres.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20every%20time%20a%20new%20booking%20is%20made%20the%20flow%20is%20started%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1224659%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1224659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551952%22%20target%3D%22_blank%22%3E%40_MichaelVD_%3C%2FA%3E%26nbsp%3BThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1284536%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1284536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551952%22%20target%3D%22_blank%22%3E%40_MichaelVD_%3C%2FA%3E%26nbsp%3BBrilliant%20workaround%2C%20I%20couldn't%20find%20the%20booking%20user%2Fcalendar%20in%20the%20admin%20portal%20so%20I%20created%20it%20as%20a%20user%20without%20a%20license.%20Had%20some%20trouble%20trying%20to%20add%20it%20as%20another%20connection%20in%20Flow%20though%2C%20logged%20in%20fine%20but%20it%20failed%20to%20pull%20in%20the%20calendar.%20Did%20you%20have%20to%20assign%20the%20user%20a%20license%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Jake%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1286087%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343319%22%20target%3D%22_blank%22%3E%40jhodgson%3C%2FA%3EI'm%20having%20this%20same%20confusion.%20Creating%20a%20Bookings%20page%20apparently%20creates%20a%20sort%20of%20%22ghost%20user%22%20with%20a%20calendar%20for%20the%20booking%20appointments...but%20there's%20no%20instruction%20on%20how%20to%20control%20this%20%22user%22%2C%20access%20the%20calendar%2C%20change%20the%20default%20name%20or%20email%20address%2C%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20sure%20its%20designed%20to%20be%20as%20simple%20and%20automatic%20as%20possible%2C%20but%20its%20confusing%20outside%20of%20very%20specific%20use%20cases.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1363750%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1363750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343319%22%20target%3D%22_blank%22%3E%40jhodgson%3C%2FA%3E%26nbsp%3Bwhen%20I%20create%20a%20new%20bookingspage%20an%20online%20o365%20user%20is%20created%20for%20this%20bookingpage%20%2C%20based%20on%20the%20initial%20name%20you%20give%20it%20when%20you%20create%20the%20page.%3C%2FP%3E%3CP%3ESo%20if%20you%20create%20a%20%22Booking%20Test%22%20page%20the%20user%20that%20is%20created%20is%20%3CA%20href%3D%22mailto%3Abookingtest%40domain.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ebookingtest%40yourdomain.com%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20go%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fadmin.microsoft.com%2FAdminPortal%23%2Fusers%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fadmin.microsoft.com%2FAdminPortal%23%2Fusers%3C%2FA%3E%26nbsp%3BI%20can%20find%20this%20user%20if%20I%20search%20for%20this%20full%20email%20adres.%20While%20I%20was%20testing%20I%20then%20assigned%20a%20A1%20license%20to%20this%20user%20because%20we%20have%20free%20A1%20licenses%20because%20our%20company%20is%20a%20non%20profit%20company.%20But%20I%20just%20did%20a%20test%20with%20a%20new%20booking%20page%20I%20created%20and%20it%20also%20works%20with%20this%20booking%20user%20without%20assigning%20a%20license.%20So%20I%20just%20had%20to%20set%20a%20password%20for%20this%20user%20in%20the%20Admin%20portal.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20flow%20itself%26nbsp%3Byou%20then%20click%20the%20three%20points%20and%20choose%20%22add%20new%20connection%22%20(see%20screenshot)%20and%20use%20the%20password%20and%20email%20adress%20of%20this%20booking%20user%20to%20run%20the%20%22When%20a%20new%20event%20is%20created%20(V3)%22%20action%20(and%20when%20I%20click%20the%20dropdown%20the%20%22Calendar%22%20is%20already%20visible%20so%20I%20just%20have%20to%20select%20it.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1363774%22%20slang%3D%22en-US%22%3ERe%3A%20Integration%20of%20bookings%20with%20Flow%20and%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1363774%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F603374%22%20target%3D%22_blank%22%3E%40tom-wise%3C%2FA%3E%26nbsp%3BI%20think%20you%20should%20be%20able%20to%20change%20the%20displayname%20%26amp%3B%20email%20in%20the%20admin%20portal.%3C%2FP%3E%3CP%3EBut%20then%20you%20have%20to%20find%20the%20user%20of%20course%20%2C%20I%20found%20out%20that%20if%20you%20search%20for%20just%20a%20part%20of%20the%20name%20the%20user%20does%20not%20show%20up.%20But%20if%20you%20search%20with%20the%20complete%20email%20adres%20it%20does.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20find%20it%20with%20all%20its%20properties%20by%20using%20powershell%20%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powershell%22%3E%3CCODE%3EGet-MsolUser%20-UserPrincipalName%20bookingtest%40yourdomain.com%20%7C%20Format-List%20-Property%20*%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EOr%20change%20properties%20with%20%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESet-MsolUser%20-UserPrincipalName%20bookingtest%40yourdomain.com%20-Displayname%20%22Changed%20displayname%22%20..%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Senior Member

Is it possible to use bookings functionality in a PowerApp. I am looking for a solution that will support the booking of resources in an online examination room, asking the person to do a reservation for each student is too time consuming, is there a way to using the bookings app. to define the resource capacity and availability but use an app to create the (multiple) reservations? There does not seem to be a connector in Flow.

9 Replies
Highlighted
I am completely puzzled and angry with Microsoft for not including a Flow Connector for Microsoft bookings :(

How come it allows any products in Office 365 without including a connector to Flow, PowerApps or Power BI, it should be a minimum engineering requirements.
Highlighted
Solution

@Paul Dewhurst I have created a flow that is using the trigger  "When a new event is created (V3)" (Office 365 Outlook) and used the bookings "user"email for the connection , so now when a booking is made I can automatically do other "flow" actions.

Highlighted

@_MichaelVD_  This sounds exactly like what I'm looking for! How do you point the flow trigger to the booking calendar alias? 

Highlighted

@David_Swenson I searched for the bookings mail in my O365 users and set a password for this email adress . Then in the Flow I added the action  "When a new event is created (V3)" (Office 365 Outlook) clicked the 3 dots of this block and added a new connection with the email adres & password of the bookings mail adres.

 

Then every time a new booking is made the flow is started

Highlighted
Highlighted

@_MichaelVD_ Brilliant workaround, I couldn't find the booking user/calendar in the admin portal so I created it as a user without a license. Had some trouble trying to add it as another connection in Flow though, logged in fine but it failed to pull in the calendar. Did you have to assign the user a license?

 

Thanks Jake

Highlighted

@jhodgsonI'm having this same confusion. Creating a Bookings page apparently creates a sort of "ghost user" with a calendar for the booking appointments...but there's no instruction on how to control this "user", access the calendar, change the default name or email address, etc.

I'm sure its designed to be as simple and automatic as possible, but its confusing outside of very specific use cases.

Highlighted

@jhodgson when I create a new bookingspage an online o365 user is created for this bookingpage , based on the initial name you give it when you create the page.

So if you create a "Booking Test" page the user that is created is bookingtest@yourdomain.com

 

When I go to https://admin.microsoft.com/AdminPortal#/users I can find this user if I search for this full email adres. While I was testing I then assigned a A1 license to this user because we have free A1 licenses because our company is a non profit company. But I just did a test with a new booking page I created and it also works with this booking user without assigning a license. So I just had to set a password for this user in the Admin portal.

 

In the flow itself you then click the three points and choose "add new connection" (see screenshot) and use the password and email adress of this booking user to run the "When a new event is created (V3)" action (and when I click the dropdown the "Calendar" is already visible so I just have to select it.)

 

 

Highlighted

@tom-wise I think you should be able to change the displayname & email in the admin portal.

But then you have to find the user of course , I found out that if you search for just a part of the name the user does not show up. But if you search with the complete email adres it does.

 

You can also find it with all its properties by using powershell :

Get-MsolUser -UserPrincipalName bookingtest@yourdomain.com | Format-List -Property *

Or change properties with :

Set-MsolUser -UserPrincipalName bookingtest@yourdomain.com -Displayname "Changed displayname" ..