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.

What is the Microsoft Dataverse?

Today Microsoft announced the Microsoft Dataverse and Microsoft Dataverse for Teams. Check out the announcement here: https://powerapps.microsoft.com/en-us/blog/reshape-the-future-of-work-with-microsoft-dataverse-for-teams-now-generally-available/ Goodbye Common Data Service, Hello Dataverse. What is Microsoft Dataverse? Simply put, it’s the new name for the Common Data Service. The term “Dataverse” is part of a series of nomenclature changes as Microsoft pushes the Power Platform… Continue reading What is the Microsoft Dataverse?

Hello Tables, Columns and Choices. Goodbye Entities, Fields and Options. Getting ready for new names in the Power Platform

If you are like me, chances are you have been using the new Power Apps maker portal to create new model-driven Power Apps or to modify Dynamics 365 apps. By default, I like to go to https://make.preview.powerapps.com instead of https://make.powerapps.com as I can see new and upcoming preview features and try them out. If something… Continue reading Hello Tables, Columns and Choices. Goodbye Entities, Fields and Options. Getting ready for new names in the Power Platform

How to setup a Common Data Service Application User (and why)

When you build custom solutions where you need to create, read, update or delete data in the Common Data Service (including Dynamics 365 apps), you don’t necessarily want that application to use specific user credentials to do its work. This used to be a common way for external applications and integrations to authenticate to the… Continue reading How to setup a Common Data Service Application User (and why)

Displaying a Customizable Map on a Power Apps portals Web Page

A popular out-of-the-box feature of Power Apps portals that came from the original Adxstudio product is the ability to display a map on a web page based off of data from an entity list. In order to render the map, you need to configure an entity list to display the map and point data as… Continue reading Displaying a Customizable Map on a Power Apps portals Web Page

Get Geo Co-ordinates from Address values in Common Data Service Records

This is a reference post for another blog post I am working on. I figured it would be a good as standalone post as well. Power Automate has opened up a whole new world of connectors and APIs that would traditionally have been reserved for professional developers. A great use case for Power Automate calling… Continue reading Get Geo Co-ordinates from Address values in Common Data Service Records