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.
- 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 .
- 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.
- 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.