SharePoint List Lookup column values to another List

Question

I have a list that provides information (Plot Number) to a SharePoint Site Column lookup called "Plot No. Lookup". I use this Column to select plot numbers in a folder within a Library and display them in the Plot No. Lookup column - this works great and displays any plot number that I select in the column as required.

However those values selected from the lookup and stored in the folders' column, I need to also store in another list as well. There are multiple selections from the lookup column that need to be stored in the other list's column.

I have a flow that is runs and mainly does what it should, which is to approve the drawing and transfer it and all the data about the drawing (Including the plot numbers selected from the lookup) to another folder.

How can I get the plot numbers selected from the lookup to also be displayed in another list?

I have included a snapshot of the Create item flow and this includes the Plot No. Lookup field at the bottom (incidentally, I have been able to get it to transfer the data if I use "Plot No. Lookup ID" but this creates an entry in the folder for each plot number individually and does not put all of the plot numbers in one entry.

Any Help is much appreciated TIA

Nigel

Answer 1

Hi @Nigel Foot ,
This flow can get the value/numbers that I have selected in the lookup column into the new list item.
Here are steps：

The test results are shown below. I created a site lookup column in 0919library. When uploading or modifying a file, the flow is triggered, and the value in the lookup is separated by ";" and displayed in 0919list2 (sorry for the My attempt, I have no way to convert the displayed content to int).

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 2

Hi,

So I have a library which contains folders, within those folders are files, the Lookup column is a site column that runs all through the folders and I can select multiple values from it for each file.

The values stored in the "Plot No. Lookup" column I need to store in a list entry that is added when my flow runs.

The flow creates an item in a list as in my previous post. This works fine but it does not show the values that I select in the folder area. I need to somehow get the value/numbers that I have selected in the lookup column into the new list item.

Answer 3

Thanks you for your reply. Please can you tell me if your "plot NO.number" column is a "Lookup" column in my scenario it would be a "Lookup" column and gets its values from a two column list called "Accommodation". The columns are "Plot Address" and "Plot No". The value for Plot number is selected in the file in "Library>folder1.plotNO.number" column and these can be multiple values.

I have tried your solution and it does not resolve the issue for me. I cannot get the values selected to append into to the column. Its just blank. Although the flow does test ok and runs fine. (All green tickets)

TIA