Bulk Job Status Dashboard Generator

Overview

Scheduled daily flow that retrieves all Salesforce bulk data jobs via the GetAllJobs connector action, iterates through each job record, and writes a row to an Excel workbook on SharePoint containing job metadata (ID, state, operation, object type, record counts, timestamps). Provides IT admins with a persistent, filterable dashboard for monitoring bulk job health across the Salesforce org.

Use Case

IT operations teams need visibility into Salesforce bulk data jobs — imports, exports, deletes, and upserts — to catch failed or stalled jobs early. This flow runs daily, captures a snapshot of every bulk job, and writes it to Excel on SharePoint where Power BI or pivot tables can surface trends, failure rates, and processing volumes over time.

The flow is ideal for teams that:

• IT operations teams monitoring Salesforce bulk job health
• Admins who need early warning on failed or stalled bulk jobs
• Reporting teams building Power BI or pivot views over bulk job history
• Organizations running daily/weekly Salesforce data imports, exports, or upserts

Flow Architecture

Environment Variables

Connectors & Connections

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Create the dashboard workbook

Create an Excel workbook at the path specified in flowlibs_BulkJobDashboardExcelPath (default: /Shared Documents/FlowLibs - Bulk Job Dashboard.xlsx).

Add the BulkJobDashboard table

Inside the workbook, add a table named per flowlibs_BulkJobDashboardTableName (default: BulkJobDashboard) with columns SnapshotDate, JobId, State, Operation, Object, RecordsProcessed, RecordsFailed, CreatedDate.

Set environment variables

Update the three environment variable values for your SharePoint site URL, workbook file path, and Excel table name.

Authorize connections

In the flow designer, authorize the Salesforce and Excel Online (Business) connections with accounts that have the required permissions.

Turn the flow On

Enable the flow so the daily recurrence trigger fires at 6:00 AM EST.

Adjust the schedule

Edit the Recurrence trigger to change frequency or time of day if a daily 6:00 AM EST snapshot does not fit your monitoring cadence.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

utcNow('yyyy-MM-dd HH:mm:ss')

body('Get_All_Bulk_Jobs')?['records']

coalesce(items('For_Each_Job')?['operation'], '')

concat('Bulk Job Status Dashboard updated at ', variables('varSnapshotDate'), '. Total jobs logged: ', string(variables('varJobCount')), '.')