I have two tables, "Test Table 1" and "Test Table 2", in Dataverse.
Each table has had all of their data imported. Each table has a "Customer Number" column.
"Test Table 1" has a "Name" column with each of the customer's names.
"Test Table 2" has a Lookup Column called "Customer Name"
I need to create a Power Automate Flow that loops through the two tables, and populates the Lookup Column Values in "Test Table 2", with the Customer Name values from "Test Table 1".
In the real scenario, Test Table 1 may store all the Customer's additional data, and Test Table 2 just stores the Customer's Main data. All of this is imported through a CSV, so it lacks the ability to link the two tables up with a Lookup value properly.
I have partially created the following flow:
1. List Rows in Test Table 2 (this works OK)
2. Apply to Each row (this works OK)
3. For each row, List the Rows in Test Table 1, and filter where the customer numbers match on each of the tables (this works OK i think)
4. I then need to Update that row, which is where it's failing:
This is what the Flow is trying to do:
I think the issue is that where i'm trying to reference the value in Customer Name (Test Table 1S), the syntax is incorrect.
