Process Automation

How knows how to Create a new folder on the" virtual resource" in RPA ? Thank you:)

hi all, unable to import .side into bot, i was trying to build the bot using selenium   FYI, i have attached the screenshot 

As the title says, I would like to be able to extract data from a pdf or word document using RPA. I know Appian has the IDP app, however that requires google AI and a different setup.  What I want to do is extract data from a PDF document, such as an invoice, and input the data into an excel document. Is this possible with RPA? If so, does anyone have any examples?

Hello everyone, I have created a bot to do mathematical operation, will open a notepad and calculator, add two numbers (say n1, n2) and save result in notepad, switches back to calculator will add two numbers (say n3, n4), switch back to notepad to copy first sum. When execute the bot it has completed steps till addition of n3 and n4 and while switching back to notepad, bot was failed with element not found error though notepad application was opened. Could any one please guide me on how to resolve this issue. Thanks in advance.

Dear Experts, There is a requirement that, a given date time, which maybe GMT+05, GMT, or GMT-03, we need convert it to logged user's time. For example, given date time is "7/29/2021 2:39 AM GMT+05:00", my local time zone is "GMT+08", I need convert it to local time, the expected result should be "7/29/2021 5:39 AM GMT+08:00". However, I have tried below functions ( image attached ), no one can meet my expectation.

Hi All, I am using regex match to validate some values but after 20.1 upgrade system is very slow & appian support team is saying it is due to regexmatch.  Can regexmatch go to long running process or infinite loop( no loop has been use to in regex ). Any help would be appreciated .

Is is possible to update multiple fields of a CDT using the a!update()? The documentation shows that you can for a regular array, but with the CDT examples shown, it only updates one field at a time. When I test it out in an expression, it throws an error. I just want to check that I'm not missing anything here.  e.g. a!update( data: ri!submission, index: {"StatusID", "SubmissionTypeID"}, value: {1, 2} ) error thrown: Expression evaluation error at function a!update: Invalid index: cannot index multiple indices of type List of Text String into type CRA_T_Submission  

Hi, I want to read a list of string say {"A","B","C"}. then For A there will be set of specific actions. after that same  for B and C I was able to setup a process variable and pass one value. Can anyone please help on how can I read all values one by one and loop through. currently I am using variable as below Thanks, Mohini

