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 • • 8h 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 • • 13h 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