Process Automation

Hi All, My requirement is to read the excel sheet data and to write it into Database table from Appian. The excel sheet contains some dateTime columns. But when we read the excel sheet in Appian, it considers all the columns as text, so I am getting the dateTime as below format when I read the excel, example 1: "2024-01-31 09:14:36" example 1: "2024-05-28 15:14:36" But I have created  columns with dateTime datatype in CDT/table, so please help me to convert the above dateTime text to dateTime as below formats, output 1: 1/31/2024 9:14 AM output 2: 5/28/2024 3:14 PM Thanks in Advance!

Hello All, My use case is using ai-knowledge-assistant(community.appian.com/.../ai-knowledge-assistant), chatbot will ask question sequentially like ai-knowledge-assistant: Hello! I am your assistance. How can I help you? Human :I want to register one student in the school. ai-knowledge-assistant:sure! what is the name of the student? Human : Arka ai-knowledge-assistant:what is his previous school name? Human: Abc ai-knowledge-assistant: Please upload the school results <Upload button> Human:<human uploads the document> ai-knowledge-assistant: Please review the below information  Student Name : Arka Previous school: Abc School result Please confirm  Human: I confirmed <system creates an entry in the student record > Now my question are  1. Is it possible to show the question sequentially ? 2. Is it possible to have a button to upload a document and save it  document folder? 3. Is it possible to trigger the process model after user says li

Hi Team, We are Aware of all the Robot Status but whenever we execute a bot its going in enqueue mode. The data process successfully but we are not getting data in variables because of enqueue status of bot.  We are using these variable but getting empty value because of which its going into failure. Also we are not able to deleted the enqueue record from robot dashboard. Can someone please help here why its happening .

Hi, As per appian 24.1 documentation, I was looking for Ai Skills for - "Prompt Builder" option. I have checked and verified that I have 24.1 Appian version and when I select "AI Skills" then I can only 3 options as 1. Document Classification. 2. Documentation Extraction 3.Email Classification. Can someone please help me that why I am not able to see that 4th Option for Prompt Builder? Also, I am looking for some example to create a prompt lib for the use case we are looking into. Thanks in advance.

[ERROR] 2024-03-15 06:55:01 01m 01s (0h) - Error executing action [exceljacob->open-create-workbook]Invoke of: OpenSource: Microsoft ExcelDescription: Open method of Workbooks class failedHi, i am getting this above error when i am trying to open XLSB workbook through Appian RPA and for this i'm using "Open Workbook(license required)" component.

Hi Everyone, I am trying to connect Appian 22.4 with Uipath 22 but getting below Error When I use the same credential with Uipath, I was able to login in uipath orchestrator I tried changing the Url as well but same issue. Can someone please help here 

Hi, How to extract data from email using Email Classification AI, I have created Email Classification AI Skill , and provided some sample emails , on using the "Classify Emails smart service" its only returns some prediction of the email type.  Can anyone please help to guide what to do with the prediction of the email type, as I was looking more towards extracting the data from email using AI ML Email Classification. Same goes for Document Classification AI Skill, basically I want to understand what is the practical use of it? Thanks Bihitak

rule!Is primenumber{} how to implement it correctly when I want to get it in a specific range ?

I am just playing around. I have AI skill configured with matching PDF field data. It was successfully reconciled and saved data in CDT when i have less than 5 fields under 5 min. I tried to have 10 fields straight, no table type/structure, however it failed with "Document Extraction Failed." looks like timeout. It took more than 5 min even to through this error. What could have gone wrong? Any inputs helpful? Doc i am trying to extract from..

Hi, I need help with Appian queryFilter, I have found a strange behavior that I would like to consult you.When I filter for a record that is boolean true, it returns false values, what can I be doing wrong? Here are two different examples with a!queryRecordType() Thanks in advance, Hector

I am working on a related action and while working on a related action I don't want anyone to work on that related action so how to implement this scenario?

Hi Appian folks, I want to capture the screenshot from a running video and later send it to API. How can I capture it from a video using RPA modules? I tried doing this with Windows Automation modules. I captured a screenshot by "Send Screenshot" module. How can I get the screenshot from execution log to Appian?

