Finally got round to watching this. Simple, straightforward and elegantly presented as always. Extremely useful, especially the combination of the AND, OR and NOT operators to get the required logic to work. Great stuff and thank you for sharing.
Hi, I’ve always been leaning from your videos. Your explanation and the visuals have helped me a lot from my zero background of both power automate and the power apps. Thanks for your wonderful explanation dedicated to the Microsoft user’s world 👏 👍🏻
Writing to you after a long gap. But follow your videos every Monday ☺️. Can you share link of one of your videos where user can edit data from gallery. As usual 👍
A gallery if built using delegable queries will load data in batches in a performant manner. Loading 2000+ data into gallery in 1 go is not a recommended (performant) approach. You can check my playlist on delegation to learn more about how gallery works.
Great Video! Is there a specific way to add in and "assigned to" with the modern dropdown to only show the names of the people assigned. Currently I followed the same steps as your product example, but it is bringing everyone back in my directory (all OfficeUsers).
hi Reza, your is very powerful thanks for your time. I am creating two canvas apps in a model-driven app but when I switch between apps first app is off??
Most welcome! I have not come across the mentioned issue and do not have any video references on the scenario mentioned. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, How to find earliest date from multiple date column? Ex. I have three date columns Date 1, Date 2, Date 3 and I would like to find earliest date from these three columns and filter on earliest date. Thanks for great content!
Hey, 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
Hi Sir, Very informative video, do we have the step-by-step process of building this application apart from date filters like how you build the below galleries and all. if you have please share with us. Thank you.
Hi, Reza, thank you for this video, excellent, as usual. But, unfortunately, it is not working for me. Everything is just exactly as you showed, no formula error alert, but the gallery is still not filtered by the date range of the date pickers. The only thing I can guess, after much thought is the language format (although my sharepoint and powerapps are in PT-BR, in sharepoint the dates are shown in MM/DD/YYY, while in power apps they appear in DD/MM/YYY). Could that be the cause? PS: As I"m writing today, the .value property for the datepicker no long exists. I have to use .selecteddate. Could be this?
Value is now SelectedDate. It could very well be a language format issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar
Hi reza, your playlist is so helpful for me. I have a question here. How can we apply multiple filters and these filters are coming from multiple table like we can do in power bi (Applying multiple slicers on table visual)
It is possible but depends upon the tables / data source / architecture. I do not have a video reference on this scenario though. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@NofilAsif-i5e No. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hi Reza, great video thank you very much, I hoe you can assist me on the following issue, I have all excatly as in your video but I have the error "Name isn't Valid, 'Value' isn´t recognozed", again, thank you very much
Most welcome! I have not come across the mentioned issue 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
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.
I make videos when I receive multiple requests on a topic. Every quarter 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, Thanks for this, it was very helpful. I am currently trying to get a date picker in a gallery (Gallary 2) to display a date depending on the different gallery (Gallery 1) first column AND whats selected in a drop down outside of both the galleries. I tried the following - LookUp( 'Package Schedule', 'Package number' = DropdownPackageID.Selected.Result && 'Gate Item' = ThisItem.Title, 'BaselineDate' ) But its giving me a error for the "=" and ".Result" for some reason. Much appreciated.
Thanks for vídeo! is It possible to apply a filter to a choices column? I have a choices column with 5 laptops option, I want that an user select a period and the next screen It show only available laptop according with the period that the user selected previously.
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
In Case of large Data how to handel Delegation on Date also let me know i also need to apply is blank condition on another date column in sharepoint. for Example I have Sharepoint List that have 2 DateTime Column one for Enter and 2nd for Exit, i want to show record of those who entered in building on spacific date but have no record of Exit date (means not exit)?
If you are using classic dropdown control (which I assume you are), it has a property related to making it blank to begin with. I don’t remember the property name.
Hi Reza, How do I filter gallery with the order number from a barcode number from the barcode scanner. I have been trying , and although my expression is showing no errors, it's not working.
I have not done any work with barcode scanner hence not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, I have one question: Is it possible to have 2 or more filters and have the values for this filters only be items, that are present in the actual set of results? For example a list with visits of a doctor with columns name, symptoms and medication. If I filter the symptoms for “Symptom 1” I want to have the filter for medication contain just the medications that were made for visits with Symptom 1 and vice versa…
Probably possible but would run into delegation issues. Would work with data sets < 2000 items. I do not have a video reference on this scenario though. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thanks for your immediate response. In my gallery I'm showing a label text with condition. Soni wants to filter the gallery with that label name. Please suggest the right way. Thanks
I have not come across any issue with classic or modern controls and not sure what the cause or fix for your issue is. Best thing to do would be to post your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, on 2:39, there is a problem, after filter date, list only product B and Product A, while our product filter choice still shows A/B/C, which should be only B and A, how to correct this? let our filter reflect the left choices only like excel.
I have not come across the mentioned issue 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
Video description has link to download entire app and setup (member only). I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I make videos when I receive multiple requests on a topic. Every quarter 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.
Not true - these codes work fine! 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
@@RezaDorrani how to get the modern control properties? Under "upcoming features", "Keep classic themes" is off. Is there something else I should do get these modern controls?
Hi Reza,
Very informative video, these features are highly requested and I am sure it will help the community.
Thank you.
Glad it was helpful!
Finally got round to watching this. Simple, straightforward and elegantly presented as always. Extremely useful, especially the combination of the AND, OR and NOT operators to get the required logic to work. Great stuff and thank you for sharing.
Glad you enjoyed it! Thanks so much for the feedback
Hi, I’ve always been leaning from your videos. Your explanation and the visuals have helped me a lot from my zero background of both power automate and the power apps. Thanks for your wonderful explanation dedicated to the Microsoft user’s world 👏 👍🏻
Great to hear! Thanks so much for watching and learning from the videos
Thank you, Reza. I subscribed and have been watching a lot of your videos for several weeks. You are a fantastic teacher.
Wow, thank you so much.
Welcome to the channel
Great Raza, how simply you explain in the video....informative .....Thanks 🙏
You’re most welcome and thanks so much for watching
thanks!! This is the clearest guide I have seen :)
You're welcome!
Thank you Reza, looking forward to when we can format modern date picker to dd/mm/yyy
Coming very soon
Thank you for sharing, this has helped me understand better.
Glad it was helpful!
Writing to you after a long gap. But follow your videos every Monday ☺️.
Can you share link of one of your videos where user can edit data from gallery. As usual 👍
Thanks for watching the videos.
Check my playlist on editable grids.
1000x thanks to you Reza!! You are an amazing human being.
Thanks Reza 🙏🙏🙏 everytime always amazing explanations.
Glad you think so!
Brilliant!! And/or logic makes it so easy!
Thanks
very informative video, and very helpful Thank you so much
Most welcome
Another nice video Reza ... you rock!
Thanks again!
Awesome, Reza. Please, can you do a video on how to load 2000+ data into gallery.
A gallery if built using delegable queries will load data in batches in a performant manner. Loading 2000+ data into gallery in 1 go is not a recommended (performant) approach.
You can check my playlist on delegation to learn more about how gallery works.
Great Video! Is there a specific way to add in and "assigned to" with the modern dropdown to only show the names of the people assigned. Currently I followed the same steps as your product example, but it is bringing everyone back in my directory (all OfficeUsers).
Modern dropdown and combo box do not work well with person type columns.
Thanks for another amazing tip Reza
Most welcome
Always Perfect and backstopping 👍👍👍
Thanks so much
As Always.... excellent video very well explained.
Thank You George
hi Reza, your is very powerful thanks for your time.
I am creating two canvas apps in a model-driven app but when I switch between apps first app is off??
Most welcome!
I have not come across the mentioned issue and do not have any video references on the scenario mentioned. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Great video Reza. Thank you.
My pleasure!
Very nice !
How did you get the new Calendar UI. I'm still stuck with the old one on Canvas app 😞
Im using modern controls. Check my recent videos. They are all about modern controls and they can be enabled from settings in App.
@@RezaDorrani Is it stable enough to use in production?
@@kevinnguyen3635 GA was announced today for a few controls. Check power apps blog.
Great video, thanks a lot!
Most welcome
Hi Reza, How to find earliest date from multiple date column? Ex. I have three date columns Date 1, Date 2, Date 3 and I would like to find earliest date from these three columns and filter on earliest date.
Thanks for great content!
Hey, 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
@@RezaDorrani Will do! Thanks for your prompt response.
Great video, Thank you
Glad you liked it!
Hi Sir, Very informative video, do we have the step-by-step process of building this application apart from date filters like how you build the below galleries and all. if you have please share with us. Thank you.
Gallery designs -> ua-cam.com/video/Jj4ZYztnUQ0/v-deo.html
Gallery flyout menu -> ua-cam.com/video/ZWl2jwC9p3w/v-deo.html
tyvm Reza, you always help us. cheers!
Most welcome
Superb content as usual
Glad you enjoyed it
Hi sir.
Thankyou for the video. Could you please help me to find how did or which gallery have you put as browse screen and any icons you used ?
Video description has link to download entire solution (members only - check description for details)
Thank you very much !!!
You are most welcome!
You are most welcome!
Hi, Reza, thank you for this video, excellent, as usual. But, unfortunately, it is not working for me. Everything is just exactly as you showed, no formula error alert, but the gallery is still not filtered by the date range of the date pickers. The only thing I can guess, after much thought is the language format (although my sharepoint and powerapps are in PT-BR, in sharepoint the dates are shown in MM/DD/YYY, while in power apps they appear in DD/MM/YYY). Could that be the cause?
PS: As I"m writing today, the .value property for the datepicker no long exists. I have to use .selecteddate. Could be this?
Value is now SelectedDate. It could very well be a language format issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar
Hi reza, your playlist is so helpful for me. I have a question here.
How can we apply multiple filters and these filters are coming from multiple table like we can do in power bi (Applying multiple slicers on table visual)
It is possible but depends upon the tables / data source / architecture. I do not have a video reference on this scenario though. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Are you planning something like that in a future?
@@NofilAsif-i5e No. I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Amazing work ❤
Thank you! Cheers!
Tks Reza! You are amazing!
Thanks
Hi Reza, great video thank you very much, I hoe you can assist me on the following issue, I have all excatly as in your video but I have the error "Name isn't Valid, 'Value' isn´t recognozed", again, thank you very much
Most welcome!
I have not come across the mentioned issue 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
Sorry for the late reply, if you face this issue you can replace the "Value" with "Selecteddate"/"Selected" option and it should work
Hello Sir, Can you please make a video in regards to drag and drop functionality in PowerApps 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.
Magnificent.
Thanks
Hi Reza, thanks for this video. Is there a way to filter gallery if date elapses each other?
What does elapses mean?
I'm sorry..wanted to say "overlap"
@@adchrisakinyode5087 It does show data based on the range. So not sure whats the issue.
do you have videos on how I'm going to put a counter if how many items will fall under the filtered value?
No
Great work
Thank you! Cheers!
Hello Reza, I wanted to ask can you make a video on ow to do orderly sorting for displaying multiple values of dropdown?
I make videos when I receive multiple requests on a topic. Every quarter 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.
Done ! Very nice vídeo :D
Thanks
who knows how many powerapps out there are solely due to Reza spreading his magic.
I am so happy to know that there are apps out there :)
Thanks Reza..😊
Most welcome
I could not find "Value" property of a date picker. Is it no longer available?
I assume "Value" is replaced with "DefaultDate" property.
I believe Yes. Check documentation
Hi Reza,
Thanks for this, it was very helpful.
I am currently trying to get a date picker in a gallery (Gallary 2) to display a date depending on the different gallery (Gallery 1) first column AND whats selected in a drop down outside of both the galleries.
I tried the following - LookUp(
'Package Schedule',
'Package number' = DropdownPackageID.Selected.Result && 'Gate Item' = ThisItem.Title,
'BaselineDate'
)
But its giving me a error for the "=" and ".Result" for some reason.
Much appreciated.
I would have to recreate your scenario to know how to frame the formula. I recommend posting your issue on forums at powerusers.microsoft.com
Thanks for vídeo! is It possible to apply a filter to a choices column? I have a choices column with 5 laptops option, I want that an user select a period and the next screen It show only available laptop according with the period that the user selected previously.
I have done ~10 videos on filtering covering all column types. Recommend to check my videos on gallery filtering.
Maybe I need to watch this again but if there is no end date can a record still be shown?
From what I remember- Yes
Hello Reza.
Could You tell me how You make this info "show all data" or show information about actual filter date ?
the video itself is my best explanation
@@RezaDorrani i got only "Start Date cannot be greater than End Date" :(
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
Do you need to use modern controls?
No
you are my saviour 😍😍
In Case of large Data how to handel Delegation on Date also let me know i also need to apply is blank condition on another date column in sharepoint. for Example I have Sharepoint List that have 2 DateTime Column one for Enter and 2nd for Exit, i want to show record of those who entered in building on spacific date but have no record of Exit date (means not exit)?
Queries shown in video are delegable. Did you see any delegation warning in video formulas?
Hello how can you combine Search/SortbyCOlumn/Filter when you have an And function.Thank you
I have done a video on filter and sort
Simply decorate that with search
How can you make the value blank on the product filter? I keep getting the first value of the choice
If you are using classic dropdown control (which I assume you are), it has a property related to making it blank to begin with. I don’t remember the property name.
Hi Reza,
How do I filter gallery with the order number from a barcode number from the barcode scanner. I have been trying , and although my expression is showing no errors, it's not working.
I have not done any work with barcode scanner hence not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, I have one question: Is it possible to have 2 or more filters and have the values for this filters only be items, that are present in the actual set of results? For example a list with visits of a doctor with columns name, symptoms and medication. If I filter the symptoms for “Symptom 1” I want to have the filter for medication contain just the medications that were made for visits with Symptom 1 and vice versa…
Probably possible but would run into delegation issues. Would work with data sets < 2000 items. I do not have a video reference on this scenario though. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thanks for your reply. I will check the forums
Hi Raza, i have a doubt is we can add filter based on one of the label value from the same gallery along with the multiple conditions?
Does not sound like a right approach to me. Why would you want to do that? Whats the scenario?
@@RezaDorrani Thanks for your immediate response. In my gallery I'm showing a label text with condition. Soni wants to filter the gallery with that label name. Please suggest the right way. Thanks
@@abishkumar2131 whats Soni? I dont have any video on this scenario. I recommend posting your query on forums at powerusers.microsoft.com
@@RezaDorrani Thanks for your valuable help ❤️.
Sorry for the mistake, that was so I want to...
I can't get it to work with either the old or the modern controller. Can you help me Reza?
I have not come across any issue with classic or modern controls and not sure what the cause or fix for your issue is. Best thing to do would be to post your issue with screenshots on the forums at powerusers.microsoft.com
Mr Reza a quick question, how is posible to access in power apps or powerautomate the rstp protocol of a videocamara? it is posible?
I don’t know if that is possible. I recommend posting your query on forums in case someone has done something similar
powerusers.microsoft.com
thanks i will do that, BTW Excelent video@@RezaDorrani
@@fam.giannakisflores7780 Thanks
Hi Reza,
on 2:39, there is a problem, after filter date, list only product B and Product A, while our product filter choice still shows A/B/C, which should be only B and A, how to correct this? let our filter reflect the left choices only like excel.
I have not come across the mentioned issue 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
Hi Reza, What I mentioned is on your video 2:39, please kindly check. @@RezaDorrani
@@Sarahzhang-g5e Yes but that is not an issue. I would have to try it out to know how to do it. I would recommend posting your query on forums.
Hi sir im getting error in my text of product like ThisItem.Product.Value json parsing error expected object but got array
Video description has link to download entire app and setup (member only).
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
.Value is not working for me not sure why is giving me a red x
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
we want an attend app for school plzzzzz
I make videos when I receive multiple requests on a topic. Every quarter 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.
Not working. These codes are outdated
Not true - these codes work fine!
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
@@RezaDorraniBy dpStartDate.Value. It says "'Value' isn't recognized". I had to do dpStartDate.SelectedDate.
Thats becoz of modern control properties. Modern date control is in preview.
@@RezaDorrani how to get the modern control properties? Under "upcoming features", "Keep classic themes" is off. Is there something else I should do get these modern controls?
@@roelmarten3969 check setting shown in ua-cam.com/video/TWcQwocLsE4/v-deo.html
Video inservible, no ayuda en nada
Comentario inútil, no me ayuda en nada a saber qué le pasa al vídeo.