Discussion Categories

Hi Team, I have a csv in which I am receiving "11 May 2021 07:08:12 GMT" as text in one of the columns, Is there anyway to cast  to Appian datetime type Regards Bihitak

I have a dropdown on an Create record action interface that utilizes a related table for its values. On the Update record action interface I need to have the same dropdown in case it needs to be updated, however I need it to retain the selection that was made when the record was added. I am struggling to setup that connection on the Update interface.

we recently implemented a process to read emails from an outlook inbox using the MSGraph email poller detailed here: https://community.appian.com/b/appmarket/posts/msgraph-email-poller after implementing we're seeing severe performance issues where the poller is only able to process one email per minute. the emails have a 1mb attachment, and per the documentation, we are expecting 30-50 emails per minutes at the very least. does anyone have any insights they can share to get around this performance issue?  thanks!

Buenos días. Mi pregunta es: ¿Durante el examen de certificación es posible traducir con google translate? Gracias.

Hi, We are trying to generate a CSV file from CDT and the first heading on the file starts with @ symbol. Now when I open the file in a text editor Appian/plugin adds some extra characters to it. How do I get around this? Example --  the file generated in Appian -  "'@ENB"NE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 The output we are expecting - @ENBNE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 Also, we don't want any space in front.

Where can we find the slide decks and other content from Appian world 2023? I attended Charle's Tsui's UX session and would like to reference those slides. 

Hi all,  I have this issue: i want to select somehow a specified row in a!griedfield component, like ID 24 in the picture below, then start a process with some value taken from that row, with a submit buttom or something similar that can appear when the specified row is selected. Is it possible to achieve this goal? This is a screenshot of my site in which the element of the only read grid are taken from a recordtype, so this is why the ID is coloured in blue.  Thank you in advance for the responces. 

Hi All, I am new to Appian, during one of my solution development I have found that I have deleted the rows from the oracle table and when I am trying to test the expression rule where I used Query Generator to get the data from that table , it's stil returning the old data. So can you please help me to know that how can I clear some cache or sync it with my tables ? I am using query generator to generate that expression rule.

Hi, how to read mails from gmail using Appian BPM using smart services?

I am working on "Interfaces 103" in the lowcode4all curriculum. I made a mistake and deleted the PF_Goals Record Actions - Delete Goals and Update Goals. Now I am unable to generate any record actions. Please advise me on what to do next in order to continue building the interface.

