Forum Discussion
Uploading a file to a SharePoint Document Library Sub Folder using a C# Console Application in 2023
I've been scraping the Internet for two weeks using various different solutions given but none of them work in 2023. Most of the solutions provided are old and they do not work with the new libraries and also because of the added security features such as MFA. Also almost all the given solutions threw some kind of error and various people have suggested various different workarounds in comments to get those fixed. So I've been scanning these threads as well trying various different options but after failing, finally thought of posting it here so this would be useful to someone who is facing similar issues.
Why Console app: Because I want to use the Task Scheduler to automate this and run it once per day. Have used other means such as syncing with One Drive but it creates duplicate files every now and then. So thought of using a robust mechanism such as a C# console app but have tried PowerShell scripts as well hoping I will be able to ask the Task Scheduler to run PowerShell scripts on a schedule, but none of them worked.
Just to narrow it down
- I have disabled MFA
- Even tried using an App password (Yes I managed to generate the app passwords successfully, but won't work with C#, always some kind of error, after fixing one you get another but after some point you come to a point where there are no resources on how to fix those errors)
- I'm using SharePoint Developer site to test it out at the moment.
Example site URL could be: https://5mhhvs.sharepoint.com
Created a site called Documents: https://5mhhvs.sharepoint.com/sites/Documents
So my goal is to upload a file regularly to a sub folder in the Document Library of the Documents site.
Wondering if someone can provide a sample code, together with the package names I need to configure using NuGet and the necessary using statements (as there can be conflicting namespaces) either using username/password approach or app password (ClientID/Secret).
Other queries: If there is already a file, will it merge the changes or is there a setting we can configure so that it will merge the changes.
If a user has opened the file on SharePoint (and may be has started editing), will we still be able to upload the file or can we force it?
Hope someone will be able to put an end to end solution here instead of posting links to previous posts.
Thank you in advance.
4 Replies
You are approching this the completly the wrong way, so what you need to do it use the Graph API to upload the files to the subfolder. Don't disbale MFA, registering the app in Azure AD and use those credentials.
You will need to add the correct permisisons in Azure ad:
https://learn.microsoft.com/en-us/azure/active-directory-b2c/microsoft-graph-get-started?tabs=app-reg-ga
How to use graph api in c#:
https://learn.microsoft.com/en-us/graph/sdks/create-requests?tabs=csharp
Upload files:
https://learn.microsoft.com/en-us/graph/api/driveitem-put-content?view=graph-rest-1.0&tabs=cliSidenote:
From you requirements I would suggest that you use Power Auomtate instead, sounds like that could do what you aim to do.
- Thank you for your response, but we are using SharePoint in Office 365 platform (Office 365 Education). Should we still register the app in app in Azure AD in that case?
- Yeah, it's the same not matter what version you're using 🙂 You basicly say this is the app, here's the credentials it will use and here's the permissions!
