
Announcements
i have list of tasks in excel that has due dates.i need to send an email to team as reminder with list of tables that is pending for due every month. the email should read excel for pending last 3months prior and send email every month. ex- is task is meeting is april i need to get an reminder email in feb month. with task name and due dates in table.
Hi @Deepa2 ,
You can create a flow with recurrence trigger that run the flow on the 1st every month. Following the trigger, you need a List rows present in a table action that retrieves data from Excel table, get all rows that due date are 3 month later. Checking whether there is one or more rows in List rows outcome, if yes convert the outcome to HTML table:
If you also need to send emails to specific individuals based on an Email column in the table, you will need more action to get different recipients:
Best regards,