Unanswered

'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.' But there are no nulls and IF Statement doesn't work!

(0) Share

Report

Posted on by Stacey_T

I'm trying to update a SharePoint list from an Excel file - both the Excel file and list have a column CTM BRO ID.
I'm trying to filter the Excel file for just recent data which happens to start at ID 898.
I have to go through these steps to convert the CTM BRO ID to a number and then use the filter array to get all of the IDs greater than 897. It works up until the Filter array step, where I am getting an error 'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.'. My Excel file does not contain any nulls/blanks, but if I try an IF statement to replace nulls with zeroes, I get a blank filter array output. What am I missing?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Stacey_T

I got it why error occurs

You should replace the select action like below

Because then only you will get output from select action like this

[

{"CTM BRO ID":898},

{"CTM BRO ID":899}

....

]

with your current flow output from select action should be like

[

{"897":897},

{"898":898}

....

]

Hope you got the idea 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Stacey_T 60 on at

Like (0)

Report

Oh wow, this is weird but also fantastic. Thank you!

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Stacey_T

if it worked

Mark it as solution so it helps others 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No