Invalid Template error

[adamrigby]

Hi,

 I am trying to create a flow that checks data from a specific cell of an excel sheet, if it contains a mark higher than 8, it does one thing, if not it does another, but i keep getting the below error;

Unable to process template language expressions for action 'Condition' at line '1' and column '38836': 'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.'.

Below is a screen shot of my flow.

I am a novice user of automate, so i need answers to be as simple as possible please.

Thanks in advance,

Adam

[jinivthakkar]

@adamrigby please share snap of condition but as the error says the value you are trying to compare in condition is null, try passing any hardcoded numeric value (e.g 100) and try again it should work.

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

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[adamrigby]

Hi,

Below is the excel sheet that im using.

So a user completes a 365 form, the results feed into the excel sheet and grades it. The condition is, if "Total Correct" Column is >8 it sends an email with certificate if not it sends a email to retry. 

What do you mean by "try passing any hardcoded numeric value (e.g 100)"?

Thanks,

Adam

[hemrhk]

@adamrigby 

Print the expression(Before condition) in compose action, you are using in the condition and see whether it returns the value or not.

[adamrigby]

How do i do that?

[hemrhk]

@adamrigby 

Add a Compose action like below before the condition.

Copy and paste the expression or value you have inserted in the condition. Run the flow and see whether it returns value or not.

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

If it solved your problem give a kudo and accept it as a solution. 

Follow and Subscribe 365 Stack for more updates.