cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hkmamun
Helper II
Helper II

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

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
}
);

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
hkmamun
Helper II
Helper II

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

 

View solution in original post

3 REPLIES 3
hkmamun
Helper II
Helper II

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

 

View solution in original post

MarvinBangert
Solution Supplier
Solution Supplier

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

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 & "; ")

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,151)