Forum Engagement Daily Reports

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

[system]

Daily Forum Report | 19 February 2022

Top 3 Topics with Most Views

String Manipulation Problem - Remove data after the second character occurrence made by @MF.RPA with 53 views.

Chk dup from another file? made by @fairymemay with 46 views.

Create an array of Indian city names, all in lower-case strings made by @Gopikrishna_S with 40 views.

Top 3 Topics with Most Replies

String Manipulation Problem - Remove data after the second character occurrence made by @MF.RPA with 16 replies.

Chk dup from another file? made by @fairymemay with 9 replies.

Create an array of Indian city names, all in lower-case strings made by @Gopikrishna_S with 7 replies.

Top 3 Users Who Posted The Most

@MF.RPA made 9 posts!

@Yoichi made 7 posts!

@Palaniyappan made 7 posts!

Top 3 Most Liked Posts

This post made by @Dimas_Mavares received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi. My name is Dimas Mavares T. I am an electronic engineer. I have worked in education and research in telecommunications for the past 20 years. I am excited to follow this new lead of RPA through UiPath

This post made by @Yoichi received 2 likes!

String Manipulation Problem - Remove data after the second character occurrence

Hi, Can you try the following? System.Text.RegularExpressions.Regex.Match(yourString,"\$(\s?[.\d])+").Value Regards,

This post made by @Yoichi received 1 likes!

How can we split an Array

Hi, In this case, we can use Take and Skip method as the following. [img20220219-3] Main.xaml (6.8 KB) Hope this helps you. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

String Manipulation Problem - Remove data after the second character occurrence

Hi, Can you try the following? System.Text.RegularExpressions.Regex.Match(yourString,"\$(\s?[.\d])+").Value Regards,

This solution provided by @Yoichi received 1 likes!

How can we split an Array

Hi, In this case, we can use Take and Skip method as the following. [img20220219-3] Main.xaml (6.8 KB) Hope this helps you. Regards,

This solution provided by @kl_kl received 1 likes!

Chk dup from another file?

join dt.xaml (8.3 KB) Try this workflow

---

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

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

[system]

Daily Forum Report | 20 February 2022

Top 3 Topics with Most Views

Read Gmail - mail extracted as HTML made by @sspi1153 with 39 views.

Automation on attendance marking made by @Jarrypo with 39 views.

How to remove rows from datatable whoes index is greater than 5 and save it into same data table made by @Pooja_Patil1 with 37 views.

Top 3 Topics with Most Replies

Error: RemoteException wrapping UiPath.Core.SelectorNotFoundException: Could not communicate with the UiPath extension for browser 'chrome.exe'. Please make sure the extension is installed and enabled made by @fazrinhafiz with 10 replies.

Automation on attendance marking made by @Jarrypo with 8 replies.

Robotがインストールされた仮想サーバーでの実行について made by @Fujisawaaaa with 7 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 16 posts!

@Palaniyappan made 7 posts!

@gustavo.cervelin made 6 posts!

Top 3 Most Liked Posts

This post made by @adarsh_kotagiri received 1 likes!

How to Give Condition in Form Designer Panel?

Hi @Nithinkrishna Thank you for the reply, I tried that but i don’t. Know how to implement the logic over there . If possible can you please create a logic or workflow it would be helpful. Thanks Adarsh

This post made by @Nithinkrishna received 1 likes!

How to Give Condition in Form Designer Panel?

Sure I can provide you no worries. It will be posted soon.

This post made by @adarsh_kotagiri received 1 likes!

How to Give Condition in Form Designer Panel?

Thank you so much @Nithinkrishna

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

How to use deserialize xml in uipath

Hi Welcome back to UiPath forum Use deserialise xml activity and get the output create a variable called “out_XML” of XDocument type. Note: If you don’t find the “Deserialize XML” activity in the activities panel, then you have to install UiPath.Web.Activities  package Now use a writeline activity like this out_XML.Element(“soapenvEnvelope”).Element(“soapenvBody”).Element(“OdemeOncesiFaturaSorgulamaResponse“).Element(“faturaBilgiDizi”).Element(“faturaBilgiDizi”).Element(“faturaNo”).Val…

---

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

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

[system]

Daily Forum Report | 21 February 2022

Top 3 Topics with Most Views

How can i read sub-columns in main column? made by @Narayana_Acharyulu with 42 views.

How to change format of excel dates into particular format for particular columns made by @kavya.s16 with 37 views.

Date formats /logic made by @Pradeep.Robot with 37 views.

Top 3 Topics with Most Replies

Log Message Activity made by @Vanitha_Agamin with 23 replies.

Date formats /logic made by @Pradeep.Robot with 19 replies.

スクリーンショットのサイズ変更で画質が粗くなる made by @111860 with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 33 posts!

@SrenivasanKanna made 23 posts!

@nikhil.girish made 22 posts!

Top 3 Most Liked Posts

This post made by @AndersJensen received 20 likes!

UiPath Community MVP 2022 announcement!

Thanks a lot for the award, UiPath Welcome to all the new MVPs

This post made by @prasadsatish received 19 likes!

UiPath Community MVP 2022 announcement!

Many Congratulations! I loved the way various UiPath Community members interact with each other; Solid technical expertise shown by community members always help and design your automation supporting best practices. With the UiPath MVP program, I want to contribute to scaling the reach of UiPath as accessible as possible throughout countries, cultures, and people, by creating amazing content around the new products and features of ever-growing products of the UiPath RPA platform. I also look …

This post made by @Palaniyappan received 15 likes!

UiPath Community MVP 2022 announcement!

Congratulations everyone Happy and excited to be a part this program Cheers @Vibhor.Shrivastava

