Tag: MSDyn365FO

Power Automate & MSDyn365FO: Deep dive (III)

In this third and final post about Power Automate and its connector for Microsoft Dynamics 365 Finance and Operations apps, we are going to talk about the different write operations that exist in it. These operations are the following: Get record Update a record Delete record Before starting with them, we must bear in mind that these operations will be available only for those entities that have the Is Read Only property with value No, that is, entities that allow data to be written. In fact, Power automate itself warns us, as we can see in the following screenshot: Create […]

+Info

Power Automate & MSDyn365FO: Deep dive (II)

We continue with the series of articles about Power Automate and the different operations that can be performed on Microsoft Dynamics 365 Finance and Operations apps. As we saw in the previous article, thanks to the MSDyn365FO premium connector for Power Automate, we have a series of triggers and actions to interact with our system. In this new post we are going to start talking about the actions, specifically the different reading actions that exist, which are: Get list of entities Get a record Lists items presents in table If you want to learn more about the available trigger, take […]

+Info

Power Automate & MSDyn365FO: Deep dive (I)

In recent weeks I have received more than one query related to the use of Power Automate to perform actions on Microsoft Dynamics 365 Finance and Operations apps, so I have decided to write a series of articles to delve a little deeper into this topic. Power Automate Power Automate, formerly known as Microsoft Flow, is one of the applications that make up the Microsoft Power Platform. This tool allows you to automate repetitive tasks or carry out communications between different applications through workflows. For this purpose, it has more than 400 connectors that allow us to communicate with applications […]

+Info

NetCoreConf Virtual2 2020

Just a few days ago we lived an intense and interesting weekend thanks to the people of NetCoreConf. For those who do not know, NetCoreConf is a free event on Microsoft technologies that tries to bring quality technologies and sessions to those areas where historically there was no availability to attend an event of these characteristics. This year, their purpose was to hold events in Barcelona, Valencia, Asturias and finish in great style in Madrid, unfortunately, the current situation forced them to cancel the last two, but this has not stopped them in their endeavor, and they have organized two […]

+Info

No-Code: Extend MSDyn365FO with the Power Platform

No-Code solutions are here to stay, you just have to see the amount of content, use cases, articles, videos and events dedicated, for example, to the Microsoft Power Platform. In my specific case, I do not think that this platform has come to replace all the customizations that we do through X++, although they can help us solve certain problems without the need to generate code, in a faster, cheaper way and easier to maintain. Let’s put a use case for Finance and Operations: We need to notify a user or group of users when customers are modified and are […]

+Info

Business Events: Custom Payload (IV)

As you know (I hope 😅), a few days ago we presented a session about Business Events for Developers at DynamicsCon. In this session, we were talking, among other things, about how we could customize the payload of the Business Events that we expose to the outside, to give them a different structure than the one that comes by default, and being able to reuse all the functionality that Dynamics F&O brings OOB. At the end of the demo, we had a few minutes of live Q&A, and one of the assistants (J.C.) made a question related to the part […]

+Info

Working with Azure SQL from X++ using SQLClient

Microsoft Dynamics 365 Finance and Operations brings with it a whole data management framework that allows us to integrate with a database in Azure SQL in a totally standard way. This framework allows us to export ERP information to an external database for reporting (BYOD), so that we can generate our reports and dashboards in Power BI without having to attack the system database (AxDB), but… What happens if what I need is to read or perform other types of operations not allowed by this framework against an external DB? In this article I will show you a helper that […]

+Info

Generate and Import Excel files with X++ in #MSDyn365FO

We all know that the management and integration that #MSDyn365FO brings as standard with Microsoft 365 products is very good, especially with Excel files. Even so, there are occasions when we have to develop our own code to generate files or to import them for different reasons, such as importing files with a specific format that does not conform to standard integration, or generating files for which we must do a series of previous calculations. For this reason, I have decided to share with you a class that I have developed. This class allows you to manage these files in […]

+Info

Dynamics Power Spain Online 2020

Last Saturday, June 13, Dynamics Power Spain Online 2020 took place. This event has become, in my opinion, the national reference event on Microsoft Dynamics 365 and Power Platform. For those who do not know it, it is the event previously known as Dynamics 365 Saturday, a totally free event held on a Saturday (obviously) at the Microsoft Iberica offices in Madrid. Last year, this event brought together more than 400 people from all over Spain, and even from abroad, who were able to enjoy an excellent day of community, surrounded by friends and colleagues. For many, this is a […]

+Info

Azure Key Vault & MSDyn365FO: Setup Certificates and Passwords

From time to time I have to configure the electronic certificate to be used in the SII (Immediate Information Supply) module and it always happens the same, I don’t remember exactly what I had to do. That is why I have decided to write this post, with a detailed step by step detailed so that I don’t have to spend more time googling how to do it, and hey, if I also help someone in the same situation, not that bad! This post will be divided into three main parts. The first two parts are, as I said, the ones […]

+Info