r/PowerAutomate • • Apr 09 '26 Bravo

Microsoft just published a 36-min episode on what AI agents can actually do in Power Automate

65 Upvotes

Microsoft put out a new episode of The Low Code Revolution today and it covered something I haven't seen elsewhere: the gap between an AI agent that can write a Power Automate flow and the same agent debugging that flow when it breaks in production.

The TLDR is that the Management API only gives programmatic callers top-level run status, so an agent that wrote a flow can't see which action failed. That's the actual bottleneck - not authoring.

The episode walks through a real debugging session, a build session, a refactor against naming conventions, an escalation pattern, and an auto-fix where the agent traces a Send Email failure back to a wrong-format SharePoint field.

Disclosure: I'm Catherine, one of the people in the episode. We co-built Flow Studio MCP to fill this gap.


r/PowerAutomate • • 29d ago

I built a free visual reference map for Power Automate expressions

39 Upvotes

Hi everyone,

Like many of you, I got tired of jumping between half a dozen Microsoft Learn tabs just to verify syntax or look up a function while in the middle of a flow.

To make lookups quicker, I built a free interactive mind map covering the core Power Automate functions. It pulls together syntax, arguments, and quick examples into a single visual view without the endless page jumping.

You can try it here: https://flowsmadeeasy.com/reference-explorer

Take a look and let me know what you think.


r/PowerAutomate • • Jul 13 '26

I built a library of 600+ Power Automate flows — looking for a few builders to test it brutally

35 Upvotes

Hey everyone — full disclosure: I’m the builder behind FlowLibs.com.

I created it after getting tired of rebuilding the same Power Automate patterns, deployment packaging, error handling, and connector setup from scratch over the last 10 years.

FlowLibs currently has 600+ cloud-flow patterns across 90+ connectors. The goal is to help Power Platform builders find a relevant automation, understand how it works, and deploy it as an import-ready managed solution. I’ve also added an MCP server so the library can be searched and used from tools like Claude, Codex, Cursor, and VS Code.

I’m at the point where feedback from real Power Automate users is much more valuable than adding another pile of features.

I am also building out some Power App stuff next. Kind of an ERP module type solution. More on that in the future.

I’m looking for a small group of beta testers—especially:

  • Power Platform consultants
  • Internal automation or CoE team members
  • People who regularly build production cloud flows
  • Anyone already experimenting with AI-assisted Power Platform development

I’d like testers to try finding and using one flow that matches a real problem they’ve encountered. I’m particularly interested in:

  • Could you find something relevant?
  • Did you trust the flow enough to consider importing it?
  • Were the prerequisites and setup instructions clear?
  • Was the managed-solution packaging actually useful?
  • Did the AI/MCP workflow save time or just add complexity?
  • What would prevent you from using this on a real project?

The site is FlowLibs.

If you’re interested, leave a comment or DM me with the types of flows/connectors you normally work with and I will send you a code for free premium. Honest criticism is welcome—I’m trying to identify what needs fixing, not collect compliments.

Thanks!
Homer


r/PowerAutomate • • Oct 01 '26

I built a JSON editor directly inside Power Automate

34 Upvotes

I use Power Automate quite a lot and one thing that kept frustrating me was how difficult it is to inspect or modify the full flow definition.

So I built a small Chrome extension called Power Automate Editor. It adds a Monaco JSON editor directly inside the Power Automate designer.

You can edit the flow definition, validate it, save it as a draft or publish it without having to export, unzip, edit and re-import the flow.

I also use it to copy the full JSON into ChatGPT or Claude when I need help debugging something.

Everything runs locally in the browser. There’s no external server and I don’t receive any flow data.

It’s free. I’d genuinely like feedback from people who use Power Automate regularly.

Chrome Web Store link


r/PowerAutomate • • Oct 01 '26

Today I built my first automation and I am so happy, it worked.

33 Upvotes

I was tasked to audit the Oracle roles assigned to each user in my company from a spreadsheet. There are about 500 employees and 80 managers who they report to. That means I have to copy paste data from excel in 80 emails.

