How to Create a User-friendly SharePoint View with PowerApps

How to Create a User-friendly SharePoint View with PowerApps 150 150 Sameer Mohammed

PowerApps is one of the innovative features of the Office 365 environment that allows users to create, connect and share business apps with their teams. Also, it uses minimal/no-code app building mechanisms for the adjacent Office 365 offerings like SharePoint, Dynamics, etc. With the help of PowerApps, you can access these applications, forms, or views on any device without even accessing the parent applications where the PowerApps app is embedded.

SharePoint provides an elegant integration with PowerApps. This connection can be used to create a mobile/tablet friendly view for SharePoint lists and libraries. But, many users often don’t understand how to create a user-friendly SharePoint View with PowerApps. So, here we will discuss how you can create a new SharePoint View using PowerApps.

For better understanding, let’s start with a simple list (Shown below) that contains a Title and City field (Type – Single Line of Text), for which we will create a new view “My PowerApps View.” Follow the below steps to learn:

1. Sign-in to SharePoint and go to SharePoint list. Now, click “PowerApps” in the top-bar and select “Create an App.”

2. The “Create an app” wizard will appear on the screen. Enter the name for the desired view and click “Create.” Here we have named it “My PowerApps view.”

3. On clicking Create, the PowerApps engine will start loading. It will take some time to load the engine as it builds all the connections from SharePoint and PowerApps. Once the process is complete, you’ll be able to see a default mobile view as shown below.

There are many options to customize the View for different UI/UX centric needs and business requirements. Now, let’s see how you can change the default view’s theme.

• Locate the “Home” tab on the top-left corner and click on “Theme,” and then select “Aqua.”
• You can refer to the below screenshot to understand it better. The theme will be changed instantaneously in design mode.

4. Now, we will change the layout of View to give it a more tile-like appearance. To do this, select the body of the app from the designer, and then select the Layout section from the right-hand Gallery window. From the drop-down, click “Title and Subtitle on Overlay.” It will refresh and update the screen with the selected layout as shown below:

5. Here we have added two different customizations in the app. Now, we will preview the app before publishing it to SharePoint. Click “Preview the app” button on the top-right corner or press F5.

Clicking the button will provide a real-time view of the app in a new wizard. You can still go back and make any changes to the app before publishing it.

6. To test the interaction and responsiveness of the app, click any item or search for any particular record. Here we will search for – Aditi.

As you can see, searching for any record hides other records. Now, we will show how to display this app as a view in SharePoint.

7. Go to the “File” tab and click “Save.”

After saving the settings, you’ll be prompted to the Publish screen. Click “Publish” to publish the view on SharePoint list.

8. Now, go to the original SharePoint list and select “My PowerApps View” from the PowerApps view.

9. Selecting the “My PowerApps View” will display the newly designed tab.

User can add new entries from the same view, by clicking the “+” icon. Also, they can sort the records based on their requirements. Using these steps, you can easily create a new View using PowerApps.

PowerApps are specially designed to target users that are outside the context of SharePoint and uses mobiles/tablets. After installing PowerApps on their Android or iPhone devices and authenticating themselves, they can access this view with the PowerApps URL shared with them. This will elevate the PowerApps experience across SharePoint to its full capacity.