The CreatorCon Call for Content is officially open! Get started here.

Email to all users in MRVS

rambo1
Tera Guru

HI Team, 

I have a MRVs set with name and email.

when request is submitted and approved , I want all the emails in MVRS to receive email . How can I do this ? those emails or users are not part of user table in servicenow.

2 REPLIES 2

pavani_paluri
Giga Guru
Giga Guru

Hi @rambo1 ,

 

Parse the MRVS data (which is stored as a JSON string).

Loop through the MRVS entries, extract the email field.

Send an email to each address using gs.eventQueue().

 

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Pavani P

kaushal_snow
Mega Sage

@rambo1 ,

 

You can achieve this by writing a Business Rule (or Flow/Script Action) that triggers after approval, then reading the MRVS variable (e.g current.variables.my_mrvs_name), parsing it as JSON, iterating through each row to collect email addresses (even if they’re not users in the system), and feeding that list into an event (via gs.eventQueue) so your email notification To field can send to all those addresses....

 

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

 

Thanks and Regards,
Kaushal Kumar Jha - ServiceNow Consultant - Lets connect on Linkedin: https://www.linkedin.com/in/kaushalkrjha/