About Us
Our Team
Join the Team
News
Business Solutions
Customer Relationship Management
Stakeholder Management
Sales Management
Case Management
Business Intelligence
Member Management
Custom Business Applications
Infinity Support Suite
Migrate from Salesforce
Our Products
Our Work
Blog
Contact Us
Magnetism
About Us
Our Team
Join the Team
News
Business Solutions
Customer Relationship Management
Stakeholder Management
Sales Management
Case Management
Business Intelligence
Member Management
Custom Business Applications
Infinity Support Suite
Migrate from Salesforce
Our Products
Our Work
Blog
Contact Us
    • Options for Microsoft Dynamics 365 Free 30-Day Trial

      Colin Maitland, 18 January 2017

      In this blog I will provide a short description of the solution options when setting up a free 30-day trial of one or more of the CRM solutions in Microsoft Dynamics 365. The solution options are Sales, Customer Service, Field Service and Project Service Automation. The process for setting up a free

      Read the full article here
    • Interactive Experience Forms for a Custom Entity in Microsoft Dynamics CRM 2016

      Colin Maitland, 21 December 2015

      In this blog I will briefly highlight the look and feel of the new Interactive Experience Forms for a custom Project entity in Microsoft Dynamics CRM 2016 Online. This entity has a Business Process Flow associated with it and has related child Projects, Cases and Contacts. Form Header Tiles Thes

      Read the full article here
    • Use Hierarchy Security in Microsoft Dynamics CRM for Private Notes

      Colin Maitland, 12 November 2015

      In this blog I will demonstrate how Hierarchy Security can be used in Dynamics CRM to secure notes so they can only be accessed by the users who created and own them, and their managers. This can be achieved as follows: Update the Security Roles assigned to users so that they only have User Level R

      Read the full article here
    • Use of Capacity in Service Scheduling in Microsoft Dynamics CRM

      Colin Maitland, 04 November 2015

      In this article I will demonstrate the use of Capacity when using the Service Scheduling Engine in Microsoft Dynamics CRM. I will demonstrate this using the example of a Service for the delivery of a one day “Service Scheduling Training” course. This example is similar to a scenario demonstrated in

      Read the full article here
    • Bulk Hide Unused Fields from Users in Advanced Find in Microsoft Dynamics CRM 2015

      Colin Maitland, 21 July 2015

      When using Advanced Find the list of fields that are presented can be cluttered by the visibility of fields that are not used. Examples of these fields include Base Currency fields and many fields that are not displayed on Forms or Views. In this blog I will demonstrate how to hide the unused fiel

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power Map Report Part 3

      Colin Maitland, 19 July 2015

      In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data from a Microsoft Dynamics CRM Online Organisation. In my previous blog I demonstrated how to configure the second layer of a Power Map report in Microsoft Excel to display Account Reven

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power Map Report Part 2

      Colin Maitland, 17 July 2015

      In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data from a Microsoft Dynamics CRM Online Organisation. In my previous blog I demonstrated how to configure the first layer of a Power Map report in Microsoft Excel to display Account Number

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power Map Report Part 1

      Colin Maitland, 17 July 2015

      In this series of blogs I have been describing how to create Power BI reports in Microsoft Excel based using data retrieved from a Microsoft Dynamics CRM Online Organisation using a Power Query query. In this blog I will demonstrate how to create a Power Map report and configure the first layer to

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power View Report Part 3

      Colin Maitland, 14 July 2015

      This is the third blog in a series of three blogs on how to create a simple Power View Report in Microsoft Excel to display information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. The report is based on an ODataFeed related query created using Power Que

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power View Report Part 2

      Colin Maitland, 13 July 2015

      This is the second blog in a series of three blogs on how to create a simple Power View Report in Microsoft Excel to display information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. The completed report will look similar that shown below. In my prev

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – Power View Report Part 1

      Colin Maitland, 11 June 2015

      In this blog and the next two blogs I will demonstrate how to create a simple Power View report in Microsoft Excel that displays information on Accounts and Opportunities retrieved from a Microsoft Dynamics CRM Online Organisation. This report uses a Power Query named AccountOpportunitiesSet previou

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – PivotChart Report Part 3

      Colin Maitland, 03 June 2015

      In my previous blog I demonstrated how to convert a Column Chart that displays the Sum of Estimated Value by Account into a Pie Chart. In this blog I will demonstrate how to update the Column Chart to display both the Sum of Estimated Value and the Sum of Actual Value. I will also demonstrate how to

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – PivotChart Report Part 2

      Colin Maitland, 29 May 2015

      In my previous blog I demonstrated how to create a simple Clustered Column Chart in Microsoft Excel that displays the Sum of Estimated Revenue by Account using data queried from a Microsoft Dynamics CRM Online Organisation. In this blog I will demonstrate how to convert this chart into a 3D

      Read the full article here
    • Approve Microsoft Dynamics CRM Online 2015 Update 1

      Colin Maitland, 27 May 2015

      Microsoft Dynamics CRM Online Update 1 (May 2015) is now available. In this blog I will show you how to schedule and approve this update for your Organisation. Important: The best practice prior to applying updates to a production instance of Microsoft Dynamics CRM is to first complete the foll

      Read the full article here
    • Power BI Microsoft Dynamics CRM Online – PivotChart Report Part 1

      Colin Maitland, 26 May 2015

      In this blog I will demonstrate how to create a simple Clustered Column Chart in Microsoft Excel to display Microsoft Dynamics CRM Online Sum of Estimated Value for Opportunities by Account. The chart is based on the AccountOpportunitySet query built using Power Query as demonstrated in the previous

      Read the full article here

Category List

  • Azure
  • CRM
  • Dynamics 365
  • Microsoft 365
  • Mobile
  • Power Apps
  • Power Automate
  • Power BI
  • Power Platform
  • SharePoint

Filter by Author

  • Adam Murchison
  • Alfwyn Jordan
  • Arthur Mandisodza
  • Calum Jacobs
  • Colin Maitland
  • David Mochrie
  • Dominic Liu
  • Gayan Perera
  • Harshani Perera
  • Isaac Stephens
  • Jaime Smith
  • Jared Johnson
  • John Barrencechea
  • John Eccles
  • Lauren Withers
  • Paul Nieuwelaar
  • Roshan Mehta
  • Roz Millar
  • Ryan Blaikie
  • Ryan Ingram
  • Sarah Coleman
  • Sean Roque
  • Shalane Williams
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
Back to Top
Magnetism Solutions Microsoft Solutions Partner

Our team

Join our team

Our products

Our work / case studies

Sustainability | Privacy Policy | Terms of Use | Trust Center

Power Platform | Power Apps | Power Automate | Pricing | Training

Auckland
26 Greenpark Road, Penrose
+64 9 888 4086

Wellington
Level 13, 57 Willis Street
+64 4 889 4450

Christchurch
Level 1, 293 Durham Street North
+64 3 669 5210

Sydney
Coming soon…
+61 1800 330 955

Thank you! We will be in touch with you soon.

Copyright © 2025 Magnetism Solutions Limited.
All Rights Reserved.