Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 April 2021

Top 3 Topics with Most Views

Filter some data in excel file made by @maroua301 with 26 views.

PDF content in to in to excel table made by @srilakshmi_Tippireddy with 24 views.

Loop through application until data table is null? made by @Tristan_Stumpf with 24 views.

Top 3 Topics with Most Replies

Need help with data scraping from sub links made by @tabbyd with 8 replies.

PDF content in to in to excel table made by @srilakshmi_Tippireddy with 7 replies.

How to get latest downloaded file in a workflow or sequence? made by @Vishal_Singh1 with 5 replies.

Top 3 Users Who Posted The Most

@wasea made 9 posts!

@Mikolaj_Zielinski made 7 posts!

@Shraddha_Gore made 6 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 3 likes!

PDF content in to in to excel table

@srilakshmi_Tippireddy - I will try my best to provide the patterns by looking at the pic… TO: (?<=TO\s?:).*(?=\sINVOICE) For the above use…Regexvar(0).value.trim… INVOICE NUMBER = (?<=ISSUE DATE\r\n\s+)\w+ ISSUE DATE = (?<=ISSUE DATE\r\n\s+\w+\s+)\w+ CUSTOMER CODE = (?<=DUE DATE\r\n.*)\S+(?=\s+\d{2}\w{3}\d{4}) INR = (?<=GRAND TOTAL AMOUNT IN\s?)\w{3} AMOUNT = (?<=GRAND TOTAL AMOUNT IN.*)[\d.]+ Hope this helps…

This post made by @prasath17 received 2 likes!

Move various files with the same extension type

