Answered

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

(1) 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)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @msv

Is someone else submitting data from your app?

Was this reply helpful? Yes No
msv 30 on at

Like (0)

Report
Copy link

Link copied!

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

Link copied!

@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 30 on at

Like (0)

Report
Copy link

Link copied!

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

Link copied!

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