Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 January 2022

Top 3 Topics with Most Views

Condition in if error? made by @fairymemay with 54 views.

How to replace particular word from string in excel without using For each made by @Vinit_Mhatre with 46 views.

https://forum.uipath.com/t/395239 made by @xxGoRpa with 45 views.

Top 3 Topics with Most Replies

Condition in if error? made by @fairymemay with 27 replies.

Issue on using type info into a Web Calendar made by @Jim_Yang_1117 with 14 replies.

I want to check only starting words matching with keywords made by @Mansi_Mhatre with 12 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 33 posts!

@fairymemay made 15 posts!

@Vinit_Mhatre made 13 posts!

Top 3 Most Liked Posts

This post made by @Arun_Thimmaiah received 2 likes!

Submit your use case to earn a 50% discount on advanced certification voucher

Thanks @Vibhor.Shrivastava @Oana_Chicioroaga @loginerror for the opportunity and happy to support Uipath Community , I have received 50% discount voucher. Keep encouraging and keep growing.

This post made by @Nithinkrishna received 2 likes!

Condition in if error?

Cool @kirankumar.mahanthi1 Very thanks for that prompt help. @fairymemay, Kindly check please… Thanks #nK

This post made by @kirankumar.mahanthi1 received 2 likes!

Condition in if error?

For me perfectly working fine. please check the suggestion from Nitin @Nithinkrishna [image]

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Condition in if error?

Kindly correct the Address2 spelling in the input sheet. For the data count you mentioned, is it input sheet data or the other sheet…? Hopefully that shouldn’t be an issue… Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

How can we build an API request to kill the running process in the Orchestrator?

Hey @sandeep_thota Here you go… [IMG_20220129_135802] You can access this from your swagger for ref <Orch Url>/Swagger Hope this helps. Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

I had my output as string and i want to add to dictonary (string ,object). But getting object reference not set

Hey @MitheshBolla For C#, new Dictionary<String,Object>() Please make sure you do the same, n should be small in new. Thanks #nK

---

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

Top 3 Topics with Most Views

How to manipulate a row item in a data table and "update" the data table made by @Botter with 49 views.

Pass variable to linq? made by @fairymemay with 38 views.

I had a variable of type JObject which contains id and its value,name and its value and address and its value. , i need to get Name . i am getting error if i use this DruidConfig["Name"].ToString() made by @MitheshBolla with 38 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/395313 made by @xxGoRpa with 10 replies.

