Date Format Data Card => from Data Verse Table

(0) Share

Report

Posted on by GuMean

I am using data verse for Teams to build a canvas app in Teams. I have created a Due Date column:

The Due Date card is using the following format:

I would like the date to appear dd/mm/yyyy instead of the above format.
My date and time settings in PC are set accordingly. I have tried to add Text(....),dd/mm/yyyy to display name property of due date data card but this did not work. Please advise. Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

Hi @GuMean ,

Could you check your date settings?

1. In your environment, select Advanced Settings

2. Select the chevon near Settings and select Administration

3. Select System Settings

4. Adjust the settings under the General and Formats tab

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
GuMean 77 on at

Like (0)

Report

Thanks for your response.
I am in the Power Platform admin center:
But, I do not see Advanced Settings option?
Also, this app was created in Microsoft Teams.
Thanks for your help

Was this reply helpful? Yes No
GuMean 77 on at

Like (0)

Report

In my PowerApps environment, I do see the settings (which is all in correct format):
But, in my Teams Environment, where I have created the App, I do not see Advanced Settings option:

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@GuMean ah I should have read your initial post correctly. As far I am aware there is not a fix for this problem.

https://ideas.powerapps.com/d365community/idea/c26181f3-ce21-4e28-a363-3e106e19556d

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
GuMean 77 on at

Like (0)

Report

Can an expression be used in the value property of the datacard value that holds the date? Currently, the value property is set at Parent.Default. I have tried Text(Parent.Defaul', " dd mmm yyyy"), to no avail.
Thanks

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@GuMean - the workaround used to involve turning Classic controls back on, and then changing the Format of the classic Date picker control. Unfortunately this feature has now been retired.

You could update the Default property of the DataCard (not the Data Card Value) with:

Text(ThisItem.'Your Date Field', "[$-en]mm/dd/yyyy hh:mm")

However, this is pointless because the field will default back to the incorrect format each time you re-select the record or make an update.

If you have a "View" mode for your form, an alternative option is to hide the Date picker control when the Form is in View mode and instead display a Label with the correct formatting for the saved Date.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No