Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 December 2023

Top 3 Topics with Most Views

How Convert 30 Csv into single Excel? made by @chandrakala.productanalys with 42 views.

Cloudflare cookie error with OCR made by @kyoauei with 41 views.

Failed to update Uipath Studio made by @Udiar with 35 views.

Top 3 Topics with Most Replies

Regarding downloading issue for UiPath studio made by @thiru211 with 11 replies.

How Convert 30 Csv into single Excel? made by @chandrakala.productanalys with 10 replies.

Cloudflare cookie error with OCR made by @kyoauei with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 24 posts!

@vrdabberu made 22 posts!

@Vikas_M made 6 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Get transaction item count and log it into excel

@BHUSHAN_NAGAONKAR1 Say 3 items failed…with 3 difference exception messages then how to give them? If you need both separate only in two lines max one for success and other for failed then use same get queue items two times…once for success and get the count then for failed and get the count and for exception message String.Join(",",qulistitems.Select(function(x) x.ProcessingException.Reason)) with the above all exception messages will be separated by comma and given as one string for this…

This post made by @Anil_G received 1 likes!

Get transaction item count and log it into excel

@BHUSHAN_NAGAONKAR1 Please try the above…the above does not need any loop as we are using oonq and you need only counts For every single item if it writes then it will be 9…if you need consolidated then it will be 2 Cheers

This post made by @Sudharsan_Ka received 1 likes!

Winners Announcement: Advent 2023 in the UiPath Forum Community

Congratulations all

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!

Comapre 2 list and Send the non match ones in outlook

Hey @Chirag12 , i have replicated your scenario, kindly check the compressed file given below Check_Files_And_Mail.zip (31.2 KB) Hope it helps you!

This solution provided by @Vikas_M received 1 likes!

Remove Blank rows in datatable

Hey @Girid , You can use filter datatable and remove all the blank rows by giving a condition [image] Or u can use linq DT.AsEnumerable().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value OrElse field. Equals(“”)) hope it helps you out!

This solution provided by @efelantti received 1 likes!

Where is the 'Attach Browser' activity?

With Use Application/Browser, Url is only required if you value of Open is set to Always or IfNotOpen, ie. set it to “Never” and you don’t need to specify Url. You should be able to find Attach Browser if you filter for Classic activities or set the desogn mode to Classic. However, the Modern activities allow you to use latest features so it would be worth to switch to use them.

---

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

Top 3 Topics with Most Views

I can't find Type Secure Text for password input made by @HongJoo_Choi with 38 views.

Get Current location of the workflow made by @Duy_Luong_Minh with 32 views.

Hello, everyone, support is needed for Oracle application GL switch responsibility made by @mohamed.saty2012 with 32 views.

Top 3 Topics with Most Replies

Prelabelling is not working in Document Manager made by @keeswirken with 11 replies.

日付変数について教えてください。 made by @non with 9 replies.

I can't find Type Secure Text for password input made by @HongJoo_Choi with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 20 posts!

@vrdabberu made 10 posts!

@BHUSHAN_NAGAONKAR1 made 5 posts!

Top 3 Most Liked Posts

This post made by @Mesut_Can received 2 likes!

Delete specific line with regex replace command

Thank you very very much.

This post made by @Vikas_M received 2 likes!

Do you have some recommendations for courses that help with learning visual basic specifically for using UiPath?

Hey @Blox_master_Playz , Kindly refer below threads Hope it helps you out!

This post made by @rikulsilva received 1 likes!

Get Current location of the workflow

Hi @Duy_Luong_Minh Use Get Current Job Info activity for this Cheers

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

Get Current location of the workflow

@Duy_Luong_Minh Try this function Environment.CurrentDirectory gives you the expected output

---

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

Top 3 Topics with Most Views

【条件分岐】特定のセルに記載された時刻が、９時以降であれば made by @kiki1 with 43 views.

Automation cloud security incident flow made by @patomchai.ka with 42 views.

Mobile Device Connection - How to continue with the last page? made by @mironb with 39 views.

Top 3 Topics with Most Replies

REGEX PDF Automation made by @manikandan.murugan with 16 replies.

UiPath Assistant実行時に最初からタスクバーに格納する設定 made by @gorby with 16 replies.

Delete Matching Row in DataTable before export to Excel use C# made by @balaraj.pubalan with 15 replies.

Top 3 Users Who Posted The Most

@Yoichi made 30 posts!

@Anil_G made 21 posts!

@vrdabberu made 13 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Best way to crop images to particular aspect ratio?

Hi, The following sample may help you. (UiPath.Core.Image,SimpleCrop method is used.) [image] Sample20231225-2.zip (3.6 KB) Regards,

This post made by @Yoichi received 1 likes!

Best way to crop images to particular aspect ratio?

Hi, How about the following? [image] Sample20231225-2 (2).zip (3.2 KB) Regards,

This post made by @Anil_G received 1 likes!

Getting an issue while getting exception message for Queue Item

@BHUSHAN_NAGAONKAR1 The folow would besame as the queue one…only difference instead of queue you will get items from excel and instead of list of queue items you will loop theough datatable or get count crom datatable You dont need the outer while loop as all items are read at once Dt.AsEnumerable.Where(function(x) x("Status").ToString.Equals("Successful")).Count will give the successful count similarly can get failed count also Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Best way to crop images to particular aspect ratio?

Hi, How about the following? [image] Sample20231225-2 (2).zip (3.2 KB) Regards,

This solution provided by @Yoichi received 1 likes!

REGEX PDF Automation

Oh, sorry, backslash is displayed as yen sign in my Japanese environment. Please use backslash like the first expression. System.Text.RegularExpressions.Regex.Replace(Ins1Sentence,"(?<="+FirstOccurrence+")\s+(?="+FirstOccurrence+")"," - ") Regards,

This solution provided by @Anil_G received 1 likes!

Try catch for multiple activities

