Forum Engagement Daily Reports

[system]

Daily Forum Report | 01 April 2024

Top 3 Topics with Most Views

Regex for Credit card made by @Sathish_Kumar_S with 53 views.

Convert String To DataTable made by @alan.prakash with 51 views.

I am not able to open process made by @Mahesh99 with 50 views.

Top 3 Topics with Most Replies

"For Each Excel Row" not working as intended made by @Biswas_Ishan with 19 replies.

How we can extract the text from mail body in the below format made by @Ajinya_jorwekar with 15 replies.

Regex for Credit card made by @Sathish_Kumar_S with 14 replies.

Top 3 Users Who Posted The Most

@Gautham_Pattabiraman made 14 posts!

@ashokkarale made 14 posts!

@muktadir made 14 posts!

Top 3 Most Liked Posts

This post made by @Vennmukhil_T received 3 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

Hi @pradeep_ch , @pathrudu , @AutomationX_by_Kiran , Please find attached Challenge 3 package, PDF Activity_Challenge 3.zip (237.3 KB)

This post made by @abhilash_sb received 3 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

Uipath_challenge3_PDF.zip (237.1 KB) THANK YOU for the challenge. @pradeep_ch @pathrudu @AutomationX_by_Kiran .

This post made by @Tejaswini_Yadav1 received 2 likes!

Beginners Learning Challenge #3 in the UiPath Forum Community!

Hello @pradeep_ch , @pathrudu, @AutomationX_by_Kiran and @loredana_ifrim PDF automation _UIPATH Challenge 3.zip (462.8 KB) Please find the Solution attached. Thank you for creating Challenges Happy Automation!!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

Use applicaion to open file from a particular folder

Hi @vignesh.maruthappan Use Browse For File activity to open a file from a Folder. [image] Regards

This solution provided by @Parvathy received 1 likes!

Long pdf file to word conversion

Hi @maneesha.padamata Try this way: => Use Read PDF with OCR activity and save the output to a variable say pdfTextVariable =>Use the below code in Invoke Code activity. Change the path where you want to store the word document in 10th line. ' Initialize Word application Dim wordApp As New Microsoft.Office.Interop.Word.Application() ' Create a new document Dim doc As Microsoft.Office.Interop.Word.Document = wordApp.Documents.Add() ' Get PDF text from UiPath variable (pdfTextVariable) Dim p…

This solution provided by @ashokkarale received 1 likes!

Excel, Data table, For Each row

@manikandan.murugan, Try this way. Use For Each Row in DataTable activity. Declare Output/Index variable which will hold row index it’s iterating starting with zero. Use assign activity inside loop to assign row number. Add 1 to index value as index is starting at 0. [image] 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 | 02 April 2024

Top 3 Topics with Most Views

🙋‍♀️ 🙋‍♂️ Beginners Learning Challenge #4 in the UiPath Forum Community! made by @pradeep_ch with 267 views.

If condition syntax with date made by @mark_rajkumar1 with 69 views.

【初心者】データテーブルから重複行の削除 made by @ando0403.primal with 51 views.

Top 3 Topics with Most Replies

If condition syntax with date made by @mark_rajkumar1 with 14 replies.

【初心者】データテーブルから重複行の削除 made by @ando0403.primal with 10 replies.

Copy a file and rename the file before adding to the folder made by @Ellen with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@ashokkarale made 23 posts!

@Yoichi made 12 posts!

Top 3 Most Liked Posts

This post made by @pradeep_ch received 4 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

Dear Community , Are you ready for Beginners Learning Challenge #4: Excel application ? Let’s enhance your UiPath skills further with the help of our @pathrudu , @AutomationX_by_Kiran and @loredana_ifrim . Here is the Challenge #4 we have in store for you Challenge_4_input.xlsx (10.8 KB) Take an Excel File, Where it has 3 sheets. First sheet has 4 columns (F.Name, L.Name, DOB, Address) of information and Second sheet has 3 columns (F.Name, …

This post made by @nikhilesh578 received 4 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

All the best👍for challenge 4. Kudos to the team @pradeep_ch , @pathrudu , @AutomationX_by_Kiran , @loredana_ifrim

This post made by @Anil_G received 4 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

Some fun ExcelAsDB.zip (12.4 KB) cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

【初心者】データテーブルから重複行の削除

グルーピングの問題なのでそれ用のメソッドを使う方法を共有します。 [image] dt.AsEnumerable.GroupBy(Function(r) r("管理№").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.First().Item("請求年月"),g.First().Item("実績年月"),g.Key,g.Sum(Function(r) CDec(r("実績（件１）"))),g.Sum(Function(r) CDec(r("実績（件２）"))),g.Sum(Function(r) CDec(r("実績（個数）"))),g.Sum(Function(r) CDec(r("実績（Ｍ３）")))},False)).CopyToDataTable() サンプル Sample20240402-1.zip (3.6 KB)

This solution provided by @muktadir received 1 likes!

How to add manual increment in Write Celll

Hi, Please try the following [image] this will enter the data after the last row of the data table.

---

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

Top 3 Topics with Most Views

Don't click made by @Stef_99 with 63 views.

UiPath Extended Languages OCR Public Preview made by @andras.palfi with 60 views.

How to remove string front space only using regex made by @Chethan_M1 with 48 views.

Top 3 Topics with Most Replies

Excel date filterr made by @Yurdanur_Yusuf1 with 28 replies.

Distinguish emails made by @shilpashree.mohanty with 24 replies.

Don't click made by @Stef_99 with 20 replies.

Top 3 Users Who Posted The Most

@Ajay_Mishra made 32 posts!

@Maheswar_Reddy made 19 posts!

@ashokkarale made 19 posts!

Top 3 Most Liked Posts

This post made by @andras.palfi received 5 likes!

UiPath Extended Languages OCR Public Preview

We’re excited to announce our latest OCR engine, the UiPath Extended Languages OCR, which can digitize documents in over 200 languages. This new OCR engine performs significantly better for Chinese, Japanese, and Korean than our current OCR engines. Additionally, it can now process documents in Thai, Vietnamese, and all major languages from India, as well as languages that use the Cyrillic alphabet and Greek, as well as over 200 other languages. We recommend starting with the UiPath Document OC…

