Recurrence Power Automate Flow

Question

I am trying to create a recurrent flow that sends a reminder email to the employee 11 months after the request date and the SharePoint status is marked as completed. I have created a list column with Status ( Completed, Rejected), RequestDate, and Name. Reminder email should only be sent out one time when the above requirements are met. It should not send another reminder when the flow runs again the following day. My flow runs with no errors and I was able to get emails but after few days of running the flow stopped sending out the email. I have an item that satisfies the requirements but the email is not running/sending out reminder to the appropriate user.

Answer 1

Hi @Magie,

Thank you for posting in this community.

I checked the images you shared and noticed some discrepancies in the logic of your flow and your description. Your flow will start executing every day starting November 25th at 11:45 a.m. The filter for Get Items is that the request date in your list is the current date minus 6 months. (The subtractFromTime function is used to subtract time.) Your text description was emailed 11 months after the request date.

First, I suggest you double check how often you need to space out your email reminders.

Secondly, here I offer you a way to troubleshoot flow problems. Please navigate to Power Automate>My Flows>click on this flow and go to the details page for that flow. In the run history below look for the history of your latest run and click on it. This allow us to better check the exact value of each variable when you run it and find out why the problem is occurring. If it is convenient, you can also share the input and output information of each step with me. Please be careful not to give away your private information.

Thank you for your time and efforts in advanced.

---

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.