Filter Dataverse Choice column in Power Apps Gallery
In this video, you will learn how to filter Power Apps Dataverse Table based on a Choice column. How to create Choices with good naming practices, how to use them to Filter data in a Gallery, how to list out the choices in a gallery and more.
✨ More gallery filtering options: • PowerApps Multiple Fil...
#PowerApps #MicrosoftDataverse #Dataverse
Table of Contents:
00:00 - Introduction
00:43 - Create Choice column in Microsoft Dataverse Table
03:02 - Filter Power Apps Gallery from Dataverse Choice Column
06:45 - Load Choices into dropdown and use as gallery filter
10:47 - Filter Dataverse Table based on multiple Choice columns
12:12 - Load Choices into combo box and use as gallery filter
14:43 - Add conditional formatting based on Choice Column value
15:56 - Load choices as a gallery & filter Dataverse table
21:33 - Subscribe to Reza Dorrani channel
Пікірлер: 172
Great video Reza and well explained those Dataverse choice fields have had me scratching my head recently.
@RezaDorrani
3 жыл бұрын
Glad this was useful.
Beautiful presentation, as always. Structured and well explained, thanks Reza.
@RezaDorrani
3 жыл бұрын
My pleasure!
One of the best dataverse/powerapp tutorials I have ever seen! Super informative and easy to follow - I am bookmarking it for future reference 🤓 First video of yours I have watched and I subscribed straight away - keep up the good work! Thank you for making such useful content 😊
@RezaDorrani
2 жыл бұрын
Thank You for watching and thanks for the sub.
Your videos are amazing. I couldn't find this information elsewhere and the way you explained everything is highly crisp and clear. Thank you! (I was struggling with this filter and was not able to figure out what wrong I was doing. After 1.5 hrs of search I landed here.)
@RezaDorrani
Жыл бұрын
Glad to hear that! Thanks for watching.
Another amazing tutorial! I was beating myself up on how to do exactly what this video is teaching. How to filter dataverse choice columns in PowerApps. Thank you Reza! You are truly amazing!
@RezaDorrani
Жыл бұрын
You're most welcome!
Thanks Reza! Great video as always 👍. I am waiting to learn more new things from your videos. Thanks again for all your efforts!
@RezaDorrani
3 жыл бұрын
Your most welcome. I will keep trying my best to share my learnings.
Dude, what a fantastic video! For me, a beginner, his explanation on how to solve these errors helped me to make comparisons in the formulas that evaluate conditions. Thank you very much! (Forgive English, I'm using Google translator ... lol)
@RezaDorrani
3 жыл бұрын
Thank you and your translation is perfect 👌
Excellent video, exactly what I was looking for. Much appreciated.
@RezaDorrani
2 жыл бұрын
You're most welcome!
Great idea to use a gallery to make a visual choise for the user, instead of a dropdown control :)
@RezaDorrani
3 жыл бұрын
Thank you
Brilliant Video, @Reza! Thanks again!
@RezaDorrani
3 жыл бұрын
Glad you enjoyed it!
Another awesome video Reza!! Keep it up, you are my PowerApps teacher :)
@RezaDorrani
2 жыл бұрын
Wow, thanks!
Thumbs up before I even watched it... 2x Thumbs up after 👍👍. Thanks for sharing.
@RezaDorrani
3 жыл бұрын
🤩 Thank You
Thanks Alot Rezza You're Doing A great Job
@RezaDorrani
Жыл бұрын
Thank You
Great video as always , very helpful, thank you
@RezaDorrani
3 жыл бұрын
You are most welcome Sundra
Great Job as I am waiting.Thank you so much Reza
@RezaDorrani
3 жыл бұрын
You're most welcome
Wonderful video!I would love to see a video on using a search box for choice columns.
@RezaDorrani
Жыл бұрын
Thanks for watching the video. I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZread channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
Thank you, Reza!
@RezaDorrani
Жыл бұрын
Most welcome
awsome video Reza. THnaks
@RezaDorrani
2 жыл бұрын
Most welcome!
Hi Reza, Extremely useful content !!!
@RezaDorrani
Жыл бұрын
Thanks
Thank you so much reza.
@RezaDorrani
Жыл бұрын
Most welcome
Great video,, very helpful, thank you🙏
@RezaDorrani
3 жыл бұрын
You are most welcome
Great method. So elegant
@RezaDorrani
2 жыл бұрын
Thank you! Cheers!
I love watching your videos! Where do you learn this stuff and come up with your ideas?
@RezaDorrani
2 жыл бұрын
Thank You. I am always on the lookout for ideas and/or common questions related to M365. Once I have an idea locked down, I begin learning more about that topic.
Amazing this video helped so much
@RezaDorrani
Жыл бұрын
Glad it helped!
Amazing Reza, thx ;)
@RezaDorrani
3 ай бұрын
Any time!
Great video, Reza. One thing: although it's not really intuitive, you CAN choose the blank value in a drop-down control by selecting the selected value again (which would clear the selection).
@RezaDorrani
3 жыл бұрын
Ahhhh. Did not know that. Thanks for sharing this tip. As you said, not intuitive :)
Many thanks for another excellent video, Reza. I am currently struggeling with adding a dataverse column of the type 'choices' to my table. When I try to enter data (i.e. select options) the column is write protected which prevents me from using it. Do you have any idea how to solve this issue?
@RezaDorrani
2 жыл бұрын
Thanks for watching. Looks like you have column level security in place. You account may not have edit rights to that specific column.
Great videos , very useful and informative. by the way Which video should i see to know how to show the items in Gallery as cards like u have shown instead of vertical list, pls guide.
@RezaDorrani
3 жыл бұрын
Here is a video on gallery designs kzread.info/dash/bejne/lKJ3mtdsl8e9o9Y.html
@manasdas11155
3 жыл бұрын
@@RezaDorrani thanks a lot
Hey Reza, Must say well explained the concepts and better than any other video I have come across so far. Just wondering what would be the best way to display my ZipCode in one of the PowerApps from Dataverse (Use Case - I have a Dataverse table stored 48k+ Zipcode where company sell product so i need to provide a look up on PowerApps where user can search all of my zipcode and choose the appropriate zipcode for the current request) - Can I do that?
@RezaDorrani
3 жыл бұрын
You can create a gallery (connected to ZipCode table) and then provide filter for gallery where user can search and then accordingly select a zipcode.
Great video, as always. But, one doubt: what if we have a YES/NO column in Dataverse? How to filter based on its value? In Sharepoint this was straight direct, but in Dataverse I can not figure how.
@RezaDorrani
3 жыл бұрын
Filter(tablename, colname= 'colname (tablename)'.Yes) You should get enum 'colname (tablename)' in App.
Thanks a lot for this Reza, it is indeed the videos you are posting is very helpful. I was wondering if there’s an option if I can have sort and multiple filter choices in a gallery via dataverse data source. I’ve been trying to write the expression and I keep on failing. For example i wanted my gallery to be sorted by ID, then dropdown filter by Area and another dropdown by Status. Your feedback is greatly appreciated. Thanks!
@RezaDorrani
Жыл бұрын
Possible. I have done multiple videos on filtering and sorting. Please check those. It should be in my Power Apps playlist.
@LequinFamBam
Жыл бұрын
Thank you, Reza. :)
Thanks for the video. How can we sort a gallery by a choices column? Simply just by Choice column ascending order or something? This seems more difficult to do.
@RezaDorrani
Жыл бұрын
kzread.info/dash/bejne/aH-gq5OiisKxdJM.html
Hi Reza, Great video. I have question, I created a choice column and added the combo box. However, when using filter with IN operator I get the delegation warning.
@RezaDorrani
Жыл бұрын
I believe you would need to enable power app feature for enhanced delegation in Dataverse
Hi Reza, awesome videos. Thanks for all, have not found another channel yet who covers MS POWER platform better! Quick question, when I use the filter "in" option for multiple selections for dataverse choice column, i get an error "this might not work correctly in large data sets" but not explicitly a delegation warning? Any advice?
@RezaDorrani
2 жыл бұрын
Thanks so much. The message “this might not work for large data sets” means there is a delegation warning. In App settings, I believe there is an experimental or preview feature that allows IN to be delegable with Dataverse.
@sreeponn
2 жыл бұрын
@@RezaDorrani Wow, that was fast. Thanks for the response. I could not find this in the experimental features. If there is indeed a delegation limit for dataverse for teams, do you know the row count limit?
@RezaDorrani
2 жыл бұрын
@@sreeponn It is somewhere in features. Check preview. Delegation limit is 500 and can be increased to max 2000
@sreeponn
2 жыл бұрын
@@RezaDorrani Found it, thanks! It was already turned on, this means I do not have to worry about the warning hopefully! Thank you again.
Thank you so much for this video it is very very helpful! One question I have (and I am not sure if I am being an idiot!), when you created the Choice column you were able to add a name for the actual column eg 'Work Task Status' and also for the choices within that column eg 'Work Task Status Choices'. When I do this I only get the option to name the actual column, am I missing something? Because I only have the one name I am finding it difficult to use the same coding as you have
@RezaDorrani
3 жыл бұрын
When creating a choice column, you need to pick the choices list. There is an option there (As shown in video) to create a new choices list. That's where we can define the name. Ideally screenshots would help me understand the steps you are taking. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, great video thank you! QQ, how would you show ALL in the gallery except for one of the values. For example, show all statuses except for 'Deferred' but I still want to be able to use a dropdown to show Deferred as well , but i don't want to see it in the ALL , thank you
@RezaDorrani
2 жыл бұрын
For the All scenario, include status"deferred" in filter. Give it a try and in case of issues post the screenshot of the error on the forums at powerusers.microsoft.com/
Video's are great Reza, I've used quite a few of them. Only trouble is I can't seem to rename my group of choices without renaming the column. Not sure if this is something to do with the modern SharePoint. Any idea's
@RezaDorrani
Жыл бұрын
This video is on Dataverse and not sharepoint. Not sure if there is an option for this. I have not tried it. I will recommend posting your query with screenshots on forums at powerusers.microsoft.com/
Amazing video! Really appreciate you sharing your knowledge. I have one questions. How can I make the text for the "All button" white?
@RezaDorrani
4 ай бұрын
Thanks! Button has a color property. The formula to define color is there.
@MrBBStorage
4 ай бұрын
@@RezaDorrani Yes the text of all my buttons are showing correctly. Except for the All text. The text is black and I need to change it to white. How can I add it to the formula? There is no All in my choices column.
@RezaDorrani
4 ай бұрын
@@MrBBStorage All was not in mine either. Check video again for the steps.
@MrBBStorage
4 ай бұрын
@@RezaDorrani Yes, the All button text is created by the Collect formula. 20:34 in your Video.
@RezaDorrani
4 ай бұрын
@@MrBBStorage You should have the same experience.
Thanks, is it possible to apply this based on sharepoint? Thanks again.
@RezaDorrani
3 жыл бұрын
Yes, it will work with SharePoint as well. Give it a shot and see how it goes.
Hi, do you have a video on filter array for filtering share point choice columns in power automate ?
@RezaDorrani
3 жыл бұрын
Check kzread.info/dash/bejne/q5l10NeNcpublco.html
Nice work Reza. I am trying this demo but when am displaying choices value in gallery's label control for display like ThisItem' .Status.value it gives me an error. What is the right expression?
@RezaDorrani
3 жыл бұрын
Expression will depend on your column type and column name. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Дякую!
@RezaDorrani
Жыл бұрын
Ласкаво просимо
@MrMikerbehemoth
Жыл бұрын
🥰
Hi Reza, Happy New Year.. Can you please help to pick Choice field from Data verse Table ? In my case its show an error "Unsupported for evolution". I Want to pick the whole Table in a collection including Choice Field.
@RezaDorrani
Жыл бұрын
I will have to look at your app in action to know your scenario and the issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza. How to deal with filtering Options Set? Multiple filter for multiple data selected. I saw couple solutions (JSON(), etc) but they are too complicated.
@RezaDorrani
3 жыл бұрын
This is something I have not tried. My guess is the formula would be complicated. I will recommend you check on the forums and see if someone has a better approach at powerusers.microsoft.com/
Hey Reza, is it possible to use this value to filter out a dataverse choice column? Dropdown1.SelectedText.Value. I find that sometimes this alternative is not very effective for filtering choice columns, but I really want to filter a choice column with text values.
@RezaDorrani
Жыл бұрын
Dataverse Choice columns are special types and cannot be filtered by Text values. It needs the Enum association.
Nice video, I understand how to share table from teams if I create the app from ms teams. Please how do I share my table to someONE or people or everyone in my organisation From the powerapps environment not teams side?
@RezaDorrani
2 жыл бұрын
You add users to roles in environment and then based on the roles you define the access level on tables.
@utoroprincewill7808
2 жыл бұрын
@@RezaDorrani thanks, how do you define the access levels on the tables..?
@RezaDorrani
2 жыл бұрын
@@utoroprincewill7808 I do not have a specific video on that. Check the documentation for Dataverse.
HI Reza, is Choices (datasourcename,Column Name) Still work to pull the drop down as indicated in this video? or am I missing something?
@RezaDorrani
11 ай бұрын
Still works fine. I have not heard of any changes to this function.
is it possible to add a searchbox to this while keeping the select galler?
@RezaDorrani
2 жыл бұрын
Yes, check kzread.info/dash/bejne/rKyOqcORgc_AodI.html
Sir what if I have to check condition I mean I have to filter by a choice colum with a variable? In your care you have three option to equalize and check what if these three values are stored in a variable then how we can
@RezaDorrani
10 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hey Reza, I am having a problem trying to import data into dataverse from excel. The Choice column values are not showing up after the import but those columns with text data type do. I am wondering if it is possible or not. Can you share your ideas on this please?
@RezaDorrani
Жыл бұрын
Not sure as it's been a while since I tried that. I would recommend posting your issue with screenshots on forums at powerusers.microsoft.com/
Hi Reza when I'm working with choice column for SharePoint for filter I have given choice value in another gallery and when I'm trying to filter based on status the fx formula is showing error 'incompatible types for comparison.These types can't be compared: Record,Text' can you guide what is the issue. Will appreciate your help.. thanks in advance.
@RezaDorrani
8 ай бұрын
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
O do not understand why the attribute "AllowEmptySelection" is not available for me!? I checked also in the dropdown and in the combo box. Any idea?
@RezaDorrani
5 ай бұрын
Modern controls dont have it. Classic dropdown has it
IsBlank() and in operator are delegable with Dataverse so no point of delegations issues in the video?
@RezaDorrani
2 жыл бұрын
Sorry I did not understand the question. Video has delegation issue?
Great job , more useful information & Thank you so much ₹eza Pls share to me or suggestions to me for better business apps begin with Inrule engine , dynamics 365 (rule configuration) , Power Apps or Dataverse.
@RezaDorrani
2 жыл бұрын
Ideally business rules in Dataverse. Since you are applying it at the Table level. All apps connecting to it, will automatically have the rule applied.
@ramakrishnapaidi1479
2 жыл бұрын
@@RezaDorraniTqs ₹eza,can we do any validation using rule based configuration in powerapps or data verse.
@RezaDorrani
2 жыл бұрын
@@ramakrishnapaidi1479 Yes
@ramakrishnapaidi1479
2 жыл бұрын
@@RezaDorrani Tq u so much....₹eza
Hi Sir, with dataverse, how can pass dataverse to powerapps by flow in Power automate?
@RezaDorrani
3 жыл бұрын
Am assuming your flow is being called from Power Apps. Flow has an action return to power apps, so you can send the data back. Ideally, you would just connect to Dataverse from Power Apps.
is it doable when sharepoint list as data source?
@RezaDorrani
2 жыл бұрын
Possible. Check kzread.info/dash/bejne/aH-gq5OiisKxdJM.html & kzread.info/dash/bejne/Z5iHzZeif8q6Zps.html
is there a way to get person column in dataverse like sharepoint?
@RezaDorrani
2 жыл бұрын
I covered that in one of my videos - kzread.info/dash/bejne/qIaimcSrYrLHqKg.html
Hi Reza, How do I achieve the same filter for a sharepoint column?
@RezaDorrani
Жыл бұрын
I have done many videos on filters with SharePoint. I would have shown this in one of those.
@akshay._.solanki
Жыл бұрын
@@RezaDorrani Can you point me to the right one, I am just browsing through your playlists but it would be easier if you have any link handy :)
@RezaDorrani
Жыл бұрын
@@akshay._.solanki I do not remember myself :)
HI Reza, Can we concat multiselect choice column and display a label
@RezaDorrani
Жыл бұрын
Should be possible
@GordeNN
Жыл бұрын
@@RezaDorrani i tried and it's working
Hi Reza I want to filter the location based on the login user name with dataverse
@keepitsimplenaruto6912
Жыл бұрын
Without any dropdown just based on userlogin
@RezaDorrani
Жыл бұрын
User().email will give you logged in user name. Filter your data source based on this value.
@keepitsimplenaruto6912
Жыл бұрын
@@RezaDorrani I try many times but not giving full result i also tagged you in forum also with image
@RezaDorrani
Жыл бұрын
@@keepitsimplenaruto6912 Forums is a platform where you may or may not get a response. I only go to forums to assist in my free time. If this is time sensitive, then you may want to look at getting consulting help.
I am using Dataverse in teams and if I extract my data to power bi then choice IDs are showing only and not exact values, any solution pls?
@RezaDorrani
2 ай бұрын
I have not worked on this scenario so not sure
@anilkumar-ml2sl
2 ай бұрын
@@RezaDorrani Thank you
Hi Reza Is there a way to sort a Dataverse table on a choice column?
@RezaDorrani
2 жыл бұрын
powerappsguide.com/blog/post/sort-dataverse-choice-column
@boubahai
2 жыл бұрын
Hi @@RezaDorrani Thank you for your quick answer and great solution suggestion. In my case, I need to be able to sort a table with a choice column based on that choice column. Example: First(Sort(Gallery1.Selected.Table2,Year, Descending)) where Year is a choice column.
@RezaDorrani
2 жыл бұрын
@@boubahai I do not have a video reference for your scenario and would have to try it out to provide guidance. I would recommend checking or posting your query on the forums at powerusers.microsoft.com
@boubahai
2 жыл бұрын
Thank you @@RezaDorrani . You are the best!
@boubahai
2 жыл бұрын
Hi @@RezaDorrani I finally was able to solve this issue by adding a column that has a the text value of the choice column. First(Sort(AddColumns(Gallery1.Selected.Table2, "TempYearColumn", Text(Year)), TempYearColumn)).ColunmToDisplay
How come sometimes the column name of a dataverse table is either the perceived column name, schema name, or api name?
@RezaDorrani
Жыл бұрын
Depends on the settings of the App. Its in experimental or preview features, do not exactly remember.
How to insert data of choice column into dataverse using patch function
@RezaDorrani
2 жыл бұрын
I do not have a video reference for this. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@NarenderKumar-zq6hp
2 жыл бұрын
@@RezaDorrani I tried, but not solved my problem
@RezaDorrani
2 жыл бұрын
@@NarenderKumar-zq6hp Forums is a free platform. You may or may not get a response immediately. You should look at getting consulting help if it’s urgent.
How to filter using auto number please suggest
@RezaDorrani
5 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@BhumikaChhabra-wh8ir
5 ай бұрын
@@RezaDorrani thanks for reply Reza I didn’t find any solution I want to add filter from value 1000 to 2000 but auto number is text field and if I changed it to number I am getting delegation warming
@RezaDorrani
5 ай бұрын
@@BhumikaChhabra-wh8ir I recommend posting your query on forums at powerusers.microsoft.com
Unfortunately, it seems that power apps disabled this feature. Now I have to filter with lookup columns instead of choice
@RezaDorrani
9 ай бұрын
Not true at all. This feature is very much active.
@wildchangjr.8998
9 ай бұрын
I always get an error saying option set value does not equal record. Any way to get around this?
@RezaDorrani
9 ай бұрын
@@wildchangjr.8998 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
Your videos are really helpfull for a novice like me. Thanks! I may discovered a small bug in your Filter-code at kzread.info/dash/bejne/dals0qaoZrrWgqw.html (or it is maybe related to some code change at MS?) For correctly using a filter with dropdown (and default Blank()) I needed to change the "IsBlank(drpStatus)" to "IsBlank(drpStatus.Selected)". Value of "IsBlank(drpStatus)" was always false for me, wheter I selected a value from dropdown or it was at default-value "Blank()".
@RezaDorrani
6 ай бұрын
Thanks! Depends on how the dropdown is configured. Both could be right.
Hey Reza, great video. Thank you. Is it possible to filter based on a lookup column? My filter does not work: Filter(Masterliste; LookupProjektinfoTabelle.Projektart = drpProjektart.Selected.Value)
@RezaDorrani
2 жыл бұрын
Possible, the technique is different though. Your formula looks more on lines of SP column lookup. Here there are enums for lookup column types that you can leverage. I will have to look at your App in action to provide guidance & do not have a video reference for it. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com