Error trying to convert DateValue to text

(0) Share

Report

Posted on by anacarolinagr

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
anacarolinagr 48 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
gulshankhurana 1,397 Moderator on at

Like (0)

Report
Copy link

Link copied!

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-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

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @gulshankhurana ,

I don't think DateTimeFormat is valid within the column definition formulas for PowerFX in Dataverse.

Was this reply helpful? Yes No