r/PowerAutomate

Creating solutions with Fable

Spent the day thinking and adding features to some of my business flows by handing solutions to fable and telling it what I wanted then importing solutions again.

The results have been amazing. I have incredibly good error handling and extra features like multiple attachment processing of pds, txt files and word docs and images that would have taken me hours to build in about 5 minutes.

Anyone else working like this? I'm grateful I've spent years learning because I know exactly what I want but man is so easy now.

reddit.com
u/prospectorJ — 1 day ago

Is something happening with Excel connections right now?

A flow that has been working for weeks has just failed due to “429 TooManyRequests, throttle.aad.aha.excel.flow” and nothing I do seems to fix it.
Has this happened to anyone before? Any clear fix?

reddit.com
u/deant_b01 — 3 days ago

Power Automate: Save email attachments directly to network share instead of SharePoint?

Hi everyone,

I have a completed flow for the following scenario:

  • A new email arrives in a shared mailbox.
  • Power Automate checks whether the email has attachments.
  • If attachments exist, save them automatically.

Currently, I'm saving the attachments to SharePoint, and this works fine because it's a standard Power Automate setup. However, we're starting to face limitations with SharePoint libraries due to the volume of files being stored.

My alternative goal right now is to save the attachments directly to:

  • A network/shared drive

The challenge is that these files need to be accessible by many users, so OneDrive is not a suitable option.

I've also tried using the File System connector with an On-Premises Data Gateway, but when I run the flow, I receive the following error:

>

Because of this, the File System approach appears to be blocked by company policy.

Has anyone faced a similar situation?

Are there any alternative solutions to automatically save email attachments from Power Automate to shared/network drive without using OneDrive and without violating DLP policies?

Any suggestions would be greatly appreciated.

Thanks in advance!

reddit.com
u/hellcryer — 3 days ago

Webhook: 202 Accepted 😩

My dudes on the PowerAutomate team.

Can someone please mail an envelope of glitter to the dev and PM who decided that every webhook that hits PowerAutomate gets a 202?

Thanks.

Edit: The 202 is generated by the trigger endpoint, not by my flow. My complaint is that the endpoint acknowledges receipt even when the trigger never instantiates a flow run. If the trigger dies before a run exists, I have no way to detect or debug it.

reddit.com
u/MonkeyDDataHQ — 4 days ago

On-premises data gateway

Hello,

I trying to setup power automate flow, that takes CSV from SharePoint folder and backup on my hard drive.

It recognizes when a file is created and get file content, but last step create file inside hard drive folder doesn't work.

Please share your ideas how to fix it.

Thanks

Stan

reddit.com
u/slavasp — 3 days ago

Trying to automate downloading of email attachments and saving to Sharepoint

Please forgive me if I used the wrong terms. New to power automate.
I have been asked if I can create a flow that captures emails with attachments and save them to specific folders based on the sender.
I tried to create it based on a switch connector but I have around 2000 different email addresses
I also tried to use the switch connector to first separate them into first letter, then further separate using the function below but this wasn't successful

startsWith(triggerOutputs()?['body/from'], 'a')

This is the error message

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The template action 'From' at line '1' and column '4564' is not valid: the value '@startsWith(triggerOutputs()?['body/from'], 'a')' specified for 'case' property in switch case 'A' contains expressions that are not supported. Only a literal of type string or interger or a '@parameters()' expression can be specified for the 'case' property.'.'.

I have exhausted my basic training and I don't know how to search for the correct method, but is there a way I can essentially do a Vlookup to match email address with the specific folders?

Thank you in advance

reddit.com
u/Pooka_S — 4 days ago

Power automate desktop (record using capture mode)

So first of all, I am new to power automate.

What i want: daily logging to a web and extract csv files then send it to a folder+ rename it and connect this to power bi.

What I did: since my company is blocking a lot of things, I was limited to use the capture mode and use clicks to do the whole flow. I finished a part and my flow now is doing everything I want (except the power bi part, it is easy so no problem)

My question: Am I wasting my time?. Is there another way which is way easier and more efficient?.Although this is my second time with power automate desktop, i am proud of my self but it feels messy and not reliable ( i have around 110 action and i still have 3 other topic to cover). It is hard to fix small problems since it relies on pictures clicks and it doesn’t feel fully automated since i need to trigger it and i need to have my laptop working.

My post is long but I really wanted to express my concerns and know your answers, specially from the people who use this type of recorder.

reddit.com
u/MAS_S_ — 4 days ago
▲ 2 r/PowerAutomate+2 crossposts

If you could build one tool for Microsoft 365 admins, what would it be?

Hi everyone,

My manager has asked me to explore new project ideas around Microsoft 365 that we can potentially pitch to clients. The goal is to build solutions that make day-to-day administration easier, automate repetitive tasks, improve security, or simplify the use of any M365 service.

I'm looking for ideas such as:

  • Pain points you face as an M365 admin
  • Tasks you wish were automated
  • Missing tools or dashboards in Microsoft 365
  • Security, governance, compliance, or productivity problems that need better solutions
  • Projects you've built or wish someone would build

Some examples I'm already considering:

  • Automated employee onboarding/offboarding
  • License optimization and cost-saving dashboard
  • Teams and SharePoint governance automation
  • Sentinel incident response automation
  • Executive M365 health and security dashboard

I'd love to hear your experiences and ideas. If there's something in Microsoft 365 that makes you think, "I wish this existed," please share it in the comments!

Thanks in advance.

reddit.com
u/CypherText-325 — 6 days ago
▲ 4 r/PowerAutomate+1 crossposts

Published Power App dropping fields when passing SharePoint data to Flow

Hi everyone,

I'm facing a strange bug where my published Power App behaves differently than it does in the edit mode (Power Apps Studio).

The Setup:

I have a canvas app that passes data from a SharePoint list to a Power Automate flow. The flow processes this data, generates a CSV file, and returns a download link back to the app.

The Problem:

In Edit Mode (Studio): Everything works flawlessly. The flow receives all fields from the list, and the generated CSV is complete.

In the Published Version: The app fails to send specific fields. As a result, the final CSV comes up with missing data.

What I've checked so far:

I confirmed this behavior by inspecting the Power Automate run logs. Looking closely at the trigger payload (the raw data package sent from the app to the flow), I can see that the fields are missing right at the start of the execution—but only when the request originates from the published version of the app.

Has anyone encountered this issue where the published version drops fields that the Studio version handles correctly? Any ideas on how to fix this?

Thanks in advance!

reddit.com
u/KoalaSamuraiTuga — 6 days ago
▲ 11 r/PowerAutomate+2 crossposts

Automating generation of KB articles in SharePoint based on Teams transcripts (via Copilot / Power Automate?)

Hi folks👋

I’m working on a small project and trying to automate a workflow that’s currently very manual.

During some Teams calls, I enable transcription so I can go back and look at what knowledge has been shared / discussed.
Once the meeting ends, I go into the chat, open the recap, download the transcript (Word), then upload it into Copilot to generate a structured knowledge base article based on a template.

After that, I download the generated document and upload it to SharePoint.

It works, but it’s a lot of manual steps for something that feels like it could be automated..

What I’d like instead is something like this:

meeting ends
transcript is automatically retrieved
processed into a clean, structured KB article (with consistent formatting)
saved directly to SharePoint (Word format)

Basically : turning conversations into documentation automatically, with no / a minimum of manual steps.

I’ve started experimenting with Copilot Studio and Power Automate, but I’m struggling with the automation part and how to connect everything properly.

I assume this would involve Teams transcripts, OneDrive/SharePoint, Power Automate, and some kind of LLM/Copilot - but I change keyboards and passwords for a living, I’m not sure what the cleanest architecture looks like, or even what’s actually feasible...

Has anyone built something similar, or found a good way to automate this?

If you guys have any tips for me or expertise on the topic, I'm really all ears...

Thanks !!

reddit.com
u/passwordresetguy — 6 days ago

Making a form emailed

Hello,

I am new to Power automate and would appreciate any tips.

I am trying to make it so when a new response is submitted to our Microsoft forms the contents (all of them**) are then set to a set email.

I have all the steps ready and the emails are sending but they are blank but I can’t figure out what I should include in the body of the email action. If I put response ID I get nothing sent. Do I have to one by one click each question? Also I did that and the email sent will all info in one like (allinfoinoneline)

reddit.com
u/Flat-Alternative-492 — 6 days ago

PA flow: trigger by MS Form response, write into specific Excel table

Hi,

in our researches, we collect agreements with terms and conditions, among other detials from our participants via MS Forms. We have multiple researches running in parallel and each requires a different From -> therefore there is a big number of underlying tables. I would like to aggregate all the responses that "agree" into a single table, so we dont have to access all the underlying tables.

To my understanding, the underlying table has to be opened in order to contain all the responses. So Im asking if there is a way to walk arount this.
I have thought about using the Forms trigger + webhook, but those are a Premium feature of PA (uncool).

reddit.com
u/mountain_chicken1 — 7 days ago

New User - Help with Initial Flow

Hi!