System.Text.RegularExpressions.Regex.Replace(new_String.Substring(var_Start_Index, var_End_Index - var_Start_Index), @"[\s]{3,}", "|" made by @Rateb_Thor with 10 replies.

How to manipulate a row item in a data table and "update" the data table made by @Botter with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 25 posts!

@Nithinkrishna made 21 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @fairymemay received 2 likes!

Pass variable to linq?

Now I use linq as below. [image] But I want change from text Voucher to variable in TypeVoucher (voucher,central) [image] Please guide me about it.

This post made by @Nithinkrishna received 2 likes!

Pass variable to linq?

Hey @fairymemay Kindly check this now please… It was due to a bracket mismatch. OutputDT.AsEnumerable.Where(Function(x) _ TypeVoucher.Contains(x("Premium").ToString) AndAlso x("Type Special").ToString.Equals("Yes") OrElse (x("Premium").ToString.Equals("เงินคืนเข้าบัญชีเงินฝาก SCB") Or x("Premium").ToString.Equals("เงินคืนเข้าบัตรเครดิต SCB")) AndAlso x("Type Special").ToString.Equals("Yes") AndAlso String.IsNullOrWhiteSpace(x("Account No").ToString)).ToArray Thanks #nK

This post made by @ppr received 2 likes!

Deleting middle rows in dataTable

Give a try on following: Assign Activity LHS: dtReduced | DataType: DataTable RHS: dt.AsEnumerable.Where(Function (x,i) i < 5 or i > dt.Rows.Count - 6).CopyToDataTable dt = your Origin DataTableVar

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Pass variable to linq?

Hey @fairymemay Kindly check this now please… It was due to a bracket mismatch. OutputDT.AsEnumerable.Where(Function(x) _ TypeVoucher.Contains(x("Premium").ToString) AndAlso x("Type Special").ToString.Equals("Yes") OrElse (x("Premium").ToString.Equals("เงินคืนเข้าบัญชีเงินฝาก SCB") Or x("Premium").ToString.Equals("เงินคืนเข้าบัตรเครดิต SCB")) AndAlso x("Type Special").ToString.Equals("Yes") AndAlso String.IsNullOrWhiteSpace(x("Account No").ToString)).ToArray Thanks #nK

This solution provided by @ppr received 1 likes!

Deleting middle rows in dataTable

it about LINQ we used an indexed where statement and i is representing the poisition/row index from the processed collection of datarows

This solution provided by @Nithinkrishna received 1 likes!

Replace text in excel?

Hey @fairymemay Here you go… nmnithinkrishna_DTColBulkUpdate.zip (13.5 KB) Hope this helps Thanks #nK

---

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

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

[system]

Daily Forum Report | 31 January 2022

Top 3 Topics with Most Views

All about Datetime - UiPath made by @Palaniyappan with 50 views.

UiPath Queue Triggers - InProgress item made by @MohammadAljaafreh with 46 views.

How can I click on a button without getting detected by a web page? made by @lsl with 45 views.

Top 3 Topics with Most Replies

How to Add the Data in Ascending order made by @anurita.mishra with 17 replies.

Delete Excel rows with specific value made by @Ritika_Singh with 15 replies.

Can't Extract Text made by @raja_ias with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 42 posts!

@Nithinkrishna made 39 posts!

@Gokul001 made 15 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 12 likes!

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

This post made by @pikorpa received 4 likes!

I have problem with IMAP

Hey @rpa6 , for gmail you have to enable IMAP on your account settings: Sign in to your Gmail account by using a browser that is supported (Google Chrome, Firefox, Internet Explorer, or Safari). Choose or click the gear icon ([Choose the Gmail gear icon.]) on the top right. Choose Settings > Forwarding and POP/IMAP . Select Enable IMAP , and then choose Save Changes . Don’t forget to switch on the ‘less secure apps’ option: Click Security > Basic settings . Under Less secure apps, select G…

This post made by @AMALRAJ received 3 likes!

Send smtp mail message unknown host

Hi @Raul_Palma Change your smtp host at the right side of the properties panel, there is some spelling mistake at the first screenshot you write it as smpt instead of smtp try with @Palaniyappan feedback also. Make a try may be its work. Happy mail automation. Regards AMAL

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 4 likes!

I have problem with IMAP

Hey @rpa6 , for gmail you have to enable IMAP on your account settings: Sign in to your Gmail account by using a browser that is supported (Google Chrome, Firefox, Internet Explorer, or Safari). Choose or click the gear icon ([Choose the Gmail gear icon.]) on the top right. Choose Settings > Forwarding and POP/IMAP . Select Enable IMAP , and then choose Save Changes . Don’t forget to switch on the ‘less secure apps’ option: Click Security > Basic settings . Under Less secure apps, select G…

This solution provided by @AMALRAJ received 3 likes!

Send smtp mail message unknown host

Hi @Raul_Palma Change your smtp host at the right side of the properties panel, there is some spelling mistake at the first screenshot you write it as smpt instead of smtp try with @Palaniyappan feedback also. Make a try may be its work. Happy mail automation. Regards AMAL

This solution provided by @Palaniyappan received 2 likes!

Read data from another column

Then mention like this str_monthnumber = Convert.ToInt32(Datetime.ParseExact(Strinput.ToString, “MMM”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM”)).ToString Cheers @fairymemay

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

@Yoichi received 55 likes for their solutions!

@ppr received 40 likes for their solutions!

@pikorpa received 26 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 February 2022

Top 3 Topics with Most Views

Convert txt to excel? made by @fairymemay with 54 views.

How to Add condition (LINQ) made by @fairymemay with 48 views.

開いているウェブページのURLを取得したい made by @HANAKO with 45 views.

Top 3 Topics with Most Replies

How to Add condition (LINQ) made by @fairymemay with 18 replies.

Convert txt to excel? made by @fairymemay with 15 replies.

String Not Recognized as a Valid Date Time made by @Dr_Raza_Abidi_PhD with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 41 posts!

@Nithinkrishna made 26 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 5 likes!

How to use a Windows Forms UI

In some cases, with attended bots, it could be necessary to input data into the automation workflow. As long as we work in desktop environments, we have everything aboard to enable such inputs on a simple way. In this post I describe an example of how to use Windows Forms UI. Windows Forms UI DLL Windows Forms is a UI framework to create rich desktop client apps for Windows. We can use Windows Forms for the compatibility modes Windows - Legacy (dotNET Framework 4.61 - x86 architecture) and Wind…

This post made by @Oana_Chicioroaga received 2 likes!

Submit your use case to earn a 50% discount on advanced certification voucher

Hello community fellows, Thank you all for the amazing contribution! Our use case repository has been significantly enriched. We appreciate you for joining us in this learning and sharing campaign. Now we are closing it as the first 50 approved use cases are achieved! If your use case was added after that deadline, you won’t qualify for voucher. In any case, we do encourage you to share your knowledge and make your voice known. Enjoy your learning journey and use the vouchers until May 2022. …

This post made by @ppr received 2 likes!

Counting the full KeyValuePair in transaction item variable

TransactionItem.SpecificContent.Where(Function (kvp) isNothing(kvp.Value) OrElse String.IsNullOrEmpty(kvp.Value.toString.Trim)).Count

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Counting the full KeyValuePair in transaction item variable

TransactionItem.SpecificContent.Where(Function (kvp) isNothing(kvp.Value) OrElse String.IsNullOrEmpty(kvp.Value.toString.Trim)).Count

This solution provided by @Gokul001 received 2 likes!

How to Convert this string to date type

Hi @Gopikrishna_S Try this below expression DateTime.ParseExact(“Input string”,(“ddMMyyyy”),Globalization.CultureInfo.InvariantCulture).ToString(“ddMMyyyy”) ddMMyyyy - Your conversion format. For more info refer the post Hope it will works Regards Gokul

This solution provided by @StefanSchnell received 1 likes!

Where to add license information to nupkg template

@nicortak Hello Nico, to add license URL and other stuff very comfortable you can use NuGet Package Explorer, a fantastic tool. [image] Best regards Stefan

---

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

Top 3 Topics with Most Views

How to extract using both substring and split method made by @ydash999 with 43 views.

Write range date formatting made by @kl_kl with 41 views.

Robot Names made by @Balan with 41 views.

Top 3 Topics with Most Replies

Write range date formatting made by @kl_kl with 15 replies.

How to get sheets from Excel or check if sheet name exist made by @vlast with 14 replies.

Robot Names made by @Balan with 13 replies.

Top 3 Users Who Posted The Most

@ppr made 22 posts!

@Gokul001 made 19 posts!

@supermanPunch made 18 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 7 likes!

Monthly Forum rewards - January 2022

Congratulation All the winners

This post made by @Palaniyappan received 7 likes!

Monthly Forum rewards - January 2022

Congratulations everyone And thanks for this initiative Awaiting to share and see great ideas Cheers

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - January 2022

Congratulation to all the reward winners

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

How can I use if condition for perticular browser window?

HIb @Jalan_Pranav For getting an bool Value. you can use “Element Exist Activity” Indicated the appropriate browser → Create an output variable in the properties panel (BoolBrowser) You can use “IF condition” → BoolBrowser Then → “Kill Process” [image] Hope it will help you Regards Gokul

This solution provided by @supermanPunch received 2 likes!

How to add all key value of a dictionary

Hi @ramadhani.sheffi , For a more dynamic approach to Sum up all of the Values of the Dictionary (Provided all values are numbers), we can use the below Expression : myDict = new Dictionary(of String, String) From {{"A","10"},{"B","20"}, {"C", "30"},{"D","40"}} TotalSum = myDict.Values.Sum(Function(x)CDbl(x)) Where TotalSum is of the data Type Double, myDict is of Data Type Dictionary(Of String,String)

This solution provided by @supermanPunch received 2 likes!

String Not Recognized as a Valid Date Time

Hi @Dr_Raza_Abidi_PhD , As per the Data that was Provided, the dates read by the Read Range activity is converted into an OADate representation and Hence we were not able to convert the Date properly since it is a Double value. By Debugging we can get to know the value of the Date at Run Time. [image] For Handling such changes in datetime values, we could use a Try Catch on the First Conversion in Assign and then in the Catch Block we could use the Conversion from OADate as Shown in the Imag…

---

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

Top 3 Topics with Most Views

How to solve this Write Range error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again? made by @111962 with 46 views.

6 months experience as RPA Developer made by @uicoda with 45 views.

HOW TO RUN A ROBOT WHEN WINDOW IS LOCKED made by @gap with 41 views.

Top 3 Topics with Most Replies

Read Range - Workbook Does made by @allwynbazil with 21 replies.

Cron Expression: Daily at 02:00 Between Second and Second to Last day of each Month made by @Neetu_Goyal with 16 replies.

How to solve this Write Range error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again? made by @111962 with 15 replies.

Top 3 Users Who Posted The Most

@Shikhar_Tandon made 22 posts!

@Gokul001 made 20 posts!

@Nithinkrishna made 18 posts!

Top 3 Most Liked Posts

This post made by @THIRU_NANI received 6 likes!

Monthly Forum rewards - January 2022

Congratulations Guys

This post made by @Srini84 received 6 likes!

Monthly Forum rewards - January 2022

Congratulations to every one, I’m happy to take part into this initiative and good to see many great minds sharing their knowledge to forums I feel every one is winner who are sharing there knowledge with others , Keep rocking guys Thanks Srini

This post made by @Ahmad_Rais received 6 likes!

Monthly Forum rewards - January 2022

congratulation everyone , just last month i posted on the [Monthly Forum rewards ] hoping i will be the up there, and here i am , with the help of everyone @AndersJensen @pravin_calvin @Gokul001 @Yoichi and others who i usually watch and seek for solution , i am able to gain more knowledge and then helping others also!! cheerrs everyone and thank you , next target TOP 1O

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to solve this Write Range error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again?

Hi, ExcelWriteRange throws exception if there is hidden column or row, as the specification of Excel activities package 2.8.5 or above. So, downgrade Excel activities package to 2.8.4 or lower might resolve this issue. Or can you try to write range to another sheet, then copy it to the target area using other activity? Regards,

This solution provided by @Gokul001 received 2 likes!

How to check the previous date

Hi @vaishali Use Assign activity LHS - Create an variable RHS - Below condition Convert into integer to get only Month CInt( DateTime.ParseExact(“Input String”,(“yyyy MM dd”),Globalization.CultureInfo.InvariantCulture).ToString(“MM”)) Convert into integer to get only Year CInt( DateTime.ParseExact(“Input String”,(“yyyy MM dd”),Globalization.CultureInfo.InvariantCulture).ToString(“yyyy”)) Hope it will works Regards Gokul

This solution provided by @Nithinkrishna received 1 likes!

Modify column values of datatable based on specific condition

Hey @ahmad.sultan Here you go… [nmnithinkrishna__Uipath] PFA - nmnithinkrishna_ConsRowsTimeDiff.zip (8.5 KB) Hope this helps. Thanks #nK

---

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

Top 3 Topics with Most Views

https://forum.uipath.com/t/396683 made by @nvignesh456 with 62 views.

Delete row in excel in value in column = 0 made by @fairymemay with 53 views.

Clarifications in the usage of parallel activity made by @Mohan_Vasan with 52 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/396683 made by @nvignesh456 with 19 replies.

Delete row in excel in value in column = 0 made by @fairymemay with 14 replies.

How to move the folder which is in a same directory made by @Doonline with 14 replies.

Top 3 Users Who Posted The Most

@nikhil.girish made 22 posts!

@Yoichi made 20 posts!

@Nithinkrishna made 16 posts!

Top 3 Most Liked Posts

This post made by @lieehoma0 received 2 likes!
https://forum.uipath.com/t/396009/20

This post made by @Cristian_Negulescu received 2 likes!

If, Switch and While inside UiPath Studio | UiPath in 5 minutes | Ep:17

If, Switch and While inside UiPath Studio | UiPath in 5 minutes | Ep:17 [If, Switch and While inside UiPath Studio | UiPath in 5 minutes | Ep:17] #uipath #decision #5minutes

This post made by @ANSHUL received 2 likes!

ピクチャーインピクチャーの使い方

このビデオをチェックして、それが役立つことを願っています：

Top 3 Most Liked Solutions

This solution provided by @pravin_calvin received 2 likes!

Delete row in excel in value in column = 0

Hi @fairymemay Please refer to the attached Screen Shot below! [image] Expression readDt.AsEnumerable().Where(Function(row) Not(row(“Amount”).ToString.Equals(“0”))).CopyToDataTable Result [image] Regards

This solution provided by @HANACCHI received 1 likes!

ピクチャーインピクチャーの使い方

デバッグタブでピクチャーした後、実行してますよね？ 別窓が開いて、初回ログインモードになりますのでご自分のアカウントでログイン…

This solution provided by @Raviteja_N received 1 likes!

Delete rows from Excel then write to same sheet

@kasey.betts the one which provided by @Nithinkrishna works pretty well. since you don’t want the values matches fiscal year, place a “not” in the query. dt1.AsEnumerable().Where(Function(x) Not YearArray.Contains(Convert.ToString(x(“FiscalYear”)))).CopyToDataTable 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 | 05 February 2022

Top 3 Topics with Most Views

Re-Framework not giving expected output whenever queue get trigger made by @Vinit_Mhatre with 41 views.

Localized OCR Engine made by @vincent.zheng with 36 views.

Download File Into Specific Folder made by @Sarah_Syed with 35 views.

Top 3 Topics with Most Replies

Re-Framework not giving expected output whenever queue get trigger made by @Vinit_Mhatre with 13 replies.

Unable to display pdfs dynamically on the form made by @Yousuf_Ali with 9 replies.

https://forum.uipath.com/t/396976 made by @Antonios_Hakim with 6 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 23 posts!

@Sergey_Petrenko made 14 posts!

@nikhil.girish made 10 posts!

Top 3 Most Liked Posts

This post made by @Harika_Mudiam received 2 likes!

Forms AI in Public Preview

Hey Readers, I found this new feature interesting and I created one video on it. Here am posting the link have a look at it and let me know if you found this useful. [FormsAI | Document Understanding | Create Extractor]

This post made by @vincent.zheng received 2 likes!

Localized OCR Engine

Introduction of localized OCR engine which works with UiPath Document Understanding Framework. (will add more description here soon)

This post made by @daniele.giunta94 received 2 likes!

Select a specific row in a web page table

Hi @kirankumar.mahanthi1 , nice to see you again! first of all, I confirm that is a web page table (in particular ERP of my company). Then, i would submit you a possibile solution but it doesn’t work like i hope. So, i find out that in ui explorer on the left panel there is “text=unchecked” and i put this condition in selector but nothing… it doesn’t click on the row [Schermata 2022-02-05 alle 10.04.21] It should works or not for what reason? I’ll try to make the two advice that you give m…

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Unable to display pdfs dynamically on the form

Hello @Yousuf_Ali Kindly remove the spaces or special characters from the filepath and please try. Also you can refer - UiPath Forms - dynamic pdf - #2 by Nithinkrishna Thanks #nK

This solution provided by @Palaniyappan received 1 likes!

While Loop Codition

Hi We need to validate first how the month actually looks like Let’s try with a normal approach and then will deep dive based on the outcome you get Try with this expression in your while loop If your month is a string like this January or Jan NOT MonthIn.ToString.ToUpper.Trim.Contains(CurrentMonth.ToString.ToUpper.Trim) If it’s a numerical value like this 01 or 11 Then try with this NOT MonthIn.ToString.Trim.Contains(CurrentMonth.ToString.Trim) Cheers @Naveen_Kumar2

This solution provided by @Sergey_Petrenko received 1 likes!

Nextlinkselector Proprerty In data scraping

Hi, Renu! Welcome to the forum I think you are missed single quotes webctrl aaname=‘“+Counter_PO.ToString+”‘ parentid=‘dtBasicExample_paginate’ tag=‘A’ But I’m not exactly sure)

