AI and Agentic Automation

We are trying to compare to one intake value with data that is coming from another system. Both these values are present in pv and we are using contains function inside a script task to check the same. But even though the value is present in array, its giving false.  Array value Single valueBoth are of same data types but still giving false. contains(arrayValue, singleValue) is the function being used inside a script task. Let us know if we are doing something wrong here.

We can write If/Else condition in expression rule then why do we need decisions objects in Appian

Can anyone please hep me in this? I want to sort below mentioned data. I was trying to sort data using queryentity and it worked. But I have to use rule input ri!employee(Type: Data Type). Please assist. Need to sort data by these fields: sort: { a!sortInfo(field: "empcode", ascending: true()), a!sortInfo(field: "type", ascending: true()), a!sortInfo(field: "amount", ascending: true()), } joinarray( a!forEach( items: ri!employee, expression: concat( "", "", union( { fv!item.empcode }, { fv!item.empcode } ), "", "", if( rule!GLB_isBlank(fv!item.barcode), {}, a!localVariables( local!code: union( { fv!item.barcode }, { fv!item.barcode } ), local!newcode: split(local!code, "_"), local!newcode[2] ) ), "", "",

Hi, I am trying to experiment with Appian Co-pilot and I have encountered few issues. 1. I have set up my chat completion model in admin console. https://azure-open-test777.openai.azure.com/openai/deployments/gpt35-model/completions?api-version=2023-09-15-preview   : this is Chat completion endpoint in Azure If i Paste it in the admin console under AI services it's giving error, but if I add chat/ in endpoint as suggested by Appian then it is successful, please refer attached SS. Even if I give different deployment model name the connection is successful HOW??? 2. I am trying to upload simple PDF after successful connection (refer SS highlighted in yellow color), i am unable to get the expected interface. PDF:   

I have defined a process calendar called "US calendar". I defined working hours for 14.2.2024 to be from 8am to 4pm. When calling calisworktime(datetime(2024,2,14,15), "US calendar") (checking if 4pm is working time) it returns true. Then i set working hours for 14.2.2024 to be from 8am to 5pm. Then i called calisworktime(datetime(2024,2,14,16), "US calendar") (checking if 5pm is working time) and it returned false. It appears that calisworktime() function does not behave consistently. I have tried searching for this problem but it appears nobody else has experienced it.

Hi, We have an expression rule (see below image). We want to get the indices of numbers from the array (local!numberList) that would not make the local!initialValue negative when added together.   The result we are expecting from the sample values in the image is: {1, 2, 3, 5} If we have local!initialValue = 100 & local!numberlist = {5, 100, 15, 100, 25}, the result should be: {1, 3, 5} We're having a hard time thinking of the way we can do this. Would gladly appreciate your help.

Hi [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] , I want to click the id number in which it should take me to the summary view of the particular page.This everything happens in send email smart service.Could you please help me. Thanks, Priyadharshini,S

HI,As Length function doesn't consider the null values but Can anyone explain me why the below code has returned value 4 ? Thanks

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?