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
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?
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.
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?
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.
@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
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})
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?
@@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.
@@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.
oh, good man, it's helpful, thank so much
Hi, I thought of asking you to know how can we prepopulate the edit form fields into different tabs by using data table control?
Hi Dhruvin,
Pls provide example on onselect event
Awesome 👏
This is really useful intro to DataTable... Can you search or filter records in DataTable?
I dont understand how to populate the form on the next screen with the row i selected
Thankyou
You’re welcome 😊
Than you for the Video. I have question, how i can edit that transition form in another screen from Data table (Edit row selected)
How to navigate back to 2 different screens when I click back navigation of the edit screen.
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
Greeting Dhruvin, I followed your steps but my edit form is showing no data when i play my app
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
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?
se pueden agregar filtros en cada columna de la tabla?, estoy muy acostumbrado a telerik.
OOTB - No
hi Dhruvin,
Good day!
Can we design on data table to make header on the left side in power apps?
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?
Wow thanks Dhruvin, much appreciated...How do i filter a table via a textBox input?
write this formula in grid Items property -> Filter(DataSourceName,ColumnName = textbox1.text)
Can we add sort functionality on the columns?
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?
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.
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?
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.
if use datatables, how to formulas for add data in datatables to sharepoints sir ?
Hi! can you create a label that is the sum of a numeric column?
Hi dhruvin how we can delete multiple selected rows in data table
Hi.. is it possible to add a new column in gallery ?or my using any other means?
Hi Sir, How to Export data table content to Excel, Please provide a solution. Thanks
@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
You can't do that
@@iamdhruvinshah any alternative?
Hi Dhruvin. Great video. It was very helpful. It would be even helpful ,if you can share the edit screen 'items' formula.
Please download entire Power Apps from GitHub:
github.com/Dhruvinshah16/PowerApps/tree/master/Beginner%20Series/LeaveApplication
@@iamdhruvinshah what is the formula
Hi Aravind, Did you get the formula
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})
helo i tried inserting datatable in to my screen but datasource if i try to add not pulling data .Any suggestion psl.
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?
Can I do filtering on sharePoint datatable ?
How can i insert or create a search box for an item in a data table? I've tried without success
It is exact same as Gallery! No Change
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)
We cant add scroll in gallery
hi , I want create a button in powerapp, then import excel data into sql? Thankyou. I can give to mail?
Yes, you can
@@iamdhruvinshah you have tutorial?
Thankyou
How to include Pagination in DataTable?
Can we add responsiveness to data table?
Or 2 groups in a list 1 group can see 5 field and other is 2
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
not working it seems information is incorrect or missed...
Can i add the data table in sharepoint list view page?
I didn't get your question. Can you please elaborate?
This is very good. I also want to export this table data to a excel. Is that possible ?
Interesting! At this moment there is no OOTB way.
But we can export by connecting Flow or some other solutions
@@iamdhruvinshah Hi. can you show us also how to export to csv or excel? Thanks
by connecting flow?
5 groups has 5 different screen.. how to do
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.
I think in Power Apps data table there is a full border for all cells. What exactly you are looking for?
@@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.
@@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.
How to select multiple Row ?
Can not select multiple row from data table.
As alternative we need to provide check box with each row with gallery control