Power Apps Blog Posts for Microsoft Dynamics 365 and Dynamics CRM | Magnetism Solutions | NZ (Auckland, Wellington, Christchurch and Dunedin)

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