Search results

  1. R

    Attaching to Excel fails

    Hi Daenerys, Just a few questions regarding your process. Is there a reason as to why you are using an action to click into Excel? Blue Prism should have a Excel VBO object provided along as part of its software which should allow you to do what you are looking for. There shouldn't be a need...
  2. R

    Duplicate Mail Issue

    Not sure if this is the same issue you are facing but it could be due to the version of Microsoft Outlook being used. I saw on the BP forums that Microsoft 360 outlook may cause duplicate emails being sent out due to drafts being saved...
  3. R

    Process a collection - get file name

    When you are dealing with Collections, you can think of each field as a separate data item within the collection. So if you are trying to grab a specific field from the 'Get Files' Collection, you can set it as this: [Collection Name.Field] Collection Name would be based on what you had named...
  4. R

    Convert month name to month number eg: December - 12

    There's a few ways to go about it but most commonly used would be using the FormatDate logic within Blueprism to convert. One potential way would be to do this: FormatDate([Date],"dd")&"."&FormatDate([Date],"MM")&"."&FormatDate([Date],"yyyy")
  5. R

    Solved Comparing two Collections and providing unique value output - Narrowing down based on 1 field

    Hi Sahil, that was actually what we tried using first but it didn't turn out too well mainly because we only wish to have the unique values only while the remove duplicate will still give us one of those values back. For example here is what would be how the collection would look like...
  6. R

    Solved Comparing two Collections and providing unique value output - Narrowing down based on 1 field

    Hi all, I know this was somewhat answered via https://www.rpaforum.net/threads/comparing-two-collections-and-and-saving-unique-values.14717/ But I would like to see if there is a way to further narrow down a comparison using code stage for Blue Prism. The given code is the following...
  7. R

    Need help with Regex

    Hi Pete, Try testing out using this Regex expression: \b(\w+(?:\s*\w*))\s+\1\b
  8. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    I used the <{CTRL}{W}>{CTRL} send keys to help with closing the browser. But this is only effective if your application is using just one tab on the browser. There was another suggestion mentioned on the Blue Prism forum but I found that the send key was enough for what I was trying to do. For...
  9. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    Closing thread, found solution to this by using global send key function.
  10. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    @RsBhargav Unfortunately, I am only able to try the first suggested step which didn't work. The other steps need admin access which I do not have.
  11. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    Hi all, Is there a way within Blue Prism for us to soft terminate MS Edge application which doesn't trigger the Restore Page popup to occur? In our current state, Blue Prism is able to use the terminate action to close the MS Edge application. But once we try to launch a new application browser...
  12. R

    Solved Collection Manipulation and Writing Specific Data into collection

    Thank you eric! Implemented how you did it and it works like a charm!
  13. R

    Solved Collection Manipulation and Writing Specific Data into collection

    Hi eric, It's a bit of both actually. I do have an Excel file given to me to work as an input file but was advised I should try and manipulate my data within Blueprism instead of within the excel. As such, the screenshots provided were more to to just illustrate how the layout would be. I'll...
  14. R

    Solved Collection Manipulation and Writing Specific Data into collection

    Hi all, I am trying to figure out if something of the following is possible within Blueprism: I have a set of data which I have stored into my collection that I am trying to manipulate and store into a 'master' collection. What I am trying to do is the following: From the collection listed...
  15. R

    Solved Setting Multi-Line text and storing data item variable within another data item

    Hello everyone! I'm trying to figure out if something like this is possible... My issue is two-fold - I have a multi-line text which I need to keep in the same format in order to run a certain command script inside an application. For example, the multi-line command would be something like the...
  16. R

    Multi Bot allocating Resources

    I may not be understanding correctly so please also correct me if i'm wrong in my assumption... When you say resource, you mean as in resource machines right? For example: Machine A Machine B Machine C If so, then when you go into the control room and setup a scheduler for the process, if you...
  17. R

    Multi Bot allocating Resources

    You may need to apply something like a Choice stage for your process to determine which credential name is being pulled. Ex: -Let's say the credential names for the bots are Bot1, Bot2, Bot3 -You have Bot1's credentials in the startup parameters set for your process. When it retrieves the...
  18. R

    Solved Using Regex to capture variable

    Thank you very much! This works perfectly! I was putting the items in brackets without the | separator
  19. R

    Solved Using Regex to capture variable

    Hi all, I'm having a bit of difficulty trying to get a certain regex expression to work properly. I have one part of the pattern figured out. I was able to find something online for one part of the expression of what I am trying to do but I am still rather new to using Regex in general and am...
Top