116
I create two lists: orders and customers.
The orders list have a lookup field 'Email Address' to link the customers list.
How to retrieve the first name, last name from the customers list in Flow?
Thanks,
Joe
Hi Scott,
I know this is an old post but you maybe able to help me with something similar, how does your look up column work?
I have two lists, one which is updated by a flow daily with a list of computers which comes from active directory, the other is a list of exclusions which need to be excluded from the flow.
I just wondered if your lookup scenario may work for my problem? thanks.
Great! This is what I have been looking for. A "VLOOKUP" in Flow. One word of caution based on my trial of this - If you change the display name of "Title" column of a list in SharePoint, Flow still undestands it as "Title" and using the display name does not work.
Here is a solution that should work for you. My lookup column is called email in the customers list. I store the email in a column called Customer in the orders list.
While I need to use an apply to each loop, there should only be one entry with a given email address. In fact, you may want to set that column to contain unique values.
Please post if you have more questions.
If this solves your issue, please mark you question as solved.
Share
Report
All responses (
Answers (
