In
the previous article we looked upon SharePoint list
form modification in PowerApps, but now it is time to do
what PowerApps mainly is intended for: create apps.
In the demo below, Peter Kalmström, CEO and Systems
Designer of kalmstrom.com Business Solutions, shows how
to create a PowerApp called Projects. In this app, items
in a SharePoint Projects list can be viewed, edited or removed,
and new items can be created.
Any changes you make in the Projects PowerApp will be reflected
to the Projects SharePoint list and vice versa.
Peter starts in a SharePoint Projects list that has the
modern interface.
Create a Projects PowerApp
In
the Projects list, click on 'PowerApps' in the command
bar and select 'Create an app'.
Give the PowerApp the name "Projects" and click
on Create.
The new app will now open at create.powerapps.com. It will
have a touch friendly design and three different screens:
Browse, Details and Edit, where some of the fields from
the list will be shown. The design might not be optimal,
but it is possible to modify which fields are displayed,
and in which order.
Click on the Play button to the right in the top banner
to see the Play screen and test your modifications.
Modify the Browse screen
The
Browse screen has a search box on top, and under it a few
fields of each list item are displayed. It is important
that the most informative list fields are shown, so Peter
suggests some changes in the design:
Set the search box to look in the Title field, by
selecting the BrowseGallery and changing the search
parameter shown in the formula bar. This is Peter's
formula: SortByColumns(Filter(Projects, StartsWith(Title,
TextSearchBox1.Text)), "Title", If(SortDescending1,
Descending, Ascending))
Show the project title first, by selecting the first
card in the app and writing 'Title' after ThisItem.
in the formula bar, instead of the existing text.
Show Status in the second field, by selecting the
card and typing 'Status.Value' after ThisItem instead
of the existing text.
Show cancelled items with a red title, by selecting
the Title field in the PowerApp and Color in the Property
dropdown and typing 'If(ThisItem.Status.Value ="Cancelled",
Red,' before the standard text color in the formula
bar.
Save and use the Projects PowerApp
When you are finished, save the PowerApp under the File
tab. It will be stored at web.powerapps.com, which you can
reach via the PowerApps tile in your Office 365 App Launcher.
Sign in with your Office 365 account and select 'Apps I
own' above the list of apps.
At web.powerapps.com you can remove or edit your PowerApps
and also create new PowerApps.
To use the Projects PowerApp we have created here, you can
just click on the Projects view in the SharePoint list.
That view was added automatically when you created the PowerApp
from the SharePoint list. The Projects view opens in the
web player, web.powerapps.com.
When you have PowerApps installed on a smartphone or tablet,
you will have the new PowerApp among the other apps in that
device.
In
In
the Projects list, click on 'PowerApps' in the command
bar and select 'Create an app'.
The
Browse screen has a search box on top, and under it a few
fields of each list item are displayed. It is important
that the most informative list fields are shown, so Peter
suggests some changes in the design:
