Forum Engagement Daily Reports

[system]

Daily Forum Report | 28 September 2024

Top 3 Topics with Most Views

To monitor the time delay for each activity made by @domsmgtmeet22 with 16 views.

UiPath Certified Professional Automation Developer Associate - 2024 made by @maynardhalili443 with 14 views.

Date Logic made by @dutta.marina with 12 views.

Top 3 Topics with Most Replies

Type Into Activity Dynamic Index Set made by @NISHITHA with 9 replies.

To monitor the time delay for each activity made by @domsmgtmeet22 with 8 replies.

Convert CSV to Excel (.xlsx) made by @aranadya with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 7 posts!

@ashokkarale made 6 posts!

@Michael.Vornes made 5 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 4 likes!

Yoichi 5000th Solution Celebration

@postwick @Vamsi_Krishna_Gogineni @Divyanshu_Divyanshu @supermanPunch @Anjani_Kapoor @lrtetala @ShumpeiWatanabe Thank you all so much for your kind messages!

This post made by @Kancharla_Mahija received 3 likes!

Unlock the Future: #10 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint Day 10/10 I delved into two fascinating use cases: AI Center and DU. Usecase19-AICenter.zip (151.9 KB) usecase20-DU.zip (254.2 KB) I’m immensely thankful to the outstanding MVP experts for offering me this invaluable opportunity to expand my skills and knowledge Eagerly anticipating more growth and collaboration ahead! UiPath rpa automation #SemanticActivities #TableExtraction #Learning…

This post made by @Akash_Javalekar1 received 2 likes!

Unlock the Future: #10 Challenge from the 20 Use Cases Challenge Learning Sprint

Unlock the Future: 20 Use Cases Challenge Learning Sprint - Day 10 Completed! Successfully completed Day 10 of the 20 Use Cases Challenge! Sentiment Analysis Restaurant Review Leveraging AI to analyze and categorize sentiments was truly fascinating. The AI Center’s capabilities made it easy to perform analysis on text data, providing insights without the need for custom training. Document Understanding with the Invoice ML Model: This challenge showed the pow…

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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

Top 3 Topics with Most Views

Press down button made by @Mohamed_Amer with 12 views.

Row("Date")とitemの値を比較して同じ場合はThenに処理を渡す構文 made by @gorby with 11 views.

How to copy column data from 1st excel to specific column in diffrerent excel using LINQ made by @Syed_Sultan_Ahmed1 with 11 views.

Top 3 Topics with Most Replies

How to copy column data from 1st excel to specific column in diffrerent excel using LINQ made by @Syed_Sultan_Ahmed1 with 7 replies.

Get OCR Text: Invalid API Key specified made by @Simion_Ursache with 5 replies.

No Option of Robot when i Assign role to user made by @Ejaz_Ab with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@aranadya made 9 posts!

@sudster made 9 posts!

Top 3 Most Liked Posts

This post made by @chethan.dinnupati received 1 likes!

Unlock the Future: #10 Challenge from the 20 Use Cases Challenge Learning Sprint