I have a requirement where I need to send an Image ID using users data(his profile pic in Appian) through an API. (plz don't question the reason)user(), document() and some other image related functions were unhelpful.There are components that can be used to get the image and display it such as userImage, but its useless to me in an expression(rule).I also looked up discussions.. nothing for this specific case.Another note: a process is involved, so smart services can be used(I don't know if there is one to help in this case) any suggestions?extra:wataheck is this? this gibberish happened when I added ('), and it stayed that way

Hi everyone, just wondering why the string is not being typecasted to both user and group and being checked which one is valid since the type is userOrGroup?

What does the below warning mean in AI skills document extraction? Files with pages with too many tokens These files contained pages with too many tokens (token limit: 512) for the model to process. Labeled entities on these pages may not be included in training if they fall beyond the token limit.

Hi, I am currently receiving an error when trying to convert free text from a paragraph into an html, simply because the single apostrophe (') does not convert to a special character when trying to create html formats used to create a microsoft document and convert it to pdf. The document either shows the escape character of ' or we receive an exception error in the process model. I am using the smart service Configure DocX From Dynamic Template. I have been using the toHtml() function to convert all text into html format, but only receive this error for sing apostrophes. Any help would be useful. Thank you.

Is there any way to get the latitude and longitude details based on the given location?

Hi All, We are trying to build new RPA use case to open browser and download file and bringing back to Appian. Earlier the robitc task was working fine with below browser and driver versions.  Browser: Chrome  (121.0.6167.161) Driver Version: 121.0.6167.85 After the chrome got upgraded the robotic task is not able to launch brower with the below browser & driver version:  Browser: Chrome  (121.0.6167.185) Driver Version: 121.0.6167.184 Robotic task is failing with below error: [INFO] 2024-02-21 05:23:03 03s (0h) - Browser version: 121.0.6167.185, Driver version: 121.0.6167.184[INFO] 2024-02-21 05:23:03 03s (0h) - WebDriver file is out of date. Attempting to auto resolve it from the console...[INFO] 2024-02-21 05:23:06 07s (0h) - Successfully auto resolved webDriver from RPA console[DEBUG] 2024-02-21 05:23:06 07s (0h) - Using default module Chrome options[WARN] 2024-02-21 05:23:09 10s (0h) - Driver could not be initialized: session not created: Ch

Hi team Here is my use case: Duplicate an app that exists in one schema to a different schema (for data separation) Recreate every object in the SAM app in the SAL app In creating the SAL schema, convert all instances of a!queryEntity() to a!queryRecordType() Temporarily leave the SAM app in place so I can compare SAL functionality against SAM functionality Completed so far: Created the new schema (SAL) Set up the new synchronised record types Duplicated or created every object that exists in SAM into SAL Ensured the SAL site has the same layout as the SAM site Questions I need answers for: Is there a way to do a bulk find and replace to change all references in every expression from SAM to SAL, or do I have to manually update each individual expression? I get a warning that type SAL does not exist every time I try to change 'type!{urn:com:appian:types:SAM}SAM_SoftwareOnboardingCase' Is there a standardised way to convert an a!queryEntity() expression to an a!queryRec

In a PM, getting the below error, how can I resolve this?

Hi I am trying to remove space Infront of 9 as shown in below image  I tried with trim but still the space is coming < can anyone help me with this?Attached my code in this message a!localVariables( local!allocatedLoads: rule!PLSB_QR_queryAllocatedLoadsForDashboard(allocatedId: 2058), local!vin:trim(local!allocatedLoads['recordType!{e48e7749-5c4f-4ece-89a1-1f096042fbc5}PLSB Allocated Loads.fields.{e79eb6a6-7005-42cb-ae7e-72dcb80c9d34}vinNo'][1]), local!vin )

Hi  In below query rule i am passing 2 and 3 product ids so it was returning both 2 and 3 product id's email id's but i want 2 product  id email ids in one list and 3 product id email ids separately means like two list of usernames separately could you please suggest on this 

Hello everyone! Is there a way to get rid of empty lists? I attempted to use `reject(a!isNullorEmpty, RESULT)`, but I encountered the following error: (Image 2). Image 2

Hi All, Please help me out in understanding this error . Error message: Internal Error

We are trying to compare to one intake value with data that is coming from another system. Both these values are present in pv and we are using contains function inside a script task to check the same. But even though the value is present in array, its giving false.  Array value Single valueBoth are of same data types but still giving false. contains(arrayValue, singleValue) is the function being used inside a script task. Let us know if we are doing something wrong here.