How to Dynamic filter in report

huytq6

I have a report with column 'Branch', and I have flow output is Current User Branch, I need to filter 'Branch' equals 'Current User Branch' (output of flow,type String), thank you

Sumanjana_Decisions

Hi,

It's feasible to filter the report by passing the value from a flow.

In the report level, you need to add the filter 'Branch Equals' and in the properties select Get Values From Other Reports from the Runtime Behavior dropdown.

You need to trigger the flow that outputs the 'Current User Branch' using the run flow or Flow run part step. In that flow, pass the 'Current User branch' value to the URL using the Set Dashboard Report Parameters step.  This step can be used to set and create runtime filters for a Report on a dashboard. When running the flow, the report will be filtered and displayed based on the filter value passed.

Refer to the documentation on Filtering Reports via Page Control for more details. If you need further assistance, kindly reach out to support@decisions.com

huytq6

Sumanjana_DecisionsMar 26, 2025

Hi,

It's feasible to filter the report by passing the value from a flow.

In the report level, you need to add the filter 'Branch Equals' and in the properties select Get Values From Other Reports from the Runtime Behavior dropdown.

You need to trigger the flow that outputs the 'Current User Branch' using the run flow or Flow run part step. In that flow, pass the 'Current User branch' value to the URL using the Set Dashboard Report Parameters step.  This step can be used to set and create runtime filters for a Report on a dashboard. When running the flow, the report will be filtered and displayed based on the filter value passed.

Refer to the documentation on Filtering Reports via Page Control for more details. If you need further assistance, kindly reach out to support@decisions.com

Hi, I have entity with Branch and Email, when I Fetch Entities with criteria Email equals Current account email, it output Branch of that email for me, then I need report filter Branch equals that find out Branch, so when user A with brand A open report, he just view data of brand A