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
DynamicsCon 2020, for the community, by the community
The past 9 and 10 September were accompanied by the long-awaited DynamicsCon, a virtual learning experience for Microsoft Dynamics 365 and Power Platform users and professionals. You missed out? Don’t worry, all sessions have been posted on the DynamicsCon YouTube channel for consumption on demand :). To describe it very quickly, it is an international event, made up of two days full of high-level sessions spread over four different tracks: Power Platform, Finance and Operations, Customer Engagement and Business Central. As I said, the event was divided into 2 days and 4 tracks each day, getting more than 60 sessions […]
+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
5 years is nothing… #AxazureRocks
Directly. Today, Monday, August 3, 2020, just 5 years ago I made the best decision of my life (on a professional level). On this day, 5 years ago, I signed an employment contract with a small, but really small, company called Axazure. I remember quite fondly the day I went to do the interview. Antonio was there waiting for me with the rest of the team (2 more people 🤣), actually it wasn’t even an interview, because he didn’t let me speak, he just started telling me everything he had in mind, with full transparency. It is true that I […]
+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
