How can Flow Designer email the schedule for the day?

Sato3
Tera Contributor

Hi, All.

I would like to use Flow Designer to fulfill the following requirements. Do you have any advice?

Requirements : 

Every day, once a day, if the Last_login field in the User [sys_user] table contains today's date, I would like to email the user who is the instance administrator with the login record information for the day.

 

This requirement seems feasible, but is there any good idea?

Thank you

1 ACCEPTED SOLUTION

Example below:

find_real_file.png

 

find_real_file.png

 

find_real_file.png

View solution in original post

27 REPLIES 27

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

yes can be done using flow

where are you stuck?

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you can also use daily scheduled job

Query sys_user table and send email via eventQueue approach and include the users who satisfy the query in event parm2

Then use that in email body to print event.parm2

regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi, @Ankur Bawiskar .

I don't have much experience with Flow Designer, but how do I implement it?

Hi,

something like this; you enhance it

find_real_file.png

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader