DEV Community

Cover image for The Art of Over Engineering on the Power Platform
david wyatt
david wyatt Subscriber

Posted on

56 5 4 3 3

The Art of Over Engineering on the Power Platform

I've started to notice a pattern, and it goes like this:

  • Someone finds Power Automate or Power Apps
  • They build something amazing
  • They want to use their awesome new skills
  • They find a problem and make it a Power Automate or Power App problem

And there is definite logic to this, if you know how to build a flow why would you learn/out source a Dell Boomi just because it scores higher on the requirements. You have to work with the tools you have, but here's the thing, you have a lot more tools.

And here's the thing, the development is just a small part of the lifecycle of the app/flow. What about:

  • Deployments
  • Bug Fixes
  • New Features
  • Support
  • Scalability
  • Stability

So when thinking of the right tool you really need to think about the whole package and look for the simplest solution, not necessarily the most exciting:

If you have two competing ideas to explain the same phenomenon, you should prefer the simpler one
Occam’s Razor / Principle of Parsimony

So lets look at other cool tools you should be considering first.

Data Gathering

I see this probably the most, someone wants to gather information, the spin up a Power App that gets the data and saves it to SharePoint. The key strengths and USP of Power Apps is 2 way data connections (Not just create but modify and delete), complex dynamic inputs (questions related to previous values or logged in user) and rich connectivity (cameras, gps, etc). So in our case there simpler alternatives:

A Simple SharePoint Form

That's right just use the built in functionality of SharePoint, that removes all the complexity. With the recent updates it has nice UI and can gather any type of data.

sharepoint form

Microsoft Forms

If you need branching logic or want it pre-populated good old MS Forms has you covered.

Canvas App SharePoint Form

You can have 80% of the functionality but with 90% less complexity. It has all the requirements and only loses out from a UI side, as without some bodging it is designed as a side panel.

Data Notifications

Using SharePoint to store data is now almost as ubiquitous as Excel now, and with Data storage we want alerts when the data is modified. The go to for most is Power Automate, but out of the box SharePoint has something called rules. They allow you to trigger by action (create/update/delete) and by conditions on the row.

sharepoint rules

Data Visualisation

Power Apps is not a data visualisation tool. It has some basic charts and can imbed Power BI tiles, but it is not visualisation tool. Guess what is, Power BI, and its dam good at it and relatively easy to learn. Yes Power Apps can show complimentary charts etc as part of the app, but that should be an additional benefit, not the key purpose of the app.

And then there is the elephant in the room, the one we love to hate, Excel. No matter what you say, Excel is a powerful visualisation tool, add in Power Query and Office Scripts and it can do nearly everything you need.

excel dashboard

Project Management/Ticketing

If you want an all singing and dancing project management system then Power Apps is a good solution, but do you need an all singing and dancing system? Planner covers most of your basic needs, and with a little Power Automate integration it covers even more. Additionally we now have Loop in the equation that has potential to manage tasks and projects.

planner

Mailbox Automation

Long before Power Automate was even just Flow there was Outlook rules. There is some powerful functionality built right into Outlook, this removes all of that complexity around working over 2 systems and life cycle management.

Some examples where rules should rule (😎)

  • Moving Emails by condition
  • Deleting Emails by condition
  • Forwarding/replying by condition

outlook rules

And this is just the begining, Micrsoft love to launch new products, and it loves to canabalise its own tools, so expect more overlap, as example Im excited for Copilot actions which will be another solution to data gathering / notifications / Mailbox Automations / etc.

copilot actions


Having a robust Intake process to help establish 'the right tool for the right job', good training/documentation, is key to ensuring your organisation doesnt end up being wasteful just when its focusing on efficiency.

Image of AssemblyAI tool

Transforming Interviews into Publishable Stories with AssemblyAI

Insightview is a modern web application that streamlines the interview workflow for journalists. By leveraging AssemblyAI's LeMUR and Universal-2 technology, it transforms raw interview recordings into structured, actionable content, dramatically reducing the time from recording to publication.

Key Features:
🎥 Audio/video file upload with real-time preview
🗣️ Advanced transcription with speaker identification
⭐ Automatic highlight extraction of key moments
✍️ AI-powered article draft generation
📤 Export interview's subtitles in VTT format

Read full post

Top comments (10)

Collapse
 
timexpeachtree profile image
Timex Peachtree

Yeah have seen lot of apps built with power apps and it would have been lot cheaper to deploy based on number of users/per month if they had just made it in Microsoft Forms or made it using some basic internal CRUD app.

Collapse
 
balagmadhu profile image
Bala Madhusoodhanan

Keep it simple !!

Collapse
 
jean_pauldosher_ecc6e833 profile image
Jean Paul Dosher

All valid! It depends on the complexity, and sometimes you need to keep the user within a unique application (like Power Apps). Again, my vote is for simplicity, but, again, it depends

Collapse
 
wyattdave profile image
david wyatt

Good call out, there are definitely times for apps (like plans for future features too)

Collapse
 
jean_pauldosher_ecc6e833 profile image
Jean Paul Dosher

Lol.. and sometimes this brings another discussion; people think Power Apps could be a CRM -well, I've already seen it, but it's caothic 😨

Thread Thread
 
wyattdave profile image
david wyatt

It's technically built on a CRM tool (dynamics), but I can imagine the chaos you have seen, why would you reinvent the wheel

Collapse
 
sumit profile image
Sumit Singh • Edited

Very well said and with good examples. I seen people using unnecessary flow and Apps where even it's not needed. Just want to quote and example, in order to drop an email from your PowerApp, you no need to create a separate flow and then send and email, you can directly use Outlook Connector in PowerApp to do so

Collapse
 
wyattdave profile image
david wyatt

Great call out, I mentioned it in a previous blog too. App connections should be the default, not flow like I often see too.
dev.to/wyattdave/power-apps-client...

Collapse
 
Sloan, the sloth mascot
Comment deleted
Collapse
 
wyattdave profile image
david wyatt

Apologies this article was never meant to attack anyone, it's to help share that there are other tools that could make your life easy and should be considered.

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay