AI and Agentic Automation

Hello, I am opening an excel file in Notepad++ editor. In this file I see there is an end of line character added called CRLF. Please see attached for reference. Please try to open this file in Notepad++. You can see CRLF at the end of first line. I want to add the same in second line as well. Can anyone please suggest? Adding snapshot as well. Thanks[View:/cfs-file/__key/communityserver-discussions-components-files/15/sample.txt:320:240]

Hi, I have a below rule with pre-passed 3 parameters. Now, Is there any way that I can store these parameters (para1, para2, para3) and its values (val1, val2, val3) in variables and pass them to the rule dynamically? The no of parameter will be changed as they could come from rule input or local variable. Example: [Code] I have two variables local!para and local!val and end result is whats written in the expression is what I want. See, rule can accept 5 parameters but I have given only 2 in this case. a!localVariables( local!para: {"para1", "para2"}, local!val: {"val1", "val2"}, rule!JS_abcRule( para1: "val1", para2: "val2" ) )

Good day, I am trying to split a return from a query and display the first two items from the array,  Here is the query a!queryRecordType(   recordType: 'recordType!{e408fa22-7df7-4073-ac43-add3091357ab}AIM Asset',   fields: {   'recordType!{e408fa22-7df7-4073-ac43-add3091357ab}AIM Asset.fields.{af99cf34-7d26-4a14-b291-4cfff81e3500}name' },   pagingInfo: a!pagingInfo(   startIndex: ri!assetID,   batchSize: 1 )).data Which returns: List of AIM Asset - 1 item AIM Asset id4(Number (Integer)) name"ThinkPad P16s 16” Intel Mobile Workstation"(Text) I would like to return from the query: ThinkPad P16s I think I can use the split() function and concat() but I have never done this within a query before. The other option I have is to take the return and manipulate it in the display field of the summary interface richtext field. Can someone help me figure out the best way to do this p

Hi Community, I have a multiple question on the Document classification AI Skill. I have trained the AI Skill classification with 2 types of document. Both type does not have fixed structure (few text change based on the conditions).  When we upload the document of these 2 type the confident score is always fall between 55 to 60 .  Another behaviour i observed  when i upload different document type which is totally different , the confident score is 50 which i do not expect. Questions: Does anyone know how the confident score is determine?  The document structure is not same every time  is that because the confident score not going beyond 60? I expect to be more. Why confident score is still 50 when non trained document uploaded?

Hello, I´ve configurated the Azure service insede de Admin Console as it shows the image: This returns me a succes, and i see in the interface design mode the Copilot: But when I upload a fillable PDF to generate the form in appian, i keeps loading, but nothing generates Anyone knows what its happening and which could be the solution for this? Thx

Hi All, I have a process model which calls AI skill Document Extraction, I have trained the AI skills to extracts the fields and it extracting properly. The only thing is for 5 fields, its taking more than 4 min in the PM on extracting node alone. Is this is a common behavior or usual time, or is there any possible way to make it faster.

Hi, Is there an existing function on Appian to convert this value for example 100,000 to 100k? this goes on by million or billion. Thanks2

