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

Aishwarya Apte 5 Reputation points
2023-03-23T17:59:18.42+00:00

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.

Microsoft 365 and Office | Office Online Server
Microsoft 365 and Office | Excel | For business | Windows
Windows for business | Windows Server | User experience | PowerShell
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Limitless Technology 44,776 Reputation points
    2023-03-24T12:25:50.95+00:00

    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–

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.