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 #1392: Missing entities in Power Automate

Missing piece

The classic “give me 5 minutes and I’ll whip a flow for you” did not start well. Users entity table was not there. Options Choices: It’s something trivial and I’m simply no longer worthy. ‘u’ is not an actual ‘u’ but Russian ‘и’ typed accidentally but in a weird font. It’s a UI bug It’s […]

Tip #1367: Tell apart create, update, and delete events

It’s not every day one gets to chime in on a post from Jerry, the lifetime tipster and Power Automate connoisseur. In this post Jerry talks about When a record is created, updated, or deleted trigger in CDS (current environment) connector and how to tell the event that triggered the flow using a clever combination […]

Tip #1227: Use CDS instead of Dynamics 365 connector in Flow

A hand plugging a wire into a network router

People have been reporting that Dynamics 365 triggers in Flow are not consistent. Sometimes they fire twice, sometimes not at all, sometimes they fire after a manual test run. There are some other weird side-effects I did not even look into. Why? Because of one of them quick tips. Where possible, use Common Data Service […]

Tip #275: Uninstalling the MDM Connector

If you implement Microsoft Dynamics Marketing, Microsoft documents the process of installing the MDM connector. However, should you ever need to remove the connector, the instructions are not as clear. At a high level, the process of uninstalling the connector is:  Be sure the connector queues are drained. Verify in Azure management portal that there are […]