cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vinoth1_
Helper IV
Helper IV

How to lookup the value from one sharepoint list to another using flow?

Hi,

I have a sharepoint list GET MDP, with Orderno & Email as column. both order no & email of the sales person will be registered from sales department when customer book an order.

 

1.JPG

 

I have another sharepoint list Defect registry, with Orderno & Email as column, whenever there is a quality defect happened in production, the operator will register the order number in sharepoint. and whenever an order is registered as defect in defect registry, i was thinking to build a flow to lookup the matching order number from Get MDP sharepoint & get the email of the salesperson & save the email unders the matching order no in Defect registry sharepoint list.

 

2.JPG

i made a flow, but its not working and giving me an error

3.JPG4.JPG

5.JPG

i used filter query, the filter query Orderno is associated with (when an item is created sharepoint list Orderno)

 

any help is highly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@Vinoth1_ 

Mira_Ghaly_0-1616663470566.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

4 REPLIES 4
Mira_Ghaly
Dual Super User II
Dual Super User II

@Vinoth1_ 

Your filter Query Should be like this

Orderno eq Mira_Ghaly_0-1616660893296.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hi @Mira_Ghaly ,

 

I donot understand, can you explain it in detail please.

 

should i need to make some changes in the filter query, what kind of change need to be in?

6.JPG

 

 

Mira_Ghaly
Dual Super User II
Dual Super User II

@Vinoth1_ 

Mira_Ghaly_0-1616663470566.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

Hi @Mira_Ghaly ,

 

Many thanks it works now.

 

Thanks for help.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (2,076)