Dropdown values should come from a field after consolidating multiple csv files

[bjprado16_spgi]

Hi,

I'm trying to create an app for our data cleaning automation. The general workflow so far is like this:

1. consolidate csv files from a specific folder into one table. The table contains a field for account names.

2. the user will select an account name from a dropdown. The dropdown values are the unique values of the account field.

3. the dataset will be filtered based on the selected account by the user.

My challenge is that, when I test the app, I am seeing no values in the dropdown. I already tried to search for quite a bit for answers here but can't find anything similar to my problem so here I am.

screenshot of workflow

any help will be appreciated. :)

[Qiu]

@bjprado16_spgi 
I think at least we are missing one "Dynamic Rename" tool after the Cross Tab tool to bring the account names as the field names.
I stay corrected for above. sorry
and I dont know about the icon #1 between Drop Down and Action tool.

[Qiu]

A quick sample.

[SPetrie · Accepted solution]

I believe the issue is that you are trying to populate the dropdown from data that is collected after the workflow starts running.

I think a chained app is the only other option besides having a pre-populated account list to pre-load the dropdown.

I have a quick example of a chained app attached.

[bjprado16_spgi]

Yes, I opted for a chained app solution. Closing this thread now. Thanks all for the input.