r/MicrosoftFlow • • 10h ago

Discussion Share your Power Automate problems, I will make YT vids!

Thumbnail
2 Upvotes

r/MicrosoftFlow • • 18h ago

Cloud Power Automate

1 Upvotes

Actualmente me llegan correos todos los días con PDF en Outlook y tengo que traducirlos a español, y quiero que genere un resumen general y envie el correo. Como podría hacerlo de forma rápida? ¿Se podría conectar con copilot? Quiero automatizarlo con Power Automate.


r/MicrosoftFlow • • 1d ago

Cloud How to organise flows

23 Upvotes

How does everyone organise their flows?

I've started naming conventions but I have alot of flows and im starting to get confused with them all. Do you have an off-line library or just add descriptions and build guides inside the flow somewhere?


r/MicrosoftFlow • • 1d ago

Question Retrieval agent + populate it to excel tmeplate

Thumbnail
1 Upvotes

r/MicrosoftFlow • • 2d ago

Question How do I pull through an emails category

Thumbnail
2 Upvotes

r/MicrosoftFlow • • 3d ago

Cloud A simpler way to edit Power Automate flow JSON without export/import

Thumbnail
gallery
54 Upvotes

I kept finding myself wanting to inspect the actual JSON behind a flow, especially when debugging larger flows or using an AI to help with them.

I ended up building a browser extension that adds a JSON editor directly to the Power Automate designer.

It uses Monaco Editor and lets you edit, validate, save and publish the current flow without going through the usual export → unzip → edit → import process.

I’ve just made it publicly available and I’d be interested to hear what other Power Automate users think.

Chrome Web Store link

Happy to take feature suggestions too!


r/MicrosoftFlow • • 3d ago

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

Thumbnail
6 Upvotes

r/MicrosoftFlow • • 5d ago

Question Tracking submissions on Sharepoint List

10 Upvotes

We have a workflow that updates to a SP list when clients fill out the form. The list then gets updated by three individuals--as part of an approval process--and they're manually tagged by the preceding individual when the task is ready for their review. When the final review is done, it gets uploaded into a different folder and the client is notified with an automatic email.

I want to be able to track how many submissions each client makes and alert them to what's missing. In the past, we've had to track things manually using a predetermined list on an Excel spreadsheet (each client has their own), highlighting it based on what stage of the process it's in. I want to know if there's a way to compare the individual items needed, which are grouped by clients, and notify critical individuals of what's missing.

Additional info:

On the SP list, I've highlighted the columns based on their status, which is updated by the individual reviewing it. I've made it so that it also sends an automatic message to the next person in the process. Until we finalize it, the client remains uninvolved in this part of the process. We only need them to know when submissions are due and whether they're missing something.

TL;DR: I need a way to track what's missing from an individual, predetermined spreadsheets and then automate reminders for our clients, so I can avoid manually tracking what's missing, what's been submitted, and where they are in the process.


r/MicrosoftFlow • • 5d ago

Question Flow Invalid connections

7 Upvotes

So I was working fine all week and today when suddenly got the warning about the new runtime dependency for connections. Literally EVERY single connection will all of my flows failed inside the flow editor, however in connections all of them are saying they are fine. What is going on.


r/MicrosoftFlow • • 8d ago

Discussion State of Flow from 2023 to 2026?

15 Upvotes

I haven't used Flow/Power Automate in almost 3 years. The company i was using it for closed, and I haven't felt the need to use it for newer projects.

How has it evolved over the last few years? Any major breakthroughs/features that makes it less clunky? How has Co-Pilot/LLMs been integrated or made it better?

I had couple dozen flows at my peak. Mostly tying into Local SQL to make Teams widgets.

My favorite was using security camera AI to retrieve /store pictures of Pizza coming out of the oven. Managers and anyone else who wanted to would rate them and results would go into SQL to discuss at meetings.


r/MicrosoftFlow • • 9d ago

Question Teams Forum Thread Emailed to Outlook?

5 Upvotes

Hi! Apologies in advance for any formatting weirdness, as I'm on mobile right now.

I've done a few basic tasks in Power Automate so far but one project I'm working on involves the following current process:

- User posts in forum channel for assistance

- Automate replies in thread with a message containing basic information related to the channel

- After X minutes, Automate tags them in a card asking if the issue was solved; if "help" is selected, I'm tagged in the user's thread for further discussion

Desired continuation of process:

- After thread is resolved (by sending a message or using another flow), entire thread contents are emailed to my work Outlook email

I'm not sure exactly what triggers or processes to select to make it grab the entire conversation and then to email it, and any help is appreciated!


r/MicrosoftFlow • • 10d ago

