I have a simple lookup table with four columns - Project Manager
1) Manager Name (Primary name)
2) First Name
3) Last Name
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?
Solved! Go to Solution.
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.
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.)
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.