How to connect info from 2 SharePoint lists?

Question

Hi everyone!

I'm working with 2 SharePoint Lists, one of them is filled by a MS Forms, and the other one, has complementary info. The info I'm working with is a 1:1 relation.

Is there a way to relate automatically information between 2 Lists, just like a VLOOKUP in Excel?

I found a manual way to do that, by selecting "Lookup" on the Create Column options. The problem is, this form will get about 50 answers by day.

For example:

List 1:

Name of employee: "Filled by Forms"

Register Number: "get automatically from List 2"

Date of birth: "get automatically from List 2"

List 2:

Name of employee: database

Register Number: database

Date of birth: database

Thanks in advance!

Answer 1

From your description, you want to automatically update columns of list 1 with the values ​​in list 2.

We could use flow to meet your requirement, please check following steps:

Step 1: I create list 1 with Employee Name(Single line of text),Register Number(Single line of text), Date of birth(Date and time).

Step 2: Then create list 2 with Name of employee(Single line of text),Register Number(Single line of text), Date of birth(Date and time) and fill in the fields.

Step 3: Create a flow with template "When a new item is added in SharePoint, complete a custom action".

Step 4: Get values in list 2 and filter the value when Employee Name is equal to Name of employee.

Step 5: Update the Register Number, Date of birth of the specified user in List 1 with the expression "item()?['RegisterNumber']" and "item()?['Dateofbirth']".

Step 6: Test and save the flow, create a new item in list 1, wait for a while for the flow to work.