You’re offline. This is a read only version of the page.
I have been struggling already for some weeks and I can't get it to work in Power Automate.
The issue is the following:
1) I am receiving in my Email (Monday morning) a bunch of system-generated emails that contain downloadable links:
That clickable link is in this form:
https://deu01.test.outlook.com/?url=https%3A%2F%2Fcdn1.test.co/XYZ/&%$!%&/§§abbvcccc => (it is a long URL anyways)
The number of those Emails is like 10 with different names of course but the content inside them (after clicking on the link) is always .csv and always has the same structure.
2) What I wanted to accomplish is to automate that process, to get the content of those links and save them somewhere on SharePoint let's say under the same I am unfortunately stuck on developing the proper actions/triggers in Power Automate to get this work.
3) We have Premium connectors!
This is my "work" up till now:
these are separate actions:
a)
b)
c)
d) Usually I am getting an error here:
The provided 'Http' action URI '*sanitized*' is not valid. The URI must be a well formed absolute URI not referencing local host or UNC path.
e)
f)
I used this for the variable:
Share
Reportsubstring( substring(outputs('html'), indexOf(outputs('html'), 'https://deu01.test.outlook.com')), 0, indexOf(substring(outputs('html'), indexOf(outputs('html'), 'https://deu01.test.outlook.com')), '"'))
Unfortunately, I am not familiar with this kind of flow, especially with HTTPS and so on. I saw something on Google but I don't get it properly...
Any kind of help would be appreciated!!
I think you can download files from links (as long as the link is public and the output of the link is a file rather than a website from which you need to then fetch the file)
(1) Solved: Automatically download a file that is in an url li... - Power Platform Community (microsoft.com)
@M1rzA_V
Can you check the output of the linkURL action in your flow run history to make sure you are passing through the correct URL?
Also, why are you doing an apply to each on the email attachments? You want to create the file output from the HTTP action, not the email attachment?
Dear M,
By my limited experience, unless you have back-end HTTP/API access to the source/link you are trying to access, I do not think you can accomplish this via PowerAutomate (cloud).
What you are trying to do is to mimic human actions ... 'click link', 'go to new browser', 'click download' or something like that.
What you can use however is PowerAutomate desktop (or any other similar RPA). With this you can mimic human behaviour and execute what you want. You can call PowerAutomate Desktop (PAD) flows from PowerAutomate cloud, but it will have to run locally and it uses some different actions/settings stuff.
Hope this helps you further,
Koen
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
All responses (
Answers (