Foundation

local!data: { a!map(SAPNumber: "1111111", Qty: "1", Spare: "0"),  a!map(SAPNumber: "1111111", Qty: "2", Spare: "1"), a!map(SAPNumber: "1111111", Qty: "3", Spare: "0"), a!map(SAPNumber: "2222222", Qty: "1", Spare: "0") }, In the above list, If a duplicate combination of 'SAPNumber' and 'Spare' exists in the list, display a message indicating that duplicate data is present. Example :  a!map(SAPNumber: "1111111", Qty: "1", Spare: "0"),  a!map(SAPNumber: "1111111", Qty: "3", Spare: "0"), here, 'SAPNumber' and 'Spare' are same so it must shows a message.

Hello, I have a Web API configured to trigger when a process model encounters a failure. The logic to detect the failure in the API's body section is as follows: error_code: if(fv!processInfo.pv.success, fv!processInfo.pv.errorCode), error_description: if(fv!processInfo.pv.success, fv!processInfo.pv.errorMessage, "Failure in process model") The issue I'm facing is that the process model executes successfully — no errors occur, and I receive the expected data in the response. However, the API still returns the error message: "Failure in process model". Also, the errorCode and errorMessage passed from the process model are empty. Could anyone help me understand why this is happening? Is there something wrong with how the condition is structured? Keep in mind it used to work prev and is working perfectly in other processes/web APIs?

I am trying to use the DOCX from dynamix template smart service "<dynamic><caseNumber>U-123</caseNumber><caseOpenDate>9/23/2024</caseOpenDate><fbiLocation>Texas</fbiLocation> <Today>May 30, 2025</Today><fbiPhone>(123) 456-7895</fbiPhone><fbiEmail>test@gmail.com</fbiEmail><fbiRole>Chris Hustle</fbiRole><SItable Subject='Jeff Gates' DOB='2/11/1982' SSN='' /><SItable Subject='Aron Jones' DOB='6/22/2005' SSN='' /><SItable Subject='Chris H'stle' DOB='' SSN='' /><allegations></allegations></dynamic>" However, I'm encountering the following error due to the apostrophe in the Subject attribute: Element type "SItable" must be followed by either attribute specifications, ">" or "/>". The issue is caused by the unescaped apostrophe (') in the Su

Hi, I wanted to know if there's a way to get deployment logs from an Oracle database using Appian's OOTB compare and deploy feature without going to the database. For example, I deploy a script that returns a log file to verify that it ran correctly. If this is not possible then I would like to hear some other suggestions. Thanks.

I wanted to update record field with fv!index. I have Recrod type filed1, field2, field3 field3 should update with foreach index

Hi All, I'm experiencing a quirky behavior. I am a system administrator and have designer group access but unable to edit process model expression editors of script task, email nodes etc. I have also tried in Designer view and made sure it is not analyst view. Please advise. 

a!isNullOrEmpty(a!fromJson("{}")) gives me result as false but my requirement is to check if a!fromJson is empty then it should return true. How can we acheive this?

Hi Team, I want to display an external PDF URL into a!documentViewerField, i tried using a!webContentField for the same, however the URL is not supported in it. I am open to first save the document to Appian and then display it. Please help me with the possible solution to this use case . Thanks in Advance.

Hi all, we're looking for the best way to maintain a large deployment between environments.  We have the package created in our DEV environment but we don't want to keep deploying this into SIT every time we fix an issue, as it's a large package and some issues may be in progress and not ready for deployment. I think ideally we want to create a package we can maintain in SIT as we deploy fixes to keep all the objects we've changed consolidated for when we deploy to UAT. Is there any way to create a package from a direct deployment or do I just need to manually create a new package in SIT and manually add all of the objects? Thanks!

Getting error in the script task. I'm trying to pass the below jsonPV in PM.I want to store the id values in DB as separate row

implement an Appian Expression Rule that validates the sequence of header values, ensuring that: The first value is "SAP Number", The second value is "Qty", The third to sixth values, if present, are "Spare", "Price", "Delivery Date", and "Remarks" , The third to sixth values are optional and may be missing,

Hello we have a document editing software that we wanted to embed into Appian, however at the time we could not because it only allowed links of the form https://blah We need to put in a link of the form ms-word://blah or ms-excel://blah etc etc Is that still not possible?

Hi Everyone, Since the 24.3 upgrade, we have been having trouble accessing Appian on safari browser after logging in, the screen stays blank. We have reported this issue to the Appian support team. Has anyone else experienced this problem and if so has it been resolved for you? Is there any workaround? Thanks and Regards, Anju

