Salesforce Flow: Mass Delete Paused and Waiting Flow Interview Records

Solution 1: Use a Salesforce Flow to Mass Delete Flow Interviews

Follow these steps to create a Flow that mass deletes FlowInterview records:

1. Navigate to Setup > Process Automation > Flows (Lightning Experience) or Setup > Build > Create > Workflows & Approvals > Flows (Classic).
2. Click New Flow. This opens the Lightning Flow Builder Select a Flow Type (Screen Flow or Autolaunched Flow). Drag and drop a Delete Records element onto the canvas and fill in the following details:
   1. Enter a Name and API Name for the element.
   2. Under "How to Find Records to Delete," select Specify conditions.
   3. Under "Delete Records of This Object Type," select FlowInterview and create a filter such as: InterviewLabel contains "API-Name-Of-The-Process." The InterviewLabel field includes the API Name, Version Number, and Object Name, which gives you the flexibility to mass delete interviews for a specific version of a process.
3. Click Save. Enter the Flow Name and click Activate to make the Flow available to run.

Important Considerations Before Running the Delete Flow

• The filter you define in Step 2 determines which FlowInterview records are deleted. Take your time to ensure you select the correct filter and include the version number in the API name as necessary.
• Test this Flow in a Sandbox environment first to confirm it works as expected before running it in production.
• To delete a FlowInterview record, the running user must have the "Manage Force.com Flow" user permission. All other calls require the "Run Flows" user permission or the Force.com Flow User field enabled on the user detail page.

Once the Flow is created and activated, navigate to the Flow Detail page and click Run to execute the Flow. Note: clicking Run immediately kicks off the Flow and the delete process.

Solution 2: Use Bulk API or Data Loader

As an alternative, the FlowInterview standard object is exposed via the Salesforce REST and SOAP APIs (API version 33.0 and above). Use Salesforce Data Loader or Workbench to query and delete FlowInterview records in bulk. Filter by InterviewLabel containing the API name of the specific process to target only the relevant records.