Using Power Automate to import data into an existing SharePoint list is fairly straightforward, except when the data isn’t very clean. For instance, if a number column contains blank values or some non-numerical garbage, SharePoint connector will flip out. OpenApiOperationParameterTypeConversionFailed The ‘inputs.parameters’ of workflow operation ‘Create_item’ of type ‘OpenApiConnection’ is not valid. Error details: Input […]
We all enjoy flexing our Dataverse or Dynamics 365 skills from time to time. Many of us have meticulously crafted a demo instance from proverbial stone and blood. However, one of the challenges is keeping the data up-to-date. There’s nothing worse than displaying 20 tasks that are all overdue by four months. Fortunately, Dataverse offers […]
You use the import utility in Dynamics, and sometimes you get the option to export your failed row and sometimes you don’t. What gives? The answer is it depends on your import file type. If you import from XML or from CSV, you will get the Export error rows option. If you import from xlsx, […]
Kevin Altman emailed jar@crmtipoftheday.com with the following question about data import in Dynamics 365: Users want to perform updates to existing data in CRM but the export for update/re-import process is too rigid as data often changes between the export and re-import, blocking the import (I guess CRM forces you to have no changes to […]
Importing into Dynamics 365 can be concerning to even the most hardened of CRM consultants. Often, if we are importing into a production system, we have tight schedules to get in and out before the users log in. If we are still importing data when the users come online, the system can be unacceptably slow […]
tl;dr Setting data validation error on the form level with Xrm.Page.ui.setFormNotification call will NOT stop form from closing, setting errors on individual controls with Xrm.Page.getControl(arg).setNotification, on the other hand, will. To achieve even better results, use business rule instead of the javascript. Slightly longer version Friend of mine pinged me to help with the script […]
The goal functionality in Microsoft Dynamics CRM is very powerful, but in my opinion, is not used as often as it should be. One of the reasons for this is because goals do not recreate themselves–you must recreate them for each time period. This can be very cumbersome, especially if the time periods are short. […]
of the