SharePoint field type conversion error

[nahcyrret]

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.'.

[v-xiaochen-msft]

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

[nahcyrret]

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

[v-xiaochen-msft]

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

[nahcyrret]

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?

[v-xiaochen-msft]

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

[nahcyrret]

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.

[nahcyrret · Accepted solution]

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.