Discussion Categories

Hi , My process was getting errored out at Parse XLSX file node saying  Error: An error occurred while evaluating expression: Output:rule!s_CRDoc(pv!changeRequestFile_doc) (Expression evaluation error in rule 'c_doc' at function 'readexcelsheetpaging' [line 8]: com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.) (Data Outputs)

So I have an interface that is saving two array of CDTs the idea I was having is that it would store each iteration of the array into its own respective row for the array example: {[uuid:1, fkuuid: ab32, date: today], [uuid:2, fkuuid: cd43, date: tomorrow]}. In the database there would be a row for UUID 1 and a row for UUID 2 but when I execute the write to data store entry I only get uuid 1. To push this even further I am doing this two times for separate tables and its only putting 1 entry into 1 table.  If there is any more information that is needed let me know! Any Ideas on how to get it to save all the information in the array of cdt to each of its separate rows?

When should we re-deploy an application vs. using a patch?

I am trying to connect the target vehicle.vehiclelastmodifiedby but its not listed as an option. Where do I go to fix this issue?

Hi, Is there a function available to retrieve only direct members from a group. The a!groupMembers function returns both direct and rule based members when "direct=true" is passed, but I am looking for a way to specifically obtain just direct members. Thank you 

I have used validation while creating a new entry in the grid which shows a message in case of duplicacy in entered field. But when I use the same validation in the update related action , it shows the duplicacy message  as soon as we click on update, even before actually updating it. How to resolve this? I want validation to occur when i enter the data, not when I it automatically loads the data

Dear All, Can anyone please tell me how to create connected system for active directory, because there is no template for active directory in Appian. Thanks in advance!

I am trying to create nested CDT . As part of that one of the CDT needs to be created multiple times. I tried to use forEach in type! but it's throwing me below error.  Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!localVariables parameter 2 [line 7]: Keyword and non-keyword arguments must not be mixed. Used in: {urn:uk:aviva:appian:eow:createdocumentstoreanddistribute}EOW_coverLetterDetails.. Please find below code for reference, -- a!localVariables( local!customerNomineeDetails: {{Forename:"name1",Surname:"surname1",PercentageAmount:"45"}, {Forename:"name2",Surname:"surname2",PercentageAmount:"40"}, {Forename:"name3",Surname:"surname3",PercentageAmount:"45"} }, local!requestBody: 'type!{urn:uk:aviva:appian:eow:createdocumentstoreanddistribute}EOW_coverLetterDetails'( xcdBeneficiariesIndicator: "N", xcdCOBSchemeName: &quot

In IDP home page we cant find tasks metrics and configure options.

Hello All, Is there an order of objects to deploy. I have environmental constants also. My prod deployment is still manual. Eg: 1.SQL scripts to be executed first. 2. CDTs 3. Datastores. 4. Constants 5. Connected systems.. ..etc

Hi everyone! [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] and I will be going live at 11:00AM Eastern to talk all thing Appian Records while building an app using the PokéAPI! Join us live to build with us and ask all your burning Records questions. Here is the see attachmentApp Information Packet that will provide you information on getting set up to build along with us and give you ideas for additional functionality you can build out. We can also use this thread as a "show & tell" if anyone would like to share what they've built!

I've been experiencing this since a couple hours. every time i submit a user input task in one process model it throws this error even though the  process model  that is giving me this error hasn't  been  modified since yesterday   and everything was working fine. 

is there any way to apply tool tip in rich text item.

Hi, I have a readonly grid and loading the data using RecordType.  When select any row selected, I am storing into a local variable of specific type. When I try to load the value of firstname like below, it was not loading any thing into the textfield. Can someone advise what went wrong.

once submit button is clicked .. a diologue box /pop box should open iwth cancel and submit button  ..  consist of dropdown "Yes " "NO"if user selects yes then user picker field should open ,, So how shud i achieve this in appian.. through record action or some other way ?

can we show any icon after label ... with caption

Hi Experts, Looking forward for your help. We have created a process model where we are running two process flows simultaneously using "AND" Gateway and we want our last node to be executed only once. But the problem we are facing here is that the last node is executing twice due to the "AND" Gateway. Is there any alternative solution so that the last node will be executed only once along with the "AND" Gateway? Thanks

Hi, I'm getting error message from Record Type object. Not enough disk space to complete sync. https://docs.appian.com/suite/help/22.2/Records_Monitoring_Details.html What should I do to fix this problem?

Hi Team, How do we filter the query entity with datetime (2023-01-13 14:03:59) like how we filter a string. Can anyone please tell how can we filter the entity with one specific datetime value? Eg: a!queryFilter( field: "value", operator: "=", value: "test" ),

Hi Everyone, Can anyone please help me how can I open different record views through record link function based on input params in interface. Thank you

Hello, I have a record type with n number of values. The serial number is also saved. For eg, there is an editable grid. with the serial number as 1,2,3,4. Now i can delete any row and hence the serial number should get updated.   How to do this in saveinto of that delete button? I tried using foreach, but im doing some syntax error. Can you tell me any alternative?

Hi,  I have Process Model with user Input Task, I am assigning task For Task Approver if that task Approver Not Approve that task In 24 hours, that task was automatically Approved After 24 Hours. How I can  achieve this  Thanks  Prashanth  

HI , I have a jira integration requirement and need to call jira from appian  to create epic,story and read few data from jira. To handle integration errors and maintaining each jira int call before and after maintaining the logging in DB. Instead of having  the error handling and logging in each of every process model , thinking to have a common routing process based on dynamic parameter  it should that process  and  since error handling and logging db and email notifications are in common process no need to have in sub process alone. with this redundant code is reduced and can be used for any other workflow later since it is a common component. what is the best approach for this  Thanks Soujanya

Hello, I'm working right now on increase the performance of my project and I'm been searching what could I do, in the academy the suggestions are, to replace subprocess for Startprocess etc. Well, I have a few question that I could testing but i want to hear if anyone has this answers. 1: in a process model, if I put 3 script task with diferent action, does anyone knows if its better to put all in 1 script or is the same?  2: which is faster, put multiple nodes of smart service to Write no DSE or put 1 of Write to multipleDatastore? 3: I have seen multiple flows that do not need to wait for the previous node, is it viable to use the "AND" GATEWAY to execute multiple nodes at the same time and this shorten the time or has that affect the performance of the process?

Hi Guys,       I had some react Ui application I want to use it in the Appian interface how can I do that? without custom plugin is there any anyway? Many thanks in advance