Discussion Categories

I am using a read-only grid to show data for reports. I need to export the data to excel but the grid has more than 50 columns. I have already tried default export to excel feature and a!exportDataStoreEntityToExcel() function but none of these worked. FYI: Data is in SQL. Appian version is 23.2. Columns cannot be merged or it's count can't be reduced Is there any way I can export the data to excel?

Hi Appian Community! I have a requirement where in the column chart below, I need to show a breakdown of the data for each bar of all the series based on the date. I had to manipulate the dataset so using a record type was not possible. Now I have my data structured where  x-axis is dates, and y-axis is the percentage of each area of the office's seat booking. How do I show within each bar, a breakdown of say half is booking type A and the other half is booking type B?

Hi everyone, I am building a report that is accessed by a Super Admin (business user). The purpose of the report is to display which users belong to which groups. To retrieve the group information, I am using the a!groupsForUser() function. However, when the report runs under the business user context, I receive the following error: Expression evaluation error in rule at function a!groupsForUser [line 6]: The user does not have sufficient privileges to get groups for user. [User Context: ...] does not have sufficient privileges to perform the requested action. It appears that this happens because some users belong to restricted groups (for example Developer groups or Health Report groups) that the business user running the report does not have permission to view. Because of this, the entire report fails instead of simply ignoring those restricted groups. My question: Is there a way to: Retrieve only the groups that the logged-in user has permission to see, without the expression fa

Hi everyone, We’re working on enabling document preview functionality in our Appian application. We created a Web API that can successfully preview and download documents from the UI. However, we’re facing an issue specifically with Microsoft Office files (Word, Excel, PowerPoint). Instead of previewing in the browser, these files automatically download. Current behavior: PDF files preview correctly in the browser MS Office files (.docx, .xlsx, .pptx) always trigger a download, regardless of browser settings We are returning the document via a Web API using proper headers, but preview still doesn’t work What we need help with: Is it possible to preview MS Office documents directly in the browser using Appian? Does Appian support inline preview of these formats, or do we need an external viewer (Office Online Viewer, Google Docs Viewer, etc.)? Any recommended approach, best practices, or sample configurations to achieve inline preview?

My Appian Senior developer certification had an expiration date of March 18.I have completed the 25.4 Release showcase on the same day.Could you please confirm if my certification will be considered renewed based on the showcase completion.Regards,Priyadharshini.S

Hi all, I had just been researching on the different character limits for data types. So from my understanding of text data type, these are the following limits. Text - 255 characters Long Text - 4000 characters Extra Long Text - 64000 characters  To my knowledge these are the 3 available options for any VARCHAR in record types, I was just wondering if this information is correct, wanting clarification please.  Couldn't really find a clear answer on the limits. Note: I believe that for record types, there's a limitation for Extra Long Text, limited to only 3 fields within a record type that's allowed to have the Extra Long Text data type.

Hi everyone, I’m working on a large and complex process where we are not using User Input Tasks. Instead, we implemented a pool-based approach, where each group has its own pool of requests. All request data is stored in the database. We also have an Admin Configuration interface that allows the admin to enable or disable certain tasks for specific groups. For example, in the database we store a boolean flag: true → the request/task should appear in the pool false → the request/task should no longer appear On the interface side, we are using a grid that queries the database and filters the tasks based on this flag to display the pool for each group. The issue we are facing is the following: When the admin disables a task (changing the flag from true to false), the request still appears in the pool grid. It only disappears after performing a hard browser refresh. The standard refresh mechanisms in the interface do not update the grid immediately. My questions are:

Hi All, I'm trying to pass Json type data input (which is a rule from my interface sending it to process model via start process) to JsonToExcel Smart Service. I need the output format as below. Please advise. expected sample output format - = "[{ ""startPublicationDate"": ""2021-09-05"",""endPublicationDate"": ""2021-09-05""   }]" The challenge I see here is my rule has nested rules inside it and output is a list of dictionary. 

I have a question related to "Appian RPA - working with Excel": is the set of activities powerful enough?  I have a project that requires specific activities in a few Excel files: -renaming a sheet -adding/removing a sheet -applying sorting -transferring (copy and paste) data from one sheet to another one in the same Excel documents and between documents -searching in a column for the first file name (the column has files names in it) that has or not an extension (".txt" for example). etc etc etc Can the Appian "working with Excel" set of activities powerful enough? Did somebody have something that couldn't be implemented (lack of functionality maybe)? I have to choose between "Appian RPA" and "MS power automation", I don't want to start with "Appian RPA" and to realize afterwards that it cannot do this and that, etc. Thank you so much.

Hi, I'm following the exercise in the attached PDF, but I'm getting the following error: "Reply-To email did not resolve to a valid email address." I've repeated the steps several times but I can't figure out what might be causing it. Since I'm new to Appian, I'm also not very familiar yet with diagnosing or resolving these kinds of errors. Could someone please help me understand what might be wrong or what I should check? Thanks in advance! [View:/cfs-file/__key/communityserver-discussions-components-files/62/Exercise-2_5F00_-Examine-and-Configure-a-Process-Model.pdf:320:240]

Hi everyone, I am working with AI Document Center in Appian and I am trying to use a classification model with an .eml file. According to the documentation, .eml should be a supported file type, but when I run the model I get this error: Generative AI Classification: Unsupported file type. Try again using a supported type or contact your admin if the problem persists.The issue happens specifically when I upload an .eml fileHas anyone successfully used .eml files with AI Document Center classification?

We switch our primary timezone from GMT to GMT+1 in the Appian admin console during UK daylight saving time. In the application, we display all dates using a text() function, like this: if(   a!isNotNullOrEmpty(ri!dateTime),   text(ri!dateTime, "dd/MM/yyyy hh:mm AM/PM"),   "" ) However, as soon as the timezone is updated in the admin console, the displayed date values shift according to the new timezone. This causes the date and time shown in the UI to change even though the stored datetime has not changed. Is there any way to keep the displayed date consistent regardless of timezone changes?

Hi Appian Community, I'm working on a PickerField component that needs to display data from a large dataset (~15,000 rows). Here are my requirements: Requirements: Display a PickerField with approximately 15,000 rows of data Implement a search functionality that only triggers after the user enters 3 or more characters Load the data using a Record Type as the data source Optimize performance to handle the large dataset efficiently Current Challenge: I want to avoid loading all 15,000 rows upfront for performance reasons. Instead, I'd like the search to execute only when

org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session:

We have a requirement to delete data from multiple records ie., almost 30+ records. Seems like we can pass data of only one record type at a time while trying to delete using delete records smart service which increases the number of process variables. Is there any optimized way of deleting data from these many number of records ?? We are trying to query each record individually since the number of records to delete at a time can be high more than 100 which is more than the number of related records that can be queried.

Hi All, Please help on below -  I'm trying to pass my below rule to JsonToExcel Smart Service which needs a json data. How do I pass this rule so my output looks something like this: expected output sample - "[   {     ""Name"": ""Robert"",""age"": ""30""   }]" Rule I want to convert to json by passing from process parameters in start process- a!localVariables( local!data: a!refreshVariable( /*RMSP1-2105 - Added rule input - refresh to getlatest data*/ value: a!queryEntity( entity: cons!RMO_ENTITY_VW_EMPLOYEES, query: a!query( selection: if( rule!RMO_RULE_isNullorEmpty(ri!columns), rule!RMO_RULE_employeeSelection(), a!querySelection( columns: a!forEach( items: ri!columns, expression: a!queryColumn(field: fv!item) ) ) ), logicalExpression: a!queryLogicalExpression( operator: "AND",

Hello Folks,We are trying to deploy a Process HQ report to higher environments, but while doing it,  we are seeing protected as status for the Process HQ Report Object, did any one faced this or have idea?Please let me know as this is a high priority task. Appreciate your time & response![mention:9861aef97eb2483a8b76175d9eda1e37:e9ed411860ed4f2ba0265705b8793d05] 

There is an Interface C which has parent as B and B has parent as A. Now I am passing via rule input from C it is working in B but not in A. The value gets refreshed at A interface automatically. FYI the rule input data types are same for all 3 interfaces A, B and C.

Calling all developers! Earn the Appian AI Skill Badge to demonstrate your knowledge of Appian AI concepts and implementation. The exam is based on coursework from the Appian AI learning path, and tutorials and resources from Appian Documentation. This Skill Badge is aimed at developers who have already earned the Associate Developer certification and have 6+ months of hands-on experience with Appian projects. Skill Badges allow you to showcase your expertise to the Appian Community through short, topic-focused exams on Academy Online. These exams are free, non-proctored, and a great way to highlight your skills. More information about skill badges here. Enroll here! Questions? Please reach out to academyonline@appian.com.

Hi Everyone, I am working on an Editable Grid in Appian where the grid data comes from a Record Type (Employee Request). The record also has a relationship (requestDetails) which contains fields like categoryId, typeId, and referenceNumber. For normal fields (like department or location) I can update values using saveInto with the local variable and fv!index. However, when I try to update fields that belong to the relationship object, the values are not saved and I receive errors. Example dropdown: a!dropdownField( label: "Category", choiceLabels: local!categoryLabels, choiceValues: local!categoryValues, value: fv!item.requestDetails.categoryId, saveInto: { a!save( fv!item.requestDetails.categoryId, save!value ) } ) This results in the error: The save target must be a local variable that does not refresh on every evaluation, a process variable, or a node input... I understand that fv!item cannot be used as a save target, so I tried updating using loca

Hi Everyone,I want to add new value using custom picker field .Let's say , I have picker field name country and its having all country but not "XYZ".So how can we add it?

Hi Everyone, I am learning Appian and working on a simple interface form. While submitting the form, I am getting the following error: "A button component must not contain both a 'recaptchaSaveInto' and a 'saveInto' parameter." I tried removing some parameters but the error still appears. Can someone explain why we cannot use both saveInto and recaptchaSaveInto in the same button and what is the correct way to handle this? Any guidance would be helpful. Thank you.

My client is concerned about reducing token usage, and we are investigating how to prevent repeated tokenization and embedding. We understand that Document Management Record Types embed the document representations for use in the smart search.  Are these embeddings used system wide when document content is provided to an AI Agent or Skill? Are they only available if the document is referenced using the special system document type? Help us understand. Thanks!

I have been facing an issue since I started working with Appian related to the behavior of Process Model labels when using multiple languages. Currently, Appian requires me to manually replicate the same labels across different languages, which is not efficient nor logical in my development environment. Although I understand that a large portion of the community primarily uses one language (English), my team operates in a multilingual setting, where developers have different language preferences. Given this context, it becomes necessary for me to enter the same label in another language to maintain clarity and understanding among my team members. However, this redundancy could easily be avoided if Appian implemented a feature allowing us to persist labels across multiple languages. A simple checkbox option like "use same labels for multiple languages" when creating a process model would greatly enhance our workflow by ensuring consistency and saving time. Moreover, the curre

We are using Appian DocCenter for document extractions, mainly pdfs. Sometimes for few pdfs preview is not appearing. But data is getting extracted fine. Did anyone faced this issue.