THANKS a lot! Using a variable as buffer, to avoid real-time reactions and delays... So simple, yet so elegant!

As a complete beginner, I find your videos really helpful April. I’m always amazed by you power apps ‘guru’s’ having the ability to create brilliant business solutions and then to post these on KZfaq so we can all learn. So grateful to you all.

I know it's been years since you did this but I appreciate it. I added one small change to the cancel button, Set(searchQuery,"");Reset(txtSearchInput);SetFocus(txtSearchInput) this puts the cursor right back at the beginning of the text box so the user can begin typing again.

Thank You April, I'm just a couple minutes in and you've already been a great help. The world's a brighter place with you and Shane Young.

April - this video is just an amazing practical example. You just made my PowerApp solution even more user acceptable. Keep up the good work.

Thank you for another very helpful video April!

A little addition. If one navigates away from the page without clearing the search box, the search string characters remain in the search field. To get around this one can put in Reset(name of search field); before Navigate(destination) command...

Amazing. This video was so detailed and now my search function works the way I want.

nice and elegant tidbits, April to add a touch of difference, thanks! have watched it a few times over time...😊👏

The best and the most detail tutorial about power app search box . Thanks

You did an amazing job with this video. Thank you.

PERFECT! Thank you very much!

LOVE the intro! And the content too obviously... nice start to a morning at 4:am!!

Very well explained, thank you.

GREAT video - thank you. I have used your search function in an app I made. I have 2 search boxes that search for 2 different fields. However the gallery list it searches is blank unless I put in a "space" (space bar), and then backspace in the text box. When I type in a word, it functions the way it should. I have text in the "Placeholder". The DATA value is "" In the "OnChange" I have Set(SearchDesc,tbsearchDescInput.Value). What can I do to have the list display without having to put in a space and backspace it out? Thanks in advance!

Thank you. This is really helpful. 🥰 looking forward to more of yr tutorial.

Thank you April! You're really April because you bring light :)

Excellent. Clear, concise and uses a real world scenario. I particularly liked the method for avoiding delegation by using "StartsWith". Thank you! One issue though is the gallery doesn't show any items unless I press the magnifying glass. There must be something Ive missed. How do I default the gallery to show all records on page load?

This Video was very useful, Thank you for your efforts.

Thank you, April. Your presentations are very wonderful .Question: Wanting to set up the search functionality, when I added a Text label to do the exercise of adding search, the label is unmovable. That means, It can't be dragged to a place where I wanted to place. Because of that, I am unable to proceed. Can you suggest?

Thank you. Great Tutorial

Hi April, found this very useful. Could you tell what to use instead of startswith function to return not only the items that start with the word input? Thanks

Superb tutorial. Works like a charm. Thankyou

Thank you April for another fine video. Im building a canvas app that is pulling in data from multiple data sources. The key field is AppID and is common across the data sources. Can I seach across multiple data sources using what you are illustrating?

Great video! Thank you for posting! Could you show how to launch the search result(s)? I mean when we click on the search result item, it will launch a URL linked to that item.

Hi April, great video! Thank you 👍

Thank you April this is a great video very easy to follow. I have a question I am very new to Power apps as in I am creating my first app. Is there a way to have one text search and then have a 2nd text search that searches on the results of the first search? Do you have a video on this? Thank you.

Really useful, thanks!

Thank you so much! I learned a lot from watching your videos.

Thank you , wonderful content

Thanks a lot for your lesson

Hi April, another amazing video! Succinct and easy to follow. Further reading your comment: Filter(YourList, StartsWith(Title, tbInput.Text) || StartsWith(Speaker, tbInput.Text) ) for searching speakers, how do I tweak this line so it also can search by the speaker's last name? Thanks in advance. :D

Very clear and helpful video

This is a great tutorial, I had to stop and scroll back many times to catch the actual function that you entered. It would be awesome if you'd show that two seconds longer before jumping to the next screen.

Hey April, thank you for this your videos are very helpful! I have created a power app with this search function and filtering capability however I also want to filter the gallery list by only the current user so they are unable to see other peoples input. I have tried all the formulas I know but it shows an error. This is the formula I have but I need to filter the files (in a sharepoint list) so that the current user can only see items where they are the 'requestor' field. If( FilterGallery.Selected.Value = "All", Filter( TravelRequests, StartsWith( Title, SearchInput.Text ) ), Filter( TravelRequests, StartsWith( Title, SearchInput.Text ) && Status.Value = FilterGallery.Selected.Value ) ) I am stuck, can you please help? thanks!

Can you do this with a person column? I am really struggling to use a combobox with an editable grid as there appears to be a glitch where duplicate rows get added. It works with a dropdown box but I need to be able to search for people’s names. Many thanks!

Thanks a lot and Nice explanation.Please give me more videos on power apps.

Wonderful content - thanks

Hi April, build out a gallery that has 3 columns (name, title, department) that can store multiple user pick from office365 users search. How can I get that done?

Excelent! Tks!

This is awesome

Great video as usual April! Question: when filtering a gallery via a search use case, above is it more "efficient" to filter for a number type of column data in SharePoint? I was thinking if it makes it more efficient to filter a number datatype column (specially for very large datasets) and then just make a validation in the search input for users to enter just numbers (my use case needs to search for numbers but I can also save it as text).

fantastic! I just started using PowerApps but found my search box was not behaving the way I wanted it to...your video addressed my issue! thanks for your wonderful instruction. I just followed some other video tutorial that instructed me to create a Power App directly from a SharePoint list....how do I create a home page like the way you have?

