Using flow designer relative conditions

[rdskn023ET]

Having an issue where I am setting up a flow to send an email notification out once a the project completion date is 7 days beyond the current date. I have it set to run daily at a specific time, however, the date ranges are not exactly working as expected. For instance, I am running the flow at 8 am each morning and using the relative conditions as follows:

Project Completion Date relative before 6 days ago AND

Project Completion Date relative after 8 days ago

What is happening is that the PMs are receiving two notifications on back to back days. For instance, on 9/30, projects with a Project Completion Date of 9/23, with time stamps of either 9 or 17 hours, are receiving the email. Then, on 10/1 they are receiving the same email again due to the relative condition. Does anyone have any insight or thoughts on how to ensure that the action is triggered only on the 7th day and not go across multiple days? 

Thanks in advance for any insight!

[Anantha Gowrara · Accepted solution]

Hi @rdskn023ET below condition should give you exactly 7 days duration from current date.

I tested in PDI and it works fine. You must update the condition to say as project completion date instead of planned end date

Created 3 projects with planned end date as 23/09, 24/09, 25/09 and filter is giving me only 24/09

[Anantha Gowrara · Accepted solution]

Hi @rdskn023ET below condition should give you exactly 7 days duration from current date.

I tested in PDI and it works fine. You must update the condition to say as project completion date instead of planned end date

Created 3 projects with planned end date as 23/09, 24/09, 25/09 and filter is giving me only 24/09

[rdskn023ET]

Thanks Anantha! That took care of it. 

[Anantha Gowrara · Accepted solution]

@rdskn023ET that's great. Please mark answer as correct if that worked for you