Discussion Categories

Hi All, Through stored procedure how to sync record? If anyone know pls let post your comments.. Getting all values through stored procedure smart service but couldn't able to sync record. https://docs.appian.com/suite/help/23.3/Execute_Stored_Procedure_Smart_Service.html

Hi Experts, I need your help in resolving my issue. I have one HTML template which is being attached in send email node in a process model. I want to add one image in that template. But up on adding the image via a document constant that we are passing in a template   its not showing up like this in the email that we are getting:  But when we are using URL for adding an image in the template its working fine. My question is how to add an image in an HTML template that it will display in the email but using Image file document constant in Appian?

I have a problem to run quiz using 10 questions answers in in foreach loop. I want to save values in a local or rule variable. (question id with selected answer value)  If user modify his answer, then selected Ans value changed with new selected option. I want to do with record type.

I  have a requirement for an organizational chart.  I have an employee-specific table in the database containing the reporting manager column and role.I tried the code but it doesn't expand to down-level resources. I require a dynamic chart to add employees and roles. a!localVariables(local!user: loggedInUser(), a!orgChartField( value: local!user, saveInto: local!user, showAllAncestors: true, showTotalCounts:true ))

hi, i want to know is there any way we can extract data from this kind of string. "[place_id:519fcdaacfd556c0bf591a4bfd61f0c04940f00101f9014600010000000000c002089203064c6f6e646f6e,address_line1:London,city:London,address_line2:ENG, United Kingdom,country:United Kingdom,state:England,county:Greater London,formatted:London, ENG, United Kingdom]" i want to get data as { place_id:"519fcdaacfd556c0bf591a4bfd61f0c04940f00101f9014600010000000000c002089203064c6f6e646f6e",  address_line1: "London", city: "London", address_line2: "ENG, United Kingdom", country: "United Kingdom", state: "England", county: "Greater London", formatted: "London, ENG, United Kingdom" }

on click of submit am getting this error what might be the reason

 Does it means that, for local variable 'outage' the value from database is given through recordtype power outage.

Hi all, I have a use case I have build a webpage using HTML and JS and I am calling it using a Web-API from Appian interface which will be triggered by a safelink.But whenever the user clicks the safe link the page is re-directing to the Web page, but i want to show it inside the Interface , i tried using webcomponent object but it's error saying internal appian urls cannot be used in webcomponent.Is there any alternate way to achieve this. Thanks in Advance.

When triggering a process model from the Receive message event by sending a simple mail, it works fine. I'm having an error like the above when adding an Attachment to the Start process triggering mail also, I'm having an Error with Create Eml File from OOTB Poller "An error occurred while creating the note. (APNX-1-4101-005)" These are the PV ...

Hi Team, I have requirement to get the groups names which has the input value which we pass. For example: If I pass input value as "United States" I should get the group with the name "<App prefix>_United States", India => "<App Prefix>_India" Can anyone please help.

Hello everyone, I am using plugin HTML to PDF. I have used two nodes in process model "HTML DOC from template" and "HTML to PDF". In first node("HTML DOC from template") I am passing process variable for  ###name###  (pv!customer.name) and so on for others. Successfully converted HTML to PDF file but I am having issue with multiple entries. Like: I have total 10 records but in pdf all records shown up in one line with comma separator. Note: Created a rule for this where I get all records but getting issues passing this rule in process model node ("HTML DOC from template"). for example: <table> <tr> <td> <h3> Name </h3> </td> <td> <h3> Address</h3> </td> <td> <h3> Unit </h3> </td> </tr> <tr> <td> ###name### </td> <td> ###address### </td> <td> ###unit### </td> </tr> </table

