Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 April 2021

Top 3 Topics with Most Views

UiPath Marketplace - Automation Ideas Board made by @Andreea_Stroe with 53 views.

Dynamic folder creation made by @Nivetha_R with 33 views.

How to tackle with overlapping text in a Document? made by @raheelferoze with 32 views.

Top 3 Topics with Most Replies

Dynamic folder creation made by @Nivetha_R with 10 replies.

Filter Data Table activity deletes cells made by @achalisma with 8 replies.

How to read a different date format and write the output in a different format? made by @lmoham with 8 replies.

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@Hiba_B made 18 posts!

@Techpriest made 11 posts!

Top 3 Most Liked Posts

This post made by @Andreea_Stroe received 9 likes!

UiPath Marketplace - Automation Ideas Board

Hello, We are very excited to share with you the latest news from UiPath Marketplace! We know how enthusiastic the RPA Community is when it comes to automation and we want to help you in your efforts! Today we have released a public Trello board containing automation ideas that we believe are not touched upon yet and would make an impact on everyone’s way of work. This comes as a result of a massive content review - we wanted to spot the gaps and allow everybody who wants to…

This post made by @DeaTo received 3 likes!

Object Detection Virtual Event - Discussion

You’ll be able to find the recording in the event page :See How to Detect Objects in Images & Videos using UiPath Robots at UiPath EMEA&APAC Virtual Events

This post made by @ppr received 2 likes!

Keep string after a certain word

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

データテーブルの値を配列に変換したい

こんにちは DataTable 側がnullなのではないでしょうか？

This solution provided by @HANACCHI received 1 likes!

Datediff関数の戻り値について

[image] こんな感じです。ご参考まで。

This solution provided by @Hiba_B received 1 likes!

Need to have XML activity for Uipath 2019.10.6

No because it’s not in .nupkg format (as would be an activity in UiPath terms). It’s in xaml format, so if you want to call it as a package you will need to open the xaml file of Paramatrix, create as a library from it (basically copy/paste the code + argument): [image] Then you will be able to publish it from library options, then you will be able to call the package from Manage packages at a local level [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 | 29 April 2021

Top 3 Topics with Most Views

https://forum.uipath.com/t/311215 made by @SIM_JUN_HUI_BERTRAM_CSOD with 43 views.

Convert MMMM to MM made by @fairymemay with 36 views.

Convert UI element to 1 Decimal Place made by @Yudhisteer_Chintaram1 with 35 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/311215 made by @SIM_JUN_HUI_BERTRAM_CSOD with 14 replies.

Using list values in a "add data row "activity made by @Dhouha_Cherif with 10 replies.

Convert UI element to 1 Decimal Place made by @Yudhisteer_Chintaram1 with 9 replies.

Top 3 Users Who Posted The Most

@prasath_S made 23 posts!

@ppr made 14 posts!

@Hiba_B made 13 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

Tip: How to Build Your Own SAP Accelerator

Since a few month are very interesting Accelerators for SAP at UiPath Marketplace available. In my opinion is the approach of mapping technical interfaces into Excel spreadsheets extremely interesting. That is why I have extended my RFM code generator so that it can also generate a corresponding Excel workbook from the interface description of an remote enabled function module, aka RFC. This provides an easy way to create a frame for SAP API automation. And precisely this aspect I would like to …

This post made by @Hiba_B received 2 likes!

Download UiPath Remote Runtime on standalone studio enterprise edition

Great ! Then don’t forget to mark your topic as solved so people that have the same problem find your topic as the solved one ^^ Thanks Pablito

This post made by @wasea received 2 likes!

UIpath Remote Runtime Download

Hello @alvaro.j.nobre , You can download the file from cloud platform. You have the option to download the correct version of it. Go to : https://cloud.uipath.com/ Click on HELP (left down) [image] The resource center page will open In the right side, you have the options to download the executables that you want. [image] Install the msi. I hope it helps. Vasile.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Combining Two IEnumerables of UiElements into a Single DataTable with LINQ

@ashwin.ashok lets assume both Lists have reliable same count of items the datatable col structure is 2 cols (name,adress) and an empty datatable is available - dtFinal Give a try on (From i in Enumerable.Range (0, ListName.Count) Let ra = {ListName,ListAddr}.Select(Function (x) x(i).Get(“innertext”)).toArray Select dtFinal.Rows.Add(ra)).CopyToDataTable ListName = your List_UIElement of the names

This solution provided by @prasath17 received 1 likes!

Convert UI element to 1 Decimal Place

@Yudhisteer_Chintaram1 - Please try this… Math.round(cdbl(Item),2).ToString(“N1”)) [image] Hope this helps…Actually clue was in your previous post, i have posted the reference link from Microsoft docs too… [image]

This solution provided by @pavanh003 received 1 likes!

In abbyy flexicapture setup station, how can I check for a checkbox value by c# script?

Hi, if (this.Field(“F1”).Value == true){ this.Field(“F1”).Value = this.Field(“F2”).Value } I have writtien it using javascript in abbyy rule section for the field. I am getting the expected result. Try this way, may be it will help. Let me know if not. Regards, pavan H

---

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 April 2021

Top 3 Topics with Most Views

Delete multiple CSV or Excel columns and column range made by @markosc with 31 views.

Extract working date made by @Amin with 31 views.

ジョブを実行する際にロボットを選択できない。 made by @smochidolphine with 31 views.

Top 3 Topics with Most Replies

Copy Range Keeping Formulas made by @sereganator with 10 replies.

Today's Date Coming Wrong Suddenly(Project Notebook -> Date Sheet ) made by @ayewale with 10 replies.

Start Process activity, how to best wait for completion made by @rogerfries with 9 replies.

Top 3 Users Who Posted The Most

@alexandretperez made 14 posts!

@ppr made 11 posts!

@prasath17 made 11 posts!

Top 3 Most Liked Posts

This post made by @MBSHansen received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, my name is Mikkel and I joined as I am currently going through the UiPath RPA Associate Certification Training, and have a few questions to optimize the way i build my workflows. I am looking forward to learning with all of you.

This post made by @wasea received 2 likes!

Chrome Save As

Hi @Minol_Pamosha , If it’s related to the file path, you can put it in the file name and it will save the file at the new path. Not needed to change the path from the upper address bar. Something like this: [image] Just an idea. Vasile.

This post made by @SIM_JUN_HUI_BERTRAM_CSOD received 2 likes!
https://forum.uipath.com/t/311365/6

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Excel splitting a column value to multiple columns

@bhishaj Welcome to the forum give a try on doing the extraction with the help of regex e.g. [grafik] [grafik] [grafik] [grafik] etc. Also have a look here:

This solution provided by @prasath17 received 1 likes!

Convert excel column to 2 decimal places

@Yudhisteer_Chintaram1 - After using “MidpointRounding.AwayFromZero” issue has fixed… Math.Round(cdbl(row("NW Elasthane")),2,MidpointRounding.AwayFromZero).ToString("N2")) Please see the ouput below: [image]

This solution provided by @prasath_S received 1 likes!

Delete multiple CSV or Excel columns and column range

You can use invoke VBA activity for this, Do this one time on excel, In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel (File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box). Put the code on text file, Sub macro() Range(“AC1”).entirecolumn.delete Range(“CM1”).entirecolumn.delete Range(“CO1”).entirecolumn.delete Range(“CQ1”).entirecolumn.delete R…

---

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

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

[system]

Daily Forum Report | 01 May 2021

Top 3 Topics with Most Views

Reading pdf with regex. how to continue when he's not finding the object? made by @Nightowl_music with 28 views.

Introducing UiPath Insights Cloud made by @Michelle_Yurovsky with 26 views.

アクティビティ「要素が出現したとき」の結果の出力について made by @111131 with 26 views.

Top 3 Topics with Most Replies

Reading pdf with regex. how to continue when he's not finding the object? made by @Nightowl_music with 6 replies.

The current limit for the length of lists is Int32 i.e a max of 256 elements can be kept in it. How do I increase it or make it dynamic so that I can keep unlimited number of elements in the list? made by @Jaideep with 5 replies.

System rule exception and business re made by @airwaveexporter with 4 replies.

Top 3 Users Who Posted The Most

@Sakshi_Jain made 12 posts!

@wasea made 12 posts!

@ayewale made 7 posts!

Top 3 Most Liked Posts

This post made by @Michelle_Yurovsky received 3 likes!

Introducing UiPath Insights Cloud

Introducing UiPath Insights Cloud We are so excited to introduce you to the newest member of the UiPath Automation Cloud family, Insights Cloud ! A purpose-built analytics solution now available for Automation Cloud Enterprise customers, Insights Cloud helps you track, measure and report on the performance and business impact of your RPA operations. Gain operational awareness with a library of pre-built dashboard templates, customizable with any combination of widgets…

This post made by @wasea received 1 likes!

UI path overwriting .pdf attachments with same name while downloading from outlook

Hello @Beatriz_Eugenia_Duqu , Interesting thig from my check is if you’re using the UiPath Studio with C# project, the attachment files with the same name will be saved with an appended number (_1,_2,_3…). I have also a project created in VB. To avoid the overwrite issue, I pass in the filter, the attachment name [image] I hope it helps. Vasile.

This post made by @cheez_RPA received 1 likes!

アクティビティ「要素が出現したとき」の結果の出力について

この動作であれば、「要素の有無を判定」（Element Exists）アクティビティをお使いいただくのが良いかと思います。 こちらのアクティビティは、出力に指定したBoolean型の変数に下記のとおりに保存します。 要素が存在する場合には True 要素が存在しない場合には False

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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

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

[system]

Daily Forum Report | 02 May 2021

Top 3 Topics with Most Views

Array Error made by @Dorothy_lee with 25 views.

Can not open Uipath these day. Help,I don't know what happened? made by @233214496 with 24 views.

Splitting one excel file to multiple excel files made by @adarsh_kotagiri with 23 views.

Top 3 Topics with Most Replies

If Cell format = "dd/MM/yy" then Situation 1 otherwise 2 made by @Soudios with 8 replies.

Can not open Uipath these day. Help,I don't know what happened? made by @233214496 with 7 replies.

Add New Column Values To A Datatable using existing Column Values And Change Format Of The Entire Column Values to Number (Using Linq - Both The Case) made by @Ashish6541 with 5 replies.

Top 3 Users Who Posted The Most

@josephatomwanzia made 9 posts!

@wasea made 9 posts!

@Soudios made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

IENumerable<Match> Regex Group fast way to Datatable

lets assume the datatable has only 1 col then give a try: create an empty datatable with the column - dtResult use an assign activity left side: dtResult right side (from m in IENumerable.Cast(of Match) Select dtResult.Rows.Add(m.Groups(1).toString)).CopyToDataTable

This post made by @Adrian_Star received 1 likes!

How to convert date format(mm/dd/yyyy) to (dd/mm/yyyy) and also how to change string into date format

Hi, new_date = DateTime.ParseExact(string_date.ToString,"DD-MMM-YY", Globalization.CultureInfo.InvariantCulture).ToString("DD/MM/YYYY")

This post made by @wasea received 1 likes!

UI path overwriting .pdf attachments with same name while downloading from outlook

Like this: [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

IENumerable<Match> Regex Group fast way to Datatable

lets assume the datatable has only 1 col then give a try: create an empty datatable with the column - dtResult use an assign activity left side: dtResult right side (from m in IENumerable.Cast(of Match) Select dtResult.Rows.Add(m.Groups(1).toString)).CopyToDataTable

This solution provided by @Yoichi received 1 likes!

How to use the updated kill process

Hi, Can you try the following? [img20210502-3] Regards,

This solution provided by @Yoichi received 1 likes!

XML Deserialize won't work because of xmlns attribute

Hi, xmlns="http://tempuri.org/" means default XML namespace. So can you try the following? [img20210502-2] 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 | 03 May 2021

Top 3 Topics with Most Views

Type into - Date Field made by @Nelson.R with 42 views.

Get date from email:{subject, body, attachments} made by @Sakshi_Jain with 36 views.

Excel after header A and B write a formula made by @CoolRobot with 29 views.

Top 3 Topics with Most Replies

Type into - Date Field made by @Nelson.R with 15 replies.

How to give reply to same mail chain through outlook by adding today's date in the subject? made by @anjasing with 9 replies.

Click activity not click made by @fairymemay with 7 replies.

Top 3 Users Who Posted The Most

@Pankaj.Patil made 16 posts!

@NIVED_NAMBIAR made 10 posts!

@fairymemay made 8 posts!

Top 3 Most Liked Posts

This post made by @CoolRobot received 2 likes!

Excel after header A and B write a formula

Thanks you is working perfectly

This post made by @Pankaj.Patil received 2 likes!

Excel after header A and B write a formula

@CoolRobot, Take two write cell activities and provide formula into value property =Text(C1203, ““MMM””) Second one, write as it is, no change in it

This post made by @NIVED_NAMBIAR received 2 likes!

To calculate birth year automatically?

Hi @vaigunth_rey welcome to forum use this in message box to get the age CInt(birthday)-CInt(year) Regards, Nived N Happy Automation

Top 3 Most Liked Solutions

This solution provided by @Pankaj.Patil received 2 likes!

Excel after header A and B write a formula

@CoolRobot, Take two write cell activities and provide formula into value property =Text(C1203, ““MMM””) Second one, write as it is, no change in it

This solution provided by @NIVED_NAMBIAR received 2 likes!

To calculate birth year automatically?

Hi @vaigunth_rey welcome to forum use this in message box to get the age CInt(birthday)-CInt(year) Regards, Nived N Happy Automation

This solution provided by @markosc received 1 likes!

Sort Datatable by two columns

(From x In datatable.AsEnumerable() Order By convert.ToInt32(x(“Column2”)), convert.ToString(x(“Column11”)) Select x).CopyToDataTable

---

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 May 2021

Top 3 Topics with Most Views

Need solution on blank columnsIf made by @pravin.shigwan with 35 views.

Extracting URL from single string made by @Basak_Demirel with 32 views.

Excel Regex Extract Date made by @Yudhisteer_Chintaram1 with 31 views.

Top 3 Topics with Most Replies

Excel Cell values not being checked correctly due to containing special characters? made by @struggling_student with 13 replies.

Extracting URL from single string made by @Basak_Demirel with 10 replies.

PDF to XML made by @Mohammed_Junaid with 10 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@josephatomwanzia made 15 posts!

@struggling_student made 10 posts!

Top 3 Most Liked Posts

This post made by @iamwiliamb received 3 likes!

Orchestrator with Apollo Design System is here!

Hey all, Just wanted to announce everyone that starting today, the new look for Orchestrator using our new Apollo Design System is now available in Community! We hope you’ll like Orchestrator even more now and that you will get to love our new look and feel! You can find more details about what changed here: Our new look for Orchestrator is here! If there’s anything that you don’t like or would like us to change, suggest it here and we’ll get in touch with you! Thanks and have a fabulous Tue…

This post made by @sarathi125 received 2 likes!

How to insert Tab delimeter in Text file

@adarsh_kotagiri, Try with this workflow, it may help you. It needs an input excel from your desktop named as “Data.xlsx” with sheet1. Tab_Delimiter.xaml (9.3 KB)

This post made by @ppr received 2 likes!

How to insert Tab delimeter in Text file

@adarsh_kotagiri we can do like following: read range - readin excel write CSV - configured wit delimiter to tab https://docs.uipath.com/activities/docs/write-csv-file

Top 3 Most Liked Solutions

This solution provided by @sarathi125 received 2 likes!

How to insert Tab delimeter in Text file

@adarsh_kotagiri, Try with this workflow, it may help you. It needs an input excel from your desktop named as “Data.xlsx” with sheet1. Tab_Delimiter.xaml (9.3 KB)

This solution provided by @prasath_S received 2 likes!

Excel Regex Extract Date

Hi @Yudhisteer_Chintaram1 Please try this Main.xaml (9.2 KB) In Invoke Code dt1.AsEnumerable().ToList().foreach(sub(row) row(“Date”) = System.Text.RegularExpressions.Regex.Matches(row(“INV Date / BL Date”).ToString,“\d{1,2}/\d{1,2}/\d{1,4}”,RegexOptions.RightToLeft)(0)) Pass you datatable as in/out argument [image] Use write range to check if values are correct Thanks

This solution provided by @Nelson.R received 1 likes!

Type into - Date Field

Found what I was looking for: Get the System Date Format - #5 by Kabeer So for my case the only solution I could think of is to read a text file that has the system date format written in it.

---

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

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

[system]

Daily Forum Report | 05 May 2021

Top 3 Topics with Most Views

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 35 views.

Filter table by 2 Columns made by @markosc with 35 views.

Retrieving Conversation ID from mail box made by @rakshitha.shetty with 34 views.

Top 3 Topics with Most Replies

Publish error: Regex.Match non declared made by @Danny_Gi with 18 replies.

Move PDFs based on Name in specific Folders made by @Yudhisteer_Chintaram1 with 17 replies.

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 12 replies.

Top 3 Users Who Posted The Most

@Yudhisteer_Chintaram1 made 19 posts!

@josephatomwanzia made 17 posts!

@Adrian_Star made 16 posts!

Top 3 Most Liked Posts

This post made by @AndersJensen received 3 likes!

Filter data By Strikethrough In Excel?

Hey @Aaron_Ko For sure. I’ve created a simple VBA script for you, which does the job (checks if there is a Strikethrough). If yes, write “1” in the next column. We invoke it with an “Invoke VBA” activity inside an “Excel Application Scope” activity. Everything is attached. The simple Excel dataset (attached as Book1.xlsx) [image] The VBA code to invoke (attached as StrikeThrough.txt) Sub StrikeThrough() For n = 1 To Rows.Count If Range("A" + CStr(n)).Font.StrikeThrough Then Range("B…

This post made by @Steven_McKeering received 3 likes!

Regex for date

Hi A full list of your expected date formats is needed to build a robust Regex pattern. In the meantime, try this pattern:

This post made by @ppr received 2 likes!

Manually creating a TransactionItem/QueueItem w/o an Orchestrator queue

the prepared Dictionary has to be assigned on YourTransactionItemVar.SpecificContent Property

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Linq Query, Please Help!

@kantheshm give a try on following prepare an empty datatable with build datatable reflecting the target datacolumn strucutre: Col1 – Col2 - Col3 Variable: dtResult then use an assign activity left side: dtResult right side: (From d in dtData.AsEnumerable Group d by k1=d(“Col3”).toString.Trim,k2=d(“Col4”).toString.Trim into grp=Group Let s = grp.Sum(Function (x) CInt(x(“Col2”).toString.Trim)) Ler ra = new Object(){k1,s,k2} Select dtResult.Rows.Add(ra)).CopyToDataTable Also have a loo…

This solution provided by @AndersJensen received 1 likes!

Difficulty with modern folders

Hey @tainan.ramos Creating unattended robots in the new Modern Folder Orchestrator environment was the question I got the single-most. I’ve created this “get started” guide Feedback is very welcome. [🤖 Unattended Robots in Uipath Orchestrator (Full Tutorial)]

This solution provided by @Hiba_B received 1 likes!

Write full Date Format in Excel column

Hi @Yudhisteer_Chintaram1 ! Here is a suggestion: Date_conversion.xaml (9.7 KB) Beware, there is a strange date format at the end. I took care of it in the code through Try Catch but I wanted to let you know if it’s a forbidden/forgotten date format: [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 | 06 May 2021

Top 3 Topics with Most Views

Document Understanding - Data Manager Public Preview in Automation Cloud made by @alexcabuz with 56 views.

【UiPathアカデミー】新規コースリリース＆【UiPath 認定資格】日本語版バウチャーストアリリース made by @Taeko_UiPath with 52 views.

Help in HTML pls made by @evan.joy.celino with 38 views.

Top 3 Topics with Most Replies

Help in HTML pls made by @evan.joy.celino with 26 replies.

How to Append file excel 2 sheet? made by @fairymemay with 25 replies.

Data type for combination of text and numbers made by @evan.joy.celino with 17 replies.

Top 3 Users Who Posted The Most

@Yoichi made 26 posts!

@prasath17 made 19 posts!

@evan.joy.celino made 18 posts!

Top 3 Most Liked Posts

This post made by @Taeko_UiPath received 5 likes!

【UiPathアカデミー】新規コースリリース＆【UiPath 認定資格】日本語版バウチャーストアリリース

平素より、UiPathアカデミーをご愛顧いただき誠にありがとうございます この度新たに2つのコースをリリースいたしました UI操作を伴わない処理の自動化 コース 個人用ワークスペースの活用 コース UiPath 製品に関する知識の拡充にお役に立てればと思います ぜひご活用くださいませ また、UiPath認定資格 日本語版受験チケット用バウチャーストアがリリースされました 受験チケットをまとめてご購入が可能となるため、 複数人や団体でのご受験の計画・管理する際にお役立ていただけます ※試験言語（日本語または英語）により購入ページが異なります 英語版にて受験をご希望される方は、こちらよりご購入いただけます 引き続きUiPath をよろしくお願いいたします

This post made by @alexcabuz received 5 likes!

Document Understanding - Data Manager Public Preview in Automation Cloud

We are happy to announce the public preview release of the Document Understanding Data Manager version for Automation Cloud! Data Manager is the key tool used to build datasets for training Document Understanding ML Models in AI Center, but it was only publicly available on premises until now. Starting today, we have brought the convenience and ease of use of Automation Cloud to Data Manager. If you have AI Center in the Cloud, then you have Data Manager! The vers…

This post made by @Eric_Wong_Test received 2 likes!

Selector issue with Outlook

Esign*

Top 3 Most Liked Solutions

This solution provided by @Eric_Wong_Test received 2 likes!

Selector issue with Outlook

Esign*

This solution provided by @ppr received 2 likes!

ForEach Segment RowSets

we assume that you are meaning: 19 - Rows Count, 250 Segment Size it is working withour error: [grafik] Maybe you can share some more details on your implementation. Especially on the part where the Random is used. Thanks

This solution provided by @tlano received 1 likes!

Box Integration Activities - Now in Public Preview!

Thanks! Very helpful

---

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 May 2021

Top 3 Topics with Most Views

指定文字数未満の行を削除したい made by @miwa_yamamoto with 37 views.

How to add watermark to word automatically to word file using uipath made by @Gowtham_Srinivasan with 31 views.

How To Select a TAB in Forms Based on Certain Condition? made by @hsendel with 30 views.

Top 3 Topics with Most Replies

How To Select a TAB in Forms Based on Certain Condition? made by @hsendel with 12 replies.

Using Regex With Different Text Format made by @Sahil_J_Patel with 11 replies.

Data scaping only in 1 page made by @Tharusha_Fernando with 10 replies.

Top 3 Users Who Posted The Most

@prasath17 made 17 posts!

@Yoichi made 17 posts!

@Hiba_B made 14 posts!

Top 3 Most Liked Posts

This post made by @Zrinko_Zalik received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello. Thank you for the warm welcome. I’m sort of new in UiPath, I had some experience in it about a year and a half ago but starting this monday I’m a full time RPA DevOp so going trough the academy and finding solutions here on the forum helps a lot. I hope that I will contribute to the community.

This post made by @prasath17 received 2 likes!

Match file name and move

Hi @Beatriz_Eugenia_Duqu - Below one line copy all the .pdf and .xml files to the destination [image] array.ForEach(Directory.GetFiles("DeleteFiles\", “*”, SearchOption.AllDirectories).Where(Function(s) s.EndsWith(".pdf") Or s.EndsWith(".xml")).ToArray,Sub(x) File.Copy(x,"MoveFiles\"+ Path.GetFileName(x))) Above code copy the files from DeleteFiles folder to MoveFiles folder…

This post made by @Yoichi received 2 likes!

Can't get value when using Matches activities

Hi, Can you try the following sample? Sample20210507-2.zip (2.9 KB) The pattern will be (?<name>.*)\r?\n\r?\n(?<Role>.*)\r?\n\r?\nDOB:\s+(?<DOB>\d{2}-\w{3}-\d{4})\r?\n\r?\nEmail:\s+(?<Email>.*)\r?\n\r?\nMattermost:\s+(?<Mattermost>.*)\r?\n\r?\nSkype:\s+(?<Skype>.*) Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Can't get value when using Matches activities

Hi, Can you try the following sample? Sample20210507-2.zip (2.9 KB) The pattern will be (?<name>.*)\r?\n\r?\n(?<Role>.*)\r?\n\r?\nDOB:\s+(?<DOB>\d{2}-\w{3}-\d{4})\r?\n\r?\nEmail:\s+(?<Email>.*)\r?\n\r?\nMattermost:\s+(?<Mattermost>.*)\r?\n\r?\nSkype:\s+(?<Skype>.*) Regards,

This solution provided by @JayakumarSanthanam received 2 likes!

Data scaping only in 1 page

There is chance that there’s difference in page 2 element layouts. Try making another scraping selector for page 2 onwards and test if it works going forward. If this works, you need to first identify page 2 before proceeding to the specific scraping Thanks

This solution provided by @jvanmarion received 1 likes!

How we can schedule the task by using Orchestrator

You can use triggers for that. Take a look here.

---

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 May 2021

Top 3 Topics with Most Views

Copy data from one excel sheet to Another made by @abhide with 27 views.

Scraping linkedin post from a certain profile made by @Basak_Demirel with 26 views.

How can I extract an embedded PDF from an XML file? made by @Reginald with 26 views.

Top 3 Topics with Most Replies

How to convert feedback input into equivalent grade (number) made by @raymond_barlis with 6 replies.

Copy data from one excel sheet to Another made by @abhide with 5 replies.

How can I extract an embedded PDF from an XML file? made by @Reginald with 5 replies.

Top 3 Users Who Posted The Most

@wasea made 18 posts!

@Mikolaj_Zielinski made 5 posts!

@sunny_singh made 5 posts!

Top 3 Most Liked Posts

This post made by @kchang received 1 likes!

Problem with unattended robot and browser

On the UIPath forum I’ve seen a post regarding using tscon to disconnect from an RDP session but leave the GUI active. UiRobot run in Remote desktop I’ve see a similar post here for different use case Disconnecting From Remote Desktop While Running Automated Tests | TestComplete Documentation What I tried was from cmd as administrator, I ran “query session” to get my Session Name. Then ran " %windir%\System32\tscon.exe RDP-Tcp# NNN /dest:console" substituting my Session Name for “RDP-Tcp#NNN”…

This post made by @Gayathri_Ramanathan received 1 likes!
https://forum.uipath.com/t/312905/4

This post made by @StefanSchnell received 1 likes!

How to use Java Selenium in Combination with UiPath

Based on my approach about the using of JShell (Java REPL) here, an integration scenario of Java source code into UiPath, now an use case to integrate Java Selenium regression automation tests. Selenium is a portable framework for testing web applications. In business exists many sources which uses Selenium client and web driver language bindings in Java language. With this approach the existing automations can be used furthermore. Preparation Besides the OpenJDK I built two other packages. T…

Top 3 Most Liked Solutions

This solution provided by @Shraddha_Gore received 1 likes!

Copy data from one excel sheet to Another

Hi, use Merge Data Activity to get expected output. Your final Data Table will have following columns : ID, Import, Export, WW10, WW11, WW12, WW13, WW14, WW15, Unnamed Column. Remove Unnamed Column. Then write this final Data Table to excel sheet.

---

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 May 2021

Top 3 Topics with Most Views

How to use for each row when the variable is at the column instead of row made by @cxx with 34 views.

Try Catch: Catch portion not working made by @anonymous3 with 30 views.

【Googleマップ】到着時間の設定について made by @owlhr with 29 views.

Top 3 Topics with Most Replies

Can i make look up with separator and return value by same sequance made by @rpa13 with 18 replies.

DefaultView.ToTable(true, がうまく使えない made by @miwa_yamamoto with 11 replies.

Can I send Outlook e-mail based on excel data condition? made by @Dorothy_lee with 9 replies.

Top 3 Users Who Posted The Most

@prasath_S made 12 posts!

@rpa13 made 8 posts!

@Dorothy_lee made 5 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 3 likes!

Can I send Outlook e-mail based on excel data condition?

@Dorothy_lee - Another option would be filter the data first (this will avoid the if condition) and then read filtered data in the foreach loop for sending the email… DtFiltered = (From r In Dtout.AsEnumerable Where r("Feedback").toString.Contains("FALSE") Select r).CopyToDataTable Here dtfilterted is of variable Datatable. For Dynamic body, Please try like this…(Copy paste the right hand side value to your body) [image] Make sure to check - isBodyHtml Checkbox in the property… Hope this …

This post made by @prasath_S received 2 likes!

Write to text file with a complex given format

Hi @Tharusha_Fernando Please try these steps, Write the text to text file using write text fil activity. Varname + environment.newline + varAc + environment.newline + varAge + environment.newline +varIncome +environment.newline + environment.newline + varSply+ environment.newline + varsplyarea + environment.newline + varTrl After this use start process activity and open the text file that’s just created. Using clicks or hotkeys to enter the format in the note pad file , save the file a…

This post made by @prasath_S received 2 likes!

How to dynamically read an specific cell from a large number of data

Hi @Shraddha_Gore I think it should be first row and then column , Balance = YourDT(YourDT.Rows.Count - 1)(“Balance”)

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

How to dynamically read an specific cell from a large number of data

Hi @Shraddha_Gore I think it should be first row and then column , Balance = YourDT(YourDT.Rows.Count - 1)(“Balance”)

This solution provided by @prasath_S received 1 likes!

How to delete specific column?

@Dorothy_lee lets assume your datatable is dtTable1, please try this {dtTable1.Columns(2).ColumnName.ToString,dtTable1.Columns(3).ColumnName.ToString,dtTable1.Columns(4).ColumnName.ToString,dtTable1.Columns(5).ColumnName.ToString} give this in the column names

This solution provided by @Rajesh.Attada01 received 1 likes!

Unable to Convert the Date format to Required Date format

Took Substring of 11 characters Jan 2 2020 Wrote if statement to find if 5 character is a whitespace if yes → following MMM d yyyy format if no → following MMM dd yyyy format This worked. Happy Face

---

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 May 2021

Top 3 Topics with Most Views

Orchestrator Community - Scheduled Maintenance Downtime made by @Bianca_Duminica with 247 views.

Copy data from html and focus paste into new excel made by @CoolRobot with 32 views.

ファイル内の更新日時取得について made by @nara1 with 31 views.

Top 3 Topics with Most Replies

Substring: How to remove last two element from a string? made by @Tanzill_Ahsan with 23 replies.

How to extract particular string from text? made by @sambulkar with 22 replies.

Ready PDF and get only the specific value between double quotes made by @Gowtham_Srinivasan with 19 replies.

Top 3 Users Who Posted The Most

@prasath17 made 36 posts!

@postwick made 16 posts!

@NIVED_NAMBIAR made 14 posts!

Top 3 Most Liked Posts

This post made by @Bianca_Duminica received 9 likes!

Orchestrator Community - Scheduled Maintenance Downtime

We will be performing infrastructure changes for Orchestrator running on our Automation Cloud - Community instance. Scheduled downtime window for 1 hour: May 13, 19:00 - 20:00 UTC During this maintenance window: some Orchestrator tenants will become unavailable; connected robots will appear as disconnected; the API will return an error code; schedules will not be executed; the user interface will be replaced by a static web page. We’ll keep this topic updated with progress…

This post made by @Priyanka_Bhalere received 2 likes!

Our new look for Orchestrator is here!

Explored the Apollo Design System and its really cool. Specially quick actions and Tenant header color. And can’t stop myself from making a video on it😁 Have a look UiPath Orchestrator Update 2021.5 || Apollo Design System || New Look -Priyanka

This post made by @Geoff received 2 likes!

Release: Automation Cloud Migration Tool

We’re excited to announce that the UiPath Automation Cloud Migration Tool is now live! This freely downloadable tool makes it much easier to move an Orchestrator tenant (or tenants) to Automation Cloud for enterprise from an on-premises installation – it does most of the work for you. [image] If you are considering a migration from on-prem to Automation Cloud for enterprise, this should further reduce the time and effort required. It’s also a great way to start prototyping or evaluating Autom…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

ファイル内の更新日時取得について

こんにちは 繰り返しの中で System.IO.File.GetLastWriteTime(item.ToString) で取得できると思います。DateTime型で返るので、適切な型・フォーマットに変換すると良いかと思います。

This solution provided by @ppr received 2 likes!

Dynamically Adding Columns to DataTable Using LINQ

@ashwin.ashok we can interpretate the case as a certain kind of transponation. Lets assume following sample input: [grafik] we prepare the target Datacolumn structre by a build datatable for the name column and do add the ordered country columns [grafik] with one go we also do create an array with the country names - newColNames Finaly we following LINQ dtData will be transposed accordingly the case requirement (flag with *) [grafik] Result: [grafik] Find starter help here: Transpo…

This solution provided by @prasath_S received 1 likes!

Can i make look up with array

if you mark it as solution, than after 3 days with no replies it will automatically get closed…thanks

---

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

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

[system]

Daily Forum Report | 11 May 2021

Top 3 Topics with Most Views

Get Latest Date with Max function from list (of Match) made by @Sakshi_Jain with 29 views.

How do you deploy the code from one machine to another without studio? made by @aparna3010 with 28 views.

RPA Developer - BANGALORE - India - Full Time - UiPath made by @Vibhor.Shrivastava with 27 views.

Top 3 Topics with Most Replies

Text Error on Excel after write operation made by @Tanzill_Ahsan with 14 replies.

Checking if Column Name exists C# made by @lmoham with 13 replies.

Get Latest Date with Max function from list (of Match) made by @Sakshi_Jain with 13 replies.

Top 3 Users Who Posted The Most

@prasath17 made 37 posts!

@NIVED_NAMBIAR made 30 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @judylee received 4 likes!

Hear first-hand from our CEO Daniel Dines at UiPath Live: The 21.4 Release Show

Hi UiPath Community! After listening to community feedback and evaluating your biggest needs, we’re excited to announce the launch of UiPath 21.4. Discover the latest and greatest features of this release in our upcoming UiPath Live: The 21.4 Release Show on: OPTION 1: 2021-05-20T15:00:00Z (UTC) OPTION 2: 2021-05-21T03:30:00Z (UTC) Watch live as UiPath CPO Param Kahlon introduces new products like Automation Ops and UiPath CEO Daniel Dines shares his view of …

This post made by @rlove received 4 likes!

How to gain deep understanding of automation concepts?

I would recommend attending Devcon to hear from peers in the space. RPA Developer Conference - DevCon 2021 | UiPath. You might also consider participating in the HyperHack (See HyperHack - Automation for Good at UiPath Hackathons) to work on an advanced use case with a group.

This post made by @Vibhor.Shrivastava received 3 likes!

RPA Developer - BANGALORE - India - Full Time - UiPath

Job title: RPA Developer Job role: RPA Developer Country: India City: BANGALORE Company name: UiPath Employment Type: Full Time Seniority level: Associate, 3 to 5 years Job Description: :pushpin:This is what you’ll do at UiPath:- As a RPA developer you will provide solution design’s to customers throughout the deployment and involve in testing and delivering technical training to the clients. Provide solution design’s to customers throughout the deployment of new deals, during POCs and…

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

How to fetch the regex output and write into excel file

Hi @chaithanya_kumar_M Please try this Build datatable output is dtTable1 Matches output is matchColl [image] [image] in add data row activity give Arrayrow as {item.ToString} and Datatable as dtTable1 and in write range give datatable as dtTable1 [image] Thanks

This solution provided by @MikkelNielsen received 2 likes!

UiPath still can't handle emails properly in REF?

UPDATE - THIS WORKS NOW - SEE BELOW Lets talk this through then. This is how we use the REF: I have the Init phase, in which I will extract all the relevant information from each mail, and add this data to the Queue. So this is where I have my For Each, enumerating all the e-mails. Then I got the Process phase that processes each transaction from the Queue. At the end of my Process, I ultimately need to move the mail in question to another outlook/exchange folder. In case the processing of …

This solution provided by @Yoichi received 1 likes!

How to remove a duplicates values from the array and list

Hi, Sorry. I might have misunderstanding. If your expected result is {“value1”,“value2”,“value4”} ,the following Union method works. arrString.Union(arrString).ToArray The above expression : arrString.Where(Function(x) arrString.Count(function(y) y=x)=1).ToArray returns {“value2”,“value4”} 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 May 2021

Top 3 Topics with Most Views

How to remove leading zeros from data table column made by @roysupriya21 with 37 views.

Get queue items pushed in last 1 Hour made by @Sahil_Garg1 with 35 views.

ワークフローを終了と強制終了の違い made by @196006 with 34 views.

Top 3 Topics with Most Replies

Read Range : Couldnt read range [Excel] made by @AS07 with 14 replies.

Open browser activity not working made by @ad2000 with 14 replies.

How to remove leading zeros from data table column made by @roysupriya21 with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 14 posts!

@postwick made 10 posts!

@NIVED_NAMBIAR made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Formating a variable

@Jose_Pedro_Mendes Welcome to the forum PadLeft will help us: [grafik]

This post made by @postwick received 2 likes!

Get queue items pushed in last 1 Hour

Get all the Queue Items and then when processing, check if it was created in the last hour. If not, skip it.

This post made by @ppr received 2 likes!

Linq query to filter using between operator in Datatable

give a try on: [grafik] [grafik] (From x In {"02"} Let dl = dtData.AsEnumerable.toList Let fi = dl.FindIndex(Function (d) d(0).toString.Equals(x)) Let li = dl.FindLastIndex(Function (d) d(0).toString.Equals(x)) From r In dtData.AsEnumerable.Skip(fi).Take(li-fi + 1) Select r).toList then branch: drResult.CopyToDataTable

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Extract the last word using regex

Hi, Can you try the following pattern? \S+$ Regards,

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to remove leading zeros from data table column

Hi @roysupriya21 for this we had to do some modifications in same code as i told above Modified code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Depost”)= If(row(“Depost”).ToString.Length<=6,CInt(row(“Depost”).ToString),row(“Depost”))) Try this and let me know if it works Regards, Nived N Happy Automation

This solution provided by @prasath_S received 1 likes!

How to copy selected rows from one excel to another empty excel file

@WASEEM_KHAN if you can mark this as solution, for others it will be helpful. [image] Thanks

---

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

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

[system]

Daily Forum Report | 13 May 2021

Top 3 Topics with Most Views

データテーブルで横に並んだ情報を縦に整理する made by @kaori.horiuchi with 33 views.

Linq Query on Group By and Sum made by @tmond with 32 views.

Remove &ZeroWidthSpace Unicode character from a string made by @phaniraj.raichooti with 30 views.

Top 3 Topics with Most Replies

Get Index of First Empty Row made by @tilarapiyush with 18 replies.

Cannot Automate a desktop application made by @Penganimation with 11 replies.

Need help with dynamic process made by @ShengChao_Soh with 11 replies.

Top 3 Users Who Posted The Most

@Pankaj.Patil made 9 posts!

@ashwini.magar92 made 8 posts!

@ppr made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to remove datatable1 form datatable2 (datatable2 contains datatable1)

give a try on Assign activity: left side: drResult | Datatype: List(of DataRows) right side: datatable2.Except(datatable1, DataRowComparer.Default).toList If activity: Condition: drResult.Count > 0 then: dtFiltered = drResult.CopyToDataTable else: dtFiltered = datatable2.CopyToDataTable dtFiltered is of datatype: DataTable

This post made by @ppr received 2 likes!

Linq Query on Group By and Sum

@tmond Welcome to the forum We can do it with folloing flow: [grafik] (From d In dtData.AsEnumerable Group d By k=d("Col3").toString.Trim Into grp=Group Let gs = grp.Sum(Function (x) CInt(x("Col2").toString)) Let raa = grp.Select(Function (g,i) If(i=0,g.ItemArray.Append(gs).toArray,g.ItemArray.Append(Nothing).toArray)).toarray From m In raa Select dtResult.Rows.Add(m)).CopyToDataTable And will get: [grafik] Find starter help here: GroupBy_1Col_AddSumToFirstMember.xaml (9.0 KB) Also have…

This post made by @mdiaz2307 received 1 likes!

Generic Value not availalble

Cheers mate.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Linq Query on Group By and Sum

@tmond Welcome to the forum We can do it with folloing flow: [grafik] (From d In dtData.AsEnumerable Group d By k=d("Col3").toString.Trim Into grp=Group Let gs = grp.Sum(Function (x) CInt(x("Col2").toString)) Let raa = grp.Select(Function (g,i) If(i=0,g.ItemArray.Append(gs).toArray,g.ItemArray.Append(Nothing).toArray)).toarray From m In raa Select dtResult.Rows.Add(m)).CopyToDataTable And will get: [grafik] Find starter help here: GroupBy_1Col_AddSumToFirstMember.xaml (9.0 KB) Also have…

This solution provided by @StefanSchnell received 1 likes!

SAP Read ICDataFlowCtrl (interactive flowchart)

@jack.chan Hello Jack, this control is embedded in an SAP docking control and it is not supported by the SAP GUI Scripting. Best regards Stefan

This solution provided by @prasath17 received 1 likes!

Write range, append function not working

@Dennon_Seet - I was able to achieve it using the counter … [image] Workflow file: WriteRange_Append.zip (159.4 KB) Note: Save for Later activity is available in the version starting 20.10.6 i guess… Hope this helps…

---

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

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

[system]

Daily Forum Report | 14 May 2021

Top 3 Topics with Most Views

📢 Announcing Use Cases Repository on our Forum made by @Vibhor.Shrivastava with 164 views.

Amazon - Automation Program Manager - Hyderabad - India - Full Time made by @dhyani_bhangre with 66 views.

Xebia - Depends on Work Exp - Delhi - India - Full Time made by @Shubham_Varshney with 37 views.

Top 3 Topics with Most Replies

In between time data filter made by @Harish_pavuluri with 23 replies.

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails made by @sreekanta_yogesh_krishna with 9 replies.

Can any one please help with this..its bit urgent made by @Seema_S with 8 replies.

Top 3 Users Who Posted The Most

@prasath_S made 9 posts!

@Yoichi made 9 posts!

@prasath17 made 8 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 9 likes!

Announcing Use Cases Repository on our Forum

[UiPath-LinkedIn-14May21.usecase] Happy to announce we now have the Use Cases Repository. This will enable you to learn from others and share Use Cases specific to Domains, Products & Skills wise. Well-written use case works as an invaluable guidebook to gain learning experience. Community members, be it a student, a citizen developer, an advanced user, or a beginner in the RPA field - are always looking for a guide that can help them gain RPA experience for their ca…

This post made by @mukeshkala received 2 likes!

We need YOU ...Influence Our Next Big Thing

Registered , Looking Forward for the connect

This post made by @StefanSchnell received 2 likes!

Tip: How to Find the Correct SAP Table

The RFM Code Generator offers the possibility to create code to read data from SAP transparent tables or views, via the SAP standard RFM RFC_READ_TABLE. But when data is to be loaded from an SAP system, the question very often arises in which tables can be found in. A very good approach is to start the transaction code (TAC) and to take a look at the selection screen. In our example the TAC VA03, Display Sales Order. [image] Select the field of interest, in our example Order, and press key F1.…

Top 3 Most Liked Solutions

This solution provided by @Pankaj.Patil received 1 likes!

Changing and merging the names of more than one attachment from the email

Yes, you will get… // Create empty datatable that store all files data each time loop executes. Dim datatableFinal as Datatable = New Datatable() strFileArray = Directory.GetFiles(“your_Files_Path”, “*.excel”) — please explore more on google. for each file in strFileArray { // Perform above steps given. // Provide datatableFinal to output property of Merge datatable activity. }

This solution provided by @shinji received 1 likes!

メッセージボックスのボタン選択で処理を分岐させる

条件欄に IF( 選択 = "Yes", True, False) または 選択 = "Yes" と書けば出来ると思います。 IFで書くのは「三項演算子」と言って、IF分岐を1行で記述する方法ですが、色々応用が出来ます。 例） メッセージをログアクティビティでメッセージに IF( 実行フラグ, “実行するよ”, “実行しないよ”) と指定する

This solution provided by @Eric_Wong_Test received 1 likes!

It is possible to set default value via parameter in Uipath Form Activities?

If you want have default value in text field, make sure the value name is same with field key [Screenshot 2021-05-14 165255] [Screenshot 2021-05-14 165314] [Screenshot 2021-05-14 165344]

---

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 May 2021

Top 3 Topics with Most Views

Extract table from raw text made by @rameezimtiaz with 30 views.

UiPath Robot Error: Cannot Create Unknown Type made by @ShengChao_Soh with 24 views.

Multiple lookups made by @abhide with 24 views.

Top 3 Topics with Most Replies

Multiple lookups made by @abhide with 22 replies.

Error: “Assign: Object reference not set to an instance of an object” while running Client Security Hash main.xaml file made by @Svitlana with 19 replies.

Extract table from raw text made by @rameezimtiaz with 16 replies.

Top 3 Users Who Posted The Most

@copy_writes made 29 posts!

@wasea made 22 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 3 likes!

UiPath - RPA Pre-sales Engineer - BANGALORE - India - Full Time

Job title: RPA Pre-sales Engineer Job role: Other Role Country: India City: BANGALORE Company name: UiPath Employment Type: Full Time Seniority level: Junior, 1 to 2 years Job Description: This is what you will be doing at UiPath: Build and deliver custom made industry specific demos for new prospects and clients. Create powerful POC’s (Proof Of Concepts) for prospects and customers. Be an evangelist of UiPath automation tools by identifying customer needs and showcasing the best solut…

This post made by @copy_writes received 2 likes!

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails

Ok buddy Hear is the solution [image] [image] SendMiailToStudents.zip (15.2 KB) If you get the solution mark as the solution and close the topic if have any drought in this above topic ping me I will help you Note: Student ID should be unique and in both Excel file ID of the Student Should be same example Student Chethan ID is 1 In DT1 and in The DT2 Also Same ID for Chethan I Use Message Box you replace and use mail activity regards Chethan P

This post made by @sreekanta_yogesh_krishna received 1 likes!

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails

thank you very much for your kind and detailed reply yeah please share the sample XML file, Thank you once again.

Top 3 Most Liked Solutions

This solution provided by @copy_writes received 2 likes!

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails

Ok buddy Hear is the solution [image] [image] SendMiailToStudents.zip (15.2 KB) If you get the solution mark as the solution and close the topic if have any drought in this above topic ping me I will help you Note: Student ID should be unique and in both Excel file ID of the Student Should be same example Student Chethan ID is 1 In DT1 and in The DT2 Also Same ID for Chethan I Use Message Box you replace and use mail activity regards Chethan P

This solution provided by @prasath17 received 1 likes!

DateDiff always returns 0

@Alex_Tee - Can you please as below DateDiff(dateinterval.Day,Convert.todatetime(Start_Date),Convert.todatetime(End_Date)) Sample Input and Output [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 | 16 May 2021

Top 3 Topics with Most Views

Move the file to respective folder using excel reference made by @vijayabhaskar1987 with 36 views.

How to sum values in different excel sheets made by @chickennuggets with 35 views.

Question for excel made by @anon with 29 views.

Top 3 Topics with Most Replies

Move the file to respective folder using excel reference made by @vijayabhaskar1987 with 21 replies.

Please help with reading specific range without sheet number made by @jing_jing with 8 replies.

Chrome Tab Unique Identifier/Scraping - Uipath Scrapes the 1st tab instead of the 2nd made by @Daniel-F with 8 replies.

Top 3 Users Who Posted The Most

@copy_writes made 34 posts!

@prasath17 made 10 posts!

@259_Utkarsh_Tripathi made 9 posts!

Top 3 Most Liked Posts

This post made by @copy_writes received 2 likes!

How to keep open excel file until entire project execute

Simple Use excel scope application inside that you automate [image] if you need to open the application you have use open application activity. excel application scope is read the excel file and if excel file is open it wont through error i Hope you get the solution and please mark it as solution and close the thread Regards Chethan P

This post made by @prasath17 received 2 likes!

Regex extraction from html

@Druidtier3 - Please try this… [image] Regex Pattern = https:.+(?=\”\>here. This link will expire in 1 hour.) Sample workflow with output [image]

This post made by @Srini84 received 2 likes!

Move the file to respective folder using excel reference

@vijayabhaskar1987 check below, This should in For Each row activity [image] Hope this may help you Thanks

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Regex extraction from html

@Druidtier3 - Please try this… [image] Regex Pattern = https:.+(?=\”\>here. This link will expire in 1 hour.) Sample workflow with output [image]

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

The output of mail.body

please try href=\W(.*?(?=\W\Where\. This link will expire in 1 hour)) [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 | 17 May 2021

Top 3 Topics with Most Views

One Page You Should Bookmark - RPA Use Case Repository Guide made by @Lahiru.Fernando with 241 views.

Get multiple Files in Folder and send it In Email made by @Vincent_Nuestro with 57 views.

Click the list based on the three letter code made by @Sudharsan_Ka with 44 views.

Top 3 Topics with Most Replies

Click the list based on the three letter code made by @Sudharsan_Ka with 18 replies.

Regex to fetch table data from text file made by @rameezimtiaz with 18 replies.

Check digit number of a column made by @jntrk with 15 replies.

Top 3 Users Who Posted The Most

@prasath17 made 43 posts!

@copy_writes made 20 posts!

@Sakshi_Jain made 19 posts!

Top 3 Most Liked Posts

This post made by @Lahiru.Fernando received 10 likes!

One Page You Should Bookmark - RPA Use Case Repository Guide

Learning is a process that never stops. Every journey we get on board starts by learning. Learning gives you the knowledge, and applying the knowledge you gained gives you experience. UiPath Academy is a great resource to learn the basics and advanced functionalities of the UiPath platform and RPA as a whole. Have you ever wondered where we can find resources to apply the knowledge to gain experience in the world of RPA? Finally… that resource we all were waiting for is now available… U…

This post made by @iulian.mircea received 2 likes!

Timeout property if the SAP session has hang or disconnected

Hi all, Thanks for your feedback! Can you please tell me which statement better describes your situation? The activity (SAP.ReadStatusBar or other, like a Click which triggers a time-consuming operation in SAP) would succeed if you gave it enough time. But you still want it to fail, if it takes longer than a precise amount of time. Eg: the activity succeeds in 31 seconds, but you want it to fail if timeout is set to 30 seconds. The activity has no chance to succeed, no matter how big the…

This post made by @prasath17 received 2 likes!

SAP Download Data

@Markus3003 - For Each type should be string… Inside the For Each add write Line and just print ‘file’ and check whether its reading all the files… Looks like this is off the topic from what you initially enquired, could you please open a new topic and discuss about this… Kindly close this thread, if you already received a solution from Stefan.

Top 3 Most Liked Solutions

This solution provided by @Pankaj.Patil received 2 likes!

How to select a outlook account

@Tharusha.fernando, You can set accounts as default by following weblink as below, How to Make Outlook Open to a Specific Default Account.

This solution provided by @Yoichi received 2 likes!

配列をランダムに並び替えるには？

こんにちは 以下でいかがでしょうか？ [img20210517-7] 本番で利用するときは、Randomクラスに適当なseedを与えてください。

This solution provided by @prasath17 received 2 likes!

While reading excel data for time base it is throwing error

Hi @GouthamVijay - Initial query provided by me in his previous post works like a charm…The reason why it is failing is Time Column has a blank data. So i just used another LINQ query to filter the Non Blank and ran the same code previous used and it ran successfully. [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.