Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 February 2023

Top 3 Topics with Most Views

Linq query to update datatable column made by @Sasikanth with 49 views.

"Add to dictionary" Activity is not available in uipath studio made by @Yazharasan with 47 views.

How to get value by Regex match made by @TakeshiC with 47 views.

Top 3 Topics with Most Replies

How to get value by Regex match made by @TakeshiC with 28 replies.

Linq query to update datatable column made by @Sasikanth with 16 replies.

How to get the Required values form the string using regex expressions made by @chandolusathi.kumar with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Sudharsan_Ka made 38 posts!

@fernando_zuluaga made 23 posts!

Top 3 Most Liked Posts

This post made by @Venkatesh_R1 received 5 likes!

UiPath Community MVP 2023 announcement!

Hearty Congratulations to all the MVPs of 2023

This post made by @kennbalobalo received 5 likes!

UiPath Community MVP 2023 announcement!

I am honored and humbled to be an MVP 2023. Congratulations to my amazing fellow MVPs! I am looking forward to collaborating with you and supporting the community! Thank you so much, UiPath and UiPath Community, for all the support.

This post made by @jamesjacobsydney received 4 likes!

UiPath Community MVP 2023 announcement!

Congratulations to all MVPs!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Split関数の使い方について

こんにちは 変数名.Split({" "c,"_"c}) で空白と _ の両方の文字でSplitできますので 変数名.Split({" "c,"_"c})(2) で取得できると思います。

This solution provided by @Jack_Moran received 1 likes!

Invoke PowerShell/Start Process: Backslashes get Added to String at Runtime

With the help of @Anil_G I have found the answer: As he mentions below, the backslashes don’t actually do anything; they are just UiPath’s way of processing my String. The actual issue was the command itself: I had failed to account for time zones! This is why my extracted logs, and the logs I was seeing in Event Viewer for the same time period, did not match up. The above command is still correct, but you must specify to your end user that their input should be in UTC time, NOT your timezone.

This solution provided by @Sudharsan_Ka received 1 likes!

Unable to install Bala Reva easy excel packages

Checkout this expression @Manju_Reddy_Kanughula Read the data and save it in the datatable dt.AsEnumerable().Where(Function(s) Not String.IsNullOrEmpty(s("Amount").ToString) or Not String.IsNullOrWhiteSpace(s("Amount").ToString)).Sum(Function(a) CInt(a("Amount").ToString)).ToString Regards Sudharsan

---

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 2023

Top 3 Topics with Most Views

Replace exact text in string made by @Ram_Gurav1 with 68 views.

Check if text in an element exists - do X if exists, do Y if it doesn't made by @mhoreen with 46 views.

I want to create a gettext from multiple pds in a folder made by @PriyaRPA with 40 views.

Top 3 Topics with Most Replies

How can I detect diferent types of objects that are located in the same place made by @goncalo.rocha with 9 replies.

How to get different time zone - current date and time made by @AJITH_SK with 9 replies.

Assign Column as type date from datatable (source excel) made by @laura.groeger with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@postwick made 14 posts!

@Sudharsan_Ka made 11 posts!

Top 3 Most Liked Posts

This post made by @RPAForEveryone received 3 likes!

Read and write last row

Hi @Sabbir_Anwar You can achieve this in two steps: Get Total Rows in table → dt.Rows.Count dr = dt.Rows(RowCount - 1) dt is a DataTable object, dr is DataRow. The dr object can then be used to retrieve column values as needed. Please use the search feature on Forums to look up answers for simple questions such as this one. It’s always likely that someone has already had this problem and it’s resolved. This will save you a lot of time (and community members too ) https:…

This post made by @ddpadil received 2 likes!

UiPath Community MVP 2023 announcement!

[image]

This post made by @ppr received 2 likes!

Issue with Selectors maybe from the resolution

@FlorinOvi welcome to the forum can you check:

Top 3 Most Liked Solutions

This solution provided by @Shakti_Singh received 1 likes!

How update Project Settings UI Automation Classic

Hi Check this Package Version, How sap is coming [image] [image]

This solution provided by @Yoichi received 1 likes!

Check if text in an element exists - do X if exists, do Y if it doesn't

Hi, I think it might be better to use either of the following. Use GetText (or GetFullText, Get VisibleText), then check its contents. [image] Use ElementExists with aaname or innertext attibute like '*NET ONLY*' in the selector. [image] Regards,

This solution provided by @Anil_G received 1 likes!

Assign Column as type date from datatable (source excel)

@laura.groeger You need to convert them to date.Try as below var. Lieferdatum = cdate(CurrentRow("Lieferdatum").ToString) var. Umterminierungsdatum = Cdate(CurrentRow("Umterminierungsdatum").ToString) And change the datatupe of your liefrdatum and umte… to datetime Hope this helps Cheers

---

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

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

[system]

Daily Forum Report | 18 February 2023

Top 3 Topics with Most Views

Trying to capture every filtered group made by @pprin001 with 42 views.

Datatable object reference made by @Nancy_Star with 34 views.

String.EmptyをExcelの指定シートの指定セル範囲に埋める簡単な方法 made by @gorby with 31 views.

Top 3 Topics with Most Replies

Get Transaction Item is not Picking the data which has NULL Values in One Column made by @sharu_priya with 13 replies.

Trying to capture every filtered group made by @pprin001 with 12 replies.

How to get row with highest value in row 0 and active in last row made by @ashishmani with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@fernando_zuluaga made 16 posts!

@sharu_priya made 9 posts!

Top 3 Most Liked Posts

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

UiPath Community MVP 2023 announcement!

[UiPath Most Valuable Professional 2023 - Thank You | RPA | Intelligent Automation]

This post made by @muhammedyuzuak received 1 likes!

UiPath Community MVP 2023 announcement!

Congratulations to all MVPs.

This post made by @Anil_G received 1 likes!

Updating column based on another dt Column with LINQ

@Meli_Marco The straight forward and easy way would be to use join datatable and then use filter datatable to remove the non required columns Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Trying to capture every filtered group

