Monthly reminder to Project owner

[lachr]

Hi,

I have a very simple SP Online list with project details and I need to send out an email on the last tuesday every month, to the Project owner, IF two of four conditions are true.

The Project owner has to update status on his specific projects on the list.

How can I do that?

[Brad_Groux · Accepted solution]

Yes, you can do this. See the Run Flows on a Schedule documentation.

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[jonathanmweaver]

For the first step, use the Run Flow on Schedule as Brad linked. That's how to get the Flow to run.

However, I'm guessing you are also asking for the logic on how to check if 2 or more conditions are met.

I'd do something like this:

varConditions = 0

If condition1 = True, varConditions + 1

If condition2 = True, varConditions + 1

If condition3 = True, varConditions + 1

If condition4 = True, varConditions + 1

If varConditions gt (greater than) 1, then send the email.

If this post answers your question, please mark as Solved so others may find the answer more quickly.

If you like this reply, please click the Thumbs Up button.

[lachr]

Hi,

Thanks for your feedback.

My flow looks like this, I do not get any errors but unfortunately no mail notifications either.

[Brad_Groux]

Insure that the columns that you are trying to compare are in the default lit view, or add a custom list view and populate it in the Limit Columns by View field of the Get Items step.

If you are still having issues, please provided a detailed view of your Flow's run history - where we should be able to find out where the logic is taking it. 

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.