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
thankyou because of your question i know the error is because null value
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.