PowerApps Delegation & Gallery Filtering using multi select Choice and Lookup Columns (Part 4)

[@jenniferrasal519]

This tutorial literally saved me, been puzzling over this for nearly 4 days, managed to combine this with filtering by 3 other comboboxes that had single choice fields in SP, been a nightmare but finally it now works. Big thanks for sharing this.

[@RezaDorrani]

Thanks for watching and glad it was helpful.

[@Inovators]

I use the same technique to filter data in gallery. My second step is to use the visible data in maps.But when i access this data it shows all the data because in real all the data is in gallery and we just true the visible property for the required rows. Can anyone help me how can I get the data which is visible in gallery?

[@adamk7743]

@@RezaDorrani Doesn't work on large datasets, just try it on large list, you will see the problem. If you do a filter data and it is deep down in the gallery, you will see blank space on the top.

[@RezaDorrani]

@@adamk7743 Performance is a concern with this approach for sure. There is no workaround for delegation with IN operator in SharePoint.

[@adamk7743]

@@RezaDorrani Yes the UX is also bad with this, Does Dataverse also have this problem ? Too lazy to try. I need to propose a solution

[@saqnevermind]

Reza ... You are truely a Gem of a person... Most of my issues are getting resolved after watching your videos...Many Thanks for uploading these :)

[@RezaDorrani]

Glad to hear that

[@tauseefshk]

This is really what I needed. An "IN" operator to filter the gallery without the delegation warning. Thank you so much 😀

[@RezaDorrani]

Please note that this approach works ok for small data sets. For large (10k+), this would cause performance issues.

[@tauseefshk]

@@RezaDorrani Thank you for your response. My current requirement involves less than 10k rows. But just for my knowledge is there an alternate way other than using IN operator to filter galleries without a delegation warning?

[@RezaDorrani]

@@tauseefshk No other option.

[@varUser01]

Fantastic as always - Thank you, Reza! I've been wrestling with multi-choice filtering for a few days and this video triggered a thought that saved the day! For the sake of sharing, I found I was able to use AddColumns on my SP list following your logic and it seems to be working with the default filtering function, like so: Filter(AddColumns(SOURCE_LIST,"MultiFilter",Concat(ForAll(ComboBox.SelectedItems.Value,If(Value in MULTICHOICE_COLUMN.Value,"yes","no")),Value)),"yes" in MultiFilter)

[@RezaDorrani]

Thanks for sharing this!

[@WimpieTV]

Such a genius work around for the delegation warning!

[@RezaDorrani]

Thanks but it does have performance challenges with very large data sets.

[@sinimahanta4490]

The solution is kind of challenging PowerApps out of the box property. It is an amazing solution.

[@RezaDorrani]

Thanks. I have a better solution coming next week.

[@adityabajaj14]

Thanks sir. It took a while but eventually figured out. Appreciate you taking the time to post the tutorial.

[@RezaDorrani]

Great. Thanks for watching.

[@poorneshyh]

Superb bro... Thanks for sharing this knowledgeable. Have been scratching head for over 5 days on how to achieve this! You made it look so simple... You rock 👍👏 Keep going

[@RezaDorrani]

Thank you for your kind words

[@karthikindianchennai]

Hi Reza, this is great way to work filter gallery with multichoice values. Thanks a lot

[@RezaDorrani]

Glad you like it!

[@sarfarajsindhi]

This had been of a great help for me.. Really appreciate the contents and the way it is explained.. Was struggling a lot in an issue and this video helped me solve that. Jazakallah...

[@RezaDorrani]

You're very welcome!

[@jhormangomez2268]

You are a genius! LOL that was cool! I was wondering how to filter multiple selections, thank you

[@RezaDorrani]

Thank you. Let me point to another latest video of mine which has some more cool tricks on multiple gallery filters - kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@Inovators]

I use the same technique to filter data in gallery. My second step is to use the visible data in maps.But when i access this data it shows all the data because in real all the data is in gallery and we just true the visible property for the required rows. Can anyone help me how can I get the data which is visible in gallery?

[@mozhdehdashti1839]

all your videos are great, thanks!!

[@RezaDorrani]

Glad you like them!

[@darylt11]

Great video this, gave me some ideas, and more importantly the ability to move forward in a project. Thanks Reza!

[@RezaDorrani]

Glad to hear that and thanks for watching

[@n2datasolutions443]

Reza Dorrani I flipping love you, thanks for this video you just saved my ass!!!!!!! Absolute boss👊🏼👊🏼👊🏼👊🏼

[@RezaDorrani]

Wow! Thank you.

[@mandijohnson-fisher5370]

Thank you very much for making this series! It was very helpful!

[@RezaDorrani]

