Uploading file to Sharepoint Folder

[john.hammond]

Good Morning all,

I'm looking to upload/copy/save an Excel file to a specific Sharepoint Folder. Firstly, my apologies in advance - I am by no means an expert in working with SharePoint. I'm aware that there is the Graph API for interacting with SharePoint, but I have absolutely no idea how that works in practice (is there an idiots guide somewhere as to how this integrates with Blue Prism?). I'd like to think that there was a simpler solution to this particular issue anyway - denoting a save path on SharePoint for the document from with the 'Save Workbook As' object within the Excel VBO - but I cannot seem to get this to work. 

So actually, I guess there are two questions that I currently have:
* Is there a simple way to save an Excel file to a specific folder on SharePoint? If so, how?
* How does Graph API work for someone who's not overtly familiar with SharePoint and indeed API's in general? The documentation is fine but could benefit from some example structures within Blue Prism.

Not sure if it over-complicates things, but the file(s) I'll be looking to upload will just under 6mb - from what I understand, there may be a 4mb limit on the Graph API Upload File action?

I should add: one thing I've seen mentioned is about uploading to OneDrive and then syncing to SharePoint, however unfortunately, my organisation has blocked this.

------------------------------
John Hammond
------------------------------

[saivikas729]

Hi,

Please see if this helps your case :-

​Solution :  Assuming your robot works on file and saves it locally - Make your Process send this as attachment to your mail.
                   Set up a Power Automate flow (free and simple) - to place this file in SharePoint whenever you receive  a Mail with specified trigger and attachment.

Thanks 

------------------------------
Kolli Sai Vikas
------------------------------

[EasyBluePrism]

I don’t have large files (max. 1 MB).
Still, I don’t understand in what form I have to pass the binary file (how the value for the file should look like in the Action "Upload File")? Let’s say my file is called test.csv and it’s on G:\shared\test. What’s the value?

[Neel1]

hello @EasyBluePrism  - Use the latest SharePoint VBO which do not use binary file as input unlike old version which was housed as Web API.  New VBO works for me[ Blue Prism Digital Exchange ] all the input are self explanatory. Let me know if this do not work for you. 

[EasyBluePrism]

Hello @Neel1 ,
Thank you very much for the note, which I will be happy to check.
But what I don’t understand is your hint “...which was housed as Web API”. It’s still a Connector for Microsoft Graph API like before, or what do you mean?

[Neel1]

hello @EasyBluePrism  - SharePoint Connector before version 3.0.0 was supplied as Web API which was having binary file as input.

Post v 3.0.0 - this connector is supplied as VBO not as Web API and it do not have option of Input as Binary file. and also in  latest version, all actions of VBO  are having same O/P which look more standardized. 

[EasyBluePrism]

@Neel1 Thank you! Unfortunately, I get the following message “Internal : Could not execute code stage because exception thrown by code stage: The given path's format is not supported.“. I entered the path as follows: "‪C:\Users\MyName\Documents". However, I have access to this path if I open FileExplorer manually.

[Neel1]

Hello @EasyBluePrism  - For Upload File action & for FIle path Input - You need to give full path of file not folder path

like this.

[EasyBluePrism]

Hello @Neel1 Thank you very much. Yes, of course 😉 But unfortunately it doesn’t work like that either. I get the same error message. I tried other file types and other folders, and I also started with another user. I’m pretty confused now.

[Neel1]

hello @EasyBluePrism  - i am able to upload the file using below inputs. @ewilson can you point what can be issue for @EasyBluePrism 

File Upload snip on SP.

[ewilson]

Post screenshots of your actual configuration of the input variables.

Cheers,
Eric