Process Automation

Hi, I want to show 'No URL' where url is not available ("") for any party. But that needs an indexing. This is for one party. If we want to do it for multiple parties, Can someone please suggest how can I do the index to get the actual result

I have a Matters dropdown and a Sub Matters  dropdown that get their options from related tables. I want to make the choices in the Sub Matters dropdown dependent on the the selection in the Matters table. I know there needs to be a Query in the following expression section somewhere, however I am still trying to learn Appian and was hoping someone help me with the query and where to insert it..

Hi All, Is there any function that returns the last date of the current year  Thanks in Advance

Hi,     I have a complete flow of RPA process and I need the progress of the flow to be showcased in the interface created automatically. How can I achieve this?

starting number is 100 & ending number is 200, I need all numbers that contains 5

Hi,In A Bar Chart, Can we display Tooltip value in for example in 1D 1H 1M 1S. Suppose we are getting data in floating 176.5439, and we need to display in 176D 13H 3M 13S. I have converted the value, but a!chartSeries says a!chartSeries accepts only Number (Floating Point) data (List of Number (Floating Point)): Array of decimal data values to display in a chart.

I need to get the admin group in an specific app where the app name is going to be a rule input. Any suggestion? is there anyway to achive it?

Hi All, To display wait time which is waiting for more than a day. We are converting createdDate(date time format) in days and hours. Now, ask is to display the WAIT TIME only when it is more than 1D 0H.But, queryFilter field is createdDate(date time format). In that case how can we display this.Query Filter which I'm using at present  (I know it's not correct), could anyone help me in getting this expression correct.

Hi , I am getting below error the attached code when there I don't pass value for ri!gLLs. Can someone please help in resolving this. "Expression evaluation error at function 'remove' [line 67]: Invalid index (0) for list: valid range is empty" a!localVariables( /* Appending logged in user with GLLS from LUContacts if logged in user is GLL */ local!isLoggedInUserGLL: rule!APN_distinct( if( rule!APN_isEmpty(ri!gLLs), {}, if( and( not( contains( touniformstring( index( a!groupMembers( group: cons!RGRACSLBL_GROUP_AGLL, direct: true(), memberType: "USER" ), "data", {} ) ), touniformstring(ri!loggedInUser) ) ), or( contains( touniformstring(

Hello, How can we get value after an operator for the value which we separate using split function. Eg. 249.5832 Using Split for 249.5832, we can get 249 and 5832. But, I want value after split. If I index with 2, it's getting 5832, but I have to use this for a!forEach for the below expression. For below expression, getting the result as in the image local!calP1days: a!forEach( items: local!P1, expression: if( a!isNotNullOrEmpty(fv!item), split(fv!item,"."),{} ) ) , local!calP1days)

Hi team, I am Exploring Excel RPA , docs.appian.com/.../actions-excel-license-required.html I want to get values into Excel cell as columns  which are stored in DB, i have a CDT name resources with fields EMP-ID and Name, i Added some values in DB creating record actions. then Using Write into Excel Action in the value Array I  tried using both record type and CDT  recordtype!resources.name / 'type!{urn:com:appian:types:ERP}ERP_Resources'(), But when i use CDT I am getting the fields in the CDT like EMP-ID and name ,but not the values in the DB. as shown below i came to know that we have to give the List of CDT's  in value array , but I don't know how to do it to get the values under Name column . Help me in Finding more resource to know more about the Excel RPA configurations. Thank you  J Vinay

What does the outputs represents? How to get a process model variable into the RPA's local variable? Is there any way to send process model variables into same RPA from where it was triggered?

