In this article I’m going to answer the question Best Microsoft Power Apps workflows practices. Power apps is a really exciting technology that allows people. Who don’t write code to create business applications as a little more to it than that so stick with me.

I’ll take you through it it’s actually three completely different things that you can do with power apps. One of these gets a lot of attention! if you’re looking at stuff around on the web power apps. You’ll probably find that one which is canvas apps.

But you can also create what are called model driven apps. Which is the ability to create a data model of full web based business application. You can also create a partial to reach out to your customers and allow them to interact with your data.

Microsoft Power Platform

Power apps is actually grammatically correct even though it sounds like. It might not be power apps is one of the parts of Microsoft’s power platform alongside. Power BI power automate and power virtual agents. This suite of tools allows citizen developers people who don’t write code who aren’t traditional developers. To solve their own business problems by building applications.

Best Microsoft Power Apps workflows practices

We use the word applications in the broadest sense of the word because all of these pieces work together. But let’s focus here on this purple partial the power apps part and what you can do with that. So the idea is that you are someone who perhaps you know users Excel a lot to solve business problems.

You might be familiar with formulas and logic and things like that! and this allows you to create your own application using no code. In another word, you can write formulas and expressions and use logic and drag and drop points! and click interface to create your own business application.

Applications Of power Apps

The first thing that’s really important to remember! When you’re looking at power apps. It is a business applications platform. He can’t use this to create a consumer app put it on that App store and sell It or give.

It away to your customers or whatever it is first and foremost it’s a business applications tool set. You are using it to create things for your organization for your business or your own personal kind of use. That’s all good too but you need to be licensed.

You need to remember is that every user! who uses this needs to be licensed either through their Office 365 license. Or with the power apps premium license depending on what you’re doing. So if you’re watching this thinking this is an application building toolset! that you can use to make the next great game and put it on the App Store stop.

Canvas Apps

Canvas apps allows you to start with a blank canvas! So this is like a hybrid of PowerPoint and Excel. Basically you can drag and drop pieces onto the blank canvas you can design this down to the last pixel. It’s a pixel perfect design you can move the pieces around designed the colors all of those things. Microsoft Power Apps workflows practices.

What is Components

You actually building out your app with different screens and different design elements called components. Then with formulas that determine the behavior of what’s going on there and it’s not exactly the same as Excel.

Best Microsoft Power Apps workflows practices

 Microsoft Power Apps workflows practices. If you are good with Excel formulas certainly that gives you a good starting point. But you know we’ll Start learning somewhere you don’t have to come from that place. But that’s about the level of technical knowledge that’s needed to be able to succeed with this.

The canvas app and choose your own data source you can choose from any one of the top tubes out 400 different connectors now. So you are building a canvas app referencing data on anything from an enterprise database system! SharePoint list all sorts of different options there. That you can get started with and you can also use this with dynamics 365. If you’re using that as your CRM or with the Microsoft database which I will show you.

Model Driven Apps

Model-driven apps are the other kind of power apps! There’s a third one too but this is the other one that didn’t get quiet! as much love and the idea here It’s called a model-driven app. It allows you to build a data model with the canvas app. You start with a blank canvas with a model-driven app.

We start with a data model this is a relational data model! you have to think about what kinds of data do I need to collect! How do they relate to each other? What are the different tables in my data? What are the different columns that I want to have on my table?

So on and then Table! So on and then how do those tables relate to each other? Think of a model-driven app as something that compares! a table to a CRM system or any kind of database system. That you would purchase for your organization.

But the beauty of the model driven app is that you’re not buying an off the shelf prebuilt application. That somebody else is designed that doesn’t quite work for you. You know if you’re working in sales environment or customer service environment! And so on there are awesome kind of CRM systems out there! for that but say you work in healthcare or hairdressing or office supplies or office management bookings sporting whatever.

It is but you don’t necessarily need an opportunity pipeline or our customer service case management system. You really just want to be able to say well here is my particular data. That I have for my business and the process is that.

I wanted to define my business model-driven app that allows you to do that. And what you’ve got here is again code this is a drag and drop interface. That allows you to construct your tables construct all of the columns on those tables! and the relationships between them and then.

The front end user interface of that is already ready to go for! You in terms of a responsive accessible performance interface. Then what you do is you build out what are called forms! and views that allow you to see and interact with your data in certain ways.

Best Microsoft Power Apps workflows practices

So you defining where things go on the screen and unlike hand this apps! which is a pixel perfect kind of design. Where you start with a blank canvas here because you started with your blank model. You are designing that front end user interface in User interface in a component driven kind of way. How many columns do! I want on the screen which parts of my data do. I want to see where on the screen! and you can drag and drop those things there to create that experience.

Canvas Apps embedded in Model Driven Apps

Now These two things can come together you can actually bring a canvas app into a model driven app. So where a canvas app is typically a mobile app. You could also think of it as a widget like this for a model driven app.

So in this case what I’m showing you is a model driven app! that has a canvas app embedded in it. Now remember our canvas app can reach out to and connect to anyone of like 400 different data sources.


Here is a canvas app that is connected to Twitter. Now I can see contextual E on my record inside my model driven app. I’m having a look at a person! I want to see their Twitter feed for instance it’s able to dynamically draw that in.

So you can use canvas apps inside your model driven app. In this way to bring in other types of data! you can use it just to jazz up the user interface! a little bit because remember you canvas app pixel perfect design.

Power Apps Portals

You can also create portals a partial is! what you would use where you want to be able to have customers interacting with that data. Where you want customers to be able to log in and raise a ticket! or get the status of a request or something like that.

This has to be built on the Microsoft database so Microsoft out of this is where we built that Dawson model for a model driven apps are these two things go together. You can’t use the portal functionality on SharePoint.

You can’t use the portal functionality on kind of other external database systems. The idea here is that you’ve built out that data model as we saw previously in the model driven app. Then you are surfacing parts of that with the appropriate security and permissions to your customers or your members or your clients or whatever the use case is for those people to be able to log in read get updates submit information.

So on should also mention with a model driven app that interface the user interface we saw before again only can be used with what you’ve built with your data model on Microsoft data verse Microsoft out of US used to be called the common data service.

So if you see that around there was a name change that happened to November 2020 same thing there so there you go the three things you can do in answer to what is power apps is a low code. application development system people who are not traditional developers you can use it to build mobile applications connected to any data source you can use it to build out a full data model and an enterprise-scale database with a responsive accessible user interface over the top and you can also use it to build a portal to access that data as well.

Click here! to know more about Best Microsoft Power Apps workflows practices