Jam packed with a ton of information, tips, and tricks. Yes this video is about modern Table control, but it also shows how to use named formulas, screen size, create views, add filters within views, filter out views, formula columns, color code the information displayed, and a lot more… No surprise you are amongst the best in the business.
Today i learned modern table control, filter functionality, search functionality, Responsive design handling. Thanks Reza for your support on technology
Thank you, Reza, for such clear and precise explanations. I try to watch your videos every day, and they've become a part of my daily routine. I feel like I wouldn't have been able to improve at PowerApps development without these tutorials. I truly admire your work!
i really like this "Tips and Tricks" video style as it gives you more insight about things you may already have ideas about. Good to see how the Modern Table control can be used but even better are the tips around screen sizing, dynamic font and size manipulations and view filters plus powerfx in tables etc. Excellent demo and more of these, please. Thanks for sharing.
Looks like a superior version of “galleries”. If so, I think this is the missing piece that will tie together a crucial project I’m mapping out. So excited. Thanks, Reza!
Awesome demonstration of how to make the most of this new control! The only thing I feel might be missing (just my personal take) is the option to customize the column headers titles, since I usually prefer using abbreviated field names when I’m developing. ⭐⭐⭐⭐⭐ for you.
@@RezaDorrani You may have an idea. I made the change and it works perfect in my development environment but when I go to production the modern table control stops working. Any idea? Thank you in advance.
Unfortunately I had problems with this modern table control when filtering data. When I select a filter option, it seems the table rendering is not updating. As an example, if I choose something that would return no data to my table control, it shows the text "no data found", that background image that appears when no data is found but the rendering of the table control shows all records... And it's funny because it also shows 0 (zero) records in the bottom label...
I always enjoy your content, Reza. Have you worked with large datasets, over the 2000 record limit? How did you overcome that limit? Any delegation issues?
Thank you for this overview. This control is really new, very 'young' but already powerfull to display tabular datas. Furthermore it is finally accessible ! (gallerys used as tabular datas are not) Do you think that column filters will be released soon ? What about the GA of this control ? When ?
Incredibly helpful. Just looking for something last week and here is your video. Thank you so much! Q: I tried building something similar but instead of Dataverse I am using SharePoint with 5000+ records. I have implemented Filters on Items property of Table control. I am having issue as no data loads because of the filters. As soon as I remove filters all data loads fine. Any thoughts on this. Thanks
As always, excellent content. I would like to know how to apply a filter to a table to show all records if a user email is present in any of the fields, including in person groups that have multiple approvers from a Sharepoint list.
Really appreciate your work and have learnt a lot. One question - How to highlight rows based upon conditions. I can see some rows highlighted in the video.
Hi Reza, I have one doubt, you have added two variables for width and font in the app formula property and used the variables in their respective screen properties, can't we directly add switch function in the width and fontsize properties?
Didn't know that we can set column width of modern table table control. 👍 If I only we can add buttons on each line, similar to a gallery, that would be perfect.
You can select an item in Table control and then light up buttons to take action. I have shown that in my other TABLE controls videos. I will recommend checking those.
@@RezaDorrani There is a button added to each row in Power Apps Editable Grid using Gallery & Modern Controls (2023). th-cam.com/video/76RJyaoW0BQ/w-d-xo.html But I can't see how to add a "View" button to each row in the Modern Table control.
Thanks so much for the tutorial! very useful and @RezaDorrani, just wondering if there is any good "export to excel" function that can be used in power apps? Thanks heaps!
The dynamicTableColWidth formula is fantastic. I have a really hard time with screen height and responsive screens. Like if I have a form in the main container and I display it on a smartphone, instead of the main container growing it height, it stays the same and puts a scroll bar so you have to scroll to see what is in the container, annoying! I'm wondering if the idea you are using with the dynamicTableColWidth could be used for container height as well? Wondering also if you can have a dynamic screen height as well. Any thoughts on that? If there is a video on this, please let me know. If not, please consider making one. Thanks for all you do for the community. Also, do you do consulting? If so, please let me know.
Thank you so much Chef, you really were cooking ! Much appreciated. I wanted to ask that how do I make people from a team/group in sharepoint only be able to view and edit things that are for their teams only, say for instance a ticketing tool, members from payments or technical must view and edit tickets for their department only
Great Tips and Tricks thank you.... it appears I'm able to add lookup fields from Dataverse however the value is not visible, is this a limitation for table controls?
Awesome Video as always. Have you tried adding related table columns into the table control? When I tried to add the lookup columns, it started loading super slow. My use case requires morethan one look up columns.
I have not tried to do that. You should not see performance impacts for dataverse. I did a video on multiple related table controls. You can check that one out.
Thank you for this excellent demonstration, Reza. I would like to just confirm the general reason for choosing a table control (as opposed to a gallery). With a table control, you can't select a record, and then navigate to a screen to edit that record (with a form, let's say) -- is that correct? It isn't possible to select a record with the table control, right? So really, it's only for viewing data -- correct?
Hi Reza, Thanks for such an amazing video. I have an issue with formula column. I have added a formula column in my table (using if statements and choice column). The formula column works perfectly fine. But when I deploy the solution to Production environment, it given me as error for the formula column. Can you please suggest me the solution to this issue?
I have not faced any issues with it, hence not sure of the cause or fix for it. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, thanks for sharing. But do you know if you can make a selection from one of the rows and open a form (view/edit mode). I can see that there is a "OnSelect" option for the Table property but I am not sure how to use it.
Raza- The options for the column within the table, there is a selection "FieldType" with some text in it. So far I found "E","A","s". What do these mean and do you know where I could find more info? Thanks.
Thank you for this video, it was very helpful. However, I am using SQL table as data source for my Power apps. The table has over 5 million rows. I need to create several cascading combo-boxes with an option to export the results to excel. However the distinct option on combo box only returns one value. IS there a workaround for this, or can you suggest a different way to work with large dataset?
I have not tried with SQL but distinct is NOT a delegable function with any data source. Exporting to excel is again not a feature that power apps would be ideal for, specifically with millions of rows. Power Auto would be a better option for that.
Hi, I am trying to add sort (Ascending/Descending) on each column. However, it has not appeared by default on the table when I add one. Is that a setting? Also is it possible to have searchable feature inside a column header?
Hi Reza, in the new modern "Table" "preview" the total rows count area is always shorter than the table width which cause the background color show if you have a background on the screen causing inconsistence in the view of the displayed table, is there a way to prevent the total rows from displaying? or is possible to make the width of this area the same as the table?
Can you show how to implement the toggle for the left menu in the modern control? When I followed your old tutorial on how to show/hide the left menu using a canvas app starting with the Page Design/Sidebar, it worked, but not as I expected. It only affects the Leftbar Component and not the Sidebar Container. :( I want to create a design something like an admin dashboard with toggle menu on the side. how can I do that here in modern control in powerapps?
I don’t plan to revisit the old video with new toggle control. I don’t remember running into any issues with it. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Is it possible to add a checkbox for selecting multiple records and add the submit button with chaging the state from draft to pending approval? How will it be possible to filter records vs. users' department? That should be the default records for the users?
@@shineremanan5523 It is not a supported feature. Im not sure if there is a workaround. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, how we can add checkboxes for every row? After checking checkbox want save record ids somewhere to use further. Can you please help me on this. Thanks
Is it possible to use the modern table control to format a currency column? I have a currency column with SharePoint lists but can't seem to format it in the same way I can with a standard data table. I noticed you have done this in your video, but you were using Dataverse.
The sort (Ascending/Descending) now appears on modern table. Within that same drop down, there is greyed out options called 'Filter by'. How do we get that activated?
The video also shows SharePoint list (check last 5 mins of video) 90% of my videos are on SP lists. Subscribers asked to add more Dataverse content and hence the shift.
Hello Reza, i need an clarification. In this Table modern control with Sharepoint as a datasource can you tell me why are not displayed the complex fields , for example People column? It;a a bug aot Microsoft does not implemented yet? i choose a people column but the content of the column is not displayed.
Hi Reza, I seem to have a problem where the column sorting doesn't function at all. My table "items" is a filtered collection which came from filtered data from a SharePoint List. I would appreciate any insight.
I am using the table control and attached it to a form on another screen with a variable with the selected row. But if i come back to the table screen without submiting or saving the form, it keeps the row selected and i am not able to click that row again and go back in. I have to click some other row and come back and click the row which i wanted to. Do you know about this issue. I tried to refresh connection but it doesn't work.
When you navigate back to screen where table control is present, on visible of screen, set a variable value to false and then set same variable to true. Filter table control items property using the variable. This will clear the current selection.
You don’t need to load all that data. Check my videos on delegation. As user scrolls through gallery or table, it will load the data as needed (efficient and performant)
I created a collection from a sharepoint list and used that collection in the items property of modern table and the sorting does not work. Even if you create a table in the items property the sorting does not work. If you use addcolumns to create a new calculated column the sorting does not work. Any idea on this or any workaround?
Thanks for sharing sir, hopefully power app teams on microsoft can improve their product special for modern table control, add feature searching per column, can add action on row table, multi selection data (purpose for delete selection data), i don't know ya, if my position on selected table.. then i move to other action selected table is missing, different with gallery if my position on selected gallery, and if move to other action my selected gallery it's still on position.
1 - the modern table control is the same for both teams and power apps. 2 - multi-selection, per column searching are not current features 3 - on select does work. My next video will show it in action
Another question: When connecting to a SharePoint list, is it possible to have a column in the Modern Table Control that will display multiple selections from a choice column in the SharePoint list? When I select "Allow multiple selections" in the SharePoint list, the column in the Modern Table Control becomes completely blank and shows nothing.
The documentation for the modern table control says that it has an OnSelect property, but here is the bug myself (and others online) have found with that: it will not allow you to select the same record two times in a row. For example, in testing I have only one record in my SharePoint list. OnSelect of the table I have: Set(varRecord, RecordsTable.Selected); Navigate('Record Form Screen'). Works fine the first time. When I navigate back to the gallery, I cannot select the record again. There is no way to "reset" the table. If I have more than 1 record in the table and I had selected the first record, when I navigate back to the table I can select a DIFFERENT record... and then go back and select the first record after that... but never select the same record more than once. For scenarios when people are viewing a record and then realize "oh wait, let me look at that again" - it's confusing when they click on the row again and nothing happens! (All that said, thank you for your awesome work, Reza - you have helped me to learn so much!!!)
When you navigate back to screen where table control is present, on visible of screen, set a variable value to false and then set same variable to true. Filter table control items property using the variable. This will clear the current selection.
@@RezaDorrani Reza saves the day! That works beautifully! (As soon as I posted my comment I realized that by clicking my refresh icon that refreshed the data source, that also cleared the gallery. I'm going to do your method though!) Thanks so much!!
@@RezaDorrani yes it works. Use If to evaluate multiple unrelated conditions. In Power Apps (unlike Microsoft Excel), you can specify multiple conditions without having to nest If formulas. It is more a question of readability, I don't think performance is improved, but it is always good to know 👍
@@RezaDorrani I think it's the collection. If the table is fed from the list, it sorts. But when I throw the list into the collection and create the table, I can't sort. Interesting
@@RezaDorrani When I setup drop-down with Choices('My Table (Views)') it shows also personal views (the one I created and saved from model driven app). Unfortunately when I select view from the drop-down list it gives me error "savedquery" with id=... does not exist.
In Modern Table how we can do every column diffrent onselect. my task is in modern table i wnat to show a column in this the ticket id this is show in a link type i wnat to when user click on that the nevigate to another screen ?. Please anyone reply.
Modern table has an onselect function. There you can check to see the metadata of selected item and accordingly write your logic with if or switch statements.
for some annoying reason my table control is showing the logical name of the column as the header and not the column name. Any idea why? Update: Actually I noticed that it happens only if I apply some filtering to the Items
would be nice if you explained why filter option is grayed out in the modern table control. Even if you use your own filters this will inevitably make users ask why the option cannot be used. Also, the search is broken because as soon as the table content refreshes, the focus jumps to the table and you must click back into the text field, now that's what I'd call rubbish UX wouldn't you agree?
Filters in table is grayed out as thats a future planned feature. The control is in preview. Possible that in next iteration the filter option is not available in grid - which would then mean I would have to explain to others why they dont see it in table.
SOS! My modern table control connected to a sharePoint list is not showing values of multiselect choice fields. values for single select choice fields are showing fine. Can't find any solution or even mention of this issue. The only solution I found mentioned Dataverse table, or Data Table control. I need help with modern table control connected to SharePoint list. Please help!!!
@@RezaDorrani Thank you. Appreciate the response. It would've been good to know such a major limitation before setting up the app. Was stupid of me not to pay attention to the two blank columns early on. Also noticed my custom person column not showing values. Though the system person fields of "created by" and "modified by" were populated.
@@RezaDorrani that may be my issue. My table is connected to a SharePoint list. Dataverse seems to be missing for me as a table creation option. I find it annoying that Power Apps allows SharePoint connection but when searching for workarounds, I don't even see it documented anywhere that Multiselect fields are not supported. That much should be mentioned at least even if a solution is not at hand.
@qudsia2343 the control is in preview. Always best to check documentation first to see if its a preview feature and always best to first test out a feature before building the entire solution around it.
In my experience the table control is bugged with sharepoint and filtering. Using a dropdown to filter the table by the selected value it just continues to append selected values to the query until you initiate a refresh(datasource), I went back to galleries.
@@RezaDorrani I understand that. I even removed all additional filtering logic and just tried to filter the modern table by the selected value in the drop down only and it still failed. It would just append additional selections from the same dropdown (meaning filter by first selected value then second, third, etc.) Occasionally it works correctly. I further tested by adding a button with OnSelect being refresh(mydatasource) and then it would update the table to filter by the currently selected value in the drop down. It was like the cache was not being recognized as altered and not "refreshing" like a gallery does when it's cache as been invalidated (idk though i'm not a pro.) I tried this both in the studio and published version of the app and it failed in the same way with simple filtering of the datasource by selected value in dropdown.
The only thing stopping me from using Table Control is not formatting the numbers properly. It shows 7602.18 as 7602.18000000000. That is a major drawback. Even the Classic Control Data Table has the same problem. I am using Gallery instead because it gives me more control. However, it is too much effort to maintain.
@@RezaDorrani I had the same problem with this, text looks blurry by default. However when I resize the browser window or try to zoom in, the text won't be blurry anymore.
It's a true disaster, it neither refreshes after filtering nor sorts correctly. Yet another disappointment from MS. Unfortunately, within our company, MS Power Platform is the sole avenue available for non-IT employees to create the tools they require.
I agree with the sorting issue. If the modern table directly references the data source then sorting works. If you set items property of modern table to a collection it does not sort. Really strange issue.
Jam packed with a ton of information, tips, and tricks. Yes this video is about modern Table control, but it also shows how to use named formulas, screen size, create views, add filters within views, filter out views, formula columns, color code the information displayed, and a lot more… No surprise you are amongst the best in the business.
Wow! Thanks so much.
Your summary is way better than my video description.
Once again, very useful information on Modern table control. Thank you Reza for sharing this video.
Glad it was helpful!
Today i learned modern table control, filter functionality, search functionality, Responsive design handling. Thanks Reza for your support on technology
You are most welcome!
Thank you, Reza, for such clear and precise explanations. I try to watch your videos every day, and they've become a part of my daily routine. I feel like I wouldn't have been able to improve at PowerApps development without these tutorials. I truly admire your work!
You are very welcome and thank you so much for watching and learning from my videos.
i really like this "Tips and Tricks" video style as it gives you more insight about things you may already have ideas about. Good to see how the Modern Table control can be used but even better are the tips around screen sizing, dynamic font and size manipulations and view filters plus powerfx in tables etc. Excellent demo and more of these, please. Thanks for sharing.
I’m happy to hear your feedback on this format. I will plan for more like this.
Absolutely brilliant, detailed and very clear instructions. Thank you.
Glad it was helpful!
Thanks for another great video @reza, loved it. This helps me knowing what's possible and I can suggest these to my clients.
Thanks Sudhir and very happy to know this can help customers
Very excellent information about modern tables control and dataverse tables view it will be very very useful to us Thanks a for sharing with us. 😊
You are most welcome
Looks like a superior version of “galleries”. If so, I think this is the missing piece that will tie together a crucial project I’m mapping out. So excited. Thanks, Reza!
Both Table and Galleries have their uses.
I have started using the table control more and more.
Excellent information. Thank you for putting the work into these.
You’re most welcome
Excellent! Thank you sir!!!
You are most welcome!
Awesome demonstration of how to make the most of this new control! The only thing I feel might be missing (just my personal take) is the option to customize the column headers titles, since I usually prefer using abbreviated field names when I’m developing. ⭐⭐⭐⭐⭐ for you.
Column header titles can be changed! There is a headertext property available for that.
@@RezaDorrani You may have an idea. I made the change and it works perfect in my development environment but when I go to production the modern table control stops working. Any idea? Thank you in advance.
@@W.Wallace73 I have not experienced any issue with modern control and specific environment types
Another great video! Thanks, Reza.
You're most welcome
Unfortunately I had problems with this modern table control when filtering data. When I select a filter option, it seems the table rendering is not updating. As an example, if I choose something that would return no data to my table control, it shows the text "no data found", that background image that appears when no data is found but the rendering of the table control shows all records... And it's funny because it also shows 0 (zero) records in the bottom label...
Not something I have come across.
Thank you, Reza, for such an informative presentation. Does this new table have "ThisItem" variable like in the gallery?
Most welcome!
It does not.
I always enjoy your content, Reza. Have you worked with large datasets, over the 2000 record limit? How did you overcome that limit? Any delegation issues?
I have worked with large data and as shared in video, as long as the query is delegable, Table control will automatically handle it.
Love your videos!
Thank you so much
Thank you for this overview. This control is really new, very 'young' but already powerfull to display tabular datas. Furthermore it is finally accessible ! (gallerys used as tabular datas are not)
Do you think that column filters will be released soon ? What about the GA of this control ? When ?
Happy to hear the positive feedback on the control.
I am not aware of ETA for filter options or GA date.
Incredibly helpful. Just looking for something last week and here is your video. Thank you so much!
Q: I tried building something similar but instead of Dataverse I am using SharePoint with 5000+ records. I have implemented Filters on Items property of Table control. I am having issue as no data loads because of the filters. As soon as I remove filters all data loads fine. Any thoughts on this. Thanks
Most welcome!
I have not faced any issues with filtering and hence not sure.
Great Tips & Tricks! Do you have a video on how to add icons to the modern text box? That search icon looks really good in the search text box.
Yes, I did videos on that. Check my other TABLE control videos.
As always, excellent content. I would like to know how to apply a filter to a table to show all records if a user email is present in any of the fields, including in person groups that have multiple approvers from a Sharepoint list.
Thanks!
Filter scenario mentioned would not be a delegable query with SharePoint since IN or Search are not delegable functions.
Great video, thanks! Is there a way to add conditional formatting to the table? For example, highlight rows based on certain criteria?
Currently, No
Really appreciate your work and have learnt a lot. One question - How to highlight rows based upon conditions. I can see some rows highlighted in the video.
The highlight only works when a row is selected. Currently, there is no other option.
Very sad, I miss this functionality as well
@@marti0 the functionality never existed
Nice as always!, Just want to ask is there any trick to Freeze column like gallery does ?
I have not thought about that scenario. Dont think there is an option for it.
Hi Reza Great videos!!! With modern table control is there a way to format a date column?
Thanks!
Currently, Date column formatting is not supported
Hi Reza, I have one doubt, you have added two variables for width and font in the app formula property and used the variables in their respective screen properties, can't we directly add switch function in the width and fontsize properties?
Yes you can. But now I have started using named formulas more and more.
@@RezaDorrani ok thank you for the clarification🙂
Let's goooooooo! thanks for sharing
Awaiting feedback
Didn't know that we can set column width of modern table table control. 👍
If I only we can add buttons on each line, similar to a gallery, that would be perfect.
You can select an item in Table control and then light up buttons to take action.
I have shown that in my other TABLE controls videos. I will recommend checking those.
This is bananas!
Thanks @RezaDorrani!
@@RezaDorrani which video is that, I'm unable to find it ?
@@maayaavi Search for “table control reza”
2-3 videos will show up
@@RezaDorrani There is a button added to each row in Power Apps Editable Grid using Gallery & Modern Controls (2023).
th-cam.com/video/76RJyaoW0BQ/w-d-xo.html
But I can't see how to add a "View" button to each row in the Modern Table control.
Thanks Reza for the video. Quick question: Do we have a way to show colored labels like you used but with SharePoint?
SharePoint has calculated columns option. You could use that.
@@RezaDorrani That worked. Thanks.
Great Article Reza, as always. Do you have an idea, when Microsoft is going to enable FilterBy option in Modern Tables?
I am not aware of any ETA for filter by
Thanks so much for the tutorial! very useful and @RezaDorrani, just wondering if there is any good "export to excel" function that can be used in power apps? Thanks heaps!
Export data from apps th-cam.com/video/UZdngrwWsqA/w-d-xo.htmlsi=3R9NBdgYmTCF1XJw
The dynamicTableColWidth formula is fantastic. I have a really hard time with screen height and responsive screens. Like if I have a form in the main container and I display it on a smartphone, instead of the main container growing it height, it stays the same and puts a scroll bar so you have to scroll to see what is in the container, annoying! I'm wondering if the idea you are using with the dynamicTableColWidth could be used for container height as well? Wondering also if you can have a dynamic screen height as well. Any thoughts on that? If there is a video on this, please let me know. If not, please consider making one. Thanks for all you do for the community. Also, do you do consulting? If so, please let me know.
I have a Playlist on responsive design. I will recommend checking that out.
Thank you so much Chef, you really were cooking ! Much appreciated. I wanted to ask that how do I make people from a team/group in sharepoint only be able to view and edit things that are for their teams only, say for instance a ticketing tool, members from payments or technical must view and edit tickets for their department only
You are very welcome.
Item level permissions is what would be needed in SharePoint. Dataverse is a much better option.
@@RezaDorrani Thanks Chef 👨🍳. I will look into that
Great Tips and Tricks thank you.... it appears I'm able to add lookup fields from Dataverse however the value is not visible, is this a limitation for table controls?
Welcome!
Not sure why the value would not be visibile
@@RezaDorrani I'm now able to see the values. Thank you
Awesome Video as always.
Have you tried adding related table columns into the table control?
When I tried to add the lookup columns, it started loading super slow. My use case requires morethan one look up columns.
I have not tried to do that. You should not see performance impacts for dataverse.
I did a video on multiple related table controls. You can check that one out.
Thank you for this excellent demonstration, Reza. I would like to just confirm the general reason for choosing a table control (as opposed to a gallery). With a table control, you can't select a record, and then navigate to a screen to edit that record (with a form, let's say) -- is that correct? It isn't possible to select a record with the table control, right? So really, it's only for viewing data -- correct?
Most welcome!
You can select a record in a table control.
One of the properties it has as output is tablecontrolname.Selected
Can you please show us how to use that property?
Never mind. I found the video that shows that. I can sooooo use this in my power app! Thank you for all you do!
@@CarolLoughrey looks like you found that video
Hi Reza, Thanks for such an amazing video. I have an issue with formula column. I have added a formula column in my table (using if statements and choice column). The formula column works perfectly fine. But when I deploy the solution to Production environment, it given me as error for the formula column. Can you please suggest me the solution to this issue?
I have not faced any issues with it, hence not sure of the cause or fix for it.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Raza how to achieve the functionality of refresh button on side of drop down. Btw thanks for your amazing videos.
Side of dropdown? What should that button refresh?
Is it possible to filter in the header? I mean enable the filter in the header? And can you use SharePoint as a datasource?
My next video is on filtering data in TABLE with SharePoint.
Hi Reza, thanks for sharing. But do you know if you can make a selection from one of the rows and open a form (view/edit mode). I can see that there is a "OnSelect" option for the Table property but I am not sure how to use it.
Watch my latest video which covers this 👉 th-cam.com/video/xAQbO8COV5c/w-d-xo.htmlsi=6PM8rxzSThnw29nH
Raza- The options for the column within the table, there is a selection "FieldType" with some text in it. So far I found "E","A","s". What do these mean and do you know where I could find more info?
Thanks.
It is not documented + it does not seem to have any impact. For now, avoid it.
Thank you for this video, it was very helpful. However, I am using SQL table as data source for my Power apps. The table has over 5 million rows. I need to create several cascading combo-boxes with an option to export the results to excel. However the distinct option on combo box only returns one value. IS there a workaround for this, or can you suggest a different way to work with large dataset?
I have not tried with SQL but distinct is NOT a delegable function with any data source.
Exporting to excel is again not a feature that power apps would be ideal for, specifically with millions of rows. Power Auto would be a better option for that.
Hi Reza, is it still in preview? Or is there a schedule now of when it will be out for general availability?
Currently in preview. GA soon. Im not aware of the ETA.
Is that possible to implement the same behavior using sharepoint list instead of Dataverse or SQL? Thanks!
Possible, but there are limitations with SharePoint and table control. I have done videos where I have shown table control with SharePoint
Hi, I am trying to add sort (Ascending/Descending) on each column. However, it has not appeared by default on the table when I add one. Is that a setting? Also is it possible to have searchable feature inside a column header?
Sorting is only supported for certain column types and it also depends on the data source used. Note: table control is currently in preview
Thank you Reza
Most welcome
love-it....i learned how to select multiple controls and set their property in batches...i was just selecting the column widths 1by 1 smh!!!
That was a nice trick!
Hi Reza, in the new modern "Table" "preview" the total rows count area is always shorter than the table width which cause the background color show if you have a background on the screen causing inconsistence in the view of the displayed table, is there a way to prevent the total rows from displaying? or is possible to make the width of this area the same as the table?
I dont believe we have any control over that
Thanks Reza, is there a way to change the white background for the table?
@@nabilsidrak4495 Currently, No
Can you show how to implement the toggle for the left menu in the modern control? When I followed your old tutorial on how to show/hide the left menu using a canvas app starting with the Page Design/Sidebar, it worked, but not as I expected. It only affects the Leftbar Component and not the Sidebar Container. :(
I want to create a design something like an admin dashboard with toggle menu on the side. how can I do that here in modern control in powerapps?
I don’t plan to revisit the old video with new toggle control. I don’t remember running into any issues with it.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Is it possible to add a checkbox for selecting multiple records and add the submit button with chaging the state from draft to pending approval? How will it be possible to filter records vs. users' department? That should be the default records for the users?
Currently, adding checkbox inside table control is not supported
@RezaDorrani could pls suggest how can do this now? Share video link if it is already available?
@@shineremanan5523 It is not a supported feature. Im not sure if there is a workaround.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
At 10:52 in the video when you select the sort drop down for Full Name, there is a FILTER BY option grayed out, how do you enable that ?
That is a feature planned for future. No option to enable at the moment.
Hi Reza, how we can add checkboxes for every row? After checking checkbox want save record ids somewhere to use further. Can you please help me on this. Thanks
You cannot do that currently for table control
@@RezaDorrani any other way around?
@@junedshaikh9074 Im not aware of any
Is it possible to use the modern table control to format a currency column? I have a currency column with SharePoint lists but can't seem to format it in the same way I can with a standard data table. I noticed you have done this in your video, but you were using Dataverse.
You would need to explore calculated columns in SharePoint
@@RezaDorrani Thanks. That worked.
The sort (Ascending/Descending) now appears on modern table. Within that same drop down, there is greyed out options called 'Filter by'. How do we get that activated?
Filter is a future planned feature. Currently it is disabled for everyone
It would be great if you record a video by focusing in Sharepoint list as source , please …. Thank you very much for everything!!
The video also shows SharePoint list (check last 5 mins of video)
90% of my videos are on SP lists.
Subscribers asked to add more Dataverse content and hence the shift.
Reza, Can we perform deletion/edit to the perticular record with table control?
Yes, via connected form control. Next video will show edit.
@@RezaDorrani Great, will wait for that one, Thanks much!
I have a modern table control that won’t show people picker columns (SPO), any way you can show the details of the Assignment column you have?
I tried with single select person column and it works fine on my side
@@RezaDorrani strange, I’ll try again. I also have a single select person column. What editor version are you using?
Hello Reza, i need an clarification. In this Table modern control with Sharepoint as a datasource can you tell me why are not displayed the complex fields , for example People column? It;a a bug aot Microsoft does not implemented yet? i choose a people column but the content of the column is not displayed.
Its a limitation probably. The documentation clearly calls out that this works best with Dataverse + the control is in preview.
Hi Reza, I seem to have a problem where the column sorting doesn't function at all. My table "items" is a filtered collection which came from filtered data from a SharePoint List. I would appreciate any insight.
I have not experienced any issues with sorting, hence not sure.
Only thing is that certain column types are not supported for sorting.
@@RezaDorrani Thank you. I would expect that for a collection that sits in memory all columns should be easily sorted.
@@alancrawford3563 Not all column types are supported. A collection can also have record data types.
Thanks Renza too much 🙏🙏🙏
Any time
Im not getting the flexible height and align in container options. I’m on premium capacity trial. What am I missing here? Please advise
None of that is related to licensing or capacity. You are probably not using the responsive containers.
@@RezaDorrani thank you for your prompt response, I’ll try with responsive containers. Much appreciated !
I am using the table control and attached it to a form on another screen with a variable with the selected row. But if i come back to the table screen without submiting or saving the form, it keeps the row selected and i am not able to click that row again and go back in. I have to click some other row and come back and click the row which i wanted to.
Do you know about this issue. I tried to refresh connection but it doesn't work.
When you navigate back to screen where table control is present, on visible of screen, set a variable value to false and then set same variable to true.
Filter table control items property using the variable. This will clear the current selection.
Is this also available if connected to SharePoint
Yes, check end of video
Experienced some kind of buggy behaviour with modern controls. Any experience in this regards?
May be some details around buggy behavior would help
Is there a way to align table text or icons for headers?
I don’t think so. Check in style and theme section if there is any option for it.
What is the best way to load a table with 10k+ data in a table or gallery. Is there a way that is more efficient and fast.
You don’t need to load all that data. Check my videos on delegation.
As user scrolls through gallery or table, it will load the data as needed (efficient and performant)
@reza what about the Person column from SP list? Is it currently supported? Mine is not showing anything
Im not sure if that is supported. Table control works best with Dataverse currently. Note: table control is in preview.
@@RezaDorrani Thanks. so for showing the person column from SP you still recommend doing it thorugh galleries and nested galleries?
@@AhmetGllava galleries
I created a collection from a sharepoint list and used that collection in the items property of modern table and the sorting does not work. Even if you create a table in the items property the sorting does not work. If you use addcolumns to create a new calculated column the sorting does not work. Any idea on this or any workaround?
I have not idea of a workaround for it. May be sorting is not supported for collections at the moment. Control is in preview.
Thanks for sharing sir, hopefully power app teams on microsoft can improve their product
special for modern table control, add feature searching per column, can add action on row table, multi selection data (purpose for delete selection data),
i don't know ya, if my position on selected table.. then i move to other action selected table is missing, different with gallery
if my position on selected gallery, and if move to other action my selected gallery it's still on position.
1 - the modern table control is the same for both teams and power apps.
2 - multi-selection, per column searching are not current features
3 - on select does work. My next video will show it in action
@@RezaDorrani
Thanks sir
Another question: When connecting to a SharePoint list, is it possible to have a column in the Modern Table Control that will display multiple selections from a choice column in the SharePoint list? When I select "Allow multiple selections" in the SharePoint list, the column in the Modern Table Control becomes completely blank and shows nothing.
I believe that is a current limitation
@@RezaDorrani Good to know! Thank you very much for the confirmation!
Can you edit data in this new Table Control?
Yes, by connecting it to a form control. Video coming on Monday.
Any trick to add Actions column in the table?
Currently, there is no option or trick I have for that
The documentation for the modern table control says that it has an OnSelect property, but here is the bug myself (and others online) have found with that: it will not allow you to select the same record two times in a row. For example, in testing I have only one record in my SharePoint list. OnSelect of the table I have: Set(varRecord, RecordsTable.Selected); Navigate('Record Form Screen'). Works fine the first time. When I navigate back to the gallery, I cannot select the record again. There is no way to "reset" the table. If I have more than 1 record in the table and I had selected the first record, when I navigate back to the table I can select a DIFFERENT record... and then go back and select the first record after that... but never select the same record more than once. For scenarios when people are viewing a record and then realize "oh wait, let me look at that again" - it's confusing when they click on the row again and nothing happens! (All that said, thank you for your awesome work, Reza - you have helped me to learn so much!!!)
When you navigate back to screen where table control is present, on visible of screen, set a variable value to false and then set same variable to true.
Filter table control items property using the variable. This will clear the current selection.
@@RezaDorrani Reza saves the day! That works beautifully! (As soon as I posted my comment I realized that by clicking my refresh icon that refreshed the data source, that also cleared the gallery. I'm going to do your method though!) Thanks so much!!
For your formula column you can do the same without nested 'if's. you can do it if(condition, result, else condition, result, else)
I dont know if there is an option like that. What’s the challenge with nested if?
@@RezaDorrani yes it works.
Use If to evaluate multiple unrelated conditions. In Power Apps (unlike Microsoft Excel), you can specify multiple conditions without having to nest If formulas.
It is more a question of readability, I don't think performance is improved, but it is always good to know 👍
I have assigned a collection to the modern table, but the sorting function in columns does not work. What is the reason for this?
I believe sorting only works with certain types of columns
@@RezaDorrani I think it's the collection. If the table is fed from the list, it sorts. But when I throw the list into the collection and create the table, I can't sort. Interesting
@@powerplatforms Table is in preview. Might very well be a limitation
How to change the logo from the header? its like your header is fillow the datasource logo
Check Header control properties. There is an option to upload image.
Here is the video th-cam.com/video/UEX4mXjxWOI/w-d-xo.htmlsi=PpoiJdzB2_ijymO9
What about personal views? Any idea?
I dont think thats an option
@@RezaDorrani
When I setup drop-down with Choices('My Table (Views)') it shows also personal views (the one I created and saved from model driven app).
Unfortunately when I select view from the drop-down list it gives me error "savedquery" with id=... does not exist.
@@Pietrasek121 Im not sure whats the issue or fix for it. I will recommend posting your query on forums at powerusers.microsoft.com/
In Modern Table how we can do every column diffrent onselect. my task is in modern table i wnat to show a column in this the ticket id this is show in a link type i wnat to when user click on that the nevigate to another screen ?. Please anyone reply.
Modern table has an onselect function.
There you can check to see the metadata of selected item and accordingly write your logic with if or switch statements.
for some annoying reason my table control is showing the logical name of the column as the header and not the column name. Any idea why? Update: Actually I noticed that it happens only if I apply some filtering to the Items
You can set your own header names for each column.
and i cann apply all that with a sharepoint list instead of DV right?
Not everything, check end of video
@@RezaDorrani thanks for the prompt reply , appreciate your work
would be nice if you explained why filter option is grayed out in the modern table control. Even if you use your own filters this will inevitably make users ask why the option cannot be used.
Also, the search is broken because as soon as the table content refreshes, the focus jumps to the table and you must click back into the text field, now that's what I'd call rubbish UX wouldn't you agree?
Filters in table is grayed out as thats a future planned feature. The control is in preview. Possible that in next iteration the filter option is not available in grid - which would then mean I would have to explain to others why they dont see it in table.
@@RezaDorrani thanks, any idea why the focus jumps to the table every time it gets updated?
@@elseb No idea
how to edit data in the table fields
By connecting it to a form control th-cam.com/video/xAQbO8COV5c/w-d-xo.htmlsi=ksUzfOrHQNjH9jZL
SOS! My modern table control connected to a sharePoint list is not showing values of multiselect choice fields. values for single select choice fields are showing fine. Can't find any solution or even mention of this issue. The only solution I found mentioned Dataverse table, or Data Table control. I need help with modern table control connected to SharePoint list. Please help!!!
It might not be a supported feature for table control as of now.
@@RezaDorrani Thank you. Appreciate the response. It would've been good to know such a major limitation before setting up the app. Was stupid of me not to pay attention to the two blank columns early on. Also noticed my custom person column not showing values. Though the system person fields of "created by" and "modified by" were populated.
@qudsia2343 setting up which app?
Video mainly covers dataverse which is what the table control currently works best with.
@@RezaDorrani that may be my issue. My table is connected to a SharePoint list. Dataverse seems to be missing for me as a table creation option. I find it annoying that Power Apps allows SharePoint connection but when searching for workarounds, I don't even see it documented anywhere that Multiselect fields are not supported. That much should be mentioned at least even if a solution is not at hand.
@qudsia2343 the control is in preview. Always best to check documentation first to see if its a preview feature and always best to first test out a feature before building the entire solution around it.
In my experience the table control is bugged with sharepoint and filtering. Using a dropdown to filter the table by the selected value it just continues to append selected values to the query until you initiate a refresh(datasource), I went back to galleries.
How to Filter SharePoint List Data in Power Apps TABLE Control | Multiple Filters
th-cam.com/video/IhfBPKY8tqc/w-d-xo.html
@@RezaDorrani Yep, i followed that, still bugged. Copy the same code to a gallery and it works no problem.
Check the whole video again. I am able to run the App with no issues (Published version of app)
@@RezaDorrani I understand that. I even removed all additional filtering logic and just tried to filter the modern table by the selected value in the drop down only and it still failed. It would just append additional selections from the same dropdown (meaning filter by first selected value then second, third, etc.) Occasionally it works correctly. I further tested by adding a button with OnSelect being refresh(mydatasource) and then it would update the table to filter by the currently selected value in the drop down. It was like the cache was not being recognized as altered and not "refreshing" like a gallery does when it's cache as been invalidated (idk though i'm not a pro.)
I tried this both in the studio and published version of the app and it failed in the same way with simple filtering of the datasource by selected value in dropdown.
@lechium02 this may have to do something with your setup. I cannot guess what your issue is without reproducing it.
The only thing stopping me from using Table Control is not formatting the numbers properly. It shows 7602.18 as 7602.18000000000. That is a major drawback. Even the Classic Control Data Table has the same problem. I am using Gallery instead because it gives me more control. However, it is too much effort to maintain.
Try checking if the formatting trick I showed in video helps for that scenario
Why my data in table control coming in faded form😮😮😮..only header of all coloumn is coming bold rest all data faded...i wonder why
Dont worry. Publish the app and check it out when in play mode.
@@RezaDorrani I had the same problem with this, text looks blurry by default. However when I resize the browser window or try to zoom in, the text won't be blurry anymore.
It's a true disaster, it neither refreshes after filtering nor sorts correctly. Yet another disappointment from MS. Unfortunately, within our company, MS Power Platform is the sole avenue available for non-IT employees to create the tools they require.
Ok
I agree with the sorting issue. If the modern table directly references the data source then sorting works. If you set items property of modern table to a collection it does not sort. Really strange issue.