Forum Discussion
SharePoint list self join?
I've a SharePoint List which I'd like to use for both parent and child references, is it possible to do this?
Unfortunately we can't use the dataverse for this project which would make it easier, but is it possible to have a lookup field which looks up to the same List?
Thank you
Louise
4 Replies
LouiseAspman Here is an example using lookup from same list:
Column settings: List Data:
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
ganeshsanap - thank you
LouiseAspman You're welcome, hope it answered your question!
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
LouiseAspman Yes, it is possible in SharePoint to create lookup column based on same list.
Check this documentation: Create list relationships by using lookup columns
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
