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 #1402: Why you should not use Microsoft Lists/SharePoint Lists for business-critical Power Apps

Long list of things to do before I die written by chalk on blackboard

SharePoint lists (and now Microsoft Lists) are an easy way to quickly create lists of data for use in a Power App. Makers can quickly create lists, add fields, and populate data for canvas apps. However, not all apps are equal from a complexity perspective. If the app is simple and contains data that is […]

Tip #637: Tipster guide to Microsoft Flow – codeless integration between CRM and other apps

Friday Flow

Apparently, for people who like bending their joints backward, Friday Flow is a thing. We’ve decided to join the bandwagon and in today’s video we will show you how to create a basic workflow between SharePoint and CRM using Microsoft Flow. Flow is a cloud service, currently in preview, that allow you to create automated […]

Tip #536: CRM Online, SharePoint On-premises and OneNote walk into a bar

OneNote

There seems to be a theme here, at CRM Tip of the day, with trios of various components walking into refreshment establishments. On this occasion, it did cost me a few hours of mouse-bending investigation. Enjoy the summary. As we mentioned before, if you carefully followed the steps to configure server-based authentication for Dynamics CRM […]

Tip #218: Sales Literature vs. SharePoint

So you have implemented Dynamics CRM with SharePoint document integration. The mindset of many companies with SharePoint is that SharePoint is where all documents should live, and that is a good idea, as SharePoint provides document collaboration features not found in CRM. However, Microsoft Dynamics CRM includes Sales Literature functionality. The value of sales literature is that […]

Tip #205: Other Really Killer New Features Spring ’14

It’s the last day in the series of topic specific video posts for the Spring ’14 Dynamics CRM Online release. Today we have finish up with a collection of 6 different topics that I have grouped together. When you finish this set in the series give yourself the Spring ’14 Badge of Knowledge. Misc Items […]