Discussion Categories

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)

How to trim this text: "UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_UDI_1_592268_Integral_-_MARSHA_BISHOP_-_banking-mb_jfblaw.ca" to  Integral_-_MARSHA_BISHOP_-_banking-mb_jfblaw.ca

HII'm working with the following table structures and need to display approval tasks to users based on the current milestone of each request. A task should be shown if the user is either directly assigned or belongs to the assigned group. Each row in Request table has multiple rows in approval table. Is there a way to achieve this using records (not a database view) given the structure below?  CREATE TABLE `table_request` ( `col_id` INT NOT NULL AUTO_INCREMENT, `col_loan_key` VARCHAR(32) DEFAULT NULL, `col_loan_1` VARCHAR(32) DEFAULT NULL, `col_loan_2` VARCHAR(255) NOT NULL, `col_manager` VARCHAR(100) DEFAULT NULL, `col_sponsor` VARCHAR(255) DEFAULT NULL, `col_milestone` INT DEFAULT NULL, `col_status` INT DEFAULT NULL, `col_submit_date` DATETIME DEFAULT NULL, `col_created_date` DATETIME NOT NULL, `col_created_by` VARCHAR(255) NOT NULL, `col_updated_date` DATETIME NOT NULL, `col_updated_by` VARCHAR(255) NOT NULL, `col_is_active` TINYINT(1) NOT N

I am trying to follow appian academy tutorial.  In the steps i have to call a record type using rule input in an interface. However, when i type my record name in New rule input type it is not shown. What can i do?

I am creating editable tree grid. I want to save the identifier value in local!selection. GridLayout and GridRowLayout are in two different rules.GridLayout in an interface and GridRowLayout is in a expression rule. the selection saves values in local when the selection style is "ROW_HIGHLIGHT" but not "CHECKBOX" Can anyone help me resolve this issue?

Hi, does anyone know what's the difference between using WhatsApp Business Connected System (plug-in) and Connected System with the base URL https://graph.facebook.com/

I am having one form ie. customer form, I need to hide the 2 fields like dob and email id from basic user automatically , like we can keep showwhen condition in the form itself but it is manual process , need to do automatically .. is there any way to do this? in appian

We are experiencing an unusual issue in our application running on Appian version 24.4. When users fill out a text field and tab out, the value is not immediately saved to the associated local variables or rule inputs. Interestingly, the value only seems to persist after entering text two or three times. This behavior is inconsistent and unexpected. Has anyone else encountered this issue or identified a possible root cause? Any suggestions or workarounds would be greatly appreciated.

I am in a site and I need to open an interface/site in a new Tab, and I need to pass more than 500 items in a List of Text format to the new Tab site

When retrieving data through an integration, if an error occurs, I want to display a detailed error message to developers for debugging purposes. However, if an end-user encounters the same error, I prefer to show a user-friendly message that doesn't expose technical details.

 I have created a form and now I want  likenow how will the input details of this form will go when we click on save  button and also how access CDT and DS and how will data get saved [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:2df2892a4df7486f9775b4d2f0e405fd:e9ed411860ed4f2ba0265705b8793d05]  [mention:ba9672c2f5294cb98c0a2b8fb79cf967:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

Hi! In the Appian Designer, we have interfaces with text fields that save into rule inputs or local variables. When entering in data into each of these text fields, the data is only sometimes saved in the rule inputs or the local variables. Why is the user input not saving all of the time? Has anyone encountered this issue before? Below is an example with four text fields. Text1 and Text2 save into rule inputs ri!text1 and ri!text2 both of type text. Text3 and Text4 save into local!text3 and local!text4. User input is not saved every time the value changes. a!localVariables( local!text3, local!text4, { a!textField( label: "Text1", labelPosition: "ABOVE", value: ri!text1, saveInto: {ri!text1}, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Text2", labelPosition: "ABOVE", value: ri!text2, saveInto: {ri!text2}, refreshAfter: "UNFOCUS", validations: {} ), a!textField( label: "Text3", labelPosition: "A