This is very helpful Reza. I'll be using these techniques + the other Flow technique to export to excel using Graph API in seconds in my use case for device collection at 18 secondary schools where previously users created 18 workbooks each having at least 5 worksheets or more, in the end someone had to reconcile 100+ worksheets. All of that is now gone with canvas apps and all the tips & tricks you share. Thank you.
Designing a modern filter UI looks really awesome, like a professional design. Watching your video helps me learn new things. Could you please make a video on Gantt charts for project purposes?
Great to hear! I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza Thank you for a great video, I see when I build the same, I get a delegation warning on the (in) function of the filter for the gallery, but in your video you do not. Is there something you did so you don't get the warning?
Hi Reza! I recall watching one your videos where you deconstructed the Attachments control in a way the Attach button, and the files attached still worked outside of the Attachment control itself. The video was about something else, but your clever solution was required to achieve the desired end-state in that video. Would you happen to know which video it was? It will really help! Thanks in advance!
@@RezaDorrani , thank you, I was battling and now, got the answer, I will check your videos on doc libraries, appreciate it. This video is awesome as your other contents, thank you
Hi Reza, Nice video, it is really usefull. Thanks. I try to reproduce this example and when I am aplying the filter 'And 'with the project collection, it does not show any item, If any check is checked the collectin is empty so the gallery does not show item. Can you help with that!. BS
Video description has details of link to download entire solution (members only - check description for details) I would suggest giving that a try as I have not experienced the mentioned issue and not sure how I can help.
Hi Reza, love all your videos. I am having the same issue where the Main Gallery Filter does not return anything unless one of the checkboxes is checked. If you select items from the checkbox it will filter for those, but when you uncheck them all the main Gallery is empty. That seems to make sense because there in nothing in the projects collection, but it obviously works in your example so not sure what I am missing. Any suggestions on how to fix that?
@RichD159 I probably added some extra logic in the code which honestly I do not recollect. I have not had anyone who downloaded the app report any issues, so my guess is there must be something extra I may have done.
Hi Reza, the filter container takes up quite a bit of screen space. Would it be easy to implement a filter button, which would show/omit that container?
@RezaDorrani is there video with adding more sort columns to your code? I would need to add another dropddown in my case drpSortIDasset but I want keep sorting by data. And sorting by IDasset I could switch on or off. Sort ofcourse ascending descending
Hi..i have a form data card which is multi select dropdown.How to create seperate rows for each dropdwon value in my dataverse table after submitting the form
I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video however I think the sort function could be handled better. I would create a variable thats set on the sort dropdown update. Then use that variable in your gallery items. This way you can later add in more ways to sort just by modifying the sort dropdown update, which will then avoid you having to repeat code on your gallery. Awesome video as always.
I totally agree! MS modern controls are still far away of being Fluent 2.0 aware and even not stable in much cases. The example Reza showing here is using basic properties and functions of them and that works. But if you dig deeper into it, it is still a long way to go for them to make them "modern". Doesn't has to do with the very nice example from Reza of Refinement. Hopefully MS will continue work in the controls to make them really THEIR Fluent 2.0.
Agreed. Filters on Grid reflow property inside a modern table control is very unreliable when the data source/collection has over 30 items. List reflow works with multiple filters and large data sets.
Nice video Reza, I would love to understand if you don't use gallery with check box, instead use modern combobox, how do you uncheck the checked item, how do we select blank value in modern combobox or If we put collect formula on on-change or on select value in collection I can do it, but with without collection how do I reset and allow empty selection
Thank you Reza! Amazing video as always. Any reason you used filter and in operator for search rather than using the search function directly? Any shortcomings of using search directly in dataverse?
Thanks! No specific reason. Only certain types of columns supporting searching as a delegable query. The delegation documentation has all the details listed.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@@RezaDorrani more likely would use ‘starts with’ coz other data sources not poss, unfortunately. ‘Starts with’ obviously limited though, so would have to use on a couple of fields to avoid non delegable joining operators
Wow, that video was fantastic, and the training was stellar as always! Thank you so much for sharing it with us.
Glad you enjoyed it!
Awesome work! I was able to recreate this in my own app. I'm always blown away by your content and I can't wait to see what else you come up with.
Awesome! Thank you!
This is very helpful Reza. I'll be using these techniques + the other Flow technique to export to excel using Graph API in seconds in my use case for device collection at 18 secondary schools where previously users created 18 workbooks each having at least 5 worksheets or more, in the end someone had to reconcile 100+ worksheets. All of that is now gone with canvas apps and all the tips & tricks you share. Thank you.
Great to hear how you plan to use multiple videos to solve a scenario. Thanks for sharing.
I see your video, I clicked. Really informative!
Awesome, thank you!
Thank you Reza, great video showing in-depth filter application any app should have
Great to hear
Thanks Reza for wonderful tips
Any time!
thank you Reza, great video
Glad you enjoyed it
Loved the Video Reza. An awesome mix of UI and functionality
Thanks Tolu
A few more nuggets in there.... thanks as always 💥💥👍👍
Always!
Designing a modern filter UI looks really awesome, like a professional design. Watching your video helps me learn new things. Could you please make a video on Gantt charts for project purposes?
Great to hear!
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
thanks Reza for another great video.
My pleasure!
Thanks sir from India.
Most welcome!
Thank you Reza
Most welcome!
Thanks Renza 🙏🙏🙏
Most welcome!
Its great, thanks for supporting to us for latest version of MS Power APps
It's my pleasure
Nice video and haircut both looking clean..
Thanks for both
Hi Reza
Thank you for a great video, I see when I build the same, I get a delegation warning on the (in) function of the filter for the gallery, but in your video you do not. Is there something you did so you don't get the warning?
I'm using Dataverse
You are probably using sharepoint
very useful tips thanks
Most welcome!
Hi Reza! I recall watching one your videos where you deconstructed the Attachments control in a way the Attach button, and the files attached still worked outside of the Attachment control itself. The video was about something else, but your clever solution was required to achieve the desired end-state in that video. Would you happen to know which video it was? It will really help! Thanks in advance!
I dont remember :)
Hi Reza, great video, one question, will this method work with Document library? If you like to search/checkboxes, will this still work? Thanks
Should work but doc libs have different challenges. Check my videos on doc libraries.
@@RezaDorrani , thank you, I was battling and now, got the answer, I will check your videos on doc libraries, appreciate it. This video is awesome as your other contents, thank you
Hi Reza, Nice video, it is really usefull. Thanks. I try to reproduce this example and when I am aplying the filter 'And 'with the project collection, it does not show any item, If any check is checked the collectin is empty so the gallery does not show item. Can you help with that!. BS
Video description has details of link to download entire solution (members only - check description for details)
I would suggest giving that a try as I have not experienced the mentioned issue and not sure how I can help.
I too am experiencing this with my SharePoint List data. I had to create a cumbersome IF stmt to make it work.
Hi Reza, love all your videos. I am having the same issue where the Main Gallery Filter does not return anything unless one of the checkboxes is checked. If you select items from the checkbox it will filter for those, but when you uncheck them all the main Gallery is empty. That seems to make sense because there in nothing in the projects collection, but it obviously works in your example so not sure what I am missing. Any suggestions on how to fix that?
@RichD159 I probably added some extra logic in the code which honestly I do not recollect. I have not had anyone who downloaded the app report any issues, so my guess is there must be something extra I may have done.
At 7:03 you inserted custom icons in the Text input control ! I dont see those icons, how did you get those nice icons ?
Those are emojis. Use windows+. to open emoji keyboard.
Hey, this is very helpful, but what if the data is large, the IN operator won't work, right?
It will work if your datasource is dataverse.
For SharePoint- I have done several videos showing different options
Hi Reza, the filter container takes up quite a bit of screen space. Would it be easy to implement a filter button, which would show/omit that container?
Yes, possible. I already have done a video on that as well. Responsive filters. Did not want to repeat the same thing.
@RezaDorrani is there video with adding more sort columns to your code? I would need to add another dropddown in my case drpSortIDasset but I want keep sorting by data. And sorting by IDasset I could switch on or off. Sort ofcourse ascending descending
This is probably the best reference I have.
May I know if it is suitable for large set of data? Will it cause performance issue?
The query is fully delegable and will work with large data sets
Hi..i have a form data card which is multi select dropdown.How to create seperate rows for each dropdwon value in my dataverse table after submitting the form
I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Oh the luxury of being able to the "in" function without delegation issues. I guess that's because it's Dataverse.
No prizes for guessing
I’m already fired up, and your intro hasn’t finished!
🔥
Great video however I think the sort function could be handled better. I would create a variable thats set on the sort dropdown update. Then use that variable in your gallery items.
This way you can later add in more ways to sort just by modifying the sort dropdown update, which will then avoid you having to repeat code on your gallery.
Awesome video as always.
Variable if used in sort would result in delegation warning.
Hi Reza,When you are using ‘in’ in filter,it should throw you delegation warning isn’t it?
It won't if you use Dataverse
@@RezaDorrani oh yes that’s right,is there any alternative if we are using sharepoint list?
@@shwetaswami8462 Search or IN are not delegate with SharePoint
That look nice, but Modern UI is so "beta" that after spending majority of time on troubleshooting, Classic controls are definitelly more reliable.
The technique shown in video is reliable.
I totally agree! MS modern controls are still far away of being Fluent 2.0 aware and even not stable in much cases. The example Reza showing here is using basic properties and functions of them and that works. But if you dig deeper into it, it is still a long way to go for them to make them "modern". Doesn't has to do with the very nice example from Reza of Refinement. Hopefully MS will continue work in the controls to make them really THEIR Fluent 2.0.
Agreed. Filters on Grid reflow property inside a modern table control is very unreliable when the data source/collection has over 30 items. List reflow works with multiple filters and large data sets.
Nice video Reza, I would love to understand if you don't use gallery with check box, instead use modern combobox, how do you uncheck the checked item, how do we select blank value in modern combobox or
If we put collect formula on on-change or on select value in collection I can do it, but with without collection how do I reset and allow empty selection
I would have to try that to know the steps.
@@RezaDorrani yeah bcz new modern combobox doesn't have allowEmptySelection property
So does the checkbox - there is always a way. Just that I have not explored it.
Thank you Reza! Amazing video as always. Any reason you used filter and in operator for search rather than using the search function directly? Any shortcomings of using search directly in dataverse?
Thanks!
No specific reason. Only certain types of columns supporting searching as a delegable query. The delegation documentation has all the details listed.
Hi Reza, could you please do a video how to create a docset in a folder that exists in SharePoint document library using power automate , please 😢
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@@RezaDorrani sure thanks for your reply
brilliant - if only my company let me use Dataverse to allow operators and functions that are non-delegable in SPO 😞
You could build this with other data sources as well, but may run into delegation challenges.
@@RezaDorrani more likely would use ‘starts with’ coz other data sources not poss, unfortunately. ‘Starts with’ obviously limited though, so would have to use on a couple of fields to avoid non delegable joining operators
Thats the limitation with SharePoint
@@RezaDorrani exactly. And it won’t change now MS is pushing dataverse. May have to change employer 🤫
Hi Reza ! how can send my task for support ? can we get your email
Task for support?
Thank you Reza...
Most welcome!