Answered

Calculated Field in CDS

(0) Share

Report

Posted on by IsaiahA

Hello,

I created a column in an Address entity to add 2 fields together. The fields are "FirstName" and "LastName". I called the calculated column as "FullName". In the formula window, I did the following: FirstName & " " & LastName, it says it is wrong. Then, I changed the columns to cr320_FirstName and did the same with LastName, and yet it is an error. I replace "&" with "+" sign, ditto. I would really appreciate any help.

Thanks,

Isaiah A

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (2)

PowerBack19 679 on at

Like (0)

Report
Copy link

Link copied!

@IsaiahA - Have you tried the CONCAT function in the calculated field's formula? Here is a reference page: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields#calculated-field-functions-syntax

Was this reply helpful? Yes No
IsaiahA 75 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Thanks for you response. There is no CONCAT function on that link. When it comes to calculating two numeric field, it was so straight forward like say: Column1 * Column 2

In the box that designated your formula, I was expecting something like: Column1 & " " & Column2. It is surprising to me that CDS would not give an example of how to concatenate two columns with a string. Hopefully, someone has created a calculated column in CDS that joins two fields together.

Thanks,
Isaiah A.

Was this reply helpful? Yes No
Verified answer

PowerBack19 679 on at

Like (0)

Report
Copy link

Link copied!

Actually the CONCAT function is listed in the "Calculated field functions syntax" section, found right below the DIFFINYEARS and above TRIMLEFT.

Here is the information from the link:
CONCAT (single line of text, single line of text, … single line of text)

Returns a string that is the result of concatenating two or more strings.

Was this reply helpful? Yes No
PowerBack19 679 on at

Like (0)

Report
Copy link

Link copied!

I apologize for not including this screen shot:
CONCAT info from Microsoft Docs

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @IsaiahA ,

Please try this:
Concat(firstname, " ", lastname)

Sik

Was this reply helpful? Yes No
IsaiahA 75 on at

Like (0)

Report
Copy link

Link copied!

To those who have responded to my questions:
Dear All,
Thank you very much for responding to my questions. I will use the CONCAT function as described by you all.
Sincerely,
Isaiah A.

Was this reply helpful? Yes No
testasdfasfsafa 309 on at

Like (0)

Report
Copy link

Link copied!

This approach doesn't seem to work for Lookup field. I need to concatenate 3 look up field and 1 multiselect and cannot find anything online on such topic. 😞

Was this reply helpful? Yes No