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.
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.