Flow Designer - Check if ticket exists and create tickets where none exist

[DylanB]

Hi all, I'm struggling with a flow that I'm working on. The end goal is to automate lease upgrade ticket creation based on the Scheduled Retirement date of Computer assets.

My flow looks up computers on the Assets table with a Scheduled Retirement date of today. If it finds any, create a Lease Upgrade ticket for each Asset found.

This next step is where I'm struggling with the logic. Before creating the Lease Upgrade ticket, I want the flow to check if other Lease Upgrade tickets exist per Asset. If a Lease Upgrade ticket does exist for that Asset, don't create a ticket. If a Lease Upgrade ticket does not exist for that Asset, create a ticket.

How can I manipulate the flow to only create tickets for Assets that do not have a Lease Upgrade ticket created for them already? My flow is posted below. I'm sure the answer exists somewhere around step 3.

[Vijay Balotia1 · Accepted solution]

Hi @DylanB,

you dont need if condition in step 2. Try with following steps i hope that will work for you.

1. Lookup Records (with you condition)

2. For Each (Step 1 output lookup record)

3. Lookup Record (for RITM ) I hope there will be one RITM if it exits not multiple in you flow you are using Lookup Records which is not need.

4. if (Condition if result is false for step 3 )

5. Submit catalog item request

Next step can follow as per requirement.

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.
Thanks
Vijay Balotia

[DylanB]

Awesome, that works great Vijay! I had to set the step 4 look up to "If Look up record error message is "No Record Found"" to get it to work, but after that, it works! 

Thank you for the help!