Discussion Categories

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

I implemented the Google Maps Component Plugin in the Dev and Test environments, and everything worked as expected. However, after deploying to Production, Google Maps is not functioning. Upon inspecting the browser console, I see the following error: Failed to load resource: the server responded with a status of 404 (Not Found) - Googlemap.svg. I’ve checked the server configuration, and it appears to be identical to the other environments. Any idea what could be causing this issue?"

I am trying to extract values from response received by integration but,it is showing empty .local!applicationProgressDetails:index(rule!NW_Event(contractNumber: ri!contractNumber),"httpresponse",{}),But here applicatinProgressDetails is coming empty.Kindly help me regarding this Value: Result HttpResponse statusLine"HTTP/1.1 200 OK"(Text) statusCode200(Number (Integer)) headersDictionary Date"Mon, 21 Jul 2025 09:20:12 GMT"(Text) Content-Type"application/json"(Text) Content-Length"5906"(Text) Connection"keep-alive"(Text) x-amzn-RequestId"de4f04b3-d699-49bd-b52a-175fee2120be"(Text) Cache-Control"no-cache, no-store, max-age=0"(Text) X-Amz-Executed-Version"$LATEST"(Text) X-Amzn-Trace-Id"Root=1-687e064c-4d97a9623f7dd8c80713ea2c;Parent=238c206491f7f614;Sampled=0;Lineage=1:ea392a22:0"(Text) x-amzn-Remapped-Content-Length"0"(Text) contentType"application/json"(Text) bodyList of Dictionary - 1 itemHTTP/1.1 200 OK Date: Mon, 21 Jul 2025 09:20:12 GMT Content-Type: application/json Cont

Hi Team, I am trying to use XOR gate in the process model for diverting the flow based on the 2 conditions as shown below , here in XOR gate we are getting error because 2nd condition getting failed as per our analysis it should go end node because the first condition becomes true in that case why XOR gate checking 2nd condition? could you please suggest me! Thanks!

Hi Team, good afternoon! I'm facing an issue that I haven't been able to identify the root cause of, and I’d appreciate your help. Context:I created a subprocess node and configured it to call a specific process when reached. This subprocess expects two mandatory input parameters: A map array A record-type variable X (which should remain the same across all instances) The node is configured with MNI (Multi-Instance) to launch one instance per element in the map array, using Spawn All, running all instances simultaneously, and continuing only after all have completed. The subprocess node is also set to Synchronous. The issue:When the process runs, only the last instance launched by the MNI receives the record-type variable X correctly. All previous instances receive it as null. For example, if three instances are launched, only the third one gets the correct value for variable X; the first two receive null. The vari

O/P - 1 O/P - 2 O/P - 3 When I directly query the comments table with a filter to fetch comments where the audit is null, it returns the expected results(O/P - 1). However, when I apply the same filter in a related record query from the main test table, it does not return any comments(O/P - 2). Interestingly, if I remove the audit filter, the related record query returns the correct data(O/P - 3). Any idea what could be causing this issue?

Hi, I am getting above error while selecting user for task assignment on the interface. a!pickerFieldUsersAndGroups( value: rule!<rulename>( fv!item.Assignee ), Rule code if( rule!APN_isBlank( ri!userOrGroup ), null, if( charat( tostring( ri!userOrGroup ), 1 ) = "[", togroup( ri!userOrGroup ), touser( ri!userOrGroup ) ))

Hi Community, I am using a!recorddata for my readonly grid. record is API backed which has 3.5 million rows of meta data (just 4 columns). I am using pagesize as 50. I have provided filters in UI for users to narrow down their search. Since currently I am only using sample size data , Should I expect any performance issues once 3.5 million data is synced into records? I didn't find any recipes for a!recorddata with pagesize. So also would like to understand how readonly grid interprets and handles pagination just by using pagesize without any limitation on amount of records?

I have created a new robot in Operations Console and the robot is "Online". When I am trying to open this robot, it is throwing error as "ArrayIndexOutOfBoundException". And the Robotic task also cannot execute and says "Robot_Not_Allowed". Why this is happening?

Hi team We're trying to enter data when we are considering software to deploy. We've used the "Remove" function to avoid saving null values to our four filters table. It works just fine if we are looking at a single title, but for multiple titles we can't make it work PROBLEM: When we upload multiple values the pv correctly contains all data for each instance. The task generates the correct number of instances If the assessor chooses "not necessary" on any one task we get an error when trying to complete the subsequent tasks An Error Has Occurred Expression evaluation error [evaluation ID = 4fdbd:bd846] in rule 'sal_fourfilterdetails' (called by rule 'sal_uiaddfourfilters') : An error occurred while executing a save: Expression evaluation error: Cannot update List of Map; using a scalar value to update a list of length (3) The error does not appear when we choose "not necessary" Here's a pic of the interfac