Answered

Concatenate a date column and a text column using a dataverse formula column

(0) Share

Report

Posted on by JerryVividMiM

I'm fairly new to using dataverses. I want to fill a new column with a date and a text from two other columns in the same row. I created a new column for this with type fx.

When I enter something like:
Text(DateColumn; "dd/mm/yyyy") & TextColumn

Then the syntax is ok, but the error message follows:
This argument cannot be passed as DateTime type in formula columns.

How do I solve that?

Categories:

Tables

Microsoft Dataverse

All responses (4)

Answers (1)

Akhila1 on at

Like (2)

Report

Re: Concatenate a date column and a text column using a dataverse formula column

Yes, you can achieve with the following
Text( Year(UTCNow()), "####" )..Please try and let me know
Verified answer

Jonathan Manrique 2,678 on at

Like (0)

Report

Re: Concatenate a date column and a text column using a dataverse formula column

Hi @JerryVividMiM

At the Column level using Power FX formulas it is not possible to do what you are asking for, it does not allow converting a date into text

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution
JerryVividMiM 33 on at

Like (0)

Report

Re: Concatenate a date column and a text column using a dataverse formula column

Hi Ethan,
Thanks for your response. I've tried it without the concatenation. Even with Now() as value for the date, but this doesn't work either. In the Power FX documentation it says the text function also applies to Dataverse formula columns and no exception is mentioned on the page. Strange, because it seems such an obvious and useful possibility. I can of course solve it in the apps, but it would be better if it is reusable in the table.

Hope somebody else has an idea.

Kind regards,
Jerry
Ethan_009 4,838 Super User 2025 Season 1 on at

Like (0)

Report
Re: Concatenate a date column and a text column using a dataverse formula column

Hi @JerryVividMiM ,

Have you tried different formula just to check if you are getting Date format first and then check your textcolumn value is coming in your field.

Later, you can use Concatenate function like,

Concatenate(Text(DateColumn; "dd/mm/yyyy"); TextColumn.Text)

I am not sure if .Text is used in FX because I haven't used it yet.

But hope this helps