I often see makers declaring multiple settings in a Power Automate flow using a single variable per setting.
Instead, use Parse JSON action and keep your flows compact by combining all related settings in one neat JSON object.
To create an empty array in a Power Automate formula, just use json(‘[]’). That’s it — there’s your entire tip.
The product has been renamed at least twice since we talked last time about how to restrict the date picker control in now Power Pages. But most importantly that code, according to some reports, no longer works. Fear not, here’s the revised version that works perfectly well in Power Pages (it did 5 minutes ago, […]
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 talk about security around Dataverse and Power Platform from time to time. We even dabble into platform agnostic security tips. Today is all about vendor-agnostic cybersecurity. Learn the fundamentals of identity management, zero trust, AppSec, and data security in this new 7-lesson open source course, “Security for Beginners” created by Microsoft Cloud Advocates. Each […]
WARNING: Niche L400 tip ahead. tl;dr If you’re expect primary column name to be tablename + “id“, add an exception for systemuser and team tables – both will come back as ownerid in custom API. L400 If custom API has an output property of type EntityReference then, for example, for account (or any other “normal”) table, the […]
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 […]
I am back after lengthy hiatus. Any day is good to restart but today feels just right: Changes are coming but let’s resume the daily ritual first. GeorgeTipster in charge, reporting for duty 🫡 Almost forgot! Cover photo by Abi Schreider on Unsplash
From time to time you may be forced to deal with JSON objects in Power Automate that contain duplicate property names. Consider this object, for example: To make this object maker-friendly, the common approach is to use Parse JSON action and derive schema from the data itself. When done, maker can use properties as dynamic […]
Is there any way to export automatically or with a script a list of all the Dataverse tables in an organisation? From our good friend Shan McArthur came a multilayer answer (narrated and illustrated by The Enabler): One: We have a virtual entity called entities that will give you a list of all entities in […]
of the