Auto populate the Primary Name column with the combination of two other columns

[JohnYu500]

Hello,

I have a simple lookup table with four columns - Project Manager

1) Manager Name (Primary name)

2) First Name

3) Last Name

3) Supervisor

What I'd like to do is set the Manager Name to be equal to the First Name + the Last Name so that we do not need to manually type it.

I tried the Business Rule way but I found it only allows me to set the Manager Name to just one column, either the first name or the last name, but both. 

Is there a way for me to do what I need to do?

Thank you.

[shavora]

Does anyone have a screenshot or step by step with this flow creation? I am not able to figure this out.

[FacundoGorla]

In case anyone else still care I tried another way without using any premium feature since I have Microsoft 365 business premium but it doesn't work for power automate.

I created another column with calculation to concatenate name and last name.

Then I created a business rule to set the value of "Name" (Manager Name for you) to the new column I added that is calculation column.

THIS DOESN'T WORK. It leave the name field in blank, you can't use a calculation column in a buisness rule ti seems.

[bpm]

I haven't tried this exactly (as I want a date field in my name column, and the Calculation field can't concatenate single-line-text and date-fields), but I have come across this issue in different contexts. The reason is that the business rules only operate on fields that are in the form. Try adding your calculated field to the form you use to create/update the record, and hide it.

(The context I had where I tried something similar was for showing/hiding/locking fields between creating and updating. So I added a context on Created On: Has Data. This had no effect, until I added the Created On field to the form. The business rule started working, even when I hid the Created On field.)

[TTDUY]

Hi There,

Following your instruction for this issue, I have done setting up my own process, when I created a record, the process runs successfully but I met another issue related to this.

My issue is,

When other peolpe create a record, record was created but the process is not running.

So could you please help me on this?

I have attached a screenshot to show the issue.

Thank you guys!