Create a flow through Power Automate to send personalised email when certain conditions are met in a SharePoint List

Harry N Nomikos 1,266 Reputation points

Hi Team

Can someone outline the steps to show me how to create a flow from a modern SharePoint list to an email through outlook when the below conditions are met;

  • when the change status = "Triage in Progress" & the Go Live date is less then 30 Days for a personalised email to be sent to the "Project Contact" requesting more information

Below are the fields in the SharePoint list

  • Change Status (Drop down option)
  • Go Live Date
  • Project Contact= is a free text field with the contact's name.


A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,210 questions
0 comments No comments
{count} votes

Accepted answer
  1. Renjie Sun-MSFT 2,851 Reputation points Microsoft Employee

    Hi @Harry N Nomikos ,

    Here is a flow template for you. Your contact's name field should be an email link.

    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.

0 additional answers

Sort by: Most helpful