Answered

Dropdown Values from Excel Table on OneDrive will not populate

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

LRVinNC 2,297 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Mr-Dang-MSFT Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

jignaski18 9 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No