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. 😎 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.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!
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
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. :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html
I appreciate that! If it helps I did make a follow up video earlier this year. More ideas on how to deal with challenge. 🙂 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.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 ! 💖😊
@@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!
Thanks. There is a newer version if you want to check it out. Power Apps Search and Filter Function with SharePoint + Workarounds ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html 😎
Awesome Walter. There is a video from this year that would help you more if Search is your challenge. :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html
Great to hear! Even better? There is a newer version of this video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html that may help 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iG8SjWtX1yM.html and ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Fstk03c9dcg.html Search(Filter(table, field = dropdown Or dropdown = "All"), SearchInput, "FieldToSearch") Something very close to that.
Crazy isnt' it. BTW. There is a very recent video that show some clever uses workarounds of Search ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html
This video is a newer version if you want to dig in deeper. 😎 Power Apps Search and Filter Function with SharePoint + Workarounds ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.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! :)
Crazy isn't it. Good news there is finally an updated version with some newer ideas for you ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html
@@ShanesCows have you got any recording about using variables? I'm struggling with Search by non-text columns and I believe this this can be managed by creating Global variables
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
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,
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.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
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.
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?
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.
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?
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.
.....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.
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!
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UaBmVUQx_Fk.html
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
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?
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?
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!
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.
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!
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 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?