trouble with currency format excel

(0) Share

Report

Posted on by GeekAlf_Pro

402

hello,

i have a powerautomate that add lines in an excel table.

so far so good.

the trouble is that i have a currency value that is not "recognized", i need to enter the cell in excel to force the value.

in the screen shot, on the second line, the value is on the left, as if it was a raw value

i tried the following formula's in power automate, without success

concat(triggerBody()['Ajouteruneligneàuntableau_MontantCommande'],' €')

and

formatNumber(float(triggerBody()['Ajouteruneligneàuntableau_MontantCommande']),'C3','fr-FR')

thanks !

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you specify the format in the excel file itself so that power automate is only passing the raw value? Then Excel is the program that will display the proper currency format?

Was this reply helpful? Yes No
GeekAlf_Pro 402 on at

Like (0)

Report
Copy link

Link copied!

Hello @srduval

i also tried to set the currency format in the column in Excel if it is your question, but without success
it's in Excel that i need to display the value

Was this reply helpful? Yes No
Verified answer

srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!
I'll try to play with it later and see if I can get something to work, four more things to try:

One

1. Format the column in excel as the proper currency type

2. Run the concat version again, but without the space between the number value and symbol

concat(triggerBody()['Ajouteruneligneàuntableau_MontantCommande'],'€')

Two

1. Again format the column in excel as the proper currency type

2. do the format number method again

Three

1. Again format the column in excel as the proper currency type

2. Try doing the concat but converting the trigger body to float first like you do in the format number then try concating the currency symbol with and without a space and see what happens

four:

1. Again format the column in excel as the proper currency type

2. convert the trigger body to float and send that value no format, no concat, just float([value[)

float(triggerBody()['Ajouteruneligneàuntableau_MontantCommande'])

the result you posted with the values left aligned suggests excel was reading it as a text value, not numeric, which might happen anytime you try and pass a currency symbol with the numeric value, so my gut says you have to do something in excel to make it treat numbers and to make sure the value being sent from automate to excel is numeric.

Was this reply helpful? Yes No
GeekAlf_Pro 402 on at

Like (0)

Report
Copy link

Link copied!

hi,

i tried your 4 proposals, the last one works.
i had a french environment, and i had another problem with the "." and the "," but it's solved now.

thanks

Was this reply helpful? Yes No