cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lachr
New Member

Monthly reminder to Project owner

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Brad_Groux
Community Champion
Community Champion

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!

View solution in original post

4 REPLIES 4
Brad_Groux
Community Champion
Community Champion

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!

View solution in original post

jonathanmweaver
Advocate I
Advocate I

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
New Member

Hi,

Thanks for your feedback.

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

Capture.JPG

Brad_Groux
Community Champion
Community Champion

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 👍.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,394)