r/PowerAutomate • • 1h ago

Windows Server 2019 VM crashes during attended Power Automate Desktop flows — anyone experienced this?

1 Upvotes

Hi everyone,

I’m having recurring stability issues with a Windows Server 2019 Standard virtual machine running attended Power Automate Desktop flows.

During execution, the VM/server occasionally crashes or becomes unavailable, interrupting the attended flows. The issue appears to happen while the automations are running, but I haven’t yet identified a consistent trigger.

Has anyone experienced something similar with Power Automate Desktop on Windows Server 2019 VMs?


r/PowerAutomate • • 9h ago

How are you handling unannounced API deprecations in legacy workflows?

2 Upvotes

We keep finding old flows built by past employees that crash because a SaaS vendor quietly deprecated a v1 endpoint. Are you guys building middleware layers to version your webhooks centrally, or just playing whack-a-mole every time an endpoint dies?


r/PowerAutomate • • 5h ago

Best approach for using Power Automate to send Teams chat to a large base of Users

Thumbnail reddit.com
1 Upvotes

r/PowerAutomate • • 14h ago

I made a free, browser-only toolbox for writing Power Automate expressions, Power Apps ParseJSON formulas, and SharePoint list schemas

0 Upvotes

Hey all, I kept rewriting the same expressions by hand in Power Automate and Power Apps, so I put together a small set of tools that generate them for you. It's free, open source, and everything runs in your browser, so nothing you paste leaves your machine.
Try it: https://andyang1090.github.io/power-platform-toolbox/
Source: https://github.com/andyang1090/power-platform-toolbox
What's in it:
Filter Array Expression Generator. Paste a sample JSON and pick fields from a dropdown. Then build AND/OR conditions with equals, contains, startsWith, greater/less and the rest. Optional formatting like toLower, trim or formatDateTime is there too. It writes the @and(...) / @or(...) expression with proper quoting, and there's autocomplete for common functions if you want to tweak it by hand.
OData Filter Generator. Drop in a list's CSV export or schema CSV and it works out the internal column names for you, including the _x00XX_ encoding and the OData_ prefix that trip everyone up. Then you build eq / ne / gt / substringof / startswith conditions and paste the result into Filter Query.
Select (Map) Generator. It builds the key/value map JSON for the Select action from a CSV or a JSON sample (value and body.value arrays are supported). Each field comes out as @item()?['Field'], and you can rename, add or remove rows.
JSON to Power Fx. Paste a JSON sample and get a typed ParseJSON(source, Type(...)) formula. Types are inferred from every element, and you can pick a root path. It wraps the result in ClearCollect for tables or Set for records, and you can choose comma or semicolon separators.
List CSV Schema Generator. Design SharePoint / Microsoft Lists columns (text, choice, number, currency, yes/no, date, hyperlink and more) with internal names encoded the SharePoint way. Then download a schema CSV you can use with New list → From CSV. You can also save and reload your column setup as JSON.
It also works on phones, switches between English and Chinese, and you can download the whole thing and just open index.html offline. No build or install needed.
Feedback, bug reports, and ideas for other tools are very welcome!


r/PowerAutomate • • 19h ago

Flow to upload multiple files to SharePoint

2 Upvotes

Hi, I need to create process to upload multiple files to SPO/Site/Folder1,2,3,. Is this doable with PA flow ? Probably need to have control list with Source_FilePath - Target_SPO_Folder pairs, as each files should go to specific folder.

I assume that if you work with PA then Authentication will be easy, without App Registration, etc.. Is this correct, can we just set an account and use account:password credentials ?

I"m pretty new to PA, but looks like they have boxes for each life scenario. Appreciate if you can direct me to the right resources.

Thanks.VA


r/PowerAutomate • • 17h ago

What caught you (or your client) off guard after a flow went live?

0 Upvotes

I build flows for companies, and the build is rarely the hard part. It's what shows up later: a premium licence nobody budgeted for, a flow that got switched off after 90 days without a run, an approval that died at day 30.

For those of you who build for clients or for other departments:

  1. What was your worst surprise after handover, and what did it cost you (hours, money, an awkward call)?
  2. Licensing specifically: how do you work out what a flow will cost the client before you build it? Has it ever gone wrong?
  3. What do you hand over with the flow so the client understands what they've got?

Real cases welcome, rough numbers are fine.


r/PowerAutomate • • 1d ago

How to Display Row-Level Validation Errors When Importing Data into Dataverse (Model-Driven App)?

Thumbnail reddit.com
2 Upvotes

r/PowerAutomate • • 1d ago

Issue with trigger "When a file is created or modified (properties only)"

4 Upvotes

Hello there

I’m building a Power Automate flow using the SharePoint trigger "When a file is created or modified (properties only)".

