Alteryx Gallery no longer displaying drop down menu correctly

Question

I have a workflow that was working great for over 4 years, but after the latest server update, the last part of the workflow stopped working correctly. It is supposed to be 10 drop down fields allowing users to select a data field.

I have attached a picture of what it looks like in Designer, when its working properly, vs a picture of the gallery where it no longer works correctly.

Any help would be appreciated. Thank you

Designer.PNG

Gallery.PNG

jordan_mackey · Answer

For anyone that might be having the same issue, I was originally using the "External Source" option in the dropdown configuration, and then using a gallery data connection to pull the data via a SQL query. Even formatting the data as NAME and VALUE fields within the query, I was still getting "No results" when trying to run the app in the gallery.

To resolve this, I created a separate workflow that refreshes and deposits yxdb files on our shared drive of all of the values needed for the dropdown menus with the field names hardcoded as NAME and VALUE. I then updated the dropdown configurations to "External Source", and then browsed for each file of the dropdown values. The app now works correctly on the gallery and the dropdown menus show the appropriate values.

jordan_mackey · Answer

Hello,

Was this resolved? I am on the same Alteryx version and experiencing the same issue with my first app that I've developed.

khana0530 · Answer

Hi Dan,

We upgraded to 2024.2.1.14.

Yup, if I open the workflow in designer from the server, I can run through everything just fine. When I try to run the workflow in the gallery, the drop downs no longer show up. It's not an issue of the drop downs not having data, they just fail to render in the gallery. I have the dropdowns updating a text input field.