Create Grid View in Power Apps with Data table Control

hey everyone this is druveen and i welcome you all to powerups beginner series you are watching the 12th part of this series in this session we are going to talk about the data table control in powerapps so now let's get started [Music] in my earlier session we have prepared this beautiful grid with the help of custom gallery control now here i am going to talk about the data table control in detail we can also prepare the grid using the data table control but when to use data table control and when to use gallery control let me explain you that thing in detail for that let me let me create one scrollable screen here and let me just give the name of data table demo now let's add data table control over here go to insert menu and from here just select data table so it will add the data table control to you here now let's provide the list name as leaves here now that has been added over here like this now here you can see that header and row part created automatically over here like this this selected item also we can get automatically here now let me explain few things here let's say for an example this is my data table right and here we just need to select the field which we want to show let's say i want to see the title second position i need leave type so i'm selecting layer type then leave status department manager start date ended number of days manager comment i don't need i'm removing this one so i need this many of information and it is looking like this you can see that and this type of scroll is also available over here right so let's say for an example now i want to add one edit button inside my data table so can i edit can i add that let's see whenever you click on add field here you can only add the fill which is provided by your data source you cannot add any field which is not a part of your data source so in data table we have limitations like let's say if your requirement is something that you only want to show the data you don't want to take any action on your data like you don't you want to to redirect that to another grid or something like that you don't want to do that so at that time this data table control will best for you it saves your lots of designing effort over there but suppose your requirement is something like let's say you wanted to add one edit button or let's say one unique column you want to add and you want to have a functionality like let's say uh whenever the approved whenever the item is approved you want this image otherwise it you need this image so this type of column is something you cannot add in the data table control so this is one limitation otherwise it is very simple and very straightforward and you can see that the configuration is also very simple right now one more thing let's say for an example whenever i am selecting any item and i want that item to be passed on some another screen can i do that let's see that so let's say for an example i am adding one button here for editing right so let me just give this button name as edit so what i want to achieve here is whenever we select any item it should open its edit form right so will i get selected item from data table let's see now if we take the data table control what will happen here is let's say i want to open the edit form for that what i need to do here is i need to write a code like data table 1 dot selected so i am getting the entire row inside the selected item and then similar way i need to pass that item inside my edit form right so here we have configured our data table and this is looking amazing right now let's say here there is only one limitation we cannot add any custom columns apart from the data source column so let's say if i want to add any edit icon over here i cannot add right as alternative what i need to do here is i need to add edit icon at the bottom whenever i'm selecting any item based on that i need to sell click on edit and after that it will redirect me to the edit form this is something that i can do otherwise we can do one alternative thing like whenever i am clicking on that it will automatically redirected me to the edit form this thing also we can do by using on select item of the data table right now in order to do that what we need to do here is let me just add this update context over here like this now i need to use navigate function in navigate i need to redirect to the second screen then cover and then we just need to pass selected item as data table one dot selected so i am getting the entire context from here right so what it will do is let's say for an example i'm selecting this one and i'm clicking on edit so it will automatically redirecting it to the edit form and all the fields will be pre-populated over here like this so this looks really amazing right so hope you get an idea about the data table and you understand where i can use the data table now the only basic difference between the gallery and data table is that in gallery we have so much flexibility that we can add our own custom controls over here and based on that we can do the formatting and so many other things as well conditionally like i i can add my custom buttons over here as well as if i want to make some check boxes check i can also do that same way let's say if i want to make some unique character formatting i can also do that here but in case of table we are facing that much of limitations over there right so use the data table and gallery wisely based on your requirement and you will get now you have get an idea like what's the data table and what's the gallery right if you have any question related to this topic you can add your questions in the comment section if you are for the first time to my channel make sure you hit subscribe and press the bell notification to never miss any updates from my channel stay connected with me on facebook linkedin twitter and whatsapp and if you wish to receive the daily notification from my channel click on this link it will be redirecting you to this form fill the form and you will be receiving daily notification on your whatsapp number stay connected with me have a great day goodbye

Channel: Dhruvin Shah

Views: 74,222

Keywords: Power Apps Data table Control, Power Apps, When to use Data table in PowerApps, Grid Design with Data tables, Data table in PowerApps, Get Selected item from data table in PowerApps, Power Apps Data tables, Limitations to use Data table in Power Apps, learn Power Apps Step by Step, Power Apps learning, How to start with Power Apps, Power Apps Tutorials for beginners, Power Apps Beginner Guide, Get started with Power Apps, Power Platform, Power Apps Consulting, Power Apps Grids

Id: UcXYf4nq9BA

Length: 7min 32sec (452 seconds)

Published: Tue Sep 15 2020