Logic Apps Azure Save File Dialogue to OneDrive

Question

I have a super simple workflow and am embarrassed at not being able to figure this out.

1. Login to Site
2. Navigate to Report Download URL
3. Save the file (xlsx) to One Drive

I'm using two HTML tasks, the first to login and the second to get the file. (I've also used a OneDrive upload from URL in place of the second HTML task) Both save the 'body' of the HTML GET URL. I get a file of HTML.

There is an answer here describing use of a create blob, but I need to create an Azure resource for this. I suspect the answer is in the 'Body' text box where the hint is 'Enter Request Content'

what is the content type for a 'save as or open' dialogue one sees in a browser when downloading a file?

I hope this is clear. I am so good at writing questions which make sense to me which go unanswered! I even appreciate constructive criticism in how I present the question!

Answer 1

According to your requirements from the question and the comments, I provide a solution(which use azure function and logic app) here for your reference:

First, you need to create a azure function (python) and you can write the python code to download the xlsx file from the website. And then you can use python sdk for azure storage to upload the xlsx file to azure file storage.

Now, you have completed the development of your azure function. Then we need to call this azure function in logic app. Please refer to this tutorial to add the function you developed to your logic app.

Then we can use "Get file content" action from "Azure file storage" connector in logic app to get the xlsx file which we uploaded it to azure file storage.

At last, we need to use "Create file" action from "OneDrive" connector in logic app to save the file from the previous action("Get file content" from azure file storage) to One Drive.

Hope it would be helpful to your problem~