My process model has an integration task that calls an API and then follows up to write into my database, but I keep getting this error when I run it: Cannot index property 'property' of type Text into empty List of Dictionary) (Data Outputs) From what I'm understanding is that the PM can't write a List ({}) to the DB and rightfully so. So in my expression for the output I have this: if( length( rule!myIntegration().result.body.people.person.address ) =0,"", rule!myIntegration().result.body.people.person.address.state.value) I try to tell the expression, that if the List ({}) is empty (or length of 0), then to make it an empty string ("") so it can write an empty string to the DB instead of a List (why the error happens), otherwise if not empty or not 0, to add the value to the DB. I would think this work but I keep getting this error. My JSON API string is as follow: { "people": [ { "id": 1, "person"

I have this expression rule and I need to get the value of one of the keys based upon whether another key property is true or false, I have this but doesn't work: a!localVariables( local!myDictionary: { { item: 1, active: true, description: "Widget", color: "Green"} ,{ item: 2, active:false, description: "another", color: "red"} }, if( fn!index(local!myDictionary,"active","") == true, fn!index(local!myDictionary,"color",null), "") ) To explain further: I would want to return the value "Green" from the key property color due to active property being true and not the value "red" because active property is false.

Hi Everyone, I am working on Integration with Appian to RPA Bot by using Execute Robotic Process Smart Service but it is working not with Activity Chaining in process model. There is another flow in my process model which needs to be executed after the first flow but Appian doesn't allow Activity Chaining in Execute Robotic Process smart service. I have attached screenshot of the Process Model in which first flow is validation and second one is submit. For Integration i need to remove activity chaining before the Execute Robotic Process Smart service, due to this second flow doesn't work/execute. Can anyone suggest solution for this. Thanks.

Hi, So Im trying to get this code to save below into my ri! field but no matter what I do it will not save. Can someone please tell me whats wrong here?

Hello, I have a requirement where I want to use the body present in the XML document as text. And use that text as the rule input value. Is there any way to achieve this? Thanks

if( rule!APN_IsBlank(ri!userOrGroup), "", if( runtimetypeof(topeople(ri!userOrGroup)) = 'type!{http://www.appian.com/ae/types/2009}User', user(touser(ri!userOrGroup), "firstName") & " " & user(touser(ri!userOrGroup), "lastName"), if( runtimetypeof(topeople(ri!userOrGroup)) = 'type!{http://www.appian.com/ae/types/2009}Group', group(togroup(ri!userOrGroup), "groupName"), "" ) ) ) Hello All, Please find the above code ( rule it is to get user or group name ) when you enter a user name it's showing it is  user and when you Test with a group name it's giving me an error  Please look at the code is there any mistake  Thanks in advance 

Who can explain this statement better : "If you're not working on the resource already, copy the AppianRPAagent.exe file to the resource after it has finished downloading."I am wondering if it means that one still need to add "AppianRPAagent.exe " back to the resource created after downloading it to our physical PC , if yes, then how or to where in the resource ? Here is the screenshot of a typical resource : 

Well, Im doing a process model. As an output of my RPA process I can have the execution id as Process Variable. I want to pass this variable to an appian integration to have the result. But it doesn't work, how can I do that?  Thank you so much.

Hi everyone, Robotic processes are missing under RPA integration drop down. Can someone help on why this behavior. This is the screenshot for clarification of the issue:

i am trying index the property "ISOCountryCodeOfIssue", if it is not available in the dictionary (data). We need to default value output. We run the expression , it return back null instead of "BCD" property( { /*ISOCountryCodeOfIssue: "ABC",*/ expiryDate: "10/20/2016", issueDate: "10/20/2011", documentId: "XR58", documentType: "PASSPORT", issuingAuthority: "EN" } ,"ISOCountryCodeOfIssue","BCD") Not sure what am i exactly missing here

Following our deprecation of Nexus in our 7.7 release, we plan to fully remove Nexus in the near future. To ensure any robots you have don't break, please follow the migration steps to switch your default repository. 

How to create an expression rule that returns a list of data from a table in a database?  I already queried in my data using a constant, now I need to create a rule that will returns a list of employee names from a database using the tables primary key (employee_id). 

Hi all, I'm trying to clean up some very messy data by converting text strings representing dates into date objects. The input strings are extracted from various documents (using Appian Document Extraction), so the messiness of the inputs is not something I have control over and cannot be standardized ahead of time. I've found multiple posts on this forum featuring recent recommendations from Appian employee [mention:ab53b06651874f7ba5bfbf12e75aa807:e9ed411860ed4f2ba0265705b8793d05]  to use the value() function for this purpose, so it does seem like this is an expected use case for the function; I'm not trying to do something crazy here. However, the value function does not appear to be working as documented...? This is copied directly from the latest version (21.2) of the official value() documentation on the value() function: Syntax value ( text, [format] ) text: (Text) The string of characters to be converted into a number or date. format: (Text) The

The Maven settings doesn't look like it was well configured after inputting the required parameters. Can anyone please help out. Thank you.

I have a view table which contains 100000 records. What measures are to be considered to obtain faster query results?

Has anyone received this error before in their execution logs "Reason to abort execution was NO_DATA_RECEIVED"? Below is a snapshot of the execution logs. This is on a Windows 2019 VM that I'm running the bot on. I've had multiple successful runs prior to this. So, I'm wondering what this error means, and why I'm suddenly getting it, without any change in code.

Hi Appian Community, I have a RPA process I run on a Windows 2019 Virtual Machine via VirtualBox, on my MacBook Pro. I've run this process successfully 20+ times which takes around 1 min 20 seconds from start to finish Today, however it took 1 hr and 33 minutes to run, which is odd because I hadn't changed the process or inputs at all. I decided to let it run till it hit an error, and was surprised that it actually finished. Does any one have any input as why RPA processes would be this slow? Or what factors I should look at to make a RPA process faster?  The process itself just goes on a website and tries to grab some values off the site. Below is the execution logs where I noticed the bot just stopped running after it opened the browser and ran through another gateway. And you can see on the next line that it took 44 minutes for the bot to figure out that the "element was not present." It was a very simple gateway that just determined if a browser element