TL;DR: As the title says, I'm brand new to Power Automate and I'm looking for a little guidance to help me create this first flow. PA is asking for certain information that I just don't understand, specifically what the "key value" means, and my Googling hasn't provided any clarity. If anyone could help to clarify, or even just point me in the direction of a reliable learning resource for newbies, I'd be so grateful. I'll describe the gist of the flow below.

I am attempting to create a flow that sends a weekly email to each of my students with a summary of that student's progress (in this particular case, it's demerits).

I have an Excel file with 2 separate tables on the same sheet. One table has each student listed, and if they've earned demerits, those are listed with dates, descriptions, number of demerits, and a link to the student handbook (which is on another sheet in the same Excel file). If a student earns demerits in more than one instance, the table gets a new row added each time, meaning a particular student may have a few individual rows pertaining to them.

The second table is a simplified running tally of each student's demerits, so each student is only listed once regardless of how many times their name is on the first table.

I would like PA to send a weekly email to each student with a summary of their demerits, and I've been playing with a flow that would simply show them their running total each week (but I haven't been able to get it to work). Preferably, I'd love it if PA could create a kind of summary sheet that shows each student's individual offenses as well as their running total. I'm wondering if that's something I need to do in Excel instead, and then reference the individual student's table for the weekly email in PA. Regardless, I'd run into the same issue with terms specific to Power Automate that I just don't understand.

Thanks so much for your time!

reddit.com
u/liebteimmer — 7 days ago
▲ 2 r/PowerAutomate+1 crossposts

Email Attachment (clad) to OneDrive - what am I missing?

Title should be Email Attachement (xlsx)*

I receive an email every day with an excel file. The file name includes a timestamp of the report. I need to save this file to OneDrive and change the name so the file is overwritten every day. I have tried a few times but either 1. the file in OneDrive is not an excel but an empty document or 2. the file is not able to be opened from OneDrive. What step did I skip?

reddit.com
u/GassiusKlay — 11 days ago

Confusion with file types

Hi all, weird issue.

When i let power automate create a file in sharepoint, i fill in the filename and manually enter ".pdf" when i want a pdf. This is how it was taught to me. However now the file in sharepoint contains twice .pdf.pdf.

I dont get where the 2nd one comes from? What can i do to prevent this? Is this something SharePoint does, or does power automate do it. Because imas i understand, if i dont put .pdf after the filename, power automate does not know which file type to use right?

reddit.com
u/PippinTheShort — 10 days ago

Possible to draw data from a table to a form?

I'm trying to create a replica of our Joiners, Movers, leavers process but for our projects team to create a 'master list' of projects.

The project Manager field often needs to change. I wanted to create a MS Form for this.

Is it possible to somehow use a form to edit that particular field?
Same for offboarding i suppose, is it possible to link a form to the line in the table so that it can be changed to 'inactive'?

I have managed to do the onboarding by creating a GUID and using 'pre-filled' form links. But this is all automated, i cannot figure out if this is possible on a user started action

reddit.com
u/FineAd6098 — 12 days ago

Has anyone successfully jail broken PA?

I want to make a REST call to a third party api without having to upgrade to premium. I’m sure M$ hasn’t done enough to seal off its walled garden.

reddit.com
u/V3X390 — 11 days ago

Best way to collect all Response Comments in a sequential approval with multiple approvers?

Need some assistance with this. My flow has a sequential approvers list with 7 approvers and an "Update Item" between each approver to update the Status.

I'd like to collect each comment and display each collective comment to the next approval. So Approver 2 will get Approver 1's comment. Approver 3 with get both Approver 1 and 2's comment. Approver 4 will get Approver 1,2 and 3's comments and so on and so forth.

Of course, applying a Response Comment in the approval cause a For Each loop, which causes issues with fetching comments from outside the loop.

Can someone let me know how I could get around this? I'm sort of a noob at Power Automate so if you could please add details to your instructions, that would be amazing.

Thank you!

reddit.com
u/achenx75 — 10 days ago

Power Automate Approvals

Boa tarde!

Estou criando um modelo de Requisição de Compras para facilitar o meu trabalho. O fluxo está funcionando, porém, no momento do envio da requisição para o gestor, os itens não aparecem no e-mail.

A solução está sendo desenvolvida utilizando Forms, SharePoint e Power Automate, com duas listas no SharePoint: uma para o cabeçalho da requisição e outra para os itens, já que o formulário permite o preenchimento de até três itens.

Alguém poderia me ajudar, por gentileza? Sou totalmente leiga nesse processo e estou utilizando o Copilot como apoio na criação.

reddit.com
u/Constant-Cricket1985 — 13 days ago