Hi Community, Thanks @loredana_ifrim @AutomationX_by_Kiran @pradeep_ch @pathrudu for great sessions. Use Case - 19 Solution RestaurantSentimentalAnalysis.xaml (13.3 KB Use Case - 20 Solution InvoiceExtractionProcess.xaml (56.8 KB)

This post made by @aranadya received 1 likes!

Convert CSV to Excel (.xlsx)

Hello Sir, i just change my assign destinationPathhh = “C:\Users\azzah\OneDrive\Documents\UiPath\attatchment\ClientData-” + Now.ToString(“yyyy-MM-dd”) + “.xlsx” and write to Workbook, it works but the header not included, i already try to checklist header, but when copy to excel there’s no header. Do you have any idea ? Thankyou

This post made by @Anil_G received 1 likes!

dtの("TimeSpan")平均値を計算して、他のdtに出力したい

@gorby First build a datatable with teo columns and both of string type and it is dt4 Dt4 = Dt3.AsEnumerable.GroupBy(function(x) x(0).ToString).Select(function(x) dt4.LoadDataRow({x.Key,If(x.Where(function(y) y(4).ToString.Equals("0")).Count>0, Timespan.FromSeconds(x.Where(function(y) y(4).ToString.Equals("0")).Average(function(y) Timespan.Parse(y(3).TOstring).ToTalSeconds)),"00:00:00")},False)).CopyToDataTable Cheers

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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

Top 3 Topics with Most Views

How would you improve ReFramework? made by @bp777 with 23 views.

How find running hours? made by @domsmgtmeet22 with 22 views.

THIS IS HOW TO GET IN ONE ARRAY BY CODE THE ITEMS WITHOUT EMPTY OR CONTAINS ANY SPACE made by @Jesus_Fonseca with 21 views.

Top 3 Topics with Most Replies

How would you improve ReFramework? made by @bp777 with 17 replies.

When i log in (ACME) not logged but no error occur made by @Ejaz_Ab with 16 replies.

To get Date from Month made by @Gokul_Murali with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@ashokkarale made 23 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @Makiko_Tsuda received 2 likes!

日本語版 特化型 AI プロフェッショナル資格認定試験のご紹介

2024年月10 日15日、日本語版の特化型 AI プロフェッショナル資格認定試験 (UiPath-SAIv1_JPN) がリリースされます。この試験は2024年 6月に配信開始された英語版の Specialized AI Professional Exam (2023.10) の日本語版です。 特化型 AIプロフェッショナル認定資格は、UiPath Document Understanding 、Communication Mining™ 、AI Center に関する深い理解と広範な実務経験を評価します。AI を取り入れ、非構造化ドキュメントの理解やコミュニケーション データの処理に対応したオートメーション開発に携わる方を対象としています。 特化型 AIプロフェッショナル認定には次のUiPath認定資格の中から最低ひとつの有効な資格をすでに有していることが必須条件です。 特化型 AI アソシエイト オートメーション デベロッパー アソシエイト オートメーション デベロッパー プロフェッショナル RPA アソシエイト (UiRPA) RPA デベロッパー上級 (UiARD…

This post made by @ashokkarale received 2 likes!

How to change modern and classic design seeting in updated version of uipath 2024.10.1

Hi @shraddha_koli2, Welcome to the UiPath Community! As the classic design has been retired to can’t switch to it stait away. You will have try modifying the project.json of the project. Try this approach. Thanks, Ashok

This post made by @Anil_G received 1 likes!

Why arguments get reflected in main flow?

@Sanket_Shinde1 looks like the out arguments are declared in inputexcel.xaml instead of process xaml can you please check the same cheers

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

How to change modern and classic design seeting in updated version of uipath 2024.10.1

Hi @shraddha_koli2, Welcome to the UiPath Community! As the classic design has been retired to can’t switch to it stait away. You will have try modifying the project.json of the project. Try this approach. Thanks, Ashok

This solution provided by @ashokkarale received 1 likes!

DataTable Not Extracting Properly

Ok then use mouse scroll and data extraction in a loop like while loop. For every iteration check if the last row is same as previous extraction data. If it’s same even after scrolling, it’s the real last row else continue scrolling and extracting data.

This solution provided by @Anil_G received 1 likes!

Why arguments get reflected in main flow?

@Sanket_Shinde1 then declare in argument in process and link the variable from inputexcel which is to be passed cheers

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

@Anil_G received 31 likes for their solutions!

@ashokkarale received 28 likes for their solutions!

@lrtetala received 19 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 October 2024

Top 3 Topics with Most Views

Very poor exception handling made by @pere with 21 views.

Read PDF and Extract Text to Excel using Regex made by @cclemon with 20 views.

Building RegEx for different types of Company names made by @Komom with 19 views.

Top 3 Topics with Most Replies

I cannot see my uploaded Processes in Orchestator. I am also unnable to create new folders in Tenant made by @mateo.lardiez with 20 replies.

Create copy of datarow in new datatable made by @SorenB with 11 replies.

When i run the process the start button is disable? made by @Ejaz_Ab with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@sudster made 18 posts!

@ashokkarale made 12 posts!

Top 3 Most Liked Posts

This post made by @KalyanM received 2 likes!

Join AI Associate Developer Series 2024!

Exited for the series😀

This post made by @lakshmi.mp received 2 likes!

Read PDF and Extract Text to Excel using Regex

Hi @cclemon , Refer this link you’ll get some idea. [UiPath PDF Extraction | How to EXTRACT data from invoice PDF using ReGex in UiPath? - Use Case]

This post made by @Yoichi received 1 likes!

Split date left rigt problem studiox

Hi, There are several ways to achieve it. How about using SplitText activity as the following? [image] Main.xaml (8.7 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @lakshmi.mp received 2 likes!

Read PDF and Extract Text to Excel using Regex

Hi @cclemon , Refer this link you’ll get some idea. [UiPath PDF Extraction | How to EXTRACT data from invoice PDF using ReGex in UiPath? - Use Case]

This solution provided by @ashokkarale received 1 likes!

Extracting Characters

@Latifa, Correct answer is B. ExtractedText.Trim.Length Explanation: Trim removes the leading and trailing spaces from String Length gives the number of characters You can try this in Studio. Thanks, Ashok

This solution provided by @Anil_G received 1 likes!

Copy Range

@A_Learner Since the data is more it is taking time Try to do in batches so that it might be quick 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 | 02 October 2024

Top 3 Topics with Most Views

American Dates in Orchestrator made by @g.ward with 16 views.

How to get the Run count every day of the bot made by @hansen_Lobo with 15 views.

Issue with API Automation made by @devasaiprasad_K with 13 views.

Top 3 Topics with Most Replies

HTTP request error: JSON content missing or malformed made by @Povilas_Jonikas with 11 replies.

How to filter a column containing date where we have to filter days before 6 months older dates made by @Gopi_Krishna1 with 9 replies.

StudioX freezing on any project made by @Mircea_Urda with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@ashokkarale made 10 posts!

@Quan.Mai made 10 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Issue with Clearing Date/Time Component in UiPath Forms via Button Click

@power the only change is using ‘’ instead of null form.getComponent('frist').setValue(''); Also in custom code just the above line is enough [The image shows a highlighted custom action being configured in a form, with specific button logic to set the value of the component 'mytime' to an empty string. (Captioned by AI)] Hope this helps cheers

This post made by @ashokkarale received 2 likes!

Monthly Forum Rewards - September 2024

Congratulations everyone

This post made by @jast1631 received 2 likes!

Monthly Forum Rewards - September 2024

Thank you for your kind words! Congratulations to all winners! Happy Automation!!!

Top 3 Most Liked Solutions

This solution provided by @power received 2 likes!

Issue with Clearing Date/Time Component in UiPath Forms via Button Click

Thank you for the suggestion! You were absolutely right — the key to solving this issue was using '' instead of null to clear the Date/Time field. The final solution was as simple as this: I added this line in the Display/Update Data Logic section, and it worked perfectly. [The image shows a configuration screen for a button component with various settings and a preview of a blue button labeled "Frist Entfernen" which has a typo. (Captioned by AI)] Additionally, I realized that my issue ma…

This solution provided by @Yoichi received 1 likes!

ロボットの動作を途中で正常終了させる方法について

こんにちは シーケンスのみで組んでいるのであれば、一つ一つのワークフローファイル単位で抜けていくのが基本かと思います。（そうしないと保守性が担保できなくなるように思えます） ビジネスロジック上このようなルートが避けられないのであれば、フローチャートやステートマシン等を使った方が良いかもしれません。

This solution provided by @parvathi_ayanala received 1 likes!

UiPath GenAI_Rewrite Activity Error

Hi @Anil_G , Thank you for response. Will try and let you know

---

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

Top 3 Topics with Most Views

Extract PDF Page Range by Regex in a Folder made by @cclemon with 21 views.

Value of type String() cannot be converted to string made by @kavitha_chavala with 21 views.

How to Scrap URL that assigned to a variable made by @reyhandwip with 21 views.

Top 3 Topics with Most Replies

How to Scrap URL that assigned to a variable made by @reyhandwip with 19 replies.

Rewrite Expression to Handle the error related to Date Column in Data table made by @Sisay_Dinku with 18 replies.

Value of type String() cannot be converted to string made by @kavitha_chavala with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@Yoichi made 21 posts!

@Akash_Javalekar1 made 14 posts!

Top 3 Most Liked Posts

This post made by @KalyanM received 2 likes!

Migrate all selectors from chrome to diff browser

@Swaroop with recent update in activities. U can use set run time of browser which u can select any browser Default Chromee ie Firfox So no need for any migratiiin tool simply keep as asset in orch and change the browsers by changing the values. [IMG-20241003-WA0001]

This post made by @Yoichi received 2 likes!

RPAを使用してGmailからメールを送信したい

基本的にはGmailを使用アクティビティとメール送信アクティビティを使います。 うまく動かないでしょうか？問題点があるようでしたら具体的内容を共有いただくと良いかと思います。

This post made by @mdiv received 2 likes!

How to replace text in Workflow template

Thank you @ijanszen1, @postwick, @ashokkarale, @Jon_Smith for your replies. By using @ijanszen1s reply in the thread posted by Jon_Smith, I actually got a oneliner to put into my Log Message. It is in vb.net, but if anyone is looking for the same solution here it is: BlockquoteSystem.Text.RegularExpressions.Regex.Match(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.AssemblyQualifiedName,“.(.*?)_Expressions”).Groups(1).Value + " start" I have moved the code to a variable set i…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

How to add Defects into jira from test manager

@Nisha_K21 Please check this video it has details on how to create [UiPath Test Suite Session -1 || Integrate JIRA with Test Manager] Credits to @pathrudu cheers

This solution provided by @Yoichi received 1 likes!

読み込んだDataTableの文言と同じものを探して対象データを抽出したい

以下の式で可能と思います。 dict = dt2.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("氏名").ToString,r("氏名カナ").ToString,r("誕生日").ToString)).Where(Function(g) g.Count=1).ToDictionary(Function(g) g.Key,Function(g) g.First().Item("背番号").ToString)

This solution provided by @Supriya_Allada received 1 likes!

Using Regex to replace texts in string

Hi @Komom Try this: res = System.Text.RegularExpressions.Regex.Replace(extractedText, "[^\w\s]|\[REDACTED\]", "")

---

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

Top 3 Topics with Most Views

Need help in formatting mail body,Can anyone help me please made by @Chandini_Roy with 27 views.

Unable to Connect MySQL with UIPath made by @anand.t with 24 views.

Take the snapshot from any application and paste it in excel file made by @Riya1 with 21 views.

Top 3 Topics with Most Replies

Move Mail: Value cannot be null made by @adriano.dias with 15 replies.

Unable to Connect MySQL with UIPath made by @anand.t with 13 replies.

Write a value to junction point of row and column made by @Affan_Basar with 10 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 20 posts!

@Yoichi made 15 posts!

@Anil_G made 10 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 7 likes!

Announcing the Winners of the 20 Use Case Learning Sprint Challenge!

Wonderful initiative @pradeep_ch , @pathrudu @AutomationX_by_Kiran @loredana_ifrim & @Ana_Bulhac. Congratulations winners and everyone tried their best

This post made by @pradeep_ch received 6 likes!

Announcing the Winners of the 20 Use Case Learning Sprint Challenge!

Thanks…! @loredana_ifrim for the support throughout the series

This post made by @AutomationX_by_Kiran received 6 likes!

Announcing the Winners of the 20 Use Case Learning Sprint Challenge!

Congratulations to all the winners. Thanks for the support all the way @loredana_ifrim , @Ana_Bulhac

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Download sharepoint folder - How?

@Meu_Eu_Nando First thing you can ot download a folder directly Now what you can do is use for each file activity If you are not using integration services then can go with find files and give only subfolder details and leave wuery emtpy so that all files from the given folder are retrieved can use for loop and download inside As per error you tried downloaded folder and not file Cheers

This solution provided by @Yoichi received 1 likes!

Hi I'm Planniing to learn about test automation and become TAE

I guess it’s because UiPath has feature of Coded Test Case which we can write test case using C#. The following document may also help you.

This solution provided by @Akash_Javalekar1 received 1 likes!

Go back to the previous version of the project in Orchestrator

Hi @amanda.gondim please find below screen you can go to the process click on edit you would find option roll back it will get the previous version of your project. let me know if you need any help Hope this will help you Happy Automation! [The image shows a Process Configuration screen in UiPath Orchestrator where a package version is selected, with a displayed warning about UiPath.System.Activities version requirements. (Captioned by AI)]

---

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

Top 3 Topics with Most Views

Extracting Email from an ID proof using taxonomy made by @Parth_Sarnobat with 16 views.

Adding Datacolumn to existing Datatable and updating values in newly added Data column made by @Bharath_Kumar3 with 15 views.

Query to concat values from two columns in datatable made by @hemasai.06 with 14 views.

Top 3 Topics with Most Replies

Unable to open UI path studio made by @CodeRays_Info with 13 replies.

Extracting Email from an ID proof using taxonomy made by @Parth_Sarnobat with 8 replies.

Captch in UiPath made by @Shravan_Pintu with 7 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 13 posts!

@sudster made 11 posts!

@isabel_kim made 10 posts!

Top 3 Most Liked Posts

This post made by @esongi_park received 2 likes!

Announcing the Winners of the 20 Use Case Learning Sprint Challenge!

Due to my lack of skills, I haven’t solved any of the challenges yet, but I’m looking forward to trying them all. Thank you to the instructors for a great course, and congratulations to the winners and everyone who participated!

This post made by @ashokkarale received 1 likes!

HTTP Request 400 error

@Santhosh_Perumal, Remove the q from endpoint URL as you are already passing as parameter. [A screenshot of an HTTP Request Wizard is shown, with configurations for an API call to OpenWeatherMap's weather endpoint, including parameters for "q" (query) and "appid" (application ID). (Captioned by AI)]

This post made by @Bharath_Kumar3 received 1 likes!

While and For each Row

Thank you @ashokkarale @Anil_G It was resolved. Changed the code to use while condition within for each activity. It worked!!

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

HTTP Request 400 error

@Santhosh_Perumal, Remove the q from endpoint URL as you are already passing as parameter. [A screenshot of an HTTP Request Wizard is shown, with configurations for an API call to OpenWeatherMap's weather endpoint, including parameters for "q" (query) and "appid" (application ID). (Captioned by AI)]

---

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

Top 3 Topics with Most Views

How to convert FileInfo type to IResource type made by @KezayAlperen with 13 views.

Pass the Parameter / Variable in Http Request Body made by @Naresh_Upadhyay with 13 views.

Compare two Columns in Datatable Using Linq made by @Manii_K with 12 views.

Top 3 Topics with Most Replies

Compare two excell sheet made by @Samsuj_Joha with 17 replies.

How to bulk of data into data table made by @suraj_gaikwad with 14 replies.

How to convert FileInfo type to IResource type made by @KezayAlperen with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@sudster made 8 posts!

@suraj_gaikwad made 7 posts!

Top 3 Most Liked Posts

This post made by @jitendra.saroj received 1 likes!

Announcing the Winners of the 20 Use Case Learning Sprint Challenge!

Thrilled to be among the winners!, massive thank you to @loredana_ifrim @pradeep_ch @AutomationX_by_Kiran @pathrudu @deepak.rai6 and @Hyperautomation-ai for organizing and leading the sessions with such enthusiasm and dedication. Your guidance has truly been invaluable throughout this sprint!

This post made by @rashmisingh2695 received 1 likes!

Compare two Columns in Datatable Using Linq

Hi @Manii_K, You can use linq or invoke code to acheive this. Sharing the workflow with invoke code. Please try and let me know if it works. Code.txt (1.9 KB) Main.xaml (23.2 KB) [The image shows a UiPath workflow with activities and output panels, displaying a data table comparison result based on partial matching of numerical identifiers. (Captioned by AI)]

This post made by @KezayAlperen received 1 likes!

How to convert FileInfo type to IResource type

I tested it and it works! Thank you very much @Akash_Javalekar1 :)) Happy Automation

Top 3 Most Liked Solutions

This solution provided by @Akash_Javalekar1 received 1 likes!

How to convert FileInfo type to IResource type

What is txtFile varaible type? try this one LocalResource.FromPath(txtFile.ToString)

---

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

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

[system]

Daily Forum Report | 07 October 2024

Top 3 Topics with Most Views

Sorting datatable according to multiple columns made by @arun.v7 with 32 views.

Element Exists is not working in unattended mode made by @Mahesh_Bandi1 with 27 views.

"Import arguments" button for Workflow activity doesn't work anymore made by @pere with 22 views.

Top 3 Topics with Most Replies

Sorting datatable according to multiple columns made by @arun.v7 with 26 replies.

Need help with UiPath robot to process emails with attachments made by @Soudios with 24 replies.

Get Orchestrator Asset does not work with assets of type Credentials made by @Vijaylakshmi_2 with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 32 posts!

@Akash_Javalekar1 made 25 posts!

@Soudios made 18 posts!

Top 3 Most Liked Posts

This post made by @Aditi_Indoriya received 3 likes!

Announcing the Winners of the 20 Use Case Learning Sprint Challenge!

Congratulations to all the winners !

This post made by @Bogdan_Sultana received 2 likes!

UIAutomation Semantic Activities Deep Dive Oct, 31st

Hello, UiPath Community! Curious to explore how simple and flexible automating form-filling really is? I am @Bogdan_Sultana, Sr. Product Manager @UiPath, and for this Dev Dives session I will present a live demo focusing on the magic combination of simplicity & resiliency behind the UIAutomation Semantic Activities. I’ll walk you through the key components such as the DOM Extractor, the Semantic Matching, and the Semantic Execution engine. Join me on 2024-10-31T15:00:00Z (UTC) and le…

This post made by @josheph772 received 1 likes!

Monthly Forum Rewards - September 2024

I’m glad you made the modifications. If you need any more help or have questions, just let me know!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How to get Output Data values from orchestrator queue?

@Guru_Koli21 After you do get queue items Say output is listqueue variable then Listqueue(0).Output("KeyVLueInOutput").ToString will giv ethe respective output value Cheers

This solution provided by @Anil_G received 1 likes!

Question for UiPath backlog - Orchestrator API Connector?

@Matt67 Agreed …but connectors are made based on demand and as api calls are already present the only thing you would need to do as part of custom connector is to import the swagger so that the connector is ready Cheers

This solution provided by @Anjani_Kapoor received 1 likes!

How to get filepath based on specific keyword

Hi @Raja.G , You may try the following solution: Step1: use “Excel application scope” activity to read the excel file and drag “Get workbook Sheets”. it will store all the sheets in a list of strings. Step2: For each loop, Directory.GetFiles(“FolderPath”) Step3: in the same container, use an if activity with the condition: mySheets.Any(function(f) file.Contains(f)) [This image depicts a flowchart in UiPath Studio, illustrating the process of opening an Excel file, retrieving its sheets, a…

---

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

Top 3 Topics with Most Views

Need help to creating the robot for below scenario made by @satish_nangedda with 23 views.

Multiple extensions for for each file activity made by @shivappa.katti1 with 21 views.

Download file from URL:Don't know about such a host made by @Brian.Lee with 20 views.

Top 3 Topics with Most Replies

Sort Data Table not working made by @hp321 with 17 replies.

Multiple extensions for for each file activity made by @shivappa.katti1 with 12 replies.

Download file from URL:Don't know about such a host made by @Brian.Lee with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 32 posts!

@rashmisingh2695 made 18 posts!

@Soudios made 15 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Need help to creating the robot for below scenario

@satish_nangedda If you indicate radio button then it would loop on through it Instead indicate row and then use find children inside to get the radio button If you indicate row you xan get any column value as you need using colindex Cheers

This post made by @ijanszen1 received 2 likes!

How to replce value in text file of json

Hi Mathkar, Serialize the text as json object with Activities - Deserialize JSON. It’s a lot easier to manipulate json like that. When you have a JObject you could do something like an assign: yourJsonObject("attributes")("workAttributeId") = that + 1 (My syntax is probably wrong here, but you will figure it out ) Afterwards you can print the object again as string or do whatever else you needed to do with it.

This post made by @rashmisingh2695 received 2 likes!

Extarct value from json

Hi @Mathkar_kunal Please try to use deserialize json activity and extract values from Response like below JSONResponse(“attributes”)(“WorkLocation”)(“workAttributeId”).ToString JSONResponse(“attributes”)(“TypeofHour”)(“workAttributeId”).tostring JSONResponse(“attributes”)(“HourType”)(“workAttributeId”).tostring [This image shows a "Deserialize JSON" activity in a workflow, with "strJSON" as the input and "JSONResponse" as the output variable. (Captioned by AI)] [The image shows a code sni…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

画像をトリミングすると赤枠が付きカットできない

こんにちは トリミングしたいだけならSimpleCropメソッドをお試しください。 img.SimpleCrop(New UiPath.Core.Region(New RectAngle(190, 0, 420, 420)))

This solution provided by @Anil_G received 2 likes!

Swagger API error question

@A_Learner First open a browser and login to orcheatrator Then open the swagger first click on autherization green color icon on top right…then if already loggedin click on logout and then login…no need to fill anything…if not directly click login/authorize and again no need to fill anything Now try any api in swagger and it would work Cheers

This solution provided by @Anil_G received 1 likes!

Extarct value from json

@Mathkar_kunal use deserialize json and get the output into a variable say jobj then loc id - jobj("attributes")("WorkLocation")("workAttributeId").ToString type id - jobj("attributes")("TypeofHour")("workAttributeId").tostring Hour id - jobj("attributes")(" HourType")("workAttributeId").tostring

---

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

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

[system]

Daily Forum Report | 09 October 2024

Top 3 Topics with Most Views

I need duration - time taken = delay seconds made by @domsmgtmeet22 with 23 views.

SAP WinGUI 800 Auto-scroll issue in SE16N made by @Stefan_Reutter with 15 views.

Add Data Row Data format changing made by @Gokul_Murali with 15 views.

Top 3 Topics with Most Replies

How to install BouncyCastle for 2 step authen? made by @Alex_Ng with 9 replies.

How to connect Mongo DB with Uipath? made by @Marc_Font with 9 replies.

How to replace empty value with respective of upper row value in datatable made by @Nisha_K21 with 8 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 34 posts!

@Anil_G made 14 posts!

@Soudios made 9 posts!

Top 3 Most Liked Posts

This post made by @deepak.rai6 received 2 likes!

Announcing the Winners of the 20 Use Case Learning Sprint Challenge!

Congratulation to all the winners

This post made by @Manisha_Ravindra received 1 likes!

How to replace empty value with respective of upper row value in datatable

Hi @Nisha_K21 Use this code in invoke code activity: datatable as dtInput For i As Integer = 1 To dtInput.Rows.Count - 1 For j As Integer = 0 To dtInput.Columns.Count - 1 If String.IsNullOrEmpty(dtInput.Rows(i)(j).ToString()) Then dtInput.Rows(i)(j) = dtInput.Rows(i - 1)(j) End If Next Next

This post made by @Alex_Ng received 1 likes!

How to install BouncyCastle for 2 step authen?

Thanks for your explanation! Highly appreciated!! I am working on a automation which required 2 FA to login to a website so I need to get google token which order to access into the website.

Top 3 Most Liked Solutions

This solution provided by @Manisha_Ravindra received 1 likes!

How to replace empty value with respective of upper row value in datatable

Hi @Nisha_K21 Use this code in invoke code activity: datatable as dtInput For i As Integer = 1 To dtInput.Rows.Count - 1 For j As Integer = 0 To dtInput.Columns.Count - 1 If String.IsNullOrEmpty(dtInput.Rows(i)(j).ToString()) Then dtInput.Rows(i)(j) = dtInput.Rows(i - 1)(j) End If Next Next

This solution provided by @SorenB received 1 likes!

How to replce value in text file of json

Hello @Mathkar_kunal You can loop the jTokens (“workAttributeId”) in a For Each activity by using JSON filter expressions to grab the required tokens and modify them. For each jobj_JsonObject.SelectTokens("..[?(@.workAttributeId)]") Assign currentJToken("workAttributeId") = CInt(currentJToken("workAttributeId"))+1 Example attached: Increment number in json.xaml (12.8 KB) jsonfile.json (1.5 KB) Regards Soren

This solution provided by @PVSneha_Nair received 1 likes!

The screen displays a blank page after logging into the Prime Orchestrator URL

yes , not sure why, but the issue resolved automatically. By Monday, I was able to login.

---

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

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

[system]

Daily Forum Report | 10 October 2024

Top 3 Topics with Most Views

Issue with Get Transaction Item made by @Maxime_LAUGIER with 19 views.

https://forum.uipath.com/t/772606 made by @domsmgtmeet22 with 18 views.

Unable to connect new Robot machine to Orchestrator made by @Frincu_Ionut with 17 views.

Top 3 Topics with Most Replies

Need to get amount from a sentence made by @sruthesanju with 10 replies.

Regex for Mail Address made by @VanjaV with 7 replies.

Uipath_error made by @aysedemir with 7 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 12 posts!

@Anil_G made 10 posts!

@Kismet_Tosun made 8 posts!

Top 3 Most Liked Posts

This post made by @Suvera received 2 likes!

Become a 2025 UiPath Community MVP – Apply Now

Thanks Vibhor. We will utilize this time…

This post made by @Jon_Smith received 2 likes!

Become a 2025 UiPath Community MVP – Apply Now

Wooo! Lets make 2025 an even better year!

This post made by @ppr received 2 likes!

Windows - Legacy Refactor

find a landing page for this topic here:

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

SharePoint Get List Item Filter With Special Characters

@sarikayaebru Also give a try at: [grafik]

This solution provided by @Akash_Javalekar1 received 1 likes!

How to remove the row with specified column value

Hi @jamuna_T Please find attached workflow let me know if its working it will ignore the empty row as per your requirement RemoveEmptyrows.zip (2.6 KB) [The image shows a screenshot of UiPath Studio with a workflow to remove empty rows from a data table, including activities and variables panels. (Captioned by AI)]

This solution provided by @Anil_G received 1 likes!

Need to have trigger, if a email is recieved on outlook

@Soudios If you need without orchestrator then can use local triggers options 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 | 11 October 2024

Top 3 Topics with Most Views

How to get E212 and E214 value from regex made by @shaik.muktharvalli1 with 30 views.

Read captcha? made by @fairymemay with 19 views.

Identify Extracted Data Based On Excel File made by @NISHITHA with 18 views.

Top 3 Topics with Most Replies

How to get E212 and E214 value from regex made by @shaik.muktharvalli1 with 22 replies.

How to group a datatable and convert table style? made by @rockchord with 10 replies.

I am getting an error “The source contains no Datarows” made by @shaik.muktharvalli1 with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 24 posts!

@shaik.muktharvalli1 made 15 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 2 likes!

Cannot send input to ui element because it is outside of screen bounds - Click Activity

@Rup_1, May the screen resolution issue. Use Mouse Scroll activity to scroll to the Ui Element. This should resolve this issue. Thanks, Ashok

This post made by @johnom1 received 1 likes!

SET TEXT Function in Studio X

Thanks, got this resolved. The solution was to “Simulate” the Type Into activity instead of using the default “Same as App/Browser” option

This post made by @Kismet_Tosun received 1 likes!

Become a 2025 UiPath Community MVP – Apply Now

I’ve applied for the first time and I’m waiting with excitement

Top 3 Most Liked Solutions

This solution provided by @sudster received 1 likes!

Attach dynamic file in the folder in send email (Gmail) activity

Refer this:

This solution provided by @Anil_G received 1 likes!

How to change column value based another column value

@Raja.G Read the data into datatable Then use invoke code by passing dt as io argument Dt.AsEnumerable.Where(function(x) Cdbl(x("yy").ToString.Trim)<0).ToList.ForEach(sub(r) r("vv") = "Yes") After this use write range and write the datatable back Cheers

This solution provided by @KalyanM received 1 likes!

Need help with decimals

Hi @Barkha_Thakkar , Use activity format value from studio [IMG-20241011-WA0000]

---

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

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

[system]

Daily Forum Report | 12 October 2024

Top 3 Topics with Most Views

Compare two Datatables(LINQ) made by @rockchord with 21 views.

Automation suggestion using string values made by @Ajith3 with 11 views.

繰り返し(データテーブルかExcelのどちらでも)で画面上をクリックする made by @toshiki_kubo with 10 views.

Top 3 Topics with Most Replies

Compare two Datatables(LINQ) made by @rockchord with 14 replies.

Automation suggestion using string values made by @Ajith3 with 11 replies.

Find Specific File in the Directory and Return The File Name in the Email made by @nirmit.kansagra with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 10 posts!

@rockchord made 8 posts!

@sudster made 8 posts!

Top 3 Most Liked Posts

This post made by @rashmisingh2695 received 1 likes!

Compare two Datatables(LINQ)

Try to use this expression in Invoke code For Each row1 As DataRow In dtInput1.Rows Dim row2 As DataRow = dtInput2.AsEnumerable().Where(Function(r) r("Company").ToString() = row1("Company").ToString()).FirstOrDefault() If row2 IsNot Nothing Then Dim errors As New List(Of String) If row1("Company").ToString() <> row2("Company").ToString() Then errors.Add("Company") If row1("Code").ToString() <> row2("Code").ToString() Then errors.Add("Code"…

This post made by @nirmit.kansagra received 1 likes!

Find Specific File in the Directory and Return The File Name in the Email

Thank you so much this. How do I send an email if my file is not found? I want to send email for both cases if found or if not found. I got the email to be sent with the file name if file is found, but don’t know how to send email if not found.

This post made by @rashmisingh2695 received 1 likes!

Compare two Datatables(LINQ)

Hi @rockchord Please try to use this code in invoke code activity and you should be able to get the output First build the OutputDT with required columns and then use the invoke code For Each row1 As DataRow In dtInput1.Rows Dim row2 As DataRow = dtInput2.AsEnumerable().Where(Function(r) r("ID").ToString() = row1("ID").ToString()).FirstOrDefault() If row2 IsNot Nothing Then Dim errors As New List(Of String) If row1("Company").ToString() <> row2("Com…

Top 3 Most Liked Solutions

This solution provided by @rashmisingh2695 received 1 likes!

Compare two Datatables(LINQ)

Try to use this expression in Invoke code For Each row1 As DataRow In dtInput1.Rows Dim row2 As DataRow = dtInput2.AsEnumerable().Where(Function(r) r("Company").ToString() = row1("Company").ToString()).FirstOrDefault() If row2 IsNot Nothing Then Dim errors As New List(Of String) If row1("Company").ToString() <> row2("Company").ToString() Then errors.Add("Company") If row1("Code").ToString() <> row2("Code").ToString() Then errors.Add("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 | 13 October 2024

Top 3 Topics with Most Views

How to take the next column value when the current column Process? made by @jamuna_T with 16 views.

How to avoid blank cell in Pivot table made by @Raja.G with 14 views.

Attachments not getting download made by @Hemant_Deshmukh with 11 views.

Top 3 Topics with Most Replies

Read Range Workbook: The process cannot access the file 'D:\RPA DEVEloper\make doc excel.xlsx' because it is being used by another process made by @Ejaz_Ab with 12 replies.

Unable to create new Unattended machine in the latest orchestrator made by @kumarsathishchandolu with 10 replies.

How to take the next column value when the current column Process? made by @jamuna_T with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 16 posts!

@Akash_Javalekar1 made 13 posts!

@sudster made 6 posts!

Top 3 Most Liked Posts

This post made by @AJ_Ask received 1 likes!

Mastering UiPath GenAI Activities: AI Units, Signature Similarity, Sentiment Analysis & More

In this video, we dive into UiPath’s GenAI activities, showcasing how to track AI Units consumption and set up a connection for GenAI activities. We cover a range of activities, including Signature Similarity, Sentiment Analysis, Object Detection, Image Analysis, Email Generation, Categorization, Content Generation, and Language Detection. This step-by-step guide is perfect for both beginners and experienced users, helping you harness the power of UiPath GenAI to enhance your automation workflow…

This post made by @Akash_Javalekar1 received 1 likes!

How to take the next column value when the current column Process?

Hi @jamuna_T Please find attached workflow to get next column date value while processing previous which will subtract day 1 from each column Let me know if it’s working DateSubstract.zip (48.6 KB) [The image shows a software output window listing a series of date values in the format "CurrentDate Value" followed by the date, and "Next Column date" followed by another date, covering dates from December 2023 to March 2024. (Captioned by AI)]

This post made by @Akash_Javalekar1 received 1 likes!

How to merge two datatable with different headers & Range

Hi @jamuna_T Please find my attached solution and let me know if it’s working JoinDatatable.zip (113.8 KB) Please mark as solution if its working! Thanks Akash Javalekar

Top 3 Most Liked Solutions

This solution provided by @Akash_Javalekar1 received 1 likes!

How to take the next column value when the current column Process?

Hi @jamuna_T Please find attached workflow to get next column date value while processing previous which will subtract day 1 from each column Let me know if it’s working DateSubstract.zip (48.6 KB) [The image shows a software output window listing a series of date values in the format "CurrentDate Value" followed by the date, and "Next Column date" followed by another date, covering dates from December 2023 to March 2024. (Captioned by AI)]

This solution provided by @Akash_Javalekar1 received 1 likes!

How to merge two datatable with different headers & Range

Hi @jamuna_T Please find my attached solution and let me know if it’s working JoinDatatable.zip (113.8 KB) Please mark as solution if its working! Thanks Akash Javalekar

This solution provided by @ashokkarale received 1 likes!

Captch in UiPath

@Shravan_Pintu, Here is one blog on Python approach.

---

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

Top 3 Topics with Most Views

How to calculate the Age from the DOB made by @naveen.s with 24 views.

Get Text from ID (N Get Text) Failed: made by @james07 with 21 views.

How to capture an embedded link from outlook email made by @yangyq10 with 21 views.

Top 3 Topics with Most Replies

How to capture an embedded link from outlook email made by @yangyq10 with 16 replies.

How to read latest timestamp excel file made by @Jeeru_venkat_Rao with 12 replies.

How to use semi structured AI in uipath document understanding service made by @Nisha_K21 with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 23 posts!

@Anil_G made 12 posts!

@lrtetala made 12 posts!

Top 3 Most Liked Posts

This post made by @stevewakley received 1 likes!

Will UiPath run ok in ARM version of Windows 11?

Hi again I’ve now managed to get the latest 2024 Community edition of Studio installed and am seeing a vast improvement in overal performance of Studio - workflow load times, no delays jumping aroung the worlflow, loading of .Net function parameters (e.g. with enter ‘.’ after an activity to load the list of options, or loading the list of arguments and variables).

This post made by @ppr received 1 likes!

How to calculate the Age from the DOB

we recommend to resharpen the needs: years needed - OR months count needed - definition of the fractions is needed We also would highlight that the DateDiff method is not handling fractions and can lead to side effects for years: [grafik]

This post made by @Anil_G received 1 likes!

Get Text from ID (N Get Text) Failed:

@james07 Welcome to the community Please check the selector you are using Generally we would not use attributes which changw in selector…to get the correct one which is not dynamic we use ui explorer and check the attributes which do not change Cheers

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 1 likes!

Get Text from ID (N Get Text) Failed:

Give this a try: < webctrl parentid=‘q-portal*dialog*’ tag =‘DIV’ type=‘’ class= ‘text-subtitle1 text-grey-8*’ /> Let us know how you go. . … . To paste an asterisk * in a forum post you need to escape it with a backslash \ Aka insert this \*

This solution provided by @Anil_G received 1 likes!

Lists

@A_Learner I guess you used inverted comma Cheers

This solution provided by @Akash_Javalekar1 received 1 likes!

Attachments not getting download

hi @Hemant_Deshmukh please mark as solution as it resolve your 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 | 15 October 2024

Top 3 Topics with Most Views

Join Datatable Using Linq made by @Manii_K with 23 views.

How to get the column value based on the specified value matched in the table made by @jamuna_T with 23 views.

Error: String '' was not recognized as a valid DateTime made by @rajababu.mandapati with 21 views.

Top 3 Topics with Most Replies

Copy Excel cells to clipboard iteratively made by @shreesh.bhardwaj_7 with 18 replies.

Retrieving cell value in Excel made by @Komom with 14 replies.

FTP/SFTP: Upload Files - Creating a new folder does not work when using SFTP made by @PeCour with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 23 posts!

@Yoichi made 19 posts!

@naveen.s made 10 posts!

Top 3 Most Liked Posts

This post made by @SorenB received 2 likes!

Become a 2025 UiPath Community MVP – Apply Now

I hope to come into consideration Very exited for 2025 and continuing my automation journey with UiPath

This post made by @Akash_Javalekar1 received 1 likes!

AI and Automation Unite : Join the UiPath HyperHack 2024 Challenge!

Hi @Vibhor.Shrivastava can we participate if members from different organizations?

This post made by @Brian_Mathew_Maben received 1 likes!

Retrieving cell value in Excel

Hey @Komom , could you please let us know exactly what are the extra texts you want to remove from the table under the USD Column? We can then also help you on finding a solution through string manipulations or Regex. Meanwhile I can guide you one how you can use the For Each Row Activity: Search the For Each Row in Data Table Activity in the activity panel and drag it on to your sequence. Next you will need to specifiy the datatable you want to iterate over. For example, let’s say you ha…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Cannot open Uipath Studio

@anjani_priya, It seems Studio update interrupted or not finished properly. Uninstall and do a clean reinstall thats the only way. Thanks, Ashok

---

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

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

[system]

Daily Forum Report | 16 October 2024

Top 3 Topics with Most Views

How to convert data table into string with preferable reading format? made by @Marcellee with 26 views.

Change status from new to in progress made by @camaro123 with 20 views.

Call Workflow Dynamically made by @NathanSK with 20 views.

Top 3 Topics with Most Replies

How to click each checkbox on a for each help made by @22222222asas with 15 replies.

How to convert data table into string with preferable reading format? made by @Marcellee with 13 replies.

チリンという鈴の音を出したい。 made by @gorby with 13 replies.

Top 3 Users Who Posted The Most

@Yoichi made 28 posts!

@Anil_G made 23 posts!

@ashokkarale made 18 posts!

Top 3 Most Liked Posts

This post made by @LevKushnir received 5 likes!

Can't install packages with Windows compatibility

Hi everyone, I have some good news—actually, not just one piece of good news, but two! IT IS HERE! SAP BAPI for Windows projects SAP 3.0.0 (classic) has been released today and should now support Windows projects Please check release notes here We also released SAP BAPI connector from Integration Service Please check docs here Note: minimum Studio version required for the classic activities is 24.10 minimum Studio version required for the Integra…

This post made by @Kismet_Tosun received 3 likes!

Celebrating Our Outstanding Community Contributors: Meet our 11 Forum Moderators 2024

Congratulations everyone

This post made by @ashokkarale received 3 likes!

Celebrating Our Outstanding Community Contributors: Meet our 11 Forum Moderators 2024

Great efforts everyone! Thank you for your time and efforts helping and inspiring everyone here Congratulations

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to click each checkbox on a for each help

HI, One of the simplest way is ForEachUiElement activity as the following, for example. [image] Sample Sample20241016-5.zip (4.5 KB) Regards,

This solution provided by @KalyanM received 1 likes!

Change a Date Format

Hi @Ayushi_Kuhar To change the date format, you can use this code: CDate(YourDateTimeVariable).ToString(“dd/MM/yyyy”) This will convert your DateTime variable to the desired format.

This solution provided by @ashokkarale received 1 likes!

How to input an array of PDF file paths

@Marcellee, Pass it like this. {“C:\User\Desktop\” + str_number + “.pdf”, “C:\User\Desktop\” + str_date + “.pdf”} Thanks, Ashok

---

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

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

[system]

Daily Forum Report | 17 October 2024

Top 3 Topics with Most Views

How to remove group of data match should remove the row in excel made by @Raja.G with 28 views.

Identify Item in Data Table made by @anmita with 21 views.

Change Int to Datetime Variable made by @Srushti_Swami with 19 views.

Top 3 Topics with Most Replies

Click the checkbox using 'Find Children INPUT help made by @22222222asas with 7 replies.

Identify Item in Data Table made by @anmita with 6 replies.

Issue with get text in a filled form webpage made by @Chiara_Zatta with 6 replies.

Top 3 Users Who Posted The Most

@Yoichi made 15 posts!

@Anil_G made 14 posts!

@ashokkarale made 13 posts!

Top 3 Most Liked Posts

This post made by @ali.koundi1 received 2 likes!

Celebrating Our Outstanding Community Contributors: Meet our 11 Forum Moderators 2024

Great efforts , I thank each and every one of you

This post made by @LevKushnir received 2 likes!

Can't install packages with Windows compatibility

Feel free to reply here. I am watching you :)))

This post made by @Shahazeer_Ummer_D received 2 likes!

Browser opening error

By any chance have you used a browser other than edge or chrome? Some browsers don’t seem to be compatible with use browser.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Click the checkbox using 'Find Children INPUT help

Hi Is the target Checkbox type in HTML? If so, the filter string should be as the following. <webctl tag='INPUT' type='checkbox' /> And it’s necessary to indicate target element of FindChildren, to make contain multiple checkboxes, as the following image. [image] Regards,

This solution provided by @Yoichi received 1 likes!

Need last value after - how to split

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(System.IO.Path.GetFileNameWithoutExtension(yourFileName),"\d+$").Value [image] System.Text.RegularExpressions.Regex.Match(System.IO.Path.GetFileNameWithoutExtension(yourFileName),"(?<=\w+-)\w+-\w+").Value [image] Regards,

This solution provided by @Sanjay_Bhat received 1 likes!

Cron expression for first day of every quarter

Hi @Sathish_Kumar_S Try this “0 0 11 1 1,4,7,10 ?” Thank You

---

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

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