Applying a DAP Job to Report results

Last published at: June 19th, 2023
Delete

Running a DAP Job on the results of a report is available for Premium and PDM licenses.

The records that you can run a DAP Job on can come from several different sources, such as a simple list view, but also the results of a Duplicate Check Job for example. Another source, the results of a report you have saved in Salesforce, is explained below.

Prerequisites

  • The report should contain at least one column that contains record IDs.
    The DAP Job will run on the records in the record ID column you select. This can also be a column with records related to the report object, such as a list of Parent Accounts in an Account report. The column should contain a maximum of 1560 IDs.

  • To run a DAP Job on report results, users need the “Run Reports” permission that lets them run a report in Salesforce.

  • The report should be a saved report.
    Users can apply DAP Jobs to the results of saved reports that they have access to. These can be reports in a public or shared folder, or reports in a private folder of the user. The report should have been run somewhere in the past 365 days.

Running a DAP Job on report results

To use the results of a report in a DAP Job:

  1. Go to DAP Job and click + New Job1660307202678-New Job button.png.
  2. Enter a Job Name that describes what the job will do.
  3. At Select Records, click the Reports option.

    The available reports are shown.
  4. Click the report you want to use the results from If the report contains several objects, select one of the objects as well.
    In this example the report 'New Leads Report' is available for DAP Job

    The report is run to determine which records are available for the DAP Job.
  5. Select the report column that contains the IDs of the records that you want to apply the DAP Job to.
    In this example the Lead ID column can be selected
    Note that these are not necessarily the records in the report itself. The selected report column can also contain records that are related to the report records, e.g. the Parent Accounts in an Account report.
  6. The Select Records field now shows the report and record ID column you selected. Hover over the field to verify which column was selected.
    The Preview Record Selection option will open the report page, where you can review the contents of the selected column.
  7. Click Next.
    You can now continue setting up the DAP Job‍ by selecting an Action to apply to the report records.

No results found

When you selected a report to use in a DAP Job‍, and a message appears stating that no results were found, this could be because:

  • The report does not contain any records
  • No record ID column was added to the report
  • The selected record ID column does not contain any record IDs

Report not available

If you want to use the results of a report in a DAP Job, but the report is not shown when clicking Report at Select Records, this could be because:

  • The report was not saved yet.
  • The report is not accessible by the user who is setting up the DAP Job. The report should be saved in a public or shared folder, or in a private folder of the user.
  • The report hasn't been run in over a year. Run the report and try again.

Use Case

Watch an example of how to use the Mass Update action, in this case on the results of a saved report: