Flow - Checking if incident exists

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2022 01:48 AM
Hello, I hope everyone is ok and safe, Happy New Year, all the best for 2022.
I have a flow with logic to create or update an existing incident.
The logic is simple:
1. look up the incident record
2. if the incident exists (I have some conditions there) then, update it.
3. If incident does not exist, create a new one.
The issue I have is that it creates a new one every time, because I can't check if the incident record exists.
I tried the solution from this post: https://community.servicenow.com/community?id=community_question&sys_id=9a2359a7db28bfc014d6fb24399619bf
However I don't have the option for If count is 0, so I can't add that condition.
Does somebody know what I'm missing?
is count not available for look up records incidents?
Thanks in advance!
- Labels:
-
flow designer

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2022 01:52 AM
Hi Damian,
When you say you don't have the option for "if count is 0" do you not have the data pill to get the count of records? Are you using the "Look up Records" and not "Look up Record" (plural version needs to be used).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2022 02:10 AM
Hello Kieran,
Thanks for your fast response, I appreciate it.
That was correct, in the data pill I did not have the option for look up record-count, it was because I was using lookup record instead of lookup records, so now that I have look up records I have the option for count in the data pill, however now I can't add a condition to check the state of the record, does this mean I have to add two actions?
One for lookup record and another one for look up records?
so I can add a condition to check state of incident and the count?
Regards.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2022 02:24 AM
Hi,
You can still add a condition as part of the look up records action, similar to filtering a list view.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2022 02:34 AM
Hello Damian,
What is the trigger point you are using?