Answered

SharePoint field type conversion error

(0) Share

Report

Posted on by nahcyrret

115

I have a SharePoint field of type text that get the value from the calculate of add(). After that I try to get that SharePoint field and convert to integer int() for another calculation. However, I get the error below. How to fix this?

Unable to process template language expressions in action 'VM_Charge' 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.'.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @nahcyrret ,

It means the value of int parameter is wrong. It cannot be converted to the int type. Please check it.

Best Regards,

Wearsky

Was this reply helpful? Yes No
nahcyrret 115 on at

Like (0)

Report
Copy link

Link copied!

It is a integer number in SharePoint text field. I wonder why it can't be convert back to integer using int().

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @nahcyrret ,

I don't know what's going on with your flow.

If you save the value directly without Int, will it work?

Best Regards,

Wearsky

Was this reply helpful? Yes No
nahcyrret 115 on at

Like (0)

Report
Copy link

Link copied!

The VM Charge text field is first populated from value of another SharePoint field(I have tried both text and number type). You can see the 0 value. After that compose of VM Charge is int(VM Charge) that got the error. See if you can actually reproduce it?

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @nahcyrret ,

My flow ran successfully. Please see the figures.

What's the difference from my flow and yours?

Did I understand your flow correctly? 🙂

Best Regards,

Wearsky

Was this reply helpful? Yes No
nahcyrret 115 on at

Like (0)

Report
Copy link

Link copied!

It is not directly having a value in the Title field. The Title field should be populated from another SharePoint list field with the value 0 first.

Was this reply helpful? Yes No
Verified answer

nahcyrret 115 on at

Like (0)

Report
Copy link

Link copied!

I know the problem. I should get item from the SharePoint list again after it has been updated in order to use that updated value. I get the value from create item for SharePoint list which has not been updated yet and the value is null.

Was this reply helpful? Yes No