Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 May 2023

Top 3 Topics with Most Views

How to take screen Shot of Data Table in excel and Insert this Screenshot in Word File made by @Gopikrishna_S with 54 views.

Aren't we having nested if-else in uipath cross platform? made by @Riya_Bansal with 47 views.

Python scope / How to run python scope made by @sooyeon_Lim with 45 views.

Top 3 Topics with Most Replies

Need to filter Excel Data based on Date made by @Learner007 with 20 replies.

Full job works except reply to email made by @Albin_Johansson with 20 replies.

How to take screen Shot of Data Table in excel and Insert this Screenshot in Word File made by @Gopikrishna_S with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@adiijaiin made 25 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @Jeroen_van_Loon received 3 likes!

Browser Use

I work with different clients and they all use different browsers. And they all work fine with UiPath. So UiPath should not be factored in when choosing a browser. Better to choose the browser in which your site / process / application works best. If my client uses Firefox to open their stuff, then I will build the robots on that as well. So Robot and human interaction stay similair. The main advantage there is that the local IT departments do not have to cope with extra compaibility requirem…

This post made by @adiijaiin received 2 likes!

Extract unique dates from List of dates in Data table

Hi @benjamin.9052 If you need only the unique years from this datatable, here’s the workflow that you can use: Datefilter.xaml (5.4 KB) Dates.xlsx (9.5 KB) expression used here: String filteredYears= actualDates.AsEnumerable.Select(function (x) DateTime.Parse(x(“Dates”).ToString).Year.ToString ).Distinct.ToArray Hope it helps. Thanks Happy Automation!

This post made by @adiijaiin received 1 likes!

Python scope / How to run python scope

There are some things that you put wrong. Also Invoke Python Method would call a function which is created inside your Py file. And I cannot see any function created with OS name in your file. Possibly can you try with Python 3.9 There might be some incompatibility with .NET Runtime version.

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 2 likes!

Extract unique dates from List of dates in Data table

Hi @benjamin.9052 If you need only the unique years from this datatable, here’s the workflow that you can use: Datefilter.xaml (5.4 KB) Dates.xlsx (9.5 KB) expression used here: String filteredYears= actualDates.AsEnumerable.Select(function (x) DateTime.Parse(x(“Dates”).ToString).Year.ToString ).Distinct.ToArray Hope it helps. Thanks Happy Automation!

This solution provided by @fernando_zuluaga received 1 likes!

How to clone or import all arguments to another file?

Hi @lovepong66 You can just select all the arguments from the workflow you want to copy with the ctrl Key pressed and then right click and copy, then go to the secondary workflow in the arguments panel and the just press ctrl + v, this is the single copy paste as always Regards

This solution provided by @Anil_G received 1 likes!

For each row in Dt table with retry scope

@Povilas_Jonikas If the retry scope is around the for each then it will start from first again if it is inside the for each then it will retry on the same iteration and continue or error out according to the retry 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 | 25 May 2023

Top 3 Topics with Most Views

I am unable to export custom activity to UiPath made by @rameespk23 with 52 views.

Organisation Pdf files in google drive made by @noussair_prof with 49 views.

LastModifiedDate on Fileinfo gives error made by @Ninjabullen with 47 views.

Top 3 Topics with Most Replies

How to show output array of string as int32 made by @private_matter with 30 replies.

Microsoft sharepoint/ onedrive Connect Help- ASAP made by @hymasharma.vemavarapu with 18 replies.

Searching_Excel made by @Gokul_Murali with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 89 posts!

@adiijaiin made 33 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

How to add to array

@NISHITHA Please try this Arrayval = System.Text.RegularExpressions.Regex.Replace(str,"(?=[A-Z])",",").Split({","},StringSplitOptions.RemoveEmptyEntries) [image] cheers

This post made by @Yoichi received 2 likes!

'IsNothing' function no longer working in Studio

Hi, For now, can you try to add full namespace as the following? Microsoft.VisualBasic.Information.IsNothing(var) Regards,

This post made by @MEGHA_cs received 2 likes!

RE framework Error convert variable

Hi, Just clear Transaction item and retype “Nothing” or Delete the Assign activity and reassign the same. It will work.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

How to add to array

@NISHITHA Please try this Arrayval = System.Text.RegularExpressions.Regex.Replace(str,"(?=[A-Z])",",").Split({","},StringSplitOptions.RemoveEmptyEntries) [image] cheers

This solution provided by @Yoichi received 2 likes!

'IsNothing' function no longer working in Studio

Hi, For now, can you try to add full namespace as the following? Microsoft.VisualBasic.Information.IsNothing(var) Regards,

This solution provided by @MEGHA_cs received 2 likes!

RE framework Error convert variable

Hi, Just clear Transaction item and retype “Nothing” or Delete the Assign activity and reassign the same. It will work.

---

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

Top 3 Topics with Most Views

UiPath & unattended license made by @Meli_Marco with 58 views.

How to pass transaction data in get transaction data without queues? made by @vnsatyasunil with 55 views.

[InfoSet] - LegacyToWindows Migration # Project Blueprint Overview made by @ppr with 49 views.

Top 3 Topics with Most Replies

How to pass transaction data in get transaction data without queues? made by @vnsatyasunil with 27 replies.

Orchestratorでログが表示されない made by @KITAHARA.HATSUMI with 23 replies.

Compare 2 sheets using 2 column names and get the uncommon data from 2 files made by @kambhampati_manisridhar with 22 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@raja.arslankhan made 35 posts!

@adiijaiin made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

[InfoSet] - LegacyToWindows Migration # Project Blueprint Overview

This post is currently in a preview version and will be further updated in the near future. TL:DR UiPath is based on a code platform provided by Microsoft. This code platform has been evolved by Microsoft and support for older versions will be phased out in the future. This creates the need to migrate existing code projects to a more recent version of the code platform - often referred to as Legacy-to-Windows migration. Migrations can cause uncertainties that should be planned for from the v…

This post made by @Anil_G received 2 likes!

Remove empty cells, rows and columns