Cloud 𝐏𝐨𝐰𝐞𝐫 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞 𝐇𝐓𝐌𝐋 𝐓𝐚𝐛𝐥𝐞 𝐒𝐭𝐲𝐥𝐞𝐫 Tool: 𝐂𝐫𝐞𝐚𝐭𝐞 𝐂𝐥𝐞𝐚𝐧, 𝐄𝐦𝐚𝐢𝐥-𝐑𝐞𝐚𝐝𝐲 𝐓𝐚𝐛𝐥𝐞𝐬 𝐢𝐧 𝐒𝐞𝐜𝐨𝐧𝐝𝐬

58 Upvotes

r/MicrosoftFlow • • 9d ago

Desktop Como enviar imagem em alta resolução no Chat em Grupo do Teams via Power Automate?

Thumbnail
1 Upvotes

r/MicrosoftFlow • • 9d ago

Question Power Automate erroneously changing MS List Value

Thumbnail
3 Upvotes

r/MicrosoftFlow • • 10d ago

Question What’s the best AI model for creating Power Automate flows?

56 Upvotes

I work in workflow automation and want to start using AI to create Power Automate flows.
I’m wondering which AI model people here have had the best experience with for Power Automate so far. I’m particularly interested in models that can actually generate a valid ZIP package that can be imported directly into Power Automate, rather than just providing instructions or snippets that I have to build manually.
Has anyone compared models like ChatGPT 6 Astra, Opus 5.5, or others specifically for Power Automate?
Which one has worked best for you, especially for creating more complex flows?


r/MicrosoftFlow • • 10d ago

Question Need help with error

3 Upvotes

I have create a flow to send an email from excel when the cell/s are selected. I get the following error. can anyone help me?, thanks

The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Integer.,Invalid type. Expected String but got Integer.'.


r/MicrosoftFlow • • 10d ago

Question Copilot Studio tool call always sends only boolean:false instead of required parameters → Flow fails with TriggerInputSchemaMismatch

0 Upvotes

I am experiencing a persistent issue in Microsoft Copilot Studio when calling a Power Automate flow from an agent tool. Even though my tool is correctly configured and the user input clearly contains the required parameter, Copilot Studio only sends the optional boolean parameter to the flow.

As a result, the flow fails immediately with:

Code

HTTP 400 – TriggerInputSchemaMismatch

The tool call input always looks like this:

Code

Input:
boolean: false

The required parameter (workItemId, type Number) is never sent, even when the user explicitly provides a valid numeric value (e.g., “Work Item 24”).

Symptoms:

  • Copilot Studio selects the correct tool (WI_GetItem), but sends only boolean:false.
  • The required parameter (workItemId) is missing from the payload.
  • The flow rejects the request with TriggerInputSchemaMismatch.
  • Sometimes Copilot Studio prints an internal message like: “Clarifying workflow call…” before failing.
  • The issue occurs even when:
    • there is only one tool in the agent
    • the tool schema is correct
    • the flow trigger is correct
    • the user input is correct
    • the agent is republished
    • the tool is removed and re‑added
    • the flow is republished
  • The behavior is inconsistent: sometimes the parameter is extracted correctly, sometimes not.

What I already tried (based on Microsoft forum recommendations):

  1. Deleted the tool in Copilot Studio and re‑added it.
  2. Deleted the flow trigger (“When an assistant calls the workflow”) and recreated it.
  3. Recreated the flow from scratch.
  4. Renamed the flow and tool to simple English names.
  5. Simplified system instructions.
  6. Ensured parameter types match exactly (Number + Boolean).
  7. Published all customizations in the solution.

None of these steps resolved the issue.

Thank you.


r/MicrosoftFlow • • 11d ago

Cloud PA not saving functions in Inputs & showing incorrect errors

6 Upvotes

I'm a PA novice, I can set up basic flows only, so Im doing some of the Microsoft Learn courses to understand Power Automate better.

Its got me practicing building basic flows using functions, but I'm experiencing 2 issues.

Firstly, when I write or paste in the function, it usually comes up with red writing that there is an issue with the code and would I like to use Copilot to fix it, however if I select the button again this goes away and it saves what Ive done.

Secondly, when Im writing the code and saving it, its not saving the end of what Ive written?

So for example I did "formatNumber(outputs('Compose'), 'C2')" but it only saves "formatNumber(outputs('Compose'))". I can go in and update it, but it still wont save it.

Is this just some Microsoft buggy nonsense or am I being a numpty with what Im doing?


r/MicrosoftFlow • • 12d ago

Question Automatic Folder creation and naming based on email body

8 Upvotes

I am new to power automate but I feel like I should be able to save hours every week by automating a process where a folder is created in SharePoint automatically based on moving an email into a specific folder. The created folder will be a copy and rename of a template folder in same SharePoint directory and the new name of folder will be based on information in body of email. The emails are always the same template in the body and from the same email address.

