-
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
Filter by Category
Filter by Author
Adam Murchison
Alfwyn Jordan
Arthur Mandisodza
Calum Jacobs
Colin Maitland
David Mochrie
Dominic Liu
Gayan Perera
Harshani Perera
Isaac Stephens
Jaime Smith
Jared Johnson
John Barrencechea
John Eccles
Lauren Withers
Paul Nieuwelaar
Roshan Mehta
Roz Millar
Ryan Blaikie
Ryan Ingram
Sarah Coleman
Sean Roque
Shalane Williams
