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 @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.
Hello,
I have designed the below but running into loop and triggering notification for all rows. Any advice how to resolve this issue?
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
28 | |
27 | |
27 |