Is it possible to stop a flow pulling in a duplicate line item

Daniel Gill 97

Hi all,

Hope you are all well!

With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we are 5 days away from cancellation and then a day away.

Because of this, we are going to run a flow that allows us to automatically add projects to this form once they are placed on hold.

They will then have 90 days to resume before cancellation.

When we run the flow, we have many of the same project come through.

I want to know is there a way to stop this, we have Projects identified with an ID code if that would help, i imagine it could be used.

Thanks and have a nice day.

Dan

David Tutwiler

I think you'll need a status column somewhere to drive this automation. So something where you automatically change the status to something like On Hold.

Then in your automation you'll want to check to make sure you're checking for the status to change to On Hold as your trigger. If you make it the condition, you'll copy the row over every time your conditions match and the status is On Hold. If you make it the trigger it will only trigger the first time the status changes to On Hold, preventing the duplications.

At mention me if you still have questions, but this should get you close.

Daniel Gill 97

I think you'll need a status column somewhere to drive this automation. So something where you automatically change the status to something like On Hold. <\/p>

Then in your automation you'll want to check to make sure you're checking for the status to change to On Hold as your trigger. If you make it the condition, you'll copy the row over every time your conditions match and the status is On Hold. If you make it the trigger it will only trigger the first time the status changes to On Hold, preventing the duplications.<\/p>

At mention me if you still have questions, but this should get you close.<\/p>","bodyRaw":"[{\"insert\":\"I think you'll need a status column somewhere to drive this automation. So something where you automatically change the status to something like On Hold. \\nThen in your automation you'll want to check to make sure you're checking for the status to change to On Hold as your trigger. If you make it the condition, you'll copy the row over every time your conditions match and the status is On Hold. If you make it the trigger it will only trigger the first time the status changes to On Hold, preventing the duplications.\\nAt mention me if you still have questions, but this should get you close.\\n\"}]","format":"rich","dateInserted":"2021-10-11T19:01:42+00:00","insertUser":{"userID":120260,"name":"David Tutwiler","title":"","url":"https:\/\/community.smartsheet.com\/profile\/David%20Tutwiler","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GiIpuCpV7Zvo9nduJmLt8ULNYObTVazzemdnIiy6w=s96-c","dateLastActive":"2023-07-27T20:33:00+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/307506#Comment_307506","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/307506#Comment_307506

Thanks for the comment David,

unfortunately this does not stop the same line item being brought over as the line item exists multiple times on what we pull from.

Really unsure what to do in this instance.

Thanks for the help though!

Dan