My Power Automate Tips

So, as I go through making new creations with Microsft’s Power Automation (previously Flow), I thought I’d collect my observations and ways of doing things.

  • Setting a variable = null (using an expression) and then testing if it is null (expression) does not work. Type the word null into the value box rather than using an expression and it will work.
  • To work out the difference in time between two date/time values, convert them both to ticks (using the ticks expression) and subtract the later one from the earlier one. Divide the answer by the relevant number below to get the answer you want:
    • Divide by 600000000 to get the difference in minutes

Automating Releases for D365 & Power Platform – Episode 5 Reference Data

In this video, we use the Configuration Migration Utility to define which reference data should be extracted by our Azure DevOps Pipelines to take our data into version control (Git) ready for deployment to a Dynamics 365 Customer Engagement / Power Platform CDS instance.

The configuration tools can be downloaded via https://docs.microsoft.com/en-au/powerapps/developer/common-data-service/download-tools-nuget

Your support by SUBSCRIBING to my YouTube channel is very much appreciated.

Automating Releases for D365 & Power Platform – Episode 4 Portal Deployment

In this video, we explore CI/CD (continuous integration/continuous deployment) using Azure DevOps Pipelines to take our portal configuration into version control (Git), package it up and deploy it to a Dynamics 365 Customer Engagement / Power Platform CDS instance.

To download the configuration file for the portal contents mentioned in the video, please refer to https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/migrate-portal-configuration

Your support by SUBSCRIBING to my YouTube channel is very much appreciated.

Automating Releases for D365 & Power Platform – Episode 3 Solution Deployment

In this video, we explore CI/CD (continuous integration/continuous deployment) using Azure DevOps Pipelines to take our solution contents from version control (Git), package it up and deploy it to a Dynamics 365 Customer Engagement & Power Platform CDS instance. We also look at how we can recall a solution from any point in time as the basis for our deployment.

To make things easier for you, below are the strings used to specify the source folder and

Source Folder of Solution to Pack:
$(System.DefaultWorkingDirectory)/Azure_Source/D365_Solutions/$(SolutionName)

Solution Output File  and  Solution Input File:
$(System.DefaultWorkingDirectory)\$(SolutionName).zip

Your support by SUBSCRIBING to my YouTube channel is very much appreciated.

Automating Releases for D365 & Power Platform – Episode 2 Version Control

In this video, we explore CI/CD (continuous integration/continuous deployment) using Azure DevOps Pipelines to copy our Dynamics 365 Customer Engagement & Power Platform solutions to version control (Git) so that we can a) see what has changed over time and b) recall a solution at any point in time that was captured.

In the video, a couple of copy/paste blocks were used. I’ve provided them below for easy reference.

Powershell Script:

$date=$(Get-Date -Format 'yyyyMMdd')
Write-Host "##vso[task.setvariable variable=CurrentDate]$date"
Write-Host "Set CurrentDate to $date"

Command Line:

echo Commiting all changes
git config user.email "justin@notjust365.com"
git config user.name "Automatic Build"
git checkout master
git add --all
git commit -m "Automatic solution commit $(CurrentDate)"

echo Push code to repository
git -c http.extraheader="AUTHORIZATION: bearer $(System.AccessToken)" push origin master

Your support by SUBSCRIBING to my YouTube channel is very much appreciated.

Display SP files in D365 CE using PowerApps and Flow

In this video, we look at how to use a PowerApp and a Flow to enhance the user experience of accessing related files from SharePoint within the Dynamics 365 Customer Engagement (CRM) screens.

As mentioned during the video, the URI for the Flow action ‘SharePoint – Send an HTTP request to SharePoint’ is
_api/web/GetFolderByServerRelativeUrl(‘incident/body(‘List_records’)?[‘value’][0]?[‘relativeurl’]‘)/Files
The text above in Bold/Italics is entered using Expression

Below are some references used in building this solution:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/
https://preview.flow.microsoft.com/en-us/blog/return-data-to-powerapps/

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/pass-current-embedded-canvas-app

Your support by SUBSCRIBING to my YouTube channel is very much appreciated.

Create a website or blog at WordPress.com

Up ↑