cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Leu0101
Helper III
Helper III

Issue: Filter variable number 1 also filters number 10

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!

2 REPLIES 2
timl
Super User
Super User

@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
)

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)))


Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,643)