Announcements
Can someome tell me what is wrong in this formula column in Dataverse?
I got the error:
Unexpected characters. The formula contains 'Error', where 'ParenClose' is expected.
Hi @anacarolinagr ,
I don't know of a supported function in the Dataverse PowerFX formulas that will accomplish this requirement. You can do "UTCNow()" to get the UTC date time as a field in Dataverse through PowerFX.
Actually I need a formula that changes the format of another column to the format mentioned. I used Now() just as an example. Do you know how I could do that?
This is the sharepoint formula that I need to pass to Dataverse
Not possible that I know of. Now, with Dataverse there are default columns in all tables including the CreatedOn an ModifiedOn fields which are date fields that will contain the date and time the record is created and the date and time the record is last updated. When you configure dataverse you can setup the format for dates and users can view their dates (under personalization options) in their required format.
Hopefully this default functionality meets the needs of this column.
Hi @anacarolinagr
I believe you may need 'DateTimeFormat'.
You may find the following links useful:https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-datevalue-timevaluehttps://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/show-text-dates-times
If you find my answer helpful then please do give it a thumbs up and if it helps address your query then please accept it as a solution.
Kind regards
Gulshan
Hi @gulshankhurana ,
I don't think DateTimeFormat is valid within the column definition formulas for PowerFX in Dataverse.
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 600
WarrenBelz 478 Most Valuable Professional
Valantis 322
