Solved! Go to Solution.
Not only is it possible, PowerApps will build the whole thing for you.
Hi @Akumar,
Could you please share a bit more about your scenario?
Do you want to list your SQL table records in tabular format in PowerApps app?
If you want to list your SQL table records in tabular format in PowerApps app, I think the Data Table control could achieve your needs.
Please consider add a Data Table control within the screen of your app, set the Items property to following:
'[dbo].[YourSQLTable]' /* <-- Type your SQL table data source */
Please check the following video for more details:
https://www.youtube.com/watch?v=fefK35e8Thk
If you want to view a selected record within above Data Table, I think the Display form control could achieve your needs. You could add a Display form control within another screen, set the Item property of the Display form to following:
DataTable1.Selected
Set the DataSource property of the Display form to same data source as above Data Table control.
If you want to edit a selected record within above Data Table, I think the Edit form control could achieve your needs. You could add a Edit form control within another screen, set the Item property of the Display form to following:
DataTable1.Selected
Set the DataSource property of the Edit form to same data source as above Data Table control.
In addition, if you want to delete a selected record, I think the Remove function could achieve your needs.
More details about the Remove function, please check the following article:
More details about Data Forms in PowerApps, please check the following article:
Best regards,
Kris
User | Count |
---|---|
196 | |
124 | |
87 | |
49 | |
42 |
User | Count |
---|---|
284 | |
163 | |
138 | |
75 | |
72 |