Announcements
Hi all
I have two sharepoint lists and i want to update one list by looking up the value in another list and returning the value from another column in that row?Is this something flow can support?
Hi @Kmayes
Yes, it can be done with the flow. Just give it a try and if you have any clarifications let us know. We will help you.
@sudharsan1985
Thanks for responding. I have attempted this in multiple ways using when an new item is created, then get items (from the list i want to get items from) but unsure how to do the lookup part between two list are you able to provide a solution as it would be much appreciated as i have been searching online for ages 🙂
Please refer the below link for detailed explanation. Let me know if you have any issues.
https://powerusers.microsoft.com/t5/Building-Flows/Update-List-List-A-using-Flow-from-another-List-B-Banging-my/m-p/516320#M65654
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue-Sudharsan K...
Hi @sudharsan1985
Im still having issues on my list 1 the row has a four digit code i want it to look up the corresponding same code in list 2 and return the value in the column 'Auditor'.
Unfortunately i dont think the suggested link works?
List1
List 2
Hi @Kmayes ,
Please try to refer to the following image to configure Flow and check if it helps:
Best Regards,
Hi @v-bacao-msft
Thanks for your response. This seems to be closer to what i need it to perform. However I am getting an error on the compost area, any ideas?
The flow runs but doesnt enter the required info into list 1.
I just provide an example to filter items, you need to configure another action in If yes to achieve your needs.
It seems that you need to configure update item action here.
Besides, that is not an error message in Compose, because the result of the condition is false, so this action be skipped.
@v-bacao-msft
Sorry im a newbie with advanced flow.
Can you provide help how to get the look value updating List 1?
I added after compose, update list but this doesn't seem to work? What am doing wrong?
Please provide the screenshot and Flow run history so that we could provide a proper workaround.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 445
11manish 345 Super User 2026 Season 2
M Bilal Khan 300
