Answered

PowerApps Date and SQL

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've created a Powerapp for data entry which contains a date field using Today(). The App writes back to a table in a SQL database via a power automate flow.

When I run the app in a browser the date is displayed as MM/DD/YYYY and the App writes back to SQL. However when I run the App on a mobile device the date is displayed as DD/MM/YYYY and the App does not write back to SQL.

The error on my Flow is:

Conversion failed when converting date and/or time from character string.
clientRequestId: add48fa2-e6cd-49ff-8d42-7290f9dbeab2

I'm not sure why the mobile version displays the date differently but it appears to be problem.

How can I fix it?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

What I've tried and found out.

My browser was set to English(US) and the app worked. I changed my browser to English and the app worked; all from within the browser.

I changed the Region on my iOS device from UK to US and the app worked.

My server is in the UK.

Whilst I can get it to work it's not reasonable to ask employees to change the region on their devices.

Any help would be gratefully appreciated. Thanks

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I found a better solution that putting the date in the Powerapp. In the SQL table I've added a column that automatically populates the date when a row is added

CreatedDate date DEFAULT GETDATE()

This way I can remove the date from the powerapp and it works across desktop and mobile devices.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Glad to see you found the Solution.

Maybe you could consider marking your answer as a 'Solution' so that it will be useful for others and close the case.

Cheers!

Best Regards,

Charlie Choi

Was this reply helpful? Yes No