Forum Engagement Daily Reports

[system]

Daily Forum Report | 06 March 2023

Top 3 Topics with Most Views

Can't Find nor add downloaded package made by @Jackson_Hew with 92 views.

Update Row Item First Name: Value Cannot be null. (Parameter 'row') made by @olmccb with 58 views.

DateTime.ParseExact the whole Column without looping made by @arthurang with 54 views.

Top 3 Topics with Most Replies

Update Row Item First Name: Value Cannot be null. (Parameter 'row') made by @olmccb with 21 replies.

Copy same folders and rename it multiple times with different names made by @Kunal_Jain with 18 replies.

Read PDF text line by line instead of block by block made by @Joachim with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@Gokul001 made 31 posts!

@supermanPunch made 26 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

How to add comma to the integer value

Hi @sneha_arbole1 Check this below code, formattedValue(variable as String data type) = CDbl("10000000").ToString("#,#.00", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")) Hope this may help you

This post made by @ppr received 3 likes!

How to extract array json data to data table

we will deserialize the JSON - Out: myJObject [grafik] And can convert by: [grafik] Assign Activity: dtResult = JArray.FromObject(myJObject.PropertyValues.select(Function (x) x(0).Value(Of JObject))).toObject(Of DataTable) POST EDIT: statement shortening: [grafik]

This post made by @Manish540 received 3 likes!

Linq query to filter data

Hi @shaik_Azam , Check this below workflow attached, the query and input file used, Uipath_Linq_FilterData.xaml (6.8 KB) query:- (From x In dt_Input.AsEnumerable Group x By k=x(“Vendor”).ToString.Trim Into grp=Group Let successRmk = grp.Any(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“successful”)) Let failedCnt = grp.Where(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“failed”)).ToArray.Count>1 Let removedEx = String.Join(" Or “,grp.Select(Function(x) If(System.Text.R…

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 4 likes!

How to add comma to the integer value

Hi @sneha_arbole1 Check this below code, formattedValue(variable as String data type) = CDbl("10000000").ToString("#,#.00", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")) Hope this may help you

This solution provided by @ppr received 3 likes!

How to extract array json data to data table

we will deserialize the JSON - Out: myJObject [grafik] And can convert by: [grafik] Assign Activity: dtResult = JArray.FromObject(myJObject.PropertyValues.select(Function (x) x(0).Value(Of JObject))).toObject(Of DataTable) POST EDIT: statement shortening: [grafik]

This solution provided by @Manish540 received 3 likes!

Linq query to filter data

Hi @shaik_Azam , Check this below workflow attached, the query and input file used, Uipath_Linq_FilterData.xaml (6.8 KB) query:- (From x In dt_Input.AsEnumerable Group x By k=x(“Vendor”).ToString.Trim Into grp=Group Let successRmk = grp.Any(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“successful”)) Let failedCnt = grp.Where(Function(x) x(“Remarks”).ToString.Trim.ToLower.Equals(“failed”)).ToArray.Count>1 Let removedEx = String.Join(" Or “,grp.Select(Function(x) If(System.Text.R…

---

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

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

[system]

Daily Forum Report | 07 March 2023

Top 3 Topics with Most Views

None of the overload groups have all their required/optional activity arguments configured in any add data row made by @Nathan_Betters1 with 81 views.

How to get current user logon time windows 10 using uipath made by @vinod_badgujar with 49 views.

Need regex to get time from a trsing made by @sudha456 with 48 views.

Top 3 Topics with Most Replies

How to skip scrapped rows? made by @Paul_Li2 with 16 replies.

How to get current user logon time windows 10 using uipath made by @vinod_badgujar with 14 replies.

Need regex to get time from a trsing made by @sudha456 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 58 posts!

@fernando_zuluaga made 30 posts!

@Yoichi made 26 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

Need regex to get time from a trsing

Hi @sudha456 , Use this below code, YourStr(String as data type) = System.Text.RegularExpressions.Regex.Match("EXPECTED DELIVERY DATE | 3/7/23 AT 8:00 AM - 9:00 AM","\d{1}\:\d{2}\s+[A-z]{2}\s+\-\s+\d{1}\:\d{2}\s+[A-z]{2}").Value Hope this might help you

This post made by @Pavanraj_Shetty received 3 likes!

Uipath act

Hi @garimavarshney9 Please find the following approach, which is actually working: In the ‘Filter’ property of ‘Get outlook mail messages’ - set the value to "[ReceivedTime] >= " + DateTime.Today.ToString("dd") Output: [image] Hope this helps, please let me know if any further assistance is required. Regards.

This post made by @dipensoni99 received 2 likes!

Recording - Preview release

Can we save the recording or share via emails to business groups?

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Can't find Set to clipboard activity

@guillaume.cabanes2 You can directly use the clipboard value using set variable value if you want to set the value then on left side give Clipboardx.StringValue and on right give the value to be assigned To get value again clipboardx.stringvalue can be used [image] Hope this helps Cheers

This solution provided by @fernando_zuluaga received 2 likes!

SL01_Query Regarding to the Executing the LINQ Query

Hi @Harsha_S1 What about the following? [image] arrNumbers.Where(Function(x) x >= 2).ToArray() Regards

This solution provided by @supermanPunch received 2 likes!

Problem in looping with Data table then append to .xlsx

@Hossam_Gouda , The correction again would be to use only the Extract Structured Data and Write Range Activities in the Then part of If and remove the whole If, as there is no looping of the pages to be done, even that part is not necessary. Also, Could you add the below Expression in the Assign Activity before the Close Application. ExtractedDT = new Datatable This will erase the data in the datatable after it is already written to the Excel sheet, so that when used again, it will only cont…

---

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

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

[system]

Daily Forum Report | 08 March 2023

Top 3 Topics with Most Views

How to download folder from google drive? made by @Tuannna1 with 87 views.

Read Table from PDF and Regex made by @bryant.macciano with 44 views.

'The Operation has timed out' error where the user tries to install package made by @feedrpa with 44 views.

Top 3 Topics with Most Replies

Deleting the Complete current row at the end made by @karthik_kulkarni1 with 17 replies.

How to download folder from google drive? made by @Tuannna1 with 16 replies.

Error After Update : Excel File cannot be overwritten made by @Vaishnav_Tej with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 88 posts!

@ABHIMANYU_THITE1 made 39 posts!

@raja.arslankhan made 19 posts!

Top 3 Most Liked Posts

This post made by @arjunshenoy received 4 likes!

How to apply multiple subject Filters in get outlook mail message

Hi @Ishan_Shelke Please try this: "@SQL=urn:schemas:httpmail:subject like '%MARCICOIMPPAID%' OR urn:schemas:httpmail:subject like '%MARICOIMPLCPAID'" Edit the quotations according to the syntax: "@SQL=""urn:schemas:httpmail:subject"" like '%MARCICOIMPPAID%' OR ""urn:schemas:httpmail:subject"" like '%MARICOIMPLCPAID%'" Hope this helps, Best Regards.

This post made by @Manish540 received 4 likes!

Data table column to list with no duplication

Hi @Hazem_Saleh , We can have C# linq’s in the Invoke Code activity as shown below, companyNames(List of String) = dt1.AsEnumerable().Select(ra => ra.Field<String>("COMPANYNAME")).Distinct<String>().ToList<String>(); We have to set the language to CSharp in Invoke Code activity property section as per below screenshot, [image] Arguments:- [image] Hope this may help you

This post made by @Manish540 received 3 likes!

For each row excel and when row have "Keyword" i want duplicated that row

Hi @Phunya , Check this below workflow attached, Uipath_DuplicateRowBasedOnKeyword.xaml (12.7 KB) [image] Hope this may help you

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 4 likes!

How to apply multiple subject Filters in get outlook mail message

Hi @Ishan_Shelke Please try this: "@SQL=urn:schemas:httpmail:subject like '%MARCICOIMPPAID%' OR urn:schemas:httpmail:subject like '%MARICOIMPLCPAID'" Edit the quotations according to the syntax: "@SQL=""urn:schemas:httpmail:subject"" like '%MARCICOIMPPAID%' OR ""urn:schemas:httpmail:subject"" like '%MARICOIMPLCPAID%'" Hope this helps, Best Regards.

This solution provided by @Manish540 received 4 likes!

Data table column to list with no duplication

Hi @Hazem_Saleh , We can have C# linq’s in the Invoke Code activity as shown below, companyNames(List of String) = dt1.AsEnumerable().Select(ra => ra.Field<String>("COMPANYNAME")).Distinct<String>().ToList<String>(); We have to set the language to CSharp in Invoke Code activity property section as per below screenshot, [image] Arguments:- [image] Hope this may help you

This solution provided by @Chirag_Shetty_Divakar received 3 likes!

For each row excel and when row have "Keyword" i want duplicated that row

Hey @Phunya [image] ExcelTable.zip (9.5 KB) 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 | 09 March 2023

Top 3 Topics with Most Views

Comparison between Einstein OCR (Salesforce OCR) VS UiPath OCR made by @shreyash_shirbhate with 65 views.

Update individual cell in Excel Spreadsheet made by @craig.norton with 63 views.

How to Automatic add the sum of columns values in a same row in UiPath Studio Coding? made by @raghav.bhardwaj.external with 44 views.

Top 3 Topics with Most Replies

How to get data from orchestrator queue made by @sruthesanju with 27 replies.

Google blocks Gsuite made by @aquinn with 20 replies.

Regex to get str values between numbers made by @syezids with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 89 posts!

@supermanPunch made 31 posts!

@Yoichi made 28 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

指定ファイルパスのフォルダパスを取得する構文は存在しない？

Hi @gorby , You can use below code to get folders from a main folder, System.IO.Directory.GetDirectories(“folderpath”) To get the folder name of a filepath you can use below code, System.IO.Path.GetDirectoryName(“filepath”) Hope this may help you

This post made by @Yoichi received 3 likes!

Lookup Address Values - Unique Values

Hi, It’s because * and ? are special characters in lookup. Can you try to escape it using ~ as the following? row_symbol = row_symbol.Replace("*","~*").Replace("?","~?") Regards,

This post made by @Yoichi received 3 likes!

How to take the first set(ConfigValue) of records in a loop

Hi, FYI, another approach: chunksize = 2000 then arrDt = Enumerable.Range(0,(dt.Rows.Count \ chunksize) -CInt(dt.Rows.Count mod chunksize <>0)).Select(Function(i) dt.AsEnumerable.Skip(i*chunksize).Take(chunkSize).CopyToDataTable).ToArray returns datatable array which has chunksize (2000) rows (the last item has remaining rows) Then iterate this array. Regards,

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 4 likes!

指定ファイルパスのフォルダパスを取得する構文は存在しない？

Hi @gorby , You can use below code to get folders from a main folder, System.IO.Directory.GetDirectories(“folderpath”) To get the folder name of a filepath you can use below code, System.IO.Path.GetDirectoryName(“filepath”) Hope this may help you

This solution provided by @Anil_G received 2 likes!

Migration classic folder to modern folder: Attended robot not displayed

@PeCour You need not reinstall the attended robots…you just need to configure the attended license again once you migrate… You have to create machine templates and users and assign the license to it Users are what are called as robots in the modern folders… you have to create and add them to the respective folder and provide the attended user license Can use this as a started help [UiPath Advance Orchestrator | Assigning Roles to Modern Folders] cheers

This solution provided by @fernando_zuluaga received 2 likes!

Write date as 'Thursday 09th March'?

Hi @Rowley101 Give a try with DateTime.Today.ToString("dddd dd'th' MMMM") 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 | 10 March 2023

Top 3 Topics with Most Views

How to change text color in excel made by @Raja.G with 52 views.

Dt & DateTime format in error made by @Ertan_AY with 51 views.

Click activity randomly stops working made by @justinv with 45 views.

Top 3 Topics with Most Replies

Dt & DateTime format in error made by @Ertan_AY with 35 replies.

How to change text color in excel made by @Raja.G with 19 replies.

Pass two lists through one validation made by @qwerty1 with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 64 posts!

@supermanPunch made 29 posts!

@ABHIMANYU_THITE1 made 28 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 5 likes!

Date Column in Excel based DataTable UiPath

Hi @Neal369 , Try to read your file with Preserve Format enabled as shown in below screenshot, [image] and let us know.

This post made by @Michael_Halpin received 2 likes!

How to create a custom activity for UiPath using .Net 6.0+?

I updated the .NET Framework template for custom activities to run on .NET Core 6.0+ it includes several modernizations to the code to be up to standard with C#10. The project can be found on GitHub here: https://github.com/Michael-S-Halpin/UIPath.HelloActivity It includes a UnitTest project which will allow developers to step through their and debug their code outside of UiPath. It also has debug logging implemented to allow developers to optionally specify a log file which is useful for de…

This post made by @Carla_Beretta received 2 likes!

YellDucal - UIPATH PROGRAMADOR - Buenos Aires - Argentina - Contract

Job title: UiPath PROGRAMADOR Job role: Other Role Country: Argentina City: Buenos Aires Company name: YellDucal Employment Type: Contract Seniority level: Junior 1 to 2 years Job Description: Hoy les traigo una nueva búsqueda de trabajo remoto y pago en euros para el mercado europeo!!! Empresa dedicada a la automatización y robotización de procesos, busca :heavy_check_mark:Programadores expertos en #Uipath Son requisitos poseer formación universitaria tecnológic…

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 5 likes!

Date Column in Excel based DataTable UiPath

Hi @Neal369 , Try to read your file with Preserve Format enabled as shown in below screenshot, [image] and let us know.

This solution provided by @mark.eseo received 2 likes!

How to set up web scraping for each page when the "next page" button is different for each page?

Thanks - Try using Check app state activity. Output: Result - Indicates if the element exists or not. The field supports only Boolean variables. Optionally, you can save this value (True/False) for later use, or save it in a cell in a parent Excel file or the Project Notebook. Check if the next page elements exists if it exist then click it Else check other elements to go to next topic (skip quiz or skip assignment) if those exist then click it. [image]

This solution provided by @supermanPunch received 2 likes!

Date format-01

Hi @Kuldeep_Pandey , If the interest is only with the String Representation and if no need to store the values as Date type, then you could check the below Expression : Now.ToString("01.MM.yyyy")+" to "+Now.AddDays(-1).tostring("dd.MM.yyyy")

---

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

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

[system]

Daily Forum Report | 11 March 2023

Top 3 Topics with Most Views

How to get current date count row by row made by @Raja.G with 47 views.

Server Monitoring using UiPath made by @Prasanna_Venkat with 43 views.

Open browser is taking time made by @pushkar.singh with 41 views.

Top 3 Topics with Most Replies

How to get current date count row by row made by @Raja.G with 26 replies.

Extract data from pdf and save to CSV made by @Luca09 with 15 replies.

Open browser is taking time made by @pushkar.singh with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 32 posts!

@ABHIMANYU_THITE1 made 22 posts!

@Raja.G made 15 posts!

Top 3 Most Liked Posts

This post made by @companir received 2 likes!

Getting ui-rel-001 and ui-dbp-006 errors on my Uipath studio Community edition 2023.2.0. Need help resolving them

Thanks. It works!

This post made by @Anil_G received 2 likes!

Server Monitoring using UiPath

@Prasanna_Venkat As per the official documentation it says we can use it for different computers that are present on the same network…if they are from differnet networks then it is not possible [image] This is how you can check the remote server of same network [image] Hope this helps Cheers

This post made by @Suraj_B_Shetty received 2 likes!

How to get current date count row by row

Hi @Raja.G Check this workflow. DateCount.xaml (11.0 KB) Hope this helps

Top 3 Most Liked Solutions

This solution provided by @Laura_Ringiene received 1 likes!

Download Email Attachments

The only way to save the documents was by using the While loop and moving the documents from one directory to another. [image] Applying For Each failed. I specified ILocalResource, but item was recognized again as a list. I think I am not learning something yet.

This solution provided by @Suraj_B_Shetty received 1 likes!

How to get current date count row by row

Hi @Raja.G Check this workflow. It matches your requirement. DateCount.xaml (14.9 KB) Hope this helps.

---

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

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

[system]

Daily Forum Report | 12 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.