cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JACK_LAI_1117
Resolver I
Resolver I

Textinput has smart filter fuction

HI ,

In my powerapps , I have a textinput , and I want it has "smart search function " like google search .

After I key two or three words ,it will show all match filter condition name for me to choose~~~~ So how do I config in textbox config to meet our demand ~~~

 

 

Annotation 2020-08-04 172625.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

I made a test with;
Distinct(Filter(APP1,ComboBox3.SearchText in user_email),user_email)

 

If you face Delegation issue, create a collection,
ClearCollect (MyUsers,APP1)

 

Then change it to;
Distinct(Filter(MyUsers,ComboBox3.SearchText in user_email),user_email)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

4 REPLIES 4
eka24
Super User
Super User

Instead of textinput, use a Combobox.

It has the search function.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

@eka24 

 

I change to combobox and the "Item" config below this pic

 

"Distinct(Search(Filter(APP1,StartsWith(user_email,ComboBox3.SearchText)),ComboBox3.SearchText,"user_email"),user_email).Result"

Annotation 2020-08-05 093210.jpg

 

Then I play this app , it still not show suggestion result.......

Annotation 2020-08-05 093528.jpg

 

So how can I set up the combobox parameter to meet my needs~~~~

I made a test with;
Distinct(Filter(APP1,ComboBox3.SearchText in user_email),user_email)

 

If you face Delegation issue, create a collection,
ClearCollect (MyUsers,APP1)

 

Then change it to;
Distinct(Filter(MyUsers,ComboBox3.SearchText in user_email),user_email)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

@eka24 

 

Thank you for your replay ...... YES ,it works .

 

But I modify your script a little

 

ClearCollect (MyUsers,Distinct(APP1,user_email)) -->Because I want to reduce the data amount in my collection .

 

Then in the combobox "item" , my script is -->Filter(MyUsers,General_affairs_query_user_name.SearchText in Result)

 

After this , it can show what I want ~~~~~

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,202)