Drop Down Tool to Update Filter Selection Not Working

I am trying to use the drop-down tool to update filter selection and can't seem to get it to work. The workflow has the filter selecting a Tax Function of Human Resources. When I try to run the app and select a different function, i.e. Legal, the data in the workflow is not updating. I am hoping this is easy to fix, and I just don't understand how to use the action tool properly. Any help would be greatly appreciated. Sample workflow is attached.

Filter Issue.yxwz

Interface Tools

Accepted answers

patrick_digan

@twheeler Great question! You just need to highlight a different line in your action tool:

You were updating the line for the custom filter (which is greyed out and you're not using). You instead need to update the line for the basic filter. It's not at all obvious from the action tool's setup.

All comments

patrick_digan

@twheeler Great question! You just need to highlight a different line in your action tool:

twheeler

Patrick - Thank you SO much! So, just to make sure I understand, the Simple tree branch represents the Basic filter in the Actions tool? Is that correct?

F_Leghorn

I'm having the same issue. Using a drop down and action tool to populate/change the value in a basic filter. The action tool seems to be configured correctly but the values aren't being entered/updated in the filter. I am using a file to populate the drop down (rather than have the user choose from 1,300 options) but that too, appears to be formatted correctly (Name & Value fields) because the drop down is populated and functioning.

I'm baffled as to why it's not working. Having trouble attaching the wizard to this board message too. Sorry.

patrick_digan

@F_Leghorn I would try using debug mode (see the "test" section https://help.alteryx.com/current/InterfaceDesigner.htm). This will give you a separate workflow with a comment box showing you what was selected as well as the filter tool after the action tool.

F_Leghorn

Workflow is attached

Filter_test.yxzp

Filter_Test_Input.yxdb

stores_for_drop-down.yxdb

patrick_digan

@F_Leghorn tldr: the value column in your stores_for_drop-down.yxdb is currently set to 1 for all records. It should instead be set the store id which is the same as your name column.

Here is what you currently have:

The name field is shown to the user and the value field is passed to the action tool and then the filter tool. Here is what you should have:

In case anyone finds it useful, here is how I attacked your problem. I went to the interface designer, chose the second icon (test view) and selected the first store id. I then clicked open debug. Here is the comment box that was generated in the debug workflow:

Original File Name: C:\Users\216005535\Downloads\Filter_test\Test Filter.yxwz

App Values:
<WizardValues>
<Module>\Test Filter.yxwz</Module>
<Value name="Drop Down (3)">1</Value>
</WizardValues>


Actions Log:
Started running Test Filter.yxwz at Tue Jun  4 14:29:14 2019
00:00:0.007 - Alteryx: The Condition Named="(Always Run)", Expression="1" was True

00:00:0.010 - Alteryx: The Action Named="Tool #4", Type="UpdateValue" was run

The import line is this one:

<Value name="Drop Down (3)">1</Value>

We selected a store id of 458, and it's passing the value of 1 to the filter. We can also check the filter tool and see the issue as well:

From there i went and inspected your file that's feeding the drop down and saw that the value column was all 1.

F_Leghorn

You were correct. Thanks so much!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167