Forum Discussion
How to setup a lookup relationship between 2 fields in separate lists
Hi,
I have a lookup field in a list (e.g. asset list) which lookups up people from a (e.g. user list). When I lookup and associate a user from the user list in the asset list, I would like that it creates a link record within the user list.
Currently, what I do is that I need to go to the items in both lists and populate the lookup field accordingly. Can I do anything to automatically add the relationship in the second list items as relevant?
Thanks
Unfortunately, currently there is no way to achieve your requirements using SharePoint out of the box lookup column functionality.
You will have to use custom solution to achieve this functionality. When you create or modify a list item in "Assets" list, you can run a Power Automate flow with trigger like "When item is created or modified" on Assets list.
Then you can automate the process of creating/updating information in Users list accordingly using Power automate flow.
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.
Unfortunately, currently there is no way to achieve your requirements using SharePoint out of the box lookup column functionality.
You will have to use custom solution to achieve this functionality. When you create or modify a list item in "Assets" list, you can run a Power Automate flow with trigger like "When item is created or modified" on Assets list.
Then you can automate the process of creating/updating information in Users list accordingly using Power automate flow.
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.
- Thank you ganeshsanap. Makes sense. Hoping for magical field type! 🙂
