Jan 23 2019 04:21 PM
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.
Jan 23 2019 07:17 PM
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 :)
Jan 24 2019 12:10 AM
Hi @spvan2019, what @Deleted 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.
Jan 24 2019 11:26 AM
Jan 24 2019 04:57 PM
Jan 28 2019 11:23 AM
If the filter is not title, then you need to make sure the filter is referring to the ID rather than that associated text.
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.
You can check this but running the workflow and seeing what was returned, with Get list
Mar 06 2019 07:47 AM
Mar 07 2019 05:50 PM
Strange, if your filter is right then it should work fine. Because you should be using "update Item" and for me that does exactly what it says ... updates the item. It would only not do that if it could not find the item when you filtered it. What are you filtering on?
Mar 12 2019 04:39 AM
Filter is set to Title eq '@{triggerBody()['Title']}'
I just tested again not all items are re-created in List 2 and some items are duplicated.
Attached screenshots of the Flow setup.
Thanks!
Oct 29 2019 01:34 AM
Nov 28 2019 01:44 AM
Hi @lvk5700
I have created a couple of videos on this subject now:
FlowBites: Does it Exist (Part 1) - Filter Arrays: https://youtu.be/YLqMiDubA7s
FlowBites: Does It Exist? (Part 2) - Filter Query & Expression: https://youtu.be/x6QcntAs2_0
See if these help :)