Discussion Categories

I am using Import CSV to Database v6 to import CSV file to a database. I have a field in the table that is not part of the CSV. I tried to configure the additional column and additional value thinking that will store the value into the table but it didn't save the value in the table. Any thoughts how to populate the field in the table that is not part of the CSV using this plugin? For instance, my table has 5 columns, my csv has 4 columns and I want to store a value in the 5th column of the table (e.g. hardcoded value). Thank you.

Hi community, I've just started exploring the Appian. I'm trying to create a new vehicle form based on the tutorials, but the form inputs are being cleared when clicking outside of the input fields. This is the code a!localVariables( a!headerContentLayout( header: a!cardLayout( contents: { a!headingField( text: "Create Vehicle", size: "LARGE", fontWeight: "SEMI_BOLD" ), a!richTextDisplayField( labelPosition: "COLLAPSED", value: { "Enter vehicle details" } ) }, style: "ACCENT", padding: "STANDARD", showBorder: false ), isHeaderFixed: true, contents: { a!columnsLayout( columns: { a!columnLayout( showWhen: a!isPageWidth( { "DESKTOP_WIDE", "DESKTOP", "DESKTOP_NARROW", "TABLET_LANDSCAPE" } ) ), a!

Hi All,  I m a beginner in appian. As part of my request, I need to build a editable grid with record data rule input. I have 5 fields totally and I need to display them. Can someone help me how to configure edit button and add button and what actions I need to perform to save or update the values to the rule input. And i should add only one row at a time and all the fields in grid are mandatory. Can someone help me with the code. 

Hi all, there is one requirement where user will search with 2 to 3 part number like 3456,3234. We should show in which countries this part numbers are allowed to use data base structure :  countrylistid(pk) , partnumber, countryname, isallowed(bit(1)). Notes : For 1 one part number there are 150 entries in database.

Good day, fellow Appian developers, I have a question about best practices regarding managing document uploads conditionally. Scenario: I have about 11 user tasks in a new application. Each task has different business logic regarding what documents can be uploaded and how. For example: On the first task, only documentType1 and documentType2 can be uploaded. documentType1 can be uploaded only once and must have a .docx extension. documentType2 can be uploaded multiple times, with no restriction on file extension. Business rules will vary from task to task. Additionally, this setup is currently only applicable for country1/organization1. Over time, this process will be adapted for seven organizations/countries. Each organization will have different business rules about what documents are required and how they can be uploaded in each task. Since this involves quite a number of validations, what is the best practice for creating a generic document upload component that can work ac

Hello, I am encountering a recurring validation issue while attempting to install version 24.2 of the local Appian application on my computer. Despite thorough checks, the problem persists during the configuration validation process. I have verified the following: SQL Database and Driver: MySQL 8.0 with InnoDB engine, connector: mysql-connector-java-5.1.49-bin. System Variables: Correctly definded. Configuration Files: The custom.properties and tomcatResources files are set up identically to a successful 23.4 installation on my computer (with the folder name changed to avoid conflicts), so they should be correct. Licenses: The k3 and k4 licenses are valid. As i said, I keep getting the same issue while trying to validate the configuration:Is there a log available where I can review the reasons for the validation failure? Thank you.

I'm using this readlinesfromtextfile plug-in, which is currently no longer available on the App Market, I get an error during conversion where every accented letter or apostrophe is converted to this value � .Can anyone help me?

Hello All, I am facing issue with the following map. I am building dynamic filters. Here is the map is the output. But I wanted to delete logicalExpression:{} from the map. It can be there at any level. If logicalExpression is null then my resulted map should not contain logicalExpression:{} a!localVariables( local!conditions: { a!map( operator: "AND", logicalExpressions: { a!map( operator: "AND", filters: { a!map(field: null, operator: null, value: null), a!map(field: null, operator: null, value: null) }, logicalExpressions: { a!map( operator: "AND", filters: { a!map(field: null, operator: null, value: null), a!map(field: null, operator: null, value: null) }, logicalExpressions: {} ), a!map( operator: "AND", filters: { a!map(fiel

Hi there, How could we implement maker and check/4 eye check in Appian.  My process have 2 tasks (claim submission and approval), both the task is expose to same Group (say sales group)  However, If I have created claim (first task), I should be able to approve it. Even though I am part of the group.    

Hello, Iam new to this platform and i have a use case but facing issues on Receive message event. the user is sending the Mail with attachements to Appian DL(processmodeluuid12582365452632563263@appian.com) when ever the email triggered with the Subject" MRD Report" it has to check the attachments and save it in the appian folder by using Receive message and also if there are attachments(1 or more) without changing the attachmement names. could any one help how to create this use case it will be a great help. appian version 23.2

I am using TextToHex() function available in HexFunction Plugin. Is there any replacement plugin available for hexFunction ? is this cloud approved for version 25.2 ? 

Hey Everyone, Im trying to embed a powerBI into one of our Appian apps. Considering that this report has to be exposed to users who might not have powerBI licenses there is a way to expose it externally within an application by using "Embed for your customers" feature.  Understanding the different embedding solutions in Power BI embedded analytics | Microsoft Learn     This means that the only potential obstacle is Appian. I have observed that the webComponent in Appian appears to be unable to pass any data, including tokens (it can only accept url). Is there any other way for implementing such functionality? I believe that creating our own custom plugin might be an option although I dont have enough expertiese in it yet to make that judgement. Would custom plugin be able to achieve this requirement or is there any other easier way in Appian to do the same? I had a look at some existing powerBI plugins but they dont seem to be for "Embed for

We have a requirement to pull Service backed records which needs some query parameter to it only pulls Records based on user selection.  I was not able to find a way to pass parameter to the recordtype , is there a way to do that  ? rule!myIntegrationPointingToServiceBackRecords ( input1: ri!input, batchnumber: ri!batchnumber )

Hi, I have a gridfield inside a foreach loop. I need to display the items side by side. Currently it is displayed one below the other. I need to display 2 grids in each row.  How to achieve this.

I have created a process to loop through each row in a record, and for each row, I have defined a set of instructions to execute. However, I'm encountering an issue where the process enters an infinite loop. In the "Get Script Task," I am using a simple query to retrieve data from a record. I attempted to save the query result in a multiple variable, hoping it would allow me to loop through the rows correctly, but it still results in an infinite loop. the problem is im not able of retreiving a single value of a frild form the record , its concatenating all the values in the output  inside the variable ,and not one by one which cuases this infinte loop , and this what im passing for codice progetto : pv!ImprotPregressoPC['SC Import Pregresso PC.fields.codiceProgettoConnessione'] how can i make it retieve one by one every loop?

Hi [mention:b1ec831bc63f413fb8baec7179cee8b3:23b05a61c3e5445190d9bfa00453bce4] / [mention:5357deb643314f689f0553cc98556414:23b05a61c3e5445190d9bfa00453bce4] ,  https://docs.appian.com/suite/help/24.4/rpa-9.16/java-module-ms-outlook.html  I'm working on creating a custom Java code for the Appian RPA MS Outlook module. While I've finished the Java component, I'm unsure how to integrate or put those into Appian RPA.  It would be great to get some insights on best practices and common challenges from someone with experience in this area. I tried to follow the Appian RPA documentation, but somewhere felt like lost. Could anyone with experience incorporating custom Java code into Appian RPA offer some guidance?   Thanks, Bharathwaj RK

Hi all, I want to automate the change of the deletion policy of a Process model (PM) when it is deployed. My idea is as follow: Look into PMs there were deployed. Change the data retention to delete after 1 or 0 day  have a list of exceptions to not be updated when these are deployed. To run this new PM for each new deploy How Can I extract the UUID of the deployed PMs and then change their policy.  I did this in the past but with old plugins that are not available anymore (and in other cloud instance). Thanks in advance

Is there anyway I can use github copilot to analysis my application.

Hi! I was wondering if it’s possible to add a “Select All” option to User Filters in a Record Type. I tried but couldn’t find a way. The business needs to be able to select all options and then deselect a few, rather than having to select each one individually, which is time-consuming when there are many options. I know it’s possible to do this in a custom interface, but I’m curious if it can be done from the record side. Thanks!

Hello,  I'm currently looking for a way to pull data from the Appian Database into Microsoft Power BI. Our goal is to use Power BI to create reports based on the data we have in Appian. It would be very helpful if there is a way to connect the Appian database to Power BI directly, so we can start building reports in Power BI, where most of our users are comfortable creating content. Ideally, we would like to avoid using plugins, but if necessary, we are open to that possibility. Thank you so much for your help!

When i am trying to access the Tempo record i am getting below error can anyone suggest us how to resolve this issue 

Look at these two screenshots (English version vs Spanish version): In the Spanish version the process model name is missing. Do you know if is it a bug in the 25.1 release? Thanks.

Hello Community, I've created a new Process Report in Appian Designer, which worked fine, but I am not able to save any changes to this report. I simply want to add 2 new columns. These get displayed as intended in the preview, but when pressing save on the pop up, nothing happens. I checked my browser and it seems like the URI that is called is wrong: /suite/analytics/report/save.bg?appian_environment=designer --> No resource with given identifier found Do you guys know how to fix this issue, or do you know which URI I can call manually to save my draft? Thanks!

Hello, I'm extracting data from the database using the 'Export SQL to Excel' smart service and then using the 'Send file over SFTP' smart service. I'm doing this for 4 different tables but the issue 'java.io.IOException: inputstream is closed' seems to appear only for one of the tables. The issue seems to appear randomly as it usually works correctly.  I found an article that addresses the issue directly so I followed the advice by adding a timer (first 1 min then 3 min) before the send over SFTP but the issue persists at random occurrences. KB-1113 SFTP smart service transfers a blank file to its destination - Appian Knowledge Base - Support - Appian Community What could be the problem? Thanks in advance

Hi, I have a local variable with multiple values. I used foreach loop to iterate a grid. I got multiple grids based on the number of values in the local variable. I have another variable containing users. The user name should be displayed at the top of each grid. Example if there are 4 grids I need to display 4 names . Each name above each grid. I want to know how to merge these two values to display each user names at the top of each grid. local!user:ri!selectedLeaderIds (contains Users)