Discussion Categories

HI Team, We are trying to connect SFTP to Appian Server using the SFTP Smart service, We are getting the error - "  Auth fail for methods 'publickey,password' " We are providing all the required configration mention below. 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "hostname", serverPort: 22, scsExternalSystemKey: "key", privateKeyFile: private key , usePerUserCredentials: false(),) Plugin Verions - 4.1.0 We have tried multiple times to connect using ppk , pem files , still we are getting the Auth fail issue. Help us with some guidance , if anyone gonne throught this.

I have a csv file with delimiter '|'. When I try to run the smart service by passing a csv file where few fields are null, it is returning the error message 'Error executing SQL'. But when I replace the null with random text values it is writing the data to DB. Is this an expected behavior of this smart service? Is there any way to import or read a csv file with null values?

How do i add a new manual action in the summary view with an auto generated interface. Is that possible ?

Join Appian experts for an in-depth livestream on maximizing value from Appian's Data Fabric and AI tools. We'll explore key strategies and best practices to implement during development, ensuring you leverage these powerful features to their fullest potential. Whether you're new to Appian or looking to refine your approach, learn how to optimize your projects for success. We'll dive into practical applications, share insider tips, and answer your questions live. Don't miss this opportunity to enhance your development skills and harness the full power of Appian's Data Fabric and AI capabilities! Turn on notifications to make sure you don't miss it!

HI All, I have a requirement, where we need to generate the Dynamic Word Template. we are using "DOCX from Dynamic Template." How to add signature & check boxes in the word template dynamically Signatures: Lets say I have an Employee editable grid, whenever we add an employee, signature will be provided by employee, how we can show those signatures in the Word Template.  In the Employee form we have a checkbox field how we can represent that in Word Template.  

