Forum Discussion
How to setup a lookup relationship between 2 fields in separate lists
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! 🙂
