Process Automation

Can any on help me for "how to sort the text field integer values", example i have field name: data it is text field but in that field values are stored 10,000 and 80,000 and 20,000 so i want to sort those values if anyone know can you please help me with it?

Is there a way to capture screenshot as part of BOT processing and save it to Appian documents folder?

Hi All, I have numbers between 100-200 and I want to display the 5 multiples and 5 included numbers. Sample output: 105,110,115,120,125,130,135,140,145,150,151,153,154,155,156,157,158,159,160,165,170,175,180,185,190,195,200

In DB I have some records with only Date and some records with date& time Example: 2/1/2023 1:22:31 PM 10/17/2023 11/15/2023 7/07/2022 6/17/2022  2:22:32 AM 11/17/2022 9/28/2022 9/28/2022 i need to filter it out with only date but where ever time records available those records unable to filter it out a!queryFilter(field: "date",operator: "=",value: ri!date) can someone help me with this

Hi All, I have an external report where i will be pulling data into Appian. When am storing fields into Appian i could see space is replaced with "non breaking space". for ex: IN Appian DB: In External report: Can anyone suggest why this is happening ?

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

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18}Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

I need to setup an intergration between UiPath and Appian, and have learned that by using the "Appian Activities" utility and "UiPath Connector" plug-in, the connection between the two could be done. Meanwhile, I also notice that when searching related information through Appian Document, UiPath seem to be associated with RWM to some extent. I would like to confirm that whether I need a RWM in order to finish the setup. Does anyone have any idea about how RWM function within the process indicated as the picture above.

I'm currently trying to implement RPA to get the title, URL, etc. of each news from the news list on the news site.My RPA was able to get the information I wanted and store it in an array.However, the information cannot be saved in Appian's DB in table format. I would like to store the contents of the array that holds the acquired information in the pre-created CTD. Since the Appian document states that it is not possible to directly store data from RPA to the DB, I will implement RPA which creates a list of data saved by CDT etc. and returned this list to the process model. If you have better idea, could you tell me about it?

