‘Distribution List’ Emails and Appointments with Power Automate

‘Distribution List’ Emails and Appointments with Power Automate

Automating the creation of Dataverse Activities to lists or groups of contacts. This post shows you how to build power automate flow that does the magic behind the scenes of the custom page in my last post ‘Distribution Lists’ in model-driven apps.

Read More
‘Distribution Lists’ in model-driven apps

‘Distribution Lists’ in model-driven apps

Send group emails and appointment invitations to Contacts in model-driven apps and Dynamics 365 using Distribution Lists. This custom page allows you to browse and select one or many distribution lists, review the contacts who belong to those lists, then create an appointment or an email (and the type of recipient - To, CC or BCC) with the click of a button.

Read More
Convert a spreadsheet or CSV file into a Marketing List in Dynamics 365 - Strings

Convert a spreadsheet or CSV file into a Marketing List in Dynamics 365 - Strings

How to import a spreadsheet list of contacts or leads, into a marketing list in Dynamics 365 or Dataverse. If they are all new rows, its not too bad, but otherwise its a very manual export/import/VLOOKUP hodgepodge.

This post will show you how to create a flow which turns a CSV file with display names, into a populated marketing list in Dynamics 365. The fields are flexible. Import Contacts or Leads. Use New or Existing rows. Populated Standard or Custom fields.

Read More
Create sales tasks and phone calls directly from Real-time Dynamics 365 Marketing Journeys

Create sales tasks and phone calls directly from Real-time Dynamics 365 Marketing Journeys

Handing over a good lead to the sales team at the right time is important. Knowing when a prospect needs further enrichment is valuable. Wouldn’t it be good if we could automate activities and notifications, at the right time, based on customer interactions as part of our real-time marketing journeys?

Activate a custom trigger to call a flow that creates the sales activity from within a marketing journey to help you achieve your marketing metric KPIs

Read More
Insert your email signature from Dataverse using Power Automate

Insert your email signature from Dataverse using Power Automate

If you are using Power Automate to create dataverse emails then the users signature will not be automatically populated (even if it’s been configured correctly in Dataverse!).

There is no guarantee that the user will have an email signature set up/assigned correctly. How to ensure we accommodate for both scenarios and automatically populate the email signature seamlessly as part of your flow.

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
Sync Dataverse Email Attachments to SharePoint using Power Automate

Sync Dataverse Email Attachments to SharePoint using Power Automate

When you ‘set regarding’ an email in The Dynamics 365 App for Outlook, an email record will be created in Dataverse, linked to the relevant record(s) then any attachments are created as files in Dataverse. Storing files in Dataverse is not often a good idea. Instead, you can automatically upload these files into the relevant SharePoint folder the document is ‘regarding’

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
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
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
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
Filtering the ‘Regarding’ column in Power Automate

Filtering the ‘Regarding’ column in Power Automate

Triggering a Cloud Flow in Power Automate when an email is tracked ‘Regarding’ an Account record in Dynamics (or Dataverse) should be simple - but when your filter is throwing an error and Regarding (Type) is blank. You need to ask not once, but twice for the values you need!

Read More
From Azure Queues to model-driven Power Apps for social media analytics

From Azure Queues to model-driven Power Apps for social media analytics

The second step in creating an immersive, AI enriched social media monitoring and analysis model driven app. Retrieving messages from an Azure queue which is full of AI enriched data and displaying it to our users in meaningful and enjoyable ways

Read More
VIDEO: Virtual Quizzes (#PPPQ) and Community Engagement with Power Platform

VIDEO: Virtual Quizzes (#PPPQ) and Community Engagement with Power Platform

The story so far on how the virtual Power Platform Pub Quiz initiative #PPPQ is leveraging the power of the platform to run live virtual quiz events featuring trivia questions across the power platform stack. t’s a true showcase of how the Microsoft Community & Power Platform come together to help us learn, engage and connect with each other despite being physically apart.

Read More