Discussion Categories

I have main data store entity that comes from CDT, in this CDT has 2 related CDT's. I am currently trying to delete from main data store entity to then have impacts on the related ones. When I made a process model that takes user input that then results in "delete from data store entities" node to delete, it was working for a few unique identifiers before not working anymore. It has ConstraintViolation as the error that it's giving. I am just trying to clear all of the data that are within my DSE's but keep the structure there.

I am sending an email attached with excel sheet to process model vai Receive Email at start node. I could able to extract the excel from email but the data is not written in the database.FYI: Using Plugin Import Excel to Database, Using CDT 

We have some Appian administrator users who, when they try to access process supervision, edit the process, and try to change a value in a node, do not see all the tabs and cannot change anything. For all other administrator users, it displays correctly. At first glance, it seems that both have the same groups, but we don't understand why the tabs don't appear. We are probably missing some groups, but we thought that an administrator could do everything.  Is that right? Thank you very much for your help.

"RUN EXTRACTION" button is not visible on AI Document Center, after creating an Extraction Model. Why?

"RUN EXTRACTION" button is not visible on AI Document Center, after creating an Extraction Model. Why?

Hi All, What would you all recommend for implementing a confirmation page after a form is submitted ? another user form ? The only concern I have is that once my user submits the form is a subprocess creating multiple instances (as we need). So basically for the confirmation page we need something along the lines this # of items were created in the system, even better if we can give the ids of the created items. Any suggestions for a good design implementation? Thanks in advance

Can someone please explain what are major pros and cons of process driven and  db driven task and in which use case we should consider db driven and process driven approach.

Hi, We have an excel file in shared network drive (x drive) which we need to update as per some business logic in Appian. We dont need the file to be stored in Appian. Is there any way (eg. plug-in function / smart service / connected system), through which we can update the remote excel file? Thanks, Sudip

