Process Automation

Hi Team, I was unable to get the data with the below condition that passing one ID should get CaseID: 1234 and passing more than one than one ID should get CaseID: Multiple ID a!localVariables( local!data: a!queryEntity( entity: cons!BEMS_ENTITY_PAYABLE_CASE_VIEW, query: a!query( aggregation: a!queryAggregation( a!queryAggregationColumn(field: "clientName", isGrouping: true) ), filter: a!queryFilter( field: "caseId", operator: "in", value: a!flatten({ ri!caseIds }) ), pagingInfo: rule!TCO_defaultPagingInfo() ) ), { if( local!data.totalCount > 0, if( local!data.totalCount = 1, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - " & "CaseId:" & joinarray(ri!caseIds, ", "), 80 ), if( local!data.totalCount >= 2, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - "

Hi all, I am trying to make a small robot that downloads an excel file from Appian and uses a macro template to apply formatting to the downloaded file.Using the Open excel workbook action on the downloaded file everything works. When I use the same action to open an xlsm file, that is, the file with the macro, I get this error which I attach.I thank in advance those who will help me solve the error.Best regards,Marco Pennacchia

local!data: { { name: "John", status: "Active", test: 10 }, { name: "John", status: null, test: 4 }, { name: "Alice", status: "Active", test: 5 }, { name: "Alice", status: null, test: 6 }, { name: "Bob", status: null, test: 8 } }This a the above data now my requirement is remove null status only for the duplicate name and transfer the test value to the non-null status.Can any one please help me with this.

Hi All, I created an RPA task and placed it in the process model, but it is not executing in the RPA instance. can anyone give me the solution.

Hi everyone, I have a use case where a due date will be the 2nd Wednesday of the next month of given month and year. 

Hi,Having the below scenario,Having 2 different object lists as below. Now A type of object having 1,2,3 fields, similarly for B object list as well.A - 1,2,3 B - 1,2,3 Now in the first for each the Items will be A object list. foreach( items: ri!A, expression: foreach( items: ri!B, expression: { If(fv!item[B.2] = fv!item[A.2], "Hi", "Hello" ) } ) )Here, I am getting an error on below line for referencing the fv!item of A's object list in second for each.fv!item[B.2] = fv!item[A.2]Can anyone help me out this? Thanks in advance.

I&#39;m unable to find where the mistake is in below code Reverse a string without reverse function:&nbsp;a!localVariables( local!result: ri!result, local!index: if( a!isNullOrEmpty(ri!index), length(ri!Input), ri!index ), if( ri!index < 1, ri!result, rule!T_Reversestring( ri!Input, local!index - 1, concat( local!result, index(ri!Input, local!index) ) ) )

I have some data in my DB in that one filed named &quot;CreatedOn&quot;(2025-11-20 06:00:44.470000) i need to&nbsp;group&nbsp;the details by CreatedOn&nbsp;i need to group data by current year ,current quarter, current month, current week and&nbsp; want to sum a field called &quot;EMI&quot;Using a!quereyRecordType() | this will be in a rulei want to hit this rule only once to get all of this data in a stretch&nbsp;How to achieve it

Hello, I am trying to access UiPath through a connected system. I have tried to access UiPath through a connected system, but the test connection fails and the following error occurs. Can you please tell me why I cannot connect? I am using the cloud version of UiPath and&nbsp;Orchestrator (license is Pro trial). Thank you in advance.

Hi fellow Appian Community! Can you provide information on AI tools or plugins available for verifying the authenticity of digital signatures on documents? Most documents are captured using a phone or scanned via a printer. I am looking for solutions that can utilize image comparison techniques for signature analysis, or any other similar tools/techniques, even under such conditions. Your recommendations will be greatly appreciated.Thanks!

so here to reuse the obj i have written like this. but for one scenario i have to use one output for another scenario another output how to achieve that&nbsp;

Hi I want to Calculate the date difference in to Months and years&nbsp; form given dates&nbsp; date1: 15 Jan 2022 date2: 15 Jan 2024 date2-date1 ANS= 2 years In Appian date difference&nbsp; date2-date1 is calculating only days&nbsp; 730

Hi All I am trying to&nbsp;design a generic rule which will take recordtype. filter fields and filter values and filter operators and final filed as inputs and it should give result of that final field after ruining the query Record and applying the aggregation.It is working if the filter are single or multiple and all filter operators are &quot;=&quot;,&quot;&lt;&gt;&quot;,&quot;&lt;&quot;,&quot;&gt;&quot; but not when filters are multiple and operators are mix of in ,= or not in,= .here is the code i have used.&nbsp;a!localVariables( local!filterFields: { recordFields }, local!filterValues: { a!update(a!map(), "1", { 21, 27 }), true() }, local!filterOperators: { "in", "=" }, index( a!queryRecordType( recordType: recordName, fields: finalOutputField, filters: a!queryLogicalExpression( operator: "AND", filters: a!forEach( items: { local!filterFields }, expression: a!queryFilter( field: fv!item, op

Hello,I am developing a robot that performs a registration on a website. The problem is that sometimes when I click the &quot;Sign In&quot; button, it shows the message &quot;Invalid or expired reCAPTCHA token.&quot; This is not a reCAPTCHA that involves puzzles or checkbox clicks; it&#39;s just a message. If I click manually, it sometimes allows me to proceed. I have tried implementing pauses and mouse movements, but they don&#39;t always work. I would like to know if there is a viable solution to bypass this reCAPTCHA. Is it possible to add a support file to the robotic task that solves reCAPTCHA? If so, do these solutions have a cost, and which ones do you recommend? Or is there another solution?Thanks

Hi All, I have created a new AI skill object for text generation in the Appian Dev environment. The skill was successfully created and tested with different temperature settings, and it works as expected. I have integrated it with my process model, published, and saved the model. However, when attempting to deploy the AI skill to the Test environment, the deployment fails with an import error. During deployment, there are no warnings or dependency issues shown. The deployment log indicates the following message: Problems (1):aiSkill 8292bde1-7e28-4b70-a94f-890b679ab860 &quot;NH_Generative_AI_Skill&quot;: An error occurred while creating aiSkill [uuid=8292bde1-7e28-4b70-a94f-890b679ab860]: Name is insufficiently unique (APNX-1-4071-032) (APNX-1-4071-007) I have attempted to resolve the issue by changing the name of the AI skill, but the problem persists. Could someone assist me in identifying the potential cause of this issue? Additionally, out of curiosity, could you let me know whic

Hi everyone, I&#39;m facing issue while saving unique identifier value into a local variable. By default indexes are getting saved but I want to save the identifier value so that even if custom filters are applied only the actual selected value is checked/selected in the grid. The working approach I came up till now is to convert my data into a datasubset using a!dataSubset and then use todatasubset with fv!pagingInfo from the grid. The issue which I found with this is todatasubset function is not able to over ride the paging configured by a!dataSubset, it could very well be an Appian issue not sure but due to this I&#39;m getting full grid data in the screen. (Screenshot attached for this below) If you know any workaround for this or any approach you implemented for this use case please share!

Hi, I am evaluating Appian&nbsp; OOTB capabilities for Document extraction. We have Trained an AI skill, used it in a process model, reconciled it, etc. But what is not written or documented anywhere is how is Appian doing this behind the scenes. I am trying to understand if a client is using Appian Cloud, where does the Model run does it use the same infrastructure, if yes then how does this affect the memory/cpu power (Models are generally cpu hungry is what i understand). So by introducing an AI skill to an existing model how does it affect the runtime performance of the process model, the memory consumption. Do we need to consider any upgrades in the Appian engine before using AI Skills.

Hi everyone, I have this specific use case: I have to extract data from a pdf document using AI Skills. The pdf document has the structure of a table, with multiple rows. So the problem is, when setting up the AI Skill, when I want to label the fields, I can only select one of the rows. I want to extract the same field, say &quot;email&quot;, for all the rows in my pdf table. Still haven&#39;t found a way to label repeating fields inside a document. Any workaround or help is much appreciated, thank you.

Hi Team, I am trying to setup the RPA , and the&nbsp;agent icon colour appears&nbsp;GRAY&nbsp;and in the logs I am getting &quot;java.net.UnknownHostException&quot; Can anyone please suggest. Thanks

I want to perform a regex match&nbsp;in such a way that the text should start from # symbol and text should be from a - f and 0 - 9 Eg: #123A34 (hexcode)

How to create list of unique 3 character alphabet code. If i pass &quot;AAA&quot; and 2, it should return &quot;AAB&quot;, &quot;AAC&quot;. 2 unique codes after &quot;AAA&quot;

Hii I have requirement to trigger PM on 15th business day of each month so, ( workday( date(year(ri!date), month(ri!date), 1), 13, { null() } )) By this expression i&#39;m getting 15th working day of month bt as we have timer event and in that monthly time recurrence will ask for On Days&nbsp; So How we can do that ?

Hi , I want to know the character limit that the Appian Private AI (GEN AI) - Document Extraction. I&#39;ve uploaded a document with table value of 43 rows. But in the response , I can get only 30 rows as incomplete. I have altered the prompt also, but its not the problem. I&#39;ve searched about the character limit of Extraction , But couldn&#39;t able to find it ..&nbsp; Can anyone help me with this matter?

Hi, I am using Appian&#39;s Execute Gen AI Skill smart service for unstructured document extraction. I want the document extraction ID similar to what I have in the Document Extraction Smart service. Is it possible to obtain the document extraction ID in this case?

Hi&nbsp; We recently encountered the following alert in the Operations Console:&ldquo;You have robot(s) using an outdated auto-login service. Please reinstall the robot(s) to avoid disruptions. The outdated version will be unsupported in a future release.&rdquo; However, we have already updated to the latest versions: Agent Version: 9.14 Java Version: 17.0.12 Has anyone else faced this issue, and if so, what steps were taken to resolve it? Any insights would be greatly appreciated. or agent re installation will work? Thank you!