cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CH6
Frequent Visitor

Dropdown items not showing values connected to excel

I am building a form which consists of text fields, drop downs and combo boxes.  I am having difficulty displaying the drop down values which is connected to an excel file on one drive for business. I have completed the following steps; converted my datasheet to a table, connect to the data from the canvas and set items = Stage_Table.Stage on the drop down. 

 

The table is called 'Stage_Table and has one column called Stage with values 1,2,3,4,5,6,7,8,9,10. When I enter the formula for items like this [1,2,3,4,5,6,7,8,9,10] it works but I need to get it to work with excel as my other drop downs will contain a lot more data. 

 

When I write the formula I notice a message saying "we didn't find any data", even though the table does contain data. Any help would be greatly appreciated. Thank you

1 ACCEPTED SOLUTION

Accepted Solutions

Ok @CH6 ,

At least we know here the issue is now and you can forget about the drop-down.

Try this

  1. Delete the connection
  2. Go back to your Excel file and make another copy
  3. Format the required area as a Table with the name Stage_Table
  4. Re-connect to the table
  5. Do the Collection again and see if you have data.

 

View solution in original post

6 REPLIES 6
WarrenBelz
Super User
Super User

Hi @CH6 ,

I find at times if you add a Sort, it all displays

Sort(Stage_Table.Stage,Ascending)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

CH6
Frequent Visitor

Thank you for response @WarrenBelz 

Unfortunately it still isn't displaying the values. Please see screenshot. 

 

OK @CH6 ,

Just to confirm, I did a test at this end on an Excel sheet OneDrive connection using the TableName.ColumnName syntax in a drop-down and it displayed perfectly, so we need to look at your data source/connection.

Firstly, put a button on the screen with this

ClearCollect(colStage,Stage_Table)

then choose View > Collections, open colStage and see what is in the field Stage 

CH6
Frequent Visitor

Here is what I see in the view>collections

 

Attachments: Stage View in collections.PNG. 

It seems to think there are no values. I don't understand as my table has values. I have deleted the connection and added it again and refreshed it, still no luck!

 

Ok @CH6 ,

At least we know here the issue is now and you can forget about the drop-down.

Try this

  1. Delete the connection
  2. Go back to your Excel file and make another copy
  3. Format the required area as a Table with the name Stage_Table
  4. Re-connect to the table
  5. Do the Collection again and see if you have data.

 

CH6
Frequent Visitor

Thank you @WarrenBelz  🙂

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (4,011)