Glad it was useful. Thank you for watching.

[@BigLeafDropper86]

My man, so good took me ages trying to work this out!!!!!!

[@RezaDorrani]

Thank you

[@janetbarrett8632]

Awesome tutorial! I have one little problem, it is not filtering in all of the results and I don't see any patterns to what it is not pulling in. Any ideas?

[@RezaDorrani]

Thanks! I have not come across this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@davidjimenez8952]

woooo! top video, this is for Jedi developers.

[@RezaDorrani]

Thank you David

[@lakhsmic]

Hey Reza, Thanks for wonderful video, it solved my issue, which I was looking to solve for couple of day. But if we need to select all the items in gallery that are visible and generate a excel, could you please show some light on this? Thanks in advance.

[@RezaDorrani]

Large data export to excel kzbin.info/www/bejne/i4vHn5qorLymp6M

[@TheFranx3]

Thanks man!! Solve my problem

[@RezaDorrani]

Happy to help

[@arulanand12]

Many thanks. Crystal clear explanation.

[@RezaDorrani]

You are welcome!

[@RezaDorrani]

Glad you liked it

[@Raghavendra8231]

Thank you very much for the tutorial it really helped me. Also, can you please help with the formula to include 3 comboboxes in the Visible property. Thanks for your help in advance.

[@RezaDorrani]

You can just use a combination of || and && functions with the different comboboxes.

[@dianasoares7823]

This video is AMAZING!!!!

[@RezaDorrani]

Thank you

[@nbercasio]

This is awesome. I got it to work but do you have a tutorial like this with two cascading lookup columns?

[@RezaDorrani]

I have done 2 videos on cascading dropdowns. Check those (not sure if they include lookup though).

[@kanishkaroychowdhury4050]

Hi, great video again... thanks for uploading...concat (thisitem.subject, text (value), ", ") may be the a way to avoid "," in the end

[@RezaDorrani]

Try powerusers.microsoft.com/t5/Building-Power-Apps/removing-last-character-in-string/td-p/395691

[@jacobfordmicamountainwrest457]

Reza, your tutorials are amazing, especially since I am very new at this. I built a responsive card style gallery with a wrap count of screen size. I was able to use this logic to hide the items I did not want to see, but it didn't adjust and just left white space where the empty cards were so the visible cards were all over the place. Am I missing something?

[@RezaDorrani]

I don’t think this technique will work with wrap count > 1. This requires flexible height gallery which does not have wrap count (as far as I know).

[@AnneCin29]

Hi Reza, thanks for the video! Quick question: I now need a collection of only the visible recordsof the gallery, after applying your Video. Could you help?

[@RezaDorrani]

I do not have a reference video on this scenario & 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

[@richellesinger19]

Works great! Thanks Reza!

[@kellymay8659]

Thank you so much! I was able to get this working with multiple filters. My only issue is that I need it to be exact. As like the example, instead of matching any that has one or the other in the combo box, they both need to be in the array to match. Like if both social studies and math was selected, the array must have them both in order to be visible. How would I go about doing that?

[@RezaDorrani]

I did that in one of my videos but do not remember where. May be - powerusers.microsoft.com/t5/Community-App-Samples/Apply-multiple-filters-to-Power-Apps-Galleries/td-p/774230

[@DennisHobmaier]

Hi Reza, thank you very much! Very clear and helped me a lot. As you said, you did an OR filter for the gallery and you can do an AND filter as well. How could this look like? Regards, Dennis

[@DennisHobmaier]

Found the solution by using - not sure if this is the way to go but it works: If ("yes" in Concat( ForAll( combo_Characteristics_Adv.SelectedItems.Value, If( Value in ThisItem.column.Value, "yes", "no" ) ), Value ) And Not ("no" in Concat( ForAll( combo_Characteristics_Adv.SelectedItems.Value, If( Value in ThisItem.column.Value, "yes", "no" ) ), Value ) )

[@RezaDorrani]

As long as it works :)

[@RezaDorrani]

Glad it helped!

[@justinharville7519]

@@DennisHobmaier Hey Dennis, is your code here exactly what you put and it didn't throw any errors? Mine is saying only 1 argument is received, when we need 2 or more.

[@justinharville7519]

@@RezaDorrani Hi Reza, I tried Dennis's code and it throws an error saying only 1 argument is received, when we need 2 or more. How would we change the filter from "or" condition to "and" when selecting multiple items in the combo-box?

[@heloisaheng3189]

thank you, it's very helpful !

[@RezaDorrani]

Glad it was helpful!

[@beccadavison6513]

