cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JoeAu
Level: Powered On

retrieve value from another Sharepoint list

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: retrieve value from another Sharepoint list

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.

 

Lookup.jpg

 

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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

3 REPLIES 3
Super User
Super User

Re: retrieve value from another Sharepoint list

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.

 

Lookup.jpg

 

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.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

JoeAu
Level: Powered On

Re: retrieve value from another Sharepoint list

I solve it.

Thanks.

YatinMumbai
Level: Powered On

Re: retrieve value from another Sharepoint list

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. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,947)