Get Items Filter Query Error

(0) Share

Report

Posted on by MitchTer

Good Day,

Please Help! I am new to this and am very stuck.

I am trying to build a basic flow that checks the property leases our company has. I want to trigger an email when the expiry date less the notice period in months is greater than or equal to today. I have tried many different options but can't seem to overcome this.

I receive this error message:

Unable to process template language expressions in action 'Get_items' inputs at line '1' and column '15191': 'The template language function 'mul' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#mul for usage details.'.

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @MitchTer,

The error talks about the mul function. However, in your screenshot I don't see any mul function.

Can you share the expression you are using in that filter query. I am assuming your are using a mul function within that adddays expression?

Was this reply helpful? Yes No
MitchTer 30 on at

Like (0)

Report

Hi @Expiscornovus

Thanks for the reply, I am using the mul function. We have the notice period in months and I am trying to multiply that by -30 to get the days. I have added in the function below

addDays('Lease_x0020_expiry_x0020_date',mul('Notice_x0020_period_x0020_in',-30),'yyyy-MM-dd')

Thanks so much!

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @MitchTer,

Can you try this expression logic instead. I have added an int function to convert the string to an integer.

addDays('Lease_x0020_expiry_x0020_date',mul(int('Notice_x0020_period_x0020_in'),-30),'yyyy-MM-dd')

Was this reply helpful? Yes No
MitchTer 30 on at

Like (0)

Report

Hi @Expiscornovus ,

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

I took a screen shot of the column settings in case that may play a role?

Was this reply helpful? Yes No
MitchTer 30 on at

Like (0)

Report

All of the records do have a value in and they are either 1, 2 or 3

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @MitchTer,

I need to get my morning coffee 😅. I had a better look at your first screenshot. I think we need to use a different approach, my bad.

You are referring to fields of the Get Items action itself and not dynamic content from any of the previous actions. As far as I am aware the filter query field doesn't support these kind of expressions.

Another approach would be to try and add a condition action after the Get Items action and do the comparison over there with utcNow.

Was this reply helpful? Yes No
MitchTer 30 on at

Like (1)

Report

Hi @Expiscornovus

Thanks so much - I was able to get it right as you suggested. Hope the coffee was good!

Was this reply helpful? Yes No