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

In this video, you will learn how to use the Power Apps Search Function & IN function. These functions are useful to allow users to search through all items in your data source and/or filter your data. We will build a search box, look at delegation (working with large data sources) & create a ONE search experience in Power Apps by searching on multiple columns in Dataverse Table.

Power Apps Search how to video covers the following:
✅ Search function
✅ IN Function
✅ Search and IN delegable with Dataverse?
✅ Search on multiple columns in PowerApps
✅ Search in Text, Choice, Lookup and Related Tables in Dataverse

My PowerApps Delegation Playlist:

#PowerApps #Search #Dataverse #Delegation

Table of Contents:
00:00 - Introduction to Search in multiple columns in PowerApps
00:41 - Power Apps Search scenario with Dataverse and related tables
02:45 - How to Search across multiple columns in Power Apps
04:37 - Search based on Choice column in Power Apps with IN Function
10:31 - Search on Lookup column in Power Apps
12:20 - Power Apps Search on related table in Dataverse
15:13 - Subscribe to Reza Dorrani channel

[derekgray]

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 🎉

[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.

[graysenm]

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.

[anjanchidige]

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

[oluwatobipaul]

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

[MohammadAli-tsev]

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

[rkirkk]

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

[lawrencechiu]

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

[shaikhfirdos]

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

[rajasekharreddysanivarapu]

@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 :)

[magnusjeppesen]

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

[rayanmohammad]

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

[saeedsm]

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

[georgegualda]

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

[islamshaban]

Reza, this last formula was AMAZING 🎉

[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)

[smkrokm]

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.

[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

[fam.giannakisflores]

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

[jhonatandiaz]

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.