Discussion Categories

Hi, How to get the staring date time of week using the current now() function in Appian? Example suppose Wed 14-05-2025, I want to get the date of starting of week i.e Monday 12-05-2025. Thanks Bihitak

Hi Everyone, I got this error one time "at function a!flatten [line 5]: Cannot read the array length because "<local3>" is null" in expression rule. Unable to find the root cause because local3 is not used anywhere in the expression. Can anyone please help me out.

Hello Folks, I have a requirement to display last login time for any user whenever they login to the application. As we know, it's a site page, where-in a user lands whenever they login, and a process can be triggered only with user interaction. Is there any way to implement this? Any suggestion/help is highly appreciated. Thanks in advance! Thanks Shobhit.

In this image its mentioned as CDT will created for record type with no data sync But in the next course it is mentioned as CDT can be created automatically for action page for record type with datasync enabled

Hi everyone, I'm working on a project where I need to generate quote PDFs that include both dynamic data and images. I’m currently using Advanced Document Templating (DOCX from dynamic template → PDF from DOCX), and while the DOCX file looks great with the images inserted, I’m running into alignment issues when converting it to PDF — the layout shifts and the formatting isn’t consistent. Has anyone else faced this kind of issue with images during the DOCX-to-PDF conversion? Also, I’m wondering if HTML to PDF might be a better approach for this use case. If so, does anyone know how I can include images from Appian document folders in the HTML content? I need to add them dynamically, similar to how I’m doing it with DOCX templates. Any suggestions, experiences, or tips would be really helpful! Thanks in advance!

In appian developer course, they mentioned CDT is used for Record type with no sync But in the next Leason , they mentioned CDT will be created automatically once the Action is created for record type with Datasync enabled. where we use CDT ? for non synced record type or synced record type

I have an interface that displays an interface with a form if a local variable is true, else it shows an interface with a grid. The desired behavior is once the user creates an item using the form, the grid will automatically update to display the new item in the grid. It does not do this. The user has to click the grid refresh button to see the new item. The form saves the item using writeToDataStoreEntity in the saveInto of the submit button. On success, it changes the value of the boolean which causes the grid to appear to the user. The grid is a record-backed grid. Changing the grid to use a DSE or changing the form to use a record are not allowed. A process model is also not allowed. Placing the recordData in a local variable and using refreshAfterVarChange does not update the recordData. Using the refreshOnVarChange parameter in the grid does not refresh the data. Placing the grid interface in a local variable with refreshOnVarChange also does not cause the recordData to update.

Hello, we have the MS Graph Email Poller installed and operating. However, I noticed today that the BCC_EMAILS and BCC_NAMES columns are not populating for ingested emails. Is there a configuration or setting that needs to be applied in order for those to work? Thanks

Hi, we are using CMS applications and have made custom changes to meet our business requirements. However, we want to keep the CMS version up-to-date to utilize the latest features. Could you please provide the steps or guidelines for upgrading the CMS to a newer version without losing our business changes and incorporating the new features.

Hi Appian Community, I am using Export Data Store Entity to Excel Smart Service to export DSE data in excel format using formatted template, Issue is it is overwriting the template, and suppose two user requested to generate excel, so excel doc generated has overwritten the previous users data. This issue would be fixed in case this smart service generate new doc every time using formatted template. is there any way we can fix this issue?, Please help what to do in this scenario. Thanks in Advance. Shree Krishna Tiwari        

Hello, mates! I would like to create a rule that will provide choices/options through parameters to be used with the choose() function (https://docs.appian.com/suite/help/25.1/fnc_logical_choose.html) However, the choices will not have a default length. I tried using Appian array, but as expected, it didn't work because choose() expects individual parameters, not an array. I'm working on creating a tab interface component, where the number of tabs isn't fixed, hence the need for dynamic choices. Does anyone have any hint on this? Thanks.

I have being seeking information about my problem but I haven't found the properly anwser. I have a constant as you see: I'm creating dinamic subfolders inside this folder. Inside them I'm going to create documents. In some situations I will need to delete the documents in a particular subfolder and delete the subfolder as well. I have cheked the documentation (delete folder smart service, delete document smart service) but I don't know how to use it because I need to provide a folder type in the Input variable and I haven't this type of data. I have a variable with the name of the subfolder that is dinamically generated (for instance, today's date) and I need to use this name to delete the subfolder as well. Is there any way to do so? Thanks in advance!

Hi Team, Just want to know. How to find time complexity and space complexity for Appian in-built functions since its not available in each Appian documentations. Is it possible to find which kind of algorithm used for creating there in-built functions for all the cases like best-case and worst-case sceneries.  Thanks and Regards, Vigneshkumar Radhakrishnan

