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
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.
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.
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 :)
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.
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.
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 😂🤣😂🤣
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.
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
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.
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
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.
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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bnC8u3gdWss.html It also has link (in video description) to look at the sample App which includes multiple designs.
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,
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.🙏
@@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, 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
YOU ARE A LEGEND Reza.... This video is a life-saver buddy... Keep it up... A small question I have a SP list with 44 columns and around 600 rows I need to filter it by 5 text columns also by 10 range of days and finaly around 5 choice columns... An advice on how to start would be really appreciate it... Thanks 😊
Just follow the technique in this video to achieve it. You will need to add plenty of conditions in the filter query. Since your data source is SharePoint use the StartsWith function.
@@RezaDorrani Legend :( when one applies various StartsWith to the filter the gallery doesn't show anything and also if the columns that you're filtering by have empty records those rows are just ignored... :(
@@RezaDorrani You are right Master I apologies the query works ok but I think if on the column there are empty fields, in my case, not all the records have yet a Manager assigned so those records are ignored. Filter(colProcesses, StartsWith(Companyname, inputCompanyName.Text), StartsWith(Manager, inputManager.Text), StartsWith(Reviewer, inputReviewer.Text), StartsWith(Form, inputForm.Text) ) I really appreciate your time answering my silly questions... God bless you.
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, 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
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
@@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
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
Hi Reza, love the videos, especially this one. Very clear and great examples. I'm just having an issue where the combo box will filter the gallery fine. And the check box will update the combo box but this doesn't filter the gallery, it returns no items. Any ideas why that might happen?
Try breaking the formula into parts. First check if you get data for checkbox query. Then check for combo box and then merge both. 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
@@RezaDorrani I also had an issue with this formula. Ended up breaking it into parts as you've suggested, and trying different variations of the syntax. I kept a record of each variation I tried so I could refer back to it. From your video around timestamp 6:50, IsBlank and IsEmpty worked fine, but the 3rd argument didn't. (For simplicity, I've transcribed my fields etc. into your terms, but my scenario is the same - I have a text box input and a combo box input...) You wrote: 'TaskStatus'=cbTaskStatusFilter.Selected.Value, and I narrowed it down to this argument. Eventually I found that I had to change the argument around, to: cbTaskStatusFilter.Selected.Value=TaskStatus.Value Then I progressively rebuilt the entire function in stages to check it still worked. I wonder if this is a change to PowerApps since you did this video? I've come across a few other things that seem to work differently now than when the help topics (not just yours) were written 2-3 years ago.
@@GraemesAdventures Thanks for the updates. Is your datasource Microsoft Dataverse? Im using Option Set type column in Dataverse. Based on your usage of .Value it looks like you are using Sharepoint choice column. Formula would differ based on column type.
@@GraemesAdventures The video showcases example of Dataverse at the time you mentioned in the video. For choice columns, .Value is a must. I have videos on filtering specific to SharePoint as well on my channel.
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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bnC8u3gdWss.html Video description includes link to download sample App as well.
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
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
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
Awesome video! Is there a way to have a drop down filter that contains all the items in a column - name for example. So instead of typing in the name, the user would select from a drop down based on the contents of the Name field. Is there another video that explains this? Thanks!
Thank You! Creating a dropdown that lists out all the values from a column would result in a delegation warning (will not work with large data sets). I do not have a video reference on this scenario though.
Hi Mr. Reza Dorrani, First of all thank you for making these knowledgeable videos. Secondly, Can you please guide me because "I want to apply current user & view all users filter in PowerApps Gallery by control using radio buttons or drop down". I will be thankful if you can guide me about that. Thanks
You can add 2 options in dropdown (current user, all). Then check value of dropdown and add filter. If(drpdownvalue = "Current User", filter for current user, get all data). I would recommend you give it a try and in case of issues post it with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Thank you for the great video. I am very new to Power Apps I wanted to know if you have a video that shows how you made the gallery to contain more information then just title, subtitle and body. Thank you.
Hi Reza, Love this video. One question is there a way to have a main text search and then have a 2nd text search that will filter the results of the first text search? How do you do that? Do you have a video on that? Thank you.
@@RezaDorrani Yikes I don't know how to stitch multiple functions together. Do you have a video that goes over how to do this? Thank you for being so responsive it is greatly appreciated.
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.
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 👍
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.
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.
@@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?
Thank you for your videos. They are quite good and really helpful but there is one functionality I could not find in any of your videos. I have a list with 3 columns...just for the sake of simplicity, I will use car brands example. The first column is brand of cars, second column - models, 3rd column - colors. I want this list as my source to show in a canvas. The canvas will have a search buttom which I know how to set up. The struggle is adding "ONE" dropdown so when a user choose Toyota, next values of the same dropdown will show Corolla, Camry, Highlander then when the user choose Corolla, next values will show the colors (the canvas updates too while interacting with this dropdown. Do you have a sample video of this functionality? Thank you.
Seems like cascading dropdowns. Search for cascading dropdowns on my channel, I have done videos on them. Scenario will not be exactly like yours but outline would be similar.
@@normanbercasiophotography1749 I may not have understood your requirement. Difficult to do so here on chat. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com/
Top Video Reza as always!! It's possible to filter a Gallery based on a Lookup Column in Sharepoint? I can use the Choices function to get the values to a ComboBox, but when I tried to filter the gallery it's return a error. Keep the good working.
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!!
You will need to build a collection and add your own values in there. In this video I add “All” as an option - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IWEQwGLcW7Q.html