Great video and very helpful! Can you give an example of how to replace the StartsWith function with the in function?

this is very helpful

Question? Is it possible to do that but with data populated from a dropdown source?

In Outlook we searching the person name once we select the mail those person name will render in search field is that possible in powerapps

H Aprili, good day, need help to upload gallery data along with pictures into email body as tabular format. Also how to prevent picture upload control to upload heavy image in term of pixel or mb

This video was awesome! How about doing a search box that will search on all fields in the gallery, that would be amazing.

Hey April. Thanks for producing amazing videos. I do have a question on this. Would it be possible to search from multiple columns with just one search box. In your video, you showed searching for training name. How would you tweak the search box to also be able to search for the speaker and maybe some more other columns you might have? Thanks

How to change the behavior of Built-in Search TexBox, for example in my Opportunities View there is Default Search TextBox and it search records with [Starts With] Keyword and I want to change that to [Contains] Keyword. But I am unable to find that built-in Search Box on View...where to find and edit that SearchBox default behavior.

Hey , thanks for this video. I have a quick Q , Can I have a browse button in app , so that users can select their excel from lets say one drive or dataverse . And the template functioning of app can be intact with different excel but with same structure and metadata

Hi April, I've got an Excel spreadsheet which has a column of weblinks. But when I've connected via Powerapps, the URLs aren't live, they are just text and can't be clicked and don't link. I've tried using [link] and [linkURL] in the header of the Excel file as I have with my [image] column, but it doesn't work for the links column. Thanks

Can we add the search bix in a data card with number of different buttons?? .. pls help

Thanks!

Is there a way to use the search box to search multiple fields? For instance the name of the class and the description

Is there a way to get the search box automatically selected when the app is active? I have made a search box app that I have embedded in a Sharepoint page as an app. Is there a way to have that automatically selected, so a user doesn't have to select the text box to start?

Hello! Thanks for this video which has come in super useful given the clear instruction. But at the 4:40 mark where you use tbSearchInput.Text in the formula bar, I get the error "PowerApps encountered an internal error trying to evaluate this expression." I've followed everything as closely as possible to make my App apples to apples with April's. Does anyone have any suggestions? Thank you!

Hi April, awesome tutorial thanks ! One question (might sound stupid but i just started with PA). How not to loose the visible properties of the magnifying glass / cross icon (from the search bar) when they belong to a group that has a different visible property? Basically if i put the search bar within a pop up, it seems that the visible property of the pop up overwrites the ones of the glass / cross and i am loosing the fact that they either appear or disappear when using the search bar. Hope this makes sense and that you see what i mean. So i guess my second question is how to apply multiple visible properties to an element. Thanks for your reply

That was great! Do you have a full course?

April how can I add more than one search field for powerapps with sharepoint?. Thank you for this great video. For your case searching using title,speaker etc.

Hi April, thanks so much for the video. How would you handle if the text entered does not exist in the data source?

Hi There, Thank you for this video it works great however I am having a small issue. My app now starts with the gallery blank and nothing will appear in it until I press the "Clear Search" button I'm using like the X in your video. Do you know a way to get this gallery to just start working?

Great tips April. Thank you. If I dont go with StartsWith and use in operator, there is delegation issue. I would like to search any text not just that StartsWith. How do I handle it without any delegation warning and even without in operator. Is there a way?

Hi April, I have a search box, my data is connected to a Sharepoint list. I wanr my users to only be able to enter their name, the record appears and they edit the data if needed. I don't know what i am doing wrong.

How can search a number (int) in TextInput (Format is Number) witch the search function??

Adding the clear icon, the magnifying glass cant be used to update the variable you have to use enter, but very informative video, ty

Is it possible to count the number of times in a column text appears and matches string? And to sort descending? Ie/ example - Collection has two entries Canada and cango. If I put a text entry of "a" in my search window how can I make Canada (A appears 3 times) as my first record before Cango (A appears 1 time)?

Hello, Can I have two search fields for the same gallery? Thanks and good work

Good videos, although when you finalize the line of logic in your function bar you quickly change to another screen lol, pause for a moment so we can seeeeee. Thanks.

is it possible to search sharepoint library file content? I'm new to powerapps. so far i can search on metadata columns only

Hi April, Very nice video about search. But I want to search the gallery with a choice field and also with a Text column. I am getting error for the choice column any help?

Does this work for a sharepoint calculated field or choice field? I get a delegation error.

Hi April! How to populate Requestor information and search from AD? Thanks

Hi, is there a video on how you created your home screen?

what iff i want to search using a number and a text with the same search box is that possible Filter('[dbo].[demo]',StartsWith(Text(reportdate),TextSearchBox1.Text)); Search('[dbo].[demo]',TextSearchBox1.Text,"client") this is what i have written but gives error

Is there a way to search without having the gallery displayed and then if there is a match, it will pop up with that match?

April, i am from India i want to learn Power apps completely which one is the best institute for online classes. please help me.

How to search a number in that text box

What if I want to search the entire contents of the title and not just what it starts with?

it becomes white. its showing an error tho i copied everything u said

What would you do if you wanted multiple search text boxes? Type first search...then second search box becomes visible and you type within it to search from the results showing from the last search text box.

That 2000 Limit is a real pain in the ***

Update fyi MS decided get rid of the border color property on the text input control. which is very very stupid. who on earth makes these decisions?

Not helpful, thank you