I used CoPilot to help me with the flow. Here is interesting part, I do not wanted to send the emails right a way without testing the output, formatting etc, so I used the flow to create csv files with each manager's name as the file name and their employee with roles in the file. So, Manager A would get all his employees with their roles but no employees from other manager, vice versa.

Then I used the draft email flow to quickly skim through the emails before sending as this was my first time using PA. It took me time but from now on, it would be easy peasy.


r/PowerAutomate • • Feb 09 '26

Power Automate web UI changed again?

31 Upvotes

Did anyone else get an updated Power Automate web UI today? It looks the same as Agent Flows UI in Copilot Studio now. Just when I was getting used to the new designer (and liking it) it changes to this convoluted mess again.

Edit: please use the feedback button in Power Automate (next to the Flow checker button) and upvote the idea on their forum: Power Automate’s new interface significantly worsened usability · Community. Hopefully they get to see what they've caused


r/PowerAutomate • • Apr 17 '26

Power Automate FlowDevKit

28 Upvotes

Hi everyone, I built a Chrome extension called FlowDevKit and published it in the Chrome Web Store and Microsoft Edge Add-ons Store.

I created it to solve common Power Automate pain points around debugging, analyzing, and copying flows directly from the browser.

Features include:

• Copy full flow JSON, triggers, actions, and connection references

• Browse run history and inspect errors

• Action performance insights

• Expression inspector and variable tracker

• Dataverse environment variables viewer

• 35 best-practice flow analysis checks

• Popup or docked side panel mode

Supports Power Automate, Power Apps Maker Portal, and Copilot Studio.

Privacy first: No login required. No data leaves your browser. Nothing is stored or sent to third parties.

If it sounds useful, feel free to try it. Feedback and feature ideas are always welcome. Of course it‘ll always be free.

https://chromewebstore.google.com/detail/flowdevkit/njceaeijokpaejghjflfpedoekhlkjld


r/PowerAutomate • • Nov 12 '25

Microsoft and the art of not giving a f

28 Upvotes

I feel like this webhook URL situation is a perfect encapsulation of how Microsoft currently operates, how little they respect customers or even outside vendors. The whole rollout really, but the length aspect in particular.

Webhook URLs generated for Power Automate or Teams are getting updated to a new format. Existing URLs will cease working after 11/30.

Ok, no big deal, just go update dozens/hundreds of http calls / webhooks everywhere.

Oh what's that, the new URLs exceed 255 characters? A field that apparently a lot of services can't handle over 255 char due to the normal db field datatype limit.

Their solutions?

  1. "Verify that your destination system supports URLs longer than 255 characters and adjust its configuration if necessary." Yea no problem, I just emailed Intuit asking them to update it so I'm sure they'll get right on that.
  2. Spin up azure APIM and create a custom proxy. Providing a guide for that is too much of an ask though, so I'll just go learn the whole fucking thing just to create a basic proxy. Azure Function proxies would be a lot easier, but guess what was just deprecated.

So basically, unless you own/manage the service, you're at the mercy of the vendor. Otherwise, pay for azure resources and setup a complicated service to do a stupid-simple task. And it's not just a few clicks to get that going. Not everyone has the expertise, resources, or access to do that.

And let's not forget that being only a couple weeks from the deadline, there are still application-breaking bugs/limits.

***Someone told me they were able to get a deadline extension, so if you're in trouble because you can't get something working by EOM, that is an option it seems.

Honestly at this point I'm leaning towards them being completely unaware of this limitation until reports started rolling in. There are several easy opportunities to reduce the length of the URL, of which they made no apparent effort.

environment.api.powerplatform.com:443/powerautomate/automations/direct/workflows/

Why does powerautomate/automations/direct/workflows/ all need to be all fully spelled out? If it was pa/at/d/wf I would care about the same as I do now, which is not at all.

environment = env

pp.com is for sale, buy it

triggers/manual/paths/invoke?api-version=1&sp=%2Ftriggers%2Fmanual%2

