Process Automation

Hi All, My scenario is to filter the below view column in appian expression rule using the two rule inputs of "date" dataype(startDate,EndDate), We can see in screenshot, the  column is of text and its in concatenated way, is it possible to filter this from appian? Could you please help me on this. Thanks in Advance.

if( isnull(ri!type), {}, a!forEach( items: a!queryEntity( entity: cons!POINTER_TO_DSE, query: a!query( filter: a!queryFilter( field: "type", operator: "=", value: ri!type ), pagingInfo: if( isnull(ri!pagingInfo), a!pagingInfo(1, - 1), ri!pagingInfo ) ), fetchTotalCount: true ), expression: if( ri!type = "Text", updatedictionary(fv!item, { textField: true }), if( ri!type = "Decimal", updatedictionary(fv!item, { decimal: true }), if( ri!type = "Date/time", updatedictionary(fv!item, { dateTimeField: true }), if( ri!type = "Integer", updatedictionary(fv!item, { integer: true }), if( ri!type = "Date", updatedictionary(fv!item, { date: true }), if( ri!type = "Boolean", updatedicti

Hi, How can I print the numbers between two numbers. Eg: Number 1 = 1, Number 2 = 5. Expected output 2,3,4 Kindly help. Thanks in Advance

RPA process cant scan Drop down components from appian and ends the process when it comes to drop down, it takes id as a random number when i gave recorder by interacting with dropdown, So what i was trying to do is create rpa process to automatically login into my appian designer and create an interface, so when i try to press new which is a drop down the interaction is not being performed

a!localVariables( local!metadataJSON: if( a!isNotNullOrEmpty(ri!metadataJSON), a!fromJson(ri!metadataJSON), null ), local!result: a!forEach( items: local!metadataJSON, expression: a!localVariables( local!section: fv!item, a!forEach( items: local!section.questions, expression: a!localVariables( local!questionrow: fv!item.questionrow, a!forEach( items: local!questionrow, expression: if( fv!item.questiontitle = ri!targetField, updatedictionary(fv!item, { "responsetext": ri!value }), null ) ) ) ) ) ), local!metadataJSON ) I have a nested json. I need to update its field "responestext" if its questiontitle is equal to the parameter. Then return the new json. But the original variable metadataJSON is not updated. Is there an

i tried but i did not get exact output, any one try this .. a!localVariables( local!expression: "x+y-x*y", local!result: a!forEach( items: enumerate(len(local!expression)) + 1, expression: local!expression[fv!index] ), local!arryIndex: { x: wherecontains(touniformstring({ "x" }), local!result), y: wherecontains(touniformstring({ "y" }), local!result), }, local!etdata: a!update( data: local!result, index: { local!arryIndex.x, local!arryIndex.y }, value: { 10, 20 } ),local!etdata)

Hello, I am learning query entities and I am getting the warning message (missing domain prefix).  cons!UA_DSE_STUDENTSINFO is mapped to UA_Students DB. I believe it is configured properly because I use the same constant to write values to DB. I am getting the same warning message when I try to use sorting. 

hi, I am trying to create a BOT that will read records from Appian DB, hit a website, extract information (get attributes) and update few other columns of the DB. The table is The BOT reads restaurantname (in a loop), get attributes (status and date) and update the DB back this is what I have Loop is: foreach pv!restaurant.restaurantName Update value in search is "interact with element" with value as fv!item Get Date is 'get attribute' with target as restaurant.inspectionDate where restaurant is a variable of type CDT that has when i run this BOT (through a process model) I see the restaurant names are picked up fine by the loop (one after another), however the status and date values that gets updated is for the last entry in the table (in this case: Gallery Market & Cafe)  so when I see the process variable in BOT after it has run it is  Value [{"restaurantID":1,"restaurantName":"True Food Kitchen","restaurantStatus":"Status: Permitt

I need an expression which finds corresponding value based on ranges: Input:x{v1,v2,...,vn+1}{r1,r2,...,rn} Result:if (x<=r1) then v1else if (x<=r2) then v2....else if (x<=rn) then vnelse vn+1 Thanks

Hi, we are facing issue with executing “Open Browser(Edge)” action stage in Appian RPA for “https://xxxxx.xxxxxxxx.local/Reports/Pages/Folder.aspx” URL. Getting below error while executing it. Kindly give your suggestion.

Hi folks, I have a requirement like display the number of resignation cases per quarter and the data in grid format. Facing issues to fetch data by quarterly. Please help me on this, Thank you. 

Hi, I have created a BOT (as suggested by the Appian RPA tutorial) to update a single DB row and it works just fine..Here are the steps in brief My Appian DB: BOT is 1. opening the browser: https://inspections.myhealthdepartment.com/va-arlington 2. updating value in search: pv!restaurant.restaurantName (comes from the process model which retrieves the data from the DB) 3. click on search button 4. Getting status (from UI - CSS selector) and updating restaurant.status 5. Getting date (from UI - CSS selector) and updating restaurant.date This is my CDT and the process model My process variables: Get Restaurants to Search Node: Execute the RPA and saving the values in restaurant variables Writing to the restaurant variables:   Updating DB This works just fine. The status and date field on my DB gets updated with the value it extracts from the https://inspections.myhealthdepartment.com/va-arlington Problem: Now I am trying to do this for mult

Hi, We have a requirement in Appian RPA where robot needs to open a website which is having 'http' and NOT 'https'. When I'm using 'Open Browser' action it is showing to provide a valid URL. Could anyone tell a solution on this?

Hi, we are facing issue with executing “Open Browser(Edge)” action stage in Appian RPA for “http://xxxxx.xxxxxxxx.local/Reports/Pages/Folder.aspx” URL. Getting below error while executing it. Kindly give your suggestion.

Hi All, I have a requirement where Appian RPA needs to pull an excel file from computer's local folder and pass that to a process model as parameter. Could you please help me on how Appian RPA can pull file from local folder and also if it is possible to pass the file as parameter to a process model? Thanks, Sudip

I want to set up configure or flow to process multiple if conditions. If(condition= true and condition2=true), true, false) Takes a specific path if condition is true. Wanted to know if it was possible

I was trying to follow this course for RPA Windows Automation: https://academy.appian.com/#/online-courses/b08d47ca-0cac-42a4-803d-7384e0127dc4 The course stated to select the Element Selector to Name instead of Automation ID in Interact Element Action, and select the parameterized variables they told to create for the Element Selector Name. The problem is this doesn't work on my end. When I switch the Element Selector to Name and select the parameterized variable, the bot is unable to find the element as shown here:  However, when I deselect the Parameter checkbox in the variables, I was able to proceed with the Action, but the value of the clicked number in the calculator doesn't save in the variables:

While trying to check an empty map, a!isNullOrEmpty and a!isNotNullOrEmpty are not working, rather giving opposite result.  The result of a!isNullOrEmpty(a!map())should be true but the function is returning false. Not sure if this is a bug but something that might need the engineering team's attention. [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05]

A,                                             1 BC,                                          2 DEF,                                        3 GHIJ,                                       4 KLMNO                                   5 ---------                                     -- A to Z                              &nbsp

Hi, I am trying to call the Appian RPA robotic process from Appian. I have created a connected system and integration object. In the integration object i have selected the operation as 'Execute Robotic process' but I don't see any robotic processes to select. The following message is displayed there "You do not have permission to retrieve the list of robotic processes.".  I could see the robotic processes when I login to RPA with same login and I have the same permissions to resource, user and robotic process. I do not know what is missing here. Please advise.

Hi, I wanted to try MS Outlook Java Module using Custom Code to process specific emails which are coming to a mailbox.  I was able to complete the below pre-requisites with the help of the documentation - https://docs.appian.com/suite/help/22.1/rpa-7.13/custom_code/configurator.html JDK Version - 1.8.0_221 Maven Version - 3.6.3 IDE - Eclipse Neon Post this, I had created a new Robotic Process using blank template. The project which got downloaded was extracted and imported as a Maven project. After importing, I got an error message as mentioned below -  "No marketplace entries found to handle jidoka-maven-plugin:8.1.0:generate-resources in Eclipse.  Please see Help for more information." The overview of my pom.xml is as mentioned in the below screenshot.  Within the pom.xml, I was able to see the error - "Plugin execution not covered by lifecycle configuration: com.novayre.jidoka:jidoka-maven-plugin:8.1.0:generate-resour

Hi everyone, I've a task that say: Convert 12/12/21 to December 12, 2021 and he gives me this hint Hint: You need to use two Appian functions: text() and datevalue() this is the task on the image below. can anyone would help me to do this task.

I want to Create time slots for specific interval and get a List of all slots (like 20 min or 30 min slot) for Interval.

I have the following which i saved as a process variable of type text { "userId": "abc123", "submissionId": "111222333", "createdDt": "2022-06-17T04:07:19.611Z"} I want to remove spacing between the commas and colons, trying to do so with substitute(pv!text, ": ", ":") and substitute(pv!text, ", ", ","). It works for the colon, but not for the comma, so the result is the following { "userId":"abc123", "submissionId":"111222333", "createdDt":"2022-06-17T04:07:19.611Z"} Also, when i use stripwith(pv!text,","), the comma can be affected and removed. Wondering why substitute cant do the same. Any ideas as to why this is happening or how else I can remove the space between the comma?