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
Hi @Anonymous,
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.
Hello,
I have designed the below but running into loop and triggering notification for all rows. Any advice how to resolve this issue?