Top 3 Most Liked Solutions

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

How to get machine name while running unattended

Hi @Rahul_54 welcome to community so use an assign activity and create a variable called Machine_name and in value - just type environment.Machinename later pass this variable in output mail Screenshot for reference [image] Hope this Helps

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

Help in answering UiPath Academy Question

Hi @Rajeena_M The Answer is 3 jobs created using a foreground process and 5 jobs created using a background process 5 jobs created using a background process Each machine is allocated 2 licenses and each machine can run 1 foreground and multiple background.

This solution provided by @Gokul001 received 2 likes!

Check String array null or not?

Hi @fairymemay Try this condition Array IsNothing OrElse Array.Length = 0 Regards Gokul

---

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

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

[system]

Daily Forum Report | 22 February 2022

Top 3 Topics with Most Views

How to find URL with Regax made by @Sweety_Nagar with 51 views.

Write range from row.item made by @Rntss23 with 49 views.

How to remove rows whose index are more than 5 made by @HeartCatcher with 41 views.

Top 3 Topics with Most Replies

How to find URL with Regax made by @Sweety_Nagar with 23 replies.

I would like the bot to write to the last empty line in Excel made by @Soudios with 20 replies.

Write range from row.item made by @Rntss23 with 17 replies.

Top 3 Users Who Posted The Most

@Shikhar_Tandon made 36 posts!

@Gokul001 made 25 posts!

@nikhil.girish made 21 posts!

Top 3 Most Liked Posts

This post made by @parvathi_ayanala received 5 likes!

UiPath Community MVP 2022 announcement!

Congratulations rakesh ! I follow your channel . The way you explain with all minute details is really awesome.

This post made by @parvathi_ayanala received 5 likes!

UiPath Community MVP 2022 announcement!

Congratulations everyone!!

This post made by @liu_shubin received 4 likes!

UiPath Community MVP 2022 announcement!

Congratulations, all UiPath MVPs! UiPath MVP is an opportunity for us to learn and contribute to the community. Let’s grow together! [image]

Top 3 Most Liked Solutions

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

XLS file can be processed,

Hi @Nancy_Star Welcome to community Yes Bot can process “XLS” files too , kindly drag an excel application scope and provide full file path and carry out operations Thanks

This solution provided by @ppr received 2 likes!

UiPath Deserialize XML Multiple Data Extraction

when deserialzing the XML you will get returned a XDocument when looping over the elements we do set the typeargument to XElement for retrieving the value as done by xDoc.Root.Descendants(“faturaNo”)(0).Value we will get back a string in your screenshot you are mixing up retrieval and looping [grafik]

This solution provided by @ppr received 2 likes!

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</productVersion>] } xDoc.Descendants(xnsDefault + "productVersion").First().Value "123" xDoc.…

---

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

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

[system]

Daily Forum Report | 23 February 2022

Top 3 Topics with Most Views

How to find specific string using regex made by @BHARAT_NAGAR with 61 views.

How to Date Convert "Date" to "System date" format? made by @Ashok_kumar7 with 57 views.

Excel Delete Columns from a dynamic sheet tab (Source) made by @CMB80 with 53 views.

Top 3 Topics with Most Replies

Excel Delete Columns from a dynamic sheet tab (Source) made by @CMB80 with 31 replies.

How to find specific string using regex made by @BHARAT_NAGAR with 31 replies.

Trim data made by @daryl_pressley with 22 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@Shikhar_Tandon made 27 posts!

@gustavo.cervelin made 25 posts!

Top 3 Most Liked Posts

This post made by @Krollythegoalie received 6 likes!

Your feedback on UiPath Apps can earn you a certification voucher - ends March 9

Hello Maciej, and thank you for the opportunity to provide some feedback on UiPath Apps! 1. What integration to an automation platform are you looking forward to see in UiPath Apps and why? Action Center Integration Apps allows for the construction of beautiful interfaces, but it could benefit from Action Center. Showing a user a list of tasks assigned to them, or their group, would be very useful within an App portal homepage. Would like to see improvements around connecting to workflow …

This post made by @Vitor_Merola received 4 likes!

Your feedback on UiPath Apps can earn you a certification voucher - ends March 9

What integration to an automation platform are you looking forward to see in UiPath Apps and why? It would be great if we can find a plugin to integrate Uipath Apps getting data from Sharepoint list directly, without Premium connectors. Once the most of the companies have Microsoft Plataform in place, and not are working with Microsoft Power Automate to automate boring tasks. What controls are missing in UiPath Apps and how would you use this new control? As it is found in several development…

This post made by @Gokul001 received 2 likes!

How to Date Convert "Date" to "System date" format?

Or you can use this too Datetime.ParseExact(“1-Feb-2022”,“d-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy”) [image] Regards Gokul

Top 3 Most Liked Solutions

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

Why is this written as "=SUM(A1,B1)" in TypeB workflow?

Hi @ydash999, It’s just a different approach usign Excel formula to get the sum of two values. In this case, the formula is written from C1 to C11 because the defined range is "C1:C"+RowsCount Where RowsCount is 11. Then, it will work similar to when you drag a formula. I mean, it will consider the respective row. Are there other ways to do this without formulas? Yes… You could use a for each row activity, get column A value and column B value, covert both of them to Int32, perform the sum …

This solution provided by @THIRU_NANI received 1 likes!

How to Date Convert "Date" to "System date" format?

Hi! Try this: Cdate(DateVariable).ToString("dd-mm-yyyy") Reference: [Date1] Regards, NaNi

This solution provided by @sven.wullum received 1 likes!

Download from storage bucket - Cannot find the requested page

Solution was to install and use Chrome instead of IE11!

---

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.