How do I download Microsoft 365 xlsx file to local folders using PowerShell

Question

I have created a form and created a powerautomate task to link form to Excel online file in documents folder

now my next task is to auto download file once a day, There is no rest service i can use..

if anyone can guide me that will be really great.

Answer 1

Hello there,

This thread contains Powershell script to download documents and save as serial number https://social.technet.microsoft.com/Forums/en-US/009abf5d-126b-42fa-9a36-90fbc0b53039/powershell-to-download-documents-and-save-as-serial-number?forum=sharepointadmin

For the auto download of files, you can use the task scheduler and trigger this activity.

The Task Scheduler enables you to automatically perform routine tasks on a chosen computer. The Task Scheduler does so by monitoring whatever criteria you choose (referred to as triggers) and then executing the tasks when those criteria are met. https://learn.microsoft.com/en-us/windows/win32/taskschd/task-scheduler-start-page

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–