Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

How to Export data from DataTable to Excel in PowerApps

Like (0) ShareShare
ReportReport
Posted on 3 Jun 2019 12:17:46 by Microsoft Employee

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

Categories:
  • RobH1 Profile Picture
    60 on 08 Dec 2020 at 19:03:52
    Re: How to Export data from DataTable to Excel in PowerApps

    Works perfectly 😀

  • Udaybharati Profile Picture
    6 on 23 Nov 2020 at 22:59:35
    Re: How to Export data from DataTable to Excel in PowerApps

    To implement this I created a view with required columns in backend SharePoint list to match data from DataTable.
    Then created below url for downloading view data to excel:

    {Site URL}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={LIST ID}&View={View ID}

    Then in PowerApps added one button. Set "OnSelect" property to launch above url.
    Launch("URL",{},LaunchTarget.New)

    This way we can download the data to excel. We can add filters to the view to match the data from DataTable.

    Sharing this idea as it might help someone with similar need.
    Let me know if there is any other way of implementing this.

  • Durga Profile Picture
    Microsoft Employee on 11 Jun 2019 at 12:35:23
    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

     

  • Verified answer
    v-xida-msft Profile Picture
    on 04 Jun 2019 at 02:13:08
    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/m-p/164632

     

    Best regards,

  • yashag2255 Profile Picture
    24,442 Super User 2024 Season 1 on 03 Jun 2019 at 12:46:43
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 20

#2
BCBuizer Profile Picture

BCBuizer 10 Super User 2025 Season 1

#2
LC-26081402-0 Profile Picture

LC-26081402-0 10

Overall leaderboard
Loading started