Patch Inactive Value for all Employee Name

(0) Share

Report

Posted on by PrudhviL

136

Hi Community,
Firstly, Happy New Year 😊

I have a requirement,
I have an Employee Marker Column, When I hit the Delete Button for a Particular Employee records in the App , the delete button has to patch the Employee Marker column as "Inactive" for all the records of that particular Employee in the SharePoint List.

This is the formula I tried but is not working.

Patch(
 'NewList',
 ForAll(
 Gallery2.AllItems,
 LookUp(
 'NewList',
 EmployeeName.DisplayName = Gallery1.Selected.EmployeeName.DisplayName,
 {'Employee Marker': "Inactive"}
 )
 )
);

Please help me with this.

@LaurensM @AARON_C @Rajkumar_404

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @PrudhviL ,

If you simply want to mark all records for the selected employee as inactive

UpdateIf( 'NewList', EmployeeName.DisplayName = Gallery1.Selected.EmployeeName.DisplayName, {'Employee Marker': "Inactive"} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Hi @PrudhviL , Try this:
ForAll( Filter('NewList', EmployeeName.DisplayName = Gallery1.Selected.EmployeeName.DisplayName ) As var, Patch( 'NewList', LookUp( 'NewList', EmployeeName.DisplayName = var.DisplayName, {'Employee Marker': "Inactive"} ) ) );
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
PrudhviL 136 on at

Like (0)

Report
Hello @WarrenBelz @ANB

Thank you so much for your reply.
However each employee has more than 200 items in my SP list and it is taking more than a minute for the process to complete.
Also, I know that If we write the ForAll inside the Patch it is more Efficient than ForAll Outside Patch. So, I used this Formula suggested by @LaurensM . Is there any way that we can do it quickly?

Patch( NewList, ForAll( Filter( NewList, Gallery1.Selected.EmployeeName.Email = EmployeeName.Email ), { ID: ID, 'Employee Marker': "Inactive" } ) );

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@PrudhviL ,

If speed is the issue, then all I would improve here is the Ambiguity issue

Patch( NewList, ForAll( Filter( NewList, Gallery1.Selected.EmployeeName.Email = EmployeeName.Email ) As _Data, { ID: _Data.ID, 'Employee Marker': "Inactive" } ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

@PrudhviL You can give a try using power automate.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
PrudhviL 136 on at

Like (0)

Report
Hello @WarrenBelz
Thanks for the reply I have tried the formula and it's still taking at least 30 secs for the delete to complete . Is there a way to make it faster like 10-15 secs.
Patch( NewList, ForAll( Filter( NewList, Gallery1.Selected.Employee.Email = Employee.Email ) As _Data, { ID:_Data.ID, EmployeeMarker: "Inactive" } ) );

Hello @ANB . Thank you for your reply But I cannot use Power Automate since it's not in the Project Scope. I only have to use Power Apps and SP list.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
@PrudhviL ,

Sorry, a bulk Patch is as quick as you are going to get. You could try this

With( { _List: Filter( NewList, Gallery1.Selected.Employee.Email = Employee.Email ) }, Patch( NewList, ForAll( _List As _Data, { ID:_Data.ID, EmployeeMarker: "Inactive" } ) );

but I do not think it will make much of a difference.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No