Dataverse for Teams why is Date control (date only) showing also time and wrong region format

[AndrewS]

I have created an Teams app using dataverse for Teams. When I ceate a date column for a table used by the app , with the options 

Data type : Date & Time

Time zone adjustment : User Local

Input method editor : Auto

When I add a date control to the app it not only shows the date but also the Hour and minutes, even though in the column setting is date only. Can i just hide the Hour / Min controls?

Also when I preview the app in the Power Apps studio it displays dd/mm/yyyy which is what I expect (my region settings are UK).

When I run the app from Teams dates are displayed as mm/dd/yyyy . I do not understand why as my Win10 settings are UK language and also my O365 profile is also set to UK. This happens both in the Teams app an Teams running from  a browser. 

Are there any settings that I need to set in the Dataverse for Teams enviroment ?

[AhmedSalih]

Hello, @AndrewS, in your Environment go to Advanced Setting > (Click on the Settings Gear) >> Options and change the Format for your Date:

This will change your Dataverse Environment Date format. Check it out and let me know if that solve the issue. 

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

[Stevejm]

I have this question too.  We are just moving from Sharepoint to Dataverse for Teams and when creating date column in Dataverse it is defaulting to USA format and we must have UK format. I have looked at environment setting under Power Automate (as that appears to be the only place I can view the DV4T environments and there is no option for changing the date fomat. Any help much appreciated as this is a showstopper for moving to DV4T.

[AhmedSalih]

@Stevejm, if you go to flow.microsoft.com do the following.  Change the Country to UK

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

[Stevejm]

Hi Ahmed, thanks for the response but I’ve already checked these settings and the display language is ‘English’ and the Regional Format ‘United Kingdom’ but the date format, as mentioned, is defaulting US date in my Dataverse table in Dataverse for Teams still

[AhmedSalih]

@Stevejm, for the Dataverse, you need to change the Environment customization as mentioned in my First Reply.

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

[Stevejm]

Hi Ahmed, how to I get to the environment settings for Dataverse for Teams please as settings for Teams have limited options and I don’t get this box 

[AndrewS]

@AhmedSalih  Thanks for your help so far , but I also cannot find this advance settings. Dataverse for Teams has very limited settings to change , in the enviroment admin panel. Which is also different from the screen you showed on the Power Automate home page. What I have done is enabled a classic date control in my Teams app and used that instead of the fluid UI default control. Would there be something else that we have missed? 

[AhmedSalih]

@AndrewS, this is not in the Admin Center. Go to your Environment https://make.powerapps.com/environments/YOUR-URL  

Click on the GEAR on Top-Right >> Advanced Settings >> Again Click on the Gear on Top Right >> Options >> Formats >> Customize

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

[AndrewS]

@AhmedSalih  This screen is what i see https://docs.microsoft.com/en-us/power-platform/admin/about-teams-environment#dataverse-for-teams-en... . I will see if I can create a screenshot of my Teams environment settings.