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.
Solved! Go to Solution.
@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-calcula...
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.
To those who have responded to my questions:
Thank you very much for responding to my questions. I will use the CONCAT function as described by you all.
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. 😞
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT