Power app form that will populate more than one line in a list

%3CLINGO-SUB%20id%3D%22lingo-sub-2873603%22%20slang%3D%22en-US%22%3EPower%20app%20form%20that%20will%20populate%20more%20than%20one%20line%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2873603%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVery%20novice%20power%20app%20individual%20here%2C%20we%20are%20wanting%20to%20use%20a%20power%20app%20to%20log%20our%20back%20up%20successes%20and%20failures%20(currently%20a%20piece%20of%20paper).%20So%20from%20a%20List%20perspective%20(where%20the%20data%20will%20be%20saved)%20this%20will%20need%20to%20be%20an%20individual%20line%20per%20backup%20procedure.%20However%20it%20would%20be%20good%20on%20the%20power%20app%20to%20have%20the%20date%20and%20then%20each%20procedure%20listed%20and%20be%20able%20to%20tick%20cross%2C%20add%20a%20note%20and%20then%20save%20all%20in%20one%20screen%20but%20on%20the%20list%20these%20all%20appear%20on%20different%20lines.%20Before%20I%20hunt%20and%20hunt%20to%20see%20how%20this%20can%20be%20done%20can%20anyone%20tell%20me%20if%20it%20is%20possible%2C%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2873603%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Elist%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2878818%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20app%20form%20that%20will%20populate%20more%20than%20one%20line%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2878818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F961861%22%20target%3D%22_blank%22%3E%40SH0lm3s%3C%2FA%3E%26nbsp%3Byes%20this%20is%20possible%20and%20not%20difficult%2C%20it%20uses%20a%20series%20of%20%3CSTRONG%3EPatch%3C%2FSTRONG%3E%20functions%20to%20save%20each%20item%20from%20the%20screen%20into%20the%20list.%20I'll%20post%20some%20screenshots%20shortly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2880851%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20app%20form%20that%20will%20populate%20more%20than%20one%20line%20in%20a%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2880851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F961861%22%20target%3D%22_blank%22%3E%40SH0lm3s%3C%2FA%3E%26nbsp%3Bso%20this%20example%20has%202%20lists%2C%20one%20that%20holds%20the%20tasks%20to%20be%20completed%20(BackupTasks)%20and%20the%20main%20list%20of%20the%20backup%20tasks%20completed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-dataSources.png%22%20style%3D%22width%3A%20163px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319673i4539A67B47B9F29B%2Fimage-dimensions%2F163x171%3Fv%3Dv2%22%20width%3D%22163%22%20height%3D%22171%22%20role%3D%22button%22%20title%3D%221-dataSources.png%22%20alt%3D%221-dataSources.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BThe%20tasks%20get%20added%20to%20the%20screen%20from%20the%20BackupTasks%20list%2C%20or%20you%20can%20add%20them%20manually%20which%20is%20easier%2C%20particularly%20if%20the%20actions%20don't%20change%20much%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-taskList.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319680iF539A883EA52FE55%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-taskList.png%22%20alt%3D%222-taskList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20add%20a%20checkbox%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-checkBox.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319682iC909CA3B84184DFC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223-checkBox.png%22%20alt%3D%223-checkBox.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20add%20a%20text%20input%20box%20for%20the%20comment.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%224-comment.png%22%20style%3D%22width%3A%20943px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319683iE8D8797C1CD7F9A5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%224-comment.png%22%20alt%3D%224-comment.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdd%20a%20button%20to%20save%20the%20items%20to%20the%20Backup%20list.%20In%20the%20OnSelect%20property%20add%20a%20Patch%20function%20to%20add%20each%20of%20the%20fields%20in%20the%20screen%20to%20the%20appropriate%20SharePoint%20column%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-json%22%3E%3CCODE%3EPatch(Backup%2C%20Defaults(Backup)%2C%0A%7BTitle%3A%20lblTask1.Text%2C%20Comment%3A%20Comment1.Text%2C%20Completed%3A%20Checkbox1.Value%2C%20Completion%3A%20Now()%20%7D)%3B%0A%0APatch(Backup%2C%20Defaults(Backup)%2C%0A%7BTitle%3A%20lblTask2.Text%2C%20Comment%3A%20Comment2.Text%2C%20Completed%3A%20Checkbox2.Value%2C%20Completion%3A%20Now()%20%7D)%3B%0A%0APatch(Backup%2C%20Defaults(Backup)%2C%0A%7BTitle%3A%20lblTask3.Text%2C%20Comment%3A%20Comment3.Text%2C%20Completed%3A%20Checkbox3.Value%2C%20Completion%3A%20Now()%20%7D)%3B%0A%0APatch(Backup%2C%20Defaults(Backup)%2C%0A%7BTitle%3A%20lblTask4.Text%2C%20Comment%3A%20Comment4.Text%2C%20Completed%3A%20Checkbox4.Value%2C%20Completion%3A%20Now()%20%7D)%3B%0A%0APatch(Backup%2C%20Defaults(Backup)%2C%0A%7BTitle%3A%20lblTask5.Text%2C%20Comment%3A%20Comment5.Text%2C%20Completed%3A%20Checkbox5.Value%2C%20Completion%3A%20Now()%20%7D)%3B%0A%0APatch(Backup%2C%20Defaults(Backup)%2C%0A%7BTitle%3A%20lblTask6.Text%2C%20Comment%3A%20Comment6.Text%2C%20Completed%3A%20Checkbox6.Value%2C%20Completion%3A%20Now()%20%7D)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%225-onSelect.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319681iBD5359A99E3E4914%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%225-onSelect.png%22%20alt%3D%225-onSelect.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20add%20any%20follow-on%20actions%20to%20navigate%20to%20a%20different%20screen%2C%20exit%20the%20app%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20checkbox%20next%20to%20each%20task%20is%20checked%20(or%20not)%20and%20any%20comment%20added%20and%20the%20button%20clicked%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%226-form.png%22%20style%3D%22width%3A%20905px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319684i23DC4783DCF7C742%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%226-form.png%22%20alt%3D%226-form.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Patch%20function%20adds%20each%20row%20to%20an%20item%20in%20the%20list%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%227-SP-listResult.png%22%20style%3D%22width%3A%20829px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F319685iEBE950DBEECEDF03%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%227-SP-listResult.png%22%20alt%3D%227-SP-listResult.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

3 Replies

@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)

@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.

 

1-dataSources.png

 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:

 2-taskList.png

 

Then add a checkbox:

 

3-checkBox.png

 

Then add a text input box for the comment.

4-comment.png

 

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() });


 

5-onSelect.png

 

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:

 

6-form.png

 

The Patch function adds each row to an item in the list:

7-SP-listResult.png

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

 

 

Hi Rob,

Thanks so much for that - patching will be new to me but at least I know what I'm learning now