question

JamesVose-9693 avatar image
0 Votes"
JamesVose-9693 asked EchoDu-MSFT commented

Powerautomate to send email every 2 weeks based on column value

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
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JamesVose-9693 ,

Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

0 Votes 0 ·

Hi @JamesVose-9693 ,

Can you tell me whether your issue has been resolved or have any update?

I am looking forward to your reply.

0 Votes 0 ·

Hi @JamesVose-9693 ,

I'm glad to hear that your problem has been solved.

If the answer is helpful to you, you can accept it as answer. The behavior will help others who meet the similar issue in the future quickly find the correct answer.

0 Votes 0 ·
EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT commented

Hello @JamesVose-9693 ,

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.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you Echo, thats worked

Really Appreciated this support?

ill have more powerautomate enquiries over the next few weeks


Thanks!

James

0 Votes 0 ·

Hi @JamesVose-9693 ,

Thanks for your reply.

If the answer is helpful to you, you can accept it as answer. The behavior will help others who meet the similar issue in the future quickly find the correct answer.

Thanks,
Echo Du

0 Votes 0 ·
JamesVose-9693 avatar image
0 Votes"
JamesVose-9693 answered EchoDu-MSFT commented

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



capture.jpg (24.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JamesVose-9693 ,

Of course, you can add "".

80348-1.png

80367-2.png

Thanks,
Echo Du
===============
You can directly click “Comment” option under ”My Answered“ to put forward your opinions and thoughts about solution that I propose.



0 Votes 0 ·
1.png (19.8 KiB)
2.png (80.4 KiB)