Forum Engagement Daily Reports

[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.

[system]

Daily Forum Report | 22 November 2022

Top 3 Topics with Most Views

How to input variable from input dialog into run query made by @hanungrizqi with 58 views.

System.Activities.DynamicUpdate need to add Uipath Studio(Windows) process made by @Kaviyarasu_N with 41 views.

O365 Activities - Get Mail made by @gopai with 40 views.

Top 3 Topics with Most Replies

How to input variable from input dialog into run query made by @hanungrizqi with 31 replies.

Filterdatatable convert string into Int made by @tharani.natarajan with 19 replies.

Can't convert output date from dialog box to pick automatically dates on website made by @hanungrizqi with 15 replies.

Top 3 Users Who Posted The Most

@Yoichi made 65 posts!

@Gokul001 made 49 posts!

@Anil_G made 48 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

Compare two datatables and find row index of matching data

Hi @b.forbes , I believe we could use Join Datatables Activity to get the Matched Data between the two Datatables. The Join type should be Inner Join. We could then iterate through this Output of Join Datatables Activity using a For Each Row Activity and create an index and use it for the Anchor. The above suggestion is provided based on the input statement that was given, if it does not fully satisfy your requirements, maybe you could provide more descriptive details of the process. Let us …

This post made by @Gokul_Jayakumar received 2 likes!

Compare two datatables and find row index of matching data

Hello @b.forbes You can get the Current row index by getting output from index properties as an Integer variable type. Based on current row, we can get the index in loop. [image]

This post made by @Yoichi received 2 likes!

フォルダー内の複数のCSVを取込Excelへ書き込む

こんにちは CurrentNameはファイル名しか返しませんので、相対パスとして扱われ、UiPathのプロジェクトフォルダを参照した形になります。 そのためCurrentFile.FullNameを使ってください。 その上で２の方ですが、文字コードが正しく設定されていませんので、 エンコーディングプロパティに"Shift_JIS" または”UTF-8"を設定してください（実際の文字コードに合わせてください） もしWindowsプロジェクトの場合（WIndowsレガシーではなく）エンコーディング指定の前に 一つメソッドを呼ぶ必要があるかもしれませんので、以下参照ください。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

フォルダー内の複数のCSVを取込Excelへ書き込む

こんにちは CurrentNameはファイル名しか返しませんので、相対パスとして扱われ、UiPathのプロジェクトフォルダを参照した形になります。 そのためCurrentFile.FullNameを使ってください。 その上で２の方ですが、文字コードが正しく設定されていませんので、 エンコーディングプロパティに"Shift_JIS" または”UTF-8"を設定してください（実際の文字コードに合わせてください） もしWindowsプロジェクトの場合（WIndowsレガシーではなく）エンコーディング指定の前に 一つメソッドを呼ぶ必要があるかもしれませんので、以下参照ください。

This solution provided by @jeevith received 1 likes!

UiPath Assistant (22.4) not showing string array input argument

Hi @EevaHanninen, I have not crossed checked the behaviour, but one thing I always forget is to update the package in the process within the orchestrator folder. May be this is the case? You may have updated and published the package, but could it be that the process in question is not updated to the newest package (where you have input array argument?). This way the assistant only shows you two arguments (from previous version of your package) and not three (your newest version of the package…

This solution provided by @Gokul001 received 1 likes!

Does it cause any problem to update Uipath?

HI @Peace_Maker Yes, If you need to migrate to the latest version. You have do some change inside the flow. Check out the document 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 | 23 November 2022

Top 3 Topics with Most Views

Difference result between run through orchestrator and studio made by @Kelvin1 with 45 views.

How to test the workflow on a new virtual desktop? made by @g_ii with 45 views.

Click activity fail when run from orchestrator made by @g_ii with 41 views.

Top 3 Topics with Most Replies

Click activity fail when run from orchestrator made by @g_ii with 23 replies.

Facing issues in web application made by @varunk with 16 replies.

How to match the variable value in excel sheet made by @sruthesanju with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 61 posts!

@Anil_G made 54 posts!

@sangeethaneelavannan1 made 22 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to Compare two data tables with specific Column data

Hi, Can you try the following sample? [image] DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"}) Sample20221123-2aL.zip (10.6 KB) Regards,

This post made by @Jayavignesh_G received 2 likes!

How to add data row in different data table of different column using linq

@adarsh_kotagiri Datatable-> DT_1 & DT_Final and Create “Result” argument as “in/out” direction. In Total 3 Datatable will be used, DT_1 , DT_Final and Result Take Involve Code Activity, Pass the DT_1 & DT_Final argument as “in” direction. then open the Code Editor, Var query = from DT_1 in DT_1.AsEnumerable() Join DT_Final in DT_Final.AsEnumerable() on DT_1.Field(“Document Number”) equals DT_Final.Field(“Cheque.no”) select new { Date = DT_1.Field<string>("Date") …

This post made by @Jayavignesh_G received 2 likes!

Extract diffrent tables with same format per emails

@iremguner - At First Read the Outlook Mail, For Each Outlook (Apply the some filter Condition if needed) → Use HTML Content create 2.Now you may got the code of Total Body Content then Keep “Date” as Start Label and “RMK” as End Label (Hint: Use the Index Logic to find position of those label) 3.Now Write those Range value from start Label to End Label into Excel. Happy Learning !!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to Compare two data tables with specific Column data

Hi, Can you try the following sample? [image] DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"}) Sample20221123-2aL.zip (10.6 KB) Regards,

This solution provided by @Hendriyanto received 1 likes!

How to install custom activities

hello @son.dc , What is your project Version? (Windows, Legacy, or CrossPlatform), if your project compatible version is Windows, not all Costum activity is supported Cheer,

This solution provided by @Anil_G received 1 likes!

Arrived email outlook trigger

Hi @nora_ziani yes you need to configure required arguments in process and then publish it and then create integration service in orchestrator. Please check the documentation in previous post on how to create process and required arguments to get data from trigger 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 | 24 November 2022

Top 3 Topics with Most Views

How can i convert DD/MM(Months in Words) to MM/DD/YYYY format made by @sagar.raval with 42 views.

Option Strict On disallows implicit conversions from 'Object' to 'Integer' made by @Sadder with 39 views.

Unable to extract Table data which has a horizontal scroll within a webpage made by @David_Bekky with 33 views.

Top 3 Topics with Most Replies

Option Strict On disallows implicit conversions from 'Object' to 'Integer' made by @Sadder with 23 replies.

365 SharePoint made by @Ahmad_Rais with 17 replies.

How can i convert DD/MM(Months in Words) to MM/DD/YYYY format made by @sagar.raval with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 67 posts!

@Gokul001 made 63 posts!

@Yoichi made 27 posts!

Top 3 Most Liked Posts

This post made by @VirajN received 2 likes!

Monthly Forum rewards - October 2022

Congratulations @Gokul001 @Sudharsan_Ka @Yoichi and all others. Thank you all for making our lives easier with your contributions.

This post made by @ashwin.ashok received 2 likes!

Alternate to Element Exists property?

Hi @Sami_Rajput , The Check App State (Modern Activity) works quite well in scenarios like these. It allows you to wait for an element to either appear or disappear: [image] If the element is present or disappears, it won’t wait 30 seconds - it moves on with the execution. Could you give that a try and let us know if it works out for you? Kind Regards, Ashwin A.K

This post made by @Manoj_sreekanth received 2 likes!

CLick image not working: Windows application(Studio)

thank you so much , i have almost followed the steps mentioned and it has worked for me. regards, Manoj

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Convert string to datetime error

Hi, FYI, another approach: [image] (CDate(Now.ToString("yyyy/MM/dd ")+yourString.Trim)-Now).ToString Regards,

This solution provided by @Gokul001 received 2 likes!

Uipath Studio Community Edition is Always free?

HI @ashwini.mali Check out the video link and document [Download & Install UiPath Community Edition | UiPath Tutorial For Beginners | Class 03] [2022 Latest UiPath Download Install Sign In and Connect to Orchestrator] Regards Gokul

This solution provided by @Gokul001 received 1 likes!

How can i take only the files of today in a ForeEachFile Activity loop

Hi @Imene_ZARAI You can if activity inside the For each file in folder activity Use this condition New System.IO.FileInfo(CurrentFile.ToString).CreationTime.ToString("dd.MM.yyyy") = DateTime.Now.ToString("dd.MM.yyyy") Can you check out the XAML file TodaysFileINFolder.xaml (7.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 | 25 November 2022

Top 3 Topics with Most Views

LINQ Query Troubleshooting made by @Mahii with 38 views.

Robot auto closed after a few second made by @mzbar with 37 views.

When we use And, Andalso, or, orelse made by @Kelvin1 with 36 views.

Top 3 Topics with Most Replies

Is there a way to extract the account no values(excluding special characters that are not numeric or alphabets)? made by @Justine with 20 replies.

Uipath studio enterprise edition made by @vivekktr with 16 replies.

Key not present in dictionary made by @Cuberoot with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Yoichi made 52 posts!

@Gokul001 made 40 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Convert all dictionary values which has array as datatype to List

A shortened one: [grafik] [grafik]

This post made by @Rafal_Walicki received 2 likes!

KSeF e-invoicing in Poland - new custom activities package

Hello UiPath community! Office Samurai team would like to announce: The package containing activities that provide integration between UiPath and Polish e-invoicing system KSeF (Krajowy System e-Faktur) is now available and ready to use: Key functionalities that simplify interactions with this system: Providing a choice for the user between all types of environments: Test, Demo and Prod. Establishing an interactive session using previously generated secret token. Sending invoices i…

This post made by @supermanPunch received 2 likes!

Convert all dictionary values which has array as datatype to List

Hi @RpaNoobMax , Could you check with the below Expression : list1 = yourDictVar.SelectMany(Function(x)x.value.Select(Function(y)y)).ToList Let us know if it doesn’t work

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Convert all dictionary values which has array as datatype to List

Hi @RpaNoobMax , Could you check with the below Expression : list1 = yourDictVar.SelectMany(Function(x)x.value.Select(Function(y)y)).ToList Let us know if it doesn’t work

This solution provided by @Yoichi received 2 likes!

Extracting value from json after comparison?

Hi, As there are some syntax errors for json format in the above text, I fixed it as the following. { "statuses" : [ { "jobId" : "abx", "name" : "Suzan", "folder" : "abcd", "status" : "Ended Not OK" }, { "jobId" : "aby", "name" : "Pinacio", "folder" : "abcd", "status" : "Ended Not OK" }, { "jobId" : "abz", "name" : "Loren", "folder" : "abcd/pqrs", "status" : "Ended Not OK" } ], "returned" : 3, "total" : 3 } Then, can you try as the following? [image] Sample20221125-9.zip (2.6 KB) Regards

This solution provided by @Anil_G received 1 likes!

Move data from one data table to another

Hi @Cam1 Yes it is possible Use a for each row in datatable on dt1 and then use a add data row inside the loop and add the currentrow to dt2 After the loop you can use clear datatable to empty it if you want to empty it 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 | 26 November 2022

Top 3 Topics with Most Views

Removing validation error made by @lq_c with 40 views.

Github UIPath App not working made by @EchoS with 31 views.

How to open logs from execution_log_data made by @RPA_Canada with 30 views.

Top 3 Topics with Most Replies

Can't access for each json children after deserializing made by @pink_unicorn_waifu with 17 replies.

DataTable Group By and Sum made by @huang.kaijin with 10 replies.

Unable to upload sheets in uipath made by @Cuberoot with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 33 posts!

@pink_unicorn_waifu made 7 posts!

@Justine made 6 posts!

Top 3 Most Liked Posts

This post made by @neil.obrien received 1 likes!

Extract Table Data fails and causes Studio to freeze

Hello Maciej , Packages look like this [image] I have worked around the error by copying an Extract Table activity and then using a click to get the selector and then updating the Extract Table activity with the selector from the click.

This post made by @neil.obrien received 1 likes!

Extract Table Data fails and causes Studio to freeze

Maciej, You are right! Updated to current versions and the problem disappeared. Thank you!! [image]

This post made by @RajKumar_DC received 1 likes!

How to open logs from execution_log_data

Hi @RPA_Canada, Use Ctrl+L

Top 3 Most Liked Solutions

This solution provided by @RajKumar_DC received 1 likes!

How to open logs from execution_log_data

Hi @RPA_Canada, Use Ctrl+L

This solution provided by @Anil_G received 1 likes!

Is there a way to extract the account no values(excluding special characters that are not numeric or alphabets)?

Hi @Justine “1.12345678/2.35548674” this is the string that is being passed in the assign if you want to split what is there in excel then read the excel into datatable…run a for each loop and pass currentrow(“Youraccountnumbercolumnname”).Tostring then it will get the account numbers eg: System.Text.RegularExpressions.Regex.Matches(currentrow(“Youraccountnumbercolumnname”).Tostring,“\d+.\d+”) Note: Do this inside for each row in datatable loop. Keep assign and the for each(already created)…

---

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

Top 3 Topics with Most Views

Read range cell value made by @rajyavardhansr with 37 views.

Cant add sharepoint list item made by @Nathan_Betters1 with 31 views.

Acme-test login is not working made by @balasubramaniam.r.k with 28 views.

Top 3 Topics with Most Replies

JIRA Cloud> HTTP Request with proxy made by @pushkar.singh with 12 replies.

Edgeの右クリック→メニュー上の「画像をコピー」操作できない made by @11159 with 8 replies.

Read range cell value made by @rajyavardhansr with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Yoichi made 10 posts!

@bakrious12 made 6 posts!

Top 3 Most Liked Posts

This post made by @house.of.nf.ssk received 1 likes!

無料期間の失効

それらしき情報は落ちていませんでしたので、一か八かでアンインストール、インストールしました。 インストール後はどのアカウントにサインインしますか？と聞かれ恐らく今まで使用していたアカウントを選択するとエラーが出ました。おそらく間違って作成したアカウントを選択すると無事サインインが完了し、使用できるようになりました。取り急ぎ勉強は可能になりましたが、今後も更新で苦労するのかもしれません。更新が来るたびにアカウントを作成していけばよいのかもしれませんが、正式な更新方法を知らないと不安ですね。 急ぎの案件ではなくなりましたが、どなたか今後もアドバイス頂けると助かります。

This post made by @lynnsong986 received 1 likes!

Regex help 11.26.22

thanks both, this works perfectly! Lynn

This post made by @RajKumar_DC received 1 likes!

Acme-test login is not working

@balasubramaniam.r.k, try with deferent browser thanks,

Top 3 Most Liked Solutions

This solution provided by @house.of.nf.ssk received 1 likes!

無料期間の失効

それらしき情報は落ちていませんでしたので、一か八かでアンインストール、インストールしました。 インストール後はどのアカウントにサインインしますか？と聞かれ恐らく今まで使用していたアカウントを選択するとエラーが出ました。おそらく間違って作成したアカウントを選択すると無事サインインが完了し、使用できるようになりました。取り急ぎ勉強は可能になりましたが、今後も更新で苦労するのかもしれません。更新が来るたびにアカウントを作成していけばよいのかもしれませんが、正式な更新方法を知らないと不安ですね。 急ぎの案件ではなくなりましたが、どなたか今後もアドバイス頂けると助かります。

---

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

Top 3 Topics with Most Views

How to solve this issue can anyone suggest me? made by @Soundarya_Guduri with 44 views.

"Could not find the UI element corresponding to this selector" made by @Ram_Gurav1 with 40 views.

Need LINQ expression for multiple Group by made by @Marian_B with 38 views.

Top 3 Topics with Most Replies

Need LINQ expression for multiple Group by made by @Marian_B with 22 replies.

DateTime data insert to sql server made by @Shyam_Pragash with 18 replies.

How to extract table in PDF file made by @minal.patil with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 119 posts!

@Yoichi made 48 posts!

@Gokul001 made 39 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

ブラウザのタブをアクティブ化

こんにちは Activateアクティビティ 検証しましたがうまくいきませんでした。 どのように設定していますでしょうか？ 最も単純には、ブラウザをアタッチで、当該タブ(タイトル)を指定して、その中に何も設定しないアクティベートアクティビティを設置するだけで動作すると思います。 [image] 動作原理的に、入力方式をSimulateType/ClickやChromimuAPIを使えばアクティブかどうかは無関係で動作します。(SelectItemも同様です）Default(HardwareEvent)を使う場合はアクティブ化は必須になります。

This post made by @ppr received 2 likes!

How to convert this ISO time format PT1M16.87S to seconds in studio

[grafik]

This post made by @Yoichi received 2 likes!

Is it illegal to use the community version at work?

HI, First, perhaps you should check license term of Community Agreement In the latest, it says as the following. So if your purpose is profit purpose, you cannot use it. [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to convert this ISO time format PT1M16.87S to seconds in studio

[grafik]

This solution provided by @Yoichi received 2 likes!

Is it illegal to use the community version at work?

HI, First, perhaps you should check license term of Community Agreement In the latest, it says as the following. So if your purpose is profit purpose, you cannot use it. [image] Regards,

This solution provided by @Anil_G received 1 likes!

How Can I Filter a Long TXT File

Hi @Burak_Baris_Gologlu My bad . This is the regex to use System.Text.RegularExpressions.Regex.Matches("YourString","T\.C\. SAKARYA.*T\.C\.") And your matchcol variable should be of type Matchcollection [image] Adding .ToString will not work . Change the variable type as shown above 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 November 2022

Top 3 Topics with Most Views

How to solve: 0 (zero) gets truncated with the number beginning with 0 in my output excel file made by @Sisay_Dinku with 63 views.

代入アクティビティでキャスト例外 made by @shunsuke.ogata with 51 views.

How to extract the table using Regex or String Manipulation made by @sunilkanth with 43 views.

Top 3 Topics with Most Replies

Can I Use Read Cell Activity To Output String Type Only? made by @Hendaryie_Tjoeng with 23 replies.

How to solve: 0 (zero) gets truncated with the number beginning with 0 in my output excel file made by @Sisay_Dinku with 21 replies.

InvokeWorkflowFile activity Issue UiPath.System.Activities 22.10.1 version or higher made by @satchauhan with 21 replies.

Top 3 Users Who Posted The Most

@Anil_G made 121 posts!

@Gokul001 made 60 posts!

@Yoichi made 36 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

String Manipulation from heLLo WOrLd to HEllO woRlD

on of a few options: [grafik] String.Join("",YourStringVar.Select(Function (x) If(Char.IsLower(x), x.tostring.toupper, x.toString.tolower)))

This post made by @yrobert received 2 likes!

The "modern" activities don't make sense

Hi Since we work most of the time on a test environment when we create the automation, the window selectors won’t work on the production environment. SImple reason, the window selector has a different title in test environment or even app name. So we need to change every window selector. With modern, it implies a lot of additionnal work. Even anchors and verifiy part of click/type activities have their own window selector that we need to adapt → this means 3 Window selector to adapt. It is ju…

This post made by @sangeethaneelavannan1 received 2 likes!

How to show a message box, stating the total invoice value?

@how2awpp Welcome to uipath community. Yes ,you can use message box [image] here totalinvoicevalue is the variable

Top 3 Most Liked Solutions

This solution provided by @ppr received 4 likes!

String Manipulation from heLLo WOrLd to HEllO woRlD

on of a few options: [grafik] String.Join("",YourStringVar.Select(Function (x) If(Char.IsLower(x), x.tostring.toupper, x.toString.tolower)))

This solution provided by @ppr received 2 likes!

How to handle "The source contains no datarows" exception?

@Sami_Rajput With the DataTableVar.Select Method we can do it similar in_DT_to_filter.Select("[Date] > '"+in_Date+"'").ToList

This solution provided by @Gokul001 received 1 likes!

Read Specific Tet from Text File

HI @prerna.gupta Check out this XAML file TextFileRegex.xaml (9.0 KB) [image] [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 | 30 November 2022

Top 3 Topics with Most Views

Uipath practice Test Question made by @Aima_Arif with 49 views.

GetCurrentJobInfo-->WorkflowFullPath as a property made by @jeevith with 37 views.

Error not solving made by @taruna.mehra with 37 views.

Top 3 Topics with Most Replies

When trying to Invoke a Ref process from a flowchart workflow, "Could not find part of the path '....../GetTransactiondata.xaml' error made by @Rajeena_M with 25 replies.

範囲に書き込みをしようとするとエラーになる made by @miwa_yamamoto with 24 replies.

I have upgraded some packakes and now my WF does not recognizes some actyvities made by @tomaz with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 84 posts!

@Gokul001 made 60 posts!

@Yoichi made 42 posts!

Top 3 Most Liked Posts

This post made by @Emerald received 2 likes!

GetCurrentJobInfo-->WorkflowFullPath as a property

Thanks, @Konrad_Mierzwa. For all others, below is the code for the custom activity. using System.Activities; using System.ComponentModel; using UiPath.Robot.Activities.Api; namespace UiPath.Workflow.Information { [Category("Custom Activities.Workflow")] [DisplayName("Get Workflow Path")] public class GetWorkflowPath : CodeActivity { [Category("Output")] public OutArgument<string> Output { get; set; } protected override void Execute(CodeActivityContext …

This post made by @sangeethaneelavannan1 received 2 likes!

Selecting combobox by using value inside excel row

Hi @Miracle_Vernawan Welcome to the UiPath community If you do not want to use a select element, you can use one-click activity to click on the dropdown field and another click activity to select the item.

This post made by @Gokul001 received 2 likes!

Selecting combobox by using value inside excel row

Hi @Miracle_Vernawan Can you share the error message here? Try to use in_TransactionItem.Specificcontent("Plant Code").Tostring Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Studioxにて各行の繰り返し処理を各シートで実行する方法

こんにちは StudioXの場合、デバッグ機能が弱いので、必要な情報を適当なタイミングで出力することにより 原因を探ることになると思います。 シートの指定は Index_From_For_Each で行ているように思えますので、 まずはその数値がインクリメントされているかを確認するためにループ中で 1行書き込みで書き出してみる それが問題なければ、シート名が正しいかを確認するために SheetsOfExcelA(Index_From_For_Each) の内容を書き出してみる 等のアプローチになると思います。

This solution provided by @Anil_G received 1 likes!

Error in creating a custom input dialog box

Hi @Prathyai_K Try changing the system activities package version Please check this Cheers

This solution provided by @Shyam_Pragash received 1 likes!

DateTime data insert to sql server

Hi @Anil_G @RajKumar_DC Thanks All Finally we found the soluation to import Null data with specificed variable types in sql server. If ( String.IsNullOrEmpty(Exl_Created_At), New Nullable(Of Date), System.Convert.ToDateTime(Exl_Created_At)) Variable Type : Nullable.System.Datetime Thanks Shyam

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

@Gokul001 received 90 likes for their solutions!

@Yoichi received 71 likes for their solutions!

@ppr received 36 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.