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)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

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,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@tony_soprano_99

Can you post a screen shot of your Flow please?

Was this reply helpful? Yes No