Clearing Report Filters through a Flow
  • 03 Oct 2022
  • 1 Minute to read
  • Dark
    Light

Clearing Report Filters through a Flow

  • Dark
    Light

Article Summary

Overview

For a Report on a Page, filters can be cleared through a Flow Run Part Page component, where selecting the clear option would reset the applied filters to the Report.

The following example builds upon the knowledge of creating both a Report and a Page, along with using a Flow Run Part Page component to set the filters for the Report. For clearing filters on Page load, please refer to this article: Resetting Report Viewer Settings.

Example

This example uses a Page with both a Report Viewer and a Flow Run Part Page component. With the Flow Run Part selected:

  1. Under Flow Info, select Pick or Create Flow ID and create a new Flow.
  2. Add a Form to the Flow. In the Form, add a button as this will be used to provide a way to trigger the remaining steps in the Flow, allowing the Report filters to be cleared.
  3. Once the Form has been configured, add a Create Data step to the outcome path of the button.
  4. With the Create Data Step selected:
  5. In the Properties panel, under Data, select Show Editor. A window should open. Create a new String variable, but leave the input blank. Save and close the window.
  6. Add a Set Dashboard Report Parameters step.
  7. Under Data Definitions, select Add, and input a name that matches a filter on the Report. For example, "Account ID contains".
  8. A new input should be created under the INPUTS section. Here, select the string from the Create Data step and use it as an input to the field. For the Folder ID input, provide the ID of which folder the Page is applied to. Repeat these steps for as many filters as needed. 
  9. Once finished, link the outcome path back to the Form.

Was this article helpful?