In this article, We will see how to export data from Dynamics 365 HR via Rest API. Dynamics 365 HR/ F&O supports two APIs. The Data management framework's package API.The recurring integrations API. Both APIs support both data import scenarios and data export scenarios. The following table describes the main decision points that you should... Continue Reading →
In this article, We will see how to change the workflow approver. This is the common request by the user. What is workflow? The term workflow can be defined in two ways: as a system and as a business process. Workflow is a system Workflow is a system that runs on the Application Object Server (AOS). The... Continue Reading →
In this article, We will see how to use reserved keyword in SQL query. There are couple of scenarios when customer has table fields which are reserved keyword such as select, date, max and group. Reserved Keywords Here is the list of reserved keyword list https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15 How to use reserved keyword in SQL query Wrap... Continue Reading →
In this article, we will see how to import and export workflow configuration to multiple legal entities. This is possible in Dynamics 365 F&O/ HR and most of the time user does not know this feature. They are always try to create new configuration in other legal entities. To avoid this situation, We can use... Continue Reading →
A good way to enhance your reports is to add images to them. Static images on the page are good for some purposes. But sometimes you want images that relate to the data in your report. In this article, we will see how to display images from Dynamics 365 F&O/ Human resources in Power BI.... Continue Reading →
In this article, we will see how to integrate Dynamics 365 HR with Azure AD. Currently, there is no functionality available within Dynamics 365 HR. It is very useful for partner/customer to develop by using Power Automate, Azure AD connector. Below points are covered in this article. How to create a user in AD when... Continue Reading →
In this article, We will see how to expose custom field on Virtual entity. There are some scenarios where you would require to add new custom fields to track additional details in Dynamics 365 HR. Pre-requisite Virtual entity needs to be configured in Dynamics 365 HR. User should have an access to Dataverse Configure virtual... Continue Reading →
Microsoft announce that Dataverse connector is available for Power BI and tabular data stream(TDS) endpoint. Power BI users have more options when connecting to Dataverse environments, including Dataverse for Teams. The endpoint enables better relationship discovery in the Power BI dataset model. The new connector supports Direct Query providing real-time data and support for the... Continue Reading →
Today, Microsoft announced Microsoft Power Fx: the low-code programming language for everyone. This is the newest member of the Microsoft Power Platform family Microsoft Power Fx, an open source formula language for low code that’s based on Microsoft Excel. Power Fx is exciting for three key reasons: Power Fx is open source. The future of programming... Continue Reading →
In this article, We will see how to delete a record in Web apps through Power Platform with HTTP Post method. In previous article, We saw how to update data from Webapp and display in Power Apps. Here is the link for previous article HTTP Patch from Power platform to Web app This is the overall structure... Continue Reading →
