How to create a button when clicked downloads an excel file in SharePoint to local file?

(0) Share

Report

Posted on by AC-31122111-0

Hi all,

Having trouble with creating a button in PowerApps where when a user clicks it downloads an Excel file (currently located in a SharePoint folder) to a user's local computer file.

Here is my current function:

Download("Excelfilelocation?download=1")
 
The goal here is to write a function where when a button is selected it download the file straight to the users local file. 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

WarrenBelz 153,773 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @AC-31122111-0,

Assuming you have the file in a SharePoint Library and are displaying the files in a Gallery, put a button/icon in the Gallery and using your Domain and Library names.

Download($"https://YourDomainName.sharepoint.com/YourLibraryName/_layouts/download.aspx?SourceUrl=https://YourDomainName.sharepoint.com/YourLibraryName/" & ThisItem.'Full Path')

The file should go into the Downloads folder of the user.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 153,773 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @AC-31122111-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No