a!localVariables( local!bookinfo: if( a!isNotNullOrEmpty( ri!Lms_issuebook['recordType!{01e3b0e9-0572-442f-afd0-5278d2e5255e}LMS_books_issue.fields.{550c5ea8-8a07-4a21-9693-209c159c6319}bookId'] ), a!queryRecordType( recordType: 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK', fields: { 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{92b7d831-6d1e-4319-941c-66d2c1b49a9f}author', 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{39d871be-ff6b-43bc-8200-4f5764212db4}availableCopies', 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.relationships.{23c62a5c-04db-4f30-89f0-4ccc4bb61a47}lmsGenre.fields.{d2da18ac-f795-482a-99d8-914552162ac1}value' }, filters: a!queryFilter( field: 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{8a72e153-4658-455c-a313-dc3d895c5ed3}bookId', operator: "=", value: ri!Lms_issuebook['recordType!{01e3b0e9-0572-442f-afd0-5278d2e5255e}LMS

We have some fields with extra long text type in our records. Seems only 3 fields are allowed with extra long text data type and we had 4 fields. We assume this warning is coming because of the recent upgrade. Its showing warning that only 3 fields can have extra long text and its not allowing us to add any column. And we are unable to change datatype from extra long to text from record side. I changed the column from text to varchar in db side but still getting this error. Please let us know how to resolve this issue.

We are trying to enter a decimal number into a!floatingPointField and storing it in Number(Decimal) field. Since it is a decimal we are trying to save it using rounddown(value, 2) so as to allow only 2 decimals according to our requirement. Note: This functionality is being used in editable grids. While doing so, for certain fields we are getting random numbers keep appearing after the decimal for the numbers. (47.3 shows as 47.3000000004, etc.). This is happening only for that particular row for only a specific value i.e in the example 47.30 only will show 47.3000000004, if we enter 47.322445 it will round down to 47.32. We tried using, round(), roundup(), rounddown() and floor(). SInce we have mutliple grids in the same fashion, this issue seems to appear in atleast 1 grid row.

I need to Show Error Message for the user in the User interface when process on create record action fails. Currently it just says 'Action completed' whether the process is success or failure. User is unable to know if the record is successfully created or not.

Hi Everyone, I 'm getting above error for the below code. a!dropdownField( label: "Is Under Header", placeholder: "Select", /*required: ri!questions[ri!index].questionType<>cons!RIDCO_QUESTION_TYPES[11],*/ disabled: index( ri!questions[ri!index], "questionType", {} ) = cons!RIDCO_QUESTION_TYPES[11], choiceLabels: touniformstring(local!headerQuestions), choiceValues: touniformstring(local!headerQuestions), value : touniformstring(index(index(ri!tempQuestions,ri!index,""),"parentQuestionText",{})), local!headerQuestions : returns list of text string

Hi everyone, good day. I’m working with an AI Skill for document extraction in Appian, specifically targeting a structured and standardized document used in Mexico: the Constancia de Situación Fiscal (a tax ID certificate). My goal is to extract the following fields: RFC (tax ID) Business or legal name (Razón Social) Start date of activities List of economic activities (shown as a table in the document) The issue I’m facing is that the AI Skill successfully extracts all the individual fields (RFC, name, start date), but it completely skips the table that contains the economic activities. I’ve already configured the document type, field mappings, and extraction zones where possible — I’ll share screenshots of my current setup below. Has anyone encountered a similar issue with table extraction in structured documents? Any suggestions would be greatly appreciated. Best regards, Víctor Valenzuela

Hi All, What is the difference between calling a synchrous process via Subprocess and Start Process smart service nodes? Is it just that the first runs in the same thread / Appian engine and the latter runs in a separate thread / process to balance the workload? I know that Subprocesses are traditionally used in synchronous settings and are especially helpful when the child process is activity chained, but would it ever make sense to use the Start Process node in a synchronous setting? I've only primarily used Start Process nodes for asynchronous processes. 

Hi All, Please help in understanding or explaining the working of the following code. displayvalue( 5, { 1, 2, 3, 4, 5 }, { "A", "B", "C", "D" }, "Z") In the above sample code, based on it's behavior, ideally, the result should be the default value ("Z" in this case as there is no item in 5th index of 2nd array). But the result I'm getting is "A", the 1st index from the array. Version I'm using is Appian 24.4 Please refer the screenshot attached.

Appian's a!isNotNullOrEmpty funciton does not work for values {null}, {null,null} please find below testcase. code given on community works as expected but not a!isNotNullOrEmpty https://docs.appian.com/suite/help/25.2/fnc_informational_isnotnullorempty.html#replace-if()-and-isnull()-expressions-with-a!isnotnullorempty

Hi Com, I have tried to install RPA Agent in my laptop. However it shows greyed out in the taskbar. I followed the steps mentioned in the documentation-Intalled java 17 Changed system environment variable.My doubt is, if i wish to not opt for enable automatic sign in, i will not select the checkbox. I have directly installed the agent and run on laptop. But it is greyed out.Any other prerequisite that i am missing? is there any other framework or software needed to start the agent?

Hi All,Currently we are having a workflow which consists of a task which will be worked by a user. When any updates to the workflow occur from external system, we cannot show the updates to the user in the UI when user has the UI already open since the data cannot be refreshed. We are thinking of either cancelling and creating a new workflow with the latest updates or completing the task using smart service and recreating the task within the same workflow. Any insights on which will be better approach will be useful. 

Im getting the error when writing to data store:  ... " with identifier value `1007` does not exist  " . This is the value of my primary key I'm trying to insert into the data store. I already have the primary key from user input and I'm trying to write all of the info into an empty data store. (I would share screenshot but it's work information). This is occurring within my process model when I am using the write to data store smart service.  Why is this happening?

When I am running RPA it is failing and saying it is failed to delete the file after copying it to the given location. Please help me with the possible cause and fix

Hi everyone! I need your help with an integration challenge I'm currently facing. Soon, in my project, we will gain access to a SQL Server table that contains a column with images or documents stored in BLOB (Binary Large Object) format. Our objective is to read these BLOBs from Appian and convert them into Appian documents that can be correctly viewed and managed within the platform. To test the feasibility, I tried creating an integration that calls a Web API. This Web API, in a simplified manner, receives a binary as a parameter and returns the same binary to me. When configuring the integration in Appian to interpret the response as an Appian document, the documents are generated correctly in the designated folder, and the file extension matches the original (e.g., .pdf, .jpg). However, the problem arises when trying to open these documents in Appian: the viewer indicates that "the format is incompatible". Furthermore, I've noticed that the size of the files gener

Hello, I'm facing a challenging issue when reading dates from Excel files using readexcelsheetpaging(). The problem occurs when Excel cells contain dates in custom format that appear as values like "2026-07-17". The Problem: When Appian reads these date values, it interprets 2026-07-17 as a mathematical expression (2026 - 07 - 17 = 2002) instead of treating it as a date string. This happens before I can apply todate() or text() functions. Context: Excel cells contain dates with custom formatting (cannot be changed on Excel side) Dates appear as format like "2026-07-17" when read by Appian Need to convert these to proper Appian date values Current Code: a!localVariables( local!document: ri!document, local!sheetNumber: ri!sheetNumber, local!startIndex: ri!startIndex, local!tempResult: readexcelsheetpaging( excelDocument: local!document, sheetNumber: local!sheetNumber, pagingInfo: a!pagingInfo( startIndex: local!startIndex,

Appian RPA agent not coming online in spite of the satisfying the conditions about Java environment jdk 17. It used to be up but suddenly stopped working triedreinstallation as well.

We have multiple applications within the Appian platform. Could someone provide guidance on how to implement auto-provisioning and group syncing in a way that maintains separation between these individual applications?