Uploading files from a single system with multiple users to a Sharepoint site automatically

Dear @Phil Grubaugh,

Thank you for posting your question in the Microsoft Q&A forum.

I understand you're looking for a way to automatically push audio files from C:\Audiorecordings to SharePoint daily, without requiring users to manually configure or sync anything. According to my research, I recommend you try using Microsoft-native tools, specifically Power Automate which can be set up once and run reliably in the background.

Power Automate can be configured to monitor a local folder and upload new files to SharePoint. Since Power Automate doesn’t natively access local drives, you’ll need to install a local data gateway, a lightweight Microsoft service that bridges your local system with cloud flows.

Step 1: Install On-Premises Data Gateway

• Go to Install an on-premises data gateway
• Download and install the Standard Mode gateway on the PC where the audio files are stored.
• Sign in with your Microsoft 365 account.
• Name your gateway and set a recovery key (you’ll need this if you ever reinstall).
• Complete the setup and ensure the gateway is running.

Step 2: Share the Local Folder

• Share C:\Audiorecordings on the network (if not already shared).
• Ensure the account running the gateway has read access to this folder.

Step 3: Create a SharePoint document library

For more detailed instruction: Create a document library in SharePoint

Step 4: Create a Power Automate Flow

• Go to https://flow.microsoft.com/
• Create an automated cloud flow. Give the flow name

Step 5: Select the trigger When a file is created (properties only) from the File system action.

Step 6: Now change the connection and add a new to provide the below data:

• Connection Name: Name of the connection
• Root Folder: The folder path of the local network drive.
• Authentication type: Windows
• Username: Provide machine name/ Administrator name(personal) or domain/ username (if you do know, in the cmd, type whoami).
• Password: Provide the password
• Gateway: Choose the gateway or install the gateway here: Install an on-premises data gateway

Step 7: Then, provide the root folder by clicking on the folder icon.

Step 8: Add the ‘Get file content’ action from the File System connector, provide the file path using dynamic content, and click on ‘Show advanced options.’ Then, in the ‘Infer Content Type’ field, select ‘Yes.’

Step 9: Copy files and folders to SharePoint online using power Automate

Step 10: Since you want to create the file in the SharePoint library. Add the ‘Create File‘ action from the SharePoint Online connector. Then, use dynamic content to provide the site address, folder path, file name, and file content.

Step 11: Now click on Save and run the Flow manually. Once the flow runs, add a file to the local network drive. Step 12: After the flow runs successfully, go to the SharePoint documents library, and you will see the same file successfully copied from the local desktop to SharePoint. You can copy a file from the local desktop folder to the SharePoint library using Power Automate.

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.

Thank you for your patience and your understanding. If you have any questions, please feel free to reach out.

I'm looking forward for your reply.

If my answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.