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.