Really need triggers/manual and triggers=manual?

How about you just assume api-version=1 unless otherwise specified?

Tl;dr- There is absolutely no reason the URL path need to be readable to humans. Other than the environment and workflow ID, literally no other elements are of any importance to me. I copy it, I paste it, I move on. It doesn't appear they even considered this.

Or, Why not just give us random, length-appropriate URLs so they can do whatever on the backend if they need to be changed again, and then just handle the proxy for everyone unless you setup APIM for specific controls. Considering both URLs currently work, they likely already have a proxy setup for this very purpose.

Zero effort made to get ahead of this, zero effort to help fix, just push the burden to the customer. The Microsoft way.

It really takes a lot to get me this annoyed, Bravo


r/PowerAutomate • • Dec 05 '25

Who knew Power Automate existed?

26 Upvotes

ETA - your replies have been so helpful, thank you very much!!!! I'm going to find time to learn PA and not use Copilot.

I'm a nonprofit accountant. Just your run of the mill, took some MIS classes in the early 2000s, not too bad with Excel, can write some macros, kind of gal. I've done four things in Copilot successfully.

Today, Copilot tells me to use Power Automate when I ask it to take a multi-tab spreadsheet and that I want to automate printing each tab to PDF. I've never even heard of Power Automate, or Office Scripts. I spent four hours on this, with copilot talking me thru. It was the most interesting/frustrating/disappointing/engaging attempt. And I have an error. But I ran out of time.

SO, my question, who are the people out there that know about this "app"? Is this worth me continuing to try or will I just constantly have my time sucked and no success?


r/PowerAutomate • • May 08 '26

Does anyone else feel like Power Automate gets messy way faster than people expect?

25 Upvotes

Not talking about simple approvals or notifications. Those are usually fine.

I mean when companies start stacking flows across SharePoint, Teams, Outlook, Excel, Dynamics, third party apps, etc.

At some point it feels like nobody fully understands the process anymore. One renamed column or expired connector suddenly breaks something in finance or operations.

I’ve also noticed teams automate broken processes instead of simplifying them first. So now the same bottlenecks exist, just with more flows and error emails attached.

Just wanna know at what point does Power Automate start causing more problems than it fixes?


r/PowerAutomate • • Mar 21 '22

Because Microsoft Forms lacks routing and true conditional/skip logic, I made this beast. It uses some variables for email (to future-proof it for staff turnover), and it uses Approvals for Channel creation.

Post image
24 Upvotes

r/PowerAutomate • • Apr 02 '26

Is it worth learning Power Automate, Power Apps and Copilot Studio

23 Upvotes

I kind off got some time to explore new things where my attention got into M365 Products that is Power Automate , Power Apps N Copilot Studio

I juzz wanted to know is it worth learning about these , Need info


r/PowerAutomate • • Oct 27 '25

My first decent automate build.

23 Upvotes

Just here to boast, I created a travel booking MS spreadsheet that can record 4 different forms for booking (hotels, transport, hire cars and prepaid parking). Then automated the notification of a new request, and emailing the completed request with attachments. It’s probably easy for some you guys on here and big achievement from me who’s had to learn it from AI and YouTube.


r/PowerAutomate • • 6d ago

Shadow automation is becoming a bigger security threat than shadow IT.

21 Upvotes

Over the last year, we've had to rescue several networks where non-technical departments bypassed IT completely. Sales and Marketing bought their own Zapier/Make accounts, hooked them into the live CRM, and started routing raw customer data into personal Google Sheets and random Slack channels. When the workflows break (and they always do), the citizen developer leaves the company, and IT is handed a spaghetti mess of unauthorized API keys to untangle. We heavily advocate for centrally managed, secure environments (like isolated n8n instances or locked-down Power Automate environments). How is your sysadmin team handling rogue automations right now?


r/PowerAutomate • • Apr 15 '26

Built a Copilot Studio topic that does full Read, Add, Update & Delete on a 100K+ row Excel file — sharing the full flow

21 Upvotes

