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 RU-vid 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.
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...
Thanks Steve! I really like that music too. Unfortunately I had several copy cats so I switched it up in my most recent videos so I could stay unique. I'm thinking I need to write my own intro music :)
@@AprilDunnam Well keep doing what you are doing and thank you for the response. I did however have a question, but not sure you can answer it. I did a search box after following your direction on selecting the gallery, then pointing the search box to that... Can't remember the specific error, but I was trying to search on a column that had solely numeric values and I THINK the ".Text" was not allowing it. I THINK because the values were numeric. Any comment/thoughts on that? Thanks in advance! Steve in Colorado...
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.
This is really great feedback. Unfortunately I can't change the videos that are already uploaded but I will make a conscious effort to slow down and keep the screen up for awhile when showing formulas :)
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?
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?
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.
Thanks! You can do something like this: Filter(MyDataSource, ColumnName in "Text to Search"). Hope that helps! Be mindful of delegation though because the In operator isn't delegable in most cases
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.
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?
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
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.
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?
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
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.
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.
You can search by multiple fields with the Or operator. So using the example I show in the video the Filter formula would look like this: Filter(Training, StartsWith(Title,tbSearchInput.Text) || StartsWith(Category, tbSearchInput.Text) || StartsWith(Status, tbSearchInput.Text)) Hope that helps
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!
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
Hey Zairil - Absolutely you can chain together multiple search queries with the Or function. So for example: Filter(YourList, StartsWith(Title, tbInput.Text) || StartsWith(Speaker, tbInput.Text) )
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
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!
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
Hi Vincent - Your question makes sense - visibility properties get tricky when you are doing that within groups. You will have to go into your search icon and modify it's Visible property to incorporate both the visible logic for your dialog and the visible logic for the search icon. So for example, if your dialog box visible property is set to: If(showDialog = true, true, false) and your search icon visibility is: If(showSearch = true, true, false) then you'll need to mash them together like so in the Search Icons visible property: If(showDialog = true && showSearch = true, true, false)
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
Hi Robinson - Absolutely, you can string together multiple search box queries like so: Filter(MYDataSource, StartsWith(ThisField, SearchBox1.Text) && StartsWith(OtherField, SearchBox2.Text))
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).
Hi Emmanuel - I haven't observed any efficiency increase from using say a number column versus a single line of text. As long as the filter you are doing is delegable then the I don't think there's a huge boost between the two
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?
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.
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
Thanks for watching Bryan! I don't have a full course - just my RU-vid videos. But if you have any suggestions for topics you'd like to see covered let me know!
Hey Fernando - So the search will automatically handle it and not return results. I often take it a step farther though and what I'll do is add a label that is overlayed on top of the gallery which has the text "No items matching your search". Then I set the Visible Property of that label to something like this: If(CountRows(GalleryName.AllItems) > 0 , true, false) Hope that helps!
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?
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 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 Ramesh - I think it would be best to use the Search() function in this case. You can pass in a value and it will search for any text that matches in that string. More details can be found here: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
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?
For choice fields you have to make sure you get the choice fields value in the comparison. So for example, if I want to filter a list called Timesheets that has a choice column called Status to get items where Status equals Approved then you would do that as so: Filter(Timesheets, Status.Value = "Approved")
You can set the visibility of the gallery based on if there is something typed in the search. So something like If(IsBlank(searchbox.text), false, true). Also, the "StartsWith()" function acts as an instant filter so if you want to wait for an exact match you can use Search() instead
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)?
Hi - I actually took that home screen from the Crisis Communication Template. It's a component in that template. You can download it here: docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sample-crisis-communication-app
Hey there - you can do that with the Office365Users Connector for that. there is a SearchUsers function in that connector that you can use. Hope that helps!
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
You can do it like this: Filter('[dbo].[demo]',StartsWith(Text(reportdate),TextSearchBox1.Text) Or StartsWith('[dbo].[demo]',TextSearchBox1.Text,"client"))
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.
@@AprilDunnam Yeah... just trying to figure out where to include the search portion in combination of the massive nested Ifs for 5x dropdowns already filtering. To include blanks as well.
@@AprilDunnam Hey, if I combine multiple searchboxes, the functions don't work properly anymore. I tried || and &&, but it fails everytime. What could i do? :)
The process would be the same for searching a number. If you want to search for an exact number and not a number that starts with those numbers then you would change it to equals in your formula.