on a form, when selecting a user from a Person field, have another field populate with their employee ID.

[Pxtavern]

Hi

I've only been using PowerApps for a few weeks but I am having trouble figuring this one out.

I have a Powerapps form with a field for selecting user, and another field for inputting their employee I.D. When submitted this sends data to a SharePoint list

On another SharePoint list I have a person field and there Employee number stored.

What I want is with that original list, when a user enters their email address I want that Employee number to auto populate based on the second SharePoint list. Is that possible? Or is their an easier way.

Any help would be very much appreciated 

[AmDev]

Hi @Pxtavern 

Try the following in the 'Default' property of the ID control:

Lookup(EmployeeList, EmployeeDropdown.Selected.Value = Employee.Email, Employee ID)

Might need to interchange this with .Email

[Pxtavern]

Hi

Thanks for your quick reply. I am a little stuck so so far this all makes sense to me:

Lookup(EmployeeList, EmployeeDropdown.Selected.Value = Employee.Email, Employee ID)

Lookup('OCR Claimant List', EmployeeChoice_2.Selected.Email =...

I am stuck on that second part, what needs to go here? Employee.Email, Employee ID)

My Column names on the OCR Claimants list are "Name"(Person field) and Employee ID ( Text field) 

Are they want goes here?

[AmDev]

Hi @Pxtavern 

Try: Lookup('OCR Claimant List', EmployeeChoice_2.Selected.Email = Name.Email, Employee ID)

You are essentially looking up your list for the record/row where the email in your drop down matches the email in your name column and once that's found, produce the result based on you Employee ID column)

Hope this clarifies

[Pxtavern]

I thought that was the case, it comes up with an error, so as far as I can tell it should read as:

Lookup('OCR Claimant List', EmployeeChoice_2.Selected.Email = Name.email, Employee id)

but when typing in the = name.email it isn't auto looking up the fields from the SharePoint list.

Any idea?

[AmDev]

Can you provide details of the error?

Also, make sure the capitalisation matches (i.e. it should be  = Name.Email)

If this is still failing, can you provide a screen shot of the edit column settings for your 'Name' Column?

[Pxtavern]

So Name.Email comes up with - Invalid use of "." and if I fill out the whole code it says on the error pop up:

Which as far as I can tell means it isn't finding those columns, although it is 100% the correct spelling/ capitals as I have copied from the SharePoint URL for that Column.

P.S Thank you for your help so far 

[AmDev]

Thanks - Can you go to the Name column in your sharepoint list, go to 'column settings\edit\expand more options' and take a screen shot?

[Pxtavern]

Heres the details 

[AmDev]

Is this potentially a new column you have added recently while you had the app open and you just need to refresh the dataset? 

If not, Can you do a ClearCollect(colTEST, First(YourDataSource)) and then go to view\collections and try to find the name column and open the nested table to make sure all the person attributes are there?

Thanks