Unanswered

Convert text to currency

(0) Share

Report

Posted on by Kai_U_P

Hello everyone,

I want to create a flow that transfers data from Microsoft Forms to a Microsoft SharePoint list. In the form I have a field for entering an amount. Now when the flow starts, the following error message appears:

Unable to process template language expressions in action 'Verfassen' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

I have tried the following actions:

Initialize variables with type string
Compose with the expression int(variables('EK - Volumen'))
Convert numbers

I also tried to set the restriction to numbers in the form, unfortunately also no success. In this case the amount 0,00 € is entered as value in the list.

Does anyone have a tip on how I can build the flow so that the text is converted to a currency?

In the SharePoint list the column is also formatted as currency.

Thanks a lot.

Many greetings

Kai

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Kai_U_P,

In the screenshot I don't see how you are using the answer from the form question/response. Can you share a screenshot where you are setting your variable with this value?

I tried to reproduce your issue with the same setup. When I am input 0,00 as a string value in the variable it seems to work fine.

Below are screenshots of my test/repro.

1. The setup with the 0,00 value in the variable

2. The output of the flow run with a euro currency symbol.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Dear Expiscornovus,

Thank you very much for your response. I found the error in the flow. The problem was that I had not entered the form field as the value here.

Now I have another problem. As soon as I enter the amount in the form, it is transferred to the SharePoint list with incorrect formatting. Instead of 123,33, 12.333,00 is now deposited.

This is the result of the action get form details

This is the result of the action initialize variables
And this is the result of the compose action
I don't know, how I convert the input in the correct currency.

This is the form field for querying

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous,

That is because a comma is used to separate the euro cents (which is understandable, because that is a normal format in the EU). The format number action expects a dot for this. You can use a replace function for this.

Secondly, you are using an int function, which will convert the answer into a whole number. In that case try and use a float function, which support decimals.

Try this in your compose:

float(replace(variables('EK - Volumen'), ',', '.'))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hello Expiscornovus,

Please apologize for my late reply. unfortunately i did not have time to test your solution suggestion this week.

I've tested your suggestion and it worked 🙂 Thank you very much.

Have a nice weekend.

Kai

Was this reply helpful? Yes No