cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

How to Export data from DataTable to Excel in PowerApps

Hi,

I have a Data Table in Canvas app. So, I want to export data from Data Table to Excel. Could you please suggest some approaches.

Thanks
Durga

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to Export data from DataTable to Excel in PowerApps

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:2.JPG

 

3.JPG

 

4.JPG

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...

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User III
Dual Super User III

Re: How to Export data from DataTable to Excel in PowerApps

Hi @Durga , 

 

Currently there is no functionality in canvas app to export data directly to excel.
 
But as a workaround, you can create an excel file, somewhere on cloud platform. eg. OneDrive/Dropbox etc. and connect it to your powerapp as a data source. For updating the data, you can use patch command. You could also use Flows that are triggered from Powerapps. 
 
Hope this Helps!
Highlighted
Community Support
Community Support

Re: How to Export data from DataTable to Excel in PowerApps

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:2.JPG

 

3.JPG

 

4.JPG

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...

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Microsoft
Microsoft

Re: How to Export data from DataTable to Excel in PowerApps

Hi v-xida-msft,

 

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?

 

Thanks

Durga

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,928)