Create Outlook Calendar Event through PowerApps

We have a lot of requirements to create an outlook calendar invite through PowerApps. We will discuss the common issues that users are encountering like timezone, Combobox not displays the name, Time off by x hours, or not creating invites/events when adding required attendees.

Setup to Add Invite

Required and Optional Attendees Items Property (Office 365 users)

Office365Users.SearchUser({searchTerm: “”})

We can also use SP Person Column

Choices([@SPList].PersonColumnName)

Set the Primary text and Searchfield for that Combobox

Select the Combobox
Click “Edit” on the right-side properties
Set Primary text (DisplayFields) and Searchfield as “DisplayName”

Which is

Difference between Office365 and SP column

Concat(RequiredAttendess.SelectedItems.Mail,Mail& “;”), //Office 365 Users

vs

Concat(RequiredAttendess.SelectedItems.Email ,Email & “;”), //SP Person Column

Syntax to create an invite/event

Office365Outlook.V4CalendarPostItem(
table,
subject,
start,
end,
timeZone,
{
requiredAttendees:Text,
optionalAttendees:Text,
resourceAttendees:Text,
body:Text,
location:Text,
importance:Text,
isAllDay:Boolean,
recurrence:Text,
recurrenceEnd:Text,
numberOfOccurences:Number,
reminderMinutesBeforeStart:Number,
isReminderOn:Boolean,
showAs:Text,
responseRequested:Boolean,
sensitivity:Text
}
)

OnSelect Property of ‘Send Calendar Invite”

Will split into multiple sections for easy understanding.

1. Table – Name of the Calendar from your outlook

LookUp(
Office365Outlook.CalendarGetTables().value,
DisplayName = “Calendar”
).Name

2. Subject

SubjectInput.Text

3. Start

Text(
DateAdd(
DateTimeValue(
StartDatePicker.SelectedDate & ” ” & TimeValue(
Concatenate(
StartHour.Selected.Value,
“:”,
StartMinute.Selected.Value
)
)
),
TimeZoneOffset(),
Minutes
),
“yyyy-mm-ddTHH:mm:ssZ”
),

4. End

Text(
DateAdd(
DateTimeValue(
EndDatePicker.SelectedDate & ” ” & TimeValue(
Concatenate(
EndHour.Selected.Value,
“:”,
EndMinute.Selected.Value
)
)
),
TimeZoneOffset(),
Minutes
),
“yyyy-mm-ddTHH:mm:ssZ”
),

5. Timezone

“(UTC) Coordinated Universal Time”

6. Body

body: ‘Email Content’.HtmlText

6. RequiredAttendees

requiredAttendees: Concat(
RequiredAttendess.SelectedItems.Mail,
Mail & “;”
),

7. OptionalAttendees

optionalAttendees: Concat(
OptionalAttendess.SelectedItems.Mail,
Mail & “;”
),

8. Other Few Properties

isReminderOn: Reminder.Value,
reminderMinutesBeforeStart: 30,
responseRequested: ResponseRequested.Value

Complete “Create Calendar Invite” code

Office365Outlook.V4CalendarPostItem(
LookUp(
Office365Outlook.CalendarGetTables().value,
DisplayName = “Calendar”
).Name,
SubjectInput.Text,
Text(
DateAdd(
DateTimeValue(
StartDatePicker.SelectedDate & ” ” & TimeValue(
Concatenate(
StartHour.Selected.Value,
“:”,
StartMinute.Selected.Value
)
)
),
TimeZoneOffset(),
Minutes
),
“yyyy-mm-ddTHH:mm:ssZ”
),
Text(
DateAdd(
DateTimeValue(
EndDatePicker.SelectedDate & ” ” & TimeValue(
Concatenate(
EndHour.Selected.Value,
“:”,
EndMinute.Selected.Value
)
)
),
TimeZoneOffset(),
Minutes
),
“yyyy-mm-ddTHH:mm:ssZ”
),
“(UTC) Coordinated Universal Time”,
{
body: ‘Email Content’.HtmlText,
requiredAttendees: Concat(
RequiredAttendess.SelectedItems.Mail,
Mail & “;”
),
optionalAttendees: Concat(
OptionalAttendess.SelectedItems.Mail,
Mail & “;”
),
isReminderOn: Reminder.Value,
reminderMinutesBeforeStart: 30,
responseRequested: ResponseRequested.Value
}
)

Output

Demo

Common Issues and Solutions

Sending invite as UTC time
1. “(UTC) Coordinated Universal Time”
Convert time using TimeValue( to get the right format
1. TimeValue(Concatenate(EndHour.Selected.Value,”:”,EndMinute.Selected.Value
  ))
Use TimeZoneOffset
1. DateTimeValue(EndDatePicker.SelectedDate & ” ” & TimeValue(
  Concatenate(EndHour.Selected.Value,”:”,
  EndMinute.Selected.Value))),TimeZoneOffset(),Minutes),
