Email Notification if new user added in User table

Community Alums
Not applicable

Looking auto Email notification option and create requested item for below condition. Anyone can suggest best possible way 

 

1st : If new user added or created under user table need to notify IT support group Email id and create a Request 

 

2nd : if user status change to inactive need to notify IT Support group email id also create a Request 

 

Thanks in advance. 

 

 

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Community Alums 

 

You can do via notifications or via Flow

 

1st : If new user added or created under user table need to notify IT support group Email id and create a Request 

Atul: Create a notification on user table and set on insert

 

LearnNGrowAtul_1-1707210293037.png

 

LearnNGrowAtul_0-1707210279868.png

LearnNGrowAtul_2-1707210319324.png

 

 

 

2nd : if user status change to inactive need to notify IT Support group email id also create a Request 

Atul: 

LearnNGrowAtul_3-1707210355818.png

 

 

To create a request , use the flow designer.

Trigger

Create record

 

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Community Alums 

 

You can do via notifications or via Flow

 

1st : If new user added or created under user table need to notify IT support group Email id and create a Request 

Atul: Create a notification on user table and set on insert

 

LearnNGrowAtul_1-1707210293037.png

 

LearnNGrowAtul_0-1707210279868.png

LearnNGrowAtul_2-1707210319324.png

 

 

 

2nd : if user status change to inactive need to notify IT Support group email id also create a Request 

Atul: 

LearnNGrowAtul_3-1707210355818.png

 

 

To create a request , use the flow designer.

Trigger

Create record

 

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Community Alums
Not applicable

Thank you Will try this option. 

SunilKumar_P
Giga Sage

@Community Alums, If the email notification subject and body contains the same verbiage then you can also try the business rule to trigger an event to send an email notification and also you can use cartAPI or anyother to submit the requested item.

1. Create an Event in the Event Registry on user table.

 

2. Create an after (Insert & Update)Business Rule on user table something like below.

 

(function executeRule(current, previous /*null when async*/ ) {

    if (current.operation() == "insert" || (current.operation() == "update" && current.active.changes() && current.active == false)) {
        gs.eventQueue("user.status.notification", current, '', '');
    }
})(current, previous);

 

 

3. Create an notification of type 'Event is fired' and configure the event created in step 1.

 

4. Use CartAPI / anyother to submit the catalog item.

 

Community Alums
Not applicable

Thank you Will try this option