Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 March 2023

Top 3 Topics with Most Views

Error connecting UiPath Studio and Assistant to Orchestrator - "Requested Address is not valid in its context" made by @FTIDS with 52 views.

Remving Number Extension from a downloaded File made by @Sisay_Dinku with 37 views.

Linq query to merge datatable made by @Shyam_Pragash with 33 views.

Top 3 Topics with Most Replies

How to align center text cellvalue in excel made by @Raja.G with 7 replies.

Please let me know, How to loop into List of Datatables and what is the argument value we need to set if we use for each loop for that? made by @Salman_Faries with 7 replies.

Select Row item in Browser DT made by @Dhiaa-ABM with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 20 posts!

@Luca09 made 6 posts!

@Steven_McKeering made 6 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 2 likes!

How to align center text cellvalue in excel

Hi @Raja.G , Check this below attached workflow, Uipath_AlignTextCenter.xaml (6.4 KB) Files Used: GetAddressAndAlignCenter.txt (264 Bytes) Book1 (1).xlsx (11.3 KB) Parameters: {"Your Sheet Name","Text to Find"} [image] Hope this may help you

This post made by @Anil_G received 2 likes!

Extract data from pdf and save to CSV

@Luca09 Then you have to save to different columns For each are you getting one match only or multipe matches? If only one match then what youa re doing will save the first value in first row and second value in second row…yes ienum will not contain the first… If youw ant both …then do two separate regex matches…then you get teo variables… Now use a nee datatable …build one with teo columns …first column for first regex values and second column for second regex values Now use loop on one i…

This post made by @omar_ismail received 1 likes!

Bulk insert No value given for one or more required parameters

Hi all, I am trying to upload my data to SQL through bulk insert activity however it keeps giving me the below error in the screenshot [image]

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Extract data from pdf and save to CSV

@Luca09 Then you have to save to different columns For each are you getting one match only or multipe matches? If only one match then what youa re doing will save the first value in first row and second value in second row…yes ienum will not contain the first… If youw ant both …then do two separate regex matches…then you get teo variables… Now use a nee datatable …build one with teo columns …first column for first regex values and second column for second regex values Now use loop on one i…

This solution provided by @Anil_G received 1 likes!

How to align center text cellvalue in excel

@Raja.G Giving the cell Number and selecting centre in Horizontal is not moving everything to centre? [image] I Just tried it on same file you gave and it did move both [image] I beleive environment.Newline is already part of it so no need of it to be separately included 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 | 14 March 2023

Top 3 Topics with Most Views

Unable to pass the variable in the moderns activity made by @copy_writes with 73 views.

Filter Data Table DayOfWeek made by @pl.rusinov with 52 views.

Perform hotkey press in terminal session made by @shravan_nayak with 49 views.

Top 3 Topics with Most Replies

Perform hotkey press in terminal session made by @shravan_nayak with 21 replies.

Path cannot be null issue made by @Pyx with 17 replies.

Extract from mail body made by @jnarthan.g with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Yoichi made 40 posts!

@jnarthan.g made 20 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 5 likes!

UI web activity question

Hii @A_Learner , Can you please give a try by setting “Table” as your target element and in the property panel of the find children activity there is a Property called “Filter” There u provide [image] Can you check this and confirm? Note : Provide property “Scope” as :- FIND_DESCENDANCE Cheers,

This post made by @Yoichi received 4 likes!

Assign value/string to ColumnB based on value of ColumnA

HI, Another approach: [image] dt.Columns("ColumnB").Expression = "IIF([ColumnA]<=5,'A','B')" Regards,

This post made by @Manish540 received 4 likes!

Linq Query question regarding DT

Hi @Shubham_Kinge , Check this below query to get unique rows based on a column, dt_Grouped = (From d In dt_Input Group d By k=d("Your Column Name").toString.Trim Into grp=Group Select grp.First).CopyToDataTable() Hope this may help you

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 5 likes!

UI web activity question

Hii @A_Learner , Can you please give a try by setting “Table” as your target element and in the property panel of the find children activity there is a Property called “Filter” There u provide [image] Can you check this and confirm? Note : Provide property “Scope” as :- FIND_DESCENDANCE Cheers,

This solution provided by @Manish540 received 4 likes!

Linq Query question regarding DT

Hi @Shubham_Kinge , Check this below query to get unique rows based on a column, dt_Grouped = (From d In dt_Input Group d By k=d("Your Column Name").toString.Trim Into grp=Group Select grp.First).CopyToDataTable() Hope this may help you

This solution provided by @Suraj_B_Shetty received 2 likes!

Assign value/string to ColumnB based on value of ColumnA

