Search code examples
sharepointpowerapps

Power Apps/Sharepoint, Item will not change after modification

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

Solution

  • 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