Announcements
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?
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/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
No go.
@lardo5150 ,
Could you please tell me how it is getting saved in dataverse. Is it in yy/MM/dd format?
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.
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.
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
I am not sure i am in the right spot, cause my stuff looks a bit different than your screenshot
The screenshot which you shared is system settings. Select settings->options that will open personal settings, check short date format in there.
Looks correct
Then it dataverse column it will save in that format only.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