Hi @Cruz_Becerril_Alliso - Please try this… Directory.GetFiles(Environment.ExpandEnvironmentVariables("%USERPROFILE%\Downloads\"),"*.xml") [image] For Each "Type Argument’ is string. Hope this helps…

This post made by @Shriharsha_H_N received 1 likes!

Uipath Marketplace ! BalaReva Word Activities

Thanks @balupad14 its working now i updated the package

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

Top 3 Topics with Most Views

How to access the offcial and connet packages? made by @fightblue with 29 views.

How to delete a last row in excel file when the data is dynamic? made by @Vishal_Singh1 with 28 views.

https://forum.uipath.com/t/310189 made by @fairymemay with 28 views.

Top 3 Topics with Most Replies

How to resolve 'Copy Sheet' error in excel? made by @Dorothy_lee with 15 replies.

Not able to maximize the window from taskbar made by @Vishal_Singh1 with 15 replies.

Condition always true! made by @Mohammed_Bakr with 6 replies.

Top 3 Users Who Posted The Most

@wasea made 13 posts!

@prasath_S made 7 posts!

@Vishal_Singh1 made 6 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 2 likes!

Invoke Vb.NET Code dictionary error

Hi @Hara_Gopal In UiPath you have to create a new dictionary variable inside invoke code and assign that dictionary to your output dictionary variable. Try this, Dim dict As New Dictionary (Of String, String) Dim item, key, val As String Try For Each item In lst 'lst is a list passed as input key = item.Split(CChar(“:”))(0).ToString.Trim val = item.Split(CChar(“:”))(1).ToString.Trim dict.Add(key, val) Next emailDict = dict Catch e As Exception console.WriteLine(e) console.WriteLin…

This post made by @NIVED_NAMBIAR received 2 likes!

Invoke Vb.NET Code dictionary error

Hi @Hara_Gopal I think u had forget to declare the dictionary Can u try this code Dim dictionary As New Dictionary (Of String, String) Dim item, key, val As String Try For Each item In lst 'lst is a list passed as input key = item.Split(CChar(":"))(0).ToString.Trim val = item.Split(CChar(":"))(1).ToString.Trim emailDict.Add(key, val) Next Catch e As Exception console.WriteLine(e) console.WriteLine(e.Message) console.WriteLine(e.Source) End Try Regards Nived N …

This post made by @pat_lee received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Everyone, I am Patrick. I have been a software consultant for more than 25 yrs, My Job is to train people in accounting software and management reporting. With uipath I hope I can intergrade Uipath to the software to make its more easier to generate report.

Top 3 Most Liked Solutions

This solution provided by @wasea received 1 likes!

Download file from web to a specific folder

hello @Brennan_Montoni , You can use the Wait for download activity to do this. try and let us know if works. Vasile.

---

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

Top 3 Topics with Most Views

What's new in Action Center 21.4? made by @Liji with 37 views.

Save Attachment - Length cannot be less than zero made by @Louis_liu with 36 views.

Splitting Excel in various columns made by @Yudhisteer_Chintaram1 with 34 views.

Top 3 Topics with Most Replies

Delete rows in excel if value in a column is "D" made by @Brennan_Montoni with 19 replies.

Splitting Excel in various columns made by @Yudhisteer_Chintaram1 with 17 replies.

How to pull out all files with modified date less than seven days in a folder? made by @Kelsey_Dane with 17 replies.

Top 3 Users Who Posted The Most

@Jayesh_678 made 26 posts!

@Pankaj.Patil made 19 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Liji received 6 likes!

What's new in Action Center 21.4?

Since our last updates in 20.10 where we released a dedicated Action Center portal for business users, we have been focusing on enabling our customers to scale operations using Action Center based automations by on-boarding more business users as well as by broadening the scenarios being automated. What’s new in business user experience and Actions handling ? Multi-user handling of Form Actions by forwarding Actions to other Users [ForwardActions] Action summary panel to keep track of th…

This post made by @alvaro.j.nobre received 2 likes!

UIPath Studio freezes when I right click on project

That solved it. Thank you for your quick and effective response.

This post made by @Yoichi received 2 likes!

携帯電話にSMSを送信したい

こんにちは UiPathからの直接のSMS送信は難しいので、Twilio等のサービスを経由して行う場合が多いかと思います。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

携帯電話にSMSを送信したい

こんにちは UiPathからの直接のSMS送信は難しいので、Twilio等のサービスを経由して行う場合が多いかと思います。

This solution provided by @Srini84 received 1 likes!

Error: Object invoked has disconnected from its client?

@SIM_JUN_HUI_BERTRAM_CSOD can you share your screenshot of workflow? Also tell us is it causing due to looping into many files? Thanks

This solution provided by @Yoichi received 1 likes!

範囲を読み込みが途中で終わってしまう

こんにちは Localsパネルのビューアーはすべての情報を出力するわけではないので、今回のケースの確認方法と してはあまりよくないと思います。 WriteLineやLogMessageあるいは、ブレイクポイントで実行を停止しているなら Immediateパネルで dt.Rows.Countの様にDataTableの行数を確認してみると 良いように思います。 [img20210426-6]

---

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

Top 3 Topics with Most Views

🚀 Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16 made by @teresa with 60 views.

Object Detection Virtual Event - Discussion made by @Radu_Buciu with 36 views.

How to find month before today 3 days (working day)? made by @fairymemay with 28 views.

Top 3 Topics with Most Replies

データテーブルの値を配列に変換したい made by @zuka with 14 replies.

How to take cc from excel sheet while sending mail in uipath made by @Sudha_Jha with 13 replies.

Excel Update - Help made by @Anjali_Rani with 12 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 26 posts!

@prasath17 made 18 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @teresa received 10 likes!

Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16

Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16. We’re excited to share that UiPath DevCon is BACK for 2021! Read more below or register right away! Our annual conference by developers, for developers is coming up this June 15-16, 2021. This virtual event brings together our technical community around the world for two days of learning, building, and connecting. We’re covering topics like Inter-process Communication, Object Repository, an…

This post made by @Radu_Buciu received 6 likes!

Object Detection Virtual Event - Discussion

Hi! I’m Radu from Neurolabs. We have created this topic to discuss about object detection in the UiPath workflows. We encourage you to share your thoughts, challenges, use cases or any ideas related to this topic. Let’s extend the current RPA capabilities beyond the screen by identifying objects in images or videos! What will follow is a webinar 2021-04-28T11:30:00Z (UTC). You can join it here:

This post made by @Geoff received 2 likes!

New enterprise-scale features now live!

With today’s regular update of Automation Cloud, we’re excited to announce that the following new enterprise-scale features have moved out of preview to be fully available (some today, some last week). These features focus on lowering your total cost of ownership for automation and making your automation environment easier to manage with better compliance. Automation Cloud for Enterprise customers can now exclusively take advantage of: Azure AD Integration : Customers with an Azure AD get aut…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Get specific tags from an XML document

Hi, Do you want to extract “ClaveProdServ” attribute and “Importe” attribute? If so, the following helps you. [img20210427-1] Sample20210427-1.zip (5.3 KB) Regards,

This solution provided by @Rome received 1 likes!

Uipath Studio shows blank

Hi All, Issue resolved. From my end we are suspecting some license issue connecting to orchestartor. What we did is we updated via Home>Setting>License and Profile>Change Local License. We select acquire license to orchestrator then auto restart the uipath studio. open again the studio select the workflow and you will encounter the same as per screenshot above. But when you click NEW…in the background the workflow appear. see screenshot below. [uipath]

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to find month before today 3 days (working day)?

Hi @fairymemay I had updated the workflow check this Main.xaml (13.2 KB) the output i got [image] Regards, Nived N Happy Automation

---

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