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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,357)