How do I get my flow to send an email if a date is approaching in two weeks? This is what I currently have but its not working. Is there an error in the condition or the variable?
Date is Less than or equal to formatDateTime(addDays(utcNow(),14),'yyyy-MM-dd')
Thanks in advance.
formatDatetime gives you output in string whereas if you are comparing output of this with actual datetime field it wont work . You need to format your date time field to the same format before putting your logic there.
Could you provide an example? The issue for your current condition is checking the date which is todays date always going to be less than 14 days ahead.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.