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:
ForAll(
Gallery1.AllItems,
Patch(
OriginalTable,
Defaults(OriginalTable),
{
ProjectName: Label3.Text,
'Due Date': DateValue(Label5.Text),
Executor: Label9.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:
ForAll(
Gallery1.AllItems,
Patch(
YourExcelTable,
Defaults(YourExcelTable),
{
Column1: Label1.Text,
Column2: Label2.Text,
Column3: Label3.Text,
...
}
)
)
More details about the Patch function, please check the following article:
Patch function
Also please check and see if my response within the following thread would also help in your scenario:
https://powerusers.microsoft.com/t5/General-Discussion/Export-data-from-powerapps-to-excel-with-Flow/m-p/164632
Best regards,
