Unanswered

How to use formatNumber() with an array of values from a excel file

(0) Share

Report

Posted on by tony_soprano_99

Hey everyone,

I'm working on a project and need to display an array of prices in an html table formatted correctly. I've read about the formatNumber function which seems to convert a value to a specified currency. When trying to utilize this function I've run into a compile error.

What I want to do is : formatNumber(item()?['Prices'], 'C2','en-US') but get the following error message: 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'.

I've tried to convert to an integer and float but had no luck. Was wondering if I could get some input.

Cheers.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@tony_soprano_99

Try wrapping your first parameter in a float() expression.

Was this reply helpful? Yes No
tony_soprano_99 2 on at

Like (0)

Report

Unfortunately this did not work, I entered:

formatNumber(float(item()?['Prices']),'C2','en-US') and was greeted with this error message: 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@tony_soprano_99

Can you post a screen shot of your Flow please?

Was this reply helpful? Yes No