Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 March 2023

Top 3 Topics with Most Views

Created a automathon with using the automation challenge made by @imumeriqbal with 70 views.

Mail retrieve attachments does not work made by @Joachim with 56 views.

Trim the string in datatable made by @Demo_User with 45 views.

Top 3 Topics with Most Replies

Mail retrieve attachments does not work made by @Joachim with 24 replies.

Excel - Classic Version - Column and Header Formatting made by @PPIM_RPA with 14 replies.

Present Validation Station: The value must either contain a textual value or have components, not both made by @Nithya_Aashitha with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 76 posts!

@Yoichi made 37 posts!

@arjunshenoy made 18 posts!

Top 3 Most Liked Posts

This post made by @mukeshkala received 2 likes!

Live Streaming & Remote Control - Preview release

Hi @Adrian_Tamas , I Tried this Feature and its working fine for me with one Exception that it is changing settings of my computer. Whenever I am using this - My Wallpaper is getting changed to a default Black Screen . Tried doing the same multiple times - same thing happens. Not sure if thats the Tight VNC or something else. – Mukesh

This post made by @mukeshkala received 2 likes!

Live Streaming & Remote Control - Preview release

@Adrian_Tamas , Thank you - I got it - Just adding the screenshot here of the setting for anyone else facing the same. [image] – Mukesh

This post made by @Gokul001 received 2 likes!

Split String which is having multiple occurrences

Hi @Vardhan Welcome to UiPath community You can try with Regular expression System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)") [image] System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)")(1) [image] [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Split String which is having multiple occurrences

Hi @Vardhan Welcome to UiPath community You can try with Regular expression System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)") [image] System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)")(1) [image] [image] Regards Gokul

This solution provided by @Yoichi received 2 likes!

How to get all columns (example A,B,C ...) in excel and return to array

HI, How about the following expression? (Case for 100 columns) Enumerable.Range(1,100).Select(Function(i) ExcelUtilities.ConvertColumnIndexToColumnLetter(i)).ToArray [image] Note: please add UiPath.Excel.Helper namespace in advance. Sample20230324-5L.zip (2.4 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Invoke Workflow question

@A_Learner You have to use another use application browser activity inisde the workflow… You can either attach to window using selector or can send the output of use application browser from the main xaml to the called xaml Hope this helps Cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 25 March 2023

Top 3 Topics with Most Views

Excel Manipulations, The result of final status column should come as OK & NOT OK made by @Praveen_Vs with 41 views.

Get Text OCR Error made by @Amit_Kumar_Charde with 36 views.

How to know which activity get error? made by @prabin_chand1 with 36 views.

Top 3 Topics with Most Replies

Excel Manipulations, The result of final status column should come as OK & NOT OK made by @Praveen_Vs with 13 replies.

Get Text OCR Error made by @Amit_Kumar_Charde with 9 replies.

Not able to access Type Argument for For Each Loop made by @Arijit_Sarkar with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 11 posts!

@ushu made 10 posts!

@supermanPunch made 8 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 2 likes!

How to read my config file?

Hi @prabin_chand1 You can copy the InitAllSettings workflow from any blank RE Framework & paste the same in your project folder, along with your config.xlsx file. In the studio, just drag the same workflow, map the config file & store the data in Config variable. That’s it, you are good to go. Hope this helps, Best Regards.

This post made by @saritha received 1 likes!

Invoke Workflow question

Hi Yoichi, Here may I know what will be the output of UiElement. Thanks and have a great day.

This post made by @ushu received 1 likes!

How can I manually connect to Oracle DB using variables

Hi @j.wheeler - You can use variables of type String in the connection string. Did you check the connection string working without using any variables in it. This is to confirm, successful connection to db. If it works then, try passing variables in it. Hope below link useful

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 2 likes!

How to read my config file?

Hi @prabin_chand1 You can copy the InitAllSettings workflow from any blank RE Framework & paste the same in your project folder, along with your config.xlsx file. In the studio, just drag the same workflow, map the config file & store the data in Config variable. That’s it, you are good to go. Hope this helps, Best Regards.

This solution provided by @supermanPunch received 1 likes!

Issues while attaching file

Hi @JOBIN_JOSE , Maybe try the below : {str_latest}

This solution provided by @supermanPunch received 1 likes!

Excel - Classic Version - Column and Header Formatting

@PPIM_RPA , Apologies. It seems I made a small mistake. Could you shift the datatables in the Merge Datatables Activity and check, It should be like the below image : [image] Let me know if you still receive the same output again.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 26 March 2023

Top 3 Topics with Most Views

VLookup LINQ - Multiple Columns made by @Neal369 with 42 views.

LINQ for 2 Tables made by @tep_b with 42 views.

How to remove last char from a range in one go without loops made by @Jeeru_venkat_Rao with 35 views.

Top 3 Topics with Most Replies

VLookup LINQ - Multiple Columns made by @Neal369 with 11 replies.

Color detection with CV made by @Gabriel_Isman with 10 replies.

Queue Trigger With Postpone is not triggered made by @logesh_kumar1 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 32 posts!

@Manish540 made 9 posts!

@arjunshenoy made 9 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

How to remove last char from a range in one go without loops

Hi @Jeeru_venkat_Rao , Can you please check below screenshot its working for me, [image] Use this below code in write cell activity, "=SUBSTITUTE(A2,""$"","""")" [image] Hope this may help you

This post made by @arjunshenoy received 3 likes!

Minimal Product Set

Hi @A_Learner UiPath Studio for developing automation workflows. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Robot: The software that executes the automation workflows created in Studio. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Orchestrator: Centralised management and monitoring tool. You will need a server with at least 8GB RAM and a quad-core processor. The server should also have a minimum of 10GB of free di…

This post made by @arjunshenoy received 2 likes!

Minimal Product Set

@A_Learner Along with the UiPath Enterprise Licence, some hardware requirements might differ from regular requirements, as DU uses GPU units & need higher machine capabilities. You can find the list of requirements for DU in the doc below: Hope this helps, Best Regards.

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 4 likes!

How to remove last char from a range in one go without loops

Hi @Jeeru_venkat_Rao , Can you please check below screenshot its working for me, [image] Use this below code in write cell activity, "=SUBSTITUTE(A2,""$"","""")" [image] Hope this may help you

This solution provided by @arjunshenoy received 3 likes!

Minimal Product Set

Hi @A_Learner UiPath Studio for developing automation workflows. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Robot: The software that executes the automation workflows created in Studio. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Orchestrator: Centralised management and monitoring tool. You will need a server with at least 8GB RAM and a quad-core processor. The server should also have a minimum of 10GB of free di…

This solution provided by @vishal.kp received 2 likes!

Design Window Activities Minimized

@Orchestrator_Practice , try this [image]

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 27 March 2023

Top 3 Topics with Most Views

UiPath learning help made by @gaurav2000 with 53 views.

Remove Junk Values made by @Rajneesh_Kumar with 51 views.

Report malware on forum made by @leosaumure with 48 views.

Top 3 Topics with Most Replies

Remove Junk Values made by @Rajneesh_Kumar with 20 replies.

When I start UiPath Studio, I get an error made by @sozdaiblog with 16 replies.

How to download all files from SharePoint folder using microsoft O365 activity made by @Akshay_Suryawanshi with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 81 posts!

@Yoichi made 27 posts!

@supermanPunch made 16 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

UiParh log mearning

@Wirit_Panrit UiPath.Studio.log: contains information about the Studio application itself, including startup and shutdown events, errors that occur within the application, and general diagnostic information. UiPath.Studio.Project.log: contains information about the current project being worked on in Studio, including activities that have been executed, errors that have occurred, and diagnostic information specific to the project.(Execution logs) UiPath.Studio.Analyzer.log: These contain the…

This post made by @Yoichi received 2 likes!

I need regex expression to get date from above line

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,".*(?=\r?\nDepartment of Labor,)").Value [image] Regards,

This post made by @supermanPunch received 2 likes!

While using read pdf ocr , i am getting error ( Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. )

@MitheshBolla , It looks as if the Environment mentioned matches the Environment you have, and hence do follow the Suggestion provided in the post above : [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

I need regex expression to get date from above line

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,".*(?=\r?\nDepartment of Labor,)").Value [image] Regards,

This solution provided by @supermanPunch received 2 likes!

While using read pdf ocr , i am getting error ( Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. )

@MitheshBolla , It looks as if the Environment mentioned matches the Environment you have, and hence do follow the Suggestion provided in the post above : [image]

This solution provided by @Anil_G received 1 likes!

Best way to remove the first two characters from every string value in a list?

@David_Hernandez Try this Listvar.Select(function(x) x.SubString(2)).ToList Hope this helps Cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 28 March 2023

Top 3 Topics with Most Views

Process PDF Files, Classify Documents & more with new Document Understanding Activities in Studio Web made by @Monica_Secelean with 107 views.

Automatic locked screen in Hardware Events input mode? made by @prabin_chand1 with 49 views.

UiPath Studio - Issue with folder connection(Default) made by @dinesh.pazhaniyandi with 45 views.

Top 3 Topics with Most Replies

RPA Challange Extraction Errpr made by @Amit_Kumar_Charde with 17 replies.

Getting data from Website and Load to datatable made by @Sisay_Dinku with 14 replies.

UiPath Studio - Issue with folder connection(Default) made by @dinesh.pazhaniyandi with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 73 posts!

@Yoichi made 21 posts!

@fernando_zuluaga made 13 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 6 likes!

Process PDF Files, Classify Documents & more with new Document Understanding Activities in Studio Web

