How to use the Filter Dynamic Datasource Fields Action (with example)?

How to use the Filter Dynamic Datasource Fields Action (with example)?

FIRST CREATED ON 16 Jan 2026 I AUTHOR Emma Camacho

This action allows you to be even more flexible. You can build a Supporting App that will contain the name of the fields and their corresponding value. Kind reminder: usually the Supporting App contains the values to filter a specific field. In contrast, this action has both the field names and the values.

We have the Executive Dashboard App that looks like this:


and we want to generate a special Report that will show per Region the Sales for 2 specific Sales Reps with 2 specific Products.  We have the supporting App that looks like this:


Note that the Sales Reps are different for every Region as well as the Products.

The Report definition and template look like this:



The Repeater Element looks like this:


The Preparation Actions of the Repeated elements Group look like this:



Product Type Desc

[Datasource].[Executive Dashboard - Partners Workshop].[Expression].[concat(distinct [Product Type Desc],', ')]

Region
[RepeatedValue].[Region]

Sales Rep Name
[Datasource].[Executive Dashboard - Partners Workshop].[Expression].[concat(distinct [Sales Rep Name],', ')]

table

Output:

We have a report that was created using Filter Dynamic Datasource Fields Action.

Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.