web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Format estimated close...
Power Automate
Answered

Format estimated close date for Dynamics 365 Opportunity

(0) ShareShare
ReportReport
Posted on by 68

I have a flow that creates a new record (in Opportunities) in Dynamics 365 when a new email arrives. I can't figure out how to format the date for the expected close date field. I want the expected close date to be 30 days from when the email is received.

 

I have tried a couple things but most recently set it to: 

formatDateTime(addDays(triggerBody()?['DateTimeReceived'],30),'MM/dd/yyyy')
 
The dates in Dynamics are displayed as MM/dd/yyyy so I'm not sure why this doesn't work.
 
The error message I get is: "Cannot convert the literal '08/25/2018' to the expected type 'Edm.DateTimeOffset'."
Categories:
I have the same question (0)
  • Verified answer
    MitchC3 Profile Picture
    68 on at

    formatDateTime(addDays(triggerBody()?['DateTimeReceived'],30),'yyyy-MM-dd' works

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard