Tip #1443: Let SharePoint deal with rogue data

The image depicts a flowchart illustrating the process of importing data into a SharePoint list using Power Automate, highlighting the challenges of handling 'dirty' data. The diagram shows the initial data import encountering errors symbolized by warning signs, due to non-standard or 'dirty' data. Subsequent steps demonstrate the use of Power Automate to clean or filter out these errors, with symbols like checkmarks indicating successfully cleaned data. The overall image conveys a journey from obstacle-laden data processing to achieving a streamlined and efficient import process, emphasizing the transformation from 'dirty' to clean, usable data.

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 […]

Tip #1440: Relative dates in sample data

Import Excellence Award

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 […]

Tip #1041: Make Dynamics 365 data import less rigid

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 […]

Tip #1034: Set Yourself Up For Efficient Importing

Prepare for import

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 […]

Tip #471: What will stop your form from closing

Failed import using business rule

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 […]