Hello,
I am attempting to build a power automate flow to serve as a substitute to the VLOOKUP function in excel. My logic is as follows:
1. When an item is created in List A,
2. Check to see if that same item is in List B,
3. If True, populate column 6 in List B with information from column 6 in List A,
4. If False, do nothing.
I have a drafted the flow pictured below. But when it runs, it updates column 6 in List B for all of the rows instead of the row that matches List A, despite the conditional logic that should check to see if the data in column 1 of both lists is the same.
Building relationships between SharePoint Lists is crucial for data entry efficiency, so any support you can provide would be greatly appreciated.
