Can Apsona scheduled reports be triggered dynamically from Salesforce Flow based on conditions?

Resolution:

  • Apsona does not directly offer triggering scheduled reports using flow.

  • Work around: Salesforce Flow updates the Active status of a specific Apsona scheduled report. In this case, the Flow determines whether the report is active or inactive, and the Scheduler will run or skip it the next time it evaluates scheduled reports.

  • Please note that this still follows the Scheduler’s regular timing and does not trigger the report immediately.

Important points to consider:

  • Apsona scheduled reports are stored in a custom Salesforce object called Apsona Schedule (API name: apsona_sched__Schedule__c)

  • This object includes an Active checkbox field, which is a key control used by the Apsona Scheduler. Only schedules with Active = TRUE are eligible to run

  • The user or system context running the Flow must have full read/write access to this object and its fields.