In this article, I will demonstrate how to configure a Line and Stacked Column chart in a Power BI report to display Won Revenue and Open Revenue against Sales Targets and Target Remaining for Opportunities from Dynamics 365. This demonstration highlights a useful approach for using this type of cha
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 hereThe productivity dilemmaA recent report from the New Zealand Productivity Commission, Productivity by the numbers, paints a bleak picture of the productivity of NZ compared to other OECD countries. But it’s not just us - measured productivity growth in recent times has been weak globally.Productivit
Read the full article hereUntil now, custom PCF controls have only been available for Dynamics 365 Online. If you tried to install a PCF control in a version 9.0 on-premise environment, you would receive an error stating ‘This action is not supported’. With the release of 9.1 for on-premises, and with a little bit of magic,
Read the full article hereI was wanting to create a filtered look up on a BFP that showed cities based on the selected country that was a field within a form. Developing on from my colleague Sean’s blog, I came across an issue, where if the field was changed, the filter was not updating.After investigating the issue, I solve
Read the full article hereIn Software testing, test cases are the step-by-step instructions carried out to verify the behaviour of a Software application. There are many tools to write test cases such as Excel, XMind, Testing tools or even Word. Azure DevOps is also a tool that provides the ability to create test cases easil
Read the full article hereIn this article, I will demonstrate how to dynamically align the end value for the Y axis between two corresponding charts in Power BI. This demonstration will use of the example of displaying Won sales versus Lost Sales by Fiscal Quarter.A common approach to comparing values, such as Won Sales vers
Read the full article hereIf you have used Alert Dialogue boxes before in Dynamics 365, you will have noticed that they do not scale dynamically when there is a lot of text. Instead, the out of the box functionality has a default size and displays a scroll bar. This can become messy if there is a case when your Alert Dialogu
Read the full article hereIn our Dynamics 365 environment, there is a custom 1 to Many relationship between Contact and Case. In the Case entity, there is an existing Calculated Field called “Case Duration” which calculated the time in hours, between the Case “Created On” field and the current date and time. Notice that the
Read the full article hereDynamics for Marketing allows you to bypass the manual use of segments and customer journeys to send Marketing Emails through the send now button, although customer journeys and a static segment are generated in the background to track the insights. This accompanies the test send functionality which
Read the full article hereIn this article I will demonstrate how to update the addresses for a Contact in Dynamics 365 using a Canvas App that is embedded in a Model Driven App Contract.This image shows the embedded Canvas App. The app is displayed on a tab named Addresses on a Model Driven App Contact Form. You learn how to
Read the full article hereWhat are they and what’s the difference?An add-in is a software program that expands the capabilities of bigger programs. It is a term commonly used by Microsoft and other platforms which have additional functions that can be added to primary programs. An add-on is a software extension that adds ext
Read the full article hereThe Microsoft Teams connector for Power Automate is a bit limited when it comes to messages and replies. With the built in Teams connector, we can only get ALL messages in a channel, using the “Get messages (preview)” action. If we want to get just the replies to a specific Teams message, we can use
Read the full article hereSitting Microsoft Exams is a great way to prove your skills and gain ‘Certifications’. These Certification are now only valid for 1 year after a recent change by Microsoft. However, if you are sitting a Fundamentals exam these currently do not have an expiry date. As you can see below, I have the Po
Read the full article hereWhen you are presented with a project to test, it can be overwhelming at first in deciding what to test to ensure a quality product will be delivered to the customers. There are an infinite number of tests that can be run but it’s not possible to test everything. You are also bound by two big factor
Read the full article here