New Features – Common Data Service, SQL and Power BI !!!

One of the cool recent announcements by Microsoft is the ability to write T-SQL queries against a Common Data Service database using SQL Server Management Studio. This also includes the ability to connect to the Common Data Service using Direct Query in Power BI. Let’s look at how to enable this preview feature and how to use it. Note this is a preview feature from Microsoft, so expect things to … Continue reading New Features – Common Data Service, SQL and Power BI !!!

Get Alerted When a Common Data Service Database Version Changes

In this post, we will look at how to create a Power Automate Flow that alerts someone when a Power Platform Common Data Service version changes. This can be very useful if you’re waiting for new features to come out, for example the T-SQL access to the Common Data Service. We can also use this to connect to any of the D365 / Power Apps Web API methods from Power … Continue reading Get Alerted When a Common Data Service Database Version Changes

Find Out When a Dynamics 365 Version Update is Scheduled for Installation

Microsoft releases Dynamics 365 updates periodically. You may want to see which is the current and next version for your region. To do this, go to https://docs.microsoft.com/en-us/business-applications-release-notes/dynamics/released-versions/dynamics-365ce#latest-version-availability. For example, below we see a list of updates per region: In this case, North America Station 5 is on version 9.1.0.16845 Service Update 168, with the next version 9.1.0.17154 Service Update 171 being rolled out on 5/22. Clicking into one of these release … Continue reading Find Out When a Dynamics 365 Version Update is Scheduled for Installation

How to Use FormContext in a Web Resource in Dynamics 365 Power Apps with getContentWindow

When working with web resources in Dynamics 365 / Power Apps in the past, we were able to access form elements by using Xrm.Page. This has now been deprecated in Dynamics 365 v9.x, so we need a way to access these controls from an HTML web resource. Microsoft documentation has stated that calling parent.Xrm.Page from web resources is still a way to access the form context. However, there is also … Continue reading How to Use FormContext in a Web Resource in Dynamics 365 Power Apps with getContentWindow

Users Not Seeing Model-Driven App? Check These 2 Things

When you create a model-driven app and deploy it to another environment such as from Dev to your Test or Production environments, your users may not see the app. For example, in https://home.dynamics.com (soon to be located in https://www.office.com/apps) we have an app called UciApp1: Our salesperson. Jeff, does not see the app – “We can’t find any apps for your role. To check for recently-added apps, select Refresh”: Note, Jeff has … Continue reading Users Not Seeing Model-Driven App? Check These 2 Things

Business Process Flows and Troubelshooting Security Roles

In this post, we will look at how forms with Business Process Flows can be affected by the saving of records or moving stages in a BPF, which may occur before or after you deploy your code to a new environment. We will take a look at how to troubleshoot these errors in general as well. Let’s create a new business process flow at https://flow.microsoft.com/: We will call it Carl’s Flow, … Continue reading Business Process Flows and Troubelshooting Security Roles

Autogenerate Field Values with Auto-Number Attributes in Power Apps D365

In this post, we will take a look at how to create a field in Power Apps Dynamics 365 that auto-generates a value. This is useful if you would like records to have unique values that are automatically generated. You can add these fields to out of the box entities and also custom entities. Let’s create on in the Account entity. Go to https://make.powerapps.com and select Account: Then add field: Change … Continue reading Autogenerate Field Values with Auto-Number Attributes in Power Apps D365

Merge Solutions in Dynamics 365 Power Apps using Solution Components Mover

When building and deploying solutions in Dynamics 365 Power Apps across environments, we may want to merge or combine solutions into one deployable solution. For example, if you have multiple developers with their own solutions in a Development environment, and you are creating a new release, you may want to deploy the one Release solution to the next environment. The Solution Components Mover in the XrmToolbox can help to merge … Continue reading Merge Solutions in Dynamics 365 Power Apps using Solution Components Mover

Error Loading Ribbon Workbench in XrmToolbox

When using the Ribbon Workbench tool in XrmToolbox, you may run into this error when trying to open it: An error occurred when trying to display this tool: Unable to cast object of type ‘Microsoft.Xrm.Tooling.Connector.CrmServiceClient’ to type ‘Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy’: To resolve this, go to Tool Library: Select the Ribbon Workbench and click Uninstall: This will restart XrmToolbox. Now, go back to Tool Library and Install the Ribbon Workbench: We see the … Continue reading Error Loading Ribbon Workbench in XrmToolbox