Oct 22 2021 05:07 AM
Hello All,
Very novice power app individual here, we are wanting to use a power app to log our back up successes and failures (currently a piece of paper). So from a List perspective (where the data will be saved) this will need to be an individual line per backup procedure. However it would be good on the power app to have the date and then each procedure listed and be able to tick cross, add a note and then save all in one screen but on the list these all appear on different lines. Before I hunt and hunt to see how this can be done can anyone tell me if it is possible, thanks.
Oct 24 2021 07:11 AM
@SH0lm3s yes this is possible and not difficult, it uses a series of Patch functions to save each item from the screen into the list. I'll post some screenshots shortly.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Oct 25 2021 01:48 AM
@SH0lm3s so this example has 2 lists, one that holds the tasks to be completed (BackupTasks) and the main list of the backup tasks completed.
The tasks get added to the screen from the BackupTasks list, or you can add them manually which is easier, particularly if the actions don't change much:
Then add a checkbox:
Then add a text input box for the comment.
Add a button to save the items to the Backup list. In the OnSelect property add a Patch function to add each of the fields in the screen to the appropriate SharePoint column:
Patch(Backup, Defaults(Backup),
{Title: lblTask1.Text, Comment: Comment1.Text, Completed: Checkbox1.Value, Completion: Now() });
Patch(Backup, Defaults(Backup),
{Title: lblTask2.Text, Comment: Comment2.Text, Completed: Checkbox2.Value, Completion: Now() });
Patch(Backup, Defaults(Backup),
{Title: lblTask3.Text, Comment: Comment3.Text, Completed: Checkbox3.Value, Completion: Now() });
Patch(Backup, Defaults(Backup),
{Title: lblTask4.Text, Comment: Comment4.Text, Completed: Checkbox4.Value, Completion: Now() });
Patch(Backup, Defaults(Backup),
{Title: lblTask5.Text, Comment: Comment5.Text, Completed: Checkbox5.Value, Completion: Now() });
Patch(Backup, Defaults(Backup),
{Title: lblTask6.Text, Comment: Comment6.Text, Completed: Checkbox6.Value, Completion: Now() });
You can also add any follow-on actions to navigate to a different screen, exit the app etc.
The checkbox next to each task is checked (or not) and any comment added and the button clicked:
The Patch function adds each row to an item in the list:
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Oct 27 2021 01:09 AM