web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Download a csv file fr...

Power Apps

Unanswered

Download a csv file from sharepoint select by date

(0) Share

Report

Report

Posted on by Wahyu

2

First of all, I'm sorry If the subject is a bit confusing.

Here is my problem.

I made a PowerApps for downloading a reporting file from my sharepoint. In my PowerApps there is only date picker component, dropdown, and a button. It is pretty simple, but from that component I want to take my reporting csv file by select the date, then select the report type and then click download, and it will download the file from my sharepoint. In my sharepoint I had some files report with the name is like :

1. report Y 20210201.csv
2. report Z 20210201.csv

Which is Y and Z is the type of the report and 20210201 (yyyy-mm-dd) is the format date the report has been made.

How could I made a formula and get a value from datepicker and dropdown to download the file ?

Is it possible ?

Please help me, I'm new to PowerApps.

Thanks,
Wahyu.

My PowerApps

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@Wahyu,

Based on the issue that you mentioned, do you want to customize the file name clicking the download button?

Could you please share a bit more about the scenario?

Actually, the Download() function will make you download from the web to the local. If you want to download it directly, I recommend you create a custom library to store files.

Download("https://<site URL>/_layouts/download.aspx?SourceUrl=/sites/sitename/libraryname/filename.csv")

The above formula could help you download directly from the custom library.

For how to modify the file name, I think you could try as below:

Concatenate( "report" & Dropdown1.Selected.Value, Text( DatePicker1.SelectedDate, "[$-en-US]yyyymmdd" ), ".csv" )

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No
Wahyu 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Sir, I'm so sorry if my explanation is a bit confusing.
But I won't customize the file name. The file name is already in my OneDrive (I'm sorry before this I mention it as Sharepoint because of the url name, but arfter I checked it again, it's definitely One Drive Business).
The scenario is like this :
User open PowerApps -> User select date -> User select report type -> User click download.
When User click it, it will download the report file from my OneDrive.
So the download is not static, but dinamic depend on the date and report type that User choose.
As I mention before the file name is like this report update sentra 20210201.csv and report update tp 20210201.csv
which is sentra and tp is the type and 20210201 is the date. If we talk about REST, it's not POST the file, but GET the file.

So that's it Sir. The purpose is to download the report file from my OneDrive. But the problem I don't know how to customize the function/formula to get/download the file like I wanted.

Thank you so much, for replying my post.
Hope it can be solved.

Was this reply helpful? Yes No

Join the conversation