New to Appian

I am an trying to verify column type of each row in excel sheet against an array having type numbers TESTCASES: test1:{"1","abc"}  passes  test2:{"abc","abc"} also passes which should actually fail .Please let me know where it went wrong code used ,  local!error:a!forEach( items:index(ri!data,"values"), expression:{ a!localVariables( local!rowNumber:fv!index, a!forEach( items: fv!item, expression:{ if(a!isNotNullOrEmpty(fv!item), if(typeof(cast(local!types[fv!index],fv!item))=local!types[fv!index],{},"Type does not match at Row"&local!rowNumber&" and column"& fv!index), {} ) } ) ) } ),

hi,  i have a local variable  local!test:{"test1","test2","test3"}, - this shows as List of String  I am trying to create a constant for this , selected as Text ( Array), - This shows as Text how to convert the constant as List of String , because I am actually validating against another variable that is of type - List of String.   

hi,  I am trying to upload a excel sheet and extract the values from the sheet, Would some one give an idea on  how to access each columns to find if its not null and of type "Text" . I am new to this implementation. I am able to write an expression to fetch all rows including the header.  Any help is appreciated.

I accidently delete the current version of a PM but dont't load & save the last published version again of the same PM. So if this PM is referrred in a constant & that constant is used in some Start Process nodes. So in this case does this start process node is having issue to start because of this below mentioned issue.

Hi Everyone, If the user is assigned more than 1000 tasks and if his account gets deactivated and he left. How can we reassign to those assigned tasks or what will happen to those tasks.

Hi All, I am facing a weird issue. I have removed myself from the group and is not part of whether direct or indirect. When I execute isUserMemberOfGroup function, it gives true. Can anyone please help me out.

I am facing the issue while trying to get the below mentioned logic through subtractdays() function. logic: we need the value i.e. current date - 74 days used expression:  subtractdays(today(), 74) error found:

I have followed the document as described but getting the following error when running in debug mode: Even the sample application provided has the same issue. My Interface is configured as follows: Up to this exercise everything seems to have worked as expected. I tried changing the rule input in the interface to Vehicle which resulted in a lot more error messages. I deleted the process model and generated a new "Create" process model automatically. Any help to get working would be greatly appreciated.

I have a scenario. I have a parent folder ID and inside the parent folder there is may folder. And inside the folder there is many sub folder. Now I have to find out a specific subfolder ID withe help of  parent folder ID. Please suggest. Thanks!

Hi Appian community, I'm an IBM BAW developer in Egypt considering a switch to Appian for remote work opportunities keep in mind there's no local market for appian in egypt at all. Quick questions: Can non-US/UK citizens find remote Appian jobs with US/UK companies? What are the key requirements for international candidates? Is learning Appian worthwhile for remote work, given no local market? Any tips to stand out as an international candidate?

Hi All, There is requirement in my project where i need to create a process where i can send or move all existing documents  which is save in  a  particular folder and i have to move those documents into google drive. As i am a new in appian i don't have much idea for this , can any one help me or give some ideas how can i achieve this and what objects will require for the same. Will use any API or anything else to achieve this.

Hi all, I have a list and the count of this list is 15 once i try to use count isn't return 15 it returns 1 also I tried to use a!flatten but the same issues  any advice ?

Suppose I have an existing application with prefix `ABC`. The application contains multiple objects, whose names start with `ABC_` according to Appian's naming convention. Suppose now that I want to edit the application's prefix to `ABC123`(for instance in Appian Designer, by clicking the 3-dot button next to the application name, and selecting properties). Is there a way to automatically update the prefix of all application objects?

I'm stucking on Wyndhamm Power Portal Excercise.Does anyone know how to resolve this? When I enter the expression on page 6 as instructed, an error message appears and cannot proceed. error:Expression evaluation error: Syntax error. Details: Expression evaluation error : Invalid double value 0000e /resized-image/__size/640x480/__key/communityserver-discussions-components-files/62/_3B75CF50_1.png_2D00_640x480.png ※Added 6/11/2024 The exercise is to add lines 5~13, with the other lines retained as provided by Deployment Service Account. Expression a!localVariables( local!showReport: false, local!result, local!errorMessage, local!outage: a!refreshVariable( value: 'recordType!{29c13db8-6b5d-406d-8f11-bc4adec59e00-w2175wpo}W2175WPO Power Outage' ( 'recordType!{29c13db8-6b5d-406d-8f11-bc4adec59e00-w2175wpo}W2175WPO Power Outage.fields.{e7052282-96ec-417d-9e15-d06a4b84b7c3-w2175wpo}street': null, 'recordType!{29c13db8-6b5d-406d-8f11-bc4adec59e00-w2175wpo}W2175WPO Power

