Unanswered

date format getting corrupted that I can see in the Azure SQL table when submitted from Powerapps

(0) Share

Report

Posted on by msv

Hello

When I submit the date from my PowerApp it usually gets submitted in the format 2/19/2021. However sometimes it gets submitted with the format 19/2/2021 that I can see in Azure SQL table. This is impacting my reporting and Power BI reports gets corrupted, where I am using my PowerApp data to build Power BI reports.

So when I go to that corrupted record and resubmit it back again, the date changes back to the correct format that is 2/19/2021.

Not sure what is causing this behavior and how can I avoid it?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @msv

Is someone else submitting data from your app?

Was this reply helpful? Yes No
msv 26 on at

Like (0)

Report

Thanks for your reply.Well its been rolled out to a set of users and yes they are submitting from the form

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@msv

It is likely the problem with one or more of your users who is in a different country that uses that format for dates. Check the DateValue() function in PowerApps that converts a date string to a date/time value.

Was this reply helpful? Yes No
msv 26 on at

Like (0)

Report

ok but how does PowerApp date picker field take different formatted dates when the user enters it from different region/countries?. I believe it needs to be consistent globally right?

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @msv

@Meneghino has a post about international apps and date formatting. https://powerusers.microsoft.com/t5/Building-Power-Apps/Best-DATE-format-for-INTERNATIONAL-app-use/td-p/115579 . Since I am the only one using my apps, it hasn't been an issue with me.

Was this reply helpful? Yes No