I have a flow which works when an item is marked as ordered with a tick box it sends the item to another list. I'd like it to first check if the line exists in the other list and amend and only create when it doesn't exist there. As we are finding alot of data is needing to be amended on the original list the flow is creating duplicate items which is starting to become troublesome.
Is there a flow that could do the check and update first?
I would add a column to your secondary list to store the ID value from the primary list (OriginalID). You can then use a get items action and use a query filter to where OriginalID eq ID from the trigger. Then add a condition and use a length expression to determine how many items were returned from the get items action and set the condition to where the expression is equal 0. If it equals zero, it means the item does not exist and you can create the item in the yes side of the condition.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.