PowerApps Bulk Update Collection With Patch And Floating Concept Used For Screen Customization

ClearCollect(
    colPhaseunderProject,
    Filter(
        Project_Phase_Info,
        ProjectID.Value = Projectlist.Selected.ID
    )
);
Created a collection to extract all the tasks under a particular phase
ClearCollect(
    colTasksunderPhase,
    Filter(
        Task_List,
        ProjectID.Value = Projectlist.Selected.ID
    )
)

OnUncheck: Remove(colBulkUpdate,ThisItem)

Now, click on the Edit button and select some tasks from the list.

Action

1. The Task Start Date of these 4 tasks to be changed June 16, 2021
2. The Task End Date of these 4 tasks to be changed to June 23, 2021
3. The Task Assignee of these 4 tasks to be changed to Dilip Kumar
4. The Task Status of these 4 tasks to be changed to In Progress

Result - Displayed in the below image

Steps to achieve this,

Select the checkbox inside the gallery.

On Check: Collect(colBulkUpdate,ThisItem)

OnUncheck: Remove(colBulkUpdate,ThisItem)

Select the Save button: Code(OnSelect)

UpdateIf(
    colBulkUpdate,
    true, // If any tasks selected by checkbox as we have created this collection on Oncheck of Check box//
    { // Below the bold letter are the SharePoint Column name which we want to update. //
        Title: Now(),
        Task_Start_Date: TaskStartdate.SelectedDate,
        Task_End_Date: TaskEnddate.SelectedDate,
        Task_Status: {
            '@odata.type': "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedReference",
            Id: 0,
            Value: dd_TaskStatus.Selected.Value
        },
        Task_Assignee: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
            Claims: Concatenate(
                "i:0#.f|membership|",
                dd_TaskAssignee.Selected.DisplayName
            ),
            Department: " ",
            DisplayName: dd_TaskAssignee.Selected.DisplayName,
            Email: " ",
            JobTitle: " ",
            Picture: " "
        }
    }
);

ClearCollect(
    coldatatoPatch1, // Created a temporary collection //
    ShowColumns(  // The column names which need to be patch are listed //
        colBulkUpdate,
        "ID",
        "Title",
        "Task_Start_Date",
        "Task_End_Date",
        "Task_Status",
        "Task_Assignee"
    )
);
Patch(
    Task_List,  // Sharepoint List//
    coldatatoPatch1 // Temporary collection//
); 
Clear(colBulkUpdate);  //Clear the collection of tasks selected b checkbox//
ClearCollect(colPhaseunderProject,Filter(Project_Phase_Info,ProjectID.Value = Projectlist.Selected.ID));
ClearCollect(colTasksunderPhase,Filter(Task_List, ProjectID.Value = Projectlist.Selected.ID));
Set(
    ResetCheckbox2,
    true
); // Reset the checkbox value in Select All set the Reset property ResetCheckbox2

Bulk Update: Scenario 2

When we click on the Select All checkbox all the tasks will be selected. Let’s update the Task Start Date, Task End date, Task Assignee, and Task Status.

OnCheck: Collect(colBulkUpdate,colTasksunderPhase)

OnUncheck: Remove(colBulkUpdate,colTasksunderPhase)

Action

Result

Bulk Update: Scenario 3

I have explained the 2 examples above for Bulk updates, but in both cases The Task Name box I have kept blank and the Task Name in every task is present. I will explain here the case where the Bulk updates will create the problem and what will be the solution for this.

Please note in the code I have written there is no Task Name column to update,

Let’s add Task Name to update and will check What will be the result,

OnSelect of Save button

UpdateIf(
    colBulkUpdate,
    true,
    {
        Title: Now(),
        Task_Start_Date: TaskStartdate.SelectedDate,
        Task_End_Date: TaskEnddate.SelectedDate,
        Task_Status: {
            '@odata.type': "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedReference",
            Id: 0,
            Value: dd_TaskStatus.Selected.Value
        },
        Task_Assignee: {
            '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
            Claims: Concatenate(
                "i:0#.f|membership|",
                dd_TaskAssignee.Selected.DisplayName
            ),
            Department: " ",
            DisplayName: dd_TaskAssignee.Selected.DisplayName,
            Email: " ",
            JobTitle: " ",
            Picture: " "
        },
        Task_name:Txt_Taskname.Text
    }
);
ClearCollect(
    coldatatoPatch1,
    ShowColumns(
        colBulkUpdate,
        "ID",
        "Title",
        "Task_Start_Date",
        "Task_End_Date",
        "Task_Status",
        "Task_Assignee",
        "Task_name"
    )
);
Patch(
    Task_List,
    coldatatoPatch1
);
Clear(colBulkUpdate);
ClearCollect(colPhaseunderProject,Filter(Project_Phase_Info,ProjectID.Value = Projectlist.Selected.ID));
ClearCollect(colTasksunderPhase,Filter(Task_List, ProjectID.Value = Projectlist.Selected.ID));
Set(
    ResetCheckbox2,
    true
);

Action

Result

Task names of all tasks are changed to Initialize the Budget.

In the above scenario1 and scenario2 if I would have Patch the value of Task Name column then all the Value of Task Name would have Blank. So, it is dangerous to add a column that should have a unique value.

Solution

In the case of doing the bulk update, the data only add the columns which can be changed in a bulk.

Bulk Update: Scenario 4

Delete the multiple Tasks:

On Select of Delete button:

Remove(Task_List,colBulkUpdate.ID);

Clear(colBulkUpdate);

Conclusion

In this article, I have tried to explain how to do various bulk operations like edit, update and delete using the Patch function. It takes very little time which enhances the performance of the application. I hope you enjoy reading the article and watching the video here. Please like and share if you like the content. Thanking you.