Trigger Notification based on MRVS choice selection

[sujan0119]

I am using a MRVS in my catalog item. The MRVS questions come up when Request type "Contract extension Tenure" is selected. There is a question on MRVS "Specify the Tenure". If choices 1,2,3 selected ,for MRVS question "Specify the Tenure" , the notification should trigger for example abc@xyz .com but if 5 is selected for MRVS question "Specify the Tenure", the notification should trigger for example def@xyz .com . MRVS choices are not showing for selection for "When to Run" condition for the notification. Please suggest.

[GlideFather]

Hi @sujan0119, 
you can create a flow with trigger conditions that submitted record with the particular scenario will trigger the notification. It can be done fully in the flow designer (now it is called "workflow studio").

Or you can use an event for that.

Let me know how you proceed and share some of the screenshots or details of what you have and it will be easier to share some ideas how to achieve it.

[sujan0119]

Hi @GlideFather,

Thanks for the reply ,

I have noticed one thing that for each choice iterated through for MRVS via For each loop, it is triggering notification. If 3 rows are added with 1,2,3 choices it should trigger one notification to   "abc@xyz .com" and not 3 different notification for each choices and similarly for 5, No matter how many rows are added by selecting 5, it should trigger only one notification to "def@xyz .com"  . for example, if four rows are added by selecting "Specify the Tenure" choices as 1,2,3,5 , it should only trigger 2 notifications one for 1,2,3 choice selection and one for row with choice 4 selection. Please suggest

Regards,
Sujan

[Anand Kumar P]

Hi @sujan0119 ,

You can handle this via flow foreach mrvs row you can loop and trigger event.
Else
You can create Business Rule on sc_req_item table

var mvrs = current.variables.mrvs_name;
mvrs = JSON.parse(mvrs);
for(var i=0; i<mvrs.length; i++){

var tenure= mvrs[i].specify_the_tenure;
if(tenure=='1' || tenure=='2' || tenure=='3'){
gs.eventQueue('event_name",current, 'abc@xyz.com");
}
else if(tenure=='5'){
gs.eventQueue('event_name",current, 'def@xyz.com");
}
}

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand