Unanswered

How to remove comma from an integer

(1) Share

Report

Posted on by svivek

I have a question: Is it possible to remove comma from a number value and convert that decimal number to whole number in power automate platform. For example: I want to convert 1,27.89 to 128. Here I want to remove comma after 1,2XX and covert the decimal number 127.89 to 128. Please note that the value should remain as integer only and not string.

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (2)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@svivek Pls use format number action. First make it proper float number by removing comma. use replace().

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
svivek 65 on at

Like (0)

Report

Hi Hardesh,
Actually I am getting an integer value (it is variable integer it can be 1,000 or 12,78.9 etc.) from a PDF extractor.
I am using this variable integer in a format number function. And in the format row I have added "#######" as suggested by you as solution. However I am getting an error. Pls help (refer below screenshot for details)

Unable to process template language expressions for action 'Format_number' at line '0' and column '0': 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'. Please see

Was this reply helpful? Yes No
Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@svivek do as suggested by @Hardesh15 but before that try to convert the value in integer using the int() expression
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@svivek It means you are passing string value rather than float. Convert your number into float type.

1. Use compose and replace all comma using replace() function in capacity.

2. Initialize one float variable and pass compose output with float().

3. Then pass float variable into number format.

I can suggest this in one step but that you may not understand.-

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
svivek 65 on at

Like (0)

Report

Hi @Hardesh15 ,

I tried using float type as suggested above. However it is showing "Invalid expression"

As per your suggestion I have used float by placing "variable as highlighted in red font below. Here the red font variable is coming from PDF extractor. Also I would like to highlight that this variable can have comma anywhere in number and I understand this float expression should be able to remove comma placed at any digit of a number :
Synatx as suggested : float(replace('variable',',','))

Synatx actually used in power automate:
float(replace('outputs('PDF_Extractor')?['body/responsev2/predictionOutput/labels/Capacity554fecb051bb0b706c621d503cf5f5d6/value']',',','))

Pls advice.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@svivek Your expression is wrong.

Replace('Your Output', 'part of your output you want to replace', 'replacement value')

Part of your output you want to replace : in your case it is comma

Replacement value: nothing means quotes without space ''

Your expression:

Float(Replace(outputs('PDF_Extractor')?['body/responsev2/predictionOutput/labels/Capacity554fecb051bb0b706c621d503cf5f5d6/value'],',',''))

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
svivek 65 on at

Like (0)

Report

Hi @Hardesh15

Still it is showing expression is invalid. I have provided a detailed screenshot for clarity what I am exactly typing in expression editor which is leading to invalid expression. Not sure where am I going wrong.
float(repalce('outputs('Pump_Datasheet_Value_Extractor')?'body/responsev2/predictionOutput/labels/Flowrate/value']',',',''))

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@svivek Do one thing use one compose and pass your pump data value in it. Then try it. Also sometime you have opened tab for long time it cached previous session. So refresh your tab and then try.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
svivek 65 on at

Like (0)

Report

@Hardesh15 tried closing tabs and started a fresh session.
Additionally created compose and passed on the string value to format number function as :
float(replace('outputs('Compose')',','''))
Still it shows expression in valid.
Is there any other option?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@svivek Pls share screen with expression.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No