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 the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.