Process Automation

Dear Sir/Madam, I'm a newcomer with Appian RPA. And I'm trying to build a very simple process with steps for studying like this: Open a Google Chrome -> Search a keyword ex: 'World Cup' -> Then click a hyperlink or something like that. I have tried to find a document that similar guided end-to-end steps but not found so far. Could anyone have or suggest me anything else for newcomer? Thanks so much in advance.

Hi, Can Someone help in writing a&nbsp;rule which gives me a list of users whose last login date was a year back. I wrote this rule but it is pulling users with the lastlogin date as null.&nbsp;Please correct me a!forEach( expression: if(todatetime(getuserlastlogin(fv!item)) < ri!datetime,fv!item,""), items: getdistinctusers(cons!PDS_USERS_TYPE) ) Thanks in Advance

Hi, I want to have a ri!startDate, I will use the a!isNotNull function to display some warning message if the ri!startDate is null else will retrieve the weekday(ri!startDate) but I keep encountering the error message such as&nbsp;Cannot sub incompatible operands of type Date and type Text. below here is my code for the interface a!localVariables( local!weeknum:if(a!isNotNullOrEmpty(ri!startDate),weeknum(ri!startDate),{}), local!day:if(a!isNotNullOrEmpty(ri!startDate),day(ri!startDate),{}), local!month:if(a!isNotNullOrEmpty(ri!startDate),month(ri!startDate),{}), local!year:if(a!isNotNullOrEmpty(ri!startDate),year(ri!startDate),{}), local!dayofWeek:if(ri!startDate=null(),"Please Select a Date ", weekday(ri!startDate)-1), local!startWeekDay:if(local!dayofWeek1,ri!startDate-local!dayofWeek+1,{}), local!endWeekDay:local!startWeekDay+4, local!monday:local!startWeekDay, local!tuesday:local!startWeekDay+1, local!wednesday:local!startWeekDay+2, local!thursday:local!

Hi, can anyone teach me how to retrieve the week range based on the weeknumber and year. For example, the user selects a date. I use the weeknum(ri!startDate) already retrieve the weeknumber and the year(ri!startDate), so I already have the weeknumber and the year already, how to retrieve the date range from the week number and year ? such as 11/11/2022, week number is 47 and the year is 2022,&nbsp; how to we retrieve the date range like &quot; 7/11/2022 - 11/11/2022 ? anyone can help or assist me [emoticon:c4563cd7d5574777a71c318021cbbcc8]

How can we generate a series of random numbers like 23434 56767 89789 34355 56307 Please suggest me or an example without any table connection

Hi, I have a requirement where I have to schedule a task i.e to activate RPA agent from the server on each day when server comes online, I have used task scheduler to trigger the agent but its not being stable as it is activating and deactivating the next minute, which is leading all the RPA processes to be in queued. Please update with any solution.&nbsp;

I want to roundup below result to ...upto two places like 3.13....how could i achieve that please help

Hii all, we have 3 teams in my building portal they are 1vendor , 2buyer and 3internal team and the intrnal teams have 3 other sub teams called IT1 and&nbsp; IT2 and IT3,&nbsp; normally when a vendor raised a request&nbsp; for pricing change for a product then it will goes to buyer team , he has the power to reject or accept or send it to internal teams ,&nbsp; now the 1)rule is if the&nbsp; current product price is 10% more than&nbsp;previous price then this&nbsp; should get approval from all the teams from internal teams called&nbsp;IT1 and&nbsp; IT2 and IT3 &nbsp;2) if the the&nbsp;&nbsp;current product price is 10% less than&nbsp;previous price&nbsp;then this&nbsp; should get approval from teams IT1 and IT3 only 3) if retail price is more than cost price then it will get approval from IT2 only note:&nbsp; when buyer forward the request to internal teams above mentioned actions should take place could you please&nbsp; tell me how to achieve this decision mapping and business rules i

Please share any example to write HTML code into the Expression rule&nbsp;

Is it a bug or is there some other reason why my users cannot see records in Tempo or other places when I explicitly gave them permissions in the security configurations? Is anyone else having this problem.&nbsp; I don&#39;t want to run around with expressions if the option exist to give them at least viewer permission in the security configuration.&nbsp; I have given permission on the record type, data store, site, interface ... They still cannot view the record type, even though the tab is visible in Tempo

