cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
J_K
Regular Visitor

Flow to download Zip File (that contains a .csv file) and upload it to specific location in One Drive.

Hi Everyone!

 

I am new to power BI and power automate and I am needing your help!

 

I need to create a flow to automate the following steps:

 

1º - Download this file from https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.e... - https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.zip?345330e5405b4263518cc06b1622b09b

 

- Unzip the file to have a non ziped fCSV

- Upload it to a shared onedrive for bussines folder, that I am not the "owner"

 

Is that possible? I would need it to run once per day, since the exchange rates from that file exists till the day before today (14 March).

 

After that, I need it to put power BI "eating" from that location in One Drive for bussiness and manipulate the data to know the total amount of sales in euro, dollar, etc.

3 REPLIES 3
mahoneypat
Super User
Super User

FYI that you may also be able to unzip the file in your Power BI query too, but you can do it in your Flow as well.  There is a template for a similar scenario below.  You can upload the emailed zip file to OneDrive and use an Extract File from Archive (assuming you have permission to upload files even though you are not the owner).

 

Unarchive the files added to Onedrive for Business folder | Microsoft Power Automate


Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


J_K
Regular Visitor

On the example you state, it doesnt show how to download the file from the web. Howerver it was very usefull to another similiar flow I have to build, that after downloading and unziping the files, i need to delete a few of them with specific conditions. That conditional on the midle "containing" zip will also enable the flow do delete a that files containing "SalesRpt" or "Stock".

My question know is how to donwload a file from a website ( https://www.next.co.uk/, as a seller/retailer), have the option to select all of the files, and then dowload them to a specified folder location.

 

Flow needs

 

1 - Login at https://cft.next.co.uk/EFTClient/Account/Login.htm

2- Insert the User and Password

3º  Choose all documents available and download them (the output is a zipped folder downloaded to "Downloads")

 

download.png 

4- Unzip the folder

5- Copy this documents to a specific location in onedrive

6 - Delete the documents with strings " SalesRpt" or "Stock"

 

*Another options for point 6 is to only download documents without "SalesRpt" or "Stock", but I would say its more dificult, even though it's less heavy.

 

Anyone could try to help me on this, or at least, tell me it this is possible?

J_K
Regular Visitor

Anyone could sugest me how to do it?

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,874)