cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kanathi
New Member

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

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 flowpower automate flowformform

 

 

 

 

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

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

vbofengmsft_0-1634695187763.png

Best Regards,

Bof

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,422)