Get & Set Site of Users based on City field with the help of Flow
Nov22

Get & Set Site of Users based on City field with the help of Flow

I’ve demoed this Flow during my session ‘Automate your Dynamics 365 admin tasks with Flow!’ at Dynamics 365 Saturday Belgium in Brussels last Saturday. This Flow will set the Site field for Users based on the City field, that is synced from Azure AD. Here is the overview of the Flow: First I get the list of Site records that is stripped down to an array with only the Name and SiteId in the… Continue Reading StefanS365’s...

Read More
Flows & Slides of my session at Dynamics 365 Saturday Belgium
Nov21

Flows & Slides of my session at Dynamics 365 Saturday Belgium

Hereby the slides of my session ‘Automate your Dynamics 365 admin tasks with Flow!’ at Dynamics 365 Saturday Belgium in Brussels last Saturday. Automate your Dynamics 365 admin tasks with Flow! from Stefan Strube Related blog posts of the flows that were demoed: Yes we can just do it with Flow series. Here are the download links for the Flows:...

Read More
User photos lost in synchronization > Flow to the rescue: Set Entity Image
Nov19

User photos lost in synchronization > Flow to the rescue: Set Entity Image

I’ve demoed this simple but effective automation solution with Flow during my session ‘Automate your Dynamics 365 admin tasks with Flow!’ at Dynamics 365 Saturday Belgium in Brussels last Saturday. User photos in Office 365 are not synced to Dynamics 365. And if there’s no photo available in Office 365, at least there’s an avatar with the initials of the user. It would be nice to have the same… Continue Reading...

Read More
The ‘Flow Connectors for Dynamics 365’ Matrix
Nov12

The ‘Flow Connectors for Dynamics 365’ Matrix

Continue Reading StefanS365’s Article on their...

Read More
Playing around with Playbooks for custom entities
Nov08

Playing around with Playbooks for custom entities

Reading the October ’18 Release Notes I got interested in the new Playbooks functionality. Since the release is rolling out I started playing around with Playbooks. Jukka Niiranen wrote an excellent blog post about Playbooks for Dynamics 365 Activity Templates. Kevin Annfield did his part about Automating Dynamics 365 Playbooks. So I wanted to find out if Playbooks can be enabled for… Continue Reading StefanS365’s Article...

Read More
How to edit settings of Dynamics 365 Trial instance
Nov08

How to edit settings of Dynamics 365 Trial instance

I’ve added a Trial instance of Dynamics 365 version 9.0 to our tenant. Our company name was copied to the instance name and to the URL with an extra ‘0’ to make it unique. But when I connected to our production instance (with the same name) from XrmToolBox I got connected to the Trial. What the flow? OK, that must be because of the same instance name so let’s change that. Oh no, that’s not… Continue Reading StefanS365’s...

Read More
Connect Dynamics 365 version 9.0 on-premise with Microsoft Flow
Nov05

Connect Dynamics 365 version 9.0 on-premise with Microsoft Flow

Dynamics 365 Server, version 9.0 is available for download now. It’s possible to connect Dynamics 365 version 9.0 on-premise with Microsoft Flow: Triggers: make use of webhook registration to post a request to Flow connector ‘When a HTTP request is received’ Actions: make use of the Flow connector ‘HTTP with Azure AD – Invoke an HTTP request‘ and choose the option to Connect via on-premise… Continue Reading StefanS365’s...

Read More
How to clone a record and set its lookup field to new parent in Dynamics 365 CE
Nov02

How to clone a record and set its lookup field to new parent in Dynamics 365 CE

I would like to create a copy of an existing “template” record (custom entity) and then set the lookup on the new record to a parent, in this case the account from where I start the on-demand workflow. With the help of Demian Raschkovan’s Dynamics-365-Workflow-Tools I am able to clone a record. And with the help of Andrew Butenko’s Ultimate Workflow Toolkit I can set the lookup field on the… Continue Reading StefanS365’s...

Read More
Slides of SPSBE session about Model-driven apps with PowerApps
Oct20

Slides of SPSBE session about Model-driven apps with PowerApps

Hereby the slides of my session about Model-driven apps with PowerApps, at the SharePoint Saturday Belgium on 20th October 2018. Model-driven apps with PowerApps – SPSBE 2018 from Stefan Strube Continue Reading StefanS365’s Article on their...

Read More
Microsoft Flow – Business Process Flows from a traditional CRM perspective
Oct15

Microsoft Flow – Business Process Flows from a traditional CRM perspective

This post is manually triggered by the blog post of Pieter Veenstra: Microsoft Flow – Business process flows from a traditional Flow perspective. Microsoft added Business Process Flows (BPF’s) to their Microsoft Flow platform. BPF’s are managed in PowerApps since the integration between Dynamics 365 and PowerApps. With Spring 2018 update (v9.0.2) their data is stored in the Common Data… Continue Reading StefanS365’s...

Read More
Using Dynamics 365 Webhooks as the third way to trigger Flow
Oct09

Using Dynamics 365 Webhooks as the third way to trigger Flow

There are two connectors available in Flow to get triggers from Dynamics 365 CE once it’s integrated with Common Data Service for Apps (Spring 2018 update > V9.0.2): the socialist Dynamics 365 Standard connector and the capitalist Common Data Service Premium connector. To get the socialist Dynamics 365 Standard connector working as trigger you need to enable Change Tracking on Entity… Continue Reading StefanS365’s Article...

Read More
Create Account hierarchy in Dynamics 365 CE with Flow, based on CoC data
Oct03

Create Account hierarchy in Dynamics 365 CE with Flow, based on CoC data

We make use of a web services solution and subscription to enrich the accounts with data from the Business register of the Chamber of Commerce (CoC). In this way the records can be filled with validated data from a reliable source, and the accounts get unique numbers so the duplicate detection can intervene when an account with the same number is created. The CoC data contains among others the… Continue Reading...

Read More
Schedule update of Currency Exchange Rates in Dynamics 365 CE with Flow
Oct01

Schedule update of Currency Exchange Rates in Dynamics 365 CE with Flow

Working with multiple currencies in Dynamics 365 CE, you might have the need to update the currency exchange rates on a regular basis. There are custom solutions and even a XrmToolBox plugin to do the job but let’s keep it simple and just do it with Flow. Here is the overview of the flow: First I initialize a variable of the type Float, since the Exchange Rate field in Dynamics 365 is a… Continue Reading StefanS365’s...

Read More
User attribute values lost in synchronization > Flow to the rescue: Middle Name – revisited
Sep28

User attribute values lost in synchronization > Flow to the rescue: Middle Name – revisited

For the sync between the HR system and the local AD we use an on-prem SQL database that can be connected to Flow via a Data Gateway. In this database there is the Middle Name field available that I will use to sync it to Dynamics 365. Overview of the flow: For each user the local SQL database is queried: When the Middle Name value from the database is not equal to the Middle Name in Dynamics… Continue Reading StefanS365’s...

Read More