You’re offline. This is a read only version of the page.
Announcements
133
I get the sense this may not be possible, but here it goes ...
I am building a flow that is triggered by an email, and it's supposed to capture the URL string and download the referenced file. When I use an URL to a specific filename, it works great. Unfortunately, the system (ERP system using Fusion Reports) that generates the URL and sends the email sends me a URL like this:
Share
Reporthttps://servername.com/ECP_20.07_A/aspx1/QuickLink?MessageID=12345That URL then redirects the browser to another URL that looks something like this:
https://servername.com/ECP_20.07_A/aspx1/Home?DashboardID=12345&ReportID=12345&ReportName=ReportName&QuickKey=12345abcdeMessageID=12345&The browser then automatically downloads the report file successfully to my PC. Not knowing about Fusion Reports, I am assuming the report file is being created on the fly by the backend server, so there is no direct file to reference in the URL.
So, I guess my question is ... can Power Automate handle this scenario in any way so that the file can be downloaded to a SharePoint location and I can manipulate it further in the flow?
I have managed to capture the redirect by using a 2nd HTTP Get after the 1st one fails (run after). I now have a successful URL connection to the page that generates the file. Problem is ... the file that gets downloaded is actually the HTML page not the XLS file I am trying to download.
So now, I am trying to figure out how to "wait" and capture the file that this new URL generates. As noted above, the URL does NOT link to a file but rather a report page that generates the file and pushes it to the browser to download. I just don't; know how to capture that file when "it's ready".
All responses (
Answers (
