We have one service, and we developed a Powerapps app for this service.
In the application, the user can download the .xlsx (Excel) file from the server.
We did this with the help of Download function -> Download (https://path to our file).
and on the server side we set the response header "Content-Type" -> application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
When we use the app on the PC, tablet there is no problem. We can downlad the file and open with with no problems.
But we have a problem with Android (we test on Samsung s5). When we click the download button, we save the file but the file is automatically zipped, (.zip), and when we unzip it we cannot see the excel document, but instead we see the .xlsx structure in different folders.
So basically when we click the download button in android we do not get the excel file, like on the computer/tablet.
We tried to install some file explorer , but again with no luck, when we download it , we cannot save this file as "excel file".
Where is the problem?
Does the path you specify in the Download() invocation include a file extension (.xlsx)? It sounds like for whatever reason the extension cannot be inferred in your specific case on Android, so the default ".zip" extension kicks in, and your file is renamed. (not zipped up, but simply renamed from .xlsx to .zip). Specifying the file extension in the http:// path should help avoid that problem.
The file has the extension because when we download it using the computer or tablet, the file is in the .xlx format, have the extension .xlsx and we open it with excel.
When we use android, the file is saved like " filename.xlsx.zip ", but when we unzip it, we do not get the file but the file ordered in the .xlsx structure. So we cant get to the originally file.
Solved the problem with changing the Download function with Launch function...
Now the excel is open and we can see the file and eventually store it.
The result is "solved" but not totally, because we still want to have a "save the file" button, but seems that there is a problem. I don't know if this problem is android or powerapps problem.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!