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
}
);
Solved! Go to 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
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
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 & "; ")
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
198 | |
100 | |
59 | |
59 | |
55 |
User | Count |
---|---|
258 | |
161 | |
90 | |
79 | |
70 |