Hi All, I'm using for the first time the Export Data Store Entity to Excel Smart Service to add data to an existing excel template (saved as a doc in appian) (Exporting data to a formatted Excel sheet). Once I add the data to the excel it seems it adds it in the same row and erases anything on the same row that was there before, I'm trying to add the new data only in one column, different rows instead in one whole row. Does someone know if this is possible or how I should be configuring the parameters. customCellPositions List of Text String (Optional) Array of cell positions where custom cell values should be added. customCellValues List of Text String (Optional) Array of values to be added on the specified custom cell position. Or if you could recommend a different smart service to achieve this? Thanks in advance

Hello Appian community, I have a question regarding the implementation of a translation framework on record values in Appian. Currently, we are using database-backed records to store and display various referential data (such as status or list of values). I would like to apply a translation framework to dynamically translate these values into different languages when displaying a grid of record values. I am concerned about having to create a complex a!match statement to connect these values with Translation Set entries. Has anyone had experience with this or can provide guidance on the best practices for implementing such a solution using Translation Sets? Any advice or resources would be greatly appreciated. Thank you in advance!

Hi Appian Gurus, When I try to upload a file with more than 30 MB, I am getting this Appian inbuilt validation message which is totally misleading is it possbile to customize or edit this validation message in Appian On Prem environment.

Hi everyone, I have a use case where I need to send files to external system for validation. I'm submitting the form which is chained to itself, so that files are persisted in the Appian file system and then I'm sending this to an external system. User gets to see the progress percentage.So the problem is when Appian is very very slow ( due to other colleagues playing around, Appian internal apis are taking some time to write it  down. Any way I can check file exist in actual so that I can have some sort of delay retries?

Hi, I am getting this issue when selecting value from dropdown for one particular user at function a!gridField_19r1 [line 71]: A grid component [label=""] has an invalid value for "columns" and "value". All "data" arrays must not contain more items than the specified "batchSize", but "batchSize" was 10 and the largest column data array had 17 items.

I have four tables; Event, Parish, Parish Profile and Parish Event. Event holds all possible events a parish can sign up for.  It has a unique key of Evemt_ID and fields Event (name of the event) and Start_Date Parish holds Parish data and has a unique key of Parish_ID. Parish Profile holds some additional information about what type of speaker they would like at their event.  Not every Parish has a Parish Profile. Parish Event hold the history of all the events a Parish has signed up for.  Not all Parishes with a profile sign up for all events.  Some chose to participate last year, but not this year. It has a unique key of Paris_Event_ID and foreign keys, Event_ID and Parish_ID. I want to display in the Parish Profile Record List the latest Event the Parish signed up for. I currently use an expression rule to display this value in the column. However, i can't sort and the filter i wrote pulls all Parish Profiles with that has the event in its relationship.

Hello, We need to download the data from the read-only grid to Excel. We used the record type as a source for the grid and used the OOB export grid feature. The file name downloaded with this is "Record Name" - YYYY-MM-DD_HHMM.xls Is it possible to customize the file name generated with this? please let us know. Thank You, Sneha

I want to invite my friend to join my shared workspace, but I failed. I got a message. "You seem to already be in a shared workspace. If you wish to join this cohort, you must leave your current workspace before accepting this invite." But my friend is not in any workspace. He is new  member.  Please tell me how to deal with it?

Basically im developing a start form where i get a list of records that contain a a docID and a dropdown.  The interface has a editable grid where the user can add rows and per row the user can add a document (file uploadField) and a dropdown.  My issue is that on both fields i selected the value and the save with ri!VALUE and when i add a document it makes it so that in all the rows that document is selected and the same for the dropdowns. How can i make that per row created the save and the value creates a new array? In the interface i have already selected the ri! as multiple.   ill leave the code here , and thanks in advance to all,  a!localVariables(   local!rowsTemp: a!gridRowLayout(     contents: {       a!fileUploadField(         label: "Input File",         labelPosition: "ABOVE",      &n

Hello, I'm currently learning about the various functions of Appian to understand how powerful it can be. At the moment, I'm facing an issue with creating an approval process that has a condition where at least 2 out of 3 approvers must approve in order for the flow to continue. This is what I have configured in the user input task node so far.The problem I'm facing right now is that I don't know how to update the value of pv!approvalResults (which is a list of text) when each approver takes an action. Could you please give me some advice?

Hi Team, I'm currently stuck at a point and would appreciate your input. I need to display different colors for different countries in a column chart. Below is the database structure I'm working with country ListId(pK), .countryId(int), isAllowed(boolean) Note: I want to show only allowed countries data in column chart. I grouped the data by countryId, and I want to display different colors for different ranges of country IDs in a column chart. For example: Country IDs 1, 2, 3, and 4 should be shown in blue Country IDs 5, 6, 7, and 8 in yellow Country IDs 9 and 10 in another color These colors are just examples. If this approach is feasible, I will apply it to the actual requirement.

I have question like can we make editable grid to have a scroll after 4 rows.