About Us
Our Team
Join the Team
Business Solutions
Customer Relationship Management
Stakeholder 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
Our Team
Join the Team
Business Solutions
Customer Relationship Management
Stakeholder Management
Sales Management
Case Management
Business Intelligence
Member Management
Custom Business Applications
Our Products
Our Work
Blog
Contact Us
    • Authenticating Power Apps Portal with OAuth 2.0

      Adam Murchison, 15 July 2022

      Power Apps portals come with a bunch of identity providers out of the box to authenticate users such as the below providers: Another alternative to use is using a custom Open ID provider, one of many OAuth 2.0 providers is called Auth0, for the purpose of demonstration I’ll be using this to configur

      Read the full article here
    • Lookup Fields on Power Apps Portal

      Dominic Liu, 02 July 2022

      Lookup fields can define views that display different sets of values from the associated entity. We often use lookup fields in Dynamics 365 to handle the relationships between tables. However, if you have a lookup field on your table that is linked to a reference table, the view is not related as we

      Read the full article here
    • Analysing a Power Automate Flow with the Process Advisor

      Isaac Stephens, 01 July 2022

      Have you wanted to analyse some of your Power Automate flows? Maybe some of the more complex ones with multiple paths? Do you have a flow that sometimes takes a long time to run? Well Microsoft have recently released the Process Advisor to General Access, but what is the Process Advisor and how can

      Read the full article here
    • Part 1: How to create Test Plans and Test Cases in Azure DevOps

      Harshani Perera, 30 June 2022

      Azure DevOps is a great place for everyone on the team including Business Analysts, Developers, Project Managers and Testers to collaborate on a project. It allows transparency and ease of communication to keep all information in one place so it’s visible to everyone. In this series, I will share wi

      Read the full article here
    • Resolve problems with Dynamics 365 for Outlook Client with Edge

      Jared Johnson, 29 June 2022

      If you are still using the old Dynamics 365 for Outlook Client, you may notice issues when using it with Microsoft Edge. When trying to create/edit a Dynamics 365 record from inside the Outlook Client, it will open the record in Edge, but in Outlook there will be just a blank white popup that will e

      Read the full article here
    • ClickDimensions Import Failure - Invalid URI: The hostname could not be parsed

      Ryan Blaikie, 25 June 2022

      ClickDimensions import for Marketing Lists is a helpful feature when you want to add members based on an Excel spreadsheet rather than based on an existing view in Dynamics 365. However, sometimes if the import fails it can be confusing to determine what the cause of the issue is and how to fix it.

      Read the full article here
    • Rollback a request on Failure in Power Automate

      Isaac Stephens, 16 June 2022

      When using Power Automate to update Dataverse / Dynamics 365 you may not want the changes to be saved if a related action fails. For example, you may want to create two records and then update a third, but you only want this to happen if all three are successful. In this blog post I will show you ho

      Read the full article here
    • Power Query - Conditionally Replace Values in a Column with Values from another Column

      Colin Maitland, 27 May 2022

      In this article, I will demonstrate how to use Power Query to conditionally replace values in a column with values from another column. We want to do this with the least number of steps, while handling blank values and maintaining the data type of the column for which values are to be replaced. For

      Read the full article here
    • How to Re-instate the Alphabet Bar for Dynamics 365

      Ryan Blaikie, 25 May 2022

      Microsoft’s Wave 2 update in October introduced a lot of great new features; however, you might have been disappointed to log in one day and discover that the alphabet bar at the bottom of your views suddenly disappeared. If you’re like me, this is a feature that you use often to quickly find the ri

      Read the full article here
    • 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
    • Five Features you may have missed in Wave 1 2022

      Arthur Mandisodza, 20 May 2022

      There are plenty of substantial changes in the Wave 1 release this year. There are big features highlighted as flagships of the update and there are also plenty of smaller updates that will improve user experience with Dynamics 365 and the Power Platform.1. Makers can collaborate on the same app by

      Read the full article here
    • Restrict Power Apps Portals to Administrators

      Dominic Liu, 17 May 2022

      Website maintenance is important for all organisations, both big and small. Regularly maintaining your site will improve performance and provide a safe and secure environment for your visitors. In other situations like deploying new updates to the website, the website will need to be entirely blocke

      Read the full article here
    • NZBN Integration for Dynamics 365 Add-on, Installation Guide

      Paul Nieuwelaar, 15 May 2022

      NZBN Integration for Dynamics 365 which allows you to search for real-time data direct form the New Zealand Companies Office and pull directly into Dynamics 365.Please follow the five easy steps below to get the trial underway.1. Download the NZBN Integration solution, and install it into your Dynam

      Read the full article here
    • NZ Post Integration for Dynamics 365 Add-on Installation Guide

      Paul Nieuwelaar, 15 May 2022

      NZ Post Integration for Dynamics 365 which allows you to search for real-time address data direct from the New Zealand Post and pull directly into Dynamics 365.Please follow the five easy steps below to get the trial underway.1. Download the NZ Post Integration solution, and install it into your Dyn

      Read the full article here
    • How to configure a Top X Slicer in Power BI

      Colin Maitland, 13 May 2022

      In this article, I will demonstrate how to configure a slicer and related visualisation, such as a table or chart, to dynamically select and display the Top X Customers based on a measure such as Won Revenue in a Power BI report. The pattern demonstrated in this article can be adapted to suit your b

      Read the full article here

Filter by Category

  • 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

Our team

Join our team

Our products

Our work / case studies

Sustainability | Privacy Policy | Terms of Use

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.