Hello Team,
I'm trying to apply a filter to information extracted from an excel file (List Rows) and put into an HTML table that will then go into an email. The file is being used as a quote sheet, so sometimes a row will be blank if the customer doesn't want the item. I'm trying to use the Filter Array option to filter out empty rows by only showing items with a value grater than 0. I've used the int(item()?['Quantity']) expression in the filter criteria, but I'm getting the below error message.
InvalidTemplate
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@greater(int(item()?['Quantity']),0)' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
I should note that the column I'm trying to pull from in excel is using data validation to provide a drop down list of possible selections, not sure if that would require a different type of conversion? I could use another column within the file, but it pulls in a decimal and the excel file does contain a formula to return "" if not valid.
Any help is appreciated! Thank you!
