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
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.
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.