Getting data from one sharepoint list into another

[Kmayes]

Hi all

I have two sharepoint lists and i want to update one list by looking up the value in another list and returning the value from another column in that row?

Is this something flow can support?

[sudharsan1985]

Hi @Kmayes 

Yes, it can be done with the flow. Just give it a try and if you have any clarifications let us know. We will help you.

[Kmayes]

@sudharsan1985 

Thanks for responding. I have attempted this in multiple ways using when an new item is created, then get items (from the list i want to get items from) but unsure how to do the lookup part between two list are you able to provide a solution as it would be much appreciated as i have been searching online for ages 🙂

[sudharsan1985]

Hi @Kmayes 

Please refer the below link for detailed explanation. Let me know if you have any issues.

https://powerusers.microsoft.com/t5/Building-Flows/Update-List-List-A-using-Flow-from-another-List-B...

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

[Kmayes]

Hi @sudharsan1985 

Im still having issues on my list 1 the row has a four digit code i want it to look up the corresponding same code in list 2 and return the value in the column 'Auditor'.

Unfortunately i dont think the suggested link works?

List1

List 2

[v-bacao-msft]

Hi @Kmayes ,

Please try to refer to the following image to configure Flow and check if it helps:

Best Regards,

[Kmayes]

Hi @v-bacao-msft 

Thanks for your response. This seems to be closer to what i need it to perform. However I am getting an error on the compost area, any ideas?

The flow runs but doesnt enter the required info into list 1.

[v-bacao-msft]

Hi @Kmayes ,

I just provide an example to filter items, you need to configure another action in If yes to achieve your needs.

It seems that you need to configure update item action here.

Best Regards,

[v-bacao-msft]

Besides, that is not an error message in Compose, because the result of the condition is false, so this action be skipped.

Best Regards,

[Kmayes]

@v-bacao-msft 

Sorry im a newbie with advanced flow.

Can you provide help how to get the look value updating List 1?

I added after compose, update list but this doesn't seem to work? What am doing wrong?

[v-bacao-msft]

Hi @Kmayes ,

Please provide the screenshot and Flow run history so that we could provide a proper workaround.

Best Regards,

[Kmayes · Accepted solution]

Unfortunately this solution didn't work for me, however i did manage to find a solution.

If anyone wishes to know happy to assist