Answered

exporting sharepoint list data to excel file with powerapps

(0) Share

Report

Posted on by noamshn

Hello everyone,

I want to add a button in my canvas power app that will export the data from my sharepoint list to excel. I dont need any filteration or anything, I just want to export all the data to excel file that will be downloaded once the button clicked.

there is a button like this in the sharepoint site, but is it possible with canvas app? I didnt find any solution for this.

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hello @noamshn ,

I think that you would like to emulate the export data button functionality that currently exsists in the sharepoint list ? if this is the case then this is easy !!

Create a view in sharePoint with all the columns that you would like to have in the excel extract. If you are not sure how to get list ID and View ID then view this link to see how (it is very easy)

On the OnSelect property of the button add the following:-

Launch("https://*Your SharePoint Site adress*/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={*Enter List ID*}&View={*Enter View ID*}&CacheControl=1")

example

Launch("https://Test.sharepoint.com/sites/TesstSite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={5889d440-3868-70a3-9961-4e6838365ad0}&View={d32f445d-fa6b-4d43-b358-beeec073411c}&CacheControl=1")

Cheers !

Was this reply helpful? Yes No
noamshn 64 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much! it worked.

Was this reply helpful? Yes No
prasannavanga12 10 on at

Like (0)

Report
Copy link

Link copied!

Hello,
please i need some help on this
iam using this url"(*Site Name*/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={%207B7793c4f0-3d39-4057-aec3-6d8b8047da25%7D}&View={7B17E18C52-C913-4BA3-939B-06F9B2471C16%7D}&CacheControl=1") but it shows error cant complete this action please try again later

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @prasannavanga12 ,

Looks like your listID & view id is not correct can you make sure your the below is correct (i removed %20D7B from the beginning and %7D from the ending)

Launch("https://iff.sharepoint.com/sites/NB-DSCI_Fin_VOC_IFF/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={7793c4f0-3d39-4057-aec3-6d8b8047da25}&View={17E18C52-C913-4BA3-939B-06F9B2471C16}&CacheControl=1")

this should work hopefully 🙂

Cheers !

Was this reply helpful? Yes No
prasannavanga12 10 on at

Like (0)

Report
Copy link

Link copied!

HI @Anonymous_Hippo ,
its working,iam surprising its working iam trying another list it should be

https://iff.sharepoint.com/sites/NB-ProcessExcellence/projectandprograms/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={9D67A9D1-1B6C-425B-8287-4CB232D8540E}&View={ BAA1AEDB0-EDE7-4DC5-89AF-A9F5663E87D2}&CacheControl=1 what is wrong on this i dont understand

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@prasannavanga12

can you try

Launch("https://iff.sharepoint.com/sites/NB-ProcessExcellence/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={9D67A9D1-1B6C-425B-8287-4CB232D8540E}&View={BAA1AEDB0-EDE7-4DC5-89AF-A9F5663E87D2}&CacheControl=1")

you missed removing the list name (:

Was this reply helpful? Yes No
prasannavanga12 10 on at

Like (0)

Report
Copy link

Link copied!

Error

Cannot complete this action.

Please try again.

Troubleshoot issues with Microsoft SharePoint Foundation.

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I am not sure why it is not working but please make sure you follow this format and use the correct list ID and View ID

Launch("https://Test.sharepoint.com/sites/TesstSite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={5889d440-3868-70a3-9961-4e6838365ad0}&View={d32f445d-fa6b-4d43-b358-beeec073411c}&CacheControl=1")

Was this reply helpful? Yes No