cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frankie70
Post Patron
Post Patron

Value from PeoplePicker not present

Hi all,

I've a peoplepicker in PowerApps and some field that show additional data from the choosen/selected person i.e. companyname, location...

I would like to display the value for the street as well, but street is not offered.

What do I need to do to / check?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Frankie70 ,

1)Firstly, please create connection with office365 users.

2)since you set the combo box items to Office365Users.SearchUser function, so you need to make some changes.

set company textinput's Default like this:

Office365Users.UserProfileV2(ComboBox3.Selected.Mail).companyName

set city textinput's Default like this:

 

Office365Users.UserProfileV2(ComboBox3.Selected.Mail).city

 

set country textinput's Default like this:

 

Office365Users.UserProfileV2(ComboBox3.Selected.Mail).country

//please replace with your combo box name.

 

 

Best regards, 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
eka24
Super User
Super User

Do you want to show street on the people picker or you want it in a Textbox.

Also kindly show a screenshot of the Drop-down items property

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi @eka24 

Frankie70_0-1595940281090.png

All field are filled perfectly, but not the street...because I can not find it...

Frankie70_1-1595940402993.png

 

Kind regrads

Frank

Hi @Frankie70 ,

Do you want to get street value from person field?

The reason why you could not directly get these values from person field is that person field does not include those values.

Person field only includes these fields:
Department, DisplayName, Email, JobTitle

Date like company,street,city, country are all not included.

To get these data by using person field, you need to use Microsoft 365 Users connector and Microsoft365Users.UserProfileV2 function, which will return a table includes these fields: company,street,city, country.

 

Please notice that: Microsoft365Users.UserProfileV2 function will return the user's profile in his azure ad profile. 

If his azure ad profile does not has these data, you will still get blank value.

 

You should set like this:

1)connect with Microsoft 365 Users 

2)set the person field's Items:

Choices(listname.personfieldname)

3)set company textinput's Default like this:

Microsoft365Users.UserProfileV2(comboboxname.Selected.Email).companyName

set city textinput's Default like this:

 

Microsoft365Users.UserProfileV2(comboboxname.Selected.Email).city

 

set country textinput's Default like this:

 

Microsoft365Users.UserProfileV2(comboboxname.Selected.Email).country

 

 

 

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yutliu-msft 

thank you very much for your answer. Somehow it does not work for me.

I have a combobox configured like this:

Frankie70_0-1596012447796.png

And in a textinput box I would like to show the users street name.

I guess I need to modify combobox setting. Can you give me a hint?

 

 

Hi @v-yutliu-msft 

Microsoft365Users.UserProfileV2 function seems not available...

 

Frankie70_0-1596012711581.png

 

@Frankie70 ,'

You need to add it as a data source in Connectors.

 

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.

Hi @Frankie70 ,

1)Firstly, please create connection with office365 users.

2)since you set the combo box items to Office365Users.SearchUser function, so you need to make some changes.

set company textinput's Default like this:

Office365Users.UserProfileV2(ComboBox3.Selected.Mail).companyName

set city textinput's Default like this:

 

Office365Users.UserProfileV2(ComboBox3.Selected.Mail).city

 

set country textinput's Default like this:

 

Office365Users.UserProfileV2(ComboBox3.Selected.Mail).country

//please replace with your combo box name.

 

 

Best regards, 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,479)