@Kaviyarasu_N If all rows have same number of columns data that is 4 in your case…we can try like this. (From d In dtinput.AsEnumerable() Where Not(d.itemArray.All(function(x) String.IsNullOrEmpty(x.ToString))) Let ra = d.ItemArray.Where(function(x) Not String.IsNullOrEmpty(x.ToString)).Select(function(x) x.ToString) Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Cheers

This post made by @Anil_G received 2 likes!

Copy list to specific datatable column using linq

@qwerty1 In some or the other way you have to use for each to load the data One thing you can try is to use generate datatable activity and pass the list as string concatenated with new line.this will generate a datatable with one column and all the values as rows String.Join(Environment.NewLine,strlist) Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Remove empty cells, rows and columns

@Kaviyarasu_N If all rows have same number of columns data that is 4 in your case…we can try like this. (From d In dtinput.AsEnumerable() Where Not(d.itemArray.All(function(x) String.IsNullOrEmpty(x.ToString))) Let ra = d.ItemArray.Where(function(x) Not String.IsNullOrEmpty(x.ToString)).Select(function(x) x.ToString) Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Cheers

This solution provided by @Yoichi received 1 likes!

Rremove the space before the keyword or remove the word from an array of sentences and return the new array

All right. Can you try the following expression? arrRes.Select(Function(s) System.Text.RegularExpressions.Regex.Replace(s,"(?<=\b"+Stringvar1+") (?="+Stringvar2+"\b)| "+Stringvar2+"\b","")).ToArray Regards,

This solution provided by @Yoichi received 1 likes!

Webページからpdfファイルのみをすべてダウンロードする方法

こんにちは ForEachUiElemntを使うか、 https://docs.uipath.com/ja/activities/other/latest/user-guide/n-for-each-ui-element DataScraping(Table Extraction)で表を抽出し それをもとに動的セレクターで順次クリックしていく方法の いずれかが有力かと思います。

---

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

Top 3 Topics with Most Views

Downloading pdf files and moving files issue made by @Priyesh_Shetty1 with 42 views.

Convert from Legacy to Windows made by @Snowman with 41 views.

privateGPT with UiPath Robot (personal ChatGPT Project) made by @TonyNudd with 31 views.

Top 3 Topics with Most Replies

Jobs are in Pending State made by @AmlanKiranPatel with 20 replies.

Downloading pdf files and moving files issue made by @Priyesh_Shetty1 with 11 replies.

Html file to pdf file conversion made by @Rounak_Kumar1 with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Nitya1 made 18 posts!

@AmlanKiranPatel made 11 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

UiPath Apps| How To Do An Image Binding in UiPath Apps

[UiPath Apps| How To Do An Image Binding in UiPath Apps]

This post made by @fernando_zuluaga received 1 likes!

Convert from Legacy to Windows

Hi @Snowman To migrate your UiPath project to Windows, you will need to install .NET 6 on your Studio machine. .NET 6 is the default framework for Windows projects in UiPath. Installing .NET 6 will ensure that you have the necessary runtime and libraries to build and run Windows projects in Studio. Regarding running the project on Unattended Robots, you will not necessarily need to install .NET 6 on each robot machine. When you publish your project, the necessary dependencies and runtime will …

This post made by @Snowman received 1 likes!

Convert from Legacy to Windows

Thank you very much for your prompt and detail explanation. Snowman

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

Convert from Legacy to Windows

Hi @Snowman To migrate your UiPath project to Windows, you will need to install .NET 6 on your Studio machine. .NET 6 is the default framework for Windows projects in UiPath. Installing .NET 6 will ensure that you have the necessary runtime and libraries to build and run Windows projects in Studio. Regarding running the project on Unattended Robots, you will not necessarily need to install .NET 6 on each robot machine. When you publish your project, the necessary dependencies and runtime will …

---

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

Top 3 Topics with Most Views

Training classifiers and extractors from multiple processes made by @totoro84 with 39 views.

UiPath Apps, Event not triggering, tricky one? made by @Luis_Fernando with 37 views.

Getting an error as "Object reference not set to an instance of an object" made by @vignesh_S.M with 35 views.

Top 3 Topics with Most Replies

Run the whole row activities made by @Carolyna_Elsyana1 with 8 replies.

How to select/check all the items in webpage dynamically made by @rsr.chandu with 8 replies.

ReFramework - Bot keeps repeating the System Exception sequence in Set Transaction Status workflow made by @Chamath_Yapa with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 27 posts!

@Nitya1 made 21 posts!

@Chamath_Yapa made 5 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 1 likes!

Extract Checkbox value from ActiveX checkbox control

Hi @craig.norton Instead of using the “Get Text” activity, which retrieves the label of the checkbox, you can use the “Get Attribute” activity to fetch the value of the checkbox. This activity allows you to extract the value of a specific attribute of an element. Thanks!!

This post made by @Navnit_Ghadigaonkar received 1 likes!

How i get set range color activity in New Uipath Version

Gr8…thanks Its working

This post made by @HensRansen received 1 likes!

Spotify Webapi / HTTP Request Wizard: No token provided

It Works!! Thanks a lot @Anil_G !!

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 1 likes!

Extract Checkbox value from ActiveX checkbox control

Hi @craig.norton Instead of using the “Get Text” activity, which retrieves the label of the checkbox, you can use the “Get Attribute” activity to fetch the value of the checkbox. This activity allows you to extract the value of a specific attribute of an element. Thanks!!

This solution provided by @Anil_G received 1 likes!

ReFramework - Bot keeps repeating the System Exception sequence in Set Transaction Status workflow

@Chamath_Yapa As suspected there is one which is linked to itself…please delete the same [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 | 29 May 2023

Top 3 Topics with Most Views

Compare excel sheet made by @AbarnaKalaiselvam with 73 views.

I had a time in DT. How to add all time values made by @Puneet_Singh1 with 55 views.

Clicking on particular element in DataTable with For Loop made by @WilfredNg with 54 views.

Top 3 Topics with Most Replies

Compare excel sheet made by @AbarnaKalaiselvam with 36 replies.

Want date format from excel in a desired type of date format made by @ankur_kaushik2 with 24 replies.

Unable to start app from mobile made by @kunalmathkar24 with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 101 posts!

@ankur_kaushik2 made 20 posts!

@AbarnaKalaiselvam made 17 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 2 likes!

How to convert Excel to PDF using UiPath Official Packages?

Wanna learn "how to convert Excel to PDF using UiPath Official Packages ? ", check out my latest video on the same!. You can convert your excel file into PDF seamlessly. Topic discussed as follows Problem statement :point_right:Required packages to perform the task :point_right:How to use Excel Save As PDF activity :point_right:Prepare the code and run in LIVE [Convert Excel To PDF | UiPath | Excel Save As PDF Activity]

This post made by @vishal.kp received 1 likes!

Variable assignment - I have 4 variables but only one variable will always have value.I want a condition in type into activity which types only that variable which has value

Hi @ravig1206 , Use the nested if statement to check if the variable has the value. Eg:- if(not string.IsNullOrEmpty(a),a,if(not string.IsNullOrEmpty(b),b,next condition if any)) Regards,

This post made by @Anil_G received 1 likes!

Take screenshot of entire window including date time stamp on the taskbar in chrome

@sankaran.33 Do not indicate anything in the classic/Modern take screenshot activity then it would take the screenshot of whole screen as you need. Here is the bot screenshot [Test] cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Use contains function in If condition

@Akshat_Sharma1 Please use this Arr1.Where(function(x) str.ToLower.Contains(x.ToLower))(0) The array basically contains only one if only one matched and you can access by index (0) Hope this helps Cheers

This solution provided by @Nikhil_Vernekar received 1 likes!

Find (" ") and replace ("") values in Excel file with 50k+ rows

Excel_Data_Trim.zip (10.3 KB) Attached is the workflow. Let me know if this helps!

This solution provided by @Anil_G received 1 likes!

How to clear excel sheet

@suraj_gaikwad Clear datatable will not work… use clear sheet or Delete file Or Use a different filename always Clear datatablew ill only clear the datatable you are writing but not the excel 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 | 30 May 2023

Top 3 Topics with Most Views

How to extract RAM, ROM, Screen Size, Camera , product name from below 2 string made by @babita with 59 views.

Read range error excel sheet made by @suraj_gaikwad with 52 views.

For Each: Unable to cast object of type “System. Char” to type “System.Net.Mail.MailMessage” made by @Kate-Ketsirin with 44 views.

Top 3 Topics with Most Replies

Covert text to json made by @Hazem_Saleh with 15 replies.

For Each: Unable to cast object of type “System. Char” to type “System.Net.Mail.MailMessage” made by @Kate-Ketsirin with 15 replies.

Need assistance with automating legacy application (Check box) in UiPath's Community forum made by @gibl.rpa with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Yoichi made 59 posts!

@postwick made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How can i delet my account in Uipath

Hi, Please access the following URL then create organization as Community. (we might be able to create it before delete current organization) https://cloud.uipath.com/portal_/register?subscriptionPlan=community&ecommerceRedirect=false Regards,

This post made by @Yoichi received 2 likes!

Help with Regex statement

Hi, Thank you for sharing. This txt file’s linebreak is CR (0x0D) (Old Mac style linebreak). So we need to use the following pattern, for example. Can you try this? System.Text.RegularExpressions.Regex.Match(strData,"(?<=Title:\s).*?(?=[\r\n])").Value Regards,

This post made by @supermanPunch received 2 likes!

Common Items among Three Arrays

Hi @PPIM_RPA , You could maybe try using the Intersect method : array1.Intersect(array2).Intersect(array3).ToArray array1, array2, array3 are variables of type Array of String. Visual : [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How can i delet my account in Uipath

Hi, Please access the following URL then create organization as Community. (we might be able to create it before delete current organization) https://cloud.uipath.com/portal_/register?subscriptionPlan=community&ecommerceRedirect=false Regards,

This solution provided by @Yoichi received 2 likes!

Help with Regex statement

Hi, Thank you for sharing. This txt file’s linebreak is CR (0x0D) (Old Mac style linebreak). So we need to use the following pattern, for example. Can you try this? System.Text.RegularExpressions.Regex.Match(strData,"(?<=Title:\s).*?(?=[\r\n])").Value Regards,

This solution provided by @Yoichi received 1 likes!

How to get all digits by specific pattern by using regex?

Hi, How about the following? [image] Sequence1.xaml (6.8 KB) 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 | 31 May 2023

Top 3 Topics with Most Views

Extract multiple file PDf in one folder to excel made by @mycroft7 with 49 views.

Regex for paragraph made by @Kuldeep_Pandey with 49 views.

No ML Skill available error in ML skill activity for Robot and Endpoint both mode made by @Aakash_Singh_Rawat with 46 views.

Top 3 Topics with Most Replies

Extract multiple file PDf in one folder to excel made by @mycroft7 with 20 replies.

Filter datatable on date range made by @adishjain with 16 replies.

No ML Skill available error in ML skill activity for Robot and Endpoint both mode made by @Aakash_Singh_Rawat with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@arjunshenoy made 24 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @adiijaiin received 3 likes!

How to check the time between the 12am to 6am?

Hi @verma.vishal Welcome to the Community! You can use a flow decision or an if condition Now> DateTime.Parse(Now.toString(“MM-dd-yyyy 00:00:00”)) and Now<DateTime.Parse(Now.toString(“MM-dd-yyyy 06:00:00”)) [image]

This post made by @arjunshenoy received 2 likes!

Filter datatable on date range

Hi @adishjain Please give the following query a try: filteredDt = (From row In dt.AsEnumerable() Let documentDate = DateTime.ParseExact(row.Field(Of String)("Document Date"), "dd-MM-yyyy", CultureInfo.InvariantCulture) Where documentDate >= fromDate AndAlso documentDate <= toDate Select row).CopyToDataTable() “Document Date” is the column name of the document date column that you are referring to. Hope this helps, Best Regards.

This post made by @arjunshenoy received 2 likes!

How to check the time between the 12am to 6am?

Hi @verma.vishal, welcome to the Community. You can use the following condition to determine the above specified condition: Now.TimeOfDay >= New TimeSpan(0, 0, 0) AndAlso Now.TimeOfDay < New TimeSpan(6, 0, 0) [image] Hope this helps, Best Regards.

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 3 likes!

How to check the time between the 12am to 6am?

Hi @verma.vishal Welcome to the Community! You can use a flow decision or an if condition Now> DateTime.Parse(Now.toString(“MM-dd-yyyy 00:00:00”)) and Now<DateTime.Parse(Now.toString(“MM-dd-yyyy 06:00:00”)) [image]

This solution provided by @Yoichi received 1 likes!

アクティビティをテストするとエラー/Error when [test activity]「An item with the same key has already been added. Key: NApplicationCard_1」

こんにちは 手元の環境（23.4.1)では特段問題なくTestActivityメニューから実行できました。 となりますとStudioのバージョン要因かもしれません。(23.4でFIXされているのかも）

This solution provided by @Ganesh_Tiwari1 received 1 likes!

Need assistance with automating legacy application (Check box) in UiPath's Community forum

@gibl.rpa if you cannot check the checkbox from header try selecting all check box using while loop and tick using dynamic selectors (make table row dynamic). #CHEERS @UiPath_Community

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

@Yoichi received 72 likes for their solutions!

@Anil_G received 71 likes for their solutions!

@arjunshenoy received 18 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 June 2023

Top 3 Topics with Most Views

Need LINQ expression made by @Mr.Bug_Maker with 67 views.

Excel Unattended made by @odure with 56 views.

Excel Duplication matching made by @Gokul_Murali with 49 views.

Top 3 Topics with Most Replies

Using binary content type in HTTP client made by @aquinn with 23 replies.

Issue with sending Http post request made by @aquinn with 21 replies.

Excel Unattended made by @odure with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@Yoichi made 36 posts!

@aquinn made 27 posts!

Top 3 Most Liked Posts

This post made by @Ahmed_Nizamuddin1 received 3 likes!

I want to extract Fullname of csv file(recent give), starting with "Entity Changes" name (in Screenshot highlighted file)

Hi @Gaurav_Gore , If you’re looking to get the latest file from specific folder then you can use below code. ' Specify the directory path Dim directoryPath As String = "your_directory_path" ' Filter the files by name and extension Dim files As String() = Directory.GetFiles(directoryPath, "entitychangs*.csv").OrderByDescending(Function(f) New FileInfo(f).CreationTime).ToArray() ' Retrieve the latest file Dim latestFile As String = files.FirstOrDefault() ' Check if a file matching the criteri…

This post made by @Ahmed_Nizamuddin1 received 2 likes!

Configファイルの設定を使ってメールを送信したい

你好 @najio， 希望你一切都好。 看起来你正在尝试在主工作流程中的catch块中发送电子邮件，以便在出现异常时发送。 我想提出两种可能的解决方案。 首先，你可以考虑将"Init All Setting.xaml"文件放在"MainWorkflow.xaml"文件之外。这种分离可以更有效地处理异常。 或者，你可以在 Orchestrator 中创建一个资产来存储电子邮件地址。然后，在工作流程中使用"Get Asset"活动来直接从 Orchestrator 中检索电子邮件。 希望这些建议对你有所帮助。如果你有任何进一步的问题或需要额外的帮助，请随时告诉我。 最好的祝福，

This post made by @Yoichi received 2 likes!

How to clone (deep copy) dictionary

Hi, I think your understanding seems mostly correct. Basically, it depends variable type: Value types or Reference types. It’s unnecessary special care to copy Value types such as Int32, Double etc. However, Reference Types such as List, array etc are needed special care (Copy method etc. if they have) to copy deeply. (Without it, it will be shallow copy) Note: String type (and object type) is special type and it behaves like value type when copy even though it’s reference type. Regard…

Top 3 Most Liked Solutions

This solution provided by @Ahmed_Nizamuddin1 received 1 likes!

Preview PDF files from storage bucket isn't rendering in Action Centre (Version 2021.10.3) on-premise

Hi @dotbot , Hope you’re doing well, Firstly, I want to confirm whether you have already completed the necessary CORS steps for your On-Premises installation? These steps ensure that Cross-Origin Resource Sharing is properly configured to allow communication between different domains both (orchestrator & Action center). If you haven’t performed these steps yet, please follow below steps. To configure Orchestrator settings to accept storage bucket requests from Action Center, please follow t…

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

How to get email address without domain using regex

Hi @jrin3753 Welcome to community Check this out System.Text.RegularExpressions.Regex.Replace(yourString.Substring(0,yourString.IndexOf(“@”)),“[^A-Za-z0-9]”,“”)

This solution provided by @MadsV received 1 likes!

Manipulation and concating of data from one Excel sheet to another

I found a way by using row.Item(1).ToString.Replace(system.text.RegularExpressions.Regex.Match(row(1).ToString,“\d+”).Value,“”).Trim and then assigning it to a temporary row so I could get it later. Thanks a lot

---

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

Top 3 Topics with Most Views

Active Accessibility stopped working after Chrome update made by @Yameso with 95 views.

Invoke process will not end made by @raven with 56 views.

Uipath worst automation tool made by @robo_007 with 49 views.

Top 3 Topics with Most Replies

System.NullReferenceExceptionが発生した理由 made by @gorby with 26 replies.

Excel reading error made by @suraj_gaikwad with 24 replies.

Invoke process will not end made by @raven with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 99 posts!

@Yoichi made 40 posts!

@raja.arslankhan made 31 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

What is difference between element exist and check app state

@jrin3753 One is a modern activity and other is classic Bot much of difference but one major change is …element exists cannot work for verifying the visibility of the element but check app state can be used to check the visibility of the element as well In classic for checking visibility we had to use find element activity Hope this helps Cheers

This post made by @ppr received 2 likes!

Expressão regular retornando vázio

Handling defensive Windows linebreaks \r?\n

This post made by @Yameso received 1 likes!

Active Accessibility stopped working after Chrome update

Hi, I have a big issue with Chrome Update. I have Studio 22.10.5 and using UiAutomation 22.10.5. Chrome extension is 22.10.6. I was programming some web pages with Active Accessibility option in selector. For. ex. I had to print PDF from some government web page and click button “Save”: [image] It was working with AA option, Default setting was not working at all in that case. After Chrome update extension doesn’t see element in that window. This is just one of the cases I have. Now only po…

Top 3 Most Liked Solutions

This solution provided by @LAKSHMI_NARAYANA_PEMMASAN received 1 likes!

Active Accessibility stopped working after Chrome update

not sure if you have already gave try or it will work in your case but can you give a try append --force-renderer-accessibility along with your url and check if it works Regards

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

What is difference between element exist and check app state

Hey @jrin3753 It’s actually the same, with some few minor feature difference Element exist comes in classic activities Check app state comes in modern design In classic visibility check is not possible…u have to with different activity Both output returns Boolean value and are use to check a specific element whether it exists or not

This solution provided by @Yoichi received 1 likes!

Currentfile.Tostring not working

Hi, Can you try to add () like CurrentFolder.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 | 03 June 2023

Top 3 Topics with Most Views

Remove 3 lines from txt document made by @vfaundez with 40 views.

How to calculate the Years and Months and Days in Date made by @404_Error with 29 views.

How to stop the bot if a text doesn't exist made by @raju_alakuntla with 29 views.

Top 3 Topics with Most Replies

Uipath create single status report using 3 Bot made by @Shivam_Rana with 12 replies.

Excelファイルの保存に関して made by @Shige2018 with 10 replies.

Excel activities query made by @Suthari_RohithReddy with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@Yoichi made 14 posts!

@Nitya1 made 11 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 1 likes!

Uipath create single status report using 3 Bot

@Shivam_Rana 1)Make a work flow call this workflow at End process. 2)Make an bool asset and init it with True value. 3) inside work flow get asset value. 4) put if condition and check asset value is True 5) If True then first update asset value as False (So that no other robot will not use this in case of false) 6) now get all files from folder. 7) merge one by one and move in “Processed” folder.( moving will helpful to avoid duplicates in next run) 8) after merge/collate make new in se…

