How to Create a Outlook Calendar Event and Invite multiple attendees (requiredAttendees)

[hkmamun]

I am creating Outlook event from Power Apps, taking input from SharePoint List. In the list I have a Participant column which is Person Type and allow multiple value. I am using Office365Outlook.V4CalendarPostItem() function. How i can set/combine the value for requiredAttendees parameter from Participant column?

My sample code:

Office365Outlook.V4CalendarPostItem(
"Calendar",
txtTitle.Text,
dtpStartDate.SelectedDate + Time(Value(ddlStartHour.Selected.Value), Value(ddlStartMinute.Selected.Value), 0),
dtpEndDate.SelectedDate + Time(Value(ddlEndHour.Selected.Value), Value(ddlEndMinute.Selected.Value), 0),
"(UTC+06:00) Dhaka",
{
body:txtDescription.Text,
location:cbLocation.Selected.Value,
requiredAttendees:cbParticipants.SelectedItems.Email
}
);

[hkmamun · Accepted solution]

I have solved this issue by using Concat() function. Below is my code

requiredAttendees:Concat(cbParticipants.SelectedItems, Email & "; ")

NOTE: Here cbParticipants is the name of the ComboBox I am using to select Person Type value in Power Apps

[MarvinBangert]

Hey @hkmamun 

have you tried using

cbParticipants.Selected.Email

instead of 

cbParticipants.SelectedItems.Email

Then all selected users within cbParticipants should be invited as required attendees.

Hope this helps you! 🙂

Regards

Marvin

[hkmamun]

Hi @MAR 

cbParticipants.Selected.Email  will select only one value

the problem is solved by using below code which is selecting multiple items

Concat(cbParticipants.SelectedItems, Email & "; ")