Dropdown items not showing values connected to excel

[CH6]

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

[WarrenBelz]

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]

Thank you for response @WarrenBelz 

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

[WarrenBelz]

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]

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!

[WarrenBelz · Accepted solution]

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]

Thank you @WarrenBelz  🙂