Hi Team,
I have an onboarding application which uses the datasource as sharepoint list. Currently there are 4 person/group field in powerapp.
1. employee details
2. Manager Details
3. Trainer details
4. Process trainer.
As the below screenshot
Currently all these columns are entered manually. My current requirement is that the Manager feild should be populated automatically based on employe details.
For example- If I am the new joiner the moment I select/enter my account/name in the Employee details it should automatically pop up the manager email without needing me to enter the manager details manually.
Currently I have the below connectors as in screenshot
thanks in advance
Regards
Priya
Solved! Go to Solution.
Hi @Priyasantra ,
Do you want to automatically populate a person field(Manager Details) based on selection of another person field(Employee Details)?
Could you tell me whether these two person field allows multiple selections?
I assume that no.
You could set like this:
1)combo box's Items for Employee Details:
Choices(listname.'Employee Details')
2)combo box's Items for Manager Details:
Choices(listname.'Manager Details')
DefaultSelectedItems:
If(!IsBlank(employeecomboboxname.Selected.Email),{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"&Office365Users.ManagerV2(employeecomboboxname.Selected.Email).mail,
Department:"",
DisplayName:Office365Users.ManagerV2(employeecomboboxname.Selected.Email).displayName,
Email:Office365Users.ManagerV2(employeecomboboxname.Selected.Email).mail,
JobTitle:"",
Picture:""
})
this datacard's Update:
managercomboboxname.Selected
Best regards,
Hi! I think for the start of your issue this video will be very helpful!
Cascading Dropdown (Shane Young)
https://www.youtube.com/watch?v=pkZG2boN7jQ
As far as the second part of your question you can set the value to lookup based on the value of the dropdown above. Maybe something like this?
If(IsBlank(Lookup(yourdatasource,employeedetailsinsharepoint=employeedetailsinpowerapps,manageremailcolumninsharepoint),manageremailcolumninsharepoint,false)
Hi @Priyasantra ,
Do you want to automatically populate a person field(Manager Details) based on selection of another person field(Employee Details)?
Could you tell me whether these two person field allows multiple selections?
I assume that no.
You could set like this:
1)combo box's Items for Employee Details:
Choices(listname.'Employee Details')
2)combo box's Items for Manager Details:
Choices(listname.'Manager Details')
DefaultSelectedItems:
If(!IsBlank(employeecomboboxname.Selected.Email),{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"&Office365Users.ManagerV2(employeecomboboxname.Selected.Email).mail,
Department:"",
DisplayName:Office365Users.ManagerV2(employeecomboboxname.Selected.Email).displayName,
Email:Office365Users.ManagerV2(employeecomboboxname.Selected.Email).mail,
JobTitle:"",
Picture:""
})
this datacard's Update:
managercomboboxname.Selected
Best regards,
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
81 | |
50 | |
37 |
User | Count |
---|---|
290 | |
244 | |
122 | |
74 | |
55 |