Master 365: Getting Started with Power Apps (Premium)

Power Apps is Microsoft’s “low-code/no-code” platform, but I had incorrectly assumed that it was more “low-code” than “no-code.” But based on my first experiences using this platform, I can already see that it’s possible to build sophisticated apps with literally no code. And that is blowing my mind.

Note: Power Apps requires a Microsoft 365 commercial or education account.

As a bit of background, I wrote about my early experience using Xamarin.Forms to create a simple cocktails app about a month ago. This seemed like a logical enough next step given my previous experience using Windows Forms, Windows Presentation Foundation (WPF), and then the Universal Windows Platform (UWP) to create different versions of .NETpad, my Notepad clone. But Xamarin.Forms is not ideal, to put it mildly, and its successor, called .NET MAUI, is still 18 months from a public release. So I’ve been looking at alternatives.

Flutter is one obvious choice, and I’ve been taking a free online class to learn this environment, and am excited by its power and versatility. A web app is another approach, and I’ve been investigating which framework(s) might make the most sense; possibly React, Electron, or React Native.

But in preparation for the final episode of the Microsoft 365 Knowledge Series, a podcast series I’ve been recording with Stephen Rose since January, I decided it would be fun to try and recreate my cocktails app---which I’d not completed in any meaningful way yet---using Power Apps. And I am blown away by how easy it was. In fact, I immediately blew by the functionality I had previously created using Xamarin.Forms and hundreds and hundreds of lines of code. The Power Apps version is literally no-code.

Here’s how it went.

The first step was to create some kind of a data source in which I would store the cocktails, each of which has a name, a description, a set of ingredients, and series of steps, and a photo. Power Apps supports all kinds of data sources, from an Excel spreadsheet to a SQL Server database, but one data source, in particular, stood out to me: A SharePoint list. In creating the cocktails app on mobile, I always intended to eventually use some kind of database, but I was using a simple C# list for the early versions. So a SharePoint list seemed like the logical choice.

To make the list, I signed-in to the Microsoft 365 portal with my Microsoft 365 Business Standard account and chose Sharepoint from the app launcher. In SharePoint Online, I created a new site called Cocktails. Then, I create a new list, which I imaginatively named Cocktails list.

Then, I populated the list with my five starter cocktails so I’d have some data to work from.

You can actually kick off a new Power App right from the SharePoint list: There’s a Power Apps menu with a Create an app menu item right there. But the more typical way to do this is from the Power Apps website so I headed over there instead. Here, I...