Given a dictionary D , and a list of nodes N, I need to replace all existing nodes in the dictionary which are single value to list of values containing the single one. For example:   D= {foo:"bar",bar:"baz"}, N={"foo"} => {foo:{"bar"} /*converted*/,bar:"baz"/*no change*/}    D={bar:"baz",foo:{"multi","items"},nested:{foo:"bar"}}, N={"foo","bar"} => {bar:{"baz"} /*converted*/,foo:{"multi","items"}/*no change*/ ,nested:{foo:{"bar"} /*converted*/} The use case is to support conversion from XML where certain nodes should be arrays, however when converting from XML to JSON and there is  a single item under those nodes, we need it to be array and not a single object. 

Hello All,  I am seeing below error when I am querying data from database. in the database nonInvoicePayments is defined as Tinyint(4) and in the rule input for this variable is defined as Boolean.   Please suggest me the solution. Error message: expression evaluation error at function a!queryEntity [line 3]: Cannot apply operator [EQUALS] to field [nonInvoicePayments] when comparing to value [TypedValue[it=26,v=1]]. Thanks in advance.

Can we have regexmatch code for this scenario : I have   4 digits in text format but last  2 digits should be fixed EX:"XX30" here "30" is fixed "XX" can be any numbers in text format

Hi, Any idea how to find the third largest value using a!queryentity?

I am facing an issue with my RPA code. I have automated a process for data entry into an internal database, but it seems that the bots are not able to handle exceptions or errors that may occur during the process. This is causing the automation to fail and manual intervention is required, defeating the purpose of using RPA in the first place. I read this article to get more understanding and tried debugging the code, but I am not able to identify the root cause of the issue. Here's a sample of the code that's causing the problem: bot.click("submit_button") result = bot.get_text("status_message") if result == "Success": bot.click("continue_button") else: # What should I do here to handle exceptions or errors? ```"

how can i sort an Array?

Hi Team, I am trying to convert html code in my email template to dynamic so i can loop some values using expression rule but i facing some issue in syntax , Looking for the help below is the html code <!DOCTYPE html><html><body><head> <link rel="stylesheet" href="styles.css"></head> <h2>###bodytext###</h2> <br><br><h2>Please click on any below link to submit you response</h2> <a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Complete</a><br></br><a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Cancel</a> <br><br&g

Hi  I have scenario to create a chat bot in my application can any one help me how to do this?

Hi ,   I want to know what the relevant links or the paths and the topics which are priority for the preparation of RPA +IDP Badge. Also want to know the percentage that need to be achieved in order to get the Badge.

Hi All, I have this cast function  cast( 'type!{urn:com:appian:types:TLT}TLT_VEHICLEDETAIL?list', ri!data ) and I'd like to change TLT_VEHICLEDETAIL with a dynamic input using ri!inType. I thought to fix this problem with concat function ex.  but it doesn't work. and my result was this one    who can help me?

Hi team, I was following the document  https://academy.appian.com/#/online-courses/fc14c3d1-0eb3-4d9d-8ae2-fc0149ae7585 asking me to select Template from the toolbar and then select 'Import Template' but I do not find the import template icon on my community edition.  I can just see the default ones.. When I see the Appian documentation at https://docs.appian.com/suite/help/22.3/rpa-8.5/templates/rpa-templates.html I can see the import template icon on the top right in the doc. Can someone pls help is it just me or do I need to update something somewhere to get the import template icon ?? for now while I wait I have raised this to support team as well thanks jaideep

Background: Using integrations I have called several endpoints and pulled the data into a map with nested maps.  I now need to move values from the nested map to the parent, as they are all 1:1 relations. a!localVariables( local!CDT: a!map(id: 1, name: "Walt Disney", demographics: a!map(age: 73, gender: "M")), local!CDT) This returns:  Map id1(Number (Integer)) name"Walt Disney"(Text) demographicsMap age73(Number (Integer)) gender"M"(Text) what I am in the need of is: a!map(id: 1, name: "Walt Disney", Age: 73, gender: "M")

Hello good evening, I need help, well, it turns out that I have a problem, for example, when I want to omit certain special characters, I use substitute, all fine for example if I only want to omit the symbol "&", but when I put another symbol, for example "%", instead of replacing it, I get a blank space, I have already used substitute, stripwith, a regex, and I can not find a solution, I attach my code. a!localVariables( local!subs:substitute(ri!name," & "," "), local!formatB: cleanwith( local!subs, cons!GT_CONS_Clean /*1234567890qwertyuiopñáéÃ%ADóúÃ%81ÉÃ%8DÓÚQWERTYUIOPasdfghjklASDFGHJKLzxcvbnm-ZXCVBNMÑ_ */ ), if( length( local!formatB ) = 0, "attach", local!formatB ) ) I have already tried these functions and I can't get that.  regexreplaceall("\s\W", local!sub, "_") stripwith(ri!name," &#$%&/|¡? ") For example, when I try to test this string, instead

Hi Experts, I have a requirement where we have to get the input from user for the time fields, User want the time to be entered in HH:MM:SS in 24hrs format where SS is optional. Below are the input with expected stored output Input1: 23:55:55      Output: 23:55:55 Input2: 10:32           Output: 10:32:00 Input3: 23                Output  23:00:00 Input4: 231000        Output: 23:10:00 Input5: 2359            Output: 23:59:00 Input6: 23               Output: 23:00:00 Kindly suggest for the feasibility of such expression as how can we achieve this.

Hi there, could anyone let me know what's the problem here, in the following expression rule, if the condition is meeting, it will return the records which meet the condition, if there are no records meet the condition, I just want to return 0 item, but here it returns 2 "0 items". replacing "{}" with null does not work either. what I should do? regards Lin