cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adamrigby
New Member

Invalid Template error

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

 

adamrigby_0-1641313138424.png

 

Below is a screen shot of my flow.

adamrigby_3-1641313624079.png

 

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

Thanks in advance,

 

Adam

5 REPLIES 5
jinivthakkar
Super User
Super User

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

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

 

adamrigby_0-1641393329880.png

 

hemrhk
Super User
Super User

@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
New Member

How do i do that?

hemrhk
Super User
Super User

@adamrigby 

Add a Compose action like below before the condition.

Compose.png

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. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,309)