Run Flow on multiple tables at a time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2022 04:56 AM
Hi there,
I have created a flow like this:
This flow will make the release record Active when state reset to Draft from Closed complete/Cancelled.
I want to do this for few other tables like rm_task, rm_release_phase and rm_feature.
I don't want to create separate flows for each of the table. Is there a way to adjust this flow so that it will run for all the tables I mentioned above.
Please suggest me on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2022 05:03 AM
Hi
basically, a Flow can only be triggered for one table. But you can look up the records in all the mentioned tables and update them with the respective action accordingly.
Kind regards
Maik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2022 05:05 AM
Hi,
Its not possible to trigger one flow on multiple table record update.
However, instead you can create common subflow and pass inputs like table name and field values to it. You can use same subflow in every flow if the functionality is same.
Let me know if you have any further queries.
Please mark this as Correct or Helpful if it helps.
Thanks and Regards,
Abhijit
Regards,
Abhijit
ServiceNow MVP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2022 05:34 AM
Anyway we have to create separate flows right?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-11-2022 03:21 AM
Hi Harish,
I am pretty sure that you can do it with subflow by passing variable input to subflow like Table Name, field names to be updated, field value.
Here Script to call flow you can find how we can call flows, subflows and actions with scripting.
However, I think you can do the same with flow as well, if you look at above link they have given a way to pass input to flow as well (but to be frank I haven't tried this practically so not sure how to access those input variables in flow)
Please mark this as Correct or Helpful if it helps.
Thanks and Regards,
Abhijit
Regards,
Abhijit
ServiceNow MVP