Answered

Create drop-down menu based on Excel table

(0) Share

Report

Posted on by DoelliJ

Hi,

I am currently trying to link a drop down menu with a column from an excel table. In the end, the elements which are shown in the drop down list from which the user of the app can choose should be the one's which are stored in the excel table. I do not want to use any prefab design that was created based on my data source.

I saved my excel file in OneDrive and added it as a data source to Powerapps.

I have tried to do the linking by inserting table-name and column-name in items and value field, but nothing happens.

Can somebody help me with this topic?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

If your Excel Table has powerAppId and you have already connected to the App, on the Items property of the Dropdown put;

TableName.Column

If you are not sure, show a screenshot of the excel Table.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
DoelliJ 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply @eka24 ,

this is an exmple of an Excel table I have created:

My aim is to have drop down menus in powerapps that are named: Business Unit, Market and Language. When I click on them I would like to have the options to choose from which are in this table which is called "Table1". For example, when I click on drop-down menu "language" it should be possible to choose from German, English, Chinese etc.

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Your Excel doesn't have a PowerAppId as l said earlier. Kindly watch this tutorial;

https://youtu.be/-Z_13J02RPU

After getting the Id use the formula I gave for the dropdown

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
IMathur 291 on at

Like (0)

Report
Copy link

Link copied!

HI @eka24 ,
Thanks for the solution, in my case, i have similar case, just that , i am using switch case for a dropdown, based on a gallery value selected. Please see below for more details for my query link:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Create-Dropdown-list-from-different-columns-of-a-table-from/m-p/954128#M303079

Thanks

Was this reply helpful? Yes No
matix003 64 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 I have powerAppid in my excel table and I am getting the dropdown values. How do I remove duplicate values from the dropdown list?

Was this reply helpful? Yes No