Power Platform Community Forum Thread Details

Hello,

I have an Employees information list that contains the following columns:
Name(Person or Group); Emp Number (Single line of text).

Another list that contains also Name(Person or group) and Emp Number(Lookup that gets information from the Emp number in Employees information list) and I am customizing this list using PowerApps forms.

What I want to achieve is the following:

I want to populate in the form the Name and Emp number of the employee based on the current user signed in.

I was able to Lookup and populate the current user signed in, but unfortunately, I am still struggling to populate the EMP number of this current employee.

The DefaultSelectedItems property of the Employee Name Combobox is the following:

{ 
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", 
 Claims: "i:0#.f|membership|" & Lower(User().Email), 
 Department: "", 
 DisplayName: User().FullName, 
 Email: LookUp('Employees Information',Name = User().Email).'Employee Name', 
 JobTitle: ".", 
 Picture: "." 
 }

The DefaultSelectedItems property of the EMP.NO Combobox is the following, and the error is the Expected table value and invalid argument type.

LookUp('Employees Information', 'EMP.NO' = DataCardValue2.Selected.DisplayName).Title

(I have used Title in the end because I have renamed the column to Emp NO in the employee's information list).

Please have a look at the below screenshots: