Compare entered date with existing dates in PowerApps/Flow

[biuser99]

Hello,

I have a date entry field in powerapps where users can select multiple dates. After user enters the dates, I need to check date difference between the entered date(s) and existing dates and trigger email notification if the difference between 2 dates is less than 90 days.

The column is mapped to SharePoint list.

Any inputs please

Thank You

[v-litu-msft]

Hi @biuser99,

Currently, there is no function like DateDif() function that could be used to calculate the Days between two dates. AS a workaround, you can use the addDays() function instead.

If  addDays(variables('Date1'), 90) is greater than variables('Date2'), it means between Date 1 and Date 2 is less than 90 Days, or it is greater than 90 days.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[biuser99]

Hi Lin,

Thanks for the reply. The problem is I have to compare dates within the same field and not two different fields. I'm not sure if the below approach works for my scenario. Any thoughts?

Thank You

[biuser99]

Hello,

I have designed the below but running into loop and triggering notification for all rows. Any advice how to resolve this issue?