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

(0) Share

Report

Posted on by johnjohn123

3,506

I have the following parsed JSON:-

{
 "?xml": {
 "@version": "1.0",
 "@encoding": "utf-8"
 },
 "RepeaterData": {
 "Version": null,
 "Items": {
 "Item": [
 {
 "ArticleInput": {
 "@type": "System.String",
 "#text": "33333333"
 },
 "ArticleDescription": {
 "@type": "System.String",
 "#text": "desc33333"
 },
 "ArticleReturnable": {
 "@type": "System.String",
 "#text": "YES"
 },
 "Qty": {
 "@type": "System.Double",
 "#text": "1"
 }
 },
 {
 "ArticleInput": {
 "@type": "System.String",
 "#text": "33333333"
 },
 "ArticleDescription": {
 "@type": "System.String",
 "#text": "desc33333"
 },
 "ArticleReturnable": {
 "@type": "System.String",
 "#text": "YES"
 },
 "Qty": {
 "@type": "System.Double",
 "#text": "11"
 }
 }
 ]
 }
 }
}

now i want to create a sharepoint list item, and assign the Qty field, so i tried the following formula:-

float(items('Apply_to_each_2')?['Qty'])

but i got this error:-

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Hi there,

It looks like you are trying to apply your float to an Object (Qty), rather than to the "#text" inside of each Qty.

I was able to get the Qty text out with this:

float(body('Parse_JSON')?['RepeaterData']?['Items']?['Item'][1]?['Qty']?['#text'])

(Parse_JSON is because I initialized a variable with your JSON payload, then parsed it, and used that. I selected the "Items" from the parsed JSON into the Compose.)

You can see that I have a "1" in there - you'd need to do an "Apply to each" on that bad boy with an incremented value.

I hope that helps.

Cheers,

Rhia

Was this reply helpful? Yes No
Paabl00 9 on at

Like (0)

Report

In the event that the error is the same but the field is of type date, which is what should be done??
Unable to process template language expressions in action 'Create_item' 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.'.

THIS IS THE EXPRESSION
formatDateTime(addDays('1900-01-01',add(int(item()?[<FIELD NAME>]),-2)),'MM/dd/yyyy')

Please Help

Was this reply helpful? Yes No