Hi All, When trying to filter using a dropdown, getting below error: Do not see any error in the backend, data store is published successfullyalso there are less than <10 records in the database so dont think of performance issue. please advise in which logs can I check this error to debug: Expression evaluation error [evaluation ID = abc7a:61357] in rule 'rmo_rule_getticketqueueview' (called by rule 'rmo_frm_ticketqueue') : An error occurred while retrieving the data. Details: Unexpected error executing query (type: [RMOVWticketQueueDT29056], query: [queryentity expression], order by: [[Sort[implementerStatusPriority asc], Sort[isSameDayImplReq desc], Sort[cutOffTime asc], Sort[urgency desc], Sort[ticketTypePriority asc], Sort[slaDateTime asc], Sort[ticketId asc]]], filters:[((status in TypedValue[it=103,v={RS20}]) AND (isWithdrawn is null) AND ((isGLConfirmed is null) OR (isGLConfirmed = TypedValue[it=1,v=1])) AND ((isConfidential = TypedValue[it=1,v=0]) OR ((isC

conventional method to find the gratest number using for loop 

Hi all, Hangman is a guessing game for two or more players. One player thinks of a word, phrase, or sentence and draws a dash for each letter. The other player then guesses letters once a time. If the guess is correct, the player who made the puzzle writes the letter over the corresponding dashes. if the guess is wrong, the player who made the puzzle draws a part of the hangman. The goal is to guess the word before the character is hung. So, Please suggest how to design that game I tried facing an issue a!localVariables( local!wordList: {"python", "hangman", "programming", "computer", "code"}, local!guessedLetters: {}, local!attemptsLeft: 6, local!currentDisplay: "", local!gameOver: false, local!winMessage: "Congratulations! You guessed the word: ", local!loseMessage: "Sorry, you ran out of attempts. The word was: ", local!wordToGuess: if(isnull(local!wordToGuess), rndindex(local!wordList), local

I need to check a specific field in an array of cdt or map for duplicates, and return an array of cdt or map without duplicates on that field. For example:CDT Array: {type!example( email: "hello@gmail.com", type: 1, date: 01/01/2022 ), type!example( email: "hello11@gmail.com", type: 1, date: 03/02/2023 ), type!example( email: "hello@gmail.com", type: 2, date: 01/02/2023 ) } In the above case, I want to return an array with unique email fields. Since the first and third item in the array have the same email address "hello@gmail.com", I only want to return the first one.

I am having an array like {22,10,12,11, 8, 17}. I need an expression which return the index where individual array value or sum of previous values is greater than or equal to 20. For example: The output should be {1, 3, 5, 6}. 22 (22-20) => 2 (index = 1) 2 (remainder from previous value) + 10 + 12 (24-20) => 4 (index = 3) 4 (remainder from previous value) + 11 + 8 (23-20) => 3 (index = 5) 3 (remainder from previous value) + 17(20-20) => 0 (index = 6)  As there is no while/do-while loops in Appian so it seems bit difficult to get the desired output with foreach loop.

Hi, Currently have a rule containing the following where the rule input is a list of documents and constant has text "DOCX" return true if all document extensions in a list have the extension "DOCX" otherwise return false. and( a!forEach( items: ri!receivedDocumentsList, expression: document( fv!item, "extension" ) = cons!DOCUMENT_EXTENSION_DOCX )) Which works fine but is there a more elegant way to do this? Regards

Does anyone know how to configure Delete Document to delete multiple documents/images given an array of document ids? 

Hi All, I have a query that returns documents with a specific name, sometimes by mistake we will have 2 or 3 files/documents with the same name, I want to make sure that my query selects the latest one added instead of the first one that it finds, how can I accomplish this? Right now if I have 3 files with the same name it picks the first one added since its the first one the query finds. thanks in advance

a!localVariables( local!data: {     a!map(id: 1, classid: 1702116260, value: - 115),     a!map(id: 2, classid: 1702116260, value: 190),     a!map(id: 3, classid: 1702116260, value: - 190),     a!map(id: 4, classid: 1702116260, value: 115),     a!map(id: 5, classid: 1702116260, value: 210),     a!map(id: 6, classid: 1702116260, value:104) }, local!choiceLabels: {          concat(1702116260, 104),           concat(1702116260, 210) }, local!choicevalues: { 5, 6 }, local!choiceLabels) I want to eliminate all the rows in local!data that has a corresponding negative value and add their classid + value in choice labels and ids in choicevalues e.g. value -115 with id 1 has value 115 with id 4... so both need excluded. whereas values 104 and 210 has no corresponding negative fields to include those in choiceLabels/ choiceValues

Hi, I need a validation that the user can enter only numbers from 01-99 . How can we do this?Is there any range function or limit function to check it?

Is there an way to list all expression rules in an application inside an expression rule itself. Or list all the Appian rules insider a rules folder. My purpose is to find expression rules in an application with and without test cases.

Hi All, We have a Postgre SQL DB connected to Appian system, and we are trying to fetching the data from respective table. i created CDT, entity mapping verified & Data store published successfully. In Rule Expression, when we tried the query entity for this DSE, we are getting below error.  Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [AAFAssetDT2555], query: [queryentity expression], order by: [[Sort[assetpreviousstatus asc]]], filters:[null]) could you please suggest me to resolve the issue.

Hi Team, I have designed an interface which has 1 Rule Input  Now on the UI I am calling an integration and getting data from the integration The requirement here is to save the data coming from the integration to rule input  but without clicking any buttons. i.e. there are no buttons in the interface (if there were buttons I could have used the saveInto parameter of it)  Is there any alternative way to save the data to my RI ?

Hi All I am working on version 23.3. My use case is to extract data from a PDF file; the data can be both hand written or system written. In case the content is system written; after few runs; the system is able to extract certain amount of data from the PDF (which is the expected behaviour from AI Document Extraction). However, if my input PDF document is hand written; no data gets extracted after multiple cycle runs as well. Can any one please guide as to how I can achieve data extraction from hand written document as well or what am I missing to achieve my goal. I am referring to the following link to achieve my goal (Note: Currently trying to capture PDF data in CDT; not in record for my POC): Create a Document Extraction AI Skill - Appian 23.3 Thanks in advance!!

Hi, I have a rule in which I call an SP.I made changes to a field so that it accepts an array and now my Rule is not working.  I'm not getting an error, just nulls. Any idea?with( local!result: a!executeStoredProcedureForQuery( dataSource: cons!SOP_ARC_CONS_ALMACEN_DATOS, procedureName:"SOP_ARC_GETTOTAL_INFORMESLAS", inputs:{ a!storedProcedureInput( name: "STARTINDEX", value: if( isnull( ri!startIndex ), 0, ri!startIndex - 1 ) ), a!storedProcedureInput( name: "BATCHSIZE", value: if( isnull( ri!batchSize ), 100, ri!batchSize ) ), a!storedProcedureInput( name: "SORTBY", value: if( isnull( ri!sortBy ), "idinstancia", lower(ri!sortBy.field) ) ), a!storedProcedureInput( name: "ASCENDING", value: if( isnull( ri!sortBy ), true, tointeger(ri!sortBy.ascending) ) ), a!storedProcedureInput( name: "RESULTADOSMAXIMOS", value: cons!SOP_ARC_INFORMES_MAX_RESULTADO_PANTALLA_ONLINE[ri!codigoInforme] ), a!storedProcedureInpu

Hi Community ,We have a requirement where we have to compare two lists of map , Both the Map have same values but these map are created from different query statement.I want those Keys where Values are different. For Eg : Map1 : [[id:230,no:0]; [id:223,no:1]; [id:232,no:1]; [id:264,no:1]]Map 2 :  [[id:230,no:1]; [id:223,no:2]; [id:232,no:1]; [id:264,no:1]] I need a expression rule which gives result as 230, 223 bcz Map 2 values are different in it. Many Thanks ! Regards,ASK

Hello, I am working on a team that would like to try out and potentially use the AI Skill "Email Classification" for our work, but the training of the AI skill states that it requires .eml files. Unfortunately, our company uses Outlook, which does not natively have a way to save .eml files - as far as I am aware. Is there a way for me to convert .msg into .eml, or has anyone else found a workaround? We are not allowed to use other email providers in any way, and all converters I found online would likely be blocked by my company.

I am facing a weird issue when comparing two arrays of dictionary type. As in the code attached, I have two arrays of dictionary from which I am converting one of them to be similar to other one using foreach loop. I am pretty much sure that output after conversion is same as "array1" in code snippet. But, still their comparison returns {false, false, false} as output of it. And, when I run the commented comparison below, it returns {true, true, true}. Why direct comparison is returning correct output but not the output from foreach besides the fact that formats and outputs are exactly same. a!localVariables( local!array1: { { value1: "abc", value2: "cde" }, { value1: "fty", value2: "yui" }, { value1: "uiu", value2: "dft" } }, local!array2: { { value1: "abc", value2: "cde", value3: "gdh" }, { value1: "fty", value2: "yui", value3: "hyu" }, { value1: "uiu", value2: "dft", value3: "kol" } }, local!convertedArray2: a!forEach( items: local!ar