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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jchammons ,

Please try this

Best Regards,

Wearsky

Was this reply helpful? Yes No
jchammons on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
jchammons on at

Like (0)

Report
Copy link

Link copied!

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