28-08-24 03:37 AM - edited 28-08-24 03:38 AM
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?:
Answered! Go to Answer.
15-09-24 10:11 PM
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
15-09-24 10:33 PM
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
15-09-24 10:44 PM
That was impressively quick! Thanks.
16-09-24 04:42 PM
@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