Hi All, There is a requirement to have a RTE component where it is working properly in the interface, But when I open that from the site. RTE Component is refreshing with the key press with the below code. Can someone suggest a way why it is refreshing with key press in the RTE component? a!localVariables( local!data: a!refreshVariable( value: a!forEach( items: ri!Data, expression: if( search("<html>",fv!item,1)=0, null, fv!item) ), refreshOnReferencedVarChange: false() ), local!emailData: a!refreshVariable( value: reject(fn!isnull(_),index(ri!qmcData,wherecontains(null,local!data),{})), refreshOnReferencedVarChange: false() ), local!linksData: a!refreshVariable( value:tostring(reject(fn!isnull(_),local!data) ), refreshOnReferencedVarChange: false() ), { richTextEditorField( label: "Query Management Links", richTextValue:local!linksData, richTextSaveInto: { local!linksData, a!save(ri!Data,append(local!emailData,local!linksData)), a!save( ri!segment, a!for

Hi Appian Gurus, I recently came across a code like this :  I noticed that using the If() function with more than three parameters works like a nested If condition. However, I couldn’t find any documentation about this behavior in Appian’s official documentation. Is it acceptable to use the If function in this way?

I'm encountering an issue where I need my suggestion function to return both a dataSubset and an output value (like a flag). The goal is to allow users to enter a new project code if it doesn't exist and make dependent fields editable. I need a way to pass that output from the rule back to the interface Trying with a!update

Hi, We have provided a read-only grid for users. The users are applying some random filters and viewing summary view of one request. When they come back the filters which they have applied are gone and they have to apply filters again.  I know you guys will suggest that we can save filters and access them. But it doesn't work because they have lot of combinations and saving those many combinations is not a good idea. To avoid losing of applied filters, we opened the summary view in new tab. But some users are getting confused to go back to grid. Is there a way in Appian to provide a link/button in the summary page to close the tab? or Is there a way to keep the filters applied when user going back to the grid from summary view?

Hi All, I found placeholder in picker component defined as "Text to display in the field when it is empty. Does not show if the field is read only."  Ref: https://docs.appian.com/suite/help/25.2/Custom_Picker_Component.html However dropdown component it is "Text to display when nothing is selected and the value is null." Ref: https://docs.appian.com/suite/help/25.2/Dropdown_Component.html So when the picker field been disabled or in readonly, it will show blank, how ever in the same page, disabled dropdown field can show the placeholder words.  Is there a way we can show the placeholder in disabled placeholder words in picker field or anyone knows why dropdown allows to show placeholder when its readonly.

Hi Everyone,I'm working with two lists in Appian and need to find the exact indices of elements from one list (local!checkList2) in another list (local!sourceList2) without sorting the data. For example, if local!sourceList2 is {1, 2, 3, 4, 5, 1, 2, 6, 3, 2, 7, 2} and local!checkList2 is {1, 2}, I want to get the indices where these values appear in local!sourceList2 in the original order. I've tried using wherecontains, but it sorts the data, which I don't want.  a!localVariables( local!sourceList: {3, 4, 5, 3, 7, 4, 7, 6, 5, 4, 3, 9, 2, 2, 3, 2, 2, 3, 3, 2, 4, 2, 2, 2, 2, 3, 2, 2, 3, 2, 4, 2, 3, 2, 2, 2, 4, 3, 2, 2, 2, 2, 2, 3, 2, 4, 5, 4, 2, 5, 6, 3, 4, 4, 7, 3, 4, 6, 4, 4, 2, 3, 2, 2, 2, 4, 2, 2, 4, 3, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 5, 6, 2, 2, 2, 2, 2, 2, 3, 4, 5, 3, 7, 4, 7, 6, 5, 4, 3, 9, 2, 2, 3, 2, 2, 3, 3, 2, 4, 2, 2, 2, 2, 3, 2, 2, 3, 2, 4, 2, 3, 2, 2, 2, 4, 3, 2, 2, 2, 2, 2, 3, 2, 4, 5, 4, 2, 5, 6, 3, 4, 4,

Hello, We have a requirement of capturing the bounced emails which are sent from appian cloud. Can anyone suggest if there is a way of capturing those bounced emails in Appian? 

Appian UX Design Lab is back! This YouTube livestream series is designed for low-code developers looking to sharpen their UX design skills with hands-on feedback from Appian UX experts. Our next session will focus on grids—key components for presenting data clearly and enabling seamless user interactions. Join us for a live review where we’ll explore best practices for designing intuitive, user-friendly interfaces containing grids. Livestream Date: May 8, 2025 | 11:00 AM ESTTopic: Designing with Grids What's in it for you? Get Expert Feedback: Selected submissions will receive a live UX review from Appian’s design experts, with opportunities for real-time Q&A. Earn a Badge: All participants will be recognized with the UX Design Lab Participant badge on their Appian Community profile. How to participate:  Develop your UI in Appian Community Edition Submit your UI link using this form by 4/30: https://ap.pn/4iNKWlh Join the livestream on May 8th for expe

Hi everyone, I'm running into an issue with the "Import Excel to Database" smart service plugin in Appian. When I upload a .xlsx file that has been marked as "Confidential - Internal" in Excel (using sensitivity labels or classification settings), the plugin fails with the following error: "The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (e.g. HSSF instead of XSSF)" However, when I upload the same file marked as “General”, it processes successfully. Both files are .xlsx format. The only difference is the sensitivity label (General vs. Confidential - Internal). The error suggests the file is being interpreted as .xls (OLE2 format), even though it has an .xlsx extension. It appears that applying a "Confidential" label might be modifying the file in a way that makes it unreadable to the

Hi, After migrating to 25.1 version, we are unable to download excel from any of the records. The file will be attempting to be downloaded and fails after timeout. Below is the log we found in tomcat file, Caused by java.lang.reflect.InvocationTargetException Caused by java.lang.RuntimeException: Fontconfig head is null, check your fonts or fonts configuration

Hello, I am currently taking the appian developer course and it wnats me to access the operations console from the build view waffle menu on appian designer, but as soon as I select this I am greeted with the following message:Error Evaluating UI Expression Expression evaluation error [evaluation ID = UIYZI] : java.lang.RuntimeException: Retrieving resource failed, status code: 500Any fixes to this? Thanks for any help!

I want to design the application for Employee onboarding which consisted of HR, Admin, IT and EMployee So I need to make links from one interface to another, please guide me on this

Hi Champ, I want to call an related action from an image component using the link parameter. Is there a way to do that? Regards, Ghanashyam

Hi, KIndly help me how to get keys from dynamically listed dictionary, this could be of any type means list of variant, list dictionary, list map, map, dictionary, when getting result, it is type of dictionary, when checking its type it is showing of any type.  Below is the code which is not working. a!localVariables( local!data: { id: 1, name: { firstname: "shree", lastname: "tiwari" } }, local!name: property(local!data, "name", null()), local!keys: a!keys(local!name), local!keys /*{*/ /*typename(*/ /*typeof(property(local!data, "id", null()))*/ /*),*/ /*typename(*/ /*typeof(property(local!data, "name", null()))*/ /*),*/ /*property(local!data, "id", null()),*/ /*property(local!data, "name", null()),*/ /*local!keys*/ /*}*/ ) Commented code to check type of above local!name variable. added screenshot of response for reference.  Kindly suggest how to do this in appian. Thanks in advance, Shree Krish

I'm working on a use case for comment functionality, and I'm considering whether to use Appian’s built-in Event History List or to build a custom record type to store and manage comments. The Event History List is convenient, especially with @mention support and auto-timestamps, but I'm curious if there are any reasons to prefer a self-made comment record type. Are there any performance, scalability, or user experience considerations you’ve encountered in either direction? Would love to hear best practices or examples from others who’ve navigated this tradeoff!

I have a read only grid with a record type as source, I have three columns that has dynamic values. Meaning, I am using 4 or 5 record fields and get average these are custom fields. value: recordType!field1+recordType!field3+recordType!field3 / 3          --Its a numeric field lets say field name is "Avg value" then I have one drop down that suppose to filter the values in readonly grid based on slection. If I select the value ">1" from drop down readonly grid should filtered and show only records have "Avg value" column >=1 I am not able to use queryFilter as I don't have appropriate value for "Field"

Dear anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. If someone else has sent about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated.   [Error details]　*This is written in the body of the HTTP response. "{"error":"invalid_grant","error_description":"Please check the 'box_sub_type' claim. The value for 'box_sub_type' is invalid"}"   [Procedure] 1.Obtain a JWT using the createtoken() function of the “Box” Plug-ins. 2.Execute the Box API to obtain Box's Access Token.   *An error occurs here.   [Already Confirmed] 1.Applications created in Box have been approved by the Box administrator. 2.'box_sub_type' and 'sub' classifications must match.   Thank you very much in advance for your assistance. Best reg

Hello All ,  we have a database view , using that we created a record ( disable data sync) as Appian record is not allowing view with enable sync option.  facing performance issues with this Appian record picker, please can someone help with the following questions :  Question 1 : how can we implement a minimum character requirement for the search input in the record picker (pickerFieldRecords) to reduce the number of database queries ? Question 2 : how can we limit the initial load to a smaller subset (i.e. only load 20 result based on user filter) of records to prevent performance bottlenecks ? Question 3 : is there a way to implement Appian caches record data in memory with disabled data sync record  type ? Thanks!

Difference in Write to Multiple Data Store entity and Write to Data Store entity?  When we need to use the multiple data store entity?

Dear Anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. I get an error stating that the JWT is an invalid value, but when I check with jwt.io I can see that it is a valid value. If someone else has sent a support request asking about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated. [Error details]　*This is written in the body of the HTTP response. body: "{"error":"invalid_grant","error_description":"Signature verification failed"}" ・Confirmed JWT in jwt.io Thank you very much in advance for your assistance.