Unanswered

Dropdown items not showing values connected to excel

(0) Share

Report

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

Categories:

Building Power Apps

Stage table data.PNG

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

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

Was this reply helpful? Yes No
CH6 19 on at

Like (0)

Report

Thank you for response @WarrenBelz
Unfortunately it still isn't displaying the values. Please see screenshot.

Stage Table sort.PNG

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
CH6 19 on at

Like (0)

Report

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!

Stage View in col...

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
Ok @CH6 ,
At least we know here the issue is now and you can forget about the drop-down.
Try this
Delete the connection
Go back to your Excel file and make another copy
Format the required area as a Table with the name Stage_Table
Re-connect to the table
Do the Collection again and see if you have data.

Was this reply helpful? Yes No
CH6 19 on at

Like (0)

Report

Thank you @WarrenBelz 🙂

Was this reply helpful? Yes No