Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 November 2022

Top 3 Topics with Most Views

Web勤怠システムにExcelシートのデータを転記したい。 made by @gorby with 42 views.

Interview Question: types of ways to add queue items made by @Vajrang with 39 views.

HOW TO CHECK CSV HAVE VALUE OR NOT made by @Kelvin1 with 38 views.

Top 3 Topics with Most Replies

Interview Question: types of ways to add queue items made by @Vajrang with 16 replies.

I Need To filter excel data column by using LINQ query made by @Ankit_Chauhan with 14 replies.

In extracted string, i am getting 4string variables which has value or empty.How to get string names whose value is empty made by @vnsatyasunil with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 29 posts!

@Nithinkrishna made 16 posts!

@supermanPunch made 16 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 4 likes!

Interview Question: types of ways to add queue items

Can anyone tell me how many ways we can add items to orchestrator queue?

This post made by @Gokul001 received 2 likes!

How can i create a business exception if an argument contains letters?

HI @andres.alvarez You can try with Throw activity AccountNumber.ToString.IsNumeric New BusinessRuleException("Your text here!!") [image] [image] Regards Gokul

This post made by @michaelyuen received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, I join the forum and expect to find solutions from the community, and share my insights if any.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

How can i create a business exception if an argument contains letters?

HI @andres.alvarez You can try with Throw activity AccountNumber.ToString.IsNumeric New BusinessRuleException("Your text here!!") [image] [image] Regards Gokul

This solution provided by @wilbardmtei received 1 likes!

Copy Excel Chart to Image | Error: 0x8002000B (DISP_E_BADINDEX)

I managed to get a VB.NET code [image] [image]

This solution provided by @TIRUMALA_RAO_GUDLA received 1 likes!

Interview Question: types of ways to add queue items

@Vajrang 1.Add queue item Create queue item with new state Will upload only one item 2.Bulk upload queue items Create queue item with new state Can upload multiple items We will be able to add references when there is a column name “reference” and update all uniqueids for every row. And references need not be unique if queue is not set for unique items 3.Add transaction item Create queue item with inprogress state Can upload only one item 4.Upload queue items directly from orchestra…

---

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 November 2022

Top 3 Topics with Most Views

Do you have any questions on Orchestrator ask it here made by @Vajrang with 54 views.

How to IF and Else activity use? made by @Alfred_Gan with 43 views.

Orchestrator trigger problem made by @Povilas_Jonikas with 37 views.

Top 3 Topics with Most Replies

Web上のデータを編集したい（データスクレイピングは利きませんでした） made by @miwa_yamamoto with 22 replies.

Value error made by @Ali_Mustafayev with 15 replies.

Reframe worK Initallsettings error made by @Immanuel_George with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 68 posts!

@ppr made 21 posts!

@Nithinkrishna made 20 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 2 likes!

How do i publish a marketplace component that works with both Legacy and Windows frameworks?

I too would be very interested in this. I played around with it last week and made my Visiual Studio project target both frameworks but it didnt result in a nuget package with both compatibilites. A quick knowledge resource on this would be great.

This post made by @Gokul001 received 2 likes!

Orchestrator trigger problem

Hi @Povilas_Jonikas Please follow the below steps 1.Tenant->Manage Access->Select your account->Edit->Robot Setup provide the following Domain/Username Win+R → TYPE whoami->copy the code and provide it in Domain/Username Credential store Orchestrator Database Password Your windows password Credential type Windows credentials Then click on save. Check out this tutorial Regards Gokul

This post made by @mjuriga received 1 likes!

Can't filter files with for each file in folder activity according to file's extensions

Another option is to simply leave the “Filter by” form field blank… or no filtering… or everything. Not every form needs to be filled. UiPath’s user interface can be very trying at times.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Get tenant name during runtime

Hey @jacchr Of course yes, using the odata/GetCurrentUser endpoint. Here is the sample attached - nmnithinkrishna_FindCurrentTenant.zip (2.4 KB) Hope this helps. Thanks #nK

This solution provided by @Gokul001 received 1 likes!

Orchestrator trigger problem

Hi @Povilas_Jonikas Go to Tenant → machine → Edit machine [image] [image] [image] Check do you have Production (Unattended) in it. Regards Gokul

This solution provided by @omer.ozturk received 1 likes!

Write Cell Activity adds an ' to my formular

Hi @bibalesecret, Maybe language difference can cause this. Please check this topic. Uipath add simple quotes on an excel formula Regards Ömer

---

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 November 2022

Top 3 Topics with Most Views

Rate UiPath On Gartner and get rewarded! ONLY 47 Gift cards left! made by @Dana_Mustatea with 50 views.

How to remove unwanted header in excel made by @Raja.G with 46 views.

Speed up queue trigger made by @J0ska with 43 views.

Top 3 Topics with Most Replies

Speed up queue trigger made by @J0ska with 24 replies.

Can not find “Add to dictionary" made by @gauthamRPA with 14 replies.

There is no option to choose connection on uipath made by @Kelvin1 with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 52 posts!

@Yoichi made 24 posts!

@Nithinkrishna made 18 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 2 likes!

Change DateTime Format from Various Inputs

Hi @sidb You can try with this expression DateTime.ParseExact(YourString,{"yyyy-dd-MM","MM/dd/yy","MM/dd-yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy") Regards Gokul

This post made by @Dana_Mustatea received 2 likes!

Rate UiPath On Gartner and get rewarded! ONLY 47 Gift cards left!

Share your experience with UiPath RPA on Gartner and get rewarded! Guidelines / Please read this carefully You can write your review here Deadline: Nov 15th Rewards: ONLY 47 Gift Cards Left – so hurry up to grab your 25USD Visa Gift Card Your gift card will be automatically issued by the Gartner team once your review gets approved

This post made by @Emira received 2 likes!

Speed up queue trigger

Hi @J0ska The default check interval is 30 minutes, and you’re right, the condition for instantly triggering a new job is a transaction with “New” status. Unprocessed transactions (including retried ones) need to wait for the 30 minutes interval. [image] Now for on premise Orchestrator, The “Queue.ProcessActivationSchedule” parameter can be used to adjust the default 30-minute check interval (with values between 0 and 59). This value is set within the “UiPath.Orchestrator.dll.config” file (y…

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Change DateTime Format from Various Inputs

Hi @sidb You can try with this expression DateTime.ParseExact(YourString,{"yyyy-dd-MM","MM/dd/yy","MM/dd-yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy") Regards Gokul

This solution provided by @Emira received 2 likes!

Speed up queue trigger

Hi @J0ska The default check interval is 30 minutes, and you’re right, the condition for instantly triggering a new job is a transaction with “New” status. Unprocessed transactions (including retried ones) need to wait for the 30 minutes interval. [image] Now for on premise Orchestrator, The “Queue.ProcessActivationSchedule” parameter can be used to adjust the default 30-minute check interval (with values between 0 and 59). This value is set within the “UiPath.Orchestrator.dll.config” file (y…

This solution provided by @Yoichi received 1 likes!

Web上のデータを編集したい（データスクレイピングは利きませんでした）

こんにちは 以下POST以下の内容を確認してみてください。基本的にはGetVisibleTextやNGetTextのNativeモード等で文字列と座標情報を取得して、それを利用すると良いかと思います。

---

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 | 05 November 2022

Top 3 Topics with Most Views

Delete empty rows in excel made by @Aregala_Yedukondalu with 31 views.

Excel operation on dynamic sheet name made by @Md_Saiful_Khaleque with 30 views.

待機アクティビティは無くなった？ made by @gorby with 28 views.

Top 3 Topics with Most Replies

Delete empty rows in excel made by @Aregala_Yedukondalu with 15 replies.

FTP Scope Activity - Folder getting copied instead of PDF files in the folder made by @Karunamurthy with 11 replies.

Connect Studio CE to Enterprise Orchestrator made by @Snowman with 9 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 21 posts!

@supermanPunch made 15 posts!

@Yoichi made 13 posts!

Top 3 Most Liked Posts

This post made by @adamrussell8ubs received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

I work as a management application developer. In Toulouse, I work for a computer services company. I’ve been looking into UiPath for almost a month at the request of a sales manager. I’d like to take possession of the tool. However, this requires extensive training. I am delighted to be a member of the UiPath community. I am a newbie to RPA. I’m hoping to find the knowledge I need in this forum to advance my knowledge of UiPath. Thanks.

This post made by @Gokul001 received 1 likes!

Update row item missing in Studio 2022.4.3

Hi @Javier_Kan Welcome to uipath community Try to update the Uipath.System.Activities and check it [image] [image] Regards Gokul

This post made by @Javier_Kan received 1 likes!

Update row item missing in Studio 2022.4.3

God bless you Gokul, You resolved my issue within minutes, now I can continue to code

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

Update row item missing in Studio 2022.4.3

Hi @Javier_Kan Welcome to uipath community Try to update the Uipath.System.Activities and check it [image] [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

Need help to understand timezone concept

Hi, Because this method is case sensitive. Regards,

This solution provided by @Joe_Matuch received 1 likes!

After Windows Conversion: "Unable to start execution: An item with the same key has already been added. Key: VisualBasicValue `1_1 "

SOLUTION! Took a while to dig into this, but I found that after converting a project from the Legacy framework to the Windows framework, it would not compile the Main.xaml any longer. Eventually, I found that the “VisualBasicValue1_1" key was being used for 2 different transitions. (In addition, "VisualBasicValue1_2” was also being used twice.) The new Windows framework did not like the fact that two transitions were being assigned the same key. (See below.) All I did to fix it was change one…

---

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 November 2022

Top 3 Topics with Most Views

Passed the UiARD! Wahoo! But now the 5 day wait for the badge begins made by @Wanaka_Digital with 41 views.

Invoke Code OutArgument made by @K_Morgan with 34 views.

[HELP] Invoke Powershell Error made by @KB9191 with 30 views.

Top 3 Topics with Most Replies

ScrapTable from PDF Image into Data table made by @MHarakeh with 10 replies.

Intermittent Click on Save As button works made by @ayeo22 with 9 replies.

Error while Opening Studio - object reference not set to an instance of an object made by @Pramod_Nannaka with 9 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 11 posts!

@Yoichi made 10 posts!

@Nithinkrishna made 10 posts!

Top 3 Most Liked Posts

This post made by @Aleem_Khan received 1 likes!

Can't filter files with for each file in folder activity according to file's extensions

You mean to say assign activity would be place in do section Can you share screenshot please appreciate Thanks in Advance

This post made by @sheelusplsubramanian received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone, I am Sheelaa and i was creating automation processes for a bank in Singapore. Currently I am looking for better opportunities I have a plan to appear for UiARD certification program. I have submitted my REFramework process in Practice REFramework academy. But i am yet to receive my grades and since it is pending i am unable to start my next process. What is the maximum time for receiving the grade?

This post made by @nahueldelacruz received 1 likes!

Exchange mail activities are missing - Studio 2022.10.3

Hi @Yoichi, thanks for your reply. You’re right! It seems there is a problem with Windows compatibility. I can use Windows-Legacy. it’s a pity I cannot convert my project to Windows-Legacy easily. Thanks for your help!

Top 3 Most Liked Solutions

This solution provided by @Konrad_Mierzwa received 1 likes!

Reading text file (part:bottom)

Hi This loop takes lines from bootom to top: [Capture]

This solution provided by @Yoichi received 1 likes!

How to extract Photo numbers into Notepad or Excel?

Hi, Can you try GetFileNameWithoutExtension method and AppendLine activity as the following? [image] Regards,

This solution provided by @Jon_Smith received 1 likes!

Should I go for RE Framework for my project?

This seems more like a linear process rather than a transactional process. A transactional process would be having a list of files to download and the process will iterate over that list and download each one (each file would be considered a transaction). You can just make a simple linear process for this and skip the REFramework if you aren’t familiar with how it works.

---

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 November 2022

Top 3 Topics with Most Views

Regex pattern to extract address from string made by @MasterOfLogic with 41 views.

Not able to click on a text made by @Kuldeep_Pandey with 41 views.

How to check titles existing in first name variable made by @srujana13a5 with 38 views.

Top 3 Topics with Most Replies

Not able to click on a text made by @Kuldeep_Pandey with 22 replies.

Datetime format in datatable made by @Kumar802 with 21 replies.

I am Unable Extract Data from Web Page made by @Relangi_Siva with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 85 posts!

@Yoichi made 29 posts!

@Nithinkrishna made 22 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 5 likes!

Monthly Forum rewards - October 2022

Congrats All ! Regards Sudharsan

This post made by @Gokul001 received 5 likes!

Monthly Forum rewards - October 2022

Congrats for all the winner Regards,

This post made by @Rahul_Unnikrishnan received 3 likes!

Monthly Forum rewards - October 2022

Congratulations

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

Verify the Difference between two dates

Check out this XAML file @shruthi_arali Main.xaml (6.6 KB) [image]

This solution provided by @Cristian_Bardas received 1 likes!

Array of Strings - How to stipulate when you are on the last one

Use if index = splitpages.count -1 to figure out if you are on the last array element.

This solution provided by @Gokul_Jayakumar received 1 likes!

Data not getting extracted

Hello @Harish_R1 You have to select the correct indicator of correlated data. Try to indicate at middle of the page, Maybe the 1st-row of data in the website occurs advertisement. Kindly refer to the attached XAML file, You may get some Idea Main.xaml (40.2 KB) [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 | 08 November 2022

Top 3 Topics with Most Views

Document Understanding Process 22.10 now in General Availability! made by @Sergiu.Wittenberger with 222 views.

Get specified text from String made by @prerna.gupta with 65 views.

How to Iterate through Data column value in for each activity? made by @Vidhi_Patel with 53 views.

Top 3 Topics with Most Replies

Get specified text from String made by @prerna.gupta with 54 replies.

How to convert csv file to dictionary in uipath made by @Monali_Vekariya with 25 replies.

Total number of rows made by @Cuberoot with 22 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 87 posts!

@Anil_G made 47 posts!

@Tapan_Behera1 made 28 posts!

Top 3 Most Liked Posts

This post made by @Sergiu.Wittenberger received 6 likes!

Document Understanding Process 22.10 now in General Availability!

Hello everyone! We are very excited to announce the General Availability release of the Document Understanding Process version 22.10! It can be downloaded from the Official template feed. To get started, simply create a new project in UiPath Studio and select it. [711fcd2-DU_Process_1] [ccad7f6-DU_Process_2] [1e319d5-DU_Process_3] We recommend to carefully read the enclosed User Guide, even if you’re already familiar with the solution. The latest guide…

This post made by @muhamed_fasil received 3 likes!

Monthly Forum rewards - October 2022

Congrats to all the winners

This post made by @StefanSchnell received 3 likes!

Monthly Forum rewards - October 2022

Congratulations to all the winners and thank you for your effort.

Top 3 Most Liked Solutions

This solution provided by @Gokul_Jayakumar received 1 likes!

Get Dynamic DateTime Format

@Rawan.md Try this DATEVAR=DateTime.ParseExact("2022-04-29 12:00:13 م","yyyy-MM-dd hh:mm:ss t",System.Globalization.CultureInfo.GetCultureInfo("ar")) Where, DATEVAR is variable type of syste.DateTime [image] PM [image] AM [image] You can convert it to desired string as DATEVAR.tostring(“yyyy-MM-dd”)

This solution provided by @GT_Ropa received 1 likes!

インデックスおよび長さは文字列内の場所を参照しなければなりません

お疲れ様です。 100%ではないですが、このエラーの元は多分Substringからきます。Substring(1,1)は二つ目の文字を取ります。最初の1は0に変えてみてください。 右辺：元dt.AsEnumerable.GroupBy(Function(r) r(“重複検索列タイトル”).ToString).Select(Function(g) 元dt.Clone.LoadDataRow(g.OrderBy(Function(r) r(“dt左端列タイトル”).ToString.Substring(0,1)).First().ItemArray,False)).CopyToDataTable よろしくお願いいたします。

This solution provided by @Dawodm received 1 likes!

How to Add String Variable values(scrapped values) from for each Datatable loop can be added as colmnn of datatable?

Hi @Vidhi_Patel You can use add DataRow activity inside your loop. Then you can use the variable of the loop (e.g. CurrentRow) and the name of the table you want to store in. These are to be added to the activity: Add Data Row

---

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 November 2022

Top 3 Topics with Most Views

How to extract required data from text file which has duplicate values? made by @Reddy_1 with 45 views.

How to implement if condition in this activity? made by @wally.cariaga with 44 views.

Type Into or Set Text for Calender are not working? what is the solution made by @taruna.mehra with 39 views.

Top 3 Topics with Most Replies

How to implement if condition in this activity? made by @wally.cariaga with 40 replies.

Try Catch a miss "click activity" made by @hubert_leleu with 22 replies.

Type Into or Set Text for Calender are not working? what is the solution made by @taruna.mehra with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 104 posts!

@Gokul001 made 77 posts!

@postwick made 29 posts!

Top 3 Most Liked Posts

This post made by @loredana_ifrim received 2 likes!

Join Automation Education Summit 2022

It’s time for Automation Education Summit 2022 UiPath Community, in partnership with our Academic Alliance team, are happy to announce the launch of Automation Education Summit 2022, where we will gather educators and trainers from our academic alliances and partners, with the intention to develop them further as a robust community of educators in automation. Here are the details of the Summit: Date: 16-18 Nov Region: AMER - EMEA - APJ …

This post made by @Marek_Szwarczewski received 2 likes!

Invoke Workflow error after migartion from Windows_Legacy to Windows

Thank you @Yoichi ! It is worked. I will never think about edit the xaml file in text editor. I need increase my search skills as I didn’t find the topic you show me. Thank again!

This post made by @MinalGupta received 1 likes!

Document Understanding Process 22.10 now in General Availability!

@Steven_McKeering … You will still need to buy AI units. DU Framework is more like REFramework , buts its a standard framework to implement DU use cases.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Unable to use click after reusability component

Hi @Mohamed_Haseeb This is the activity create a variable for out element just go to out element and click ctrl+k and write the variable name [image] Assign hat variable to a output argument. you can create arguments from arguments at the bottom. assign out to it [image] happy Automation.

This solution provided by @Yoichi received 1 likes!

Invoke Workflow error after migartion from Windows_Legacy to Windows

Hi, We need to modify xaml file to remove key duplicate VisualBasicValue`1_1 using text editor. Please see the following post in details. Regards,

This solution provided by @William_Blech_Sister received 1 likes!

Workflow Name

Hello @Nath_Abrao , welcome to the UiPath Community!! You can try two ways: Use this custom package: Alphabet Workflow Activities - RPA Component | UiPath Marketplace Try the workflow activities You can also log the start and the end of the workflow with this option in the Invoke Workflow Activity [image] Any questions please let me know

---

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 November 2022

Top 3 Topics with Most Views

StudioXで変数の型変換 made by @11159 with 40 views.

Background process: Is it possible to refresh an excel worksheet table that is connected to sharepoint? made by @davidgoderre with 39 views.

How do I identify duplicate values in an Excel column? made by @jijorhohim98 with 38 views.

Top 3 Topics with Most Replies

How to click button based on text matching in list made by @vnsatyasunil with 31 replies.

Illegal characters in path in write range activity made by @naveenkumarr with 24 replies.

In csv file there are some missing data of employee in that i have to paste the header in the place of blank data made by @purvika_jethwa with 23 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 106 posts!

@Anil_G made 103 posts!

@sangeethaneelavannan1 made 33 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 2 likes!

FilePath

HI @zhasmina.dimitrova Updated the expression to get the excel files also inside the folder Directory.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder.UserProfile)+"\Downloads\","*.xlsx") Regards Gokul

This post made by @Anil_G received 2 likes!

Illegal characters in path in write range activity

Hi @naveenkumarr Did you give double quotes in your asset? If yes then that is the issue. You should not give…Directly give the path cheers

This post made by @Gokul001 received 2 likes!

What is the filter expression for get exchange mails

Hi @sathish_Kumar6 For Date check out this expression DateTime.ParseExact(StringInput.ToString,"ddd, dd MMM yyy HH:mm:ss K",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy hh:mm:ss") [image] Check out the tutorial Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Illegal characters in path in write range activity

Hi @naveenkumarr Did you give double quotes in your asset? If yes then that is the issue. You should not give…Directly give the path cheers

This solution provided by @ppr received 2 likes!

Delete items from a list

[grafik] List1Var.Except(ArrayVar2).toList

This solution provided by @Gokul001 received 1 likes!

UIDemo.exe username password

HI @Akbar_Badhusa The username is admin and password is password. Regards Gokul

---

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 November 2022

Top 3 Topics with Most Views

Read PDF FILE and get text made by @Kuldeep_Pandey with 47 views.

How can i compare two excel files? made by @aparna30 with 43 views.

How to get the numer out of this picture made by @alirida.alhalass with 38 views.

Top 3 Topics with Most Replies

Read PDF FILE and get text made by @Kuldeep_Pandey with 24 replies.

[StudioX]から[Studio]へのプロファイル切り替え方法 made by @yuai with 19 replies.

How to filter duplicate emails made by @Milo_Soderberg with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 82 posts!

@Anil_G made 53 posts!

@Yoichi made 48 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Insert a character in a string

Hi, Can you try the following expression? Double.Parse(yourString).ToString("#.00") [image] Regards,

This post made by @Yoichi received 2 likes!

File missing in nuget file after publish

HI, The above image shows RestSharp106.6.10 or higher is missing. Unfortunately, in some version of UiPath installer lacks necessary RestSharp package in the installer. So we need to add it and its dependcies package to Orchestrator or machine which robot works. Or as another lazy approach, if it works dev environment, can you try to copy all the folders %USERPROFILE%.nuget\packages to same place of machine which robot works. Regards,

This post made by @Tejaa received 1 likes!

Monthly Forum rewards - October 2022

Congratulations all! Filled out the form, don’t think I am eligible for the certification discount voucher but still would love to receive one. Even for the associate exam.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Insert a character in a string

Hi, Can you try the following expression? Double.Parse(yourString).ToString("#.00") [image] Regards,

This solution provided by @Yoichi received 1 likes!

Execute an action if len of a string in browser is more than 1

Hi, I think we can use GetText activity with proper selector. Probably we can use colName attribute. So can you try to use UiExplorer then indicate target cell? Or, as another approach, it’s also good to use DataScraping. Regards,

This solution provided by @Yoichi received 1 likes!

How to split excel row

HI, Hope the following sample helps you. LINQ case [image] dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r("Employee ID").ToString,System.Text.RegularExpressions.Regex.Match(r("Employee ID").ToString,"\S+$").Value},False)).CopyToDataTable() ForEachRow case [image] System.Text.RegularExpressions.Regex.Match(CurrentRow("Employee ID").ToString,"\S+$").Value Sample20221111-3.zip (10.4 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 | 12 November 2022

Top 3 Topics with Most Views

Could not start executor. The referenced account is currently locked out and may not be logged on to. (0x80070775) made by @jrp with 28 views.

Set of Rules required for Workflow Analyzer made by @Akhil_Raveendran with 27 views.

How to proceed further if there are 3 possible result for one action? made by @Karthikeyan_CS with 27 views.

Top 3 Topics with Most Replies

Could not start executor. The referenced account is currently locked out and may not be logged on to. (0x80070775) made by @jrp with 13 replies.

Choosing a date from a calendar by reading an image made by @Ilan_Edri with 5 replies.

Selecting Items in a List of a special application named "OKNA2000" made by @Dominic_Roggen with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@MHarakeh made 10 posts!

@jrp made 6 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

How to merge three data tables?

Hi, I think ForEach mitigates your problem. How about the following? [image] OR the following LINQ expression might help you. dtResult = {dt1,dt2,dt3}.SelectMany(Function(d) d.AsEnumerable.Select(Function(r) d.Clone.LoadDataRow({r(0)},False))).CopyToDataTable() Regards,

This post made by @Anil_G received 1 likes!

How to get item.Headers.Item("In-Reply-To").ToString in get mail Microsoft 365

Hi @sathish_Kumar6 So …you want to know if a message is replied or not… there is no direct way but you can try this… from get mails once you get your inbox …and getting the mail you can get the unique id of the mail and then use get mail from sent items and then match the id for this your in-reply-to in header will help to match.thats not straight but give it a try Cheers

This post made by @Sudharsan_Ka received 1 likes!

別プロセスからプレビューを保持したままのコピペ方法

Hi @yuai If you need the image you can see those in the folder .screenshots so while you copy the activities from one workflow to another you can copy the screenshots in the .screenshots folder too to the new project after copying them to new flow click on refresh button in the project panel and then you can see the screenshots in new project too Note : the thing is 1 you need to copy the whole screenshots of one project to another because you don’t know what is screenshot name assigned to th…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to merge three data tables?

Hi, I think ForEach mitigates your problem. How about the following? [image] OR the following LINQ expression might help you. dtResult = {dt1,dt2,dt3}.SelectMany(Function(d) d.AsEnumerable.Select(Function(r) d.Clone.LoadDataRow({r(0)},False))).CopyToDataTable() Regards,

This solution provided by @cheez_RPA received 1 likes!

別プロセスからプレビューを保持したままのコピペ方法

元のワークフローが含まれるプロジェクトフォルダにある .screenshots フォルダを、そのまま貼り付け先のワークフローが含まれるプロジェクトフォルダに上書きしてください。 補足すると、アクティビティに表示されているプレビューは、アクティビティ自体に保存されているわけではなく、そのワークフローが保存されているプロジェクトの .screenshots フォルダに保存されており、アクティビティはそのフォルダにある画像を、画像のファイル名を指定して読み込むようになっています。 そのため、アクティビティのみをコピー・貼り付けした場合は画像が移動されていないため、プレビューが利用できないということになります。

---

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 | 13 November 2022

Top 3 Topics with Most Views

Donwload files from AP made by @ALI_TONGA with 33 views.

Data Table type into google form made by @Allyson_Ang with 31 views.

Phần mềm hack tài xỉu vốn 10tr húp 136tr made by @manhduc_hoang with 30 views.

Top 3 Topics with Most Replies

Add timestamp and then file extension (xlsx) to a file and move to the archive Folder made by @Sisay_Dinku with 13 replies.

Data Table type into google form made by @Allyson_Ang with 12 replies.

ワークフローTOPレベルのフローチャートの周りのシーケンスが削除できない made by @gorby with 8 replies.

Top 3 Users Who Posted The Most

@sangeethaneelavannan1 made 14 posts!

@Yoichi made 11 posts!

@Sisay_Dinku made 9 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 2 likes!

Loop all the Excel Sheet and Process

Hello @jaffer_sadiq You can use the below acitivty. For Each Excel Sheet [image] Thanks

This post made by @sangeethaneelavannan1 received 2 likes!

Loop all the Excel Sheet and Process

@jaffer_sadiq ,You could use for each excel sheet activity to read each excel sheet in workbook

This post made by @arivu96 received 1 likes!

Monthly Forum rewards - October 2022

Congratulations to all the winners

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to use group by and if activities together with linq?

Hi, Can you try the following expression? [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("MailUID").ToString()).SelectMany(Function(g) g.Where(Function(r,i) r("Status").ToString.Trim<>"Success" OrElse (i=0 AndAlso g.All(Function(r2) r2("Status").ToString.Trim="Success")))).CopyToDataTable() Sample220221113-2L.zip (2.9 KB) Regards,

This solution provided by @private_matter received 1 likes!

Cannot indicate button elements with strict selector

@Anil_G That still won’t work because checking the pending state will also need an identifier as there could be several pending buttons before which case we are looping through the exact same issue of the connect button. But forget it as I’ve come up with a clever solution that will solve both issues, whether the connect button disappears or does not disappear. What needs to be done is to use an idx=‘default variable(1)’, and upon clicking on the send button, I’ll add a check app state to chec…

---

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 November 2022

Top 3 Topics with Most Views

Trouble in Append Range made by @Kelvin1 with 37 views.

Could not start executor made by @Ranganathan_M with 37 views.

パッケージを管理に「UiPath.SAP.BAPI.Activities.2.2.5」が表示されない made by @hiromi.akita with 36 views.

Top 3 Topics with Most Replies

Trouble in Append Range made by @Kelvin1 with 25 replies.

Creating folder made by @Kuldeep_Pandey with 22 replies.

Unable to allocate developer license to tenant made by @venkat4u with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 96 posts!

@Yoichi made 41 posts!

@Anil_G made 36 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 2 likes!

Adding only the last 5 rows of datatable to queue

Hi @idil.konca Before writing into the Output value, You keep the column name has a template and append the output value in that excel. After that use LINQ expression to take last 5 record from the excel. Regards Gokul

This post made by @GT_Ropa received 2 likes!

Unable to allocate developer license to tenant

When working with more than one tenant and allocating licenses you will see all of the licenses available for allocation. If there is zero, it will simply say that zero licenses are available: [image]

This post made by @ppr received 2 likes!

Regex expression for a String

to complete the series: [grafik] as * means 0 or unlimited it will also match CHG without numbers

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Adding only the last 5 rows of datatable to queue

Hi @idil.konca Before writing into the Output value, You keep the column name has a template and append the output value in that excel. After that use LINQ expression to take last 5 record from the excel. Regards Gokul

This solution provided by @ppr received 2 likes!

Regex expression for a String

to complete the series: [grafik] as * means 0 or unlimited it will also match CHG without numbers

This solution provided by @Gokul001 received 1 likes!

How to grouping data in excel and generate new file by each group?

Hi @lovepong66 How about this expression (From d In DtBuild.AsEnumerable Group d By k=d("code").toString.Trim Into grp = Group Let ra = New Object(){k,grp.First()(1),grp.First()(2)} Select r = DtClone.Rows.Add(ra)).CopyToDataTable Check out the XAML file GroupGeneratedExcelfiles.xaml (12.5 KB) [image] Note : Kindly update the Column Names Regards Gokul

---

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 | 15 November 2022

Top 3 Topics with Most Views

How to calculate a particular datacolumn sum using datatable or structured format? made by @Vidhi_Patel with 52 views.

Re-Run program if any error made by @Kelvin1 with 44 views.

I want to apply regex exp made by @Kuldeep_Pandey with 36 views.

Top 3 Topics with Most Replies

I want to apply regex exp made by @Kuldeep_Pandey with 28 replies.

Error while deploying a package in orchestrator made by @Cuberoot with 22 replies.

How to calculate a particular datacolumn sum using datatable or structured format? made by @Vidhi_Patel with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 117 posts!

@Gokul001 made 98 posts!

@sangeethaneelavannan1 made 36 posts!

Top 3 Most Liked Posts

This post made by @Yushi.E received 2 likes!

"配列Aに配列Bが含まれるとき"をどう表せばいいか？

ありがとうございます！ 解決できました！

This post made by @Yoichi received 2 likes!

"配列Aに配列Bが含まれるとき"をどう表せばいいか？

こんにちは 今回は、【配列A】の中に【配列B】がすべて含まれているかどうかを判定したいと考えています。 arrC = arrB.Except(arrA).ToArray として、arrCが空（要素数が0）であれば、すべて含まれています。 arrC.Length =0

This post made by @yosuke1 received 2 likes!

繰り返し（フォルダ内の各ファイル）のアクティビティでの＊使用

皆様 無事に解決致しました！！ ありがとうございました<m(__)m> [image]

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How to get Amount and do total with from the following text?

HI @Vidhi_Patel Check Out this Updated XAML file with Sum the Amount RegexReplace.xaml (8.0 KB) [image] Regards Gokul

This solution provided by @Gokul001 received 1 likes!

How to calculate a particular datacolumn sum using datatable or structured format?

HI @Vidhi_Patel How about this expression (From d in dtData.AsEnumerable Where Not (isNothing(d(2)) OrElse String.IsNullorEmpty(d(2).toString.Trim)) Select v = CDbl(d(2).toString.Trim)).Sum(Function (x) x) Regards Gokul

This solution provided by @Yoichi received 1 likes!

Change Month format to Indonesia

HI, Can you try the following expression? Datetime.ParseExact("May 2022", "MMM yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MMM yyyy",New System.Globalization.CultureInfo("id-ID")) 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 | 16 November 2022

Top 3 Topics with Most Views

Orchestrator unable to click the unattended robot made by @g_ii with 47 views.

Is there any limit in passing values for Add DataRow activity? made by @Soundarya_Guduri with 41 views.

How to find icon in webpage and get related details? made by @Keerthana_Udayakumar with 37 views.

Top 3 Topics with Most Replies

How to move below cell row value to above cell in particular column excel made by @Raja.G with 23 replies.

Orchestrator unable to click the unattended robot made by @g_ii with 23 replies.

Get text from each column in DataTable made by @Alexander_Ward with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 53 posts!

@Anil_G made 46 posts!

@sangeethaneelavannan1 made 33 posts!

Top 3 Most Liked Posts

This post made by @Sidney_Vogel received 2 likes!

State machines VS Sequences VS Flowchart

Hi all, I have a question in regards to this UIPath DUMP question I came across on the internet. Why is the answer for this question “State Machine” instead of Sequence, as I understand State machines is for more complex automations. I would have selected Sequence as the answer. You need to collect employees data and send it by email as an Excel file. What type of workflow is the most suitable for the final part, which adds the file attachment, formats the email, and sends it? Sequence Flo…

This post made by @Vidhi_Patel received 2 likes!

How to get Amount and do total with from the following text?

Greatful for this tutorial references of tutorial and another suggested post are cool as well thanks for sharing this, Happy automation!

This post made by @postwick received 2 likes!

How to use Arguments in the Ui path studio?

You should do all the free training on the UiPath Academy site.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How can i empty data by reference by sheet name?

Hi @lovepong66 You can try with Delete Range activity In the Range try with this expression "A2:"+UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DtRead.Columns.Count)+(DtRead.Rows.Count+1).ToString Check out this XAML file DeleteRange.xaml (6.7 KB) [image] Regards Gokul

This solution provided by @tarau_bianca received 1 likes!

"An item with the same key has already been added" error on "Test Activity" action

Hi! I checked and there are no double values. But meanwhile I have found the solution! I put the activity in a sequence container and it worked. When I chose the “Test Activity” option for the whole sequence, it worked. I am not sure why, but It did. Thank you anyway for you suggestions!

This solution provided by @Gokul001 received 1 likes!

Arithmetic operation problem

HI @Shoebmd Check out this XAML file Arithmeticoperation.xaml (5.7 KB) [image] Regards Gokul

---

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 | 17 November 2022

Top 3 Topics with Most Views

Bug report: Simulate Click in Java programs doesn't finish if a modal window is shown made by @ptrobot with 38 views.

How to split one text file into multiple text files according to text content? made by @jeleona.foo with 33 views.

How to convert string to time and compare with current time? made by @lovepong66 with 32 views.

Top 3 Topics with Most Replies

How to change a sheet name in modern experience made by @Juandix with 26 replies.

How to split one text file into multiple text files according to text content? made by @jeleona.foo with 22 replies.

Type error made by @Kuldeep_Pandey with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 56 posts!

@postwick made 53 posts!

@Yoichi made 45 posts!

Top 3 Most Liked Posts

This post made by @postwick received 3 likes!

How to deal with data in excel

https://forum.uipath.com/search?q=large%20excel%20file

This post made by @sangeethaneelavannan1 received 3 likes!

How to convert multiple line string to single line string?

Try this: input = input.Replace(vbLf, “”).Replace(vbCr, “”)

This post made by @ppr received 2 likes!

How to convert string to time and compare with current time?

[grafik] Now.TimeOfDay >= Cdate("09:00").TimeOfDay And Now.TimeOfDay <= Cdate("15:30").TimeOfDay As well agreed to use Timespan as we can reduce the code chars [grafik] Now.TimeOfDay >= Timespan.Parse("09:00") And Now.TimeOfDay <= Timespan.Parse("15:30")

Top 3 Most Liked Solutions

This solution provided by @postwick received 3 likes!

How to deal with data in excel

https://forum.uipath.com/search?q=large%20excel%20file

This solution provided by @sangeethaneelavannan1 received 3 likes!

How to convert multiple line string to single line string?

Try this: input = input.Replace(vbLf, “”).Replace(vbCr, “”)

This solution provided by @ppr received 2 likes!

How to convert string to time and compare with current time?

[grafik] Now.TimeOfDay >= Cdate("09:00").TimeOfDay And Now.TimeOfDay <= Cdate("15:30").TimeOfDay As well agreed to use Timespan as we can reduce the code chars [grafik] Now.TimeOfDay >= Timespan.Parse("09:00") And Now.TimeOfDay <= Timespan.Parse("15:30")

---

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 | 18 November 2022

Top 3 Topics with Most Views

Selector not available after conversion to windows made by @MateuszSzatkowski with 46 views.

Getting an error message while working with uipath made by @Rashmika_Barathan with 39 views.

Windows Legacy -> Windows: Error when compiling: Vale cannot be null. (Parameter 'key') made by @PeCour with 35 views.

Top 3 Topics with Most Replies

Orchestratorでマシンの入れ替えができない made by @jasano with 21 replies.

How to start automation made by @Nur_Amin with 19 replies.

Error getting latest file downloaded c# made by @javierdavidh with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 58 posts!

@Yoichi made 42 posts!

@Gokul001 made 28 posts!

Top 3 Most Liked Posts

This post made by @Sanjeevi received 3 likes!

Join Data Tables - Cheat Sheet

[Join DataTable]

This post made by @Yoichi received 3 likes!

Get Date of First thrusday of specific month

HI, The following expression helps you. Enumerable.Range(1,7).Select(Function(i) New DateTime(2022,2,i)).Where(Function(d) d.DayOfWeek = DayOfWeek.Thursday).Single() OR Enumerable.Range(1,7).Select(Function(i) New DateTime(2022,2,i)).Where(Function(d) d.DayOfWeek = DayOfWeek.Thursday).Single().ToString() Please modify 2022 and 2 to required year and month. Regards,

This post made by @jeevith received 3 likes!

Windows Legacy -> Windows: Error when compiling: Vale cannot be null. (Parameter 'key')

Hi @PeCour @Anil_G and @Gokul001 Windows version of projects do not look stable to me in the last two releases (2022.4.X and 2022.10.X) The error you are getting might also be that in one or other xaml file you have one of the following write to csv, read text file, write to text file, add to collection, get asset, read csv activities. These are my observations so I cannot say this is the same in your case @PeCour Many activities have been impacted. It’s a double whammy. Windows .net 6 activi…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 3 likes!

Windows Legacy -> Windows: Error when compiling: Vale cannot be null. (Parameter 'key')

Hi @PeCour @Anil_G and @Gokul001 Windows version of projects do not look stable to me in the last two releases (2022.4.X and 2022.10.X) The error you are getting might also be that in one or other xaml file you have one of the following write to csv, read text file, write to text file, add to collection, get asset, read csv activities. These are my observations so I cannot say this is the same in your case @PeCour Many activities have been impacted. It’s a double whammy. Windows .net 6 activi…

This solution provided by @Yoichi received 1 likes!

Get Date of First thrusday of specific month

Hi, Enumerable.Range(1,7) returns numbers from 1 to 7. Then, Select(Function(i) New DateTime(2022,2,i)) returns dates from 2022 Feb 1 to 2022 Feb 7 because i is applied from 1 to 7. Next, Where(Function(d) d.DayOfWeek = DayOfWeek.Thursday) filters the above dates whether Thursday. Remaining is what you need. (As return type of Where method is IEnumerable<DatatIme>, we need to extract one result using Single method.) Hope this helps you. Regards,

This solution provided by @Anil_G received 1 likes!

Unable to search text on web Ui

Hi @Riya_Bansal In your activities panel…click on filter icon on top…select show classic then you should be able to see Alternate activities for these in latest version are check app state and get text…change the scapping method…to make it work as get visible text 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 | 19 November 2022

Top 3 Topics with Most Views

How to Copy a DataTable? made by @Sanjeevi with 46 views.

Iterating radio buttons made by @philwaller with 43 views.

Open File that contains the specific name made by @lq_c with 37 views.

Top 3 Topics with Most Replies

How to Sum all the values in multiple column index using LINQ made by @Sidney_Vogel with 9 replies.

Input data given in excel need to get the total quantity made by @VB_Chel with 9 replies.

How to count variable starting from 01,02 ..... 10 and so on made by @enthusiastic with 8 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 31 posts!

@Yoichi made 18 posts!

@Rahul_Unnikrishnan made 8 posts!

Top 3 Most Liked Posts

This post made by @Sanjeevi received 2 likes!

How to Copy a DataTable?

There are two ways you can copy a DataTable with structure and data to another DataTable. You can copy a DataTable to another DataTable using Filter Data Table activity. You can add Source DataTable in the Input DataTable section and the Destination DataTable in the Filtered DataTable section. You can leave the Filter Rows and Output Columns values as it is. [Filter Data Table] You can use DataTable.Copy method in an Assign activity. [Assign Activity Copy] DataTable.Clone Method If y…

This post made by @Yoichi received 2 likes!

How to Sum all the values in multiple column index using LINQ

Hi, If you need sum value of specific column, the following help you. dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(4).ToString)) The above returns sum value of 4th column of the datatable (0-base index) Regards,

This post made by @Sidney_Vogel received 1 likes!

How to Sum all the values in multiple column index using LINQ

@Yoichi you are a genius, this worked perfectly, thank you so much for this, this is great. Is there a way to only get the value, instead of an array? I guess could add (indexnumber) at the end of the array, like this: Enumerable.Range(dt.Columns.Count-5,5).Select(Function(i) dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(i).ToString))).ToArray()(1) But is there another way to get just the individual sum of the column and not an array?

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to Sum all the values in multiple column index using LINQ

Hi, If you need sum value of specific column, the following help you. dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(4).ToString)) The above returns sum value of 4th column of the datatable (0-base index) Regards,

This solution provided by @sangeethaneelavannan1 received 1 likes!

Is OCR of Uipath free?

@Nitiwat_Chunprapanusorn Please download the below package from manage package window and it is free [image] The UiPath Document OCR activity is optimized for usage on scanned documents and images of documents. The UiPath Screen OCR activity is optimized for the usage on-screen images.

This solution provided by @Gokul001 received 1 likes!

This message appears after I changed from Legacy to Windows compatibility

HI @Larry_Anthony_Jacobo_Zar1 Welcome to uipath community It may be the Double Quotation issue " Try to Re enter the expression again String.Join(Environment.NewLine,(From r In dt_AgrupacionAConciliar Select r.item("Nº documento"))) Check out this thread Regards Gokul

---

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 | 20 November 2022

Top 3 Topics with Most Views

Uipath DataTable (Unable to get data) made by @PHS_BE with 35 views.

FInd and click text made by @Carlton_Morrissey with 33 views.

How to get exact color name of excel cell? made by @Vaishnav_Tej with 32 views.

Top 3 Topics with Most Replies

FInd and click text made by @Carlton_Morrissey with 18 replies.

How to get output as unique rows by comparing two columns using LINQ query made by @chanbhasha.p with 8 replies.

How to get exact color name of excel cell? made by @Vaishnav_Tej with 8 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 14 posts!

@Anil_G made 14 posts!

@Carlton_Morrissey made 10 posts!

Top 3 Most Liked Posts

This post made by @marian.platonov received 2 likes!

Chrome migration to MV3 extension

Supported versions with Chrome MV3: 2020.10.14 + 2021.10.8 + 2022.4.4 + 2019.10.9 is out of Support completely.

This post made by @marian.platonov received 2 likes!

Chrome migration to MV3 extension

The needed installer can be found here https://download.uipath.com/versions/21.10.9/UiPathStudio.msi

This post made by @Kalaisri_K received 1 likes!

Add Queue Item Activity

Thank you for your swift solution and perfectly worked.

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

Chrome migration to MV3 extension

Supported versions with Chrome MV3: 2020.10.14 + 2021.10.8 + 2022.4.4 + 2019.10.9 is out of Support completely.

---

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 | 21 November 2022

Top 3 Topics with Most Views

How to make uiPath program run bit fast made by @Riya_Bansal with 50 views.

How to create custom log made by @Kelvin1 with 45 views.

Simulate Type Not working In Browser made by @srinivasanma1 with 37 views.

Top 3 Topics with Most Replies

How to exclude the middle name (alphabet) and split the full name as 'First Name' and 'Last Name' on separate columns made by @Sisay_Dinku with 24 replies.

How to use regex that checks or compare the output if that words are the same in the file? made by @wally.cariaga with 17 replies.

1データの各項目を配列に追加 made by @r.nakanishi with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 94 posts!

@Yoichi made 42 posts!

@Rahul_Unnikrishnan made 15 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 2 likes!

Levenshtein distance - 가장 비슷한 텍스트 찾기

미리 정해진 텍스트 집합 안에서 주어진 텍스트와 일치하는 (또는 가장 유사한) 텍스트를 찾아야 하는 경우가 있습니다. 진료비영수증을 예로 들자면, 영수증의 항목명들을 OCR 기술로 추출한 경우 오인식/미인식이 존재하더라도 가장 유사한 항목명을 찾아야 해당 금액을 그 항목의 지출로 인식할 수 있을 겁니다. 두 텍스트의 유사도를 측정하기 위하여 Levenshtein distance를 사용할 수 있습니다. Levenshtein distance를 계산하는 원리는 이 포스팅에서 쉽게 설명하고 있으니 참고하시기 바랍니다. 한글의 경우 자소 단위로 비교하면 좀 더 세밀하게 유사도를 측정할 수 있고, 대량의 텍스트를 비교하는 경우 수행 시간을 단축하기 위하여 short-circuiting(기존의 최소 거리보다 커지면 계산을 중단함)을 도입한 python 코드를 아래에 공개해 두었습니다. Python 코드 안에 주석으로도 명시하였지만, 기본 구현은 이 포스팅을 참고하였고 short-circu…

This post made by @Gokul001 received 2 likes!

Read Range: Picture names cannot contain any of the following characters: :\/?*[]

Hi @hurmet.noka Can you try with excel application scope read range activity Regards Gokul

This post made by @Sergiu.Wittenberger received 1 likes!

Document Understanding Process 22.10 now in General Availability!

I have wo updates to share: Regarding the Taxonomy Manager issue, if you have it, roll back to 22.10.1 - it’s an issue with Studio and a fix is actively being worked on. And yes, you need to have .net5 / 6 installed. We have also encountered a small bug in one of our arguments in Main - ActionCenter.xaml and fixed it (In_TargetFile was of type “Out” instead of “In”)

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Read Range: Picture names cannot contain any of the following characters: :\/?*[]

Hi @hurmet.noka Can you try with excel application scope read range activity Regards Gokul

This solution provided by @Yoichi received 1 likes!

Delete duplicate row and original rows that duplicated

Hi, Can you try the following expression? dt.AsEnumerable.GroupBy(Function(r) r("Column A").ToString).Where(Function(g) g.Count=1).SelectMany(Function(g) g).CopyToDataTable The above check duplicated value of ColumnA. Regards,

This solution provided by @Gokul001 received 1 likes!

Activities panel unable to dock

Check out this thread @joscares Regards Gokul

---

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.