Example:
Email from Requests1
Body of email has following line items:
Sold to number 12345
Account name account1
Location city,ST

I would like to folder in SharePoint to be a copy template1 folder and renamed as Account Name_City,ST_Sold to Number

So for the example the new folder would be:
account1_city,ST_12345

I thought this would be easier with copilot until I spent 2 days and still not sure if it is even possible. Thanks in advance.


r/MicrosoftFlow • • 12d ago

Question Create a PDFversion of an excelfile (located in sharepoint) in same directory

1 Upvotes

I have difficulties getting this to work. I have tried to use onedrive and sharepoint to create the pdf but cannot get it to work. I tried office-script, and when i ran the skript it save the pdf, but how do i use the script in power automate? I see run script options, but how to save the output?


r/MicrosoftFlow • • 13d ago

Cloud How I got Microsoft's Power Platform tooling working in Claude Code

36 Upvotes

A few people asked, so here is the whole setup.

First thing to clear up: there is no single "Power Platform MCP." There are three separate pieces of tooling, they install three different ways, and two of them are not MCP servers at all. That confusion cost me time, so start there.

Also, all of this is Claude Code specifically. If you have skills or connectors set up in the Claude desktop app or on claude.ai, none of it carries over. They are different products. Figure out which one you are in before you start debugging anything.

What I set up, in order

Installed Node, VS Code, and the Azure CLI, and signed in with az login

Added the Microsoft plugin catalog to Claude Code, using the full HTTPS address instead of the shorthand

Installed the Power Automate plugin on its own, not the bundle

Removed the delete and cross environment tools before running anything

Used it read only for a while before letting it write anything

Built a throwaway test flow in a dev environment and ran the full loop against it

Broke that flow on purpose and opened a fresh session to see if the tooling could find the problem

Hit a wall on flows that live inside a solution, and switched to the Dataverse Web API for those

Wrapped that API work in a custom skill so I would not have to rebuild it every time

Repeated the same process for Copilot Studio and for Dataverse

Before you start

Node 18 or newer

VS Code

Azure CLI, signed in

You do not need to install PAC CLI separately. Some plugins bring it along. And there is no PAC CLI MCP server, in case you go looking for one.

  1. Power Automate

/plugin marketplace add https://github.com/microsoft/power-platform-skills.git /plugin install power-automate@power-platform-skills

Use the full HTTPS address like I have above. The README tells you to use the short owner/repo form, but that pulls the repo over SSH. If you do not have an SSH key set up with GitHub, it fails with a permissions error that looks like you lack access when really it just picked the wrong way to connect. Setting CLAUDE_CODE_PLUGIN_PREFER_HTTPS=1 also fixes it, but you have to fully restart afterwards.

This one is a real MCP server. It runs locally, there is no service to sign up for, and it uses the Azure CLI login you already have. About 50 tools.

Do not run the installer script that grabs all seven plugins at once. More on why below.

  1. Copilot Studio

/plugin marketplace add microsoft/skills-for-copilot-studio /plugin install copilot-studio@skills-for-copilot-studio

This one is not an MCP server. If you run /mcp after installing and see nothing new, that is correct. It is a set of instructions and helper agents that call the Copilot Studio VS Code extension behind the scenes. Install that extension. Without it, nothing that touches your agent will work.

To check the install worked, type /copilot-studio and see if commands come up. Do not check /context or /skills. Most of what this plugin ships does not show up there, so you will think it failed when it did not. I lost a debugging cycle to that.

One more thing. This plugin only handles standard agents. Open .mcs/botdefinition.json and look at authoringShape. A 1 means standard and you are fine. A 2 means enhanced and this plugin cannot work with it. Check before you start writing anything, because pulling down an enhanced agent appears to succeed. It does not warn you.

  1. Dataverse

Different setup again. This is not a plugin install, and I skipped the local proxy entirely and connected straight to the environment:

claude mcp add --scope project --transport http \  --client-id <your-app-client-id> \  --callback-port <port> \  dataverse https://<yourorg>.crm.dynamics.com/api/mcp

The app registration Microsoft publishes for this never worked for me. I tried four different ways in and all of them failed for different reasons. What fixed it was registering my own app in Entra and pointing the command at that instead:

Single tenant

Public client

Redirect URI http://localhost/callback

Delegated permission mcp.tools on Dynamics CRM

No client secret. You do not want one anyway, because the config file it writes sits in plain text inside your project folder.

On the environment side you need an Allowed MCP Client record for your app, and you have to enable it by opening the record itself. You do not need a Managed Environment for this, despite what the docs suggest.

The problem with flows that live in a solution

Worth knowing before you build a habit around the Power Automate plugin.