Thank you! Follow up question please @Reza... is it possible to use Grid style (3 column) Galleries, or is this not possible with multi choice columns because we must chose one of the 3 flexible height gallery options? I would like to create a card view, but can't find one with flexible height.

[@RezaDorrani]

Flexible height galleries do not have wrap count. So grid styles are not possible.

[@Ben-ws9pi]

Thank you mate, you got my back.

[@RezaDorrani]

Glad I could help

[@RezaDorrani]

I surely do mate :) Thanks for watching

[@tesnim89]

Hi Reza, your tutorials have been very helpful. can you plz tell me how do filter 3 Multi select combo box with a button when i click i int i get my the result of filter

[@RezaDorrani]

Hi, You would need to add all the 3 combox box multi select check logic to show or hide the record. You can use a combination of && or || functions based on your use case. I show in the following video how to combine multiple filters using && or || - kzbin.info/www/bejne/pp-YYXSBo5iEZ7s

[@TheAmazeer]

Well done dude

[@RezaDorrani]

Thank you

[@SK-uc3du]

Hi Reza, Thanks.. it was really very useful. quick question - I have textbox where i filter results displayed in gallery using expression Filter('All Apps', txtboxSearch.Text in 'Name' || txtboxSearch.Text in 'Description') but its not working due to combobox visible property which I have set as per your video. 'All Apps' is CDS source, so any idea how do i resolve this?

[@RezaDorrani]

Try breaking your problem into smaller chunks and test it. First set visisble property of gallery to true. The apply filter to gallery as Filter('All Apps', txtboxSearch.Text in 'Name') and check to see if this works (Note: this will give a delegation warning). Check CDS to see how the Name column stores data. Once above works then add the entire query to the gallery filter and test. Once it works just move the same filter criteria to the visisble property of the gallery

[@carolineajoly]

Great video, I feel like I'm able to do much more than I would have expected. I applied this to my new project but I get a strange behavior. When I switch the dropdown value back and forth, the number of records displaying changes. Upon first loading I see everything, but after a few changes, the records all disappear and they re-appear slowly as I keep changing the dropdown value (data values are not changing, especially as I work with a temporary collection loaded prior to navigation to the screen). Any idea what could cause this?

[@RezaDorrani]

Thanks. I have not experienced this issue hence not sure what could the cause be.

[@hartfoundation2]

I've noticed the same thing! Not sure what's the issue here!

[@ellesavage308]

Thanks so much, this is so helpful! One additional question - how could I adjust this function so that all list items will show if no value is selected in the combobox?

[@RezaDorrani]

I have a gallery filter video related to combobox where I show all items if empty. Here is the link - kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@ellesavage308]

@@RezaDorrani Perfect!! Can't thank you enough!!

[@shreyasonawane8119]

@@ellesavage308 hey what solution did you find for that pls help

[@Leo_Russo]

This is amazing

[@RezaDorrani]

Thank You

[@fog600]

apparently it's not filtering as if you have more then 2k records you won't be able to filer data from the source therefore some records won't be in a collection. ForAll + in operation with delegation warning is fine , at least data will be filtered

[@RezaDorrani]

Agreed!

[@accordeonist]

Hi Reza - I recently tried this solution with a blank flexible height gallery and it works great. I have groups all my labels in the gallery - but the gallery is not autohiding unfortunately - the filter works but its not hiding the empty spots.

[@RezaDorrani]

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

[@petermesiha4418]

Try setting the TemplatePadding to 0, when you hide controls, the row height will be there but the padding still apply, if multiple rows are hidden, you will see lots of white space to accommodate for the padding for each row.

[@พิชญะชัยชนะ-ค6ต]

Thanks so much hope u happy 😀

[@RezaDorrani]

Thank you

[@fayefouladi2973]

You are super, thanks

[@RezaDorrani]

Thank You

[@fayefouladi2973]

@@RezaDorrani everyone in my team watches your videos.

[@RezaDorrani]

@@fayefouladi2973 Thank You to everyone in your team. Tell your team Hi 👋 from my side

[@fayefouladi2973]

@@RezaDorrani will do.

[@aimeemullins2926]

Hi Reza, This was super helpful, I am wondering if this is possible alongside a search function and to include an option for 'All'? instead of combobox? I have a gallery i am trying to do both search and this dropdown selection on :)

[@RezaDorrani]

Hi Aimee, Search is not a delegable function with respect to SharePoint as a data source.

[@abyal3kod201]

Hi Reza, I`m trying to Lookup into multiple rows when email=currentUser.Email, if a Lookup DataType column has any blank rows, the thing is, even though they are Blank, it alwasy returns as they are Not (probly because its a lookup datatype) *this is one code to get an idea of what I`ve tried:+ IsBlank( LookUp( 'S2DM - Business User',Title=varUser.Email,'Asset Company' )) What approach would you take?

