CODEWITHSUNDEEP
sharepointpowerapps
Jonnyboi
Jonnyboi

Reputation: 557

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

Upvotes: 0

Views: 221

Answers (1)

EchoDu_MSFT
EchoDu_MSFT

Reputation: 621

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

Upvotes: 1

Related Questions