Forum Discussion

Copper Contributor

Sep 29, 2022

Lookup Value

Hello Community, I have a target share point list with two columns Project Name, Foreign Number Project Name is a lookup column, My source list has multiple columns and it has above both columns...

SharePoint Online

ganeshsanap
Sep 30, 2022
taimoorahmed If you want to update values in project name for all items, you can create a power automate flow which will read all items from both lists and match them based on common column to update the list items in child (second) list where lookup column is added.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

taimoorahmed

Copper Contributor

hello ganeshsanap,
so project name and foreign number columns are present in both SP lists.
foreign number has the exact entries in both SP lists. Now in my target list I want the project name to show the records according to the foreign number entries, is there any way to do it? and without power apps.

ganeshsanap

MVP

Sep 30, 2022

taimoorahmed If you want to update values in project name for all items, you can create a power automate flow which will read all items from both lists and match them based on common column to update the list items in child (second) list where lookup column is added.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.