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
    • How to configure navigation menu in Power Apps Portal

      Dominic Liu, 23 February 2023

      In this blog, we will show you what to do so that you can show/hide different tabs on the navigation menu for different portal user, based on their web roles. Firstly, the Power Apps Portal navigation menu should be configured in the ‘Web Link Sets’ Entity within Dynamics. If you are logged in with

      Read the full article here
    • How to add sequential row numbers to a table using a SQL CTE

      Colin Maitland, 23 February 2023

      In this article, I will demonstrate how to add a unique sequential row number to records in a SQL Server table using a SQL Common Table Expression (CTE).This is an example of selected columns from a table named Opportunity. This list of Opportunities selected here has been sorted by the Created On d

      Read the full article here
    • How to add Knowledge Base Articles in Power Apps Portals

      Dominic Liu, 04 August 2022

      Recently, I have been working on a Power Apps Portal project, and our customers requirement is to add Knowledge Base Articles (KB Articles) on the portal webpages so that they can easily change the content inside Dynamics 365, here are two ways to add KB Articles on the webpage.Table PermissionsTabl

      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
    • 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
    • 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
    • Scanning Receipts into Dataverse using Power Apps and AI Builder

      Roshan Mehta, 08 March 2022

      Lots of organisations have a cumbersome process for submitting expense claims. You spend a few days out of town and collect physical receipts, which you then staple to a handwritten expense claim form and submit it to the finance person. It would be much nicer to take a photo of the receipt and auto

      Read the full article here
    • Power Automate - Writing Efficient Flows with the Switch Operator

      Sean Roque, 04 March 2022

      In a Power Automate, the Switch Operator is a built-in action that allows us to execute a unique branch of flow actions depending on the value of a variable. This essentially functions the same as nesting Condition operators, except that it’s much more simplified, while providing a built-in ‘default

      Read the full article here
    • How to upload files in canvas app

      Dominic Liu, 03 March 2022

      If you want to allow your Canvas App user to upload documents and saved in your database, but when you search for all the out of box Canvas App input components you can’t find one that support all types of documents, that is because Microsoft currently only has two types of input components for file

      Read the full article here
    • Introducing Command Checker for Model-Driven App ribbons

      Dominic Liu, 10 February 2022

      Command Checker is a Microsoft feature that can help you to get the best and most knowledge at Model-Driven App interface level. You can also check the Enable Rule, Display Rule and Action all in the App so you don’t need to rely on other third-party tools. You can find more information from this li

      Read the full article here
    • New User Interface features in the Dynamics 365 2021 Release Wave 2

      Harshani Perera, 29 September 2021

      The 2021 Release Wave 2 for Dynamics 365 which will be rolled out from October 2021 through to March 2022 comes with several new features for the user interface that are quite nice. Following are some of the highlights listed below. I have also provided a few videos which explain the features in mor

      Read the full article here
    • 10 Tips for Beginner Power Automate (Microsoft Flow) Users

      Harshani Perera, 08 July 2021

      Power Automate (previously Flow) is a tool within the Power Platform that can help automate tasks and processes. It can also connect different applications and services together. As a beginner to Power Automate it can be daunting at first in trying to figure out how it all works for someone who is n

      Read the full article here
    • Canvas Apps - Formatted Number Text Input and Display Demonstration

      Colin Maitland, 19 April 2021

      In this video blog, I will explain some limitations of using a Text Input control in a Canvas App to enter and display numbers. I will then demonstrate how a Label, Text Input and Timer control may be configured and used together to allow the data entry and display of formatted numeric values in a C

      Read the full article here
    • Whitelisting IP addresses in Bulk in the PowerApps Portals Admin Center

      Jared Johnson, 08 March 2021

      In the PowerApps Portals admin center you are able to set up an allow list of IP Addresses that can access the portal via the Set up IP address restriction option.You can only add 1 address at a time, so what if you have to add a large number, like a few hundred or more?Using the Network Monitor in

      Read the full article here
    • How to Create an Effective Chatbot

      Harshani Perera, 19 February 2021

      To create my own chatbot using Microsoft’s Power Virtual Agents, I’ve been interacting with bots online to see which ones were easy to use and were actually helpful. Through these interactions, I found some commonalities amongst the high performing ones that I will share with you today which can hel

      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
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.