Unanswered

How to change the formatting of the number lookup values shown in a combo box in power apps (Remove zeros shown in the decimal values)

(0) Share

Report

Posted on by HJ-12091456-0

Hi,

I have a calculated year column ( Based on a date column) in a SharePoint list which is a numerical number with zero decimal values. I have linked this field to a combo box field in power apps. But when it comes in power apps, it adds many zeros at the end. Can someone guide how to get the number values without these zeros. Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey @huxleyjose

can you try this please:

Value(Text(YourDataSourceName.Year, "[$-en-US]0"))

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
HJ-12091456-0 5 on at

Like (0)

Report

HI, I did as you suggested, but still showing a error, the screen shot indicated below, may be I am missing something here, please guide

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

might be the case that your column has a different name than year.

instead of .Year pick the column name that holds the year

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No