Use Flow to update SharePoint list Item creating duplicate items

Question

I am trying to use Flow to meet a user's requirements to:

1. copy new items with attachments in List 1 to with attachments in List 2

2. Update changes made in List 1 to List 2 in the same site

Setup:

2 SharePoint list - List 1 and List 2 with same columns (text, choice, metadata).

I created a FLOW using 'When an item is created or modified'.

Result:

1. requirements met

2. when a user updates a column in List 1, a brand new item is created in List 2. If a user updates the 3rd time, a 3rd duplicate item is created.

I have been trying to add 'Condition' to part of the Flow but it did not work. I noticed that 'Condition' does not have 'Edit in advanced mode' but with 'Add' only. I wonder if this has to do with the version of SharePoint online. I cannot make requirement to work.

I searched a number of forums but I have yet been able to meet 2.

Thank you for any help.

deleted · Answer

Need to run them as separate flows. One to Create it in the first place and one to modify the meta data if it changes.

Just created the below and it seems to work. Note: the workflows only run every 3-5mins so you won't see a change until it triggers. Hope this helps :)

matt weston · Answer

Hi&nbsp;spvan2019,&nbsp;what&nbsp;Deleted&nbsp;has posted below is the solution for updating the other list item. The only thing I'd add, is you don't need to run them as two Flows. If you have a condition at the start which compares Created Date and Modified Date, you can branch your logic, and handle both scenarios in the same Flow.

deleted · Answer

Yes of course, thanks Matt for pointing that out ... I have normally separated them for clarity and ease of maintenance. But not a big deal to do what you suggest :)

spvan2019 · Answer

Thank you both.Deletedsomehow, in my lists, it didn't work. I am working to see why it didn't work the same way like your. My lists do not use 'Title'. My site is still in SharePoint online 2013 I believe. I have not been able to make it work.

deleted · Answer

If the filter is not title, then you need to make sure the filter is referring to the ID rather than that associated text.&nbsp;&nbsp;This has caught me out a few times, especially for a lookup field. If using a lookup field, then use the ID field instead of the field name.&nbsp;&nbsp;You can check this but running the workflow and seeing what was returned, with Get list

Forum Discussion

Use Flow to update SharePoint list Item creating duplicate items

10 Replies

Resources