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 hereIn 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 hereRecently, 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 hereLookup 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 hereMicrosoft’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 hereFormula 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 hereLots 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 hereIn 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 hereIf 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 hereCommand 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 hereThe 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 herePower 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 hereIn 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 hereIn 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 hereTo 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