Hi,I'm using the Microsoft 365 - Excel object and working around all the limitations of Microsoft's limited end points.The Microsoft 365 – Excel VBO User Guide for the Format Fill action and 'Body' Parameter advises to enter: "The JSON payload with f...
I'm getting mixed results when I try to write the content of a Collection to Excel using the Microsoft 365 - Excel::Write Collection action. Sometimes it works, in particular with simple Collections with limited content.My current collection has aro...
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 perfo...
I'm using Browser automation, using Edge and BP v7.1.1.If I use 'Get Attribute' and the Web Y attribute to get a Y-axis number value.Then use that Y-axis number value in the action: 'Global Mouse' Click Y to select the row.It clicks on a different ro...
This wasn't at all obvious to me so I thought worth mentioning:
When using the VBO Command Prompt : Run BAT. File, it doesn't work if you step through it in debug mode. You have to run the process using the Go button and take your hand off the mouse...
Can I solve my own Question? Problem was double quotes in the data. Initially I didn't think they were a problem because a line near the top of the collection had what I thought were double quotes without error. Turns out they were two single quot...
Seems there is some sort of limit. 16 rows in my Collection and it works fine. 17 rows and it fails. (Its not the data content of row 17 either - I removed a random row to take it back down to 16).
Does anyone have experience using this object? If I step through the object it is failing at the 'Set Range Value' step with the Status Code 400: Our 'Utility - JSON' object is the latest v10.0.1.
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...
