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 […]
Tip #1422: Leave old stuff behind
Let me start 2022 slowly, with a tip how to avoid annual cleanup. It all started with this email: Darn, I completely forgot about those folders and big thumbs up to Richard for reminding me. Richard is one in a million though, most would simply ignore the shared folders. Until such time when you drop […]
Tip #1420: JSON Function and size limits in Power Apps
Power Fx (gotta use the cool keyword!) JSON function in Power Apps is pure magic, it’s like a compactor converting anything you throw into it into a neat text representation to send over the wire, engrave on a golden bullion, or stash it as an alphabet soup. It works great apart from the times when […]
Tip #1418: In-app notifications in model-driven apps
Welcome to inaugural video shorts where all human knowledge is compressed into the bites of 60 seconds or less, to be consumed while waiting for the paint to dry. In this episode we help Lisa to enable in-app notifications in model-driven Power Apps without any code using a freshly baked XrmToolBox tool by Ivan Fricko. […]
Tip #1417: Power Excel in SharePoint
You’ve seen us in Tip #1415 doing some Microsoft Graph abracadabra to call Excel functions directly from Power Automate. To do that we use Excel spreadsheet located on OneDrive for Business. Documentation mentions in passing that “You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in […]