RITM Variables such a Number, date along with MRV line items written to a Custom Table

[Peter Williams]

Good Morning everyone,

i have an unusual problem, i need a way  when users submit a request (RITM) to have those variable vaules along with the MRV variable values to be written to a custom table in servicenow.

Ex.

User submits an RITM

Form variables: 

Number

Name

Date

Office

Form MRV Values:

Invoice #

Type

Amount

Details

how it should look in the custom table

The RITM variables will be the same but as each MRV value is entered for the RITM it will change

Number	Name	Date	Office	Invoice#	Type	Amount	Details
RITM0001121	Peter	13-May-24	Toronto	12345-32	Airfare	123.02	to the office
RITM0001121	Peter	13-May-24	Toronto	6587-AV	Taxi	25.25	From the airport
RITM0001121	Peter	13-May-24	Toronto	try-432	Meal	78.41	Dinner

[Vengadesh]

Hi @Peter Williams ,

Did you create the fields with the same field type as in the MRVS?

For e.g.: If its a string field , your custom filed type should also be string

As in the flow execution image, what it indicates is there are no rows in the MRVS.Did you checked whether there are data in the MRVS for the selected RITM?

Try changing the Trigger type as Service catalog and check whether it works

[Vengadesh]

Hi @Peter Williams ,

We cant able to drag and drop the RITM record from the Request record and also we cant able to get the RITM variables too.

While using the Get catalog variables, you have to drag and drop the RITM record , so that you will be getting the value of MRVS from the Triggered RITM record

Modify the flow as below:

Trigger: Service catalog

Get catalog variables: Drag and drop the Triggered RITM record

FYR: