About Us
What We Do
Our Team
Business Solutions
Customer Relationship Management
Sales Management
Case Management
Business Intelligence
Member Management
Custom Business Applications
Our Products
Our Work
Blog
Contact Us

New Zealand’s most experienced Microsoft Gold Certified Power Platform, Dynamics 365 CRM practitioners - Magnetism

About Us
What We Do
Our Team
Business Solutions
Customer Relationship Management
Sales Management
Case Management
Business Intelligence
Member Management
Custom Business Applications
Our Products
Our Work
Blog
Contact Us
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 8

      Colin Maitland, 02 March 2021

      In my first article of this series, I introduced a demonstration of a custom Power BI embedded Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this final

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 7

      Colin Maitland, 22 February 2021

      In my first article of this series, I introduced a demonstration of a custom Power BI embedded Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this penul

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 6

      Colin Maitland, 16 February 2021

      In my first article of this series, I introduced a demonstration of a custom Power BI embedded Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.The two most

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 5

      Colin Maitland, 22 January 2021

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this article I will describe

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 4

      Colin Maitland, 16 December 2020

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In a previous article I introdu

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 3

      Colin Maitland, 30 November 2020

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this article I will introduc

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI - Part 2

      Colin Maitland, 26 November 2020

      In my first article of this series, I introduced a demonstration of a custom Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.In this article I will demonstr

      Read the full article here
    • Creating/Replacing Marketing Lists in Dynamics 365 from Power BI

      Colin Maitland, 08 November 2020

      In this article, I will introduce a demonstration of a custom Power Apps Canvas App, named ‘Marketing List App’, that is used to create new or replace existing static Marketing Lists in Dynamics 365 populated with a list of Supporters selected in a Power BI report.It is possible to create and update

      Read the full article here
    • How to add the Subject Tree to the Site Map for a Dynamics 365 Model Driven App

      Colin Maitland, 14 May 2020

      In this article I demonstrate how to add Subjects to the Site Map for a Dynamics 365 Model-Driven App.Both Sales Literature and Subject are standard Dynamics 365 entities available for use as part of the Customer Engagement Plan and Customer Service App subscriptions. By default, Sales Literature mu

      Read the full article here
    • A Tale of Two Countries - Charting Covid-19 Growth Rates with Power BI

      Colin Maitland, 23 April 2020

      Power BI is a great tool for analysing information. In this article, I demonstrate some charting approaches using some standard Power BI charts. The three examples of chart-sets in this article demonstrate my lay persons analysis of a ‘Tale of Two Countries’; i.e. comparison of the reported Covid-19

      Read the full article here
    • How to Translate Dynamics 365 Field Values to Power BI

      Colin Maitland, 23 January 2020

      In this article, I demonstrate how to dynamically translate the Physical Name field values stored in the ‘Applicable From’ and ‘Related Field’ (i.e. SLA KPI) fields for Service Level Agreements (SLAs) and related Service Level Agreement Items (SLA Items) in Dynamics 365 to their equivalent Display N

      Read the full article here
    • Using Measures instead of Bi-Directional Filtering Relationships to filter Slicers in Power BI

      Colin Maitland, 19 December 2019

      In this article I demonstrate how to filter slicers using a measure instead of using bi-directional filtering relationships. I will also briefly highlight that the implementation and use of bi-directional filtering relationships between dimensions and facts for the purpose of filtering slicers is no

      Read the full article here
    • How to format numbers stored and displayed as text in a Canvas Power App

      Colin Maitland, 17 December 2019

      In this article, I demonstrate how to format the display of a number in a Canvas Power App as it is being entered by the user. This demonstration uses the example of a custom calculator created using various buttons, labels and formulas and which allows the user to enter up to 12 numeric digits as p

      Read the full article here
    • How to Capture Power BI Queries sent to Dynamics 365

      Colin Maitland, 10 December 2019

      In this article I briefly demonstrate how to capture the queries that are sent by Power BI to Dynamics 365 (Online) when refreshing a table in a Power BI Data Model.The example used in this article is based on an Account query. This query includes steps to filter, select, sort and expand the retriev

      Read the full article here
    • Custom Power BI UTC to Local Date/Time with Daylight Saving Time Function

      Colin Maitland, 03 December 2019

      In a previous article, I demonstrated several approaches for transforming Dynamics 365 UTC Date/Time values to New Zealand (NZ) Local Date/Time and Date values. In this article I demonstrate the structure of the custom Power BI function referred to in that article. This article demonstrates the inte

      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
  • Calum Jacobs
  • Colin Maitland
  • David Mochrie
  • Dominic Liu
  • Gayan Perera
  • Harshani Perera
  • Isaac Stephens
  • Jaime Smith
  • Jared Johnson
  • John Eccles
  • Megha Kainth
  • Nick Chin
  • Paul Nieuwelaar
  • Roshan Mehta
  • Roz Millar
  • Ryan Ingram
  • Sarah Coleman
  • Sean Roque
  • Shalane Williams
  • Zoe Sands
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
Back to Top
Magnetism_Logo+Icon_TransparentBG.png
 

OUR ACCREDITATIONs

Microsoft_creditations_logo.jpeg
 

About us

BUSINESS SOLUTIONS

OUR PRODUCTS

OUR WORK

OUR BLOG

CONTACT US

Thank you!