Multi Select Filters in Power Apps with Combo box, Checkboxes & No Delegation❗
ฝัง
- เผยแพร่เมื่อ 20 ก.ค. 2024
- In this step-by-step tutorial video, we will learn how to build multi select filters in Power Apps. We will apply multiple filters to PowerApps Gallery including multiple item selections using combo box, multi-select checkboxes and multi select buttons.
We will build these gallery filters keeping delegation in mind (No delegation warning) & work with multiple data sources like Dataverse & SharePoint.
I will showcase how to filter a multi select choice column based on a multi select combo box control.
Trick is to go around the IN non-delegable Operator and use Equals (=) which is a delegable function.
I will also cover a new function called "Index" in Power Apps.
Video covers the following:
✅ Multiple Item Selection based Filters
✅ Combo box control to filter Gallery for SharePoint List & Dataverse
✅ Multi select checkbox-based filtering
✅ Multi select button-based Gallery Filter
✅ Multi Select Filter on Multi Select Choice Column
✅ Reset filters
✅ Delegation Workaround
✅ Index function
Power Apps Delegation Playlist:
• Power Apps Delegation ...
PowerApps Multiple Filters on Gallery:
• PowerApps Multiple Fil...
• Power Apps Sort and Fi...
Power Apps Gallery Designs (Styling as Cards & more):
• Power Apps Gallery Des...
#PowerApps #Filter #PowerPlatform #SharePoint #Dataverse
Table of Contents:
00:00 - Intro
00:36 - Multi-Select Filter for Gallery
01:49 - Multiple Select Filters using Combo Box for Gallery connected to Dataverse
06:04 - Multi Select Filter using Combo Box on SharePoint List
10:58 - Create Multi Select Filters with Checkboxes
14:32 - Create Multi-Select Filter with Buttons
20:18 - Multi Select Filter on Multi Select Choice Column
23:33 - Subscribe to Reza Dorrani Channel
🤝 Let’s connect on social:
🔗 LinkedIn: / rezadorrani
🐦 Twitter: / rezadorrani
![[SUB] 베몬이 교관님 멘탈을 탕탕 후루후루~٩(๑❛ᴗ❛๑)۶ FOREVER 웃게 되는 갓기들의 수련회 | 돌들의침묵 | BABYMONSTER(베이비몬스터) 'FOREVER'](http://i.ytimg.com/vi/FISAO7BwIxE/mqdefault.jpg)
Wow, well that escalated quickly. It always looks simple and easy when demoed by Reza. Kudos for making this content. ❤
Thank you! 😊
I really liked how you used a gallery for buttons. It makes everything look uniform. I look forward to applying these techniques, so thank you!
Awesome! Thanks for watching.
Life saver ! I searched everywhere to figure out how to compare tables to each other and this gave me the solution. Thanks :)
Happy to hear that! Thanks for watching
Thank you so much Reza! I was hitting a wall when I had to change a single choice combo box to multi choice and you saved my staff directory app. Such a godsend.
Great! Happy to hear that.
Much needed one. Entire community is going to jump on this video 😀
I made this video because I received a ton of requests on this topic! Let's see how many people like the approach showcased in the video.
You are my go to when i am struggling with something inPowerApps. Very clear explanations, thank you.
You're most welcome
thank you very much. The last minutes were perfect for what I had to do :)
Glad to hear that
Great video as usual. I love to learn from your videos. Always well presented.
Thanks Bharti
Thanks for this great video. I picked up some more knowledge nonworking around delegations
Glad it was helpful!
This is massive Reza! Thanks so much.
You are most welcome! Happy to hear the feedback on this video. I’ll be honest I was a little nervous for this one :)
Wow...great video as usual 😀..Thank you Reza!
Your most welcome!
Wow, Rezza. Awesome work again.
Thank you so much 😃
A stunning & impressive presentation. 🤩🤟Really, really good.
Many many thanks
Thank you for your videos, special about dataverse, they are amazing and useful. Thanks
You are most welcome!
Thanks Reza. Your videos saved hours of my research time.
Most welcome!
Thank you Reza, it helped me tremendously.
Glad to hear that. Thanks for watching.
Reza, you are the best!
🙏
Bahut hard... Your You tube videos always shows god mode thinking 💭! 😃...
Apna time aayega!
Thank You :)
Great video, thank you!
Glad you liked it!
Incredible as always Reza, thank you very much, It's sad but understandable that there are almost cero example on SQL databases, mostly dataverse and sharepoint, but work perfect for mine sql one!, except I still have delegation problem!
Most welcome!
Sql requires additional setup and most of the video requests have been on SharePoint and Dataverse and hence that direction.
I’ll recommend posting your issue with screenshots on forums as there are users using sql and may be able to help
powerusers.microsoft.com
Thanks Reza excellent content as always
Much appreciated
very helpful and innovative videos, appreciate your efforts brother
Thanks a ton
Reza thank you for the very helpful videos you are doing. Fantastic! I have a question about tracking the changes on the list body, so how to have history of the changes on the column and not the items. Is there any flow or function to achieve that? Thanks again!!
Nothing out of the box. I have a video on versions (coming in 2-3 weeks time). I plan to show which column value changed from last version. Might be useful in your scenario.
Reza, another great video, I am relatively new to your TH-cam channel, is there a place to get transcripts that include all the code examples you write? The never-ending list of new functions is overwhelming.
If I have shared the code base, my video descriptions would include the links.
Most of it is on my GitHub repo - github.com/rdorrani
List of new functions** - You have my attention. That's exactly what my next video is :)
Hi Reza this is really cool, especially the multi-select filter with buttons. I am wondering what would be the best method to make it so that users can only pick one button at a time, and clicking one button makes all the other buttons "false". Thanks for the great work tho!
Simple make a dropdown filter, which forces user to make a single selection.
Excellent content! Much needed functionality for many document management scenarios. Do you have a step by step detail guide for this video for beginners?
Thanks so much.
I have done many videos on gallery filtering. Step-by-step for videos may be may not be. I have done over 200+ videos so do not remember.
Great video. There are a few ways to do this but I notice you had "All" in the default for the dropdown but that's not one of your choices in the SP list. What's the RD best practice way for doing that? I realize that's a 101 question but I like to know best practices.
Watch video from 2:18 onwards
Hi Reza, Thanks for the tutorial.
Can you suggest or point me to your any tutorial how we can handle scenario where we need to Multi-select Items from Gallery and adding/removing them from Collections
Check my playlist for Editable Grids
th-cam.com/play/PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU.html
I have a pretty extravagant filter bar that I just finished this weekend, trying to get around delegation with looping through the combo boxes etc...
Welp, guess I'm rewriting the formulas tomorrow...
Edit: I completely forgot to say, THANK YOU!
You are most welcome!
Let's write only Delegable Formulas :)
hi reza, Great video. Can you make a video on Branching questions should deal with powerapps form and with SharePoint as a backend datasource?
I will need a lot more folks requesting this topic to add it to my backlog. I have many ideas with over 50 requests that are sitting in my backlog.
Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.
Super Awesome Reza.. 💜ed It! Hope we get 'in' operator for SharePoint too, for delegation..
Thanks Sunil.
“In” with SharePoint is not delegable as per design for now.
Reza, but do you think we should see that coming in near future? As we just saw, 'in for Dataverse' supports delegation in experimental mode..
@@NarnawareSunil I hope it does but nothing has been announced as yet.
You are awesome.
I hope the content is more awesome 😉
thanks amazing lesson
Thanks for watching
Awesome stuff Reza. Though, for some reason I’m having trouble populating the combo box using the Choices function. I’m using: Choices(data source). But nothing populates? I’m definitely using a SP list with choice columns for this. Any ideas?
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
Reza - Thank you again. Just realised the source SP column was labelled ‘Task Status’. I changed this to ‘Task_Status’ and fed this into the Choices. It appears it doesn’t like spaces.
Now working perfectly. You’re the master - please keep educating newcomers and learners like me.
Nice old video,, ... @Reza Can you suggest some different type of filter screens for Mob, Tab & Desktops... or at-least some sources..
I have done many videos on filtering. One on filter pane. Check that one.
Great video Reza! thank you for sharing.... quick question, is it possible to use the index approach with a combobox to filter items that are assigned to @me using emal?
Why do you need index for that? Since you are only filtering based on current user. You can directly filter for that.
@@RezaDorrani thank you for the quick feedback, well… just trying to figure out the formula, this is multi select SharePoint people column and I am trying to filter where my email is included, I reviewed your other videos using the hide flexible gallery but not sure how to connect the formula to this approach…. Thank you for your response… I am a big fan!
@@isaiaguillon9878 ok. Index should work (not 100% sure) but as shown in video you need to have some limit to multi select.
Hey Reza!! Great content. Can you please help me on displaying use’s image on every card. It’s not working for me. May I know the formula you have used in there.
I used office 365 user's connector to get the users image.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, This is amazing! How can I add more than one combo box to my filter pane? When I added the other combo boxes in the Items of the gallery everything stopped filtering but isn't showing errors.
By combining filters using AND or OR.
Check th-cam.com/video/5dSk5iOgT68/w-d-xo.html
@@RezaDorrani Thank you !!😃
Wow..
So much information in just a 23 mins video..the "!(false ForAll(.." was a wonder for me.
Can u plz share the link of the video wherein you designed such a nice app or where to go and get beautifully designed apps?
Thank You Mohammad!
Video description has link to my video on styling galleries.
I have also done videos on left navigation on my channel. I reused my component here.
@@RezaDorrani thanks Reza
Hi reza. This video is really helpful. I am new to power app. I don't know how to select only one button instead of selecting multiple buttons for filtering at a time. And it is possible to change the pressed color for the difference to know which one is selected? Any Suggestion.
If its a single selection scenario, then simply use a dropdown.
If u still need buttons, then set 1 variable value when button is clicked.
I do not have a specific video on it though.
You may want to try checking on forums in case someone has done something similar
powerusers.microsoft.com
Hi Reza, thanks so much for your video, really helpful! I'm having a problem when following your steps for the multi-select filters though. It's working perfectly well when using the Last(FirstN( combination, but as soon as I replace it with the "cleaner" Index( function, it stops working correctly and does not filter the selected values anymore. Any reason why that might be happening? Thanks in advance!
Even I had Lookup initially but had to change to Last(FirstN
Has to be some sought of bug.
Same issue here, doesn't work with the Index function but it does with the Last(FirstN functions... Btw I'm using SQL server as a data source.. not really sure if that's the cause
Hi reza,
This is a one of the amazing content from you thank's a lot!, And I have an another scenario, If my powerapps combobox only select one value (multiselect turned off) but the backend sharepoint was have an multi select choice column, I want to filter with these combination is this possible to filter?(Powerapps combobox single selection and sharepoint column multi selection)without delegation reza!
Thank you!
Video shows how to filter on multi select choice columns. Does not matter if combo box if limited to 1 or 5 options.
Thank you for the video sir, this helped me to filter with multiple items but i am looking for the exact match with multiple selections. Can you please suggest if there is any way?
Welcome!
I am not sure how to do that.
Hi Reza, I've learnt so much from your well detailed videos. I created check boxes as per your videos and all works well. However, is there a way to set one of the boxes to selected by default, even after reset? Thankyou in advance.
Thanks for watching and learning from the videos. Set default property of combo box or gallery depending upon what you are using. I have done a video on combo box where I did show default. I also did a video on multi-select checkboxes in power apps where I did show default logic.
@@RezaDorrani I really appreciate you taking the time to respond. Keep up the good work you do.
Hi Rezzza, fantastic tutorial as always. I was wondering if you could explain how the Or function is working in your examples? I got my filters to work but I think it was more luck then understanding the Or function.
Thanks
The explanation is the video itself :)
@@RezaDorrani I was curious about the or function too - the last filter video you did used && and ||. Is the function new, for specific use cases, or you just started using it more?
@@caraziegel7652 You could use either “AND OR” or “&& ||”
Both yield same results
@@RezaDorrani i ended up googling my question and came across and article that said there are 3 ways to and/or and they all work the same, just pick one and be consistent.
This video helped me a lot in my project, but I have a question, I didn't find in your videos, how to save the "toggle" inside the datacard for the sharepoint list.
I've done over 200+ videos hence I don't remember myself.
Wow, Reza! I've been needing this for so long! Then Im sadly, found there was/is still a limitation.
My combo box has far more selections than 5 and there is no way around that. It might have three; it might have 200 options. My options are already filtered by a parent dropdown.
Any thoughts about how I can manage this since there is no way to create checkboxes or buttons because the choices are too many?
As always, thanks for your excellent guidance and help!
There is a way out with this approach. You do not have to use checkboxes or buttons. Let the user pick from your massive list of options in combo box.
However you would need some limit. You can allow them for example a max of 10 selections in combo box.
Write code for 10 indexes from your combo box and you should be good.
I dont think you want scenarios where a user is requiring to filter a gallery of more than 10-20 selections.
@@RezaDorrani Hey Reza, why would you not recommend allowing users to select like 200 options( by selecting “all”) is it concerns with performance ? I would like to create a forAll functions for all the items selected in combobox
@@filberful Performance will be biggest concern.
@@RezaDorrani even if performance takes a hit, how to do that?
I dont attempt scenarios where performance will take a hit. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com/
Can you please share the link where you have created a similar Gallery the one in this video with details. I want to create one for my current project.
That video is coming next week. Check community tab on my TH-cam channel.
Hi Reza, would like to ask i was using a container for my socrecard tracker. and trying to put in i the contaner gallery some icons to edit. I couldnt seem to reposiiton them propely and in the header container gallery.
Check my videos on responsive design. They are all placed in a playlist.
Hi Reza, videos is really helpful.
I have one scenario, kindly assist with that. I have a combo box which is showing the item based on the SP list and they are multi select. Same list is being used as a lookup column in the document library. Now when I am trying to filter it based on the selection from combo box, it is giving me the delegation warning plus comparison error with = and in.
Any suggestion.
I will have to look at your app and scenario in action to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
HI Reza! Great video -- as always. But I'm really stumped trying to apply it. (I've also watched some of your other similar videos. ) I have SP List with a Choice field set for multiple choices. I am trying to filter my Power App gallery using a multi-select combo box bound to the field using the Choices function. (I've also tried binding to a collection that contains the choices as well.) But none of the steps you walk through are working -- from the non-delegable "in" to the Index() function. I keep getting variations of the "invalid argument type," including "cannot use table values in this context." I have re-created all of your steps, including creating a new choice field in SP, but get the same roadblocks.
Filter(
'Call Board_1',
Or(
IsEmpty(ComboBoxTagFilter.SelectedItems),
IsBlank(ComboBoxTagFilter.SelectedItems),
Tags.Value in ComboBoxTagFilter.SelectedItems
)
)
I expect the delegation warning, but not the invalid argument type. I altered the above to use the Last(FirstN().Value approach you suggest as well.
Filter(
'Call Board_1',
Or(
IsEmpty(ComboBoxTagFilter.SelectedItems),
IsBlank(ComboBoxTagFilter.SelectedItems),
Tags.Value = Last(FirstN(ComboBoxTagFilter.SelectedItems,1)).Value,
Tags.Value = Last(FirstN(ComboBoxTagFilter.SelectedItems,2)).Value,
Tags.Value = Last(FirstN(ComboBoxTagFilter.SelectedItems,3)).Value,
Tags.Value = Last(FirstN(ComboBoxTagFilter.SelectedItems,4)).Value
)
For this approach, I am getting delegation warnings -- which I wasn't expecting -- and a "incompatible types for comparison: Table,Text." Finally, if I switch it to Index(), I get the same error.
By the way, my SP List has less than 2 items and my app is set to the default delegation limit of 500. I am scratching my head.
I will have to look at your App & SP list column setup in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks!
@@dbeebebrooklyn : I am facing similar delegation issue.
I have similar multi-select choice column at SharePoint List and Multi-select combobox at PowerApps.
Did you find any resolution ?
Thank you
@@RezaDorrani I am also facing similar delegation issue.
I have similar multi-select choice column at SharePoint List and Multi-select combobox at PowerApps.
is there any resolution ?
@@manjunathpatil6785 The video is the only resolution I have. I would need to reproduce your issue or look at your app in action to provide guidance. It would be best to post the issue with screenshots on the forums at powerusers.microsoft.com
Nice. I used the 'Index' function on my combobox and it removed the delegation error. However, I have three additional combo boxes and using the same 'Index' technique brought back the delegation warning for that second one. 😒
Must have to do with the technique being used to add the filter logic. I have not tried with multiple combo boxes though.
@@RezaDorrani Yes it seems to have something to do with the new syntax. I used the older technique you showed in 2020 simply using: 'field1=cbobox1 || field1=cbobox1 || etc. And that doesn't yield delegation errors.
Trust Microsoft to be inconsistent with this "low code, no code nonsense" that only works properly if it's a Tuesday with a full moon.
Even doing this filtering on the fly in Excel or Access then gathering the filter code for that years ago was more intuitive and ultimately more functional.
Iys taken me over a month of trials and tribulations just to hack together some flows and an app.
They could've produced a far simpler method of constructing these things.
Hi Reza, Thanks for the video! I have similar issue with share point list (the ‘in’ not delegable problem). But in my case I don’t have specific count of possible selection like those 5 in the video. It can be 1 it can be 100. I am losing hope to solving this😔. If you know how to solve it will be much appreciated 😄
There is no workaround for delegation with SharePoint.
Hello Reza, thanks for the video, it is really helpful. I am trying the same, but for some reason, I am still getting thee delegation warning, below are my configuration:
1- Choice field (ApprovalStatus) (Choice list: APApprovalStatus)
2- Combobox control (cbStatusFilter)
Items: Choices(APApprovalStatus)
2- Gallery:
Items: Filter (Table, ApprovalStatus in cbStatusFilter.SelectedItems)
i made sure that i enabled the "Enhanced Delegation for Microsoft Dataverse"?
any clew what am I doing wrong here?
thanks,
I would have to look at your App in action to know more.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
Thanks Reza, it is a good workarround!
I dont know if it is new but I am getting an error and then the filter wont work if there is less selection than index provided in the OR.
Example, if I use this in my filter:
Or(
IsBlank(FilterServices.SelectedItems),
Service = Index(FilterServices.SelectedItems,1).ID,
Service = Index(FilterServices.SelectedItems,2).ID,
Service = Index(FilterServices.SelectedItems,3).ID
),
But if I have only 2 items selected, I get an empty gallery. I see this text when I mouse over the 3th index,
Index(FilterServices.SelectedItems,3) = Error. (The second argument to the 'index' function must be between 1 and 2, the lower and upper bounds of the table. The upper bound may be reduced due to the non-delegation limit)
So the Last(FirstN( might still be the best solution for my case. Thank you for that trick!
I will have to look at your App in action to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi David, have you solved it?
Great video!!!. Please how can copy an Item intoo another List and delete the copied Item from the Original List?. It'll be very helpfull. Thanks in advance
Better option would be to move the item (includes versions of items as well).
I think I did show how to achieve move using flow - th-cam.com/video/EJyZfYMi4n0/w-d-xo.html
@@RezaDorrani I just finished your video. The problem is that I have two different lists (List A for IT staff and the other list for HR staff) and my application allows me to generate tickets for these two categories. And right now I would like to make sure that the person who has chosen the wrong category can change and choose the right category. I would like to know if I can change the category to the right one. For example, if I choose the category It instead of Human Resources, how can I change it to the right category?
@@onevision6706 Depends on a lot of things. How does one know that a wrong category is selected, where do you want this change to happen etc. It is difficult to provide guidance here on chat. I will recommend posting your issue with screenshots of your App & scenario on the forums at powerusers.microsoft.com/
Hello, Im trying to apply multiple independent dropdown filters to a collection with a choice column. I tried pulling the choices from the SP list and using a lookup for that filter but nothing works.. do you have any ideas ? or a video about this. Thanks
I have not come across this scenario or 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
Reza, mine i have 3 combobox with big options (10, 10, and 30) is there a problem if I write index 30 times? And what if people add more, is there any way of automatically increase? Thanks, you are the best!
Formula will become complex + maintenance challenges + there may be performance impacts.
Reza, can you combine a multi-select filter on multi-select choice column (using a combo box) along with a text search function like you did with the regular choice column?
Possible but not something I have tried
@@RezaDorrani Any ideas on how that would be accomplished? I tried combining your code for the Multi-select/Multi-Choice with the Starts With for the search box, but that got an error.
@@zestern I will have to try it out to know the steps. Try posting your query on forums powerusers.microsoft.com/
Thank you for this extremely useful demonstration, Reza. Is there a limit to the number of combo box filters? I ask because in one app, once I got to seven combo box filters, I have a problem with the gallery not loading when the app opens. Also, the reset button leaves the gallery empty. You have to do a search, and then the gallery loads again. But with only three or four combo box filters, it works fine. Is there a limit? Or maybe something else is causing this?
Most welcome!
I am not aware of any such limit. It might be something else thats causing this.
@@RezaDorrani Thank you, Reza. I figured it out. I had to add " || IsBlank(SEARCH-TEXTBOX.VALUE)" to the search box filter.
@RezaDorrani Thank you, Reza. Yes, I figured out how to solve this issue. In the part of the "ITEMS" filter for the search b ox, I added " *|| IsBlank(SEARCH-TEXT-BOX.Value)* " at the end, and now the gallery loads upon opening, as well as after clicking the "Reset" button.
Reza I am using a dataverse table so I followed the example starting at 1:49 in your video which worked. I didn't follow the steps starting at 6:04 in video since its sharepoint and thats not what i am using. I did follow the example at 10:58 because I do want to use a checkbox but once I do that and click on any checkbox it doesnt display anything in my gallery?
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
Great Tutorial M. Reza. I tried to reproduce the Multi Select Filter using Combo Box on a SharePoint List (starting at 6:04). For me, it only works when all choices are selected or none. Otherwise the filter returns nothing. What did I do wrong? Thanks.
Thanks!
I have not come experienced 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
@@RezaDorrani With the Index function it is not working, but with Last(FirstN(...)) it works perfectly as in your video. Thx!
Hi @RezaDorrani, would you please share your thoughts on how can we filter 35K SP items using dynamic filters. Eg: I am populating my combo box data using a filter condition, hence it's items are dynamic (i.e., my combo box items count is unknown). In this scenario how can we avoid delegation and get the data on to canvas app? Thank you in advance.
As long as delegation is covered, it does not matter how much data you have.
I will have to look at your App in action to know more about your scenario & provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you @@RezaDorrani for sharing your thoughts on this. I have posted my query at the community tagging you. I will try to share more details there.
@@mspowerassist Forums is where there are many experts. I only go to forums to assist in my free time.
Hi Reza, quick question: how can you have 2 combo box filtering the same gallery? I tried adding the same code on the second combo box but the gallery is blank when I choose one single value from each combo box and is displaying everything if all options are ticked in the 2 combo box. thank you, in advance, for your support.
Should work if you have the right combination of OR and AND operators.
Not sure how exactly you have framed your query, columns etc.
I recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com
is there a workaround for the delegation warning of filtering a sharepoint multiple choice column atm yet?
No
Reza I am really struggling with the scenario where the selected combo box is equal to “blank” keyword , the table should only show blank values in column
In that case for gallery items property you can write:
if combo box isblank or isempty - then filter(datasource, column = "")
else the logic shown in video
Hello reza! It is possible that this code: "region = Dropdown3_1.Selected.Value && hrCatalogCategory = Dropdown3_18.Selected.Value && country in ComboBox1.SelectedItems.Value" do not work with records of more than 2000 rows? I really need to know how to filter a gallery (which is conected to sql) with a combobox in which we select more than one option. Thanks and I hope you can answer!
I have done no work with sql so not sure.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
10:13 Hi Reza, I have used the function Index as you have suggested in my app. However, due to incompatible datatype (Table & Text), I could not be able to receive any record that I Have before. Is there any way to solve this? Many thanks
Looks like something to do with your setup. Either column type or formula. I have not come across this issue hence not sure.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Reza, If we are using SQL as DB and enabling delegation (preview) as On, it still gives delegation warning…
How we can handle this scenario?
Enbaling delegation (preview) feature is for Dataverse only. Not for SQL.
For SQL, you will need to follow similar steps like SharePoint.
Hi Reza,
My data source is SharePoint list and having choice column with check box input. As per your comments , created gallery in powerapps and fetched data in checkbox. Mapped the selected check box values to combo box. But what is the changes need to be taken in filter gallery while using check box column name
I'm not sure. 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
@@RezaDorrani i have posted my query... ID number - 1659425
@@suriya2109 I only go to forums to assist in my free time. There are many other experts on the forums who assist.
Hello Reza. Another very cool video. However, I always get an error message that the index cannot be greater than the number of rows in the combo box. Why does the error occur for me but not for you?
I am not sure why you are getting that error.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I am trying to use countif but getting a deligation warning. Is there a way to avoid it like you used in this video.
th-cam.com/video/qsIn0mytC_8/w-d-xo.html
Reza, when I put a SORT() the delegation problem came back. Is there any way of sorting ?
Check my video on sort and filter.
Getting delegation warning even with Index function described at 10:03 in video and the filter doesn't work. Any ideas why? This is the line of code along with other filters
&& (IsBlank(PlanSelection.SelectedItems) || IsEmpty (PlanSelection.SelectedItems) || Plan.Value = Index(PlanSelection.SelectedItems,1).Value). Blue line warning is with the && and 2nd || and the Plan.Value field
Formula looks fine.
You have && right at start. Is there other code. Just keep filter to the main formula and check if it works.
Difficult to know much here on chat without looking at your App in action.
If issue persists, I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, is there an alternate function for IN function when using SharePoint list as a data source?Thanks!
I am not aware of an alternative function. Whats the issue with using IN?
@@RezaDorrani hi Reza, thanks for replying! Its because IN is non delegable when using SharePoint as the data source.
@@marcocruz5351 This video shows you the workaround for it. IN is not delegable and there is no other replacement.
Hello Sir,
How can we display birthday & Aniversary Wishes Dynamically in Sharepoint home Through either Power App or Power Automate?
Possible but I do not have a video reference for it.
10:21 Hi Reza, I see you have considered static choices here, Is there anyway we can do this for dynamic choices (coming from a list/table) in multi-select combobox.
Dynamic choices is not possible without running into delegation challenge.
@@RezaDorrani Thanks a lot for your response. 🙂
@@RezaDorrani In my scenario I don't care about delegation. Super small list. Do you have a video on that?
@@user-me8xb1wi5g I don’t think I have a video on that. For me, I always care about delegation
Great video! How about for SharePoint datasource, it's still not delegable right?
I show exactly that in the video. It is delegable with SharePoint.
@@RezaDorrani @Reza Dorrani Hi, I am having the same issue. Both Index and Last(FirstN... are not delegable. I am using Powerapps within Teams referring to a SharePoint data source. Any suggestions would be much appreciated.
@@ajambo2010 Please check the video. I cover SharePoint scenario. Index last first none are delegable if you query your data source. Video shows how to make multi select filters delegable with SharePoint.
@@RezaDorrani Maybe Microsoft does not like me, because in I am definitely getting the warning symbol and the double blue lines show to show it is not delegable. My work around was to create 10 variables, using UpdateContext and Index, before the Filter expression. I then used "equals" and these variables, instead of "in" as you suggested, ", and it worked for filtering the large list (9000 rows). Thanks
@@ajambo2010 will have to see 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, I have projects choice column and projects can be increased not fixed like above choices are fixed. can we implement multiselect for projects.
You would run into delegation challenges in that case
@@RezaDorrani yes without delegation warning it's not possible right?
Hello Reza nice: I added a column on my Table AddColumns(CRMTicket;"Selezionato";false) this is my item on gallery; but i can't use a button inside the gallery for change the value of check box Selezione because it is not in collection but only on the gallery items . How i can insert a button in gallery for change the column added on the Gallery ? Thanks
I will have to look at your App in action to understand your scenario. would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I have 9 combo boxes 3 of which tie to choice columns. How can I do filters based on all 9?
You will need to repeat the filter logic for each combo box scenario and join them with AND or OR operations.
Example: th-cam.com/video/bujH2gzTduQ/w-d-xo.html & th-cam.com/video/5dSk5iOgT68/w-d-xo.html
Hi Reza, I have been working on a similar filter solution for the combo-boxes in my app. However I am using SQL. Is there a way to deal with delegation without migrating to dataverse?
I have not done any work with SQL hence not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks for replying, I'll keep digging.
Hi, Reza. What about using a Person/Group field type in multi select filter with combo box? I tried something like
Filter('Drawing', Or(IsBlank(FilterRequestedby.SelectedItems), IsEmpty(FilterRequestedby.SelectedItems),'Requested by'.DisplayName = Last(FirstN(FilterRequestedby.SelectedItems,1)).DisplayName, 'Requested by'.DisplayName = Last(FirstN(FilterRequestedby.SelectedItems,2)).DisplayName)), but unfortunately I got a delegation warning. My idea is to search by email and then show people's name based on the filter. Thanks in advance for all your amazing job!
Pattern looks fine. Might have to do something with person column that is causing the delegation warning. This is not something I have explored to see if there is a workaround. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Great videos - thanks v much Reza ! I am facing an using the sharepoint solution; basically if the user is selecting only one item from the combobox, my gallery is showing the selected item + the items that are "blank". I figured out this is because the index(combobox.SelectedItems,2).Result is returning blank if it isn't selected. Any way around that?
Its probably because your query is not well framed.
Check
th-cam.com/video/5dSk5iOgT68/w-d-xo.html
@@RezaDorrani Thanks I had already watched this video too (also great btw!) - I should have also mentioned that I am not using this solution with a choice column but a text column instead - and therefore limiting the # of choices the user can select. I was hoping it would work but it isn't unfortunately. The items from my gallery is quite simple as follow;
Filter(
SharePointList,
(IsBlank(Combobox.SelectedItems) || IsEmpty(Combobox.SelectedItems) || ComputerType = Index(Combobox.SelectedItems,1).Result || ComputerType = Index(Combobox.SelectedItems,2).Result || ComputerType = Index(Combobox.SelectedItems,3).Result)
)
As I said, all the records without any value in Column ComputerType are also showing in the gallery unless the user is selecting three items in the Combobox - that is because IsBlank(Index(Combobox.SelectedItems,2).Result) = true if there is one selection.
@@remisalome8187 Ohhh. This is something I would have to try out at my end to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I think I have found a work around that does the trick - now not sure if that's super best practice...but in case anyone encounter the same issue - here is how I did it.
OnChange property in my combobox; I set up three variables - because I give the user up to three selections;
UpdateContext({Var_1: If(IsBlank(Index(Combobox.SelectedItems,1).Result),"###",Index(Combobox.SelectedItems,1).Result)});
UpdateContext({Var_2: If(IsBlank(Index(Combobox.SelectedItems,2).Result),"###",Index(Combobox.SelectedItems,2).Result)});
UpdateContext({Var_3: If(IsBlank(Index(Combobox.SelectedItems,3).Result),"###",Index(Combobox.SelectedItems,3).Result)})
Then in the gallery, I uses those variables to filter it down as follow;
Filter(
SharepointList,
(IsBlank(Combobox.SelectedItems) || IsEmpty(Combobox.SelectedItems) || ComputerType = Var_1 || ComputerType = Var_2 || ComputerType = Var_3)
)
Please note I had tried to use a collection instead but I received delegation error with it...
@@remisalome8187 Thats a lot of work though. Better option would be to use dropdowns.
Hi, In my case I allow multiple selection On in SP list, so that filter function not working properly. because when submitting form it will take more than one value in the list. (due to allow multi -selection On).
please suggest me in this case. I used same logic.
I have not come across this issue (I also used columns of similar type) 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
@@RezaDorrani in above case … If we want to add multiple choices … then it will take only one value instead of all. This choice field with enabling multi choice in PowerApps but not enabling in SP list will not allow to take multi choice value. For that I used below logic
Filter(ListName,
Concat(comboBox.SelectedItems,Value&”,” ) in
Concat(choiceColumnName,Value&”,”)
)
@@chandradeepwaghare6359 Ok but Im not sure if this worked or not for you.
I don’t remember the exact specifics of the video or the formulas.
Hey, how to patch the selected items from the combo box into the SharePoint list?
th-cam.com/video/g9ChYuTdNd4/w-d-xo.html
Hi Reza, is this feasible when a request/item was rejected can comment section is required in approval phase. Thanks and more power
Not sure if your question is related to this video. The video is around filtering gallery data.
the enhanced delegation is not available anymore? I can`t find it, and 'in' is not delegable.
that feature is now GA.
In is not delegable with every data type. It depends. Check documentation.
Thanks Reza, I'm still having delegation warning even Enhanced Delegation.. enabled. Here's my code: Filter(datasource,Or(IsBlank(ComboBox1.SelectedItems),IsEmpty(ComboBox1.SelectedItems),Progress.Value in ComboBox1.SelectedItems.Value))
Should work based on steps in video. I am not sure what the reason could be.
Hi Reza, Somehow for the Combobox filters the results are only displayed when the selection is blank or maximum limit is selected i.e 5 in your example, in case I select 1,2,3,4 the gallary show blank.
I have not come across this issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks for reply during holidays, the issue seems to be with index formula and worked with first and LastN formula, if the value for particular index is not selected then the formula is showing error and filter is not getting apllied
@@Aditya-qt9vp Im not sure if you got it resolved or not?
If not then forums will be your best bet
@@RezaDorrani it got resolved by using First(LastN( combobox...) instead of Index()
hello, I'm having trouble retrieving data from a multi-select sharepoint list column. I write the same code as you wrote, but when I write the relevant column and put a period, the "value" expression does not appear and no data comes to the gallery.
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani OK, thank you for your return.
Reza - The approach you have taken doesn't work for multi select choice columns. Does it? I mean if your column type is single select choice, you can have combo box filters like that you applied. But if my column itself is multi select choice column Progress.Value gives you a table in return and you cannot equal it with Index() function. Am I right or missing anything here?
I did showcase multi-select choices columns in this video. Around 20:15 min in video.
You will run into delegation issues with it (is what I did call out in the video).
@@RezaDorrani Thanks Reza. Sorry, I missed that part.
@@ResponsibleXI No worries
Hi. I want to add 2 level filters in the same column. How can we do that?
I do not have a video on that and would need to try it out to let you know how. I would recommend checking on forums at powerusers.microsoft.com
when I write "Filter(Gallery2_1.AllItems,Checkbox2_1.Value" in the "DefaultSelectedItems in combobox the error appears, Gallery2_1.AllItems= there is an error in this formula, check it again and execute it again :( what would be the error if I did everything like in the video :c
Not sure as I have not come across this issue. Il recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Rezza I was facing one issue
How we can create a Lookup in Power apps like I have table in which I need lookup valves from multiple columns
its data is taken from excel like in excel
suppose from C3 :F18 means 4 columns
how we can achive this pls suggest
I have created that table in sharepoint
but looking for solution
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
I can´t seem to get the checkbox function to work with my combobox if the source is dataverse. It populates the combobox when I click on the checkboxes but It does not filter. If I manually click on the values in the combobox the filter works :/
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I have this exact same issue. Did you find a solution? Combobox filters work great as long as they're selected in the combobox. Using the checkboxes populates the combobox but the filtered gallery goes blank (returns no records) if using the checkboxes.
Hi Reza, Great stuff from you.
I am a PowerApps developer and currently I have one requirement that I am unable to complete.
Requirement:
There is .docx file with data (like employee information). Now I want to read that data from .docx and need to push the details to SharePoint list columns. Please help me on this.
@all, requesting you all to look at my requirement. Respond me with some references.
Thanks in advance!
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you very much for your kind response. 🙂
Delegation saw this and retired.
:)
imagine a record that is a multiselect field. There are N people selected. How can I filter the records that match a person that is one of the selected items of that multiselect field? My scenario is an Assigned To field that can have multiple people in. I would like to get the records that, say, PersonX is IN the selected items of that assigned to field. Thanks in advance, any help would be much appreciated and, again, just as I have said in other videos, your work is incredible. I have learned a lot
Not sure since I have not come across this scenario.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani I have an idea to implement this. If you could be so kind as to provide feedback on it, delegation issues etc, that'll be great. I'm thinking about:
1. loop through the data in that column and for each row,
2. split the field using a comma (I had to Concat the names with a comma to show up in the field, so I can "split back", to get the individual names)
3. Loop through this individual result set and compare the results with name of the person with the one I want
4. if they match, extract the ID of that row,
5. append it to a collection or a table
6. calculate the number of rows.
I don't know.. it seems like a lot of work. I was thinking maybe there was a simpler solution.
@@tiparati6834 Im not sure until I try it out. Your best bet would be to check on forums.
@@RezaDorrani Ok. Thanks
@@RezaDorrani Turns out it was much simpler indeed. Since filter works by checking every row in the DataTable and the in operator checks for matches in a list of values, I just added the condition "PersonX" in "MultiSelect Person Field". I get a delegation warning, but I'll see about changing the source to Dataverse, since IN in Dataverse supports delegation, just as you explained in the video
Hai Reza. Is this formula can use at the share point too or not ?
In video I show what’s possible with SharePoint