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 III
Super User III

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (43,537)