Downloading list of URL's from Excel, creating Sharepoint file for each result
I have a list of URL's in Excel.....I would like to download each one and create a file in Sharepoint for each. Does anyone have any ideas to make this happen? Having trouble with my snipping tool, so I'll just write out the steps of the flow I'm trying to use......
Excel -- list rows present in a table
Apply to each value:
HTTP -- GET (column containing URL's in "URL" field)
Sharepoint -- create file (column containing company name for each URL in "file name" field, Body in "file content")
I hope this makes sense.....let me know if I need to clarify.
You can use the HTTP action to get the file according to the URL, and then put the Body of response in the file content to create the file. By the other hand, you need to create the company name and file name are contained in URL, you can use Data operation to extract it, such as spilit() function, substring() function, etc.
Best Regards, Community Support Team _ Lin Tu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.