Forum Discussion
Creating an App from a SharePoint List
I am new to PowerApps and trying to learn how it works. I created a 3 screen app from a SharePoint list. One of the columns in the SharePoint list is a person field. When I execute the app, it provides a people picker from the edit screen that works well. How can I get the email for the person that is selected? At present the display name is returned but I also want to automatically load the email address of the person selected to another column in the list. Any advice would be much appreciated. Also, samples of syntax/code would be helpful. Thank you, Mark
Mark Thomas in the screenshot below I've got the people picker dropdown which I've renamed to ddEmployee (not the card, just rename the control). There's also the EmployeeEmail from the SharePoint list. I've renamed the control for that to txtEmployeeEmail - it's always a good idea to rename your controls so you know what they are as the app gets more complex!
All you need to do to display the selected employee's email address is to click in the txtEmployeeEmail control and select default from the properties bar above and enter ddEmployee.Selected.Email
When you change the selected employee the email address will change.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
2 Replies
Mark Thomas in the screenshot below I've got the people picker dropdown which I've renamed to ddEmployee (not the card, just rename the control). There's also the EmployeeEmail from the SharePoint list. I've renamed the control for that to txtEmployeeEmail - it's always a good idea to rename your controls so you know what they are as the app gets more complex!
All you need to do to display the selected employee's email address is to click in the txtEmployeeEmail control and select default from the properties bar above and enter ddEmployee.Selected.Email
When you change the selected employee the email address will change.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Hi Rob, That works perfectly. Thank you for your assistance.
Regards,
Mark
