Getting data from one sharepoint list into another

(0) Share

Report

Posted on by Kmayes

792

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?

Categories:

Using connectors

I have the same question (0)

All responses (11)

Answers (1)

sudharsan1985 1,325 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

@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 🙂

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report

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-Banging-my/m-p/516320#M65654

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

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Kmayes ,

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

Best Regards,

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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

Best Regards,

Was this reply helpful? Yes No
Kmayes 792 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Kmayes ,

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

Best Regards,

Was this reply helpful? Yes No