Discussion Categories

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.

I have update and delete options in my related actions tab , but i want to remove the related actions tab and add the update and delete options in the summary view (Job Details) tab itself. Can anyone guide me how its done.

Dear anyone, I am currently trying to execute Box API that uses JWT, I saw an article that said that you need to set "Third-Party Credentials" when executing the Box API. However, the connection is not working properly, so if you know which field to set in the Credentials, please let me know.   Thank you very much in advance for your assistance. Best regards,

How to click on the above Menu Layout Button? using the Appian Selenium 

Is it possible to generate a unique URL to open a process in Appian? I would like to be able to start an Appian process instance using an API from another system, and open that process from a screen like "Appian process list" on the other system.A process has multiple User Input Tasks and also enters sub-processes, but I would like to be able to open the process from the "Appian Process List" no matter what state it is in.Is it possible to generate and return a unique URL for opening a process, regardless of the task, when a process instance is launched? How should I implement this?I've recently started learning Appian.Please forgive me for asking a beginner's question. Thanks in Advance.

Hi all... i have a database-table (postgresql) with 3 columns: id (integer), year (integer) and cost_pre_hour (numeric(10,2)). I would like to use this table as a source for a dropdown.As choicelabels I want a contaminated string in the format: ‘Price for year ’ + [year] + ‘ (’ + [cost_per_hour] + ‘)’[cost_per_hour] preferably formatted with 2 decimal places. I just can't get it to work. what i tried:in the record-type another calculated field:a!customFieldConcat( { "Price for  ",recordType!<recordType>.fields.year," (",?????????" euro/hour)"})for ????????? i set:text(recordType!<recordType>.fields.cost_per_hour,"#.##0,00")orcast(typeof(1.0),recordType!<recordType>.fields.cost_per_hour)or other internal-cast-functions or/and combinations.I got the error Could not cast from Record Field to .... CastInvalid or something like thatWhen i try:tostring(recordType!<recordType>.fie

Hi everyone, I'm trying to load json to db using this Appian smart serivces. My sample json data i have given below. It has multiple dynamics parameter for example user have multiple types of phone number. if it flattens json file then its working without any issue but sub paramters are not working as expected. Added more details below Main Issue while accessing the json sub parameters which is dynamic In smart service Load JSON to a database, "JSON key/Column Name mapping" Field for json fields key i have tried like this Phone.number as well as Phone[].number but while executing Process model considered as "FirstName", "Phone" as column instead of each table column fields like FirstName, PhoneType PhoneNumber. I cant able to navigate inside of sub paramters while mapping json key to table columns name Plugin name: JSON Tools Smart service name: Load JSON to a database my sample appian rule { "FirstName": "First_

I'm using a Google Sheets connected system in Appian with OAuth 2.0 authentication. The integration works initially, but I'm encountering an issue where the connection requires reauthorization almost every hour. Has anyone faced a similar problem with token expiration or session persistence? Is there a recommended way to maintain or refresh the token without requiring manual reauthorization so frequently? Appreciate any suggestions or best practices to resolve this.

I am getting this error on html to pdf converter node - java.lang.Exception: java.lang.IllegalArgumentException: null incompatible with Global antialiasing enable key Following is the html body retrieved from email Best regards,Isac Hi Eunice/Team, All set: Hi team Pls set up both tranches Thanks, Eunice Trader Additional Comments Term Sheet;<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="">schemas.microsoft.com/.../omml" xmlns="">www.w3.org/.../REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--/* Font Definitions */@font-face {font-family:"Cambria Math"; pa

Hi Appian Community, Iam new to appian and iam still struggling at a lot of things due to my limited approach. I have recently started working on a POC which is a little bit complicated due to which iam facing a lot of blockers. It would be great if anyone is willing to guide me a little bit on how to resolve my blockers and help me complete my POC. You can just help me in your free time or how little you can. Thankyou.

Hello everyone, I believe I created a real issue by deleting documents I should have left alone. My goal was to make environment B identical to environment A.  There were existing files in environment B so my approach was to delete everything I could and then import everything from environment A.  To clear away everything in environment B I hard deleted all application files by going into the application in designer, check the box next to the file name, delete, and confirm delete.  Once all files were deleted I would then delete the application itself.  Once all applications and their corresponding files were deleted I then went after files that lived outside of the applications.  I'm fairly certain this is where I created my problem.  I deleted documents that I now believe were being used for the appian user profile pictures.  The documents I deleted had the format of <username>_180, <username>_90, <usernam