Using a Combobox multiple select to PATCH email address to a person column

[KyleJackDaniel1]

Hello,

I have a combobox which has a list of, Office356Users, and what I would like is for my users to select multiple email addresses or groups and to PATCH them to my SharePoint list under 'Email Reminders' which is a Persons or Group column (multiple select enabled).

I though it would just be a case of using 'cbox_Add_Email.Selected.Value' but that's not working.

Any help would be appreciated.

Thank you

[StretchFredrik]

A person column expects the following format:

{
        DisplayName: User().FullName;
        Claims: "i:0#.f|membership|" & User().Email;
        Department: "";
        Email: User().Email;
        JobTitle:"";
        Picture:User().Image
    }

[KyleJackDaniel1]

Thank you, I'v seen this online however not quite sure how to implement it into the Patch function. 

Here is my PATCH code, how would I make it so it would do that Person column requirements?

Patch(
    'Calendar Events',
    Table(
        {
            ID: varCurrentEvent.ID,
            Title: txt_Add_Title.Text,
            'Start Date': date_Add_Start_Date.SelectedDate,
            'Start Time':drp_Add_Start_Time.Selected.Value,
            'End Date': date_Add_End_Date.SelectedDate,
            'End Time': drp_Add_End_Time.Selected.Value,
            'All Day': cbox_Add_All_Day.Value,            
            'Make Recurring': cbox_Add_Recurring.Value,
            'Recur Every': txt_Add_RepeatDays.Text,
            'Recur Frequency': drp_Add_Frequency.SelectedText,
            'End Recurrence': radio_Add_End.Selected.Value,
            Description: txt_Add_Description.Text,
            'Create Reminder': cbox_Add_Reminder.Value,
            Category: cbox_Add_Category.Selected,
            'Email Reminder': cbox_Add_Email_Address.SelectedItems.Mail //This is the persons column
        }
    )
);

[StretchFredrik · Accepted solution]

Like this should work:

Patch(
    'Calendar Events',
    Table(
        {
            ID: varCurrentEvent.ID,
            Title: txt_Add_Title.Text,
            'Start Date': date_Add_Start_Date.SelectedDate,
            'Start Time':drp_Add_Start_Time.Selected.Value,
            'End Date': date_Add_End_Date.SelectedDate,
            'End Time': drp_Add_End_Time.Selected.Value,
            'All Day': cbox_Add_All_Day.Value,            
            'Make Recurring': cbox_Add_Recurring.Value,
            'Recur Every': txt_Add_RepeatDays.Text,
            'Recur Frequency': drp_Add_Frequency.SelectedText,
            'End Recurrence': radio_Add_End.Selected.Value,
            Description: txt_Add_Description.Text,
            'Create Reminder': cbox_Add_Reminder.Value,
            Category: cbox_Add_Category.Selected,
            'Email Reminder': {
        DisplayName: cbox_Add_Email_Address.SelectedItems.FullName;
        Claims: "i:0#.f|membership|" & cbox_Add_Email_Address.SelectedItems.Mail;
        Department: "";
        Email: cbox_Add_Email_Address.SelectedItems.Mail;
        JobTitle:"";
        Picture:""
    } 
        }
    )
);

[KyleJackDaniel1]

Oh I see just like that!

Thank you very much