cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cooper01
Solution Supplier
Solution Supplier

Can't convert string to date to set new date only field

I am trying to use an input from Power Apps to create a new record in a CDS entity. Below is part of my Flow configuration.

Config.PNG

I am initializing a string variable called Modified with the value coming from Power Apps. While testing, it is 3/31/2020. In the compose, the full Expression is

 

formatDateTime(variables('Modified'),'MM/dd/yyyy')

 

The Create a new record is not shown in full but in the Date field, I am just selecting Outputs from dynamic content.

The error I get is "An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal '03-31-2020' to the expected type 'Edm.Date'...."

The date field is Date Only type and in Advanced options, behavior is Date only

I am not sure what's wrong with this. I have tried a few other variations of date formatting but haven't gotten it to work. Are there any other problems I'm missing with this?

2 REPLIES 2
Jcook
MVP

Hello,

Have you tried using the convert time zone action?
In the action use Short date pattern as the format string.

Or try using
convertFromUtc('<Time to Format>', 'Pacific Standard Time', 'd')

You can swap the Pacific Standard Time with your time zone. But must follow Microsoft’s ISO
https://support.microsoft.com/en-us/help/973627/microsoft-time-zone-index-values

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Cooper01
Solution Supplier
Solution Supplier

Thank you for the response. I tried using the Convert time zone which is working fine. I am using the Converted time output as my field in Create a new record. The conversion seems to work but am still getting the same error on Create a new record.

Capture2.PNG

From Create a new record

Capture3.PNG

In Create a new record, I also tried using the following expression

convertFromUtc('2020-04-01T08:00:00.0000000Z', 'Pacific Standard Time', 'd')

with both single and double quotes around d and got the same error 

"An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal '04-01-2020' to the expected type 'Edm.Date'..."

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,524)