Unanswered

How to Download Excel file from OneDrive to my local device(desktop/laptop) through PowerApps?

(0) Share

Report

Posted on by nivD2021

I have one requirement to Download Excel file from my OneDrive to my local device (desktop/laptop). I have got Excel file's web url from PowerAutomate and passed it to PowerApps and then using Download(link_of_excel_file) function in PowerApps I tried to download it. But the file is opening in Browser instead of getting downloaded.

Is there any function for downloading any web file to local system in PowerApps or even if is it possible through Power Automate?

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@nivD2021

There is nothing that will interact with local storage in PowerApps.

The Download function will, in fact, download a file as requested, but it is up to the browser to determine how to handle it. Your browser understands to open the file in the browser and not prompt for a "save" option. If the browser does not know how to handle a file, it will prompt to save/download it locally.

But, if you are looking for Powerapps to bring up a folder chooser or something, it will not do that. It is completely reliant on the browser to handle files.

I hope this is helpful for you.
nivD2021 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @RandyHayes . Would you please tell what should be the Browser settings for that? I am using latest Edge browser and it has settings for Downloads as below image
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@nivD2021

Yes, so the browser is still going to "ask" the local registry how to handle the file and it is also going to be highly dependent (if at all) on the parameter you are passing to Download.

What is your formula for the Download?
nivD2021 8 on at

Like
a
(0)

Report
Copy link

Link copied!

In Flow (MyFlow) of Power Automate added steps - 1.Create Share Link and 2. Respond to a Power App or Flow(in this step added Output Parameter as ExcelFileLink)
Then in Power Apps used the Formula in OnSelect property of one Button as :
Set(varLink, MyFlow.Run().excelfilelink);Download(varLink);
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@nivD2021

That will not force a download.

You need to access the Download.aspx page on the site and then pass the source url to it.

So for example, if your document was on a site called "stuff" and your file was in the document library called "Documents" and was called "myExcel.xlsx"

Then your Download (or really, Launch is what you want) should be going to:

https://yourorg.sharepoint.com/sites/stuff/_layouts/15/download.aspx?SourceUrl=https://yourorg.sharepoint.com/sites/stuff/Documents/myExcel.xlsx

This will force a download.

So, if your flow is returning the full url to the file, then:

Launch("https://yourorg.sharepoint.com/sites/stuff/_layouts/15/download.aspx?SourceUrl=" & varLink)
nivD2021 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply. Actually not having such Sharepoint sites so I didnot understand how to implement your solution. Excel files are present in OneDrive. Hence I tried by appending "?download=1" after the URL. But in all browsers it is showing that Pop-ups blocked to redirect the url. If I copy and paste the whole url in a new tab it is downloading smoothly in local system.
The url in my case coming back from Flow is: "https://myorg-my.sharepoint.com/:x/g/personal/my_name_org_name/IdOfFile"
Then the function in PowerApps is : "https://myorg-my.sharepoint.com/:x/g/personal/my_name_org_name/IdOfFile?download=1"
Also, clicking on the popup it has 2 radio buttons -
1. Always allow pop-ups and redirects from https://apps.powerapps.com
2. Continue blocking
where Continue blocking is by default selected and I am not able to select allow button.
Requirement is that user will not also explicitly allow that popup in browser.
Please help.
nivD2021 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Thanks for your reply. Actually not having such Sharepoint sites so I didnot understand how to implement your solution. Excel files are present in OneDrive. Hence I tried by appending "?download=1" after the URL. But in all browsers it is showing that Pop-ups blocked to redirect the url. If I copy and paste the whole url in a new tab it is downloading smoothly in local system.
The url in my case coming back from Flow is: "https://myorg-my.sharepoint.com/:x/g/personal/my_name_org_name/IdOfFile"
Then the function in PowerApps is : "https://myorg-my.sharepoint.com/:x/g/personal/my_name_org_name/IdOfFile?download=1"
Also, clicking on the popup it has 2 radio buttons -
1. Always allow pop-ups and redirects from https://apps.powerapps.com
2. Continue blocking
where Continue blocking is by default selected and I am not able to select allow button.
Requirement is that user will not also explicitly allow that popup in browser.
jaindivyanshi 2 on at

Like
a
(0)

Report
Copy link

Link copied!

.
DBTS7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nivD2021 ,
I'm also facing the same issue, I would like to know if you are able to download the excel file from Powerapps? If yes, can you please explain, how?
I can generate the one-drive link in which excel sheet will open when user click button in powerapps, but I want to download the excel file directly in my local.
Thanks.
xanderTwiga 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@DBTS7 @nivD2021

Get the onedrive sharelink from power automate onedrive connector and append ?download=1 to the sharelink weburl worked for me.
@nivD2021 in your case
instead of - Set(varLink, MyFlow.Run().excelfilelink);Download(varLink);
use - Set(varLink, MyFlow.Run().excelfilelink);Launch(varLink&"?download=1");

hope it helps!