Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Reminder Email based on Date

I currently have an excel file with rows containing tasks that are each assigned to a person, along with a due date for that task.

 

I want to notify the owner of each task when they have 7 days remaining til the due date of their tasks.

Are alerts via PBI service the best/only method? I understand you must use KPI, Cards, or Gauges.

 

Ideally, would like to automate so the spreadsheet owner does not have to manually notify each task owner.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please refer to the video. There is how to set up a workflow to look for tasks due in 7 or 14 days and send specific email reminders to the person responsible for the task.

    Power Automate Send 7 or 14 day Task Due Reminder Emails - YouTube

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      I need the alert to come from Power BI as well. I will look into automate but the pre-requisite there is an alert created in PBI Service.

      I am trying to create an alert based on dates <= 7 days from today. Is this possible within power bi?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Please refer to the video. There is how to set up a workflow to look for tasks due in 7 or 14 days and send specific email reminders to the person responsible for the task.

    Power Automate Send 7 or 14 day Task Due Reminder Emails - YouTube

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.