How to Search on multiple columns in Power Apps | Search Vs IN function

[@derekgray3019]

Ahh Reza, this is a game changer for me, I have been trying for a while to do multi search from a single text box search. So simple, but very effective use of a search text box combined with a search button to setup the variables. This will simplify my already complicated gallery filtering 🎉

[@RezaDorrani]

Awesome!

[@dougydoe]

This is absolutely brilliant!! The assigning of formulas to a variable on the OnChange property of the button and then using these variable within the main filter of the galley's item property is so clever and opens up all these possibilities. I've been figuring out how to do something like this for a while and here is the answer. I need to incorporate these techniques into a project to make my search experiences more slicker. Thanks for sharing always.

[@RezaDorrani]

So glad to hear that! Thanks so much for watching

[@rayanmohammad910]

Hello Reza, I want to express my gratitude for your videos and the hard work you put into creating them. You have become my go-to reference, and I've watched every single one of your videos. Whenever I have a task at hand, I know I can rely on your expertise. I have a specific request: Could you please provide a demo that demonstrates how to effectively utilize the Power Platform in conjunction with SharePoint for managing policies? I believe such a demonstration would greatly benefit me and others who are interested in implementing a policies management system. Once again, thanks to you for all that you do. Your efforts are greatly appreciated

[@RezaDorrani]

Thank You so much! I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community tab of my channel. Most voted topics get added to my backlog. Make sure to post your suggestion whenever the next topic suggestion post comes out. If it gets the max votes, I will add it to my backlog.

[@rayanmohammad910]

@Reza Dorrani Thank you for your prompt response. I would like to submit my topic request and hope that it will receive the maximum number of votes. I greatly appreciate your consideration.

[@RezaDorrani]

@@rayanmohammad910 You would need to wait until I post the next topic suggestion post. It would probably be around Oct-Nov

[@darrelthompson]

@@RezaDorrani I agree with @rayanmohammad910 . You put this video out at the right time for me. I was just talking about this yesterday and I found your video today. Keep up the good work. Thank you.

[@rajasekharreddysanivarapu4239]

@reza Dorrani Your Jacket looks really nice. I am sure some of you would have noticed already. As usual your bringing PowerApps to every viewer home :)

[@RezaDorrani]

Oh thank you!

[@georgegualda4262]

WOW, you out did yourself in this one....

[@RezaDorrani]

Glad to hear that! Thanks George

[@rkirk2k]

Thank you AGAIN Reza! I hope one day to be able to buy you a coffee and thank you in person.

[@RezaDorrani]

Thanks Kirk ☕️

[@shaikhfirdos2723]

Great tricks.. great features explanation as always.. Thanks Reza.

[@RezaDorrani]

Glad you liked it!

[@anjanchidige]

Very crisp and very useful video. As always, thanks for awesome video. 👏

[@RezaDorrani]

My pleasure!

[@techknowledgetutorial]

Nice video Reza, question here if suppose user want to search without clicking search button only if we enter text will it be possible

[@RezaDorrani]

Possible. Onchange of text box you can select the button and hide the button from user experience. I would recommend to set delayoutput of text box to true in this case.

[@magnusjeppesen]

All UX in one place.... 🤩 Really liked this idea, and easy to understand

[@RezaDorrani]

Glad you liked it

[@oluwatobipaul6171]

Thank you Reza. The related table part is a take home for me. I have been looking for a way around it

[@RezaDorrani]

👍

[@graysenm1320]

Great work. I was literally trying to find a way to do this yesterday and you just gave the perfect video on my exact problem. Thank you.

[@RezaDorrani]

Glad I could help!

[@jjpk80]

Simply Genius....

[@RezaDorrani]

Thanks

[@MohammadAli-ts2ev]

Masterpiece❤ The best video on the internet on how to use Search function.

[@RezaDorrani]

Wow, thank you!

[@islamshaban216]

Reza, this last formula was AMAZING 🎉

[@RezaDorrani]

Thanks

[@ruru1419]

Another great one, thanks! 😎

[@RezaDorrani]

Glad you enjoyed it!

[@MegaKumar0]

Great work Reza!.

[@RezaDorrani]

Thank you!

[@SebasTupac]

Amazing. Good job!

[@RezaDorrani]

Thank You

[@DroneEyes]

Great video Reza!!!

