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

 

any help is highly appreciated.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

@Vinoth1_  the filter query needs to be in below format, so please change it

Orderno eq <Select from Dynamic content - orderno>

 

Then you dont need a condition inside apply to each as Get Items will only return those items which match the order number so you can directly add Update item action under apply to each action.

 

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

View solution in original post

5 REPLIES 5
annajhaveri
Super User
Super User

@Vinoth1_  are you using filter query on get items action? If yes, then can you please provide what the filter query is? From error it looks like you are using wrong column name in filter query.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

hi @annajhaveri ,

 

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

 

5.JPG

Hi @annajhaveri ,

 

can you also suggest, other ways to build a flow to perform the functions i requested or similar function to lookup & get values from another sharepoint list for the matching title/orderno?

 

 

@Vinoth1_  the filter query needs to be in below format, so please change it

Orderno eq <Select from Dynamic content - orderno>

 

Then you dont need a condition inside apply to each as Get Items will only return those items which match the order number so you can directly add Update item action under apply to each action.

 

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

View solution in original post

Hi @annajhaveri ,

 

Many thanks for information.

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 Solution Authors
Top Kudoed Authors
Users online (1,727)