PowerApps Search Function

[@ShanesCows]

Updated Video for 2022 kzbin.info/www/bejne/oorMY2eloL13htU

[@Ambular89]

Its for sure 4 years later. I can't express how much I appreciate (and kind of rely on) your videos to help me when I'm stumped or just curious to learn more. Your content continues to be thorough and really valuable. Thanks Shane!

[@ShanesCows]

Great to hear! These are the type of comments that keep me going. :)

[@johnswire74]

@@ShanesCows It's now five years later! Thanks for all the excellent advice.

[@mandijohnson-fisher5370]

It’s nearly 3 years later that I’m watching this! 😁 Thanks for all you do!

[@ShanesCows]

Glad to help. 😀 😎

[@abewearsshades2736]

Viewing 3 yrs 11 months later and this video is still useful. Thanks Shane.

[@ShanesCows]

Thanks Abe😎 I am glad this function hasn't changed at all. :)

[@2JPerfomanceHorses]

Still relevant 5 years later! Thanks for all you do for the community!

[@ShanesCows]

Isn't that crazy. There is an updated version here if you want to go deeper. kzbin.info/www/bejne/oorMY2eloL13htU

[@2JPerfomanceHorses]

@@ShanesCows watched that one as well thanks again!

[@cjfarris7963]

Watching 3 years later (May 2021) - your videos are life-saving! They are relatable and your humor makes learning all of this much easier - thanks!

[@ShanesCows]

Very kind of you. Thanks. 😎

[@rajkumarkrishnan7817]

It's 4 years now, Shane. Your PowerApps videos remain timeless classics! Nothing has changed. SharePoint lookup columns and PowerApps still don't gel!

[@ShanesCows]

Crazy isn't it. I did make a newer version of this video that has some helpful ideas. kzbin.info/www/bejne/oorMY2eloL13htU

[@lindaherr3808]

It’s 6 yrs! Thanks for the video! This solved my problems today at work!

[@ShanesCows]

🤣 That is awesome. There is an updated version if it helps. kzbin.info/www/bejne/oorMY2eloL13htU

[@happenstancecv]

5 years now! 👐 I'm new to PowerApps and I find your vids super helpful. And funny 😄 Love seeing Chewy and Ferguson in your demos haha. Thank you, Shane, for your awesome and easy to digest tutorials! Cheers!

[@ShanesCows]

Appreciate that. 😎 kzbin.info/www/bejne/oorMY2eloL13htU This video is a version of this video that isn't 5 years old if you want more info on the topic. Have a good day!

[@happenstancecv]

@@ShanesCows perfect! Thanks! Have a good day too!

[@mangporkung]

Yes, Its 4 years later. And I just found you! Your vdo just save my day. your contents are very very easy to understand and follow along. Thank you so much for your hard work. Keep it going !

[@ShanesCows]

Happy to help! This is a new version of the video you watched with some cool work arounds you might like. :) kzbin.info/www/bejne/oorMY2eloL13htU

[@gagbru]

Like you said, I am watching your video 4 years from when you made it. It's still very relevant. Great Work.!!! and as always very helpful. Thank you.

[@ShanesCows]

I appreciate that! If it helps I did make a follow up video earlier this year. More ideas on how to deal with challenge. 🙂 kzbin.info/www/bejne/oorMY2eloL13htU

[@diligentguy4679]

14:30 You are correct. It's been four years. I love your content Mark. It's just that not many people uses power apps otherwise you would be celebrity now. Keep up the good work Mark

[@EpicBizHero]

Almost 4 years later... This video is STILL Going Strong! Thanks Shane!

[@ShanesCows]

Thanks Shawn. Guess it is about time I remake some of these 4 year old videos. 😁

[@nickistern9379]

It is over 4 years later and this was very helpful and easy to understand. I appreciate all of the helpful videos.

[@ShanesCows]

Glad it was helpful! Here is the follow up video to this you might enjoy. kzbin.info/www/bejne/oorMY2eloL13htU

[@rachelshalem]

hahahaha it's 4 years later... 🤣 Thank you for all your videos. I'm 10 years in SharePoint and all new to SharePoint Online and powerApps and with your explanations it's fun and easy. I'm a fan ! 💖😊

