cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Using Flow to copy data between two lists

I'm hoping to get some guidance. I found this Flow Blog and it worked exactly as intended: Copying Using Filtering However, I need what is discussed toward the bottom around using unique ID's to prevent new items always being created. Here's the verbiage: 

 

Another limitation is if the field that you are using to keep items in sync between the two lists changes, a new item will be created in the destination list. For example, if you are using a person's Name to copy between the two lists, and their Name changes, the flow will think that it is a new item, not an update to an existing item. If you can guarantee that the Name will never change then you won't be impacted by this. However, if Name is a field that can change, you will need to add a new column to the destination list that stores the ID of the item in the first list. In this case, rather than using Name to find items, you can use ID instead (and the ID is guaranteed to always be unique).

 

I'm struggling to figure out how to make this work correctly and don't know enough about creating filter queries and condition syntax to resolve it on my own. Any help would be appreicated.

21 REPLIES 21
Anonymous
Not applicable

@faustocapellanj

 

First off, I really appreciate all of your help. The solution you posted didn't work 100%. It did start spitting out values and I made some changes to the YES/NO paths. For whatever reason in both update item and create item, it wanted the dynamic content from the source (SMART Space) list. By selecting those and using the field from "When an item is created or modified" and NOT "Get Item" it worked. See below:

No.jpgYes.jpg.

 

Without your help I wouldn't have gotten this figured out. It works swimmingly and whenever an item is created or updated in the source list, it "flows" to the destination (Staging) list... for now. *crosses fingers*

View solution in original post

Hi @Anonymous

 

I'm glad my solution got you close to what you were looking for. One thing that I forgot to mention is that the "Get items" step is only used to check whether or not the item exists in the Staging list. Another thing is that in order to create a new item or update an existing one in the Staging list, all the dynamic content must come from the "When an item is created or modified" step.

 

If you have any other question or any other flow scenario you'd like to try, you can always reach out and I'd be more than glad to help.

 

Regards,

Fausto Capellan, Jr

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,050)