Creating Duplicates - Copying and updating list items with attachment to another list
Hello all, 😊❤️
I currently have a flow down to where if I have List 1 with an existing item and it is updated with an attachment that a flow triggers to make a copy of that item along with its newly added attachment to List 2.
However, if I have multiple items in List 1 getting attachments added at the same time, then duplicate items get added to List 2.
So my question is, how do I avoid these duplicates? I was thinking something has to be done to where the flow first checks to make sure the item doesnt already exsist in List 2 but i have no idea how to squeeze that in or if it would even help?
Any help is appreciated! My current flow is below:
Hi @v-bofeng-msft , Where would i put that "Get Items" card for List 2 in your flow you had shown? Currently, my "Get Items" card is for List 1 in my flow.
Also, I am confused as to why I would be "deleting" attachments? i want to avoid duplicates altogether?
Maybe if I explain my scenario a little better... I bulk load over 100 list items in List 1 at once. Then in the coming weeks, little by little, users will go into List 1 and add an attachment to some list items and use the "ReviewDone" text column inputting a "Y". I would like the flow to copy that exact list item (along with its attachment) to List 2. When i do this, it copies a list item in List 2 multiple times... Just FYI, at the end of the flow (i didn't show in my screen captures) that once it is copied to List 2, it deletes the original list item from List1.