Тёмный

Create Grid View in Power Apps with Data table Control 

Dhruvin Shah
Подписаться 49 тыс.
Просмотров 75 тыс.
50% 1

Welcome to Power Apps Step by Step Beginner tutorial series. My self Dhruvin Shah you are watching the 12th part of the Power Apps Beginner Series. During this chapter, we will talk about how we can create a Grid View in Power Apps with Data table Control. So, now let’s get started!
First, we will add Data table control on our screen, and then we will add and remove fields based on our requirements. Data table control has some limitations. We will discuss those limitations in detail during the session. Also, we will check, how we can get the selected item from the data table and pass that to the edit form to overcome one limitation. We will also discuss, when to use the data table and when to use Gallery to develop the Grid in Power Apps.
So, stay tuned with me throughout the journey!!
Chapters:
00:00 Introduction
00:35 Introduction to the data table control
01:04 Add Data table Control in screen
01:36 Add or Remove fields in Data table
02:36 Limitation of Data table
03:15 Add Labels inside Gallery
03:40 Pass Selected item from Data table
06:14 Gallery Vs Data table basics
#PowerApps
#PowerPlatform
#CanvasApp
#PowerAppsBeginnerSeries
#PowerAppswithDhruvin
The full Power Apps beginner course is free for everyone. The main goal to develop this course is to give you all the proper direction to get started with Power Apps learning!
Happy Power Apping!!
***************************
Link for Entire Playlist:
RU-vid: • Power Apps Tutorial fo...
Link for Blog:
powerplatformtrainings.com/20...
Check all Chapters using the following link:
Chapter 0:
Power Apps Tutorial for Beginner | The Complete Step by Step Guide to start Power Apps Canvas App
• Power Apps Tutorial fo...
Chapter 1:
Introduction to Power Apps | What is Power Apps?
• Introduction to Power ...
Chapter 2:
How to start with Power Apps development Process? - Overview of Tools, Licensing and Environment
• How to start with Powe...
Chapter 3:
Customize a SharePoint List form using Power Apps
• Customize a SharePoint...
Chapter 4:
Introduction to Power Apps Canvas App | What is Standalone Power Apps Canvas App?
• Introduction to Power ...
Chapter 5:
Power Apps Standalone App Vs Customized List Form
• Power Apps Standalone ...
Chapter 6:
Variables in Power Apps
• Variables in Power Apps
Chapter 7:
Collection in Power Apps
• Collection in Power Apps
Chapter 8:
Build your first Power Apps Canvas App for Leave Management System
• Build your first Power...
Chapter 9:
Develop Forms in Power Apps Canvas App- Implement New form with Real Life Scenarios
• Develop Forms in Power...
Chapter 10:
Develop Forms in Power Apps Canvas App- Implement Edit form with Real Life Scenarios
• Develop Forms in Power...
Chapter 11:
Create Grid View in Power Apps with Custom Gallery Control
• Create Grid View in Po...
Chapter 12:
Create Grid View in Power Apps with Data table Control
• Create Grid View in Po...
Chapter 13:
Gallery Vs Data table in Power Apps
• Gallery Vs Data table ...
Chapter 14:
Filter and Search Records in Power Apps
• Filter and Search Reco...
Chapter 15:
Apply Sort on Multiple Column in Power Apps
• Apply Sort on Multiple...
Chapter 16:
Sort, Filter and Search Together for Galleries or Data tables in Power Apps
• Sort, Filter and Searc...
Chapter 17:
How to Call Power Automate Flow from Power Apps with Parameters?
• How to Call Power Auto...
Chapter 18:
How to Publish Power Apps Canvas App?
• How to Publish Power A...
Chapter 19:
Access Management for Power Apps Canvas App | Sharing Power Apps Canvas App
• Access Management for ...
Chapter 20:
Restore Previous Version of the Canvas App in Power Apps
• Restore Previous Versi...
Chapter 21:
Manage Roles in Power Apps Canvas App with Power Automate and SharePoint
• Manage Roles in Power ...
Chapter 22:
How to Export and Import Customized SharePoint Power Apps Form from Development to Production?
• How to Export and Impo...

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 66   
@hemanadezhdank401
@hemanadezhdank401 2 года назад
Hi Dhruvin. Thanks for the great video. Requesting you to let know, if it is possible to have dynamic check box for every row of the data grid. If yes how it can be done.
@mri3180
@mri3180 2 года назад
Hi, I thought of asking you to know how can we prepopulate the edit form fields into different tabs by using data table control?
@jesuscastro6455
@jesuscastro6455 3 года назад
hi Dhruvin, thank you by the video, i have a doudbt how i can do focus or go to last line in data Table control?
@vaibhavpatil-iv3lq
@vaibhavpatil-iv3lq 2 года назад
Than you for the Video. I have question, how i can edit that transition form in another screen from Data table (Edit row selected)
@OOAK-Ireland
@OOAK-Ireland Год назад
hello Dhurvin, I see that you have screens as well as components on your tree view active. Do you know why I can only see screens?
@nagaiahyara3877
@nagaiahyara3877 2 года назад
Can we add sort functionality on the columns?
@Namnguyen-sw8bx
@Namnguyen-sw8bx 2 года назад
oh, good man, it's helpful, thank so much
@vvaassaanntthh
@vvaassaanntthh 2 года назад
Hi @dhruvin can you please advice how to do this requirement? I have a datatable in my canvas app, which has 10 rows for example. 5 Rows report to manager A, and other 5 rows report to manager B. The requirement is that : Manager A should only see 5 rows (out of 10 rows) and each row should have an approve/deny option. Manager B should only see his 5 rows of users and also see the approve/deny button on each line level. How to implement this control in power apps? can you guide with a link for the same?
@TheRealHouji
@TheRealHouji Год назад
hi Dhruvin, Good day! Can we design on data table to make header on the left side in power apps?
@mybelieve9437
@mybelieve9437 3 года назад
Awesome 👏
@karolinaunderwood1039
@karolinaunderwood1039 Год назад
This is really useful intro to DataTable... Can you search or filter records in DataTable?
@srijakomirishetty1579
@srijakomirishetty1579 3 года назад
How to delete rows from data table and that change should reflect in sharepoint list also. Or is there a way that we make a change in sharepoint list and that can automatically reflect in the app data table?
@garimabhargava7706
@garimabhargava7706 Год назад
Hi @dhruvin can you please suggest how to filter data table and only show the requestor data only now it is showing everyone's data
@smbasha
@smbasha 2 года назад
Hi Dhruvin, Pls provide example on onselect event
@subhraghosh8434
@subhraghosh8434 3 года назад
Can I do filtering on sharePoint datatable ?
@fenrir433
@fenrir433 Год назад
Hi! can you create a label that is the sum of a numeric column?
@someshwarhegde8965
@someshwarhegde8965 2 года назад
Hi.. is it possible to add a new column in gallery ?or my using any other means?
@MatthewBryce
@MatthewBryce 2 года назад
I dont understand how to populate the form on the next screen with the row i selected
@hashmatali299
@hashmatali299 4 месяца назад
Sir if we want to go to new form and from our data table we have to fill our selected values which we want only in new form here edit form is happening but we want new form to fill new form And only the values that we have to fill in the form are there
@simplynaman
@simplynaman 2 года назад
How did you add the initial Data Card ? In your both gallery and data grid screens you have a data card under which you created these datatables. How did you add the datacard?
@jagen2212
@jagen2212 Год назад
Greeting Dhruvin, I followed your steps but my edit form is showing no data when i play my app
@pablov3716
@pablov3716 3 года назад
se pueden agregar filtros en cada columna de la tabla?, estoy muy acostumbrado a telerik.
@iamdhruvinshah
@iamdhruvinshah 3 года назад
OOTB - No
@panditjitechtalk314
@panditjitechtalk314 6 месяцев назад
How to navigate back to 2 different screens when I click back navigation of the edit screen.
@hariyanto6665
@hariyanto6665 Год назад
if use datatables, how to formulas for add data in datatables to sharepoints sir ?
@analyticsadda6080
@analyticsadda6080 2 года назад
Hi dhruvin how we can delete multiple selected rows in data table
@aravindsuresh4722
@aravindsuresh4722 3 года назад
Hi Dhruvin. Great video. It was very helpful. It would be even helpful ,if you can share the edit screen 'items' formula.
@iamdhruvinshah
@iamdhruvinshah 3 года назад
Please download entire Power Apps from GitHub: github.com/Dhruvinshah16/PowerApps/tree/master/Beginner%20Series/LeaveApplication
@ramubayyani5433
@ramubayyani5433 3 года назад
@@iamdhruvinshah what is the formula
@ramubayyani5433
@ramubayyani5433 3 года назад
Hi Aravind, Did you get the formula
@marcosjrodriguez2877
@marcosjrodriguez2877 3 года назад
hola buena tarde, use la formula para seleccionar una fila y siempre me manda el ultimo registro, prdian ayudarme... lo escribi así : Navigate(DetailMant;ScreenTransition.Fade;{selectedItem:DataTable1.Selected})
@kamleshpandey7514
@kamleshpandey7514 3 года назад
Hi I am using the Vertical Gallery, But I have more than 20 column. How can I add a scroll bar in the bottom(Horizontal scroll bar)
@iamdhruvinshah
@iamdhruvinshah 3 года назад
We cant add scroll in gallery
@ranjeetpm76
@ranjeetpm76 3 года назад
Want to select DataTable/Grid cell and selected cell data need to add in next table. once all selection done then need to send those selected row into excel.
@BaratthPillay
@BaratthPillay 2 года назад
helo i tried inserting datatable in to my screen but datasource if i try to add not pulling data .Any suggestion psl.
@_sai_teja
@_sai_teja Год назад
Can we add responsiveness to data table?
@mridulgrover21
@mridulgrover21 Год назад
@dhruvin Shah, hi a great video! Quick question- I have a share point list which consist of 3-4 views. I am creating an app and I want to fetch those views with the help of data table on different screens of my app. Can we do that if not is there any alternative? I hope to hear from you soon
@iamdhruvinshah
@iamdhruvinshah Год назад
You can't do that
@mridulgrover21
@mridulgrover21 Год назад
@@iamdhruvinshah any alternative?
@zaydarendse2812
@zaydarendse2812 3 года назад
Wow thanks Dhruvin, much appreciated...How do i filter a table via a textBox input?
@chintandd
@chintandd 2 года назад
write this formula in grid Items property -> Filter(DataSourceName,ColumnName = textbox1.text)
@KuldeepSingh-nq1vi
@KuldeepSingh-nq1vi 10 месяцев назад
Hi Sir, How to Export data table content to Excel, Please provide a solution. Thanks
@omtschand3432
@omtschand3432 3 года назад
Can i add the data table in sharepoint list view page?
@iamdhruvinshah
@iamdhruvinshah 3 года назад
I didn't get your question. Can you please elaborate?
@AnandWattal
@AnandWattal 3 года назад
How can we see a Grid View (similar to All Borders in Excel) in DataTables. I want to add borders to all cells of DataTables.
@iamdhruvinshah
@iamdhruvinshah 3 года назад
I think in Power Apps data table there is a full border for all cells. What exactly you are looking for?
@AnandWattal
@AnandWattal 3 года назад
@@iamdhruvinshah My DataTable in PowerApps is not having borders in Cells. It is having the outline border on the whole Table. I am looking for an option to add grid lines inside the Table - In all rows and columns.
@AnandWattal
@AnandWattal 3 года назад
@@iamdhruvinshah Can you please guide me - how to get full border for all cells? I could not find it. When I applied the Border property, and added border thickness, the outer frame of DataTable had a border. But the inner cells were without any border.
@Ribeiro1783
@Ribeiro1783 3 года назад
How can i insert or create a search box for an item in a data table? I've tried without success
@iamdhruvinshah
@iamdhruvinshah 3 года назад
It is exact same as Gallery! No Change
@mybelieve9437
@mybelieve9437 3 года назад
5 groups has 5 different screen.. how to do
@rasendell4817
@rasendell4817 3 года назад
Thankyou
@iamdhruvinshah
@iamdhruvinshah 3 года назад
You’re welcome 😊
@kvijar1
@kvijar1 Год назад
How to include Pagination in DataTable?
@sarejahaseaccha3086
@sarejahaseaccha3086 3 года назад
This is very good. I also want to export this table data to a excel. Is that possible ?
@iamdhruvinshah
@iamdhruvinshah 3 года назад
Interesting! At this moment there is no OOTB way. But we can export by connecting Flow or some other solutions
@ryancharles8033
@ryancharles8033 3 года назад
@@iamdhruvinshah Hi. can you show us also how to export to csv or excel? Thanks
@ryancharles8033
@ryancharles8033 3 года назад
by connecting flow?
@quangdungngo2836
@quangdungngo2836 2 года назад
hi , I want create a button in powerapp, then import excel data into sql? Thankyou. I can give to mail?
@iamdhruvinshah
@iamdhruvinshah 2 года назад
Yes, you can
@quangdungngo2836
@quangdungngo2836 2 года назад
@@iamdhruvinshah you have tutorial? Thankyou
@mybelieve9437
@mybelieve9437 3 года назад
Or 2 groups in a list 1 group can see 5 field and other is 2
@orcspkumar3999
@orcspkumar3999 7 месяцев назад
Hi, I am very disappointed, It is not possible I have tried many times not been populated in edit form if i do like this
@k.krishankumar
@k.krishankumar Год назад
not working it seems information is incorrect or missed...
@v75tan
@v75tan 3 года назад
How to select multiple Row ?
@iamdhruvinshah
@iamdhruvinshah 3 года назад
Can not select multiple row from data table. As alternative we need to provide check box with each row with gallery control
Далее