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