I must be missing something simple as I cannot even get the sample to work for my custom picker. I have created this expression rule: And then, this is everything on my interface: a!localVariables( local!pickedState, local!stateLabels: { "Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", &

Hi, I'm learning Appian RPA tutorial. I'm trying to create a Robot for ParseExcel Example. I have few doubts while creating a robot. 1. What kind of permissions we need to add there? ( I added my mail id which is registered for Appian is that correct) 2. I installed java in my local system and set in Environment variable also. Do we need to provide the Path here or is it fine to leave it blank? 3. I added my email id which is used for Appian community login in permission and added my local system JRE Path in JRE Path. Downloaded and installed the exe file.  After click on ok The Robot showing offline. 4. If I execute as per following the document it is not working. Below is the execution log  Below is the tutorial document I followed. [View:/cfs-file/__key/communityserver-discussions-components-files/61/9.3-_2800_23.3_2900_-Parse-Excel-Files.pdf:320:240] Please guide me where I went wrong. Thanks, Sadhu Surendra.

I have been in the construction industry for quite some time now and am looking to make a career change. Over the last few months I have learned some AWS and have obtained my AWS cloud practitioner certification. My girlfriend has a job working with appian and she suggests that I learn appian and try to get a job do that. I’m worried that with no prior work experience or a bachelors degree that I won’t be even looked at even after I get the 2 appian certifications (appian associate developer and appian senior developer certifications) does anyone have any experience on this? https://tutuappx.com/ Vidmate

Hello everyone, I am building an Appian process that needs to have only one instance running at a time, since every instance would be inserting to/ truncating the same database table. In order to achieve this, at the beginning of the process I check if the current instance is the oldest among the active instances of the process, through a query to a process report.  This works just fine, the problem is that I want to also check if the oldest instance has, for whatever reason, a node with error and therefore it's flow has been blocked. This way I could kill that instance or skip it in order not to block the other instances in the queue. What I noticed is that even though a process may have a node with errors, the status in the process report remains "Active", so I couldn't find a way to verify through the Report. Even the functions num_problem_tasks() and num_active_tasks() are not helping.  Do you guys know of any efficient way to make this control

which gate way can be used to execute 2 flows at a time

Hi, I am attempting to start using RPA within Appian and the documentation says the host machine has to have Java installed. My organisation won't allow me to download the full version of Java and have asked if I can use a free version of Java e.g. adaptivejdk or Amazon corretto. Is this possible?

I'm Having issues with run Macro licensed version Caused by: com.novayre.jidoka.client.api.exceptions.JidokaException: Error invoking method 'exceljacob->run-macro' at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1316) at com.novayre.jidoka.client.RobotClientExecutor.internalCallAction(RobotClientExecutor.java:908) at com.novayre.jidoka.client.RobotClientExecutor.onMethodCall(RobotClientExecutor.java:764) at com.novayre.jidoka.client.WorkflowProcessor.start(WorkflowProcessor.java:158) ... 22 moreCaused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.novayre.jidoka.client.SDKInvoker.invoke(SDKInvoker.java:56) at com.novayre.jidoka.client.RobotClientExecutor.internalInvokeMethod(RobotCli

Hello there! I am using Export Data Store Entity to Excel/CSV Smart Service to export the data in Excel sheet. If I check database, there are records, but through the smart service, in Excel sheet, I am getting the message "No data available due to empty data source, applied filter/selection criteria, or fields visibility." Also, I have applied filters for specific data shown in excel sheet on the basis of id.  = a!queryFilter( field: "caseid", operator: "=", value: pv!transactionDetails.caseID_int) Please assist me in this. Thanks

Hi all, I was trying to get know more about "UUID" and how it works, I came across couple of challenges , Which both include "Record Type" object and it's UUID. 1. When i'm trying to pass UUID of record object in  getcontentsbyUUID function (Content tools plug in) ,it's throwing an error   "No object with this UUID has been found" , but when i search it in application search i can find the object. Can we use this function for records? 2. When i am deploying  application to an higher environment, In inspect tab SOMETIMES similar thing  (Record object and it's related objects  were there  in the package , but still it's gonna ask  for missing object with uuid  which is record type). Can anybody please explain why it's happening   

I am looking to read a specific column of Excel in Appian. suppose I have 3 columns in Excel roll no. , name, and email. So, I want to read all the values in the column email as an array of Strings. 

We are using Write to Multiple Data Store Entity smart service to write multiple Process variables at once ( In that couple of Process Variables are null. ). After writing to DB in output we are trying to get data written back to PV using ac!storedValues.   However even though PVs are null, after writing to DB it is returning empty CDT instead of null.

Currently I have a requirement to provide filters for all the columns present in the Read-only grid which is like 25+ columns. To provide filters individually for all the columns it won't be a good practice any is there any alternative way to display the filter in efficient way.

Hi Champs, we have a requirment in Appian RPA where we are clicking a button/image to download the data in PDF in a chrome browser. It's working fine till the pop-up comes for Save option. But we are not sure how to click the save button on that pop up as this is a different window than the primary browser screen.

Hi fitnesse working very slowly on window server. however, it is working smoothly on window 11. can you please help me? in case of anything is to be enabled on to server for running chrome  Thank you in advance!