I’m an experienced application developer trying to create a business application with the PowerApps platform (Dataverse, Model Driven and Canvas App), which is new to me. A lot of time is lost in research (and trying out) where best to write the application logic. Often it turnsout that I don't succeed with the standard business rules (for example I need information of the related table), calculations (very limited options and difficult to handle null values ) or roll-up calculations (very limited options and result must be shown immediately).
The application also contains things like filling a detail table based on the input in a master (in the same transaction). Due to the solution of making plug-ins for almost everything, the number of plug-ins is increasing rapidly and the overview is decreasing. Writing plug-ins including the necessary registration steps slows down the development process and is in my opinion more complex than writing code in a traditional development environment.
As the requirements become more complex with each iteration, I often think that the Powerapps platform was not the right choice for this system. However, on the other hand, I also wonder whether I'm using all the possibilities of the platform optimally and whether more is possible in a simpler way.
Do you have any tips for me to realize the more complex application code (and where to put the code)? Also I am curious whether more people will encounter limitations as the requirements become more complex.
Hopefully, with the help of your experience I can make a better decision about whether to advise to continue using the Powerapps Platform for this application or not.
