Filter Dataverse Choice column in Power Apps Gallery

[@notonurnelly]

Great video Reza and well explained those Dataverse choice fields have had me scratching my head recently.

[@RezaDorrani]

Glad this was useful.

[@stavrosvogiatzis4016]

Beautiful presentation, as always. Structured and well explained, thanks Reza.

[@RezaDorrani]

My pleasure!

[@avi-e-atrix]

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]

Thank You for watching and thanks for the sub.

[@swapnilaswale]

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.

[@michaelmurillosr657]

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!

[@cristovaodarosa2050]

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]

Thank you and your translation is perfect 👌

[@franknielsen3219]

Great idea to use a gallery to make a visual choise for the user, instead of a dropdown control :)

[@RezaDorrani]

Thank you

[@sujisam5508]

Thanks Reza! Great video as always 👍. I am waiting to learn more new things from your videos. Thanks again for all your efforts!

[@RezaDorrani]

Your most welcome. I will keep trying my best to share my learnings.

[@AliJafry]

Excellent video, exactly what I was looking for. Much appreciated.

[@RezaDorrani]

You're most welcome!

[@btoz6237]

Another awesome video Reza!! Keep it up, you are my PowerApps teacher :)

[@RezaDorrani]

Wow, thanks!

[@spen2431]

Thumbs up before I even watched it... 2x Thumbs up after 👍👍. Thanks for sharing.

[@RezaDorrani]

🤩 Thank You

[@ramprah8910]

Brilliant Video, @Reza! Thanks again!

[@RezaDorrani]

Glad you enjoyed it!

[@ErnestoCode]

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 KZbin 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.

[@vikasgoel3149]

Hi Reza, Extremely useful content !!!

[@RezaDorrani]

Thanks

[@farooqpathan4755]

Thanks Alot Rezza You're Doing A great Job

[@RezaDorrani]

Thank You

[@sundrapillay6668]

Great video as always , very helpful, thank you

[@RezaDorrani]

You are most welcome Sundra

[@necdetsaritas8722]

Great Job as I am waiting.Thank you so much Reza

[@RezaDorrani]

You're most welcome

[@haroon420]

Thank you so much reza.

[@RezaDorrani]

Most welcome

[@DigitalReviewsMx]

awsome video Reza. THnaks

[@RezaDorrani]

Most welcome!

[@piqueddaithe]

Thank you, Reza!

[@RezaDorrani]

Most welcome

[@AdiCristea]

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]

Ahhhh. Did not know that. Thanks for sharing this tip. As you said, not intuitive :)

[@Cybermatik]

Amazing Reza, thx ;)

[@RezaDorrani]

Any time!

[@TonyDjohan]

Great method. So elegant

[@RezaDorrani]

Thank you! Cheers!

[@prajwalskateel]

Great video,, very helpful, thank you🙏

[@RezaDorrani]

You are most welcome

[@jacobjenkins2190]

Amazing this video helped so much

[@RezaDorrani]

Glad it helped!

[@rohanshaw1827]

I love watching your videos! Where do you learn this stuff and come up with your ideas?

[@RezaDorrani]

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.

[@Haggis102]

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/

[@carlsagan4802]

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]

kzbin.info/www/bejne/bHzPemSfj8R-epI

[@sreeponn]

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]

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]

@@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]

@@sreeponn It is somewhere in features. Check preview. Delegation limit is 500 and can be increased to max 2000

[@sreeponn]

@@RezaDorrani Found it, thanks! It was already turned on, this means I do not have to worry about the warning hopefully! Thank you again.

[@LequinFamBam]

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. :)

[@muhammadqasim9397]

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

[@jmrussi1968]

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]

Filter(tablename, colname= 'colname (tablename)'.Yes) You should get enum 'colname (tablename)' in App.

[@schwop]

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]

Thanks for watching. Looks like you have column level security in place. You account may not have edit rights to that specific column.

[@manasdas11155]

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]

Here is a video on gallery designs kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@manasdas11155]

@@RezaDorrani thanks a lot

[@lalitmohan5054]

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]

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.

[@MrBBStorage]

Amazing video! Really appreciate you sharing your knowledge. I have one questions. How can I make the text for the "All button" white?

[@RezaDorrani]

Thanks! Button has a color property. The formula to define color is there.

[@MrBBStorage]

​@@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]

@@MrBBStorage All was not in mine either. Check video again for the steps.

[@MrBBStorage]

@@RezaDorrani Yes, the All button text is created by the Collect formula. 20:34 in your Video.

[@RezaDorrani]

@@MrBBStorage You should have the same experience.

[@satyamdas1854]

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

[@mashohbd5838]

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]

Still works fine. I have not heard of any changes to this function.

[@barnaliroy8703]

