Answered

Automating Data Duplication With Unique Identifier SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have 2 SharePoint Lists, call them SharePoint List A and SharePoint List B. SharePoint List B is almost an exact duplicate, except SharePoint List A has one extra column of data. Both Lists even have a unique identifier for each record that can match the records between each List. I want to use this unique identifier in order to look up/match the records, and then from there the flow would copy/duplicate the values from the extra Column in SharePoint List A to an empty Column I have in SharePoint List B.

How could I go about building this?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Anonymous is this a one time process or need to be done periodically? Based on that you can create manual trigger flow for one time process or scheduled flow if its periodical process. In the flow use Get Items to get items from List A. Then use apply to each action to loop through output of Get Items. Inside Apply to each add Get Items to get data from List B, provide filter query parameter in Get Items actions to get matching records of unique ID from list A in format columnname eq 'value of uniqueID'. Then you can use update item to update the list item returned by Get Items (from list B).

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is a one time process that I am using a manual trigger. When I am looping over the output of Get Items for List A, do I just need to grab the extra column that will be moved to List B? For my filter query, would it look like this picture?
Note in the Filter Query that the text "ID2" (circled with blue pen) is a column that comes from SharePoint List B, and the Dynamic Value "ID2" (circled with red pen) comes from SharePoint List A.

Note that the image is a get items for Missing Vendor Name (SharePoint List B)

Also... when I update items, do I do this in the apply to each, or would this be done outside of that?

And lastly... Inside the Update Item, what should I use for the ID/unique identifier of item to be updated? Do I go ahead with using the ID assigned from SharePoint List B, or would I use my ID2 value in SharePoint List B which is the Unique ID I can match to ID2 in SharePoint List A?

Thanks!!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

It's not correct for the Filter query. You have an empty column in the list B and would like to copy values from list A based on the same unique IDs of the two items, am I right?

If so, there are two ways to achieve your need.

1. On Button Clicked or Scheduled, Get items from list A, Apply to each, Get items from List B and filter query ID eq (dynamic current List A item ID), Apply to each and Update item of list B, use dynamic ID from action of Get list B items and populate the blank column with dynamic content value from List A column.

2. On Button Clicked or Scheduled, Get items from list B, Apply to each, Get items from List A and filter query ID eq (dynamic current List B item ID), Apply to each and Update item of list B, use dynamic ID from action of Get list A items and populate the blank column with dynamic content value from List A column.

The difference between the two processes is, if this is a one-time process or will run periodically to copy all item values no matter whether List B column is blank, use the first way will be easier. But if it will run periodically to copy from List A to List B blank fields, use the second way and in Get List B items action set filter query to Column ne "" will be easier to get the items with blank fields and update them more targeted.

Hope I have explained it clearly and helped you.

Best regards,

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous in the get items to get items from list B, you use the columnname from list B which in your case is ID2, then value from List A e.g. ID2 eq 'value from List A', and if your ID2 column is of type text you need to add quotes (') around the value.

When updating item you have to use the ID from dynamic content of Get Item which gets items form List B

Was this reply helpful? Yes No