I wanted to share the solution I was able to build in Flow Designer without using any custom actions or scripting.
I started with a Service Catalog trigger, then used Get Catalog Variables to retrieve the specific variables I needed.
To associate multiple RITMs with the REQ, I added a Look Up Record on the sc_request table to retrieve the Sys ID of the parent request.
From there, I applied If / Else If conditions based on the catalog variable checkboxes:
If IT Systems is true → update the primary Request Item record.
If Finance is true → create a Request Item record.
If Information Security is true → create a Request Item record.
For the Else If conditions:
If Information Security is true and IT Systems is false → update the primary Request Item.
If Finance is true → create a Request Item record.
For the final Else condition:
If IT Systems is false and Finance is true → update the primary Request Item.
If Information Security is true → create a new Request Item record.
Finally, I used an Update Request Record step.
The tricky part was ensuring that updates to the REQ didn’t wipe out values when non-primary RITMs were being updated (since the primary has the flow context attached to it). My workaround was to use the Look Up Trigger Service Catalog Request Item record to pull values from there.
Attempting to populate the REQ directly from the catalog variables would cause errors, but pulling them from the trigger record worked reliably.
I hope this helps!
