cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Flow to send reminder over due email and 2 days before due date

Hello folks,

 

I have looked at some articles from this forum and tried to replicate the flows, but for some reason, the flow runs for hours and hours and still does not do what is expected. Can you please look at this and let me know what's going wrong.

 

Requirement:- 

Current Sharepoint list has the below three columns (among others).

1.png

 

 

 

 

 

 

1. Only need to look at Sharepoint list entry where the "Confirmed as closed" (Confirmed) column has value "No" or is blank.

2. Overdue notification - An email needs to be triggered every working day to check if the (DesiredCompletionDate) is overdue.

3. Near due notification - An email needs to be triggered every working day to check if the (DesiredCompletionDate) is 2 days away from today.

 

My Flows is designed this way:-

2.png

 

Running this flow has not triggered the 15 overdue entries I have in the Sharepoint list. It seems to keep running forever. Last evening it ran for 15 hours and today I tried twice each time for 52 mins and 1+ hrs before I cancelled them.

 

Any suggestions/help welcome. 

 

Many thanks.

Regards,

Vaz

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Flow to send reminder over due email and 2 days before due date

Hi @Varun_Pai 

 

I can see 3 issues here: 

1. In the filter query, you need to use the full internal name of the column that you want to apply the filter now and there seems to be some mismatch in that based  on the list schema you shared and the expression you have for the query. 

 

2. In the condition 1, the expression in the left side of the condition is wrong. It should be: 

formatDateTime(items('Apply_to_each')?['DesiredCompletionDate'],'yyyy-MM-dd')

3. Similarly, in the condition 2, the expression on left side should be: 

formatDateTime(addDays(items('Apply_to_each')?['DesiredCompletionDate'],2),'yyyy-MM-dd')

Can you make these changes and check if you continue to face the same issues? 

 

Hope this Helps!

 

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
Highlighted
Dual Super User III
Dual Super User III

Re: Flow to send reminder over due email and 2 days before due date

Hi @Varun_Pai 

 

I can see 3 issues here: 

1. In the filter query, you need to use the full internal name of the column that you want to apply the filter now and there seems to be some mismatch in that based  on the list schema you shared and the expression you have for the query. 

 

2. In the condition 1, the expression in the left side of the condition is wrong. It should be: 

formatDateTime(items('Apply_to_each')?['DesiredCompletionDate'],'yyyy-MM-dd')

3. Similarly, in the condition 2, the expression on left side should be: 

formatDateTime(addDays(items('Apply_to_each')?['DesiredCompletionDate'],2),'yyyy-MM-dd')

Can you make these changes and check if you continue to face the same issues? 

 

Hope this Helps!

 

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

Highlighted
Frequent Visitor

Re: Flow to send reminder over due email and 2 days before due date

Hi Yash,

 

Many thanks for your quick response. Please see my comments below.

 

1. The internal column name is "Confirmed". See screenshot below. The column is set up to have default value "No" and can be toggled between "Yes" and "No". Is this ok or needs to be changed?

3.png

2. and 3. made the changes as per your instruction.

 

I just ran the updated flow and still nothing. Its been running for over 10 mins and I still haven't received the notification.

4.png

Please help.

 

Regards,

Vaz

 

Highlighted
Dual Super User III
Dual Super User III

Re: Flow to send reminder over due email and 2 days before due date

Hey @Varun_Pai 

 

was the flow run successful? Can you share details on that? In the apply to each loop can you set and enable concurrency so that multiple parallel branches can run together (... on the apply to each control -> settings -> concurrency)

 

Can you try the above and check?

 

Hope this Helps!

 

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!

Highlighted
Frequent Visitor

Re: Flow to send reminder over due email and 2 days before due date

Hi Yash,

 

Your 1st response to this post was the correct solution. 

 

I noticed the problem was with the Mail V3 connector. It seems to be in beta testing and was the reason the flow was not working fine, after fixing the points you mentioned and changing the mail connector to V2 resolved the issue.

 

Many thanks. 🙂 You rock.

 

Regards,

Vaz

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,570)