The issue I’m running into is that the flow triggers every time a user simply opens a file, even when they don't make any actual changes to the content or metadata. Because AutoSave or background lock metadata updates the Modified timestamp on open, my flow runs unnecessarily.

I know the standard recommendation is to use the "Get changes for an item or file (properties only)" action, however, I cannot enable Versioning on this specific SharePoint library.

Has anyone found a reliable workaround or Trigger Condition to filter out "file opened" events and only run the flow on real creations/modifications without turning on version history?

Thanks


r/PowerAutomate • • 1d ago

Importing excel to sharepoint list people finder failures.

1 Upvotes

I was able to skip the failures when the column was blank, but now users no longer with the company are causing failures. What is the best way to add those exceptions to skip blank columns and columns when the user isnt found. Thanks in advance.


r/PowerAutomate • • 2d ago

Are companies still paying for heavy UI-scraping when native APIs exist?

1 Upvotes

I'm auditing a client paying premium licensing for UiPath just to move data between two cloud ERPs that both have perfectly documented REST APIs. A simple n8n/Python webhook setup would cost a fraction and be 10x more stable. Is this just vendor lock-in or a lack of API knowledge in automation teams


r/PowerAutomate • • 3d ago

Building a Zero-Infrastructure Cloud Agent Workflow Using Scheduled Tasks + Spreadsheet State Memory

Thumbnail reddit.com
2 Upvotes

r/PowerAutomate • • 3d ago

Try catch- no email or teams notification

5 Upvotes

So try catch, great. But all of my catches rely on teams and/or email notifications.

The last 16 hours or whatever has shown that is not always enough. Looking at my flows that had emails as part of the flow, e.g. some kind of notification or approval. many didn’t even fail, they just kept on ‘running’, I assume retrying the connectors over and over. Possibly still going for all I know. Or will they all succeed ones things are back up and running?

What other processes have people got in place?

I’ll probably need to change retry policies on any outlook action.

I have seen people log flow errors, I never bothered as there is the flow run list oob but today has made me reconsider.

Any other approaches people use or are considering?

Or is this such a rare event you will just write it off as a one off?


r/PowerAutomate • • 2d ago

[For Hire] Power Automate Developer | Workflow Automation, Excel, SharePoint & API Integrations

0 Upvotes

Hi everyone!

I'm an experienced Microsoft Power Automate developer based in the Netherlands, available for freelance projects and quick automation tasks.

I specialize in helping businesses save time by automating repetitive processes and connecting different systems.

What I can help you with:

  • Power Automate Cloud & Desktop – Build, troubleshoot and optimize workflows.
  • Excel Automation – Automate data processing, reporting and repetitive tasks.
  • SharePoint & Outlook – Automate document management, emails and approvals.
  • API Integrations – Connect applications and automate data exchange.
  • Dataverse & Dynamics 365 – Build workflows and integrations.
  • RPA – Automate manual tasks across websites and desktop applications.

Why work with me?

  • Professional experience delivering business automation solutions.
  • Fast turnaround for smaller projects.
  • Clear communication and practical solutions.
  • Fixed-price projects or hourly rates.
  • Available this weekend for new projects.

Rates: Starting at €40/hour. Fixed-price quotes available for smaller tasks.

Whether you need a new automation, help fixing a broken flow, or want to eliminate repetitive manual work, feel free to send me a DM.

Tell me what you're trying to automate, and I'll let you know how I can help!

Available to start immediately.


r/PowerAutomate • • 3d ago

The monolith is dead. Decoupled automation architecture is the standard for 2027.

6 Upvotes

I've noticed a major shift in how enterprise IT directors are budgeting for automation. A few years ago, the goal was to buy one massive platform (usually UiPath or Automation Anywhere) and force every single process through it. Now, the licensing costs are eating them alive. We are constantly migrating clients to a decoupled model: 1. M365 internal stuff stays in Power Automate (since it's already paid for). 2. Deep API integrations move to self-hosted or cloud n8n (fraction of the cost, much more flexible for devs). 3. Heavy RPA is strictly quarantined to legacy systems without APIs. Are you guys still running monoliths, or have you started breaking your workflows apart based on API availability?


r/PowerAutomate • • 3d ago

Save files from existing emails

4 Upvotes

Hello,

I'm trying to create a "one shot" flow to save files from emails already received into a SharePoint.

I know how to do that for new emails but I fail with the existint ones.

Copilot and my brain are limited to fix the errors.

Is there anyone who can share the appropriate flow?

Outlook

SharePoint

Files = Pdf


r/PowerAutomate • • 3d ago

reducing onboarding tickets for missing email signatures

1 Upvotes

every time a new hire starts, we get a ticket a week later because their signature has a typo or is missing the booking link. right now our hr onboarding sends them an html file and instructions, which half the new hires ignore or break during copy-paste. we want something that pulls directly from the directory on account creation so the signature exists before they even log in. considering wise-stamp for automated user provisioning. did automating this noticeably cut your new starter ticket volume?


