PowerApps With SharePoint Online

In this blog, we will see how to use a SharePoint list with PowerApps and deploy it as an App and use it in mobile applications, as well as SharePoint modern pages.

Powerapps is a platform created by Microsoft to extend the capabilities of developers as well as non-technical persons. A person with no coding experience can leverage the functionalities of Powerapp.
 
The main usage is to build mobile applications from predefined templates.
 
In the below demo, we will see how to use SharePoint list with PowerApp and deploy it as an App and use it in mobile applications as well as SharePoint modern pages.
 
Let's create a SharePoint custom List and name it as Issues. The list has two columns, "Issue description" and "Resolution".
 
PowerApps With SharePoint Online
 
Our task is to create an app with this list so that the user can search an issue with resolution from this specific App.
 
Let's connect to PowerApp site and choose “Create an app” option as below,
 
PowerApps With SharePoint Online
 
Give the appropriate name for the app and proceed.
 
Next you will see it opens the Powerapp. Select the Browsegallery1 as we need to make some changes.
 
PowerApps With SharePoint Online
 
On the right hand side, in the Properties section, there is a layout option where you can select a layout for the App as preferred by you. Here, I have selected the “Title” layout as below,

PowerApps With SharePoint Online
 
Next, in the Properties, we need to select the Field and edit. Here I have selected the “Issues” column to be displayed in my PowerApp.
 
PowerApps With SharePoint Online
 
The view screen gets displayed as below,
 
PowerApps With SharePoint Online
 
Next, we can adjust the search formula or leave the default formula as required based on our requirements. Here I have modified the formula.
 
First, select the BrowseGallery option and check whether “items” is selected in the top left as below,
 
PowerApps With SharePoint Online
 
Now, we will use the modified formula to search for any issue present in the list,

SortByColumns(Search(IssuesList, TextSearchBox1.Text, "Issue"), "Issue", If(SortDescending1, Descending, Ascending))

This formula asks the app to search in the Issue List based on the input given in the search box.
 
If(SortDescending1, Descending, Ascending)) - This portion tells the list to sort ascending or descending based on the sort arrows clicked in the top bar.
 
PowerApps With SharePoint Online
 
Our app is almost ready. We can get a preview of the App by clicking on the preview App arrow in PowerApps.
 
PowerApps With SharePoint Online
 
Now, we can search the issue and get to know the details of the issue as below,
 
PowerApps With SharePoint Online PowerApps With SharePoint Online
 
Our app is now ready to be saved and used successfully. We need to save the app from the top left corner “filesàsave “ option. Once saved, the app will appear in your Apps section as below,
 
PowerApps With SharePoint Online
 
The app is now ready to be used in mobile as well as modern pages in SharePoint.This app can also be shared within specific members of the community and given respective permission to edit or use the app by using the “Share this app” option available.
 
In order to view in web page in SharePoint, we can create a SharePoint modern page, and use this App as below,
 
PowerApps With SharePoint Online
 
When you select the option, you need to provide the App or web link for the app, which can be obtained from the app details page from SharePoint.
 
PowerApps With SharePoint Online
 
The app is created successfully and ready to be used.
 
All we need for this development is the trial version of SP Online and PowerApps.