How to use Power Automate to send daily tasks via email with status updates based on user selection

User116218 20 Reputation points
2024-03-15T06:34:08.47+00:00

I have an Excel spreadsheet with columns for member name, email addresses, tasks, and a status column. I want to create a flow in Power Automate that sends one task per day (like one task - one day) via email to each member with options for 'Done' and 'Undone'. If a member selects 'Done', I want the status column to update to 'Done', and if 'Undone' is selected, I want the status column to update to 'Undone'. The next day, I want the undone task from the previous day to be included in the email along with the new task of that particular member, i have given excel data sample for reference. How can I accomplish this?

i created a sample workflow as well

Screenshot from 2024-03-15 11-58-23

Screenshot from 2024-03-15 11-58-58

Screenshot from 2024-03-15 11-59-24

here is the sample excel data

Screenshot from 2024-03-15 12-01-47

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,127 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,852 questions
Windows Autopilot
Windows Autopilot
A collection of Microsoft technologies used to set up and pre-configure new devices and to reset, repurpose, and recover devices.
468 questions
PowerPoint Management
PowerPoint Management
PowerPoint: A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.Management: The act or process of organizing, handling, directing or controlling something.
230 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
618 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. LiweiTian-MSFT 19,250 Reputation points Microsoft Vendor
    2024-03-15T07:14:22.0266667+00:00

    Hi @User116218

    1. You need to replace the Manually trigger a flow trigger with Recurrence, so that your flow will run once a day.

    User's image

    1. Add a Condition in Apply to each to determine whether the task has been done. If it is done, there is no need to send an email. If it is not done, an email reminder will be sent.

    User's image

    ********************************************************************************************************* If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. *********************************************************************************************************


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.