Formatnumber expression can't be a variable or value from Microsoft Form ?

(0) Share

Report

Posted on by GreguS

173

Hello,

i try to convert number to money

if i write 13000, i want 13 000€

the expression : formatNumber(variables('rem'),'### ###€')

error details : Unable to process template language expressions in action 'Initialize_variable_2' inputs 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.'.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Pstork1 69,121 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

make the variable type a number or put the variable inside a value() function to cast it to a number when using it. You can't use FormatNumber() on a string. It has to be a number of some kind.

Was this reply helpful? Yes No
GreguS 173 on at

Like (0)

Report
Copy link

Link copied!

thank you for your reply @Pstork1

but i don't understand how to convert to number, i don't find a expression value

Was this reply helpful? Yes No
Pstork1 69,121 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Sorry, my brain was thinking Power Apps. For Power Automate you need Float() to convert a decimal number and int() to convert an integer.

Was this reply helpful? Yes No
GreguS 173 on at

Like (0)

Report
Copy link

Link copied!

i have found this and it's good for variable, i don't know if it's possible with my form

Was this reply helpful? Yes No
GreguS 173 on at

Like (0)

Report
Copy link

Link copied!

I have use this : formatNumber(int(outputs('Get_response_details')?['body/r951198f4776b49bfa11c7446eac83bd2']),'### ###€') for convert number to money

but now i have a new error for populate my sharepoint list ...

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/R_x00e9_mun_x00e9_ration' is required to be of type 'Number/double'. The runtime value '"18 000€"' to be converted doesn't have the expected format 'Number/double'.

Was this reply helpful? Yes No
Pstork1 69,121 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Use Float() in place of int(). The input needs to be a floating point number not an integer.

Was this reply helpful? Yes No