[@RezaDorrani]

Thank You so much

[@khiarmohamed1325]

you are master powerapps

[@RezaDorrani]

Thanks so much

[@fam.giannakisflores7780]

Mr Reza this app is available to download? the use of the containers is great

[@RezaDorrani]

If it is then there would be a link in description else no.

[@johannesduplessis7695]

Cool video. Enjoyed it very much.

[@RezaDorrani]

Glad you enjoyed it

[@이촌동파이리]

This is perfect! One question though: How did you make the table like gallery with columns? I don‘t think powerapps has one out of the box.

[@RezaDorrani]

I have done videos on gallery designs. You can check those on my channel.

[@webuildtrust8521]

Hey! Reza thanks for each valuable video you making, please i have one question how can i receive both converted html pdf and attachments which uploaded in attachments columns in one email?

[@RezaDorrani]

Video is related to searching :) I do not have a specific video on your scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@webuildtrust8521]

@@RezaDorrani thanks for your kind feedback Reza. much appreciated.

[@saeedsm57]

Hi Reza, thanks for sharing this amazing search approach. We need to categorize this video as a power fx design pattern.😊

[@RezaDorrani]

That would be cool :)

[@paolovr1970]

Reza Amazing 🙏🙏🙏 thanks for help

[@RezaDorrani]

Most welcome

[@lawrencechiu2802]

Exactly what I was lookin for! Great Explanation! You Da Man Reza!!! Thank you so much.👊

[@RezaDorrani]

Glad it was helpful! Thanks for watching

[@lawrencechiu2802]

@@RezaDorrani what if you wanted to combine this searchbox with multiple Combobox filters? how would you do this?

[@RezaDorrani]

@@lawrencechiu2802 I have done many videos on combining multiple filters. Try checking those and merge it with the pattern shown in this video. Who idea here is to have a one search box experience.

[@Gilgameshx]

Hi Reza, very nice video, how do you do the visual style, i meant i tried to build an app with that style and i could not make, can you please do a short video with the basics styles (shadows, paddings, margings, etc)

[@RezaDorrani]

I have done multiple videos on gallery styling. Check some of my recent ones and the playlist on gallery design.

[@hotelranimahaljaipur9380]

Will implement it Tomorrow

[@RezaDorrani]

👍

[@felixverduin569]

Really clever Reza! Nice solution. But shouldn't it be better to recommend a model driven app if you need this extensive search/filter capabilities? Also what is the performance of the ForAll function on large datasets?

[@RezaDorrani]

This video is focused around canvas Apps. 100% model-driven apps offer a lot of these features out of the box however there are various scenarios for canvas apps connected to Dataverse and the video is catered towards those. ForAll will be performance hit for large results returned after performing the query (which is delegable).

[@felixverduin569]

@@RezaDorrani you are totally right. There are scenario's where your users want these search capabilities in Canvas Apps. Really like the search capability with the LookUp columns, that's pretty genius. How do you come up with these things?

[@RezaDorrani]

@@felixverduin569 I listen to feedback in comments and if there is a common ask - that drives my interest to investigate and explore options. I have a video on similar lines lined up for SharePoint (with less flexibility due to delegation challenges) as well

[@felixverduin569]

@@RezaDorrani keep em coming! Definitely the ones for Dataverse :)

[@sohelnirban5372]

Hi Raza hope you are doing well Just a quick question if I want to allow to users can see only 1 months older data in gallery so what condition needs to put in filter gallery formula ?

[@RezaDorrani]

Check my videos on filtering galleries with different types of columns. They are all places in a Gallery control playlist.

[@sueamin2788]

Hi Reza: This is extremely useful and very well explained learning video. Many Thanks. Just wondering if the "IN" function is available for SP lists as well or just limited to Dataverse tables?

[@RezaDorrani]

IN is delegable with dataverse only.

[@fernandolemos9910]

@@RezaDorrani could you do a similar vídeo using a Share Point list? Thanks

[@RezaDorrani]

@@fernandolemos9910 I have done that as well. Look for the video on my channel. I do not have the direct link handy.

[@jhonatandiaz6420]

Ok, okay, and how do you solve the delegation with the search function in the same scenario? Also, thank you for your contribution and your very valuable help. I follow you from Colombia, Santa Marta. Greetings.

[@RezaDorrani]

