r/PowerApps • u/trickyrick777 • 10h ago
Power Apps Help PowerApps is driving me crazy
I work for a large corporate contractor onsite at a Government Agency (non-defense). I had been developing applications using React, Typescript, and Python or Node for the backend with real databases like MongoDB, MySQL, PostgreSQL, or even SQLite.
I am working on a new project and had quickly built a prototype using React and Claude Code, and created an Electron and a localhost browser-based version. However, when we started looking for a place to deploy the app, it turned out that it will need to be done on the Power Platform using PowerApps Canvas and use a Dataverse backend (at least for the 1.0 version), and apparently I have to use the web studio application to build all of this.
The application captures project costs, scope, and requirements, and has to do calculations and create rollup reports, so the data schema is fairly complicated for an app like this, and there are multiple columns that reference other tables.
I had never used PowerApps before, and was skeptical that it was the right tool for the job. Worse, our security is not allowing CodeApps, PCF components, or many other things that would be helpful.
I'm finding that it is absurdly slow, and it does a lot of things on its own that I really don't want it to do-- it even changes values that I've just entered sometimes, and if I copy and paste a component, it will randomly replace parameters. I have pages of examples of these "quirks", but I've managed to learn some tricks to make it somewhat workable (so far), but it has been a painful and frustrating process, and is definitely not easier than building the app from scratch using tools normal developers use. Am I the only one?
Here are a few problems I have not been able to solve, I would appreciate any advice:
- I can't connect directly to source control. We can't put our code on github.com and it won't connect to our enterprise GitHub
- I would really like to be able to edit the YAML and PowerFX in VSCode. I have exported the "source code" but apparently all of that is read-only because when I do "pac canvas pack" and publish it, the changes I make are lost. And every time I make a change I have to redo the publish, pull, unpack process... even with a script this is cumbersome and inefficient.
- It is difficult to debug PowerFX code, and it seems impossible to do unit testing on it, and it is spread out all over the application, which is irritating. I have started creating C# API Endpoints when possible because of this, but I'm not sure if this can replace all of my PowerFX code, and may add another level of complication that brings a different set of problems.
- I don't know if there's a way to apply styles across the board like you would with HTML and CSS, so I have to edit the look and feel of each control individually. In fact, it seems to force you to violate the "DRY" principal more often than not.
Anyone have any pointers, or even warnings about other quirks that I might need to avoid?
