question

QasimRanaITManagerDevelopment-0673 avatar image
0 Votes"
QasimRanaITManagerDevelopment-0673 asked JerryXu-MSFT commented

How to place look up field in other list

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

82178-companyfk.png
Thanks


office-sharepoint-server-development
companyfk.png (13.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

QasimRanaITManagerDevelopment-0673 avatar image
0 Votes"
QasimRanaITManagerDevelopment-0673 answered

is any one can help me out on thiz?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JerryXu-MSFT avatar image
0 Votes"
JerryXu-MSFT answered JerryXu-MSFT commented

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.

82646-image.png

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.

83071-image.png

How it works like:

83026-flow-to-update.gif


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.



image.png (14.1 KiB)
image.png (113.0 KiB)
flow-to-update.gif (403.6 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Can u share any example ( live ) ?

Thanks

0 Votes 0 ·
JerryXu-MSFT avatar image JerryXu-MSFT QasimRanaITManagerDevelopment-0673 ·

Hi, @QasimRanaITManagerDevelopment-0673 ,

I have updated with the flow setup and a demo of it. Please have a check about it.

0 Votes 0 ·

Again , its giving me above error, what to do to get rid of this.
Guide Please.

0 Votes 0 ·
Show more comments