0

Trying to get my makeshift vlookup to connect my two lists. The idea is when a user modifies a record it will reflect from List Template to list population.

The "vlookup" is based on EmployeeLoginID (template) Employee_PrimaryLoginID(population). The columns supposed to be updated are "Submitted", "Yes/Idk" and "No".

This works when I create a record from scratch but not for modification.

Can anyone help with this?

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

Condition one: Vlookup(if employeeloginid exists in template) and fill in "Submitted" in population.

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

Condition two: Vlookup(if employeeloginid exists in template) and fill in "Yes/Idk","no" in population if those fields are chosen as Yes/Idk , No in population.

enter image description here enter image description here

Jonnyboi
  • 505
  • 5
  • 19
  • Hi Jonnyboi. Can you tell me which columns are in these two lists? According to your screenshots, there are "CPDE-02..", "CPDE-056.." and "CPDE-05..." in the Condition2. Do you want to fill in "yes/Idk" when any of these three column is yes? – EchoDu_MSFT Sep 09 '21 at 07:25
  • Hi Echo. The 3 CPDE questions, If all are "Yes" or "I Don't Know" in template list I want to fill in "Yes/Idk" in population list. If they are all "No" in template list I want to fill in "No" in population list. An additional logic that I didn't think I incorporated is, if any of the 3 questions are Yes or Idk in template, then Fill in Yes/Idk in population. Meaning all 3 have to be answered "No" in template for it to be populated "No" in population. Hopefully this makes sense – Jonnyboi Sep 09 '21 at 13:05

1 Answers1

1

Please following steps:

1.List A:

enter image description here

2.List B:

enter image description here

3.Create Microsoft Flow

Note: Because as long as you modify item, the "When an item is created or modified" will be triggered. So I set the Trigger Condition, and the "When an item is created or modified" will only be triggered if the Status is Approved

enter image description here

4.Save and Test Flow

======================= Updated Answer =========================

Yes, you don’t need to add this Trigger Condition

My Flow:

enter image description here

enter image description here

enter image description here

enter image description here

enter image description here

EchoDu_MSFT
  • 621
  • 4
  • 3
  • Hey, why did you put the trigger action in? What does this do? The screenshot is kind of cut off. Also I notice you didnt include "I Don't Know" in your conditions. Going to play around with your suggestions. – Jonnyboi Sep 09 '21 at 13:25
  • Hi Jonnyboi. I have updated answer under initial My Answer. Hope this can help you to solve issue. Have a nice day! – EchoDu_MSFT Sep 10 '21 at 07:07