Create multiple RITMs under one request using MRVS on cataog item

[Utpal Dutta]

Hi community members,

I have a wired requirement where we can't use Cart on our portal because we are requesting technical services from this specific portal.

We need to have a single catalog item request form, from where user can add multiple values to some variables using MRVS and submit.

Once submitted, we need to fetch MRVS values and order individual catalog items depending upon MRVS values.

We can do this via flow but the question is "What should we show user on order summary page?". Since flow running will take some time to generate request and requested items into it.

Also, we can't use order guide as there can be scenario where we need to raise a signle catalog item multiple times with different variable values.

Any ideas or suggestion will be appreciated.

Thanks

[Di Zhang]

Just a idea: When the main request item is submitted, extract the MRVS values and generate child items attached to this parent item.

[Utpal Dutta]

It won't work like that as flows or workflows for those indivisual catalog items will not be triggered.

[Utpal Dutta · Accepted solution]

To community members who wants answer to this question:

You will need to create a Record Producer with MRVS & SubFlow to process MRVS values and generate request id as output.

Steps to follow:

1. Create Record Producer and abort action in Record Producer script. You need to create this record producer on any other table than Request Management tables like RITM or REQ.

 

2. Create MRVS (Multi-Row Variable set) with variables you like:

3. Now create a SubFlow to process MRVS values as SubFlow inputs from MRVS script.

4. In SubFlow iterate through inputs meaning MRVS array of objects using For Each item in MRVS

5. Add items in cart using Cart API and a custom action. Create an action in flow designer with inputs like below:

6. Add a script step after inputs to process inputs and add in cart via script

7. Once Add to cart action is created then call this action in Subflow to add items to cart.

 

8. Now you can all this Add to cart action to add as many catalog item request you want in your subflow

 

9. Now create order cart action to order all the items you have added in cart

 

10. Order cart action will generates an output which is JSON of request number & sys_id.

 

 

11. Order cart and assign subflow outputs as order cart output

 

12. Once your subflow is ready. Save and Publish it and then copy it’s code snippet by click on 3 dots on top right

 

13. Paste this code snippet into your record producer script and make sure sync run of subflow is uncommented.

 

14. Pass MRVS values as input to this subflow like above and build URL with outputs like above. This will redirect you when you submit the record producer.

And that's all. I know this solution takes time to implement but it’s low code. 

I hope you all like my answer. If you really do then please mark my answer helpful.

I want to extend thanks to my Architect - Rohit Gera who helped me with this solution.