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
Invoices and accounting with model-driven Power Apps

Invoices and accounting with model-driven Power Apps

A simple yet powerful model-driven Power App making the invoicing and accounting tortures for my micro enterprise a little more bearable! Key functionality includes record work items, generate invoices, track payments, capture expenses and produce financial reports.

Read More
Marketing beyond Segments and Mailing Lists
Dynamics 365 Marketing Amey Holden Dynamics 365 Marketing Amey Holden

Marketing beyond Segments and Mailing Lists

Marketing lists are so last year, dynamics segments are a little bit better - so long as you have the data but did you know you can trigger your marketing automation (i.e. Customer Journeys) when your contacts or leads actually do something meaningful? Such as submitting a form, creating an order or updating their bookings. Well you can - so its time to start conversations in a timely, satisfying and personalised way - any time of day, without even lifting a finger.

Read More
Dynamics 365 Marketing + Teams Events + Calendar Invites

Dynamics 365 Marketing + Teams Events + Calendar Invites

Marketing Events as teams meetings came into the world somewhat unfinished, the actual event didn’t show in your email or personal calendar, or any of the producers or speakers calendars.

Good news - no more workarounds required! You simply create the event in Dynamics Marketing then you, your speakers and producers will all have an invite straight to their inbox with the right permissions, to do what they need to do for your online event.

Read More
Quick View forms with edit permissions - introducing the Form Component Control

Quick View forms with edit permissions - introducing the Form Component Control

Quick View forms have been disappointingly average since CRM 2013. I’m excited to be introducing the better sibling of the Quick View form that lets you see and edit data from other tables from a single form - it’s called ‘Form Component Control’. *catchy name pending*

Read More
Flip the switch: two option (yes/no) fields in model-driven Power Apps

Flip the switch: two option (yes/no) fields in model-driven Power Apps

Lets look at how the humble two option field can be better visualised and used in more creative ways in your model-driven Power Apps. We do this by using Custom Controls out of the box and PCF components. Plus a bonus feature (although technically not a two option field behind the scenes) shows a really smart example of how you can you a flip switch to set a timestamp, two visual benefits in one field!

Read More
Face the fear of $expand and get the lookup values you deserve in Power Automate
Power Automate Amey Holden Power Automate Amey Holden

Face the fear of $expand and get the lookup values you deserve in Power Automate

Power Automate and lookup fields are problematic - especially when you are trying to send notifications which include information about records which includes lookup fields.

For example - sending an email about a contact who works at a company called ‘ Vegemite’ comes back as ‘eca9ea6f-c96b-ea11-a811-000d3a58d840‘. I’m not sure about you, but me and most my customers don’t speak '“GUID”.

You can use the ‘Get Records’ action but its not so friendly of the API calls nor so efficient. Come with me on a journey to understand the power of the ‘Expand Query’ to solve all your lookup GUID issues!

Read More