format combo box numbers

[vffdd]

I have a combo box that is populated by a number field from a dataverse table.  T

The format of the numbers  in the table  shows correct for any numbers > 10    so 10.50    14.30 etc..

However for any numbers less than ten it drops the first zero.    7.40  etc.. I would like this to show as 07.40 in the combo box

The combo box filters a gallery and in the gallery I can format the label correctly but I need the combo box to match..

I've tried adjusting at the dataverse end but can't do that either..

Any ideas on how to achieve what I need?

EDITED TO ADD:  I can switch to a dropdown if it makes any easier I actually don't need any of the other functionality of a combo box

TIA

[FernandoTC]

Hi @vffdd ,

In the items property of the ComboBox/DropDown set the property to a table with a new text column based on that number field like this:

AddColumns(_myTable,"text_val",Text(val,"00.00"))

This works for me.

Remember to use the number field for the filter part of the gallery and keep the text field just as a visualization.

Hope it helps.

[vffdd]

Thanks @FernandoTC  I feel that would definitely work if I could just replicate it !! 🙂    Here's the current items property of the combobox, I can't quite manipulate it to get what you are showing above..

Distinct(Filter('mydataversetable',status<>"Closed"),TestingTimeFormats)

[FernandoTC · Accepted solution]

Hi @vffdd ,

This should do the thing.

AddColumns(Distinct(Filter('mydataversetable',status<>"Closed"),TestingTimeFormats),"text_val",Text(Result,"00.00"))

Also for better performance I would swap to a dropdown instead.

Regards

[vffdd]

That's it perfect.. thanks @FernandoTC