With our newest Document Understanding package for cross-platform projects, we’re bringing to you PDF processing capabilities and more! Document Data In order to efficiently work with Documents, we introduced the notion of Document Data - an object which can be used as input or output to Document Understanding activities, containing all information about the document, depending on the activities one uses it with: document type (populated by the new Classify Document Activity), fields (p…

This post made by @Chirag_Shetty_Divakar received 5 likes!

Convert a month from numerical digit to words

Hey @Lochagos Use DateTime.Now.AddMonths(-1).ToString(“MMMM”) This will return you full month Like February Regards,

This post made by @Kalpesh_Chaudhari received 3 likes!

What are different ways of triggers?

Hi, There are two types of trigger Time Triggers and Queue Triggers Time Triggers: Enable you to schedule a recurrent time to start a job. Input values for processes that support input and output parameters can be managed at this level as well. Queue Trigger: Can instantly start a process upon the trigger creation or whenever you add a new item to a queue. The trigger runs in the environment associated with the selected process For more pls refer below site: Types of Trigger..? - #9 by Goku…

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 5 likes!

Convert a month from numerical digit to words

Hey @Lochagos Use DateTime.Now.AddMonths(-1).ToString(“MMMM”) This will return you full month Like February Regards,

This solution provided by @Kalpesh_Chaudhari received 3 likes!

What are different ways of triggers?

Hi, There are two types of trigger Time Triggers and Queue Triggers Time Triggers: Enable you to schedule a recurrent time to start a job. Input values for processes that support input and output parameters can be managed at this level as well. Queue Trigger: Can instantly start a process upon the trigger creation or whenever you add a new item to a queue. The trigger runs in the environment associated with the selected process For more pls refer below site: Types of Trigger..? - #9 by Goku…

This solution provided by @Anil_G received 2 likes!

UiParh log mearning

@Wirit_Panrit tried finding few, answers were more from experience Ll try to add more references as I find more Cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 29 March 2023

Top 3 Topics with Most Views

How do I loop through a List(Of String) made by @carlor with 48 views.

Get the key from dictionary where value is min made by @Sven_son with 36 views.

Filter data table by datetime made by @Kevin_Maurice with 36 views.

Top 3 Topics with Most Replies

How do I loop through a List(Of String) made by @carlor with 17 replies.

How to remove unique values from text file and get only duplicate value list? made by @vidya.wagh with 16 replies.

Save mail message activity illegal characters in header field made by @Sailaja_Pasupuleti with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@supermanPunch made 25 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @Chirag_Shetty_Divakar received 6 likes!

Cannot Type Into Element in Incognito Mode (Chrome)

@C_M1 Enable extensions in incognito mode. Steps you can follow: Go to Chrome browser Add the chrome extension(if not added yet) Go to customize and control > More tools > Extension [image] Click on the UiPath Extension Now, allow the extension in incognito. [image] Should work [image] Try this Regards.

This post made by @Jithesh_R received 4 likes!

Regarding Send hotkey multiple function

@Ram_Shiva_Reddy Can you try this In the properties panel of send hotkey Click on the selector field and indicate the target And in the Key field in properties panel add something like this (Inside double quotes) [image] Make sure to Check the SendWindowMessage checkbox Regards,

This post made by @Chirag_Shetty_Divakar received 2 likes!

Cannot Type Into Element in Incognito Mode (Chrome)

Hey @C_M1 [image] Check this private option in the Misc. Then you will be able to run in the incognito mode as well Hope this helps, Cheers

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 6 likes!

Cannot Type Into Element in Incognito Mode (Chrome)

@C_M1 Enable extensions in incognito mode. Steps you can follow: Go to Chrome browser Add the chrome extension(if not added yet) Go to customize and control > More tools > Extension [image] Click on the UiPath Extension Now, allow the extension in incognito. [image] Should work [image] Try this Regards.

This solution provided by @Jithesh_R received 4 likes!

Regarding Send hotkey multiple function

@Ram_Shiva_Reddy Can you try this In the properties panel of send hotkey Click on the selector field and indicate the target And in the Key field in properties panel add something like this (Inside double quotes) [image] Make sure to Check the SendWindowMessage checkbox Regards,

This solution provided by @Kalpesh_Chaudhari received 2 likes!

What is Ienumerable?

Hi, To keep it simple, if your object implement IEnumerable, you can iterate over it (with a ForEach). In other words, if something gives you an IEnumerable it provides you a mean to have its elements one by one. Thanks.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 30 March 2023

Top 3 Topics with Most Views

RPA Assignment Problem - exporting/importing files from Access DB made by @Jackson_Hew with 43 views.

How to type in data into application text field without using the application? made by @yadish.s with 42 views.

How do I save the latest file from a folder, move it to another folder and rename the file? made by @Shannon_Quek with 38 views.

Top 3 Topics with Most Replies

Unable to read same excel file twice in the same process made by @hari.vishalmudra2 with 16 replies.

How do I save the latest file from a folder, move it to another folder and rename the file? made by @Shannon_Quek with 14 replies.

SELECTOR WILDCARD DOUBT made by @BHUVAN with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@Yoichi made 26 posts!

@arjunshenoy made 14 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How do I save the latest file from a folder, move it to another folder and rename the file?

Hey @Shannon_Quek , 1.You can use this Directory.GetFiles(“C:\Users\Jithesh.R\Downloads\Whatsapp”,“*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) 2.You can use Move File Activity to move the file from one location to another [image] You can use Rename FIle Activity to rename a file [image] Regards,

This post made by @pradeep_ch received 2 likes!

Announcing the Winners of AI Awards 2023

Thank you so much @loredana_ifrim @Vibhor.Shrivastava

This post made by @imran.loon received 2 likes!

Announcing the Winners of AI Awards 2023

Thank You @Vibhor.Shrivastava @loredana_ifrim Congratulations to all winners​:clap:t3:

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How do I save the latest file from a folder, move it to another folder and rename the file?

Hey @Shannon_Quek , 1.You can use this Directory.GetFiles(“C:\Users\Jithesh.R\Downloads\Whatsapp”,“*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) 2.You can use Move File Activity to move the file from one location to another [image] You can use Rename FIle Activity to rename a file [image] Regards,

This solution provided by @Yoichi received 2 likes!

Month+String+Year(1 year ahead) calendar window

Hi, How about the following expression? Now.ToString("MMM")+" FY "+Now.AddYears(1).ToString("yy") [image] OR The following will also work. Now.AddYears(1).ToString("MMM \F\Y yy") Regards,

This solution provided by @Yoichi received 1 likes!

Set Dynamic Delay in Delay Activity

Hi, Can you try to use TimeSpan.FromSecond method etc, as the following? [image] TimeSpan.FromSeconds(delaySec) note : delaySec is Double type variable Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 31 March 2023

Top 3 Topics with Most Views

【UiPathアカデミー】新規コースのお知らせ（3/31 追加分） made by @yuko.tanaka with 59 views.

How could I copy data from a cell in an excel file and paste it into a web form? made by @ximenasalas872 with 42 views.

Data Service error - when Update or query records made by @Arvind_Kumar1 with 41 views.

Top 3 Topics with Most Replies

Converting the string to the integer made by @shailaja_reddy with 17 replies.

Hi, I am trying to get a email message from my yahoo mailbox but i got timeout.Can anyone help me to check why ic ouldnt get the message ? Is it something wrong with my properties? made by @royang28 with 13 replies.

Find Dynamic Excel Read & Write into sheet made by @anh.nguyen with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Yoichi made 25 posts!

@arjunshenoy made 19 posts!

Top 3 Most Liked Posts

This post made by @sumits received 3 likes!

Announcing the Winners of AI Awards 2023

Thank you so much @Vibhor.Shrivastava and @loredana_ifrim

This post made by @Chirag_Shetty_Divakar received 3 likes!

While loop with continue activity

@BHUVAN Just an example inside invoke to increase count you can use this Select Case Weekday(startDate,VBMonday) Case 1 If row(“Pattern”).ToString.Contains(“1”) Then in_Count=in_Count+1 End If Case 2 If row(“Pattern”).ToString.Contains(“2”) Then in_Count=in_Count+1 End If Case 3 If row(“Pattern”).ToString.Contains(“6”) Then in_Count=in_Count+1 End If Case 4 If row(“Pattern”).ToString.Contains(“7”) Then in_Count=in_Count+1 End If End Select Hope it helps, Cheers

This post made by @Gokul_Jayakumar received 2 likes!

Having Doubt on string conversion

Hello @Mr.Bug_Maker Try this System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(“Your String”) [image]

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 3 likes!

While loop with continue activity

@BHUVAN Just an example inside invoke to increase count you can use this Select Case Weekday(startDate,VBMonday) Case 1 If row(“Pattern”).ToString.Contains(“1”) Then in_Count=in_Count+1 End If Case 2 If row(“Pattern”).ToString.Contains(“2”) Then in_Count=in_Count+1 End If Case 3 If row(“Pattern”).ToString.Contains(“6”) Then in_Count=in_Count+1 End If Case 4 If row(“Pattern”).ToString.Contains(“7”) Then in_Count=in_Count+1 End If End Select Hope it helps, Cheers

This solution provided by @Gokul_Jayakumar received 2 likes!

Having Doubt on string conversion

Hello @Mr.Bug_Maker Try this System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(“Your String”) [image]

This solution provided by @arjunshenoy received 2 likes!

Compare String1 to String2 (String1=String2)

Hi @swinter1 UiPath is adding the @ symbol before String1 because it is interpreting it as a verbatim string literal. A verbatim string literal starts with the @ symbol and it allows you to include special characters, such as new lines or tabs, in a string without having to escape them. To avoid this, you can use: String1 = String1.TrimStart("@"c) Hope this helps, Best Regards.

[Previous Month] Top 3 Users with the most likes on their solutions

@Manish540 received 126 likes for their solutions!

@Anil_G received 119 likes for their solutions!

@Chirag_Shetty_Divakar received 81 likes for their solutions!

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 01 April 2023

Top 3 Topics with Most Views

Deskew library for document image processing made by @Minoh_Kang with 36 views.

Hello team, pls provide solution for this string manipulation.Tq made by @lakshmi_narayana_ch with 34 views.

How to put condition for Null Variable Value made by @jai_kumar2 with 32 views.

Top 3 Topics with Most Replies

Insert data in queue with Bulk add Queue items error made by @Deep_HML with 12 replies.

Regex Range Excel made by @anh.nguyen with 10 replies.

Hello team, pls provide solution for this string manipulation.Tq made by @lakshmi_narayana_ch with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@arjunshenoy made 13 posts!

@supermanPunch made 10 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 1 likes!

Deskew library for document image processing

Deskewing is the most common pre-processing that is applied to scanned documents prior to the main processing of data extraction from those documents. The following library provides an easy-to-use wrapper for Galfar’s Deskew Tools for use in UiPath document processing workflows. One notable limitation of Galfar’s tools is the lack of support for multi-page TIF files - it works for the first page only. The library enables deskewing of all the pages by disassembling the pages, performing deskew…

This post made by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

@Deep_HML To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those… And yes the limit is 15k or so… We can break the table into rows of 10k and add in 3 loops So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable And use the chun…

This post made by @supermanPunch received 1 likes!

Insert data in queue with Bulk add Queue items error

Hi @Deep_HML , Maybe also take a look at the below post :

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

@Deep_HML To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those… And yes the limit is 15k or so… We can break the table into rows of 10k and add in 3 loops So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable And use the chun…

This solution provided by @Anil_G received 1 likes!

CurrentRow properties

@TTYF Say you want to copy from sheet1 to sheet2 each column in the loop then use as below…you can copy whole row as well [image] Excel.Sheet("Sheet1").Range(currentRow.ByField("FieldName").Address) Sheetname is the difference between source and destination Hope this helps cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 02 April 2023

Top 3 Topics with Most Views

Why UiPath is bringing Updates Frequently? made by @prabin_chand1 with 51 views.

Hello team, i need to add data to datable using add data column and put data in Database. pls provide the solution.Tq made by @Lokesh_M2 with 45 views.

StudioX to Studio change made by @arnab.koley with 37 views.

Top 3 Topics with Most Replies

How to compare 2 sheet and check status made by @anh.nguyen with 15 replies.

How to pass variables as parameters in the "invoke python method" in UIPath made by @PAJ1999 with 14 replies.

Hello team, i need to add data to datable using add data column and put data in Database. pls provide the solution.Tq made by @Lokesh_M2 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@Harshith_Adyanthaya made 11 posts!

@lakshminarayana_chavala made 7 posts!

Top 3 Most Liked Posts

This post made by @fernando_zuluaga received 1 likes!

How to make click dynamic

Hi @Muhammad_Anas_Baloch did you try to use the for each ui element activity? retrieve all the list you want to click, then pass currentElement to click activity also you can use a dynamic click by editing the selector, probably you will find a property called Idx, create a counter and pass that variable Regards

This post made by @Muhammad_Anas_Baloch received 1 likes!

How to make click dynamic

No I haven’t used the Ui element activity let me do with this way. Thanks

This post made by @Muhammad_Anas_Baloch received 1 likes!

How to make click dynamic

Thank you dear for each ui element activity resolved my issue.

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

How to make click dynamic

Hi @Muhammad_Anas_Baloch did you try to use the for each ui element activity? retrieve all the list you want to click, then pass currentElement to click activity also you can use a dynamic click by editing the selector, probably you will find a property called Idx, create a counter and pass that variable Regards

This solution provided by @vishal.kp received 1 likes!

Date from 6 months ago

Hi @csanders , Try the below expression now.AddMonths(-6).ToString("dd/MM/yyyy")

This solution provided by @Harshith_Adyanthaya received 1 likes!

Orchestrator Credential in config file

Hi @Amr_Nweery Storing credential in config is not recommended. Instead store it in assets in orchestrator or window credential manager and keep the asset name / Window credential name in config. Later you can use Get credential activity to retrieve credentials from asset. To retrieve credential from window crendential manager you can use Get Secure Credential activity.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 03 April 2023

Top 3 Topics with Most Views

What are the major tools you know in UiPath platform made by @Vajrang with 89 views.

How can do to combine RPA and machine learning made by @Soudios with 42 views.

From a datatable, create a variable made by @mark_rajkumar1 with 40 views.

Top 3 Topics with Most Replies

What are the major tools you know in UiPath platform made by @Vajrang with 20 replies.

How to send a form into Outlook made by @shanmugapriyag with 12 replies.

Read Range Workbook: Sequence contains no matching element made by @Chetan_Wagh with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 89 posts!

@arjunshenoy made 31 posts!

@Gokul001 made 23 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 13 likes!

What are the major tools you know in UiPath platform

Mention all the tools and uses in UiPath platform

This post made by @arjunshenoy received 7 likes!

Monthly Forum rewards - March 2023

Congratulations everyone It’s a great thing to guide & learn altogether.

This post made by @rikulsilva received 6 likes!

Monthly Forum rewards - March 2023

Congrats everyone. Its a pleaure read and learning with solutions provided by you

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Help required for Arabic Regex

ensure that when composing the pattern that copy & paste is not confused by the borders and handle right to left text part also [grafik]

This solution provided by @Harshith_Adyanthaya received 2 likes!

Duplicates in emails and do not process them

Hi @Marc.J1 , You can try this query. mailMessages = mailMessages.GroupBy(Function(x)x.Subject).Select(Function(x)x.First).ToList where mailMessages is the output of Get outlook mail message. Hope it helps.

This solution provided by @Yoichi received 2 likes!

How to subtract 8.5 and 9:45?

Hi, How about the following? [image] TimeSpan.Parse("8:35")-TimeSpan.FromHours(8.5) Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 04 April 2023

Top 3 Topics with Most Views

Selecting an item from dialog box made by @Jerick_Geronimo with 48 views.

Help me build a linq made by @Rahul_Rajendran with 45 views.

Get value dynamic & sum Excel made by @anh.nguyen with 45 views.

Top 3 Topics with Most Replies

Selecting an item from dialog box made by @Jerick_Geronimo with 15 replies.

Get value from column header made by @anh.nguyen with 14 replies.

Invoke VBA is not working made by @shreyash_shirbhate with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 96 posts!

@arjunshenoy made 25 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 6 likes!

Comparing 2 Datatable

Hey @Atakan_Genc , Please check this workflow Comparing2DataTables.zip (2.3 KB) Comparing2DataTables.xlsx (9.0 KB) Sample Output : [image] Regards,

This post made by @supermanPunch received 2 likes!

Excel application scope problem

Hi @pravin_bindage , We cannot have : in file name. [image]

This post made by @Sudharsan_Ka received 2 likes!

Excel application scope problem

Hi @pravin_bindage File should not contains the these symbols in name change that character to _ or space and try again [image] Regards Sudharsan Regards Sudharsan

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 6 likes!

Comparing 2 Datatable

Hey @Atakan_Genc , Please check this workflow Comparing2DataTables.zip (2.3 KB) Comparing2DataTables.xlsx (9.0 KB) Sample Output : [image] Regards,

This solution provided by @Sudharsan_Ka received 2 likes!

Excel application scope problem

Hi @pravin_bindage File should not contains the these symbols in name change that character to _ or space and try again [image] Regards Sudharsan Regards Sudharsan

This solution provided by @vishal.kp received 2 likes!

Invoke VBA is not working

The method name you have mentioned seems to have a typo ChnageFormat, can you check and verify if it’s the same method you have used in the script. @shreyash_shirbhate Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 06 April 2023

Top 3 Topics with Most Views

How to genrate text to excel made by @Space_Lover with 41 views.

Copy File with error made by @Joanna2 with 38 views.

LastModifiedByUser - not able to fetch in sharepoint files made by @Vishnu_Pradhaban with 37 views.

Top 3 Topics with Most Replies

How to sort the data using linq query made by @RAKESH_KUMAR_Tiwari with 19 replies.

"Assign" keeps showing the name doesn't exist made by @108305006 with 16 replies.

LastModifiedByUser - not able to fetch in sharepoint files made by @Vishnu_Pradhaban with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 30 posts!

@Harshith_Adyanthaya made 30 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 5 likes!

How to pass parametre to Macro Excel c#

Hi @javierdavidh , Can you please pass the parameter as below and let us know, new object[] {variable1} [image] Hope this helps you

This post made by @Jithesh_R received 5 likes!

I required last 4 IP addresses Individually

Hey @Manju_Reddy_Kanughula , I believe this exercise is from the Bots DNA . So for that to take this individual values You can directly put this inside a datatable and you can put for each row in data table for each row. 1.Read text file 2. Use generate data table activity 3. Use for each row for that Generated data table you will get seperate rows. This is the configuration inside generate data table [image] Regards,

This post made by @Jithesh_R received 5 likes!

Delete column by condition

Hey @anh.nguyen , Check this workflow DeleteColumnByCondition.zip (2.3 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 5 likes!

How to pass parametre to Macro Excel c#

Hi @javierdavidh , Can you please pass the parameter as below and let us know, new object[] {variable1} [image] Hope this helps you

This solution provided by @Jithesh_R received 5 likes!

I required last 4 IP addresses Individually

Hey @Manju_Reddy_Kanughula , I believe this exercise is from the Bots DNA . So for that to take this individual values You can directly put this inside a datatable and you can put for each row in data table for each row. 1.Read text file 2. Use generate data table activity 3. Use for each row for that Generated data table you will get seperate rows. This is the configuration inside generate data table [image] Regards,

This solution provided by @Jithesh_R received 5 likes!

Delete column by condition

Hey @anh.nguyen , Check this workflow DeleteColumnByCondition.zip (2.3 KB) Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 07 April 2023

Top 3 Topics with Most Views

Slow Performance with Each Transaction made by @Pankaj_J with 43 views.

Copy last sheet everytime in Excel made by @Joshua_Ducao with 37 views.

Help with writing values from one data table to another Data table made by @Mchande with 36 views.

Top 3 Topics with Most Replies

How can add Column After Or Before Specific Column made by @anh.nguyen with 16 replies.

Help with writing values from one data table to another Data table made by @Mchande with 16 replies.

Slow Performance with Each Transaction made by @Pankaj_J with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@Nitya1 made 30 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @vishal.kp received 3 likes!

How to upload the excel input to the Mssql DB

Hi @Vrishchik , The error message suggests that there is a mismatch between the columns in your DataTable and the column data types in your database table. To resolve this issue, you can try the following steps: -Check the data types of the columns in your DataTable and make sure they match the column data types in your database table. If they do not match, you may need to convert the data in your DataTable to match the data types in your database table. -Make sure that the number of columns …

This post made by @Anil_G received 2 likes!

What is my UiPath version ? / what is difference?

@Hyde The bottom one looks like an old orchestrator…is it on prem orchestrator? Mostly that is an enterprise license as you can see the license code on the top…for enterprise only we would have that displayed See orchestrator is something that is like a place where you can manage things…once you create an account…which ever license it is you will have orchestrator available for you…but depending on the license that you use…different options on orchestrator are available… Example.community ver…

This post made by @Anil_G received 2 likes!

What is my UiPath version ? / what is difference?

@Hyde If you see at the top of your scren …you can see that your plan is community version… Community version is for learning purposes and to use them for building knowledge… here you cannot control upgrades Free plan does not have studio license and only studio x can be used If enterprise license is present then you would have more capabilities and support from UiPath team and etc…this is suitable for production runs and for actually using the products…upgrades and all can be controlled her…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

What is my UiPath version ? / what is difference?

@Hyde The bottom one looks like an old orchestrator…is it on prem orchestrator? Mostly that is an enterprise license as you can see the license code on the top…for enterprise only we would have that displayed See orchestrator is something that is like a place where you can manage things…once you create an account…which ever license it is you will have orchestrator available for you…but depending on the license that you use…different options on orchestrator are available… Example.community ver…

This solution provided by @Yoichi received 2 likes!

How can add Column After Or Before Specific Column

Hi, The following is a sample which add new column before another column named “colX”. Hope this helps you [image] Sample20230407-8L.zip (4.8 KB) Regards,

This solution provided by @Nitya1 received 1 likes!

Check isGreater and IsEqual and isLesser from in a string

Hi @Muhammad_Anas_Baloch To check if the Duration of residence (n) is less than 10 or not, you can use the following steps: Use the Matches activity to extract the numerical value from the string using a regular expression. For example, for the string “Duration of residence <10”, you can use the regular expression “\d+” to extract the number 10. Convert the extracted numerical value to an integer using the CInt function. Check if the integer is less than 10 using a simple If condition. If it …

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 08 April 2023

Top 3 Topics with Most Views

Error Problem please anyone tell me the solution made by @gpkraju.alluri with 48 views.

Problems with base64 decoding made by @rpa.cresmin with 40 views.

I don't understand what to write in the condition made by @sazonov038 with 38 views.

Top 3 Topics with Most Replies

Need help on making existing folderpaths in .xls column as clickable in uipath made by @r0818 with 17 replies.

I want to use mouse scroll functionality made by @Bhushan_Nagaonkar with 10 replies.

How to Find First Null Value in a row in Datatable? made by @Hammadul_Haque with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@jackie.yue made 10 posts!

@Harshith_Adyanthaya made 9 posts!

Top 3 Most Liked Posts

This post made by @Harshith_Adyanthaya received 3 likes!

How to open particular Excel Sheet

Hi @Muhammad_Anas_Baloch , You can use Excel Application Scope, with Visible property checked. In this case the excel will open. Later you can close it using close workbook activity. [image] Or In Modern activities, you can use Use Excel File activity inside Excel Process Scope and make show excel window property of Excel Process Scope activity to True. [image] Hope it helps.

This post made by @Pavanraj_Shetty received 2 likes!

HTML Email Body

Hi @Farah_halawani Try this Hope this might help you

This post made by @Harshith_Adyanthaya received 2 likes!

How to Add Particular Column values in excel dynamically?

Hi @Vaishnav_Tej , FindSum= (from r in inputDT.AsEnumerable where Double.TryParse(r.Item(“ColName”).ToString,Nothing)=True).Sum(Function(x) cdbl(x(“ColName”).ToString)) Hope this helps.

Top 3 Most Liked Solutions

This solution provided by @Harshith_Adyanthaya received 3 likes!

How to open particular Excel Sheet

Hi @Muhammad_Anas_Baloch , You can use Excel Application Scope, with Visible property checked. In this case the excel will open. Later you can close it using close workbook activity. [image] Or In Modern activities, you can use Use Excel File activity inside Excel Process Scope and make show excel window property of Excel Process Scope activity to True. [image] Hope it helps.

This solution provided by @Anil_G received 2 likes!

How to group by multiple columns and Sum

@anh.nguyen Please use this in Assign and change column names as you need First use a build datatable activity and then create the required group columns and sum columns and give dtoutput in datatable field dtoutput = (From d In dtinput.AsEnumerable() Group d By k1=d(1).toString.Trim,k2=d(2).toString.Trim,k3=d(3).toString.Trim,k4=d(4).toString.Trim Into grp = Group Let sum1 = grp.sum(function(x) cdbl(x("Column1"))).ToString Let sum2 = grp.sum(function(x) cdbl(x("Column2"))).ToString Let sum…

This solution provided by @Harshith_Adyanthaya received 2 likes!

Get the Hours and minutes of the system's current time

Hi @jackie.yue , DateTime.Now.Tostring(“HH:mm”) Check this. Hope it helps.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 09 April 2023

Top 3 Topics with Most Views

I faced this issue please teel me resolution made by @rajuvadlakonda7272 with 47 views.

Need Solution - challenge with Extract Datatable made by @TAL_TAL with 38 views.

Formating in to date time made by @satish.rathi59 with 37 views.

Top 3 Topics with Most Replies

Read range work makes an error made by @ani_panch with 14 replies.

Formating in to date time made by @satish.rathi59 with 12 replies.

How to Display in textbox the last sheet in excel if we use get workbook sheets activity made by @Joshua_Ducao with 8 replies.

Top 3 Users Who Posted The Most

@Harshith_Adyanthaya made 22 posts!

@Anil_G made 20 posts!

@ani_panch made 13 posts!

Top 3 Most Liked Posts

This post made by @Jennifer_Serrao received 5 likes!

[오류대처문의] Main.xaml: (2) : error BC30652: 'IXmlSerializable' 형식을 포함하는 'System.Xml.ReaderWriter, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' 어셈블리에 대한 참조를 찾을 수 없습니다. 프로젝트에 추가하세요

안녕하세요 @crpark2486 읽기 범위 활동을 사용하고 있으므로 시트는 “Datatable” 내부를 읽고 저장합니다. 따라서 데이터 테이블에서 데이터를 가져오려면 "데이터 테이블의 각 행에 대해"를 사용해야 합니다. 아래 스크린샷을 참조하세요. 감사합니다! [image] 원하는 출력을 얻고 있는지 알려주십시오.

This post made by @Manish540 received 4 likes!

Kill procss of Excel

Hi @jackie.yue , Pass the “excel” as ProcessName as shown in below screenshot, [image] And let us know if its working for you?

This post made by @Manish540 received 3 likes!

Formating in to date time

Hi @satish.rathi59 , Check this below codes, firstDate(DateTime as type) = System.DateTime.ParseExact("08/Apr/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InvariantCulture) endDate(DateTime as type) = System.DateTime.ParseExact("09/May/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InvariantCulture) totalDays(Int32 as type) = (endDate-firstDate).TotalDays Screenshot: [image] Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @Jennifer_Serrao received 5 likes!

[오류대처문의] Main.xaml: (2) : error BC30652: 'IXmlSerializable' 형식을 포함하는 'System.Xml.ReaderWriter, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' 어셈블리에 대한 참조를 찾을 수 없습니다. 프로젝트에 추가하세요

안녕하세요 @crpark2486 읽기 범위 활동을 사용하고 있으므로 시트는 “Datatable” 내부를 읽고 저장합니다. 따라서 데이터 테이블에서 데이터를 가져오려면 "데이터 테이블의 각 행에 대해"를 사용해야 합니다. 아래 스크린샷을 참조하세요. 감사합니다! [image] 원하는 출력을 얻고 있는지 알려주십시오.

This solution provided by @Manish540 received 4 likes!

Kill procss of Excel

Hi @jackie.yue , Pass the “excel” as ProcessName as shown in below screenshot, [image] And let us know if its working for you?

This solution provided by @vishal.kp received 2 likes!

Can set variables while adding values to FormFieldsCollection

@ani_panch , You have to create a variable there first in order to use it, try creating the invoiceNumber variable of type int32 and then using it. [image] Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 10 April 2023

Top 3 Topics with Most Views

Compare one by one cell value from 2 sheet made by @anh.nguyen with 47 views.

Remove duplicates from two columns made by @Jnanesh_Ballal with 39 views.

PDF made by @vidhya_s1 with 39 views.

Top 3 Topics with Most Replies

How to make orchestrator API calls? made by @Ana_Patricia with 18 replies.

How to open CMD with administration rights? made by @Muhammad_Anas_Baloch with 14 replies.

Remove the all the text after second (-) character from a string made by @smrutismita.samal with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 64 posts!

@arjunshenoy made 30 posts!

@Harshith_Adyanthaya made 29 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Tutorial: OpenAI Integration Service Connector - Getting Started

Hello Community! Here’s a new video that takes a quick swing at the Preview version of the UiPath OpenAI Integration Service connector. I’ve also shared some of work in the downloads that’s linked in the video description below including the use of core OpenAI APIs and the tiktoken APIs using Python. The video track covers the following: 00:00 - Intro 00:17 - PROLOGUE 03:52 - Connector Setup in Integration Service 05:09 - Using the OpenAI Connector in UiPath Studio 13:06 - Reading the GPT-3…

This post made by @Saahil08 received 2 likes!

Send exception mail once 3 retry from queue has been exhausted

I was searching for this solution but could not find it on forum so I have solved it and putting the solution. So we have use the transactionitem.retyno or we can assign transactionitem.retryno to retry number variable In process workflow in catch exception block we can use if condition and put like transactionitem.retryno>=3 in case if you have put max retry as 3 in queue this will solve the problem and once condition is satisfied you can send the exception mails to client

This post made by @andrei.lazar received 2 likes!

I want my Dark/Light themes back!

Hey everyone, Background We have recently switched over to using the Cloud Orchestrator and where we previously had two separate servers, one for DEV and one for PROD, we now have on Organization and the DEV/PROD split is done at Tenant level. I used to have a system, to instantly tell what instance of Orchestrator I am on, namely, the dark/white themes. I used one for DEV, and one for PROD. Life was beautiful! Now that we switched over, we have 12(I think) col…

Top 3 Most Liked Solutions

This solution provided by @Harshith_Adyanthaya received 2 likes!

Data table columns

Hi @A_Learner , Try this. dt1.columns(0).ColumnName = dt1.columns(0).ColumnName,Replace(" “,”") where 0 is a first column index. If you want to do for all then, Pull a for each and perform the following. [image] Hope it helps.

This solution provided by @Yoichi received 2 likes!

Need help to split list of dates into array based on character length

FYI, another expression: arrDateStr = Enumerable.Range(0,strData.Length \ 16).Select(Function(i) String.Join("",strData.Skip(i*16).Take(16))).ToArray() Regards,

This solution provided by @Harshith_Adyanthaya received 2 likes!

How to read multiple excel sheets

Hi @singh_sumit , Use Get workbook sheets activity. It will return all the Sheet names in List of String. You can then use for each to loop and read each sheet. [image] Try this. Hope it helps.

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 11 April 2023

Top 3 Topics with Most Views

How to add a space in a string? made by @Kumar_Sahu_Sameer with 51 views.

How to set or replace "check app state" so the studiox knows when to continue made by @marcin.chowaniec with 51 views.

Deleting empty rows made by @uiStijn with 45 views.

Top 3 Topics with Most Replies

How to set or replace "check app state" so the studiox knows when to continue made by @marcin.chowaniec with 21 replies.

I want click on Checkbox if the status is blank made by @Bhushan_Nagaonkar with 14 replies.

exception.Sourceをトライキャッチの中で使用してもファイルがみつかりませんでエラーとなる件 made by @yukiyuki with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@ppr made 20 posts!

@arjunshenoy made 17 posts!

Top 3 Most Liked Posts

This post made by @vishal.kp received 4 likes!

How to add a space in a string?

Hi @Kumar_Sahu_Sameer , Use the following expression system.Text.RegularExpressions.Regex.Replace(“APRIL2022”,“(?=\d{4})”," ") [image] Regards,

This post made by @zell12 received 3 likes!

UiPath Tutorial: OpenAI Integration Service Connector - Getting Started

Hi @AndyMenon, Thanks for sharing this content. It will definitely benefit users of this integration especially around practicing proper prompt engineering to conserve token usage. Although, looking at it in business automation angle leveraging UiPath, I believe single turn instructions with text completions (instructgpt/gpt3 models), that yields definite action paths from the workflow, would be most fitting for RPA use cases, as opposed to building conversational/chat based workflows. But stil…

This post made by @Pavanraj_Shetty received 3 likes!

How to close a particular tab in browser

Hi @tharaninatarajan1901 Try this [image] Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @Pavanraj_Shetty received 3 likes!

How to close a particular tab in browser

Hi @tharaninatarajan1901 Try this [image] Hope this might help you

This solution provided by @arjunshenoy received 2 likes!

How to convert string date to date

Hi @dhanu_lokhande If you are open to suggestions, here is another approach: DateTime.ParseExact(strValue2,"dd MMMM yyyy", Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy") Here, strValue2 = 22 september 2020 Output: [image] Hope this helps, Best Regards.

This solution provided by @Thong_Mai_Tr_ng_Hoang received 2 likes!

Unable to Install new version

Hi All, I have found a solution to my issue. I do not have the previous installer nor does the new installer help to remove the old product so i have to manually remove all the UiPath stuff from the computer. For anyone who might need it, I’ll put the solution below: Try finding the old Product Code you might have installed before (Usually in the MSI log file) (e.i. “{CA94574A-9591-4278-9269-0F5FB01F***}”) Open regedit and look for the same Remove all of it from the regedit Remove all the Ui…

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 12 April 2023

Top 3 Topics with Most Views

Why we need Codedworkflows.cs file made by @pravin_bindage with 73 views.

How can I save attachment directly out of email with a new name (e.g. date of email)? made by @aaydin with 54 views.

Acme test app Arrrggghh! Disappearing dropdowns! made by @charliefik with 51 views.

Top 3 Topics with Most Replies

Why we need Codedworkflows.cs file made by @pravin_bindage with 24 replies.

Delete Specific Sheet From workbook made by @sharu_priya with 19 replies.

Webscrapping made by @RAKESH_KUMAR_Tiwari with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 44 posts!

@Harshith_Adyanthaya made 30 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 3 likes!

New Use cases for Practising

Hey @raju_alakuntla , For practice purpose you can try Bots DNA there are almost 20 tasks with the Requirement video and the input files. https://www.botsdna.com/ Regards,

This post made by @sarathi125 received 3 likes!

Upgrade on premises orchestrator from 2020 to 2022 version on premises

@TUSHAR_DIWASE, Migrating an on-premises UiPath Orchestrator requires careful planning and execution to ensure a smooth transition. Here is a checklist of tasks you should consider before and during the migration process: Before Migration: Review the system requirements for the new version of UiPath Orchestrator to ensure compatibility with your infrastructure. Create a backup of your existing Orchestrator database and configuration settings. Review and document any customizations or integra…

This post made by @Harshith_Adyanthaya received 3 likes!

Specific name format of a file

Hi @marcin.chowaniec , Try this: “mydirectory"+Datetime.Now.Tostring(“dd.MM.yyyy”)+” name “+Datetime.Now.Tostring(“htt”)+”.xlsx" Output: mydirectory\22.02.2023 name 1PM

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 3 likes!

New Use cases for Practising

Hey @raju_alakuntla , For practice purpose you can try Bots DNA there are almost 20 tasks with the Requirement video and the input files. https://www.botsdna.com/ Regards,

This solution provided by @sarathi125 received 3 likes!

Upgrade on premises orchestrator from 2020 to 2022 version on premises

@TUSHAR_DIWASE, Migrating an on-premises UiPath Orchestrator requires careful planning and execution to ensure a smooth transition. Here is a checklist of tasks you should consider before and during the migration process: Before Migration: Review the system requirements for the new version of UiPath Orchestrator to ensure compatibility with your infrastructure. Create a backup of your existing Orchestrator database and configuration settings. Review and document any customizations or integra…

This solution provided by @Harshith_Adyanthaya received 3 likes!

Specific name format of a file

Hi @marcin.chowaniec , Try this: “mydirectory"+Datetime.Now.Tostring(“dd.MM.yyyy”)+” name “+Datetime.Now.Tostring(“htt”)+”.xlsx" Output: mydirectory\22.02.2023 name 1PM

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.

[system]

Daily Forum Report | 14 April 2023

Top 3 Topics with Most Views

Send email dynamically with attachments made by @RAKESH_KUMAR_Tiwari with 58 views.

Concatenate the string made by @Vrishchik with 44 views.

Can I trigger automations from my phone with UiPath Apps? made by @Luis_Fernando with 43 views.

Top 3 Topics with Most Replies

Send email dynamically with attachments made by @RAKESH_KUMAR_Tiwari with 27 replies.

Date format Change1 made by @Kuldeep_Pandey with 14 replies.

Opposite sing Excel made by @Kuldeep_Pandey with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@Yoichi made 30 posts!

@Kuldeep_Pandey made 17 posts!

Top 3 Most Liked Posts

This post made by @monika.singh received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi My name is Monika, Just started my journey as a RPA Developer. Glad to be a part of community.

This post made by @Anil_G received 2 likes!

How to replace row values of specific column in excel?

@Vaishnav_Tej Your replace function is correct…what you need to do is to perform this action in a for each row in datatable or for each excel row activities Inside ethat use curretrow("Column") = currentrow("Column").ToString.Replace("abc","") If abc is not constant then use regex as suggested by @arjunshenoy Cheers

This post made by @jack.chan received 2 likes!

Using VBA and file name excel variables

delete second assign in UiPath [image] then replace vba with this Sub Del_Rws(out_Str_input As String) Dim d As Object Dim a As Variant, b As Variant, itm As Variant Dim nc As Long, i As Long, k As Long Dim inputWb as Workbook Set inputWb = Workbooks.Open(out_Str_input) Dim fso As Object Set fso = VBA.CreateObject("Scripting.FileSystemObject") Dim fileName As String fileName = fso.GetFileName(out_Str_input) Sheet2.Range("A1:A1000").Formula = "='[" & fileName & "]PLHQ'!D20" Sheet2.Ran…

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 2 likes!

Using VBA and file name excel variables

delete second assign in UiPath [image] then replace vba with this Sub Del_Rws(out_Str_input As String) Dim d As Object Dim a As Variant, b As Variant, itm As Variant Dim nc As Long, i As Long, k As Long Dim inputWb as Workbook Set inputWb = Workbooks.Open(out_Str_input) Dim fso As Object Set fso = VBA.CreateObject("Scripting.FileSystemObject") Dim fileName As String fileName = fso.GetFileName(out_Str_input) Sheet2.Range("A1:A1000").Formula = "='[" & fileName & "]PLHQ'!D20" Sheet2.Ran…

This solution provided by @Yoichi received 1 likes!

Add elements from array to list

HI, Can you try to create instance of the list as the following. for example? [image] And it might be better to set scope Main. AppentCollection.zip (55.4 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Help with activites and sequence

@Ricchch Use get outlook mail message in the folder give the foler path like "Inbox\Business\Projects\Ananke" It has a filte rproperty where jet or dasl queries can be used Hope this helps Cheers

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.