What is PowerApps in SharePoint

What is PowerApps in SharePoint enabled applications? PowerApps is part of Office365 and work with SharePoint Online. If you have an Office365 account, you can access PowerApps via SharePoint or via the PowerApps interface.

This new technology will enable you to build applications that work across web and mobile. These applications can use a SharePoint list as the data source.

What is PowerApps in SharePoint Lists?

Create a SharePoint List first

To access PowerApps from SharePoint, you should create your list first. Decide on the field names and data types. Then create and save the list.

If you are planning on having dropdown boxes in your application then you can create a choice field in SharePoint to hold the values. A better way would be to create a separate list containing values for any dropdown box you intend to have.

SharePoint lists contain an attachment field type and this can be used to hold multiple attachments for a record.

Creating a PowerApps Application from SharePoint

Let’s look at SharePoint examples. There are a few ways of creating a mobile application, but one of the quickest is from the SharePoint list itself. When we think of what is PowerApps in SharePoint, we will be looking at hooking the two together. Keep in mind that it will create the bare bones of an app and you can then add in any extra functionality you need. You will see how a SharePoint online form gets created. What is created is good enough to get you going though.

The steps are as follows:

Open the SharePoint list.

At the menu above the list, select the PowerApps option followed by ‘Create an app’.

What is PowerApps in SharePoint

Give your app a name and click the ‘Create’ button.

Wait a few seconds while the app is built.

You will then see the interface with the app that it has created.

PowerApps in SharePoint

The app is fairly simple – it will allow you to

  • add data
  • edit data
  • save data
  • search
  • sort data
  • delete data

Any new records you create will be written back to the SharePoint list. This also applies to any record you update. Let PowerApps save data to SharePoint list data sources.

You can then share the app with others who have an Office365 account in your organisation.

Once you publish it, you and others who have access to it, will be able to view it on a phone or tablet. This should give you an idea now of what is PowerApps in SharePoint.

This is one way of creating forms. You can of course create custom SharePoint forms with PowerApps.

If you make changes to the structure of your SharePoint list, then you must refresh the list within the PowerApps application. Otherwise you will not have the correct list information and your app may not behave as expected.

Refreshing the list within PowerApps is easy. You can either refresh it from the data sources list…

Or by using the ‘Refresh’ command.

Refresh(data source name)

SharePoint List Permissions

Permissions will need to be set on the SharePoint list for users to be able to read and write data from PowerApps.

Users who don’t have at least Contribute access to the list are NOT going to be able to create or edit records in the list using PowerApps. The actions in PowerApps are controlled by the permissions on the list itself. So, the best that Visitors can do in PowerApps is View records.  They will not be able to edit them.

Users will need the equivalent of the members group if they are going to edit any content in the app.  They can only view content with just read permission.

In general, if you are using a list for a data source then all the users of the app are going to need to have at least Contribute or Edit permission, if they are going to create new records.  More permissions than that are not really going to do anything. Less permissions than that will only work for users to use an app that only views the records.

In PowerApps, the only permissions you set are to share the app and specify whether the other user will be able to edit the app or not. Those PowerApps permissions don’t actually have anything to do with the data source.

PowerApps Courses

PowerApps in SharePoint online tutorial courses will get you up to speed fast. PowerApps for newbies can take your learning to another level and give you a head start in this new technology.

What is PowerApps in SharePoint online is a combination of technologies that work really well together.

Also check: What can PowerApps do


Pin It on Pinterest

Welcome to PowerApps Support
Can we help you?