PowerApps Auto Suggest Search Text using SharePoint List Data

Подписаться 10 тыс.

Просмотров 11 тыс.

50% 1

This video will walk through the process of configuring the PowerApps search textbox that gives suggestion text based on SharePoint list column values. This will help speed up your data entry or search process.
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 00:21 Create Canvas PowerApps for Search
• 00:50 Configure PowerApps to Build Auto Suggest Search Text Box
• 07:57 Outro & Subscribe
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerApps
#SearchBox
#SharePoint

Опубликовано:

20 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@mateocomba3821 2 года назад

Thanks so much! It worked like a charm and the app looks much more professional. KUDOS!

@KeaPointTechTips 2 года назад

You're welcome!

@victoriendargaud409 Год назад

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)"

@KeaPointTechTips Год назад

Thanks!

@victordauden9173 2 года назад

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!

@KeaPointTechTips 2 года назад

Hi Victor, you can change the formula from Starts With to Search function.

@bucketclips6078 2 года назад

thank you so much sir this video really helps me thank you sir

@KeaPointTechTips 2 года назад

Most welcome!

@sowmiyasakthikumar7490 9 месяцев назад

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.

@oliverhutton3842 Год назад

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

@KeaPointTechTips Год назад

I think this is achievable but have not tried it myself.

@SabirKhorajiya Год назад

Thank you Sir, I have a question, can we add a line break instead of a semi-colon?

@KeaPointTechTips Год назад

Yes, you can, use html label instead of label

@molotovgod Год назад

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?

@ammaral-sharek8606 2 года назад

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

@KeaPointTechTips 2 года назад

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.

@user-xj2gb4tq3p 4 месяца назад

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

@KeaPointTechTips 6 дней назад

Thanks.

@user-pd3py5kh3w Год назад

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

@Threading_Along 2 года назад

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?

@KeaPointTechTips 2 года назад

You build PowerApp and embed it in SharePoint page.

@Threading_Along 2 года назад

@@KeaPointTechTips Thank you for your reply, I will try this

@singingmotivation4661 2 года назад

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.

@KeaPointTechTips 2 года назад

Interesting, it should work and you move teh focus away from the box.

@stefano94103 Год назад

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

@adamgill Год назад

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)))