Discussion Categories

Note: Using actions under Excel: Licensed Required I am having an issue where I could not get the visible rows of the Excel file after filtering it.  Steps I am currently doing in my robotic task:  1. Open Workbook, 2. Get the last range of the current worksheet.  2. Filter the first column by the variable: dateFilter (only filtered rows are now visible on the file). 3. Get the range, (I am getting ALL of the rows, even the invisible ones) 4. Close Workbook. Thank you!

For subprocess and start process smart service if we change assignment to :-  This node will be assigned as a task to a person or a group of people We are able to add interface on Forms tab. What is the use of it ? And if we change values in PV, changed values are not getting passed to child process.  Parent process variables have updates values.  But child process has old values. (Not updated in this start process smart service Form ) Find document for reference. [View:/cfs-file/__key/communityserver-discussions-components-files/65/Defect-in-Process-Model.docx:320:240]

hola que tal? por favor alguien podría ayudarme, estoy teniendo un problema desde hace una semana y no encuentro solución, intento colocar una imagen en una interfaz pero no se como hacerlo, busqué en chatgpt pero nada, youtube lo mismo, estoy perdidisimo por favor si alguien es tan amable de decirme como debo hacerlo ;(

I am getting an error like "ERROR: Work item cancelled (Data Outputs)" in script task in the process. How can I resolve this problem? Any idea?

I am trying to create a user filter with the results from an expression rule which displays distinct options from my table. I have researched the documentation, and was unable to find any answers with an example.  How do I call the expression rule to populate the options for this user filter based on the results from the expression rule I have created? Many thanks in advance for your assistance.

I would like to ask a question . How to work oauth 2.0 client credentials grant for web api authentication.As may understand external system  need to request access token and access token response.How to implement it on appian?

Trying to implement Auto Sign In functionality for windows server so that bot establishes session on it own and make robot agent running. Getting below error while Testing connection. (Note, I have installed all the installable as advised) Refer below screenshot for the error message.

Hi Champ, I have a use case where I am getting the constnat name (in text) and I have to pass that in Update constant service. But here the issue here is I am unable to pass the constnat name dynamically there. As the name is text type and it's expecting something of constant type. I don't see any option to cast it too. Only way possible here is selecting consttant from the menu ; but I can't do that as it's dynamic in my case.

Using v21.3. I'm fairly new to Appian. While tailing the tomcat log, I see when the ObjectSynchronizer runs, I get the following: ... WARN com.appiancorp.common.ObjectSynchronizer - 1 services were missing users.... ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint ([constraint name]) violated I am attempting to see the actual sql causing the issue. I modified appian_log4j.properties as follows:from "log4j.logger.com.appiancorp.common.ObjectSynchronizer=INFO"to "log4j.logger.com.appiancorp.common.ObjectSynchronizer=DEBUG" However, the tomcat log file does not produce any additional entries. Is a restart required? Would the debug entries be written to a different file? Is there another logger that needs to be modified? Any help would be appreciated.

Hi Team, We are facing issue to select value in drop downs - Drop down 1 and Drop down 2. We are working on FitNesse /Appian 24.1 using Wiki Keywords as below: |populate field |Drop Down 1|with|Cover1| |populate field |Drop Down 2|with|Cover2| Error in Test - Timeout period reached: Wait for Field - Drop Down 1 Please suggest to resolve this issue and how to select respective values in both drop downs using Wiki Keywords. Thank you. Shivi Khan

Hi team, How can we get the list of system administrators on Appian. Is there a group to get this list. The users that are part of "Designer", is only admins?

I can upload the documents from external application to the Appian. When try to open the received documents with file extensions .docx,.pdf,.pptx, the files are throwing error and after I select "Repair" option, then the files are opened. But the files with extension .xlsx,.zip,.png,.bmp are not opening and its throwing "file format or file extension is not valid" error and unable to open the files. Step 1: By using, "Document Upload" Web API can receive document from external application to Appian.               a!startProcess( processModel: cons!DSC_UPLOAD_CWR_DOCS, processParameters: { transcript: http!request.body, cwrId: http!request.queryParameters.cwrId, documentType:http!request.queryParameters.documentType, }, onSuccess: a!httpResponse( statusCode: 200, headers: {}, body: concat( "Upload Successful: ", document(h

Join the Appian Community Hackathon! Work in teams of 1-3 developers to build a new, scalable AppMarket Utility that will help Appian developers create beautiful UIs efficiently. Submit your project by May 24, 2024, for a chance to win cash prizes and more.  All submissions must meet the following minimum requirements: Built on Appian 24.2 EA in the official Hackathon Appian cloud environment A reusable UI similar to the Inspiration examples found on design.appian.com Uses translation sets for easy i18n Easily replaceable sample data for general use At least one new Interface Component released with Appian 23.4+ Head over to Community Challenges to see all rules and details. 

What is the maximum value for a drop down list? And after how much data performance will impact ?

I am using a!startprocess function from an interface to save some data to db, now lets say the process model being called encounters a run time error in some node, i need to show the user some custom message like ' some error occured' in the interface , onError dosent work here , as there was no issue starting the process.

Unable to fetch the data from database through a!queryrecordtype in High Availablity environment set up and its always returning null value eventhough data is present in the table. Kindly revert to me if anyone aware of the fix. Thanks for your help in advance!!

When updating a record, using the update related action, the process gets stuck on the write records smart service. I've checked the permissions, and they should be fine. It's worked thus far, however now we can't update anything. The process is not throwing and errors, nor is it providing any useful information. Additionally, this is the error that the user gets:

Hi , As pe the  Function Plug-ins - Appian 22.2 , We can inject the service ( ContentService ) as a argument to the custom functions. When I try to inject as  below public String dowork(@Parameter String para, ContentService cs) { } I am getting below error. : Unable to find a required instance of ContentService. Is there any other annotation or setting ? Thanks & Regards, Chaminda

Hi Everyone,    Good day! The appian RPA agent goes offline frequently in my local machine. I have installed the latest rpa-installer only. How to fix this issue? PFA for your reference. Thanks in advance! 1) Initial Status 2) Went offline within 1 minute

Hi, We installed and configured the FitNesse for purpose of working with Appian sites to perform some AUT. Hence we configured with given Two Example by adding the appian url with version and username but getting following errors, cannot launch the appian site. 1. At first setup and launch of FitNesse worked but had issue in invoking the Appian site and throws following error 2. Unable run the Test itself also and throws following slim error message;  This was done after closing browser and than restarted the batch job of FitNesse & ran the test. Testing was interrupted and results are incomplete. Test Pages: 0 right, 0 wrong, 0 ignored, 0 exceptions     Assertions: 0 right, 0 wrong, 0 ignored, 0 exceptions (0.625 seconds) Could not complete testing: fitnesse.slim.SlimError: Error SLiM server died before Header Message could be read. Unable to start test system 'slim': fitnesse.slim.SlimError: Error SLiM server died before Header Messa

I have a relatively simple Excel document that I want to generate using the Export Data Store Entity to Excel process node. I want a Title cell at the top left, then column headers in the second row, and then the rows of data below. I have my custom cell positions set as: {"A1, A2", "B2", "C2", "D2", "E2", "F2", "G2"}, And my custom cell values set as: { concat("Person Information for Transfer #", pv!transferId), "First Name", "Middle Name", "Last Name", "ID Number", "Date of Birth", "# of High Value Bags", "# of Personal Bags"} Both arrays have a length of 8, but I'm receiving the error, "The custom cell positions and custom cell values arrays must have the same length." What's causing this error?

Hi, I'm generating a word docx using docx from dynamic template and converting the docx to pdf using PDF from DOCX smart service. I'm able to generate the docx properly but while converting to PDF the text is getting overlapped in single line.  can anyone help me on how to convert DOCX (generated using docx from dynamic template) into pdf with proper format. Thanks in Advance.

New to Appian, Hello, I'm doing step 10: Process Modeling 101, part 2. When creating a Related Action, step 7 of the exercise, when i click REQUEST MAINTENANCE to test the action, this error message appears (An error occurred while applying the context for the W0112AX Vehicle related action [identifier=41,530]. Details: No process parameter found corresponding to override [name=pv!vehicleId]. Non-parameter process variables cannot be overridden.)

Is ther any limit for number of columns/rows for using this smart service(Export Data Store Entity to Excel Smart Service). Nothing is mentioned in documntation regarding this limits

In the documentation for the Send E-mail smart service, it says to put a semicolon between email recipients. This is the expression I am using. = toemailaddress( pv!spkrRecord['recordType!PMSO Speaker.fields.speakerEmail'] ); toemailaddress( pv!parishProfileRecord['recordType!PMSO Parish Profile.fields.parishContactEmail'] )  However, the first recipient receives the email, but the second one does not.  What am I doing wrong here?