cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
imrineeman
Regular Visitor

Powerapps wont show values from excel table

Hello, this is a super basic question but I've wasted all my weekend trying to make it work to no avail.

 

I have an excel spreadsheet and I want to link the table in it to a dropdown box.

I manage to link the table to the box but when I click it it shows no values, no matter what I do.

 

 

How can I do this properly? this is so frustrating

 

Thank you

9 REPLIES 9
Pstork1
Dual Super User III
Dual Super User III

Can you show us a screenshot of the Properties pane when the dropdown is selected in the editor?  There is a Value field in that panel.  That is the name of the field in the value that will be shown in the dropdown.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
mdevaney
Super User
Super User

@imrineeman 
If you are using a dropdown put this code in the Items property

your_excelsheet_name.your_column_name


Or if you are using a ComboBox put this code in both the Items property

your_excelsheet_name


Then put this code in both the DisplayFields and SearchFields properties

["your_column_name"]



If you still do not see any results you might need to refresh your datasource (excel sheet).  To do this, find your Excel sheet on the left-side menu, click the 3 dots beside it, then select Refresh.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

I've added screenshots. when I click the dropdown box it wont show any values..

Capture.JPG

Capture2.JPG

I can't understand why it wont show the values..

Hi @imrineeman 

What you've set up there looks correct to me.

To diagnose this further, could you add a data table control to your screen and set it up so that it displays your project and code fields?

If the data table control doesn't show any rows, that would suggest to me that is a problem with the data connector. In this instance, one of the first things to try is to refresh your Excel data source through the View > Data sources menu item.

Pstork1
Dual Super User III
Dual Super User III

Try switching the value property to Project instead of Code and see if that helps.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
v-qiaqi-msft
Community Support
Community Support

Hi@imrineeman,

Based on the issue that you mentioned, do you want to populate the Dropdown with the 'Project' column or 'Code' column?

Could you please share more about your scenario, what is your data source name, is it called Project too? Please make sure that you have connected to the correct data source.

070603.png

I have a test on my side, please take a try as below.

Add a Dropdown and set the Items property as below.

 

Table1.Project   //You can replace Project with Code here if you want to.

 

If the Dropdown still doesn't show values. Please try to use FirstN(), if you have 3 items in 'Project' column, please set the Items property as below.

 

FirstN(Table1,3)

 

Note: "N" means how many items you want to display in the 'Project' column.

You can check the GIF for reference.

0706Gif.gif

Best Regards,

Qi

Best Regards,
Qi
rsanya
Helper II
Helper II

@imrineeman First delete the connector and add again and then create a new screen and navigate back to the screen you have the drop down placed.

v-qiaqi-msft
Community Support
Community Support

Hi@imrineeman,

Have you solved your issue? 

if it solved your issue consider Accept it as the solution to help the others find it more.

Best Regards,

Qi

 

 

Best Regards,
Qi

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,359)