Forum Discussion
Lookup Value
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.
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.
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.