Unanswered

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

(0) Share

Report

Posted on by 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 ?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
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'])

Was this reply helpful? Yes No
Arsen_M 6 on at

Like (2)

Report

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:'(

Was this reply helpful? Yes No
1powerbiaccount 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Amol_51 6 on at

Like (0)

Report

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'])

Was this reply helpful? Yes No
Amol_51 6 on at

Like (0)

Report

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'])

Was this reply helpful? Yes No
Amol_51 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
GT_27 2 on at

Like (0)

Report

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

Excel COI File Sa...

Powerautomate - C...

Was this reply helpful? Yes No