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

Harry N Nomikos 1,336 Reputation points
2022-11-22T10:12:02.253+00:00

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.

Regards,
Harry

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

Accepted answer
  1. Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee
    2022-11-23T03:06:39.417+00:00

    Hi @Harry N Nomikos ,

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


    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

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.