You’re offline. This is a read only version of the page.
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 @gulshankhurana ,
I don't think DateTimeFormat is valid within the column definition formulas for PowerFX in Dataverse.
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-timevalue
https://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 @anacarolinagr ,
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.
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
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.
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (