Filter and Search Records in Power Apps

Welcome to Power Apps Step by Step Beginner tutorial series. My self Dhruvin Shah you are watching the 14th part of the Power Apps Beginner Series. During this chapter, we will talk about how we can perform Filtering and Search in Power Apps Grid Records.

In my previous video, we have developed one Grid with the help of Custom Gallery Control. During this session, we will build a dropdown and search box. Based on the selected value from the dropdown or based on search text from the search box we will implement the Filter function in Power Apps Gallery.

With this, we will also learn how we can add the “All” option in dropdown and apply appropriate conditions in Filtering.

Here, are some chapters where you can skip yourself.

Chapters:
00:00 Introduction
00:24 End Result of Search and Filter
02:00 Add search box and Dropdown in Power Apps
03:24 Code to bind Dropdown with Choices
04:25 Add “All” option in Power Apps Dropdown
06:07 Bind Choice in Dropdown
08:43 Filter based on selected value from the dropdown
15:17 Implement Search with Power Apps Records
16:35 Multi-Column Search with Single Text Field in Power Apps
19:00 Summary

#PowerApps
#PowerPlatform
#CanvasApp
#PowerAppsBeginnerSeries
#PowerAppswithDhruvin

The full Power Apps beginner course is free for everyone. The main goal to develop this course is to give you all the proper direction to get started with Power Apps learning!

Happy Power Apping!!
***************************
Link for Entire Playlist:

Link for Blog:

Check all Chapters using the following link:

Chapter 0:
Power Apps Tutorial for Beginner | The Complete Step by Step Guide to start Power Apps Canvas App

Chapter 1:
Introduction to Power Apps | What is Power Apps?

Chapter 2:
How to start with Power Apps development Process? – Overview of Tools, Licensing and Environment

Chapter 3:
Customize a SharePoint List form using Power Apps

Chapter 4:
Introduction to Power Apps Canvas App | What is Standalone Power Apps Canvas App?

Chapter 5:
Power Apps Standalone App Vs Customized List Form

Chapter 6:
Variables in Power Apps

Chapter 7:
Collection in Power Apps

Chapter 8:
Build your first Power Apps Canvas App for Leave Management System

Chapter 9:
Develop Forms in Power Apps Canvas App– Implement New form with Real Life Scenarios

Chapter 10:
Develop Forms in Power Apps Canvas App– Implement Edit form with Real Life Scenarios

Chapter 11:
Create Grid View in Power Apps with Custom Gallery Control

Chapter 12:
Create Grid View in Power Apps with Data table Control

Chapter 13:
Gallery Vs Data table in Power Apps

Chapter 14:
Filter and Search Records in Power Apps

Chapter 15:
Apply Sort on Multiple Column in Power Apps

Chapter 16:
Sort, Filter and Search Together for Galleries or Data tables in Power Apps

Chapter 17:
How to Call Power Automate Flow from Power Apps with Parameters?

Chapter 18:
How to Publish Power Apps Canvas App?

Chapter 19:
Access Management for Power Apps Canvas App | Sharing Power Apps Canvas App

Chapter 20:
Restore Previous Version of the Canvas App in Power Apps

Chapter 21:
Manage Roles in Power Apps Canvas App with Power Automate and SharePoint

Chapter 22:
How to Export and Import Customized SharePoint Power Apps Form from Development to Production?

[axelrumkorf]

Thank you my M365 hero! You made my day! I've been searching for many hours for a solution to combining text search and filtering in a dropdown! Thanks to you I got it done!

[digamberhampa]

Dhruvin Shah, you’ve done a great job!

[jray]

Dhruvin, you’ve done a great job!
Thank you for the work you’ve put into this
I like how you have the video divided up as well

[vmohakrish]

hey Dhruvin!! you just make power apps look so simple. Appreciate your effort

[krishnakishore]

Excellent video, very clearly explained about filters

[bank_po]

Efforts put by you in writing the description of each video are commendable. Thanks for providing such good videos for free.

[abewearsshades]

Your videos are amazing Dhruvin. Thank you for sharing!

[kunireddysrikanthreddy]

Excellent video, exactly datatable functionality with power apps 🙏🙏🙏

[premikaofficial]

Such a great video, it's very helpful, thanks so much

[pelletierb]

Thank you for all the great videos. This was very help full for the project I was working on.

[KuldeepSingh-nqvi]

Hi Dhruvin, Thanks for creating such valuable videos, how does "In" function works, Please upload a video on same...

[gosodre]

Excellent my friend. Thanks for sharing your knowledge. :)

[praveenkakumanu]

Hai Bro i am unable to execute on visible code on drop down can you help please

[fahadmalik]

Thanks man for the videos, really appreciate that. Just want to highlight one thing (for curious learners) that in case of Planned/Unplanned, we cannot use the approach of 'in' operator as 'planned' is being repeated in both the choices and it won't get us the desired filtered result, as per my experience, that's why we need to go for the If statement. Please correct me if I am wrong.

[mallikarjuns]

Can you make video on auto populste feilds in form edit by selecting one dropdown.

[nsgaming]

Hi Dhruvin, thanks for this video. Have you created any video to search inside document? can you share link for the same.

[sreekanth]

Hello Sir, good to see this video and can u please make a video with Multiple selection in filters

[melonafrancis]

Thank you for sharing the video. Can you let me know how to make the dropdown blank instead of showing all leaves?

[entertainment]

I am stuck in this, when practice same like in this video, the collection values not coming like leave type, department, and all

[rks]

Hi Dhruvin, Thanks for the Video, i am new to the power apps, instead of Drop down can we use the button, if yes then how to use