---
schema_version: "1"
id: 2886e53059377a9529ace33c9e4b09bec02889becd5a09fb513856e54294e15b
title: Get a List of Custom Picklist Fields with Inactive Values
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/fields_get_picklists_with_inactive_values.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.fields_get_picklists_with_inactive_values.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: db709db5b48c88494b16e228fb4f98157318bd796efd2cdc4b87ca4020f660e1
description: Get email notifications when custom picklist fields have more than 4,000 inactive values and then use this information to bulk delete the inactive unused values. This feature is available only for custom picklists with predefined values.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Get a List of Custom Picklist Fields with Inactive Values

Get email notifications when custom picklist fields have more than 4,000 inactive values and then use this information to bulk delete the inactive unused values. This feature is available only for custom picklists with predefined values.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in:<strong> All</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d98654e63">User
              Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d98654e63 ">To create or change custom fields:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d98654e63 ">View Setup and Configuration</td>

          </tr>
        </tbody>
      </table>

Follow these steps to get an email notification for custom picklists that have more than 4,000 values.

1. From Setup, in the Quick Find box, enter Settings, and then select **Picklist Settings**.
2. In the Picklist Settings window, click **Email Me** to receive an email with the picklist fields and the number of inactive values.
    
    ![List of Custom Picklist Fields With Inactive Values](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/extend_click/images/fields_picklist_email_inactive_values.png)

In the email, click the picklist name to go to the picklist field page and delete any inactive unused values.

#### See Also

- [Bulk Delete Inactive Picklist Values](https://help.salesforce.com/s/articleView?id=platform.fields_picklist_delete_inactive_values.htm&release=264.0.0&type=5 "Managing your inactive picklist values and enforcing limits on the number of inactive values for custom picklists can improve performance and the overall health of your Salesforce org. If you have a picklist with a large number of inactive unused values, you can bulk delete them.")
- [Picklist Limitations](https://help.salesforce.com/s/articleView?id=platform.picklist_limitations.htm&release=264.0.0&type=5 "The maximum number of characters that you can have in a picklist depends on the type of picklist. Each picklist value includes a line break and a return character that aren’t visible but that count in the character limit.")