SOS: Need help using SharePoint as a File Store

Hey folks,

I have an application that uses a cloud sql backend for table data storage; however, we would like to use SharePoint for a file store (for image and file storage). I am trying to rack my memory for how to set this up. I believe it is something peculiar about how to modify the root app folder path. (For a shared Google Drive, it is ‘/[TeamDrive]MyTeamDrive/myFolderPath’ where ‘MyTeamDrive’ is the name of my shared Google Drive), but does anybody know what the setup is for Sharepoint?!?

Thanks a ton!

Landan Quartemont

SOLUTION: You need to put ‘SHAREPOINT_SITE_ID_mySharepointURL/myFolderPath’ where ‘mySharepointURL’ is the url of the site you would like to read and write from.

2 Likes

I have the same issue in an application. I’m trying to generate a PDF report inside a SharePoint library, but it doesn’t quite work. If I do it in a Google Drive folder, it works fine.

I already know the library ID, and it is in the format:
SHAREPOINT_SITE_ID_mydomain.sharepoint.com_be05adXX-bXXc-7898-af60-793461202937_1ed94458-b6ea-46ca-ad46-609a2c5dbXXX, and that’s what I have set in the app’s Default app folder.

In the create a new file task:

File Store = Default

File Folder Path = empty

File Name Prefix = has a concatenation

The bot creates a folder in Google Drive named SHAREPOINT_SITE_ID_… and generates the PDF file inside that folder.
I assume the Default app folder configuration is incorrect.

What am I doing wrong?