Hi @calvin.tan Give a try to this [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 | 15 March 2023

Top 3 Topics with Most Views

Address generation for Canada missing made by @luc.poirier with 70 views.

Select DataTable made by @pl.rusinov with 56 views.

Remove rows that are filled in a particular column made by @weelearns with 49 views.

Top 3 Topics with Most Replies

Select DataTable made by @pl.rusinov with 19 replies.

Error while publishing - JIT compilation made by @pravin_bindage with 19 replies.

Unattended robot connection to orchestrator is reset (Requires Assistant) made by @bromanen with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 109 posts!

@supermanPunch made 22 posts!

@ushu made 20 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 5 likes!

Save Attachments to folder using Office 365 Activity

Hi @Shazid_Rahman , Use this below code in save attachments activity, CType(mailMessages(0),System.Net.Mail.MailMessage) Where - mailMessages(0) is of type UiPath.MicrosoftOffice365.Models.Office365Message Find the below screenshot, [image] Hope this may help you

This post made by @Manish540 received 4 likes!

Invoke VBA: Cannot run the macro 'SumTwoNumbers'. The macro may not be available in this workbook or all macros may be disabled

Hi @minal.patil , Use this below vba code to sum the numbers, Function SumTwoNumbers(Numberl As Integer,Number2 As Integer)As Integer SumTwoNumbers = Numberl+Number2 End Function Find the below screenshot for your reference, [image] Hope this may help you

This post made by @Monica_Secelean received 2 likes!

UiPath Community 23.2 Preview Release - Document Understanding

@ushu sure, find details about Business Rules here: https://docs.uipath.com/activities/docs/20232-load-taxonomy-preview#rules-tab - let us know if it doesn’t answer your questions/anything’s missing

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 5 likes!

Save Attachments to folder using Office 365 Activity

Hi @Shazid_Rahman , Use this below code in save attachments activity, CType(mailMessages(0),System.Net.Mail.MailMessage) Where - mailMessages(0) is of type UiPath.MicrosoftOffice365.Models.Office365Message Find the below screenshot, [image] Hope this may help you

This solution provided by @Manish540 received 4 likes!

Invoke VBA: Cannot run the macro 'SumTwoNumbers'. The macro may not be available in this workbook or all macros may be disabled

Hi @minal.patil , Use this below vba code to sum the numbers, Function SumTwoNumbers(Numberl As Integer,Number2 As Integer)As Integer SumTwoNumbers = Numberl+Number2 End Function Find the below screenshot for your reference, [image] Hope this may help you

This solution provided by @arjunshenoy received 2 likes!

Want to add 0 in front of time. My time is stored in string variable

@Puneet_Singh Since you said you have stored it in a string variable, try concatenation: “0”+stringVar Hope this helps, Best Regards.

---

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

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

[system]

Daily Forum Report | 16 March 2023

Top 3 Topics with Most Views

Remove strings from () made by @Abc_Xyz1 with 45 views.

How to skip saving null field date column in access from data table made by @arthurang with 45 views.

Insert record from Data Table to Access made by @arthurang with 43 views.

Top 3 Topics with Most Replies

Extract specific data from notpad++ made by @mironb with 30 replies.

How to Filter Two or More Items from a columns in Datatable made by @Sisay_Dinku with 26 replies.

Save data into an array provided by the user made by @rodriordu123 with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 59 posts!

@ppr made 25 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @ppr received 10 likes!

SupermanPunch 1000th Solution Flag Celebration

It’s time to set up the firecrackers and order the DJ for the next UiPath Forum party. Let’s celebrate @SupermanPunch’s 1000th Solution Flag milestone together. Thank you, Arpan for your support, which is marked by quality and empathy.

This post made by @Manish540 received 5 likes!

RegX for specific String from TextBody

Hi @Tate_S , Check this below code, reqValue(String type) = System.Text.RegularExpressions.Regex.Match(InputString,"(?<=By:)[0-9\sA-z()].+",System.Text.RegularExpressions.RegexOptions.Multiline).Value [image] Hope this may help you

This post made by @Anil_G received 3 likes!

SupermanPunch 1000th Solution Flag Celebration

Woooohhhhhoooo @supermanPunch great work… @ppr really good to see you keeping an eye on these wonderful moments kudos

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 5 likes!

RegX for specific String from TextBody

Hi @Tate_S , Check this below code, reqValue(String type) = System.Text.RegularExpressions.Regex.Match(InputString,"(?<=By:)[0-9\sA-z()].+",System.Text.RegularExpressions.RegexOptions.Multiline).Value [image] Hope this may help you

This solution provided by @Manish540 received 3 likes!

Insert record from Data Table to Access

Hi @arthurang , Check this below link, [Insert Data from DataTable to MS Access Table in UiPath | Insert Bulk Data in MS Access in UiPath] Hope this may help you

This solution provided by @Jithesh_R received 3 likes!

If the queue item already exists in the queue then it should not be added again

Hii @minal.patil , To do this You have to Enable the enforce Unique references while creating the queue. Then let us say you have a data table to push into queue.Just add a new Column Named “references” and add a Unique values to that column(if you have the unique columns in your datatable then uyou can take that column as a reference column) Then while adding the queue items to the queue you can provide the column name here [image] Now if you go to your orchestrator, in the queue You can…

---

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

Top 3 Topics with Most Views

Null add data column issue made by @Pyx with 44 views.

Extract data from website issue with duplicated "name" made by @AlbertM with 44 views.

Join DataTable without Condition made by @kaviyav with 44 views.

Top 3 Topics with Most Replies

How to select one item from the list in the website made by @Sisay_Dinku with 22 replies.

Read Range Workbook is not working made by @_pjflo with 18 replies.

Problem with Linq query with Group By made by @olivier.garcin with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Yoichi made 36 posts!

@supermanPunch made 29 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 3 likes!

SupermanPunch 1000th Solution Flag Celebration

Hi @ppr , Thank you for the Celebration post . It has been quite a ride with the UiPath platform and I try my best to provide a better solutioning to the queries posted. I have learnt a lot throughout the years with Forum and from fellow contributors. You and many other active members have been an inspiration for me and to many others here. Hoping to continue learning, sharing and engaging in the forum and community activities. Thank you everyone for your wishes

This post made by @Suraj_B_Shetty received 3 likes!

Adding a column to excel depending on the given condition

Hi @MEGHA_cs Give a try to this workflow it matches your requirement. AddMonthColumn.xaml (10.2 KB) Output [image] Hope this helps

This post made by @Pavanraj_Shetty received 3 likes!

When to Use vs. Write Line

Hi @kcaller Write line : Writes specified data or text to the Output panel . Use for debugging your automation. Type Into : Enters text in a specified UI element, for example a text box. If you specify the text to enter using the Text Builder, you can also send special keys like Tab or Enter to the UI element. Must be added inside an Application Card activity. To write to an Excel cell , use “Write Cell”. The name of the sheet in which the cell or range of cells that you want to write to is. …

Top 3 Most Liked Solutions

This solution provided by @Suraj_B_Shetty received 3 likes!

Adding a column to excel depending on the given condition

Hi @MEGHA_cs Give a try to this workflow it matches your requirement. AddMonthColumn.xaml (10.2 KB) Output [image] Hope this helps

This solution provided by @Pavanraj_Shetty received 3 likes!

When to Use vs. Write Line

Hi @kcaller Write line : Writes specified data or text to the Output panel . Use for debugging your automation. Type Into : Enters text in a specified UI element, for example a text box. If you specify the text to enter using the Text Builder, you can also send special keys like Tab or Enter to the UI element. Must be added inside an Application Card activity. To write to an Excel cell , use “Write Cell”. The name of the sheet in which the cell or range of cells that you want to write to is. …

This solution provided by @Jithesh_R received 2 likes!

FOR EACH ROW IN DATA TABLE DOUBT

Hii @BHUVAN , Below is one way how you can do this. In the property panel of “for each row in Datattable” activity create Index Variable. [image] Then using if condition You can do the rest of the requirement in the “then” part [image] 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 | 18 March 2023

Top 3 Topics with Most Views

How to cut off cell's text with specific mark? such as "(" made by @hoseongwon with 39 views.

: Lookup Data Table -> Excel-Application Scope -> ReadRange made by @isaac.djiki with 37 views.

Error BC30057 made by @Pedro_Alfaro with 36 views.

Top 3 Topics with Most Replies

: Lookup Data Table -> Excel-Application Scope -> ReadRange made by @isaac.djiki with 11 replies.

How to Get "Refrence" and "Status" column from orchestrator Queue made by @hemasai.06 with 9 replies.

How to cut off cell's text with specific mark? such as "(" made by @hoseongwon with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 40 posts!

@ABHIMANYU_THITE1 made 18 posts!

@Manish540 made 16 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 2 likes!

Re framework -Business rule exception

Hi @TUSHAR_DIWASE , If you throw any business or application exception in Init state then Bot will go to the End State and it will perform the operations in end state. In catch section of Init state, SystemException variable will be set with Exception value as shown in below screenshot, [image] Hope this helps

This post made by @ABHIMANYU_THITE1 received 2 likes!

Synchronization of logs from local to orchestrator

Hi @Vaibhav_Rajpoot_17, @Anil_G wonderful work around - this one helps, By doing any configuration it is not possible to stop the synchronization of execution logs from local db to Orchestrator db in the Community version of UiPath. The synchronization of logs is a built-in feature that cannot be disabled or customized in the Community version. However, you can control the level of details that are synchronized by adjusting the logging level settings in UiPath Studio or Robot settings. The “R…

This post made by @supermanPunch received 2 likes!

Where I can find UIARD certified people?

Hi @prabin_chand1 , Making a Bit of a Search in Google, Gave me the below link : Maybe this is what you were searching for ?

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 2 likes!

Re framework -Business rule exception

Hi @TUSHAR_DIWASE , If you throw any business or application exception in Init state then Bot will go to the End State and it will perform the operations in end state. In catch section of Init state, SystemException variable will be set with Exception value as shown in below screenshot, [image] Hope this helps

This solution provided by @ABHIMANYU_THITE1 received 2 likes!

Synchronization of logs from local to orchestrator

Hi @Vaibhav_Rajpoot_17, @Anil_G wonderful work around - this one helps, By doing any configuration it is not possible to stop the synchronization of execution logs from local db to Orchestrator db in the Community version of UiPath. The synchronization of logs is a built-in feature that cannot be disabled or customized in the Community version. However, you can control the level of details that are synchronized by adjusting the logging level settings in UiPath Studio or Robot settings. The “R…

This solution provided by @supermanPunch received 2 likes!

Where I can find UIARD certified people?

Hi @prabin_chand1 , Making a Bit of a Search in Google, Gave me the below link : Maybe this is what you were searching for ?

---

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

Top 3 Topics with Most Views

'.', hexadecimal value 0x00, is an invalid character. Line 48973, position 763 made by @Kiran_Govvala with 51 views.

Transpose - Excel Data using LINQ made by @Neal369 with 35 views.

Get the item before the last in queue made by @Deep_HML with 32 views.

Top 3 Topics with Most Replies

How to find top row respective values as per row 2 value made by @Jeeru_venkat_Rao with 10 replies.

How to schedule a process to run on specific dates of month made by @mohamedalthaf with 8 replies.

Get the item before the last in queue made by @Deep_HML with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 35 posts!

@supermanPunch made 10 posts!

@Deep_HML made 4 posts!

Top 3 Most Liked Posts

This post made by @mohamedalthaf received 2 likes!

How to schedule a process to run on specific dates of month

Thanks @Manish540 @Anil_G @vishal.kp

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

How to schedule a process to run on specific dates of month

Hi @mohamedalthaf , Use the expression: 0 0 20 10,15,28,30,31 1/1 ? * This will only run on those specific dates and will be on rest in other days. [image]

This post made by @Anil_G received 1 likes!

Get the item before the last in queue

@Deep_HML Try this Listqueue.ToArray(listqueue.Count-2) Cheers

Top 3 Most Liked Solutions

This solution provided by @vishal.kp received 2 likes!

How to schedule a process to run on specific dates of month

Hi @mohamedalthaf , Use the expression: 0 0 20 10,15,28,30,31 1/1 ? * This will only run on those specific dates and will be on rest in other days. [image]

This solution provided by @Anil_G received 1 likes!

Get the item before the last in queue

@Deep_HML It would be listqueue.ToArray(0) and listqueue.ToArray(1) Hope this helps Cheers

This solution provided by @Anil_G received 1 likes!

Transpose - Excel Data using LINQ

@Neal369 Thats because of union…it removes duplicates …please try this (From col In DataTbl.Columns.Cast(Of System.Data.DataColumn) Select OP_DT.Rows.Add({col.ColumnName}.Tolist.Concat(DataTbl.AsEnumerable.Select(Function(x) x(col.ColumnName).ToString).ToArray).ToArray)).CopyToDataTable [image] Hope this helps cheers

---

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

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

[system]

Daily Forum Report | 20 March 2023

Top 3 Topics with Most Views

After today's update ,lot's of errors made by @Zoeyu with 60 views.

Escaping all special characters at once made by @JenJen with 60 views.

Excel 2 column Matching made by @Gokul_Murali with 55 views.

Top 3 Topics with Most Replies

Escaping all special characters at once made by @JenJen with 21 replies.

Machine Learning Extraction with multiple PDF formats made by @syezids with 21 replies.

Excel 2 column Matching made by @Gokul_Murali with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 105 posts!

@Yoichi made 26 posts!

@supermanPunch made 24 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 8 likes!

Excel Automation Bold and font

Hi @Shubham_Kinge , Check this below workflow, Uipath_ApplyBorderAndBold.xaml (6.6 KB) Files Used:- BordersAndBold.txt (296 Bytes) sample_input.xlsx (9.9 KB) Code:- Sub ApplyBordersAndBold(sheetName,Rng) 'Sheet on which you need to perform the opertaions Sheets(sheetName).Activate 'Apply range of cells borders ActiveSheet.Range(Rng).Borders.LineStyle = xlContinuous 'Make range of cells bold text ActiveSheet.Range(Rng).Font.Bold = True End Sub If you are using vba macros for the first…

This post made by @Pavanraj_Shetty received 6 likes!

Escaping all special characters at once

Hi @JenJen [image] If a string includes multiple lines, it will replace them all. Hope this might help you

This post made by @Pavanraj_Shetty received 5 likes!

Excel Automation Bold and font

Hi @Shubham_Kinge Please try this Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 8 likes!

Excel Automation Bold and font

Hi @Shubham_Kinge , Check this below workflow, Uipath_ApplyBorderAndBold.xaml (6.6 KB) Files Used:- BordersAndBold.txt (296 Bytes) sample_input.xlsx (9.9 KB) Code:- Sub ApplyBordersAndBold(sheetName,Rng) 'Sheet on which you need to perform the opertaions Sheets(sheetName).Activate 'Apply range of cells borders ActiveSheet.Range(Rng).Borders.LineStyle = xlContinuous 'Make range of cells bold text ActiveSheet.Range(Rng).Font.Bold = True End Sub If you are using vba macros for the first…

This solution provided by @Manish540 received 4 likes!

Can't run teams

Hi @Soudios , Have you tried using the Use Application/Browser activity as shown in below screenshot, [image] Hope this helps

This solution provided by @Chirag_Shetty_Divakar received 4 likes!

How to find top row respective values as per row 2 value

Hey @Jeeru_venkat_Rao Hope this helps you [image] forum ans.zip (68.8 KB) 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 | 21 March 2023

Top 3 Topics with Most Views

To add the additional text to the cell in which already some text extist made by @Siddarth_Nagarabenchi with 66 views.

How to split excel cell data dynamically? made by @Vaishnav_Tej with 65 views.

Passing List in Create HTML Content Activity made by @Zen_Ahmed with 56 views.

Top 3 Topics with Most Replies

Disallow conversion made by @Pyx with 22 replies.

Need some help wrt Demo for reading attachment from outlook made by @lakshminarasimhan.santhan with 17 replies.

Drop Down Clock Not Working made by @Sisay_Dinku with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@supermanPunch made 34 posts!

@Jithesh_R made 16 posts!

Top 3 Most Liked Posts

This post made by @Jennifer_Serrao received 5 likes!

To add the additional text to the cell in which already some text extist

CellValue.zip (8.9 KB) Hey @Siddarth_Nagarabenchi You can refer the xaml above. Cheers!

This post made by @Manish540 received 5 likes!

Delete all the rows above dynamic row

Hi @Sathish_Kumar_S , Follow this below steps, First Lookup for “User” value in excel as shown in below screenshot and get the address of the value. [image] Next use Insert/DeleteRows activity as shown below, CInt(System.Text.RegularExpressions.Regex.Match(valueAddress,"[0-9]+").Value)-1 [image] Hope this may help you

This post made by @Jithesh_R received 4 likes!

How to send email

Hii @jnarthan.g , There are many activities in UiPath studio to send mail messages. If You have outlook installed in your system then you can try send Outlook mail message [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 5 likes!

Delete all the rows above dynamic row

Hi @Sathish_Kumar_S , Follow this below steps, First Lookup for “User” value in excel as shown in below screenshot and get the address of the value. [image] Next use Insert/DeleteRows activity as shown below, CInt(System.Text.RegularExpressions.Regex.Match(valueAddress,"[0-9]+").Value)-1 [image] Hope this may help you

This solution provided by @jack.chan received 2 likes!

Get error message & send email

something like this @anh.nguyen try: [image] catch block [image]

This solution provided by @Jithesh_R received 1 likes!

How to send email

@jnarthan.g , To attach the file ,click on attach file and there you provide your File path within the double quotes, [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 | 22 March 2023

Top 3 Topics with Most Views

How to remove UIPath studio made by @jaco with 66 views.

Orchestrator - Classic executions will stop in April 2023 made by @sebastian.ungureanu with 59 views.

How to write a VLOOKUP formula using path&sheetname made by @Betul_Dundar with 45 views.

Top 3 Topics with Most Replies

Table Extraction only extract 10 rows made by @loi.nguyen with 25 replies.

How to remove UIPath studio made by @jaco with 20 replies.

Getting unauthorized when trying to access document manager made by @Marielle_Nolasco with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 84 posts!

@Yoichi made 28 posts!

@Gokul001 made 17 posts!

Top 3 Most Liked Posts

This post made by @Chirag_Shetty_Divakar received 6 likes!

アプリのステートを確認アクティビティ内で使用するクリックアクティビティはNApplication Cardで囲む必要はありますか

@gorby はい、NApplication カード内でアプリ状態アクティビティを使用する必要があることを確認してください これがあなたの質問に答える場合は、解決策としてマークしてください [image] ありがとう

This post made by @Chirag_Shetty_Divakar received 5 likes!

Substring, regex, etc

Hey @AndhikaDwi [image] [image] [image] MatchRegexVariable is of type string Regex Forumm.zip (68.4 KB) Hope this will help Cheers.

This post made by @Pavanraj_Shetty received 5 likes!

Split Data in Excel file into multiple Excel File

Hi @mohan_sai365 Try this Test.zip (42.4 KB) Hope might helpful for you

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 6 likes!

アプリのステートを確認アクティビティ内で使用するクリックアクティビティはNApplication Cardで囲む必要はありますか

@gorby はい、NApplication カード内でアプリ状態アクティビティを使用する必要があることを確認してください これがあなたの質問に答える場合は、解決策としてマークしてください [image] ありがとう

This solution provided by @Chirag_Shetty_Divakar received 5 likes!

Substring, regex, etc

Hey @AndhikaDwi [image] [image] [image] MatchRegexVariable is of type string Regex Forumm.zip (68.4 KB) Hope this will help Cheers.

This solution provided by @Pavanraj_Shetty received 5 likes!

Split Data in Excel file into multiple Excel File

Hi @mohan_sai365 Try this Test.zip (42.4 KB) Hope might helpful for 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.

[system]

Daily Forum Report | 23 March 2023

Top 3 Topics with Most Views

[Bulk Add Test Data Queue Items] Not supporting non-ASCII characters in headers made by @GT_Ropa with 103 views.

Compare two csv and find same values from 2 different column made by @mohiniganesh15 with 59 views.

Update of UiPath made by @GhostBuster with 56 views.

Top 3 Topics with Most Replies

Compare two csv and find same values from 2 different column made by @mohiniganesh15 with 26 replies.

How to switch back to first tab after opening multiple tabs in the same browser? made by @Samraat_Maharjan1 with 23 replies.

Write Range Workbook : Split or spanned archives are not supported error made by @prabin_chand1 with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 101 posts!

@Yoichi made 20 posts!

@Chirag_Shetty_Divakar made 14 posts!

Top 3 Most Liked Posts

This post made by @Rui_Cruz2 received 3 likes!

Orchestrator - Classic executions will stop in April 2023

Hi @An_Dig If you are using on-premise orchestrator you don’t need to worry it is not applicable to you but I recommend talking to your company and updating the orchastrator because that version no longer has support

This post made by @Adrian_Tamas received 3 likes!

Live Streaming & Remote Control - Preview release

Hi there UiPath Community, We are excited to announce the release of our new Preview feature - Live Streaming and Remote Control of unattended automations! While a job is in progress, for processes that have Live Streaming and Remote Control enabled, a user with the right privileges set can access the live stream in order to see the automation execution, would be able to then take remote control (use own mouse & keyboard as input on the controlled machine), without pausing the automation, if i…

This post made by @Jithesh_R received 3 likes!

Fetch row excel 3 sheets to 1 sheet

Hey @Harpoon Please refer this screenshot Input Data Tables are : Sheet1 read range :- DT1 Sheet2 read range :- DT2 Sheet3 read range :- DT3 [image] [image] [image] While doing write range activity please dont tick the add headers as you dont want the headers. Regards,

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 3 likes!

Fetch row excel 3 sheets to 1 sheet

Hey @Harpoon Please refer this screenshot Input Data Tables are : Sheet1 read range :- DT1 Sheet2 read range :- DT2 Sheet3 read range :- DT3 [image] [image] [image] While doing write range activity please dont tick the add headers as you dont want the headers. Regards,

This solution provided by @supermanPunch received 2 likes!

How to retrieve previous 7 days data from today

Hi @Ishan_Shelke , Could you maybe check on the below Expression : DT.AsEnumerable.Where(Function(x)CDate(x("MailSentDateTime").ToString).Date<Now.Date andAlso DateDiff(DateInterval.Day,CDate(x("MailSentDateTime").ToString).Date,Now.Date)<=7).CopyToDatatable Let us know if this doesn’t work.

This solution provided by @piyushagarwal.0108 received 1 likes!

Custom Activity not working with Windows Compatibility Mode

This problem is resolved. Here is a step-by-step solution for anyone facing similar problem in future [Build Custom Activity - Windows Compatibility]

---

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 | 24 March 2023

Top 3 Topics with Most Views

Created a automathon with using the automation challenge made by @imumeriqbal with 70 views.

Mail retrieve attachments does not work made by @Joachim with 56 views.

Trim the string in datatable made by @Demo_User with 45 views.

Top 3 Topics with Most Replies

Mail retrieve attachments does not work made by @Joachim with 24 replies.

Excel - Classic Version - Column and Header Formatting made by @PPIM_RPA with 14 replies.

Present Validation Station: The value must either contain a textual value or have components, not both made by @Nithya_Aashitha with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 76 posts!

@Yoichi made 37 posts!

@arjunshenoy made 18 posts!

Top 3 Most Liked Posts

This post made by @mukeshkala received 2 likes!

Live Streaming & Remote Control - Preview release

Hi @Adrian_Tamas , I Tried this Feature and its working fine for me with one Exception that it is changing settings of my computer. Whenever I am using this - My Wallpaper is getting changed to a default Black Screen . Tried doing the same multiple times - same thing happens. Not sure if thats the Tight VNC or something else. – Mukesh

This post made by @mukeshkala received 2 likes!

Live Streaming & Remote Control - Preview release

@Adrian_Tamas , Thank you - I got it - Just adding the screenshot here of the setting for anyone else facing the same. [image] – Mukesh

This post made by @Gokul001 received 2 likes!

Split String which is having multiple occurrences

Hi @Vardhan Welcome to UiPath community You can try with Regular expression System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)") [image] System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)")(1) [image] [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Split String which is having multiple occurrences

Hi @Vardhan Welcome to UiPath community You can try with Regular expression System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)") [image] System.Text.RegularExpressions.Regex.Matches(YourString,"(?s)(.*?)home\ndelivery\)")(1) [image] [image] Regards Gokul

