Works great and easy to set up! Thank you. Quick tip to make the label disappears after pressing Enter : In visible control of your label " If( Textbox.Text in Yoursharepointlist.field,false,true)"
Thx sir, really nice trick. As you use the function "starts with" I wonder if it would have spit the correct result if you searched for the word "world" in this case. I guess not. Thx for commenting. And again, been following you, as your content is really helpful indeed. Thx!
Thanks for this video, this works for me. How do I populate the searching item like if I type PC and 2 values should show up on the same text box below not on separate box.?? Like the google search box when you type number of options shows below. I’m using a sharepoint list column for the text box, what type of column I should create in sharepoint list of I want to achieve this in PowerApps? Please help. Thanks in advance.
Thank you very much Sir for this incredible video. Silly question. WIll this method works up to 2000 delegation limit in ShaPoint ? Or I can Add a Collection with more items against the search fucntionally? Thanks in advance. The reason for my question is beveause I need to filter first by the US States, then by Cities. I wan the cities under your concept but vould be many many cities
Probably not a good idea. SharePoint interface provides enhanced document search experience which can not be easily replicated in PowerApps. Reconsider the requirements. Try to use SharePoint Enterprise Search webparts.
Hi Kea, firstly thanks. Super helpful guide. Is there a way to get the text box with examples of valid inputs to disappear once a value has been selected? Ta
Hello, I am trying to create a page in SharePoint where the content will be Frequently Asked Question, I need several buttons which will serve as categories, so when searched, auto suggest is triggered, please would you help?
Hey this worked wonderfully but it doesn't select item and submits the text to SharePoint list. Basically, it searches, it populates but it doesn't submit on the column. Any advice?
Thanks but I get an error. “Name isn’t valid. ‘Result’ isn’t recognized”. What am I doing wrong? Sorry if my question sounds silly. I’m new to PowerApps.
I think you are missing one thing - How did you setup the functionality of selecting the Searched-Value from the Label - you are saying click Tab or Move Away - but nothing is working in my case.
Thank you - I am certain this *should* work. My code is throwing an error that it is not recognizing the term "Result" and I am going mad trying to work out why - can anyone shed any light on this? If(!IsBlank(SearchTextInput.Text),With({wordResult:Concat(Distinct(Filter('Client List',StartsWith(Title,SearchTextInput.Text)),Title),Result & "; ")},Left(wordResult,Len(wordResult) - 2)))
Thanks so much! It worked like a charm and the app looks much more professional. KUDOS!
You're welcome!
Works great and easy to set up! Thank you. Quick tip to make the label disappears after pressing Enter : In visible control of your label " If(
Textbox.Text in Yoursharepointlist.field,false,true)"
Thanks!
Thx sir, really nice trick. As you use the function "starts with" I wonder if it would have spit the correct result if you searched for the word "world" in this case. I guess not. Thx for commenting. And again, been following you, as your content is really helpful indeed. Thx!
Hi Victor, you can change the formula from Starts With to Search function.
thank you so much sir this video really helps me thank you sir
Most welcome!
Thanks for this video, this works for me. How do I populate the searching item like if I type PC and 2 values should show up on the same text box below not on separate box.?? Like the google search box when you type number of options shows below.
I’m using a sharepoint list column for the text box, what type of column I should create in sharepoint list of I want to achieve this in PowerApps? Please help.
Thanks in advance.
Thank you very much Sir for this incredible video. Silly question. WIll this method works up to 2000 delegation limit in ShaPoint ? Or I can Add a Collection with more items against the search fucntionally? Thanks in advance. The reason for my question is beveause I need to filter first by the US States, then by Cities. I wan the cities under your concept but vould be many many cities
Thanks.
Hey man I hope you doing great , I want to create search box for documents in power apps what is the best method for that? Thank you in advance
Probably not a good idea. SharePoint interface provides enhanced document search experience which can not be easily replicated in PowerApps. Reconsider the requirements. Try to use SharePoint Enterprise Search webparts.
Hi Kea, firstly thanks. Super helpful guide. Is there a way to get the text box with examples of valid inputs to disappear once a value has been selected? Ta
I think this is achievable but have not tried it myself.
Thank you Sir, I have a question, can we add a line break instead of a semi-colon?
Yes, you can, use html label instead of label
great video, very valuable - but I think the formatting of the code could be better! very hard to follow, might be a feature of power apps
Hello, I am trying to create a page in SharePoint where the content will be Frequently Asked Question, I need several buttons which will serve as categories, so when searched, auto suggest is triggered, please would you help?
You build PowerApp and embed it in SharePoint page.
@@KeaPointTechTips Thank you for your reply, I will try this
Hey this worked wonderfully but it doesn't select item and submits the text to SharePoint list.
Basically, it searches, it populates but it doesn't submit on the column.
Any advice?
Thanks but I get an error. “Name isn’t valid. ‘Result’ isn’t recognized”.
What am I doing wrong? Sorry if my question sounds silly. I’m new to PowerApps.
It appears ThisItem.Result no longer exists in the framework. Changing it to ThisItem.'{Name}' or try ThisItem.Value
I think you are missing one thing - How did you setup the functionality of selecting the Searched-Value from the Label - you are saying click Tab or Move Away - but nothing is working in my case.
Interesting, it should work and you move teh focus away from the box.
I wish this code was pasted into the show more section so we wouldn't have to write the entire code and make a mistake
Thank you - I am certain this *should* work. My code is throwing an error that it is not recognizing the term "Result" and I am going mad trying to work out why - can anyone shed any light on this? If(!IsBlank(SearchTextInput.Text),With({wordResult:Concat(Distinct(Filter('Client List',StartsWith(Title,SearchTextInput.Text)),Title),Result & "; ")},Left(wordResult,Len(wordResult) - 2)))
Use Value as keyword instead of Result.
You can use "Value" instead of "Result"
Try "Value"
use "Value" instead of result
I am literally going insane with the same problem.... I feel that Wrote the formula correctly