Answered

Simple combo box displaying wrong numbers

(0) Share

Report

Posted on by CU20081159-0

Hello

I am creating a custom page, and in that custom page I want a very simple combo box that is nothing more than a dropdown with the number 0 to 3. So no reference to any data or whatsoever. It keeps on giving me random sequential numbers.

In Items I have tried to put [0, 1, 2, 3]. Result is 0,1,3,5,7.

I have tried using Sequence(4,0,1) and that gives me result of 968, 969, 970 , 971.

Sometimes in preview it also jumps to 2153, 2154, 2155, 2156. I have no idea where those sequences come from, give I have not made any reference to any table of data.

Anyone got an idea? Thanks for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Kushal_M 197 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hello CU20081159-0,

By default, a Combo Box is designed to work with records (tables of data) and will try to “guess” which field to display.

If you just pass it a plain list like [0,1,2,3], it sometimes interprets that as records with hidden IDs behind the scenes — which is why you’re seeing those strange sequential numbers (968, 969… etc.).

To fix this, wrap the numbers as records with a Value column like below formula.

Table({Value:0}, {Value:1}, {Value:2}, {Value:3})

To make it dynamic, you can make use of the below formula.

ForAll( Sequence(4, 0, 1), {Value: Value} )

Please let me know, if this works for you.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @CU20081159-0

Is there any reason you cannot use strings there instead and convert it later? There are other ways as well.

Create a JSON that has the string version and value version. Then do a lookup to get the value version based on the Selected string version.

Also is this the Class or Modern Control as you mentioned Drop Down.. If its the Modern Control then I would delete it and not use it as its not out of preview yet. You need some wasp spray for the bugs they still have ;-)

All sorts of cooky ways but I wouldn't use the Modern though either way

Was this reply helpful? Yes No
CU20081159-0 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Michael E. Gernaey

Thanks for the reply! Well, I could use strings, but it auto-identified the data type. It seems like a whole bunch of extra steps to create a json and pick up values from there, when I just want to display 0,1,2,3 :-).

I use the combo box control to create the dropdown, because in custom pages there is simply no drop down control available. So I am limited there. It's strange that I just cannot fill it with "non-data" related static values.

@Kushal_M, thanks heaps for your suggestion. You are indeed right that it refers somehow to records that are not there.

Unfortunately, neither the Table({Value:0}, {Value:1}, {Value:2}, {Value:3}) nor the ForAll( Sequence(4, 0, 1), {Value: Value} ) did the trick.

It keeps on displaying a random sequence, although it seems like it does interpret the formula correctly, the result is not reflected

Result:

So it keeps on looking indeed for record values that do not reflect the 0,1,2,3. Any other tips or suggestions that might help?

Thanks heaps for the advice!

Was this reply helpful? Yes No
Suggested answer

anuragporwal 71 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Likely cause: the ComboBox Items is a simple array like [1][2][3], but DisplayFields/Value/IsSearchable settings make it treat each item as a record, so it renders unexpected text (e.g., blank or wrong numbers), or it’s a multi-select ComboBox which formats numbers as text.

Fix fast:

- For a plain number list, use a Dropdown (simpler) with:

Items: [1][2][3]

Value: Not needed.

- If ComboBox must be used:

- Set Items: ForAll([1][2][3], {Num: Value(ThisRecord.Value)})

- Set DisplayFields: ["Num"]

- Set SearchFields: ["Num"]

- Set SelectMultiple: false (if single pick)

- To get the number: ComboBox1.Selected.Num

Please ✅️ 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 ❤️.

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,221 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @CU20081159-0 ,
i tried to replicate the Combo box with your scenario, it is working as expected , can you please share the snippet of combobox properties which you have defined ?
Sequence:

[0,1,2,3] method:

Was this reply helpful? Yes No
CU20081159-0 16 on at

Like (0)

Report
Copy link

Link copied!

Dear Power Apps 1919

Thank you very much for the reply. Let me please share the details with you. If I use exactly the same "Items" as you, I get as result 1,3,5,7. I also tried inserting a new combo box , but same result:

Here are the properties, do you see anything off? Seems like most is default:

anuragporwal, thanks for your suggestion, but as you see from the printscreen above, those options are not available in the combo box. Please note that I cannot use a drop down, because I am creating a custom page and not a canvas app. Strangely enough the options are different here. So I am still quite stuck on how to create a simple drop down from 0 to 3 in a custom page.

Thanks for the help.

Was this reply helpful? Yes No
Verified answer

Gregger 24 on at

Like (1)

Report
Copy link

Link copied!

Hello @CU20081159-0

"If you are using a modern combo box, please check which field you are referring to.

The Sequence() formula outputs a table with one column named 'Value.':

You should refer to that column as a field in your combo box property panel. See the screenshot below:

2 people found this reply helpful.

Was this reply helpful? Yes No
CU20081159-0 16 on at

Like (0)

Report
Copy link

Link copied!

@Gregger that was exactly what I was looking for. Apparently, even though we are not working with a table, to display the sequence correctly 0,1,2,3,... you need to add a field defined as a text column. This ensures that the numbers are correctly displayed.

Thank you all for your replies, you have helped me tremendously!

Was this reply helpful? Yes No
Power Platform 1919 2,221 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU20081159-0, Glad, you found the solution, you are looking for.

Was this reply helpful? Yes No