[@ShanesCows]

That is awesome! Thanks for the kind words Rachel.

[@MandyMcPhail]

5 years later now! Thanks Shane, you've got me moving in the right direction, even 5 years on!

[@ShanesCows]

Mandy there is a more recent, deeper version of this video if it helps. kzbin.info/www/bejne/oorMY2eloL13htU 🤩

[@MandyMcPhail]

@@ShanesCows perfect - thanks - early days for me on Power Apps, and love the way you explain things. Just the right tempo for me. I'm off to look at the more recent video! 😊

[@funmemes5915]

As you said. I am watching after 4 years. Anyway your tutorials are precious and accurate. great work. thanks for helping us. Cheers

[@ShanesCows]

Great to hear! Even better? There is a newer version of this video. kzbin.info/www/bejne/oorMY2eloL13htU that may help you.

[@funmemes5915]

@@ShanesCows Thank you

[@25June2011]

Ha, ha, ha! It's four-ish years now! (Which is especially ironic because while I've watched many of your videos recently while learning PA in the last month, given how old/not as accurate some things were presented as during this video I took note that it was almost four years old and things have definitely changed in PA since you originally posted.... and then your comment! 😀 Ha!) Much appreciation to so many of the MS platform pros for putting all your knowledge out there for the rest of us to benefit from! Thank you!

[@howardcallahan1054]

Shane - I would like to change the search to a "contains". Not sure what to exchange the 'StartsWith '. Here is what I'm referencing: SortByColumns(Filter([@'PD Administrator On-Call Schedule'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)). Your guidance needed, thank you! :)

[@JoeGenest]

It's not exactly 3 years, March 2021, since you created this video! Thanks for your help.

[@ShanesCows]

Crazy. 😊

[@heejungno1894]

Hi Shane! I watch your videos all the time, they are so helpful, THANK YOU!!!! I'm viewing this 3.25 years later! :-)

[@HumanResourcesHAMastronardiFar]

Five years and this video is still relevant and informative. Love your tutorials. The videos are brilliant and have helped me overcome some big hurdles as I build my apps. Question: How do I get a search box to sort through the "all" option of a DropDown filter? I built a drop down filter to sort my data by department and I included an "all" option to show all employees. I then created a search box to sort through the names of employees, based on the drop down selecdtion. Everything works great, except for when I select "all". The search box then stops working.

[@ShanesCows]

I think it is a combination of this video kzbin.info/www/bejne/n3ibhJ2Nqb1kr68 and kzbin.info/www/bejne/fKTXnGNpmJ6Xmck Search(Filter(table, field = dropdown Or dropdown = "All"), SearchInput, "FieldToSearch") Something very close to that.

[@wcmbradyparent]

Haha it is four years. I am learning a lot from your thank you for all your help!!!!!

[@ShanesCows]

Awesome Walter. There is a video from this year that would help you more if Search is your challenge. :) kzbin.info/www/bejne/oorMY2eloL13htU

[@diegocree4875]

Excellent. Do you know how hand the accent in words? I mean, in Spanish or French languages is used the accent in vowels (for example función word), but if I write the word without the accent, the function SEARCH won't find out it. Is there any function or algorithm to solve this little issue?

[@traviskennedy7802]

Can you use this same concept to search an excel sheet and bring up a whole row of info from the one piece you’ve search?

[@Imran55920]

Shane, How do you get exact match is search box? I have list of equipment with similar name like component#1,2,3 but the problem I have is that I got the equipment list starting with corresponding number like when I search for component#1 I get the results for all #1,11,110 & on.

[@ShanesCows]

Sorry I am slow. I have never tried that so not sure.

[@chrisroulaux62]

Hi Shane, I'm getting a yellow warning triangle when I do the exact same as you.. Any idea on how to fix this?

[@ShanesCows]

You are going to like it but you need to learn about Delegation. kzbin.info/www/bejne/i5KlnomLht2SfM0

[@luisaugustomeyer7178]

Hi Shane. How Can I use the Filter Function to predict words from a Sharepoint List?

[@ShanesCows]

I have never tried.

[@aminahamilton1790]

