Answered

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:

Using Apps Using Formulas

All responses (5)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

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

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.
msv 26 on at

Like (0)

Report

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

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?
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

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

@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.
msv 26 on at

Like (0)

Report

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

Thanks for your reply.Well its been rolled out to a set of users and yes they are submitting from the form
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

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

Hi @msv

Is someone else submitting data from your app?