Hey, I am trying to configure a Picker Custom Field but am getting the following error: "Interface Definition: Expression evaluation error at function a!pickerFieldCustom [line 290]: The function 'suggestfunction' is unavailable." Here is my code: a!pickerFieldCustom(  label: "User Picker",  placeholder: "--- Select Borrowers ---",  labelPosition: "ABOVE",   suggestFunction: a!dataSubset(    startIndex: 1,    batchSize: -1,    data: if(      local!view = "Borrower",      index(local!borrowers,"borrower",{}),      index(local!lenders,"lender",{})  )  ),  value: if(    local!view = "Borrower",    local!selectedBorrowers,    local!selectedLenders  ),  selectedLabels: if(    local!view = "Borrower",    local!selectedBorro

Hi All, Kindly help me I want to use Email in the process model . Like example I am using any smart service (like write to data store entity) then this nodes fails . if the node fails than I want to send email through using email service in the process rather than the group alert or any name mention in alert. And How to configure it? Thanks 

Hi, I have been using the Deprecated Export SQL to Excel Smart Service for a document download functionality. When the process model is initiated back to back like twice, or randomly out of nowhere with even the first try, the smart service gives this error and the process model fails: "The following error was raised by the Export to Excel function: ORA-01843: not a valid month".  I did an analysis on the SQL code, it works on the database and I believe it should be fine. In the SQL code, I have to_date function and I am comparing two dates with different formats such as MM/DD/yyyy and yyyyMMdd. I am wondering if anyone else is facing a similar issue and what would be the possible solution?

Hi Is there a way to sync all records within an application? Thanks

I am getting the error some time page is opening it is getting reloaded after 3-4 sec and showing this error.

Home Page displayed with following error message  An Error Has OccurredCould not find "store" in either the context or props of "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Either wrap the root component in a <Provider>, or explicitly pass "store" as a prop to "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Expected:Application Should free from expression errors

HI team, iam using Zoom connected system community.appian.com/.../zoom-connected-system How we get the recordings by giving Meeting id for locally saved? i have recorded a meeting and save it into local folder.so i know that cannot fetch the local files. but to get the recordings where should i save the recordings can anyone help me to get recordings. Thanks & Regards, J Vinay

I'm updating my database table using the "Write to Data Store Entity" I have an array of uploadId's that are my primary key. When writing to the DSE, I'm passing additional information like the current time now() and some other text values.  In the error (see image below) you can clearly see that the first uploadId (10473) is passed with the additional information. However on the 2nd iteration (uploadId 10474) all of the additional values are null. How do I pass multiple values using this smart service?   Thanks!

Hi, is there any way we could start the process model with start form and pass some input parameters from external URL. We have a request where we will have to search some customers in external system, and pass the related customerId to appian process model which should open a start form. So the similar behavior as appian actions, but being called by using URL in external system and being able to pass some parameters to a start form which should be displayed on a link click. For example, we have to search for a customer in external system. When we find a customer we need, we have to start an appian process for that particular customer only by clicking the http link in external system. Another requirement is to avoid starting the process instance if start form for particular customer is not submitted. So, for example, we find a customer with custId=1 in external system, we would like to generate some URL like http://appian.host/start_process/processModelId=2&custId=1&

Is it possible to send email during start date and end date  ,an Api call will be triggered during start date and it gets  ends at end date . So when the  start date arrives Api call be triggered during which i need email to be sent  and vice versa ( when Api call ends at end date another email needs to be sent )

Hi All, We have a requirement to start appian process automatically when a outlook mailbox recieves emails with body and attachemnt. Then we have to consume the body and attachment in Appian process to process it further. We tried to look into : https://docs.appian.com/suite/help/23.1/Sending_an_Email_Message_to_a_Process.html#starting-a-process-using-an-email But it seems it requires extensive configuration at server level to enable polling icluding setup of routing server like Apache James. Wanted to enquire if there is any solution available which doesn't require server level configuration. Regards, Soumyasish Dutta

Hi all, I'm exploring OpenID Connect to use as a SSO. I'm following these links for set up https://docs.appian.com/suite/help/23.1/OpenID_Connect_User_Authentication.html and https://tony-marziano.medium.com/walkthrough-google-openid-connection-with-appian-23-1-a397b67611e4 In the field for Authentication Group, I obviously need to specify an existing group object. My question, do I first need to create a new application, ie: OIDC, and in that application create the group? Or is there some other location for that group to reside? Many thanks,Uel.

Hi all! We need to send an email with a link that allows users to directly access the download of the documents (after authenticating in the application). instead of sending them as attachments. We have found the following discussion Appian Community and we have developed like this. We have included in our HTML template:       <a href="https://your environment/suite/doc/###docid###?appian_environment=designer">Download Document</a> and it worked. The problem is when we have moved to another environment. We have just updated the name of the environment:       <a href="https://new environment/suite/doc/###docid###?appian_environment=designer">Download Document</a> And now its not working, we got the following error:  Application Error We're sorry! We could not process your last request. There are no details available for this problem. If you continue having problems, please cont

I need to allow the user to enter a comment in an interface.  This comment might be 200-500 characters long and might contain line breaks (CR or CRLF). The a!textField allows for the character limitation, but not for multi-line display, wrapping long lines, including line breaks.   Is there a control that provides multi-line text input?  (Like this 'description' field I'm using to enter this community post.) Thank you.