Video shows how to solve it :)

[@edwarddejesus1649]

Thank you Reza for this, is it also applicable if we use SharePoint List as your data source instead of Dataverse?

[@RezaDorrani]

Most welcome! I have done many videos on searching with SharePoint. I would recommend to check those.

[@David-mw6ge]

Thanks for the video @Raza, I applied the same in my app. But, No Records are showing when any user open the app. What will be the issue here?

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@jayantrimza]

Hi Reza, Thanks for amazing video! I have a query if search function do not find any record and then when we try to filter with "in" method it display all records as there is no data to filter, I want to show empty in such case and considering delegation in account

[@RezaDorrani]

Check my others videos on searching and filtering.

[@AkishaAnthony]

Great video. I tried implementing this into my Power App but my data sources are SharePoint lists. I am getting the delegation warning using the IN function. Is there a way to get rid of the delegation warning?

[@RezaDorrani]

SharePoint does not support delegation for IN function or Search function

[@AkishaAnthony]

@@RezaDorrani Thanks for your response. What is the best way to overcome this limitation?

[@RezaDorrani]

@@AkishaAnthony Use data sources that support delegation for search and IN function like Dataverse

[@spen2431]

Mind blow 🤯🤯💥💥

[@RezaDorrani]

😊

[@smitakishore9834]

Dear Reza, this is exactly what I need to do but I am already stuck at the first step as I do not use Dataverse. My Power App is connected to a SQL database. How can I achieve the same, i.e. use a single search column?

[@RezaDorrani]

I do not have any video references with sql. Pattern would be similar. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@breadandcheese1880]

@Reza - How would you search a GUID column based on GUID text put into a text box?

[@RezaDorrani]

I have not tried searching on that type of column so not sure (very rarely have I seen users searching in GUID)

[@DCVCPC]

Hey Reza! I’ve watched a lot of your videos and I’m trying to sort of make a display form. Can you pls help me with this code. Patch(‘Equipment Not Functional’, Defaults(‘Equipment Not Functional’), {Title: txtTitle.Text, ‘Department/Location’: txtdept.Text, Area: txtlocation.Text, Reason: txtreason.text, ‘Action Plan till it is Functional’: txttargetdate.text}); I have been getting errors, "The function patch has some invalid arguments" "the type of argument does not match the expected type 'text'", most of these fields are alphabetical and numbers combined. Your help will be much appreciated🙏🏻

[@RezaDorrani]

Helping here on chat without having full context is not an easy option. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@SharanyaNakka]

Hi Reza, we have used the same formula functionality but it is through error to us as Invalid argument type

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@anuradhakulathunga9213]

Hey..i want to include fuzzy matching also when searching words are in misspelled ...how could i do it?

[@RezaDorrani]

I dont think thats an option

[@frenamakenson9844]

1 billion Thx for Sharing this Masterpiece Reza.... UX/UI/Simplicity all in 2 Control on the Screen.... this Is a game Changer, One Comment : for the last part with the Many to Many Relationship, would it work also with a Showcolumn on the variable to only show the unique ID ... instead of using the forall

[@RezaDorrani]

Yes, anyways the variable will include the data limit (500 or 2000) items returned AFTER performing search in a delegable manner. To that you can use ShowColumns.

[@frenamakenson9844]

@@RezaDorrani thank you

[@SourceCodeUniversity]

Hello, is there a way to have multiple search boxes in PowerApps that search in a Document Library? Like you have one search box in this video, instead if you can have more than one search box? For example, if there are 5 columns in a Document Library then I want to have 4 or 5 search boxes in my PowerApp and search results will only show results that match all the search data entered in those search boxes only. Another example, if there are 3 columns in the document library called: Title, Date and ID. Power app search will have 3 search boxes for user to input Title, Date and ID. Search result will only show result that match all three search inputs, i.e: Title, Date and ID. Thank you so much for your valuable time and advice, Reza.

[@RezaDorrani]

Probably possible but not something I have tried. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@SourceCodeUniversity]

Thank you so much@@RezaDorrani

[@ramontaylor4000]

Is it possible to use this technique for a multiline text field?

[@RezaDorrani]

It does not work on multiline text field as they are not delegable.

[@stlaurent26]

Thanks!

[@RezaDorrani]

Welcome

[@kazishahebaz4637]

