Filter Collection if greater than Number value

[nrenaud1]

Hi,

I am reading from an .xlsx file into a collection with thousands of rows.  I want to then filter the collection by one of the column values (Column 12) if it is > 45.  However, all of the fields in the collection are of type Text. 

Is there a way to use Filter Collection action to do this ? I cant figure out the Text format and cant compare text values to numbers.

"'" & [Data.Column 12] & "'" & " > 45"

Tryng to do something like this ?

Thanks!

[Soumya21]

Hi @Nick R

After taking data from excel. you can convert data type of column which is in text to number. Later you can put filter for values
Create action for converting data type
Please follow images 

​
Thanks,
Soumya