Answered

Auto populate columns based on people picker

(1) Share

Report

Posted on by dhlp26

Hello community, I have searched but not everyone else's use cases met my own. None the less I feel like this SHOULD be super simply, but I am unable to find it out. Maybe I spend too much time in Power Automate, none the less, I am attempting to customize a sharepoint form in power apps and auto populate other fields based on the user selected in the people picker. Those other fields being department, email, etc.

What is the best way to approach this? I am using the Office365user connector to pull the user info. For like the Department column is there a get info based on the people picker choice? If there is another article that I may have missed if you could please drop it here for my to read.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

gazzo1967 1,151 on at

Like (0)

Report

@dhlp26
The simple answer to this is yes

Lets say combobox1 is your people picker
your next textinput in the default put combobox1.selected.department, if its a Label put it in the text field
or textinput in the default put combobox1.selected.email, if its a Label put it in the text field

Gary
If it helps make as accepted so others can find the answer 🙂

Was this reply helpful? Yes No
dhlp26 14 on at

Like (0)

Report

When I select customize forms, it appears as a datacard vs combobox. Can I change that or should I just create my on form from scratch vs leveraging the columns in sharepoint.

Was this reply helpful? Yes No
gazzo1967 1,151 on at

Like (0)

Report

@dhlp26
What is it you want to do?
Are you linked to a sharepoint list?

Was this reply helpful? Yes No
dhlp26 14 on at

Like (0)

Report

Yes this is linked to a sharepoint list, I just wanted for when a user searches for someone via people picker in SharePoint, that it autopopulates the other fields. Similar to how we have it in some of our older infopath forms.

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Hi,

Where you are using Office365Users, use DataCardValue4 (from your image below) like so:

Office365Users.UserProfileV2(DataCardValue4.Selected.Email).displayName

or

Office365Users.UserProfileV2(DataCardValue4.Selected.Email).companyName

or etc.

You can also do this a more efficient way by setting a variable to Office365Users.UserProfileV2(DataCardValue4.Selected.Email) every time the DataCardValue4 OnChange is called, but if just using the lookups works for you then maybe stick with that, happy to explain about the variable if you'd like to know more,

Cheers,

Sancho

Was this reply helpful? Yes No
gazzo1967 1,151 on at

Like (0)

Report

@dhlp26
For me just depends on the detail and how simple you want your app.
If it just the department and email that you want to show i would just put 2 labels in the same card as DAtacardvalue4
and use
Datacardvalue4.selected.email
Datacardvalue4.selected.department and you don't need to use the Office users connector

just depends on what you want 🙂
Gary
If it helps make as accepted so others can find the answer

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have a form created using the same datacardvalue to get info for Employees, but after its submitted a deep link is sent out for approval. but when i click on the link it shows all data BUT the datacards that i put that info, such as combobox1.selected.Displayname. it still records it in the dataverse but can't see it in deep link. please help!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have a form created using the same datacardvalue to get info for Employees, but after its submitted a deep link is sent out for approval. but when i click on the link it shows all data BUT the datacards that i put that info, such as combobox1.selected.Displayname. it still records it in the dataverse but can't see it in deep link. please help!

Was this reply helpful? Yes No