Hi Team, I am facing below error while deploying interface which has record type as a precedent. I have recently added 2 columns in record type and deployed it to other environment for the first time deployment went successfully with interface any record type later I made small change in the interface then I am unable to deploy the interface even though I have added record type to avoid the missing precedent issue. ERROR content _a-0000e6f8-8866-8000-9bc2-011c48011c48_1560555 102914 The content [id=102914 uuid=_a-0000e6f8-8866-8000-9bc2-011c48011c48_1560555] was not imported because a required precedent is missing: recordField [uuid=AFPFVisit location=Interface Definition] in record type [id=22 uuid=928b33df-26a0-46a4-8de9-540217145302] cannot be found. (APNX-1-4070-005) (APNX-1-4071-006) Kindly help me if you have any solution. Regards, Sireesha

hola que tal? estoy trenizando un problema al crear un campo de registro y es que me dice error al mometo de poner este código: a!match(value: rv!record[SPX Launch.success],equals: true,then: "Success",equals: false,then: "Failure",default: "Upcoming")... estoy aprendiendo así que lo copie del curso que estoy haciendo de aquí pero me dice error y la verdad no se como solucionarlo, alguien sabe?

Hi All, I have created an Interface and it has card layout , when clicking  on the link, the related interfaces having those graphs will get displayed. In goals interface above progress bar, there is New Goal button, upon clicking that a form layout will get displayed, A form layout gets populated , It will get filled based on the validations once this is done, I tried to click the create button , so that new goal will get displayed in the goals interface. As of now, I am unable to proceed further, atleast it should throw some exception, i will try to trace out the issue, I am unable to proceed further. I have provided the code for create button . may i know what could be the issue, is there a chance in Appian that error will not get displayed and it will not proceed as well. Here is the code snippet part of the button: a!buttonArrayLayout( buttons: a!buttonWidget( label: "Continue", value: local!currentFormStep + 1, saveInto: local!currentFormStep, style: &quot

Hi, I am getting this error ( The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete ) on DOCX From Dynamic Template node of my process model. In this process we are combining / merging multiple DOCX files to one.   Please help me with it.

Hi All, i have a query related to logical expression  as you can see their is a logic mentioned in below code which is i am using in a database table but now i need to use this logic in expression rule to show grid field so any one can help me to implement this logic or you can give any example we requird the filter on below case where status in('Started','Pending','Suspended','Resumed','On Going') OR ( in('Cancelled','Completed')AND ModifiedDate >= (GETDATE()-7))

I am getting this below error, while debugging Request Maintenance process model ERROR An error occurred while evaluating expression: =localize("de","","fr_CA","","ru","","sv","","pt","","ko","","el","","fr_CH","","it","","fr_FR","","iw","","es","","ar","","zh_HK","","en_GB","","th","","en_US",tostring("Request Maintenance for Vehicle: "pv!maintenance['recordType!{b5aaf6ce-8d6c-4517-b332-68ba3a0c3655}W003SA Maintenance.relationships.{6b611f24-010d-41e4-a738-f889ab7c2bea}vehicle.fields.{fc426423-e013-40d4-b3a3-505e88858e0d}vin']),"ja","","es_MX","","zh_CN","","pl","","t

I want search all records with not matching two keyword (CLOS & CANS) like: 1. ADVG XCLT QRPR 2. ADVG CLOS QRPR 3. ADVG CLOS CANS 4. ADVG PQRS QRPR from the 4 rows I want to display first and last rows. Rows having two word like CLOS and CANS shall not be display. So, I want to know which keyword I shall use in query function. Not Includes function work only on keyword. But this query have more than one keyword. Please advice.

Hi When I am trying to deploy a record type from Dev environment to Test environment I am getting below error as shown in below image.  Can anyone help please Regards Kumar

I'm doing the step-by-step guide for appian developer where we're recreating the Acme Automobile example application and I encountered an error when trying to display the vehicle images in the grid. I followed all the points in the step by step guide exactly and the error I keep encountering is the following: Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 5]: User Does Not Have Rights to Perform this Operation The expression I'm using to display the image is the following:  if( a!isNullOrEmpty( fv!row[recordType!W#SA Vehicle.fields.image] ), a!EXAMPLE_DOCUMENT_IMAGE(), fv!row[recordType!W#SA Vehicle.fields.image] ) where the W#SA is only a placeholder and I have replaced it with my own prefix of course (references work). If anyone has any suggestions or gu

Hi all, I'm new to low code platforms. I've written an application (a statistical model) in Javascript. I want to develop some additional components in a low code platform such as some basic screens with a user interface and a database which will store the data to be sent to the model. The plan is to commercialise the model so we will also need to have controls over user access, billing functionality etc. I would appreciate any feedback as to whether Appian is a good platform for doing this, and/or whether there are any other recommendations. Thank you for your help.

How to test expression rules with rule inputs having more than 4000 characters?