PowerApps Multiple Filters on Gallery
Vložit
- čas přidán 29. 07. 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 🙏
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
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.
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.
Master piece. Thank you Reza as always.
You are most welcome
This is the single most useful power apps video I've seen. Thank you, Reza! Great explanations.
Wow! Thanks so much.
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!
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 Reza, you're a life saver! I spent days on this actually. Now my tasks is done...
Thanks!
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.
MAN I DON'T Know how many times you saved my Power Platform daily Life....THANK YOU MAN!
You are most welcome!
Thank you so much, again! Great videos for beginners, intermediate and advanced users.
You are most welcome!
you sent me enlightment after 2hours of trying to filter Sharepoint List - thank you Reza :-)
You are most welcome
Sir, this is Great!!! I used to waste so much time in long and conditions doing multiple filters
Great 👍
Those tips are lifesavers. Second time this video saves my ass with the Sharepoint filter. Thank you very much Reza!
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.
Great Video Reza! Like the layout too. thanks for the tip on filtering. worked a treat
Awesome! Thanks for watching.
Thanks for another great video! This helped me solve a filter issue that was driving me crazy all week.
Glad it helped!
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
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.
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!
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 😊
This video is God-sent! Thank you so so so much!
You are most welcome. Welcome to my channel :)
Learned a lot about powerapps filter usages, Thanks!
Great to hear!
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!
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!
Another great reference video, thank you Reza.
Thank you Ron
Thanks Reza, you're my Power Apps Super Hero.
🦸♂️ Thank You :)
Thanks for this video Reza, very useful as always!
Glad to hear that! Thanks for watching
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 czcams.com/video/bnC8u3gdWss/video.html
It also has link (in video description) to look at the sample App which includes multiple designs.
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 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 :)
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!
Fantastic video, thank you Reza!
Most welcome and thanks for watching
Absolute legend. Well done!
Wow! Thanks.
Reza, thank you so much! Your job is excellent! Congratulation👍
Most welcome! Thanks for watching and liking the videos
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.
Awesome Reza ,,,, you make things so simple ... thank you ..
Thank you very much
Great info, I only wish I had come across this sooner.
Better late than never :)
Welcome to my channel
Hi from the future😊😊. Top videos as always Reza thanks for all you do.
Glad you like them!
Thank you Reza, you're the best!!! You solve my problem 😅
Glad to hear that!
This is what im looking for.thanks 🤩🤩🤩
Glad it was helpful
Great video. Extremely userful!
Glad it was helpful!
This helped me so much. Thanks for your amazing videos!
You're so welcome!
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.
Amazing video ! Thanks a lot
Glad you liked it!
Thanks Reza always excellent videos
Glad you like them!
You Rock! Thanks for your efforts
My pleasure!
You are the Goat Reza! thanks for this one
My pleasure!
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! the watering be multiplied to you!
Thanks Kyle
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.
Nice way to solve multiple filters, and great video 👌👌👌👌
Thank you! Cheers!
thank you very much sir for all the explanation
You are most welcome
Thanks a Lot !!! Great Content !
Thank You for watching.
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.
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 czcams.com/video/Wr42PeW6_wU/video.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
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 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
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 czcams.com/video/Cu8pDo6WpRI/video.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
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.
Thx for sharing!!! Very helpfull!!! Greetings from germany Christoph 👏 👏 👏 👏 👏
Glad it was helpful! Thank You!
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.
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 - czcams.com/video/Qfer3DwjfwA/video.html
thank uuuuuuuuuuuuuuuuuuuuuuuuu such a beautiful tutorial
You’re most welcome
This is amazing!
Thank You
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 - czcams.com/video/tPxE_-DcWkg/video.html
Loveeeee ittttt!!!!!
Thank You
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 - czcams.com/video/bnC8u3gdWss/video.html
Video description includes link to download sample App as well.
Great, as always
Thank you! Cheers!
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
Thanks a lot sir ,you are great
Thank You 😊
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 - czcams.com/video/pn50AKn3Q1Y/video.html
I love great videos! :)
Thank you!!
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.
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
Very nice and useful!!!
Thank You
extremely helpful, thnx a lot
Thanks for watching
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
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
Thank you sooo much
You are most welcome
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.
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
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.
Hello Reza, i am trying to add multiple filters using this video while also filtering my date column using one of your previous videos. i have been able to filter by date but i dont know how to add the additional filter without getting errors.
so here is my date filter which works: SortByColumns(Filter('Works',
PlannedDateNumber>=VarDateFrom && PlannedDateNumber
I would have to recreate your scenario or look at your App in action (screenshots) to provide any guidance. I would recommend you post 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 czcams.com/video/6KlI1iZ_KD0/video.html
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 czcams.com/play/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD.html
Thanks for such excellent video. I'm replicating several filter for my own project in PowerApps for Teams and it seems Date column has different properties. It doesn't accept SelectedDate, instead
It only accepts .Value. But the filter doesn't work as expected. Do you have any tip to solve it?. This is the syntax i'm using:
'Project Deliverable Estimate Date'
I have not faced any issue with date columns.
Here is one of my old videos. Check - czcams.com/video/eCMuXPI1Qok/video.html
Thanks for the video, it's really helpful. I followed this tutorial yesterday to implement some filters on my galleries and I also used the choices fields in comboboxes. It was all working perfectly yesterday. but this morning I have found that my filters have stopped working and that the comboboxes that reference choices now contain an IDs aswell as the Value. I'm so confused how things can just change overnight
Overnight changes are scary :) Did you try posting your issue on the forums with screenshots?
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I'll be having a look at it Tomorrow morning to see if the issue persists, and if so, I'll follow your advice and make a post. Thanks for the help and thanks for the videos. They really are very helpful 👍
A life saver video
👍 👍
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
Awesome stuff
Thanks
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
@reza , I get error in the Equal sign ? when apply the command in the gallery items Filter('Expense_1',Category = ComboBox2.Selected.Value)
That depends upon your data source. You are using Expense_1 - what data source is it?
What type of column is Category?
If SharePoint and column type is choice or lookup then use
Filter('Expense_1',Category.Value = ComboBox2.Selected.Value)
Hi Reza, another great video. The dropdown task status filter works fine, I've then added the checkbox options, when I check a box the correct task appears in the task status label, however my gallery goes blank.
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
I am getting the same behavior, if you were able to resolve, would you mind proving guidance?
@@SheaStith hi, I never got to a resolution. I even tried posting on the Microsoft community. Eventually I removed it altogether and stayed with the drop down list
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/
Hi Reza. As always, thanks for your efforts with these instructional videos. Always excellent!
I have a particular project that I am struggling with. I have a SP list and SP library. The library has a lookup column that refers to the list for assigning a number to a document in the library. I've built a powerapp that uses 2 dropdown filters of a gallery (filtering each other dynamically). The gallery is just a display of the list so the user can see the remaining options for selecting a number to assign in the library. Since this is a powerapp that edits the fields in the Sharepoint library, I need to have the resulting options in that dropdown be pre-filtered based on the 2 list dropdowns that filtered the gallery. I apologize if this is confusing.
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.
@@RezaDorrani Do you know of a way to add a sortbycolumns() function to sort the gallery in ascending order once the filters have been applied? It would need to be after the delegation limit errors are no longer an issue (after filtering). I'm getting an issue where the list is out of order of how I would like it displayed. I've seen your video on sorting, but I don't know how to add it to the existing filtering formula you demonstrated in this video without creating issues.
@@user-zl8vt8fz2d Simply add sort logic on top of filter. I have a video on sort and filter which does exactly that
@@RezaDorrani Perfect, thank you. Works great!
@@RezaDorrani This worked, thanks.
Now I need an additional filter, but I'm not sure if it is possible. The gallery (from a SP list) needs to filter based on if values in a column in the list are used in a library (via lookup). The library lookup column enforces unique values. So if those are used in the library, I'd like the gallery view to not display them.
I was able to run a clearcollect on the library to pull all active values for the library column. Then I've been attempting to use Filter(source, isblank(lookup(clearcollectname, value=columnname.value)) but am getting errors. Any tips to finish this off?