DropList Tool using External Source (NAME &&& VALUE) working in desktop but not in server

Question

Hi all,

I have this Interface's DropList tool using the "External Source (NAME && VALUE)" which connects to data mart to get the most recent updated list of selections.  It's important to use the list of selections rather than user input which can results in human common errors.  The first picture I have below is working good from my desktop but the next picture shows that it's not working at all in the server which is showing blank information.  I've searched the community and found this post below.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Dropdown-list-from-SQL-Table-in-Analytic-App-on-Gallery/td-p/502340/page/2

This sounds like crew macro was the solution but that was an old post.  I would like to check if there's a new solution beside the use of crew macro.

DrydenChicago · Answer

Thanks BrandonB.  I was hoping to avoid the extra step of writing to a yxdb file.  It'll need to be dynamic and based on what's available in the data mart.

atcodedog05 · Answer

-

BrandonB · Answer

The easiest way is to leverage a chained app as explained by DanM here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Interface-DropDown-does-not-populate-on-the-server-with-updated/m-p/480442/highlight/true#M96717

Your first workflow queries the table and writes the name/value table to a yxdb file. Then your second workflow uses this name/value yxdb file as the external source to read in the values.