Alteryx Gallery no longer displaying drop down menu correctly

[khana0530]

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

[DanM]

@khana0530 

What version of the server did you move to?

Are you stating that if you open the workflow in Designer it works correctly? Meaning you've pulled the workflow from the server and are able to run it locally.

What tool are you field mapping to in the workflow to update via the app interface?

Dan

[khana0530]

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.

[jordan_mackey]

Hello,

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

[jordan_mackey]

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.