Microsoft Flow and Dynamics 365

In the digital age of automation, where repetitive routines are performed by machines and letting man-power to do more intelligent tasks, Microsoft introduced Microsoft Flow that helps this cause.

Microsoft Flow is a cloud based service introduced in Office 365 that provides workflow management to integrate and automate different tasks across more than 85 applications. It allows users to create workflows that automates time-consuming tasks like approvals, send/receive notifications, collect/update data and synchronize files.

Microsoft Flow can tighten the gap between various predefined Microsoft/Non-Microsoft applications like Dynamics 365, Sharepoint, Twitter, One Drive, Slack and many more.

How Microsoft Flow Works:

Microsoft Flow works basically helps users to create workflow so the first step in that workflow is the event on which the workflow should fire. There are already many predefined triggers available in Microsoft flow such can be seen in screenshot below:

Microsoft Flow-8


Microsoft Flow allows users to react to those triggers from one application and perform some task in another application using it’s data and that too with zero coding knowledge.

A nice example would be “When a file is added on SharePoint Online, send an Email notification”.

After setting up the Trigger, you can either put a condition, perform an Action or even apply a loop to perform actions.

Microsoft Flow-11


There are also many predefined templates available, where you can choose according to your business requirement.

Microsoft Flow-12

Microsoft Flow and Dynamics 365

Just like other various apps, Microsoft Dynamics 365 can very much benefit from Microsoft Flow. There are numerous scenarios and applications that can use this automation process and simplify the integration with Dynamics 365.


We will show you an example to fully understand Microsoft  Flow and it’s applications with Microsoft Dynamics 365.

Scenerio: Attach OneDrive’s files related to Account as Notes to respective Account if Filename starts with Account Name.

Trigger: When files is created in OneDrive.

Condition: Filename (OneDrive) starts with Account Name (Dynamics 365)

Action: Create a Note’s record in Dynamics 365.

Steps to create the Flow:

Below are the steps to create this workflow:

  • Log-in to your Office 365 account and click on Flow.

Microsoft Flow-13


  • Under My Flow menu, click on Create from Blank on top right corner.

Microsoft Flow-14

  • Select the “OneDrive – When a file is created” trigger from the list. You may need to sign-in from OneDrive account and authorize Microsoft Flow.

Microsoft Flow-1

  • Select the OneDrive’s folder you want to associate with the trigger. Flow will only fire, if new file is added/created in that folder.
  • After selecting folder click on New Step > Add an Action.

Microsoft Flow-2

  • After setting up the trigger, we need to list all the “Accounts” record from Dynamics 365 so we can put the condition and retrieve the related Account record for the uploaded file. For this select “Dynamics 365 – List Records” from the Action’s list.

Microsoft Flow-3


  • Specify the Dynamics 365’s organization name and Accounts as entity name.

Microsoft Flow-4

  • Click on Add a condition.
  • Set the condition as shown in screenshot. It will filter the records from Accounts that are related to that file.
  • You can perform action on both condition fulfilled and condition failed, by default it is set as DO NOTHING.

Microsoft Flow-5

  • File name and Account Name in the above screenshot are dynamics content resulted either from triggers or Actions. Click on see more if your required field is not listed.

Microsoft Flow-6

  • Under IF YES section of the condition tab, click on Add an action.
  • Select Dynamics 365 – Create a record from the list.

Microsoft Flow-15


  • Select your Organization Name and other related fields as seen in screenshot below.

Microsoft Flow-7

  • Final Flow will look like this:

Microsoft Flow-16

  • Give a proper name to Flow and click on Create flow > Done

Microsoft Flow-10

Congratulations, you have made your first flow, now it’s time to test it.

Steps to Test the Flow:

  • Create an Account’s record in Dynamics 365.
  • Upload/Create a file in OneDrive, have a name that starts with that Account’s name.
  • Open that Account’s record and a Note’s record with the uploaded file as attachment will be waiting for you.
  • If you don’t see that record at once, then have some patience and recheck after some time.
  • You can check the logs of the icon, by clicking the the specified icon under My flows in screenshot below:

Microsoft Flow-17


Microsoft Flow is a great addition in Microsoft family. With the slogan of Work Less Do More it really saves time and helps you automate the processes without having a proper coding knowledge.

Leave a Reply

Request a Free Demo
Enter Your Information below and we will get back to you within few hours