I have an excel data sheet with 1501 rows and about 26 columns. The first column is a numbered list from 1 through 1500. I want the user to enter a number in a text input box and I want a gallery to show only those columns from that row of the number that the user entered. I used this formula
Filter(MasterTable, txtNameFilter.Text in 'BattCont' || txtNameFilter.Text in 'RightBattCont')
but it filters the records from the gallery based on the description. The problem is that there are numbers in the description of the columns( e.g. Controller100) and the search returns those back instead of the exact text. I need to do a lookup but the formula is not working.
Filter(MasterTable, LookUp(MasterTable, 'RightBattCont' = txtNameFilter.Text))
Eventually I want to add radio buttons and checkboxes but I think I can figure it out once I get Lookup and Filter working. Any help is appreciated.
To prevent users from entering anything but a number in the textinput box, set its Format property to Number.
Filter( MasterTable, TValue=Value(txtNameFilter.Text ) )
Sure, but how do I pull the record up from the 2nd column based on the number of the 1st column (that the user entered). The name of the 2nd column is RightBattCont.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.