Forum Discussion

Lutzy's avatar
Lutzy
Copper Contributor
Jul 21, 2023

Sharepoint two way relationship between lists

Hi,  I am trying to do something pretty basic but I can't seem to work it out. 

Basically I have two SharePoint lists.  Customer list with a list of all of the customers and an equipment list  including and Asset ID.  I have created a lookup column on the customer list so I can assign multiple items from the equipment list to the customer.

 

Now I want to go back the Equipment list and create a look up back Customer list and list the Customer automatically based on the selection made in the customer list.  

 

Is this possible?

Lists
SharePoint Online

1 Reply

  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Jul 22, 2023
    Hi!
    You can relate lists using lookup columns but with a limited experience as you are seeing. For the scenario you want to achieve I think you will need a layer on top of your lists using Power Apps, JSON formatting or even SPFx

Resources