Answered

How to remove comma from an integer

Like (1) Share

Report

Posted on 13 Jul 2022 04:55:44 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.

All responses (17)

Answers (2)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on 15 Jul 2022 at 08:06:48

Like (1)

Report

Re: How to remove comma from an integer

@svivek see your expression-

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

@Hardesh /Gopenly.in
svivek 65 on 15 Jul 2022 at 08:04:53

Like (0)

Report

Re: How to remove comma from an integer

@Hardesh15 .Apologies .Yes I am new to power automate and this community.
I have shared the flow screenshot below:
Hardesh15 7,087 Super User 2024 Season 1 on 15 Jul 2022 at 07:34:17

Like (0)

Report

Re: How to remove comma from an integer

@svivek pls share format number screen and expression.

I will simply ask one question from you what do you understand just sharing output? are you new to power automate? OR just started using automation. Such question helps us to give solution in that way.

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

@Hardesh /Gopenly.in
svivek 65 on 15 Jul 2022 at 07:19:07

Like (0)

Report

Re: How to remove comma from an integer

@Hardesh15 Noted and thanks the expression has been accepted now. However when i am running the flow then following error is shown. Pls advice
Hardesh15 7,087 Super User 2024 Season 1 on 15 Jul 2022 at 06:51:54

Like (0)

Report

Re: How to remove comma from an integer

@svivek Still your expression is wrong. See comma is missing.

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

@Hardesh /Gopenly.in
svivek 65 on 15 Jul 2022 at 06:47:02

Like (0)

Report

Re: How to remove comma from an integer

@Hardesh15 Pls refer below flow:
Hardesh15 7,087 Super User 2024 Season 1 on 15 Jul 2022 at 06:30:20

Like (0)

Report

Re: How to remove comma from an integer

@svivek Also why extra quotes around output()- 'outputs('Compose')' you need to use only outputs('Compose')

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

@Hardesh /Gopenly.in
Hardesh15 7,087 Super User 2024 Season 1 on 15 Jul 2022 at 06:27:04

Like (0)

Report

Re: How to remove comma from an integer

@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
svivek 65 on 15 Jul 2022 at 06:20:43

Like (0)

Report

Re: How to remove comma from an integer

@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?
Hardesh15 7,087 Super User 2024 Season 1 on 15 Jul 2022 at 05:51:12

Like (0)

Report

Re: How to remove comma from an integer

@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