@ma_91 Add a TextInput control (rename it as searchLastName) and put this formula in the DefaultSelctedItems property of the ComboBox,
Filter(test_v02, last_name=searchLastName.Text)
Now when the user types a name in the newly created text input, the ComboBox will only show the person who's Last Name matches the text typed.
Instead of:
"Filter(test_v02, Value=TextInput.Text)"
Try:
"Filter(test_v02, Last_Name=TextInput.Text)"
Also, make sure there are no 'unseen' spaces in either the column values or the text control...
I believe you are using a ComboBox, with Allow searching property set to yes. Turn it to Off.
Add a TextInput and set the Items property of the ComboBox to (replace control, table and column names as applicable),
Filter(yourDataSource, Value=TextInput.Text)
-
@ma_91 Add a TextInput control (rename it as searchLastName) and put this formula in the DefaultSelctedItems property of the ComboBox,
Filter(test_v02, last_name=searchLastName.Text)
Now when the user types a name in the newly created text input, the ComboBox will only show the person who's Last Name matches the text typed.
Take one text input.
In your combo box where names are appearing. In it's item property write this code:
Filter(ListName,FirstName=TextInput3.Text)
What will happen is once someone writes full name in text box. Only that entry will be visible in Combobox. In my case it is Matthew
PS: Make sure you select proper filed to display in combobox. In your case it's Lastname
Instead of:
"Filter(test_v02, Value=TextInput.Text)"
Try:
"Filter(test_v02, Last_Name=TextInput.Text)"
Also, make sure there are no 'unseen' spaces in either the column values or the text control...
Also, further down the line you might also want to add a filter where Date_In = Today(). To help with security.
-
User | Count |
---|---|
157 | |
91 | |
80 | |
74 | |
57 |
User | Count |
---|---|
197 | |
166 | |
99 | |
95 | |
79 |