Power Automate “Fix the Trigger” Issue (and how to fix)

The other day I deployed an update to a Power Automate flow from my development system to my production on a small project. This particular flow ran perfectly fine for many weeks, but suddenly stopped working. On further inspection, I was getting the following issue; There’s a problem with the flow’s trigger. Fix the trigger.… Continue reading Power Automate “Fix the Trigger” Issue (and how to fix)

Using Multi-table lookups (polymorphic relationships) in Microsoft Dataverse

A new feature landed in preview last week which is something that has been a big ask of Microsoft for many years, multi-table lookups, otherwise known as polymorphic relationships. What are polymorphic relationships and how can they help you? A polymorphic relationship lookup allows you to specify more than one type of Dataverse table to… Continue reading Using Multi-table lookups (polymorphic relationships) in Microsoft Dataverse

Power Apps portal WebAPI – creating a record with lookups

One of the features of Power Apps portals that I have been impatiently waiting for is the Power Apps portals WebAPI. This new feature recently became generally available, and it allows portal makers and developers to greatly extend their portal web applications without needing to resort to complex or costly workarounds. Even if you are… Continue reading Power Apps portal WebAPI – creating a record with lookups

Secrets of the Dataverse: The Report Wizard

Anyone who has been working with Dynamics CRM/Dynamics 365 at some point likely tried the Report Wizard. The Report Wizard was introduced in Dynamics CRM v4.0 as a way to quickly create ad-hoc reports. A video version of this blog post can be found on the 365.Training YouTube channel. Reports created using the Report Wizard… Continue reading Secrets of the Dataverse: The Report Wizard

Updating Currency Exchange Rates in Dataverse (including Dynamics 365)

A little know feature of Dataverse is the ability to manage multiple currencies. This is one of the many standard features of Microsoft Dynamics 365 that is also available when building your own Power Apps based on Dataverse. A while back I posted a blog called Guide to Currencies in the Common Data Service (Note that… Continue reading Updating Currency Exchange Rates in Dataverse (including Dynamics 365)

Do you use FetchXML Builder? Please consider helping a friend out.

I use the FetchXML Builder on my Power Platform almost on a daily basis. It saves me so much in building SSRS reports, it allows me to build powerful Power Apps portals web templates and it also helps me building Power Automate flow queries. What is FetchXML Builder? It is a tool that is part… Continue reading Do you use FetchXML Builder? Please consider helping a friend out.

Inject content into Power Apps portals form components

Sometimes even the most simple requests can balloon in extra configuration to meet the client’s vision. One of the most common uses of a Power Apps portal is to collect some information using a form. Adding a form component to a portal page is a very simple exercise. You create the model-driven form in the… Continue reading Inject content into Power Apps portals form components

Set Up Your Workstation to Create SSRS Reports for Dataverse, Model-Driven Power Apps and Dynamics 365

Despite all the cool stuff you can do with the Power Platform, one of my most popular blog posts is Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365. The post was likely popular because there were different components in the setup process and Microsoft never did a great job… Continue reading Set Up Your Workstation to Create SSRS Reports for Dataverse, Model-Driven Power Apps and Dynamics 365

Using the Power Apps portals WebAPI to Clear the Portal Cache

If you work with building Power Apps portals, as you make updates to pages, assign users to Web Roles or make any other changes, you want to see these changes immediately on the portal. You are likely very much aware of the Portal studio Browse Website function or the Clear Cache button available in the… Continue reading Using the Power Apps portals WebAPI to Clear the Portal Cache

How to trigger Power Automate flows from Model-Driven Power App Business Process Flows (and get a response!)

I was working on a project the other day and the requirement was for a user of a Model-driven Power App to go through a series of steps to approve an application with a number of data points. I am not the biggest fan of Business Process Flows, (BPFs) but I felt that it did… Continue reading How to trigger Power Automate flows from Model-Driven Power App Business Process Flows (and get a response!)