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 […]
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 […]
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 […]
If you are building your Flows from solutions and connecting to Common Data Service, you should use the CDS (current environment) connector. When you do, if you populate lookup fields, you might get a “resource not found” error message. If you get this error, like I did, you are probably just putting the guid of […]
I’ve always been a fan of webhooks. In fact, I even manage to mention them twice in my rare crystal ball post for developers. Today’s tip is a good reminder from Stefan Strube that webhooks are not only a solid way to launch your code in Azure Function but also can be a good alternative […]
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 […]
MVP Elaiza Benitez gave me some very helpful advice when it comes to Microsoft Flow: If you want to filter Dynamics 365 records to only records that you create in your flow, you should use the CDS when a record is created (preview) trigger, not the Dynamics 365 trigger. If you use the CDS trigger, you […]
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 […]
of the