How to update an item in a SharePoint list based on the changes made in another SharePoint List?

(0) Share

Report

Posted on by mitalipatel

I have a List A with Analyst as Person/ Group column and Customer Name they're assigned to.

I have List B with Customer Name, Order Details.

I need to create a column in List B with Assigned Analyst which will refer List A and populate data.

How can I create a Power Automate flow that will map the Assigned Analyst value from List A into List B of SharePoint List ?

Categories:

Business Process Flows

All responses (5)

Answers (1)

Verified answer

SudeepGhatakNZ 14,303 Most Valuable Professional on at

Like (1)

Report

Re: How to update an item in a SharePoint list based on the changes made in another SharePoint List?
mitalipatel 29 on at

Like (0)

Report

Re: How to update an item in a SharePoint list based on the changes made in another SharePoint List?

The blog link you've shared does not show images. Can you share the flow snapshots if visible for you?
SudeepGhatakNZ 14,303 Most Valuable Professional on at

Like (0)

Report

Re: How to update an item in a SharePoint list based on the changes made in another SharePoint List?

Okay!

Here is what you need to do:

Update a Person field in SharePoint from one list to another using Power Automate - V's Blog (veronicageek.com)
mitalipatel 29 on at

Like (0)

Report

Re: How to update an item in a SharePoint list based on the changes made in another SharePoint List?

Hi,
I understand the Lookup option is there. However, if my list is already populated then the lookup doesn't work and rather provides a dropdown to choose from.

What I'm looking for is as soon as changes are made in List A, it should automatically update List B without any manual intervention.

Thanks 🙂
SudeepGhatakNZ 14,303 Most Valuable Professional on at

Like (1)

Report

Re: How to update an item in a SharePoint list based on the changes made in another SharePoint List?

@mitalipatel ,

You could achieve this without building a flow.

All you need is a lookup column. You can pull the required fields from List B into the List A