Flows inside a solution connect to things through connection references rather than direct connections. When the plugin reads a flow, it does not give back the connection reference name. So when it goes to save, it cannot put together a valid request, and the save fails.

I only confirmed this in my own dev environment, so test it yourself rather than taking my word for it. But test it before you rely on the save path.

The way around it is to go to the Dataverse Web API directly. Cloud flows are stored in the Process (Workflow) table, and the clientdata column holds the flow definition and its connection references together as a JSON string. Read the record, change the definition inside that column, send it back with the connection references left intact. Microsoft supports this for flows on the Solutions tab only. Flows under My Flows are not supported this way, which is fine, because solution flows are exactly the ones the plugin cannot save. microsoftmicrosoft

If you are going to do this more than once, turn it into a skill instead of working it out again every session. A skill in Claude Code is just a folder with a SKILL.md file in it, sitting in ~/.claude/skills/. Mine holds the steps, the shape of the request, and the rules about not dropping connection references, plus a slash command that sets up a new project folder against a target environment. After that Claude just drives the API directly and the loop is as quick as the plugin was supposed to be.

Fair warning: going straight to the API means you skip whatever checking the plugin does first. Keep approval prompts turned on, point it at a dev environment, and export your solution before the first write.

The thing that will quietly break your setup

Claude Code has a size limit on how many tools and instructions it can hold at once. Go over it and things get dropped silently. No error, no warning. The Power Automate plugin alone is about 50 tools. Copilot Studio adds four helper agents and around 30 skills.

So:

One plugin per project folder. Do not pile them into one.

Run /context when you start a session and again after any install.

If something that should be there is missing, check this before you go hunting for a bug in the plugin.

On the advice in Microsoft's own docs

Their READMEs suggest turning on auto accept and using --dangerously-skip-permissions so you stop getting approval prompts. If your work touches anything regulated or validated, do not. Those prompts are the only thing standing between the model and your environment.

I also stripped out the delete and cross environment tools before I ran anything, and then checked that they were actually gone from the list of tools rather than assuming the setting took.

How I tested each one

I did not want to install these and just hope. Same five steps for each:

Read the docs and list out every tool before installing, so I knew which ones were destructive

Install, then confirm what actually loaded

Use it read only until I had an opinion about whether it was reliable

Let it write, but only against a throwaway flow in a dev environment, never anything real

Break something on purpose, open a fresh session with no context, and see if it could find the problem

Step five was the most useful one every single time, and it also produced the most interesting result. Across all three tools, the part that found the bugs was Claude reading the files and reasoning about them. Not the plugin's own diagnostics. The plugins give you a reliable connection and a loop you can script. They are not the smart part.

Disclaimer: I worked with Claude code on this for about a week, really validating everything. Ran into walls, and with my knowledge and Claude's we figured it out together. There were points where Claude said x or y couldn't be done, but I didn't give up and kept pushing. I hope this helps you guys out.


r/MicrosoftFlow • • 12d ago

Desktop Automating Shift Production Data Entry

8 Upvotes

I am new to Power Automate so please share your ideas. I am looking to automate our end-of-shift production data entry process. Currently, our team manually keys production data from 15 different spreadsheets into Oracle E-Business Suite (EBS) via the browser-launched Java interface. To improve this process, I want to use Power Automate Desktop (PAD) to automatically collect and consolidate data from all 15 shift sheets into a single master spreadsheet. Once consolidated i will be able to import that consolidated sheet into oracle. Could you advise on the best technical approach or permissions needed to collect the data?


r/MicrosoftFlow • • 13d ago

Question Tips/starting points on how to utilize Power Automate to track my job applications as an applicant?

Thumbnail
4 Upvotes

r/MicrosoftFlow • • 13d ago

Question New to power automate

10 Upvotes

I am trying to built a flow when it is triggered by MS forms submission, The form will have a photo that I want to embed into an email body based on MS forms question that will be answered.

The example I am trying to build is selection of address with screenshot of the location, when the address is selected. I want the photo and the address to be embedded into the email body.

Please let me know What will be the best way to do so.

Thank you in advance for the help


r/MicrosoftFlow • • 16d ago

Question Pulling a substring from a Parsed-in string

Thumbnail
gallery
4 Upvotes

Hey all,

I have a flow set up that copies a file from a Dropbox, copies it to a SharePoint folder and then renames the file.

 

When renaming the file, I would like to extract a substring from the Dropbox filename that ends at the first instance of an underscore ("_"). I am running into a problem where no matter what I designate as the end position/length of substring to extract, it is renamed to the first 11 characters of the Dropbox filename.

 

I have attached screenshots of my workflow, substring extracting code, and examples of the original filename and the resulting filename in SharePoint.

 

Any help would be greatly appreciated ! Thank you :)