Discussion Categories

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?

Are there any disadvantages of Recordtype over CDT

Hi All, I am connect sftp with the help of SFTP (https://community.appian.com/b/appmarket/posts/sftp-smart-services) , seems able to connect sftp server as getting success status but no files getting downloading into Appian from folder & specific file as well. No logs in log file as well. What can be issue here ? Thanks in advance. Abhay 

We have a dropdown value in the editable grid, and when we click on the add row button in the editable grid we have to get unique values for each row which means already selected value should be removed for next row in the grid dropdown. For your reference below is the first row I selected App Number and I clicked add row , now in the second row dropdown we should not get App number similarly for all rows. a!gridLayout( label: "DropDown", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell( label: rule!INZ_I18N_displayLabel( i18nData: local!i18nInterfaceData, bundleKey: cons!INZ_CONS_TXT_INTERFACE_COMPONENT_INTERNATIONALIZATION & ".fieldLabelEnglish" ) ), a!gridLayoutHeaderCell( label: rule!INZ_I18N_displayLabel(

Hi All, Hope everyone is doing good..!!!, we have a requirement to export the UI data into PDF document file along with text filelds and signature fields, Can anyone please let me know what would be the best approach to achieve this requirement. I have tried using PDF from DOCX smart service to export the data into word document template and then tried to convert the same into PDF. But unfortunately I am able to capture the signatures as document Ids, not as signature images. Can someone please help us how to get the signature properly in PDF file. Regards, Dheeraj G

Hi every one,  I'm raising a question similar to this post  [mention:a16c4c9385824e0a9ad9e1c5a4c7ea34:46448885d0e64133bbfbf0cd7b0fd6f7:label=How%20to%20make%20other%20users%26%2339%3B%20profile%20information%20%28e.g.%2C%20first%20name%20and%20last%20name%29%20visible%20to%20a%20basic%20user%20on%20a%20report] as it has not been updated since 6 years ago. The issue I'm having is for this below code,when opening the UI with a system admin account I can see full user name while with a basic user account I can only see user's first name.  forEach(local!userNames, user(fv!item, "firstName") & " " & user(fv!item, "lastName")) I tried the retrieveusersecurityrolemap() recommended in the old post but not sure what to do with the output of the function, because for both accounts I had the same output:   Can anyone suggest me how to use this function or any other solution to show the same name for both account types?  Thank you. 

I have read this document https://docs.appian.com/suite/help/25.2/Start_Rule_Tests_Applications_Smart_Service.html.  But I want to know is there any way to only test the unit test of a package? 

Hi every one,  I'm receiving above error when using fileUploadField() to upload around more than 150 documents. I checked and each document I uploaded has size around 322.74 KB only. Within my fileUploadField() below is the code:  a!fileUploadField( maxSelections: 250, label: "Upload Document", labelPosition: "COLLAPSED", value: ri!documents, saveInto: { ri!documents, /*Save document details */ a!submitUploadedFiles(documents: ri!documents), a!save( ri!uploadedDocuments, reject( fn!isnull(_), a!forEach( items: save!value, expression: if(

Can anyone please tell me how to implement microsoft teams plugin successfully. If there is any document please share the link

Could someone clarify how group syncing works between Active Directory/Entra ID groups and Appian? Specifically, I’m looking for examples of how this integration is structured and what needs to be included in the SAML Assertion/Claims to enable proper group mapping and access control within Appian.

I am extremely new to Appian and looking for some answers. I have searched the forums to no avail. I have created a Site with multiple pages in it, one of them being a Contact Us page. On the Contact Us page, I have been trying to apply the expression link: a!safelink in an attempt to generate emails using our default email server (Outlook) once a person clicks the "Company Team Email" verbiage. Is this something that Appian is capable of doing?  This is my entire expression code: a!headerContentLayout(   header: {     a!cardLayout(       contents: {         a!richTextDisplayField(           labelPosition: "COLLAPSED",           value: {             a!richTextIcon(             &n