Required Attendees are users so need to send email id with comma separators like
1. Concat(RequiredAttendess.SelectedItems.Mail,Mail & “;”),
You may get property like builtinicon:Mail, this means not accessing right property
1. For Example, Concat(RequiredAttendess.SelectedItems.Email,Mail&”;”). It should be
2. Concat(RequiredAttendess.SelectedItems.Email,Email&”;”)
Set DisplayFields and SearchFields for the Combobox
1. [“DisplayName”]

13 comments

Melanie says:

October 25, 2021 at 7:38 am

Hi There,
Has anyone experienced an issue with this? I have incorporated this as part of my PowerApp but now it seems to be loading multiple calendar invites into the owner’s calendar as a calendar entry is added to a user’s calendar. I have tried to remove this code in totally but it still seems to be doing the same.
Kindly advise.
Many thanks,
Melanie

Stalin Ponnusamy says:

October 25, 2021 at 4:36 pm

Hi Melanie,

Would you please validate a few things

1. Do you have any other “power automate” to create a calendar invite?
2. Do you have a ForAll loop or something?
3. Is it vary (No of entries) whenever you click it?

Thanks
Stalin

mohamed says:

April 14, 2022 at 4:37 pm

How can i add an attachment to the invite?

1. Stalin Ponnusamy says:
  
  April 15, 2022 at 10:26 am
  
  No option to send an attachment with an invite.
  
Yannick says:

July 18, 2022 at 7:01 am

Hi
i have a question regarding time picking, what type of input form did you use for it?

BR

1. Stalin Ponnusamy says:
  
  September 6, 2022 at 7:41 am
  
  For a time, it’s just a dropdown control. Items property of Hour will be [“00″,”01″,”02″,”03″,”04″,”05″,”06″,”07″,”08″,”09″,”10″,”11″,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,”22″,”23”] and
  
  Items property of Minutes will be [“00″,”01″,”02″,”03″,”04″,”05″,”06″,”07″,”08″,”09″,”10″,”11″,”12″,”13″,”14″,”15″,”16″,”17″,”18″,”19″,”20″,”21″,”22″,”23″,”24″,”25″,”26″,”27″,”28″,”29″,”30″,”31″,”32″,”33″,”34″,”35″,”36″,”37″,”38″,”39″,”40″,”41″,”42″,”43″,”44″,”45″,”46″,”47″,”48″,”49″,”50″,”51″,”52″,”53″,”54″,”55″,”56″,”57″,”58″,”59”]
  
Mike says:

November 17, 2022 at 10:05 am

Hi sir, I´m very appreciated for your contribution, is really nice. I have an issue when I send the Calendar Invite. The message error is: String was not recognized as a valid DateTime, status 400. Could you tell me how to fix this error?. My code is exactly as yours. Thanks in advance

1. Stalin Ponnusamy says:
  
  November 17, 2022 at 12:09 pm
  
  Hi Mike,
  
  Not sure what changed in the last eight months. It’s expected in UTC format now. I updated the post to reflect it.
  
  Solution: We have to convert to UTC format like
  Text(
  DateAdd(
  DateTimeValue(
  StartDatePicker.SelectedDate & ” ” & TimeValue(
  Concatenate(
  StartHour.Selected.Value,
  “:”,
  StartMinute.Selected.Value
  )
  )
  ),
  TimeZoneOffset(),
  Minutes
  ),
  “yyyy-mm-ddTHH:mm:ssZ”
  ),
  
Emily says:

January 11, 2023 at 5:18 pm

Thanks for posting! Is this the only way to get around the connector issue of someone other than the owner being logged into the PowerApp? I have an app connected to the Create Event (v4) and the flow fails when anyone but me runs it.

1. Stalin Ponnusamy says:
  
  January 11, 2023 at 7:55 pm
  
  Hi Emily,
  
  Please create a service account that has more access (Privileged). Update the connector with that service account.
  
  1. Emily says:
    
    January 11, 2023 at 8:35 pm
    
    Thank you for replying so quickly!
    
C says:

January 13, 2023 at 6:57 pm

How do to set it for all day? When I use the optional parameter, it says the duration of an event marked as all day must be 24 hrs. I didn’t provide a time just a date.

1. Stalin Ponnusamy says:
  
  January 13, 2023 at 9:55 pm
  
  Hi C,
  
  I hope all day calendar event is covered in this post: https://learntoilluminate.com/2022/11/powerapps-create-an-all-day-calander-event-for-microsoft-group/
  
  Please check section “Scenario 2:”
  
  Please let me know if still an issue.