This post made by @Maheswar_Reddy received 2 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

hi, May i know the reason why you are connecting to the database. Thanks

This post made by @Vishal_Yadav2 received 2 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

PFB attached file ChallangeExcelAsDB.zip (12.4 KB)

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Version control git integration requires

Hi @SrinivasDev Please check this Regards,

This solution provided by @Parvathy received 1 likes!

Retrieve credential data using the 'credentials' activity

Hi @Benimaru Check the below thread Regards

This solution provided by @vrdabberu received 1 likes!

Activities突然很多東西不見

Hi @guan_yu_Chen Please download the package UiPath.Excel.Activities. The Excel activities that you see comes under the package UiPath.MicrosoftOffice365.Activities. Go to Manage Packages-> All Packages-> Type UiPath.Excel.Activities → Click Install-> Click Save. 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 | 04 April 2024

Top 3 Topics with Most Views

How to Filter More Items from two columns in Datatable made by @vignesh.maruthappan with 57 views.

Take first n number of rows and next n and so on from datatable made by @yashashwini2322 with 49 views.

Dynamic window selector of object repo on runtime made by @Kervin_Robby_Pagtalunan with 48 views.

Top 3 Topics with Most Replies

How to Filter More Items from two columns in Datatable made by @vignesh.maruthappan with 21 replies.

How to get the file path of an active excel file? made by @corey.phelan with 12 replies.

Filtering the datatable between Dates made by @quick_123 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 44 posts!

@Gautham_Pattabiraman made 23 posts!

@mohamed.saty2012 made 18 posts!

Top 3 Most Liked Posts

This post made by @tazunnisa.badavide received 3 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

Thank you for the Challenge @pradeep_ch,that was something new and challenging ExcelDB_Challenge4.zip (170.8 KB) cheers

This post made by @vignesh.maruthappan received 3 likes!

How to Filter More Items from two columns in Datatable

Thats great. Thanks for the quick response

This post made by @Akhil_Nukala received 2 likes!

Beginners Learning Challenge #4 in the UiPath Forum Community!

Hi @pradeep_ch PFA … Challenge4_UiPath.zip (14.1 KB)

Top 3 Most Liked Solutions

This solution provided by @Dheerendra_vishwakarma received 1 likes!

How to Filter More Items from two columns in Datatable

hello @vignesh.maruthappan your issue got resolved i am attaching zip file for your reference., Forum.zip (34.8 KB) Regards

This solution provided by @vrdabberu received 1 likes!

Cannot find Excel Application Scope Activity

Hi @ydhanabalan Check the below image for better understanding: Excel Application Scope [image] [image] Modern Excel Activities [image] Regards

This solution provided by @Gautham_Pattabiraman received 1 likes!

How to read the txt file value and how to write the value in another txt file

Hi @vsivaraman81 , Please set the Output property of read text Activity to store the value read from the file, [image] In the field you can create a variable to store using Ctrl+k You can use the Write text File Activity to Write the Value from Read Text Activity. Attaching the official documentation of those 2 for your ref. Activities - Write Text File (uipath.com) Activities - Read Text File (uipath.com) Happy automating. Thanks, gautham.

---

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

Top 3 Topics with Most Views

To Remove Duplicate Rows made by @NISHITHA with 47 views.

How to make a pie chart in excel using uipath? made by @Kia1 with 45 views.

How To Make For Each Row Faster? made by @Enrico_N_F with 40 views.

Top 3 Topics with Most Replies

Machine made by @Pushpendra_kowthavarapu with 12 replies.

Unable to publish any project all tools grayed out in Studio made by @Naresh_B_N with 11 replies.

To Remove Duplicate Rows made by @NISHITHA with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@Ajay_Mishra made 13 posts!

@Kia1 made 11 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 4 likes!

Beginners Learning Challenge #5 in the UiPath Forum Community!

Good thought on the process would help people understand different things…kudos PDFChallenge.zip (94.6 KB) cheers

This post made by @Gautham_Pattabiraman received 4 likes!

Beginners Learning Challenge #5 in the UiPath Forum Community!

Hi @pradeep_ch , This One Definitely was a challenge Attaching My solution here. Challenge5.zip (74.2 KB) @pathrudu, @AutomationX_by_Kiran and @loredana_ifrim - It was a great problem statement. Thank You All 4 of you for organizing this challenge, Certainly learnt a lot. Awaiting the date of results from now only All the very best to participants. Cheers, Gautham.

This post made by @DevendraRPA received 4 likes!

Beginners Learning Challenge #5 in the UiPath Forum Community!

Dear Team, I hope this message finds you well. I’m excited to submit my solution for the learning challenge. Please find attached my completed work. Thank you @pradeep_ch @loredana_ifrim @pathrudu and team for the opportunity to participate in this challenge. I look forward to your feedback. Best regards, Devendra Singh PDF Automation Challenge 5 - Devendra Singh.zip (10.8 KB)

Top 3 Most Liked Solutions

This solution provided by @Gautham_Pattabiraman received 2 likes!

Timezone Conversion DST?

Hi @Josh_James , Yes I think, TimeZoneInfo.ConvertTimeFromUtc automatically accounts for Daylight Saving Time if the specified time zone observes it. It handles the conversion based on the rules defined for that time zone, including any adjustments for DST. Try using a log message or write line with the time and match it with actual time once. Thanks, Gautham.

This solution provided by @Anil_G received 1 likes!

How to Use For Each List Item Activity

@marilia_quadros Use like this to filter "fields/Progresso eq 'Whatever Value you need'" For getting value variablename = Listitem.Fields.Where(function(x) x.Name.Equals("ColumnName"))(0).Value Cheers

This solution provided by @Anil_G received 1 likes!

Unable to run unattended bot from Orchestrator

@krishbcd Is the robot installed in service mode? Did you happen to check the screenshots? If not installed in service install it again… If already in service mode you can setresolution from robot settings in orchestrator where you need to activate logintoconsole and set it to false and then can set resolution 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 | 06 April 2024

