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

Hello olan,

In set variable y , select "logged In user name", are you create variable ? if create where is it created ?Please let me know.

find_real_file.png

Hi,

It's a Flow variable created in Flow designer.

I pointed out how it's done earlier in this thread.

@Sato

you can check the approach shared by OlaN and use flow variable and send single email to that user with all the user names

Regards
Ankur

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

Hi, @Ankur Bawiskar .

 

The Flow Designer format provided by OlaN isn't working well, but is there anything I can offer?

Vishnu Prasad K
Giga Guru

Hi Sato,

 

I think you can do it directly in notifications. Send the notification when the record in the sys_user table is updated and when the last login field changes