Formatting texts and values

(0) Share

Report

Posted on by Fernanda

380

Hello!

I am having a brain meltdown right now with regional number formatting.

I live in Chile, so my number formatting is commas for decimals and dots for thousands.

My flow is populating a word (I have the premium connector) with information from a Sharepoint (this sharepoint gets populated from a power Apps)

My drama began in PowerApps because of the **bleep** keyboard, but it was solved and it is working (I had to use substitutes to work around the problem)

So, I am patching the Sharepoint list with values from PowerApps, but my list is set as Text (otherwise stupid comma gets replaced by dots and it is all a mess)... and this shows me the info as I need it.

When I run my flow, I get the data perfectly if I use

string(items('Aplicar_a_cada_uno')?['field_7'])

... BUT... there is one more format I need for the word. And that is adding the dot for thousands.

Meaning, in column Consumo, my populated word should show 3.265,15, and if it a round number, no comma to be shown.

And here my brain just melted... I tried splitting the string and give it format only to the first part of it, but couldn't do it.

Can you help me, please??? I am totally stuck

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

You should use Format Number using the connector or as an expression. See example below using the connector (not sure if I got the exact locale).

The result after running the flow:

See further details here.
Standard numeric format strings | Microsoft Learn

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Fernanda 380 on at

Like (0)

Report
Copy link

Link copied!
Hello!
It won't work, because my SP List is fixed as Single Line Text
Unable to process template language expressions for action 'Formato_de_número' 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 https://aka.ms/logicexpressions#FormatNumber for usage details.'.

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
You can use the following formula to convert the string representation of the number to a float.

float(replace(replace(variables('number'), '.', ''), ',', '.'))

Or using an expression to format the number.
formatNumber(float(replace(replace(variables('number'), '.', ''), ',', '.')), 'N', 'es-CL')

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Fernanda 380 on at

Like (0)

Report
Copy link

Link copied!

Hi!.. it didn't work. I can't iniciate a variable from a Get Items Action... Apply to each won't let me

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

Inside your loop you would be retrieving the value from your field and wrapping that inside the expression instead of using a variable.

Was this reply helpful? Yes No
Fernanda 380 on at

Like (0)

Report
Copy link

Link copied!

it worked!!!
thanks a lot!!!
my brain was literally melted!

Was this reply helpful? Yes No