Remove data from table based on selections from a gallery

(0) Share

Report

Posted on by EricSara77

I have a table called table1 and it has the following data

EmployeeID	Name
34	Bob
35	Mary
36	Jane

I have table two called table3 and it has the following data

TaskID	Task	EmployeeID
1	Pick it up	34
2	Put it down	34
3	Pick it up	35
4	Pick it up	36
5	Move it around	34
6	Spin around	35

I have a gallery that shows table1 and I have added a check box so that the user can select one or more EmployeeID.
They then press a button and I want to remove all records in table2 where the EmployeeIDs selected in the gallery are removed from table2.

So if the user was to select Bob and Jane then the tasks removed from table2 would be 1,2, 4 and 5 as these are the EmployeeIDs for Bob and Jane.

It sounds simple, and I am sure it is, but for some reason, I cannot get this to work.

Thanks for any assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

timl 36,558 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi y EricSara77

Assuming your gallery is called Gallery1 and the checkbox in the gallery is Checkbox1, something like this should delete the selected rows from Table2.

RemoveIf( Table2, EmployeeID in Filter(Gallery1.AllItems, Checkbox1.Value).EmployeeID )

Was this reply helpful? Yes No
Pacel1 79 on at

Like (0)

Report
Copy link

Link copied!
In checkbox Onselect property You have to put something simmilar to this
ClearCollect( SelectedEmployees, Filter(Gallery1.AllItems, Checkbox1.Value).EmployeeID )

In button for user removal something similar to this:

ForAll( SelectedEmployees, RemoveIf( table2, EmployeeID = ThisRecord.Value ) )

Was this reply helpful? Yes No