@pprin001 So if you need only the count of eqch group the. Use the below linq…which will give you a two column table one with your key and other with count…you can build a datatable with 2 columns and use the belao in assign Newdt = (From d In Dt.AsEnumerable() Group d By k=d("key").toString.Trim Into grp = Group Let coun = grp.count Let ra = New Object(){k,coun} Select r = Newdt.Rows.Add(ra)).CopyToDataTable() If you want each of the group only as separate sheets or anything then Use a ass…

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

Datatable object reference

Hi @Nancy_Star So basically to get the count and avoid that error Better check the count in if condition and then assign it to a variable Example In if condition Expression : DT.rows.count>0 Then. Use your variable and assign the value accordingly Else datatable is empty,send out notification Also please intialize your datatable

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

Checking of folder

Sure Here you go

---

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 2023

Top 3 Topics with Most Views

https://forum.uipath.com/t/518597 made by @Muneer_Alrashdan1 with 38 views.

Add Image In Excel made by @Joy_Ballav1 with 38 views.

How to mask a particular value in a image or document? made by @Selvaganapathy_T with 37 views.

Top 3 Topics with Most Replies

Flowswitch or flow discission to speedup process made by @Ranjit_Nayak1 with 10 replies.

I'm stuck - Build your first process with Studio (Workflow Part 1) made by @Paz7 with 10 replies.

How to mask a particular value in a image or document? made by @Selvaganapathy_T with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 18 posts!

@fernando_zuluaga made 12 posts!

@Selvaganapathy_T made 10 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 3 likes!

Write Range to SpreadSheet displays the formula not the result

Hi @Arijit_Sarkar, Use excel application scope and try to use write range inside. Regards, Arivu

This post made by @arjunshenoy received 2 likes!

Dropdowntext

Hi @gaurav2000, Welcome to the community. You can use Click Text activity to achieve this. Indicate the drop down & make the selectors stable. Pass the text you need to click. Hope this helps. Best Regards

This post made by @unknownay received 2 likes!

How to select the radio buttons all at one time

Dear @Ranjit_Nayak1 I think you cannot click everything at a time using UI Method. for a faster execution try using simulate method or there an option to inject java script you can try that as well. Inject JS activity is available in UiPath studio. Regards, MRMK

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 3 likes!

Write Range to SpreadSheet displays the formula not the result

Hi @Arijit_Sarkar, Use excel application scope and try to use write range inside. Regards, Arivu

This solution provided by @arjunshenoy received 2 likes!

Dropdowntext

Hi @gaurav2000, Welcome to the community. You can use Click Text activity to achieve this. Indicate the drop down & make the selectors stable. Pass the text you need to click. Hope this helps. Best Regards

This solution provided by @Anil_G received 1 likes!

I'd like to filter data with a condition

