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

Question

I have a system which automatically records audio files to a location on the C drive (C:\Audiorecordings) and I need to get those files to Sharepoint automatically as the users are busy with other tasks and can't be expected to manually sync things every time, nor are they tech savy so I can't expect them to manually configure or set things up every single time they use the system.

If I try to use OneDrive then the recording location needs to be changed every single time to the user's OneDrive and from there it will go to Sharepoint. That doesn't work for my purposes. The recording software will only archive to a network location or the system, it doesn't accept URLs or anything else.

What I need is a way to have my system able to push the files daily, regardless of user, from the C drive over to Sharepoint. I've been unable to find a method thus far which allows me to do that the way I need it to, ideally without involving 3rd party software which is very difficult for me to convince my superiors is necessary.

Thanks!

Answer 1

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.

Answer 2

Dear @Phil Grubaugh,

I hope you are doing well.  

My apologies for reaching out to you again to ensure everything is progressing smoothly on your end. If there's anything you'd like to share or if further assistance is needed, we're here to help. Your feedback is important, and I want to make sure nothing is left unattended.

If you see any replies, bring helpful information, please kindly accept it as an answer and vote it up by your original account which raised this question. Once marked, it will automatically pin to top. As other users will also search information in this community, your valuable marked answer will definitely also help other users who have similar queries easily to find the correct channel and useful information more quickly.  

Looking forward to hearing from you.

Thank you for your patience and understanding. 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.