cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Format estimated close date for Dynamics 365 Opportunity

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'."
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate II
Advocate II

Re: Format estimated close date for Dynamics 365 Opportunity

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

View solution in original post

1 REPLY 1
Highlighted
Advocate II
Advocate II

Re: Format estimated close date for Dynamics 365 Opportunity

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

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,777)