Dynamic Filter with Dynamic List Box Interface

Question

Hello All,

I am attempt to create a workflow that creates a dynamic check list in the analytic portion of the app based on the "TEST_DATA" workbook and then using said check list in another workflow to filter down the data. Additionally, being able to select multiple from the list to run at once is key here that is why I attempted to use the "in" formulas in the macro.

Attached:

1. TEST_DATA_1, TEST_DATA_2 and TEST_DATA_COMBINED: Source data, Columns that will be utilized as the control "Operator"

2. DYNAMIC_FILTER: This workbook is attached to the list interface tools in the "TEST_WORKFLOW" so that the checkbox changes with each file thats added. If TEST_DATA_3 was added then TEST_Filter3 would be added to the below.

3. TEST_WORKFLOW: this simulates how the dynamic filter should be used. If the operator is selected in the analystics app I would like it to filter the TEST_DATA_COMBINED down to what matches on whats selected.

4. DYNAMIC_LIST: this workflow creates the "DYNAMIC_FILTER" file first based on the TEST_DATA

5. DYNAMIC_FILTER_1 & 2: These are my attempts to filter the data on the available operators from the data that will also show up in an analytics app.

Ultimately the final version of the "DYNAMIC LIST" and "TEST WORKFLOW" will be chained together but for now I cant get the macro to successfully filter the data based on the "DYNAMIC_FILTER" workbook. Any and all assistance would be greatly appreciated

DYNAMIC_FILTER_1.yxzp

DYNAMIC_FILTER_2.yxzp

DYNAMIC_LIST.yxzp

TEST_DATA_2.xlsx

TEST_DATA_1.xlsx

MKlotz · Answer

This makes sense, but when I run the macro in the TEST_WORKFLOW in debug mode, im still not getting any values to pass through the macro even after selecting both options in the questions section. I have the list option selected as an external source in the test_workflow so im unsure if that is what is causing the issue.

DYNAMIC_FILTER_1_UPDATED.png

TEST_WORKFLOW_2.png

TEST_WORKFLOW_1.png

OTrieger · Answer

One more thing Action tool is not needed there. I always prefer using the Q for connection unless I will need to setup a specific rule in the action tool, if you would like only to get the values directly from the interface tool, use Q connection it is much easier

OTrieger · Answer

Hi @MKlotz

You did not set correctly the List Box tool.

Here is my advice, when you are building Analytical tool with user interface tools, always use Open Debug to see how the data would be in your would run it from Gallery.

If you would do just that you will know what was the issue.

As you can see you are not getting the values that you wanted to get.

You would like to get a list from the List Box