Top 3 Topics with Most Views

Array of string using semicolon made by @Pavan_kumar15 with 40 views.

Need to store Exception message in Datatable made by @Pavan_kumar15 with 40 views.

Customize Table Extract as per our requirement made by @Anonymouss with 35 views.

Top 3 Topics with Most Replies

Customize Table Extract as per our requirement made by @Anonymouss with 14 replies.

Need to store Exception message in Datatable made by @Pavan_kumar15 with 8 replies.

Array of string using semicolon made by @Pavan_kumar15 with 6 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 28 posts!

@Gautham_Pattabiraman made 14 posts!

@Anil_G made 13 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 3 likes!

Queues - reference

@A_Learner You dont need to use linq also can use this in assign…before that use add data column and add the reference column uou need Dt.Columns("Reference").Expression = "[Employee ID]" Cheers

This post made by @Anonymouss received 2 likes!

Customize Table Extract as per our requirement

This solution is working. @ashokkarale @Gautham_Pattabiraman Thank you Akhil

This post made by @Kalyan1 received 2 likes!

Beginners Learning Challenge #5 in the UiPath Forum Community!

Thanks for the challenge #5 Challenge_5.zip (177.8 KB)

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 3 likes!

Queues - reference

@A_Learner You dont need to use linq also can use this in assign…before that use add data column and add the reference column uou need Dt.Columns("Reference").Expression = "[Employee ID]" Cheers

This solution provided by @ashokkarale received 1 likes!

Customize Table Extract as per our requirement

@Anonymouss, It’s easy to add this logic also to my earlier logic. Input: [image] Solution: [image] Sample Code: ConditionalDataExtraction.xaml (15.6 KB) Output: [image] 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 | 07 April 2024

Top 3 Topics with Most Views

Queues question made by @A_Learner with 35 views.

Help! UiPath Studio Web "Use Authentication" error made by @m.tan with 33 views.

Business_Exception and mail to User made by @Pavan_kumar15 with 32 views.

Top 3 Topics with Most Replies

Update excell value made by @Ellen with 15 replies.

Queues question made by @A_Learner with 8 replies.

How to update EXCEL rows where id is occurs more then 1 time made by @Ellen with 7 replies.

Top 3 Users Who Posted The Most

@Gautham_Pattabiraman made 12 posts!

@Anil_G made 11 posts!

@ashokkarale made 10 posts!

Top 3 Most Liked Posts

This post made by @Manisai received 3 likes!

Beginners Learning Challenge #5 in the UiPath Forum Community!

Thank you @pradeep_ch @loredana_ifrim @pathrudu @AutomationX_by_Kiran guys Your hard work and dedication are truly commendable. Thanks for the challange Challange_5(pdf_automation).zip (73.0 KB)

This post made by @Pavan_kumar15 received 2 likes!

DOU_Error

Thanks @Parvathy It worked

This post made by @Vishal_Yadav2 received 2 likes!

Beginners Learning Challenge #5 in the UiPath Forum Community!

PFB challenge 5 PDFChallenge5.zip (94.6 KB)

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

DOU_Error

Hi @Pavan_kumar15 Check out the below thread. Make sure your packages are in latest version. Regards

This solution provided by @ppr received 1 likes!

XML FETCH VALUE

we mentioned clear the analysis and handling of the XML Namespaces within the linked post. Also we demonstrated the name/namespace analysis [grafik] And can filter and access [grafik]

---

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

Top 3 Topics with Most Views

Getting error on Put Method in "http request" activity made by @shuklarchana001 with 61 views.

How to skip microsoft excel message box? made by @WS_Chai with 60 views.

Can Bot install a software in a desktop using uipath? made by @keerthi_arumugam with 57 views.

Top 3 Topics with Most Replies

REFramework/ Get Transaction Data/Error made by @joselito_chavez with 19 replies.

System.DllNotFoundException: Unable to load DLL 'sni.dll' or one of its dependencies: The specified module could not be found. (0x8007007E) made by @Povilas_Jonikas with 16 replies.

Getting error on Put Method in "http request" activity made by @shuklarchana001 with 16 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 52 posts!

@ppr made 19 posts!

@Ajay_Mishra made 15 posts!

Top 3 Most Liked Posts

This post made by @jaya_raju received 3 likes!

Beginners Learning Challenge #5 in the UiPath Forum Community!

Hi Team, PFA for Challenge_5 process. Challenge_5_PDF.1.0.1.nupkg (52.5 KB) Thanks for all your efforts @pradeep_ch , @AutomationX_by_Kiran & @pathrudu Thanks, JR

This post made by @jawagarraja123 received 3 likes!

I need to extract text between first and last comma

Try This : (?:\s‘\d+).*(?=,) If its work Mark the solution let me if doesn’t work.

This post made by @ashokkarale received 3 likes!

Unable to interact with MS Edge popup on Virtual Machine

@dbukk, Even if you don’t have studio installed, you will have Ui Explorer available at UiPath Assistant installation folder. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 3 likes!

Unable to interact with MS Edge popup on Virtual Machine

@dbukk, Even if you don’t have studio installed, you will have Ui Explorer available at UiPath Assistant installation folder. Thanks, Ashok

This solution provided by @Dheerendra_vishwakarma received 2 likes!

Python or c#

hello @anamariavioleta.dinca , For your specific requirement of extracting text and utilizing font and size information for recognition, both Python and C# can achieve this task effectively. However, if you plan to incorporate machine learning models for text recognition, Python’s extensive ecosystem of machine learning libraries may offer more options and flexibility. if you’re more comfortable with Python or your project involves extensive use of machine learning, Python might be a bette…

This solution provided by @ashokkarale received 2 likes!

REFramework/ Get Transaction Data/Error

@joselito_chavez, It was very small issue. You had declared one variable with name io_dt_TransactionData which was taking precedence or the Extract Data was getting assigned to variable rather than argument. Just remove the variable - io_dt_TransactionData from GetTransactionData workflow and you are good. [Duplicate name] 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 | 09 April 2024

Top 3 Topics with Most Views

Mainframe Automation - Press Left control key made by @Praveen_Vs with 47 views.