@pprin001 Please try like this nuevaDT.AsEnumerable.Where(Function(r) r.Item(“KEY”).ToString.Equals(“ENT960054944L20220922”) AndAlso Not r.Item(“column6”).ToString.Equals(“#N/A”) AndAlso Not r.Item(“Columnd36”).ToString.Equals(“#N/A”)).CopyToDataTable Cheers

---

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

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

[system]

Daily Forum Report | 20 February 2023

Top 3 Topics with Most Views

Remove duplicate & add value to new columnt made by @kafabic728 with 75 views.

Get the Text from PDF with specific format made by @Ralph_Sena26 with 49 views.

Linq query Exception made by @Sasikanth with 48 views.

Top 3 Topics with Most Replies

Filter another activity in the loop made by @Mark_Rajkumar with 21 replies.

Excel auto fil made by @YUGAN_NITHISH_KUMAR with 19 replies.

Linq query Exception made by @Sasikanth with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 30 posts!

@fernando_zuluaga made 26 posts!

@ppr made 23 posts!

Top 3 Most Liked Posts

This post made by @fernando_zuluaga received 3 likes!

Submit your AI Use Cases for the UiPath AI Summit 2023, Challenge

Hi eveyone, Here is my use challenge use case, if this may helps you then feel free to reach me for any helper or suggestion Happy automation!

This post made by @Ralph_Sena26 received 2 likes!

Get the Text from PDF with specific format

you’re amazing @Yoichi Happy automation to all.

This post made by @ppr received 2 likes!

"Only one overload group should have it's arguments configured"

let us know your version of UiPath.System.activities and which target framework is selected (legacy, windows). Check also newer / latest version of UiPath.System.activities we can replicate by: [grafik] and when removing one from both (file, fileName) it will accept e.g. [grafik]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

"Only one overload group should have it's arguments configured"

let us know your version of UiPath.System.activities and which target framework is selected (legacy, windows). Check also newer / latest version of UiPath.System.activities we can replicate by: [grafik] and when removing one from both (file, fileName) it will accept e.g. [grafik]

This solution provided by @amy93amanda received 1 likes!

Where is the unattended installation in last version

thanks for you reply, i found out what was the problem… its the previous step which give me the unattended mode [image]

This solution provided by @ppr received 1 likes!

How to convert a String to Guid in dataservice

[grafik]

---

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 2023

Top 3 Topics with Most Views

Oracle SQL Developer connection made by @anusha2 with 46 views.

Get Column Name from Excel with partial match made by @rvivek with 45 views.

Capturing type of phone number after the actual number made by @olmccb with 43 views.

Top 3 Topics with Most Replies

Oracle SQL Developer connection made by @anusha2 with 22 replies.

INVOKE CODE ERROR CORRECTION made by @Krishan_Rapswal with 13 replies.

Can we take screenshot when robot running unattended made by @pranitha63 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 56 posts!

@arivu96 made 40 posts!

@Sudharsan_Ka made 28 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 3 likes!

Why does the list in uipath need to be initialized and the array does not

Hi @1545030349 In UiPath, a list variable needs to be initialized before it can be used. This is because a list is a dynamic data structure, which means that its size can change during runtime. When you initialize a list, you are essentially creating an instance of the list with a specific capacity. This capacity can be increased or decreased as items are added or removed from the list. On the other hand, an array is a fixed-size data structure, which means that its size is determined when it …

This post made by @Anil_G received 2 likes!

Screen Scraping not working anymore

@lrinczaron Welcome to the community Please try using modern activity inplace of the classic activities and check… Cheers

This post made by @ABHIMANYU_THITE1 received 2 likes!

Screen Scraping not working anymore

Hi @lrinczaron, There could be a few potential causes. Here are some things to check: Check if the PDF file format has changed: If the format of the PDF file has changed, for example, if the font or layout has been modified, the screen scraping process may not work as expected. Check if the PDF viewer has changed: If the PDF viewer application has been updated or changed, this could be affecting the screen scraping process. Ensure that the PDF viewer is still compatible with the version of Ui…

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 2 likes!

How to get entire row data

Hi @Sai.Srinivas , Use updated xaml file Attendance.xaml (16.2 KB) Regards, Arivu

This solution provided by @AHMAA received 2 likes!

Hi, I need help to edit the inspect element chrome to remove disable textfield to enable

Hi all, I already resolved the issue. Apparently I just have to use Set Text and set AlterIfDisabled to true in the Properties. [image]

This solution provided by @Catalina_Ianus received 1 likes!

Connected to orchestrator. Unable to retrieve a license in UiPath Assistant

Hello! This status has different causes. An error message including extra information can be found on the tooltip if you hover this exact status that you have provided on the screenshot → access Orchestrator Settings interface in Assistant. Extra error might be: Robot does not exist. There are no available licenses on the server. Use Interactive login. The machine key is linked to another machine! Waiting for the machine to be defined in Orchestrator. The floating robot’s session is already …

---

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 2023

Top 3 Topics with Most Views

Try catch 자체 오류 made by @youngchang with 44 views.

Identify if there is any duplicate values in excel column made by @nir.kail with 44 views.

Download Folder from Share point using Microsoft Office 365 Package made by @lakshman with 42 views.

Top 3 Topics with Most Replies

After open UI path studio it can open studio x made by @Shubham_Bidwai with 19 replies.

Identify if there is any duplicate values in excel column made by @nir.kail with 15 replies.

Message: "Click 'Download': Multiple similar matches found made by @hiennguyen with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@Sudharsan_Ka made 23 posts!

@fernando_zuluaga made 23 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 4 likes!

How to get the value count in particular Row

@404_Error Use for loop on the datatable and then use this inside to get the count Total = currentrow.Itemarray.Count(function(x) x.ToString.Equals("True")) Atlernately on excel you can use countif formula and use autofill range activity Cheers

This post made by @jeevith received 2 likes!

Invoke Python Method: Pipe is broken

Hi @amithvs, I have wasted a lot of hours as I said before trying to understand Pipe is broken error and I have chosen to move away from the Python Scope Activity. My other two fallbacks are Invoke PowerShell Activity and Start Process Activity. Sadly the Invoke PowerShell activity is currently broken in Windows projects (UiPath Community 2022.12 Release - #41 by jeevith) So the Start Process activity is the only option I can see working using standard UiPath activities. It has a way to call a…

This post made by @Rutva_patel1 received 2 likes!

Happy Anniversary UiPath Learner, Virtual Party!

Congratulations and Happy 5th Anniversary UiPath Academy! I appreciate that so much quality content is free and products can be tested completely free to test them. My first experience with UiPath Academy was in 2021. UiPath academy is my best UiPath platform, it helped my at the beginning of everything in UiPath and RPA, this also helps a lot my team mates to reach their projects with the best practices and techniques. Regards, Rutva

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 4 likes!

How to get the value count in particular Row

@404_Error Use for loop on the datatable and then use this inside to get the count Total = currentrow.Itemarray.Count(function(x) x.ToString.Equals("True")) Atlernately on excel you can use countif formula and use autofill range activity Cheers

This solution provided by @Anil_G received 2 likes!

Convert response body into excel

@Bhushan_Nagaonkar Its a json …do first use deserialize json and select type as jarray as I see a jarray first Then use jarr(0)("ClientNumber").ToString to get the clientnumber and so on Which can then be wrriten to datatable using add datarow Cheers

This solution provided by @Gokul_Jayakumar received 1 likes!

How to increase the numbers in a column

Hello @pprin001 Refer to this Xaml file you may Get Some idea Forum_NumberAutoFill.zip (143.2 KB) [image] [image] Use Excel Modern Actvity. If You are classic user, Enable activity vy following these steps: Click Actvity pannel> Click Filter> Enablke the Show modern option. [image]

---

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

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

[system]

Daily Forum Report | 23 February 2023

Top 3 Topics with Most Views

The status that it shows "In process" and "Completed" made by @Bhushan_Nagaonkar with 44 views.

Decoding Excel file from HTTP Request made by @Erikas_Martinaitis with 42 views.

How to make unattend robot unlocked the screen made by @Zoeyu with 42 views.

Top 3 Topics with Most Replies

Element changes after hovering made by @dyvo with 21 replies.

How to get the Excel data Values by increasing value of cell value one by one made by @chandolusathi.kumar with 16 replies.

Merge excel files into 1 made by @Juandix with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 56 posts!

@ppr made 26 posts!

@postwick made 23 posts!

Top 3 Most Liked Posts

This post made by @Savan_S_Bangoria received 3 likes!

How to sum up the duplicates values

Hi @T_Y_Raju , First you will have to filter the data based on the fff column to consider only rows containing PA2 and then you can use the following code to get the sum of the duplicate columns. add this in the assign statement and add your datatable instead of dt (From row In dt.AsEnumerable Group row By key = New With { Key.group = row.Item(“aaa”).ToString.Trim } Into grp = Group Select dt.LoadDataRow(New Object() { Key.group, grp.Select(Function(x) x(“bbb”).ToString).First, grp.Selec…

This post made by @Ali_Gunawan_S.Kom_M.M received 2 likes!

It doesn't feel like it's been 3 years of learning RPA

Hi All, At the beginning of 2020 I learned RPA Studio X and Studio, at first I thought RPA was something related to Robots or Robotic Machines like Factory, but after I studied I was quite surprised, it turns out that RPA is something that is easy to learn because it’s low code and it looks like it’s easy. RPA, all digital things on the computer can be automated, after studying I finally took the certification exam and successfully passed it, then from the university it gave me a very extraordi…

This post made by @ignasi.peiris received 2 likes!

String was not recognize valid date time

As @supermanPunch suggested, using DateTime.ParseExact would be the Go-To solution to convert strings to date, and then work with DateTime functions. CDate, Convert.ToDateTime, DateTime.Parse tend to fail with certain type of dates. DateTime.ParseExact lets you write the exact format (in this case it would be “dd/MM/yyyy”, but also an array of possible formats Hope this helps!

Top 3 Most Liked Solutions

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

How can I import linq and other libraries into invoke code activity?

@ext-o can you try use the import pane instead [image]

This solution provided by @supermanPunch received 1 likes!

String was not recognize valid date time

Hi @satish.rathi59 , Could you Check with the below Expression : DateTime.ParseExact(str_ETADate,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).AddDays(-Cint(str_MapTransitTime)).ToString("dd/MM/yyyy")

This solution provided by @Gokul_Jayakumar received 1 likes!

Date time condition

Hello @Kevin_Maurice Initially Convert the String into Date Time Format using Use read range activity and store data as DT Use For Each loop data table. and try below conditions DateTime.ParseExact(CurrentRow(0).tostring.trim,"yyMMddHHmm",System.Globalization.CultureInfo.InvariantCulture()) If Condition (DateTime.ParseExact(CurrentRow(0).tostring.trim,"yyMMddHHmm",System.Globalization.CultureInfo.InvariantCulture()).TimeOfDay>DateTime.ParseExact("10:15","HH:mm",System.Globalization.Cultur…

---

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

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

[system]

Daily Forum Report | 24 February 2023

Top 3 Topics with Most Views

Why is so hard to contact UI Path sales to get started with UI Path? made by @spmo with 121 views.

Adding the data from (stored variable )- data table to append the Excel sheet made by @vr10 with 71 views.

Just trying to download a file from a website.... this should be easy made by @Coffeesnob with 45 views.

Top 3 Topics with Most Replies

メッセージボックスの機能について made by @sayaka.y with 13 replies.

How to extract particular words from string made by @Neha_Aggarwal1 with 11 replies.

UiPath Studio Launch Issue - Community Edition made by @mallickram99 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@fernando_zuluaga made 15 posts!

@GANESH_BALAGAM made 14 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Why is so hard to contact UI Path sales to get started with UI Path?

Looping @loginerror

This post made by @arivu96 received 2 likes!

Regex to get Datetime from a string

Hi @sudha456, Please use below regex to extract the value \d{2}\/\d{2}\/\d{4} \d{2}:\d{2} (AM|PM) To get the date value using below syntax in assign activity strDate=System.Text.RegularExpressions.Regex.Match(yourString,"\d{2}\/\d{2}\/\d{4} \d{2}:\d{2} (AM|PM)").Value [Screenshot_20230225-024241_Chrome] Regards, Arivu

This post made by @arivu96 received 2 likes!

How to check pdf is password protected or not in uipath?

Hi @manipreethi410 . [image] Regards, Arivu

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 2 likes!

Regex to get Datetime from a string

Hi @sudha456, Please use below regex to extract the value \d{2}\/\d{2}\/\d{4} \d{2}:\d{2} (AM|PM) To get the date value using below syntax in assign activity strDate=System.Text.RegularExpressions.Regex.Match(yourString,"\d{2}\/\d{2}\/\d{4} \d{2}:\d{2} (AM|PM)").Value [Screenshot_20230225-024241_Chrome] Regards, Arivu

This solution provided by @arivu96 received 2 likes!

How to check pdf is password protected or not in uipath?

Hi @manipreethi410 . [image] Regards, Arivu

This solution provided by @Yoichi received 1 likes!

How to get last item that is numeric in datatable column

Hi, How about the following expression? dt.AsEnumerable.Where(Function(r) Double.TryParse(r(0).ToString, new double)).Last().Item(0).ToString 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 | 25 February 2023

Top 3 Topics with Most Views

I want Datatable to Excel automatically creating new folder and writing into it made by @Bhushan_Nagaonkar with 40 views.

Input Dialog - multiple choice made by @paulparkes with 38 views.

Get data from Json in Excel made by @GDMM with 37 views.

Top 3 Topics with Most Replies

I want Datatable to Excel automatically creating new folder and writing into it made by @Bhushan_Nagaonkar with 30 replies.

Regex Not Working But Match Activity Highlighting made by @raja.arslankhan with 21 replies.

Filter Data from Excel without Condition made by @Tanzill_Ahsan with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@supermanPunch made 27 posts!

@Bhushan_Nagaonkar made 18 posts!

Top 3 Most Liked Posts

This post made by @Boopathi.M received 2 likes!

Can I make BlockUserInput Activity property (Mouse or Keyboard) like a Flag option (Enable or Disable mode)

Okay, Thanks for your suggestions @Anil_G and @Sudharsan_Ka

This post made by @Coffeesnob received 1 likes!

Just trying to download a file from a website.... this should be easy

@jeevith wow man, thanks so much, you realy went the extra mile in explaining this, I realy apreciate it thank you.

This post made by @Coffeesnob received 1 likes!

Just trying to download a file from a website.... this should be easy

@Anil_G thanks for the sugestions. I will give it a shot.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

I want Datatable to Excel automatically creating new folder and writing into it

@Bhushan_Nagaonkar , As Already shown above, the .xlsx is a string that is appended inside the double quotes itself "". If you could check back the post suggested above, you might get the idea. In your case, it should be like below : Path.Combine(FolderPath,"OutputDRLAPI_"+Now.ToString("dd_MM_yy_HH_mm_ss")+".xlsx")

This solution provided by @Anil_G received 1 likes!

Dynamically Filter Excel Data and Store in DT

@Tanzill_Ahsan I see the id column is of type integer so as we did tostring it is not filtering Please use currentrow(“id”) and remove .ToString. And to write data into separate sheets you can change the sheetname to Currentrow(“id”).ToString [image] [image] Hope this helps cheers

---

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

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

[system]

Daily Forum Report | 26 February 2023

Top 3 Topics with Most Views

Activity to close open excel in studiox made by @jaeho_hyeon with 86 views.

Unable to find dictionary activities in uipath made by @vineelag with 37 views.

Obtaining and cleaning up data made by @bobbyfisher with 37 views.

Top 3 Topics with Most Replies

Im trying to create a new excel and write into it but it is giving me an error made by @Bhushan_Nagaonkar with 12 replies.

Create assessment sheet using create form activity in UiPath studio made by @swathi_sakthi with 9 replies.

How to choose a checkbox dynamically based on data in Excel made by @Jeeru_venkat_Rao with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 39 posts!

@supermanPunch made 21 posts!

@mironb made 17 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 3 likes!

Extract the Data with Regular Expression

Hi @adarsh_kotagiri , Check this below attached workflow, Uipath_Regex_Extraction.xaml (5.7 KB) I have used the text file which you provided and tried to extract the details which you required. Hope this may help you

This post made by @rmorgan received 2 likes!

Invoke Code Errors

Awesome thankyou!

This post made by @anmita received 1 likes!

How to apply loop with condition

Thanks @Anil_G !!

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 3 likes!

Extract the Data with Regular Expression

Hi @adarsh_kotagiri , Check this below attached workflow, Uipath_Regex_Extraction.xaml (5.7 KB) I have used the text file which you provided and tried to extract the details which you required. Hope this may help you

This solution provided by @Anil_G received 1 likes!

Excel group by same values of one Column + Move

@Meu_Eu_Nando In the write range properties…you have an option to add headers…please check that check box and you shpuld have the headers added to excel Hope this helps Cheers

This solution provided by @supermanPunch received 1 likes!

How to change date to variable

Hi @mironb , Could you check with the below Expression : Split(timeASMConvert,":")(0)+":00"

---

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

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

[system]

Daily Forum Report | 27 February 2023

Top 3 Topics with Most Views

Test set execution in test manager is Pending made by @shruthi_arali with 56 views.

How to count row by row based on color in excel made by @Raja.G with 44 views.

Generate Yearly Report Dispatcher can't add queue item error code 1002 made by @Floris_Maat with 41 views.

Top 3 Topics with Most Replies

Regex Pattern in Studiox made by @venkateshcheeni09 with 17 replies.

Datatable comparison error of data I get with get text activity made by @Mert_Samet_Sonmez with 13 replies.

Regex to capture only date from the string made by @Sathish_Kumar_S with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 29 posts!

@supermanPunch made 26 posts!

@Anil_G made 23 posts!

Top 3 Most Liked Posts

This post made by @Savan_S_Bangoria received 3 likes!

How to use same dispatcher for different performers?

Hi @huseyinemre.cetin, You can keep the “type” as an asset in orchestrator and can get the asset in the process, you can change type to “WI4” or “WI3” in the asset before running the dispatcher.

This post made by @arjunshenoy received 2 likes!

How to use same dispatcher for different performers?

Hi @huseyinemre.cetin, welcome to the Community. You can use the following approach: Step 1: Create different queues for every transaction type. Step 2: Filter the different types of data in the Dispatcher & upload the respective type of data to their designated queues. Step 3: You can configure the queues in multiple dispatchers accordingly. Ex: WI3 perform consumes data from the WI3 queue. Hope this helps, Best Regards.

This post made by @arivu96 received 2 likes!

How to get the difference btw the count of working days comparing with other date column

Hi @bhanupriya.cb , Use below formula to get count of workday =NETWORKDAYS("13-01-2023",EOMONTH("13-01-2023",0),0) [image] Regards, Arivu

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 2 likes!

Disabling activities from another Activity

Hi @agahito That’s not possible, debug mode doesn’t allow to make changes within the project, for that you can edit the values and start ignoring activities but that should be manually, also you can add conditional breakpoints, that based on any condition take this way or another Regards

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

How to count row by row based on color in excel

@Raja.G please try out this sequence Sequence.xaml (24.2 KB) sample [image] set name here [image] result (result is a dictionary of the colors + # occurences) [image]

This solution provided by @supermanPunch received 1 likes!

Regex to capture only date from the string

Hi @Sathish_Kumar_S , Could you try using the below Regex Expression : \d{4}-\d{2}-\d{2}(?=.* ms_acl_info\b) [image]

---

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

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

[system]

Daily Forum Report | 28 February 2023

Top 3 Topics with Most Views

Assign rows in specific column with For Each Row made by @Steyn_Muller with 110 views.

Testing the new triggered attended automation capabilities with Studio 23.2 made by @bogdanripa with 45 views.

Validation Check is taking too long made by @Md_Asfaque with 44 views.

Top 3 Topics with Most Replies

How to capture the first search link from browser made by @Neha_Aggarwal1 with 15 replies.

Instead of throwing what other activities to be used made by @Mark_Rajkumar with 14 replies.

How to get last row cell value in particular column made by @Raja.G with 12 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 38 posts!

@Sudharsan_Ka made 29 posts!

@fernando_zuluaga made 23 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 3 likes!

Identify if there is any duplicate values in excel column

Hii @nir.kail , Can you please crosscheck which DataTable Variable you have put in the Log message. I think by mistake u have put the Input DataTable I guess .Because if you use the below query DT_Output :- ( From row In DT_Input.AsEnumerable Group row By a=row(“MESSAGE NUMBER”).ToString.Trim Into grp=Group Select grp.First ).CopyToDataTable You should be able to get the required output which we are getting. If not I have dropped the Xaml please try to run that and let us know i…

This post made by @Bilal_Anwar received 2 likes!

Women in Automation Program 2023

That is a good initiative.

This post made by @raduc received 2 likes!

SAP: selector 'tableCol' no longer working

Hi @loxyms, In SAP there are 2 types of tables, grids and tables, and they look very similar but are totally different controls. For grids we generate and use selectors using colName and tableRow and for tables tableRow and colTooltip (but you can also use tableCol here). From your selectors it seems that you are indicating in a grid. To be 100% sure and on the same page, could you please indicate a cell in the table/grid using UiExplorer with the full selector visible? Please be sure to als…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

HELP!. I'm trying to split 1 text file into multiple text files

Hi, Can you try the following sample? [image] arrStr = System.Text.RegularExpressions.Regex.Split(strData,"(?=^10/20)",System.Text.RegularExpressions.RegexOptions.Multiline).Where(Function(s) not String.IsNullOrEmpty(s)).ToArray Sample20230228-3L.zip (2.7 KB) Regards,

This solution provided by @Sudharsan_Ka received 2 likes!

Comparing_Dates

@Hardik_Durgam Checkout this Sequence2.xaml (6.8 KB) In here date_2 in the expression is the one where you need to give your second date variable and it should be in String Regards Sudharsan

This solution provided by @Yoichi received 1 likes!

How to count the values in a column 1 based on column 2 and transpose row to column

Hi, Can you try the following sample? [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Department").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Count,g.Key},False)).CopyToDataTable Sample20230228-1L.zip (10.1 KB) Regards,

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

@Anil_G received 65 likes for their solutions!

@Yoichi received 43 likes for their solutions!

@supermanPunch received 34 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 March 2023

Top 3 Topics with Most Views

LOOPING FOR EACH IN INVOKE CODE made by @Krishan_Rapswal with 52 views.

Error with Machine Learning Extractor: made by @Vinny_LaRocca with 44 views.

Need Regex to get email id from a string made by @sudha456 with 43 views.

Top 3 Topics with Most Replies

LOOPING FOR EACH IN INVOKE CODE made by @Krishan_Rapswal with 31 replies.

Error with Machine Learning Extractor: made by @Vinny_LaRocca with 10 replies.

Delete column using index number in excel file made by @Sathish_Kumar_S with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@Sudharsan_Ka made 17 posts!

@Krishan_Rapswal made 17 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 7 likes!

Monthly Forum rewards - February 2023

Congrats All

This post made by @Gokul_Jayakumar received 6 likes!

Monthly Forum rewards - February 2023

Congrats All

This post made by @Vamsi_Krishna_Gogineni received 5 likes!

Monthly Forum rewards - February 2023

Wohoo! First time on the list. Thank you and congratulations everyone

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

How to make click in this webpage

@Juandix I would suggest use a different approach… As it is a table…you can get relation between each column… So first use get attribute with a selector containing your required text… it looks something like this <webctrl tag=‘tr’ tablecolumn =‘5’ innertext=‘text youa re looking for’ /> And get the attribute tablerow…which gives you the row you need Now use click with <webctrl tag=‘tr’ tablerow=‘value obtained previously’ tablecolumn=‘1’ /> Note: selector given are for illustrations…actu…

This solution provided by @Yoichi received 1 likes!

パブリッシュしたnupkgファイルがインストールできない

こんにちは 最も手っ取り早く（かつ雑な）方法は、開発した端末では正常に動作していたと思いますので 開発した端末の、当該ユーザーの c:\Users\ユーザー名\.nuget\packages 以下に 今回インストールに失敗しているGoogle.Apis.OAuth2.v2 のフォルダがあると思いますので これを ロボットの端末の当該ユーザーの同じ個所に丸ごとコピーすると 問題は解消すると思います。 正攻法は、nugetのfeedの設定で、当該パッケージがある場所を設定する方法かと思いますが、配布先を特定する必要がありますので、まずは上記を試してみてはと思います。

This solution provided by @Yoichi received 1 likes!

How to get timestamp dynamically?

Hi, Can you try the following? System.Text.RegularExpressions.Regex.Match(yourString,"\b\d{2}:\d{2}:\d{2}\b").Value [image] 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 | 02 March 2023

Top 3 Topics with Most Views

(Improvement suggestion) When creating a new variable/argument let us choose type and scope in addition to name made by @Cosmin_Mandoc with 59 views.

Need a help to write a LINQ query for a datatable made by @deepika.garg with 57 views.

How to add backround color/cell color in Gsheet made by @Sidney_Vogel with 46 views.

Top 3 Topics with Most Replies

How to throw BRE properly (error code 1002) made by @Meu_Eu_Nando with 14 replies.

Edge - "Cannot communicate with browser" made by @David_Hernandez2 with 12 replies.

Regex Multiple condition made by @ravindar.singh with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Yoichi made 22 posts!

@postwick made 17 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 2 likes!

Multiples values SQL Excel

Hi @DimitriLYR Try the following code & let us know if it works: Select * From [Export$] where [Supplier] = '22' AND [Product Code] NOT IN ('101748', '101896') Best Regards.

This post made by @RobertRussell_Monsalud received 2 likes!

The Queue being created in the orchestrator is not being detected in the Studio (REFramework)

Hi @fernando_zuluaga and @Sanjit_Pal Thank you for your inputs and solutions. Both are helpful. I really appreciate it. Best regards, Robert

This post made by @RobertRussell_Monsalud received 2 likes!

Enforcing Unique References in Queue Creation

Hi @arjunshenoy and @GANESH_BALAGAM Thank you for your inputs and solutions. Both are helpful. I really appreciate it. Best regards, Robert

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 2 likes!

Multiples values SQL Excel

Hi @DimitriLYR Try the following code & let us know if it works: Select * From [Export$] where [Supplier] = '22' AND [Product Code] NOT IN ('101748', '101896') Best Regards.

This solution provided by @Anil_G received 2 likes!

Change Action Center Port (on-prem) issue

@irahmat I hope this might help you [image] Cheers

This solution provided by @Anil_G received 2 likes!

How to group the row and add the values in the row and copy it to the same datatable

@Demo_User Welcome to the community Please try this in assign activity with the below given formula on right and on left dtoutput… dtoutput = (From d In dtinput.AsEnumerable() Group d By k=d("Name").toString.Trim Into grp = Group Let sum = grp.sum(function(x) cdbl(x("Value"))) Let ra = New Object(){k,sum} Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Before this use another assign with Dtoutput = dtinput.Clone() And if not working please confirm if your project is in c# or vb.net Ch…

---

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 March 2023

Top 3 Topics with Most Views

Recording - Preview release made by @Adrian_Tamas with 221 views.

How to create dynamic data table? made by @aparna30 with 51 views.

JSON to DT made by @mz3bel with 47 views.

Top 3 Topics with Most Replies

Getting made by @sruthesanju with 19 replies.

String array int32 array convert made by @private_matter with 16 replies.

Send an email with a picture embedded, rather than attached as a file made by @Tuannna1 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 35 posts!

@ABHIMANYU_THITE1 made 23 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Tamas received 7 likes!

Recording - Preview release

Dear UiPath Community, I am excited to announce the upcoming release of a new feature powered by our Robots and available in UiPath Orchestrator and Studio Web (Preview): Job Recording. On behalf of all the teams involved, I am more than thrilled to share this feature with you, our community, thus allowing you to troubleshoot faulted jobs more efficiently. With Video Recording, you can capture the last 3 minutes of the robot execution, which can be incredibly useful in identifying if anything …

This post made by @midhunsug661 received 2 likes!

Recording - Preview release

Amazing! Is the recording available only on the job level or would be there an option to enable recording on transaction level? Eg: if a queue item fails, would be there an option to record it?

This post made by @Jithesh_R received 2 likes!

Need To Get Highest Value

Hii @Rishik_Chowdary , Assuming that your input will be in array or in list. Use for each activity to iterate through each values. Inside the body Split the currentitem to get the price value that is Split(currentItem,“$”)(1) Use append to list activity . it will add all your price values into a list Then (Outside the for each activity) using assign activity get the max value by providing, MaxValue = NewlistVariable.Max I have dropped a sample xaml for your reference Sequence.zip (1.7 KB) C…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Days difference

Hi, In my environment, it returns 6 as the following. Did you change your locale in the project? [image] I guess “-172” is caused by 03/09/2023 is recognized as “dd/MM/yyyy”. So can you try DateTime.ParseExact instead of Convert.ToDateTime as the following? DateDiff(DateInterval.Day, DateTime.ParseExact(date_ETADate,"MM/dd/yyyy",System.Globalization.CultureInfo.InvariantCulture), convert.ToDateTime(date_ATADate)) Regards,

This solution provided by @Yoichi received 1 likes!

How to get the Last date of the Particular Date

Hi, FYI, another approach: We can easily get last date of the month using ModifyDate activity as the following. [image] DateTime.ParseExact(strDate,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture) Regards,

This solution provided by @rodrigoneira received 1 likes!

Latest update 2023.2.0-beta.11986 problems - bugs

Bastian, revisa si el formato del del nombre que estas invocando esta en mayúscula o en minúscula, por alguna razón la nueva versión esta generando errores cuando el formato esta en .XAML reemplazalo y déjalo en .xaml cc @Diego_Montecinos Saludos

---

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 March 2023

Top 3 Topics with Most Views

Get Full Text Activity Is Not Working made by @Ayush_Das_Purkayastha with 64 views.

Hello, can anyone help me made by @GDMM with 48 views.

Get Attribute made by @GDMM with 31 views.

Top 3 Topics with Most Replies

Hello, can anyone help me made by @GDMM with 31 replies.

Get Attribute made by @GDMM with 27 replies.

メソッドを呼び出し JObjectを作成したいがエラーが出る made by @711 with 7 replies.

Top 3 Users Who Posted The Most

@GDMM made 18 posts!

@raja.arslankhan made 14 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Tamas received 1 likes!

Recording - Preview release

Hi. Are you on the Community plan? If not, it will soon be available on the Enterprise plan as well. Looking forward to hearing back your feedback once you try it!

This post made by @mukeshkala received 1 likes!

Recording - Preview release

Yes, I am on Enterprise Plan , Will try on my community plan and share the feedback. Also , Welcome to the Community – Mukesh

This post made by @Aakash_Gaikwad received 1 likes!

REFrame work task on data scrapping from browser save in excel to mail

and scroll down to get the below table. 2. Extract the table data from webpage with details of the states 3. Filter the data and get details of the states whose population is greater than 20,000,000 4. Write those states and respective capitals in one excel sheet 5. Email the result with excel file Please develop the process in transactional flow first. Then try to upload all states details in queue and use REF for this usecase.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

For Each Activity (Community Version)

Hi, It seems a bug of UiPath.System.Activities package 23.2.0-preview in Windows project. As a workaround, can you try to downgrade UiPath.System.Activities package to 22.10.4? (Or use Windows-Legacy) FYI, this seems similar issue to the following. Regards,

This solution provided by @Yoichi received 1 likes!

メソッドを呼び出し JObjectを作成したいがエラーが出る

こんにちは JObject.Addはvoidなので、戻り値は不要です。戻り値を空欄にしてみてください。 [image]

---

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

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

[system]

Daily Forum Report | 05 March 2023

Top 3 Topics with Most Views

Getting an error about "because it is being used by another process" error made by @sinkt88 with 44 views.

Building a Rock-Solid On-Premises UiPath Infrastructure - Initiation made by @Joel_Medeiros with 43 views.

How to Update Google Sheet having Extension made by @anmita with 38 views.

Top 3 Topics with Most Replies

Getting an error about "because it is being used by another process" error made by @sinkt88 with 12 replies.

How to calculate the sum of weights only of duplicate values from column SONum? made by @geetanjali.nerlekar with 10 replies.

How to open file explorer? made by @mironb with 10 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 21 posts!

@GDMM made 17 posts!

@Manish540 made 14 posts!

Top 3 Most Liked Posts

This post made by @Joel_Medeiros received 7 likes!

Building a Rock-Solid On-Premises UiPath Infrastructure - Initiation

Getting Started As businesses grow and evolve, it becomes increasingly important to undertake new projects to support their growth. However, without proper planning and gathering project requirements, these projects may fail, leading to a waste of resources, money, and time. Gathering project requirements is the first and most critical step in the project management process. This is not different when it comes to UiPath Enterprise Adoption Projects. In this blog post, we will discuss what are …

This post made by @mukeshkala received 1 likes!

Recording - Preview release

One feedback We can think of an Option to add a Filter Here - to Filter out the Jobs which has Recordings or we can Put some Symbol to differentiate the jobs with screenshot / Videos. This is for the support people monitoring a lot of Jobs. [image]

This post made by @mukeshkala received 1 likes!

Building a Rock-Solid On-Premises UiPath Infrastructure - Initiation

Thank you for sharing @Joel_Medeiros , Book Marked

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 1 likes!

Not Getting the value from SHA using Get Text Activity

Hi @GDMM Can you check this below selector and let us know if it is working for you, <html app='chrome.exe' title='SHA1 online' /> <webctrl tag='P' aaname='*Result for sha1:*' /> <webctrl id='result-sha1' tag='SPAN' aaname='*' />

This solution provided by @Robinnavinraj_S received 1 likes!

Fill an array

Hi @GDMM Array indexes are fixed length so we can’t append or add an element to the existing array.if you want to add an element to an existing collection means you can make use of list. List are similar to arrays but the only difference is we can easily (modify/add/append/delete) list values. Regards Robin

This solution provided by @raja.arslankhan received 1 likes!

Package install while running showing faulted

@satish.rathi59 did you try to upgrade mail packages and then publish again

---

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

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

[system]

Daily Forum Report | 06 March 2023

Top 3 Topics with Most Views

Can't Find nor add downloaded package made by @Jackson_Hew with 92 views.

Update Row Item First Name: Value Cannot be null. (Parameter 'row') made by @olmccb with 58 views.

DateTime.ParseExact the whole Column without looping made by @arthurang with 54 views.

Top 3 Topics with Most Replies

Update Row Item First Name: Value Cannot be null. (Parameter 'row') made by @olmccb with 21 replies.

Copy same folders and rename it multiple times with different names made by @Kunal_Jain with 18 replies.

Read PDF text line by line instead of block by block made by @Joachim with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@Gokul001 made 31 posts!

@supermanPunch made 26 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

How to add comma to the integer value

Hi @sneha_arbole1 Check this below code, formattedValue(variable as String data type) = CDbl("10000000").ToString("#,#.00", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")) Hope this may help you

This post made by @ppr received 3 likes!
https://forum.uipath.com/t/523418/3

This post made by @Manish540 received 3 likes!

Linq query to filter data

Hi @shaik_Azam , Check this below workflow attached, the query and input file used, Uipath_Linq_FilterData.xaml (6.8 KB) query:- (From x In dt_Input.AsEnumerable Group x By k=x(“Vendor”).ToString.Trim Into grp=Group Let successRmk = grp.Any(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“successful”)) Let failedCnt = grp.Where(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“failed”)).ToArray.Count>1 Let removedEx = String.Join(" Or “,grp.Select(Function(x) If(System.Text.R…

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 4 likes!

How to add comma to the integer value

Hi @sneha_arbole1 Check this below code, formattedValue(variable as String data type) = CDbl("10000000").ToString("#,#.00", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")) Hope this may help you

This solution provided by @ppr received 3 likes!
https://forum.uipath.com/t/523418/3

This solution provided by @Manish540 received 3 likes!

Linq query to filter data

Hi @shaik_Azam , Check this below workflow attached, the query and input file used, Uipath_Linq_FilterData.xaml (6.8 KB) query:- (From x In dt_Input.AsEnumerable Group x By k=x(“Vendor”).ToString.Trim Into grp=Group Let successRmk = grp.Any(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“successful”)) Let failedCnt = grp.Where(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“failed”)).ToArray.Count>1 Let removedEx = String.Join(" Or “,grp.Select(Function(x) If(System.Text.R…

---

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

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

[system]

Daily Forum Report | 07 March 2023

Top 3 Topics with Most Views

None of the overload groups have all their required/optional activity arguments configured in any add data row made by @Nathan_Betters1 with 81 views.

How to get current user logon time windows 10 using uipath made by @vinod_badgujar with 49 views.

Need regex to get time from a trsing made by @sudha456 with 48 views.

Top 3 Topics with Most Replies

How to skip scrapped rows? made by @Paul_Li2 with 16 replies.

How to get current user logon time windows 10 using uipath made by @vinod_badgujar with 14 replies.

Need regex to get time from a trsing made by @sudha456 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 58 posts!

@fernando_zuluaga made 30 posts!

@Yoichi made 26 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

Need regex to get time from a trsing

Hi @sudha456 , Use this below code, YourStr(String as data type) = System.Text.RegularExpressions.Regex.Match("EXPECTED DELIVERY DATE | 3/7/23 AT 8:00 AM - 9:00 AM","\d{1}\:\d{2}\s+[A-z]{2}\s+\-\s+\d{1}\:\d{2}\s+[A-z]{2}").Value Hope this might help you

This post made by @Pavanraj_Shetty received 3 likes!

Uipath act

Hi @garimavarshney9 Please find the following approach, which is actually working: In the ‘Filter’ property of ‘Get outlook mail messages’ - set the value to "[ReceivedTime] >= " + DateTime.Today.ToString("dd") Output: [image] Hope this helps, please let me know if any further assistance is required. Regards.

This post made by @dipensoni99 received 2 likes!

Recording - Preview release

Can we save the recording or share via emails to business groups?

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Can't find Set to clipboard activity

@guillaume.cabanes2 You can directly use the clipboard value using set variable value if you want to set the value then on left side give Clipboardx.StringValue and on right give the value to be assigned To get value again clipboardx.stringvalue can be used [image] Hope this helps Cheers

This solution provided by @fernando_zuluaga received 2 likes!

SL01_Query Regarding to the Executing the LINQ Query

Hi @Harsha_S1 What about the following? [image] arrNumbers.Where(Function(x) x >= 2).ToArray() Regards

This solution provided by @supermanPunch received 2 likes!

Problem in looping with Data table then append to .xlsx

@Hossam_Gouda , The correction again would be to use only the Extract Structured Data and Write Range Activities in the Then part of If and remove the whole If, as there is no looping of the pages to be done, even that part is not necessary. Also, Could you add the below Expression in the Assign Activity before the Close Application. ExtractedDT = new Datatable This will erase the data in the datatable after it is already written to the Excel sheet, so that when used again, it will only cont…

---

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.