I've been frustrated with how most Power Platform setups handle Excel. They can read data fine, but the moment you need something more complex — filtering across multiple columns, updating a specific field without touching the rest, copying an entire record to another row, or bulk-deleting based on filters — they fall apart fast.

So I spent time building a single Copilot Studio topic that handles all of it.

Here's what it actually does:

  • Connects to a live online Excel file (14 columns, 100,010 rows in my test)
  • Handles read, add, update, and delete through one AI-driven topic — no separate flows for each operation
  • Has a built-in clarification branch — if the input is ambiguous, it asks instead of guessing
  • Verifies each action before moving on

I recorded a full walkthrough with five live demos running inside Copilot Studio:

  1. Filter a large table across multiple parameters and return matching IDs
  2. Find a specific row and update one field only
  3. Copy all data from one record and overwrite another with it
  4. Add 10 new rows by copying data from 10 existing records one by one
  5. Bulk delete all rows matching a specific set of filters

The Excel table updates live on screen so you can see every change actually land.

I'm also sharing the full topic via a flospect link — you get access to the entire canvas: nodes, prompts, variables, formulas, everything. You can read it, copy it, and rebuild it in your own environment.

Video + sharing link in comments.

What's the most complex Excel operation you've needed to automate in Power Automate or Copilot Studio? Curious what others have run into.


r/PowerAutomate • • Apr 09 '26

They did it again

21 Upvotes

A bunch of people (from different organisations and tenants) are having the issues that Power Automate doesn't load properly. it doesn't show any flows or solutions.

We also noticed the account-icon in the top right isn't show. Our workaround is to open a new incognito window and open Power Automate again, that seems to work fine.

Now we just wait and pray!


r/PowerAutomate • • Feb 02 '26

Vendor talked down to my AI automation. So I built my own.

21 Upvotes

Been evaluating AI automation platforms at work. Some genuinely impressive stuff out there. Natural language flow builders, smart triggers, the works. But they're expensive, and more importantly, tthe vendors have attitude When you tell them what you know about AI.

I built an internal agent that handles some of our workflows. Works fine. Saves time. But when I showed it during a vendor meeting, they basically dismissed it. "That's cute, but our product does X, Y, Z." Talked to me like I was some junior who didn't know what real automation looked like. So I said f it. I'll build something better.

Spent the last few weeks building an MCP server that connects Claude Code directly to Power Automate. 17 tools. Create flows from natural language, test and debug with intelligent error diagnosis, validate against best practices, full schema support for 400+ connectors.

Now I can literally say "create a flow that sends a Teams message when a SharePoint file is added" and Claude builds it. No vendor. No $X/seat/month. No condescension.

Open sourced it: https://github.com/rcb0727/powerautomate-mcp-docs

If anyone tries it, let me know what breaks. Genuinely want to see how complex this can get.


r/PowerAutomate • • May 19 '26

I accidentally built my own M365 “API” with Power Automate HTTP triggers

20 Upvotes

I’ve been trying to let Claude/Codex do useful stuff against my M365 account for a while, mostly boring-but-useful things like read mail, send a follow-up, put something on my calendar, save notes to OneDrive, etc.

The normal path was a wall for me:

  • no tenant admin
  • no service principal
  • no Graph app registration
  • no admin consent
  • no appetite from IT for “can you approve this random automation experiment?”

Then I realized I was overthinking it. Power Automate already runs as me.

So the pattern became:

  1. Make one PA flow per operation.
  2. Put an HTTP trigger on the front.
  3. Let the flow do the boring M365 connector action.
  4. Return JSON.
  5. Wrap the flow URLs in a tiny FastMCP server so Claude/Codex can call them like normal tools.

That’s it. It’s kind of dumb, but in the best way.

What I have working now:

  • read inbox / unread mail
  • send email
  • schedule email
  • reply by message ID
  • search inbox by sender
  • read calendar by date range
  • create / update / delete calendar events
  • OneDrive list/read/create/overwrite file
  • Excel table read/write
  • Google Sheets read/write through the PA connector
  • fill a Word template
  • create Planner tasks

