Search results

  1. G

    Identifying a Google Chrome Window that is launched from inside a PowerBuilder Window

    Hi All, I am looking to see if anyone else has encountered a similar problem and found a resolution. (I hope the explanation is clear enough as it is a tricky one to explain) We have an in house built css.exe PowerBuilder application. It’s a legacy system. The developers have added new bits of...
  2. G

    Filter a large Collection in Blue Prism

    Hi, I have an Excel File with up to 100,000 rows that need to be split it up. I need to filter the collection based on values in a column. These same values are added to their own individual workbooks. (Usually 10-12 workbooks in total) Looping through the collection is not optimal. Is there...
  3. G

    Communicate Power automate Flow results back to Blue Prism

    Hi there, I am currently using - Blue Prism and Power automate. I pass a variable as an input parameter to start a Power automate flow of updating fields on SharePoint from the web API's section of Blue Prism. I have a check in place at the end of the flow to verify that the fields updated...
  4. G

    I need to Query the DB to find out what Tags are associated with Process's that are running?

    Hi All, I need a SQL query to get the corresponding tags from a running process's session ID from the Work Queue. ( I am just looking to check if a certain tag is in the Queue for the current active process) I am getting the list of active session ID's from the below query. Select distinct...
  5. G

    Win32 can't uniquely identify a Microsoft Edge window

    Hi, Win32 mapper in Blue Prism can't uniquely identify an Edge window in Blue Prism. I can't activate and maximize. Has anyone encountered this problem before.
  6. G

    Adding time to DateTime

    I have a date time - 23/07/2021 23:30:00 I need to add 1 hour to this Expected result: 24/07/2021 00:30:00
  7. G

    Microsoft Word - Save As Object

    Hi, I am getting a compile error when trying to include a timeout as part of the Save as action for Microsoft word on Blue Prism. Code Stage: ExecWithTimeout(Timeout, "Save As", Sub() Dim doc as Object = GetDocument(handle,documentname) doc.SaveAs(filename) newname = doc.name End...
  8. G

    Outlook VBO Unailable

    Hi, ERROR: Internal : Could not execute code stage because exception thrown by code stage: The remote server machine does not exist or is unavailable. Getting the above error when trying to run Outlook VBO - Get received items basic. This occurs occasionally and stepping through manually...
  9. G

    String manipulation

    Hi, I need to replace the 9th and 10th character in a string with 00 1112223334 - Test 1112223300 - Result 111222333 Test 1112223300 - Result
  10. G

    Blue Prism interpreting % as 0 when inputting into SharePoint URL

    I currently am having problems when writing a URL to an address bar. The % in the URL is getting interpreted as a 0 when written to the URL by Blue prism
  11. G

    Email Notification Action

    Hi, Is there a limit on how many recipients that the Email notification action in blue Prism can send to?
  12. G

    Regtex to check if space between an opening and closing bracket in a data item

    Hi All, Looking to see what is the Regex to check if there is space between an opening and closing bracket in a data item. ( john) True (john) False
  13. G

    How to check that every first letter of a data item is Uppercase?

    Hi All, How to check if every first letter of words in a data item is set to uppercase and the rest set to lowercase. ( Variable is the length of words can change in the data item) Data item = "joHn Michael Ryan" = False Data item = "John Micheal Ryan John" = True
  14. G

    Set 2 letter words to uppercase in a data item?

    Hi All, I need to set a data item text to uppercase if the data item length is = 2 This data item could also be enclosed in brackets Eg. data1 = (jp) OR jp Expected result = JP
  15. G

    Check for brackets in a data item and update first letter to uppercase?

    Hi All, I need to check if Brackets are present in a data item. If yes I then I need to remove any blank space inside the brackets. I then need to the set the first letter of the word in the data item to upper case and keep the brackets in place. Test Data Item = (john ) Expected result = (John)
  16. G

    How to remove the last character of a string

    Hi All, What is the code to remove the last character from a data item?
  17. G

    How to check if a data item contains any ",",".","-"

    Hi I need to check if a Data Item contains either "," or "." or "-" Scenario: Data Item 1 = John,Mary Data Item 2 = John Data Item 3 = John- Mary My Data Items can be of different length, but I only want to check if they have any of the above characters.
  18. G

    Filter-Collection Blue Prism

    Hi All, I am having issues around [Utility - Collection Manipulation - Filter Collection] I have a Get Files action which gets all the files from a particular folder and outputs them into a collection in Blue Prism (there are 14 .txt files) I then use the Filter Collection Object to filter...
  19. G

    Writing Collection into Excel or setting a cell value ERROR Blue Prism

    Hi All, I am encountering an issue when trying to write a collection or set a cell value into excel. I am first creating an instance of excel, then showing it and then opening the workbook. When I try and complete any Excel VBO like I have mentioned, I am delivered the same Error message ...
  20. G

    Is there a way to write 2 data items into the one input box in Blue Prism

    I need to write 2 email address into one input field in blue prism. Using the write stage I can write one email address in, however after I write the second one in, it overwrites the first one. Is there a way to space them out. Any help would be greatly appreciated.
Top