Great video Reza and well explained those Dataverse choice fields have had me scratching my head recently.
@RezaDorrani
3 жыл бұрын
Glad this was useful.
@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!
@stavrosvogiatzis4016
3 жыл бұрын
Beautiful presentation, as always. Structured and well explained, thanks Reza.
@RezaDorrani
3 жыл бұрын
My pleasure!
@avi-e-atrix
2 жыл бұрын
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.
@cristovaodarosa2050
3 жыл бұрын
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 👌
@franknielsen3219
3 жыл бұрын
Great idea to use a gallery to make a visual choise for the user, instead of a dropdown control :)
@RezaDorrani
3 жыл бұрын
Thank you
@farooqpathan4755
Жыл бұрын
Thanks Alot Rezza You're Doing A great Job
@RezaDorrani
Жыл бұрын
Thank You
@vikasgoel3149
Жыл бұрын
Hi Reza, Extremely useful content !!!
@RezaDorrani
Жыл бұрын
Thanks
@spen2431
3 жыл бұрын
Thumbs up before I even watched it... 2x Thumbs up after 👍👍. Thanks for sharing.
@RezaDorrani
3 жыл бұрын
🤩 Thank You
@AdiCristea
3 жыл бұрын
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 :)
@ErnestoCode
2 жыл бұрын
Wonderful video!I would love to see a video on using a search box for choice columns.
@RezaDorrani
2 жыл бұрын
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 KZitem 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.
@piqueddaithe
Жыл бұрын
Thank you, Reza!
@RezaDorrani
Жыл бұрын
Most welcome
@davidrico8755
2 жыл бұрын
awsome video Reza. THnaks
@RezaDorrani
2 жыл бұрын
Most welcome!
@haroon420
Жыл бұрын
Thank you so much reza.
@RezaDorrani
Жыл бұрын
Most welcome
@sujisam5508
3 жыл бұрын
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.
@AliJafry
2 жыл бұрын
Excellent video, exactly what I was looking for. Much appreciated.
@RezaDorrani
2 жыл бұрын
You're most welcome!
@jacobjenkins2190
Жыл бұрын
Amazing this video helped so much
@RezaDorrani
Жыл бұрын
Glad it helped!
@btoz6237
3 жыл бұрын
Another awesome video Reza!! Keep it up, you are my PowerApps teacher :)
@RezaDorrani
3 жыл бұрын
Wow, thanks!
@Cybermatik
4 ай бұрын
Amazing Reza, thx ;)
@RezaDorrani
4 ай бұрын
Any time!
@TonyDjohan
3 жыл бұрын
Great method. So elegant
@RezaDorrani
3 жыл бұрын
Thank you! Cheers!
@ramprah8910
3 жыл бұрын
Brilliant Video, @Reza! Thanks again!
@RezaDorrani
3 жыл бұрын
Glad you enjoyed it!
@rohanshaw1827
2 жыл бұрын
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.
@sundrapillay6668
3 жыл бұрын
Great video as always , very helpful, thank you
@RezaDorrani
3 жыл бұрын
You are most welcome Sundra
@jmrussi1968
3 жыл бұрын
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.
@necdetsaritas8722
3 жыл бұрын
Great Job as I am waiting.Thank you so much Reza
@RezaDorrani
3 жыл бұрын
You're most welcome
@carlsagan4802
2 жыл бұрын
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
2 жыл бұрын
kzitem.info/news/bejne/l4Gir2Wfk5F8d2U
@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. :)
@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/
@manasdas11155
3 жыл бұрын
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 kzitem.info/news/bejne/w6R5nqlpoJaIpqg
@manasdas11155
3 жыл бұрын
@@RezaDorrani thanks a lot
@prajwalskateel
3 жыл бұрын
Great video,, very helpful, thank you🙏
@RezaDorrani
3 жыл бұрын
You are most welcome
@sreeponn
2 жыл бұрын
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.
@MrBBStorage
6 ай бұрын
Amazing video! Really appreciate you sharing your knowledge. I have one questions. How can I make the text for the "All button" white?
@RezaDorrani
6 ай бұрын
Thanks! Button has a color property. The formula to define color is there.
@MrBBStorage
6 ай бұрын
@@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
6 ай бұрын
@@MrBBStorage All was not in mine either. Check video again for the steps.
@MrBBStorage
6 ай бұрын
@@RezaDorrani Yes, the All button text is created by the Collect formula. 20:34 in your Video.
@RezaDorrani
6 ай бұрын
@@MrBBStorage You should have the same experience.
@lalitmohan5054
3 жыл бұрын
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.
@schwop
3 жыл бұрын
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
3 жыл бұрын
Thanks for watching. Looks like you have column level security in place. You account may not have edit rights to that specific column.
@MrMikerbehemoth
Жыл бұрын
Дякую!
@RezaDorrani
Жыл бұрын
Ласкаво просимо
@MrMikerbehemoth
Жыл бұрын
🥰
@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
@mauriciom.7496
3 жыл бұрын
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.
@utoroprincewill7808
2 жыл бұрын
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.
@andypiker
3 жыл бұрын
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/
@adityaprakash9151
11 ай бұрын
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
11 ай бұрын
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
@davidrico8755
2 жыл бұрын
is it possible to add a searchbox to this while keeping the select galler?
@RezaDorrani
2 жыл бұрын
Yes, check kzitem.info/news/bejne/266QrZWOip6LpKQ
@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
@danielioan6338
6 ай бұрын
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
6 ай бұрын
Modern controls dont have it. Classic dropdown has it
@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.
@indujaha642
2 жыл бұрын
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/
@nawazpathan6099
9 ай бұрын
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
9 ай бұрын
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
@SK-mx7jx
3 жыл бұрын
Hi, do you have a video on filter array for filtering share point choice columns in power automate ?
@RezaDorrani
3 жыл бұрын
Check kzitem.info/news/bejne/2pt31KmKe2pmmJw
@grantbrannen4812
3 жыл бұрын
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
@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/
@surajnautiyal8810
3 жыл бұрын
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
@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.
@ResponsibleXI
2 жыл бұрын
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?
is there a way to get person column in dataverse like sharepoint?
@RezaDorrani
2 жыл бұрын
I covered that in one of my videos - kzitem.info/news/bejne/14iknZaoa4GSq3o
@ramakrishnapaidi1479
3 жыл бұрын
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
3 жыл бұрын
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
3 жыл бұрын
@@RezaDorraniTqs ₹eza,can we do any validation using rule based configuration in powerapps or data verse.
@RezaDorrani
3 жыл бұрын
@@ramakrishnapaidi1479 Yes
@ramakrishnapaidi1479
3 жыл бұрын
@@RezaDorrani Tq u so much....₹eza
@tuyenchi4459
3 жыл бұрын
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.
@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
@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 :)
@carlsagan4802
2 жыл бұрын
How come sometimes the column name of a dataverse table is either the perceived column name, schema name, or api name?
@RezaDorrani
2 жыл бұрын
Depends on the settings of the App. Its in experimental or preview features, do not exactly remember.
@anilkumar-ml2sl
3 ай бұрын
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
3 ай бұрын
I have not worked on this scenario so not sure
@anilkumar-ml2sl
3 ай бұрын
@@RezaDorrani Thank you
@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.
@boubahai
2 жыл бұрын
Hi Reza Is there a way to sort a Dataverse table on a choice column?
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
@BhumikaChhabra-wh8ir
7 ай бұрын
How to filter using auto number please suggest
@RezaDorrani
7 ай бұрын
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
7 ай бұрын
@@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
7 ай бұрын
@@BhumikaChhabra-wh8ir I recommend posting your query on forums at powerusers.microsoft.com
@wildchangjr.8998
10 ай бұрын
Unfortunately, it seems that power apps disabled this feature. Now I have to filter with lookup columns instead of choice
@RezaDorrani
10 ай бұрын
Not true at all. This feature is very much active.
@wildchangjr.8998
10 ай бұрын
I always get an error saying option set value does not equal record. Any way to get around this?
@RezaDorrani
10 ай бұрын
@@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
2 жыл бұрын
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.
@user-wm1bg5xi3q
7 ай бұрын
Your videos are really helpfull for a novice like me. Thanks! I may discovered a small bug in your Filter-code at kzitem.info/news/bejne/pKtu1nilb4mhhX4 (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
7 ай бұрын
Thanks! Depends on how the dropdown is configured. Both could be right.
@Zim54
2 жыл бұрын
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
Пікірлер: 172