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.

Visit my blog for nice articles: 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.

Visit my blog for nice articles: 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.

Visit my blog for nice articles: here

View solution in original post

Hi @Mira_Ghaly ,

 

Many thanks it works now.

 

Thanks for help.

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (17,534)