• Setting up an Application User in Dynamics 365

      Paul Nieuwelaar, 21 September 2021

      In this article we’ll walk through all the necessary steps involved in setting up a new Application User in Dynamics 365, including creating a new Azure App Registration to use with the App User.Setting up the Azure App RegistrationStep 1:Create an App registration in Azure, under Azure Active Direc

      Read the full article here
    • Growing Customer Equity

      John Eccles, 27 August 2021

      Customer EquityCustomer equity is the sum of the discounted lifetime values of the customers of a business.It’s a customer-centric measure of the value of the business and should be a key strategic focus.The way to grow customer equity is with the strategy and tactics of customer relationship manage

      Read the full article here
    • Power BI: Is Leap Year Pattern

      Colin Maitland, 16 August 2021

      In this article, I will demonstrate several DAX formulas for Power BI that may be used to calculate whether a date falls within a Leap Year.Here is a table of dates showing the results for a set of dates. You will notice that:· If the Date is blank, then the result is False.· If the Date falls withi

      Read the full article here
    • Using a Calculation Group to configure a Matrix in Power BI

      Colin Maitland, 11 August 2021

      In this article, I will demonstrate the use of a Calculation Group to dynamically update the columns displayed by a matrix (i.e Pivot Table) visualisation in Power BI.The following image shows a page from a sample Power BI report. This page provides an analysis of Opportunities Estimated Revenue and

      Read the full article here
    • How to Quickly Capture Bugs in Azure DevOps using the Test and Feedback Tool

      Harshani Perera, 06 August 2021

      When testing software, recording issues and bugs is one of the time-consuming tasks. You may also need to use several tools to capture all the necessary data e.g., Excel, screen capture tools and paint. The great thing about the Test & Feedback Tool is that you can do all these things with this

      Read the full article here
    • Formatting (Blank) in Power BI using a Calculation Group

      Colin Maitland, 04 August 2021

      In this article, I will demonstrate a simple method to format ‘(Blank)’ on a Data Card in a Power BI report as ‘0’ or ‘-’ rather than ‘(Blank)’.This image shows a page from a report in Power BI. Notice that the values displayed by the Data Cards for Open Revenue and Due to Close Revenue near the top

      Read the full article here
    • Custom Emails to multiple Signees using DocumentsCorePack and DocuSign

      Arthur Mandisodza, 02 August 2021

      In this blog I am going to talk about a use case that the out of the box solution could not solve…yet. A client we worked with wanted to send a document to two recipients and each recipient needed to receive a customized email that had a different subject and email body. We put many heads together a

      Read the full article here
    • Are you ready for a virtual agent?

      John Eccles, 30 July 2021

      Virtual AgentA virtual agent (or virtual assistant or chatbot) is software that uses scripted rules and, increasingly, artificial intelligence (AI) to provide automated service or guidance to customers or employees.Virtual agents offer the promise of 24/7 service and significant efficiencies as huma

      Read the full article here
    • Fixing See All Associated Records from a Sub-Grid in Dynamics 365

      Adam Murchison, 29 July 2021

      While using Dynamics 365 recently, I encountered an error where I was not able to view associated records related to a specific record. I was instead navigated to all records for the given associated entity, below will be an example of this and how to fix the issue.Example of the issueAs described,

      Read the full article here
    • Configure Power BI Line and Stacked Column charts for Targets

      Colin Maitland, 26 July 2021

      In this article, I will demonstrate how to configure a Line and Stacked Column chart in a Power BI report to display Won Revenue and Open Revenue against Sales Targets and Target Remaining for Opportunities from Dynamics 365. This demonstration highlights a useful approach for using this type of cha

      Read the full article here
    • 10 Tips for Beginner Power Automate (Microsoft Flow) Users

      Harshani Perera, 08 July 2021

      Power Automate (previously Flow) is a tool within the Power Platform that can help automate tasks and processes. It can also connect different applications and services together. As a beginner to Power Automate it can be daunting at first in trying to figure out how it all works for someone who is n

      Read the full article here
    • How can we improve our productivity?

      John Eccles, 05 July 2021

      The productivity dilemmaA recent report from the New Zealand Productivity Commission, Productivity by the numbers, paints a bleak picture of the productivity of NZ compared to other OECD countries. But it’s not just us - measured productivity growth in recent times has been weak globally.Productivit

      Read the full article here
    • Install Custom PCF Controls in Dynamics 365 9.1 On-Premises

      Paul Nieuwelaar, 01 July 2021

      Until now, custom PCF controls have only been available for Dynamics 365 Online. If you tried to install a PCF control in a version 9.0 on-premise environment, you would receive an error stating ‘This action is not supported’. With the release of 9.1 for on-premises, and with a little bit of magic,

      Read the full article here
    • Filter a Lookup on a Business Process Flow in Dynamics 365

      Calum Jacobs, 30 June 2021

      I was wanting to create a filtered look up on a BFP that showed cities based on the selected country that was a field within a form. Developing on from my colleague Sean’s blog, I came across an issue, where if the field was changed, the filter was not updating.After investigating the issue, I solve

      Read the full article here
    • How to Run Test Cases in Azure DevOps

      Harshani Perera, 28 June 2021

      In Software testing, test cases are the step-by-step instructions carried out to verify the behaviour of a Software application. There are many tools to write test cases such as Excel, XMind, Testing tools or even Word. Azure DevOps is also a tool that provides the ability to create test cases easil

      Read the full article here