AI and Agentic Automation

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

Hi Appian Community, hope you are doing wellI have the following use case, The solution should be intelligent enough to capture the payslip documents from the end user and extract the data from the payslip document. As with Appian 23.4 release the AI skill has became much more smarter and works like a charm for documents that have similar structure. But, in this particular use case each user can have a different format of payslip that will be uploaded to the system, although all the payslips will be pdf and will be a structured document, but again can vary in terms of format. What is the best way to train the model so it can capture data from these payslips. Also, in case it is not possible can you please suggest a workaround as well.Regards

Hello, How would I go about Base64 encoding a string inside of an expression? In my use case, I have an input to a process model where parameters is a list of type map I would like to wrap local!JOB_ID in a function that converts it to Base64. processParameters: { parameters: { a!map("operationId": 210), a!map("jobId": local!JOB_ID), } } Thank you!

Hi, I have many users and I have custom field 3. I want to get the list of values in the custom field 3.  Is there any function to get the list of specific custom field values? Thanks in advance!

Hi, I have a question regarding exporting users of one project to another. We have one project in one of the environments and the other two in different environments. I want to bring all the two in the same environment, I can export the other two projects but how to export the users of those projects with specified groups they were in one go?

Hello all,We have a requirement to extract the data from the Driving License & Passport images. The catch here is that the user might have clicked it from his phone and sent it to us so We are converting them into PDF but we are not able to extract data from it as it is a semi or unstructured document. Please help if any kind of extraction is possible in such documents.Thanks in advance.

Hi, I have a expression rule which has the result : Name - Company - Phoneno.  I concatenated with "-" when I get the above 3 values. In some cases, the name can be blank / company / phone no. If the name is blank, my result is like  -company-phoneno. If the phoneno is blank, then it's name-company-How to remove the - if the value is not present ?

I have below expression to get the country groups without groups ids. It is working fine when I pass the country name without special characters.  if( rule!APN_isBlank(ri!countryName), {}, a!forEach( items: ri!countryName, expression: rule!APN_replaceNull( nullableValue: group( tointeger(getgroupbyname("RGRACSLBL_" & fv!item)), "groupName" ), replacementValue: group( tointeger( getgroupbyname( "RGRACSLBL_" & stripwith( fv!item, joinarray(cons!RGRACSLBL_SPECIAL_CHARACTERS, "") ) ) ), "groupName" ) ) ) ) But I'm getting below error when I pass a country with special character even though I have special character check in the code. Please help in resolving the error.  For example the country name with special characters : "Bolivia, Plurinational State of", I should get the group name as "RGRACSLBL

Hi, not a problem but following code should throw some error, but it is evaluating.Here a comma is missing, and we are using a local variable in its definition, which should throw an error. Also, we can try various P&C./*Code 1*/ a!localVariables(local!data: 2 * 5tointeger(2 * local!data)) /*Code 2*/ a!localVariables(local!data: 2 * 5tostring(2 * local!data)) /*Code 3*/ a!localVariables(local!data: 2 * 5toboolean(2 * local!data)) /*Code 4*/ a!localVariables(local!data: 2 * 5date(2 * local!data))