I have created RPA process that run in an Azure VM, it only works properly while I was logged into VM, otherwise it shows blocked status in RPA console and didn&#39;t execute the RPA process correctly, How can I troubleshoot this

Hello Team, I need to extract the file extension in a string&nbsp;StoneX - Dist. Agreement -&nbsp;XX Draft 12 Dec 2021.docx. I cannot use the document function to extract the file extension&nbsp;since we have the option to delete/remove the file from repository&nbsp;and this will pop an&nbsp;error &quot;document does not exist&quot;. I&#39;m current using the function&nbsp;getcontentobjectdetailsbyid(todocument(docId)) to extract the name. Is there an easy way to extract the file using an OOTB function? Thanks &amp; Regards Girish Katti

Hi everyone, I&#39;m trying out RPA on my Windows 11 computer. I used the configurator and followed all the steps. The configurator completed successfully. https://docs.appian.com/suite/help/22.3/rpa-8.4/custom_code/configurator.html. I start the RPA agent on my computer, it shows a list of Robotic Processes (created by a colleague on his Mac). Then back in my cloud environment, my computer does show Online under Resources. Next I create a new Robotic Process, blank template, add Permission, leave everything else as default, and click Create. But straight away I get this error pop up. Any help would be appreciated :)

expression evaluation error at&nbsp; &quot;readexcelsheet&quot; readexcelsheet( excelDocument:ri!Spreadsheet, sheetNumber: 1, startRow: 2, ) ruleinput is document

In this rule i had merged two query rule to one new rule, now i want set query filters on this new rule to filter data. Thank You

Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp? I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement? Can anyone please help?

Hello everyone, &nbsp; How to display the table format in appian using expression rules?&nbsp; If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this and data is coming from database.

i have written the expression rule to show the data in table. but how to remove these semicolons from the table&nbsp;a!localVariables( local!contractData: rule!generatecontracttable( cif_int: ri!cif_int ), local!rowItemsdata: { " " & index( local!contractData.value_txt, wherecontains( 1, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 5, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 6, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 7, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & inde

I&#39;m working on a integration project where data is coming out of appian, here I have a situation Where I need to specify if data is missing In a particular field let&#39;s say &quot;name&quot; under &quot;personal details&quot; section then &quot;error type&quot; should be &quot;personal details&quot; and &quot;error details&quot; should be &quot;name&quot;. Likewise I have many fields under section &quot;personal details&quot; - for this i have created a record. Can anyone please help me to achieve this situation

Hello everyone, &nbsp; How to display the table format in appian using expression rules?&nbsp; If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this

Hello everyone, I can&#39;t find a single mention in the docs for this, so here I am - does anyone know what &#39;Orphaned&#39; means for the result of an Appian RPA process? The process was a longer running one (looping over several pages to pull data out) In the Robotic Processes tab of the Appian RPA dashboard, the Result shows as Aborted and Orphaned. It shows pretty much the same thing in the Monitoring -&gt; Events tab. There&#39;s no error in the process indicating why it would have broke, so any insight is appreciated!

Hi all, I am trying to configure the RPA resource. The final Maven setting does not work and results in error. I have tried to give the credentials and all the&nbsp;URL info but still pops up with same message. The same works fine when I initiate from my personal PC but when&nbsp;I try to work on the same logic with my official Pc there is an error thrown. Is there something am&nbsp;I missing to configure or set up I specified my URL as :&nbsp;https://&lt;mysite&gt;/rpa-repo/ I gave my credentials too&nbsp;

Hello Everyone,&nbsp; is there a guide how to configure a resource for APPIAN RPA&nbsp;in&nbsp;AWS&nbsp;?&nbsp;

here for the fist two filters i want to use it as &quot;AND&quot; operator filters and last two I want use as &quot;OR&quot; operator. Is there any way to do it inside the a!queryrecordtype function?

Hi, I have a string in DB which is: &quot;&lt;key&gt;PROJECT_CODE&lt;/key&gt;&lt;style&gt;BOLD&lt;/style&gt;&lt;color&gt;#EF0010&lt;/color&gt;&quot; and I want your help to split this into different variables, like after splitting the above string&nbsp; var1 will have value = PROJECT_CODE, var2 will have value = BOLD, var3 will have value = #EF0010 Thanks in advance!