
Announcements
I'm trying to update a power app that submits a form to a SharePoint list. One of the fields in the form is "Employee" which is a dropdown selection of an Employee column in the SharePoint list which is a People and Groups field. On submit, this writes the selected employee to the "Employee" column in SharePoint along with all the other form fields into their respective columns.
What I'm trying to do is have an additional column for the employee's department. The best (only) way I found to do this is add another People and Groups column and have it display the Department attribute (the Employee column displays the Display Name attribute). To avoid input redundancy, I want to have the Employee Dept data card value update with the Employee data card selection, but it is blank every time I submit the form. I have both data cards set with the same Update value but the Employee Dept data card is not writing anything to the SharePoint list. Below is what I have set for the Employee data card which works fine:
So, I figured I could use the same variable in the Update field for my Employee Dept data card, but that did not seem to work.
@joliverkc - your set up looks fine to me and this is not a problem I can replicate in my environment.
Is there a need to capture the department attribute onto a separate People data type, when you can simply save that information onto a separate Single Line Text column? You can then use the below on the Update property of that Single Line Text DataCard:
EmployeeValue.Selected.Department