web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps We cannot convert the ...

Power Apps

Unanswered

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

Report

Posted on by Murcus finn

2

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 Img

All responses (1)

Answers Img

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

Join the conversation