This post made by @Anil_G received 1 likes!

Uipath create single status report using 3 Bot

@Shivam_Rana two options Create a bot to get all status reports and merge and send update the status of all the bots to the queue only in output fields of the queue and create a process to get queue items and create a status report as needed instead of creating individual status reports cheers

This post made by @Anil_G received 1 likes!

How to use queue by Using 3 Bot on a single flow

@Shivam_Rana My bad it should be dt.AsEnumerable.Skip(assetcount).Take(100).CopyToDataTable Missed .AsEnumerable Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Get only one value from cell from datatable

Hi, How about the following? [image] Sample20230603-1aL.zip (11.7 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Lookup Value in DT and delete all the rows

@Sathish_Kumar_S Use find/Replace activity and search for Cancellations… This would give the cell value as output now use delete rows activity with specific rows option and give the rows like this System.Text.RegularExpressions.Regex.Match(cellvalue,"\d+").Value + "-" + (Excel.sheet("Sheetname").RowCount+1).ToString If in datatable please try this dt.AsEnumerable.Take(dt.Rows.IndexOf(dt.AsEnumerable.Where(function(x) x(0).ToString.Contains("Cancellations"))(0))-1).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 | 04 June 2023

Top 3 Topics with Most Views

Pdf Automation AI Center On-Prem Orchestrator Learning Help made by @Iswarya_P1 with 50 views.

REFramework Global Variables made by @ivette_lugo with 44 views.

How to handle unexpected pop up in automation made by @babita with 37 views.

Top 3 Topics with Most Replies

Pdf Automation AI Center On-Prem Orchestrator Learning Help made by @Iswarya_P1 with 9 replies.

How to handle unexpected pop up in automation made by @babita with 8 replies.

How to replace date format quickly for two columns in data table variable? made by @sathish_Kumar6 with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 11 posts!

@Yoichi made 10 posts!

@Nitya1 made 5 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 2 likes!

Restrict orchestrator API calls per user

Hi @Camila_Caldas To restrict API calls per user in Orchestrator: 1.Define roles with specific permissions that align with the desired level of API access for each user. You can assign these roles to users or groups in Orchestrator. 2.Set up Role-Based Access Control in Orchestrator. RBAC allows you to control what users or roles can do within Orchestrator, including API access. Assign the appropriate roles to each user based on their responsibilities and required level of API access. User…

This post made by @nogamikim received 1 likes!

WinActortonoと比較したマーケティングの失敗

UiPathが優れている製品であることは、理解していますが、RPAの内容も知らないBigginerにプロセスの自動化のための高邁なお説教を延々ときかされても、なにもメリットを感じないはずです。改善は現場の人間が行うことが最も必要なハズですが、そこを見落として、アカデミーのプログラムを作成をしていると思います。 トヨタやTOCというコンセプトを理解してから、Marketing戦略を組む必要があると思います。

This post made by @Anil_G received 1 likes!

カーソルの移動方法を教えてください

@allbran If you want to only move the mouse pointer to some location then use hover activity and set input mode to hardware events If you want to perform a click also then you can use click activity and again with input mode as hardwareevents Cheers

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 2 likes!

Restrict orchestrator API calls per user

Hi @Camila_Caldas To restrict API calls per user in Orchestrator: 1.Define roles with specific permissions that align with the desired level of API access for each user. You can assign these roles to users or groups in Orchestrator. 2.Set up Role-Based Access Control in Orchestrator. RBAC allows you to control what users or roles can do within Orchestrator, including API access. Assign the appropriate roles to each user based on their responsibilities and required level of API access. User…

This solution provided by @Yoichi received 1 likes!

カーソルの移動方法を教えてください

こんにちは そうであればホーバーアクティビティを使い、入力モードをハードウェアイベントにします。必要に応じてカーソルの動きの種類を設定。より細かい座標を指定するときは、クリックのオフセットを有効にして、設定を行います。 [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 June 2023

Top 3 Topics with Most Views

Edgeブラウザで名前を付けて保存が選べない made by @minami with 91 views.

Not able to click on Save As pop up in edge browser made by @vishal_nachankar with 79 views.

Selectors inside inspect element stopped working after new chrome update made by @manojj.yadav with 54 views.

Top 3 Topics with Most Replies

Quick Question! made by @170290064 with 24 replies.

Hi please help me with extract types of clauses using regex in the given word made by @praveena.nadi with 20 replies.

Filter Data Table: the value for argument 'Column Name' is not set or is invalid, filter table issue made by @lakshmi.mp with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 86 posts!

@raja.arslankhan made 27 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

@minami Open ui explorer and change the framework to active accessibility and then try to indicate the element [image] you can as well check the visual tree on the left to see if the element is identified or not…sometimes if if not identified it would be available in visual tree and you can select from there right click and use set as target element… cheers

This post made by @Yoichi received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

もう少し深堀してみたところ、 最初はダウンロードの枠のみしか選択できない →そのまま枠をターゲット要素として選択 →アンカー選択時に内部の各要素を選択できるようになる →一旦アンカー含めて確定する →再度要素を取り直すと、以降は問題ないようです。 一度21.10の環境でも試してみてはと思います。

This post made by @Anil_G received 2 likes!

Ask where to save each file before downloading button isn't working anymore in google chrome

@Ush_Dhar Keep the activity which download the file inside a wait for downlod activity…and wait for download has a output which will give the file which is downloaded… [image] Also I have checked and you can use this selector change framework from ui explorer and it is working [image] <wnd app='chrome.exe' cls='Chrome_WidgetWin_1' title='Settings - Downloads - Google Chrome' /> <ctrl name='Settings - Downloads' role='document' /> <ctrl name='Ask where to save each file before downloading…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

@minami Open ui explorer and change the framework to active accessibility and then try to indicate the element [image] you can as well check the visual tree on the left to see if the element is identified or not…sometimes if if not identified it would be available in visual tree and you can select from there right click and use set as target element… cheers

This solution provided by @arjunshenoy received 1 likes!

Relationship between the number of documents and the training time

Hi @Konrad_Mierzwa The number of data used in training a pipeline seems to be a factor that significantly increases the training time. Since the default epoch value is set to 100, some more factors such as the complexity of the document, its digitization & number of labels also make some impact. Using GPU will reduce this time but is gonna consume a lot of AI units depending upon your use case. Hope this helps, Best Regards.

This solution provided by @arjunshenoy received 1 likes!

How to get the datarow with the lowest value from datatable

Hi @richardvh, welcome to the Community. You can try this expression: DriverRow = dt_F1.AsEnumerable().OrderBy(Function(row) CInt(row("Points"))).First() The First() method to retrieve the first row from the sorted DataTable, which will be the DataRow with the lowest value in the Points column. Finally, we assign the result to the variable DriverRow. Edit: Output will be like- [image] Hope this helps, Best 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 June 2023

Top 3 Topics with Most Views

Broken selectors after Chrome/Edge update to version 114.0.1823.37 made by @Luiza_Surdu-Bob with 235 views.

UiPath Edge Extension can no longer sense or interact with the Save As Button within Edge PDF Viewer made by @taxguy33 with 88 views.

Active Accessibility(AA) is not available Suddenly made by @Kathiravan with 88 views.

Top 3 Topics with Most Replies

Problem with Browser Automation made by @Julian3 with 13 replies.

配列ないの値を分割したい made by @natsumikan with 12 replies.

Need to click the dynamic data on scroll box made by @sandhya.govindharam with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@Yoichi made 38 posts!

@argin.lerit made 14 posts!

Top 3 Most Liked Posts

This post made by @Luiza_Surdu-Bob received 8 likes!

Broken selectors after Chrome/Edge update to version 114.0.1823.37

The latest Chrome and Edge updates (114.0.1823.37) introduced a breaking change to the way support for Active Accessibility is enabled. This causes automation processes to fail when trying to interact with the following browser screens: Print popup PDF viewer Observed behavior Following the browser update, it is no longer possible to identify web elements using Active Accessibility (AA) mode with UIAutomation activities. Example of selector that no longer works because of this issue: <wnd…

This post made by @karanpvsr received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone, Good to be in the community, I am an IT Professional with 6+ years of work experience on various products alongside Solution Architecture of RPA (Robotic Process Automation) specifically in UiPath. I have graduate in my Masters in Management Information Systems at University at Buffalo Recently and I am looking for new opportunities where I can employ my expertise to create and contribute to automations based on UiPath in an organization. I hope I can learn and contribute furt…

This post made by @manojj.yadav received 3 likes!

Selectors inside inspect element stopped working after new chrome update

Hi, Just contacted UiPath support and they mentioned that after recent update for Google Chrome/Microsoft Edge (from old version to114.x.x.x) the selector which contains “< wnd >” and “< ctrl >” tags have stopped working. Then this means Active Accessibility support is broken and issue is from Chrome side. We can use --force-renderer-accessibility along with your URL or provide it as an argument to access those tags again in dev region. But the issue is, there are already running bots in produc…

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Get Email Query Categories

I believe you have to use categories/any not just categories. So… categories/any(a:a eq ‘BOT Pending’)

This solution provided by @Yoichi received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

FYI 本件に関するナレッジベース公開された模様です。

This solution provided by @postwick received 1 likes!

How to convert the text file data to datatable or excel file?

Read Text File into a string variable. Split on VbCrLf + VbCrLf (basically split on every blank line) Now you have an array of the records. Then you can For Each through the array and split each one on VbCrLf. Using Add Data Row, your array(0) will be Name and array(1) will be Age. You can just use Replace to get rid of "Name " and "Age " each time.

---

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

Top 3 Topics with Most Views

Uipath stopped working on extensions? made by @Munish_Jain with 61 views.

After converting from windows legacy to windows changes made by @lakshmi.mp with 53 views.

Sum the amount if id is duplicate made by @adishjain with 53 views.

Top 3 Topics with Most Replies

Error in Linq .Need Help made by @dutta.marina with 22 replies.

I want to compare two values using regex made by @Bhushan_Nagaonkar with 19 replies.

Sum the amount if id is duplicate made by @adishjain with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 143 posts!

@Yoichi made 38 posts!

@prateek.mehandiratta9 made 30 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 4 likes!

Monthly Forum Rewards - May 2023

Congratulations everyone…keep up the good work. Cheers

This post made by @Sudharsan_Ka received 4 likes!

Monthly Forum Rewards - May 2023

Congrats All

This post made by @Matti_rajobit received 3 likes!

Broken selectors after Chrome/Edge update to version 114.0.1823.37

If someone needs desperate fix and downgrading chrome is not possible. I accidentally found out really weird fix for this. Fix: install and open Windows Accessibility insights. If you open Windows Accessibility insights on the background UiPath seems to be able to find the selectors. I have no idea how and why this works. Maybe this will help the team solve the problem. Disclaimer, I have only tried this on my local computer and one website. The version of Accessibility Insights I am using i…

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Make array of distinct Strings from a column in a data table that has values of type Integer and String

dt.AsEnumerable.Select(Function(row) row("WE").toString).Distinct.toArray The statement is doing this already

This solution provided by @Anil_G received 1 likes!

Need to click the dynamic data on scroll box

@sandhya.govindharam With mouse scroll may I know what element you used…it should exactly match witht he required element if not it will scroll till down Alternatelt use the mouse scroll with no of scrolls and then use click activity So basically you floe should be as below While loop with condition as true and max iteration as any number may be 40 Then element exists /check app state to check for the click element On the then side use click activity On the else side use mouse scroll The…

This solution provided by @Anil_G received 1 likes!

Issue on using the Active Accessibility UI Framework after Browser Upgrade

@Jerry1 Please check this. If using modern activities a work around is provided for now. If not downgrade the browser. UiPath is working on it and can use the workaround in the mean time 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 | 08 June 2023

Top 3 Topics with Most Views

On Element Appear! made by @170290064 with 55 views.

Date column error, Error 1899 made by @Sisay_Dinku with 47 views.

Fetch date from an application, and change it to the beginning of the next month in format( MM/DD/YYYY) made by @ayushi_jain3 with 45 views.

Top 3 Topics with Most Replies

Data from PDF to Excel made by @JwK with 53 replies.

Date column error, Error 1899 made by @Sisay_Dinku with 27 replies.

On Element Appear! made by @170290064 with 22 replies.

Top 3 Users Who Posted The Most

@Anil_G made 83 posts!

@prateek.mehandiratta9 made 57 posts!

@Yoichi made 51 posts!

Top 3 Most Liked Posts

This post made by @_Chuki received 2 likes!

Edge、Chromeをアップグレード(Edge:114.0.1823.37、Chrome:114.0.5735.91)すると、セレクター操作できない

ありがとうございました。 おかげさまで安心してパッチ適用の指示を出せますm(_ _)m

This post made by @kevinpscott received 2 likes!

23.4.2 bug no longer able to select Exceptions in Try/Catch

UPDATE! I have determined I can select an Exception Type by using tab to select the dropdown and using keys to select what I want. But as you can see, selecting it with the mouse no longer works.

This post made by @Bhushan_Nagaonkar received 2 likes!

I want to compare two values using regex

@Anil_G & @argin.lerit I tried using get ocr text and image region selection. It worked. Thanks for your time and effort.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Chromium APIの優先順位について

こんにちは 個人的には シミュレート＞ChromimuAPI＞ウインドウメッセージ＞ハードウェアイベント です。対応さえしていれば、シミュレートが速く正確なので最優先。 ChromiumuAPIは直接ブラウザとのやり取りで済みますので、他よりも精度は高い傾向になると思います。ただしGoogleChromeとEdgeにしか使えない制限はあります。 https://docs.uipath.com/ja/studio/standalone/2023.4/user-guide/input-methods

This solution provided by @Anil_G received 1 likes!

How to split string into array at the end of every line

@SRoyi Welcome to the community Please use this Arrayvar = str.Split({Environment.NewLine},Stringsplitoptions.RemoveEmptyEntries) Str is the string variable where the data is stored Cheers

This solution provided by @arjunshenoy received 1 likes!

Passing the Dynamic values to the body payload in HTTP PUT requests

Hi @srinusoft37 Seems like there are some syntax issues in the dynamic parsing of the data into the payload. Please try the following syntax & let us know if this works: "{""state"":""3"",""comments"":""" + StrValue + " Completed""}" Hope this helps, Best 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 June 2023

Top 3 Topics with Most Views

TYPE INTO ACTIVITY not typing made by @BHUVAN with 53 views.

Uipath studio objects binding issue made by @Harika_Mudiam with 51 views.

How to Decode base64 string value using uipath? made by @Thumu_Suresh with 46 views.

Top 3 Topics with Most Replies

Selector Issue while downloading the PDF's made by @Priyesh_Shetty1 with 40 replies.

TYPE INTO ACTIVITY not typing made by @BHUVAN with 24 replies.

I have encountered failures in my UiPath process in certain special cases made by @Sreeja_Chilumukuri with 24 replies.

Top 3 Users Who Posted The Most

@prateek.mehandiratta9 made 54 posts!

@Anil_G made 39 posts!

@Yoichi made 38 posts!

Top 3 Most Liked Posts

This post made by @Sneha_S_Ananda received 2 likes!

Broken selectors after Chrome/Edge update to version 114.0.1823.37

Hi, You would have to download the package version 21.10.9 & load it orchestrator or to your project nuget from the official UiPath feed

This post made by @alvin.c.apostol26 received 2 likes!

Regex for extracting string

Hi UiPath, let say I have 2 possibles strings below: 10-77349_PLS LOAD & GIVE ME PO#_APR&RETAILS. THANK YOU or 10-77349_PLEASE LOAD & GIVE ME PO#_APR&RETAILS. THANK YOU How can I manipulate it to have the output format below: 10-77349_APR&RETAILS

This post made by @sidra.zeeshan received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, My name is Sidra Zeeshan. I am here because recently I have started my work as RPA developer, and I am taking courses of UiPath certifications. Hope to have good time here Thanks, Sidra.

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 1 likes!

What is the purpose of Column* section in Add Data Column Activities?

Hi @lovepong66 This Column section would take a Variable of type DataColumn. Alternate way of creating a column inside a datatable. See this example, initially I had 3 columns in my dataTable. I have used DataColumn type variable ColumnName, assigned a value to it new DataColumn(“Column4”) And then used Add Data Column activity and passed that ColumnData Variable in here. [image] The outputs are as follows: [image] e

This solution provided by @Yoichi received 1 likes!

値を検索/置換のアクティビティについて

こんにちは 例えば以下のような感じでしょうか。 [image] NewBlankTask20230609-1.zip (107.8 KB)

This solution provided by @arjunshenoy received 1 likes!

Filter email body on specific line

Hi @Tengku_Aliff, welcome to the Community. You can simple read the email body & use the following RegEx pattern to extract the desired data: Ticket ref: (\w+\d+) [image] The corresponding UiPath Syntax will be: System.Text.RegularExpressions.Regex.Match(emailBodyString,”Ticket ref: (\w+\d+)”).ToString Hope this helps, Best Regards.emphasized text

---

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

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

[system]

Daily Forum Report | 13 June 2023

Top 3 Topics with Most Views

UiPath Assistant for Excel add-in made by @Catalina_Ianus with 214 views.

Sort or Getting specific words that be included in specific value made by @hoseongwon with 58 views.

Convert Regex Result to String Variable made by @raychel.hall with 57 views.

Top 3 Topics with Most Replies

Date format issue of excel file made by @Cuberoot with 22 replies.

Type Into Error Field made by @dutta.marina with 15 replies.

웹사이트에서 다운로드 한 엑셀파일을 실행시키고싶습니다 made by @Jeongmin_Park with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Yoichi made 37 posts!

@prateek.mehandiratta9 made 35 posts!

Top 3 Most Liked Posts

This post made by @Catalina_Ianus received 6 likes!

UiPath Assistant for Excel add-in

We are glad to announce that we released UiPath Assistant for Excel, the new add-in that enables you to run your attended automations without leaving the Excel spreadsheet. So, whenever you need a robot’s help with structuring, analyzing, or updating data, you can simply open Assistant in the Excel panel and access all your Excel-related automations with no disruptions. The add-in can be accessed and downloaded as follows: Via a direct link from Microsoft AppSource By searching t…

This post made by @supermanPunch received 2 likes!

New Forms Activity Dictionaries Disabled after latest Update!

@AndyMenon , I guess this is an approved bug After updating my Studio to the latest version now, 23.4.2, I do have the same issue. And all the methods you mentioned as a work around does work. You could see that the Arguments Property is Locked in the below image and also the form Path is updated as well : [image] But again this happened only after I updated my Studio.

This post made by @adiijaiin received 2 likes!

ExcelReadRange Activity, custom range

Hi @dbukk Are there some more columns after G, which you don’t wanna read? If that is the case, please do the following, read the whole range starting from A3. Store it in a DataTable variable, retrieve the count of rows from here using ReadRowCount = datatablename.rowCount Then again use a read range activity: pass “A3:G”+ReadRowCount.toString. Thanks Happy Automation!

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 2 likes!

ExcelReadRange Activity, custom range

Hi @dbukk Are there some more columns after G, which you don’t wanna read? If that is the case, please do the following, read the whole range starting from A3. Store it in a DataTable variable, retrieve the count of rows from here using ReadRowCount = datatablename.rowCount Then again use a read range activity: pass “A3:G”+ReadRowCount.toString. Thanks Happy Automation!

This solution provided by @Harshith_Adyanthaya received 1 likes!

How to bypass captcha in website

Hi @sathish_Kumar6 , Try this chrome extension: Captcha Buster After installing this, you will get a new icon on the captcha screen. Clicking that captcha will be solved automatically using audio. [image] Hope it helps.

This solution provided by @arjunshenoy received 1 likes!

Regular expression not working but it works at Regex101

@Juan_Paz I just observed that the RegEx pattern that you are using to retain the numbers & remove that whitespaces is not actually working when the whitespace is present in the end of the data. [IMG_4320] If your sole purpose is to remove the whitespace, then I’d suggest you to go with the Trim function, like portapapeles2.ToString.Trim Or, if you are determined to achieve this via RegEx, please give the following pattern a try: \s*(\d+)\s* [IMG_4321] Hope this helps, Best 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 | 14 June 2023

Top 3 Topics with Most Views

💥 UiPath Community HyperHack 2023 is LIVE! Register Now! 💥 made by @diana.gray with 77 views.

Columns data to move another Columns in linq made by @Shyam_Pragash with 51 views.

Getting error when using python activities in uipath made by @Vivek_Sharma with 47 views.

Top 3 Topics with Most Replies

How to Assign: Now.toString = "01/05/2023" made by @wija with 22 replies.

UiPath Action Centre-Error made by @marina.dutta with 19 replies.

Bc30561: 'action' is ambiguous, imported from the namespaces or types 'system, microsoft.office.interop.outlook' made by @NewBiew with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 80 posts!

@Yoichi made 41 posts!

@raja.arslankhan made 32 posts!

Top 3 Most Liked Posts

This post made by @diana.gray received 11 likes!

UiPath Community HyperHack 2023 is LIVE! Register Now!

UiPath Community HyperHack 2023 is LIVE! Register Now! HyperHack 2023 is now LIVE! Are you a problem solver within your team or organization? Are you interested in creating effective, ground-breaking solutions with UiPath technology? Do you often think of innovative use cases for any business problem that you come across? The UiPath Community invites you to choose your challenge from one of two categories and contribute to bringing automation ideas to life by identi…

This post made by @ppr received 3 likes!

[InfoSet] - LegacyToWindows Migration # Information Index

About this [InfoSet] - LegacyToWindows Migration series The [InfoSet] series summarise a topic and offer information resources of different kinds. As the topic of Legacy-to-Windows migration is currently in focus, it was selected for the [InfoSet] series to provide further assistance. This information index is the landing page that lists all the different information resources. Blogs Tools & Guides Blueprint Block Topic Registration / Inventorisation / Prototyping Jump Start Guide …

This post made by @ppr received 2 likes!

[InfoSet] - LegacyToWindows Migration # Jump Start Guide

Introduction A migration project blueprint was presented here: [InfoSet] - LegacyToWindows Migration # Project Blueprint Overview and discussed why the Legacy-To-Windows migration is necessary and proposed a project blueprint for it. This blog contains a series of questions and a checklist for preparing a Legacy-To-Windows migration . Following the Legacy-To-Windows migration project blueprint, the building blocks from the beginning to the first prototype migration are addressed. How To use …

Top 3 Most Liked Solutions

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

Not able to view tenant feed while publishing project

Hi @sneha09871 Welcome to community There m8ght be missing permissions Check this link Happy Automation

This solution provided by @Anil_G received 2 likes!

Can't "PadLeft" for some reason

@Josh_James If you need first five then you need to do substring and not pad Str.Trim.SubString(0,5) Cheers

This solution provided by @Yoichi received 1 likes!

データテーブルの加工について

こんにちは 以下いかがでしょうか？ （事前に結果出力用のresultシートを作成しています） [image] dtResult = dt.AsEnumerable.GroupBy(Function(r) r("番号").ToString).Select(Function(g) dtResult.LoadDataRow({g.key}.Concat(g.Select(Function(r) r("英語").ToString)).ToArray,False)).CopyToDataTable NewBlankTask20230614-1.zip (56.8 KB)

---

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

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

[system]

Daily Forum Report | 18 June 2023

Top 3 Topics with Most Views

Revision help please made by @Latifa with 47 views.

How to solve this error: Write Range: 0x800A03EC? made by @Samraat_Maharjan1 with 44 views.

File Change Trigger V3 made by @tclukay with 38 views.

Top 3 Topics with Most Replies

How to solve this error: Write Range: 0x800A03EC? made by @Samraat_Maharjan1 with 27 replies.

Revision help please made by @Latifa with 15 replies.

Create percentage using LINQ query made by @coder with 11 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 39 posts!

@Anil_G made 33 posts!

@prateek.mehandiratta9 made 21 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 1 likes!

Getting Select Item Error

@170290064 Issue resolved. [image] Generate_Yearly_Report_2023_Performer (2).zip (1.0 MB) change Queue name and asset name in process and enjoy Ignore Failed Items in snip…it was due to testing

This post made by @170290064 received 1 likes!

Getting Select Item Error

Yes please, I know there is a simple mistake but i do not know where is it.

This post made by @tclukay received 1 likes!

File Change Trigger V3

What level of folder access is required in order for the File Change Trigger activity to work? I tried attaching a trigger to a folder I have read-only access to, and the trigger completely ignores any activity occurring in the folder. No error messages, just doesn’t detect anything. @UiPath or someone else, any thoughts on this?

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

I don't ́t have the Get IMAP activity in studiox Windows

Hi, Can you try to turn on Developer option at Filter in Activities panel as the following? [image] Regards,

This solution provided by @Yoichi received 1 likes!

Value does not fall within the expected range

Hi, I guess probably in_System1Url is null. Can you check Locals panel when error occurs in Debug run? If it’s null, can you check logic regarding passing argument? Or if you need to Run File or Debug File, please set some url value as defult value as the following? [image] Regards,

This solution provided by @BeiJing0305 received 1 likes!

Write Dataset to Excel with Table mixed with Field

Appreciate all the help. The new “For Each” is a bit counter-intuitive, however. Hope UiPath will “fix” this. I can’t be the only one who’s confused.

---

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.