HOW TO DOWN LOAD FILE FROM AUDIO HTML TAG WITH UIPATH made by @Quang_Minh_Nguyen with 46 views.

Error BC30311: Value of type 'String' cannot be converted to 'String()' made by @ttk with 45 views.

Top 3 Topics with Most Replies

Excel Automation for column made by @tejas.kotharkar with 18 replies.

Mainframe Automation - Press Left control key made by @Praveen_Vs with 14 replies.

Email is not sent when package published to orchestrator made by @DannyVelkov with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 27 posts!

@ppr made 22 posts!

@Ajay_Mishra made 21 posts!

Top 3 Most Liked Posts

This post made by @Sylvain received 3 likes!

Dev Dives: Streamline document processing with UiPath Studio Web

Description Hello UiPath Community! Are you excited to discover how to easily automate document processing with UiPath Studio Web and Document Understanding? I’m Sylvain Boutié, Founder & CEO @MyLittleBot and 3x UiPath MVP, and alongside my partner Silviu Tanasie, Senior Product Manager @UiPath, we invite you to the next episode of Dev Dives on April 18th. In this session, we’ll delve into the exciting world of document processing automation, made accessible to everyone with the power of UiPa…

This post made by @ppr received 1 likes!

Regex code for more than one "$" sign

Assign Activity hasMoreDollars | DataType: Boolean = System.Text.RegularExpressions.Regex.Matches(strText, strPattern).Count > 1

This post made by @ashokkarale received 1 likes!

https://uipath.onlinetests.app/assess.aspx?aid=UIPATH-ADPV1-PT&key=uippassword

@PavanPannu, It’s up now. Good luck.

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

System.DllNotFoundException: Unable to load DLL 'sni.dll' or one of its dependencies: The specified module could not be found. (0x8007007E)

@Povilas_Jonikas, May be we should be updating the code also like this? Using connection As New Microsoft.Data.SqlClient.SqlConnection(connectionString) connection.Open() Using bulkCopy As New Microsoft.Data.SqlClient.SqlBulkCopy(connection) bulkCopy.DestinationTableName = tableName Try bulkCopy.BulkCopyTimeout = 60 bulkCopy.WriteToServer(dataTable) Catch ex As Exception out_ExceptionMessage = ex.Message Throw …

This solution provided by @ppr received 1 likes!

Mainframe Automation - Press Left control key

have a look here: taken from: 5250 Terminal Connections: Resetting locked keyboard? UPD1- Also scroll down when the RESET key is mentioned

This solution provided by @ppr received 1 likes!

HOW TO DOWN LOAD FILE FROM AUDIO HTML TAG WITH UIPATH

when post edit the extract XML to the src attribute you can grab the links As alternates: Find Children (configure correctly the find scope and the filter) + Post processing the result will return the urls Custom grapping e.g. with: https://html-agility-pack.net/ The files we can download by using the url e.g. with: HTTPRequest Activity Download File from URL Activitiy

---

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

Top 3 Topics with Most Views

Regex to match first two words of multiple lines made by @RamboRocky with 62 views.

Sort date excel made by @Stef_99 with 59 views.

For sending SMTP mail message made by @AsadPathan2665 with 48 views.

Top 3 Topics with Most Replies

Regex to match first two words of multiple lines made by @RamboRocky with 24 replies.

Sort date excel made by @Stef_99 with 15 replies.

Regex find,replace multiple characters made by @Anelisa_Bolosha1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 27 posts!

@Ajay_Mishra made 24 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @Ajay_Mishra received 5 likes!

Sort date excel

