Answered

Having error: Cannot convert a primitive value to the expected type 'Edm.DateTime'

(0) Share

Report

Posted on by Mgodby

359

I have an http request that updates a task in project that is triggered by clicking button in powerapps. I am however having an issue when trying to update the start date of the task since the data that I send through powerapps is not accepted.

This is the flow action that I use.

My issue occurs on the last line with Start. I am passing a SelectedData value from a Date Picker object in Power Apps.

I am getting an error saying: Cannot convert a primitive value to the expected type 'Edm.DateTime'. Do I need to cast? I am not very familiar with JSON. Thank you.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Mgodby ,

First, you need to make sure that the value of this Dynamic content output is not empty.

Second, you can try to format this value into the format required by the Start field using the formatDateTime() function.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Verified answer

Mgodby 359 on at

Like (0)

Report
Copy link

Link copied!

I looked into and found out that I needed to format the date into the ISO 8601 format.
Text(UpdateStartDateInput.SelectedDate,"[$-en-US]yyyy-mm-ddThh:mm:ss") worked for me.

1 people found this reply helpful.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Mgodby ,

If you have found a solution to the issue, please click "Accept as Solution" on the reply that describes how you were able to solve your issue!

Best Regards,

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

The solution the OP wrote in the reply is the solution to this problem.

I had the same issue and none of the convert or date format options in Flow resolved it. I also had to format my date in the PowerApp using this:

Text(dpDate.SelectedDate,"[$-en-US]yyyy-mm-ddThh:mm:ss")

And then use that value from the parse JSON action directly in the Send HTTP request. Every other date from the various formatting and convert methods that were recommended in other posts and answers failed with the original 'Cannot convert a primitive value to the expected type 'Edm.DateTime' error. This is the only solution that worked.

Was this reply helpful? Yes No