How to send mail to employee if he is absent to office uipath

Learning Hub Academy Feedback
, , , , ,
1

Hello All

       Am new to uipath ,how can we send mails to employees based upon his attendance.like if he is absent today he should get a mail .can any one give me idea or workflow to understand the scenario

Thanks,
Pranay

2

@pranay.a - Pls provide few details -
how to identify an employee is off today?
having any system to check?
All employees having a common entry time?

3

@GBK 1.based on excel data we fill the columns like A=absent,P=present if absent send mail to employee
2.if employee leaves the office before complition of office time like 8hr 45mins he should get mail like left early today worked for =total time stayed in office
3.no particular common entry timing
4.we have a fingerprint entry machine which stores the information of employee

4

@pranay.a you can try below

  • read the excel with excel activities

  • do a datatable filter like dt.select(“columnName=A”)

  • based on results datatable -
    do a for each row activity
    use the smtp mail activities/outlook activities to send a mail to the respective employees

  • after development - you can do a trigger /scheduler job on daily/business days with a specific time.

1 Like
5

@GBK
have a doubt the length of dates changes from month to month ,how to select a specific value like (Absnt/Prsnt) from random excel Columns like(02-june,03-june…)

6

@pranay.a - you can add the date filter as well - like

dt.select(“columnName=A and dateColumn = 02/06/2020”)

1 Like
7

@GBK m asking like how to select a specific value(a/p) from random columns(dates) present in excel sheet

8

@pranay.a - you can do a data filter with linq query - however if your going to use the excel for an application - make the excel in standard format.