Posts

In this blog post, I will share a workaround to update or delete records in different legal entities when using the Fin & Ops Apps connector. This connector can be used with Microsoft cloud services: Power Automate, Power Apps, and Logic Apps. When the records to be updated or deleted are not part of the default company of the user, you will get an error “No resources were found when selecting for update”. Continue to read how to solve this error.

Read more
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

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.