Unanswered

Convert EU format number to US format number

(0) Share

Report

Posted on by rameshmukka

1,133

I would like to input 12.348,55 and get output as 12,349.55. Basically converting EU to US format. The action "Format Number" doesn’t like the input number and throws “Enter a valid number”. How do I deal with this? Do we have other ways to deal with this?

Thanks and Best Regards,

Ramesh Mukka

Categories:

General topics

All responses (8)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Following this topic, i have the same issue actually. I have a list of values mixed with EU and US format, i need to convert the EU values to US
PowerPuffKK 316 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RameshMukka @Anonymous ,

In the 'Format' input field, please could you click on the dropdown and click 'Enter custom value'. Then paste this:

###,###,###.0

and let me know if it solves the issue?

If it does, please mark it as a solution for future forum visitors 😊

Kristine
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

What if i have a list of values with EU and US format, how can i apply in the flow that the US ones should be skipped and only the EU formats to be formatted
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

What if i have a list of values with EU and US format, how can i apply in the flow that the US ones should be skipped and only the EU formats to be formatted
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have tries your resolution PowerPuff, it still says enter a valid number
Barret 652 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
I had to deal with this a year or two ago and my eventual solution (extremely inelegant, but it worked) was to iterate the values and for each one:
convert value to string
Use lastIndexOf function to search to find the last position of comma and period characters
If the comma value > period value, then it's a European number, else US number and convert accordingly
Not a great solution, but it worked. I would love for something better to be out there
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Barret, can you perhaps send a screenshot of the workflow with the expressions? I just started with power automate
Barret 652 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I don't have the flows anymore. They were for a client I no longer work with.