Unanswered

HTTP Response with File Download

(1) Share

Report

Posted on by DrFrank Microsoft Employee

I'm trying to include an excel file in a http response action.

The desired functionality is upon calling the http trigger, the flow creates an excel file and returns it and the user sees the file starting to download in the browser.

I want the user to be able to download the "Copy File" after they perform the HTTP request.

Any pointers on how to format the response?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

The Copy action that you are using creates a copy in OneDrive, make sure that the user has access to it (in case they are not the owner of the one drive)
To answer your question, you simply specify the Status Code and provide the URL generated from the Copy action (using dynamic selector)
{
"Url": From the dynamic selector
}
HTTP Requests and Responses in a Flow Demo using Power Automate | Softchief Learn

Was this reply helpful? Yes No
DrFrank Microsoft Employee on at

Like (0)

Report

The end user may not be on the tenant and thus is not sure to have access.

Was this reply helpful? Yes No
Verified answer

DrFrank Microsoft Employee on at

Like (2)

Report

I was able to solve this with the help of a friend.

The trick was getting the file contents and correctly formatting the response.
I will note that there seems to be a bit of a lag when I'm updating the file and getting the file contents. I.E. I make updates, but get file contents is returning stale data. That's a topic of another thread.

Was this reply helpful? Yes No