Filter and Search Records in Power Apps

[@axelrumkorf9761]

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!

[@iamdhruvinshah]

Glad I could help!

[@digamberhampa4537]

Dhruvin Shah, you’ve done a great job!

[@krishnakishore993]

Excellent video,very clearly explained about filters

[@vmohakrish]

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

[@abewearsshades2736]

Your videos are amazing Dhruvin. Thank you for sharing!

[@jray1429]

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

[@iamdhruvinshah]

Thanks a ton

[@kunireddysrikanthreddy5773]

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

[@iamdhruvinshah]

Yes

[@bank_po2023]

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

[@amalsnair4075]

Awesome Tutorials, Thanks Man

[@KuldeepSingh-nq1vi]

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

[@TheMinitravellerLife]

It’s so easy explanation

[@nsgaming1928]

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

[@premikaofficial2729]

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

[@iamdhruvinshah]

Glad it was helpful!

[@mallikarjuns4280]

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

[@pelletierb]

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

[@melonafrancis731]

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

[@rks553]

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

[@gosodre4279]

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

[@fahadmalik7010]

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.

[@sundrapillay6668]

Thanks Dhruvin

[@iamdhruvinshah]

Thanks

[@praveenkakumanu919]

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

[@yahiamahmoud6345]

Hello Ghruvin, Great videos, I had an issue when a dd multiple filter nothing appeared and I couldn't filter. I reviewed the code multiple time and it is the same as u have wrote. Any ideas what is the issue?? Thanks in advance and happy new year

[@asihasih6972]

Hai Dhruvin, thank you your video tutorials.. I would like to ask you, in screen View and Edit for Gallaries and Filter and Search function , why is the table not updating even though there is a new form input ? I want use only Filter and search, not sort

[@sreekanth3115]

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

[@satishkumar-or2dp]

Hi Dhruvin, awesome, I have a scenario, I would like to filter gallery data based on text input and 4comboboxs only when i I click on a button, filter should happen with respect to input provided into text inputs and combobox controls. Is it possible?

[@entertainment2560]

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

[@entertainment2560]

Kindly suggest

[@mehulchawhan6900]

Hi Dhruvin, how can we overcome the delegation exception, if we use in operator we get Delegation exception, i see in your video even you got the same exception but you have overlooked it, kindly suggest

[@iamdhruvinshah]

Yes, I overlooked this, as it was beginner series! My intention here is to understand concept! For Delegation warnings, there are so many alternative work arounds! I will try to cover this in some of my upcoming videos!

[@pandukataru7237]

thank you Dhruvin.how can get above code plz help...and if you have in your channel please share links about topics like Environments and Solutions in PowerApps.

[@iamdhruvinshah]

Sure, It is available on Github! I will consider your feedback! github.com/Dhruvinshah16/PowerApps/tree/master/Beginner%20Series

[@danielleco9010]

Can I do this inside a portal in powerapps?

[@lbaidya]

Hi Dhruvin, How can I collect filter list without empty space? My selection Data filed has Empty values as well. Thats why it is collecting the empty space/row and showing in dorpdown list.

[@iamdhruvinshah]

I didn't get your question! Can you please elaborate?

[@gustavobaeza3890]

You have the delegation yellow warning for using your filters like that...how to avoid it or fix it?

[@iamdhruvinshah]

I will upload a new video for that very soon

[@saianugrah9844]

@@iamdhruvinshah What is the selected type. value being used at 14:00 ?

[@minvisusanpaul2212]

Hi, can u plz help filtering dropdown in lookup fields... Drop down its showing 'records' in result..

[@gangasanisreenureddy6332]

How to create environment dynamically by using flows

[@stefin.nathan5960]

What about if you have million rows of data

[@manir5220]

Where can i get GIThub link for Code?

[@zaydarendse2812]

thanks for the great content!! :) how do i filter a Data Table, not a Galary only i cant find anyone doing this, you come close :)

[@GAURAVKVNIEC]

If we apply distinct function in a combo box, the allow search property stops working. Could you please tell me a resolution.

[@Toto-pw4tw]

At 4:02 can someone explain why did he write Choices([@Leaves].LeaveType) ? What are we supposed to write inside choices?

[@Toto-pw4tw]

its Choices(ListName.FieldName) yw

[@markmoore6258]

I was using 'in' at 11:49 but realized 'in' is NOT case sensitive. After research, I found the operator 'exactin' that IS case sensitive. :)

[@AKumar036]

Also one of the problems i see is tht you assume that people know power apps and therefore don't mention what they need to select, like source, table, or field. Here, after clear collection formula you simply pasted the values.

[@ramalingaiahmedabalimi9793]

Hi Dhruvin sir I get an from 5:34 sec u written code for drop-downs but I am also write same code but not showing any different types of leaves and department etc. I don't know why drop-down box not shown different types names. In I mention the LeaveType.Value. Aslo every drop-down boxs but I didn't get drop-down boxes nams also. plz what I am do tell me sir

[@aadarshvalsange8548]

same issue will you please help me , if this issue got fixed for you ?

[@aadarshvalsange8548]

sorry it worked on dropdown, Item property is case sensitive I was using Leavetype.value but the V needs to be capital Leavetype.Value

[@Voltzz1982]

I loved all your other videos so far but this one has many name mistakes in their objects (Leave type dropbox name's based on the Planned/Unplanned column, The Leave Types box is easily confused with the All Leaves box, etc). It made the video hard to grasp for me. Free is free but I would recommend you to replace this video with a new one that has less confusion in the objects' names. I still want ot thank you for the free courses.

[@ravikumararavapalli8850]

hi, JBL I am facing an issue with the search and filter, dropdowns on collections, I am trying to do it for a while but have no luck with this video ...if possible can you guide me if you can do ..thanks

[@afsalc9674]

Where is GITHUB link?

[@ResponsibleXI]

How can I implement the same handling the delegation issues?

[@iamdhruvinshah]

Will prepare the new video soon for that. Stay connected. Thanks for the ask.

[@PradeepKumar-xd2oc]

getting an error in Gallery Filter( Leaves, Substitute( ddlLeaveType.SelectedText.Value, "All Leaves", "" ) in 'Leave Type'.Value, Substitute( ddlPlannedUP.SelectedText.Value, "All Leaves Type", "" ) in 'Select Type'.Value, Substitute( ddlDepartment.Selected.Value, "All Departments", "" ) in Department.Value, Substitute( ddlLeaveStatus.Selected.Value, "All Status", "" ) in 'Leave Status'.Value, If( ddlLeaveType.SelectedText.Value = "All Leaves Type", Or( 'Select Type'.Value = "Planned", 'Select Type'.Value = "Unplanned" ), ddlLeaveType.Selected.Value = 'Select Type'.Value ), Or( TextInputSearch.Text in Title, TextInputSearch.Text in Manager.DisplayName ) )

[@iamdhruvinshah]

What error you are getting?

[@PradeepKumar-xd2oc]

@@iamdhruvinshah it does not filter out records when i select CasualLeave in 'Leave type' or any other 'LeaveType' for the above code that i had written on Gallery i

[@suprajakumari700]

github url?

[@AKumar036]

Please solve your mic issue, the volume of your videos is very low. One can hardly hear without headphones