Answered

Booking app connected to Outlook calendar

(0) Share

Report

Posted on by DS0216

Hi all,

I am currently working on a booking app via PowerApps for my company. However, it's my first time to come across PowerApps. I would like to simply connect the booking app to a outlook calendar to find out whether the timeslot is available then the whole booking process is done afterwards. I have tried to change the template of "Book a Room", while those buttons do not work at all after I have done all the changes. Anyone can help with some simply illustrations for me to follow it?

Many thanks!!!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DS0216 ，

Could you describe more clearly about how do you want to customize the "book a room" template?

If you could clear what functions you want or which formulas that you want to modify, it will be better.

Describing with screenshoots will help a lot.

If you just want to recreate connection, please click here:

If you want to change connection's account , you just need to remove the original connection, create new connection, choose the account that you want when create new connection.

Best regards,
DS0216 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply. As I'm really new to PowerApps, I do not know which particular formula I should use. However, I have connected it to an outlook account. Basically, I would like to have a button to click and pop up the calendar which linked to my outlook account, and users can based on my calendar availability to book an one hour session for each appointment. Confirmation email would be send out and marked the appointment in both of my outlook and user outlook calendar.

Many thanks.
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DS0216 ,

Well, do you want to book meeting and send email about this message?

If so, you need these connector:Skype for Business, office365 outlook

1) use Skype for Business to book meeting

function:

SkypeForBusiness.CreateMeeting

parameter:

formula for example:

SkypeForBusiness.CreateMeeting("Skype Meeting for " & MeetingsGallery.Selected.Subject, {ExpirationDateTime: Text(DateAdd(StartDateTime, 1, Days), UTC)})

2)use office365 outlook to link the calendar to outlook:

function:

Office365.V4CalendarPatchItem

parameter:

formula for example:

Office365.V2CalendarPatchItem(MyCalendar, MeetingsGallery.Selected.Id, MeetingsGallery.Selected.Subject, StartDateTimeUTC, EndDateTimeUTC,"(UTC) Coordinated Universal Time")

3)use office365 outlook to send email:

function:

Office365.SendEmailV2

parameter:

You need to save the information of the meeting as a collection and use this collection's data as the email's body.

Here are docs about these two connector for your reference:

https://docs.microsoft.com/en-us/connectors/office365/#send-an-email-(v2)

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

What's more , book a room is a good template. You could refer the formulas in this template.

Best regards,
DS0216 4 on at

Like
a
(0)

Report
Copy link

Link copied!

What if I have created a date picker to pop up a calendar, which I would like to link with my outlook calendar to check the availability of a particular time slot. What kind of code I should add on for that? Also, I would like to add a time picker for it as well.
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DS0216 ,

There has been a template screen for what you want.

In the template screen, after you select date in the date picker, the related event will display in the left of the screen.

If you want to display calendar in date picker directly, I'm afraid it's not supported currently.

Date picker not supports this kind of customization now.

But this template has similar function.

Please refer the formulas that the template use:

1)dropdownCalendarSelection1's Items:

Office365Outlook.CalendarGetTables().value

//lists available calendars

2)dropdownCalendarSelection1's OnSelect:

ClearCollect(MyCalendarEvents, Office365Outlook.GetEventsCalendarViewV2(_myCalendar.Name, Text(_minDate, UTC), Text(_maxDate, UTC)).value)

//save all the events based on the date and calendar that you selected as a collection , GetEventsCalendarViewV2 has been DEPRECATED, please try

Office365Outlook.GetEventsCalendarViewV3

3)CalendarEventsGallery1's Items

SortByColumns(Filter(MyCalendarEvents, Text(Start, DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate)), "Start")

//display the related events

Please refer these functions in details here:

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

Best regards,