Update multiple record in Hardware table?

[Hafila Hatta]

I have a catalog that is using multi row variable set. User will select multiple CI. How do i set in flow designer to update a field in Hardware table according to the selected CIs?

[Juhi Poddar]

Hello @Hafila Hatta 

To update a field in the Hardware table based on selected CIs in an MRVS:

1. Trigger: Set the flow to start on Catalog Item Request.

2. Retrieve MRVS Data: Use Get Catalog Variables to pull in the MRVS data.

3. Loop Through MRVS:

   • Add a For Each loop to process each CI entry in the MRVS.
   • Inside the loop, Lookup Record in Hardware based on the current CI.
   • Use Update Record to set the desired field in the Hardware record.

This structure ensures each selected CI updates its corresponding Hardware record.

Catalog item Configuration considered here to implement the flow is:

Name of Catalog item: Update multiple record in Hardware table

variable set name: CMDB CI

MRVS variable name: Add CI

Please refer to the screenshots attached of flow design for your reference:

1. Flow looks like:

2. configuration in "Get Catalog Variables from Update multiple record in Hardware table"

submitted request: trigger - service catalog > catalog item record

3. Configuration in "For each item in"

4. Configuration in "Update hardware record"

Desired fields can be updated. As an example I have added description field.

"If you found my answer helpful, please give it a like and mark it as the accepted solution. It helps others find the solution more easily and supports the community!"

Thank You

Juhi Poddar