Problem While working with Switch control in Power Automate, if the field used in the switch control is blank we will get this error:- “It is of type ‘Null’ but is expected to be a value of type ‘String, Integer” I am going to share one possible way of handling which I used, if you have a better way please… Read more »
Issue Recently I was working on scheduling SSIS packages developed using Kingswaysoft toolkit for Dynamics 365 CRM, while testing my job I encountered following error: “Source: Data Flow Task Dynamics CRM Destination [11] Description: The runtime connection manager with the ID “{…}” cannot be found. Verify that the connection manager collection has a connection manager with that ID..” Solution Based on the error message, it… Read more »
Requirement We got one requirement where we wanted to download Word Document based on the word template after validating some conditions. I am going to share sample code which can be used to download word document based on the template name. Solution We create a flyout button similar to existing word template flyout and hide out of the box flyout… Read more »
Requirement Add a custom Flyout menu with buttons and identify which button is clicked. Solution Sometimes we need to add a custom flyout ribbon button and need to write code depending on the button which is clicked. Normally that is done using menu, but I will be adding button to flyout and using command there to perform action. I will… Read more »
Problem Recently while working on Power Automate to send notification if custom activity record is completed before 15 day but still invoicing is not done yet, I was facing time zone issue while comparing date. I will provide details how I sold this issue. Solution Initially I started creating my flow where I used Recurrence and fetched my entity records… Read more »
Issue Recently we started getting error in CRM to BC integration where we have used SSIS Integration toolkit for Microsoft Dynamics 365 from KingswaySoft and we have hosted this in Azure Data Factory. We were getting following error: “SsisDBOperationGuid”: “0ea2f07f-56ee-404d-8762-8d38851f7cb7”, “SsisDBOperationId”: 64741, “OperationErrorMessages”: “2/9/2021 7:33:27 AM +00:00 : Data Flow Task:Error: Dynamics CRM Destination.Inputs[Input].Columns[invoiceid] has lineage ID 1611 that was… Read more »
Requirement Sometimes we have requirement to change activity status using custom button. Here we are going to discuss how we can complete activity using WebAPI and action using a custom ribbon button placed on the subgrid. Solution We are going to complete activity using custom action and then we will be calling our custom action using WebAPI. We will add… Read more »
Issue Recently while working in one of the customer environment we found sales order is automatically submitted to BC without pricing details as we soon as order is created like below: I am going to share some details how I fixed this issue. Details This environment has Sales order integration enabled and we have developed a custom workflow for customer… Read more »
Introduction While importing data into Dynamics 365 with lookup fields, sometime we get duplicate reference found error, if you are getting same error then here is the quick tip for you . Details While we are importing data into Dynamics 365 CE with lookup field, Dynamics try to relate lookup records based on the primary field name by default. So… Read more »
Introduction Sometime back I wrote Show child accounts on Bing Maps using client side code, today in this this article I will be discussing how we can show Bing maps in Canvas app and embed it in Model driven app. In this sample app we are going to show Event organizers on the Bing maps and it will look like… Read more »