Discussion Categories

hmacsha256bytehashbase64key - We are using this funciton in appian onpremise and now we are deploying to cloud . In cloud this function is not supporting .Is there any alternative function to use instead of hmacsha256bytehashbase64key ?Thanks

I have created a Robotic task, and it is throwing error when I try to execute it. The error is "Problem when launching executions: ROBOT_NOT_ALLOWED_NOW". The robot is online and it as also added to the Robot Pool. Any reason we get this error?

Hi Team, I need Last working Day date of every month as i need to start process for every month Last working day. Let's say if i take Aug-2025 Month & its month end date is 31st & falls on Sunday but in my case process should trigger on 29th Aug which is a last working day. I need dynamic approach so that it iwll pick last working date & start process. prompt response really appreciated,Thanks

Hi, I am trying to generate excel document by using the a!exportDataStoreEntityToCsv(). Below is my code snippet: load( local!exportDocId, local!errorMessage, { if( isnull(local!exportDocId), a!linkField( labelPosition: "COLLAPSED", links:a!dynamicLink( Label: "Export Inactive Users Details to Excel", saveinto:{ a!exportDataStoreEntityToCsv( entity: cons!VW_EPMT_EWR, selection: a!querySelection( columns:{ a!queryColumn( field: "ewr_number" ), a!queryColumn( field: "name" ), a!queryColumn( field: "active" ) } ), documentName: "EWR Grid Record Data", saveInFolder: cons!EWR_FOLDER, onSuccess: a!save( local!exportDocId, fv!newDocument ), onError: a!save( local!errorMessage, "Error in Exporting File" ) ) } ) ), {} ), if( not(isnull(local!exportDocId)), a!linkField( links:a!documentDownloadLink( Label:"Download Excel File", document: local!exportDocId ) ), a!textField( value:local!errorMessage, readonly:true ) )

Hi all! New to Appian, and I am stuck on figuring out how to correct configure a dependent dropdown.  The first dropdown field is called "Plant," and its fields consist of plantId, value, & description. The second dropdown field is called "Storage Location," and its fields consist of werks, name1, & land1. Both queries have one similar field, which is "value" and "werks," but I need to call back "plantid." How would I do that? Thanks! 

Hello Everyone I want to achieve POPUP/Dialog Box in Interface without using Process model is there any way to achieve this within interface without using record action or process model ?  for now i am only using a!dynamicLink function for  show/hide option but for many USE Cases , POP UP would be the best option!  Thanks , Raj Thakor

Hi, I am trying to import a CSV file, but I receive this error "java.lang.IllegalStateException: (line 76) invalid char between encapsulated token and delimiter". The CSV file has an open quotation mark but no closing quotation mark, and my separator is ‘##’. How can I get around this problem? Is it possible to insert some escape characters?

Hi Everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I have a sync start process(Process Id is used to select the Process Model) in my Parent Process.Now I am not able to save the Output. PVs are not shown in pv!.

The basic user who has viewer permission can't initiate the send email node? Will it get errored at send email node?

Hello everyone, Is there a method to programmatically reset all column sorting/filters simultaneously within the GridPlus component? For instance, consider a grid with five columns where a user applies sorting and filtering on three separate columns. Currently, the user must clear each column’s sorting/filtering individually to restore the grid to its initial state. My idea is to reset all sorting and filtering criteria with one button action.Thanks!

Appian delivers process automation powered by enterprise AI, empowering organizations to design, automate, and optimize business processes through a unified platform for process orchestration, automation, and intelligence. This latest release, 25.3, introduces significant advancements and exciting features across the platform, including highlights on AI Smart Search, AI for self-managed environments, High-throughput data fabric, Generalized async loading for SAIL UIs.Join our team of Appian experts as they delve into the key highlights of this release. Tune in to see Appian 25.3 in action and engage with the experts by asking your questions.Turn on notifications to make sure you don't miss it!

We are seeing a strange issue in which write to record is not working properly. If we check the process variable value, it is successfully updated, but when we look at the database, the latest data is not being updated, no expression error is generated, and this is an intermittent issue. As per this thread we updated to latest version https://community.appian.com/discussions/f/data/39426/data-fabric---write-to-child-records-via-relationship, still we see same issue. Anyone knows the reason?

I am running some processing in parallel that includes api calls.The result with then populate an interface attended by a user. I have tried both a!forEach and MNI but for both the performance is not as expected. By looking at the performance tab in the expression rule, it is clear that the items in the array are running sequentially and not in parallel, as the total time for the expression rule is the sum of every iteration. As a test I tried to put only a GET api call in the foreach loop and the result is the same. This is not what I was expecting, is there anything that can be done to enforce the threads to run in parallel to optimize the performance?

Record Type details not showing after  click on View Record List

The description tooltip is not visible when hovering on the Record action icon. Although I was aware it was there, now unable to see this tooltip on icon.

Hi FolksJust sharing the experience!When writing to child record via write record, there was no error on process model, but it was still not writing to DB. Then we realized the issue was because of two reason which we did not pay attention 1. We need to make sure the record object is updated o latest version means below pop should not be visible 2. On the model switch to latest version of smart service.

Hi All, Below is one of the issue we are facing it an intermittent issue. While Executing Write Record Smart Service for the Process Models we are getting the below error:- Unable to write to or delete from the source due to a data integrity violation.Error Details: Column 'TaskStatus' cannot be null. The TaskStatus is set to NotNull in Database . We have always value set or Update in taskStatus Field before Executing the Write Record Service Node. Below is the Screenshot attached. attaching the logs screenshot as well for the issue:-

Hi all,  Is there any way that we can implement a copilot that will answer about our record data? For ex: it should be like a chat bot and it should be in the record summary page, if we ask about the details of the record summary, it should provide the answer. Can anyone please help me in implementing this ?Thanks in advance!!

Hi everyone. I need to step by step guide line . As my requiremnet (Connect  from Appian to AWS RDS Using Private Link)I checked this references link :https://docs.appian.com/suite/help/23.2/Access_Customer_VPC_using_AWS_PrivateLink.html I cannot understand below of point (check below of screenshot)>Appian will create a VPC endpoint to connect to the VPC endpoint service you have provided. How to create vpc endpoint in appian enviromnent?

I'm currently in the process of scheduling my first Appian certification exam. During registration, I was redirected to the Registration | ProctorU platform, which requires me to select an institution. However, I couldn't find my company's name listed, and this field is marked as mandatory. Could you please advise on how to proceed?

I have an open support case for this, but hoping to see a working example of add/edit/delete rows using GridPlus asap. Attached is my attempt, but I'm seeing an error (I won't share here, that's in a separate thread). I'm hoping someone can package and share a working example (they don't necessarily need to debug mine) where they can add/edit/delete rows and submit changes. [View:/cfs-file/__key/communityserver-discussions-components-files/19/create_5F00_table.sql:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/19/Fund-Operations-Sandbox-_2D00_-GridPlus-Error.zip:320:240]

Initially, I considered using deployment packages to track changes. However, I noticed that once changes are pushed from UAT to Production, the environments become synchronized. As a result, all objects appeared in the deployment package; however, the ones that were initially modified before being pushed to Production are no longer listed as 'modified.' This makes it difficult to track the specific changes made during that deployment.I'm looking for a reliable approach to maintain visibility into code changes with each deployment. Has anyone found a good solution or best practice for this scenario?

Background: I created some groups in my app and added my account to them. The app has a site that’s visible to all users, but one page within the site is only visible to specific groups. Questions: 1.When visiting this site, how can I switch between groups to test access? 2.I assume I can change my group by clicking this button (the first one in the screenshot). However, the groups I created aren’t listed here. How can I add them to this list? Additional Info: This issue occurred during the "Build an Application: Step-by-Step" hands-on practice. >When I set the visibility of the [My Task] page in the site to "Always show", I can access the [My Task] page. >But when I set its visibility to "Only visible to specific groups" (the intended setting), the [My Task] page doesn’t appear when I visit the site. Additionally, groups from other apps are shown in the button’s list, but my created groups (W1481SA Registers/Mechanics/S

Can we pass a list of numbers to input parameter of SP? Is it possible. a!storedProcedureInput( name: "group_ids", value:local!groupids (It is a list of number) ), It's not working as input parameter is defined as INT on DB side but we are passing list of integers.

I need to integrate Appian with Snowflake so that data from Snowflake can be fetched and displayed in multiple dashboards within Appian Sites. Looking for guidance on the best approach, recommended plugins, integration patterns, or configurations to achieve this.