Dataverse Table showing DateOnly as yyyy-MM-dd instead of M/dd/yyyy

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

In my power automate, I have confirmed that I am inputing the date as M/dd/yyyy

But the output on the table is always yyyy-MM-dd

How do I fix this or change this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @lardo5150

Hope you are doing good,

Format the Date time to get the exact date time values

formatDateTime(triggerOutputs()?['body/dateformat'],M/dd/yyyy)

dateformat - pass your logical Name.

Default Syntax:

formatDateTime(utcNow(),M/dd/yyyy)

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

No go.
formatDateTime(body('Convert_time_zone_2'),'d')
I also tried
formatDateTime(body('Convert_time_zone_2'),'M/dd/yyyy')

Same result in the table. Here is my output, same as before.

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

@lardo5150 ,

Could you please tell me how it is getting saved in dataverse. Is it in yy/MM/dd format?

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

Where can you see that at?
I was looking to see if there was a standard format set on the table, but I could not find it.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

I am not sure where to look to see if the table is set on that format.
The functions I am using to add it to the dataverse table from Power Automate are above in the previous comments.

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

@lardo5150 ,

Date time format depends on how we set in our personal options. If you have access to model driven app, navigate to settings->Personalization Settings. Go to Formats tab and look for Short Date format. According to that DateTime and Date only field value gets saved.

Attached screenshot for your reference.

If it answers your question, kindly give kudo and accept it as solution.

Regards,

Prakash

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

I am not sure i am in the right spot, cause my stuff looks a bit different than your screenshot

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

@lardo5150 ,

The screenshot which you shared is system settings. Select settings->options that will open personal settings, check short date format in there.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like (0)

Report

Looks correct

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

@lardo5150 ,

Then it dataverse column it will save in that format only.

Was this reply helpful? Yes No