Another great piece. Looks like the new Table control is quite versatile and powerful. Definitely another option to Galleries I reckon. Thanks for Sharing.
I watched your previous video about Patch function and Modern controls, I added the table and found that it worked with SharePoint so my next app was going to use that feature, though I was nervous about it since it did say "dataverse only". thank you for showing us how it works. I like these new modern controls, allows us to build neat looking layouts faster.
Hi @@RezaDorrani , i have used this with sharepoint also but i seem to be having a problem with it and the modern forms not loading in choice fields. Have you encounter this
Hi Reza is there any option to auto width of the Columns in the modern table as I've 30 columns they are shrinking I need to adjust it manually and when I restart app back to same, is there any way to do so Thank you.
Hi Reza. This is extremely helpful. Thank you again for this tutorial. One quick question, In the table I have many columns like 10-12 columns and as a result the columns are so narrowed that I can't even read the names of the columns and values. Is there a way to enlarge the columns? When I play the App, I can do that one by one but after publishing the app its going again to the narrowed version. Is there a to permanently enlarge the columns? Thanks
@@RezaDorrani Thanks for confirming as I read the same in Microsoft blog. Also, is there an alternative as of now with same functionality? Just wondering? :? Can I use the table preview in Classic Experience? Will that give me the same functionality?
This is a great video. I am following along but I am not sure how you aligned the container within the main container that shows your form to the right of the table?
Thanks! The video is a step by step build from what I remember. May be I don’t remember :) Video description probably has link to download sample app (members only)
This is GREAT!!! Just what I needed for developing a list with dynamic columns with form views. I created this but used your tutorial for list views in the dropdown. The only issue is that I cannot seem to get a New Form to open in the form container. Just edit form pops up. I tried a CREATE NEW button with Set(varFormType, "New");NewForm(Form2), but still shows the table item. Any tips on this?
I noticed your list only option for reflow shows three fields while mine only shows two. How can I change that? BTW I just subscribed because you are by far the best tutor I could find and your ideas are so creative. please keep up the wonderful work
Thanks for the sub and the appreciation! List only showing 3 fields is an OOTB option. I did not make any specific setup. Just make sure the first 3 fields in table control has data.
Hi Reza, this is gold and i learnt so much. However, i have a question, how do you hide the edit form after you are done considering that the modern data table is not allowing you to unselect the rows? Thanks
This is a great video as I'm using this new control and it really helped. I noticed that you have a timestamp showing on your Dataverse table example, how can you format that to date only, especially if the column in Dataverse is set as date only?
Hey Reza, you're probably the best teacher ever 😊. Is there a way to include a sum here that sums up a column, even if there are more than 2000 records?
Great tutorial as always Reza. Is there a way to increase the width of the columns? I have allowed it to be scrollable but it still tries to squeeze all columns into to container, hence not readable.
Thanks so much for this Reza - this is exactly what i've been looking for - to connect with a sharepoint list. I've followed along with the entire video, however when i'm connecting the table to my sharepoint list, i keep getting an "error when trying to retrieve data from the network. the attempted operation is prohibited because it exceeds the list view threshold" Not sure how you were able to bypass this with your list being over 10,000 items...mine is around 9,000 items. So it won't show me any of the data in my table - when i connect to the old version of the data table, it allows me to see the data...but with all of the issues of not being able to see/load more than 2000 items
This boils down to delegation and handling large data with sharepoint. Indexing columns etc. I covered delegation and handling large SharePoint data in depth during the Training session - th-cam.com/users/live0nhGaQ_J278 Please note: TH-cam training sessions are only available to gold members of my channel. To check membership levels and become a members - use the following link on a desktop or laptop www.youtube.com/@RezaDorrani/join
Amazing like always ! But in my tenant business, i can connect the component table to my SharePoint List but column type choices are not supported, the values are not retrieve, may be the versionning or for the moment only available in US ? Thanks a lot Reza for this topic !
There is an issue with SharePoint complex type columns. Even in my demo - I created a calculated column that shows value of choice column and put it on the table.
Really helpful this video. One question though is how was the table layout changed automatically when the form appears and disappears. I see you used 2 containers. THanks for the response.
Thanks! Is there a way to persistently set the column sizes on the modern table item? I have observed it reverts back to original column size when the app is closed and then opened. @@RezaDorrani
Found this sooo useful! Thank you! Following on from you showing you can copy from the table into Excel, can you copy from Excel and paste into the table?
Hi Reza, Nice to explain this control ! Your knowledge help us everyday to learn new things of PowerPlatform! Very nice to show a form control when a row is selected, but how can the form be hidea after..? I want to show this form as a popup screen , but cannot a find a way to hide it...If you can give me an idea ... Thank you!
Thanks! Your question can be interpreted in 2 ways :) 1 - Do you edit your videos - Yes 2 - Did you edit out a lot on this video - No - I think I kept all the imp/necessary steps.
Great video Reza and thanks for sharing. Quick question. The table I am using from Dataverse has several lookup columns. Some are showing with the values in the rows but others display nothing. When I try to add them from the field selector, they show as custom card and dont display data. Do you know why this could be?
I've just added the source tables in the tables section in the menu on the left and the values have appeared. Strange but appears to work for now. Interestingly though, one of the fields brings up and SQL CRM error.
Greetings from Australia. Thanks - I've been keeping an eye on the Table control and it's getting there. Galleries are nice, but for simple data views time consuming to implement in some use cases and the old data grid doesn't play nicely in contrainers. My understanding is that end users should be able to sort and filter directly from the column headers without the need to code it as you have done here. The hover arrow is there on the column header but it doesn't seem to do anything. It will be great when that is implemented. PS - Better luck next time 😁on the cup
Great video Reza! Thank you so much! One question: Can this table have the feature of adding new rows where use can copy and paste into the new row? The scenario i am thinking of is this table would be perfect to have as my line item source and have it be right under my main header table form that uses data from another table. The end goal I want to do is to Patch the data from the header form and table (line item) to its respective dataverse tables using one button. i.e. Submit.
@@tutanekai55 Check documentation on how to change auth version of app. Ive shown it in some videos. Do not remember which. Version numbers keep getting updated. Just pick the latest available.
First off I love your videos. Very helpful. As it relates to this table control...how do you export the entire data in the table to a flow to be exported to Excel? Unlike a gallery control, there doesn't appear to be a way to Extract All to a flow to create an Excel File to be downloaded? How can I export all my filtered table data to a flow?
Idea would be to not export either table or gallery data as both would run into delegation challenges. Best option would be as shown in this video - th-cam.com/video/UZdngrwWsqA/w-d-xo.html
@@RezaDorrani Thanks, that helped. On another note, I have a date field called Closed Date and it is empty until the case is closed. However, for closed date default the Table Control is showing a random date instead of blank?? FYI, this is a Dataverse Table Date ONLY field. I want the field to show blanks and not the default date that seems to be there.
@@RezaDorrani I implemented your suggested video...however I have another issue I'm hoping you can help me with. I want to disable the export button when the NEW Modern Control Table doesn't have any items in it. There doesn't appear to be a property to use like the gallery to determine if items exists in the table...unless I'm missing it somewhere?
@@MarkSmith-338-gd7jp Modern table currently does not. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, I like the way you demonstrate the features with examples. I have to build Applications to insert/update Azure SQL server database data. Can I leverage the very same approach you demoed here or is there any specific videos you have already published.
Hi Reza. This is awesome. You usually demo your development process showing the steps. Could you do the same here please? Like adding another container and connecting to form etc. Thanks a lot!
Control is in preview. So too early to talk about performance. However modern controls are designed to be faster from a rendering standpoint. What data source I connect to, how many columns, delegation etc. all play a key role in performance irrespective of it being a gallery or a table
Hi Reza, Thanks for the wonderful insights gained from your videos, on this particular video, I can't seem to get the detailed steps to line up the canvas to include all the containers, is there a more detailed steps video that walkthrough adding all the other containers and form? Kind Regards
Hi Reza Awesome video but I have a question with regards to SharePoint lists in the modern table. How did you in your example have columns that have choices or are they just text fields that look like choices? I created a SharePoint list for my app but the data in my choice columns is not displaying anything?? I noticed that each data card is labeled as Custom and if I select the Table from the Tree View / Custom Card Name / Dropdown / Field Type - they are all of type "s". Can this be changed to a different type to read from SharePoint or is there another way to read in the SharePoint data?
Thank you for replying, Reza. I hope Microsoft add the support for SharePoint as there are a lot of smaller companies that we develop apps for and Dataverse is not viable for their budgets or use cases. Until then, I am following your other tutorial on Responsive Gallery as a table with column filtering.
Thanks for your great video, Reza! One question, How should I initialize Form you mentioned in 10:30 ? I'm trying to do the same but there is no timing to EditForm.
Hi Reza, greay video! Does the modern data table work with all column types when using a sharepoint list as a datasource? Im experimenting with it now but it doesnt seem yo pull through values on choice colums or created by
Another fantastic video, thanks for sharing. One question though, if you add more than one filter criteria the filter query needs to have even more conditions right?
@@RezaDorrani Thank you for your comment. Thanks for confirming that gallery filtering logic can be used at table as well. I want to be able to fulter upto 5 columns and filtering should apply only if they are selected. Conditional (if ) criteria are only way right? Which would mean a lot of conditions.
Hi reza great video once again. Regarding data verse tables, does security/permissions get taken into account.? E.g a user will only be able to see records they have permissions to see or will we have to code in filters to the apps based on signed in user
Can we add buttons to this powerapps table control as a column, this is a very good video, I have been following you for a long time and your videos are gold
Table control has no option for buttons but you can tie a toolbar control to it as shown here th-cam.com/video/FUVjkPnRsfg/w-d-xo.htmlsi=w4foYb92vupfWx61
Hi Rena, do you know a way to allow a word wrap in a column for this table control? I have a column with a longer string I would like to wrap. Love this control!
Hi Reza, its me again. 13:26 - whats the equivalent function for 'in' when the backend is a SharePoint. I am getting a aoft warning ⚠️ on delegation when used on my SharePoint list based modern template.
Hi Reza, I found another video of yours where you have done filter and search on SharePoint being the database and I find '=' being shown as delegable.. doesn't it equate to 'in' on the dataverse table. Sorry for multiple questions I just wanted to be sure.
@@kedar910 Not sure how in and equals are the same. Sorry but it has been a while since I did these videos, so don’t remember the context. I would recommend posting your query/issue on forums at powerusers.microsoft.com
Great video Reza.. I have created a modern table with an on select > navigate to take it to an edit form for the selected record, but everytime i return to the table screen it automatically sends me right back to the edit form, seems like it auto selected the last table row i clicked.
It is a known bug. Better option for now is to use the toolbar control as shown in this video th-cam.com/video/FUVjkPnRsfg/w-d-xo.htmlsi=1veS6P5LMtBZgqIO
Hi Reza, almost of your video is about connecting directly to Sharepoint. However, in fact we normally would block user from accessing data source. So, could you please do a tutorial about using powerautomate to integrate data between apps and data source? With best practice to structure data flow well.
You normally block users from accessing data sources - So how do users connect to data? I want to let you know that this is certainly not normal. I have no plans to make a video on topic to integrate data between apps and flows as it is definitely not a pattern used by many.
@@RezaDorrani Oh I see, Actually, I often settle Sharepoint list as data source, and using power Automate as a transportation to bring data into Powerapps and back to list. If I share the sharepointlist to them, it means that they can access and see the database (I work in HR field). So, that's why I normally did as I mention (using the flow which the keys are "Response" and "Send HTTP request".
@Reza This is very good and easy to create a table view. But I am facing a problem here , for example if I have let say more than 20 columns which I want to show here , in this case it is showing very small length where we can not read the complete column title and I did not find the solution for this. Can you please suggest how can I do this ?
@@RezaDorrani Yes I can change it manually. Like if I run the app and then I am able to change it. But when I closed and reopen it is still the same. I need to do it again for all the 20 columns . Is it possible to fix that in develpment it self so that when it runs it show with proper size with a scroll bar ?
Reza, great stuff. I can see this offering a great deal of flexibility to filter larger record libraries (document libraries). Do you have any references or pointers to how we would incoporate this table on top of a document library - and open the underlying document on click ?
Hi Reza, thanks for the video. I'm struggling with sort option. It doesn't seems to work at all when you use collections instead of direct connection to datasource. Have you experienced the same problem?
Hi Reza. Big thanks! I have built my first app with the help of your videos. Now, I am making some design changes to it. Following your video above, is it possible to adjust row height of a table connected to a SharePoint list, please? If I am not mistaken, I saw some folks achieved this, but couldn't find how to do it.
hey Reza, thanks for you video is very informative, Microsoft Automate change the edit layout, I can't build a flow from a Form to Sharepoint List, can you do a video to guild us pleas.
Most welcome! I have a few ideas in my backlog. Not sure which one I would do next so no guarantees. You can always revert to old flow editor by adding &v3=false in url
Helo Reza, Great Video. I have a problem with this control. I have an SQL Table and I don't know how to show the Value of the foreign table instead of the foreign ID number. Do you know if it is possible to do this with an SQL database? THANKS FOR THE HELP!
I have not done any work with sql table and hence not sure of how I can help. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Huge fan of your videos! I am new to the Dataverse world, but when I add a dataverse table to a modern table, I only get 2 columns ("title" and created on) When I add a choice column, everything goes blank - is that something you or anyone reading this has come across?
@@RezaDorrani I was previously at "Bronze level and could not perform any type of "Upgrade" (from within TH-cam). So, I cancelled, thinking I could rejoin at a higher level, but now I am unable to do that either. Now stuck.
Incredible video, it is helping me enormously. Is there any possibility to edit the table directly in grid mode? Copy and paste multiple cells or just edit each one directly? I'm testing a SharePoint list and I can only display the table in view mode 😢
Hi Reza, just wanted to ask if you've tried using a date in the table and were you able to hide the time when showing data in the table. I have a dataverse date only column but it still shows 12:00 AM on all my dates
can you show how you made the second header looking Container where you put the filtering? I made another header_Container but not sure how you have placed the filter text, dropdown etc.
Hi Reza, which would be better - the PowerCAT Details List or this modern table control in terms of stability in prod environment? The PowerCAT Details list has a lot of customization available though.
PowerCAT list is custom component. This is out of the box control. Out of the box one would be a preferred option but you are free to choose based on your needs.
Hey Raza, Thank you for the valuable video. I dont have the similar preview version of this table control. I also have modern table control but it is completely different than the one that you have been using in this video. I have turned it on from the upcoming features section. do you know what could be the issue? Thanks in advance
Is it possible to combine this with your graph api search to make full string searches possible in sharepoint lists? I just can't explain not being able to offer full text search (and we have more than 10k items in that project list)
@@RezaDorrani To view the side form, you use the selected item in the container view, something like "!IsBlank(PowerAppsOneGrid1.Selected)". But in the video the only way you used to close the form container was through submitForm. I'm trying to add a close icon to this form container to close it (and not just use submitForm to close the form container). Is there a way to clear "PowerAppsOneGrid1.Selected" by clicking a button without necessarily using the submitForm?
Hello Reza, can we apply validation on the data table columns similar to excel and highlight the incorrect cell data? if yes, would like to know how it can be achieved? Thanks :)
Hi! I found a problem using containers, when a set a header container and I insert a header or a table, I can't modify its size, it's static different like your video. do you know what I should change in order to enable the custom size using the cursor?
Reza, how do you change the Date format in a table control? My Dataverse table has DateTime with DateOnly configuration but in a table control, I see the date plus 12:00:00 AM. I couldn't figure out a way to get rid of the time part (althought DV doesn't have this value)
@@RezaDorrani Thanks for the confirmation. I was going in circles trying to figure out. I hope this is something the team considers as option/improvement, especially since it is taking lots of real estate. Thanks again.
This is gold. Another one in my bookmark list. Thank you so much Reza for this invalulable knowledge.
Most welcome and thanks so much for watching
Power Apps just keeps getting better and better.
I agree
Thanks Reza - you are the first reference if I need to get information about Power Platform.
Amazing. This opens the door to lots of opportunities for canvas apps
Thanks
Another great piece. Looks like the new Table control is quite versatile and powerful. Definitely another option to Galleries I reckon. Thanks for Sharing.
Most welcome and thanks for watching.
Awesome video Reza… this will save huge efforts and time for developers working on gallery with more than 15 columns
I agree
Thanks Reza. Time to upgrade my Apps to Modern controls.
👍
Another fantastic video Reza. Waiting when this would be available in canvas apps. Superb work
Very soon!
Thank you. It was very useful.
Glad to hear it!
I watched your previous video about Patch function and Modern controls, I added the table and found that it worked with SharePoint so my next app was going to use that feature, though I was nervous about it since it did say "dataverse only". thank you for showing us how it works. I like these new modern controls, allows us to build neat looking layouts faster.
Awesome! I am super happy to hear that
@duncan - You used this on Canvas app with SharePoint as your data source?
@@sankhlayashraj Yes. Video shows both Dataverse and SharePoint
@@sankhlayashraj Yes, SharePoint, our company will not pay premium for anything.
Hi @@RezaDorrani , i have used this with sharepoint also but i seem to be having a problem with it and the modern forms not loading in choice fields. Have you encounter this
Really great tutorial, a gem
Thank You
Hi Reza is there any option to auto width of the Columns in the modern table as I've 30 columns they are shrinking I need to adjust it manually and when I restart app back to same, is there any way to do so
Thank you.
Currently, the table control is in preview. I don't think there is an auto width feature.
Table control is in preview. I'm not aware of a way to fix this at the moment.
Another fantastic video Reza. Waiting when this would be available in canvas apps. Superb work❤
Very soon!
Always brilliant. Thanks Reza ⚡⚡⚡⚡
Most welcome and thanks so much for watching
Thanks so much Reza. This is fantastic!
Most welcome and thanks for watching
Reza you are GREAT !!!
Thanks
Thanks Guruji for another valuable input
Most welcome
Reza is just fantastic! Thank you!
Most welcome!
Hi Reza... This new control looks awesome. Let me give it a try. I am sure we can use collections as well. As always 👍
Works with collections
Awesome content as always
Thanks
Thank you Reza. Bookmarking this
Welcome and thanks for watching
Hi Reza. This is extremely helpful. Thank you again for this tutorial. One quick question, In the table I have many columns like 10-12 columns and as a result the columns are so narrowed that I can't even read the names of the columns and values. Is there a way to enlarge the columns? When I play the App, I can do that one by one but after publishing the app its going again to the narrowed version. Is there a to permanently enlarge the columns?
Thanks
I believe that’s currently a bug. Please note the control is in preview
@@RezaDorrani Thanks for confirming as I read the same in Microsoft blog. Also, is there an alternative as of now with same functionality? Just wondering? :? Can I use the table preview in Classic Experience? Will that give me the same functionality?
@@anuragdhamija7201 Alternative is to build a collection but I would not recommend that as it would result in delegation challenges
Great knowledgeable video...
Thanks a lot
This is a great video. I am following along but I am not sure how you aligned the container within the main container that shows your form to the right of the table?
Thanks!
The video is a step by step build from what I remember. May be I don’t remember :)
Video description probably has link to download sample app (members only)
Hi Reza, Thanks for another great section of learning. I would like to ask how we can reset the selection for this table control.
Table currently does not have a reset property. Only way to reset is by initiating a reload of the items property. Not something I have tried.
This is GREAT!!! Just what I needed for developing a list with dynamic columns with form views. I created this but used your tutorial for list views in the dropdown. The only issue is that I cannot seem to get a New Form to open in the form container. Just edit form pops up. I tried a CREATE NEW button with Set(varFormType, "New");NewForm(Form2), but still shows the table item. Any tips on this?
Video description has link to download entire solution. I would recommend grabbing the link from community tab.
I noticed your list only option for reflow shows three fields while mine only shows two. How can I change that? BTW I just subscribed because you are by far the best tutor I could find and your ideas are so creative. please keep up the wonderful work
Thanks for the sub and the appreciation!
List only showing 3 fields is an OOTB option. I did not make any specific setup. Just make sure the first 3 fields in table control has data.
Great video Reza. Would you know how to display dates in UK format though, with the modern data table control? - Thanks.
I believe currently the table control does not support formatting
Hi Reza, this is gold and i learnt so much. However, i have a question, how do you hide the edit form after you are done considering that the modern data table is not allowing you to unselect the rows? Thanks
I believe I was resetting the table control by setting a variable to false and then true and using that variable to filter the items of table
This is a great video as I'm using this new control and it really helped. I noticed that you have a timestamp showing on your Dataverse table example, how can you format that to date only, especially if the column in Dataverse is set as date only?
Thanks!
Currently, formatting options are not available.
thanks Reza, this is awesome
Most welcome
Hey Reza, you're probably the best teacher ever 😊. Is there a way to include a sum here that sums up a column, even if there are more than 2000 records?
Wow! Thanks so much!
Sum is not a delegable function so will not work with large data sets.
Nice work Reza! Would be nice to see 'OnSelect' functionality of a record. Is that in the works?
Thanks!
Im not aware if that is in the works.
I have achived that by adding this code to the Table1 On Select property: Set(varItem,Table1.Selected); I hope it helps 👍
Great tutorial as always Reza. Is there a way to increase the width of the columns? I have allowed it to be scrollable but it still tries to squeeze all columns into to container, hence not readable.
There is a known issue with column widths.
@@RezaDorrani Yeah, I figured. I ended up using creator kit's fluent details list. Thank you for your quick response Reza.
Thanks so much for this Reza - this is exactly what i've been looking for - to connect with a sharepoint list. I've followed along with the entire video, however when i'm connecting the table to my sharepoint list, i keep getting an "error when trying to retrieve data from the network. the attempted operation is prohibited because it exceeds the list view threshold" Not sure how you were able to bypass this with your list being over 10,000 items...mine is around 9,000 items. So it won't show me any of the data in my table - when i connect to the old version of the data table, it allows me to see the data...but with all of the issues of not being able to see/load more than 2000 items
This boils down to delegation and handling large data with sharepoint. Indexing columns etc.
I covered delegation and handling large SharePoint data in depth during the Training session - th-cam.com/users/live0nhGaQ_J278
Please note: TH-cam training sessions are only available to gold members of my channel.
To check membership levels and become a members - use the following link on a desktop or laptop www.youtube.com/@RezaDorrani/join
Amazing like always ! But in my tenant business, i can connect the component table to my SharePoint List but column type choices are not supported, the values are not retrieve, may be the versionning or for the moment only available in US ?
Thanks a lot Reza for this topic !
There is an issue with SharePoint complex type columns. Even in my demo - I created a calculated column that shows value of choice column and put it on the table.
Really helpful this video. One question though is how was the table layout changed automatically when the form appears and disappears. I see you used 2 containers. THanks for the response.
Table automatically changes layout based on real estate available. I added a form container and show/hide it based on table item selection.
Thanks! Is there a way to persistently set the column sizes on the modern table item? I have observed it reverts back to original column size when the app is closed and then opened. @@RezaDorrani
@@chrisadriano3461 Currently no option for that
Found this sooo useful! Thank you!
Following on from you showing you can copy from the table into Excel, can you copy from Excel and paste into the table?
Welcome!
Currently, you cannot copy from excel to table.
Awesome Reza Sir!
Thank You
Great Work
Advantages / Disadvantages with respect to Galery
Covered that in my training video for gold members 😉
There are plenty.
@@RezaDorrani How i can access it?
@@v75tan You would need to be a gold member. To upgrade membership - support.google.com/youtube/answer/6304294?hl=en&co=GENIE.Platform%3DDesktop
Hi Reza, Nice to explain this control ! Your knowledge help us everyday to learn new things of PowerPlatform! Very nice to show a form control when a row is selected, but how can the form be hidea after..? I want to show this form as a popup screen , but cannot a find a way to hide it...If you can give me an idea ...
Thank you!
When table is reset (via filters) form gets hidden.
I love your videos. Do you edit out a lot on this video?
Thanks!
Your question can be interpreted in 2 ways :)
1 - Do you edit your videos - Yes
2 - Did you edit out a lot on this video - No - I think I kept all the imp/necessary steps.
Great video Reza and thanks for sharing. Quick question. The table I am using from Dataverse has several lookup columns. Some are showing with the values in the rows but others display nothing. When I try to add them from the field selector, they show as custom card and dont display data. Do you know why this could be?
Not sure about that
@@RezaDorrani Thanks anyway Reza
I've just added the source tables in the tables section in the menu on the left and the values have appeared. Strange but appears to work for now. Interestingly though, one of the fields brings up and SQL CRM error.
@@jameshart9519 Control is in preview
Greetings from Australia.
Thanks - I've been keeping an eye on the Table control and it's getting there. Galleries are nice, but for simple data views time consuming to implement in some use cases and the old data grid doesn't play nicely in contrainers. My understanding is that end users should be able to sort and filter directly from the column headers without the need to code it as you have done here. The hover arrow is there on the column header but it doesn't seem to do anything. It will be great when that is implemented.
PS - Better luck next time 😁on the cup
Greetings to aussies 😊
We will meet in the next world cup 😉
Yes the sort is shown which is a giveaway of whats to come. Good things to come.
Great video Reza! Thank you so much! One question: Can this table have the feature of adding new rows where use can copy and paste into the new row? The scenario i am thinking of is this table would be perfect to have as my line item source and have it be right under my main header table form that uses data from another table. The end goal I want to do is to Patch the data from the header form and table (line item) to its respective dataverse tables using one button. i.e. Submit.
The Table control is currently read-only.
@@RezaDorrani Thanks Reza!
Thanks Reza. Great video as always. Have you had any trouble displaying dataverse lookup fields within the table?
New authoring version of app should have it fixed.
What is the 'New authoring version' and how do i get access to it? Thanks in advance@@RezaDorrani
@@tutanekai55 Check documentation on how to change auth version of app. Ive shown it in some videos. Do not remember which. Version numbers keep getting updated. Just pick the latest available.
First off I love your videos. Very helpful. As it relates to this table control...how do you export the entire data in the table to a flow to be exported to Excel? Unlike a gallery control, there doesn't appear to be a way to Extract All to a flow to create an Excel File to be downloaded? How can I export all my filtered table data to a flow?
Idea would be to not export either table or gallery data as both would run into delegation challenges. Best option would be as shown in this video - th-cam.com/video/UZdngrwWsqA/w-d-xo.html
@@RezaDorrani Thanks, that helped. On another note, I have a date field called Closed Date and it is empty until the case is closed. However, for closed date default the Table Control is showing a random date instead of blank?? FYI, this is a Dataverse Table Date ONLY field. I want the field to show blanks and not the default date that seems to be there.
@@RezaDorrani I implemented your suggested video...however I have another issue I'm hoping you can help me with. I want to disable the export button when the NEW Modern Control Table doesn't have any items in it. There doesn't appear to be a property to use like the gallery to determine if items exists in the table...unless I'm missing it somewhere?
@@MarkSmith-338-gd7jp Modern table currently does not.
I would recommend checking or posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Hi Reza, I like the way you demonstrate the features with examples. I have to build Applications to insert/update Azure SQL server database data. Can I leverage the very same approach you demoed here or is there any specific videos you have already published.
Thanks!
Yes, similar pattern can be applied.
@@RezaDorrani okay, great. Thank you !
Amazing !!! How can we maintain the history of the changes done?
Ideally you would do that in your data source settings. Dataverse has auditing, SharePoint has versions.
Hi Reza. This is awesome. You usually demo your development process showing the steps. Could you do the same here please? Like adding another container and connecting to form etc. Thanks a lot!
I did not do it here because I did not want to reinvent the wheel. I have done that in many other videos. Same steps apply here.
Thank you Reza for Sharing, So Many Time Saved with This Demo.
One small Question, In terms of Performance, is this control better than a gallery?
Control is in preview. So too early to talk about performance. However modern controls are designed to be faster from a rendering standpoint.
What data source I connect to, how many columns, delegation etc. all play a key role in performance irrespective of it being a gallery or a table
Hi Reza, Thanks for the wonderful insights gained from your videos, on this particular video, I can't seem to get the detailed steps to line up the canvas to include all the containers, is there a more detailed steps video that walkthrough adding all the other containers and form? Kind Regards
As a channel member (gold or silver) - you can download the entire solution. Link in community tab.
This video is the only reference I have.
Hi Reza
Awesome video but I have a question with regards to SharePoint lists in the modern table. How did you in your example have columns that have choices or are they just text fields that look like choices?
I created a SharePoint list for my app but the data in my choice columns is not displaying anything??
I noticed that each data card is labeled as Custom and if I select the Table from the Tree View / Custom Card Name / Dropdown / Field Type - they are all of type "s".
Can this be changed to a different type to read from SharePoint or is there another way to read in the SharePoint data?
🗒️ Table control is in Preview.
Currently type cannot be changed. I believe mine were text columns and calculated columns.
Thank you for replying, Reza.
I hope Microsoft add the support for SharePoint as there are a lot of smaller companies that we develop apps for and Dataverse is not viable for their budgets or use cases.
Until then, I am following your other tutorial on Responsive Gallery as a table with column filtering.
@@JoeAtWork-gy4wh They will but control is in preview for now. We have to wait.
Thanks for your great video, Reza!
One question, How should I initialize Form you mentioned in 10:30 ?
I'm trying to do the same but there is no timing to EditForm.
Timing to form?
Form default mode is edit.
Onsuccess of form submit, I simply reset the form
@@RezaDorrani Got it! Thanks Reza!
it's a great video !!
Can we integrate table control with gallery control? In my case, I want to have a check box for each row in table control!!
Thanks!
I have not tried integrating it with gallery so not sure.
Hi Reza, greay video! Does the modern data table work with all column types when using a sharepoint list as a datasource? Im experimenting with it now but it doesnt seem yo pull through values on choice colums or created by
It does not work with complex type columns. Its a known limitation.
@@RezaDorrani Thanks for the quick reply! I'll keep an eye out on the development to check for when complex types work :)
@@hackmo From what I know, it wont be soon
Another fantastic video, thanks for sharing. One question though, if you add more than one filter criteria the filter query needs to have even more conditions right?
More filters means more filter criteria. I have done numerous videos on gallery filtering.
@@RezaDorrani Thank you for your comment. Thanks for confirming that gallery filtering logic can be used at table as well. I want to be able to fulter upto 5 columns and filtering should apply only if they are selected. Conditional (if ) criteria are only way right? Which would mean a lot of conditions.
@@sreeponn Yes it would but I have done plenty of videos on that.
@@RezaDorrani thanks for your response! I will look them up! Thank you!
Hi reza great video once again. Regarding data verse tables, does security/permissions get taken into account.? E.g a user will only be able to see records they have permissions to see or will we have to code in filters to the apps based on signed in user
Security is respected.
Thanks for the video. Does modern control table support images? 🤔
Currently it does not support images
brilliant lecture
Thanks
Can we add buttons to this powerapps table control as a column, this is a very good video, I have been following you for a long time and your videos are gold
Table control has no option for buttons but you can tie a toolbar control to it as shown here th-cam.com/video/FUVjkPnRsfg/w-d-xo.htmlsi=w4foYb92vupfWx61
Hi Rena, do you know a way to allow a word wrap in a column for this table control? I have a column with a longer string I would like to wrap. Love this control!
Currently, it does not support wrap
Hi Reza, its me again. 13:26 - whats the equivalent function for 'in' when the backend is a SharePoint. I am getting a aoft warning ⚠️ on delegation when used on my SharePoint list based modern template.
IN is not a delegable function with SharePoint. There is no workaround for it.
@@RezaDorrani ok thanks.. I will post back if I find anything
Hi Reza, I found another video of yours where you have done filter and search on SharePoint being the database and I find '=' being shown as delegable.. doesn't it equate to 'in' on the dataverse table. Sorry for multiple questions I just wanted to be sure.
@@kedar910 Not sure how in and equals are the same. Sorry but it has been a while since I did these videos, so don’t remember the context.
I would recommend posting your query/issue on forums at powerusers.microsoft.com
Great video Reza..
I have created a modern table with an on select > navigate to take it to an edit form for the selected record, but everytime i return to the table screen it automatically sends me right back to the edit form, seems like it auto selected the last table row i clicked.
It is a known bug. Better option for now is to use the toolbar control as shown in this video th-cam.com/video/FUVjkPnRsfg/w-d-xo.htmlsi=1veS6P5LMtBZgqIO
Awsome video, if I joined to Silver club, can I download the app? thanks
Yes
@@RezaDorrani great, thanks Reza....
Hi Reza, thank you for this wonderful video. just wondering, how did you make the department field on your form control a dropdown?
It automatically did that probably because it was a Choice column
Great video Reza. My only question is will this work with managed meta data?
Probably not
That sucks. If it did it would solve many problems. 😎@@RezaDorrani
@@MrBond249 I rarely use that column
Hi Reza, almost of your video is about connecting directly to Sharepoint. However, in fact we normally would block user from accessing data source. So, could you please do a tutorial about using powerautomate to integrate data between apps and data source? With best practice to structure data flow well.
You normally block users from accessing data sources -
So how do users connect to data?
I want to let you know that this is certainly not normal. I have no plans to make a video on topic to integrate data between apps and flows as it is definitely not a pattern used by many.
@@RezaDorrani Oh I see,
Actually, I often settle Sharepoint list as data source, and using power Automate as a transportation to bring data into Powerapps and back to list.
If I share the sharepointlist to them, it means that they can access and see the database (I work in HR field). So, that's why I normally did as I mention (using the flow which the keys are "Response" and "Send HTTP request".
@Reza This is very good and easy to create a table view. But I am facing a problem here , for example if I have let say more than 20 columns which I want to show here , in this case it is showing very small length where we can not read the complete column title and I did not find the solution for this. Can you please suggest how can I do this ?
Welcome!
I believe you can change the column width manually.
@@RezaDorrani Yes I can change it manually. Like if I run the app and then I am able to change it. But when I closed and reopen it is still the same. I need to do it again for all the 20 columns . Is it possible to fix that in develpment it self so that when it runs it show with proper size with a scroll bar ?
@@SandipMohapatra-d3d Did you try doing this in edit mode of app and then publishing?
@@RezaDorrani Yes, but in app mode there is no option to do so. I have only option to change the column manually once I run it.
@@SandipMohapatra-d3d There is an option in edit mode. Hold Alt key and do it.
Reza, great stuff. I can see this offering a great deal of flexibility to filter larger record libraries (document libraries). Do you have any references or pointers to how we would incoporate this table on top of a document library - and open the underlying document on click ?
I have done videos on document library browsing and more that leverage galleries. Similar concept would apply here.
Hi Reza, thanks for the video.
I'm struggling with sort option. It doesn't seems to work at all when you use collections instead of direct connection to datasource.
Have you experienced the same problem?
It might very well be a limitation as of now. Note: control is in preview
Hi Reza. Big thanks! I have built my first app with the help of your videos. Now, I am making some design changes to it. Following your video above, is it possible to adjust row height of a table connected to a SharePoint list, please? If I am not mistaken, I saw some folks achieved this, but couldn't find how to do it.
Row height in table control? I don’t think we have an option today
hey Reza, thanks for you video is very informative, Microsoft Automate change the edit layout, I can't build a flow from a Form to Sharepoint List, can you do a video to guild us pleas.
Most welcome!
I have a few ideas in my backlog. Not sure which one I would do next so no guarantees.
You can always revert to old flow editor by adding &v3=false in url
Helo Reza, Great Video. I have a problem with this control. I have an SQL Table and I don't know how to show the Value of the foreign table instead of the foreign ID number. Do you know if it is possible to do this with an SQL database? THANKS FOR THE HELP!
I have not done any work with sql table and hence not sure of how I can help.
I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Huge fan of your videos! I am new to the Dataverse world, but when I add a dataverse table to a modern table, I only get 2 columns ("title" and created on) When I add a choice column, everything goes blank - is that something you or anyone reading this has come across?
Thanks Kevin!
I have not come across this issue hence not sure.
Hi Reza, is it possible to do bulk operations in this modern table view?
Currently, No but coming soon
Thanks Reza, I have a question how can we select multiple rowns in if so how can we do that because currently it limited to one record.
Currently, it’s limited to one record only.
You would need to use gallery for multiple select options.
@reza Is this control still in preview or GA..? Thank you for the video.
Preview
Thank you@@RezaDorrani
This is a great work through. I have attempted to update my channel membership to download the sample but have been unable to do so.
What membership level are you at currently?
@@RezaDorrani I was previously at "Bronze level and could not perform any type of "Upgrade" (from within TH-cam). So, I cancelled, thinking I could rejoin at a higher level, but now I am unable to do that either. Now stuck.
@@RezaDorrani Update: I was able to "Re-Subscribe" ... however the option to "Change Level" is still not available (within TH-cam).
@bodynfocus check support.google.com/youtube/answer/6304294?hl=en&co=GENIE.Platform%3DDesktop
@@RezaDorrani thank you. Yes, I walked through the items on that page as well.
Hi sir, thanks for sharing.
it's possible to add function remove all the selected item on modern table control ?
I did not understand the question. Can you please reframe the question?
@@RezaDorrani do you have idea / solution for delete multiple data on modern table control ?
@@pratamar8147 Modern table control currently does not have option for multi selection
Incredible video, it is helping me enormously. Is there any possibility to edit the table directly in grid mode? Copy and paste multiple cells or just edit each one directly? I'm testing a SharePoint list and I can only display the table in view mode 😢
Thanks!
Currently, the table does not support editing in grid mode.
Does it support delegation with Sharepoint as datasource?
Yes, as long as Items property query is delegable
It is possible to add hyperlink like in classic table?
No but there is an unselect function
Hi Reza, just wanted to ask if you've tried using a date in the table and were you able to hide the time when showing data in the table. I have a dataverse date only column but it still shows 12:00 AM on all my dates
Yes, thats by design for now.
can you show how you made the second header looking Container where you put the filtering? I made another header_Container but not sure how you have placed the filter text, dropdown etc.
I have made the entire app available for members (check video description for details)
Hi Reza, which would be better - the PowerCAT Details List or this modern table control in terms of stability in prod environment? The PowerCAT Details list has a lot of customization available though.
PowerCAT list is custom component. This is out of the box control.
Out of the box one would be a preferred option but you are free to choose based on your needs.
Hey Raza, Thank you for the valuable video. I dont have the similar preview version of this table control. I also have modern table control but it is completely different than the one that you have been using in this video. I have turned it on from the upcoming features section. do you know what could be the issue? Thanks in advance
What’s different in your version?
Well done 👏 It would be great to be able to edit data in batches. Do you think it is possible in such a scenario?
Thanks!
Table control is currently read only.
Is it possible to combine this with your graph api search to make full string searches possible in sharepoint lists?
I just can't explain not being able to offer full text search (and we have more than 10k items in that project list)
Should be possible but not something I have tried.
Full text search is NOT an option with SharePoint.
Dataverse or SQL is the answer to that.
Congratulations on the video, one question, is there a way to clean the selected item?
I ask if we added a close button in the form's container view.
What does clean an item mean?
@@RezaDorrani To view the side form, you use the selected item in the container view, something like "!IsBlank(PowerAppsOneGrid1.Selected)". But in the video the only way you used to close the form container was through submitForm.
I'm trying to add a close icon to this form container to close it (and not just use submitForm to close the form container).
Is there a way to clear "PowerAppsOneGrid1.Selected" by clicking a button without necessarily using the submitForm?
@@wellingtonnalmeida6794 Ahh. So reset the table. Im not sure if it supports reset behavior
@@RezaDorrani Thank you for the immediate response Reza. I added a refresh to the database in the button event and it worked perfectly.
Hi is it possible to customized the header and do a similar feature with sharepoint?
Table control works with SharePoint as well.
Header customization options are limited.
thanks Reza but how do you show column names at top of the gallery in SharePoint list scenario
You mean Table? You simply pick the columns you want to show.
Do you know how to change the date format in the new tables? Mine is currently displaying in US and I cant figure out how to get it into uk
Currently, changing display formats is not supported
Hello Reza, can we apply validation on the data table columns similar to excel and highlight the incorrect cell data? if yes, would like to know how it can be achieved? Thanks :)
The Table control is currently a read-only control.
Hi!
I found a problem using containers, when a set a header container and I insert a header or a table, I can't modify its size, it's static different like your video. do you know what I should change in order to enable the custom size using the cursor?
I have not experienced this problem so not sure
so this works for sharepoint list as well ? for canvas app
Yes, shown in video
Which is better for fast editable table on powerapps ? Sharepoint or dataverse?
Dataverse
You're the best.
Thanks so much
Reza, how do you change the Date format in a table control? My Dataverse table has DateTime with DateOnly configuration but in a table control, I see the date plus 12:00:00 AM. I couldn't figure out a way to get rid of the time part (althought DV doesn't have this value)
Changing format for table control is currently not supported
@@RezaDorrani Thanks for the confirmation. I was going in circles trying to figure out. I hope this is something the team considers as option/improvement, especially since it is taking lots of real estate. Thanks again.
@@alisalih101 It definitely will be an option
Hi Reza, How can I get the form to appear with more width so that it takes half the screen instead of how you have it on the right end side? Thanks
There are different layout options available. Split screen you could use.
Or simply update width for container.