Document generation before your eyes and on demand with Power Automate

Document generation before your eyes and on demand with Power Automate

Transform how you automate and orchestrate document generation in Dynamics 365 and model-driven Power Apps. How to produce, review and distribute sophisticated documents using Power Automate without compromising on the user experience or leaving your model-driven app.

Read More
Mapping Option Sets/Choice Labels from Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

Mapping Option Sets/Choice Labels from Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

How to make sense of option set/choice responses in a Marketing Form submission, when the form response says ‘15’ but what it actually means is ‘My dog ate my homework’. If your users can’t speak integer then this ones for you.

Read More
Trigger flow when a Marketing or Subscription List is updated

Trigger flow when a Marketing or Subscription List is updated

How to trigger a flow when a Marketing or Subscription list is updated in Dynamics 365, understand what kind of update just happened, then get the GUIDs you need to do your next steps whatever that might be.

I want to update the Marketing Preferences and Consents in response to a subscription list update!

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
Mapping Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

Mapping Dynamics 365 Marketing Form Submissions to Custom Tables with Power Automate

Marketing forms in Dynamics 365 are great for creating and updating contact and/or lead records, but not much else. The documented way to handle form submissions beyond lead or contact is to build a classic workflow but that in itself is very restrictive. By moving the automation into a Power Automate flow it opens up many more doors in terms of generation submission reports, notifications and sophisticated record manipulation that cannot be achieved with classic workflows alone.

Read More
Document Templates and Rich Text Controls

Document Templates and Rich Text Controls

Document Templates and Rich Text Component Controls are both excellent features of Dynamics 365/Model-Driven Power Apps, but they do not work well together at all. The solution isn’t perfect but by combining some Power Automate flow magic and a simple Word Document setting you can restore some slight harmony between the features.

PS. don’t waste your time trying to add/remove line breaks in Power Automate

Read More
Set Customer Voice Survey Variables using Dynamics 365 Marketing

Set Customer Voice Survey Variables using Dynamics 365 Marketing

Sending Dynamics 365 Customer Voice surveys via Dynamics 365 Marketing is possible today already. Unfortunately it is not possible to set any survey variables (except first name and last name which is taken from the contact record)… until now!

This post is going to be using the ‘Real-Time Marketing’ functionality of Dynamics 365 Marketing to send personalised customer voice surveys, with all the variables you could ever dream of!

Read More
Create custom Dataverse triggers for Dynamics 365 Marketing - without a developer!

Create custom Dataverse triggers for Dynamics 365 Marketing - without a developer!

Real-time marketing comes with a bunch of pre built triggers which come with the installation such as ‘Contact Created’ and ‘Lead Created’ but obviously none for my custom tables. How to create your own real-time Dynamics Marketing customs triggers based on activity/data in Dataverse - without a developer!

Read More
Track and Process Digital Applications with Customer Voice & Power Automate

Track and Process Digital Applications with Customer Voice & Power Automate

Every customer application is unique, the additional evidence & supporting documents they need to provide depends on how they answer the questions. We can use Power Automate to send specific and personalised directions on what they need to do next after submitting an application.

Linking a customer voice response back to its originating invitation and related enquiry so that we can track all activities in one place. Ensuring any user can clearly see what is/was required and help move the application process along.

Read More
Sending Digital Applications with Customer Voice & Power Automate

Sending Digital Applications with Customer Voice & Power Automate

This post will focus on sending a personalised, uniquely identifiable application form to a potential customer with dynamically generated email content from the simple click of a button of a business process flow. Customer Voice and Power Automate are a serious work force when combined!

Read More
Handling ‘Run Flow’ failures from a business process flow

Handling ‘Run Flow’ failures from a business process flow

Current limitations mean you cannot use business rules on the ‘Run Flow’ button on the business process flow, so its entirely possible for a user to run the flow when the scenario is going to cause silent failure in the background. Lets look at how to mark a business process flow step as failed, so you can handle flow run failures - gracefully and informatively, in a user friendly manner!

Read More
Digitising paper-based application forms with Customer Voice - it’s not just a survey tool!

Digitising paper-based application forms with Customer Voice - it’s not just a survey tool!

You read that right - I used customer voice for an application process. Well ok not just customer voice, my good friend Power Automate got pretty involved too. There are so many new features in Customer voice which make it so much more than just a survey tool!

Read More
Citizen Can: Mastering Power Automate and Dataverse with George Doubinski

Citizen Can: Mastering Power Automate and Dataverse with George Doubinski

One ‘Citizen’ Developer and one ‘Real’ Developer combine forces to educate and empower the less technical among us with the simplified knowledge to unleash awesomely powerful functions in Power Automate without needing to be a ‘Real’ Developer.

Expand to save on thousands API calls; Relationships are complicated; Expand expanded no matter how deep; Call classic workflows from Power Automate; Pass parameters between classic and flow; Select like a boss; Row count and page.

Read More