Skill Level Intermediate
- [Instructor] This month's SharePoint business app starts as a request from one of our users, asking if we could put together an IT services assets inventory. Jojo, this one's for you. It's also for all of us who want to be able to use organizational columns to represent and standardize our organizational data, all of us who want to be able to create custom apps using those organizational columns, and finally, this is a great app for anyone who wants to be able to quickly create a mobile app, using Microsoft Power Apps.
Operating under the assumption that this may not be the only asset inventory that would be useful in an organization, we're going to begin by creating site columns, columns that are reusable and that provide an easy way to create lists and to keep those lists consistent, which is really helpful when we want to automate or modify those lists. Using those site columns, we will create an asset inventory. This is a custom list created in SharePoint, just as we've created many other custom lists.
Both site columns and custom lists, of course, work in all of those versions of SharePoint. With our list in place we're going to add a couple of items. Make sure we like how it looks. And then, we are going to use Microsoft Power Apps, which is available in SharePoint Online and in some versions of SharePoint On-Premises to create a mobile application, so that when we're actually capturing inventory information in the field, we can do that on a mobile phone.
We'll start from SharePoint, by choosing to create an app. That will take us to Microsoft Power Apps, where we will build this app in so few keystrokes, it's amazing, because we're sending over the information from Microsoft SharePoint. The result is a custom app that we can run on a Windows phone, IOS, Android. It is connected directly to our SharePoint list, so that I can browse information, edit records, and even add new records to my list, or search and sort the records that are here already.
All this in 30 minutes or less. If you've wondered about how to make lists consistent, or wanted to know how to create an app from a custom SharePoint list, this month's SharePoint business app is for you.