We cannot convert the value "22/10/2021" to type DateTime. inner exception: We cannot convert the value "22/10/2021" to type DateTime.

(0) Share

Report

Posted on by Murcus finn

Hello guys,

I have a powerapps form that submits data to an sql table through a power automate flow. All field are okay except for the dates field which give the following error on the flow "We cannot convert the value "22/10/2021" to type DateTime.
inner exception: We cannot convert the value "22/10/2021" to type DateTime." The date collums on the sql table have been set to DateTime.see images below. Apparently this is working on a desktop or laptop but on the phone its not the case, could this be a date format issue?. Kindly help

power automate flow form form

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @kanathi :

Could you please show me your setting and expression?

Could you consider directly formatting the date in the iso8601 format in Power Apps and then passing it to the flow?

Text(DatePicker1.SelectedDate,"yyyy-mm-ddThh:mm:ssZ")

Best Regards,

Bof

Was this reply helpful? Yes No