Process Automation

Hi, I have a below output from my expression My requirement is if "expr" of every Dictionary contains "rowcode" that row code needs to be replaced by "expr" of that particular rowcode (for eg: "(FRML_88_1+FRML_88_2)" this expression contains rowcode so i need to replace it with expr "((123/12)+(1284*64))" and  the final output be like  "(((123/12)+(1284*64))*(9090+122))"

Hi All, I have recently got a chance to go through the academy course on Appian RPA Excel Data Provider and it is really good.   I'm looking to build simple use cases like read excel file and store it in PV only by using low code modules. I attempted to use features like - Initialization with URL - Initialization with File Parameter - Get Current Item attribute by name/column. is there an academy course/documentation available to use the ExcelMap data provider and how to configure every feature provided in it. I'm looking for this for other low code modules as well. May be its already available and I'm not able to locate. Please suggest some good documentations / academy courses for this. Thanks,Arjun.

Hi, JFI, I am new to Appian and do not have admin access.  I have excel file as below. I want to read each row and process on it. Please suggest me stepwise process for the same  What I have tried so far is, 1. Created process with Excel data provider template, but when executed as it is, I am getting error as below [ERROR] 2021-08-02 12:30:48 03s (0h) - java.lang.reflect.InvocationTargetException Caused by: com.novayre.jidoka.client.api.exceptions.JidokaException: Error invoking method 'processItem' .... Thanks in advance, Mohini

Hi, I have downloaded the "Additional RPA Browser Actions" plug in from community.appian.com/.../additional-rpa-browser-actions How to add it to the Appian console and how can I be able to see it in Modules section. Does that need Admin access ?  Please let me know the process to add this plugin Thanks, Mohini

while import the project I face this kind of issue Project build error: Non-resolvable parent POM for com.novayre.jidoka.robot.test:dataprovider.ksk:0.0.1: Failure to transfer com.novayre.jidoka.robot:jidoka-robot-parent:pom:7.4.0 from https://***demo.appiancloud.com/rpa/repo/ was cached in the local repository, resolution will not be reattempted until the update interval of jidoka has elapsed or updates are forced. Original error: Could not transfer artifact com.novayre.jidoka.robot:jidoka-robot-parent:pom:7.4.0 from/to jidoka (https://***demo.appiancloud.com/rpa/repo/): Not authorized and 'parent.relativePath' points at wrong local POM Any help will be highly apprciated. Thank you, kannan

Hello! I am using low code to evaluate expressions as you see in the image, but it  is not working when I open a Excel file before using the expression. How can I resolve it? How can I save the workflow or make a backup? Thank you in advance for your support.   Andrea R.

Hi All, I am trying to execute the Appian RPA project test case in Jenkins, however, it displays the following output in the console "No tests to run". In case anyone has faced similar issues please share a workaround. Thanks in advance! Pragya Dwivedi

Hello,  I am using executestoredprocedure() function to get the data, but when i am executing the expression rule it is not returning any data. a!localVariables( local!result: executestoredprocedure( dataSourceName: cons!dataSource, procedureName: cons!storedProc, inputs:{ name:"user_id", value:"ankita12" } ), local!result)

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: