Forum Engagement Daily Reports

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

[system]

Daily Forum Report | 19 June 2023

Top 3 Topics with Most Views

Regex patterns made by @Gayathri_Mk with 56 views.

Migrating Legacy Activities to Windows made by @Anuj_Tiwari with 55 views.

Get current job running made by @Yazan_Otaibi with 55 views.

Top 3 Topics with Most Replies

Dt1 made by @Pushpendra_kowthavarapu with 20 replies.

Issue in reading argument made by @RAKESH_KUMAR_Tiwari with 14 replies.

UiPath.Python.Activities Scope problem made by @KevinDS with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 58 posts!

@arjunshenoy made 19 posts!

@raja.arslankhan made 17 posts!

Top 3 Most Liked Posts

This post made by @Anuj_Tiwari received 3 likes!

Migrating Legacy Activities to Windows

Hi everyone, We conduct regular content reviews at UiPath Marketplace to uphold user experience and trust by ensuring the listings meet the necessary standards and provide value to users. As you might already be aware, legacy .NET Framework 4.6.1 is no longer supported by Microsoft, hence, we encourage all of you to finalize migrating your legacy activities to Windows and keep the content updated with latest product releases. This way you can ensure that the automations that you have developed…

This post made by @ppr received 2 likes!

Linq for fetching value from Datatable

Duplicate of:

This post made by @balaraj.pubalan received 2 likes!

Date & Time to C#

