Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Lookup Record in Flow designer IF no record found - how to go next?

rexter1
Tera Expert

Hello guys, the requirements is quire seems to be easy: If an Alert has come - > create an Incident. If on the same day same alert comes - > Update the Incident.

So, I have an Alert rule creates Incident (using the OOB subflow cloned version of Create Incident)

The Problem: in the flow I have a Lookup Record Action. With a conditon to check the Incident table, if there is a Record "Created today" and the "Short description" hard coded, comes from Alert.

By clickink on "Test" the flow I have the result:

-> If there is already an Incident record, I'm ok it seems, the flow continues - I can update the existing Incident.

BUT, if record not found, no such an Incident yet, (In this case I wish to create a new Incident) The Lookup Record Action simple just drops an Error, and does not go further... See screenshot above the IF condition does not run.

find_real_file.png

Why is that? How can I achieve that if the Lookup does not find anything, then create a record? Maybe the question would be why "Error" is the state if a Lookup record is not found? How can I avoid this? That is normal in our case there will be no record, but wish the flow continue then.

Any help welcome, thanks!

L

 

 

 

 

1 ACCEPTED SOLUTION

Swapnil Soni1
Giga Guru

Hi,

I'd suggest you do use "look up record(s)" in a way similar to this: 

find_real_file.png

 

And don't forget to mark correct and helpful if this helps.

Thanks

View solution in original post

7 REPLIES 7

Great it works!! Thanks

Plus another way also is

SamyukthaR_0-1732987660700.png

Ticking don't fail on error., It worked too

I am also facing with the above and your solution helped me alot, Thank you!