Notification email

[Raji15]

Hi,

I have a requirement to send notification email to the employees manager of XYZ company. It is a pre-hire notification email which includes Employee name, email and hire date. It should run on a daily basis in sys_user table. First we have to check if the user is XYZ company employee and the employee's manager should receive an email with all the details. I want to achieved this with Flow designer, Can anyone pls help.

[Rajesh Chopade1]

Hi @Raji15 

In trigger you can able to see the condition as bellow

[Raji15]

Hi @Rajesh Chopade1 , This should run on daily basis on sys_user table. So I have given that condition in trigger.

[Rajesh Chopade1]

Are you facing any further issue?

[Raji15]

Can I still add them in trigger? As I mentioned above I have added "This should run on daily basis on sys_user table." this condition on trigger. Still unable to understand how can I filter the user from XYZ company....

[Rajesh Chopade1 · Accepted solution]

hi @Raji15 

Ok, got it. 

First you add scheduled 'daily' (you already added)

Click on the "+" icon to add an action. Choose "Lookup Records" from the list of actions.

Select table = sys_user, here you can add condition 'company IS xyz company'

have a look bellow image for reference: