Powerautomate to send email every 2 weeks based on column value

James Vose 21 Reputation points
2021-03-18T16:55:24.207+00:00

Hello, i need to create a straight forward Email alert that sends the creator of a Sharepoint list item an email everything 2 weeks if the field 'Status' equals 'Open' As soon as 'Status' equals closed this workflow can then stop. its just to remind the creator to keep an eye on the log entry as long as its in an open state.

thanks
James

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
499 questions
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,101 Reputation points
    2021-03-19T06:29:39.21+00:00

    Hello @James Vose ,

    Please the following steps:

    1.Add a Trigger "Recurrence" : You can specify the specific trigger time

    2.Add an Action "Get items"

    3.Add the Condition

    • Status Value is equal to Open

    4.If yes: add an Action "Send an email (V2)"

    5.Save and Test it

    79456-flow.png

    Thanks,
    Echo Du

    =======================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.


1 additional answer

Sort by: Most helpful
  1. James Vose 21 Reputation points
    2021-03-22T10:15:44.32+00:00

    Thanks Echo

    Ive already tried but it doesnt seem to like the Open free text in the condition, does it need to be in " "

    80056-capture.jpg