How can Flow Designer email the schedule for the day?

[Sato3]

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

[Sato3]

Hi, @Ankur Bawiskar .

The Flow Designer you provided works fine, but if there are multiple users whose Last_Login field has been updated, is there an approach that allows you to email the information of multiple people at once?

[OlaN]

Hi,

Create a Flow variable, and populate it with the data as needed, then attach the contents of the Flow variable in the email text.

[OlaN · Accepted solution]

Example below:

[Sato3]

Hi, @OlaN .

I can't set a variable, is there anything I'm missing?

[OlaN]

You will need to create a variable on your Flow first.