Change Format Number #,#

(0) Share

Report

Posted on by nrd10

132

hi,

I have a column in sharepointlist and filter by array containing the number 12345, but I want to format it as 12,345.00. I've tried using the this function

formatNumber(item()?['InPlan'], 'N')

but it hasn't worked.

The screenshot below shows my current Flow.

Thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Chriddle 8,434 Super User 2025 Season 2 on at

Like (1)

Report

formatNumber(12345, 'N') works great and returns '12,345.00'

What exactly is the issue?

You have two different expressions in your description:

formatNumber(item()?['InPlan'], 'N')

and

formatNumber(item()?['In'], 'C')

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @nrd10

Pls try the below expression:

formatNumber(int(item()?['InPlan']), '#,000.00')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
nrd10 132 on at

Like (0)

Report

thankyou because of your question i know the error is because null value

Was this reply helpful? Yes No