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.
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?
Proud to be a Flownaut!
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.
From Create a new record
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
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.
User | Count |
---|---|
50 | |
17 | |
15 | |
12 | |
12 |
User | Count |
---|---|
58 | |
40 | |
24 | |
20 | |
19 |