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
    • 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
    • Overview of the View Management in Model-Driven Apps

      Arthur Mandisodza, 11 May 2022

      The view management feature in Dynamics 365 allows users to have more abilities to collaborate and share views, empowering users to have more control of their workspace by giving them the full capability to change what views they see, the order of the views and more personalized options. There is n

      Read the full article here
    • Power BI - Calculating Mean and Actual or Percentage difference from Mean for a Measure using DAX

      Colin Maitland, 10 May 2022

      In this article, I will demonstrate how to use DAX to calculate the Mean, Actual Difference from Mean and Percentage Difference from Mean for a set of values calculated by a measure in Power BI. The Mean is the average of a set of numbers. That is, the sum of the values divided by the number of valu

      Read the full article here
    • Using Power Apps for Teams Power FX Formula Columns in Dataverse

      Jared Johnson, 05 May 2022

      Formula table columns are currently in preview, but Microsoft docs state that they are only available in Power Apps for Teams for now.Now while the Maker experience is only available in Power Apps for Teams, can we create them there and bring them into our normal Dataverse environment?To test this,

      Read the full article here
    • Analysing Donor and Supporter dates in Power BI

      Colin Maitland, 27 April 2022

      In this article, I will demonstrate an approach that may be used in Power BI to analyse the dates such as Created On, First Donation and Last Donation dates for Donors or Supporters. This approach may also be considered for other scenarios, such as First Sale and Last Sale dates for Customers, First

      Read the full article here
    • Changes to Auditing in Dynamics 365

      Calum Jacobs, 21 April 2022

      Microsoft has just recently release changes to the way you can manage Audit records/logs in dynamics 365. Before these changes, audit logs could be visible individually through records under auditing or as grouped quarterly partitions. There wasn’t a whole lot you could do to maintain logs other th

      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
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 © 2024 Magnetism Solutions Limited.
All Rights Reserved.