List Segment Members from Customer Insights - Journeys in Power Automate

List Segment Members from Customer Insights - Journeys in Power Automate

You can create seriously impressive and complex data queries for Leads or Contacts using the new ‘real-time marketing’ segment builder for in Dynamics 365 Marketing (Customer Insights - Journeys). Then use the segment data to provide you with the data set of Contacts or Leads you want to automate with in Power Automate!

For example: the interaction data for email delivery is super valuable in helping to clean up your data. A hard bounced email is a clear indicator for an invalid email address. You can identify Contacts or Leads to unsubscribe, deleted or modify to protect the sender reputation of your domain and give marketers a clearer view on conversion rates.

Read More
Include specific row (entity) references and all the data in Real-time marketing custom triggers

Include specific row (entity) references and all the data in Real-time marketing custom triggers

Custom triggers in Dynamics 365 Marketing (Customer Insights - Journeys) have recently became 1000 times better with the ability to include ‘Entity references’ - a way of making an entire record and all its associated records (up to 5 levels ‘deep’) available through a single trigger attribute. It works exactly the same as the ‘Contact‘ or ‘Lead’ in a trigger works, but for any table/row you choose.

This make all the data available in the trigger journeys for branching and emails for conditional content and personalisation. And you can have lots of these!

Read More
Synchronise SharePoint folder name with row name in Dataverse or Dynamics 365

Synchronise SharePoint folder name with row name in Dataverse or Dynamics 365

Updating the name of a record in Dataverse does not update the name of the linked SharePoint folder or Document Location.

Dataverse is confused, the user is confused, and I am severely triggered by this data disarray. With a little bit of Power Automate magic we can automatically synchronise any record name changes with the SharePoint folder and Document Location, because that’s what it SHOULD do!

Read More
Set Dataverse Choices in Power Automate  dynamically - without a switch statement!

Set Dataverse Choices in Power Automate dynamically - without a switch statement!

Setting the value of a Dataverse choice option set or choices multi-select option set column field in Power Automate can be a little tricky. Flow expects either a static choice or the choice ‘Value’ rather than the ‘Label’. Smaller choices work ok with a switch statement but what about when your choice has 10+ choices? Here is a way to avoid cumbersome switch statements to handle larger choice lists.

Read More