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".
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,
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.
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,
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.
The view screen gets displayed as below,
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,
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.
Our app is almost ready. We can get a preview of the App by clicking on the preview App arrow in PowerApps.
Now, we can search the issue and get to know the details of the issue as below,
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,
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,
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.
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.