Hi, We need to get the users access and refresh tokens using the SAML assertion. We tried to do this creating a connected system with the authentication method OAuth 2.0: SAML Bearer Assertion Flow. The problem we have with this solution is that the assertion along with the client id, client secret and scope are added as a header when calling the integration. We are required to send the assertion separately in the request body, so we are trying to find a way to get the assertion after the users login with SAML to add it to the body of the integration to retrieve the tokens. Has anyone done something like this before or knows how we can access the SAML assertions stored in Appian? Thanks in advance. 

Hi there, I'm on the last part of the instructions where we have to create a record action: 1. In the left menu, go to the Actions page.2. Click GENERATE RECORD ACTIONS.3. In the Choose Your Action dialog, deselect Update and Delete. For this exercise, you will focus on the Create record action. Click CUSTOMIZE.4. Configure the following properties:● Display Name: Enter Add Vehicle.● Description: Enter Action to add a new vehicle to the fleet.● Click NEXT: REVIEW OBJECTS.5. Review the objects that Appian generates for this action, including a process model and interface for adding a new vehicle.6. Click GENERATE. After clicking GENERATE in step 6, I am put back at the Actions page with the following error displayed (Your record actions and supporting objects could not be created. Try generating them again or configuring manually.): Interestingly, when I look at the object listing for the site, I see that the Process Model was generated, but not the Interface: Any suggestions

Good morning, I need to add an editable column in a gridField because I don't want to lose functionality. Is it possible to do this?

Can I assume Stored procedure in DB side and Expression rules in Appian side having same functionality/usage?

Hello everyone, I am having issues with querying process report which has multiple (different) values in one column. The column is filled with data from a list of CDTs, for example: I've tried setting it as a list of integers and strings, but either way, when trying to query all rows which have a value "12345" in that column (by using a!queryProcessAnalytics), I get no results. a!queryFilter( field: "c4", operator: "includes", value: tostring("12345") ) I also tried all different combinatios (in, includes, strings, integers....). Thanks in advance!

Hi team i am unable to fetching the data using the query entity,due to some restrictions i have to use the CDT only so i am using query entity for fetching  the data,(I want this data for displaying into the read-only grid)i have 2 tables in DB1st table having the 42 columns and 26191 rows of data so i am using the below code for fetching the hole data  a!queryEntity(entity: cons!1stentity,query: a!query(pagingInfo: a!defaultValue(value: ri!pagingInfo(Type:pagingInfo),default: a!pagingInfo(startIndex: 1, batchSize: 10)), ),fetchTotalCount: true(),), but using this code i can able to fetch 21568 rows of data only not able to fetch the whole data,2nd table having the 8 columns and 389434 rows of data so i am using the below code for fetching the whole data. a!queryEntity( entity: cons!2ndentity, query: a!query( pagingInfo: a!defaultValue( value: ri!pagingInfo, default: a!pagingInfo(startIndex: 1, batchSize: 10) ), ), fetchTotalCount: true(), ),From this tab

Doing Appian Developer course in which under Engage Logged IN Users excercise it is trying to add a second page as Action where we have to select Process Model which doesn't exist when trying to add an empty Process model it keep throwing this error - help me with steps how to getrid of it or point me to excercise which I missed and can follow to get rid of this error

hi team, how to add the multiple documents at the same time to record  could you please suggest me. thanks

Hi All, I am having a requirement to generate a PDF Invoice. I am using PDF doc from template smart service. I have to display data in table where number of rows are dynamic. Question: How to create dynamic tags in PDF template that will accept dynamic data. 

Getting below error while starting tomcat {"error":{"root_cause":[{"type":"security_exception","reason":"unable to authenticate user [appian] for REST request [/user-activity-8-0/_settings?master_timeout=30s&timeout=30s]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}}],"type":"security_exception","reason":"unable to authenticate user [appian] for REST request [/user-activity-8-0/_settings?master_timeout=30s&timeout=30s]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}},"status":401}  

I currently am doing an aggregate query that groups by two fields and sums a third field.  The result is the following: [period:1,week:1,total_hours:2]; [period:5,week:1,total_hours:3]; [period:2,week:2,total_hours:5]; [period:6,week:2,total_hours:8]; [period:12,week:3,total_hours:4]; [period:3,week:4,total_hours:2] I am trying to pass this data into a grid but with one row per "week" value with an array of period / hour values as below: [week:1,periods:[[period:1,total_hours:2],[period:5,total_hours:3]]]; [week:2,periods:[[period:2,total_hours:5],[period:6,total_hours:8]]]; [week:3,periods:[[period:12,total_hours:4]]]; [week:4,periods:[[period:3,total_hours:2]]] - Can this be done in the queryRecordType itself? - Which array methods would be best suited to handle this? - Should I be using foreach to do this?

Is is possible to create an interface where there is a carousel list for images, cards, etc. ? Refer to the image above.