Foundation

Hi All, Can you guys please help how do I get list of Ids containing duplicates values in list of objects containing duplicate values. The list always has duplicate values. This is the list locallist: {    { id:12, FacilityName:"New Test1", FacilityTypeId:8,},     { id:13, FacilityName:"New Test0", FacilityTypeId:9,},    { id:14, FacilityName:"New Test1", FacilityTypeId:8,},    { id:15, FacilityName:"New Test0", FacilityTypeId:9,},    } what I want to get list of ids containing duplicates. So in this case, id 12, 14 are duplicate having same FacilityName, FacilityTypeId. And id 13, 15 are duplicate having same FacilityName, FacilityTypeId local!ResultList: {   {  12, 14 }. {13,15}    } Any help would be appreciated

Hi all, We’re looking to integrate Appian with Epicor Prophet 21 (P21) and I’m hoping to learn from anyone who’s done this in the real world.  We currently host Prophet 21 on-prem and with their recent announcement of going strictly cloud hosted by Epicor I am trying to plan things correctly.   A few questions: Are you integrating via APIs, using the read-only database, or something else? What P21 interfaces have you used most (orders, inventory, customers, pricing, etc.)? Any gotchas around authentication, rate limits, data model quirks, or transaction handling? Did you build a reusable Appian integration layer (connected system + integration objects), or keep it in an external service? Any general lessons learned or recommended patterns? If you’ve implemented this, I’d love to hear what worked, what you’d avoid, and whether you have any high-level architecture suggestions.

Batch Size for a condition set is 1000  in a loop and we are passing it to subprocess MNI as "Run one instance for each item in the condition set" and spawn all and running all instances at the same timeEven though the size limit is 1000 which is default size limit getting this error.How to resolve this please help

Hi, As the title says, I'm trying to retrieve all fields of a record type and its related record types in a query using a!selectionFields. I have the following hierarchy Produktbeschreibung (Prroduct Description) Konzept (Concept) as (one-to-many) [several other types, such as related risks] My problem now is, that using the following expression: I get all fields that are directly related to Produktbeschreibung and Konzept, but not the data for the related record types under Konzept. I'm suspecting that selection fields cannot drill down more than one relationship at a time. If that is correct, is there any way, I could get the data for the nested ralationships in a way such that I can retrieve the full record?

I'm not sure what the purpose of a Quick Task is. Do you know any YouTube video to see an example of use? Thanks in advance.

We recently did a bit of an object purge on our DEV site to clean out some unused or obsolete objects. We checked for dependencies before deleting anything, but apparently we didn't check hard enough. I have a process model that contains 2 Start Process nodes, that is now displaying an error on the Setup tab (see image below). This happens even when adding a new Start Process node to the process model, but other process models work fine. The uuid listed in the error is one of the record types we deleted.   I have process variables that are type Record Type, so I started by checking the precedents of that record type. I found one that, when trying to expand its precedents tree gives me the error message: Going in to that record type directly and attempting to view it's precedents just gives me a "Record field's uuid must not be null" error, and no precedents are displayed. However the record behaves completely normally apart from this and other apps that

HI We are exploring a potential integration pattern and would appreciate guidance from the community on whether this is feasible within Appian’s integration capabilities—specifically around user-specific authorization with Box when a process is triggered via email. Use Case Overview A user sends an email containing a Box folder link to a designated mailbox. This email triggers an Appian process via Process Model Email Polling (this is currently working as expected). The process then attempts to download documents from the referenced Box folder. The key requirement is that Box access must respect the sending user’s specific Box permissions. Current Authorization Approach We plan to use OAuth 2.0 Authorization Code Grant for Box authorization from within Appian. We are intentionally not using the JWT approach, as it requires Box admin-level permissions and provides broader access than desired. This approach works well when initiated from the Appian UI, whe

I want to generate an excel sheet using JSON to Excel converter plug in. Even though I am passing the json correctly, I am getting an error message:

How do I get prime numbers 1-100 ?

Hello,  I am currently working with a record which is being used in 2 different websites on the same environment. These 2 websites have a different look and feel, and some record informations should only be displayed on one of the website, but not on the other one. Is there a way to keep using the same record on these 2 websites, but have the summary interface dynamically change depending on the website it is accessed from ? For instance, if we access the record from website A, some cards are hidden, whereas if we access the same record from website B, the same cards are showing. So far I haven't been able to find a way to "detect" the active website from my interface, and I am not sure this is possible. Thanks

When using a!startProcess within the interface button, the process instance is successfully created and completes as expected. However, despite the successful execution, the a!startProcess function moves to the onError block, resulting in unintended error.

We have a WebApi to approve requests (mostly in html/JavaScript/Appian)  This page contains a table which has a link to download documents from filenet. It works fine for Application level roles but redirects to Appian sign in page for non-Application roles. We were told to fetch documents from Appian instead. I created a post webapi(doc) which has start process(retrieve docs from filenet) and returns docId in json . This is working fine but when calling this webapi(doc) in Integration, it fails with 302. Provided basic auth, tried with serviceaccount as well. Idea: create another get webapi to invoke this integration and call in approval page. I'd appreciate if there are any other ways for non-Appian users to access documents can be given. Any guidance will be appreciated. TIA.

Here’s an overview of my process model: the “PDF Doc from Template” smart service generates the PDF file using an editable template. Below is the structure of the template: All fields in the template are configured as multiline and can hold up to 5,000 characters. Since each field has a fixed height, any content exceeding the visible area becomes scrollable within the field. After generating the PDF using the “PDF Doc from Template” smart service, I use the Fill PDF smart service to flatten the document and make it read-only. Everything works as expected up to the point where the PDF is created and stored in the designated folder. The issue arises when the Fill PDF smart service is executed. This functionality was working correctly before scrollable multiline fields were introduced into the template.

