CODEWITHSUNDEEP
sharepointpowerapps
Jonnyboi
Jonnyboi

Reputation: 557

Automate "Vlookup" using Sharepoint Lists, and Flow

I have two lists in sharepoint. List A (Template) and B(population). List A contains column "Employee Login ID" and List B contains "Employee_PrimaryLoginID".

I want to create a vlookup, So whenever a new record in List A gets created, a column named "Submitted" will be edited in List B.

I want to lookup on "Employee Login ID" and ""Employee_PrimaryLoginID" , as "Employee_PrimaryLoginID" in List B is the full set, and when a new record is created(in list A) I want to be able to view that is have been created.

Hopefully this makes sense. Here is what I have tried using Flow:

enter image description here enter image description here enter image description here enter image description here enter image description here

Upvotes: 2

Views: 4082

Answers (1)

EchoDu_MSFT
EchoDu_MSFT

Reputation: 621

According to my understanding:

  • ListA contains column "Employee Login ID"
  • ListB contains "Employee_PrimaryLoginID" and "Submitted". And ListB has all employees’ login ID, in other words "Employee_PrimaryLoginID" in ListB is the full set.
  • When ListA creates a new item, if "Employee Login ID" is equal to "Employee_PrimaryLoginID", then update the corresponding item in ListB and set the "Submitted" value to the value of "Employee Login ID".

If yes, please following steps:

1.Set "Employee Login ID" in ListA is unique value and required column

enter image description here

2.Set "Employee_PrimaryLoginID" in ListB is unique value and required column

enter image description here

3.Create Microsoft Flow

enter image description here

4.Save and Test flow

5.When you creating new item, the ListB will happen as shown below:

enter image description here

Upvotes: 2

Related Questions