Home >Tips >Power Apps >Projects powerapp kalmstrom.com site map icon Site map  

Create a Projects Powerapp from a SharePoint List

A tutorial by Peter Kalmström

Microsoft Power Apps iconIn the previous article we looked upon SharePoint list form modification in Power Apps, but now it is time to do what Power Apps is mainly 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 where 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.

Create a Projects powerapp

Start in a SharePoint Projects list that has the modern interface.
  1. In the Projects list, click on 'Power Apps' in the command bar and select 'Create an app'.
  2. Give the powerapp the name "Projects" and click on Create.
The new app will now open at make.powerapps.com with thre different screens: Browse, Details and Edit. The design might not be optimal, but it is possible to modify which fields are displayed in the app, 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.

NOTE: The demo was recorded a few years ago, and Power Apps has improved. Now, Power Apps searches by the Title by default. The method Peter shows, can however be used to search other columns instead.

Modify the Browse screen

The Browse screen has a search box on top, and below it a few list fields are displayed. It is important that the most informative fields are shown, so Peter suggests some changes in the design:
  1. Set the search box to look in the Title field, by changing the search parameter shown in the formula bar.
  2. Show Project title and Status by modifying ThisItem formulas.
  3. Show cancelled items with a red title, by adding 'If(ThisItem.Status.Value ="Cancelled", Red,' before the standard text color in the formula for the Status field Color property.

In the next article we will create a Phone Messages powerapp

Learn more





back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved