Hello,
I've got a flow where we download files from a sharepoint and then imports into sql databases.
I have all steps working except for downloading the files. The files are hosted on a clients SharePoint.
I've tried to try and find the URL used to download all the files but couldn't find this during inspection.
I can do this using automated browser options but that doesn't work when left unattended and the flow fails.
Ideally would download all the files in the folder as a onedrive zip.
The PAD is hosted on a remote server if that is relevant. Triggered by a cloud flow.
Hi,
Thank you for your assistance.
I tried your response and it looks to be correct and as you put it. I even found this and followed it to the letter. https://learn.microsoft.com/en-gb/power-automate/desktop-flows/actions-reference/sharepoint
Your solution produced the error below:
Power automate List folder Cloud connector call failed with status code 'NotFound'.
Alt solution produced the error below:
Cloud connector call failed with status code 'Unauthorized'.
Seems to be an authorisation error with the client. The account I am using is our own and it is an external guest on their sharepoint. We have access to the shared folder to view/edit/move/delete etc. Now I just need to determine what is missing to allow this connection between us.
Here's how to download all files from a specific folder
These are what my sharepoint actions look like:
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2