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

Set Required Attendees from combo box

I am creating a button to invite attendees to a Teams meeting.

 

Combo box items (cbStaffEmailInvite) is list of staff email addresses.

Code for OnSelect button includes:

{requiredAttendees: Concat(cbStaffEmailInvite.SelectedItems, Mail,";"),

 

Whole optional code is:

{requiredAttendees:Concat(cbStaffEmailInvite.SelectedItems, Mail,";"),
reminderMinutesBeforeStart: 30,
isReminderOn: true}

 

Not sure what the Mail does but I got it from Shane's video.

 

Anyone have an idea how to make this work.

3 REPLIES 3
Community Support
Community Support

Hi@slhangen,

Do you want to create event using the Office365Outlook?

Could you please share a bit more about the scenario:

  1. what is the column type in your SP list including staff email addresses, Person or Choice or any other?(Important!)
  2. do you want to send email to required attendees?
  3. how you set the Items property of the combo box?

I have a test on my side, please take a try as below:

Office365Outlook.V4CalendarPostItem(
    LookUp(
        Office365Outlook.CalendarGetTables().value,
        DisplayName = "Calendar Name",
        Name
    ),
    "Test Subject",
    DatePicker1.SelectedDate,
    DatePicker2.SelectedDate,
    "(UTC-06:00) Central Time (US & Canada)",
    {
        requiredAttendees: Concat(
            ComboBox1.SelectedItems.Mail,
            Mail,
            ","
        ),
        reminderMinutesBeforeStart: 30,
        isReminderOn: true
    }
)

Please check if it helps.

Regards,

Qi

Thanks Qi so much for taking your time to help.

 

Do you want to create event using the Office365Outlook?

I am trying to create a button that allows user to schedule a MS Teams meeting.  

 

Could you please share a bit more about the scenario:

  1. what is the column type in your SP list including staff email addresses, Person or Choice or any other?(Important!)
    1. Combo box cbStaffEmailInvite has items: '2021 Staff Directory'.StaffEmail
    2. This is a SP list with staff emails, not sure how to determine column type.
      1. I really wanted to use a people picker (from my org) but couldn't figure out how to do it.
  2. do you want to send email to required attendees?
    1. Yes
  3. how you set the Items property of the combo box?
    1. '2021 Staff Directory'.StaffEmail

Code for the button is as follows:

Set(varNextMeeting,
MicrosoftTeams.CreateTeamsMeeting(
LookUp(Office365Outlook.CalendarGetTables().value, DisplayName= "Calendar").Name,
varSelStudentFirstName&" "&varSelStudentLastName&" Follow-Up Meeting",
{content: "Please confirm your attendance for "&varSelStudentFirstName&"'s "&"follow-up meeting.", contentType: "HTML"},
"Central Standard Time",
{dateTime: DateTimeValue(dpNextMeetingDate.SelectedDate&" "&dpNextMeetingHour.SelectedText.Value&":"&dpNextMeetingMinute.SelectedText.Value&dpNextMeetingAP.SelectedText.Value)},
{dateTime: DateTimeValue(dpNextMeetingDate.SelectedDate&" "&dpNextMeetingHour.Selected.Value&":"&dpNextMeetingMinute.SelectedText.Value&dpNextMeetingAP.SelectedText.Value)},
true,
"teamsForBusiness",
{requiredAttendees:Concat(cbStaffEmailInvite.SelectedItems, Mail,";"),
reminderMinutesBeforeStart:30,
isReminderOn:true}
)
)

 

Thx again for your help!

One thing I see, when I click on the event the attendee field says builtinicon:Mail

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (17,240)