Linking two Sharepoint lists in edit form using a lookup

Like (0) Share

Report

Posted on 16 Oct 2020 18:32:18 by Sarah4

Hello everyone,

I am fairly new to Power Apps and I need your help.

I have two Sharepoint lists. One is called 'Order form' and has following fields/columns: Order date, Employee number, Employee name, Cost center, Job description, Clothes, Amount, Size, etc. This list is currently empty and will be filled with the data coming from the Powerapp form. The other list is called 'Personnel list' and has following fields: Employee number, Employee name and Cost center.

I've already created a Power Apps based on the fields of the 'Order form' list. In the EditForm people have to fill in the Employee number (this is unique for each employee). This Employee number field has already been linked to the 'Personnel list', so people can choose one of the Employee numbers stored in that list via a dropdown. However, I would like the Employee's name and his/her Cost center to appear automatically in the EditForm when someone selects a certain employee number.

Does anyone know how to accomplish this?

Personnel list is updated each week. Is that problematic?

Thanks in advance!

Sarah

Categories:

Connecting to Data

Connectors

General Questions

All responses (4)

Answers (1)

Sarah4 10 on 20 Oct 2020 at 19:02:20

Like (0)

Report

Re: Linking two Sharepoint lists in edit form using a lookup

Hey,

I was able to solve it. Thank you very much!

Kind regards,
Sarah
Sarah4 10 on 20 Oct 2020 at 18:59:28

Like (0)

Report

Re: Linking two Sharepoint lists in edit form using a lookup

Tried it at work today and it works!

Thank you very much!

Kind regards,
Sarah
v-yutliu-msft on 19 Oct 2020 at 10:04:02

Like (1)

Report
Re: Linking two Sharepoint lists in edit form using a lookup

Hi @Sarah4 ,

Do you want to get related Cost center value based on the selection of Employee number?

Could you tell me:

1)whether Employee number field is lookup type in 'Order form' list or not?

2)what is Cost center field data type in 'Personnel list'?

3)where do you want to display the related Cost center value?

I assume that yes and display in a label.

If so, you could set like this:

1)the drop down's Items for Employee number field:

Choices('Order form'.'Employee number')

2)label's Text for Cost center:

LookUp('Personal List', 'Employee Number'=Dropdown1.Selected.Value ,'Cost center')

Best regards,
Verified answer

eka24 20,921 on 16 Oct 2020 at 21:08:28

Like (1)

Report

Re: Linking two Sharepoint lists in edit form using a lookup

You can use Lookup function to achieve that. In the field which the name will populate, put in the default;

LookUp('Personal List', ' Employee Number=Dropdown1.Selected.Value ,'Employee Name')

Or

LookUp('Personal List', ' Employee Number=Dropdown1.Selected.'Employee Numbet' ,'Employee Name')

Am assuming you are using a Dropdown to select the employee number

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.