Setting a condition when a task progress listed in Sharepoint is not Completed

[Anonymous]

Hi, currently I am facing a problem about the flow below that I can only send reminder email when the task is due in 3days but it cannot detect the task that is due in 2 days, as I want to set a reminder for all task that is less than 3 days from the due date. In addition, I also would like to add in a condition that when the task progress that listed in Sharepoint is not completed only would proceed to the due date condition to avoid email sent for the task that has been completed.

Lastly, I also want to avoid reminder email sent to the assignee before the start date as sometimes the start date and the end date will be very close which may need to complete the task in two days. Is there any condition I can add in to the flow to avoid this issue?

Thank you very much

[Gopala_Krishna]

@Anonymous 

I have tried replicating the scenario from my side, based on the requirement that you have shared and below is the flow designed that I came up with.

--> In this I am using the Get Items to extract all the items present in the SharePoint

--> Then I am using condition to check if Status is equal to Completed if true then do nothing if false then proceed to next step

--> In the next step I have a condition to check if the remainder date is falling before 3 days or 2 days or a day. I have configured the condition which deducts 3 days from the end date configured in the list and checks if todays date is greater than the result. This condition qualifies for 2 days as well.

--> In later steps I have put in compose action for reference you can put what ever the actions that you want the flow to perform if the condition succeeds.

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

[Anonymous]

Hi @Gopala_Krishna , thanks for your reply. May I know for the get items' flow, what should I put insert in the filter query column?

[Gopala_Krishna · Accepted solution]

@Anonymous 

You shouldn't have to put it in the Get Items.

The condition has to be specified after the Get Items step.

You can follow the same steps as in the above shared snap