Thanks for the video. Does this work only on Galleries? I'm trying to apply a search box on my data table.

[@ShanesCows]

Nope, should work on a datatable. Put the Search() function in the Items property of the data table.

[@shubhamsatpathy6489]

I have a question: I made a inner join and now I m unable to do a search operation on the inner join table.learCollect( ViewrealMapping, AddColumns( Table1_3, "FTEInfo", LookUp( Table1 , JobTitleID = Table1_3[@JobTitleID] ),"STDInfo",LookUp( Table1_2, JobTitleStdID = Table1_3[@JobTitleStdID] ) ) ); If i do a search on FTEInfo . Power apps says : some error; and to access FTEinfo. I write "ViewrealMapping.FTEInfo.columnname" in search or filter as to do search on these columns which throws error.

[@ShanesCows]

Not sure. SOrry

[@colby4390]

how would you format the search function if you were dealing with numbers? It appears that search can only work with Text.

[@ShanesCows]

Correct. You would have to change the column to text. Maybe use the AddColumns function and Text(columnname) to get it to text?

[@agustinmisaza]

Hello Shane great videos. How can I do a Filter that works with a big sharepoint list, but that doesn't use the Startswith function, I want it to search any word, not only the first word. Tks

[@ShanesCows]

Not possible with SharePoint. Watch this video on Delegation for more thoughts. kzbin.info/www/bejne/i5KlnomLht2SfM0

[@ammaryuliodasmansyah9852]

Hi Shane, i'm using a SharePoint list for my data source and it's contain almot 5000 row data. PowerApps has a limitation that only can contain 2000 record data. do you have any workaround for this case? thanks!

[@ShanesCows]

PowerApps has a delegation limit but that is only for certain functions. Your SharePoint list can be as big as you want depending on how you interact with it. kzbin.info/www/bejne/i5KlnomLht2SfM0

[@mathieupelletier402]

Hi Shane, I am trying to do the exact same thing as you but it doesn't work. My gallery has 3 fields : Division, Year, and Quarter. When I try to select a column, I can select everything (other columns in my forms) except Division and Quarter. My guess is that it doesn't work because they are Choice Columns in my Sharepoint List. Have you encountered a similar issue and know the way to work around this? Thank you,

[@ShanesCows]

Search only works for text columns. ChoiceColumn.Value

[@julireid9574]

Can you search a filtered gallery? If I have this: (Sort(Filter(TitleQueue, 'Developer Email' = varUserEmail), Created, SortOrder.Descending)) can I also add a search by title?

[@ShanesCows]

Yes, put it between sort and filter.

[@estebarney]

4 years! Dude you keep on rocking!

[@ShanesCows]

Thanks. There is a newer version if you want to check it out. Power Apps Search and Filter Function with SharePoint + Workarounds kzbin.info/www/bejne/oorMY2eloL13htU 😎

[@paolatosi4324]

What if I have to send an email to one of those people that I search for? In my case I have to search for the name of one or more suppliers (so external users) and send them an email. Thanks!

[@ShanesCows]

Select the user in the gallery then for to use gallery.selected.emailcolumn

[@harittzpeawsaad44]

Hi Shane Young, Your video is really helpful. Btw I need your help, I cannot search in other column except "Title". I don't know how to fix it and could not find the same problem in the internet.

[@ShanesCows]

You can only search on Text columns 😑😑

[@Peterkmil]

Hi Shane, as soon as I connect the gallery to the searchbox I get an error. It says data type table. How can I fox this? Thanks in advance

[@ShanesCows]

2 things. 1 - There is a newer version of this video that you might find more helpful. kzbin.info/www/bejne/oorMY2eloL13htU 2 - What is the formula you are typing in the Items property. SHould be Search(Data Source, "Shane", "COlumnTOSearch")

[@Peterkmil]

