web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Business rules concane...
Power Apps
Answered

Business rules concanenate

(1) ShareShare
ReportReport
Posted on by 230

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

I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    on at

    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:

    2.JPG

    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-fields 

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

    3.JPG

    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-workflow-in-dynamics-crm-2011/

     

    Best regards,

  • Kesh Profile Picture
    230 on at

    Thank you very much!

  • Eccountable Profile Picture
    48 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard