This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Power Apps (13 exercises)
Topic ==>	Editing data in forms (2 exercises)
Level ==>	Average difficulty
Subject ==>	Power BI training

Create a linked gallery, details form and edit form from scratch

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.

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:

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:

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:


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: 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:

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.