PowerApps Multiple Filters on Gallery
HTML-код
- Опубликовано: 22 июл 2024
- #PowerApps #GalleryMultipleFilters #GalleryFilters #MultiSelectFilters
In this video on PowerApps Multiple Filters on Gallery, we will go through a step-by-step tutorial of applying multiple filters to PowerApps Gallery control. We will apply multiple filters of type text, date, dropdown, combo box, checkbox, multi-select combo boxes etc.
I will also showcase how to get around the default select item issue with Gallery so that you can have all items displayed when no filter is applied and filter the galleries based on multiple filters once filter is applied.
We will leverage both Microsoft Dataverse (CDS) and SharePoint as a data source in this video on How to apply Multiple filters on Gallery in Power Apps.
Video covers the following:
✅ Multiple filters for Gallery
✅ Search function and filter function
✅ Filter based on single select combo box (acts like a dropdown control)
✅ Filter based on multi-select combo box
✅ Filter based on multi-select checkboxes
✅ Filter based on date range
✅ Reset filters
Links:
Delegation documentation - docs.microsoft.com/en-us/powe...
My delegation playlist - • Power Apps Delegation ...
Table of Contents:
00:00 - Intro
00:42- Data source schema - Dataverse table
01:07 - Search on text column
02:30 - What is Delegation?
03:45 - Filter on Choice column (single-select filter)
06:26 - Show data when no filter value is selected
08:26 - Add a second filter using comb box choices
09:41 - Filter on Choice column (multi-select filter)
11:40 - Filter on checkbox selections (multiple)
14:28 - Filter based on date range
16:15 - Reset filters
17:36 - Apply multiple filters with respect to SharePoint as a data source
thank you Reza, your isblank or is empty is gold. Before this I wrote nested if statements to check for all possible combinations, so if I had three combo boxes, ended up with a huge complicated nested if statement. Very elegant, now I need to refactor lots of code. Thank you
Excellent! So happy to know that the techniques showcases are valuable. Yes, time to refactor code :)
that is what I started doing too.
I usually battle with Nested statements, especially when it comes to filter & search functions. You are saving a lot of lives with this video Reza. This is like a VACCINE for our Filter virus. I appreciate you.
Wow! These are some really amazing compliments. Thank you. The world definitely needs a Vaccine.
Thank you!
That moment when Power Apps slaps on my face but Reza publishes a video to save me! :) Always thankful to you. May God bless you and help you in all your life. You are surely helping a lot of people.
Thank you 🙏
So many helpful tips in there, thanks Reza. Every week I am learning so much from you! I never realised the need for checking isblank and isempty! In regards to search not being delegable in SP, what I have done in the past when the datasource is small enough is imported that into a collection then used search.
Firstly, thank you for the fantastic feedback.
Collections are all held locally in memory. There are always delegation challenges which one needs to be aware of.
Thank you for watching.
There we go! Yet another video with amazing information by Reza. Before this, my filters where huge because of several nested if statements. Thanks a lot.
Thank you Juan. Hopefully I have simplified the process of applying filters :)
i second that!...thank you Reza
This is the single most useful power apps video I've seen. Thank you, Reza! Great explanations.
Wow! Thanks so much.
You have an amazing knack for teaching. You pick nice examples to demonstrate and provide information to the point. Good job and Thanks
Thank you for the amazing feedback.
Oh my god, you're a legend.
I am building a mobile app for my uni project, and you have hugely saved my life.
Can't thank you enough Reza.
Thank You for your kind words.
I am no legend. I am just a content creator.
@@RezaDorrani Humble really you are, but please know that your videos mean a lot to people like me. Thanks again.
@@lk43wz You are most welcome.
@@RezaDorrani No, seriously, you are a legend.
@@aprilmills5925 🙏
Thanks for all your continued help on my powerapp journey. Most of the best practices I have learned have come from you!!!
You are so welcome!
MAN I DON'T Know how many times you saved my Power Platform daily Life....THANK YOU MAN!
You are most welcome!
Sir, this is Great!!! I used to waste so much time in long and conditions doing multiple filters
Great 👍
Thanks Reza, you're a life saver! I spent days on this actually. Now my tasks is done...
Thanks!
you sent me enlightment after 2hours of trying to filter Sharepoint List - thank you Reza :-)
You are most welcome
Brilliant solution on filters. Followed the steps and have used these with ease and would like to generate the output in form of charts. In anticipation of your ultimate guidance. Thank you.
Output in form of charts? There is no direct action for that. You could call a flow and send your filtered data and then generate an excel file from it.
Dear Reza, apart from your explanation and the way of presentation, I am a big fan of your fluent speaking and crisp n clear pronunciation! I wish I could achieve that expertise one day :)
Thank You. If I can do it, anyone can.
Those tips are lifesavers. Second time this video saves my ass with the Sharepoint filter. Thank you very much Reza!
Most welcome
Master piece. Thank you Reza as always.
You are most welcome
Great Video Reza! Like the layout too. thanks for the tip on filtering. worked a treat
Awesome! Thanks for watching.
Another great video Reza, keep up the good work. I will be using this method for filtering data in the future. again great work👍
Thank you
Thanks for another great video! This helped me solve a filter issue that was driving me crazy all week.
Glad it helped!
Thank you so much, again! Great videos for beginners, intermediate and advanced users.
You are most welcome!
Good day Reza, you are reading my mind. I was struggling with multiple filter since 3 days, where I could not find the right way online. Finally I achieved the result, but as usual, will adopt your way 😂🤣😂🤣
My videos are now based on subscriber requests. I feel I am following the pulse of my audience.
So Audit Check List is on your Pipeline? 😉
@@ehabatme5324 I need multiple folks to make similar requests 😊
Excellent tutorial sir. You solved a problem I was having with syntax, and although it is still a little illogical, you gave some pointers on how to solve my particular issue. Kudos
You are welcome!
Hi Reza, this is so cool. I have watched so many videos, but this one is ultimate! Learned so much, thank you!
Happy to hear that!
Thank you for demystifying gallery filters for us Reza. It is such a core piece of every app, but can be confusing knowing how to nest Search, Filter and SortByColumns in a Gallery Items formula.
You are most welcome. Your feedback was exactly the goal of my video.
Awsome !! Thank you for this video, I was affraid that I would need very complexed "If" for my multiple filters in my App and with this solution it's nice and easy.
Glad it was helpful!
This content was helpful for my project confused on whats acceptable in SharePoints and thabks you showed how to choose the right funtion for data value.
Most welcome
Hi from the future😊😊. Top videos as always Reza thanks for all you do.
Glad you like them!
Thanks for this video Reza, very useful as always!
Glad to hear that! Thanks for watching
Learned a lot about powerapps filter usages, Thanks!
Great to hear!
This is awesome! Your videos are the best, and I love the way your screens look. Is there a video that explains how you set up the original gallery with the 3 column, shading, etc.? It would be a basic video, but if you have it, I would love to see it. I looked but couldn't find it among your videos. Keep the videos coming!!!
Thank You so much :)
Here is my Gallery design video ruclips.net/video/bnC8u3gdWss/видео.html
It also has link (in video description) to look at the sample App which includes multiple designs.
As always, fast and simple explained. Thank you for the delegation input, that causes a lot of trouble. I wonder why SharePoint is still not delegable for many functions.
Thank you for sharing with us
Most welcome!
This video is God-sent! Thank you so so so much!
You are most welcome. Welcome to my channel :)
Another great reference video, thank you Reza.
Thank you Ron
Hi Reza, great video. I like your IsBlank and IsEmpty conditions. Awesome 👌
Thank you
Reza, the videos you upload are extremely helpful!
Thank you!
(not a native speaker myself and I love the way you pronounce "Data Worse"! :-) )
I keep trying to improve my pronunciation :)
@@RezaDorrani No! Don't! It's yours, and it is part of you!
@@DinosKonstantinou Ok. I will stick to my pronunciation style :)
Awesome Reza ,,,, you make things so simple ... thank you ..
Thank you very much
Thanks Reza, you're my Power Apps Super Hero.
🦸♂️ Thank You :)
Reza, thank you so much! Your job is excellent! Congratulation👍
Most welcome! Thanks for watching and liking the videos
Thank you Reza, you're the best!!! You solve my problem 😅
Glad to hear that!
Nice way to solve multiple filters, and great video 👌👌👌👌
Thank you! Cheers!
Fantastic video, thank you Reza!
Most welcome and thanks for watching
absolutely loving your videos.. they are very helpful... keep up the good work.
i am trying to program the gallery view to show data according to the following conditions,
Thank You.
Hi Reza, thank you so much for the amazing videos! I've started a career in power app development which you videos have played a massive part in. When using dataverse I am still getting a delegation warning using the in function when using lookup fields - is this expected? The in function works without delegation on text fields.
i.e this works: Filter(Table, TextColumnType in Filter.SelectedItems)
but Filter(Table, LookupColumnType in Filter.SelectedItems) has delegation warnings
Not all column types are delegable with IN function. Lookups is one of them. Hopefully, it would be in future.
Great video. Extremely userful!
Glad it was helpful!
Thanks a Lot !!! Great Content !
Thank You for watching.
Absolute legend. Well done!
Wow! Thanks.
You are the Goat Reza! thanks for this one
My pleasure!
This helped me so much. Thanks for your amazing videos!
You're so welcome!
This is what im looking for.thanks 🤩🤩🤩
Glad it was helpful
Thanks Reza always excellent videos
Glad you like them!
Thx for sharing!!! Very helpfull!!! Greetings from germany Christoph 👏 👏 👏 👏 👏
Glad it was helpful! Thank You!
thank you very much sir for all the explanation
You are most welcome
Thanks @Reza for this great video. I am having an issue, when I choose values from checkbox, it is showing in combo box but gallery is not filtering, when I select manually from combobox then gallery filtering.following your video at 13:40
Welcome!
I have not come across this 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
Quick question (I hope). I did the date filter for my gallery utilizing the Modified date from a SharePoint list. It works great except if you pick the same date as the listed item in the gallery. Even though the code says less than or equal to, it doesn’t seem to do the equal to. If I select a date that comes after a listed date in the gallery, the item appears just fine. Is there something I’m missing here? Also thank you so much for everything you do. You’ve saved me so many times with your videos!!
This is related to Power Apps working in UTC for dates. Also the time component comes in play.
I will plan a video on this in future.
Thanks for your video!! It helped me a lot. Is there a way to default check some checkboxes, for example: when going to this screen "Not started" and "In progress" are default checked? I tried with a If statement, but then the filtering does not work anymore. Thanks in advance!
Possible. Set the default values on App load in the collection which gets updated when checkboxes are checked or unchecked.
Amazing video ! Thanks a lot
Glad you liked it!
Thank You Reza!!!! This is amazing! I had a question though, what if i have multiple text filters along with combo box filters, how do i write the multiple search functions? any tips at all will be appreciated.
Search function with SharePoint is not delegable. I would not recommend using it if your data source is SharePoint.
thank uuuuuuuuuuuuuuuuuuuuuuuuu such a beautiful tutorial
You’re most welcome
Thank you so much for the lessons in this video Reza, I found it very helpful. I do have a question though, at 10:39 you demonstrated a way to bypass the delegation warning through the setting by using Dataverse. Is there any workaround to bypass delegation warning for Sharepoint List?
No workaround for SharePoint yet.
Thank you so much for the detailed explanation. How can I search based on the Created By column on the sharepoint list in addition to few other text fields.
Search function has delegation issues with SharePoint.
But you could add filters for Person column as well. Check - ruclips.net/video/tPxE_-DcWkg/видео.html
Reza. Thank you so much for the work that you do! Your videos have giving me the skills to create a new job for myself at my company. In regards to this video, I got all the filtering to work in PowerApps/Dataverse for Teams. I’ve tried for hours to figure out how to have some of the checkboxes checked, as a default, rather than all being cleared. With the reset button I thought I could clear the collection and then make a new collection with just the choices I wanted checked, but can’t seem to get that to work. Do you have any advice? Thanks again!
For anyone interested, I was able to figure this out using another one of Reza's videos on Dataverse Choices columns ruclips.net/video/Cu8pDo6WpRI/видео.html. In making the collection the name of the choices group and the selected choice must be included in the code, rather than hardcoding text. For example, Collect(colJobStatusFilter, {Value: JobStatusChoices.'Not Started'}), rather than Collect(colJobStatusFilter, {Value: "Not Started"})
Thank You so much for liking and following my videos.
I will have to look at your App in action to know the exact issue. All you would need to do is load the collection with default values on click of Reset. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks for sharing
Great info, I only wish I had come across this sooner.
Better late than never :)
Welcome to my channel
Hello Rex’s, quick question, am I able to add another 2 search boxes, and concurrently filter all rows based on searching specifics on several “Text” type columns? For example, searching “Project” instead of Name (in the case of this demo), then having another search box for Project Owner, Email, and more?
You can add multiple filters and combine them with OR and AND operations as shown in video.
I will have to look at your App in action in case you are running into issues to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza, your workarounds are always fantastic! One question I need some help with, I know that Microsoft is already working on app certification to certify apps created by ISVs.
But for now us there a way/workaround that I can use to sell a solutions built on PowerApps with a subscription model, like USD1 per user per month. Given that I will have access to build the backend on the client tenant?
It would be an amazing solution till Microsoft finalize this.
I have never tried publishing Apps to App Source so I am probably not the best person to answer this.
App Source -
To list on App Source - appsource.microsoft.com/en-us/partners
appsource.microsoft.com/en-us/marketplace/apps
You Rock! Thanks for your efforts
My pleasure!
Another great video Reza. Thanks. I do have one question and that pertains to the Gallery you created. How did you create a gallery that goes left to right and down? Do you have a video to demonstrate this? Thank you.
Thank you.
Yes, I do have a video - ruclips.net/video/bnC8u3gdWss/видео.html
Video description includes link to download sample App as well.
Hi Reza!
First of all, thank you for incredible content, as always!
I just wanted to ask you a question - when I use the checkbox from a gallery and Collect to fill out a collection, the performance gets crippled and the app glitches out and when I unselect an item, it doesn't always remove it...
Do you have an idea on how to avoid this?
Also, I cannot see to use Choices from a collection, but only directly from the SP list - is this by design or am I missing something?
Thank you very much!
1 - I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
2 - Choices function is for choice type columns in a data source
thank you Reza! the watering be multiplied to you!
Thanks Kyle
Thank you very much ! I love your videos. This Time I have got a problem. I have a sharepoint list as data source. With the Filter(Search( function the dataset finds nothing because there is a problem with the deligation. Can you help me here ?
Thank You!
Debugging issues here on chat is not a great option. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza, Hi, btw, the dynamic sort does not work with delegation?
Sort delegation is tricky. Check ruclips.net/video/6KlI1iZ_KD0/видео.html
Hi Reza, Thanks so much for the great video. I have a list with a column that allows multiple values (characteristics like SEO, SEA, FBAds, ...). I used your filter logic with a combo box but don't get any results. I suppose it only works for columns with one value? Is there any way I can filter for one or more matching charateristics that are n this column (eg. SEO or FBAds)? Thanks so much angain!
I do not have a video scenario on multiple-select values.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza..
I have a scenario where I need to use 2 datasources on one Gallery. Both have reference number field but based on the selection on the first screen, the reference number starts with either: PLR---, PRJ---, POC---. Both data sources have PRJ--- and then the other has PLR--- while the other has POC--- in the reference field as well. How would I go about showing both data sources on one gallery accounting that they both have PRJ but then I need PLR and POC as well from each data source?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks for the video. If I don't want some values from drop down to show in gallery in one screen and show that in a different gallery in different screen to differentiate the choices..how to make that. Am using SP list tried sing Collection but not working for me.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Reza, great content thank you! How do I create gallery that is grouped by section so that if I click one of the sections, it will open new screen at the top of that section but expanded to show sub items, while still letting me scroll up to previous sections or continue to next section and subitems?🤷♂️
That would be quite a lot of work - Group the data, then create sections of data based on group, then showcase them inside gallery and also provide add row on top of section.
I would have to spend a good amount of time to see the possibility and test it out.
Also, there will be issues related to delegation.
Check out 1 video I found on this topics - ruclips.net/video/Qfer3DwjfwA/видео.html
Thanks for your work Reza, I have a question about using the "in" operator in the other direction. I'm trying to use a choice drop down component to filter if the selected value is IN a multi-choice column in Dataverse. I can only get it to work right now by using the Field.Value reference which is giving me a delegation warning. It seems like it SHOULD work using dropdown.selected in Field but that doesn't work at all.
Not sure I understood the question.
Check ruclips.net/video/Wr42PeW6_wU/видео.html for multi select choice columns
@@RezaDorrani Hopefully I can clarify the question. In the video you linked you are doing a filter using a multi-select combobox and checking if those values exist IN a multi-select field. You clarify in the video that this WILL cause delegation issues due to the ForAll() function you need to use to execute that check. What I'm trying to do is check if a SINGLE item from a dropdown is IN a multi-select choice field. When I attempt to do this the filter seems to not work at all (the gallery just stays blank). Filter(MyTable, DropDown.Selected in MultiChoiceField). If I change it to Filter(MyTable, DropDown.Selected in MultiChoiceField.Value) it works but I get the delegation error.
@@anthonypriest6726 I will have to see your app in action to know the reason why your gallery is blank. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Excellent! I finally found a tutorial that I need for what I'm going to build. My first app, a little nervous.😁 Now, I have a Excel table that stored in one drive, is the concept still the same? I mean when we apply the formula, do I use the header name of the column I wNt to pull the data from? Do I have to define the name of the column in Excel before I do anything? Thank you for your time.🙏
Concept would be similar.
However, Excel is not a good data source for Power Apps.
Better options are Dataverse, SQL or SharePoint.
@@RezaDorrani Thank you for the prompt reply. I have a feeling excel is not ideal foe power app but I've never worked with dataverse. It might be a good time to learn. Thank you again.
Hi Reza. I have a lookup column in my sharepoint list. Can i use that lookup column as a filter to the gallery? If so what code shouldi past in the filter for that lookup column. The lookup column has a Value and Id i saw. If i filter on the lookup column alone it works. But when i start adding other filters i doesn't work. Not sure if my code is incorrect. I am using " LOOKUPCOLUMN.Value in DROPDOWN.SelectedItems. "
Possible but I would have to test it out. I did a video long back on lookup column single select filter - ruclips.net/video/pn50AKn3Q1Y/видео.html
Hi Reza, I followed your steps and everything works well, except that when I set the default value of the combo box to collected values of the checkboxes. The values show up in the combo box, but nothing appears in the gallery. ANy suggestions on what might be going on?
Check description of video
Good video Reza. I am a newbie to power apps. I see there a combo box hidden and respective values are placed as checkboxes. Does both required? Is there anything like multiselect checkboxes or radio buttons which can do the functionality without hidden combobox.
Yes both are required in my example since the combo box default values is set from the checkboxes.
There is no muli select checkbox control in Power Apps.
There is a radio button control but it only allows single selection. I wanted to showcase multi selections in my demo.
When you insert > combo box. This creates a combo box with white styling. Mine are always blue. Is there a method of changing the look of the standard object permenantly? Like some kind of style sheet?
If change the theme of the power app, it will change the style. Currently, there is no concept of style sheet in power apps and you would have to update each of the color properties independently.
Great, as always
Thank you! Cheers!
Hi Reza, thanks for the help. For some reason PowerApps cannot find one of my column names. It is a single line of text, but the formula for search comes back with an error that the column cannot be found. However, it is there with the list and i can use in other places.
Search only supports certain types of columns depending upon data source. Check the documentation.
Awesome Video. One question Can we save this data whatever is filtered out from slicers. And also the slicers selected data in sharepoint ?
Save data meaning export it out? Then yes. I have done videos on that topic.
Save slicer data - may be you can use savedata and loaddata functions to store than info on user device.
Hi Reza, Thanks for video it was great. I was using a common search button where user can type and search for all the column in a table . I was having a date column but i was nort able to use the common search function for it. Can you please help regarding the same.
Not sure if one can search on dates. The Data source would also play a key role in this.
I will recommend you check on the forums at powerusers.microsoft.com/
Very nice and useful!!!
Thank You
great Video thank you!
I have a question regarding the date filter:
Why does this filter not show me the last day of the month?
'Date' >= Date_From.SelectedDate && 'Date'
I will have to look at your App in action to know the reason for your issue. Power Apps works with dates and times in UTC time. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks a lot sir ,you are great
Thank You 😊
Thank you Reza, this is awesome. I have problem with filter reset button. When button pressed, all filters cleared but gallery is empty. If i set filters again, then the gallery works fine. Have you any idea?
You are probably not checking for conditions defined in filters. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you Reza! Unfortunately my choice column is stored on Sharepoint, so it appears these filter options do not work in that situation. Any suggestions?
Check my playlist on delegation ruclips.net/p/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Hi Reza, thankyou for this video but is there a way to filter a gallery based on lookup column? I'm using dataverse.
Check if this gives you any ideas -> ruclips.net/video/2XUKvXNfsIc/видео.html
Great content. One question. How did you get the date into PowerApss? In my case it says that the formula is not admitted. I´m using a Label to show the date in the app.
I will have to look at your App in action to know the cause of your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Very useful this video! I only have one question, in my SharePoint list I have a multiple selection column but when I use your formula just that column does not read it but the others that are of a single selection if you read them. Do you know what that will be? Could you help me please
I have a video on filtering multi select columns. I would recommend checking that.
Thank you very much for answering! Could you tell me his name so I can look him up, please?@@RezaDorrani
I am trying to filter my Table (formerly CDS) based on this explanation but I am not getting anything. If I use my Table as the main data source, I get a delegation warning, If I use a collection for the same Table, I get nothing! is there anything I should do for my entity/table?
I am tryin to filter my gallery based on a combobox selection for an option set!
Could be many reasons - No data matching your criteria, mismatched data types, etc.
Would be best to post your issue with screenshots on the forum at - powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1
Collections will never give a delegation warning even if you are running into one. That does not mean that there is no delegation.
Hi Reza, I am using the share point list as the data source, but when I follow you through the reflect the combo box value into the check box group. I have trouble, the collect function is not working and telling me the data type returned from the combo box is a record but expected a table, can you please teach me how to fix this issue, appreciate your kind reply.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza..This is one of my "goto" videos!!..when i reset the textbox the value is blanked out however the gallery does not refresh with the values, however when i enter some value in the text box and delete it, then i see the full gallery!!..can you throw some light?
That is a weird issue. I would have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thank you for this! I have created a PowerApp grid view gallery using your video. I have nearly 1000+ data in my Sharepoint list and have created Power App gallery grid with multiple filter boxes. When i search an item in a text input the gallery is very quick and responsive however when i have a dropdown box and select specific items the app crashes. I hope you can advise how to fix this. Appreciate your help, Love what you're doing!
I have not come across an issue with filtering grid data. I have done 4-5 videos on grids and one of them shows filtering. You can try checking that.
Also, I have not come across any performance issues and without reproducing it, I will not be able to provide any fix.
It would be best to post your issue on forums at powerusers.microsoft.com
I love great videos! :)
Thank you!!
Would be great if you could help find a way to pass multiple parameters to a SharePoint library in a web part where the search values are coming from another web part. Tried to search a lot, but couldn't find any solution.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza - I can get the drop down to filter, I can get the check box collection to work and populate the drop down, but on check, the gallery doesn't filter. It just goes blank. And the select value is populating in the drop down. Any ideas/suggestions?
If you follow the steps in the video and if your column types and data source match then it should work.
There must be some issue with your code or may be there is no associated data. It would be difficult to guess the solution here on chat. I would recommend posting your issue with screenshots to the forums at powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1