Patch Sharepoint "Person or Group" column with Office365 list from Combo Box

(0) Share

Report

Posted on by jchammons

I am trying to Patch a Sharepoint "Person or Group" column with Office365 Users from Combo Box.

The Combo Box "Items" code is as follows and works to search Users from the Office 365 connector:

Filter(Office365Users.SearchUserV2(

{

searchTerm:Trim(Self.SearchText),

isSearchTermRequired:false

}

).value,AccountEnabled=Not("#EXT" in UserPrincipalName

))

DefaultSelectedItems =

It is blank

My Patch function is as follows but does not work. Specifically the Combo box is causing the error:

Patch('Front Desk Messages',

Defaults('Front Desk Messages'),

{

Title:txt_ContactName.Text,

'OSARC Contact':cmb_OSARC.Selected.DisplayName,

'Contact Date':Date_Contact.SelectedDate,

'Contact Time':txt_ContactTime.Text,

'Contact Phone No':txt_ContactNumber.Text,

'Contact Email':txt_ContactEmail.Text,

'Contact Message':txt_ContactMessage.Text

}

);

Reset(txt_ContactName);

Reset(cmb_OSARC);

Reset(Date_Contact);

Reset(txt_ContactTime);

Reset(txt_ContactNumber);

Reset(txt_ContactEmail);

Reset(txt_ContactMessage)

I also attached another patch function that I have tried. Nothing seems to work.

Categories:

General Questions

Using Apps Using Formulas

Capture3.JPG

Capture2.JPG

Capture4.JPG

All responses (3)

Answers (0)

jchammons on at

Like (0)

Report

Re: Patch Sharepoint "Person or Group" column with Office365 list from Combo Box

Figured it out. For some reason, nothing likes the this part of the patch. Seems to not recognize the ".Mail" part.
Email: cmb_OSARC.Selected.Mail

Also I turned it into a "TABLE". It patches the Sharepoint Column and also my PowerAutomate works as well. The PowerAutomate sends an email to the person selected in the Combo Box.

Patch('Front Desk Messages',
Defaults('Front Desk Messages'),
{
Title:txt_ContactName.Text,
'OSARC Contact':
Table(
{
Claims:"i:0#.f|membership|" & Lower(cmb_OSARC.Selected.DisplayName),
Department: "",
DisplayName: cmb_OSARC.Selected.DisplayName,
Email: cmb_OSARC.Selected.DisplayName,
JobTitle: "",
Picture: ""
}
),
'Contact Date':Date_Contact.SelectedDate,
'Contact Time':txt_ContactTime.Text,
'Contact Phone No':txt_ContactNumber.Text,
'Contact Email':txt_ContactEmail.Text,
'Contact Message':txt_ContactMessage.Text
}
);
Reset(txt_ContactName);
Reset(cmb_OSARC);
Reset(Date_Contact);
Reset(txt_ContactTime);
Reset(txt_ContactNumber);
Reset(txt_ContactEmail);
Reset(txt_ContactMessage)
jchammons on at

Like (0)

Report

Re: Patch Sharepoint "Person or Group" column with Office365 list from Combo Box

No luck with anything I do. See attached and below code.

Patch('Front Desk Messages',
Defaults('Front Desk Messages'),
{
Title:txt_ContactName.Text,
'OSARC Contact':
{
Claims:"i:0#.f|membership|" & Lower(cmb_OSARC.Selected.Mail),
Department: "",
DisplayName: cmb_OSARC.Selected.DisplayName,
Email: cmb_OSARC.Selected.Mail,
JobTitle: "",
Picture: ""
},
'Contact Date':Date_Contact.SelectedDate,
'Contact Time':txt_ContactTime.Text,
'Contact Phone No':txt_ContactNumber.Text,
'Contact Email':txt_ContactEmail.Text,
'Contact Message':txt_ContactMessage.Text
}
);

Reset(txt_ContactName);
Reset(cmb_OSARC);
Reset(Date_Contact);
Reset(txt_ContactTime);
Reset(txt_ContactNumber);
Reset(txt_ContactEmail);
Reset(txt_ContactMessage)

Capture5.JPG
v-xiaochen-msft on at

Like (0)

Report

Re: Patch Sharepoint "Person or Group" column with Office365 list from Combo Box

Hi @jchammons ,

Please try this

Best Regards,

Wearsky