You’re offline. This is a read only version of the page.
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.'.
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'.
Sorry, my brain was thinking Power Apps. For Power Automate you need Float() to convert a decimal number and int() to convert an integer.
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.
Share
Report
162
All responses (
Answers (
