Multirow Variable configuration on Flow designer

Alpha_K
Tera Contributor

Hi All,

 

In ServiceNow I have a catalog with the MultiRow  variable set with Internal name as dataset_name.

where it has variables

Project- Type is Look up select box,

Data- selectbox ,

Warranty- single line text

Approver- single line text

based on the project and data the warranty and approver should autopopulate which i have configured  using script include and client script where it fetches the data from the custom table.

 

Where project Alpha to Delta , and data selected is Raw Approval are configured in custom table 1

where project is Gamma and data selected is Maturity approval is configured in custom table 2

 

Can some one please suggest how to achieve the aprroval process in flow designer.

2 REPLIES 2

Satish Rana1
Tera Contributor

Hi @Alpha_K ,

Prepare the MRVS Data
In Flow Designer, MRVS values are stored as a JSON string (not as individual rows).
You can access this string via the Catalog Request Item's variables

Add a Script Step to Parse MRVS Rows
In Flow Designer, add an "Action → Script" step after the catalog item is submitted.

Use a Flow Designer For Each loop to iterate through rows (set from the previous script step’s output).
Inside the loop:
Add: Approval Action
Use "Ask for Approval" → "Ask For Approval (User)"
Approver = item from loop > approver
Approval message = use project/data from row if needed

Access MRVS values: current.variables.mrvs_name Stored as JSON in Flow Designer
Parse MRVS rows Script step Loop through each row
Lookup Approver: GlideRecord Use only if you don’t already populate it in UI
Trigger Approval: Ask for Approval (User) Dynamically assign based on MRVS row

Please mark it helpfull or accept solution if it usefull.

Thank you

Hi @Satish Rana1 ,

 

Thankyou for sharing the inputs can you please help with the script Action.

I have been trying with the script action but that is throwing me the error

Exception while executing request: Could not deserialize value from sys_flow_value with sys_id 883ba9476b4fa61050e3a81970bc3989