Forum Engagement Daily Reports

[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 commonly required pre-processing that is applied to scanned document images prior to the main processing of data extraction. 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 deskewing …

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.

[system]

Daily Forum Report | 02 April 2023

Top 3 Topics with Most Views

Why UiPath is bringing Updates Frequently? made by @prabin_chand1 with 51 views.

Hello team, i need to add data to datable using add data column and put data in Database. pls provide the solution.Tq made by @Lokesh_M2 with 45 views.

StudioX to Studio change made by @arnab.koley with 37 views.

Top 3 Topics with Most Replies

How to compare 2 sheet and check status made by @anh.nguyen with 15 replies.

How to pass variables as parameters in the "invoke python method" in UIPath made by @PAJ1999 with 14 replies.

Hello team, i need to add data to datable using add data column and put data in Database. pls provide the solution.Tq made by @Lokesh_M2 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@Harshith_Adyanthaya made 11 posts!

@lakshminarayana_chavala made 7 posts!

Top 3 Most Liked Posts

This post made by @fernando_zuluaga received 1 likes!

How to make click dynamic

Hi @Muhammad_Anas_Baloch did you try to use the for each ui element activity? retrieve all the list you want to click, then pass currentElement to click activity also you can use a dynamic click by editing the selector, probably you will find a property called Idx, create a counter and pass that variable Regards

This post made by @Muhammad_Anas_Baloch received 1 likes!

How to make click dynamic

No I haven’t used the Ui element activity let me do with this way. Thanks

This post made by @Muhammad_Anas_Baloch received 1 likes!

How to make click dynamic

Thank you dear for each ui element activity resolved my issue.

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

How to make click dynamic

Hi @Muhammad_Anas_Baloch did you try to use the for each ui element activity? retrieve all the list you want to click, then pass currentElement to click activity also you can use a dynamic click by editing the selector, probably you will find a property called Idx, create a counter and pass that variable Regards

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

Date from 6 months ago

Hi @csanders , Try the below expression now.AddMonths(-6).ToString("dd/MM/yyyy")

This solution provided by @Harshith_Adyanthaya received 1 likes!

Orchestrator Credential in config file

Hi @Amr_Nweery Storing credential in config is not recommended. Instead store it in assets in orchestrator or window credential manager and keep the asset name / Window credential name in config. Later you can use Get credential activity to retrieve credentials from asset. To retrieve credential from window crendential manager you can use Get Secure Credential activity.

---

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 2023

Top 3 Topics with Most Views

What are the major tools you know in UiPath platform made by @Vajrang with 89 views.

How can do to combine RPA and machine learning made by @Soudios with 42 views.

From a datatable, create a variable made by @mark_rajkumar1 with 40 views.

Top 3 Topics with Most Replies

What are the major tools you know in UiPath platform made by @Vajrang with 20 replies.

How to send a form into Outlook made by @shanmugapriyag with 12 replies.

Read Range Workbook: Sequence contains no matching element made by @Chetan_Wagh with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 89 posts!

@arjunshenoy made 31 posts!

@Gokul001 made 23 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 13 likes!

What are the major tools you know in UiPath platform

Mention all the tools and uses in UiPath platform

This post made by @arjunshenoy received 7 likes!

Monthly Forum rewards - March 2023

Congratulations everyone It’s a great thing to guide & learn altogether.

This post made by @rikulsilva received 6 likes!

Monthly Forum rewards - March 2023

Congrats everyone. Its a pleaure read and learning with solutions provided by you

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Help required for Arabic Regex

ensure that when composing the pattern that copy & paste is not confused by the borders and handle right to left text part also [grafik]

This solution provided by @Harshith_Adyanthaya received 2 likes!

Duplicates in emails and do not process them

Hi @Marc.J1 , You can try this query. mailMessages = mailMessages.GroupBy(Function(x)x.Subject).Select(Function(x)x.First).ToList where mailMessages is the output of Get outlook mail message. Hope it helps.

This solution provided by @Yoichi received 2 likes!

How to subtract 8.5 and 9:45?

Hi, How about the following? [image] TimeSpan.Parse("8:35")-TimeSpan.FromHours(8.5) 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 2023

Top 3 Topics with Most Views

Selecting an item from dialog box made by @Jerick_Geronimo with 48 views.

Help me build a linq made by @Rahul_Rajendran with 45 views.

Get value dynamic & sum Excel made by @anh.nguyen with 45 views.

Top 3 Topics with Most Replies

Selecting an item from dialog box made by @Jerick_Geronimo with 15 replies.

Get value from column header made by @anh.nguyen with 14 replies.

Invoke VBA is not working made by @shreyash_shirbhate with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 96 posts!

@arjunshenoy made 25 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 6 likes!

Comparing 2 Datatable

Hey @Atakan_Genc , Please check this workflow Comparing2DataTables.zip (2.3 KB) Comparing2DataTables.xlsx (9.0 KB) Sample Output : [image] Regards,

This post made by @supermanPunch received 2 likes!

Excel application scope problem

Hi @pravin_bindage , We cannot have : in file name. [image]

This post made by @Sudharsan_Ka received 2 likes!

Excel application scope problem

Hi @pravin_bindage File should not contains the these symbols in name change that character to _ or space and try again [image] Regards Sudharsan Regards Sudharsan

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 6 likes!

Comparing 2 Datatable

Hey @Atakan_Genc , Please check this workflow Comparing2DataTables.zip (2.3 KB) Comparing2DataTables.xlsx (9.0 KB) Sample Output : [image] Regards,

This solution provided by @Sudharsan_Ka received 2 likes!

Excel application scope problem

Hi @pravin_bindage File should not contains the these symbols in name change that character to _ or space and try again [image] Regards Sudharsan Regards Sudharsan

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

Invoke VBA is not working

The method name you have mentioned seems to have a typo ChnageFormat, can you check and verify if it’s the same method you have used in the script. @shreyash_shirbhate Regards,

---

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

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

[system]

Daily Forum Report | 06 April 2023

Top 3 Topics with Most Views

How to genrate text to excel made by @Space_Lover with 41 views.

Copy File with error made by @Joanna2 with 38 views.

LastModifiedByUser - not able to fetch in sharepoint files made by @Vishnu_Pradhaban with 37 views.

Top 3 Topics with Most Replies

How to sort the data using linq query made by @RAKESH_KUMAR_Tiwari with 19 replies.

"Assign" keeps showing the name doesn't exist made by @108305006 with 16 replies.

LastModifiedByUser - not able to fetch in sharepoint files made by @Vishnu_Pradhaban with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 30 posts!

@Harshith_Adyanthaya made 30 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 5 likes!

How to pass parametre to Macro Excel c#

Hi @javierdavidh , Can you please pass the parameter as below and let us know, new object[] {variable1} [image] Hope this helps you

This post made by @Jithesh_R received 5 likes!

I required last 4 IP addresses Individually

Hey @Manju_Reddy_Kanughula , I believe this exercise is from the Bots DNA . So for that to take this individual values You can directly put this inside a datatable and you can put for each row in data table for each row. 1.Read text file 2. Use generate data table activity 3. Use for each row for that Generated data table you will get seperate rows. This is the configuration inside generate data table [image] Regards,

This post made by @Jithesh_R received 5 likes!

Delete column by condition

Hey @anh.nguyen , Check this workflow DeleteColumnByCondition.zip (2.3 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 5 likes!

How to pass parametre to Macro Excel c#

Hi @javierdavidh , Can you please pass the parameter as below and let us know, new object[] {variable1} [image] Hope this helps you

This solution provided by @Jithesh_R received 5 likes!

I required last 4 IP addresses Individually

Hey @Manju_Reddy_Kanughula , I believe this exercise is from the Bots DNA . So for that to take this individual values You can directly put this inside a datatable and you can put for each row in data table for each row. 1.Read text file 2. Use generate data table activity 3. Use for each row for that Generated data table you will get seperate rows. This is the configuration inside generate data table [image] Regards,

This solution provided by @Jithesh_R received 5 likes!

Delete column by condition

Hey @anh.nguyen , Check this workflow DeleteColumnByCondition.zip (2.3 KB) Regards,

---

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

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