Discussion Categories

Hello Team, We have a requirement to populate data into an excel template which will spawn for multiple sheets. This would be in a process model as we fetch the data to populate from a rest service. We were able to achieve populating data into the excel template using the using "Export Data Store Entity to Excel Smart Service". It works fine for regular mapping. But we are stuck with these 2 requirements.  1) We are were not able to dynamically insert rows into output excel sheet in this flow, when needed. There is a requirement to dynamically insert and populate rows in certain places (in the template), which we are not able to get through. 2) Also we are looking to see if there are any plugins or ability to dynamically delete redundant sheet from the output excel. Appreciate any inputs and suggestions.

It is regarding image recognition I store image of 8,+,5,= so as per pdf it should be excused in calculator and answer would be 13 but it is not executing and that why I am not able to complete this lesson Facing the issue after completing the all steps provided by Appian Document Anyone Guide me how can we resolve this....

I am an SQL Server Database Administrator and I will be migrating the Appian database from a stand alone SQL 2019 server to a clustered SQL 2022 server that has Always On Availability Group.  The Availability Group will be stretched across two subnets and will employ a listener for the application to connect. My question are: A: Do you see any problems with the configuration I am proposing for the SQL server set up - SQL AG and listener B: What features do I need to have installed on the SQL Server. C: Do I need the Client Tools SDK feature installed on my SQL server - I found it installed on the existing server D: What SQL Database permission are required for the Appian user that connects the app to the SQL server.  I like to work on the least privilege concept Please if you have the answers to these question or if you have a document that illustrates my SQL settings I would appreciate it I look forward to hearing from you Jeffrey

Hi Appian Community I am using a web service to fetch the records I have synced all the records successfully but, in the list, there are less records available.  Sync successfully for 10046 records but only 6549 available in the list