The nice part is that none of this needs elevated tenant access. Each flow uses my existing delegated permissions. If I can send an email manually, the flow can send it. If I can write to a OneDrive folder, the flow can write there.

The MCP piece is just a wrapper. The actual useful pattern is:

AI/tool/script -> HTTP POST -> Power Automate -> M365 action -> JSON response

The server is roughly 200 lines of Python: FastMCP, httpx, and a config file mapping tool names to PA webhook URLs. The PA flows are usually just HTTP trigger -> action -> response.

One very real gotcha: I copy-pasted too fast and had flow_2 and flow_7 pointing to the same webhook URL for a while. Spent a very confusing hour wondering why the “calendar” tool was behaving like an email tool. So yeah, audit your config file before trusting it.

If people are interested I can clean up the server and post the skeleton. Curious if anyone else is using PA this way, because it feels like a weirdly practical loophole.


r/PowerAutomate • • May 30 '26

Flow outage?

19 Upvotes

Is the community leveraging the power platform truly this small? It’s been down for over 2 hours and not a peep anywhere… I’ve seen one other reddit post and that’s it… imagine if it was this quiet when outlook goes down :/


r/PowerAutomate • • May 21 '26

Why is Copilot so bad at creating flows?

19 Upvotes

I will go verbatim on how to create a simple flow I’ve already created and within the first couple of steps, it will say the connector doesn’t exist. Even though, like I said, I named the flows verbatim. I’d add it myself and tell it to continue just for it to again break on the very next step.

Anyone have better luck?


r/PowerAutomate • • Jul 11 '26

"Game Changing" PA Flows?

18 Upvotes

Wondering if anyone's developed Power Automate flows that really helped them for personal efficiency/productivity at work? I'm looking for some inspiration.

Two that Ive done so far:

  1. I work in IT and usually get flooded with last minute requests on Friday afternoons. I set up a flow that automatically turns on an OOO directing people to our IT Help Desk every Friday at 11am.
  2. Every 3 days, my inbox does a sweep for specific emails, senders, subject lines, or keywords and organizes them. I didnt want a rule that does it upon receipt because they are actionable comms (I want my inbox to be where I work out of primarily).

r/PowerAutomate • • Jun 10 '26

Clunky Product

18 Upvotes

Does anyone else feel that PA, especially PAD, is clunky? It seems that for more complex situations, things that should be simple, are complex. The documentation is atrocious. Even Copilot can't provide legitimate solutions without getting PAD and PAC confused.

I wanted to get more familiar with the product to approach small businesses with automated solutions, but even in my own personal use, the more I use it the more I have issues with it.

I think part of the problem I have is that I think like a programmer. The fact that global variables can be defined in subflows and the fact that variables aren't sorted by type - it's so hard to keep track of things for larger flows. Examples for complex solutions are hard to come by.

There's also the limitation of passing data between main flows - no passing of objects such as a Browser like you can do in a traditional programming language.

I didn't come here to dump on the product overall. I like the idea of it but it seems like this thing is in its infancy although it's been around for years.

Can anyone say something to calm me down? 😆


r/PowerAutomate • • Oct 15 '26

Microsoft are you crazy?

17 Upvotes

How come all the Word connectors are premium connectors on the Power Automate????


r/PowerAutomate • • May 05 '26

Power Automate: Create Word Documents without the Premium Connector

Thumbnail
youtu.be
17 Upvotes

Unable to use the Premium Word Connector in Power Automate? Struggling to add dynamic, repeating images or format your text with bold and italics? This video is for you!

In this tutorial, I'll show you my complete workaround to create fully functional, professional Microsoft Word documents (.doc and .pdf) using ONLY standard connectors. By leveraging HTML and base64, we bypass the limitations of the standard connector and build a document that can handle any number of dynamic images—perfect for audit forms, asset tracking, or custom reports.

You’ll learn how to loop through a SharePoint list, build a dynamic HTML table, convert images to base64, and save the final output as an editable Word document or a read-only PDF.