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

[Arsen_M]

Hi all,

I'm running simple flow, which send email notification if number of days left till current date (column7, or column 11) is less than 30 days.

Actually this flow works, but strangely it still shows such error:

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

What's wrong with it ?

[Expiscornovus]

Hi @Arsen_M,

The expression for the column7 looks ok. I assume you are using the same type of expression for the column11?

Alternatively, you could try and use the item function instead of the items function. Maybe that one does not give you an error.

That would be something like below in your setup:

int(item()?['column7'])

[Arsen_M]

Just returned to give update on that issue. Actually it was very simple - error was showing due to incorrect column type in Excel. File itself was provided by user who asked me to help, <column 11> was correct <Number> type, but <Column 7> was of <Date> type.  But I somehow missed checking and correcting that column type. And of course <Date> type couldn't be properly converted to <Int>. Mea culpa:'(

[1powerbiaccount]

I hav exactly the same issue; draing my time on it.

[Amol_51]

Tried all of the above solutions but still getting this error. Here's the formula I'm using 

int(items('Apply_to_each')?['Days Remaining'])

[Amol_51]

Hi there, I tried the solution you recommended but I'm still getting error. Here's the original formula I used int(items('Apply_to_each')?['Days Remaining'])

[Amol_51]

Managed to get my flow running again. The root cause was the flow could not recognize null values in the column. So filtered out rows with the null values in "Filter Query" field in "List rows present in a table" section by using following condition.

<column name> ne '<value>'.

[GT_27]

Tried the above suggested solutions and I still receive the error on my flow. I'm fairly new to this, so feedback is greatly appreciated. The objective of my flow is to send an email reminder based on dates in an excel table. The Column 26 is the date the initial email would have been sent (approval generates the 5 digit excel serial date) and I am wanting it to send a reminder email once 3 days has passed. 

The 'is equal to' condition expressions used are below. 

addDays('1899-12-30',int(items('Apply_to_each')?['Column26']),'MM/dd/yyyy')

subtractfromtime(utcNow(),3,'Day','MM/dd/yyyy')