@mountie Just follow this and it would work with single try catch also…basically the globalexception handler in studiox is catching the exception and then it is not rethrowing but is opening a window…if you suppress that then single try catch will do that job…and the way to do that is as below Open the globalhandlerx.xaml in notepad or notepad++ Delete this part and save the xaml and then try to run the workflow (the part with trycatch on line 109 till 829 in my case [image] Attaching a sa…

---

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

Top 3 Topics with Most Views

Error code:“This control does not support Table Cell Scope activity” made by @Xu_Haotian02 with 56 views.

Alternative to throw? made by @adext with 54 views.

How to know keyboard input source or Caps lock status made by @mountie with 51 views.

Top 3 Topics with Most Replies

Error code:“This control does not support Table Cell Scope activity” made by @Xu_Haotian02 with 20 replies.

How to know keyboard input source or Caps lock status made by @mountie with 18 replies.

Convert pdf to textfile made by @0bb4628e217fd43ac86ac9294 with 11 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 39 posts!

@Anil_G made 35 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 2 likes!

How to know exception was generated from which activity?

Hi @mountie Try this exception.Source If you have renamed the acitivities you can easily find out in which acitivity you are getting the error. Hope it helps Regards

This post made by @mkankatala received 2 likes!

Getting Wrong Format Data In Excel

Instead of using the Workbook activity use the Excel activities, Use the Use excel file activity and insert the For each excel row activity to loop through the each row. Change the property of Use excel file activity to raw value for Read formatting option. Hope you understand!! @Thriesh_Naidu

This post made by @hp321 received 2 likes!

Extracting values that appear in one data column and not in the other data table

Thank you @Parvathy, @sanjay3, @Anil_G, @Yoichi for your helpful answers! You each really helped me!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

How to know exception was generated from which activity?

Hi @mountie Try this exception.Source If you have renamed the acitivities you can easily find out in which acitivity you are getting the error. Hope it helps Regards

This solution provided by @mkankatala received 2 likes!

Getting Wrong Format Data In Excel

Instead of using the Workbook activity use the Excel activities, Use the Use excel file activity and insert the For each excel row activity to loop through the each row. Change the property of Use excel file activity to raw value for Read formatting option. Hope you understand!! @Thriesh_Naidu

This solution provided by @Parvathy received 1 likes!

Do while

Hi @A_Learner Your sequence is right Do While activity: Body: If activity: Condition Then: Throw activity: Exception: new BusinessException() Break activity End If Hope it 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 | 27 December 2023

Top 3 Topics with Most Views

How to deal with the blank POP up while using a wait for download activity made by @elt.rd13 with 49 views.

Argumentsand Variables made by @0bb4628e217fd43ac86ac9294 with 47 views.

Project Design Mode Selection property Not present in Studio after latest patch update made by @gRao with 46 views.

Top 3 Topics with Most Replies

Webで取得した文字列の一部の文字列を取り除きたい。 made by @kiki1 with 17 replies.

How to vlookup for the huge data made by @anjani_priya with 15 replies.

Project Design Mode Selection property Not present in Studio after latest patch update made by @gRao with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@vrdabberu made 29 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @pravallikapaluri received 2 likes!

String character modify

Hi @AJITH_SK if (inputString.Length >= 4) inputString = inputString.Substring(0, inputString.Length - 4) + "****"; [image] [image]

This post made by @jjes received 2 likes!

"Run from this" and other debugging tips

Time for another quick tutorial, this time with 2 useful (and 1 useless) tips for better and more effective debugging in UiPath Studio: [2 useful (and 1 useless) debugging tips for UiPath Studio]

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

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

Issues with Regex Pattern in Capturing Dynamic Text Fields

Hi @divyanshu52 Please use below regex expression (Line1.*\d*)|((Invoice[^:\s].*)|(Invoice(?=\s)))|((Status[^:\s].*)|(Status(?=\s)))|((FieldValue[^:\s].*)|(FieldValue(?=\s)))|(Invoice:Status:.*)|((Error[^:\s].*)|(Error(?=\s+Instructions)))|(Instructions.*) Regards

This solution provided by @Anil_G received 1 likes!

Move files from desktop to Sharepoint subfolder - issue

@dbukk You have to provide the drivename also whcih is the document library name Use subfolder field as the relative path to the folder you need for example if sp sire is xxxsharepoint.com/sites/sitename/drivename/folder1/folder2/requiredfolder then url is - xxxsharepoint.com/sites/sitename Drivename - drivename Subfolder = folder1/folder2 Query - requiredfolder Hope this helps cheers

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

유아이패스 상에서 오라클 SQL 실행할 때 먹통이 되는 이유

Hi @ZEROIN_KG , Please pay attention to the execution time of this activity, by default it will be about 30 seconds. If this time expires and the query cannot be completed, it will cause an error. Please adjust its properties if there is a time delay, or you can directly use the delay operation right after the query action. 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 | 28 December 2023

Top 3 Topics with Most Views

Idea for logic made by @Iswarya_P1 with 46 views.

Folder path copy. but exception files....error made by @taejin3690 with 45 views.

Linq Query Syntax Return Type is not IGrouping made by @enesb with 43 views.

Top 3 Topics with Most Replies

Want to create a library were I want status Successful and Failure of Queue Items made by @BHUSHAN_NAGAONKAR1 with 14 replies.

How to delete the row in datatable? made by @chandu_royal with 14 replies.

How to access data from Select Multiple Items made by @Wahaj11 with 12 replies.

Top 3 Users Who Posted The Most

@mkankatala made 25 posts!

@Anil_G made 22 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @Mohan_Reddy received 2 likes!

How to automate installed mobile app using UIpath studio?

Hi @sohyl , Refer following documents it might help you. Mobile Device Manager (MDM), a tool that connects to real or simulated devices through Appium. With the help of Mobile Device Manager, you can record and perform actions, manage devices and applications, run tests, and debug. It supports Android, iOS, and Web for emulators and real devices that are connected through the cloud, your local network, or USB.

This post made by @vrdabberu received 1 likes!

Based on two column value we need concatenate remain column value

Hi @Jijendiran_Murugan Please check the below thread Regards

This post made by @sohyl received 1 likes!

How to automate installed mobile app using UIpath studio?

Here is what I want to automate: starting a mobile app → click on a search box → type in search string → hit search button → scrap the result. But I have no idea how to connect to the mobile app from UiPath studio (for example, uber app. btw, I am connecting to physical device). The article I read are all using demo APK “TheApp”, but the real app has already installed on the physical phone which I have no clue where to find the APK. Anyone kindly enlighten.

Top 3 Most Liked Solutions

This solution provided by @Mohan_Reddy received 2 likes!

How to automate installed mobile app using UIpath studio?

Hi @sohyl , Refer following documents it might help you. Mobile Device Manager (MDM), a tool that connects to real or simulated devices through Appium. With the help of Mobile Device Manager, you can record and perform actions, manage devices and applications, run tests, and debug. It supports Android, iOS, and Web for emulators and real devices that are connected through the cloud, your local network, or USB.

This solution provided by @Parvathy received 1 likes!

How to bring window to the focus

Hi @A_Learner In a Citrix environment, bringing a window to the front may have limitations. However, you can simulate pressing Alt + Tab to cycle through open windows, bringing the desired one to the foreground. Introduce delays in your script and explore any specific functions your automation tool offers for Citrix environments. Trial and error might be needed due to virtualized environment constraints. Try using Keyboard Shortcuts activity or Send Hotkeys and give Alt+Tab. Hope it helps Re…

This solution provided by @Yoichi received 1 likes!

Folder path copy. but exception files....error

HI, How about the following? [image] Sequence.xaml (10.3 KB) Note: Please create folder in advance using the above exception file_copy folder.xaml. 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 | 29 December 2023

Top 3 Topics with Most Views

I want a Linq Query to Compare two excel sheet made by @Melbin_Antu1 with 37 views.

How To download the latest community studio, I can not find the download link! made by @Lori with 34 views.

Read Link From Excel, Write To Excel made by @Emre_Toy with 33 views.

Top 3 Topics with Most Replies

Read Link From Excel, Write To Excel made by @Emre_Toy with 20 replies.

Cron Expression For Biweekly Tuesday At 12PM made by @Putta_Sri_Sai_Rishik_Chow with 15 replies.

How to remove rows that have completed iteration from a DataTable help made by @22222222asas with 13 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 21 posts!

@pravallikapaluri made 14 posts!

@Nguyen_Van_Luong1 made 13 posts!

Top 3 Most Liked Posts

This post made by @Emre_Toy received 1 likes!
https://forum.uipath.com/t/709337/10

This post made by @pravallikapaluri received 1 likes!

How to remove rows that have completed iteration from a DataTable help

@22222222asas As the Data in the datatable is going to change after Removing data from datatable.It will throw an error that “Collection is modified” using for each Use the linq Query instead of it after reading the excel dtInput = dtInput.AsEnumerable().GroupBy(Function(row) row.Field(Of String)("ColumnName")).Select(Function(group) group.First()).CopyToDataTable() [image] Hope it helps!!

This post made by @Yoichi received 1 likes!

Invoke Code - Change of content for in_arguments

Hi, Because List type variable is reference type and it passes not value but reference (Address) So, if we modify content of reference type variable in InvokeCode, the varaible will be changed outside of InvokeCode because its content exists in same address. [image] Note String is special reference type and it behaves like value type. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Invoke Code - Change of content for in_arguments

Hi, Because List type variable is reference type and it passes not value but reference (Address) So, if we modify content of reference type variable in InvokeCode, the varaible will be changed outside of InvokeCode because its content exists in same address. [image] Note String is special reference type and it behaves like value type. Regards,

This solution provided by @AutomationX_by_Kiran received 1 likes!

Dynamic Selector Challenge in UiPath Studio

Hi @Swaroop_Naidu , Please follow below steps Dealing with dynamic selectors requires a flexible approach. Here are some strategies: Use wildcards (*) in the selector to match dynamic parts of the element’s attributes. Leverage the UiExplorer tool to fine-tune and validate dynamic selectors visually. Consider using relative selectors or anchor-based selectors to provide more stability. If possible, use reliable attributes like “id” or “class” that are less likely to change. Regularly review …

This solution provided by @vrdabberu received 1 likes!

Datatable click

Hi @wjdehdnr456 [image] Open the above highlighted one if the aaname or else innertext is not visible. [Screenshot (199)] [Screenshot (200)] [Screenshot (201)] 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 | 30 December 2023

Top 3 Topics with Most Views

Filtering data table by using a LINQ query's made by @killarapusiva with 40 views.

Attended robot with database made by @takyysh with 38 views.

Have a doubt on object repository made by @Rad_K with 38 views.

Top 3 Topics with Most Replies

Check App State Problem made by @Emre_Toy with 23 replies.

Filtering data table by using a LINQ query's made by @killarapusiva with 8 replies.

Need String manipulation made by @Soumith with 5 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 24 posts!

@Emre_Toy made 13 posts!

@AutomationX_by_Kiran made 9 posts!

Top 3 Most Liked Posts

This post made by @Emre_Toy received 1 likes!
https://forum.uipath.com/t/709547/11

This post made by @Emre_Toy received 1 likes!
https://forum.uipath.com/t/709547/12

This post made by @Emre_Toy received 1 likes!

Check App State Problem

Yes please thank you so much

Top 3 Most Liked Solutions

This solution provided by @AutomationX_by_Kiran received 1 likes!

Filtering data table by using a LINQ query's

Hi @killarapusiva , // Assuming dt is your DataTable var filteredRows = from row in dt.AsEnumerable() where row.Field(“Status”) == “Completed” && row.Field(“Priority”) > 3 select row; // Convert the result to a new DataTable or use further processing DataTable resultDataTable = filteredRows.CopyToDataTable(); This LINQ query selects rows from the DataTable where the “Status” column is “Completed” and the “Priority” column is greater than 3. The CopyToDataTable() method is then used to co…

This solution provided by @AutomationX_by_Kiran received 1 likes!

LINQ Query to Group and Sum Data in DataTable Columns

// Assuming dt is your DataTable This LINQ query groups the DataTable by the “Category” column and calculates the sum of the “Amount” for each category. The result is then converted into a new DataTable with columns “Category” and “TotalAmount.” var groupedData = from row in dt.AsEnumerable() group row by row.Field(“Category”) into grouped select new { Category = grouped.Key, TotalAmount = grouped.Sum(row => row.Field(“Amount”)) }; // Convert the result to a new DataTable or use further…

This solution provided by @pravallikapaluri received 1 likes!

Getting data from a website

Hi @Soumith If you are Extracting a tabular data,You can use the below activities [image] Hope it 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 | 31 December 2023

Top 3 Topics with Most Views

Reframework states made by @A_Learner with 37 views.

Dynamic Input Handling in UiPath Studio Forms made by @Lokeswari_Nakka with 34 views.

Controlled access to users in modern folder UiPath 2022.10 Orchestrator made by @visali_j with 34 views.

Top 3 Topics with Most Replies

Reframework states made by @A_Learner with 9 replies.

How to pass list to a drop down inside a edit grid in form made by @Nitin_Mishra with 9 replies.

Unable to access my UiPath-ADAv1 certificate made by @Vankayalapati_Varun_Chowd with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 11 posts!

@AutomationX_by_Kiran made 10 posts!

@Parvathy made 10 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 1 likes!

Reframework states

Hi @A_Learner If you have given the retry count when creation of Queues or in Config file. Then it will retry based on your retry count. If you got the system exception in the Process state, it will retry based on your retry count. In the retry it will not retry the activity which failed, it will start retrying the same transaction item from the Initialization. In the Set Transaction status xaml there is a close application activity which close the application before returning to the Initiali…

This post made by @vrdabberu received 1 likes!

Doubt with Selector

Hi @Soumith Please follow automate with Rakesh YouTube videos [UiPath Selectos Tutorial | Full Tutorial Series | By Rakesh] Regards

This post made by @pravallikapaluri received 1 likes!

Doubt with Selector

Hi @Soumith Refer thw below video [UiPath Selectos Tutorial | Full Tutorial Series | By Rakesh] Hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Reframework states

Hi @A_Learner If you have given the retry count when creation of Queues or in Config file. Then it will retry based on your retry count. If you got the system exception in the Process state, it will retry based on your retry count. In the retry it will not retry the activity which failed, it will start retrying the same transaction item from the Initialization. In the Set Transaction status xaml there is a close application activity which close the application before returning to the Initiali…

This solution provided by @pravallikapaluri received 1 likes!

Doubt with Selector

Hi @Soumith Refer thw below video [UiPath Selectos Tutorial | Full Tutorial Series | By Rakesh] Hope it helps!!

This solution provided by @AutomationX_by_Kiran received 1 likes!

Connecting Jira Project in Uipath Test suit

Hi @Murali_Dhar , Please follow below steps for the INtegration of Jira with Test Suite . Cheers!

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

@Yoichi received 35 likes for their solutions!

@Anil_G received 29 likes for their solutions!

@AutomationX_by_Kiran received 24 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 January 2024

Top 3 Topics with Most Views

Extract Datatable From Tiff File made by @Rpa29 with 50 views.

Unable to find "Modern Design Experience" button made by @laxmikant.bhale with 46 views.

HOW TO ADD AN USER TO UIPATH ORCHESTRATOR made by @francogeno97 with 45 views.

Top 3 Topics with Most Replies

24:00:00をDateTime変数に代入する方法 made by @gorby with 10 replies.

Connect to Oracle DB from user machine made by @takyysh with 10 replies.

Exception.SourceがSystem.Activitiesと表示されてしまいます made by @gorby with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 13 posts!

@mkankatala made 9 posts!

@gorby made 8 posts!

Top 3 Most Liked Posts

This post made by @laxmikant.bhale received 1 likes!

Unable to find "Modern Design Experience" button

Hi @mkankatala Thanks for the update! I appreciate the information about the changes in UiPath Studio version 2023.12.0. It’s helpful to know that the option to switch between classic and modern design experiences has been removed. The tip on accessing classic activities through the activities panel filter is especially valuable. I’ll keep that in mind for my workflow. Thanks again! @laxmikant.bhale

This post made by @Alex_Phillips received 1 likes!

Getting Error while open Main.xaml to get start

Hey @mkankatala, so you cant use UiPath Studio with windows 7. Is that correct?

This post made by @mkankatala received 1 likes!

Reframework states

Yes @A_Learner If there is no retry count, in this case also it will close all application and process the next transaction item. In your second query, the Transaction item status set to retried and it will create a new transaction item with the same details in failed transaction item. Hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Catch

Hi @Pushpendra_kowthavarapu System.Exception will capture all exceptions in the code. Encapsulate code with in the Try catch activity. In catch create an System.exception. It will handle all exceptions. Hope it 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 | 02 January 2024

Top 3 Topics with Most Views

Start Job Usage made by @DH_P3T with 49 views.

Dateformat made by @0bb4628e217fd43ac86ac9294 with 44 views.

How to update running process? made by @mountie with 43 views.

Top 3 Topics with Most Replies

Dateformat made by @0bb4628e217fd43ac86ac9294 with 21 replies.

Extract table data timing issue made by @Niranjan_k with 17 replies.

Screen Scraping selector made by @Wagner_Macedo with 16 replies.

Top 3 Users Who Posted The Most

@mkankatala made 51 posts!

@Anil_G made 21 posts!

@lrtetala made 20 posts!

Top 3 Most Liked Posts

This post made by @itbuddy1 received 2 likes!

How to get difference records of 2 datatable

sure, I’ll provide you the input files

This post made by @DimitriLYR received 1 likes!

Recording the whole execution of each job

Okay, I don’t think you can record the whole process unfortunately. I leave room for other answers, I hope you find a solution.

This post made by @mkankatala received 1 likes!

Screen Scraping selector

Thank you and wish you the same brother @Wagner_Macedo

Top 3 Most Liked Solutions

This solution provided by @Nawazish_Ahmad received 1 likes!

How to print entire array or dictionary or list in single message box

Hi @Vinay_Gite1 For Array name as MyArray MessageBox = String.Join(Environment.NewLine, MyArray) For List name as MyList MessageBox = String.Join(Environment.NewLine, MyList.ToArray()) For Dict name as MyDict MessageBox = String.Join(Environment.NewLine, MyDict.Select(Function(keyvalue) keyvalue.Key & ": " & keyvalue.Value)) Hope it will helps you Cheers!!

This solution provided by @mkankatala received 1 likes!

Legacy in UiPath Apps

The function of options is same but usage and names are different. You can learn the VB Apps from the given playlist of @Harika_Mudiam Check the below link to learn VB Apps, [UiPath Apps - VB Expressions - Create your 1st App with VB expression Right from scratch] Hop you understand!!

This solution provided by @mkankatala received 1 likes!

Datatable extraction

After extract datatable activity use the for each row in datatable activity to iterate the values in the datatable. Inside for each insert the assign activity and provide the below expression. - Assign -> Currentrow("Column name") = System.text.regularexpressions.Regex.match(Currentrow("Column name"),"[\d.]+").Value Hope you understand!!

---

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

Top 3 Topics with Most Views

How to add dynamically todays date in Typeinto made by @Niranjan_k with 53 views.

Exciting Announcement: Introducing Snowflake's Latest Feature - RSA Key Authentication made by @Samrat_Dutta with 50 views.

Add a value to Excel made by @wjdehdnr456 with 50 views.

Top 3 Topics with Most Replies

How to put condition for two columns made by @anjani_priya with 17 replies.

Send mail not from VM mail but from another mail address through VM machine made by @Ellen with 15 replies.

Office 365 Online ( Download Attatchments ) made by @Zainab_Zaidi with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@mkankatala made 23 posts!

@lrtetala made 13 posts!

Top 3 Most Liked Posts

This post made by @Samrat_Dutta received 2 likes!

Exciting Announcement: Introducing Snowflake's Latest Feature - RSA Key Authentication

Exciting Announcement! We’ve introduced RSA Certificate Authentication for the Integration Service Snowflake connector. RSA certificate authentication offers enhanced security by using public-key cryptography. It eliminates the need for passwords, reducing the risk of unauthorized access and providing a robust and scalable authentication solution. Learn how to generate your RSA Key Pair at: Key-pair authentication and key-pair rotation | Snowflake Documentation. Once you’ve establis…

This post made by @mkankatala received 2 likes!

Application auto close problem after invoking activity of library project

Hi @mountie I hope you used the Use application\browser activity to launch the application or webpage. If yes, you have to do some modifications in the properties of Use application\browser activity to handle this behavior. Open the Properties Keep Always option for open option, Keep Never option for close option, In the Window attach mode keep the Single window option, In the Resize window option select the maximize. The above properties have to change for the Use application\browser act…

This post made by @Anil_G received 2 likes!

How to check if datatable is empty or not?

@Sanket_Shinde1 A small correction IsNothing(dt) OrElse dt.AsEnumerable.All(function(x) x.ItemArray.All(function(y) String.IsNullOrEmpty(y.ToString))) cheers

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

Application auto close problem after invoking activity of library project

Hi @mountie I hope you used the Use application\browser activity to launch the application or webpage. If yes, you have to do some modifications in the properties of Use application\browser activity to handle this behavior. Open the Properties Keep Always option for open option, Keep Never option for close option, In the Window attach mode keep the Single window option, In the Resize window option select the maximize. The above properties have to change for the Use application\browser act…

This solution provided by @Anil_G received 2 likes!

How to check if datatable is empty or not?

@Sanket_Shinde1 A small correction IsNothing(dt) OrElse dt.AsEnumerable.All(function(x) x.ItemArray.All(function(y) String.IsNullOrEmpty(y.ToString))) cheers

This solution provided by @pravallikapaluri received 1 likes!

Cannot selection indicate target on screen

Hi @windy.dekdoy Try to use strict selector instead of fuzzy selector Hope it 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 | 04 January 2024

Top 3 Topics with Most Views

How to change date format into specific month made by @anjani_priya with 59 views.

Log Message: Column 'HR' does not belong to DataTable(config file) made by @chandrakala.productanalys with 48 views.

Excel-based Run Query stuck made by @Fabio_G_Silva with 46 views.

Top 3 Topics with Most Replies

How to change date format into specific month made by @anjani_priya with 49 replies.

Need to calculate two columns of notepad made by @dipon1112000 with 25 replies.

How to sum three columns in LINQ query made by @sathish_Kumar6 with 22 replies.

Top 3 Users Who Posted The Most

@mkankatala made 54 posts!

@anjani_priya made 34 posts!

@Anil_G made 33 posts!

Top 3 Most Liked Posts

This post made by @vrdabberu received 3 likes!

Unable to process division

Hi @dipon1112000 ] Check out the below workflow: [image] Assuming your input is like below: [image] =>Use Read CSV to red the file and store the output in a datatable. => Use For Each row in DataTable to iterate through each row and give the below syntax in assign activity: Number1= CDbl(CurrentRow("column3").ToString) Number2= CDbl(CurrentRow("Column5").ToString) Note: Number1 and Number2 are of DataType System.Double. => Use WriteLinew to print the values by giving below syntax: (Nu…

This post made by @mkankatala received 2 likes!

Re-framework exception occurs stars

Hi @siva_sankar There is only two exceptions here one is Business Exception and second is System Exception. We don’t have failed exception, if any unknown exception occurs it will consider it as System Exception. If we will discuss about flowing of states. → If the Transaction status is Success it will increment the transaction item and go for the next transaction started from Get transaction item state. → If the Transaction status is Business Exception it will consider the present transa…

This post made by @siva_sankar received 1 likes!

Re-framework exception occurs stars

In this case if system rule expection occurs means or application expection occurs means it will go to the int state right???

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Excel condition value

@wjdehdnr456 Looks like this is a duplicate Cheers

This solution provided by @Yoichi received 1 likes!

Need Help in Excel segregation and Splitting

Hi, I think it’s necessary to clarify your requirement more, for example key etc. However, how about the following? [image] Sample20240101-2.zip (15.0 KB) Regards,

This solution provided by @vrdabberu received 1 likes!

When comparing DT1 and DT2, retrieve the matching rows Help

Hi @22222222asas Try this query: resultDataTable = (From row1 In DT1.AsEnumerable() Join row2 In DT2.AsEnumerable() On row1("NUMBER").ToString() Equals row2("NUMBER").ToString() Select row1).CopyToDataTable() resultDataTable is of DataType System.Data.DataTable If possible share the DT1 and DT2 data tables with dummy data. 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 | 05 January 2024

Top 3 Topics with Most Views

Write cells from bottom to top help made by @22222222asas with 41 views.

Pdf automationn made by @Nikhil_Katta with 41 views.

UI Automation - cannot select a hoverable element made by @MKB with 41 views.

Top 3 Topics with Most Replies

UI Automation - cannot select a hoverable element made by @MKB with 16 replies.

Selection option made by @Wagner_Macedo with 14 replies.

How to use Mouse over and click toggle button in StudioX? made by @rosshild21 with 12 replies.

Top 3 Users Who Posted The Most

@mkankatala made 28 posts!

@lrtetala made 23 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @pikorpa received 2 likes!

I need to break a Captcha... Preciso quebrar um Captcha

I noticed that in 2captcha you can send image as a file: [image] So, you don’t need to convert file to base64. here is eveything how to do it 2Captcha API - Captcha solver API

This post made by @mkankatala received 2 likes!

On Image Appear time out error

Hi @A_Learner Adjust Timeout property In the properties of the “On Image Appear” activity, you will find a property named “Timeout.” This represents the maximum time the activity will wait for the image to appear. Try increasing the timeout value to give the activity more time to locate the image. Depending on the nature of your automation, you can consider using other activities such as “Element Exists” or “Find Image Matches” activities. Hope it helps!! Regards

This post made by @Anil_G received 1 likes!

Autopilot for Developers - Public Preview Announcement

@Cuberoot If you open the advanced editor in any activity…you will get the feature at the bottom where you can type free text and it gives expression Cheers

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 2 likes!

I need to break a Captcha... Preciso quebrar um Captcha

I noticed that in 2captcha you can send image as a file: [image] So, you don’t need to convert file to base64. here is eveything how to do it 2Captcha API - Captcha solver API

This solution provided by @Parvathy received 1 likes!

How to sum three columns in LINQ query

Hi @sathish_Kumar6 => Use Read Range Workbook to read the exce3l and store it in an datatable say dt Input: [image] =>Use the below linq query in assign acitivity: dt= (From row In dt.AsEnumerable() Let sum = row.Field(Of Double)(0) + row.Field(Of Double)(1) + row.Field(Of Double)(2) Select newRow = dt.Clone().LoadDataRow({row(0), row(1), row(2), sum}, False)).CopyToDataTable() => Use Write Range workbook to write the data back to excel. Output: …

This solution provided by @Yoichi received 1 likes!

Write cells from bottom to top help

Hi, Can you try to set idx at Index property of ForEach activity, if you have not yet? [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 | 06 January 2024

Top 3 Topics with Most Views

Autofill in Excel using StudioX made by @flashdrive07 with 42 views.

Unable to extract output of Uipath made by @dipon1112000 with 37 views.

Anchor_base_selector_error made by @Pavan_kumar15 with 35 views.

Top 3 Topics with Most Replies

Unable to extract output of Uipath made by @dipon1112000 with 20 replies.

Excel Automation in Studio X made by @flashdrive07 with 8 replies.

How to write Cell Address in the "Get Cell Color" Under App Integration>Excel>Cell>Get Cell Color? made by @Thiyaga_rajan with 8 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 20 posts!

@dipon1112000 made 12 posts!

@lrtetala made 10 posts!

Top 3 Most Liked Posts

This post made by @Ragavi_Rajasekar received 1 likes!

I have a string like (- ABCDE-15-826-79- - - - - - -) . I want to add B after 9 in this string . This string is not constant , but I always wanted to add B before the last set of hyphens starts

Thank you so much … it worked

This post made by @Praharsha_Kanaparthi2 received 1 likes!

Hi this is Praharsha having problem with using the Classic mode in UIPATH studio the option of classic Mod itself is not visible

ok thank you @vrdabberu

This post made by @mkankatala received 1 likes!

Excel Automation in Studio X

Hi @flashdrive07 Check out the below process: [image] After Find/Replae value activity use the below syntaxes in Set Variable Value activity: Set Variable Value-> column= System.Text.RegularExpressions.Regex.Match(foundX,"[A-Za-z]+").Value.Trim() Set Variable Value-> cal= Convert.ToInt32((System.Text.RegularExpressions.Regex.Match(foundX,"(?<=[A-Z]+)[0-9]+").Value.ToString.Trim())) Set Variable Value-> cal=cal+2 Set Variable Value-> output= String.Concat(column+Cal.ToString) Note: cal i…

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Excel Automation in Studio X

Hi @flashdrive07 Check out the below process: [image] After Find/Replae value activity use the below syntaxes in Set Variable Value activity: Set Variable Value-> column= System.Text.RegularExpressions.Regex.Match(foundX,"[A-Za-z]+").Value.Trim() Set Variable Value-> cal= Convert.ToInt32((System.Text.RegularExpressions.Regex.Match(foundX,"(?<=[A-Z]+)[0-9]+").Value.ToString.Trim())) Set Variable Value-> cal=cal+2 Set Variable Value-> output= String.Concat(column+Cal.ToString) Note: cal i…

This solution provided by @Jayavignesh_G received 1 likes!

Anchor_base_selector_error

Hi @Pavan_kumar15, Can you please try to revisit the Selectors of anchor. Kindly re-indicate the selector of anchor base again and try it out Thanks in advance, Jay

This solution provided by @lrtetala received 1 likes!

Should stop activity xaml

Hi @siva_sankar arrNumbers = {1, 2, 3, … , 100} strNumbers = String.Join(", ", arrNumbers) In Get Transaction Data state [image] 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 | 07 January 2024

Top 3 Topics with Most Views

REFramework System Exception made by @A_Learner with 44 views.

Passing Arguments - return values made by @Sai_deepthi with 39 views.

About The Community license and using it on two computers made by @LamaX with 39 views.

Top 3 Topics with Most Replies

Cannot get output in notepad made by @dipon1112000 with 12 replies.

REFramework System Exception made by @A_Learner with 10 replies.

Remove Extra charcters after certain limit from a specific column in datatable made by @karthik_kulkarni1 with 9 replies.

Top 3 Users Who Posted The Most

@Parvathy made 13 posts!

@vrdabberu made 12 posts!

@lrtetala made 11 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Find All Weekends

Hi, Can you try the following expression? targetYear = 2024 targetMonth = 1 Then arrDays = Enumerable.Range(1,DateTime.DaysInMonth(targetYear,targetMonth)).Where(Function(i) New DateTime(targetYear,targetMonth,i).DayOfWeek= DayOfWeek.Saturday OrElse New DateTime(targetYear,targetMonth,i).DayOfWeek= DayOfWeek.Sunday).ToArray() [image] If you need previous month, the following will help you. targetYear =DateTime.Now.AddMonths(-1).Year targetMonth = DateTime.Now.AddMonths(-1).Month Sample …

This post made by @pikorpa received 2 likes!

Find All Weekends

Hello @wjdehdnr456 It is a working code: BlankProcess62.zip (3.1 KB) Solution which I used: Assign: currentDate = DateTime.Now Assign: firstDayPrevMonth = New DateTime(currentDate.Year, currentDate.Month - 1, 1) If currentDate.Month = 1 (January), then firstDayPrevMonth = New DateTime(currentDate.Year - 1, 12, 1). Otherwise, firstDayPrevMonth = New DateTime(currentDate.Year, currentDate.Month - 1, 1). Assign: lastDayPrevMonth = firstDayPrevMonth.AddMonths(1).AddDays(-1) Assign: nextDate…

This post made by @mkankatala received 1 likes!

REFramework System Exception

Hi @A_Learner If a System Exception occurs since the process will be enclosed within an Try Catch you can catch that Exception by using Re-Throw and in the Set Transaction State xaml you can process the code of Exit Window under System Exception. This would be a better way of Handling the exception. [image] [image] Do the required process inside the System Exception at the highlighted place in below picture. [image]. This should handle the exception efficiently. Hope it helps!! Regards …

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Find All Weekends

Hi, Can you try the following expression? targetYear = 2024 targetMonth = 1 Then arrDays = Enumerable.Range(1,DateTime.DaysInMonth(targetYear,targetMonth)).Where(Function(i) New DateTime(targetYear,targetMonth,i).DayOfWeek= DayOfWeek.Saturday OrElse New DateTime(targetYear,targetMonth,i).DayOfWeek= DayOfWeek.Sunday).ToArray() [image] If you need previous month, the following will help you. targetYear =DateTime.Now.AddMonths(-1).Year targetMonth = DateTime.Now.AddMonths(-1).Month Sample …

This solution provided by @mkankatala received 1 likes!

REFramework System Exception

Hi @A_Learner If a System Exception occurs since the process will be enclosed within an Try Catch you can catch that Exception by using Re-Throw and in the Set Transaction State xaml you can process the code of Exit Window under System Exception. This would be a better way of Handling the exception. [image] [image] Do the required process inside the System Exception at the highlighted place in below picture. [image]. This should handle the exception efficiently. Hope it helps!! Regards …

This solution provided by @lrtetala received 1 likes!

Set Transcation progress & set Transcation activity

Hi @siva_sankar Set Transaction Progress: Helps you create custom progress statuses for your In Progress Orchestrator transactions . Set Transaction Status: This activity is used to update the status of a transaction. It allows you to set the status of the current transaction, indicating whether it is successful, failed, or in progress. Set Transaction activity is present in Success, System Exception and Business Exception [image] [image] [image] Set Transaction progress ac…

---

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

Top 3 Topics with Most Views

Check if Column Contains Specific Value made by @NISHITHA with 57 views.

How to convert datatable to PDF without using Word automation. please help made by @Nancy29 with 47 views.

How to Select multiple application? made by @hoseongwon with 46 views.

Top 3 Topics with Most Replies

Convert comma seperated text to a dictionary made by @Sree_Krishnan_vellinezhi with 27 replies.

How to do screenscraping (datascraping is not an option) on dynamic data made by @dipon1112000 with 15 replies.

How to convert datatable to PDF without using Word automation. please help made by @Nancy29 with 14 replies.

Top 3 Users Who Posted The Most

@ppr made 32 posts!

@mkankatala made 30 posts!

@lrtetala made 25 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

How to remove every columns after a specific index (C# or VB)

Hi @indiedev91 Try this dt = dataTable.DefaultView.ToTable(False, dataTable.Columns.Cast(Of DataColumn).Take(17000).Select(Function(c) c.ColumnName).ToArray())

This post made by @pikorpa received 2 likes!

Json variable to keep new line breaks

Hey, Did you try this: processedString = originalString.Replace(vbCrLf, “\r\n”).Replace(vbCr, “\r”).Replace(vbLf, “\n”) This replaces Windows (vbCrLf ), Mac (vbCr ), and Linux (vbLf ) newlines with their escaped versions.

This post made by @amanda.gondim received 2 likes!

Problems with list type variables

I was putting the wrong type, now it’s gone, thank you

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 2 likes!

How to remove every columns after a specific index (C# or VB)

Hi @indiedev91 Try this dt = dataTable.DefaultView.ToTable(False, dataTable.Columns.Cast(Of DataColumn).Take(17000).Select(Function(c) c.ColumnName).ToArray())

This solution provided by @pikorpa received 2 likes!

Json variable to keep new line breaks

Hey, Did you try this: processedString = originalString.Replace(vbCrLf, “\r\n”).Replace(vbCr, “\r”).Replace(vbLf, “\n”) This replaces Windows (vbCrLf ), Mac (vbCr ), and Linux (vbLf ) newlines with their escaped versions.

This solution provided by @vrdabberu received 1 likes!

Can we use navigate to or go to url activity in for each loop

Hi @Adithyeshwar_goud you can as below [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 | 09 January 2024

Top 3 Topics with Most Views

Non-Working HOURS (not days) - Is it possible? made by @Mads_Commerou with 43 views.

How to take read range rows count and write cell of 1 to A column made by @sathish_Kumar6 with 39 views.

How to do sumifs by using uipath made by @anjani_priya with 39 views.

Top 3 Topics with Most Replies

Send hot key to browser made by @A_Learner with 18 replies.

How to do sumifs by using uipath made by @anjani_priya with 17 replies.

Comparing Values made by @Pogboom with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@mkankatala made 32 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @AlvinStanescu received 2 likes!

GetAsset() in CodedWorkflows freezing when using all arguments

Hi Lucas, It seems like there is indeed a concurrency issue when the timeout is getting hit. In your case, it would pretty much always get hit, as 1 ms is not enough for this call. If you’d use a higher timeout value the call should work just fine. Thanks, Alvin

This post made by @lucas.stern received 1 likes!

GetAsset() in CodedWorkflows freezing when using all arguments

Hi alvin, unfortanelly the problem occurs independently of the timeout param.

This post made by @Yoichi received 1 likes!

RegEx Based Extractor does not work but same expression works on Matches activity

Hi, The following may work. ((?<=Date:\s+Time:)[\s\S]*?)(?=Signature) Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

RegEx Based Extractor does not work but same expression works on Matches activity

Hi, The following may work. ((?<=Date:\s+Time:)[\s\S]*?)(?=Signature) Regards,

This solution provided by @Yoichi received 1 likes!

Excel Segregation help with format

Hi, How about the following sample? Excel Segrigation_v2.zip (17.4 KB) This uses the following Combination library. It’s necessary to add nuget feed in MangePacakge as the following. [image] https://api.nuget.org/v3/index.json Regards,

This solution provided by @ppr received 1 likes!

Excel split based on count

Variables: [grafik] Preps [grafik] Groups = (From d In ReadDT.AsEnumerable Group d By k=d(0).toString.Trim Into grp=Group Select g = grp.ToList()).ToList outerlist: Groups, innerlist: Groupmembers Splittings [grafik] Then: tmpSegment= tmpSegment.Concat(grp).ToList Else: TableList = TableList.Append(tmpSegment.CopyToDataTable).toList Last TableList = TableList.Append(tmpSegment.CopyToDataTable).toList So resulting List(of DataTable) can be used again within a For each e.g. for wri…

---

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

Top 3 Topics with Most Views

How to detect color? made by @mountie with 51 views.

How to get data from RDP using UiPath? made by @TIN_RPA with 51 views.

Typing '<' in a different keyboard language with CV made by @Joshua_Allan_0 with 49 views.

Top 3 Topics with Most Replies

Unable to extract details from youtube made by @sidhaarthcrazy with 18 replies.

How to split the values in a single cell made by @anjani_priya with 18 replies.

Can't Find GSUite package made by @Wagner_Macedo with 17 replies.

Top 3 Users Who Posted The Most

@mkankatala made 29 posts!

@pikorpa made 23 posts!

@lrtetala made 23 posts!

Top 3 Most Liked Posts

This post made by @pikorpa received 3 likes!

Get xml element problem

@Arettu63 here is solution for you: BlankProcess66.zip (2.9 KB) XNamespace: [image] for each: [image]

This post made by @pikorpa received 3 likes!

Get xml element problem

I think that you can use it: [image]

This post made by @Shiva_Nikhil received 2 likes!

DataTables - update a row based on another datatable

@adrian_sullivan can you try this in invoke code activity For Each r As datarow In dt2.AsEnumerable If dt1.AsEnumerable.Any(Function(a) (a("FileCode").ToString).trim.equals(r("FileCode").ToString.Trim)) Then r("Processed")="Y" Else r("Processed")="N" End If Next [image]

Top 3 Most Liked Solutions

This solution provided by @pikorpa received 3 likes!

Get xml element problem

@Arettu63 here is solution for you: BlankProcess66.zip (2.9 KB) XNamespace: [image] for each: [image]

This solution provided by @Shiva_Nikhil received 2 likes!

DataTables - update a row based on another datatable

@adrian_sullivan can you try this in invoke code activity For Each r As datarow In dt2.AsEnumerable If dt1.AsEnumerable.Any(Function(a) (a("FileCode").ToString).trim.equals(r("FileCode").ToString.Trim)) Then r("Processed")="Y" Else r("Processed")="N" End If Next [image]

This solution provided by @Yoichi received 1 likes!

Studio on prem trial version licensing error

Hi, I think it’s trial for UiPath platform with on-premise orchestrator and it provides with license key of Orchestrator. Can you try to apply from the following URL? 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 January 2024

Top 3 Topics with Most Views

Image exists always returning true made by @A_Learner with 53 views.

Get assest made by @Rakesh_Tiwari with 45 views.

How to Extract data from site by not using Scraping Methods? made by @Jai_Pande with 42 views.

Top 3 Topics with Most Replies

How to Extract data from site by not using Scraping Methods? made by @Jai_Pande with 22 replies.

Get assest made by @Rakesh_Tiwari with 20 replies.

Outlook search 2 made by @poojaskyrathore with 20 replies.

Top 3 Users Who Posted The Most

@mkankatala made 40 posts!

@vrdabberu made 33 posts!

@ppr made 29 posts!

Top 3 Most Liked Posts

This post made by @jack.chan received 2 likes!

Run query activity error

@fairymemay change the double quotes in the middle to ` e.g. "SELECT a.extract_date, a.due_date `Due_Date`, c.I9_company_code `Company Code`, …

This post made by @A_Learner received 1 likes!

Image exists always returning true

Thank you. In Citrix. No CV. Regards,

This post made by @lrtetala received 1 likes!

In library it doesn't validate for wrong queue name

Hi @BHUSHAN_NAGAONKAR1 Can you please check in Config File whether you are given or not [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

時刻「〇時〇分」の抽出について

こんにちは 午前または午後が無いので System.Text.RegularExpressions.Regex.Match(日にち,"\d+時(\d+分)?").Value か System.Text.RegularExpressions.Regex.Match(日にち,"(午前|午後)?\d+時(\d+分)?").Value のいずれかお試しください

This solution provided by @rikulsilva received 1 likes!

Transpose multiple rows into single column

@Rreddy Try this one. You can set the column separator as same join string separator Single Row (2).zip (14.3 KB)

This solution provided by @lrtetala received 1 likes!

Why are activities different between projects?

@rodrigo.simao [image] In your packages i didn’t see UiPath.System.Activities Package can you please download that package and Uninstall UiPath.System.Activities.Runtime Package

---

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.