I have two lists in SharePoint one for Orders and one for Customers which stores thier email address.
Is it possible with Flow that when an employee fills out an order and chooses a customer that flow can extract the email address for that customer from a lookup column?
I have made a test on my side and have created a sharepoint list A as below:
The Customer and email address column are both Single line of text column.
And I have created a sharepoint list B as below
The Customer is a Single line of text column, the lookup column is a lookup type column.
please refer to screenshot below to create the flow:
When an item is created in the List A as below:
The flow would run successfully as below:
The item in list A would be modified as below: