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

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.