A very informative and insightful tutorial on the modern table control. A feature rich option to use in certain use cases instead of always leaning on the Gallery. Thanks for sharing, Reza.
Brilliant video again Reza. So helpful. One of the only downsides I have found in using the table control is that it displays dates such as 'created on' and 'modified on' in the American format rather than uk format.
The modern table has a problem...upon scrolling more than 25 rows at once in list view mode loses the current selection field...you have any workaround for this?
Hi Reza, when you modified the Items property of the table, does the native sorting feature, EnableSorting set to "yes", still work? Can the table still be sorted by the columns?
Thanks alot Reza, love your work... by any chance is there a workaround to insert the attachment column in this table control where the user can launch the attachment link and it will open in a new browser?
Thanks for this, Reza! For the list reflow behavior, I'm unable to change the color of the dropdown arrow as well as the font and button colors within the dropdown. Is this possible?
Great Tutorial!!.. I have a question, when sorting the table, I get this message "400 Error when trying to retrieve data from the network. The $orderby expression muste evaluate to a single value of primitive type". It happens to look up columns only. Is there a way to solve it?... Thanks so much!
Thank you so much Reza, very informative video. I have been waiting to use the modern table control and the only thing that keeps me away fro musing it is that I cannot add for example a button to do a certain action on the selected record. This is the only reason that keeps me using the gallery control despite of all the complications of having to implement sorting and other usability issues. Any ideas on how to use a table AND have possibility to have a button with some action attached to it? I dont see it possible at the moment.
Thank you Reza for your reply! Quick question : If I'm using the Modern controls and Themes in Power APPs, and I have Master and Detail table. To show the detail table only those records which is selected in Master, what should I use? If I have ID as PK in both the tables, how can can I do it?
Thank you, Reza, for creating this informative video. I have a question regarding the Table modern control: Can we change the display property of a specific column? For example, if we have a datetime column in the Dataverse table, can we configure it to display only the date and not the time? If you could provide an answer to this question, it would greatly assist me.
As usual - a great video with clear and concise explanations. But, when I tried this display idea for related Dataverse tables - once I added a search upon the related records (as you did with rdProjects for the sake of a search box) - all data became none visible, although you can tell by the rows, that the Search is done 🤔?!
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
Thanks for this video Reza. Is there a way to join related tables in one table (like an inner join)? For example, I have created a View on two related Dataverse tables, but when linking the Table and its View to a Modern table on Canvas App, it does not allow to select the related table columns - only the main table. Do you know if this is a limitation on the Modern Table in Canvas App?
Hi Reza, if i use the "OnSelect" property for modern table to navigate to the second screen and use the "Back" to return after submit it cause a looping and the first screen navigate to the second screen, i noticed that you used button to navigate and not the "OnSelect" property of the table to avoid the looping, is there a way to use the "OnSelect" for navigation? thanks
For searching, when you added the search function on items property of Table you did not get any delegation warning. When i tried, it is showing delegation warning. Any idea?
I had the same issue. I wasn't able to set the Search function on the Project panels. Hope you'll make a video to show us how to troubleshoot it @RezaDorrani
I found this vid (ua-cam.com/video/lYi24okXDPs/v-deo.html) but it's the (old) problem that's supposed to happen with SP lists. No idea why it happens to Dataverse dtb
Hi Reza! Thank you for this great video! Question: When I use the modern table control, it does not display the data in choice columns for me. Why is that? How can I fix it? (I'm running this app and the Dataverse table in Teams.) Could it have something to do with the "global choice" selection? I'm not clear on what "global choice" is for or how to use it.
Hi Reza, Thanks again for this video but I have another question. Is it possible to increase the default size of the table above 25? i.e. the pagination occurs at 25 items.
Hi Reza thanks for the video! I'm having a problem tho, tha table rows sometimes are not updated even if the filtering/searching is correctly done (the row number on bottom sx shows the right number). Any idea on what could possibly cause the problem? thanks!
Thanks for the great content! I'm facing an issue with Modern Table Control where, even with a visibly selected record in a table, the Selected property sometimes returns empty. I've tried solutions like refreshing the data source, using variables, and recreating the table, but the problem persists. What could be causing this, and how can I fix it?"
@@RezaDorrani I see. To explain my case a bit better: I have a Modern Table connected to a collection that filters records from a SharePoint list. I also have a form connected to the same list. I have a 'New' button that creates a new form if no item is selected or pre-fills the form if an item is selected from the table. There's also an 'Edit' button that opens the form in Edit Mode and a 'Delete' button. Over time, I noticed that when selecting a record in the table using Table.Selected, whether directly or by setting a variable in the OnSelect property of the table, nothing happens - it doesn't recognize the selected record. The interesting part is that in the same list, some records work fine (showing the selected record), while others don't. After many tests, I realized the issue occurs when I use the scrolling feature of the Modern Table. As long as I don’t scroll, the record selection works normally. I’ve read in some comments that it might be an issue with SharePoint as a data source, while others suggest it could be a bug in the current version. I’m not sure if there’s anything else I can do to figure out what's happening or if it’s just a bug, and I should give up and try another solution...
Great tutorial! When I add the search input, it doesn’t allow the sorting of the table to function properly anymore. Even though it says the sorting is enabled, it just doesn’t work anymore. Any ideas why this is happening? I’m using a share point list as a data source.
@@RezaDorraniI mean once I create the search capability, it completely removes the sorting functionality altogether. I am unable to sort anymore, even if I am not searching in that instance, even if I click “ascending” or “descending” on the table.
Reza, I am experiencing the same issue as @DanielBitters. When the 'Items' property references a list, i.e., ListName, the sorting functionality works. As soon as I add search, i.e, Search(ListName, SearchInput.Text, field1, field2), to the 'items' property, the sorting no longer works. I can select "ascending" or "descending" in the table, but the order of the items in the table does not change. @DanielBitters, were you able to resolve the issue? Thank you for such amazing content!
Hey! I am dealing with the table and I noticed that I am not being able to show date only (without time). I have configured a column in dataverse with date only, and I expect the column to only show the date also (without time). Have you figured out somehow to achieve this? Thanks!
Hi Reza, everything is great and your video helped me a lot, I got a problem though. Let say that at the beginning my table got only one record. I used the OnSelect property of the table to open a container where I got the form to edit data. Problem is that when I close the side container to go back to the table I can't re-open the edit form container, because the record is already selected and doesn't respond anymore to the OnSelect event and so far I didn't find any solution to this. Any Idea how could I solve this?
When you close the side container- you can set a variable to false and then set that same variable to true. Then use that variables as filter on items property of table.
@@RezaDorrani First, thank you for your kind reply! Sorry but don't know if I right understood but, when I close the container (I mean, when I set Visible = false) I set variable Set(var_test, false); Set(var_test, true); one after the other. But in the items property of the table (considering that is a collection) how can I use it? I mean I tried with Filter(, var_test) but of course doesn't work.
@@RezaDorrani doing this the second time because apparently didn't save my answer. Anyway I'm using a collection and there is no problem about delegation because record will be top 20-30 no more, and mostly I'm using it because I make use of those default SharePoint fields like "Created", "Modified".. date field that I can't format with dd/mm/yyyy so I wrote the following code ClearCollect(cl_activity_project, AddColumns(TPL_Internal_Project_Activities, CreateDate, Text(Created, "dd/mm/yyyy"), ModifyDate, Text(Modified, "dd/mm/yyyy"), CreatedBy, 'Created By'.DisplayName, ModifiyBy, 'Modified By'.DisplayName ) ); In any case, sorry, but the first solution you gave me, I got hard time to understand what I've to do (mostly within the items property of the table)
@@gokyo_66 Its difficult to understand on chat by looking at formulas. I would suggest you post your issue on forums in case someone has tried something similar powerusers.microsoft.com/
Another excellent video! Three questions: 1) Can I filter by a field, such as Employee ID, that is NOT included in my table, but IS included in the data source list? 2) Can I wrap text for column headings and multiple line content fields? 3) For calculated columns that are formatted both in the data source list and the form used to insert new rows to have 2 numbers after the decimal, how can I display them that way in the form? At the moment, they are displaying 14 numbers after the decimal. Thank you!!!
@@RezaDorrani, thank you for your quick reply. I am very new to Power Apps - would you have a link to another of your videos that explain using filter function on items property of table? I have many rows in my Power Apps Form table that I would like to filter by selecting an Employee ID from a drop-down. The Employee ID had to be removed from the table but it is in the underlying SP List. Once an Employee ID is selected from the drop-down, it would filter the table to show only the rows that belong to that particular Employee ID (they may have many related rows in the table). Thanks again!
Hey Reza! Thanks for the video. Have you noticed any problems with the sorting feature of this table? None of my sortings work properly. It doesnt put them in order
Hey, is it possible to display lookup column from sharepoint list (ie: If I got employee list with their manager column - lookup column to another list)? Now if try to do it I see blank fields in data type I see Complex data, and some formula in FieldType: "![Id:n, Value:s]"
Hello, thanks Reza for this video, very clear as always. One question thought, we cannot filter the columns by values ? Like in a modern driven app ? For example when is a text column using filters as "Contains Data"... ?
@@RezaDorrani Thanks for the answer but I meant natively as the grids used in Model driven apps, so as I understand it doesn't exist out of the box. We have to do them the traditional way.
Thanks a lot for this tutorial. I use a shp list (no dataverse) and when i type a value with no result (e.g. Naruto in MarvelCharactersList :) ) in the search txt input, i have a spinner running instead of 'no result'. It annoying because this user still wait for results... How can i clearly give feedback to the user that there no need to wait ?
I have done videos with sharepoint and table control as well. I dont remember running into any issues with it, hence cannot comment on what you need to do as I would have to first reproduce your issue.
@@RezaDorrani Search(myList,TXT_Search.Value,Title) If the searched string doesn't exist, the spinner remains. No pb with a filter query which display 'no result'
@@RezaDorrani Thanks Reza. My requirement is to group the Date columns by the Year and Get the Total Count (Records) and Total Sum (Amount) for contact. What would be the best approach ?
@@Arjunsuganthar921 Im not sure if there is a non-delegable option for that. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
It does sort on data > 15 items. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani the issue is with non U.S. date formats. You have to convert them to text then they can't sort correctly because of text conversion format. The modern table only shows dates in U.S format
@Reza - Wanted to check with you one thing - If I select an item in the data table, I am able to navigate the same to a page where I have a gallery. I would like to know how I can select that item in that Gallery that I have selected in the table. Also would like to know a work around to get countrows as there is a delegation issue. I understand the new table gives the count, but I would like to give a better UI to my users.
Why would you have a table for selecting and then a gallery for selecting? Sounds like duplication. Countrows is not a delegable function and Im not aware of any workarounds.
Thanks Reza for sharing this video of Modern table. This help in designing Power App using Modern Table. Just one thing i wanted to know why is filter option in Modern table disabled thanks.
Thanks for the tip about using ‘Alt’ to adjust column widths. I’ve been having the issue where column widths always revert to minimum, forcing me to constantly adjust.
so this layout does not have the capability of editing the actual table by clicking on the items , right? Seems like it only displays the values as text input and you can change it to "edit" for the data type....
Excellent timing I was looking for similar one, your videos always come as my first reference. Additionally, is it possible to edit the Heading title in modern control? If not, what is the better alternative for responsive screen?
@@RezaDorrani That's disappointing! Also I'd appreciate if you can help me understand how to control default selection in the modern table control? I am trying to run an action based on record selection. But when I write an if condition with IsBlank property it always returns false despite no record selection.
Hi Reza, is there a way to search on an already filtered data on table control. I have filtwred the table.to nly show the items belonging to the current user and i want to be able to search on rop of that.
Reza, I like all your videos. Very informative. keep up the good work! Do you have a video with multiple tables in master detail relationship in tabbed format in one form.? Can you share the video please? Many Thanks !
Is there a way to have the secondary table display different linked data depending on what you select from the primary table? Also would this work with lists?
What does different linked data mean? Currently it shows linked data depending upon the relationship. End of the day, there must be some reference with main table. Can also work with SharePoint lists - formulas wont be same though.
@@RezaDorrani so if I had two tables references from the primary, so if I clicked ‘name’ it would show all associated projects as in yours, but if I had another table with financial data could I select a separate column and display the other referenced data? Would and ‘if’ statement work with table.selected? Do you happen to know the lists formulas?
Am I right that the Modern Table is a readonly control? The control is great and it is very Excel-like control. It would be great if users can edit each field on the Table.
Reza, Thanks for sending me the link of the above Video! Much appreciated. I'm trying to do a master detail (One to many relationship) between two tables. I'm stuck on how to show the details table data for those selected in Master table when the relationship is not established in sql server. Although there are columns like ID in both master and details tables which can be joined. Can you please help?
These videos are the best references I have. I have done no work with sql so not sure how to help. I will recommend posting your issue/query on forums in case someone has done something similar powerusers.microsoft.com
Hi! Very useful info here, I've a question, how can I format to currency type a field of this table? If I have a to format a long Date to short date, how can I do it? Thanks for the help!!
With ReflowBehavior = ListOnly and ShowFooter = yes, i can see the pagination, can we make this work without all steps on your another video: Gallery pagination? TIA
@RezaDorrami, yesterday I had a not very good surprise with this control. It simply stopped to show values, with a message of "No column selected". This at an app scheduled to be released next week. I opened a support ticket and the answer was that this control is still under preview, and that there is nothing they can do to solve it.
Check this post which explains about preview vs GA www.microsoft.com/en-us/power-platform/blog/power-apps/ga-of-many-long-time-preview-features/ I have not experienced any issues with table control recently. Have also not seen any customers report this.
Hi, I have a task to create 360 feedback tool in Powerapp application. Can you show us how to develop one? I tried to use the list to create the Q forms but how to send the forms for stakeholders to answer and give feedback and how to analyze the results.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
I am unable to wrap the text of table headers, which causes the column widths to adjust unnecessarily and increases the table's length. Are there any solutions
Great video thank you for all. Power apps has come a long way with these modern controls 👏🏼👏🏼 but there are some bugs and missing features hope they all will be solved soon
Hi That is really helpfull content but one more question when we are adding lookup column in modern table control it will not works getting blank column why is that?
Apparently the "DelayOutput" property is gone, Text Input now has a property called "Trigger output", if you set it as "Delayed" it gives you the same behavior. Cool video, Reza. :)
Here is my statement : 'data_prospector.DP_UserSummary'.Selected.'data_prospector.DP_UserDatabaseList' in the formula for items for the detailed sidebarContainer Somehow it is not liking the "Selected" as a valid property or function. My intention is to access the selected row of the DP_UserSummary' table, to get to the details of Dp_UserDatabaseList It i also not liking the '.' (dot operator ). Can you help me to resolve it ?
The modern table control becomes blurry, if the browser is in full screen mode (scale to fit is ON for the app), and only becomes clear if i resize the window manually to hide the grey margins around the app. Is there a way to solve this? Thanks!
@@RezaDorrani Thanks Reza, hopefully it fixes itself :) How can i format a number field as percentage? Is there a way to do it? Love your vods!! The field type is "n" and im not sure how to tell it to convert to %.
The only thing i wish you did in these videos is show the full process not only the front end but how you defined and related the backend of the project. I'm noticing a real lack of back end content related to power apps on youtube.
The backend can be any data source of your choice. I have done multiple videos on table control and tried connecting with SharePoint, Dataverse and collections. These are more of how to videos focused on a specific topic. I share the entire code base including the data source with channel members (check video description for details)
Hello! This video is really helpful for someone like me whose a beginner in powerapps. However, I'm struggling to insert the data table inside the container. Wheneve I tried to insert it, the data table is shows as a new screen. Please help. Thank you
I have not come across this issue. Video shows step by step how I add the control into container. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thank you so much! Really this video is very helpful. Can i ask another question? For the side container, I only what to view the selected items? What can i do? Thanks
@@RezaDorrani yes. I think i figured why is it happening. My data source is sharepoint and the search query gives delegation warning. Hence the sorting on modern table fails to work
Thanks for the video and the good explanations, but there is something I don't get, why making a video and promoting something that is in preview and that might be fundamentally changed before GA? For example the property "Selected" has been removed from the table even though it is still in the documentation. Maybe because it was never working properly and it was always returning an incorrect value.
Thanks, Reza. The edit function keeps giving the error "Network error when using patch function: An Error occurred on the server." Just to let you know that I am using SharePoint List
I have not come experienced this issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Great video! I was super excited when Microsoft added the table control, but it still has too many issues to be used. The column widths don't stick, row heights can't grow, column names don't change, and there are too many scenarios that result in the table values appearing fuzzy. I think I've narrowed the fuzzy issue to laptop screens and screens that aren't run at the recommended setting. For example, I have 4k monitors and if I run them at 1080p the table data gets fuzzy and hard to read. They also don't work well with custom canvas resolutions. Hopefully, Microsoft will continue to develop the table control because it would be a great addition. For now, the gallery is probably the better approach depending on the use case.
This gets me part way, but I really need someone to model multiple tables in a header/detail line fashion. In this tutorial you have two forms and two tables, but it's not a parent/child table relationship and I need to find something like that. Not sure if that's something you could model here or if anyone knows of resources for that type of powerapp. I've been scouring the tutorials and haven't seen anything to really explain that process.
I do not have a video reference on this. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Actually, I stumbled on your 'Editable Grid' series which looks like I may be able to extrapolate what I need from. But thank you, I will also check the forum.
Most welcome! Look like ur ask is on a completely different topic. My rule for topic suggestions is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post”
My rule for topic suggestions is set - "Every 6-8 months I ask for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets max votes, I will add the topic to my backlog"
I was looking for a solution where data feed is from 2 different lists. This video is spot on. THANK YOU so much
Glad it helped!
Thank you Reza. You always hit the nail on the head. Thanks for sharing your knowledge. It shall be well with you and yours.
Much appreciated! Thanks a lot
A very informative and insightful tutorial on the modern table control. A feature rich option to use in certain use cases instead of always leaning on the Gallery. Thanks for sharing, Reza.
Glad to hear that! Thanks so much Doug
Brilliant video again Reza. So helpful. One of the only downsides I have found in using the table control is that it displays dates such as 'created on' and 'modified on' in the American format rather than uk format.
Thanks!
Formatting of data in table control is currently not an option.
Great video as always Reza! Nice to see them adding in sorting & styling to the modern table control.
👍
Hi, Thanks. At 8:50 you connect the two tables but guessing you are using Dataverse. How can this be done with other data sources like SharePoint?
ua-cam.com/video/1Qsf2RPyp8s/v-deo.htmlsi=LUnLqJZAB4PVXXhO
The modern table has a problem...upon scrolling more than 25 rows at once in list view mode loses the current selection field...you have any workaround for this?
The control is in preview and does have its challenges at the moment. This is one of them. I do not have a workaround for it.
@@RezaDorrani np. Thanks Reza.
@@RezaDorrani, How about today, is there any solution for the problem of scrolling and losing the current selection field on Modern Table Control?
@@alefefreitas2128 Control is still in preview. I am not tracking to see if this feature has been updated.
@@alefefreitas2128 Control is still in preview. I am not tracking to see if this feature has been updated.
Thank you Reza, this is perfect! You're the best 😁😁
I'm glad you like it
Hi Reza, when you modified the Items property of the table, does the native sorting feature, EnableSorting set to "yes", still work?
Can the table still be sorted by the columns?
It can still be sorted as far as I know.
Best to give it a shot and check.
Note: the control is still in preview
Thank you Reza for the video.... would you recommend the use of preview modern controls in production? 🤷♂
As long as it meets your requirements then why not?
Godd info, as always... but when I implement the search, Modern Tables sorts no longer work... any ideas?
It is a preview feature + works best with dataverse
Thanks alot Reza, love your work... by any chance is there a workaround to insert the attachment column in this table control where the user can launch the attachment link and it will open in a new browser?
Currently, that is not an option.
Thanks for this, Reza! For the list reflow behavior, I'm unable to change the color of the dropdown arrow as well as the font and button colors within the dropdown. Is this possible?
I dont think we have an option to change that.
Great Tutorial!!.. I have a question, when sorting the table, I get this message "400 Error when trying to retrieve data from the network. The $orderby expression muste evaluate to a single value of primitive type". It happens to look up columns only. Is there a way to solve it?... Thanks so much!
Sorting does not support all column types. Check documentation for table control.
Thank you so much Reza, very informative video. I have been waiting to use the modern table control and the only thing that keeps me away fro musing it is that I cannot add for example a button to do a certain action on the selected record. This is the only reason that keeps me using the gallery control despite of all the complications of having to implement sorting and other usability issues. Any ideas on how to use a table AND have possibility to have a button with some action attached to it? I dont see it possible at the moment.
Check my latest videos on table control. Specially my video on modern toolbar control.
Thank you Reza for your reply!
Quick question :
If I'm using the Modern controls and Themes in Power APPs, and I have Master and Detail table. To show the detail table only those records which is selected in Master, what should I use? If I have ID as PK in both the tables, how can can I do it?
Im not sure how I can help on chat.
I will recommend posting your issue on forums in case someone has done something similar powerusers.microsoft.com
This is exactly what I'm looking for. Thank you, Reza! Great Video.
Most welcome
Thank you, Reza, for creating this informative video. I have a question regarding the Table modern control: Can we change the display property of a specific column? For example, if we have a datetime column in the Dataverse table, can we configure it to display only the date and not the time? If you could provide an answer to this question, it would greatly assist me.
Most welcome!
Currently, there is no option to format the display behavior of a column.
As usual - a great video with clear and concise explanations.
But, when I tried this display idea for related Dataverse tables - once I added a search upon the related records (as you did with rdProjects for the sake of a search box) - all data became none visible, although you can tell by the rows, that the Search is done 🤔?!
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Great video helped me a lot!!
I do have a question is it possible to format the columns in the table to currency?
Most welcome!
I showed 1 hack to format in this video ua-cam.com/video/CVmjxMp79W0/v-deo.htmlsi=05cAn-yBnmFuFiWa
Hello Reza!Is there any way to directly edit data entry from the table?Thank you!
Currently, Table control is ready only.
For editing via grid, check my playlist on grid control
Thanks for this video Reza.
Is there a way to join related tables in one table (like an inner join)? For example, I have created a View on two related Dataverse tables, but when linking the Table and its View to a Modern table on Canvas App, it does not allow to select the related table columns - only the main table.
Do you know if this is a limitation on the Modern Table in Canvas App?
I have not tried this but my guess is it may very well be a limitation
Thank you Reza. Really great and informative video. A true master.
Thanks so much
Hi Reza, if i use the "OnSelect" property for modern table to navigate to the second screen and use the "Back" to return after submit it cause a looping and the first screen navigate to the second screen, i noticed that you used button to navigate and not the "OnSelect" property of the table to avoid the looping, is there a way to use the "OnSelect" for navigation? thanks
I have not used unselect for navigation.
Table control is in preview and it may very well be a bug that's auto navigating.
@@RezaDorrani thank you for the quick response, i think it is a bug, i was just wanted to see if someone else experiencing the same issue.
For searching, when you added the search function on items property of Table you did not get any delegation warning. When i tried, it is showing delegation warning. Any idea?
My data source is Dataverse and I am searching on text columns.
I had the same issue. I wasn't able to set the Search function on the Project panels. Hope you'll make a video to show us how to troubleshoot it @RezaDorrani
@@Coco-lr1sc I have no plans for a follow up video on this topic
I found this vid (ua-cam.com/video/lYi24okXDPs/v-deo.html) but it's the (old) problem that's supposed to happen with SP lists. No idea why it happens to Dataverse dtb
Hi Reza! Thank you for this great video! Question: When I use the modern table control, it does not display the data in choice columns for me. Why is that? How can I fix it? (I'm running this app and the Dataverse table in Teams.) Could it have something to do with the "global choice" selection? I'm not clear on what "global choice" is for or how to use it.
Im not aware of any limitations for DV4T
Thanks Reza! Do you know when the "filter by" column options are going to be activated?
I am not aware of the "Filter By" timeline
Hi Reza,
Thanks again for this video but I have another question.
Is it possible to increase the default size of the table above 25? i.e. the pagination occurs at 25 items.
Currently, the default pagination size cannot be changed
Hello, is there a way to change for example row background color? Lets say priority is critical and i want it to highlight the row?
Currently, this is not a supported feature.
Hi Reza thanks for the video! I'm having a problem tho, tha table rows sometimes are not updated even if the filtering/searching is correctly done (the row number on bottom sx shows the right number). Any idea on what could possibly cause the problem? thanks!
Video description has details on how to download entire solution (you can check all the logic I used in it)
Thanks for the tutorial. Would you be comfortable to use the preview controls in Production apps? Maybe if the apps are not mission critical?
Yes I would be as long as it meets my requirements.
Thanks for the great content! I'm facing an issue with Modern Table Control where, even with a visibly selected record in a table, the Selected property sometimes returns empty. I've tried solutions like refreshing the data source, using variables, and recreating the table, but the problem persists. What could be causing this, and how can I fix it?"
I haven't encountered this issue, hence not sure of the cause or fix for it.
@@RezaDorrani I see. To explain my case a bit better: I have a Modern Table connected to a collection that filters records from a SharePoint list. I also have a form connected to the same list. I have a 'New' button that creates a new form if no item is selected or pre-fills the form if an item is selected from the table. There's also an 'Edit' button that opens the form in Edit Mode and a 'Delete' button.
Over time, I noticed that when selecting a record in the table using Table.Selected, whether directly or by setting a variable in the OnSelect property of the table, nothing happens - it doesn't recognize the selected record. The interesting part is that in the same list, some records work fine (showing the selected record), while others don't.
After many tests, I realized the issue occurs when I use the scrolling feature of the Modern Table. As long as I don’t scroll, the record selection works normally. I’ve read in some comments that it might be an issue with SharePoint as a data source, while others suggest it could be a bug in the current version.
I’m not sure if there’s anything else I can do to figure out what's happening or if it’s just a bug, and I should give up and try another solution...
@@alefefreitas2128 Im not sure either. Key thing to note is the Table control is in preview. Might very well be a bug.
@RezaDorrani Thank you for your attention!
Great tutorial, curious how you avoided the delegation warning for the search box warning though.
Search is a delegable query with Dataverse
@@RezaDorrani Yet another reason I can use to justify licensing dataverse 😆
Great tutorial! When I add the search input, it doesn’t allow the sorting of the table to function properly anymore. Even though it says the sorting is enabled, it just doesn’t work anymore. Any ideas why this is happening? I’m using a share point list as a data source.
After you search the sorting will be lost. User would need to sort again.
@@RezaDorraniI mean once I create the search capability, it completely removes the sorting functionality altogether. I am unable to sort anymore, even if I am not searching in that instance, even if I click “ascending” or “descending” on the table.
I have not experienced that issue
Reza, I am experiencing the same issue as @DanielBitters. When the 'Items' property references a list, i.e., ListName, the sorting functionality works. As soon as I add search, i.e, Search(ListName, SearchInput.Text, field1, field2), to the 'items' property, the sorting no longer works. I can select "ascending" or "descending" in the table, but the order of the items in the table does not change.
@DanielBitters, were you able to resolve the issue?
Thank you for such amazing content!
Hey! I am dealing with the table and I noticed that I am not being able to show date only (without time). I have configured a column in dataverse with date only, and I expect the column to only show the date also (without time). Have you figured out somehow to achieve this? Thanks!
That is a current bug
@RezaDorrani thank you! I tried a lot of Things yesterday to get that working but it's a deal breaker, I will set up a normal table. Thanks again!
Great video! I noticed the disabled filter option on the column headers, is there a way to use these or is an incoming feature?
Most probably an incoming feature
Clean and Simple. Great vid Reza 👍👍
Thanks
Hi Reza, everything is great and your video helped me a lot, I got a problem though. Let say that at the beginning my table got only one record. I used the OnSelect property of the table to open a container where I got the form to edit data. Problem is that when I close the side container to go back to the table I can't re-open the edit form container, because the record is already selected and doesn't respond anymore to the OnSelect event and so far I didn't find any solution to this. Any Idea how could I solve this?
When you close the side container- you can set a variable to false and then set that same variable to true.
Then use that variables as filter on items property of table.
@@RezaDorrani First, thank you for your kind reply! Sorry but don't know if I right understood but, when I close the container (I mean, when I set Visible = false) I set variable Set(var_test, false); Set(var_test, true); one after the other. But in the items property of the table (considering that is a collection) how can I use it? I mean I tried with Filter(, var_test) but of course doesn't work.
@@gokyo_66 why a collection on table? Collections are not delegable
@@RezaDorrani doing this the second time because apparently didn't save my answer. Anyway I'm using a collection and there is no problem about delegation because record will be top 20-30 no more, and mostly I'm using it because I make use of those default SharePoint fields like "Created", "Modified".. date field that I can't format with dd/mm/yyyy so I wrote the following code
ClearCollect(cl_activity_project,
AddColumns(TPL_Internal_Project_Activities,
CreateDate, Text(Created, "dd/mm/yyyy"), ModifyDate, Text(Modified, "dd/mm/yyyy"), CreatedBy, 'Created By'.DisplayName, ModifiyBy, 'Modified By'.DisplayName
)
);
In any case, sorry, but the first solution you gave me, I got hard time to understand what I've to do (mostly within the items property of the table)
@@gokyo_66 Its difficult to understand on chat by looking at formulas.
I would suggest you post your issue on forums in case someone has tried something similar
powerusers.microsoft.com/
Another excellent video! Three questions: 1) Can I filter by a field, such as Employee ID, that is NOT included in my table, but IS included in the data source list? 2) Can I wrap text for column headings and multiple line content fields? 3) For calculated columns that are formatted both in the data source list and the form used to insert new rows to have 2 numbers after the decimal, how can I display them that way in the form? At the moment, they are displaying 14 numbers after the decimal. Thank you!!!
1) Possible by using filter function on items property of table
2) Currently, No
3) No idea about this
@@RezaDorrani, thank you for your quick reply. I am very new to Power Apps - would you have a link to another of your videos that explain using filter function on items property of table? I have many rows in my Power Apps Form table that I would like to filter by selecting an Employee ID from a drop-down. The Employee ID had to be removed from the table but it is in the underlying SP List. Once an Employee ID is selected from the drop-down, it would filter the table to show only the rows that belong to that particular Employee ID (they may have many related rows in the table). Thanks again!
@@deborahjoyous I have done many videos on filtering galleries and one with table control. They are all in playlists in my channel.
@@RezaDorrani thank you - I will search those.
Hi Reza Thanks for the vid, is there any possibbility to change de default of a column? Like changing how a bollean is shown?
Currently, we cannot change the default display behavior
Hey Reza! Thanks for the video. Have you noticed any problems with the sorting feature of this table? None of my sortings work properly. It doesnt put them in order
Works on text cols only
I noticed it doesnt sort if you use a collection. will only sort on direct datasource
@@Chaddcl0ps813 The control is in preview. It will have limitations.
Hey, is it possible to display lookup column from sharepoint list (ie: If I got employee list with their manager column - lookup column to another list)? Now if try to do it I see blank fields in data type I see Complex data, and some formula in FieldType: "![Id:n, Value:s]"
I believe currently it's not supported. Support for all column types to release soon.
@@RezaDorrani Thank You very much for quick response!
Hello, thanks Reza for this video, very clear as always. One question thought, we cannot filter the columns by values ? Like in a modern driven app ? For example when is a text column using filters as "Contains Data"... ?
ua-cam.com/video/IhfBPKY8tqc/v-deo.html
@@RezaDorrani Thanks for the answer but I meant natively as the grids used in Model driven apps, so as I understand it doesn't exist out of the box. We have to do them the traditional way.
Thanks a lot for this tutorial. I use a shp list (no dataverse) and when i type a value with no result (e.g. Naruto in MarvelCharactersList :) ) in the search txt input, i have a spinner running instead of 'no result'. It annoying because this user still wait for results... How can i clearly give feedback to the user that there no need to wait ?
I have done videos with sharepoint and table control as well. I dont remember running into any issues with it, hence cannot comment on what you need to do as I would have to first reproduce your issue.
@@RezaDorrani Search(myList,TXT_Search.Value,Title) If the searched string doesn't exist, the spinner remains. No pb with a filter query which display 'no result'
Thank you for this video! It is very, very complete.
You are most welcome!
Hi Reza. Thanks for the vedio. AddColumns PowerFX Formula will work with this Modern Table Control ?
It will work, but AddColumns is not a delegable function
@@RezaDorrani Thanks Reza. My requirement is to group the Date columns by the Year and Get the Total Count (Records) and Total Sum (Amount) for contact. What would be the best approach ?
@@Arjunsuganthar921 Im not sure if there is a non-delegable option for that.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Does table sorting work for lists larger than 15 items? My list doesn't sort at all when clicking the sort buttons
It does sort on data > 15 items.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani the issue is with non U.S. date formats. You have to convert them to text then they can't sort correctly because of text conversion format. The modern table only shows dates in U.S format
@Reza - Wanted to check with you one thing - If I select an item in the data table, I am able to navigate the same to a page where I have a gallery. I would like to know how I can select that item in that Gallery that I have selected in the table.
Also would like to know a work around to get countrows as there is a delegation issue. I understand the new table gives the count, but I would like to give a better UI to my users.
Why would you have a table for selecting and then a gallery for selecting? Sounds like duplication.
Countrows is not a delegable function and Im not aware of any workarounds.
@@RezaDorrani Agreed. Thanks much...
Thanks Reza for sharing this video of Modern table. This help in designing Power App using Modern Table. Just one thing i wanted to know why is filter option in Modern table disabled thanks.
Because its not available yet 😊
Thanks for the tip about using ‘Alt’ to adjust column widths. I’ve been having the issue where column widths always revert to minimum, forcing me to constantly adjust.
That would still happen when user runs the app. The limitation is called out in documentation for Table control which is currently in preview
I see, thanks for confirming. I’m hopeful that this will be fixed when modern controls become more mainstream.
@@mw011i I hope so too
As always you are the man.
Thanks ya
so this layout does not have the capability of editing the actual table by clicking on the items , right? Seems like it only displays the values as text input and you can change it to "edit" for the data type....
Currently, its a read only table experience.
Excellent timing I was looking for similar one, your videos always come as my first reference. Additionally, is it possible to edit the Heading title in modern control? If not, what is the better alternative for responsive screen?
Thanks!
What is heading title?
@@RezaDorrani I mean column name. It takes the default column name from data source; how could I change as I needed?
@@Sab-ph7zl Currently, changing names or formatting data is not supported (as far as I know)
@@RezaDorrani That's disappointing! Also I'd appreciate if you can help me understand how to control default selection in the modern table control? I am trying to run an action based on record selection. But when I write an if condition with IsBlank property it always returns false despite no record selection.
@@Sab-ph7zl That is also a limitation. Please note the control is in preview.
Hi Reza, is there a way to search on an already filtered data on table control. I have filtwred the table.to nly show the items belonging to the current user and i want to be able to search on rop of that.
Search and Filter functions can be combined
Great video as per usual. I implemented the table and I am unable to get the sorting to work. Any ideas?
I have not run any issues with it so not sure.
Note: sorting mainly works with text columns. Check documentation for limitations
Ah found the issue, now just need to resolve. My data is a Collection and not a table
Great video!!!, 1 qq, how you can use the search icon or emoji in the text input for the search control for the table??
To add emojis user windows+. to open emoji keyboard
Thank you.
Can you add the checkbox in left of the Company table? Then user can select 1 or many record.
Currently, table control does not support that feature
Wow, muchas gracias
Claro, directo, sencillo, extraordinario
Most welcome!
Reza, I like all your videos. Very informative. keep up the good work! Do you have a video with multiple tables in master detail relationship in tabbed format in one form.? Can you share the video please? Many Thanks !
I dont think I have a video reference on that
Is there a way to have the secondary table display different linked data depending on what you select from the primary table? Also would this work with lists?
What does different linked data mean? Currently it shows linked data depending upon the relationship. End of the day, there must be some reference with main table.
Can also work with SharePoint lists - formulas wont be same though.
@@RezaDorrani so if I had two tables references from the primary, so if I clicked ‘name’ it would show all associated projects as in yours, but if I had another table with financial data could I select a separate column and display the other referenced data? Would and ‘if’ statement work with table.selected? Do you happen to know the lists formulas?
@@thomasboden4053 It should work but not something I have tried. Give it a shot and check
@@RezaDorrani thanks for replying 😊
Thank you for share this video!
My pleasure
Thanks, Reza. After an item is selected, how can you deselect it without selecting another item in the table, ie. deselect all?
I dont think there is an option to do that other than the Table control reloading.
Hello Reza, How do you activate that emoji keyboard? How useful it is to add icons to the application.
windows+.
Am I right that the Modern Table is a readonly control? The control is great and it is very Excel-like control. It would be great if users can edit each field on the Table.
Currently, it is read only.
Reza,
did you maybe found out the purpose of the FillPortions option in the Table control ?
Thats an inherited property as Table is inside container control
Reza, Thanks for sending me the link of the above Video! Much appreciated. I'm trying to do a master detail (One to many relationship) between two tables. I'm stuck on how to show the details table data for those selected in Master table when the relationship is not established in sql server. Although there are columns like ID in both master and details tables which can be joined. Can you please help?
These videos are the best references I have.
I have done no work with sql so not sure how to help. I will recommend posting your issue/query on forums in case someone has done something similar powerusers.microsoft.com
Hi! Very useful info here, I've a question, how can I format to currency type a field of this table? If I have a to format a long Date to short date, how can I do it? Thanks for the help!!
Currently, formatting of data is not supported
@@RezaDorrani Thank you very much!! And I'm very gratefull to meet you and your content! ☺️
With ReflowBehavior = ListOnly and ShowFooter = yes, i can see the pagination, can we make this work without all steps on your another video: Gallery pagination? TIA
Yes - this is not a gallery control though.
@@RezaDorrani can you show us how to enable the pagination at the table footer?
@minhvinhtube I did not understand. You want pagination in modern table control? It's already a part of it
@@RezaDorrani sorry for the cufusion. The pagination in the table footer is gray out for me and never working for me. Thanks for all of your videos!
@@minhvinhtube I'm not sure why that is the case
will the modern table control work with data sources other than dataverse? e.g., SharePoint list?
Yes as per documentation
Thank you so much for your videos, it helps a lot to learn power app! 🥰
You're so welcome!
@RezaDorrami, yesterday I had a not very good surprise with this control. It simply stopped to show values, with a message of "No column selected". This at an app scheduled to be released next week. I opened a support ticket and the answer was that this control is still under preview, and that there is nothing they can do to solve it.
Check this post which explains about preview vs GA www.microsoft.com/en-us/power-platform/blog/power-apps/ga-of-many-long-time-preview-features/
I have not experienced any issues with table control recently. Have also not seen any customers report this.
Hi, I have a task to create 360 feedback tool in Powerapp application. Can you show us how to develop one? I tried to use the list to create the Q forms but how to send the forms for stakeholders to answer and give feedback and how to analyze the results.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
I am unable to wrap the text of table headers, which causes the column widths to adjust unnecessarily and increases the table's length. Are there any solutions
Im not aware of a solution for long table header names
Great video thank you for all. Power apps has come a long way with these modern controls 👏🏼👏🏼 but there are some bugs and missing features hope they all will be solved soon
Most welcome
Thanks for this video! It is very helpful.
Hi That is really helpfull content but one more question when we are adding lookup column in modern table control it will not works getting blank column why is that?
Lookup column for which data source?
Works fine with Dataverse
@@RezaDorrani SharePoint data source .
@@PankilBhatt71 Currently table control (preview) works best with Dataverse (video shows Dataverse)
Is there something like a .AllItems for a table , that we could build a sum on a number cloumn?
There is not. Even if there was, it won't give you correct result as table and gallery both load data in batches.
@@RezaDorrani Thanks for checking used a collection for table and sum then
@@RezaDorrani Oh so you mean if the gallery is not completely loaded it would lie to us :) Thanks for the headsup
@@DaHooka It would not lie. It would simply give the sum based on what it loads :)
Apparently the "DelayOutput" property is gone, Text Input now has a property called "Trigger output", if you set it as "Delayed" it gives you the same behavior.
Cool video, Reza. :)
Yes, it's now 'Trigger Output'
is it possible to patch from the modern table to another list in SP?
Possible but not something I have tried
Here is my statement :
'data_prospector.DP_UserSummary'.Selected.'data_prospector.DP_UserDatabaseList'
in the formula for items for the detailed sidebarContainer
Somehow it is not liking the "Selected" as a valid property or function. My intention is to access the selected row of the DP_UserSummary' table, to get to the details of Dp_UserDatabaseList
It i also not liking the '.' (dot operator ). Can you help me to resolve it ?
I will recommend posting your issue on forums powerusers.microsoft.com
@@RezaDorrani Thanks! ... will do
The modern table control becomes blurry, if the browser is in full screen mode (scale to fit is ON for the app), and only becomes clear if i resize the window manually to hide the grey margins around the app. Is there a way to solve this? Thanks!
I believe this only happens in the studio (may be a bug - as control is still in preview)
Once you play the app, it works fine.
@@RezaDorrani unfortunately it happens in live
@@deadmikehun I have not experienced this in live.
@@RezaDorrani Thanks Reza, hopefully it fixes itself :) How can i format a number field as percentage? Is there a way to do it? Love your vods!! The field type is "n" and im not sure how to tell it to convert to %.
@@deadmikehun Currently, table control does not support formatting
The only thing i wish you did in these videos is show the full process not only the front end but how you defined and related the backend of the project. I'm noticing a real lack of back end content related to power apps on youtube.
The backend can be any data source of your choice. I have done multiple videos on table control and tried connecting with SharePoint, Dataverse and collections.
These are more of how to videos focused on a specific topic. I share the entire code base including the data source with channel members (check video description for details)
Hello! This video is really helpful for someone like me whose a beginner in powerapps. However, I'm struggling to insert the data table inside the container. Wheneve I tried to insert it, the data table is shows as a new screen. Please help. Thank you
I have not come across this issue. Video shows step by step how I add the control into container.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thank you so much! Really this video is very helpful. Can i ask another question? For the side container, I only what to view the selected items? What can i do? Thanks
@@Ramen1991 You mean the main table? User can select 1 item there. Not sure I understood your question
Thanks, Reza. It will be helpful
Glad to hear that
When you add the search on the items property, the sorting feature of table stops working. Please check this
You mean the filter on the Table control? After you apply the filter, sorting is working (atleast on my side)
@@RezaDorrani yes. I think i figured why is it happening. My data source is sharepoint and the search query gives delegation warning. Hence the sorting on modern table fails to work
Thanks for the video and the good explanations, but there is something I don't get, why making a video and promoting something that is in preview and that might be fundamentally changed before GA?
For example the property "Selected" has been removed from the table even though it is still in the documentation. Maybe because it was never working properly and it was always returning an incorrect value.
Because I make videos based on topics that subscribers suggest.
Thank you Reza.
Welcome
Thanks, Reza. The edit function keeps giving the error "Network error when using patch function: An Error occurred on the server." Just to let you know that I am using SharePoint List
I have not come experienced this issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Great video! I was super excited when Microsoft added the table control, but it still has too many issues to be used. The column widths don't stick, row heights can't grow, column names don't change, and there are too many scenarios that result in the table values appearing fuzzy. I think I've narrowed the fuzzy issue to laptop screens and screens that aren't run at the recommended setting. For example, I have 4k monitors and if I run them at 1080p the table data gets fuzzy and hard to read. They also don't work well with custom canvas resolutions. Hopefully, Microsoft will continue to develop the table control because it would be a great addition. For now, the gallery is probably the better approach depending on the use case.
Thanks for the feedback
Why that in sort dropdown ..filter by option is disabled?
Because that’s a feature coming in future
Good stuff. Thanks
Welcome!
This gets me part way, but I really need someone to model multiple tables in a header/detail line fashion. In this tutorial you have two forms and two tables, but it's not a parent/child table relationship and I need to find something like that. Not sure if that's something you could model here or if anyone knows of resources for that type of powerapp. I've been scouring the tutorials and haven't seen anything to really explain that process.
I do not have a video reference on this. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Actually, I stumbled on your 'Editable Grid' series which looks like I may be able to extrapolate what I need from. But thank you, I will also check the forum.
Thank you so much for this video 😊... Can you please show us using power automate how can we pull the data from Ado to SharePoint list online
Most welcome!
Look like ur ask is on a completely different topic. My rule for topic suggestions is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post”
Hi, Can you point me to a tutorial video for the Timesheet app #2 ? Thanks.
I do not have a video tutorial on that
Table column width been resetting every time, is there a way to auto fit?
Currently, No.
This is called out in documentation of table control
Can you make a video about how to get subgrid view in canvas app? I haven't see anyone do this yet.
My rule for topic suggestions is set - "Every 6-8 months I ask for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets max votes, I will add the topic to my backlog"
not sure if anyone else is having this issue my codes were all working then this week it just stopped working and now my form says no item to display.
I have not seen any issues with my existing apps.
Great video as always. How delete works on the table.
Select an item, then have a button similar to edit. When user clicks on it, use remove function
@@RezaDorrani Thank you
Thank you Reza
Welcome
I don't have DelayOutput for my text input, why ?
Advanced properties of control- search for word delay