Hi everyone, I'm having this issue and trying to find some help/ recommendation.  I'm having this process report that contain 1 row of data. But when I run the expression rule to query it with 2 different user account, I get different results, even though the 2 accounts are in same All Users group and that group has Viewer level security in my report.  With my main user account, when I run the query I get that 1 row of data back as output - expected With my test account, I get null value as output - Even though when I open the report I can still see data displayed.  Is there any other areas apart from security level that I should look at?  This is my code snippet, I just input in the context process model and report if( ri!isMissingMinimumInputs, if( ri!doReturnData, {}, a!dataSubset() ), a!localVariables( local!columnConfigs: if( not(rule!GBL_isEmpty(ri!columnConfigs)), ri!columnConfigs, a!queryProcessAnalytics(

How does RPA agent connect/communicate with orchestration server ? Is there any specific ports need to open - considering the agent is internal to company's infrastructure and the appian is in cloud..

From the Grid Layout list i need to add to the other Selected List which is Related Record Data. So when calling this grid interface i am facing issue in the Parent Interface that. When I am selecting more that one item from the list it throwing me the below error. Please let me know how to rectify it Interface Definition: Expression evaluation error [evaluation ID = 033a4:c74b3] : An error occurred while executing a save: Expression evaluation error: Cannot update List of DIL Product User Trans; length of assign value list (2) does not match length of the list to update (1) 1. No Error while selecting 1 item from the list 2. If select more that on item from the list it throwing the below error

Hi All,       What is the Maximum number of nodes in Process Model?  Process Models contain no more than 50 nodes (limitation from Appian side). But i heard, maximum number of nodes is 38 in latest Version.can you pls confirm and send me the link.  Thanks in Advance!  Thanks, Kanna.R  

or( and( rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{8435c94d-c75d-4250-b60c-267fa8e9fe8c}locked']=false, a!isNullOrEmpty(rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{6586c1e5-e5c7-4f5b-8a42-04f5c067aab3}utenteLocked']), a!isUserMemberOfGroup(username: loggedInUser(),groups: cons!SLC_GRP_VERIFICATORE_INFRATEL), contains(cons!SLC_INTS_ID_FASI_PROGETTO_DI_CONNESSIONE[3],rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{12f3ca11-6e56-437c-a111-0188f3e80076}idFase']) ) ), or( and( rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{8435c94d-c75d-4250-b60c-267fa8e9fe8c}locked']=false, a!isNullOrEmpty(rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{6586c1e5-e5c7-4f5b-8a42-04f5c067aab3}utenteLocked']), a!isUserMemberOfGroup(username: loggedInUser(),groups:

Hi, How we can create dropdown using record data?

Hello, I'm creating a process model to synchronize a database with a record type.In the process, I created a node that uses the "Sync Records" smart service.According to the documentation, synchronizing more than 1,000 records requires a loop.I've followed the steps, but the "Sync Records" smart service doesn't return anything inthe "ac!RecordsUpdated" variable, which should be used to avoid an infinite loop.Here are some screenshots of the configuration and docs link. docs.appian.com/.../Sync_Records_Smart_Service.html The import to the database is successful, but the record type is not synchronized.

Hi everyone, We have configured a process report to retrieve all active processes. Additionally, we have a query to obtain the active process ID for each case based on the Case ID. However, we are encountering an issue where multiple values are appearing in the column of the process report (mapped pv value for column in process report). As a result, some of the active process IDs are not being queried correctly. Could someone please help us understand why multiple values are appearing in the process report? Is it because the process report contains the value changes from the process history?

a!localVariables( local!choiceValues: cons!VS_VALUES(list of array : "AB","BC","CD",) local!dropDownValue, local!value, a!multipleDropdownField( choiceLabels: local!choiceValues, choiceValues: local!choiceValues, value: local!value, saveInto: { a!save( local!value, if( contains( save!value, index(local!choiceValues, 1, {}) ), 0, save!value ) ), a!save( local!dropDownValue, if( contains( save!value, index(local!choiceValues, 1, {}) ), remove(local!choiceValues, 1), save!value ) ) } ) ) Hi All. Hope you all are doing well.  I am using multiple dropdown and working with records. The above code i am trying to edit already present value in the multiple dropdown. Above is the code .  If i try displaying the selected value i am unable to deselect it and

Hi,What trying to create a sample data for a Record Type but is throwing the below error. Even tried suggestion given on the error but again throwing the same. Kindly let me know what else can be done. 

Hi Team I am using an environment specific date constant. This is an array of dates constant .. I want to deploy to higher environment but in such a manner that the constant should be null ( because I will be appending values in it via process model as part of logic later ) While deploying I am passing nothing in the custom properties file  eg :   content._a-0000ed12-853e-8000-9c18-011c48011c48_2772176.VALUE= But when seen in higher environment it comes like this :  I wanted it to be blank ( i.e. nothing in the constant ) .. somewhat like this :  Is there any way we can achieve this via custom properties ?

How can i check what value appian returns?

If a user belongs to two different application groups and both the groups are added to user start page (different application), which application start page will they see after logging into Appian?

I'm trying to delete using a delete action inside interface using a stored procedure because I also need to delete related data from other tables. However, I'm facing an issue: the entity is successfully deleted from the database, but it still appears in Appian. I have a subprocess that runs after the stored procedure to sync all the updated tables, but the entity remains visible in Appian until I manually trigger a sync—after which it disappears as expected. Does anyone have any idea what could be causing this issue? Any insights would be greatly appreciated! here u can see the main subprocess sync : and an example of one subprocess sync:

Hello, Previously, in v24.4, I was able to configure a data source for SQL Server. Now, in v25.1, I can't. Any suggestions? Here the error: Thanks in advanced! Allan

Hi, I'm new to Appian and apologies if I missed something really obvious.I'm running into an issue attempting to capture selected choices and their respective labels of an a!multipleDropdownField(). I've declared 4 local variables to hold the list of available choice labels, available choices, selected choice labels and selected choices. a!localVariables(  local!arrChoiceLabels: {"Option1", "Option2", "Option3"},  local!arrChoiceValues: {1, 2, 3},  local!arrSelectedLabel: if(    a!isNullOrEmpty(ri!rec.selected),    {},    split(ri!rec.selected,";")   ),  local!arrSelected: if(    a!isNullOrEmpty(local!arrSelectedLabel),    {},    wherecontains(local!arrSelectedLabel,local!arrChoiceLabels)  ), Then I tried to plug them into the multiple dropdown field,  a!multipleDropdownField(    choiceLabels: local!arrChoiceLab

Hi all, For context, I'm trying to display a record type "Files" which as of last week has hit the memory threshold (800,000+ records). The record type is still legacy. When I try to access the record via Tempo > Records > Files, I'm displayed with  "The Requested Record Type Is Not Available An error occurred while retrieving the data for "File". Details: Unexpected error executing query ...." I've tried a few approaches but the most noteworthy one is  :  1) Updating the default filter criteria to only show Files that were created the last 2 years. The problem with this is if I need to access something older than the 2 years I won't be able to. In short, I just want to limit the Record List view to maybe 200 records but the data source having access to all 800,000+ records so that I can still have a functioning record that can display the appropriate views when accessed individually. Thank you.

So I have a process where a user uploads a .csv or .txt file with numbers. Those numbers are then extracted and ran through various validation checks. When a user uploads it in a .txt file, no issue. When it's a .csv file, the very first value, a fn!char(65279) is always added before it, so it's failing the validation check. Like so: When I copy the expression and paste it into the rule input of my validation expression rule, that first number always fails the validation check. But if I remove the fn!char(65279), it passes and works. A quick google search showed me that this is some sort of whitespace character. So I tried adding trim() to the variable that hold each individual extracted number, but that doesn't appear to make a difference. Does anyone have any idea? To either prevent that char from being extracted with the data, or to remove it after extraction? Thanks for any help.

Hi everybody!I am getting a weird error when I try to select a connected system to create an integration object. As soon as I write anything on the connected system field: I get this error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 87317:f0efe] : Unable to find Connected System Template with the id "plugin.[uipath-connectedSystem-rwm].[UiPathConnectedSystemTemplate]@2" I don't understand why the error mentions a plugin as we are not using any plugin for integrations/connected systems.Has anyone seen anything similar?Thank you

I have made changes to the custom.properties file, specifically:appian.feature.selfManagedMonitoring=true. I validated and deployed the changes, and also restarted the server after deployment. However, upon checking the configure.log file, the configuration changes are not being reflected.

Good dayI have robotic process, that uses the e mail to send notifications and retrieve information from the mail body or the attachments. Today by the morning, i am notified that the robotic process arent reading the mail. i'm Using this dependency com.sun.mail javax.mail 1.6.2 I'm using this process:public ArrayList getTodayNewEmails() //throws Exception { //EmailInfo toReturn = new EmailInfo(); local_server.info ("Obteniendo los correos nuevos de hoy..."); ArrayList messagesList = new ArrayList(); Properties props = System.getProperties(); props.put("mail.store.protocol", "imap"); props.put("mail.imap.auth.plain.disable", "true"); props.put("mail.imap.host", host); props.put("mail.imap.port", ""+port); props.put("mail.imap.ssl.enable", "true"); props.put("mail.imap.starttls.enable", "true"); props.put("mail.imap.auth", "true"); props.put("mail.imap.auth.mechanisms", "