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

[rexter1]

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.

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

[Michael Fry1]

Have you tried using Create or Update Record action? If the conditions match a record, it should update it. Otherwise, it will create a new record.

[rexter1]

Hello, I have not tried it but you are right, it could be ok. I have tried the another solution mentioned above and it helped me. Thanky for your time and answer!

[Swapnil Soni1 · Accepted solution]

Hi,

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

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

Thanks

[rexter1]

thanks! I already tried with Record(s) and count 1 or else, but did not try with "For Each". Exactly what I was looking form thank you!