- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 08:44 AM
Hello,
Anyone knows if it is possible to check if a record with particular parameters already exists?
In this flow i want to check if it already exists, if no to create one or if yes to create a record on another table.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 09:54 AM
@hadron_collider Instead of using Look up Record, you can choose to use Look up Records action. Look up Records action returns an additional output variable count which can be checked via an if block to check if the record already exists on the table or not.
For more information on Look up Records, please refer to https://docs.servicenow.com/bundle/vancouver-build-workflows/page/administer/flow-designer/reference...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 08:55 AM
Hi @hadron_collider ,
From the docs - StatusData type: Choice
0 if a record was found successfully, and 1 if there was an error.
Link : https://docs.servicenow.com/bundle/vancouver-build-workflows/page/administer/flow-designer/reference...
I believe status should help you identify whether or not there is a record that's existing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 08:59 AM
Have a look on
Not exact , but similar.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-23-2023 09:54 AM
@hadron_collider Instead of using Look up Record, you can choose to use Look up Records action. Look up Records action returns an additional output variable count which can be checked via an if block to check if the record already exists on the table or not.
For more information on Look up Records, please refer to https://docs.servicenow.com/bundle/vancouver-build-workflows/page/administer/flow-designer/reference...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2023 02:57 AM
Indeed, this is the right solution. Thank you!