Format currency inside action Create HTML Table

(0) Share

Report

Posted on by RicardoaGomes

I am trying to format a string to currency in a "Create HTML Table", using the following flow:

Where

Value	float('2021.12') -> just for testing
Value_2	concat(string(item()?['Amount']),'€')

I got the following result:

I want to have the 'Value_2' format like the following 961 600,11€, when using the expression:

formatnumber(float(item()?['Amount']), 'C', 'pt-PT'), I get the following error:

"The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'."

Tried several alternatives and type conversion but the error is allways the same.

Is it possible to convert a string to currency inside action 'Create HTML Table' ?

Thanks for your support

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RicardoaGomes

"€" concatenation is not required in this case for formatNumber conversion.

formatNumber Syntax:

Sample flow:

Output:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Regards
Kaif

Was this reply helpful? Yes No
RicardoaGomes 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Kaif,

The concat(string(item()?['Amount']),'€'), was just a workaround because the expression formatnumber(float(item()?['Amount']), 'C'), is not working inside the action 'Create HTML Table' (cloud be because of the formatnumber or the float)

if I do this:
where Value=item()['Amount'], the result is:
If I use Value=float(item()['Amount']) I get the following error:
"The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type."

If I try to use the formatnumber directly (without the float) Value=formatNumber(item()['Amount'],'C2')
"The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'."

So if item()['Amount'] works ok, why the flot or formatNumber does not?

Thanks for your support

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RicardoaGomes

So basically you are facing two issues:

1. Why float is not working ?
- I think item()['Amount'] returns a number value. but float() supports string value as input parameter. so when you write float(item()['Amount']) gives error.
Use isFloat() expression to check the output value is floating-point number or not.

2. Why formatNumber is not working ?
- It supports number but input value is string.

I would suggest check input value datatype. If required, convert the datatype as per requirement.

Regards
Kaif

Was this reply helpful? Yes No