Dropdown Values from Excel Table on OneDrive will not populate

[jignaski18]

I am trying to populate a dropdown list based on a previous selection. The excel file contains a table called Fleets. It has two columns: Districts and Fleet. The dropdown is to display the fleets associated with that district. The user selects what district they are working from in a previous screen. 

Flow: Selects district > Transitions to Fleet Selection > Selects Fleet from dropdown

I cannot get the dropdown to generate any values even setting the Items formula to fx= Fleets.Districts.

Any suggestions?

[LRVinNC]

I created a table identical to the one you included in your screen shot and connected it to two dropdowns - one to choose the district and the second to choose the fleet from only those valid for the district. 

I don't connect to Excel very often, so when I first started to test, I couldn't get anything to show up in my dropdown, even after refreshing twice and I was very puzzled.  Then I realized the file was open so I closed it, refreshed again and immediately my data popped.  That may not be related to your issue, but thought I would share, just FYI.

Here is how I set up my dropdowns.  You can see that it did indeed show the data and filter by district.

I hope this can help you pinpoint your problem.

[Mr-Dang-MSFT]

@jignaski18 , let us know if @LRVinNC's solution works for you.

As FYI, the scenario you're trying to achieve can be searched by some keywords: 'dependent drop downs' or 'cascading drop downs'. 

[jignaski18 · Accepted solution]

Thank you for your suggestion. I fould that setting a variable onselect of the button to control the dropdown seemed to work. Going to move my data over to a SQL server next!