Posts

Excel to Purchase orders

In this post, I will share a Power Automate Flow example. This example is importing data from Microsoft Excel into Microsoft Dynamics 365 Supply Chain Management. It has an example of how to import multiple purchase orders and lines. Besides, it has some logic and special field handling. The example is also shared as a download.

Read more
Let your Operations Flow - Part 8

This is another episode of my blog series on the Microsoft Dynamics 365 for Finance and Operations connector for Microsoft Flow. In this blog, I will share some information about the Execute action option. What is it and how can you create your own actions for OData?

Read more
Let your Operations Flow - Part 7

In this part of the introduction to Microsoft Flow, I will provide some tips on making the Flow readable for yourself and others and how to handle decimal, integer and date fields using the Excel connectors.

Read more
365Saturday experience

Saturday May 18, we had a 365Saturday event in the Netherlands. The organization asked me to do a presentation on this event. As there were no obligations for the kids playing baseball, I accepted the invite and prepared for a session on security architecture in Microsoft Dynamics 365 for Finance and Operations. This post is about my 365Saturday experience…

Read more

Downloads

This download contains a Power Automate flow to import purchase orders into Dynamics 365 Supply Chain Management from an Excel file. Both the Excel template and the Power Automate package are included in the download.

The example shows how to deal with grouping purchase orders per vendor, increase line numbers per order. The field mappings include mappings for date and decimal fields which do need formulas instead of a direct field mapping from Excel.

You can find a demo of the flow and technical explanation in the next post: Let your Operations Flow – Excel to Purchase orders example

 

Don’t forget to read the License.txt file before installing and using the software.