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

All responses (10)

Answers (0)

Prakash4691 1,332 on at

Like (0)

Report

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

@lardo5150 ,

Then it dataverse column it will save in that format only.
lardo5150 Microsoft Employee on at

Like (0)

Report

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

Looks correct
Prakash4691 1,332 on at

Like (0)

Report

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

@lardo5150 ,

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

Like (0)

Report

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

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

Like (0)

Report

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

@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
lardo5150 Microsoft Employee on at

Like (0)

Report

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

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.
lardo5150 Microsoft Employee on at

Like (0)

Report

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

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.
Prakash4691 1,332 on at

Like (0)

Report

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

@lardo5150 ,

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

Like (0)

Report

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

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.
Ram Prakash 5,166 Super User 2025 Season 1 on at

Like (0)

Report

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

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