Not able to update sharepoint list using excel data

[skk638]

i created a simple flow to update sharepoint list using excel. both addition and creation of new items have same error.

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

couple of posts are already available but didnt get a solution

[DamoBird365]

Hi @skk638 

I would guess that you are using the expression int() to convert a string to an integer but the string you are supplying is null, empty or characters, that therefore cannot be converted to an integer.  Might be best to look at your history for the flow and check the dynamic value you are inserting into int().

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

[v-LilyW-msft]

Hi @skk638 

Has your problem been solved?

The error indicates that the parameter passed in function int() is not of type string. The conversion function int() converts any string to an integer if the parameter is not of type string then it throws an error.

The error also happen at times when the column that you are trying to convert contains blank values.

Assume that you have a column in excel called "Number" and you are trying to convert this to integer value, if the "Number" contains blank values then those cannot be convert and it gives the error. In this situation, you can try the following formula.

if(empty(items('Apply_to_each')?['Number']),null,int(items('Apply_to_each')?['Number']))

Hope the content above may help you.

Best Regards