• Transforming Dynamics 365 UTC Date/Time to local Daylight Saving and Standard Date/Time in Power BI

      Colin Maitland, 04 November 2019

      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 here
    • How to Invoke Shared Formulas in a Canvas PowerApp

      Colin Maitland, 30 October 2019

      In 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 here
    • Replicating If Statements, For Loops and Do While Loops in Microsoft Flow

      Adam Murchison, 29 October 2019

      People 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 here
    • Change in how to Enable Dynamics 365 Unified Interface

      Nick Chin, 25 October 2019

      The 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 here
    • Facebook Lead Ad to Dynamics 365 via LeadsBridge and Flow

      Sean Roque, 24 October 2019

      Facebook 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 here
    • Dynamics 365: Solving the Action Invalid Argument error with Flow

      Nick Chin, 23 October 2019

      Have 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 here
    • Improving Microsoft Flow Runtime using Concurrency Control

      Satyvir Jasra, 22 October 2019

      In 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 here
    • Using Dynamics 365 and the Power Platform to better calculate the ROI on sponsoring events.

      Ryan Ingram, 18 October 2019

      Attending 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 here
    • Quickly create a manually triggered Flow in Dynamics 365

      Nick Chin, 17 October 2019

      There 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 here
    • Creating a Form Processor in the Power Platform AI Builder (Part 2)

      Isaac Stephens, 15 October 2019

      Check 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 here
    • How to Create Copies of Microsoft Flows

      Ronelle Raath, 14 October 2019

      In 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 here
    • How to Highlight the Selected Record in a Canvas PowerApp Gallery

      Colin Maitland, 11 October 2019

      In 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 here
    • Configuring Dynamics 365 Currency Fields in Power BI

      Colin Maitland, 10 October 2019

      In 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 here
    • How to Accurately Calculate Ages in Power BI

      Colin Maitland, 07 October 2019

      In 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 here
    • Using Scopes and Branches in Microsoft Flow

      Adam Murchison, 04 October 2019

      If 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