Home > Forum > General > Connect to SP Online and exchange files

Connect to SP Online and exchange files
0

Hello Everyone,

I am looking for solution to exchange files between WebCon and SharePoint Online.
I was thinking about built-in actions in WebCon ("add an attachment to a list") as described in this article:
https://community.webcon.com/posts/post/creating-a-sharepoint-site-with-a-webcon-bps-action/203/3

Unfortunately probably because of MFA I am not able to establish connection with SPO (I get error "The sign-in name or password does not match one in the Microsoft account system").

I don't have SDK purchased, therefore I won't be able to create custom action to send these files.
My attachments are also greater than 4MB, so Microsoft Graph is not an option as well.

Do you have any other suggestions what to use to exchange files between these two systems?

Thanks in advance.

MVP

Hello Mateusz, what about this kind of exchanging files: https://community.webcon.com/posts/post/adding-attachments-to-onedrive/183 Does that help? There is also another post here in the forum about adding attachments to Google Drive via REST API. I know it's a different platform, but maybe it's the right direction to implement it. I don't have a SharePoint version so I can't test it out.

MVP

Hi Mateusz,

you are right, this error message may refer to MFA. Isn't there any chance to create a service account without MFA and without chaning passwords? The IT could even set the password inside Designer Studio, if they want to make sure no one knows it.

I have one other "crazy" workaround in mind. If nothing fancy is done to the attachment binaries you could probably use PowerShell to retrieve the binaries of the attachment, store and store it on the hard drive. If this works you could go down two roads. Storing the file inside SharePoint using CSOM and an App, you need this to circumvent the MFA restriction.
https://www.c-sharpcorner.com/article/connect-to-sharepoint-online-site-with-app-only-authentication/
The other option would be to install Onedrive, sync the SharePoint Library and store the attachment there.
This is only an idea, and I haven't tested any part of it.

Best regards,
Daniel