05:25 I tried to do this same way but it's not working for me. Not even automatically suggesting Choices when I am typing my column name. Edit: This formula worked for me - ' '.

[@RezaDorrani]

I have not experienced the mentioned issue, hence not sure. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/

[@pikachickfarm]

Hi, I'm having the same issue. Can you show me how you resolved it?

[@barnaliroy8703]

@pikachickfarm try the formula I wrote in Edit section. It should work.

[@FikreyesusGarredew]

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/

[@SK-mx7jx]

Hi, do you have a video on filter array for filtering share point choice columns in power automate ?

[@RezaDorrani]

Check kzbin.info/www/bejne/r5akn6iKd51om8k

[@wildchangjr.8998]

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.

[@mauriciom.7496]

Thanks, is it possible to apply this based on sharepoint? Thanks again.

[@RezaDorrani]

Yes, it will work with SharePoint as well. Give it a shot and see how it goes.

[@indujaha642]

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]

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/

[@andypiker]

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]

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/

[@danielioan6338]

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]

Modern controls dont have it. Classic dropdown has it

[@nawazpathan6099]

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]

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

[@grantbrannen4812]

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]

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

[@DigitalReviewsMx]

is it possible to add a searchbox to this while keeping the select galler?

[@RezaDorrani]

Yes, check kzbin.info/www/bejne/sKm9eJSOhtGNp9E

[@surajnautiyal8810]

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]

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

[@akshay._.solanki]

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 :)

[@adityaprakash9151]

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]

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

[@kyivbrevet]

Дякую!

[@RezaDorrani]

Ласкаво просимо

[@kyivbrevet]

🥰

[@utoroprincewill7808]

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]

You add users to roles in environment and then based on the roles you define the access level on tables.

[@utoroprincewill7808]

@@RezaDorrani thanks, how do you define the access levels on the tables..?

[@RezaDorrani]

@@utoroprincewill7808 I do not have a specific video on that. Check the documentation for Dataverse.

[@GordeNN]

HI Reza, Can we concat multiselect choice column and display a label

[@RezaDorrani]

Should be possible

[@GordeNN]

@@RezaDorrani i tried and it's working

[@keepitsimplenaruto6912]

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.

[@ResponsibleXI]

IsBlank() and in operator are delegable with Dataverse so no point of delegations issues in the video?

[@RezaDorrani]

Sorry I did not understand the question. Video has delegation issue?

[@praninggising16]

is it doable when sharepoint list as data source?

[@RezaDorrani]

Possible. Check kzbin.info/www/bejne/bHzPemSfj8R-epI & kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@anilkumar-ml2sl]

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]

I have not worked on this scenario so not sure

[@anilkumar-ml2sl]

@@RezaDorrani Thank you

[@tuyenchi4459]

Hi Sir, with dataverse, how can pass dataverse to powerapps by flow in Power automate?

[@RezaDorrani]

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.

[@Saadssk94]

is there a way to get person column in dataverse like sharepoint?

[@RezaDorrani]

I covered that in one of my videos - kzbin.info/www/bejne/rIPRaJWoZ7SUrqc

[@boubahai]

Hi Reza Is there a way to sort a Dataverse table on a choice column?

[@RezaDorrani]

powerappsguide.com/blog/post/sort-dataverse-choice-column

[@boubahai]

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]

@@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]

Thank you @@RezaDorrani . You are the best!

[@boubahai]

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

[@AryahiNagpal]

How to filter using auto number please suggest

[@RezaDorrani]

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

[@AryahiNagpal]

@@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]

​@@AryahiNagpal I recommend posting your query on forums at powerusers.microsoft.com

[@carlsagan4802]

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.

[@Zim54]

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]

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

[@wildchangjr.8998]

Unfortunately, it seems that power apps disabled this feature. Now I have to filter with lookup columns instead of choice

[@RezaDorrani]

Not true at all. This feature is very much active.

[@wildchangjr.8998]

I always get an error saying option set value does not equal record. Any way to get around this?

[@RezaDorrani]

@@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

[@NarenderKumar-zq6hp]

How to insert data of choice column into dataverse using patch function

[@RezaDorrani]

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]

@@RezaDorrani I tried, but not solved my problem

[@RezaDorrani]

@@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.

[@ramakrishnapaidi1479]

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]

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]

@@RezaDorraniTqs ₹eza,can we do any validation using rule based configuration in powerapps or data verse.

[@RezaDorrani]

@@ramakrishnapaidi1479 Yes

[@ramakrishnapaidi1479]

@@RezaDorrani Tq u so much....₹eza

[@Christian-w9h]

Your videos are really helpfull for a novice like me. Thanks! I may discovered a small bug in your Filter-code at kzbin.info/www/bejne/eaaboXela7yjiKs (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]

Thanks! Depends on how the dropdown is configured. Both could be right.