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:

Building Power Apps

Capture3.JPG

Capture2.JPG

Capture4.JPG

I have the same question (0)

All responses (3)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @jchammons ,

Please try this

Best Regards,

Wearsky

Was this reply helpful? Yes No
jchammons on at

Like (0)

Report

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

Was this reply helpful? Yes No
jchammons on at

Like (0)

Report

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)

Was this reply helpful? Yes No