How to place look up field in other list

Question

Hi,

Using Sharepoint online

Problem: I have 3 lists , names are company ,plant and products

company name is using as a look up field in plant and plant name is also using as look up in Product

Solution Required: I want to display company name in product list ( which has no directly link ) how can I display company name in product list ( Note : plant based on company, it means I cannot create link between company and product directly )

image is attached for reference

Thanks

Answer 1

is any one can help me out on thiz?

Answer 2

Hi, @QasimRanalTManagerDevelopment-0673 ,

For SharePoint Online, I will suggest you to use Power Automate (Flow). Using flow you can get all the value in the lookup column. The value of the referred item field and the ID of the referred item. With the ID, you use a Get Item Action to get the original Item first list and all the required information.

So the basic mechanism of the flow will be like this.

1. With a Get Item action, we have the item in the Product list. We get the lookup column of it. That means we have the id of the item in Plant list which user select .
2. Again we can use the ID of the item in Plant list, with a Get Item action, we can get the company (Item id and the company name) user select in that Item.
3. Use an update item to fill the company name in the required field in the item in Product list

And if you do not have access to Power Automate, you may need to use PowerApps to create a cascading drop down for it.

Only with SharePoint online list, there is no out-of-box solution for it.

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Update With a Flow demo
Hi, I made a demo for your scenario and find things could be easier.

How it works like:

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.