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!
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!
Appreciate that. 😎 ua-cam.com/video/lYi24okXDPs/v-deo.html 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!
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 !
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 ! 💖😊
I appreciate that! If it helps I did make a follow up video earlier this year. More ideas on how to deal with challenge. 🙂 ua-cam.com/video/lYi24okXDPs/v-deo.html
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
@@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! 😊
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!
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.
I think it is a combination of this video ua-cam.com/video/iG8SjWtX1yM/v-deo.html and ua-cam.com/video/Fstk03c9dcg/v-deo.html Search(Filter(table, field = dropdown Or dropdown = "All"), SearchInput, "FieldToSearch") Something very close to that.
Thanks. There is a newer version if you want to check it out. Power Apps Search and Filter Function with SharePoint + Workarounds ua-cam.com/video/lYi24okXDPs/v-deo.html 😎
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! :)
This video is a newer version if you want to dig in deeper. 😎 Power Apps Search and Filter Function with SharePoint + Workarounds ua-cam.com/video/lYi24okXDPs/v-deo.html
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))
I put a search in my PowerApp and it works great but the client is now asking for a search refiner. I was going to put in a drop down to the left of search to store the available search columns. Then when a certain drop down is selected then you can search on only that column. I have tried many different ways but can't seem to get anything to work. Any tips/tricks you may have? BTW your videos are great! This is my first PowerApp and you have helped me a lot!
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?
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
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 ua-cam.com/video/lYi24okXDPs/v-deo.html
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
.....As requested. Four years have passed and your video is still Awesome! I appreciate your efforts. However, when I add the search language as directed, all of the items from the gallery disappear.....Spooky...... Thanks Again.
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...
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
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 ?
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
Hi Shane! I've been loving your videos. Do you know if there is a way to run AWS ElasticSearch within a search component on a PowerApps app? How to call that API from within PowerApps?
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. :(
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?
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.
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 ?
Shane - thanks for video! It's really helped me out. I using the drop-down to show columns search... I get data from a column named 'Group' in my Sharepoint list. What I don't understand is how to prevent showing multiple values of the same name within the group column. Would you direct me in how to fix this? Thanks again for the video :)
Hey Shane, Almost 3 years after the video and still great! I have one big confusion on the Search. I was able to get it to work in the gallery. In SharePoint the column name is "InventoryItem", the only way I could get it to work is to use "Title" in the search function. Title is the label name for ThisItem.InventoryItem, That took me two days to get to work. I am just wondering why?
Say lets add a second table called table2 with the common data of department and a second column name Cat with data from top to bottom "Ed,You,Pete". The gallery will have the 4th column with table2 data for Cat so you will have title,department,favouritecolor and cat. My question is how will you search for the common data at table2 Cat column with only one gallery and what is a "lookup_type value" and how does it work?
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?
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?
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 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.
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 ?
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...
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 Hey! We found a solution for this issue: 1. Create a new text column in the sharepoint list called "Text to search". 2. Add this as a field in the form and set it's datacardvalue.default to the text of your "complex type" columns as: Concatenate(Text(DataCardValue7.Selected.DisplayName),",",Text(DataCardValue15.SelectedDate),",",Text(DataCardValue17.SelectedDate),",",Text(DataCardValue1.Selected.Value)) 3. Do it to 'New form' as well as 'Edit form' 4. Turn he field visible property to 'False'
Hi Shane, thanks for the informative video. I am trying to search a column that contains letters and numbers, eg X1234. Powerapps is returning errors such as "wrong column type" and also invalid arguments on my search. It works perfectly when it is only text, such as XYZ, but when I add numbers it doesn't play nice. Cheers.
@@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,
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
Updated Video for 2022 ua-cam.com/video/lYi24okXDPs/v-deo.html
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!
Great to hear! These are the type of comments that keep me going. :)
@@ShanesCows It's now five years later! Thanks for all the excellent advice.
It’s nearly 3 years later that I’m watching this! 😁 Thanks for all you do!
Glad to help. 😀 😎
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!
Very kind of you. Thanks. 😎
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!
Appreciate that. 😎 ua-cam.com/video/lYi24okXDPs/v-deo.html 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!
@@ShanesCows perfect! Thanks! Have a good day too!
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 !
Happy to help! This is a new version of the video you watched with some cool work arounds you might like. :) ua-cam.com/video/lYi24okXDPs/v-deo.html
It's 4 years now, Shane. Your PowerApps videos remain timeless classics! Nothing has changed. SharePoint lookup columns and PowerApps still don't gel!
Crazy isn't it. I did make a newer version of this video that has some helpful ideas. ua-cam.com/video/lYi24okXDPs/v-deo.html
It is over 4 years later and this was very helpful and easy to understand. I appreciate all of the helpful videos.
Glad it was helpful! Here is the follow up video to this you might enjoy. ua-cam.com/video/lYi24okXDPs/v-deo.html
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 ! 💖😊
That is awesome! Thanks for the kind words Rachel.
It’s 6 yrs! Thanks for the video! This solved my problems today at work!
🤣 That is awesome. There is an updated version if it helps. ua-cam.com/video/lYi24okXDPs/v-deo.html
Viewing 3 yrs 11 months later and this video is still useful. Thanks Shane.
Thanks Abe😎 I am glad this function hasn't changed at all. :)
Almost 4 years later... This video is STILL Going Strong! Thanks Shane!
Thanks Shawn. Guess it is about time I remake some of these 4 year old videos. 😁
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.
I appreciate that! If it helps I did make a follow up video earlier this year. More ideas on how to deal with challenge. 🙂 ua-cam.com/video/lYi24okXDPs/v-deo.html
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
Still relevant 5 years later! Thanks for all you do for the community!
Isn't that crazy. There is an updated version here if you want to go deeper. ua-cam.com/video/lYi24okXDPs/v-deo.html
@@ShanesCows watched that one as well thanks again!
5 years later now! Thanks Shane, you've got me moving in the right direction, even 5 years on!
Mandy there is a more recent, deeper version of this video if it helps. ua-cam.com/video/lYi24okXDPs/v-deo.html 🤩
@@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! 😊
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!
As you said. I am watching after 4 years. Anyway your tutorials are precious and accurate. great work. thanks for helping us. Cheers
Great to hear! Even better? There is a newer version of this video. ua-cam.com/video/lYi24okXDPs/v-deo.html that may help you.
@@ShanesCows Thank you
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.
I think it is a combination of this video ua-cam.com/video/iG8SjWtX1yM/v-deo.html and ua-cam.com/video/Fstk03c9dcg/v-deo.html
Search(Filter(table, field = dropdown Or dropdown = "All"), SearchInput, "FieldToSearch")
Something very close to that.
It's not exactly 3 years, March 2021, since you created this video! Thanks for your help.
Crazy. 😊
Hi Shane! I watch your videos all the time, they are so helpful, THANK YOU!!!! I'm viewing this 3.25 years later! :-)
4 years! Dude you keep on rocking!
Thanks. There is a newer version if you want to check it out. Power Apps Search and Filter Function with SharePoint + Workarounds
ua-cam.com/video/lYi24okXDPs/v-deo.html 😎
5 years later! Thanks for the video that helped me :)
Crazy. There is a new version of this video if it helps you ua-cam.com/video/lYi24okXDPs/v-deo.html
Jajajajaja 5 years later and I am watching this video. Hi Shane ❤thanks for the video (:
That is awesome and crazy. There is a new version of this video now if it helps. ua-cam.com/video/lYi24okXDPs/v-deo.html
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! :)
Watching 3 years after, thanks for all the good info bro ! very helpful !
Awesome Juan. 🤩
Haha it is four years. I am learning a lot from your thank you for all your help!!!!!
Awesome Walter. There is a video from this year that would help you more if Search is your challenge. :) ua-cam.com/video/lYi24okXDPs/v-deo.html
watching on november 24th 2020. great content. got my search working in no time at all
Awesome. Most of these videos I have stood the test of time well.
Pretty close to the 4 years mark! Thanks Shane!
HAHAHA, I'm listening to this 3 years later...I know you mentioned 4 in the video but had to put it in!
It will be 4 soon enough. 😁 Good news the UI has changed but the function use has not.
you make things so easy in good understandable funny way … huge respect brother 👍🏼
Thanks. I try. 😊
I am your big fan. Videos are simple and straight to the point. Excellent explanation as well
Thanks 😊
I'll join in.... it's been 4 years! Planning on going through at least 1 video a day.
Lots to learn. Hope you enjoy. 😎
It's now 5 days short of your 4 years mark. Yes people are still watching!
So close. The crazy thing is nothing has changed for the function in that time. 😍
Hey Shane... you said in the video to comment that i am watching in '4 years from now'. and yes, much has changed in the interim :)
Crazy. Good news function is the same. UI is totally differewnt though 😁
Nearly 4... thanks for your videos mate!
Crazy. Good news this function hasn't changed at all in that time. :)
haha, it's two years from then...
Thank you very much for all the videos
Time flies when you are having fun. 😍
2 years later I hit the like and you reach 500 :)
Thank you, thank you 😊
Yep, more than three years 9 more months and it will be 4 years, Thanks Shane!
Of course 😎
Great video!!! And I am watching it 3 years later (June 2021)
yup, it's been four years! thanks for the great content!
Very helpful! I got my search box working immediately.
Thank you.
Awesome.
Hahaha, it's two years later! Nice video, thanks for putting it together
You bet! Search hasn't changed at all in that time. 😍
I'm here. 6 years later. As of today, Delegation suggestions have been re-classified as warnings.
This video is a newer version if you want to dig in deeper. 😎 Power Apps Search and Filter Function with SharePoint + Workarounds
ua-cam.com/video/lYi24okXDPs/v-deo.html
Hi, It`s four years now. Thank you for this video
You're welcome Camila - There is a follow up with some new ideas to help here ua-cam.com/video/lYi24okXDPs/v-deo.html
@@ShanesCows thank you, I will check this out
Watching this almost 3 years to the day.
Glad it still hasn't changed. 😊
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))
Thanks! I was able to make a searchbox in one go with this info
Awesome! Congrats.
Hi Shane great video it worked a treat. Quick Q is there anyway the seach box can look for a value. Thank you
Hi Karen I think you are asking for type ahead and not really possible.
I put a search in my PowerApp and it works great but the client is now asking for a search refiner. I was going to put in a drop down to the left of search to store the available search columns. Then when a certain drop down is selected then you can search on only that column. I have tried many different ways but can't seem to get anything to work. Any tips/tricks you may have? BTW your videos are great! This is my first PowerApp and you have helped me a lot!
Collections. 😀 You need to have the dropdown modify a collection with their selection. Then have the gallery use the collection not the datasource.
Hahaha it's 4 years from now -- for real, GREAT videos
Thanks 😁
Not quite four years in the future, but still super helpful 3 years on!
Fingers crossed they don't change the function this year. 3 years and counting.
Awesome tutorial, man, thanks a lot. Btw, how the heck you make the intro almost identical all the time....impossible task
Lots of practice 😁
It's 3 years later....still watching.
Good news nothing has changed. 😀
Hahaha over 3.5 years later... Awesome teaching!
Thanks Doug 😎
I absolutely love the Bold Zebras intro.
I do too. Thanks 😍
4 years, yessir mr. prognosticator. :)
Crazy isnt' it. BTW. There is a very recent video that show some clever uses workarounds of Search ua-cam.com/video/lYi24okXDPs/v-deo.html
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?
Yes you can nest filter and search. Replace the Table1 in your search formula with the filter formula.
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
so maybe there is something i am missing or so. but your content were really helpful
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 ua-cam.com/video/lYi24okXDPs/v-deo.html
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
.....As requested. Four years have passed and your video is still Awesome! I appreciate your efforts. However, when I add the search language as directed, all of the items from the gallery disappear.....Spooky...... Thanks Again.
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...
I think so. Set the all of the galleries to use the search function with the input being the TextInput.
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
Excel isn’t a great datasource. Not sure there is a way to overcome this b
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 ?
Nope. Search function only accepts strings.
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
Not possible with SharePoint. Watch this video on Delegation for more thoughts. ua-cam.com/video/UaBmVUQx_Fk/v-deo.html
Hi Shane! I've been loving your videos. Do you know if there is a way to run AWS ElasticSearch within a search component on a PowerApps app? How to call that API from within PowerApps?
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. :(
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?
@@ShanesCows Thank you. I did consider a gallery. That would make collecting them to pass later much easier. I'll give it a try.
Thanks for the video. Does this work only on Galleries? I'm trying to apply a search box on my data table.
Nope, should work on a datatable. Put the Search() function in the Items property of the data table.
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.
You can only search on Text columns 😑😑
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
Thanks for the reminder.
@@ShanesCows thank You.! I could finish my work thanks to your video
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 ?
Yes and no. You can raise the limit to 2000. Watch my video on Delegation I just released for more info.
PowerApps Delegation and the 500 item limit ua-cam.com/video/UaBmVUQx_Fk/v-deo.html
Shane - thanks for video! It's really helped me out. I using the drop-down to show columns search... I get data from a column named 'Group' in my Sharepoint list. What I don't understand is how to prevent showing multiple values of the same name within the group column. Would you direct me in how to fix this? Thanks again for the video :)
Hey Shane, Almost 3 years after the video and still great! I have one big confusion on the Search. I was able to get it to work in the gallery. In SharePoint the column name is "InventoryItem", the only way I could get it to work is to use "Title" in the search function. Title is the label name for ThisItem.InventoryItem, That took me two days to get to work. I am just wondering why?
Search is just an old function that doesn't understand displaynames :( A few of the functions are like that. AddColumns is another example.
@@ShanesCows So we should switch to using filter instead?
Say lets add a second table called table2 with the common data of department and a second column name Cat with data from top to bottom "Ed,You,Pete". The gallery will have the 4th column with table2 data for Cat so you will have title,department,favouritecolor and cat. My question is how will you search for the common data at table2 Cat column with only one gallery and what is a "lookup_type value" and how does it work?
Look up my video on SharePoint lookup columns. It show how to do Relationships
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?
For 2 try lookup to get the data. Yes for 1
Thanks Shane, these videos are 10/10
You are very kind. 🐶
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?
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.
That should work. Hmm. Not sure.
Thanks bro, you saved me a lot of hours at work!
Awesome 😎
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?
Nope only text columns. Look at In operator (recent video) for something you might try
@@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.
Thank you for this tutorial, but my problem is that I use a people picker for the Employee column
Thanks Shane, it's now 4 years ago lol...Thanks dude..
too funny.... I'm watching this in late 2023.... more than 4 years later!
Awesome. Good news there is a newer version if you need it. ua-cam.com/video/lYi24okXDPs/v-deo.html 💛 Thanks!
So would there be a disadvantage of using Filter instead of Search? Isn't it pretty much the same?
They are similar. Sometime next week I will make the video and finish my notes on Filter so I can accurately compare for you.
It's been almost 3 years from your video!
Thankfully this function has changed exactly zero in that time. 🤩
@@ShanesCows , yes, you’re right. Thank you Shane for the great content. Keep it going! Best regards
Shane, Thank you for the video, Do you have any info on how you can search for more than words like using a SPLIT
Hmmm I haven’t done that best I can recall. Sorry
Awesome Shane thanks a lot for your great help, you are awesome Buddy
No worries!
can't say 4 years but 3 it is @Shane Young . thanks for videos they are really good
Thanks 😀
Landed here, learned something. No blathering.
Glad to help. 😀
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 ?
Answered your other comment.
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...
Solid question. Maybe use delay output on the text input.
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!
Nope. Have to change to a better datasource to use Search function
@@ShanesCows You can change the delegation limit from 500 to 2000 under settings in powerapps
Could you go around the limit with graph? Is it possible to use it in Powerapps?
Yes you can use Graph. No, I haven’t tried so not sure what options it presents.
Hi. Thank you very much. I love your videos! One question about the SEARCH - why can't I do it with sharepoint list "Choice" or "Person" columns?
Those are complex column types and have different rules. 😑
@@ShanesCows Hey! We found a solution for this issue: 1. Create a new text column in the sharepoint list called "Text to search". 2. Add this as a field in the form and set it's datacardvalue.default to the text of your "complex type" columns as: Concatenate(Text(DataCardValue7.Selected.DisplayName),",",Text(DataCardValue15.SelectedDate),",",Text(DataCardValue17.SelectedDate),",",Text(DataCardValue1.Selected.Value)) 3. Do it to 'New form' as well as 'Edit form' 4. Turn he field visible property to 'False'
@@ורדפרידמן This was better than nothing as I needed to search a couple of choice columns. Thanks
Hi Shane, thanks for the informative video. I am trying to search a column that contains letters and numbers, eg X1234. Powerapps is returning errors such as "wrong column type" and also invalid arguments on my search. It works perfectly when it is only text, such as XYZ, but when I add numbers it doesn't play nice. Cheers.
What if you use the Text function? Text(YourInput)
Got it working, had to format my excel static data column as "Text". Cheers :)
Hello Shane, first of all Thanks!
Can you please suggest how we can filter a powerapps gallery by multiple keywords separated by ","
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
@@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!
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?
Thanks Dear, May i know how to writeback to Excel through PowerApps
Start with thtis video ua-cam.com/video/-Z_13J02RPU/v-deo.html
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
Hi Shane.
How Can I use the Filter Function to predict words from a Sharepoint List?
I have never tried.
Hi Shane, I'm getting a yellow warning triangle when I do the exact same as you.. Any idea on how to fix this?
You are going to like it but you need to learn about Delegation. ua-cam.com/video/UaBmVUQx_Fk/v-deo.html