Browser language settings corrupting the date picker values

[msv]

Hello,

I have a Powerapp based on Azure SQL table. This app is used by me in US and some of my colleagues in UK, India

I have a few date picker fields which has nvarchar(max) as its datatype in the SQL table.

In my app and when I submit the date it gets submitted in the format mm/dd/yyyy. When my colleague submits the date it submits in the format dd/mm/yyyy. Till here it is kind of ok, but when I access my colleagues UK record from the PowerApp the date picker values get corrupted where I can see some random futuristic dates like 2/3/2024 

After so much testing, I observed this has something to do with the Chrome language settings. I am using English US as language in chrome browser and my colleague is using English UK as language in chrome browser. 

Seems like the chrome language settings are overriding and corrupting the UK records or viceversa if the chrome language settings are different across regions.

I tried a lot of configurations using Text conversions but nothing worked. When I made the data type of date picker as date, then the UK folks are unable to submit their form. I did a poc with only 1 date picker field and observed the same as well.

Is there any solution to this problem?. This seems so concerning to me as the data that is submitted is getting corrupted for critical date picker fields.

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

[timl]

@msv 

The crux of this problem is that you are storing your date values in a field of data type nvarchar(max).

If you set the data type of your column to date (or datetimeoffset data type if you want to store times), all of these problems will go away.

Technically, this is the correct way to build this functionality, and this is the approach to you should try to work towards.

[msv]

Thanks for your reply @timl but like I said when I change the datatype to date, the UK users with UK browser are unable to submit the form for some reason. I dont want to store time.

[timl · Accepted solution]

Hi @msv 

If you change the datatype to date, can you screenshot and post the setup of your form, specifically the update property of the card that contains your date picker control?

In case you haven't done this - when you change the data type of a column in SQL, you'll need to refresh the data source in Power Apps.

Just for info, I'm in the UK and I use SQL a lot. Therefore, I'm confident that we can get this setup to work correctly.

[msv]

Yes I tried a lot yesterday(poc) and finally realized that the datacard needs to be refreshed by deleting and adding it back after changing the datatype to date which is a pain I reckon as the datacard as all other icons and buttons that I dont want to delete. May be I need to try just deleting the datepicker and invoking it back to see it will do the complete refresh, otherwise need to delete the card and add it back. But I appreciate your inputs.