This solution provided by @Yoichi received 2 likes!

How to get all columns (example A,B,C ...) in excel and return to array

HI, How about the following expression? (Case for 100 columns) Enumerable.Range(1,100).Select(Function(i) ExcelUtilities.ConvertColumnIndexToColumnLetter(i)).ToArray [image] Note: please add UiPath.Excel.Helper namespace in advance. Sample20230324-5L.zip (2.4 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Invoke Workflow question

@A_Learner You have to use another use application browser activity inisde the workflow… You can either attach to window using selector or can send the output of use application browser from the main xaml to the called xaml Hope this helps Cheers

---

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

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

[system]

Daily Forum Report | 25 March 2023

Top 3 Topics with Most Views

Excel Manipulations, The result of final status column should come as OK & NOT OK made by @Praveen_Vs with 41 views.

Get Text OCR Error made by @Amit_Kumar_Charde with 36 views.

How to know which activity get error? made by @prabin_chand1 with 36 views.

Top 3 Topics with Most Replies

Excel Manipulations, The result of final status column should come as OK & NOT OK made by @Praveen_Vs with 13 replies.

Get Text OCR Error made by @Amit_Kumar_Charde with 9 replies.

Not able to access Type Argument for For Each Loop made by @Arijit_Sarkar with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 11 posts!

@ushu made 10 posts!

@supermanPunch made 8 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 2 likes!

How to read my config file?

Hi @prabin_chand1 You can copy the InitAllSettings workflow from any blank RE Framework & paste the same in your project folder, along with your config.xlsx file. In the studio, just drag the same workflow, map the config file & store the data in Config variable. That’s it, you are good to go. Hope this helps, Best Regards.

This post made by @saritha received 1 likes!

Invoke Workflow question

Hi Yoichi, Here may I know what will be the output of UiElement. Thanks and have a great day.

This post made by @ushu received 1 likes!

How can I manually connect to Oracle DB using variables

Hi @j.wheeler - You can use variables of type String in the connection string. Did you check the connection string working without using any variables in it. This is to confirm, successful connection to db. If it works then, try passing variables in it. Hope below link useful

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 2 likes!

How to read my config file?

Hi @prabin_chand1 You can copy the InitAllSettings workflow from any blank RE Framework & paste the same in your project folder, along with your config.xlsx file. In the studio, just drag the same workflow, map the config file & store the data in Config variable. That’s it, you are good to go. Hope this helps, Best Regards.

This solution provided by @supermanPunch received 1 likes!

Issues while attaching file

Hi @JOBIN_JOSE , Maybe try the below : {str_latest}

This solution provided by @supermanPunch received 1 likes!

Excel - Classic Version - Column and Header Formatting

@PPIM_RPA , Apologies. It seems I made a small mistake. Could you shift the datatables in the Merge Datatables Activity and check, It should be like the below image : [image] Let me know if you still receive the same output again.

---

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

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

[system]

Daily Forum Report | 26 March 2023

Top 3 Topics with Most Views

VLookup LINQ - Multiple Columns made by @Neal369 with 42 views.

LINQ for 2 Tables made by @tep_b with 42 views.

How to remove last char from a range in one go without loops made by @Jeeru_venkat_Rao with 35 views.

Top 3 Topics with Most Replies

VLookup LINQ - Multiple Columns made by @Neal369 with 11 replies.

Color detection with CV made by @Gabriel_Isman with 10 replies.

Queue Trigger With Postpone is not triggered made by @logesh_kumar1 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 32 posts!

@Manish540 made 9 posts!

@arjunshenoy made 9 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

How to remove last char from a range in one go without loops

Hi @Jeeru_venkat_Rao , Can you please check below screenshot its working for me, [image] Use this below code in write cell activity, "=SUBSTITUTE(A2,""$"","""")" [image] Hope this may help you

This post made by @arjunshenoy received 3 likes!

Minimal Product Set

Hi @A_Learner UiPath Studio for developing automation workflows. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Robot: The software that executes the automation workflows created in Studio. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Orchestrator: Centralised management and monitoring tool. You will need a server with at least 8GB RAM and a quad-core processor. The server should also have a minimum of 10GB of free di…

This post made by @arjunshenoy received 2 likes!

Minimal Product Set

@A_Learner Along with the UiPath Enterprise Licence, some hardware requirements might differ from regular requirements, as DU uses GPU units & need higher machine capabilities. You can find the list of requirements for DU in the doc below: Hope this helps, Best Regards.

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 4 likes!

How to remove last char from a range in one go without loops

Hi @Jeeru_venkat_Rao , Can you please check below screenshot its working for me, [image] Use this below code in write cell activity, "=SUBSTITUTE(A2,""$"","""")" [image] Hope this may help you

This solution provided by @arjunshenoy received 3 likes!

Minimal Product Set

Hi @A_Learner UiPath Studio for developing automation workflows. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Robot: The software that executes the automation workflows created in Studio. You will need a computer with at least 4GB RAM and a dual-core processor. UiPath Orchestrator: Centralised management and monitoring tool. You will need a server with at least 8GB RAM and a quad-core processor. The server should also have a minimum of 10GB of free di…

This solution provided by @vishal.kp received 2 likes!

Design Window Activities Minimized

@Orchestrator_Practice , try this [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 | 27 March 2023

Top 3 Topics with Most Views

UiPath learning help made by @gaurav2000 with 53 views.

Remove Junk Values made by @Rajneesh_Kumar with 51 views.

Report malware on forum made by @leosaumure with 48 views.

Top 3 Topics with Most Replies

Remove Junk Values made by @Rajneesh_Kumar with 20 replies.

When I start UiPath Studio, I get an error made by @sozdaiblog with 16 replies.

How to download all files from SharePoint folder using microsoft O365 activity made by @Akshay_Suryawanshi with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 81 posts!

@Yoichi made 27 posts!

@supermanPunch made 16 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

UiParh log mearning

@Wirit_Panrit UiPath.Studio.log: contains information about the Studio application itself, including startup and shutdown events, errors that occur within the application, and general diagnostic information. UiPath.Studio.Project.log: contains information about the current project being worked on in Studio, including activities that have been executed, errors that have occurred, and diagnostic information specific to the project.(Execution logs) UiPath.Studio.Analyzer.log: These contain the…

This post made by @Yoichi received 2 likes!

I need regex expression to get date from above line

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,".*(?=\r?\nDepartment of Labor,)").Value [image] Regards,

This post made by @supermanPunch received 2 likes!

While using read pdf ocr , i am getting error ( Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. )

@MitheshBolla , It looks as if the Environment mentioned matches the Environment you have, and hence do follow the Suggestion provided in the post above : [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

I need regex expression to get date from above line

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,".*(?=\r?\nDepartment of Labor,)").Value [image] Regards,

This solution provided by @supermanPunch received 2 likes!

While using read pdf ocr , i am getting error ( Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. )

@MitheshBolla , It looks as if the Environment mentioned matches the Environment you have, and hence do follow the Suggestion provided in the post above : [image]

This solution provided by @Anil_G received 1 likes!

Best way to remove the first two characters from every string value in a list?

@David_Hernandez Try this Listvar.Select(function(x) x.SubString(2)).ToList Hope this helps Cheers

---

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

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

[system]

Daily Forum Report | 28 March 2023

Top 3 Topics with Most Views

Process PDF Files, Classify Documents & more with new Document Understanding Activities in Studio Web made by @Monica_Secelean with 107 views.

Automatic locked screen in Hardware Events input mode? made by @prabin_chand1 with 49 views.

UiPath Studio - Issue with folder connection(Default) made by @dinesh.pazhaniyandi with 45 views.

Top 3 Topics with Most Replies

RPA Challange Extraction Errpr made by @Amit_Kumar_Charde with 17 replies.

Getting data from Website and Load to datatable made by @Sisay_Dinku with 14 replies.

UiPath Studio - Issue with folder connection(Default) made by @dinesh.pazhaniyandi with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 73 posts!

@Yoichi made 21 posts!

@fernando_zuluaga made 13 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 6 likes!

Process PDF Files, Classify Documents & more with new Document Understanding Activities in Studio Web

With our newest Document Understanding package for cross-platform projects, we’re bringing to you PDF processing capabilities and more! Document Data In order to efficiently work with Documents, we introduced the notion of Document Data - an object which can be used as input or output to Document Understanding activities, containing all information about the document, depending on the activities one uses it with: document type (populated by the new Classify Document Activity), fields (p…

This post made by @Chirag_Shetty_Divakar received 5 likes!

Convert a month from numerical digit to words

Hey @Lochagos Use DateTime.Now.AddMonths(-1).ToString(“MMMM”) This will return you full month Like February Regards,

This post made by @Kalpesh_Chaudhari received 3 likes!

What are different ways of triggers?

Hi, There are two types of trigger Time Triggers and Queue Triggers Time Triggers: Enable you to schedule a recurrent time to start a job. Input values for processes that support input and output parameters can be managed at this level as well. Queue Trigger: Can instantly start a process upon the trigger creation or whenever you add a new item to a queue. The trigger runs in the environment associated with the selected process For more pls refer below site: Types of Trigger..? - #9 by Goku…

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 5 likes!

Convert a month from numerical digit to words

Hey @Lochagos Use DateTime.Now.AddMonths(-1).ToString(“MMMM”) This will return you full month Like February Regards,

This solution provided by @Kalpesh_Chaudhari received 3 likes!

What are different ways of triggers?

Hi, There are two types of trigger Time Triggers and Queue Triggers Time Triggers: Enable you to schedule a recurrent time to start a job. Input values for processes that support input and output parameters can be managed at this level as well. Queue Trigger: Can instantly start a process upon the trigger creation or whenever you add a new item to a queue. The trigger runs in the environment associated with the selected process For more pls refer below site: Types of Trigger..? - #9 by Goku…

This solution provided by @Anil_G received 2 likes!

UiParh log mearning

@Wirit_Panrit tried finding few, answers were more from experience Ll try to add more references as I find more Cheers

---

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

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

[system]

Daily Forum Report | 29 March 2023

Top 3 Topics with Most Views

How do I loop through a List(Of String) made by @carlor with 48 views.

Get the key from dictionary where value is min made by @Sven_son with 36 views.

Filter data table by datetime made by @Kevin_Maurice with 36 views.

Top 3 Topics with Most Replies

How do I loop through a List(Of String) made by @carlor with 17 replies.

How to remove unique values from text file and get only duplicate value list? made by @vidya.wagh with 16 replies.

Save mail message activity illegal characters in header field made by @Sailaja_Pasupuleti with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@supermanPunch made 25 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @Chirag_Shetty_Divakar received 6 likes!

Cannot Type Into Element in Incognito Mode (Chrome)

@C_M1 Enable extensions in incognito mode. Steps you can follow: Go to Chrome browser Add the chrome extension(if not added yet) Go to customize and control > More tools > Extension [image] Click on the UiPath Extension Now, allow the extension in incognito. [image] Should work [image] Try this Regards.

This post made by @Jithesh_R received 4 likes!

Regarding Send hotkey multiple function

@Ram_Shiva_Reddy Can you try this In the properties panel of send hotkey Click on the selector field and indicate the target And in the Key field in properties panel add something like this (Inside double quotes) [image] Make sure to Check the SendWindowMessage checkbox Regards,

This post made by @Chirag_Shetty_Divakar received 2 likes!

Cannot Type Into Element in Incognito Mode (Chrome)

Hey @C_M1 [image] Check this private option in the Misc. Then you will be able to run in the incognito mode as well Hope this helps, Cheers

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 6 likes!

Cannot Type Into Element in Incognito Mode (Chrome)

@C_M1 Enable extensions in incognito mode. Steps you can follow: Go to Chrome browser Add the chrome extension(if not added yet) Go to customize and control > More tools > Extension [image] Click on the UiPath Extension Now, allow the extension in incognito. [image] Should work [image] Try this Regards.

This solution provided by @Jithesh_R received 4 likes!

Regarding Send hotkey multiple function

@Ram_Shiva_Reddy Can you try this In the properties panel of send hotkey Click on the selector field and indicate the target And in the Key field in properties panel add something like this (Inside double quotes) [image] Make sure to Check the SendWindowMessage checkbox Regards,

This solution provided by @Kalpesh_Chaudhari received 2 likes!

What is Ienumerable?

Hi, To keep it simple, if your object implement IEnumerable, you can iterate over it (with a ForEach). In other words, if something gives you an IEnumerable it provides you a mean to have its elements one by one. Thanks.

---

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

Top 3 Topics with Most Views

RPA Assignment Problem - exporting/importing files from Access DB made by @Jackson_Hew with 43 views.

How to type in data into application text field without using the application? made by @yadish.s with 42 views.

How do I save the latest file from a folder, move it to another folder and rename the file? made by @Shannon_Quek with 38 views.

Top 3 Topics with Most Replies

Unable to read same excel file twice in the same process made by @hari.vishalmudra2 with 16 replies.

How do I save the latest file from a folder, move it to another folder and rename the file? made by @Shannon_Quek with 14 replies.

SELECTOR WILDCARD DOUBT made by @BHUVAN with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@Yoichi made 26 posts!

@arjunshenoy made 14 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How do I save the latest file from a folder, move it to another folder and rename the file?

Hey @Shannon_Quek , 1.You can use this Directory.GetFiles(“C:\Users\Jithesh.R\Downloads\Whatsapp”,“*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) 2.You can use Move File Activity to move the file from one location to another [image] You can use Rename FIle Activity to rename a file [image] Regards,

This post made by @pradeep_ch received 2 likes!

Announcing the Winners of AI Awards 2023

Thank you so much @loredana_ifrim @Vibhor.Shrivastava

This post made by @imran.loon received 2 likes!

Announcing the Winners of AI Awards 2023

Thank You @Vibhor.Shrivastava @loredana_ifrim Congratulations to all winners​:clap:t3:

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How do I save the latest file from a folder, move it to another folder and rename the file?

Hey @Shannon_Quek , 1.You can use this Directory.GetFiles(“C:\Users\Jithesh.R\Downloads\Whatsapp”,“*.xlsx”,SearchOption.AllDirectories).OrderByDescending(Function(d) New FileInfo(d).CreationTime).Take(1) 2.You can use Move File Activity to move the file from one location to another [image] You can use Rename FIle Activity to rename a file [image] Regards,

This solution provided by @Yoichi received 2 likes!

Month+String+Year(1 year ahead) calendar window

Hi, How about the following expression? Now.ToString("MMM")+" FY "+Now.AddYears(1).ToString("yy") [image] OR The following will also work. Now.AddYears(1).ToString("MMM \F\Y yy") Regards,

This solution provided by @Yoichi received 1 likes!

Set Dynamic Delay in Delay Activity

Hi, Can you try to use TimeSpan.FromSecond method etc, as the following? [image] TimeSpan.FromSeconds(delaySec) note : delaySec is Double type variable Regards,

---

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

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

[system]

Daily Forum Report | 31 March 2023

Top 3 Topics with Most Views

【UiPathアカデミー】新規コースのお知らせ（3/31 追加分） made by @yuko.tanaka with 59 views.

How could I copy data from a cell in an excel file and paste it into a web form? made by @ximenasalas872 with 42 views.

Data Service error - when Update or query records made by @Arvind_Kumar1 with 41 views.

Top 3 Topics with Most Replies

Converting the string to the integer made by @shailaja_reddy with 17 replies.

Hi, I am trying to get a email message from my yahoo mailbox but i got timeout.Can anyone help me to check why ic ouldnt get the message ? Is it something wrong with my properties? made by @royang28 with 13 replies.

Find Dynamic Excel Read & Write into sheet made by @anh.nguyen with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Yoichi made 25 posts!

@arjunshenoy made 19 posts!

Top 3 Most Liked Posts

This post made by @sumits received 3 likes!

Announcing the Winners of AI Awards 2023

Thank you so much @Vibhor.Shrivastava and @loredana_ifrim

This post made by @Chirag_Shetty_Divakar received 3 likes!

While loop with continue activity

@BHUVAN Just an example inside invoke to increase count you can use this Select Case Weekday(startDate,VBMonday) Case 1 If row(“Pattern”).ToString.Contains(“1”) Then in_Count=in_Count+1 End If Case 2 If row(“Pattern”).ToString.Contains(“2”) Then in_Count=in_Count+1 End If Case 3 If row(“Pattern”).ToString.Contains(“6”) Then in_Count=in_Count+1 End If Case 4 If row(“Pattern”).ToString.Contains(“7”) Then in_Count=in_Count+1 End If End Select Hope it helps, Cheers

This post made by @Gokul_Jayakumar received 2 likes!

Having Doubt on string conversion

Hello @Mr.Bug_Maker Try this System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(“Your String”) [image]

Top 3 Most Liked Solutions

This solution provided by @Chirag_Shetty_Divakar received 3 likes!

While loop with continue activity

@BHUVAN Just an example inside invoke to increase count you can use this Select Case Weekday(startDate,VBMonday) Case 1 If row(“Pattern”).ToString.Contains(“1”) Then in_Count=in_Count+1 End If Case 2 If row(“Pattern”).ToString.Contains(“2”) Then in_Count=in_Count+1 End If Case 3 If row(“Pattern”).ToString.Contains(“6”) Then in_Count=in_Count+1 End If Case 4 If row(“Pattern”).ToString.Contains(“7”) Then in_Count=in_Count+1 End If End Select Hope it helps, Cheers

This solution provided by @Gokul_Jayakumar received 2 likes!

Having Doubt on string conversion

Hello @Mr.Bug_Maker Try this System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(“Your String”) [image]

This solution provided by @arjunshenoy received 2 likes!

Compare String1 to String2 (String1=String2)

Hi @swinter1 UiPath is adding the @ symbol before String1 because it is interpreting it as a verbatim string literal. A verbatim string literal starts with the @ symbol and it allows you to include special characters, such as new lines or tabs, in a string without having to escape them. To avoid this, you can use: String1 = String1.TrimStart("@"c) Hope this helps, Best Regards.

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

@Manish540 received 126 likes for their solutions!

@Anil_G received 119 likes for their solutions!

@Chirag_Shetty_Divakar received 81 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 April 2023

Top 3 Topics with Most Views

Deskew library for document image processing made by @Minoh_Kang with 36 views.

Hello team, pls provide solution for this string manipulation.Tq made by @lakshmi_narayana_ch with 34 views.

How to put condition for Null Variable Value made by @jai_kumar2 with 32 views.

Top 3 Topics with Most Replies

Insert data in queue with Bulk add Queue items error made by @Deep_HML with 12 replies.

Regex Range Excel made by @anh.nguyen with 10 replies.

Hello team, pls provide solution for this string manipulation.Tq made by @lakshmi_narayana_ch with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@arjunshenoy made 13 posts!

@supermanPunch made 10 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 1 likes!

Deskew library for document image processing

Deskewing is the most common pre-processing that is applied to scanned documents prior to the main processing of data extraction from those documents. The following library provides an easy-to-use wrapper for Galfar’s Deskew Tools for use in UiPath document processing workflows. One notable limitation of Galfar’s tools is the lack of support for multi-page TIF files - it works for the first page only. The library enables deskewing of all the pages by disassembling the pages, performing deskew…

This post made by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

@Deep_HML To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those… And yes the limit is 15k or so… We can break the table into rows of 10k and add in 3 loops So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable And use the chun…

This post made by @supermanPunch received 1 likes!

Insert data in queue with Bulk add Queue items error

Hi @Deep_HML , Maybe also take a look at the below post :

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

@Deep_HML To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those… And yes the limit is 15k or so… We can break the table into rows of 10k and add in 3 loops So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable And use the chun…

This solution provided by @Anil_G received 1 likes!

CurrentRow properties

@TTYF Say you want to copy from sheet1 to sheet2 each column in the loop then use as below…you can copy whole row as well [image] Excel.Sheet("Sheet1").Range(currentRow.ByField("FieldName").Address) Sheetname is the difference between source and destination Hope this helps cheers

---

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

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