Flow giving an error if no record found in the lookup activity
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 03:29 AM
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 03:39 AM
Hi,
I have been through this, and as per my experience, it's easy to do, you can address this issue by adding a condition in your flow after the lookup activity in the 4th step. However, if no record is found in the lookup, the flow will skip the subsequent steps and continue to update the record This ensures that errors caused by missing records in the server table won't halt the flow, allowing other records to be updated smoothly.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 06:13 AM
Hi @JamessMilleree , Thanks for your response, Can you please let me know which condition I can add so that it can skip the step 4 if no record found. Please provide steps to achieve that functionality. Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 04:45 AM
You can use If Else conditions here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-02-2024 05:31 AM
Hi @Community Alums, Thanks for your reply. Please let me know the step as I also try to apply If and else condition but it's not working properly. I'm new in flow designer so please share the steps to achieve this functionality. Thanks.