Its works [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Check if string only contains grades like A,A+,B,B+

we can use Regex isMatch method or isMatch Activity [grafik]

This solution provided by @Yoichi received 1 likes!

Date & Time to C#

Hi, In C#, as backslash is special character, it’s necessary to escape backslash or use @ as the following "C:\\Users\Documents\\DL_" OR @"C:\Users\Documents\DL_" In addition, / and : cannot be used as file name (or file path if you want to use it as part of directory name ). So as a result,the following will work, for example. @"C:\Users\Documents\DL_" +DateTime.Now.ToString("MMddyyyy-hhmm tt") Regards,

This solution provided by @Anil_G received 1 likes!

How to add node with data in JArray datatype?

@lovepong66 Follow the steps Convert the jarray to datatable using assign activity with dt = varJarray.ToObject(Of DataTable) Use add data column activity and add a new column Column3 Then populate the values …as I see all the 3 values are similar say if you want to add xxx only as value for all roes then use assign with dt.Columns("Column3").Expression = "'xxx'" Now you need to convert the datatable to jarray again using the same serialize and deserialize steps you used above in your code …

---

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

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

[system]

Daily Forum Report | 20 June 2023

Top 3 Topics with Most Views

Automaation challenge made by @RAKESH_KUMAR_Tiwari with 49 views.

Group by in list made by @rayz1503 with 45 views.

Table extraction pdf made by @devendra_bhardwaj2 with 44 views.

Top 3 Topics with Most Replies

Code for yesterday's date file download made by @Priyesh_Shetty1 with 24 replies.

Send Hotkey or Click activity is not working for save as the excel file on Data Access Studio application made by @sandhya.govindharam with 17 replies.

Create a csv file with UTF-8 Encoding (Without BOM) made by @christian.2a with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@arjunshenoy made 25 posts!

@raja.arslankhan made 20 posts!

Top 3 Most Liked Posts

This post made by @frederic-f.bonnet received 2 likes!

Problem to copy paste a cell under excel

Hi , it seems that copy/paster runs correct , in fact i probably discovered the cause in my code i open two times the file with pivot tables : to change D-D to D-1 in tables ( 1st open ) open website to recover the database D-D to update the database and update D-D tables ( 2nd open) and to refresh the data i use refresh button on excel . I decided to change , the process excel open excel and change D-D to D-1 open si the new database and update D-D tables open website to recover the da…

This post made by @Luis_Fernando received 2 likes!

UiPath Apps, Filter Function not Working

Thank you very much Dear friends @Anil_G @Arvind_Kumar1. This expression did solve my problem. Glad to count on y`all

This post made by @Anil_G received 2 likes!

Extraction Validation Action center (Document Understanding)

@Christodoulos The method that you are doing or ideating to do is the only way as of now…there is no other way to display only few fielda other than playing around eith your taxonomy Cheers

Top 3 Most Liked Solutions

This solution provided by @frederic-f.bonnet received 2 likes!

Problem to copy paste a cell under excel

Hi , it seems that copy/paster runs correct , in fact i probably discovered the cause in my code i open two times the file with pivot tables : to change D-D to D-1 in tables ( 1st open ) open website to recover the database D-D to update the database and update D-D tables ( 2nd open) and to refresh the data i use refresh button on excel . I decided to change , the process excel open excel and change D-D to D-1 open si the new database and update D-D tables open website to recover the da…

This solution provided by @ppr received 1 likes!

Main.xaml: BC30561: 'Action' is ambiguous, imported from the namespaces or types

it is more about the manual xaml editing, which you can try within an editor e.g. notepad++ Take a Backup before editing XAMLs or other files

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

Use Unique excel file for the same bot

@trentm Yes You can do it. “Your Folder Path”+UserNameVar+Now.ToString(“ddMMyyyy)+”.xlsx" Date is for to make more unique

---

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

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

[system]

Daily Forum Report | 21 June 2023

Top 3 Topics with Most Views

Filter Rows Based on Color made by @shreyash_shirbhate with 57 views.

How change the format in excel? made by @copy_writes with 55 views.

Regex extract date after specific word made by @Dave_White with 49 views.

Top 3 Topics with Most Replies

Filter Rows Based on Color made by @shreyash_shirbhate with 24 replies.

Downloading zip file and pdf file from website made by @Priyesh_Shetty1 with 24 replies.

Getting error in Queue adding made by @Learner007 with 23 replies.

Top 3 Users Who Posted The Most

@Anil_G made 72 posts!

@Yoichi made 32 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

How to merge bulk multiple pdf into single file

@Sakthi_Gokula_Kannan Please check this [UiPath - Merge multiple PDF files into One| PDF Automation| Practical demo to join pdf files] Cheers

This post made by @supriya117 received 2 likes!

Selector error while clicking a Button

Hi @Sahil_Garg1 Use SendWindowMessages as an input method. Regards,

This post made by @Irene received 2 likes!

For Each move files from folder tho another folder

Ah, you mean something like this? Directory.GetFiles("your_root_folder", "*", SearchOption.AllDirectories).Where(Function (f) f.Contains("\DLV03\") OrElse f.Contains("\E-INV\") OrElse f.Contains("\PL\")).ToList Then you do just one loop with the list you get from this operation.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

How to merge bulk multiple pdf into single file

@Sakthi_Gokula_Kannan Please check this [UiPath - Merge multiple PDF files into One| PDF Automation| Practical demo to join pdf files] Cheers

This solution provided by @Irene received 2 likes!

For Each move files from folder tho another folder

Ah, you mean something like this? Directory.GetFiles("your_root_folder", "*", SearchOption.AllDirectories).Where(Function (f) f.Contains("\DLV03\") OrElse f.Contains("\E-INV\") OrElse f.Contains("\PL\")).ToList Then you do just one loop with the list you get from this operation.

This solution provided by @mahmoud.zaky received 1 likes!

How to add multiple To id's in SMTP mail activity

Hi @Praveen_Vs Please check below solution and update us if you still face issue:

---

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

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

[system]

Daily Forum Report | 22 June 2023

Top 3 Topics with Most Views

How to process each transaction(datatable )in reframe work? made by @vnsatyasunil with 46 views.

Iterate through hundreds folder made by @Deepak_M with 45 views.

Append logic does not follow through - Write data table error / bug made by @jezaia.vanderwatt with 42 views.

Top 3 Topics with Most Replies

Downloading available name zip from Website made by @Priyesh_Shetty1 with 21 replies.

Iterate through hundreds folder made by @Deepak_M with 17 replies.

How to process each transaction(datatable )in reframe work? made by @vnsatyasunil with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@postwick made 31 posts!

@raja.arslankhan made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Cut long lines of numbers by 10

when it is not guaranteed that the string length is always a multiple of 10 then we can handle this felxible as done below: [grafik]

This post made by @Irene received 2 likes!

Best Approach for manipulation?

Fully agreed to what @raja.arslankhan posted. In addition, and only based on my personal experience, when working with files on shared drives there’s always a chance that the connection might drop even just for a moment, causing your process to fail. This can happen randomly, and sometimes it can be really tricky to manage. On the other hand, the same thing might happen when copying the files to a local folder. In both cases, error management is key, so make sure that your process is bullet proo…

This post made by @Yoichi received 1 likes!

Ocr text take much time to be executed

Hi, Can you try to set value at Timeout property such as 3000 etc? [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Irene received 1 likes!

Create HTML Content takes first row as header

It seems to be a known issue. Somebody proposed a workaround here, you can take a look: Post HTML email with datatable but doesn’t contain header - Help / Studio - UiPath Community Forum It basically creates a fake row as a first row, which will be skipped. Your header will be shifted to 2nd row and displayed as a header. Quite annoying, but it should work.

This solution provided by @Parvathy received 1 likes!

Deleting Extra Spaces in a String

Hi @Luis_Fernando Use the following below syntax: System.Text.RegularExpressions.Regex.Replace(cleanString, "\s+", " ") Note: Attached the workflow for reference Sequence11.xaml (7.9 KB) Hope it helps!! Regards,

This solution provided by @AkshaySandhu received 1 likes!

Replacing text, but I need to maintain the case

How about using below logic: dt_Mapping will look like below [image] For each row as DataRow in dt_Mapping.Rows str_Input = Regex.Replace(str_Input,"(?!\>[\w ]*)" & CurrentRow("Column1").ToString & "(?=[\w ]*\<)",CurrentRow("Column2").ToString) Next row Sample Input <li>Hello my favourite color is Red Color</li><li class="color"> Hello my favourite color is Red Color</li> Output <li>Hello my favourite colour is Red Color</li><li class="color"> Hello my favourite colour is Red Color</li>…

---

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.