---

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

Top 3 Topics with Most Views

How to delete selected multiple columns in an excel file made by @Sreekar_Mulinti with 53 views.

How to concat common rows in excel file and and write into single cell made by @Sreekar_Mulinti with 46 views.

Date for Each Row made by @ShadowZ with 45 views.

Top 3 Topics with Most Replies

How to concat common rows in excel file and and write into single cell made by @Sreekar_Mulinti with 24 replies.

How to delete selected multiple columns in an excel file made by @Sreekar_Mulinti with 22 replies.

Date for Each Row made by @ShadowZ with 20 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 31 posts!

@ppr made 24 posts!

@Sreekar_Mulinti made 22 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Linux Robots #2A: Essential Docker Basics & Cross-platform Automations

Hello Community, Following the Part 1 video on Linux Robots that dropped here last week, the Part 2A video goes the extra mile to set the stage before Linux Robots can be deployed. This involves familiarizing ourselves with some much needed Docker essentials. Obviously, audience can skip sections of coverage that they’re already familiar with. The Part 2A video track covers the following topics: 00:33 - Prologue 04:08 - Essential Docker UI Fundamentals 08:06 - Essential WSL 2 (Windows…

This post made by @Cristian_Negulescu received 2 likes!

UiPath Orchestrator webhooks use-case | UiPath in 5 minutes | Ep:18

UiPath Orchestrator webhooks use-case | UiPath in 5 minutes | Ep:18 [UiPath Orchestrator webhooks use-case | UiPath in 5 minutes | Ep:18] #uipath #webhooks #5minutes

This post made by @Krutika_Kotkar received 2 likes!

Data Scraping from PDF with multiple pages and tables into excel

scrape the entire table and use filter data table to filter rows based on your condition

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Dynamic Sum of Array Elements

Hey @Aswin_Ramesh You need to do this as below, once you get the number N from the input dialog… arrNum.Take(N).Sum() The above statement will give you the sum of the elements until the size mentioned in the input dialog You can use that in the assign statement & store it in a variable as well Hope this helps Thanks #nK

This solution provided by @Palaniyappan received 1 likes!

How to neglect a particular row in excel

Hi Hope the below steps would help you resolve this Let’s take like you have the datatable read and named as dt Now there are two scenarios If you want to have the first row after header but should process that means Use a FOR EACH ROW activity and pass dt as input Inside the loop use a IF condition like this NOT dt.Rows.IndexOf(CurrentRow).Equals(0) IF TRUE means it goes to THEN block and inside that have all the activities to process all the rows except first row Or There is an…

This solution provided by @supermanPunch received 1 likes!

ERROR IN FUCTION GROUP BY

Hi @salvatore.quimi , Could you try Updating your Query to the Below and Check : (From d In dtPv.AsEnumerable Group d By k=d("Soc.").toString.Trim, k2= d("Codici iva").ToString.Trim, k3=d("Registro").ToString.Trim,k4=d(" M").ToString.Trim Into grp=Group Let cs1 = grp.Sum(Function (x) Convert.ToDouble(If(x(" Imp. base imponibile").toString.Trim.IsNumeric,x(" Imp. base imponibile").toString.Trim,"0"))) Let cs2 = grp.Sum(Function (x) Convert.ToDouble(If(x(" IVA vendite").toString.Trim.IsNumeric,x…

---

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

Top 3 Topics with Most Views

워드파일 안 지정위치에 텍스트 대체 made by @jayD with 49 views.

Convert to number? made by @fairymemay with 43 views.

パブリッシュ後に実行したロボットのログの格納場所 made by @chokota0326 with 42 views.

Top 3 Topics with Most Replies

How to run two bots individually in orchestrator which are present in same package made by @Ashwini_Patil with 16 replies.

워드파일 안 지정위치에 텍스트 대체 made by @jayD with 12 replies.

Dynamic selector not working, even passing wild chars made by @aditya.prakash with 12 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 25 posts!

@ppr made 17 posts!

@Djh made 14 posts!

Top 3 Most Liked Posts

This post made by @BreakFree received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone! I’ve just had a career change and have started learning UiPath a couple of months back, looking forward to the learning process and get myself certified. Trying hard to find that Course Voucher meanwhile haha. Best Regards

This post made by @gustavo.cervelin received 2 likes!

Monthly Forum rewards - January 2022

Congratulation guys Keep on inspiring other members of this amazing community

This post made by @Yoichi received 2 likes!

StudioXで「後のために保存」の中身を消したい

こんにちは 「削除する」の定義にもよりますが、右辺に詳細エディタで以下を入力すると空文字列相当にすることはできます。 CType("",UiPath.Excel.ExcelValue)

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

StudioXで「後のために保存」の中身を消したい

こんにちは 「削除する」の定義にもよりますが、右辺に詳細エディタで以下を入力すると空文字列相当にすることはできます。 CType("",UiPath.Excel.ExcelValue)

This solution provided by @Gokul001 received 2 likes!

Web page loading

HI @RENU_KHALKHO You can try also this Create a new flowchart and inside that the flow should be Use element exists and set timeout as 2000 Keep Flow decision and pass the variable if true continue your steps if false join the line to the element exists By keeping like this it will wait until the page completely loaded Or You can follow these steps in this thread Regards Gokul

This solution provided by @Gokul001 received 2 likes!

Could you Please to Advise Code Format Date Time.Help

Hi @punnipah Have a look on this thread, it will help you Regards Gokul

---

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

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

[system]

Daily Forum Report | 09 February 2022

Top 3 Topics with Most Views

Automatically close chrome made by @Remy_Yuko with 80 views.

UiPath Marketplace - BalaReva - Excel Automation for Enterprises made by @balupad14 with 63 views.

Attach browser is not working! made by @Madhavi_Puliraju with 48 views.

Top 3 Topics with Most Replies

Excelで任意のセル位置を取得したい made by @miwa_yamamoto with 25 replies.

Can't able to find out the text position by using OCR Text Position made by @yamaguchi7445 with 17 replies.

Automatically close chrome made by @Remy_Yuko with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 44 posts!

@Yoichi made 24 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @nikhil.girish received 3 likes!

"Type Into" Different lines

Just pass the for each item number as variable in selector of TyPe into Let me know if it works @Papichulo For example if it’s iterating item number 1 , pass the same to selector variable of type into activity along with other attributes Next if it’s iterating item number 2 , pass the same value to type into selector variable

This post made by @Marian_B received 2 likes!

Monthly Forum rewards - January 2022

Congratulation for all the winner

This post made by @balupad14 received 2 likes!

UiPath Marketplace - BalaReva - Excel Automation for Enterprises

Dear all, I have uploaded a new package in UiPath Marketplace. Here are the package’s activities. Excel Application Scope → DropDown DropDown List Values DropDown Select DropDown Selected Value → Shape Add / New Shape Add / New Shape At Cell BringTo Forward And Backward Delete All Shapes Delete Shape Duplicate Shape Position At Cell Shape Position Shape Read Text All Shapes Read Text Shape Rotation Shape Shape Properties Shape Style Size Shape Write TextIn Shape → Slicer Slicer But…

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 3 likes!

"Type Into" Different lines

Just pass the for each item number as variable in selector of TyPe into Let me know if it works @Papichulo For example if it’s iterating item number 1 , pass the same to selector variable of type into activity along with other attributes Next if it’s iterating item number 2 , pass the same value to type into selector variable

This solution provided by @Palaniyappan received 2 likes!

Difference between image recording and native Citrix automation

Yes ofcourse we can but if you have the UiPath Extension for Citrix on the client machine and the UiPath Remote Runtime component on the Citrix Virtual Apps (formerly known as Citrix XenApp) application servers then all the elements in that Citrix environment can be accessed as a individual elements There won’t be a need of image automation if Citrix extension is installed unless you really have a image to process in that Citrix environment That’s Citrix automation is same as desktop but for …

This solution provided by @Gokul001 received 2 likes!

How do I get Excel to redisplay all hidden columns and remove the applied filter?

Hi @111962 To remake the Hidden columns Refer to this thread Regards Gokul

---

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

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

[system]

Daily Forum Report | 10 February 2022

Top 3 Topics with Most Views

💖 'Love of RPA' challenge 💖 made by @cristina.vidu with 66 views.

Error in Http GET Request in UiPath made by @BP_Deepa_Tharwani with 48 views.

How to calculate the Rank? made by @HeartCatcher with 48 views.

Top 3 Topics with Most Replies

How to calculate the Rank? made by @HeartCatcher with 17 replies.

Unable to view the Available>System>Activities>Statements>if made by @Farrukh_Munir with 15 replies.

Need to read data table from .lin file made by @shreyash_shirbhate with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 25 posts!

@Gokul001 made 20 posts!

@pravin_calvin made 20 posts!

Top 3 Most Liked Posts

This post made by @cristina.vidu received 13 likes!

'Love of RPA' challenge

Let’s all sound the RPA Love alarm!! This Valentine’s Day our whole community engages in spreading the ‘Love of RPA’ ! We’re giving out 100 sets of matching UiPath T-shirts so that you can set-up a friend on a blind date with RPA . When we say ‘blind date’ we mean your friend should not be a member of UiPath Community (does not own a UiPath Forum, UiPath Academy or community.uipath.com account). How? Follow steps in exact…

This post made by @Jobin_Joy received 9 likes!

Monthly Forum rewards - January 2022

Congratulations to all winners @Yoichi @ppr @Palaniyappan @Nithinkrishna @kirankumar.mahanthi1 @90s_Developer @Robinnavinraj_S @Srini84 @StefanSchnell @THIRU_NANI

This post made by @arivu96 received 9 likes!

Monthly Forum rewards - January 2022

@Yoichi,@ppr,@Palaniyappan,@Nithinkrishna,@kirankumar.mahanthi1,@90s_Developer,@Robinnavinraj_S,@Srini84,@StefanSchnell,@THIRU_NANI Congratulation for all the winner

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Extract PDF Regex Match

Hi, Can you try the following sample? [img20220210-2] m = System.Text.RegularExpressions.Regex.Match(yourString,"Quality 25% (?<QUALITY>\d+)[\s\S]*?Delivery 25% (?<DELIVERY>\d+)[\s\S]*?Cost 25% (?<COST>\d+)[\s\S]*?Technology 25% (?<TECHNOLOGY>\d+)") note: m is System.Text.RegularExpressions.Match type. Sequence.xaml (6.4 KB) Regards,

This solution provided by @Jalapeno received 2 likes!

EWS Get Exchange Mail Messages

My bad! The sollution to this was correct filter expression: “category:(Send Report)” Still not sure why previous expressions caused such an interesting behaviour… @Palaniyappan @Nithinkrishna Thanks for help and support!

This solution provided by @Yoichi received 1 likes!

Need help/advice in resolving a select from datatable

Hi, I think it’s simple and better to use LINQ as the following. mydatatablevariable.AsEnumerable.Where(Function(r) r("columnname1").ToString = stringvariable1 AndAlso r("columnname2").ToString=stringvariable2 AndAlso Double.Parse(r("columnname3containingInt").ToString)>=Double.Parse(stringvariable3containingInt) AndAlso Double.Parse(r("columnname4containingInt").ToString)>=Double.Parse(stringvariable4containingInt)).ToArray 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 | 11 February 2022

Top 3 Topics with Most Views

Office Hours for Partners - Technical Sessions made by @adrian.gorgan with 59 views.

Click Generic Error on Click Activity made by @Archie with 49 views.

Can some help me on the Linq made by @Marian_B with 48 views.

Top 3 Topics with Most Replies

Click Generic Error on Click Activity made by @Archie with 15 replies.

I want to run 3 foreground process simultaneously, i had 3 users on one machine with 3 licenses . if i start all 3 thoese are in pending state but they are not running y? made by @MitheshBolla with 14 replies.

Can some help me on the Linq made by @Marian_B with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 29 posts!

@THIRU_NANI made 25 posts!

@Nithinkrishna made 22 posts!

Top 3 Most Liked Posts

This post made by @adrian.gorgan received 7 likes!

Office Hours for Partners - Technical Sessions

[image] Hello Esteemed Partners, We are delighted to invite you to our newest technical enablement session series called “Office hours”. In this series, we are going through a topic of interest for our partners, adding our technical expertise and discussing the results in an open forum. To further enhance your technical knowledge you can register for any of the sessions described below based on the timezone that best suits your schedule: .NET Classes & Objects Feb 17, 2022 Option 1: 12:…

This post made by @gabrielribas4 received 3 likes!

Assign multiple row value from excel to single variable

Hey @anto.santhosh!! What a great question!! Lets go to the solution!! → First ill introduce the variables. [image] dt_test is the data table that we will store the reading of the data in the excel files, that is, the IDs. arr_test will be the array that will contain this column of IDs, that’s because we’re going to transform the column into a array, so we can handle it better. parts is the division quotient, because since you want to divide a number N into equal parts of 5, let’s get h…

This post made by @tjerosch received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi. My name is Tom Jerosch. I just started using UIPath to automate repetitive tasks at my work - I am an analyst in the Airline Industry. I just built my first (very simple) robot and am thrilled to be part of this forum.

Top 3 Most Liked Solutions

This solution provided by @gabrielribas4 received 3 likes!

Assign multiple row value from excel to single variable

Hey @anto.santhosh!! What a great question!! Lets go to the solution!! → First ill introduce the variables. [image] dt_test is the data table that we will store the reading of the data in the excel files, that is, the IDs. arr_test will be the array that will contain this column of IDs, that’s because we’re going to transform the column into a array, so we can handle it better. parts is the division quotient, because since you want to divide a number N into equal parts of 5, let’s get h…

This solution provided by @Gokul001 received 2 likes!

Issue hidding half activities

You need to Downgrade to the version [image] Regards Gokul

This solution provided by @Gokul001 received 2 likes!

Click Generic Error on Click Activity

HI @Archie These are the solutions may solve your query Keep a separate try catch block and see whether the subsequent element exists and then retry. Have a stable selector and use Click image activity if all the environment resolutions is the same. Regards Gokul

---

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

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

[system]

Daily Forum Report | 12 February 2022

Top 3 Topics with Most Views

Need To filter excel column by using LINQ query made by @ashokkumar_e with 49 views.

How to get the all the text from an ERP application made by @nirmalya.sarkar with 47 views.

Which information does "Get outlook mail messages" return/expose? made by @MaxDS1 with 37 views.

Top 3 Topics with Most Replies

Job keeps installing package on Orchestrator and failed with time out message made by @tvxqkjj1013 with 17 replies.

Hi guys,any one has reply I want only number below text "k ramakrishna $2500" made by @killarapusiva with 15 replies.

Need To filter excel column by using LINQ query made by @ashokkumar_e with 11 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 16 posts!

@tvxqkjj1013 made 10 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @ron.butler received 2 likes!

Get the URL's from an array of file names

How Do I get the URL’s from an array of file names for a Get File activity and how do I get the number of elements in the array? [image]

This post made by @Ambiga_C received 1 likes!

Monthly Forum rewards - January 2022

Congrats to all the winners…

This post made by @Gokul001 received 1 likes!

How to get Date Without Saturday And Sunday. Help

Hi @punnipah Refer to the Thread Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How to get Date Without Saturday And Sunday. Help

Hi @punnipah Refer to the Thread Regards Gokul

This solution provided by @lakshman received 1 likes!

Error renaming date

@Aguirre I guess vStrFecha holds some special characters like colon “:”. Because of that it’s giving error. First print the vStrFecha variable value and check it once. If it contains any special characters then remove it and then try 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 | 13 February 2022

Top 3 Topics with Most Views

How to apply formula in a column and then Write by using LINQ query made by @ashokkumar_e with 37 views.

How to check keywords in reversed order from string made by @Mansi_Mhatre with 30 views.

Unable to Clear Data Table using Clear Data Table Activity made by @Kenneth_Balana with 29 views.

Top 3 Topics with Most Replies

How to apply formula in a column and then Write by using LINQ query made by @ashokkumar_e with 19 replies.

How to convert pdf file data to .xlsx made by @bhanu.priya2 with 10 replies.

How can we check a specific language month names in an excel filename? made by @Poonam_Yadav with 5 replies.

Top 3 Users Who Posted The Most

@Yoichi made 13 posts!

@Sanjit_Pal made 7 posts!

@liu_shubin made 5 posts!

Top 3 Most Liked Posts

This post made by @David_Bishop received 1 likes!

LINQ Tutorials

these have been very helpful for me !! well worth a watch and subscription

This post made by @Sanjit_Pal received 1 likes!

How can we check a specific language month names in an excel filename?

Hi @Poonam_Yadav, Get all the files from a folder using Directory.GetFiles(FolderPath) Use for each activity to get the file name Path.GetFileName(FilePath) Use Regular expression to get the month name from the filename string You can use a mapping file or you can use the language translator to convert the spanish to english Regards,

This post made by @Aditya_Kumar3 received 1 likes!

Need help with Gsuite

Hi Thanks it helps and i have managed to download the files using the this activity. What condition should i put in the while loop so that the program is running infinitely and the second a new file is uploaded in that drive, it downloads it. A bit confused over here

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to Keep Some Lines from set of Lines Based on Condition?

Hi, Can you try the following sample? [img20220213-2] mc = System.Text.RegularExpressions.Regex.Matches(strData,"(?<FirstLine>Node_.*?)\r?\n(?<SecondLine>.*?)\r?\n([^:]*?\r?\n)*(?<ThirdLine>.*?)(\r?\n|$)([^:]*?\r?\n)*(?=Node_|$)") dtResult = mc.Cast(Of Match).Select(Function(m) dtResult.LoadDataRow({m.Groups("FirstLine").Value,m.Groups("SecondLine").Value,m.Groups("ThirdLine").Value},False)).CopyToDataTable() Sample20220213-2.zip (3.0 KB) Regards,

This solution provided by @Yoichi received 1 likes!

Unable to Clear Data Table using Clear Data Table Activity

Hi, ClearDataTable activity removes data in all rows, however keeps schema of DataTable such as datacolumn. If you want to remove reference to all the information from dt1, can you try to use the following expression using Assign activity? dt1 = Nothing Regards,

This solution provided by @poorna_nayak07 received 1 likes!

Check data in file excel?

Hi, We have 3 files. Config file, master file and input file. Read the config file to get searchElement list column and output column (column name/index) Use get workbook sheets activity to get all sheet names in input file. 3.Use for loop and read all sheets and add datatable to dictionary of type Dictionary(Of string, Datatable) along with sheet name as key Read master sheet Use For each loop to read searchElement. Inside loop check if SearchElement is present in Dict values (table1, table…

---

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

Top 3 Topics with Most Views

My Excel loop doesn't work made by @Aida_Azar with 49 views.

How to avoid finding duplicate/similar text in website? made by @Swati4 with 43 views.

Orchestrator Queue post data via api made by @supu123 with 41 views.

Top 3 Topics with Most Replies

Replace picture - replace with picture made by @jayD with 20 replies.

Encountering uipath studio error while using Excel Application Scope "Interface not registered" error, please help made by @Nk511 with 19 replies.

Filter mails in Outlook based on filename of attachment made by @NrC with 16 replies.

Top 3 Users Who Posted The Most

@gabrielribas4 made 46 posts!

@Palaniyappan made 37 posts!

@Yoichi made 27 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 7 likes!

Recollect the basics of Date Format, String Manipulation and LINQ

Hello Everyone, I would like to present this post who are looking for the expressions related to the Date Format, String manipulation and LINQ Basic of Date formatting In this below topic, you will learn about Date Formats Convert datetime to week of year System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(System.DateTime.Now, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.CalendarWeekRule,System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.Fi…

This post made by @Yoichi received 4 likes!

My Excel loop doesn't work

Hi, We need to use CurrentRow variable instead of Excel.Sheet.Cell, as the following. [img20220214-4] Regards,

This post made by @gustavo.cervelin received 3 likes!

Get the URL's from an array of file names

@ron.butler, That’s how you should build your URLwhen you use the Get File activity (page 23) [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

My Excel loop doesn't work

Hi, We need to use CurrentRow variable instead of Excel.Sheet.Cell, as the following. [img20220214-4] Regards,

This solution provided by @gustavo.cervelin received 3 likes!

Get the URL's from an array of file names

@ron.butler, That’s how you should build your URLwhen you use the Get File activity (page 23) [image]

This solution provided by @gustavo.cervelin received 2 likes!

How to get data from this

Hi @manoj_verma1, Have you tried this? yourVariableName("batches")(0)("batchId").toString

---

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

Top 3 Topics with Most Views

Can we correct spellling in uipath? made by @MitheshBolla with 69 views.

Regex expression to extract only numeric values separated by underscore made by @neha_malik with 48 views.

Check whether row items include alphabets, numbers or signs made by @kit2815 with 46 views.

Top 3 Topics with Most Replies

Can we correct spellling in uipath? made by @MitheshBolla with 21 replies.

From db i am getting lot of phone number so how to save it made by @manoj_verma1 with 19 replies.

Enable to run multiple processes in one folder in uipath orchestrator? made by @Fahad_Masood with 19 replies.

Top 3 Users Who Posted The Most

@gabrielribas4 made 46 posts!

@Gokul001 made 38 posts!

@THIRU_NANI made 20 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 4 likes!

Try Catch?

Can you try with this Use Try/Catch activity Try → Use If condition Then → Process the case Else → Throw activity If the condition goes to else It will process Catch [image] Regards Gokul

This post made by @Sudharsan_Ka received 3 likes!

Can i reset the data now

Hello everyone I have submitted the Calculate security hash project and it got approved. Can I reset the data in the ACME now ? @gabrielribas4 @kirankumar.mahanthi1 @pravin_calvin @lakshman @Yoichi @ppr Regards Sudharsan

This post made by @gabrielribas4 received 2 likes!

Can i reset the data now

Sure @Sudharsan_Ka!! Go on!! Keep rocking!!

Top 3 Most Liked Solutions

This solution provided by @gustavo.cervelin received 2 likes!

Compare range in excel

Hi @fairymemay, Sorry for taking to long, today was a busy day. Here is the new version: Main.xaml (42.4 KB)

This solution provided by @THIRU_NANI received 2 likes!

Not able to sign in to the Orchestrator

Thank you @gabrielribas4 and @Gokul001. After clearing the cache it is working fine with multiple cloud accounts Regards, NaNi

This solution provided by @supermanPunch received 2 likes!

Can we correct spellling in uipath?

@MitheshBolla, I am afraid the result is not very accurate with this Setup. The Word "Manger" is also a Proper word which has a meaning and hence it is not recognised as a Spelling Mistake. The Word Applicotion is understood as a Mis-Spelled word and gets corrected. Find the Updated Workflow Below which Corrects all the Mis-Spelled words in a Sentence: SpellCheck_Suggestions_CSharp.zip (4.4 KB) We could however explore the Options of Adding a Custom Dictionary but it would not cover the wh…

---

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

Top 3 Topics with Most Views

Dynamic CV table extraction (having cursor) made by @Sonalk with 64 views.

Check data in another file? made by @fairymemay with 60 views.

How to split data table from excel sheet made by @Giriraj_Vishwas_Hande with 53 views.

Top 3 Topics with Most Replies

Need help on making reliable selector for every time made by @shreyash_shirbhate with 21 replies.

Check data in another file? made by @fairymemay with 15 replies.

How to split data table from excel sheet made by @Giriraj_Vishwas_Hande with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@pravin_calvin made 28 posts!

@THIRU_NANI made 21 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

Please help me on regex

Hi @Clinton_Das Try this Regex Expression Use Assign activity LHS - Create an Variable RHS - System.Text.RegularExpressions.Regex.Match(“Input String”,“[A-Za-z]\d+”).Tostring.Trim More information about regex Hope it will work Regards Gokul

This post made by @RPAForEveryone received 2 likes!

Lookup range Multiple column values at a time

Hi @Satish_Ch Please consider using Filter Data Table activity. This link shows information with images, how the Filter activity can be used to include multiple lookup columns using AND and/or OR combinations. [image] I hope this solves your query.

This post made by @gabrielribas4 received 2 likes!

Lookup range Multiple column values at a time

Hey @Satish_Ch!! Try this! Im using this excel as Input. [image] I’m reading this data and storing it in the “dt_input” variable. [image] I will surround my Assign activity with “Try Catch” to simulate the “Lookup DataTable” activity. If no match is found, it returns -1. We first perform a filter on the values ​​to identify the match. [image] ( From p In dt_input.Select() Where p(0).ToString.Equals(val1) and p(1).ToString.Equals(val2) Select p ).CopyToDatatable If there i…

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

Please help me on regex

Hi @Clinton_Das Try this Regex Expression Use Assign activity LHS - Create an Variable RHS - System.Text.RegularExpressions.Regex.Match(“Input String”,“[A-Za-z]\d+”).Tostring.Trim More information about regex Hope it will work Regards Gokul

This solution provided by @gabrielribas4 received 2 likes!

Lookup range Multiple column values at a time

Hey @Satish_Ch!! Try this! Im using this excel as Input. [image] I’m reading this data and storing it in the “dt_input” variable. [image] I will surround my Assign activity with “Try Catch” to simulate the “Lookup DataTable” activity. If no match is found, it returns -1. We first perform a filter on the values ​​to identify the match. [image] ( From p In dt_input.Select() Where p(0).ToString.Equals(val1) and p(1).ToString.Equals(val2) Select p ).CopyToDatatable If there i…

This solution provided by @Ramya_K received 1 likes!

Check data in another file?

Filter_Non_Matching_Rows.xaml (10.6 KB) @fairymemay Please see if this workflow helps you.

---

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

Top 3 Topics with Most Views

Deserialze Jason for particular value made by @Sahil_Garg1 with 47 views.

How to iterate over Columns and only one row made by @Doonline with 43 views.

ADD SERAIL NUMBER (S/N) INTO A DATATABLE made by @Ahmad_Rais with 42 views.

Top 3 Topics with Most Replies

ADD SERAIL NUMBER (S/N) INTO A DATATABLE made by @Ahmad_Rais with 22 replies.

Deserialze Jason for particular value made by @Sahil_Garg1 with 20 replies.

How to update specific values in datatable without using for each row made by @111962 with 12 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 31 posts!

@ppr made 24 posts!

@Gokul001 made 24 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

How to get single value from datatable using Linq

dtData.AsEnumerable().Where(function(x) x("EmpID").toString.Trim.Equals("12345")).Select(Function (x) x("Age").FirstOrDefault handling not found case We do not use CoptToDataTable when we can expect also an empty filter result. In such case CopyToDataTable will throw an exception. FirstOrDefault will return null in the case no matching row was found

This post made by @Srini84 received 2 likes!

How to Pick Some Columns for Data Scraping

@Archie Once the data scraping is done then it will store into the datatable So you can use Filter Datatable and give which columns you need as below [image] Hope this will help you Thanks

This post made by @Gokul001 received 2 likes!

How to Pick Some Columns for Data Scraping

HI @Archie You can achieve this by two methods as far i know Method 1 While Data scrapping the table the wizard will be shown that can it get all the values from table In that you need to select the NO and select the columns manually and give your column name and extract correlated data of all column you need. Method 2 After datascrapping the table Use Filter datatable and Go to Output column section and click on Keep radio button and give your column names one by one by clicking “+” on i…

Top 3 Most Liked Solutions

This solution provided by @ppr received 4 likes!

How to get single value from datatable using Linq

dtData.AsEnumerable().Where(function(x) x("EmpID").toString.Trim.Equals("12345")).Select(Function (x) x("Age").FirstOrDefault handling not found case We do not use CoptToDataTable when we can expect also an empty filter result. In such case CopyToDataTable will throw an exception. FirstOrDefault will return null in the case no matching row was found

This solution provided by @Gokul001 received 2 likes!

How to Pick Some Columns for Data Scraping

HI @Archie You can achieve this by two methods as far i know Method 1 While Data scrapping the table the wizard will be shown that can it get all the values from table In that you need to select the NO and select the columns manually and give your column name and extract correlated data of all column you need. Method 2 After datascrapping the table Use Filter datatable and Go to Output column section and click on Keep radio button and give your column names one by one by clicking “+” on i…

This solution provided by @pravin_calvin received 2 likes!

Bot is not performing as expected from the Orchestrator

Hi @md.musaalireza Is the output file is in same project folder? If yes then try changing the output file apart from the project folder! 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 | 18 February 2022

Top 3 Topics with Most Views

Delete Dup by condition? made by @fairymemay with 75 views.

Http Post Request Query made by @supu123 with 72 views.

GSuite - Send mail - Changing attachment type and name made by @Eduard with 42 views.

Top 3 Topics with Most Replies

Problem with Date Filtering a DataTable made by @ieptus with 30 replies.

Excel - Programmatic access to Visual Basic Project is not trusted Exception made by @Aparna_Reddy1 with 19 replies.

Need help in Gsuite! made by @Aditya_Kumar3 with 18 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 38 posts!

@Yogesh1 made 27 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Nam1 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, My name is Nam and I am really excited to learn more about RPA and Uipath.

This post made by @pravin_calvin received 2 likes!

How to update specific values in datatable without using for each row

Hi @111962 assign dtClone=ReadDt.Clone (Vartype datatable) Assign newDt= (From d In ReadDt.AsEnumerable Let u = If(d(1).toString.Equals(“CC”) Or d(1).toString.Equals(“FF”),“0”,d(2).ToString) Select dtClone.Rows.Add(New Object(){d(0),d(1),u,d(3)})).CopyToDataTable Write range the new Dt Regards

This post made by @Hiba_B received 2 likes!

Compare Rate and write value?

Hi @fairymemay ! Here is another suggestion: From_count_to_sum.xaml (9.6 KB) It uses the filter activity to do it, but basically behind the .asenumerable() that suggests @Ramya_K there is a filter in it Let us know if we missed something ! (If you see “missing activities” that means that we are not using the same Studio version. Mine in 21.10)

Top 3 Most Liked Solutions

This solution provided by @pravin_calvin received 2 likes!

How to update specific values in datatable without using for each row

Hi @111962 assign dtClone=ReadDt.Clone (Vartype datatable) Assign newDt= (From d In ReadDt.AsEnumerable Let u = If(d(1).toString.Equals(“CC”) Or d(1).toString.Equals(“FF”),“0”,d(2).ToString) Select dtClone.Rows.Add(New Object(){d(0),d(1),u,d(3)})).CopyToDataTable Write range the new Dt Regards

This solution provided by @Yoichi received 2 likes!

Regex to extract part of the text, Please advice

Hi, Can you try the following LINQ expression? arrString = ExtractDataTable.AsEnumerable.Select(Function(r) System.Text.RegularExpressions.Regex.Match(r(1).ToString,"\D{3}\d{3}(?=\D|$)").Value).ToArray Hope this helps you. Regards,

This solution provided by @Yoichi received 2 likes!

Delete Dup by condition?

HI, How about the following? [img20220218-3] dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("CusName").ToString,r("PlanCode").ToString)).Select(Function(g) g.OrderByDescending(Function(r) Double.Parse(r("FPP").ToString)).First()).CopyToDataTable Sample20220218-1v2.zip (14.9 KB)

---

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.