Hi Reza sir....as we know the maximum character limit of text input is 255.....can we increase that character limit

[@RezaDorrani]

No. I would be worried if someone puts a search text > 255 characters.

[@lutzbeyer5253]

Hey Reza. Great video but I have one question. If I am not completely wrong this solution won't work on large Datasets. Assume the Search Function on the Project Tasks Table would have more then 2000 results... Wouldn't the variable only get the first 2000 results and therefore we might miss some Projects?

[@lutzbeyer5253]

Keyword "record limit"...

[@RezaDorrani]

The search function itself is delegable with Dataverse. Query would be performed server side. The results returned being stored in a variable would be 500 or 2000 depending on data row limit. I hope no project has 500 tasks :)

[@maldavies3374]

Hey @@RezaDorrani, great video as usual. I implemented this on my Booking canvas app & was working great till I tested delegation limit by lowering this to 1 to see if it will still works - but it is only returning that delegation limit for the variable (my learning). My bookings > 2000, so the variable limits are failing to bring back all data. Any advice on running multiple filters such as Search, State, Contractor(N-N), Service(N-N) without variable delegation limits?

[@RezaDorrani]

@@maldavies3374 Not aware of other options for this.

[@jayanthimacherla8676]

Hello rezza, How to sort data in the drop-down list, the data is coming from collection...in power apps

[@RezaDorrani]

Use sort function or sortbycolumns function. I have done video on sort function.

[@trivikram01234]

Hello Reza, Might be out of context, How did you do that onhover zoom experience for record in gallery

[@RezaDorrani]

Gallery has a transition property. You can set that to Push or Pop to create that effect.

[@kazishahebaz4637]

Hello sir .....I am updating document in document library via power apps.....but this document getting check out whenever I'm uploading it via power apps and other user are unable to see that document.........can you please help... please reply

[@RezaDorrani]

I have not come across this issue and not sure how to help. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@dukkysx1410]

You are a legend

[@RezaDorrani]

Thank you for your kind words but Im no legend

[@GordeNN]

IN function will not be available for SharePoint lists right?

[@RezaDorrani]

No. But I have a video on Search for SharePoint lined up to show whats possible. IN and Search are not delegable with SharePoint.

[@GordeNN]

@@RezaDorrani Awesome

[@HiroshimaMS]

So, I suppose the source must be tables, not working with sharepoint lists, right?

[@RezaDorrani]

Search is not a delegable function with SharePoint

[@HiroshimaMS]

@@RezaDorrani ah right! I remember seeing at a glance a video of yours about that, you used filter instead, sorry. I'm new in power apps, I am watching all your videos little by little because I like to test it at the same time, there's a lot of videos out there about power apps, but I always end up seeing yours, they are better in every aspect. Thank you for your work!

[@RezaDorrani]

@@HiroshimaMS Thanks so much

[@rashimalhotra8642]

Hi Reza! I want to show Price List Items in Gallery, and Filter the Price List Items to show only those where Search text IN the name of the related Lookup field Product. It is giving me delegation issue.

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@rashimalhotra8642]

@@RezaDorrani Ok, thanks! Actually the reason for Dataverse delegation is because 'Product' is a lookup field in 'Price list Items' table. And I am trying to search text which is IN the Product lookup's name. The IN operator works if I compare the search text field with a field in Price list item. But it gives delegation warning if I compare the search text field with the Name field in lookup Product field.

[@M87user]

Hi when I am changing from 'Filter' to 'search' function the displayed item no longer navigates to detail screen. Any suggestion how to fix it?

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@rechaly6336]

Hello Reza , can u pls tell me the way how to get the frequently searched result to be on the top of the list in searchable dropdown .

[@RezaDorrani]

For that, you would need to store most searched items in some data source and keep track. I would not advice going down that path.

[@rechaly6336]

@@RezaDorrani My scenario is one is filling timesheet with some project code evry time for every day he is selecting the project ID from the searchable drop down. With out doing search evrytime is there a possibility to get his/her respective id on the top of the list once searched. Like in ATM once we draw some money next time when we try to withdraw machine suggests the same amount

[@RezaDorrani]

@@rechaly6336 Might be possible but something I would have to try to know its feasibility. May be try checking on forums in case someone has done something similar powerusers.microsoft.com

[@rechaly6336]

