Microsoft Graph - Excel

[JeremyRTDean]

We are transitioning to use SharePoint as the file location for our bots to use.  I've managed to navigate folder structures in SharePoint using a bot process and identify/download files OK using the Microsoft Graph - SharePoint VBO.

I'd like to perform some simple actions using the Microsoft Graph - Excel VBO from the DX.  Initially just get a range of cells into a Collection.  I have the file ItemID.

But I don't understand the Inputs and there are no descriptions.  How do you drive this thing?  For example, what should the inputs be for this?:

[JeremyRTDean]

On the 'Check if Worksheet Exists' issue where the worksheet name has a space in it, I've tested this a few times now and it consistently fails to find the worksheet if the name has a space in it.  Here is the Worksheet Exists action in the Microsoft 365 - Excel

© 2022 Blue Prism Limited
Licensed under the Blue Prism Asset License and Support Terms
https://digitalexchange.blueprism.com/fileMedia/download/a9111324-3192-43ff-9166-566620ca1182

[ewilson]

Hi @JeremyRTDean,

Yes, turns out there is a bug. It seems the action is URL encoding the value of the worksheet name (i.e. replacing the space with a %20 and writing it back to the local variable in the action. The problem is that it then passes that value into the Code stage that does a comparison of retrieved worksheet names, and as you can imagine the worksheet name returned from Graph includes the actual space instead of a URL encoded value.

We'll publish a fix for it tomorrow.

Cheers,
Eric

[JeremyRTDean]

That was impressively quick!  Thanks.

[ewilson]

@JeremyRTDean version 1.5.1 of the VBO has been posted to the DX. You can access it here: https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-365---excel 

Cheers,
Eric