• Calculate Mean, Median, Mode and Percentile for a Measure in Power BI

      Colin Maitland, 22 May 2022

      In this article, I will demonstrate how to calculate the Minimum, Maximum, Mean, Median, Mode and Percentile for a set of values calculated using a measure. This demonstration considers whether the rows for which the measure returns a blank result are included or excluded. I will also demonstrate th

      Read the full article here
    • Support for your CRM system - Variable or Fixed

      John Eccles, 27 January 2022

      Support is a necessityAn IT system is like a car. The real cost doesn’t stop when the system is installed. It requires ongoing support and maintenance to keep it working effectively. There’s an ongoing expense that can’t be avoided.‘Suppose you notice your neighbour filling the gas tank of his car f

      Read the full article here
    • Canvas Apps - Formatted Number Text Input and Display Demonstration

      Colin Maitland, 19 April 2021

      In this video blog, I will explain some limitations of using a Text Input control in a Canvas App to enter and display numbers. I will then demonstrate how a Label, Text Input and Timer control may be configured and used together to allow the data entry and display of formatted numeric values in a C

      Read the full article here
    • Transfer Word Templates to Different Environments in Dynamics 365

      Megha Kainth, 09 February 2021

      Recently, I had an opportunity to create Document Templates for a client. I created a Word Document for a custom entity in DEV environment, but I had trouble transferring it to other environments i.e. UAT and PROD. Document got uploaded but field Associated Entity Type Code was blank so the document

      Read the full article here
    • How to Connect Visual Studio 2019 to Team Foundation Server (TFS)

      Adam Murchison, 14 December 2020

      As intuitive as you’d expect this to be, it is not and caused myself a bit of frustration setting this up. Visual Studio 2019 defaults the source control to the widely popular Git source control and our requirement was to set our source control to an on-premise TFS. The first step you need to do is

      Read the full article here
    • Get Items from a SharePoint List using Power Automate with ODATA Filters

      Dominic Liu, 19 November 2020

      When you use ‘Get items’ action from Power Automate, it will bring back a list of items from your SharePoint List. This however can take a good amount of time for the Flow to run if you have a large number of items in your SharePoint List. On top of that this action is limited at 5000 items, which m

      Read the full article here
    • 8 more things you may not know about Immersive Excel

      David Mochrie, 17 November 2020

      Back in 2016, I wrote a blog 10 things you may not know about immersive Excel.In the intervening years (wow, has it been that long?!) I’ve discovered a few more things about immersive Excel that may interest you. I’ve not managed another set of 10. Just 8 this time.Before we start, to refresh your m

      Read the full article here
    • New features coming for Microsoft Teams - including breakout rooms.

      Ryan Ingram, 05 November 2020

      Microsoft recently released some much-anticipated features for Microsoft Teams on the back of the COVID 19 usage explosion that has characterised 2020. Organisations found themselves needing to push their communication channels and way of working onto the cloud and it almost forced some decisions th

      Read the full article here
    • How to Create Surveys using Microsoft Forms Pro

      Megha Kainth, 28 August 2019

      With 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 here
    • Setting up a Trial Environment in Dynamics 365 App for Outlook and Exchange

      Sean Roque, 15 August 2019

      Often when making Email Configurations and changes to Dynamics 365 App for Outlook, we want to be able to test these before applying them to avoid issues and ensure correctness. This guide is a quick tutorial to setup a trial environment for Dynamics 365 App for Outlook, so we can test all those qui

      Read the full article here
    • Power Platform Licensing

      John Eccles, 18 June 2019

      Power Platform unlocks the potential of Dynamics 365 and Office 365. It opens the door for non-software developer users within organisations to manage data and electronic forms, automate business processes and enable mobility. An organisation needs licensing to use Power Platform. In this blog, I wa

      Read the full article here
    • Using Document Templates in Dynamics 365

      Ronelle Raath, 16 May 2019

      Why use Document Templates in Dynamics 365? Having document templates set up can improve document quality across the whole business. It can save time by having a document populated with Dynamics 365 data with just a few clicks as well as ensure a consistent look and feel out to your customers.I have

      Read the full article here
    • Dynamics 365 CRM v9 is Slow!

      Gayan Perera, 10 May 2019

      Now that I've got your attention, the truth: Dynamics 365 CRM v9 is actually very quick! The Power Platform team has done an amazing job getting screens to load within a couple of seconds. This of course is the case for the majority of people using the platform. However, sometimes, you’ll hear comme

      Read the full article here
    • Enable Entities for Dynamics 365 for Outlook

      Megha Kainth, 15 April 2019

      Dynamics 365 App for Outlook lets you create activities, track emails, create records in CRM from Outlook. Some out of the box entities are searchable by default - for example Account, Contacts and Leads. Some entities such as custom entities aren’t available in the app out of the box. To allow use

      Read the full article here