Getting a number to print with commas

(0) Share

Report

Posted on by TSprad

Greetings to all. New to the forum and a fairly new user to Power Apps.

I am pulling data from an Excel spreadsheet. Column 1 is a name, Columns 2-5 are numeric.

The app is pulling all of the data over fine, but my numbers are showing up like this 1526500 instead of like this 1,526,500

Currently that field is formatted like this Text(Parent.Default,"[$-en-US]###,###") still returning the value 1526500

What am I doing wrong?

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

mahoneypat 1,720 on at

Like
a
(0)

Report
Copy link

Link copied!

Your syntax is correct. I put the below in a label and it worked as expected. Where are you using the expression?

Text(1526500, "[$-en-US]###,###")

Regards,
Pat
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@TSprad

Just to be sure that your input value is numeric, I'd try including a call to the Value function to see if that makes a difference.

Text(Value(Parent.Default), "[$-en-US]###,###" )
TSprad 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response Pat. If I type in a number, like in your example
Text(1526500, "[$-en-US]###,###")
It works fine. But I am pulling the data (hence my formula containing the "Parent.Default" string) That is where it breaks.

To clarify, I am bringing over data from 5 columns in an Excel Table. My BrowseGallery is displaying each of our entities (12 of them) correctly (from Column1 of the table). When I select the > (from the BrowseGallery) it goes to each entities' page and it correctly brings up Columns 2-5 with a label (Column2) and a corresponding value which is correct, but missing the commas. It is in that field that I am using the syntax I referenced above.
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@TSprad

As I mentioned, the most likely course of this issue is that Power Apps has not recognised Column2 as numeric.

Did you try the formula that I suggested?
TSprad 10 on at

Like
a
(0)

Report
Copy link

Link copied!

timl,
Thank you for the response. Unfortunately, the formula you provided errors out and produces no value.
TSprad 10 on at

Like
a
(0)

Report
Copy link

Link copied!

timl,
Is there a way to force Power Apps to recognize a column as numeric?
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@TSprad

Can you clarify the error message that you see? It's quite possible that the input value contains text and Power Apps is unable to convert the input to a number. This would explain the cause of your initial question.

To make Power Apps properly recognise a column as numeric, the best approach is to go through your source spreadsheet and to make sure that none of the cells in your column2 contain non-numeric characters (including characters such as trailing empty spaces). I would then select the column and reapply a numeric format using the option in the ribbon bar.

If you then refresh the Excel data source from the view > data sources menu item in Power Apps, it should hopefully recognise your column as numeric.
TSprad 10 on at

Like
a
(0)

Report
Copy link

Link copied!

timl,
I appreciate your continued help on this. Here is what my data table looks like in Excel

And here is what I've got in Power Apps

This is not producing an error, but as you can see it isn't formatting as a number with commas either.