Hi,
I try to remove the collection item by checking another collection, if item is exist in other collection then would like to remove it from main collection, let me share an example below
ClearCollect(colListofPeople, {Result: "A"},{Result: "C"}, {Result: "Z"});
ClearCollect(colAvailablePerson, {Value: "A"}, {Value: "B"});
tried to iterate colListofPeople one by one to check colAvailablePerson, if exist then delete (currently "a" is the common) the respective record.
so the final result should look like:
thank you

Report
All responses (
Answers (