Hi, I have a requirement to update a date based on a condition that if the given date is of last 2 dates of that particular month, then I want my rule to return first date of the next month and it should be applicable for all the dates whether the month has 30 or 31 days or if it is February or leap year. For eg: 27/02/2023 should be converted to 01/03/2023. I have written following code for this, but my senior asks me to optimize the code and reduce the use of if conditions. Please tell me what else I can do edit:a!localVariables( local!currentMonth: month(ri!requestDate), local!currentDay: day(ri!requestDate), local!currentYear: year(ri!requestDate), local!isLeapYear: isleapyear(local!currentYear), todate( if( and( tointeger(local!currentMonth) = 2, or(local!isLeapYear), contains( tointeger({ 28, 29 }), tointeger(local!currentDay) ) ), concat( tointeger(local!currentMonth) + 1, "/

I am trying to perform related action for a record but I am facing below issue  This issue happens for only particular record where as for other records it is working fine. Any help on this would be appreciated

Hi  I am able to extract the document from fillable field in pdf by following the tutorial in forum. I tried to select handwritten notes by holding shift button and select the word but it didn't work for me.  Please guide me to get the tutorial available for handwritten notes. Also is there anything which i have to take care for handwritten notes different than the fillable pdf. 1. I tried to select the work by holding the shift button 2. Preferred vendor - Appian Please guide. Thanks in advance

Hello,  It seems the documentation for the RPA Actions is limited and I would like to know which Action should be used when the need is the robot to update Excel File,  For example I guess one of the following two will be:  Initialization with URL or Initialization with File Parameter Let's assume the file is located on disk C:\Exce\ what parameter should be passed to any of these two actions in order the robot to open the excel and start filling in data after that ?

Hello team, i would like to use an expression rule in timer to define the day when a PM will run based on the values in DB. Every month the cut off day for processes is different and its defined in the DB. The expression rule which i call inside the timer is: =rule!ICH_getCutOffDataByFilters(    year: year(today()),    month: month(today())).day, and it simple calculate the cut off day for current month. But when i publish the PM i am receiving the following error message: ERROR:EVAL:@reason=Expression is invalid (1 token(s) remain after parsing) Any advice please? Thanks

Hi, Im new to using reject function.  Now im using the reject function in a process model in a script task  In the input : I am calculating a map which looks like this :  {    id : <>,    account : <account_cdt(id, name, hold_code)>  } Now in the output tab I want to use reject function to reject all those accounts who have hold codes null ... but then my requirement is that the ID should remain in the output I am using reject function like this :  reject( fn!isnull(_),     a!forEach(           items : ac!map,           expression : {                  id : fv!item.id,                  holdCodes : index(index(fv!item, "account"), "hold_code")           }    ) ) Now I know this wont work, but can anyone suggest me how to make it

Hi, I have a requirement to append the values of a particular computation to a local variable using append function  The rule goes like this :  a!localVariables( local!data : {"x", "y", "z", }, local!finalValues, a!forEach( items: local!data, expression: append( local!finalValues, performSomeComputation(fv!item) ) ) ) now the problem is, the local variable is not getting updated no matter what, I tried using update dictionary as well as insert(local!finalValues, length(local!finalValues) + 1, fv!item) .. but still it wont append .. is there any other method I can use to append values ?

when I am trying using task recorder,  it is coming like.  " you are trying to sign in using unsupported browser" like google is finding it is a robotic process and not letting the sign in to take place

I am taking the Appian Automation (Senior Developers) course and I am on the step Tutorial: Automate Windows Applications (RPA). The task recorder doesn't recognize the calculator app even though the shortcut is listed in the start menu. What can I do to get the task recorder to recognize the calculator so I can use that app?

Hi, I have run the rpa installer successfully on my system but still the status of Robot is Offline in RPA and the appian icon in the toolbar is coming grey. Can anyone tell why this is happening and how can I change the status to Online. Thanks

a!localVariables( /* 1 - requestId, 2 - Department, 3 - Sub Department, 4 - Requestor, 5 - Status, 6 - Ship Name, 7 - Task Status */ local!inputList: split(ri!input, "#$"), local!requestId: tointeger(local!inputList[1]), local!deptIdList: tointeger(split(local!inputList[2], "-$-")), local!subDeptIdList: tointeger(split(local!inputList[3], "-$-")), local!requestor: touniformstring(split(local!inputList[4], "-$-")), local!shipId: tointeger(local!inputList[6]), local!statusIdList: touniformstring(split(local!inputList[5], "-$-")), local!taskStatus: toboolean(local!inputList[7]), local!result: a!flatten( a!forEach( items: enumerate(5), expression: a!localVariables( local!batchSize: 2000, local!startIndex: if( tointeger(fv!index) = 1, 1, 1 + ((fv!index - 1) * local!batchSize) ), /*rule!BUS_QE_getBUSReqViewDetails, BUS_QE_getBUSReqVWDtlsTest*/ rule!BUS_QE_getBUSReqVWDtlsTest( fetchtotalcount: t

Hello, The documentation says I should be able to execute and return the results of a robotic task in an interface, but I'm having trouble figuring this out. My task is working correctly in the RPA, and I'm also able to run it in a process model, but I can't figure out the SAIL recipe to get the results in an interface. The farthest I've gotten is that I know I need to use a!testRunResultForId(), but it says I need to input the "Test run ID," and I don't know where to find that. Can someone help me out? Thank you, Jason

I have CDT with following fields While using a!toJson , it is EXCLUDING fields which are having NULL values except fields with TEXT datatype. Expresion: -  a!localVariables( local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"), a!toJson(local!data)) Result:   Note: If I use parameter removeNullOrEmptyFields as true, it also excluding text fields which are null a!localVariables( local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"), a!toJson( value: local!data, removeNullOrEmptyFields: true )) Result: While using a!toJson_17r1, it is returning all the fields of the CDT irrespective of NULL values. Expression: a!localVariables( local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"), a!toJson_17r1(local!data )) Result: I want to get the data the way we are getting result while using a!toJson_17r1. i.e. I want to get all the fie