I swear you make videos just ahead of what I need. I was just thinking I hadn’t seen you do this exact topic and wanted to double check and lo and behold you just made one! Thanks!
Great presentation as always and another one for my Library. Was good to get it in before the weekend as this particular one is busy for me. Thanks for sharing.😀
Thanks Reza. Your videos solely helped me build one of my projects. It would be great if the canvas table control gets all properties of grid control of model driven apps.
@@RezaDorrani Thanks for your response. Can you please make a video about applying grouped filters? I couldn’t find this scenario in your videos. Currently, I have a popup with all filters and two buttons (Apply, Reset). I want to filter the table at once when Apply or Reset is clicked. Thanks 😊
@@venkatakrishnagolla4056 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 topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Most welcome! I have done no videos on ADO items in apps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video, as always Reza! The modern controls look great. However, I have noticed that they are quite glitchy, especially the table. When filtering it, it often doesn't filter correctly. I hope these issues will be improved in the future.
@@RezaDorrani Hi and first of all: thanks for the tutorial. That's not correct, at the 0.51 of this video you can see that the first filter you apply, it doesn't get it correctly: in the table doesn't just show you the priority that you filtered out. This is the anomaly: the first filter you apply is not taken. The same thing happens to me with my app, do you know the solution? Thanks
Great tutorial, Reza! I have just subscribed to your channel! I would really appreciate if you could show how to how to filter, let`s say your Due Date column with a date picker or month drop down menu. It`s something that I try to do but I end up in a rabbit hole.
I just started developing apps using MS Power Apps in my company and you cannot imagine how much your YT Channel has taught me! Quick question: is it possible to add an icon next to the "Priority" column if the priority is high, medium or low? Just like as we do directly in the Sharepoint List with conditional formatting. Thanks Reza!!!
That's great, I'm excited to use it in my projects. Do you know when the modern table control will be fully developed? Some column types, like multiple choice/people, are still not working properly.
Hi Reza, Great video! This is helping me build an inventory management system. I'm having a little issue with the filter function. How do you make it so it search any text within the Title instead of just StartWith?
Nice tutorial, sir! For your next video, could you create a tutorial that includes a sidebar instead of a full-width form or table? The full-width format works well for small projects, but when dealing with multiple screens, it becomes challenging to navigate without a sidebar. Please consider this suggestion. Thanks!
Thank so much for this, Reza! Do you happen to know if the performance impact expense of using "Key press" on Trigger output is the same if one is using Power Apps in Teams?
Hello Reza, i don't know if you notice it but at minut 00:50 you filtered the table by priority "High" and that didn't work. That happens to my apps too when i filter the table for the first time, then it doesn't happen again. Do you have any idea why it happens? is it a bug of the new modern table?
So many great tips in your videos, thank you. Also the new intellisense seems to work nice on your screen but on mine the options part covers up the 'input progress' part, it's horrible. how can i make it display llike yours.
Hey @reza - in my choices column I have blanks - I want to show this in my dropdown as a option as well as the available choices too. Is there a way to do this?
Probably possible but something I would have to try to know the steps on how to do it. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Hi Reza, I´m new in PowerApps and I don´t have f.e. in NewScreen Header and table. My last is Landscape print. Do you know why? Your video help me a lot. Good job Reza!
Hi Reza! I have been loving your videos. I am struggling with a part in this, however. I have a sharepoint list with a multiple choice column, and the data in that column won't show up in the app you're building that I'm copying. Your help is appreciated!
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Do you have a video to build a gallery app that does the same thing as the table above? I wonder if that might be a work around. I just need to apply two filters to a list of trainers showing them by district and topic they train.
Thanks Reza... Wonderful post as always. Thx. 2 clarifications pls.: 1. Why "Filter by" option under the "Table Column header" dropdown option is disabled. Located below "A to Z and Z to A"? 2. Is there way to filter other than "StartWith". Requirement is to detect words after the first phrase in the title. 3. Can we list the "Text column" values as drop downs to choose?
@@RezaDorrani Thx Reza. another glitch faced. After publishing precisely following your post, it works fine in preview mode. But after publishing, this error displayed "We can;t find anything to show here". Checked in NET, but could not find any answer..
@@veerpat5331 I have not experienced any such issue. Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try.
Is there a way I can directly edit in this table after filtering …. And I did notice you had a New Item aswell … would it be possible to help how to have that
Hi Reza, The dropdown is working/filtering but not visible. Maybe the text color is white and in case how to change if it is currently linked to theme?
I have not experienced any issues with drop down not visible. Not sure if it's theme related in your case. You can try downloading the solution shown in video (members only - check video description for details)
Hi Reza, your videos has helped a lot to improve the efficiency at my job. Thanks alot for that. Im getting error when adding filter for my table (07:25 mins reference). can you please help me out with that. Filter('QHSE Corrective Action Tracking Register',StartsWith(Location2,Lcttxt.Value)) Im getting red lines for startswith & Location2
Most welcome! Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I cannot guess what the issue is by looking at formulas here on chat. There could be many factors like column type, etc. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Brilliant tutorial! I was able to apply this directly at my company. I am running into an issue where my data will not load in the published version of the app. Everything works fine in play mode, but my data doesn't load when I have the full Filter function included for my data table Items. Any thoughts?
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.
Check th-cam.com/video/CVmjxMp79W0/w-d-xo.html from 11:09 onwards Table control is delegable with SharePoint as long as items property query is delegable
Hi Reza - Could you please advice is this is possible: I would like to create a Service Wrap Report on my SharePoint Document Library. By using Power Automate... can I create a Service Wrap report service - which will action every one year - it will check how many times the file was used/accessed in that document library by using the Modified By Date MetaData - and create a HTML Table and send that table as email to me. or Can we not use SharePoint Storage Metics Data somehow using Power Automate for this purpose?
Hello Reza! This is a wonderful video. I followed all the instructions, but have an issue filtering with the Choice column. The choice column in my case is also called Status. When I filter for the first time, say Status = Implemented, the data table shows accurate results. But if I change my Status selection, Status = On Hold, it doesn't clear the rows with Status = Implemented and adds the rows with Status = On Hold after those rows. Any idea what might be causing this? Any help would be appreciated. Thanks!
My column is also of type choice. I have not faced any issues with it and hence not sure whats the cause of your issue unless I reproduce it. Video description has details of link to download entire soltion.
Hi Reza, Is there any workaround you have, i have to use the icon inside the modern table control like gallery. I searched lot but i'm not able to found. Please help Reza..
Hi Reza, I have a table control on the home screen and have added filters. But the filters do not work at the first try, second time onwards it starts working. Everytime i refresh the app or reset filters this issue comes, not working just on the first filter applying. Not sure what is the issue.
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/
Hi @Reza, I am facing a wierd issue with Table control My data source is dataverse with 100k+ rows. I have a dropdown to slect the view and bunch of other filters (~15 filters). I also have a refresh button to refresh the data. When I scroll to the middle of the table and change the view/ filters, the table is refreshing but, still shows the data incorrect. User has to click the "refresh" button again to show correct data. Can you suggest a work around for this?
How might I modify this Or statement to address the issue of my last dropdown pulls from a LOOKUP column in SharePoint? Or(LocationDropdown.Selected.Value = Blank (), LOCATION.Value = locationDropdown.Selected.Value) It also gives me a Delegation warning when I attempt to pull from this column as well. Thanks Reza for all you do here! This has been extremely helpful.
With modern tables, i see a drop down for each header with sort options. I also see a filter option that is permanents greyed out... I can't find any info on that Filter option anywhere. Any ideas?
This link has the info on how to get the link thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
Hello Reza - I am not sure why I continue to have this problem, but my gallery will not filter - it produces no data even thought the formula has no errors. My formula in the items feature of gallery is Filter(Table1,StartsWith(‘Project Name’, Searchproj.Value)) - again no errors, but when I type valid data within my input text box, all data within my gallery disappears and no data is returned from the filter. I did declare a global variable within my gallery and I’m not sure if that is posing an issue, but if you have any insight as to what the issue might be, I welcome your feedback. Thanks Reza.
Hi Reza can you please help im not getting any result when im selecting “ME” filter from assigned to dropdown above field it is only filtering on All by default is there any way i can fix this?
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, Issue i am facing - "Enable UI automation in virtual desktop " I am trying to connect the RDP or Citrix application to Power automate. Can you please suggest me. What I do
Video is on Power Apps data filtering. Your issue seems to be power automate desktop related. I recommend posting your issue on forums at powerusers.microsoft.com
Hi Reza! I tried modern table control with Sharepoint, but looks like filters doesn't work properly. If I scroll down a bit and change filters, then new filtered data is stacked upon previous batch of data. E.g. initially Status = Completed, I scroll down just a but, switch Status = Returned, then scroll up: on top of the screen there are still Completed items.
I have not come experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
Hi Rezza! Very useful video! However I’m having some issues with filtering. I have 3 combobox filter controls and I’m using SharePoint as my data source. I have a default selected item set on one of the combo boxes but I notice when I go and manually try to update the filters via the comboboxes it doesn’t get applied properly. The table will act like something got applied but does not reflect the change. Or sometimes it will apply and show no data but then show all of the items I have in SharePoint (this seems more like a bug). In some cases I have checked the output of the filter command and I see that it’s working properly ex: only getting one record returned, but the modern table control doesn’t seem to reflect… How can I fix this? Or is this a bug you are aware of?
I have not experienced this issue. I have used multiple filters as shown in video without any issue. I have a customer who is actively using this today with 10+ filters. There must be something not done correctly in your App.
@@RezaDorrani I am experiencing the same issue. I have a textinput (delayed output),; when I enter in a last name, the rows at the bottom show 1 (correct), except all of the original items, before the filter, still show. If I remove 1 letter from the name, it shows correctly. It seems like the original filter doesn't apply, visually, on the table. (3.24091.13 also with 3.24084.21)
The only thing holding me back from using table control instead of gallery is the lack formatting for column values. We're stuck with the default formatting of values/texts.
Direct formatting is currently not an option, but I did show an indirect way to achieve it here th-cam.com/video/CVmjxMp79W0/w-d-xo.htmlsi=LpXfXYuwBBvEt2xd
Hi Reza, I’m encountering an issue when trying to modify a choice column in SharePoint. I keep getting an error message: "Sorry, we couldn't modify the column. Please try again." Do you think this could be due to a lack of permissions on my end, or is it a general issue that prevents us from modifying columns?
Not a general issue at all. I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I went through building a similar app though your awesome video. Data table works great in design and preview mode but the moment I publish it and use the published link the data table comes back empty over and over again. Anyone have a clue why? Is this a modern control preview bug?
Reza thanks, I cannot explain it. I did everything exactly the same. If I publish the app with no filters the data is there in both preview and publish. Once I add the filter statements the data and app work fine in preview but when I publish the app says “no data can be found”
@@jamespenna5452 Most likely something was missed. You can try downloading the app shared in video (members only - check video description for details)
thanks Reza I’ll give it one more review. I may move it to a different environment to see how it behaves. I’ve never seen an app act different like this outside preview and published
@@RezaDorrani 😊 | hello rezza can you compile a playlist from your available videos , to follow step by step development from 0 to complete enterprises level application.. it would be very helpful for the navigation..
@@tarunsharma1428 My videos are not made in any particular order. They are mostly how to videos. I have multiple playlists in which I have tried categorizing the videos. I have a training program (channel members in GOLD tier) which has step by step ordered list of content.
@@djbcobra I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Filters to gallery isn’t working for me “choices(database name.column name” in item property of drop-down but it isn’t working throwing an error ? Someone give me a solution ?
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I built a table filter like this and it worked fine, after I changed the name of the sharepoint list it stopped working correctly. I've created a new page, i've deleted the data connection and added it again, it just refuses to work. This is the code i have: Filter( 'HSD Test Report DB', And( StartsWith( Title,txtYPN.Value ), StartsWith( 'Report Nr',txtReport.Value ), Or(dropCT.Selected.Value = Blank (), Cable.Value = dropCT.Selected.Value), Or(dropPH.Selected.Value = Blank (), ProdHardware.Value = dropPH.Selected.Value), Or(dropManuf.Selected.Value = Blank (), Plant.Value = dropManuf.Selected.Value), Or(dropSpec.Selected.Value = Blank (), Specification.Value = dropSpec.Selected.Value) ) ) Most of the filters are dropdown lists and even on those it doesn't work correctly. Some times it works and filters correctly, other times it doesn't. If I try multiple filter simultaneously that it works fine. Any ideas?
I have no clue about the reason for this issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
I swear you make videos just ahead of what I need. I was just thinking I hadn’t seen you do this exact topic and wanted to double check and lo and behold you just made one! Thanks!
Thank you Reza, your videos are always rich in information, tips and explanations.
Glad you like them!
I swear you make videos just ahead of what I need. I was just thinking I hadn’t seen you do this exact topic and wanted to double check and lo and behold you just made one! Thanks!
I read minds 😊
Great Video Reza. Dynamically setting the screen is very vital
Most welcome!
I agree on the importance of responsive design.
Amazing resource, thank you. Instant subscription.
Welcome aboard!
You are the best! Thank you for your videos
Thanks so much
You always help me alot with my apps Reza, thank you!
Happy to hear that!
You and Shane are the Ronaldo and Messi of Power Apps video tutorials.
Wow! Thanks so much
Hi Reza, as always a very usful video. Thank you very much!
Glad to hear that!
Thanks Reza.... you are superb.... contents are very useful
Glad to hear that
Renza Amazing your training thanks 🙏🙏🙏
You're so welcome!
Great presentation as always and another one for my Library. Was good to get it in before the weekend as this particular one is busy for me. Thanks for sharing.😀
Most welcome! I try my best to get it done by Thursday, but some weeks its not possible.
Thank you very much, Reza!
My pleasure!
Wonderful video Reza, I’ve been a bit reluctant to use modern controls as I know many are still in preview but I must try this
Modern controls is the future. A certain set of mod controls are GA and more will go GA soon.
There are many new controls coming...
Thank You reza , great video as usual .
Glad you enjoyed it
Thank you Reza
Welcome
Thank You!!!!
You're most welcome!
Awesome video and very well explained. Thank You
Thank You so much
Thanks Reza. Your videos solely helped me build one of my projects.
It would be great if the canvas table control gets all properties of grid control of model driven apps.
Welcome!
It would be great indeed if canvas app gets model driven grid like properties
@@RezaDorrani
Thanks for your response.
Can you please make a video about applying grouped filters? I couldn’t find this scenario in your videos.
Currently, I have a popup with all filters and two buttons (Apply, Reset). I want to filter the table at once when Apply or Reset is clicked.
Thanks 😊
@@venkatakrishnagolla4056 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 topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
@@RezaDorrani
Will surely do. Thanks😊
Excellent tricks!
Thanks!
Superb again as usual! Thanks Reza. I am still trying to find out how I can connect my ADO items to power apps
Most welcome!
I have done no videos on ADO items in apps.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video, as always Reza! The modern controls look great. However, I have noticed that they are quite glitchy, especially the table. When filtering it, it often doesn't filter correctly. I hope these issues will be improved in the future.
Modern table control is in preview. Having said that, I have not faced any issues related to filtering.
@@RezaDorrani Hi and first of all: thanks for the tutorial.
That's not correct, at the 0.51 of this video you can see that the first filter you apply, it doesn't get it correctly: in the table doesn't just show you the priority that you filtered out. This is the anomaly: the first filter you apply is not taken. The same thing happens to me with my app, do you know the solution? Thanks
@@markuscrow The end result shown in video does work. I dont remember or keep a track on what was shown at a particular timeframe in a video.
Great tutorial, Reza! I have just subscribed to your channel!
I would really appreciate if you could show how to how to filter, let`s say your Due Date column with a date picker or month drop down menu. It`s something that I try to do but I end up in a rabbit hole.
Most welcome!
I have done videos on gallery filtering including dates. The month scenario is not something I have tried though.
This Help full Reza.
Great!
I just started developing apps using MS Power Apps in my company and you cannot imagine how much your YT Channel has taught me! Quick question: is it possible to add an icon next to the "Priority" column if the priority is high, medium or low? Just like as we do directly in the Sharepoint List with conditional formatting. Thanks Reza!!!
Most welcome!
Table control currently does not support data formatting.
Reza thank you for this brilliant video as always. May I ask, is there a way to search text in the title instead of start with text?
Search is Not a delegable function with SharePoint th-cam.com/video/AyfEXgNYZZs/w-d-xo.htmlsi=kWWeTrESOOo4qnnt
Thank you! How would you filter and use the "and" "or" for multiple drop down columns
I have done many videos on gallery filtering coverings various scenarios. Il recommend checking them.
That's great, I'm excited to use it in my projects. Do you know when the modern table control will be fully developed?
Some column types, like multiple choice/people, are still not working properly.
Great to hear!
I am not aware of GA date for Modern table control
Hi Reza, Great video! This is helping me build an inventory management system. I'm having a little issue with the filter function. How do you make it so it search any text within the Title instead of just StartWith?
Thanks!
If using SharePoint then StartsWith is the only delegable option. Thats a limitation.
If using Dataverse, you can use the Search function.
Nice tutorial, sir! For your next video, could you create a tutorial that includes a sidebar instead of a full-width form or table? The full-width format works well for small projects, but when dealing with multiple screens, it becomes challenging to navigate without a sidebar. Please consider this suggestion. Thanks!
Will plan for it, whenever I build an App that involves more than 2 screens
@@RezaDorrani Thank you so much for considering my suggestion. More power to your channel!
Hi Reza, I have followed your steps to create this. Do you have any videos where in the same app, I can add or amend a new task to the list?
Check videos I did around same time frame as this one.
th-cam.com/video/FUVjkPnRsfg/w-d-xo.htmlsi=gjsai_pDJGDdisIz
My gosh, thanks for the quick response! This looks perfect. Thanks so much
Thank so much for this, Reza! Do you happen to know if the performance impact expense of using "Key press" on Trigger output is the same if one is using Power Apps in Teams?
I have not done any work on power apps in teams, so not sure about that. I dont see a reason why performance would differ.
Thats great
Thanks
At 14:15, I wonder how you drew up the menu to insert the emoji.
Windows+. to open emoji keyboard
Hello Reza, i don't know if you notice it but at minut 00:50 you filtered the table by priority "High" and that didn't work. That happens to my apps too when i filter the table for the first time, then it doesn't happen again.
Do you have any idea why it happens? is it a bug of the new modern table?
The last published version of app (shown in end demo) works fine. The first one shown was based on a sample version I had prepated.
@@RezaDorrani What version of powerApps are you using? i am on 3.24074.18
Hey Reza, thank you for sharing it. For dynamic screen size setting, why don’t just turn off horizontal overflow "?😊
Welcome!
Will that make it work for all screen sizes and dimensions?
Hi Reza, from your tutorial, I have Salary column , how to change format number in the Table control column ? Many thanks in advance.
Currently, there is no option to change formatting
So many great tips in your videos, thank you. Also the new intellisense seems to work nice on your screen but on mine the options part covers up the 'input progress' part, it's horrible. how can i make it display llike yours.
The intellisense feature is out of the box. Not sure why it would not be working in your case.
Hey @reza - in my choices column I have blanks - I want to show this in my dropdown as a option as well as the available choices too. Is there a way to do this?
Probably possible but something I would have to try to know the steps on how to do it.
I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Nice video Rezza!!
Wy in may App the modern control imputtext has a sugest text in memory (autocomplete)? How to disable it? :(
Welcome!
Not sure about that. Might be something to do with your browser setting.
Would it be possible to use a multi choice combo as a filter and what would the Or condition look like?
I have done a video on multi select choice filter options. I would recommend looking for that video.
@@RezaDorrani I took a look and did not see how the filtering would translate to a modern data table. I will check again. Thanks Reza!!!
@@jamespenna5452 The technique shown was with gallery. It’s similar with modern table.
Hi Reza, I´m new in PowerApps and I don´t have f.e. in NewScreen Header and table. My last is Landscape print. Do you know why?
Your video help me a lot. Good job Reza!
Make sure you start with app in tablet mode and under settings - turn on modern controls + disable scale to fit feature
Hi Reza! I have been loving your videos. I am struggling with a part in this, however. I have a sharepoint list with a multiple choice column, and the data in that column won't show up in the app you're building that I'm copying. Your help is appreciated!
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Do you have a video to build a gallery app that does the same thing as the table above? I wonder if that might be a work around. I just need to apply two filters to a list of trainers showing them by district and topic they train.
I have a full playlist on galleries and filters. Il recommend checking that.
Thanks Reza... Wonderful post as always. Thx.
2 clarifications pls.:
1. Why "Filter by" option under the "Table Column header" dropdown option is disabled. Located below "A to Z and Z to A"?
2. Is there way to filter other than "StartWith". Requirement is to detect words after the first phrase in the title.
3. Can we list the "Text column" values as drop downs to choose?
1 - Thats a future feature
2 - StartsWith is NOT delegable with SharePoint. Dataverse would be the best choice.
3- Delegation challenges
@@RezaDorrani Thx Reza. another glitch faced.
After publishing precisely following your post, it works fine in preview mode.
But after publishing, this error displayed "We can;t find anything to show here".
Checked in NET, but could not find any answer..
@@veerpat5331 I have not experienced any such issue.
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
Is there a way I can directly edit in this table after filtering …. And I did notice you had a New Item aswell … would it be possible to help how to have that
If an item in table is selected, user gets navigated to edit form experience.
Check th-cam.com/video/xAQbO8COV5c/w-d-xo.htmlsi=b4NcdR9A0GW1Yp6i
Will this work with data source : Dataverse with filter and search option together ?
Yes
Hi Reza, The dropdown is working/filtering but not visible. Maybe the text color is white and in case how to change if it is currently linked to theme?
I have not experienced any issues with drop down not visible. Not sure if it's theme related in your case.
You can try downloading the solution shown in video (members only - check video description for details)
Hi Reza, your videos has helped a lot to improve the efficiency at my job. Thanks alot for that.
Im getting error when adding filter for my table (07:25 mins reference). can you please help me out with that.
Filter('QHSE Corrective Action Tracking Register',StartsWith(Location2,Lcttxt.Value))
Im getting red lines for startswith & Location2
Most welcome!
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I cannot guess what the issue is by looking at formulas here on chat. There could be many factors like column type, etc.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Brilliant tutorial! I was able to apply this directly at my company. I am running into an issue where my data will not load in the published version of the app. Everything works fine in play mode, but my data doesn't load when I have the full Filter function included for my data table Items. Any thoughts?
Check my video again and the steps. Specially the part where I handle StartsWith function again after applying all filter logic.
@@RezaDorrani Thank you!!!! That did the trick. Appreciate ya!
How do we do it for a filter item that is a numerical value?
You mean a number column. you can. Use = > or < type operators.
Check documentation on filter function
Hello Reza, Good Day.. Please make a video on how to save email as Draft in our outlook without using premium in power automate.
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 Okay Thank you.
Reza, table control, if used filter on SharePoint list over 2000, is there a issue with delegable ?
Check th-cam.com/video/CVmjxMp79W0/w-d-xo.html from 11:09 onwards
Table control is delegable with SharePoint as long as items property query is delegable
Hi Reza - Could you please advice is this is possible:
I would like to create a Service Wrap Report on my SharePoint Document Library. By using Power Automate... can I create a Service Wrap report service - which will action every one year - it will check how many times the file was used/accessed in that document library by using the Modified By Date MetaData - and create a HTML Table and send that table as email to me.
or
Can we not use SharePoint Storage Metics Data somehow using Power Automate for this purpose?
SharePoint storage metrics may be available in graph api. You will need to explore that.
@@RezaDorrani Thank You!
Hello Reza! This is a wonderful video. I followed all the instructions, but have an issue filtering with the Choice column. The choice column in my case is also called Status. When I filter for the first time, say Status = Implemented, the data table shows accurate results. But if I change my Status selection, Status = On Hold, it doesn't clear the rows with Status = Implemented and adds the rows with Status = On Hold after those rows. Any idea what might be causing this? Any help would be appreciated. Thanks!
My column is also of type choice. I have not faced any issues with it and hence not sure whats the cause of your issue unless I reproduce it. Video description has details of link to download entire soltion.
@@RezaDorrani thank you! :)
Hi Reza, Is there any workaround you have, i have to use the icon inside the modern table control like gallery.
I searched lot but i'm not able to found. Please help Reza..
Currently, icons inside table control are not supported
Hi Reza, I have a table control on the home screen and have added filters. But the filters do not work at the first try, second time onwards it starts working. Everytime i refresh the app or reset filters this issue comes, not working just on the first filter applying. Not sure what is the issue.
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/
Hi @Reza,
I am facing a wierd issue with Table control
My data source is dataverse with 100k+ rows.
I have a dropdown to slect the view and bunch of other filters (~15 filters). I also have a refresh button to refresh the data.
When I scroll to the middle of the table and change the view/ filters, the table is refreshing but, still shows the data incorrect. User has to click the "refresh" button again to show correct data.
Can you suggest a work around for this?
I would have to reproduce your issue to know of its cause or suggest a fix. Not sure how I can help here.
where can i download the app?
details here: thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=y_WHtcT33Eg
How might I modify this Or statement to address the issue of my last dropdown pulls from a LOOKUP column in SharePoint? Or(LocationDropdown.Selected.Value = Blank (), LOCATION.Value = locationDropdown.Selected.Value) It also gives me a Delegation warning when I attempt to pull from this column as well. Thanks Reza for all you do here! This has been extremely helpful.
Check my videos on filtering where I include lookup columns. I have a full playlist on delegation.
Do silver members have the ability to download this?
Yes
With modern tables, i see a drop down for each header with sort options. I also see a filter option that is permanents greyed out... I can't find any info on that Filter option anywhere. Any ideas?
Filter is a future feature, hence grayed out.
@@RezaDorrani Thanks mate. I assumed this but couldn't find any info on it anywhere... many thanks! :)
how to download the appp when I am a member ?
This link has the info on how to get the link
thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
Hello Reza - I am not sure why I continue to have this problem, but my gallery will not filter - it produces no data even thought the formula has no errors. My formula in the items feature of gallery is Filter(Table1,StartsWith(‘Project Name’, Searchproj.Value)) - again no errors, but when I type valid data within my input text box, all data within my gallery disappears and no data is returned from the filter. I did declare a global variable within my gallery and I’m not sure if that is posing an issue, but if you have any insight as to what the issue might be, I welcome your feedback. Thanks Reza.
Just startswith alone will not suffice. Please check the entire video again. I add an extra logic later in video for startswith.
Hi Reza can you please help im not getting any result when im selecting “ME” filter from assigned to dropdown above field it is only filtering on All by default is there any way i can fix this?
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
When I enter the filter function,all the data from my tables vanishes?what do I do
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza,
Issue i am facing - "Enable UI automation in virtual desktop "
I am trying to connect the RDP or Citrix application to Power automate.
Can you please suggest me. What I do
Video is on Power Apps data filtering.
Your issue seems to be power automate desktop related.
I recommend posting your issue on forums at powerusers.microsoft.com
Hi Reza! I tried modern table control with Sharepoint, but looks like filters doesn't work properly. If I scroll down a bit and change filters, then new filtered data is stacked upon previous batch of data. E.g. initially Status = Completed, I scroll down just a but, switch Status = Returned, then scroll up: on top of the screen there are still Completed items.
I have not come experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
Hi Rezza! Very useful video! However I’m having some issues with filtering. I have 3 combobox filter controls and I’m using SharePoint as my data source. I have a default selected item set on one of the combo boxes but I notice when I go and manually try to update the filters via the comboboxes it doesn’t get applied properly. The table will act like something got applied but does not reflect the change. Or sometimes it will apply and show no data but then show all of the items I have in SharePoint (this seems more like a bug). In some cases I have checked the output of the filter command and I see that it’s working properly ex: only getting one record returned, but the modern table control doesn’t seem to reflect… How can I fix this? Or is this a bug you are aware of?
I have not experienced this issue. I have used multiple filters as shown in video without any issue. I have a customer who is actively using this today with 10+ filters. There must be something not done correctly in your App.
@@RezaDorrani I am experiencing the same issue. I have a textinput (delayed output),; when I enter in a last name, the rows at the bottom show 1 (correct), except all of the original items, before the filter, still show. If I remove 1 letter from the name, it shows correctly. It seems like the original filter doesn't apply, visually, on the table. (3.24091.13 also with 3.24084.21)
@@pvpatrick I'll recommend posting the issue details on forums
The only thing holding me back from using table control instead of gallery is the lack formatting for column values. We're stuck with the default formatting of values/texts.
Direct formatting is currently not an option, but I did show an indirect way to achieve it here th-cam.com/video/CVmjxMp79W0/w-d-xo.htmlsi=LpXfXYuwBBvEt2xd
Hi Reza, I’m encountering an issue when trying to modify a choice column in SharePoint. I keep getting an error message: "Sorry, we couldn't modify the column. Please try again."
Do you think this could be due to a lack of permissions on my end, or is it a general issue that prevents us from modifying columns?
Not a general issue at all. I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Please this dosn't work with lookup column, How do you filter lookup column.
Check my videos on filtering galleries. I have done many of them including lookup columns.
I went through building a similar app though your awesome video. Data table works great in design and preview mode but the moment I publish it and use the published link the data table comes back empty over and over again. Anyone have a clue why? Is this a modern control preview bug?
Thanks!
I would suggest checking the whole video again. I play the app and show the published version in action.
Reza thanks, I cannot explain it. I did everything exactly the same. If I publish the app with no filters the data is there in both preview and publish. Once I add the filter statements the data and app work fine in preview but when I publish the app says “no data can be found”
@@jamespenna5452 Most likely something was missed. You can try downloading the app shared in video (members only - check video description for details)
thanks Reza I’ll give it one more review. I may move it to a different environment to see how it behaves. I’ve never seen an app act different like this outside preview and published
@@jamespenna5452 I have not experienced it either. And the app shown in video is what I have shared for members.
Windows + colon also opens the emoji keyboard
Thanks for sharing
@@RezaDorrani 😊 | hello rezza can you compile a playlist from your available videos , to follow step by step development from 0 to complete enterprises level application.. it would be very helpful for the navigation..
@@tarunsharma1428 My videos are not made in any particular order. They are mostly how to videos. I have multiple playlists in which I have tried categorizing the videos.
I have a training program (channel members in GOLD tier) which has step by step ordered list of content.
@@RezaDorrani 😥
Why is the use of the "AND" function throwing a delegable warning now?
I have not experienced any delegation issues
@@djbcobra I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani its because i was using a lookup column
Filters to gallery isn’t working for me “choices(database name.column name” in item property of drop-down but it isn’t working throwing an error ? Someone give me a solution ?
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I built a table filter like this and it worked fine, after I changed the name of the sharepoint list it stopped working correctly.
I've created a new page, i've deleted the data connection and added it again, it just refuses to work.
This is the code i have:
Filter(
'HSD Test Report DB',
And(
StartsWith(
Title,txtYPN.Value
),
StartsWith(
'Report Nr',txtReport.Value
),
Or(dropCT.Selected.Value = Blank (),
Cable.Value = dropCT.Selected.Value),
Or(dropPH.Selected.Value = Blank (),
ProdHardware.Value = dropPH.Selected.Value),
Or(dropManuf.Selected.Value = Blank (),
Plant.Value = dropManuf.Selected.Value),
Or(dropSpec.Selected.Value = Blank (),
Specification.Value = dropSpec.Selected.Value)
)
)
Most of the filters are dropdown lists and even on those it doesn't work correctly. Some times it works and filters correctly, other times it doesn't.
If I try multiple filter simultaneously that it works fine.
Any ideas?
I have no clue about the reason for this issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
I swear you make videos just ahead of what I need. I was just thinking I hadn’t seen you do this exact topic and wanted to double check and lo and behold you just made one! Thanks!
Time spent making videos < Time spent thinking about what to make
I’m glad to hear the topics are helpful and being appreciated