SharePoint Person record in Combobox

(0) Share

Report

Posted on by petewalburn

185

Hi,

I have a SharePoint list with a Person column in it.

In my app I have a combobox control which displays the selected person.

I populate this by setting the DefaultSelectedItems property to:

{'odata.type':"#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & Lower(recFNCR.'FNCR Initiator'.Email),
DisplayName:recFNCR.'FNCR Initiator'.DisplayName,
Email:recFNCR.'FNCR Initiator'.Email,
Department:recFNCR.'FNCR Initiator'.Department,
Title:recFNCR.'FNCR Initiator'.JobTitle,
Picture:""
}

Elsewhere in the app, I am setting the Visible property of a control to:

If(cboReportedBy.Selected.Mail=_sUserMail,true,false)

where _sUserMail is set up when the app is loaded to store the logged in users email. This is so that certain controls are only visible if the logged in user is the user who created the record in the first place.

However, the cboReportedBy.Selected.Mail is blank. How do I save the email of the user in the Person record and the combo box control?

Any help, much appreciated.

Pete

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @petewalburn ,
I have done just a simple modifiation in your formula (replaced Email with Mail) -

{'odata.type':"#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(recFNCR.'FNCR Initiator'.Email), DisplayName:recFNCR.'FNCR Initiator'.DisplayName, Mail:recFNCR.'FNCR Initiator'.Email, Department:recFNCR.'FNCR Initiator'.Department, Title:recFNCR.'FNCR Initiator'.JobTitle, Picture:"" }

Was this reply helpful? Yes No
Verified answer

petewalburn 185 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I have actually changed the DefaultSelectedItems of the control to:
First(Office365Users.SearchUserV2({searchTerm:recFNCR.'FNCR Initiator'.Email}).value)
and now everything seems to work fine.

Pete

Was this reply helpful? Yes No