PowerObjects Blog 

for Microsoft Business Applications


Retrieving Data from a Related Entity with Real-Time Workflows in CRM 2013


Retrieving Data from a Related Entity with Real-Time Workflows in CRM 2013

Historically in Microsoft Dynamics CRM, when you create a new record within the context of a parent record, the mapping controls what data is populated from the parent. For example, when you create a new contact from an account, the main phone number, address, and description fields are brought down from the account. But if you create a contact record from anywhere OTHER THAN the account—no such luck.

Luckily, CRM 2013 real-time workflows have come to the rescue!  These workflows can fire on change of a field and present the changes while the user is still on the page.  To demonstrate this, we will create a real-time workflow to update the basic contact fields based on the selection of an account.

Here are the steps to create that workflow:

  1. In CRM, navigate to Settings > Processes.

real-time workflows in CRM 2013

  1. In the Create Process window, name the new process. Set the category to Workflow and the entity to Contact. Uncheck the Run this workflow in the background box and press OK.

Retrieving Data from a Related Entity with real-time workflows in CRM 2013

  1. If you have used workflows in the past, you may notice that new options are available in the process window when you choose to run the workflow in the background.
    1. Set the scope to Organization.
    2. Select the desired option for Execute As. Using the system default of "The user who made the changes to the record" has some benefits because the changes will show that user on the audit log instead of the workflow's owner. However, there are times when a workflow needs to run with permissions greater than the average user, and in those cases you would want to change the setting.
    3. Check the Record fields change checkbox, press the Select button, choose Company Name from the resulting window and press OK.

Real-Time Workflows in CRM 2013

  1. Press Select this row and click Add Step and press the Add Step button.
  2. Choose Update Record in the resulting list.
  3. Enter a description on the step and press the Set Properties button.

    Real-Time Workflows in CRM 2013

  4. In the Update Contact form, click on the Business Phone. In the Form Assistant on the right side, set the Look For value to Company Name (Account) and select Main Phone in the next drop down list. Then press the Add button (which will make Main Phone appear in the window below the drop down list) and press the OK button.

Real-Time Workflows in CRM 2013

  1. Follow similar steps to add the address fields to the workflow. In this case, scroll down to the bottom to the Additional Fields section to populate the Address 1 fields. These fields make up the fly-out on the address section of the form.

Real-Time Workflows in CRM 2013

  1. Press Save and Close on the update contact form.
  2. Press Save and then Activate on the workflow form.

    Real-Time Workflows in CRM 2013

Now the workflow is done and ready to run! Simply select a contact and change the customer to test it.

This is just a hint of the power of real-time workflows. Stay tuned for more CRM 2013 news. Happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

11 comments on “Retrieving Data from a Related Entity with Real-Time Workflows in CRM 2013”

  1. Thanks - nice article - would this work for retrieving a price for a product by looking up the price list?

  2. Hi,
    I am trying to find how to check the status of a WorkFlow from the record it has been activated from in CRM 2013.
    In CRM 2011 there is the section on the left that says WF and by clicking there you can display the list of the WFs activated on that specific record.
    How do I do that in CRM 2013??
    Been looking everywhere and could not find it!
    Thanks

    1. Hi Manu - Yes this is functionality is stil available. From record you are looking at in the 'related items area' you can go to 'back ground processes'. This related items area is in the top navigation via the small down arrow. Initially it is a bit hard to find, but once you see it it will be easy the other times.

    1. Hi - An option set can be unique per entity or global -- global options sets you can use across entities. However, you can't have one option set contain all values of sub option sets.

      1. Thanks Joe. I created an option set (OOB) and now I would like to convert it to global. How can I convert a local option set to a global one in CRM 2015?

        1. Hi Ushma Patel,
          You can create global option set easily by opening solution one tab is present in left side "Option sets".
          Thanks,
          Jharana

  3. Hi Joe....

    I hope you are well.

    I don't know if you would be able to assist me, i have the standard set up of accounts and contacts where the account relationship to contact is 1:N...

    I would like to update a field on the contact card, which gets updated on the account manually.... however when following your steps where i need to look for the detail on the account that drop down is blank..

    Is there something that I'm doing wrong?

  4. Hi Joe. This works perfectly fine with single line of text field. There seems to be a problem if I want to populate the setting from a dropdown field (Account form) to the same dropdown options (on the Order from). Am I doing something wrong or is this impossible?
    Thanks a lot

PowerObjects Recommends