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
    • How to Create Copies of Microsoft Flows

      Ronelle Raath, 14 October 2019

      In this blog, we’ll cover some ways to copy Microsoft Flows. The methods we’ll cover are using the Save As button, the Send a copy (Preview) button and the Export button.Save As Button:The Save As button works as you would expect. You click the button, input the new Flow name and click Save. This cr

      Read the full article here
    • How to Highlight the Selected Record in a Canvas PowerApp Gallery

      Colin Maitland, 11 October 2019

      In this article, I demonstrate how to highlight the selected record in a Canvas PowerApp Gallery.The following image shows a Gallery displaying Contact records on the right and a related Detail Form showing the currently selected Contact on the left.It is desired that the currently selected Contact

      Read the full article here
    • Configuring Dynamics 365 Currency Fields in Power BI

      Colin Maitland, 10 October 2019

      In this article, I demonstrate the data type conversion that should be applied to Dynamics 365 Currency fields in Power BI; ie. to Fixed Decimal Number instead of to Decimal Number.In Microsoft Dynamics 365, “Currency” fields are stored in the underlying SQL Server database using the SQL Server Mone

      Read the full article here
    • How to Accurately Calculate Ages in Power BI

      Colin Maitland, 07 October 2019

      In this article, I demonstrate how to calculate Ages in whole-years and fractional-years in Power BI using several different approaches. I also identify the approach that calculates the most accurate Age.The following image shows a list of people in Power BI. These records were loaded into the Power

      Read the full article here
    • Using Scopes and Branches in Microsoft Flow

      Adam Murchison, 04 October 2019

      If you’ve ever made a large Microsoft Flow with multiple connectors you’ll have noticed how untidy or messy it is. A useful feature that I’ve recently found is the ‘Scope’ control which will neatly confine your methods/actions to a well-defined structure. As you can see this flow is running multiple

      Read the full article here
    • How to Hide Non-Customisable Dashboards in Dynamics 365

      Megha Kainth, 03 October 2019

      In Dynamics 365, customisable dashboards can be hidden by altering the Security Roles that are able to view the dashboard. I wanted to hide a system dashboard for a client, and I learned that the Server-Side Synchronization Failures Dashboard cannot be customised. In this blog post, I will show you

      Read the full article here
    • New uses-feature manifest element in PowerApps Component Framework Controls

      Jared Johnson, 27 September 2019

      Earlier this month, a previously built PCF control that utilised WebAPI to retrieve records stopped working with the following error: “Feature 'WebAPI.retrieveMultipleRecords' is required to be specified in the <uses-feature> section in ControlManifest.xml before use.”Checking the PowerApps co

      Read the full article here
    • Creating a Form Processor in the Power Platform AI Builder (Part 1)

      Isaac Stephens, 24 September 2019

      Recently, A.I. has become even more accessible with the Power Platform using the A.I. Builder functionality. Microsoft have given us four powerful templates to use to create our own models; Binary Classification, Form Processing, Object Detection and Text Classification. This blog will be the first

      Read the full article here
    • Object Recognition using the Microsoft PowerApps AI Builder

      Harshani Perera, 19 September 2019

      What comes to your mind when you hear Artificial Intelligence? A whole bunch of Hollywood films? Something for coders to figure out? Something too expensive to implement? Too complicated or just out of reach?This is no longer the case with Microsoft’s new AI Builder. The AI Builder easily allows us

      Read the full article here
    • How to display the Parent Customer Name on a Gallery or Form in a Canvas PowerApp

      Colin Maitland, 17 September 2019

      In this article, I demonstrate how to display the name of the parent Customer for a Contact on a Gallery or Form in a Canvas PowerApp.The App used for this example is connected to the underlying Contacts and Accounts entities in Dynamics 365 using the Common Data Source (CDS) Connector.In Microsoft

      Read the full article here
    • Setting Values in Dynamics 365 Portals using Entity Metadata

      Jordan Hohepa, 13 September 2019

      With Dynamics 365 Portals you can add Entity Web Forms which are the Portals’ way of displaying Dynamics 365 CRM Forms, allowing Portal Users to Create, View and Update records in Dynamics 365. The screenshot is an example of a Web Form that shows a simple Lead form to collect information about the

      Read the full article here
    • Using the Business Card Reader Custom Control in Dynamics 365

      Jordan Hohepa, 11 September 2019

      Recently it has been announced that there will be a wave of new Artificial Intelligence features being added to Microsoft PowerApps. The AI based features will be simple to add pieces of functionality that can do things like process a form or recognise objects in a picture. This blog covers the ‘Bus

      Read the full article here
    • How to update Dynamics 365 Option Set controls in a CDS Canvas PowerApp

      Colin Maitland, 10 September 2019

      In my previous articles, I have demonstrated how to set the default values for Lookup and Option Set field bound combo box controls in a Canvas Power App connected to a Leave Requests entity via the Common Data Service. In this article I demonstrate how an Option Set field bound combo box control ca

      Read the full article here
    • How to use Parameters in Power Query in Power BI

      Colin Maitland, 09 September 2019

      In my previous article I demonstrated how to use Connection Parameters in Power BI for the configuration of the Source step in Power Queries used to load data from Dynamics 365 (Online). In this article I will demonstrate how to use Parameters in Power Query.The following image shows the first three

      Read the full article here
    • How to Change a Power BI Relationship from Many-to-Many to One-to-Many

      Colin Maitland, 05 September 2019

      Recently when configuring a Power BI Data Model for Dynamics 365 I encountered a situation where I was not permitted to create a One-to-Many relationship in the data model between a Dimension table and a Fact table. Power BI automatically created a Many-to-Many relationship between the tables concer

      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
  • 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!