Missing options in dropdown

(1) Share

Report

Posted on by jlke-as

130

I have a canvas app based on Dataverse tables.

I have a dropdown in the app where the "item" is

Filter(Varer;VarerAktiv="Ja")
 
However when I would like to choose which columns to show in the dropdown the values doesn't include all the columns in the table called "Varer"
These are just a part of the colums that the table contains... Why can't I choose all of them..?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jlke-as,

You can only use Single Line of Text columns for either of those two functions.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
MiigR 2 on at

Like
a
(0)

Report
Copy link

Link copied!

You would need a Gallery if you want to display more than one column from the table Varer. You could add it to your component library once you add the functions to make it act like a dropdown and use the selected item to feed into whever you need to feed the data from the dropdowm. Dropdowns are only able to display lists with 1 column.

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jlke-as

You can only display text values in a drop down.

If you want to display any of the other fields, you would need to convert them to text.

As an example, lets say you want to display LowerStockLevel in the dropdown. To do this, you would set the Items property of the dropdown to the following.

Filter(AddColumns(Varer; LowerStockLevelText; Text(LowerStockLevel) ); VarerAktiv="Ja" )

You can then display the LowerStockLevelText column in your dropdown.

Was this reply helpful? Yes No