Updated Video for 2022 kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@Ambular892 жыл бұрын
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!
@ShanesCows2 жыл бұрын
Great to hear! These are the type of comments that keep me going. :)
@johnswire747 ай бұрын
@@ShanesCows It's now five years later! Thanks for all the excellent advice.
@mandijohnson-fisher53703 жыл бұрын
It’s nearly 3 years later that I’m watching this! 😁 Thanks for all you do!
@ShanesCows3 жыл бұрын
Glad to help. 😀 😎
@cjfarris79633 жыл бұрын
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!
@ShanesCows3 жыл бұрын
Very kind of you. Thanks. 😎
@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. 😎 kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.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!
@happenstancecv Жыл бұрын
@@ShanesCows perfect! Thanks! Have a good day too!
@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. kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@abewearsshades27362 жыл бұрын
Viewing 3 yrs 11 months later and this video is still useful. Thanks Shane.
@ShanesCows2 жыл бұрын
Thanks Abe😎 I am glad this function hasn't changed at all. :)
@2JPerfomanceHorses6 ай бұрын
Still relevant 5 years later! Thanks for all you do for the community!
@ShanesCows6 ай бұрын
Isn't that crazy. There is an updated version here if you want to go deeper. kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@2JPerfomanceHorses6 ай бұрын
@@ShanesCows watched that one as well thanks again!
@mangporkung2 жыл бұрын
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 !
@ShanesCows2 жыл бұрын
Happy to help! This is a new version of the video you watched with some cool work arounds you might like. :) kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@diligentguy46792 жыл бұрын
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
@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. 🙂 kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@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. kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@rachelshalem3 жыл бұрын
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 ! 💖😊
@ShanesCows3 жыл бұрын
That is awesome! Thanks for the kind words Rachel.
@EpicBizHero2 жыл бұрын
Almost 4 years later... This video is STILL Going Strong! Thanks Shane!
@ShanesCows2 жыл бұрын
Thanks Shawn. Guess it is about time I remake some of these 4 year old videos. 😁
@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. kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html 🤩
@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! 😊
@25June20112 жыл бұрын
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!
@JoeGenest3 жыл бұрын
It's not exactly 3 years, March 2021, since you created this video! Thanks for your help.
@ShanesCows3 жыл бұрын
Crazy. 😊
@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. kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html that may help you.
@funmemes5915 Жыл бұрын
@@ShanesCows Thank you
@heejungno18943 жыл бұрын
Hi Shane! I watch your videos all the time, they are so helpful, THANK YOU!!!! I'm viewing this 3.25 years later! :-)
@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 kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@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 kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html 😎
@wcmbradyparent2 жыл бұрын
Haha it is four years. I am learning a lot from your thank you for all your help!!!!!
@ShanesCows2 жыл бұрын
Awesome Walter. There is a video from this year that would help you more if Search is your challenge. :) kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@itsbubbalips11 ай бұрын
Jajajajaja 5 years later and I am watching this video. Hi Shane ❤thanks for the video (:
@ShanesCows11 ай бұрын
That is awesome and crazy. There is a new version of this video now if it helps. kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@juanmillan87643 жыл бұрын
Watching 3 years after, thanks for all the good info bro ! very helpful !
@ShanesCows3 жыл бұрын
Awesome Juan. 🤩
@AdrianHedley3 жыл бұрын
watching on november 24th 2020. great content. got my search working in no time at all
@ShanesCows3 жыл бұрын
Awesome. Most of these videos I have stood the test of time well.
@galinagolant3 жыл бұрын
Great video!!! And I am watching it 3 years later (June 2021)
@user-jt2rk8qz8s7 ай бұрын
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.
@ShanesCows7 ай бұрын
I think it is a combination of this video kzfaq.info/get/bejne/n61ohs2I2b6VqYE.html and kzfaq.info/get/bejne/fNmknpNkyJ_Ik5s.html Search(Filter(table, field = dropdown Or dropdown = "All"), SearchInput, "FieldToSearch") Something very close to that.
@oshritcohen-shemesh27212 жыл бұрын
haha, it's two years from then... Thank you very much for all the videos
@ShanesCows2 жыл бұрын
Time flies when you are having fun. 😍
@MrJdub342 жыл бұрын
HAHAHA, I'm listening to this 3 years later...I know you mentioned 4 in the video but had to put it in!
@ShanesCows2 жыл бұрын
It will be 4 soon enough. 😁 Good news the UI has changed but the function use has not.
@jeffreyshimp70693 жыл бұрын
It's now 5 days short of your 4 years mark. Yes people are still watching!
@ShanesCows3 жыл бұрын
So close. The crazy thing is nothing has changed for the function in that time. 😍
@magdialameen79603 жыл бұрын
Yep, more than three years 9 more months and it will be 4 years, Thanks Shane!
@ShanesCows3 жыл бұрын
Of course 😎
@gogreen04174 жыл бұрын
I am your big fan. Videos are simple and straight to the point. Excellent explanation as well
@ShanesCows4 жыл бұрын
Thanks 😊
@RentAham3 жыл бұрын
Very helpful! I got my search box working immediately. Thank you.
@ShanesCows3 жыл бұрын
Awesome.
@knpckw6 жыл бұрын
you make things so easy in good understandable funny way … huge respect brother 👍🏼
@ShanesCows5 жыл бұрын
Thanks. I try. 😊
@oliveirafcamila Жыл бұрын
Hi, It`s four years now. Thank you for this video
@ShanesCows Жыл бұрын
You're welcome Camila - There is a follow up with some new ideas to help here kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@oliveirafcamila Жыл бұрын
@@ShanesCows thank you, I will check this out
@keefchi6470 Жыл бұрын
I'll join in.... it's been 4 years! Planning on going through at least 1 video a day.
@ShanesCows Жыл бұрын
Lots to learn. Hope you enjoy. 😎
@CaptnDoug2 жыл бұрын
Hahaha over 3.5 years later... Awesome teaching!
@ShanesCows2 жыл бұрын
Thanks Doug 😎
@michaelsmollar90212 жыл бұрын
Pretty close to the 4 years mark! Thanks Shane!
@sethcalkins69114 жыл бұрын
Hahaha, it's two years later! Nice video, thanks for putting it together
@ShanesCows4 жыл бұрын
You bet! Search hasn't changed at all in that time. 😍
@TheBishopEmpire3 жыл бұрын
Watching this almost 3 years to the day.
@ShanesCows3 жыл бұрын
Glad it still hasn't changed. 😊
@JohnnyDickenz3 жыл бұрын
Hahaha it's 4 years from now -- for real, GREAT videos
@ShanesCows3 жыл бұрын
Thanks 😁
@howardcallahan10543 жыл бұрын
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! :)
@user-sz5qb3rq6f2 жыл бұрын
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 :)
@ShanesCows2 жыл бұрын
Crazy. Good news function is the same. UI is totally differewnt though 😁
@oscarotalvaro77233 жыл бұрын
Nearly 4... thanks for your videos mate!
@ShanesCows3 жыл бұрын
Crazy. Good news this function hasn't changed at all in that time. :)
@lenzy112 жыл бұрын
4 years, yessir mr. prognosticator. :)
@ShanesCows2 жыл бұрын
Crazy isnt' it. BTW. There is a very recent video that show some clever uses workarounds of Search kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@robertpapancsev88914 жыл бұрын
2 years later I hit the like and you reach 500 :)
@ShanesCows4 жыл бұрын
Thank you, thank you 😊
@franciscoperireis7866 Жыл бұрын
I'm here. 6 years later. As of today, Delegation suggestions have been re-classified as warnings.
@ShanesCows Жыл бұрын
This video is a newer version if you want to dig in deeper. 😎 Power Apps Search and Filter Function with SharePoint + Workarounds kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@motley23crued8 ай бұрын
too funny.... I'm watching this in late 2023.... more than 4 years later!
@ShanesCows8 ай бұрын
Awesome. Good news there is a newer version if you need it. kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html 💛 Thanks!
@ivannaivanova36234 жыл бұрын
I absolutely love the Bold Zebras intro.
@ShanesCows4 жыл бұрын
I do too. Thanks 😍
@keelywigfall26873 жыл бұрын
It's 3 years later....still watching.
@ShanesCows3 жыл бұрын
Good news nothing has changed. 😀
@defyingblueprints69146 жыл бұрын
Thanks! I was able to make a searchbox in one go with this info
@ShanesCows6 жыл бұрын
Awesome! Congrats.
@piscocomp59003 жыл бұрын
Not quite four years in the future, but still super helpful 3 years on!
@ShanesCows3 жыл бұрын
Fingers crossed they don't change the function this year. 3 years and counting.
@ninjamode6173 жыл бұрын
Thanks Shane, these videos are 10/10
@ShanesCows3 жыл бұрын
You are very kind. 🐶
@morneschmidt78292 жыл бұрын
Thanks Shane, it's now 4 years ago lol...Thanks dude..
@karolinaunderwood10392 жыл бұрын
This is excellent, as always. thank you so much.
@ShanesCows2 жыл бұрын
Happy to help. Have a great day. 🐶
@karolinaunderwood10392 жыл бұрын
@@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
@LabracadabradorBamboozle4 жыл бұрын
Thanks bro, you saved me a lot of hours at work!
@ShanesCows4 жыл бұрын
Awesome 😎
@LynchDwayne2 жыл бұрын
ha ha it's four years from when you posted this!.
@ShanesCows Жыл бұрын
Crazy isn't it. Good news there is finally an updated version with some newer ideas for you kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@RustomSherdiwala2 жыл бұрын
haha, I'm watching this almost 4 years later!
@ShanesCows2 жыл бұрын
Crazy 🤪
@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?
@harittzpeawsaad442 жыл бұрын
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.
@ShanesCows2 жыл бұрын
You can only search on Text columns 😑😑
@KaneTaichou2 жыл бұрын
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. :(
@ShanesCows2 жыл бұрын
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?
@KaneTaichou2 жыл бұрын
@@ShanesCows Thank you. I did consider a gallery. That would make collecting them to pass later much easier. I'll give it a try.
@aminahamilton17902 жыл бұрын
Thanks for the video. Does this work only on Galleries? I'm trying to apply a search box on my data table.
@ShanesCows2 жыл бұрын
Nope, should work on a datatable. Put the Search() function in the Items property of the data table.
@karenfingerhut62064 жыл бұрын
Hi Shane great video it worked a treat. Quick Q is there anyway the seach box can look for a value. Thank you
@ShanesCows4 жыл бұрын
Hi Karen I think you are asking for type ahead and not really possible.
@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 kzfaq.info/get/bejne/or-ZZZeg0L6ogKc.html
@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
@alfonsolans3 жыл бұрын
Awesome Shane thanks a lot for your great help, you are awesome Buddy
@ShanesCows3 жыл бұрын
No worries!
@dvdramm Жыл бұрын
Thank you for this tutorial, but my problem is that I use a people picker for the Employee column
@felipeangeles24853 жыл бұрын
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
@ShanesCows3 жыл бұрын
Thanks for the reminder.
@felipeangeles24853 жыл бұрын
@@ShanesCows thank You.! I could finish my work thanks to your video
@PADARIAD3 жыл бұрын
can't say 4 years but 3 it is @Shane Young . thanks for videos they are really good
@ShanesCows3 жыл бұрын
Thanks 😀
@heaven4ever45 жыл бұрын
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?
@ShanesCows5 жыл бұрын
Yes you can nest filter and search. Replace the Table1 in your search formula with the filter formula.
@chrisroulaux622 жыл бұрын
Hi Shane, I'm getting a yellow warning triangle when I do the exact same as you.. Any idea on how to fix this?
@ShanesCows2 жыл бұрын
You are going to like it but you need to learn about Delegation. kzfaq.info/get/bejne/i8dyoLmGtt7Ddp8.html
@traviskennedy78022 жыл бұрын
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?
@psychoba3 жыл бұрын
It's been almost 3 years from your video!
@ShanesCows3 жыл бұрын
Thankfully this function has changed exactly zero in that time. 🤩
@psychoba3 жыл бұрын
@@ShanesCows , yes, you’re right. Thank you Shane for the great content. Keep it going! Best regards
@lakshaynayyar44894 жыл бұрын
Thanks a lot Shane! For sharing this video.
@ShanesCows4 жыл бұрын
You are welcome 🙏
@MarcoGiampaoli5 жыл бұрын
Landed here, learned something. No blathering.
@ShanesCows5 жыл бұрын
Glad to help. 😀
@vikasumapathy50564 жыл бұрын
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 ?
@ShanesCows4 жыл бұрын
Nope. Search function only accepts strings.
@ankitamohapatra57062 жыл бұрын
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?
@mathieupelletier4024 жыл бұрын
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,
@ShanesCows4 жыл бұрын
Search only works for text columns. ChoiceColumn.Value
@Imran559203 жыл бұрын
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.
@ShanesCows3 жыл бұрын
Sorry I am slow. I have never tried that so not sure.
@lagenteestaloca58752 жыл бұрын
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...
@ShanesCows2 жыл бұрын
I think so. Set the all of the galleries to use the search function with the input being the TextInput.
@meredithhalverson66272 жыл бұрын
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))
@agustinmisaza3 жыл бұрын
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
@ShanesCows3 жыл бұрын
Not possible with SharePoint. Watch this video on Delegation for more thoughts. kzfaq.info/get/bejne/i8dyoLmGtt7Ddp8.html
@darylbingham83322 жыл бұрын
.....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.
@kevssignsngraphics3 жыл бұрын
Awesome, it is 2020 !
@ShanesCows3 жыл бұрын
Crazy isn’t it. 😎
@Al.sabea.mustafa6 жыл бұрын
WOW WOW WOW Shane YOU killing me man,Thanks bro,so helpfull so powerfull just what i was SEARCH for.Cant wait for Filter Video .
@ShanesCows6 жыл бұрын
Filter video is close. Glad this helped.
@luisaugustomeyer71783 жыл бұрын
Hi Shane. How Can I use the Filter Function to predict words from a Sharepoint List?
@ShanesCows3 жыл бұрын
I have never tried.
@nishantkumar82234 жыл бұрын
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
@ShanesCows4 жыл бұрын
Excel isn’t a great datasource. Not sure there is a way to overcome this b
@dylangao68502 жыл бұрын
Awesome tutorial, man, thanks a lot. Btw, how the heck you make the intro almost identical all the time....impossible task
@ShanesCows2 жыл бұрын
Lots of practice 😁
@colby43903 жыл бұрын
how would you format the search function if you were dealing with numbers? It appears that search can only work with Text.
@ShanesCows3 жыл бұрын
Correct. You would have to change the column to text. Maybe use the AddColumns function and Text(columnname) to get it to text?
@laurenpruitt19415 жыл бұрын
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!
@ShanesCows5 жыл бұрын
Collections. 😀 You need to have the dropdown modify a collection with their selection. Then have the gallery use the collection not the datasource.
@shubhamsatpathy64893 жыл бұрын
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.
@ShanesCows3 жыл бұрын
Not sure. SOrry
@howardcallahan10542 жыл бұрын
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 :)
@Sobathp3 жыл бұрын
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.
@ShanesCows3 жыл бұрын
That should work. Hmm. Not sure.
@implementedgmbh5 жыл бұрын
Great explanations! Thanks for your video!!
@ShanesCows5 жыл бұрын
Welcome
@zacharyrobertson32612 жыл бұрын
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?
@yocopop4 жыл бұрын
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
@ammaryuliodasmansyah98524 жыл бұрын
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!
@ShanesCows4 жыл бұрын
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. kzfaq.info/get/bejne/i8dyoLmGtt7Ddp8.html
@mudrasasidhar5 жыл бұрын
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?
@ShanesCows5 жыл бұрын
For 2 try lookup to get the data. Yes for 1
@franklinjunaylemus63974 жыл бұрын
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?
@ShanesCows4 жыл бұрын
Nope only text columns. Look at In operator (recent video) for something you might try
@franklinjunaylemus63974 жыл бұрын
@@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.
@merrilantoney84542 жыл бұрын
HI.. Thank you very much.. Yeah it's almost 4 years now.. :)
@julireid95744 жыл бұрын
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?