Answered

Copy the label field to Combo Box. Data are from Sharepoint List.

(0) Share

Report

Posted on by -aj

120

I have a Person Column in my Sharepoint list. I set this as Person because I need to use this in a custom view filter using [Me].

In my App, I want to look up the Person (manager) from another Combo Box (employee - ComboBox1). The data are coming from Office365Users.

Office365Users.ManagerV2(ComboBox1.Selected.Mail).displayName

- this formula is not working for me.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @-aj ,

What is not working ? I just copied this

Office365Users.ManagerV2(ComboBox1.Selected.Mail).displayName

onto a Label with my email selected in a Combo Box with the Items

Office365Users.SearchUser({searchTerm:Self.SearchText, top:999})

and received my manager's name in the label.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
If you are using the person column in SharePoint, then the property should be "Email" and not "Mail".

Example:

If(IsBlank(ComboBox1.Selected.Email), "", Office365Users.ManagerV2(ComboBox1.Selected.Email).displayName)
-aj 120 on at

Like
a
(0)

Report
Copy link

Link copied!

Im getting this error message.

Your formula is working on Text Label but not on Combo Boxes.
-aj 120 on at

Like
a
(0)

Report
Copy link

Link copied!
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
If you want to the manager value to show up in a SharePoint person combo box then it needs to be in a record format that SharePoint expects.

Try something like this in the DefaultSelectedItems property of the Manager combo box.

If( IsBlank(ComboBox1.Selected.Selected.Email), Blank(), With( {_manager: Office365Users.ManagerV2(ComboBox1.Selected.Selected.Email)}, { Claims: Concatenate( "i:0#.f|membership|", _manager.userPrincipalName ), DisplayName: _manager.displayName, Email: _manager.mail } ) )
-aj 120 on at

Like
a
(0)

Report
Copy link

Link copied!
Looks like I got it to work. Made some changes here - from

ComboBox1.Selected.Selected.Email
to
ComboBox1.Selected.Mail