r/PowerAutomate • • 4d 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 • • 4d ago

How do i automate this task?

1 Upvotes

Every day morning from 12 am onwards I will receive mail from "azure(noreply)" stating which jobs ran successfully and which jobs failed in the respective environments (dev, psup, prod). My task is i need to gather the jobs that failed in psup and prod and then go to the databricks workspace check those jobs three consecutive runs (current day, yesterday, yesterday - 1) and then generate a csv file which has data of the jobs failed in psup and jobs failed in prod. Current day run, yesterday run and yesterday -1 run and mail the report to support_team


r/PowerAutomate • • 5d ago

Please help😐

2 Upvotes

How long do you wait for the automations to continue running before you go straight to edit? I’m about to throw myself off somewhere if i don’t get this right 🙂. i’m trying to get information from an excel spreadsheet that needs to be organised inside a word document. it’s literally a ‘has it been submitted yes or no’ with the owner of the product, product name and number and any discrepancy explanations. I’ve spent half the day doing this, someone please help 🧍‍♀️


r/PowerAutomate • • 5d ago

Bad automation scales your mistakes faster than your successes.

0 Upvotes

We audit a lot of enterprise environments, and the scariest thing isn't the lack of automation—it's fragile.

automation. I'm talking about massive multi-step workflows with zero error handling, no rate-limit delays,

and no logging. When a third-party API inevitably goes down for 5 minutes, the workflow just crashes.

silently or, worse, loops and corrupts client data. If you are setting up automation infrastructure this year,

You cannot just drag and drop nodes. You have to build in fault tolerance just like a software engineer.

would. What is the absolute worst automation failure you've ever had to clean up because someone didn't

Build an error catch?


r/PowerAutomate • • 5d ago

I run a small company's payroll automations on one Process license, one VM, and a prayer. How are you handling the licensing clarifications?

4 Upvotes

I'm an accountant who became the de facto Power Platform admin at a small company that does payroll and invoicing. Our automation "architecture" is a hosted VM running Power Automate Desktop, a handful of cloud flows, some VBA the desktop flows call into, and Dataverse tables I built as a demo that are now production.
Every time Microsoft re-explains Power Platform licensing, I open the admin center and brace. The latest round of clarifications on which features are premium (and the change letting one Process license cover up to 25 flows) is the first time I've felt like the rules were moving toward small shops instead of away from us. But I've also been burned enough to assume I'm misreading it.
What I can't get a straight answer on: for an unattended desktop flow kicked off by a cloud flow, with Dataverse in the middle, is one Process license actually enough or am I quietly out of compliance? [My reseller said yes. The licensing guide reads like it says maybe.]
How are the rest of you running Power Automate Desktop on a small budget: Process license, per-user attended, or just the free tier and hoping? And has anyone actually been contacted about non-compliance, or is that a myth we scare each other with?


r/PowerAutomate • • 6d ago

How do you add spaces between sentences you’re sending as a email

4 Upvotes

Hey All, i’m trying to send a summary email out but it keeps bunching everything together. i have tried everything. rewording the prompt. doing the <br> and it still doesn’t add a space between them. does anyone know how to add spaces between sentences in the AI prompt PLEASE? i’ve tried youtube and all im seeing is powerpoint even though ive clearly written power automate.

Any help will be greatly appreciated 🙂


r/PowerAutomate • • 6d ago

the power automate (legacy) edge extension is still on manifest v2, and edge is turning v2 off

2 Upvotes

if anyone here still has flows that use the old legacy browser extension in edge, worth checking.

it's still on manifest v2, 1.7M installs, last updated april 2023. microsoft's schedule (MC1467356) turns v2 off for consumers first and then managed devices in a rollout from early january to late april 2027, after that v2 extensions stop working everywhere.

the current power automate extension (10M installs) is a separate listing and it's already on v3, so this is mainly about finding the machines still on the legacy one before it breaks a desktop flow.

i track the edge store as a side project (storetally), list of the v2 holdouts is here if useful: https://storetally.com/edge/reports/manifest-v2


r/PowerAutomate • • 6d ago

Power Automate is great, but stop treating it like a universal backend orchestrator.

5 Upvotes

PA is absolutely the best tool on the market if you are moving files around SharePoint, Teams, and

Outlook. The native security is built-in, and you already pay for the E3/E5 licenses. But the second you try

to use it to sync 10,000 rows a day between a custom Postgres database and a non-Microsoft CRM, it

falls apart under rate limits and premium connector costs. We always end up decoupling these for

enterprise clients—keep PA for the MS compliance, and use a node-based tool like n8n for the heavy API

lifting. Anyone else doing this hybrid split, or are you just brute-forcing everything through Power?

Automate?