Table not found in flow designer 'sc_req_item'

[TiffanyL]

I need to create a flow designer that counts down after a specific RITM item has been closed (where active is false). The count down time is defined by a variable inside the corresponding RITM and will vary.

Where I attempt to trigger the flow off the table it cannot be found. Only the request table is an option and that will not work because the variable isn't stored in the request.

Are there alternatives to meet the business need? I'd prefer to not add wait to the RITM workflow as the customer should be alerted the REQ has been completed and the follow up mitigation items should be hidden.

[Kieran Anson]

Hi Tiffany, You need to link the flow to the catalog item. Once the flow is published / activated go to the catalog item and there will be a tab called "engine" and a reference field called flow

[TiffanyL]

I was able to follow along but it looks as though the catalog item configuration only allows one or the other (either the workflow or the flow version) and not both. My end goal is to have the RITM close properly, workflow complete and kick off this additional (net new build) flow for reclamation. Unless you've addtl ideas, it seems I either A) need to update the workflow to include the reclamation activities (didn't want to do this bc I want the caller to get RITM is fulfilled notif and REQ close) or B) update the flow to include the items occurring in the workflow and the new reclamation steps in the created flow.

[Kieran Anson]

I think you might need to edit the workflow and either do:

1. Add a scripted action to call a servicenow subflow that can take the variable value as the wait time. This effectively hands off the work to flow designer allowing the workflow to end

2. Add the logic as part of the flow. Depending on how it's configured, you could still issue the RITM close notifications but still have the workflow running for this additiona wait activity.

[TiffanyL]

After further review and discussion at a developer meetup, I thought I'd share what ultimately helped me solve this use case. Since I wanted the original RITM to execute and fulfill, I added script in that workflow to capture what the reclamation date would be (based on the variable defined in the RITM) and stored that in the work_end field. I then created a daily flow designer that checks for those RITMs where work_end = today and if yes, then trigger my notification and task. Hope this helps!

//thanks Las Vegas Developer's meetup

[SanjivMeher]

Below threads should help you. You can't create a flow on sc_req_item. Using the Flow designer for Service Catalog, it can trigger when Request/item is created, but it can't trigger when it is updated using flow. You may need to use a workflow or an API i guess as mentioned in the thread. There is also a HI Known Error, but I can't find the link which says it is done purposefully.

https://community.servicenow.com/community?id=community_question&sys_id=658b27b4dbde18903daa1ea66896...

https://community.servicenow.com/community?id=community_question&sys_id=5c2c87f4dbcc730814d6fb243996...

https://community.servicenow.com/community?id=community_question&sys_id=38333caddb98fb445129a851ca96...

https://community.servicenow.com/community?id=community_blog&sys_id=2f163ad1db2c9490190dfb2439961942