[@RezaDorrani]

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

[@trishsparkman2436]

Yet another great video, Reza! Thank you for posting these! This one certainly alleviates some major concerns I've had around delegation. I have this working (sort of). My gallery is only showing the group of labels for the records that match my criteria, but it is still displaying blank rows for the records that don't match. I clearly missed something but have watched several times and can't figure it out. Any thoughts on how I can fix?

[@RezaDorrani]

Yes, the key is that you need to ensure you are using a flexible height gallery.

[@trishsparkman2436]

@@RezaDorrani Thanks so much for your reply! I'm definitely using a blank flexible height gallery.(even deleted and re-added a couple of times when I re-watched your video). Seems like the labels' visible is working as expected (since only the items that match my criteria display data on the row), but the gallery line item is not (since those that don't match are displaying a blank row). Do I need to do something to set the height of the gallery item if it doesn't meet the criteria? If so, what property is that?

[@RezaDorrani]

@@trishsparkman2436 Just flexible height should do the trick. I just built one from scratch to test and it worked. Ensure the visible property of all the controls in the gallery have the formula to show hide.

[@trishsparkman2436]

@@RezaDorrani Ah - you nailed it, Reza! Looks like I mistakenly left my separator out of the group so that was still showing for each record even though my data not visible. Thank you so much...this is truly genius!

[@RezaDorrani]

@@trishsparkman2436 Thank You. Please remember this is a hack :)

[@robertpapancsev8891]

Hi Reza, thank you for sharing this. What if I have a list with thousands or ten thousands of items, will the app get slower to load and hide all items?

[@RezaDorrani]

A gallery only loads data in batches of 100 (optimized loading) as long as the query is delegable

[@robertpapancsev8891]

@@RezaDorrani Great, so it means the first 100 visible items? So if the first 100 is hidden because the filtering rules are not true, than it goes until the 100 visible where the filter is true?

[@RezaDorrani]

@@robertpapancsev8891 That is correct. Performance may not be great if the visible items are 1 in a 100.

[@vitormello6100]

Hi Reza, This video helped me a lot. How do I create filter with 2 combobox? Should I do the same procedure using the AND condition?

[@RezaDorrani]

Create your combinations using AND or OR depending upon your use case

[@chandrasekharmalla]

Nice Video and easy to understand. I have small doubt. I have a choice column and have yes and no items so in power app i want search gallery with yes values can you help me with that.

[@RezaDorrani]

Yes No type column are always a problem. Check this - kzbin.info/www/bejne/pp-YYXSBo5iEZ7s

[@ResponsibleXI]

Hello Reza - Great fan of your delegation playlist. Thanks a lot for this. I have a question. I am filtering my gallery based on single select drop down column coming from SharePoint list. But I have taken the dropdown values into a collection and displaying the collection as choice values to filter the gallery. Basically I wanted to filter my gallery based on different combinations by one or more choices of my Priority Column (values: High, Medium, Low). I have opted for hide gallery record option as you advised in the video and its working well until I have 0 choices selected. When I dont have a choice selected gallery is going empty but it has to show all records. My items for gallery is just SharePoint list data source. Where do you think am doing wrong?

[@RezaDorrani]

Add a Check to see if no options are selected (empty) then do not apply the hide logic for your column.

[@chrisproctor2854]

@@RezaDorrani How would you run the check? IfBlank in Visible or in Items?

[@RezaDorrani]

@@chrisproctor2854 2 years ago :) I don’t remember. Items I guess but not sure.

[@chrisproctor2854]

@@RezaDorrani I figured it was worth a shot! Haha, thanks for the suggestion--I'll give it a shot!

[@RezaDorrani]

@@chrisproctor2854 😆

[@kilaj1]

I seem to be having an issue with the Gallery not refreshing properly. If I add the same visible code to a label, the appropriate records do return true, however once i apply it to the different controls within the gallery it stops working and displays only one result.

[@RezaDorrani]

I have not come across this issue hence not sure what would be the reason for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@mahalakshmi1404]

Hi thanks for the information..I want to hide the another text input control based the selected value in this checkbox (inside gallery).. what should I writ in the visible property of that text input

[@RezaDorrani]

I would have to try out your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@mardithpascua8112]

Can I export the data to excel containing only the Visible data in the gallery? or will it also include even the hidden rows?

[@RezaDorrani]

kzbin.info/www/bejne/qoKmc4qDh5yHbJY & kzbin.info/www/bejne/gabTq2pnmbyMr7s You can define what to export.

[@MegaSupertariq]

Good Work Reza, nice trick there on hiding items. Have been Searching for solutions to include all data in a filter rather than only first 500/2000 items and rest all ignored. Is there a way to implement search in delegation? I know of a function called StartsWith or something which is delegable but again it would only search strings at the beginning and not on any part of it.

[@RezaDorrani]

Search is not a delegable function with SharePoint and hence one cannot perform a contains string operation. You can apply the same trick as highlighted in this video to hide items by performing the contains query on each row.

[@versteegrob]

Thnx for the awesome video, very good explanation :)

[@RezaDorrani]

Thanks. I have a delegation workarounds video planned for more complex use cases.

[@ruthannvaldivia291]

Thanks, Reza for this video. If I have a data source greater than 2000 and my data row limit is 2000, will the hiding of rows allow me to access the rows over 2000?

[@RezaDorrani]

It should.

[@fenrir433]

I followed your last topic, and it works but when there is nothing selected in the multiselect combobox, the items are not visible. i would like them to show and filter based on the multiselect combobox. is that possible to solve? i can't seem to figure it out. Thanks Reza!

[@fenrir433]

for sharepoint delegation.

[@RezaDorrani]

Add checks to see if combo box is blank. kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@anilrambhajan936]

Hi Reza, This works perfectly but items in my gallery are "cutting off" on different size monitors. Please help

[@RezaDorrani]

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

[@american2236]

Hi Reza - seems flexible height galleries no longer hide gallery sections based on visible property of group inside, resulting in blank sections - negating the benefit of "flexible height." Was there a change that you are aware of?

[@RezaDorrani]

They do work. You probably have not applied the hide show logic on every control in gallery.

[@contactkpatel]

I had to same issue. Once I set the Template Padding property of the gallery to 0 it worked. So happy with the solution. Thanks Reza!

[@richellesinger19]

Thank you!@@contactkpatel

[@sonalshinde8254]

Hi Reza, What if I want to apply multiple multiselect filters on the gallery? what is the solution?

[@RezaDorrani]

I have done 4-5 videos on gallery filters. Check those on my channel.

[@GauravSharma-fq6sn]

What if I want to filter a gallery based on multiple filter columns using mult select combo box and && condition. Can you put up a video on that?

[@RezaDorrani]

Hi Gaurav For that all you need to do is apply the && condition in your creiteria when hiding the gallery item. In this video kzbin.info/www/bejne/pp-YYXSBo5iEZ7s I use the && condition to filter the gallery

[@hillaryburkett5301]

how would this work with a series of checkboxes (multiple filters, each with a checkbox in a gallery to show options) that are coming from a sharepoint online doc library with multi-select choice columns?

[@RezaDorrani]

I would have to try it out with your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@fenrir433]

hi reza, what if the combo box is blank? i still want it to show the items. if it is blank, it doesn't show my items.

[@RezaDorrani]

Add checks to see if combo box is blank. kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@ricardounzueta9570]

Hi Reza, Thanks a lot for your nice vídeos!!. I have implemented your paginated grid example and now I need to add this vídeo functionality, si possible to implement the pagination functionality with this type of grid and hidden the lines? Is the pagination going to work? Also un my grid I have the functionality that do the first grid column fixed to be able to scroll the lines. Thanks in advance

[@RezaDorrani]

Il be honest, the technique shown in this video is not great on performance. If you mix that with the grid (complex code), it will cause a lot of performance challenges.

[@ricardounzueta9570]

@@RezaDorrani Thank you very much Reza, you are a crack (The Messi of PowerApss explaining for me). Then I assume that the best way is to implement a new specific Custom Page to implement this purpose.

[@RezaDorrani]

@@ricardounzueta9570 Custom Page?

[@ricardounzueta9570]

@@RezaDorrani yes my app is a mix of dataverse and Canvas approach so for this case the data is in a sharepoint lista and I'm implementing the functionality using custom Pagés inside the modelo driven app

[@RezaDorrani]

@@ricardounzueta9570 Makes sense.

[@michaelcampbell6721]

This is fine to filter the gallery BUT I need to allow users to select multipl gallery items to PATCH to a SharePoint list so this does not work for that.

[@RezaDorrani]

This would not work for that scenario. I have not come across that scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@daniellebresich8074]

Hi Reza, If I don't have anything selected in the dropdown, nothing shows up in my gallery. Is there a way to have all records show if nothing is selected in the dropdown?

[@RezaDorrani]

Check kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@barbara5644]

Thank you so much for this video it was a great help. One question. The flexible height gallery is leaving different sized spacings between the rows. Do you have any idea why that might be occurring?

[@RezaDorrani]

Ensure you are setting the gallery height to 0 when no data exists. It is shown as part of this video.

[@pkp044]

@@RezaDorrani hello Reza, I'm sorry I guess I am missing something. Can you please let me know the exact time frame where you're mentioning about gallery height to 0

[@RezaDorrani]

@@pkp044 This video was done years ago. I don't remember myself. If you follow all steps it should work. If issue persists, I will recommend posting issue with screenshots on the forums at powerusers.microsoft.com/

[@ramprah8910]

Hi Reza, this is such a simple thing to do in every other system. But I just cannot figure this one out when it comes to Powerapps. I have a Dataverse table and I have a column which is of type Choice - Boolean Yes/No and its called 'isActive'. How do I filter my combobox to show only values of Choice 'Yes'. Its actually not 'Yes' or 'No' in Dataverse but more of 'Allowed' and 'Not Allowed'. I just can't seem to figure out the syntax to filter it off. I have tried Filter(Table, isActive = 1/"Yes"/ "Allowed" etc. Can you please guide me where I have to look as I don't have access to post a question on that Community forum and I have spent 2 hours trying to google everywhere. SP list syntax does not seem to work.

[@RezaDorrani]

Dataverse choice column is different. You cannot use numbers or strings to compare and filter. There will be a special Emum available for your column that you would need to choose the value from. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com I will plan to do a video on this soon as many are facing this issue.

[@ramprah8910]

@@RezaDorrani , Appreciate it! Thanks a lot! I shall post it today!

[@skanedes4410]

I am not sure I understand how this solves the delegation issue. Sure, we don't get the warning anymore, but the “filtered” (visible) data is still limited to the data that is rendered in the gallery, right? For example, if my filter criteria doesn’t match any record in the top 100 items, then I see an empty gallery.

[@RezaDorrani]

A gallery always loads data in batches of 100. When we show and hide all the items in a flexible height gallery based on any condition, it will still try to show 100 items based on matching criteria and hence it keeps loading further data. This is not the most efficient solution but currently there is no other supported approach with SharePoint as a data source.

[@skanedes4410]

Even if it is not efficient, I was hoping that this would work for me. Unfortunately, it doesn't. Using this method, I got three items to show up in the gallery. I know there are more items that match this criteria. Were you able to display an item in the gallery that is not in the top 2000 in the SharePoint List, based on the Multi-Choice column?

[@RezaDorrani]

@@skanedes4410 It does work. Something might not be right with your formula. Tough to know without looking at your App. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/

[@herrzettpunkt]

Maybe you can help me. I connected a document library to PowerAps and my goal ist it to filter the documents by dropdown fields. I successfully added a dropdown menu named DropACType with all the choices of Aircraft Types from a specific column with the formular Choices('Maintenance Documents'.'A/C Type') - so far so good. But when i try to filter the galery with the formular Filter('Maintenance Documents','A/C Type'.Value = DropACType.Selected.Value) it wont work. In all of your tutorials PowerApps suggest you the .Value command after typing or choosing the column, but that's not the case for me.

[@RezaDorrani]

As long as “ac type” is a SharePoint choice column it should work. Not sure why it’s causing error / not working in your case. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@herrzettpunkt]

@@RezaDorrani Hey Reza, thanks for the quick response! In the meantime i managed to get this formular work with a column where only one selection is possible. Every other column where multiple selections are possible will return a "large data set" error message. I'll try to dig deeper into that issue.

[@RezaDorrani]

@@herrzettpunkt Thats not an error message - that is a delegation warning. Check my video on combo box control and delegation playlist.

[@johnjairobolanos2332]

Hi, good video. How can I do to filter a data table using multiple combobox options?

[@RezaDorrani]

Same as the gallery filter options. Just combine your filters with AND's and OR's

[@geralddahl9159]

If I use forAll to patch the filtered items will the non visible items also be included? Can I filter the filtered gallery based on the size of the display so that the non-desired records aren’t included? Thank you.

[@RezaDorrani]

Yes, the non visible items will also be included. You would need to apply the non visibility logic to your filter condition for your items in forall. This will result in delegation issues though.

[@youngcarlsbad]

I still have gaps in my gallery even when using a flexible height gallery, any idea why?

[@RezaDorrani]

You need to ensure all the controls within the gallery have their visibility set to false based on the criteria defined.

[@joanasousa6233]

Hi Reza, I am getting perfomance issues with this solution, do you know if there is a better way to get this same result?

[@RezaDorrani]

I have a playlist on delegation. I don’t remember if I did show other approaches. You would need to check the videos in the playlist.

[@montalbaconsulting5871]

