Issue: Filter variable number 1 also filters number 10

[Leu0101]

I have a number column in my SharePoint list. The numbers consist of 1, 2, 3, up to 99. When I set my number variable and try to filter, example number one, I am resorted to seeing records with number 1 and number 10. I only want to see any record with one and leave out 10. I am assuming that this would happen if I chose 3, 30 would also show. Is there a way so only the exact number will only show? Thanks in advanced!

[timl]

@Leu0101 

What formula are you using to do this? If the value of the variable of varNum is 1, the syntax below should return only the record where numCol equals 1.

Filter(YourSharePointList,
       numCol=varNum
)

[Leu0101]

I was trying Filter(YourSharepointList, VarNum in Text('numCol')) This was delegable, however would still display 10 in number column if search for 1. What I ended up doing, not sure if it was the best way to do it but it works atm: If(IsBlank(TextInput2.Text),If(VarBoxNumber = 1,SortByColumns(Filter(KeyDirectory,'Box Number' = 1),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 2,SortByColumns(Filter(KeyDirectory,'Box Number' = 2),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 3,SortByColumns(Filter(KeyDirectory,'Box Number' = 3),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 4,SortByColumns(Filter(KeyDirectory,'Box Number' = 4),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 5,SortByColumns(Filter(KeyDirectory,'Box Number' = 5),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 6,SortByColumns(Filter(KeyDirectory,'Box Number' = 6),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 7,SortByColumns(Filter(KeyDirectory,'Box Number' = 7),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 8,SortByColumns(Filter(KeyDirectory,'Box Number' = 8),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),
If(VarBoxNumber = 9,SortByColumns(Filter(KeyDirectory,'Box Number' = 9),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"]),SortByColumns(Filter(Filter(KeyDirectory, VarBoxNumber in Text('Box Number')),If(Dropdown1_1.SelectedText.Value = "All","Common" in KeyType.Value || "Backup" in KeyType.Value || "Master" in KeyType.Value ,Dropdown1_1.SelectedText.Value in KeyType.Value)),"SlotNumber",["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24"])))))))))),Filter(Filter(KeyDirectory, TextInput2.Text in Location),If(Dropdown1_1.SelectedText.Value = "All","Common" in KeyType.Value || "Backup" in KeyType.Value || "Master" in KeyType.Value ,Dropdown1_1.SelectedText.Value in KeyType.Value)))