Flow giving an error if no record found in the lookup activity

[Siddharth4]

Hi Everyone,

Flow is giving an error if the lookup activity didn't find any record and the flow stop. As shown below in first step it query the record from table and then store the object id associate to all the records and then for each record it will try to find the associated VM  (Step-3) and server (Step-4) using the object id. But some times there were no server in the server table with the same object id and due to that the flow stops and through an error because of that other record will not get updated so I want to apply a condition so that if no record found in the lookup activity in 4th step then flow can skip only 4th step and will update the record.

Thanks

[Mark Manders]

You can set it that the flow does not stop on error. You can then add an if to do what you want if no record is found.

[Siddharth4]

Hi @Mark Manders , Thanks for your reply. Please let me know how I can set the flow to not stop on error. I'm new in flow designer. Thanks.

[SANDEEP28]

@Siddharth4 You should use "Look up records" instead of "Look up record".  In the "Look up records" action, you will get count field. If there are no records then count will be zero. You can use this count field in your further logic. Refer below link for more info

https://www.servicenow.com/community/itsm-forum/lookup-record-in-flow-designer-if-no-record-found-ho...

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[SANDEEP28]

@Siddharth4 Have you tried my solution ?? Try to use "Look up records" action instead of "Look up record". It will work

[Siddharth4]

Hi @SANDEEP28 , Thanks for your reply, I tried your solution but it end the flow rather then skipping step 4th using if condition and because of that records are not getting updated.