@@RezaDorrani Love the idea of this solution, but I'm also getting significant performance issues with this. Trying to use the Monitor to diagnose but it doesn't present all the info. It did show me 4000+ ForAll() processes (I think 1 per Dataverse table record). I think perhaps I need my .Items to retrieve only required columns and not entire table. Also wondering if the Flexible Height gallery takes time to 'size' each row individually (500 rows initially). I'm assessing this as an alternative to creating a secondary Text column and filtering that (e.g. Multi Choice column is 'Project'; when I create/modify a record via the Form I add data to the ProjectText column using Concat() function. Annoyingly, the Formula column type does not support Concat() so I have to do it via the Form)

[@RezaDorrani]

@@montalbaconsulting5871 I would recommend avoiding this technique if you are facing issues with it. I did this years ago and have not revisited it since.

[@pedropereira9322]

Hello Reza. Your solution worked just fine! However I had problems whenever I reset the combobox. If I reset the combobox the Gallery's items just disappear and then I need to select any of the combobox choices and then unselected it/them to make the Gallery display all values. Do you have any idea why this happens? To unselect the values from the combobox should be the same effect as the function of reset the combobox, however with this method it has different outputs and I still haven't figured out why. Thank you in advance and keep up the good work!

[@RezaDorrani]

The formula for hiding the gallery items expects the combox box to have values. You can add a check in there to see if combo box is empty then true else execute the condition

[@lisecarivenc1003]

@@RezaDorrani Thanks a lot for your video, which really helped me, I have the same question as Pedro and I do not find how to make all the item appear when the combo box are empty

[@RezaDorrani]

​@@lisecarivenc1003 You can check to see the number of selected items in combo box, If 0 then do not apply the hide logic. To check combobox selected items count use - CountRows(ComboBox1.SelectedItems)

[@Fernanda-uh7iz]

@@RezaDorrani I have the same issue, the IF function you are suggesting, should go in the visible property along the concat function??

[@RezaDorrani]

@@Fernanda-uh7iz It is tough to understand here on chat the exact nature of the request. I would recommend you post with screenshots on the forums at powerusers.microsoft.com/

[@MrunalLadde]

The Flexible height gallery is not hiding empty rows for me, does anyone know why is this happening?

[@RezaDorrani]

Every control within the gallery must have the formula set. I will recommend checking that and if it still does not work, then best to post this with screenshots on the forums at powerusers.microsoft.com

[@FCSSOFTWAREDEVELOPMENT]

Hello sir how to filter and search dropdown data in power app ? can you help about this issue ?

[@RezaDorrani]

If you use a combo box instead of a dropdown, it will give you search capabilities. It is not an issue. It is just how the controls are designed. I will have to look at your App in action with where you are trying to achieve this filtering and searching logic to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@FCSSOFTWAREDEVELOPMENT]

@@RezaDorrani Super thanks sir, you are great instructor.

[@FCSSOFTWAREDEVELOPMENT]

@@RezaDorrani Hello sir, one more my question if user take image and after take image firstly show message to user save and reject

[@RezaDorrani]

@@FCSSOFTWAREDEVELOPMENT Sorry, I did not understand your question. May be easier to understand with screenshots. Post your question with screenshots on the forums at powerusers.microsoft.com/

[@dabaquerom]

Hi Reza, thank you for your help it is amazing but I have an issue with the Flexible Gallery, it is not hiding the blank spaces, they keep being there

[@dabaquerom]

or hides some of them

[@dabaquerom]

the blank spaces were pad=5 accumulated now I need to check its performance it is too slow

[@RezaDorrani]

Hi Daniel I will check this later in the week and let u know

[@RezaDorrani]

Did you also set the height of the controls within the gallery based on a condition. Condition would be same as the visible property of the controls. Set height to 0 for cases that do not match.

[@lisadezarn857]

@@RezaDorrani I have a similar issue with a text input box searching a text field. The blank rows still appear. Could I get an example of the formula you would set on the height property of the gallery?

[@sridharreddy1607]

Hi Reza, What when we have two or three multiselection comboboxes to filter our gallery ?

[@RezaDorrani]

You can combine logic with && and || It gets more complex

[@sridharreddy1607]

@@RezaDorrani we need combine and logic in group visible property ?

[@RezaDorrani]

@@sridharreddy1607 Yes, if using this video technique. I have shown newer ones as well.

[@sridharreddy1607]

@@RezaDorrani where are those newer ones can you please share the video reference

[@sridharreddy1607]

​@@RezaDorraniHey any help , can you please share that newer reference videos

[@shreyasonawane8119]

hey rezza great video but when i have selected no item in my combobox the gallery gets blank which i dont want i want to display all item before filtering them any solution on that??

[@RezaDorrani]

Check my videos on gallery filtering where I have used combo box. I have done 2-3 videos on it.

[@shreyasonawane8119]

