Personalized Community is here!
Quickly customize your community to find the content you seek.
Microsoft Customer Co-creation
Help impact how the tools and services you rely on are developed. Microsoft Customer Co-creation connects you directly with our engineers so you can provide feedback before a single line of code is written. Interested? Learn more at Microsoft Customer Co-creation
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Is it possible to merge 2 fields with data in to 1 field or a new field in a Sales form?
Or maybe display data from those 2 fields in 1 field with the possibility to edit the data?Please advise.
with code is possible
You can go Settings > Process to create a workflow to achieve it.
Add field1 and field2 dynamic value to field3:
Save and active it.
After clicking save button, the value of field3 can be updated.
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
You can also try to create a Calculated field on your entity and use Concat() function in it. But there are restrictions on your field type.
You can refer to Define calculated fields with Dynamics 365 Customer Engagement (on-premises) | Microsoft Docs to create a Calculated field.
Thank you Leah Ju, very helpful :)
We can merge the value of two different fields and populate the same in third field using “Power Automate Flow” as below:
• Create a new Power automate flow and registered the same on Create and Update of respective field using “When a row is added, modified or deleted” action of Flow.
Below is the screen clip for your reference:
• Add another action (i.e. Update a row) where we have to merge value of two different fields into third field. So we took below example for the same.
Example: Merge value present in First Name and Last Name field and update the same in “Account Name” field and for the same we used “concat” function which is present in flow to generate required string as shown below:
Expression: concat(triggerOutputs()?['body/new_firstname'],' ',triggerOutputs()?['body/new_lastname'])
• Tested above flow by creating new Account record and also by updating respective fields (i.e. First Name and Last Name) and noticed that it is working as expected. Below is the screen clip for your reference:
Note: Microsoft recommends to use Power automate instead Workflow so use this(Power Automate) latest feature of Microsoft so we can achieve requirements like above using “Power Automate Flow”.
Hope this helps.
Business Applications communities