@Stef_99 I can see in your output panel date format is change to d/M/yyyy HH:mm dt_Input = dt_Input.AsEnumerable().OrderBy(Function(x) DateTime.ParseExact(x("Planned Start").ToString,"d/M/yyyy HH:mm",System.Globalization.CultureInfo.InvariantCulture)).CopyToDataTable Try above query, I have just change in input date format! If this gives error then try below mentioned query: dt_Input = dt_Input.AsEnumerable().OrderBy(Function(x) DateTime.ParseExact(x("Planned Start").ToString,"M/d/yyyy HH:m…

This post made by @Ajay_Mishra received 3 likes!

REframework should stop

Hey @A_Learner The “Should Stop” signal in UiPath allows for periodic checks during process execution to determine if the execution should be halted based on external conditions or triggers. It utilizes a dedicated activity called “Should Stop” within workflows, checking a stop signal flag that can be set externally. This mechanism is useful for handling long-running or iterative processes, enabling graceful termination and enhancing resilience and robustness in automation solutions. In UiPat…

This post made by @RAKESH_KUMAR_BEHERA received 3 likes!

UiPath Orchestrator Tutorial | Introduction Tutorial on UiPath Orchestrator

[UiPath Orchestrator Tutorial | Introduction Tutorial on UiPath Orchestrator]

Top 3 Most Liked Solutions

This solution provided by @Ajay_Mishra received 5 likes!

Sort date excel

@Stef_99 I can see in your output panel date format is change to d/M/yyyy HH:mm dt_Input = dt_Input.AsEnumerable().OrderBy(Function(x) DateTime.ParseExact(x("Planned Start").ToString,"d/M/yyyy HH:mm",System.Globalization.CultureInfo.InvariantCulture)).CopyToDataTable Try above query, I have just change in input date format! If this gives error then try below mentioned query: dt_Input = dt_Input.AsEnumerable().OrderBy(Function(x) DateTime.ParseExact(x("Planned Start").ToString,"M/d/yyyy HH:m…

This solution provided by @Ajay_Mishra received 3 likes!

REframework should stop

Hey @A_Learner The “Should Stop” signal in UiPath allows for periodic checks during process execution to determine if the execution should be halted based on external conditions or triggers. It utilizes a dedicated activity called “Should Stop” within workflows, checking a stop signal flag that can be set externally. This mechanism is useful for handling long-running or iterative processes, enabling graceful termination and enhancing resilience and robustness in automation solutions. In UiPat…

This solution provided by @Anil_G received 1 likes!

End flow in RE if it is success or failure scenario is met before the end of the workflow

@Bhushan_Nagaonkar Yes…either if or flow decision both should work 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 April 2024

Top 3 Topics with Most Views

Join data and filter made by @Stef_99 with 58 views.

How to use today’s date while using STUDIOX (시스템날짜 읽는법) made by @jaeho_hyeon with 49 views.

Help Python Activity Documentation how to guide made by @Aisya_Yahaya with 46 views.

Top 3 Topics with Most Replies

Join data and filter made by @Stef_99 with 15 replies.

in_TransactionItem.SpecificContent("Test1234").Tostring is giving me "Object reference not set to an instance of an object" error made by @Krithi1 with 15 replies.

Bot clicking the wrong spot made by @NathaliaFawcett with 14 replies.

Top 3 Users Who Posted The Most

@Ajay_Mishra made 37 posts!

@ashokkarale made 27 posts!

@postwick made 20 posts!

Top 3 Most Liked Posts

This post made by @sharathrev received 5 likes!

Winners Announcement: Beginners Learning Challenges in the UiPath Community

Very much humbled. Great initiative by the UiPath MVPs Thanks to @AutomationX_by_Kiran @pradeep_ch and @pathrudu for this wonderful opportunity.

This post made by @gangagiridatta received 4 likes!

Winners Announcement: Beginners Learning Challenges in the UiPath Community

I’m deeply motivated on my UiPath journey and immensely grateful for the challenges that continuously push me to learn more. It’s a humbling and gratifying experience to be part of this fantastic initiative led by the UiPath MVPs. A heartfelt thank you to @AutomationX_by_Kiran, @pradeep_ch, and @pathrudu for this incredible opportunity.

This post made by @ashokkarale received 3 likes!

Winners Announcement: Beginners Learning Challenges in the UiPath Community

Congratulations everyone who participated and winners as well!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Studioxの無料版終了に伴い、作成したプロジェクトを移動したい

スタンドアローン用のStudio/StudioX Trialですね。 有効期間終了後もプロジェクトフォルダ／ファイルが自動的に削除されるようなことはありませんので、その点は心配不要かと思います。先のPostの通りプロジェクトフォルダを丸ごと別端末に移動させれば開くことは可能ですので、あらかじめそのようにしても良いかもしれません。

This solution provided by @Ajay_Mishra received 2 likes!

ご相談：リトライスコープの使い方

@gorby エラーが発生した場合は、デフォルトでリトライされるため、要素の存在を確認するアクティビティを追加する必要はありません。 ハッピー・オートメーション Translate: No need to add Element exist activity if any error occurs then it will retry by default! If No errors occurs then, it will be executed once! Happy Automation! Regards, Ajay Mishra

This solution provided by @Vinit_Mhatre received 1 likes!

Create output excel by transpose of one excel

Hi @Omkar_Shete_CTR , Find Attached Workflow as per your requirement, hope it helps you Omkar Shete.zip (18.3 KB) Regards, Vinit Mhatre

---

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

Top 3 Topics with Most Views

Updating a UiElement variable made by @Clintonnn with 64 views.

Not able to debug the process made by @sowjanya.s with 57 views.

Filter Data more made by @Stef_99 with 56 views.

Top 3 Topics with Most Replies

Filter Data more made by @Stef_99 with 16 replies.

Not able to debug the process made by @sowjanya.s with 13 replies.

【質問】データテーブルの複数列の値を１行づつ合算 made by @ando0403.primal with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 23 posts!

@Ajay_Mishra made 20 posts!

@Gautham_Pattabiraman made 16 posts!

Top 3 Most Liked Posts

This post made by @mounikasurla received 3 likes!

Winners Announcement: Beginners Learning Challenges in the UiPath Community

Congratulations to all the winners. Cheers @AutomationX_by_Kiran , @pradeep_ch , @pathrudu

This post made by @ppr received 2 likes!

Check position column

assumption: DataTable - dtData Assign Activity: arrMissplacedCols | String Array {"Name","Age", "City" }.Where(Function (x,i) Not i.Equals(dtData.Columns(x).Ordinal)).toArray when there is a misplaced column we will get it within the arrMissplacedCols UPD1 -) Fix and Visualizations [grafik] And [grafik]

This post made by @Dheerendra_vishwakarma received 2 likes!

【質問】データテーブルの複数列の値を１行づつ合算

@ando0403.primal , エラーを理解しました。式内の " " をすべて削除して再度入力すると、エラーは表示されません。直接コピーして貼り付けると二重引用符 (" ") のエラーが表示されるため、再度入力するとエラーは解決されます。 。 Cheers

Top 3 Most Liked Solutions

This solution provided by @Dheerendra_vishwakarma received 2 likes!

【質問】データテーブルの複数列の値を１行づつ合算

@ando0403.primal , エラーを理解しました。式内の " " をすべて削除して再度入力すると、エラーは表示されません。直接コピーして貼り付けると二重引用符 (" ") のエラーが表示されるため、再度入力するとエラーは解決されます。 。 Cheers

This solution provided by @ppr received 1 likes!

Get previous Wednesday based on today's date

Option avtivity: Option Code myPrevWednesday = myDateAsDateTime.AddDays(-{4,5,6,0,1,2,3}(myDate.DayOfWeek))

This solution provided by @Ajay_Mishra received 1 likes!

Linq error condition

Hey @Stef_99 In the above LinQ you have given a OR condition in the 4th line, We can’t use OR in Join On! Regards, Ajay Mishra

---

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

Top 3 Topics with Most Views

Document Understanding & Generative AI - How to extract data in table from the pdf having multiple subcolumns made by @vibhuti.savaliya with 37 views.

How to download objects attached in excel which includes pdf and screenshots made by @Abhi_G_G with 37 views.

Error code: 1100; Asset name: DocumentUnderstandingApiKey made by @majAlex with 35 views.

Top 3 Topics with Most Replies

Error code: 1100; Asset name: DocumentUnderstandingApiKey made by @majAlex with 7 replies.

Package requirements missing for published processes made by @carlor with 6 replies.

Else-IF not working made by @Wilgenhoff_Adrian with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 8 posts!

@Gautham_Pattabiraman made 6 posts!

@fernan made 5 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 1 likes!

Data scrapping problems

@Vira7, Welcome to the UiPath Community Please use modern activities for these. Extract individually like this solution. This will give you 10 random names extracted from the site. you can change max iteration count of While as per your requirement. [image] [image] Sample Code: Workflow.xaml (18.5 KB) Output File: Output.xlsx (8.4 KB) Thanks, Ashok

This post made by @vrdabberu received 1 likes!

Error code: 1100; Asset name: DocumentUnderstandingApiKey

Hi @majAlex Please create an Asset with name DocumentUnderstandingApiKey and give your DU API key. For API key, Go to Admin-> Licenses-> Consumables-> Under AI Units you can find DU API Key. Make sure to connect to same folder where you create the Asset. Regards

This post made by @fernan received 1 likes!

Data scrapping problems

Hi @Vira7 Welcome to UiPath Forum! Effectively, the error here is that to use data scraping you must have a collection of data, as in Amazon, you have a list of results, that way the pattern is identified and you can extract the information in a massive way, in this case you only have a single item, a single person, so it does not work, if the portal would show you on a single screen more than one person it would be possible to do it. If you are doing it to practice this functionality, I reco…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Data scrapping problems

@Vira7, Welcome to the UiPath Community Please use modern activities for these. Extract individually like this solution. This will give you 10 random names extracted from the site. you can change max iteration count of While as per your requirement. [image] [image] Sample Code: Workflow.xaml (18.5 KB) Output File: Output.xlsx (8.4 KB) 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 | 14 April 2024

Top 3 Topics with Most Views

I want to download the file only if one of the web elements contains a date that matches today's date made by @Ajinya_jorwekar with 47 views.

Why do we need UiPath License? made by @RobotUi with 42 views.

Community studio installation , robot do not match with installed version made by @JOBIN_JOSE with 39 views.

Top 3 Topics with Most Replies

ClosedXMLでExcelをシート毎に辞書変数に格納したい Dictionary(Of String, DataTable) made by @curry with 8 replies.

I want to download the file only if one of the web elements contains a date that matches today's date made by @Ajinya_jorwekar with 8 replies.

What is the difference between My Workspace and Shared? made by @Ritaman_Baral with 7 replies.

Top 3 Users Who Posted The Most

@Gautham_Pattabiraman made 10 posts!

@Julian_Muhlbauer made 9 posts!

@curry made 5 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

ClosedXMLでExcelをシート毎に辞書変数に格納したい Dictionary(Of String, DataTable)

参考ですがInvokeCodeでのエラーはその内容から判断する必要があります（以下画像の矢印の部分で判断します） おそらく後者のエラーは、最初のエラーとは異なるものと思います。 [image]

This post made by @Ritaman_Baral received 1 likes!

What is the difference between My Workspace and Shared?

Hi , Please refer to the attachment. What is the difference between the two folders ? [image]

This post made by @AndyMenon received 1 likes!

Announcement - Demo Apps launch for improving Apps developer experience

Does this mean i can stop making youtube videos on Apps then?

Top 3 Most Liked Solutions

This solution provided by @Terry_Marr received 1 likes!

How to use Message Box or MsgBox inside 'invoke code'? Getting error

I stripped the code to barebones for testing and tried many variations. Finally, this works: System.Windows.MessageBox.Show("hello") I couldn’t get MsgBox to work on its own. I imported system.windows.forms and that didn’t work. MessageBox is “ambiguous” in a couple of imports, so the full namespace as in code above seems to be needed. This is my first foray into UiPath invoke code. I hope it’s not always this hard to get something so simple to work.

---

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

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

[system]

Daily Forum Report | 15 April 2024

Top 3 Topics with Most Views

UiPath Add to Collection missing Work around & Append Items to Collection reliability made by @bazin.makonnen with 54 views.

How to write string as hyperlink in excel made by @shameenapatel74 with 50 views.

Studio screwing up things again when converting project to library made by @pere with 46 views.

Top 3 Topics with Most Replies

Data entry made by @John_Feringa with 13 replies.

Nuget folder change in VM made by @bhanusai_sajja with 9 replies.

アクティビティが読み込めない状態の解消方法を教えてください made by @yur.h with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 22 posts!

@ashokkarale made 18 posts!

@Yoichi made 13 posts!

Top 3 Most Liked Posts

This post made by @rajneesh94 received 1 likes!

Sentiment Analysis with UiPath AI Center | Part 3 | AI Center Series

[Sentiment Analysis with UiPath AI Center | Part 3 | AI Center Series] Learn how to leverage out-of-the-box sentiment analysis packages, harness the power of non-retrainable packages, and deploy ML skills effortlessly. Plus, discover the crucial steps to making your ML skills public and accessible to all. Watch now: https://youtu.be/0NTytOf3574?si=Ht2kEaiC5KB5hItC Watch the whole playlist: UiPath AI Center - YouTube Cheers

This post made by @ashokkarale received 1 likes!

How to extract matching foldername

Hi @Geeta, Here is possible solution. [image] Sample Code: DirectrySample.xaml (10.1 KB) Thanks, Ashok

This post made by @mhaniff received 1 likes!

No Runtimes Available and None Connected

Hi Everyone. I have UiPath installed in service mode on my machine. I created an unattended setup on orchestrator but am unable to run it. It says 0 runtimes available even though the machine has an unatennded license assigned to it. Also i ran the process before with no issues [Screenshot 2024-04-15 215708] [Screenshot 2024-04-15 220415]

Top 3 Most Liked Solutions

This solution provided by @treesa.maria received 1 likes!

Indicate target to type into issue

Hi @ngochieu.tran, welcome to UiPath community [image] After clicking the Indicate on screen, press F2 or fn key+f2, then it will add delay(pause) during the recording activity.

This solution provided by @Parvathy received 1 likes!

The datetime.parseexact is not taking string() in format argument

Hi @Aakash_Singh_Rawat Try the below syntax: DateTime.ParseExact("my_date_str", {"MMMM yy", "MMMM yyyy"}, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None).ToString("MMM yyyy") Hope it helps!!

This solution provided by @ashokkarale received 1 likes!

Invoke Code with HTML in mail with exchange server (no Outlook)

@bjorn2390, Add this property to your mail object: mail.IsBodyHtml = True 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 April 2024

Top 3 Topics with Most Views

Alphabets need to write row by row made by @Jyothi1 with 53 views.

Error opening workbook. Repair Tool made by @Sabbir_Anwar with 44 views.

「$＊」の意味がわかりません made by @111561 with 43 views.

Top 3 Topics with Most Replies

Alphabets need to write row by row made by @Jyothi1 with 15 replies.

Need to fetch all the files from a folder and load those files in different table in database made by @josesusan044 with 15 replies.

Sharepoint Excel made by @quick_123 with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 38 posts!

@ppr made 16 posts!

@Anil_G made 14 posts!

Top 3 Most Liked Posts

This post made by @nikhilesh578 received 9 likes!

Monthly Forum Rewards - March 2024

Hearty Congratulations to all the winners . You guys killing it @vrdabberu @mkankatala @Parvathy @lrtetala @Anil_G @Shiva_Nikhil @ashokkarale .

This post made by @mkankatala received 4 likes!

Monthly Forum Rewards - March 2024

Congratulations to all the winners, Keep rocking!!

This post made by @Parvathy received 4 likes!

Monthly Forum Rewards - March 2024

Congratulations to all the winners

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Replace Space & Dots with '_' symbol

we recommend to ensure that the Basics are quickly checked and maybe some skill-set plans are to setup [CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum [grafik]

This solution provided by @Ajay_Mishra received 2 likes!

「$＊」の意味がわかりません

Hey @111561 “""はワイルドカードですが、セレクターではありません！" "” is a wildcard but in the selectors! 正規表現において、アスタリスク（*）は直前の要素が0回以上繰り返されることを示す量指定子です。つまり、直前の要素が0回以上出現することができることを意味します。 In regular expressions, the asterisk (*) is a quantifier that matches the preceding element zero or more times. It means the preceding element can occur 0 or more times. 正規表現の"$.doc$“では、最初の”$“は文字列内の”.doc"の前に任意の文字（なしを含む）があることを示しています。最後の"$“は”.doc"の後に任意の文字（なしを含む）があることを示しています。したがって、これらを合わせると、文字列が任意の文字で始まり、".doc"に続き、そして任意の文字で終わることを指定し…

This solution provided by @ashokkarale received 1 likes!

UIPath Studio version: 2020.10.10 compatibility with Windows 11

@bryan.davidson, It’s not officially compatible with Windows 11. More details are here: Studio - Hardware and Software Requirements [docs.uipath.com_studio_standalone_2020.10_user-guide_hardware-and-software-requirements (1)] 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 April 2024

Top 3 Topics with Most Views

INquire how to use Retry Activity made by @sssim4567 with 64 views.

Need to add new column "Date" made by @BHUSHAN_NAGAONKAR1 with 55 views.

Get Text problem made by @greff with 54 views.

Top 3 Topics with Most Replies

Need to add new column "Date" made by @BHUSHAN_NAGAONKAR1 with 19 replies.

URGENT PLEASE HELP! How do I solve this image error? made by @Kia1 with 15 replies.

ダイアログのOKボタンを探すのに時間がかかる made by @ChikaA with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@ashokkarale made 31 posts!

@Ajay_Mishra made 24 posts!

Top 3 Most Liked Posts

This post made by @Gabriatto92 received 10 likes!

Monthly Forum Rewards - March 2024

Congratulations guys, and thank you very much for sharing your knowledge @Yoichi @ashokkarale @vrdabberu @mkankatala @Anil_G @Parvathy @ppr @lrtetala @Shiva_Nikhil @Jayesh_678 @postwick @Vinit_Mhatre @jose.ordonez1 @adiijaiin @Nawazish_Ahmad @Gautham_Pattabiraman @devik @efelantti @Jeroen_van_Loon @pravallikapaluri @noufalahammed @supermanPunch @healsko_ho @mukeshkala @mukesh.singh @Vikas_M @loredana_ifrim

This post made by @Gurusimha_H_S received 5 likes!

Level up your automation beginner journey: #1 Beginner Challenge awaits you!

Hi @pradeep_ch, @AutomationX_by_Kiran, @pathrudu PFA of my solution for the given “Input their birth year” @Gautham_Pattabiraman - Thank you for informing about the challenge. Input_Prompt_Challenge.zip (3.1 KB)

This post made by @Vikas_M received 4 likes!

Monthly Forum Rewards - March 2024

Kudos to Everyone, Keep Growing

Top 3 Most Liked Solutions

This solution provided by @mhaniff received 2 likes!

Access denied ACCESS_DENIED=0x00000005 error thrown when Executor is tried to start

I reinstalled UiPath and the error seems to be resolved now

This solution provided by @J0ska received 2 likes!

Folder path going to documents instead of downloads

You can’t use environment variable in the application argument. Instead use Environment.ExpandEnvironmentVariables("%USERPROFILE%") + "\downloads" Cheers

This solution provided by @Ajay_Mishra received 1 likes!

Missing core activities (close application)

Hey @mconcepcion You can find Close Application after enabling Classic Option in filter section. Screenshot for your reference: [image] Regards, Ajay Mishra

---

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

Top 3 Topics with Most Views

HOW TO RESIZE THE HEIGHT AND WIDTH OF THE IMAGE made by @Kia1 with 60 views.

How to pass empty string in endpoint i.e. URL containing '//' in HTTPRequest? made by @ByteBreaker with 59 views.

Find Networkdays in Datatable made by @Betul_Dundar with 47 views.

Top 3 Topics with Most Replies

How to pass empty string in endpoint i.e. URL containing '//' in HTTPRequest? made by @ByteBreaker with 25 replies.

I have problem in drop down issue made by @MD_Farhan1 with 24 replies.

Change Date Format in text field made by @MD_Farhan1 with 23 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 33 posts!

@MD_Farhan1 made 27 posts!

@postwick made 24 posts!

Top 3 Most Liked Posts

This post made by @Aditi_Indoriya received 3 likes!

Level up your automation beginner journey: #1 Beginner Challenge awaits you!

Hi @pradeep_ch, @AutomationX_by_Kiran, @pathrudu @Gautham_Pattabiraman - Thank you for organizing challenge #1. Age Calculator.zip (2.8 KB) I am attaching my solution here. Kindly share your feedback. Best Regards, Aditi Indoriya

This post made by @harish.bojji received 3 likes!

Level up your automation beginner journey: #1 Beginner Challenge awaits you!

Hi @pradeep_ch, @AutomationX_by_Kiran, @pathrudu Thanks for the great Training sessions, attaching my submission below for the Challenge 1 Challenge 1.zip (3.4 KB)

This post made by @Yoichi received 3 likes!

デバッグ時にアクティビティごとの経過時間を表示させる方法

リボンメニューのデバッグタブ－「実行をプロファイル」を有効にして実行してください。 プロファイルパネルに結果が表示されます。 [img20240418-1]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

デバッグ時にアクティビティごとの経過時間を表示させる方法

リボンメニューのデバッグタブ－「実行をプロファイル」を有効にして実行してください。 プロファイルパネルに結果が表示されます。 [img20240418-1]

This solution provided by @Ajay_Mishra received 3 likes!

Get Unique Values in Column in a datatable along with required column

Hey @Kavya_S If your goal is to get unique rows based on certain properties, DistinctBy is the right choice. If you want to group your rows by some criteria and possibly perform further operations on each group, then GroupBy is more appropriate. Solutions: If you need Unique values applies to all the 3 columns then, Use Below mentioned LinQ: dt_Output = dt_Output.DefaultView.ToTable(True,{"company name","To address","cc address"}) Screenshot for your reference: [image] And If Unique va…

This solution provided by @ABHIMANYU_THITE1 received 2 likes!

Date conversion to specific format

Hi @Rreddy Use this - DateTime.ParseExact(CurrentRow(0).ToString(), "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture) [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 | 19 April 2024

Top 3 Topics with Most Views

Excel and VBA Editor made by @A_Learner with 53 views.

Can i get an excell doc as an input? made by @Suryanarayanan_Shanmugam with 51 views.

Help with Regex for PDF text made by @chauhan.rachita30 with 48 views.

Top 3 Topics with Most Replies

Get modern folder name or orchestrator made by @Pinky_AG with 18 replies.

How to extract attribute of a tag present in xml using uipath? made by @Vyshnavi_Nalumachu with 15 replies.

Can i get an excell doc as an input? made by @Suryanarayanan_Shanmugam with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@ashokkarale made 31 posts!

@Gautham_Pattabiraman made 18 posts!

Top 3 Most Liked Posts

This post made by @vrdabberu received 3 likes!

How to specify range in Read Range

Hi @ext-o If you want to read the entire Sheet then use the below syntax in Excel Read Range activity: Excel.Sheet["Sheet1"] If you read a specific Range in a sheet, then you can specify like below: Excel.Sheet["Sheet1"].Range["A1:C10"] [MicrosoftTeams-image] Regards

This post made by @Dheerendra_vishwakarma received 3 likes!

"LN 5767774 a" in this sentence I want to take numbers after LN

hey @Gopi_Krishna1 , just use this regex (?<=LN\s)\d+\s*\w [image] for your reference Regards, Dheerendra Vishwakarma

This post made by @Rohit_Kamra received 2 likes!

Issue with Automation Developer Professional Training - Assessment

Additional attempts granted, Thanks!

Top 3 Most Liked Solutions

This solution provided by @Dheerendra_vishwakarma received 3 likes!

"LN 5767774 a" in this sentence I want to take numbers after LN

hey @Gopi_Krishna1 , just use this regex (?<=LN\s)\d+\s*\w [image] for your reference Regards, Dheerendra Vishwakarma

This solution provided by @Rohit_Kamra received 2 likes!

Issue with Automation Developer Professional Training - Assessment

Additional attempts granted, Thanks!

This solution provided by @chandreshsinh.jadeja received 1 likes!

How to extract elements from html page web

@Lounis_Merabet1 This sequence extracts all the names of the company try this sequence in your project and let me know if this works for you Happy Automation!! Sequence.xaml (11.6 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 | 20 April 2024

Top 3 Topics with Most Views

Which Extractor to use in Document Understanding for extracting a table? made by @Anirudh_Tugawe with 47 views.

How to open .html file in Uipath made by @Gopi_Krishna1 with 39 views.

Start Job Acitvity not working made by @amruthageorge58 with 34 views.

Top 3 Topics with Most Replies

Start Job Acitvity not working made by @amruthageorge58 with 20 replies.

How to open .html file in Uipath made by @Gopi_Krishna1 with 11 replies.

I am getting an error in data extraction scope made by @Adithyeshwar_goud with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 27 posts!

@Julian_Muhlbauer made 15 posts!

@chandreshsinh.jadeja made 14 posts!

Top 3 Most Liked Posts

This post made by @Gabriatto92 received 3 likes!

Level up your automation beginner journey: #1 Beginner Challenge awaits you!

Hello, I’m sorry, I missed the contest — It’s been weeks of hard work… Good luck and success to all the participants… Regards @pradeep_ch @AutomationX_by_Kiran @pathrudu @loredana_ifrim

This post made by @Rama_Krishna_Dokina received 2 likes!

Level up your automation beginner journey: #1 Beginner Challenge awaits you!

Hi @pradeep_ch , @AutomationX_by_Kiran , @pathrudu Greetings, Great initiative in conducting this event. I would like to appreciate by showing my heartfelt gratitude. Kindly please find my solution in the attachment provided below. Age_Finder.zip (3.5 KB) Approach : Format the years that are less than or equal to current year in the Input Dialog activity, which helps the user to select the Birth Year from the drop down menu. The user can enter the age using keyboard as well which points t…

This post made by @Anil_G received 2 likes!

Received wrong voucher from uipath ops team

@UttamNegi You have to raise it here In the chatbot select others and it would redirect you to raise a request with necessary details 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.