Let your Operations Flow – Part 1

After spending some time with building some automation for Microsoft Dynamics 365 for Finance and Operations with Microsoft Flow, it would be a good timing to write some blogs. The intention is to help you getting started understanding the Microsoft Flow tool and build your own business automations.

Let your Operations Flow

This is the first part where I will explain the experience to sign up for Microsoft Flow and create your first automation to interact with Microsoft Dynamics 365 for Finance and Operations. First of all, it is good to know that basics of Microsoft Flow is part of the Microsoft Dynamics 365 subscription. If you need additional Flow licenses depends on factors like which connectors you need to use and how many Flow executions you need each month. Pricing can be found on the next page: Microsoft Flow – Pricing.

When you want to sign up for using Flow, you can go to the home page of Microsoft Flow. Let your Operations Flow Part 1

Then login with your organizational account or sign up for free, to get access to Microsoft Flow.  Let your Operations Flow Part 1

As you will notice, you will start with an empty environment. When you click the button Explore Templates, you can search for examples. In this case, I searched for Operations to see if there are any templates available.

Let your Operations Flow Part 1

The template to move rows from Excel to Microsoft Dynamics 365 looks interesting to start with. Note that the templates are using some legacy names for Microsoft Dynamics 365 for Finance and Operations. I do expect that this will be changed in future to align with the current product naming.
Let your Operations Flow Part 1

When you have selected a template, Flow will assume it will use your login credentials to also connect to a Dynamics 365 instance. Click Create to continue.
Let your Operations Flow Part 1

This example starts with a trigger to run the flow using a recurrent schedule. You can change the interval if you like. The next block is an Excel action to get rows. for this demo, I created a sheet with just a few fields and rows. I saved this sheet on my OneDrive for Business. Note that the data should be present in a named table in the Excel sheet. In this example the name is VendorTable.
Let your Operations Flow Part 1

You can lookup the file name and then the Table name lookup will show you all tables present in the Excel file.
Let your Operations Flow Part 1

The block Apply to each is used to loop all rows for a given result set. In this case it is the collection of Excel rows from  the table.

Now we arrived at an interested part of the Flow. The Create record action is an action of Microsoft Dynamics 365 for Finance and Operations. If you open the Instance lookup, you would see all environments of Microsoft Dynamics 365 for Finance and Operations where you have access as primary tenant. Select the environment where you want to test importing the vendors.
Let your Operations Flow Part 1

When the Instance setting is correct, you will have an option to change the Entity name. The Vendors entity is provided in the example. As there is a later version available, I did change it to VendorsV2. When you expand the list with fields, you can map the variables from the Excel file quite easy. Select a field name; then a value from the Dynamic content. It will copy the value into the field name. My Excel file does not have a Company identification. For this reason, I did fix the value to be NLMF (new created company in my test environment).
Let your Operations Flow Part 1

The next action will delete the rows from the Excel table once they are imported. You again have to provide the file name and table name.
Let your Operations Flow Part 1

Once the setup is complete, you can run a Test. It will actually execute the Flow and will process the contents of the Excel file. For a next run, you can enter new vendors in the same sheet. If you don’t want to delete the rows, you can remove this action block.
Let your Operations Flow Part 1

Click Run flow to continue executing the process.
Let your Operations Flow Part 1

You will be directed to the execution page where you can follow the progress of your Flow. Also this same page can be used for analyzing results when you do encounter errors.
Let your Operations Flow Part 1

When the flow execution is completed without errors, you will get notified on the form. You may refresh the page manually if it takes to long…
Let your Operations Flow Part 1

The vendors are now imported in Microsoft Dynamics 365 for Finance and Operations. You can check the results in the All vendors list page or vendor details form.
Let your Operations Flow Part 1

I used this exact procedure when I did start my Flow adventure. In my next blog (Part 2), I will explain the Create record action for Microsoft Dynamics 365 for Finance and Operations in more detail and will provide some additional tips.

 

That’s all for now. Till next time!

 

 

Microsoft Dynamics CommunitySubscribe to this blogger RSS FeedMy book on Merging global address book records in AX 2012

 

 

 

 

 

Comments5
  1. Sébastien VerspeeltFebruary 02, 2019   

    Thanks for sharing your knownledge and experience. Already looking forward to the details and tips of the next blog!

  2. Fatih GorkFebruary 04, 2019   

    Thanks André!

Leave a Comment!

Your email address will not be published. Required fields are marked *