Add People to Set Exclusions
Add people to Set Exclusions to prevent specific individuals from appearing in Query-Based Collections that use those Sets, even if they meet the Set's query criteria. You can exclude people through bulk CSV upload for large groups or through manual selection for smaller numbers.
Prerequisites
Before adding people to Set Exclusions, ensure you have:
- Access to manage Sets in EmpowerID
Procedure
- Navigate to Role Management > Query-Based Collections (SetGroup).
- Select the Actions tab.
- Click Add People to Set Exclusions.

- Search for and select the target Set, then click Submit.

- Under Multiple Person Selection Options, choose your method:
- Select Yes for bulk CSV upload
- Select No for manual selection
Method 1: Bulk CSV Upload
-
If you selected Yes, prepare and upload your CSV file:

Your CSV file must include a header row labeled "Login" followed by one login per row. For example:
Login
john.doe@example.com
jane.smith@example.com
jack.johnson -
Click Browse and select your CSV file.
-
Click Load CSV.

-
Review the loaded results in the preview to confirm the correct people are listed.
-
Click Submit to add the exclusions.

Method 2: Manual Selection
-
If you selected No, manually select people to exclude:

-
Search for a person you want to exclude from the Set.
-
Select the checkbox for the person's record.

-
Repeat steps 7-8 for each person you want to exclude.
-
Click Next to add the exclusions.
The system displays a message confirming the results.
Verify the Results
After adding people to Set Exclusions:
- Navigate to Role Management > Query-Based Collections (SetGroup).
- Search for and select a Query-Based Collection that uses the Set you modified.
- Click the collection name to open its View One page.
- Wait for the Set Compiler Job to run and update the collection membership (or trigger a manual compilation if available).
- Expand the Resource Explicitly Excluded accordion and verify the excluded people appear in the list.

- (Optional) Verify the excluded people do not appear in the collection's regular member list by checking the main membership accordion.
Related Topics
- Create SQL Sets — Create Sets that can have exclusions applied
- Create Query-Based Collections — Create collections that use Sets with exclusions
- About Query-Based Collections — Understand Query-Based Collection concepts