Power Platform Community Forum Thread Details

Greetings to all:

I have a situation with my PowerAutomate, my process is to upload a two column date from Excel to SharePoint.
seeing several examples of how I can do it. But this is throwing me an execution error, if you can help me to finish my work. I can thank you.

This is the error that tells me:

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

Pawer Automate.PNG

Categories:

General topics

@icq2102

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.

This can also happen at times when the column that you are trying to convert contains blank values, let us consider that you have a column in excel sheet called "Age" and you are trying to convert this to integer value, if the "Age" contains blank values then those cannot be convert and it gives an error. To tackle the blank value scenario you can make use of the below expression.

if(empty("Age"),null,int("Age"))

The above expression tries to compare the value in age column and if it's empty then we get a null there else we will get whatever value that was present in Age column converted as an integer.

------------------------------------------------------------------------------------------------------------------------------

If the information shared helps, please consider giving a thumbs up 👍 and mark solution as resolved