Power Apps | Editing data in forms exercise | Create and maintain a list of things you enjoy about lockdown

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

You can learn how to do this exercise if you attend the course listed below!

Software ==> Power Apps  (13 exercises)
Version ==> Latest update
Topic ==> Editing data in forms  (2 exercises)
Level ==> Average difficulty
Course ==> Power Apps

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Here's hoping that this exercise is nostalgic, and evokes only memories.  Create an Excel workbook of things you enjoyed about lockdown, and populate it with a couple of items:

Excel table of lockdown benefits

Create a table in your Excel workbook called Benefits, and save the workbook to DropBox or OneDrive.

Create a new canvas mobile app, and save it as Lockdown Likes.

Create a gallery on the first screen of your app to list out the rows from your workbook:

Gallery of likes

Also create the add button as shown (we'll worry what it does later in this exercise!).


Add a second screen to your app, and on this add a details form to display the selected item from the previous screen.  Within this add two custom cards (one for each field in our "database").  Unlock the properties of both custom cards to get something like this:

Custom cards Cards in form
The two custom cards ... ... and what they look like.

Now add buttons at the bottom of your form and tidy it up to get something like this:

Interesting discovery

Interesting discovery: you can't put a border round a text box inside a custom card for a form in view mode. Wonder why?


Continuing to pick the low-hanging fruit first, get the Cancel button to return a user to the list of lockdown benefits (we'll revisit the other two buttons in a bit).

Create a third screen, and add an edit form to it to look something like this:

Edit form

You'll need to set the data source and item for the form. Don't worry about the actions for the Save changes or Cancel buttons quite yet.


Deep breath ... after testing that everything works so far, attach actions to all of the buttons so far unprocessed, using the following notes (if you're lucky enough to be on a Wise Owl course, there's an excellent manual page summarising this that you can refer to):

Form Button What it should do
Gallery Add a new like Use the NewForm action to put the edit form in New mode, then go to the screen containing the edit form.
Details form Change Put the edit form in edit mode, then go to the screen containing it.
Details form Delete Run the RemoveIf command to remove from the data source any row where the benefit is the same as the current item's, then return to the gallery list screen.
Edit form Save changes Share the current value of the edit form mode in a variable, submit the form and then use the remembered edit form mode to determine which screen to return to.
Edit form Cancel Share the current value of the edit form mode in a variable, reset the form to remove any changes and then use the remembered edit form mode to determine which screen to return to.

And if you get that all working, give yourself a massive pat on the back and close your app down! 

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post