Hi @Durga ,
Hi @Durga ,
Do you want to export data from a Data Table control into a Excel file?
If you want to export data from a Data Table control into a Excel file, I afraid that there is no way to achieve your needs in PowerApps currently. There is no functionality or functions supported within PowerApps to export data from a Data Table.
In addition, within PowerApps, there is no way to select all items/records within a Data Table once time. As an alternative solution, you could consider list your records using a Gallery instead of Data Table. You could configure the Gallery control works as a Data Table.
On your side, you could create a Excel file in your cloud service, e.g. OneDrive. Add columns within this Excel file, and format it as a Excel table. Within your app, create a connection to this Excel table.
After that, you could configure your data in your Data table into a Gallery as below:
Set the OnSelect property fo the "Patch" button to following:
'Due Date': DateValue(Label5.Text),
Note: The Label3, Label5 and Label9 represents the Label controls within your Gallery, which used to display corresponding column value.
On your side, you may type:
More details about the Patch function, please check the following article:
Also please check and see if my response within the following thread would also help in your scenario:
Thanks for your reply.
Our requirement: We pull and show data in apps from Azure SQL Server and our users wanted this data to be exported to excel from DataTable.
Let me try this option and check whether all users can export data or not.
Also, we would like to know: is Role based permissions available in PowerApps?
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021