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
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?
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