Launch a subflow through a record producer

[ronro2]

Hi everyone!

I’m trying to figure out the best way to trigger a subflow from a Record Producer and could use some guidance.

Scenario:

• I have a Record Producer based on a custom table (let’s call it table_x).
• One of the variables is a Select Box called action.
• One of the choices in that select box is add_restricted_access.
• The user also selects an assignment group (reference to sys_user_group).

What I want to achieve:

When the user submits the Record Producer and the selected action is add_restricted_access, I want to automatically run a subflow that:

1. Finds all records in table_x that match the chosen assignment_group.
2. Updates the field u_restricted_read_access to false for all those matching records.
   
   

So basically we want to restrict reading access records on table table_xfor the assignment group chosen through the record producer. 

So my question is..

Is it possible to initiate a subflow directly from a Record Producer based on the selected variables?
And if so, what is the recommended approach or best practice for doing this?

Any advice, examples, or pointers would be greatly appreciated!

[yashkamde · Accepted solution]

Hello @ronro2 ,

As per my understanding, Yes you can initiate a subflow but,

don’t try to invoke the subflow directly from the Record Producer script. Instead, let the record creation event trigger a Flow, and let that Flow call the subflow. This separation of concerns is the cleanest, most scalable approach.

Refer this :

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB2657568 

If my response helped mark as helpful and accept the solution.

[Animesh Das2]

Hi @ronro2 ,

Best approach is to create a flow with triggering condition as 'created or updated' on table_x based on required condition and that flow will have subflow inside.

Otherwise, if want to trigger the subflow directly, you can try using FlowAPI, triggered from a server side script(BR). Please have a look at the blog post for the relevant FlowAPIs.

If this address your question, please don't forget to mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das

[AndersBGS]

Hi @ronro2 

As others also have stated, I would advise to trigger det flow from record producer which then calls the subflow by input/output.