Answered

ComboBox Fields Property not showing all fields from data source

(0) Share

Report

Posted on by David Brandman

294

I have a combobox that pull from a collection. However, when I open the Fields property to select the two row layout (or any layout actually), it only shows me a few of the fields to select from for that data source. Of course the ones I need are not showing. I have no idea why and if I highlight the Collection in the data source, it shows me those fields.

Items: SortByColumns(list_Port,"PortCode")

But in the Fields property box, it does not show all the fields from list_Port, yet if I highlight it in the formula, it shows them to me.

Tried creating a new combobox, same issue.

Any help would be appreciated. I've been tuck on this for hours. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (3)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dBrand

What kind of columns are the ones that are missing that you want?

Was this reply helpful? Yes No
Digital 1,207 on at

Like
a
(1)

Report
Copy link

Link copied!

Try using ShowColumns to only show those columns you are interested in displaying in the ComboBox.

Was this reply helpful? Yes No
David Brandman 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Text and Integer. Odd thing is the fields uit does show are a mixture of text and Integer fields as well.

Was this reply helpful? Yes No
David Brandman 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried this just now. It only gives me the first field in my ShowColumns as an option now in the 'Fields' property.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Only text fields are supported:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dBrand

ShowColumns is not going to help in your scenario. That would restrict columns to only those specified. Your scenario is that you are not seeing columns that are already there - and would already be showing.

Can you provide a screenshot of what you are seeing? What is the source of list_port also?

Was this reply helpful? Yes No
Verified answer

David Brandman 294 on at

Like
a
(0)

Report
Copy link

Link copied!

That may be the issue. I rechecked my field types and only the text fields are an option (I was mistaken in my previous response).

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dBrand

That is where I was going with the last question...because you should not have seen integer fields, but you stated that you were seeing them!

Was this reply helpful? Yes No
David Brandman 294 on at

Like
a
(0)

Report
Copy link

Link copied!

I rechecked and was incorrect. Only the text ones are showing. I will have to find a work around or change the field type. Thanks.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@dBrand

Then you can simply add to the Items the types you want.

Ex. Items property:

AddColumns( SortByColumns(list_Port,"PortCode"), "_intAsText", Text(yourIntColumnName), ...etc... )

Then you will have them available in your fields list.

Was this reply helpful? Yes No