Power Platform Community Forum Thread Details

INSERT ROW (V2) : cast number in string type to INT and get rid of the thousand separation point in the same process (Form Recognizer Json)

Hi everyone,

I'm stuck at finding a solution to transfer the content of a Form recognizer Json custom form (invoices) to an SQL server database.

Every item returned by the json payload, even the number are in string format.

I want to extract every price and total price of every invoice by iterating in a for each loop, after parsing the JSON.

I firstly used the int() function and it was working great on number like: "434,45" (code below)

@{int(items('For_each_6')?['valueObject']?['price']?['content'])}

But after trying to extract an invoice where the price number contained thousand, my problem started because of the housand separator point:
Ex : 1.434,45

So, i tried to use both function replace() and int() at the same time to replace the point by a blank space in every items and cast to INT but i don't think the two actions can be done at the same time:

@{int(replace(items('For_each_6')?['valueObject']?['price']?['content']),".","")}

I'm using a logic app flow and its impossible to copy/paste this expression in the logic app SQL Insert row (V2) form
Any idea of a method to get rid of these point and send the data to an Integer SQL server database column?

sql insert row problem str to int.png