Forum Discussion

rosscortb's avatar
rosscortb
Copper Contributor
Dec 12, 2022

Lookup against another ID

Hello,

I have an app the sends details to two sharepoint lists - personal details and shop orders.

 

Can I add a lookup column that will bring the name from personal details to shop orders list?

 

I have an orderID column in both lists.

 

Thanks
Ross

SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Dec 13, 2022

    rosscortb Yes, you can create list relationships by using lookup columns in SharePoint online.

     

    You can add a lookup column from personal details list to shop orders list and select additional columns to show in shop orders list. However, you can extend limited column types like single line of text, number, date, currency, etc.

     

    Check this documentation for more details: 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.

    • rosscortb's avatar
      rosscortb
      Copper Contributor
      Dec 15, 2022

      ganeshsanap 

       

      Thanks for your response but not sure the links shows how I can achieve this.

       

      As you can see I have added a lookup column in order list which does bring through the employee names for the personal details but I want it to auto fill when the items are added. I suppose in excel it would be a vLookup using the orderID as the unqid.

       

       

      Thanks
      Ross

       

Resources