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...
The collection is 3,803 rows and 31 Columns as it stands.As a workaround I created a workbook using the Excel VBO, Write Collection (Fast) and then upload that to SharePoint. This only takes seconds but annoying that I can't use Graph 100%.
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.