Hi Team, Is there any way or function to insert business holiday for particular company and retrieve same. Thanks,

Node Instance Error OccurredExport SQL Request To Excel Admin The following error was raised by the Export to Excel function: Specified named range 'Total' does not exist in the current workbook. Dec 22, 2025 9:41 AM Is anyone can assist, I changed the file name or excel file template and folder name change. after that getting the same issue with smart service Problem:  An error occurred in executing an Activity Class. Details:  The following error was raised by the Export to Excel function: Specified named range 'Total' does not exist in the current workbook. Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

I have deployed a new package which contains a expression rule doing some calculation, into Production Environment and its running Live ,Somehow its failing in production, and there are around 300 instances which got failed due to error of this Expression Rule which called in a Script task, May i know how to fix this Error,Can someone suggest us some possible and most efficient Ways to do this. Thanks in Advance.

I need to call a stored procedure that takes a lot to complete (around 6min) and it does not return anything. It could be called in a async way that it would not matter.  Having said that, can I just use the timeout field to give it a short value (one second) being sure that in the DB, the SP will complete even if my Process model completes?Cheers

I am loading data from an Excel sheet into an Editable Grid. I added Edit and Delete buttons for each row, but the actions are not functioning as expected. Could someone guide me on how to fix this or share the correct approach? Ia!localVariables( local!data: 309474, local!sheetCount: getnumberofsheets(document: local!data), local!sheetIndexes: enumerate(local!sheetCount), local!activeTab: 1, local!readOnly: tointeger({}), local!sheets: a!forEach( items: local!sheetIndexes, expression: a!localVariables( local!sheetNumber: fv!item, local!excelOutput: readexcelsheetpaging( excelDocument: local!data, sheetNumber: local!sheetNumber, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 1000) ), local!rows: index(local!excelOutput, "data", {}), local!totalRow: tointeger( index(local!excelOutput, "totalCount", 0) ), local!rowHeaderRaw: index(index(local!rows, 1, {}), "values", {}), local!headers:

Hi everyone, While following the Appian Developer course, I noticed that multiple PDFs for the Step-by-Step exercises (for example, Build an Application: Step 2) cannot be opened. They seem corrupted or possibly outdated for the current version. I’ve tried downloading them again and opening in different viewers, but the issue persists.Is there an updated version of these documents or an alternative resource for these exercises? Thanks in advance for any guidance!

Current Situation:We have two applications hosted on Appian and have configured session timeout settings. When there was only one application, after the session timeout, a popup appeared, and upon resuming, we were redirected back to that application’s page.Now that we have two applications with the same timeout configuration in the Admin Console, the behavior has changed. After the session timeout message appears and we resume the second application’s UI, the system redirects us to the first application’s interface instead. Question:Why is this happening, and what can we do to ensure that after refreshing post-timeout, the user is redirected back to the second application’s UI?

Hi , I am building a document upload form after uploading the document it should be populating in the gridfield with the link format where user can download the lfile. but that field is coming as empty.  This is my code. The documentId field is  text now, we don't have access to edit it now . can changing the datatype will fix the issue or is there anything  elseI have to look into?  a!localVariables( local!documentId: null, local!category: null, local!comment: null, local!showUploadSection: false(), local!npdoDocumentList: ri!npdoDocument, a!formLayout( contents: { a!sectionLayout( contents: { a!boxLayout( label: "Supporting Documents", contents: { a!gridField( data: local!npdoDocumentList, columns: { a!gridColumn( label: "Title", value: a!linkField(

Hi everyone, I’m trying to create a nested ordered list in the following format: However, I’m facing two issues. Issue 1: styledTextEditorField flattens the nested list formatting Instead of rendering a proper second-level indentation, the styledTextEditorField flattens it into something like: Here is the HTML I’m using: <ol start="2">    <li>        <ol type="a">            <li>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li>             <li>Praesent ac lorem non risus gravida accumsan.</li>         </ol>     </li></ol> It seems the component does not support nested <ol> indentation. Is there any workaround to make the nested list (“a.”, “b.”) render correctly inside styledTextEditorField? Issue 2: When generati

Can anyone tell why its showing only 101 item even though the ids passed are 1000 

Send Message Event: In the Setup tab, for 'Message Destination', select the Receive Message Event that is in the Process Model where you need to send the message. To do this, search for the process model and select your Receive Message Event. In Data tab, 'DestinationProcessID' is the ID of the process instance of the Process Model to which you need to send the message. Click on "New Mapping" and name it. Configure the 'type' based on your need. The 'value' should be your process variable which holds the message(data) to be sent. Receive Message Event: In the Setup tab, for 'Receive Message', select 'Process to Process'. In Data tab, click on 'Import Custom Properties', search for the Process Model where you have the Send Message Event, and select your Send Message Event. 'Value' will be automatically set. Then store it in the desired process variable. My Use Case: In Process Model A, I call an i

In the Test environment, suppose a constant named PV_TXT_TEST already exists. Now, if I create a new constant in the development environment with the same name (PV_TXT_TEST) and deploy it to the Test environment, what will actually happen during deployment? Will Appian throw an error saying that the constant already exists, or will it overwrite the existing one? This scenario came up in one of my interviews. In my current project, I don’t have permission to deploy to the Test environment, so I wanted to understand what the actual behavior would be.”