You’re offline. This is a read only version of the page.
60
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?
Hi @Stacey_T
if it worked
Mark it as solution so it helps others 🙂
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! 🙌
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 🙂
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! 🙌
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
