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)

enter image description here

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.

  1. 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.

  2. We have Premium connectors!

This is my "work" up till now:

enter image description here

these are separate actions:

a)

enter image description here

b)

enter image description here

c)

enter image description here

d)

The error I usually get is on this step: 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.

enter image description here

e)

enter image description here

f)

enter image description here

I used this for the variable:

substring(  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 was guided by this:

https://powerusers.microsoft.com/t5/Building-Flows/Automatically-download-a-file-that-is-in-an-url-link-inside-the/m-p/761142#M105122

0

There are 0 best solutions below