Edit

Power Apps connector (preview)

  • Article
  • 2 minutes to read

Bring unified customer profiles into your personalized apps with Microsoft Power Apps.

Connect Power Apps and Dynamics 365 Customer Insights

Customer Insights is one of the many available sources for data in Power Apps.

Refer to the Power Apps documentation to learn how to add a data connection to an app. We recommend you also review how Power Apps uses delegation to handle large datasets in Canvas apps.

Available tables

After adding Customer Insights as a data connection, choose the following tables in Power Apps:

  • Customer: to use data from the unified customer profile.
  • UnifiedActivity: to display the activity timeline in the app.
  • ContactProfile: to display the contacts of a customer. This table is only available in Customer Insights environments for business accounts.

Limitations

Retrievable tables

You can only retrieve the Customer, UnifiedActivity, Segments, and ContactProfile tables through the Power Apps connector. ContactProfile is only available in Customer Insights environments for business accounts. Other tables are shown because the underlying connector supports them through triggers in Power Automate.

You can do a maximum of 100 calls per 60 seconds. You can call the API endpoint multiple times by using the $skip parameter. Learn more about the $skip parameter.

Delegation

Delegation works for the Customer table and UnifiedActivity table.

  • Delegation for Customer table: To use delegation for this table, the fields need to be indexed in search & filter index.
  • Delegation for UnifiedActivity: Delegation for this table only works for the fields ActivityId and CustomerId.
  • Delegation for ContactProfile: Delegation for this table only works for the fields ContactId and CustomerId. ContactProfile is only available in Customer Insights environments for business accounts.

For more information about delegation, go to Power Apps delegable functions and operations.

Optionally, add customer profiles to a gallery control.

  1. Add a gallery control to an app you're building.

    Add a gallery element.

  2. Select Customer as the data source for items.

    Select a data source.

  3. Change the data panel on the right to select which field for the Customer table to show on the gallery.

  4. If you want to show any field from the selected customer on the gallery, fill in the Text property of a label using {Name_of_the_gallery}.Selected.{property_name}

    • For example: Gallery1.Selected.address1_city

  5. To display the unified timeline for a customer, add a gallery element, and add the Items property using Filter('UnifiedActivity', CustomerId = {Customer_Id})

    • For example: Filter('UnifiedActivity', CustomerId = Gallery1.Selected.CustomerId)