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
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
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
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 519 members 5,383 guests
Recent signins:
Please welcome our newest community members: