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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
JerryVividMiM 33 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Akhila1 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No