Skip to content

Setting up your Microsoft Dynamics 365 custom object and table

To update your Microsoft Dynamics data through campaigning, you must first set up and configure your Microsoft Dynamics table. You can then configure your channel in either Orbit or PeopleStage to begin campaigning.

This example shows how to create a custom Model table in Microsoft Dynamics and set up a channel to push updates to those models in Orbit campaigns for contacts in the Contacts table in Dynamics.

Prerequisites: Edit rights for the PeopleStage or Orbit channel editor.

Creating your custom object

  1. In Dynamics 365, click Create new App. This opens Power Apps.
  2. Give your app a name and click Create.
  3. Click Data from the left-hand menu, then click Create new tables.

  4. Select Start from blank.

    Start from blank

  5. Name the table Model.

    Model table

    A column is automatically set as the primary column.

  6. Click + New column and add the following columns:

    • Name

      Name

    • Score

      Score

    • ExternalID

      ExternalID

  7. Click Properties and set the ExternalID column as the Primary column.

    Primary column

  8. Expand the dropdown on the automatically created New column, then click Delete column.

    New column

  9. Click Save and exit. You can now add a relationship to the Contact table.

  10. Go to Power Apps home and select Tables from the left-hand menu.
  11. Select your Model table from the list.
  12. In the Schema section, click Relationships.
  13. Click + New relationship > Many-to-one.

  14. Expand the Related table dropdown and select Contact.

    Many to one

The result is a Model table with five custom fields.

Table columns

Get logical names

To configure channel field mapping, you need the logical names of the table and fields. Edit each column, open Advanced options, and note the logical name.

Logical names

In this example, the logical names are:

  • Contact → cr1e5_contact
  • ExternalID → cr1e5_externalid
  • Name → cr1e5_name
  • Score → cr1e5_score

Also get the logical name for the Model table itself:

Edit table

  • Model → cr1e5_model

You've now created your custom object. You can create your Microsoft Dynamics 365 channel in Orbit or PeopleStage to start uploading data through a campaign journey.