Move To One Form Submission To Another From A Selected Gallery Item

Overview

 
In this article, we will see how we can edit multiple items in a SharePoint list one by one on the success of form submission. In scenarios where you don't want your users to always select an item to edit from a Gallery, this solution is best suited. In scenarios where you have a set of records to be edited and you make use of a Gallery control, this solution is for you. I will give my best in giving you a suitable example in explanation to these scenarios. Let' see below step by step how we can achieve this.
 

Scenario

 
A Team Lead who logs in to the Power Apps application has to see the work items assigned to his team and should be able to edit the worklist items. For this, we need the following,
  • Data Source - Work progress tracker SharePoint List
  • Power Apps -  Work progress tracker application

Creating Work progress tracker list

 
Step 1
 
Open Lists from the O365 suite,
 
Move To One Form Submission To Another From A Selected Gallery Item
 
Step 2
 
Click on New List.
 
Step 3
 
Select the predefined template Work on progress tracker list,
 
Move To One Form Submission To Another From A Selected Gallery Item
 
Step 4 
 
Pre-fill the list with sample data,
 
Move To One Form Submission To Another From A Selected Gallery Item
 

Design Work Progress Tracker application

Step 1
 
Create a new Tablet canvas app from scratch here.
 
Step 2
 
Make a connection to Work Progress Tracker list in canvas app,
 
Move To One Form Submission To Another From A Selected Gallery Item
 
Step 3
 
You can design the controls on the screen as follows: Where Work Item 1 is selected in the edit below screenshot.
 
Move To One Form Submission To Another From A Selected Gallery Item
 
#1 Set Items property of Gallery control,
  1. 'Work progress tracker'  
#2 Function to set a variable on selected gallery item: OnSelect property
  1. Set(var,ThisItem)   
#3 User name Label: Text property
  1. User().FullName
#4 Add an Edit form control with data source 'Work Progress Tracker' list.
 
#5 Set item property of the Edit form to,
  1. var  
#6 Set OnSuccess property of the form to,
  1. Set(  
  2.     var,  
  3.     First(  
  4.         SortByColumns(  
  5.             Filter(  
  6.                 'Work progress tracker',  
  7.                 ID > var.ID  
  8.             ),  
  9.             "ID",  
  10.             Ascending  
  11.         )  
  12.     )  
  13. )  
#7 Set the Completed Icon: OnSelect property,
  1. SubmitForm(FormName)  

Output

Go to my GitHub repository to watch the output.
 

Summary

 
We have seen the creation of the Microsoft Lists Work progress tracker from the existing template and designed a simple gallery and form in Power Apps to edit the list items one by one.