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 #1439: It’s OK to take a break
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
Tip #1437: Duplicate property names in JSON objects in Power Automate
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 […]
Tip #1433: How to list all Dataverse tables in style
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 […]
Tip #1431: Power Automate loops without variables
EDIT: Added range method. Thanks Natraj Yegnaraman for fixing my brain fart! When makers need a loop with a counter in Power Automate, say from 1 to 20 (or 0 to 19 for all of you developers out there), the immediate reaction I’ve observed is to reach for a gun variable: You don’t have to […]
Tip #1430: Add Power Automate flows into solution like a boss
You didn’t think I was waffling about replacing triggers in Power Automate flows for no reason, did you? Not once but twice, in fact. The technique of painlessly replacing triggers is more like a kata before you master the art of breaking bricks with your head 🧱🤕. Enter the world of solutions where nine out […]
Tip #1429: Replace Power Automate triggers without breaking too much, Part 2
By now you know not to trust triggers and recapture their output in the step immediately after the trigger. That way you fix only one step when trigger is replaced. Do not use trigger output beyond the first step in your flow Sulking Enabler But do you want more? Do you want to keep the […]
Tip #1428: Replace Power Automate triggers without breaking too much, Part 1
Always stash trigger output into variables or compose before continuing with the flow. If your trigger output contains a record from the underlying storage (Dataverse, SharePoint, etc) get that record and use the output of the get step downstream. Why? Because when you need to replace or recreate a trigger (happens more often than you […]
Tip #1424: The user does not have sufficient access right to run flow with custom connector
I’ve tried all the right things: Created, deployed, and configured custom connector into the target environment before importing the solution that uses the connector. All tests pass. Created a manual Power Automate flow as part of the solution. Shared the flow with the user (should not need to for the solution flows but just in […]
Tip #1423: Search for solution that does not exist
You are about to record or present a demo but your environment contains all the demos you performed previously and looks like this (zoomed out for brevity): What you are about to do next is what I call the “sweeping under the rug”: Search for the solution that does not exist yet Thee Nabler If […]