Business rules concanenate

[Kesh]

Hi,

I would like to create a business rule that will fill the "Name" field of a custom entity.

The field "name" will  be a concatenation of 3 fields:

- Field "User.'Full name'

- Field "Year"

- Field "Week_Number"

Can someone help me to build this business rule?

Kind regards

[v-xida-msft · Accepted solution]

Hi @Kesh ,

Do you want to create a Business Rule for your custom Entity to fill "Name" field with concatenated three fields value?

If you want to create a Business Rule for your custom Entity to fill "Name" field with concatenated three fields value, I afraid that there is no way to achieve your needs in PowerApps currently.

Within Business Rule, there is no function or operator supported to concatenate multiple fields value for one field in CDS Entity.

As an simple solution, I also think the Calculation field functionality could achieve your needs. You could also consider remove the "Name" field from your CDS Entity, then configure it as a "Calculation" field as below:

More details about the Calculation field in CDS Entity, please check the following article:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/types-of-field... 

Then you could use the CONCAT function to concatenate multiple field values (including LookUp field value) as below:

Within the expression box, type the following formula:

CONCAT(name, "-" ,accountnumber, "-", primarycontactid.fullname)

on your side, you should type following:

CONCAT(user.fullname, "-" , year, "-" , week_number)

Please consider take a try with above solution, then check if the issue is solved.

In addition, I also think the the Workflow functionality could achieve your needs. Please check and see if the following blog could help in your scenario:

https://powerplatformramblingsbystevenblog.com/2012/05/22/how-to-concatenate-two-fields-using-workfl...

Best regards,

[Kesh]

Thank you very much!

[eccountable]

I have a better idea: how about the business rule calls an "Action" to do the calculation or concatenation. I proposed that idea here: https://ideas.powerapps.com/d365community/idea/06e1c7bd-d795-4f33-ad31-062614ab6673