Welcome to the first blog of this series, in the coming weeks we will get closer to an app that makes it possible to navigate, add, change, delete items in a SharePoint list and make the content in this list more appealing .
But it starts small with creating an empty Power App and linking the correct SharePoint list to this Power App and using that list as a database and visualize this content in a gallery.
In upcoming blogs I will show you the functions I utilize the most when building a Power App. I’ll do that by building an app that will make our company’s SharePoint content more appealing.
The first step is to create a blank canvas by going to https://make.powerapps.com. We give the app a name and click on Create to open a blank canvas in the PowerApps studio.
To work with data in this app, we use a SharePoint list as our database. When it comes to a database, several options are available for Power Apps. For example, you could use SQL or Dataverse as a database. To follow the example in this blog, you’ll need to create a SharePoint list in your site collection that has to look like the example below.
In blank canvas we add a gallery (insert -> Gallery -> Choose a suitable layout) and we call it “gal_People”.
To add the correct database to this gallery, we follow the following steps: View -> data sources -> add data -> Drop down select SharePoint. You get a list of you sharepoint sites. Select the list you want to use as your database, for this example this is my database.
Go to the gallery you just added and select the Items property. Add the database there as the Items to show.
After we connected the database, we want to show the data. We can do this by adding label and define what property we want to show in this app. So add a label, and set the Text property to: ThisItem.GivenName. With this formula you navigate through the object. You want to show somehting in this property(ThisItem) and you want to show the Given name. After the given name you can add two more labels with ThisItem.SurName and ThisItem.City.
In my example this is the result:
E voila, here ends this and my first blog about creating a Power App and the commonly used features that come with it.
I hope that you liked it and that you can use it for your own app ideas. If you have any questions or suggestions, feel free to leave them in the comments. I will answer them as I can. I am looking forward to your feedback and suggestions.