@@RezaDorrani i have checked it bit in my case the combo box has multiple choices and your video had only single choice in column so that was the issue how should i handle multiple choice column

[@shreyasonawane8119]

I would need some code that says in display of that group u wrote : that display these filtered value else display all images but not sure how to code that

[@RezaDorrani]

@@shreyasonawane8119 I have done videos with multiple choice as well.

[@shreyasonawane8119]

so i need a formula in visible of group that before fetching me yes results I want both yes n no results as well

[@mondettabyakhtar2144]

what if, there is no selection at all? for instance show every record then ...

[@RezaDorrani]

I have done many videos on filtering that showcase that. Here is one of them kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@mondettabyakhtar2144]

@@RezaDorrani doing the same thing from the video. when I load the first time, the selection is empty, but there is 1 selected item anyway.

[@RezaDorrani]

@@mondettabyakhtar2144 I will have to look at your App in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@mondettabyakhtar2144]

@@RezaDorrani two things were found, 1: in condition used "true" instead of true, 2: Set ComboBox: Default = {View:""} :/

[@shwetanayak979]

I tried this multiple tjmes but still i am getting blanks in my flexible height gallery can anyone please suggest what I might be doing wrong

[@RezaDorrani]

Try and first apply the query to a regular gallery (it will give delegation warning) but this is just to see if you are even getting any results back.

[@Inovators]

I use the same technique to filter data in gallery. My second step is to use the visible data in maps.But when i access this data it shows all the data because in real all the data is in gallery and we just true the visible property for the required rows. Can anyone help me how can I get the data which is visible in gallery?

[@RezaDorrani]

Gallery will only load data in batches of 2000. So querying gallery to get information in case of large data sets is not a good option. The technique showcased in this video is a hack that works for showcasing data in gallery based on filters. Your use case will not work with this technique. I would recommend you post on the forum to see if someone has come across this use case - powerusers.microsoft.com

[@dru6197]

@@RezaDorrani if the data set was > 2000 records, is there a way to filter the visible gallery items? I have a similar use case, but want to email the list of filtered items and I'm not sure if it's possible to filter the output to visible only.

[@RezaDorrani]

@@dru6197 Yes, if gallery follows delegation.

[@cazzah49]

WARNING - This method does not fix the problem. The goal is to avoid delegation warnings for a specific reason. This is because delegation warnings mean PowerApps cannot filter a list > 2000 items. In the shown example, 2000 items will be loaded into PowerApps as gallery items, and only then will the "in" operator be checked to calculate the visible property. So the problem remains.

[@RezaDorrani]

Thanks for the WARNING. Delegation is not just about filtering. It can be sorting or simply loading data in collections as well. Nothing can solve the delegation problem other than using delegable queries. Video simply does not apply any formula on the items property rather shows/hides items. So as you scroll down, it will load the data and hide the items based on the condition.

[@neemamotagi2404]

How to populate the gallery if nothing is selected

[@RezaDorrani]

Check kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@neemamotagi2404]

@@RezaDorrani thank you..

[@neemamotagi2404]

Hi reza, I tried, it works completely OK for one screen, the same is not working in other screen its populating the blank spaces too. I tired duplicating screen n using, but didn't work. What would be the problem

[@RezaDorrani]

@@neemamotagi2404 You need to ensure gallery is flexible height and every control within gallery has visible set to the formula. I'm not sure about copy and paste. May be something got missed.

[@neemamotagi2404]

@@RezaDorrani thq. I'm done with it.

[@sabrinakraus-zy1dr]

Another awesome Tutorial, thanks! There is only one problem, on Start of the app the gallery appears blank, because the group isn't visible. I added following check in the visibility property : If(CountRows(cbEinsatzbereich.SelectedItems)=0, true, "yes" in Concat(ForAll (cbEinsatzbereich.SelectedItems.Value, If (Value in ThisItem.Einsatzbereich.Value, "yes", "no")), Value)) It works - when all optioins are deseclect, it still shows the gallery's items. But not if reset (reset(cbEinsatzbereich)). What can I do, does the check has to placed somewhere else? Thanks a lot if sb can help

[@RezaDorrani]

This video was done years ago. I dont remember running into blank problem on start. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@DickerBub83]

@sabrinakraus-zy1dr could you solve that problem?

[@gristy58]

Seems to be what i need i just get Name is Invalid when doing my formula did i type it wrong -> Concat(ForAll(ComboBox2.SelectedItems.Value, If(Value in ThisItem.LeadAgency.Value,"yes","no")), Value)

[@gristy58]

nevermind realised it was different i needed to use Title not value

[@RezaDorrani]

looks like you get it fixed :)

[@RezaDorrani]

Nice!