In this article, I demonstrate the transformation of Dynamics 365 UTC Date/Time values to New Zealand (NZ) Local Date/Time and Date values in Power BI, taking into account Daylight Saving Time.This demonstration highlights a significant difference in the transformation of these values when the Power
Read the full article hereIn this article, I demonstrate how to invoke a shared formula from events and controls in a Canvas PowerApp without the need to duplicate the formula many times.The following image shows a simple calculator created as a Canvas PowerApp. This calculator has various buttons, labels and associated form
Read the full article herePeople who know a little bit about programming may need a good starting point for understanding how Flow works and how they can replicate their programming knowledge in Flow. When first outlining a solution to a problem I break the problem down into pseudocode, a logical set of actions that I then u
Read the full article hereThe 2019 Wave 2 update has had some changes to the “Enable only the Unified Interface” setting.Paul’s blog describes how to enable the Unified Interface by default.Now with the Wave 2 release; “Enable only the Unified Interface” has been removed from the “System Settings”.This has been moved the Pow
Read the full article hereFacebook is one of the largest social media platforms that offers high view rates and precision with the target audience. Combined with Microsoft Dynamics 365, a leading cloud-based business applications platform to store and manage this information, we end up with a powerful combination for enterpr
Read the full article hereHave you ever had the “Invalid Argument” error from an Action before?This can happen when you are retrieving a record with code and it returns a null. If an Action has an EntityReference output, then it must always return data. So, if you encounter this problem, what should you do?If the logic is co
Read the full article hereIn Microsoft Flow, one of the most used controls is ‘Apply Each’ which is used to process a list of items. However, if there is a large list of items to process through, the ‘Apply Each’ action will run for a very long time, because only one item can be processed at a time. What if we could process
Read the full article hereAttending an annual trade or industry event as an exhibitor or a sponsor used to be a given. The Justification was always warranted – you were there to meet your customers, to meet prospects and push them further along the sales process or if you had to: “we need to be there as all of our competitor
Read the full article hereThere are multiple ways to create a triggered Flow with Dynamics 365. One way is by browsing to the Flow centre and creating the Flow.If you’re logged into Dynamics 365, Flow be accessed from the top left by clicking the Office 365 app button, then selecting Flow.Select the “Create” tab.Since we are
Read the full article hereCheck Part One to see how to create the model needed to Process a form.Once your model has been created and published you are able to create an App or Flow that utilises it. Microsoft Flow is an extremely powerful way to use the Form Processor because it can automatically take newly submitted forms
Read the full article hereIn 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 hereIn 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 hereIn 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 hereIn 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 hereIf 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