@@RezaDorrani sure thank you . Once you find any solution. Pls let me know.

[@RezaDorrani]

@@rechaly6336 I have no plans to explore this but if I ever do, I will share

[@kseries100]

How export and import solutions through Desktop flows?

[@RezaDorrani]

Video is on searching in Power Apps :) I have not done much work with PAD. I would recommend posting your query on forums at powerusers.microsoft.com

[@anukachamara641]

It this works for Sharepoint lists?

[@RezaDorrani]

Here is the video for SharePoint - Power Apps Search Vs StartsWith in SharePoint Lists | Delegable Function Selection for Search kzbin.info/www/bejne/d6rJdoudg76NkNU

[@Umtsntrk]

Hello. I have office 365 users in my data table. I want to search by these names. I am getting error. How can I do a name search?

[@RezaDorrani]

I may have done a video on people pickers. Check that one out.

[@satyamdas1854]

Hello Reza, Can you please help on to filter Data table column on run time. Let Say in My Data Table Has 10 columns . I want to display 3 , 4 , 5 Columns etc . And no of column slection will be coming from combo multiselection . I want to store the final result into a collection.

[@RezaDorrani]

I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@kittydoes7600]

Will this work if my database is an excel file?

[@RezaDorrani]

“In” is not a delegable function with excel.

[@kittydoes7600]

@@RezaDorrani thank you so much!

[@the_power_ride]

Hi rezza, Can you please make a video on how we can deploy a sharepoint site's all content along with all settings, permissions, groups, lists, document library and whatever stuff we have(staging environment ) to another site (called production environment) It would be great help if you can make a Video on this Thanks, Huzaifa Siddiqui

[@RezaDorrani]

Hi Huzaifa, I make videos when I receive multiple requests on a topic. I have video ideas with 30+ requests in my backlog. This is the first request for your topic suggestion. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@the_power_ride]

@@RezaDorrani okay rezza, thank you for update 👍

[@kingsleyudeagha]

Will these work for Dataverse as well ?

[@RezaDorrani]

I think the video is based on Dataverse 😊

[@karlgerdschneider6965]

Works with Dataverse but I guess this Search Delegation with IN Filter does not work with SharePoint as Datasource?

[@RezaDorrani]

@@karlgerdschneider6965 I have a video on Search with SharePoint lined up next. SharePoint search will run into delegation limits.

[@christerrussberg3059]

Looking forward for your video with SharePoint as datasource.

[@kingsleyudeagha]

@@RezaDorrani I meant to type SharePoint 😅😅😅. Looking forward to that video.

[@Saif_Ali_Khan_1301]

I hope 'In' operator to be delegable soon with SharePoint as well after Dataverse

[@RezaDorrani]

It surely is a BIG hope

[@CemeteryLarry]

Bummer that these things rollout to GCC so much later

[@RezaDorrani]

Dataverse is in GCC. Might be the IN delegable piece that's probably not yet in GCC.

[@bijayrajbharati7999]

Status(Choice) Auto Choice Date and Time New Assigned Assign Yes/ NO IF , if Yes Current date and time Pending Pending Yes/ NO IF , if Yes Current date and time Suspended Suspend Yes/ NO IF , if Yes Current date and time Completed Completed Yes/ NO IF , if Yes Current date and time How to use the power app formula for this sir , if i selected Yes both date and status choice auto change

[@RezaDorrani]

I would have to try it out to let you know the steps Sir. I would recommend posting your query with screenshots on forums at powerusers.microsoft.com

[@bijayrajbharati7999]

@@RezaDorrani working on small project where i need this , eagerly waiting for your reply sir

[@bijayrajbharati7999]

For current date i use this formula - (on change properties ) of Assign Yes/ NO (UpdateContext({ SelectedChoice: ThisItem.'Assign'.Value}) so default for Current date and value is If(DataCardValue23.Selected.Value="Yes",Now(), Blank()) - date is automated but only problem is only auto choice i cannot do anything on here -

[@RezaDorrani]

@@bijayrajbharati7999 Please post this on the forums

[@RezaDorrani]

@@bijayrajbharati7999 I will need to reproduce this and I have no plans to do that. Please post your issue on the forums.

[@ambarish360]

Woow, great Reza bhai. Do u have any telegram or whatsapp community group?

[@RezaDorrani]

No telegram or whatsapp group