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
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,755)