In this article, I demonstrate how to display the name of the parent Customer for a Contact on a Gallery or Form in a Canvas PowerApp.The App used for this example is connected to the underlying Contacts and Accounts entities in Dynamics 365 using the Common Data Source (CDS) Connector.In Microsoft
Read the full article hereIn this article I demonstrate a best practice for the writing of a Data Analysis Expression (DAX) in Power BI regarding the use of formatting, variables and comments.The formula used for my demonstration adds a calculated field named Is Supporter to a table named Supporter. This is a table of merged
Read the full article hereWith Dynamics 365 Portals you can add Entity Web Forms which are the Portals’ way of displaying Dynamics 365 CRM Forms, allowing Portal Users to Create, View and Update records in Dynamics 365. The screenshot is an example of a Web Form that shows a simple Lead form to collect information about the
Read the full article hereRecently it has been announced that there will be a wave of new Artificial Intelligence features being added to Microsoft PowerApps. The AI based features will be simple to add pieces of functionality that can do things like process a form or recognise objects in a picture. This blog covers the ‘Bus
Read the full article hereIn my previous articles, I have demonstrated how to set the default values for Lookup and Option Set field bound combo box controls in a Canvas Power App connected to a Leave Requests entity via the Common Data Service. In this article I demonstrate how an Option Set field bound combo box control ca
Read the full article hereIn my previous article I demonstrated how to use Connection Parameters in Power BI for the configuration of the Source step in Power Queries used to load data from Dynamics 365 (Online). In this article I will demonstrate how to use Parameters in Power Query.The following image shows the first three
Read the full article hereIn this article, I demonstrate the use of parameters for connecting a Power BI Data Model to Dynamics 365 (Online). This approach simplifies the subsequent task of updating the Data Source Settings after the Data Model has been published to the Power BI Service. For instance, it may be desired to co
Read the full article hereRecently when configuring a Power BI Data Model for Dynamics 365 I encountered a situation where I was not permitted to create a One-to-Many relationship in the data model between a Dimension table and a Fact table. Power BI automatically created a Many-to-Many relationship between the tables concer
Read the full article hereIn this article, I demonstrate how to configure two related date picker controls in a Canvas PowerApp so that Date To is updated to Date From, and Date From is updated to Date To, if the User selects a Date From date that is greater than Date To or a Date To date that is less than Date From.The exis
Read the full article hereIn this article, I demonstrate how to configure the default values for a Days From and Days To date picker controls and a related Days control in a Canvas PowerApp. I also demonstrate how to programmatically update the Days control to display the number of days between the two selected dates when th
Read the full article hereRecently I encountered an issue with the Data Export Service configuration.When you add the Data Export Service from the AppSource, it will open a new screen.In my situation the configuration was unable to find the Dynamics 365 organization.I noticed something was wrong with the URL. The URL has “po
Read the full article hereOne of the long-awaited features ‘Copy to my clipboard’ was made available for Microsoft Flow as part of the July update. Previously, if we had to use the same action multiple times but with slight changes, we needed to add the actions and then configure them individually. Using the copy functionali
Read the full article hereWith Forms Pro, Microsoft has made it easy to Create Surveys, Send Surveys and View Responses. Forms Pro is a survey solution that builds on the current survey-creation experience of Microsoft Forms in Office 365. It helps you capture and analyse survey responses. In this blog post, I will show you
Read the full article hereIs your D365 instance getting a bit bloated? This blog will take you through how to find out which entity tables are the biggest offenders and will give you some ideas on how to trim some excess storage or prevent it accumulating in the first place.These days, to find your company’s D365 data
Read the full article hereIn a previous article, I demonstrated how to set the default values for Dynamics 365 Lookup fields in a Canvas PowerApp. The example used was a Leave Requests app that requires the selection of Requester and Manager.The following image shows the formula used for setting the default Requester to the
Read the full article here