@ShanesCows Hi Shane. Thanks for picking this up. I wil watch the newer version soon. I start just like you're format and like the one in the video. It just doesn't work with mine data. If I let powerapps make a app by it self it does work. But then line starts with fliterbycolumn(datasourse.... .... .... what is the difference and where can I find a video about those differences?

[@ShanesCows]

@@Peterkmil There is no FilterByColumn function. Do you mean Filter(datasource, Column = "Words") The Filter video is here kzbin.info/www/bejne/pJ3LiISdZZiHgpI

[@Peterkmil]

@@ShanesCows I will let you know tomorrow what the exact line is. I just left the office.

[@Peterkmil]

Found it annyway, powerapp 3 screen app starts with sortbycolumns(filter[@partnummer] ... ... why does it do that? And why does it work like this and not like you're examples in the videos

[@ramgopal7421]

What if column in SharePoint is lookup col and we want to search item by that particular column

[@aimeemullins2926]

Hi Shane, is it possible to have search work on a whole Sharepoint list even if my gallery has the GroupBy function. For example, I want to search for every item in Sharepoint and this is the formula I have at the moment- Search(Filter('Knowledge Hub Content', 'Topic name'=TemplateGalleryList2.Selected.Topicname),TextInput1.Text,"Title","linktitle0","Topicname") However the only results showing from the search are only for Topicname not Title or linktitle0.

[@ShanesCows]

That looks like it should work as you have written it. Keep in mind Search only works with text columns and search is not delegable.

[@aimeemullins2926]

@@ShanesCows Thank you for getting back to me, It is only allowing me to search for the item I have grouped by- Search(GroupBy('Knowledge Hub Content',"Title","EMPTY"),TextInput1.Text,"Title") This works, but I am unable to add any other columns to search for, is this because it can only search the browse gallery by what it is grouped by?

[@majidhussain1876]

2 years from now. so do searchbox and lookups still not like each other?

[@ShanesCows]

Nope. Sorry

[@morganaluz1571]

Hi Shane! Do you know how can I change the default text on a search box based on a specific button pressed? for exemple: if i press the button 1 it goes to another screen1 and write "one" in a searchbox... if i press the button 2 it goes to another screen1 and write "two" in a searchbox... :

[@ShanesCows]

Set the Textbox to use a variable for its default value. Then change the variable as you need.

[@issiewizzie]

thanks for the insight ...is it still the case as of today about the limitations of search -in relation to powerapps - sharepoint.? is it still limited to 500 items ?

[@ShanesCows]

Yes and no. You can raise the limit to 2000. Watch my video on Delegation I just released for more info.

[@ShanesCows]

PowerApps Delegation and the 500 item limit kzbin.info/www/bejne/i5KlnomLht2SfM0

[@zacharyrobertson3261]

I built an app inside of teams so that it is deployed and only my team can access it because it is for our IT inventory. The app has fully functional and really improved things. Except I don't have a search function. When I go to edit the app in powerapps for teams I cannot seem to find a "text input" to add. Only a "text box" which obviously does not help me. any advice you can give on this?

[@davidgraf8012]

Is it possible to use a variable in the Search function as in Search('Tabbed Forms Test',varID,'Clarity ID') or use the results of a combo box as in Search('Tabbed Forms Test',ComboBox1.SelectedItems,'Clarity ID')? So far, no luck.

[@ShanesCows]

You should be able to use a variable. This works for me Search(Employees, varShane, "Title")

[@davidgraf8012]

@@ShanesCows - Thank you!

[@MoonBeso]

Is there a way to search for a number? Int field on the database?

[@ShanesCows]

You can fret the filter function.

[@navindesigns]

It is possible to create a table grid and make the rows clickable to a more detail page?

[@ShanesCows]

Yes. Gallery or data table can do that.

[@navindesigns]

@@ShanesCows thanks. do you have a tutorial or formula for that? If I am using an excel document for the main table grid, where do I store the information for the details page?

[@A8OC]

As of today (29/10/2020) Lookup Columns still don't work in the Search function......unless you can tell me something different

[@ShanesCows]

Yeah I think Search is still text only. 😑

[@divyanshipareek5918]

How can i apply search function on large sharepoint list. I have around 125k records in list and there are only 2 columns. One is account name, text column and another is account id which is number column. If i am applying search then it is searching only from starting 2000 records.

[@juanmillan8764]

Watching 3 years after, thanks for all the good info bro ! very helpful !

[@ShanesCows]

Awesome Juan. 🤩

[@knowledgeintelugu9538]

Hi Shane if I use in operator for search as filed in my list has two names with / between them am getting delegation as I want use search function as it want to search first person name or second person name.Appreciate your response.

[@ShanesCows]

In is never delegable with SharePoint and Power Apps

[@dsiuniversity5806]

Hi Shane, I would like to add a Search Box to my app's 'EditForm.' Is that possible? I've tried to duplicate the same information from the Search functionality on the Gallery, but the 'SortByColumns(Filter([@TestCCHoldersList], StartsWith('LAST NAME', TextSearchBox2.Text)), "Title", If(SortDescending1, Descending, Ascending))' throws an 'expected record value' error. So, I'm not sure if I can make this work at all. Thank you, thank you!

[@ShanesCows]

Forms only show a single record so you can't search them. YOu can only search tables of data like a gallery or dropdown uses.

[@timtankka3370]

Yo Shane, thanks for the info. Question - how do we stop from hammering our backend SQL server when employing search out of the box? It appears that every added keystroke cancels the previous search a starts a new one, especially on large data sets...

[@ShanesCows]

Solid question. Maybe use delay output on the text input.

[@AdrianHedley]

watching on november 24th 2020. great content. got my search working in no time at all

[@ShanesCows]

Awesome. Most of these videos I have stood the test of time well.

[@itsbubbalips]

Jajajajaja 5 years later and I am watching this video. Hi Shane ❤thanks for the video (:

[@ShanesCows]

That is awesome and crazy. There is a new version of this video now if it helps. kzbin.info/www/bejne/oorMY2eloL13htU

[@LoveTrollingYourVids]

Hey Shane, I've been following your steps but attempting to search a number rather than a name but nothing appears, the numbers are showing in the preview just nothing when I attempt the search

[@ShanesCows]

Search function only does text. 😑

[@LoveTrollingYourVids]

@@ShanesCows Ah bugger! Thanks for the reply :)

[@galinagolant]

Great video!!! And I am watching it 3 years later (June 2021)

[@leajones5881]

5 years later! Thanks for the video that helped me :)

[@ShanesCows]

Crazy. There is a new version of this video if it helps you kzbin.info/www/bejne/oorMY2eloL13htU

[@weeb-kun8353]

How do i search a number. for example - PhoneNumber column is number formatted and latitude is Text. so i can search latitude as text but i can't search PhoneNumber, it shows invalid Search Parameter in "items" of Data table of "drive excel file" connection

[@ShanesCows]

Yeah I think you can only search text fields

[@karenfingerhut6206]

Hi Shane great video it worked a treat. Quick Q is there anyway the seach box can look for a value. Thank you

[@ShanesCows]

Hi Karen I think you are asking for type ahead and not really possible.

[@felipeangeles2485]

Hey, great video, just to say ShowColumns isn´t necessary anymore; I was workin´on it and the drop down "Know" exactly how to deal with it

[@ShanesCows]

Thanks for the reminder.

[@felipeangeles2485]

@@ShanesCows thank You.! I could finish my work thanks to your video

[@heaven4ever4]

Hi Shane! Thank you for this and the Filter video. Learned lots from it. My question for you is, if I try to filter (for the purpose of not allowing to see records from another department, but I want to search on those that are left, how can I do that? The two Formulas are like this: Filter(Table1, Department = "FM20") SortByColumns(Search(Table1, TextSearchBox1.Text, "Name","Address1","City"), "Name", If(SortDescending1, Descending, Ascending)) Can they be combined since they are both pointing to the BrowseGallery?

[@ShanesCows]

Yes you can nest filter and search. Replace the Table1 in your search formula with the filter formula.

[@dvdramm]

Thank you for this tutorial, but my problem is that I use a people picker for the Employee column

[@Sobathp]

Hi, Shane fantastic video. I am trying this search in an MS Teams - Power App. But when I put [ Items = Search (MS Common Data ServiceTable, SearchBox.Text, "Last Name" ] my Gallery view becomes blank. Even if I insert a string in the searchbox it remains blank. What could be the problem? Thanks in advance.

[@ShanesCows]

That should work. Hmm. Not sure.

[@nishantkumar8223]

Thanks Share, it's quite helpful. I have a question here, search bar is picking limited rows of a column. I am using spreadsheet which has 6000 rows in a column. what should i do

[@ShanesCows]

Excel isn’t a great datasource. Not sure there is a way to overcome this b

[@shradhakadam2623]

How to search a number in that text box. In my case database is in excel.

[@smbasha]

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

[@ShanesCows]

Searchable Comboboxes work like that.

[@smbasha]

@@ShanesCows but combobox shows in form of dropdown..

[@vikasumapathy5056]

Hello Shane! Great stuff here. But iv got a query. You have used text data to search. Can we use the search function for a date? I mean can I search from a gallery by choosing date ?

[@ShanesCows]

Nope. Search function only accepts strings.

[@phangkiansiang91]

I follow exactly the way but after i type at at search box, the gallery become empty, may I know why?

[@ShanesCows]

There is an updated version of this video that might help. kzbin.info/www/bejne/oorMY2eloL13htU

[@magdialameen7960]

Yep, more than three years 9 more months and it will be 4 years, Thanks Shane!

[@ShanesCows]

Of course 😎

[@gogreen0417]

I am your big fan. Videos are simple and straight to the point. Excellent explanation as well

[@ShanesCows]

Thanks 😊

[@HaiNguyen-rt4us]

Can lookup column work with search function together, now? I have had that problem too because i set my column type is lookup. Thanks

[@mudrasasidhar]

Hi Shane, Thanks for the videos. They are really helpful. I'm a newbie and have some question. 1. I wanted to create a form in PowerApps. Let's say I create a form using the sharepoint list as a data source. Though I did not create the form as customized form, would I still be able to publish this in share point? 2. I have a list of 3000 employees. I tried creating a form and succeeded in doing so. I do not want to edit the form with all the relevant details of the employee whenever there is something new that needs to be added. Is there any option of entering the employee id and auto-populate other details?

[@ShanesCows]

For 2 try lookup to get the data. Yes for 1

[@lorenyoung6939]

Can you please show how to do a search when your gallery is filtered by another gallery (i.e. Tabbed Selection) and the data is from a Sharepoint list. The Sample Template app Asset Checkout works fine for searching within the tabbed selections however the data is on OneDrive in an Excel file. I can not figure out how to make this work when the galleries are pulling from a Sharepoint list.

[@ShanesCows]

This video shows it. kzbin.info/www/bejne/eqrPqaaOfrqsesU

[@KaneTaichou]

This video has been a great help to me! I know this is an older one, but maybe you can still answer a question for me. I have a ListBox I am using this search method on. If I select items and change the search by searching a different item or removing the search criteria, my selected items are no longer selected. How can I retain the selected items after manipulating the search? I'm heading towards collecting the selected items with OnSelect, but then it still adds an item if I deselect it. :(

[@ShanesCows]

Every time listbox OnChange happens recollect the values. You are going to have challenges. Maybe rethink a bit how you handle this. Is there another path that may be less chaos? Gallery instead maybe?

[@KaneTaichou]

@@ShanesCows Thank you. I did consider a gallery. That would make collecting them to pass later much easier. I'll give it a try.

[@nivinilvlogs]

Hello Shane, first of all Thanks! Can you please suggest how we can filter a powerapps gallery by multiple keywords separated by ","

[@ShanesCows]

Yikes. That would be complex. Possible but complex. I think you would need ForAll to loop through the items and put them in a collection

[@nivinilvlogs]

@@ShanesCows I have creates this functionality. Thought of sharing this with you and other. OnClick of button I am creating a collection for 3 columns. code: ClearCollect(Nil3, ShowColumns(Questions,"crff8_keywords","crff8_question","crff8_response1","crff8_responsedate")) Gallery Items code: Filter( Nil3, Find( "1", Concat( Filter( Split( TextInput2.Text, "," ), !IsBlank(Result) ), If( TrimEnds(Result) in crff8_keywords || TrimEnds (Result) in crff8_keywords , "1", "0" ) ) )>0 ) This is working as expected. Once again many Thanks . Love your tutorials!

[@amailot]

Trying to search on more than one field. Code is: SortByColumns(Filter([@'Associates and Numbers'], StartsWith('Last Name', TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)) Tried to add each field in double quotes with comma. It all blows up if I add one more field. Built from blank template not using wizard. Help! Want to add Title, First Name, Last Name, Number.

[@amailot]

Got it.. thanks anyways.

[@ShanesCows]

Glad you got it. Betting the issue was the number field.

[@djcabal9219]

Hi Shane, is it possible on the search field to ignore a hyphen? example: on the data you have "ABC-100" but i will only type "ABC100" on the search field and it can still search/filter it?

[@fnanfne]

I already have quite a few lines of code in the "Items" property of my gallery like Sort and Filter functions, I can't work out how to combine this with Search! Thinking of making another screen with the same gallery and have it reference that gallery but the results will probably not appear in the one I want. Oh dear lol

[@ShanesCows]

Usually it is like Sort(Search(filter(filter criteria), serach criteria), sort criteria)

[@nightstalkers2012]

I can’t get this to work for the life of me. Been trying for days. I’m using an excel in teams for my data. Any advise?

[@ShanesCows]

A couple of thoughts Zach. 1 - There is a newer version of this video, since this one was 4 years old. kzbin.info/www/bejne/oorMY2eloL13htU 2 - What kind of issues are you having? Getting Excel data in at all or just using Search inside the Excel? Remember, Excel is not a delegable data source, so you will only be able to search up to the delegable row limit.

[@nightstalkers2012]

@@ShanesCows I have a small excel no more than 500 items. I can get the data in and link it with an edit form but when I try to link it with a search bar it says there is an error in the formula by the time I get to Search(“my data source” and even when I finish the formula it doesn’t work

[@nightstalkers2012]

@@ShanesCows oh it would also probly help if I mention that I’m building this in power apps in teams because I don’t have access to the web version

[@sukeshkumar7055]

Thanks for your video, I have a query, How do we assign values to Option sets in bulk, for ex. i want to create an Option set for country which has list of country names. All the country names list is in excel, How we do this ?

[@ShanesCows]

Answered your other comment.

[@robbe4711]

Could you go around the limit with graph? Is it possible to use it in Powerapps?

[@ShanesCows]

Yes you can use Graph. No, I haven’t tried so not sure what options it presents.

[@lagenteestaloca5875]

Great, Shane, thanks for the video. Your channel is my #1 source goodness/troubleshooter to go to for all things PowerApps... Shane, is there a way to implement/ enable search from one Search Box across multiple galleries within one PA. The source file is Excel with multiple worksheets represented as multiple pages of PA containing respective galleries sourced from the worksheets of the mother-Excel file. Thanks heaps, my head is hurting.. I just cant work out the way...

[@ShanesCows]

I think so. Set the all of the galleries to use the search function with the input being the TextInput.

[@Hammerknocker79]

Whether I use filter or search, my results end up blanking everything out??? Please help

[@ShanesCows]

Try leaving a new comment with your syntax. Maybe you ahve a typo of some sort I can help with.

[@yocopop]

Dear Shane, thanks a lot for this tutorial, i have a question, is it possible to highlight the search result with the typed letter, e.g : Greg in search box , the text in the search result Greg is highlighted. Many thanks

[@franklinjunaylemus6397]

Hi Shane, thank you for all your videos. Is there a way to use the search function for Person or Group column in a datatable?

[@ShanesCows]

Nope only text columns. Look at In operator (recent video) for something you might try

[@franklinjunaylemus6397]

@@ShanesCows thank you for your response. I was able to use filter as a substitute. I will definitely check out the video you recommended for further insight. Have a great day.

[@michaelsmollar9021]

Pretty close to the 4 years mark! Thanks Shane!

[@oshritcohen-shemesh2721]

haha, it's two years from then... Thank you very much for all the videos

[@ShanesCows]

Time flies when you are having fun. 😍

[@Dave_Medeiros]

Shane, Thank you for the video, Do you have any info on how you can search for more than words like using a SPLIT

[@ShanesCows]

Hmmm I haven’t done that best I can recall. Sorry

[@anassid4879]

What if the searching results in the gallery depends upon more than one textinputs. I have tried to do it , however i am unable to find a solution if you have one please write the solution with an example. Thanks in Advance.

[@ShanesCows]

I haven’t done that one. Sorry

[@ophemtech]

Hey shane. well i just started power apps and I created an inventory app with power app using excel as my datasource but the search function doesnt allow me search in more than one column, i mean adding more than one column name to the columns to be searched in the search function doesnt work for me, instead it just keeps loading till it returns empty screen. but so far your video has been helping so far

[@ophemtech]

so maybe there is something i am missing or so. but your content were really helpful

[@ShanesCows]

James you should be able to search as many Text columns as you want. There is a newer version of this video that might help here kzbin.info/www/bejne/oorMY2eloL13htU

[@ophemtech]

Oh okay. Thanks for that. I'll check it out. But also I want to ask why it feels like it's slow sometimes for the data to load especially when I'm doing something that has to do with relationship like one to many or one to one relational modelling. Is that just normal or I'm the one writing buggy functions

[@MemphisPains]

I'm having a problem getting this function to work with a drop down rather than the search bar. Do you have a video or an idea where to find that information?

[@ShanesCows]

Not sure I follow? Maybe give me a few more details and happy to help.

[@MemphisPains]

I'd like to use a drop down control rather than the search box to drive the information pulled into the gallery but it doesn't seem to work. I'll have working section when I use "Search (Datatable, SearchBox.Text, Field1) but if I switch it to Search (Datatable, Dropdown1.text, Field1) it doesn't work.

[@saigudiboina7685]

Thanks Dear, May i know how to writeback to Excel through PowerApps

[@ShanesCows]

Start with thtis video kzbin.info/www/bejne/Y4vCYmaAZZeFhrc

[@joshucoolable]

Hi Shane, great video! Unfortunately I can't use the search function properly because of the amount of data in my SharePoint list (~16000 data), is there any way to get around this? Thanks!

[@ShanesCows]

Nope. Have to change to a better datasource to use Search function

[@prechagirl]

@@ShanesCows You can change the delegation limit from 500 to 2000 under settings in powerapps

[@cesarvegamty]

What is the status of lookup columns in power apps in May, 2020?

[@ShanesCows]

Here is more info kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@zuah04881]

Hi , I am using simiar techinique to filter the data from selected combo box to Data table(Preview) e.g. Filter('CLAIMS PROCESSs',BusinessPlanClass = 'Business Plan Dropdown'.Selected) I get error saying Business Plan Dropdown = There is an error in this formula . Try Revising the formula and running it again , Data type : Control ???? Not sure where I have gone wrong , is there a way I can change the data type control to Text .... Need Help !!!!

[@ShanesCows]

What column type is BusinessPlanClass? Something isn't adding up here.

[@zuah04881]

@@ShanesCows found a way eventually. Thanks for your reply. The datatype for BusinessPlanClass is Text and the source for the table and the dropdown is the same. I use below to make it work. Filter('CLAIMS IBNR PROCESSs', BusinessPlanClass = ddBisPlan.Selected.BusinessPlanClass) Hope others can find it useful.

[@Bursa4k]

you make things so easy in good understandable funny way … huge respect brother 👍🏼

[@ShanesCows]

Thanks. I try. 😊

[@meredithhalverson6627]

Almost 4 years later...this was very helpful! I have a question...do you have a video that shows how to have both a dropdown and search for the same gallery? I have two dropdowns (one reliant on the other) that works well, and the search function that works well, but I would like to be able to do either one. Ideas? Searchbox: Search('Definitions Test',SearchBox.Text,"Title", "Friendly", "BusinessDefinition", "DataOwner") Dropdowns: If(IsBlank(FriendlyDD.Selected.Friendly),If(CategoryDD.Selected.Result="All",'Definitions Test',Filter('Definitions Test',CategoryDD.Selected.Result=Category)),Filter(If(CategoryDD.Selected.Result="All",'Definitions Test',Filter('Definitions Test',CategoryDD.Selected.Result=Category)),FriendlyDD.Selected.Friendly=Friendly))

[@MrJdub34]

HAHAHA, I'm listening to this 3 years later...I know you mentioned 4 in the video but had to put it in!

[@ShanesCows]

It will be 4 soon enough. 😁 Good news the UI has changed but the function use has not.