Forum Engagement Daily Reports

[system]

Daily Forum Report | 01 April 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@arjunshenoy made 13 posts!

@supermanPunch made 10 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 1 likes!

Deskew library for document image processing

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

This post made by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

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

This post made by @supermanPunch received 1 likes!

Insert data in queue with Bulk add Queue items error

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

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

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

This solution provided by @Anil_G received 1 likes!

CurrentRow properties

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

---

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

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

[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.

[system]

Daily Forum Report | 07 April 2023

Top 3 Topics with Most Views

Slow Performance with Each Transaction made by @Pankaj_J with 43 views.

Copy last sheet everytime in Excel made by @Joshua_Ducao with 37 views.

Help with writing values from one data table to another Data table made by @Mchande with 36 views.

Top 3 Topics with Most Replies

How can add Column After Or Before Specific Column made by @anh.nguyen with 16 replies.

Help with writing values from one data table to another Data table made by @Mchande with 16 replies.

Slow Performance with Each Transaction made by @Pankaj_J with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@Nitya1 made 30 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

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

How to upload the excel input to the Mssql DB

Hi @Vrishchik , The error message suggests that there is a mismatch between the columns in your DataTable and the column data types in your database table. To resolve this issue, you can try the following steps: -Check the data types of the columns in your DataTable and make sure they match the column data types in your database table. If they do not match, you may need to convert the data in your DataTable to match the data types in your database table. -Make sure that the number of columns …

This post made by @Anil_G received 2 likes!

What is my UiPath version ? / what is difference?

@Hyde The bottom one looks like an old orchestrator…is it on prem orchestrator? Mostly that is an enterprise license as you can see the license code on the top…for enterprise only we would have that displayed See orchestrator is something that is like a place where you can manage things…once you create an account…which ever license it is you will have orchestrator available for you…but depending on the license that you use…different options on orchestrator are available… Example.community ver…

This post made by @Anil_G received 2 likes!

What is my UiPath version ? / what is difference?

@Hyde If you see at the top of your scren …you can see that your plan is community version… Community version is for learning purposes and to use them for building knowledge… here you cannot control upgrades Free plan does not have studio license and only studio x can be used If enterprise license is present then you would have more capabilities and support from UiPath team and etc…this is suitable for production runs and for actually using the products…upgrades and all can be controlled her…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

What is my UiPath version ? / what is difference?

@Hyde The bottom one looks like an old orchestrator…is it on prem orchestrator? Mostly that is an enterprise license as you can see the license code on the top…for enterprise only we would have that displayed See orchestrator is something that is like a place where you can manage things…once you create an account…which ever license it is you will have orchestrator available for you…but depending on the license that you use…different options on orchestrator are available… Example.community ver…

This solution provided by @Yoichi received 2 likes!

How can add Column After Or Before Specific Column

Hi, The following is a sample which add new column before another column named “colX”. Hope this helps you [image] Sample20230407-8L.zip (4.8 KB) Regards,

This solution provided by @Nitya1 received 1 likes!

Check isGreater and IsEqual and isLesser from in a string

Hi @Muhammad_Anas_Baloch To check if the Duration of residence (n) is less than 10 or not, you can use the following steps: Use the Matches activity to extract the numerical value from the string using a regular expression. For example, for the string “Duration of residence <10”, you can use the regular expression “\d+” to extract the number 10. Convert the extracted numerical value to an integer using the CInt function. Check if the integer is less than 10 using a simple If condition. If it …

---

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

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

[system]

Daily Forum Report | 08 April 2023

Top 3 Topics with Most Views

Error Problem please anyone tell me the solution made by @gpkraju.alluri with 48 views.

Problems with base64 decoding made by @rpa.cresmin with 40 views.

I don't understand what to write in the condition made by @sazonov038 with 38 views.

Top 3 Topics with Most Replies

Need help on making existing folderpaths in .xls column as clickable in uipath made by @r0818 with 17 replies.

I want to use mouse scroll functionality made by @Bhushan_Nagaonkar with 10 replies.

How to Find First Null Value in a row in Datatable? made by @Hammadul_Haque with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@jackie.yue made 10 posts!

@Harshith_Adyanthaya made 9 posts!

Top 3 Most Liked Posts

This post made by @Harshith_Adyanthaya received 3 likes!

How to open particular Excel Sheet

Hi @Muhammad_Anas_Baloch , You can use Excel Application Scope, with Visible property checked. In this case the excel will open. Later you can close it using close workbook activity. [image] Or In Modern activities, you can use Use Excel File activity inside Excel Process Scope and make show excel window property of Excel Process Scope activity to True. [image] Hope it helps.

This post made by @Pavanraj_Shetty received 2 likes!

HTML Email Body

Hi @Farah_halawani Try this Hope this might help you

This post made by @Harshith_Adyanthaya received 2 likes!

How to Add Particular Column values in excel dynamically?

Hi @Vaishnav_Tej , FindSum= (from r in inputDT.AsEnumerable where Double.TryParse(r.Item(“ColName”).ToString,Nothing)=True).Sum(Function(x) cdbl(x(“ColName”).ToString)) Hope this helps.

Top 3 Most Liked Solutions

This solution provided by @Harshith_Adyanthaya received 3 likes!

How to open particular Excel Sheet

Hi @Muhammad_Anas_Baloch , You can use Excel Application Scope, with Visible property checked. In this case the excel will open. Later you can close it using close workbook activity. [image] Or In Modern activities, you can use Use Excel File activity inside Excel Process Scope and make show excel window property of Excel Process Scope activity to True. [image] Hope it helps.

This solution provided by @Anil_G received 2 likes!

How to group by multiple columns and Sum

@anh.nguyen Please use this in Assign and change column names as you need First use a build datatable activity and then create the required group columns and sum columns and give dtoutput in datatable field dtoutput = (From d In dtinput.AsEnumerable() Group d By k1=d(1).toString.Trim,k2=d(2).toString.Trim,k3=d(3).toString.Trim,k4=d(4).toString.Trim Into grp = Group Let sum1 = grp.sum(function(x) cdbl(x("Column1"))).ToString Let sum2 = grp.sum(function(x) cdbl(x("Column2"))).ToString Let sum…

This solution provided by @Harshith_Adyanthaya received 2 likes!

Get the Hours and minutes of the system's current time

Hi @jackie.yue , DateTime.Now.Tostring(“HH:mm”) Check this. Hope it 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 | 09 April 2023

Top 3 Topics with Most Views

I faced this issue please teel me resolution made by @rajuvadlakonda7272 with 47 views.

Need Solution - challenge with Extract Datatable made by @TAL_TAL with 38 views.

Formating in to date time made by @satish.rathi59 with 37 views.

Top 3 Topics with Most Replies

Read range work makes an error made by @ani_panch with 14 replies.

Formating in to date time made by @satish.rathi59 with 12 replies.

How to Display in textbox the last sheet in excel if we use get workbook sheets activity made by @Joshua_Ducao with 8 replies.

Top 3 Users Who Posted The Most

@Harshith_Adyanthaya made 22 posts!

@Anil_G made 20 posts!

@ani_panch made 13 posts!

Top 3 Most Liked Posts

This post made by @Jennifer_Serrao received 5 likes!

[오류대처문의] Main.xaml: (2) : error BC30652: 'IXmlSerializable' 형식을 포함하는 'System.Xml.ReaderWriter, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' 어셈블리에 대한 참조를 찾을 수 없습니다. 프로젝트에 추가하세요

안녕하세요 @crpark2486 읽기 범위 활동을 사용하고 있으므로 시트는 “Datatable” 내부를 읽고 저장합니다. 따라서 데이터 테이블에서 데이터를 가져오려면 "데이터 테이블의 각 행에 대해"를 사용해야 합니다. 아래 스크린샷을 참조하세요. 감사합니다! [image] 원하는 출력을 얻고 있는지 알려주십시오.

This post made by @Manish540 received 4 likes!

Kill procss of Excel

Hi @jackie.yue , Pass the “excel” as ProcessName as shown in below screenshot, [image] And let us know if its working for you?

This post made by @Manish540 received 3 likes!

Formating in to date time

Hi @satish.rathi59 , Check this below codes, firstDate(DateTime as type) = System.DateTime.ParseExact("08/Apr/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InvariantCulture) endDate(DateTime as type) = System.DateTime.ParseExact("09/May/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InvariantCulture) totalDays(Int32 as type) = (endDate-firstDate).TotalDays Screenshot: [image] Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @Jennifer_Serrao received 5 likes!

[오류대처문의] Main.xaml: (2) : error BC30652: 'IXmlSerializable' 형식을 포함하는 'System.Xml.ReaderWriter, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' 어셈블리에 대한 참조를 찾을 수 없습니다. 프로젝트에 추가하세요

안녕하세요 @crpark2486 읽기 범위 활동을 사용하고 있으므로 시트는 “Datatable” 내부를 읽고 저장합니다. 따라서 데이터 테이블에서 데이터를 가져오려면 "데이터 테이블의 각 행에 대해"를 사용해야 합니다. 아래 스크린샷을 참조하세요. 감사합니다! [image] 원하는 출력을 얻고 있는지 알려주십시오.

This solution provided by @Manish540 received 4 likes!

Kill procss of Excel

Hi @jackie.yue , Pass the “excel” as ProcessName as shown in below screenshot, [image] And let us know if its working for you?

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

Can set variables while adding values to FormFieldsCollection

@ani_panch , You have to create a variable there first in order to use it, try creating the invoiceNumber variable of type int32 and then using it. [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 | 10 April 2023

Top 3 Topics with Most Views

Compare one by one cell value from 2 sheet made by @anh.nguyen with 47 views.

Remove duplicates from two columns made by @Jnanesh_Ballal with 39 views.

PDF made by @vidhya_s1 with 39 views.

Top 3 Topics with Most Replies

How to make orchestrator API calls? made by @Ana_Patricia with 18 replies.

How to open CMD with administration rights? made by @Muhammad_Anas_Baloch with 14 replies.

Remove the all the text after second (-) character from a string made by @smrutismita.samal with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 64 posts!

@arjunshenoy made 30 posts!

@Harshith_Adyanthaya made 29 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Tutorial: OpenAI Integration Service Connector - Getting Started

Hello Community! Here’s a new video that takes a quick swing at the Preview version of the UiPath OpenAI Integration Service connector. I’ve also shared some of work in the downloads that’s linked in the video description below including the use of core OpenAI APIs and the tiktoken APIs using Python. The video track covers the following: 00:00 - Intro 00:17 - PROLOGUE 03:52 - Connector Setup in Integration Service 05:09 - Using the OpenAI Connector in UiPath Studio 13:06 - Reading the GPT-3…

This post made by @Saahil08 received 2 likes!

Send exception mail once 3 retry from queue has been exhausted

I was searching for this solution but could not find it on forum so I have solved it and putting the solution. So we have use the transactionitem.retyno or we can assign transactionitem.retryno to retry number variable In process workflow in catch exception block we can use if condition and put like transactionitem.retryno>=3 in case if you have put max retry as 3 in queue this will solve the problem and once condition is satisfied you can send the exception mails to client

This post made by @andrei.lazar received 2 likes!

I want my Dark/Light themes back!

Hey everyone, Background We have recently switched over to using the Cloud Orchestrator and where we previously had two separate servers, one for DEV and one for PROD, we now have on Organization and the DEV/PROD split is done at Tenant level. I used to have a system, to instantly tell what instance of Orchestrator I am on, namely, the dark/white themes. I used one for DEV, and one for PROD. Life was beautiful! Now that we switched over, we have 12(I think) col…

Top 3 Most Liked Solutions

This solution provided by @Harshith_Adyanthaya received 2 likes!

Data table columns

Hi @A_Learner , Try this. dt1.columns(0).ColumnName = dt1.columns(0).ColumnName,Replace(" “,”") where 0 is a first column index. If you want to do for all then, Pull a for each and perform the following. [image] Hope it helps.

This solution provided by @Yoichi received 2 likes!

Need help to split list of dates into array based on character length

FYI, another expression: arrDateStr = Enumerable.Range(0,strData.Length \ 16).Select(Function(i) String.Join("",strData.Skip(i*16).Take(16))).ToArray() Regards,

This solution provided by @Harshith_Adyanthaya received 2 likes!

How to read multiple excel sheets

Hi @singh_sumit , Use Get workbook sheets activity. It will return all the Sheet names in List of String. You can then use for each to loop and read each sheet. [image] Try this. Hope it 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 | 11 April 2023

Top 3 Topics with Most Views

How to add a space in a string? made by @Kumar_Sahu_Sameer with 51 views.

How to set or replace "check app state" so the studiox knows when to continue made by @marcin.chowaniec with 51 views.

Deleting empty rows made by @uiStijn with 45 views.

Top 3 Topics with Most Replies

How to set or replace "check app state" so the studiox knows when to continue made by @marcin.chowaniec with 21 replies.

I want click on Checkbox if the status is blank made by @Bhushan_Nagaonkar with 14 replies.

exception.Sourceをトライキャッチの中で使用してもファイルがみつかりませんでエラーとなる件 made by @yukiyuki with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@ppr made 20 posts!

@arjunshenoy made 17 posts!

Top 3 Most Liked Posts

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

How to add a space in a string?

Hi @Kumar_Sahu_Sameer , Use the following expression system.Text.RegularExpressions.Regex.Replace(“APRIL2022”,“(?=\d{4})”," ") [image] Regards,

This post made by @zell12 received 3 likes!

UiPath Tutorial: OpenAI Integration Service Connector - Getting Started

Hi @AndyMenon, Thanks for sharing this content. It will definitely benefit users of this integration especially around practicing proper prompt engineering to conserve token usage. Although, looking at it in business automation angle leveraging UiPath, I believe single turn instructions with text completions (instructgpt/gpt3 models), that yields definite action paths from the workflow, would be most fitting for RPA use cases, as opposed to building conversational/chat based workflows. But stil…

This post made by @Pavanraj_Shetty received 3 likes!

How to close a particular tab in browser

Hi @tharaninatarajan1901 Try this [image] Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @Pavanraj_Shetty received 3 likes!

How to close a particular tab in browser

Hi @tharaninatarajan1901 Try this [image] Hope this might help you

This solution provided by @arjunshenoy received 2 likes!

How to convert string date to date

Hi @dhanu_lokhande If you are open to suggestions, here is another approach: DateTime.ParseExact(strValue2,"dd MMMM yyyy", Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy") Here, strValue2 = 22 september 2020 Output: [image] Hope this helps, Best Regards.

This solution provided by @Thong_Mai_Tr_ng_Hoang received 2 likes!

Unable to Install new version

Hi All, I have found a solution to my issue. I do not have the previous installer nor does the new installer help to remove the old product so i have to manually remove all the UiPath stuff from the computer. For anyone who might need it, I’ll put the solution below: Try finding the old Product Code you might have installed before (Usually in the MSI log file) (e.i. “{CA94574A-9591-4278-9269-0F5FB01F***}”) Open regedit and look for the same Remove all of it from the regedit Remove all the Ui…

---

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

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

[system]

Daily Forum Report | 12 April 2023

Top 3 Topics with Most Views

Why we need Codedworkflows.cs file made by @pravin_bindage with 73 views.

How can I save attachment directly out of email with a new name (e.g. date of email)? made by @aaydin with 54 views.

Acme test app Arrrggghh! Disappearing dropdowns! made by @charliefik with 51 views.

Top 3 Topics with Most Replies

Why we need Codedworkflows.cs file made by @pravin_bindage with 24 replies.

Delete Specific Sheet From workbook made by @sharu_priya with 19 replies.

Webscrapping made by @RAKESH_KUMAR_Tiwari with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 44 posts!

@Harshith_Adyanthaya made 30 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 3 likes!

New Use cases for Practising

Hey @raju_alakuntla , For practice purpose you can try Bots DNA there are almost 20 tasks with the Requirement video and the input files. https://www.botsdna.com/ Regards,

This post made by @sarathi125 received 3 likes!

Upgrade on premises orchestrator from 2020 to 2022 version on premises

@TUSHAR_DIWASE, Migrating an on-premises UiPath Orchestrator requires careful planning and execution to ensure a smooth transition. Here is a checklist of tasks you should consider before and during the migration process: Before Migration: Review the system requirements for the new version of UiPath Orchestrator to ensure compatibility with your infrastructure. Create a backup of your existing Orchestrator database and configuration settings. Review and document any customizations or integra…

This post made by @Harshith_Adyanthaya received 3 likes!

Specific name format of a file

Hi @marcin.chowaniec , Try this: “mydirectory"+Datetime.Now.Tostring(“dd.MM.yyyy”)+” name “+Datetime.Now.Tostring(“htt”)+”.xlsx" Output: mydirectory\22.02.2023 name 1PM

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 3 likes!

New Use cases for Practising

Hey @raju_alakuntla , For practice purpose you can try Bots DNA there are almost 20 tasks with the Requirement video and the input files. https://www.botsdna.com/ Regards,

This solution provided by @sarathi125 received 3 likes!

Upgrade on premises orchestrator from 2020 to 2022 version on premises

@TUSHAR_DIWASE, Migrating an on-premises UiPath Orchestrator requires careful planning and execution to ensure a smooth transition. Here is a checklist of tasks you should consider before and during the migration process: Before Migration: Review the system requirements for the new version of UiPath Orchestrator to ensure compatibility with your infrastructure. Create a backup of your existing Orchestrator database and configuration settings. Review and document any customizations or integra…

This solution provided by @Harshith_Adyanthaya received 3 likes!

Specific name format of a file

Hi @marcin.chowaniec , Try this: “mydirectory"+Datetime.Now.Tostring(“dd.MM.yyyy”)+” name “+Datetime.Now.Tostring(“htt”)+”.xlsx" Output: mydirectory\22.02.2023 name 1PM

---

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

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

[system]

Daily Forum Report | 14 April 2023

Top 3 Topics with Most Views

Send email dynamically with attachments made by @RAKESH_KUMAR_Tiwari with 58 views.

Concatenate the string made by @Vrishchik with 44 views.

Can I trigger automations from my phone with UiPath Apps? made by @Luis_Fernando with 43 views.

Top 3 Topics with Most Replies

Send email dynamically with attachments made by @RAKESH_KUMAR_Tiwari with 27 replies.

Date format Change1 made by @Kuldeep_Pandey with 14 replies.

Opposite sing Excel made by @Kuldeep_Pandey with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@Yoichi made 30 posts!

@Kuldeep_Pandey made 17 posts!

Top 3 Most Liked Posts

This post made by @monika.singh received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi My name is Monika, Just started my journey as a RPA Developer. Glad to be a part of community.

This post made by @Anil_G received 2 likes!

How to replace row values of specific column in excel?

@Vaishnav_Tej Your replace function is correct…what you need to do is to perform this action in a for each row in datatable or for each excel row activities Inside ethat use curretrow("Column") = currentrow("Column").ToString.Replace("abc","") If abc is not constant then use regex as suggested by @arjunshenoy Cheers

This post made by @jack.chan received 2 likes!

Using VBA and file name excel variables

delete second assign in UiPath [image] then replace vba with this Sub Del_Rws(out_Str_input As String) Dim d As Object Dim a As Variant, b As Variant, itm As Variant Dim nc As Long, i As Long, k As Long Dim inputWb as Workbook Set inputWb = Workbooks.Open(out_Str_input) Dim fso As Object Set fso = VBA.CreateObject("Scripting.FileSystemObject") Dim fileName As String fileName = fso.GetFileName(out_Str_input) Sheet2.Range("A1:A1000").Formula = "='[" & fileName & "]PLHQ'!D20" Sheet2.Ran…

Top 3 Most Liked Solutions

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

Using VBA and file name excel variables

delete second assign in UiPath [image] then replace vba with this Sub Del_Rws(out_Str_input As String) Dim d As Object Dim a As Variant, b As Variant, itm As Variant Dim nc As Long, i As Long, k As Long Dim inputWb as Workbook Set inputWb = Workbooks.Open(out_Str_input) Dim fso As Object Set fso = VBA.CreateObject("Scripting.FileSystemObject") Dim fileName As String fileName = fso.GetFileName(out_Str_input) Sheet2.Range("A1:A1000").Formula = "='[" & fileName & "]PLHQ'!D20" Sheet2.Ran…

This solution provided by @Yoichi received 1 likes!

Add elements from array to list

HI, Can you try to create instance of the list as the following. for example? [image] And it might be better to set scope Main. AppentCollection.zip (55.4 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Help with activites and sequence

@Ricchch Use get outlook mail message in the folder give the foler path like "Inbox\Business\Projects\Ananke" It has a filte rproperty where jet or dasl queries can be used 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 | 15 April 2023

Top 3 Topics with Most Views

Attach a dynamic filename to outlook mail activity made by @John_Aquino with 44 views.

How to send Excel file on mail via SMTP made by @Muhammad_Anas_Baloch with 43 views.

How to run MSAccess tab from UiPath? made by @Ritesh_Burman with 40 views.

Top 3 Topics with Most Replies

StudioX Won't Run Basic Automation Past "Checking for Validation Errors" made by @derek.storm-larsen with 11 replies.

How to add url as hyperlink to the variable made by @Mohammed_Umar_Farooq with 9 replies.

Attach a dynamic filename to outlook mail activity made by @John_Aquino with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@Nitya1 made 15 posts!

@arjunshenoy made 6 posts!

Top 3 Most Liked Posts

This post made by @Joe_Matuch received 1 likes!

Concatenate Cron Expressions in a Trigger

Thanks, @TimK and @Nitya1 . That’s what I suspected. There are advantages to keeping the weekday and weekend triggers separate, anyway, in case we need to turn one set off for an extended time. In the meantime, we discovered that we could combine the weekday triggers for all 20 Bots by pairing up the Bots and VDIs in the section where you allocate hostnames. Again, there are pros and cons to having them all on a single trigger. On the one hand, a single trigger is less work to configure; on the…

This post made by @Nitya1 received 1 likes!

Concatenate Cron Expressions in a Trigger

Hi @Joe_Matuch Unfortunately, there is no way to concatenate two Cron expressions within a single Trigger in UiPath Orchestrator. Each Trigger can only have a single Cron expression. To achieve the desired functionality, you will need to create new Triggers for the weekend times. You can create 20 new Triggers with the following Cron expression: 0 0,15,30,45 1-15 ? * 1,7 This Cron expression will trigger the bots every 15 minutes from 1AM to 3:45PM every Saturday and Sunday. I hope it helps…

This post made by @Arijit_Sarkar received 1 likes!

Need Help with Extract PDF Pages

Appreciate your help! Thanks for sharing the knowledge!!!

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 1 likes!

Concatenate Cron Expressions in a Trigger

Hi @Joe_Matuch Unfortunately, there is no way to concatenate two Cron expressions within a single Trigger in UiPath Orchestrator. Each Trigger can only have a single Cron expression. To achieve the desired functionality, you will need to create new Triggers for the weekend times. You can create 20 new Triggers with the following Cron expression: 0 0,15,30,45 1-15 ? * 1,7 This Cron expression will trigger the bots every 15 minutes from 1AM to 3:45PM every Saturday and Sunday. I hope it helps…

This solution provided by @arjunshenoy received 1 likes!

Ui path - Expressions Cheatsheet or website for various scenarios

Hi @devanand.1292 The following playlists might help you with this. System.DateTime - [UiPath VB.Net Complete Tutorial (System DateTime)] LinQ - File Management - Datatable Operations - Hope this helps, Best Regards.

This solution provided by @Anil_G received 1 likes!

How to send Excel file on mail via SMTP

@Muhammad_Anas_Baloch If you are using gmail for smtp…first you should not be using your normal email password …you need to generate application password and use it…it needs to be enabled and to be retrieved from gmail settings page.please check this for detailed settings instructions https://docs.uipath.com/installation-and-upgrade/docs/studio-enabling-gmail-for-email-activities 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 | 16 April 2023

Top 3 Topics with Most Views

Adding final remarks column on the output file made by @Praveen_Vs with 49 views.

Object reference not set to an instance of an object - New Proyect made by @will.valverde with 43 views.

Citrix environment, switching between bowser and UiPath made by @rathi.sham with 43 views.

Top 3 Topics with Most Replies

Folder name change (폴더 이름 동적으로 바꾸기+해결 완료) made by @sooyeon_Lim with 13 replies.

How to use variable in select item? made by @Cuberoot with 10 replies.

Selection warning made by @jackie.yue with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 27 posts!

@Nitya1 made 15 posts!

@RAKESH_KUMAR_Tiwari made 14 posts!

Top 3 Most Liked Posts

This post made by @NutchanonSwnl received 2 likes!

Matches Activity Missing in UiPath.System.Activities v23.4.2 Package

Hello @Arijit_Sarkar i think they changed activity name at System v23.4.2 version you can see at picture below [image] Type and output type are still same. but i’m not totally sure about this

This post made by @Anil_G received 1 likes!

UiPath for GUI test

@Joao_Martins Welcome to the community You can write test cases from studio anf test license enables you to run test cases on robot.you have one on community [image] https://docs.uipath.com/automation-cloud/automation-cloud/latest/admin-guide/about-licensing Cheers

This post made by @Srini84 received 1 likes!

UiPath for GUI test

Hi @Joao_Martins To enable the Test Manager in Community Edition Go to cloud.uipath.com → Go to Admin Tab->Click on the Tenant you named Now click on the Services->Click Add Services-> There you will see the TestManger->Enable that and you are able to see Hope this may help you Thanks, Srini

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

UiPath for GUI test

Hi @Joao_Martins To enable the Test Manager in Community Edition Go to cloud.uipath.com → Go to Admin Tab->Click on the Tenant you named Now click on the Services->Click Add Services-> There you will see the TestManger->Enable that and you are able to see Hope this may help you Thanks, Srini

This solution provided by @Anil_G received 1 likes!

Selector Attribute Exact Match

@himanshu_punj1 In selector try regex match aastate = ‘^focusable$’ matching:aastate=‘regex’ Cheers

This solution provided by @arjunshenoy received 1 likes!

Folder name change (폴더 이름 동적으로 바꾸기+해결 완료)

@sooyeon_Lim 내부 폴더는 동적 이름을 가질 수 있으며 폴더 4k stogram의 전체 경로를 사용하여 동일한 이름을 변경할 수 있습니다. Directory.GetDirectories(“4K Stogram Path”)를 사용하여 그 안의 폴더 배열을 가져오고 첫 번째 폴더의 이름을 바꿉니다(이미 언급했듯이 항상 1개의 폴더만 있음). ~ 전에 [image] ~ 후에 [image] 작업 흐름 [image] 메모: 말씀하신 대로 4K Stogram 폴더에는 항상 1개의 하위 폴더만 있어야 합니다. 실행 중에는 파일이나 폴더를 열어두지 마십시오. 그렇지 않으면 오류가 발생합니다. 도움이 되었기를 바랍니다.

---

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

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

[system]

Daily Forum Report | 17 April 2023

Top 3 Topics with Most Views

Unable to find package 'Microsoft.Graph.GraphServiceClient' is not defined made by @Steven_McKeering with 46 views.

Reset Password on every 45 days made by @suganya1 with 42 views.

Remove \ from deserialized json string made by @niro with 41 views.

Top 3 Topics with Most Replies

FilterDataTable-the value for argument 'Column Name' is not set or is invalid made by @sharu_priya with 18 replies.

How to convert variable e made by @Suraj_Gaikwad_Nuvama_Grou with 14 replies.

If RDP-Machine is Disconnected means Orchestrator jobs goes to Pending state made by @Vicky_K with 13 replies.

Top 3 Users Who Posted The Most

@Srini84 made 28 posts!

@Anil_G made 27 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @yikwen.goo received 2 likes!

How to Print colors in data table cell in outlook mail

Try background-color:rgb(255, 0, 0); where the 255 / 0 /0 are your individual RGB numbers. Example: "<table><tr><td style=background-color:rgb(255,0,0);>Test Number</td><td style=background-color:rgb(0,255,0);>abcde</td></tr></table>" [image]

This post made by @miwa_yamamoto received 2 likes!

ブラウザーを開く：ブラウザーと通信できません。UiPath拡張機能をご確認ください。

ありがとうございます。 Edge を開き、edge://extensions に移動し、 出てきた拡張機能をONにすると、動き出しました。 本当にありがとうございました。

This post made by @sharu_priya received 2 likes!

FilterDataTable-the value for argument 'Column Name' is not set or is invalid

@vishal.kp and @Gokul_Jayakumar . Thanks much for your time. Instead of contains i tried giving “=” since it is an integer

Top 3 Most Liked Solutions

This solution provided by @yikwen.goo received 2 likes!

How to Print colors in data table cell in outlook mail

Try background-color:rgb(255, 0, 0); where the 255 / 0 /0 are your individual RGB numbers. Example: "<table><tr><td style=background-color:rgb(255,0,0);>Test Number</td><td style=background-color:rgb(0,255,0);>abcde</td></tr></table>" [image]

This solution provided by @Anil_G received 1 likes!

Possible to Pass Arguments Between Projects?

@astockman You can leverage orchestrator assets to do that… From receiver add data to asset and in sender get it Set asset and get asset can be use If the datatypes are complete then use a shared location and a file to pass info or serialize the varaibles and then add to asset and then deserialize again Cheers

This solution provided by @Yoichi received 1 likes!

ブラウザーを開く：ブラウザーと通信できません。UiPath拡張機能をご確認ください。

こんにちは Edgeでしたら以下になります。 https://docs.uipath.com/ja/studio/standalone/2022.10/user-guide/microsoft-edge-extension-troubleshooting

---

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

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

[system]

Daily Forum Report | 18 April 2023

Top 3 Topics with Most Views

Compare column values from two different excel sheets and highlight the matching column values with green made by @dutta.marina with 60 views.

Split excel record made by @pravin_bindage with 59 views.

Text extraction based on Regex made by @Midhila_Gurram with 52 views.

Top 3 Topics with Most Replies

Compare column values from two different excel sheets and highlight the matching column values with green made by @dutta.marina with 21 replies.

Split excel record made by @pravin_bindage with 14 replies.

Powershell呼び出し made by @windntmd with 12 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 26 posts!

@Yoichi made 18 posts!

@Srini84 made 17 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

Date conversion topic

Hey @duaine.b , Try this DateTime.ParseExact("Thu 10 Nov 2022", "ddd dd MMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy") Output : [image] Note : Output Value is of type String Regards,

This post made by @Srini84 received 2 likes!

DATASET VARIABLE

Hi @Aki1111 Dim selectedData As DataTable = myDataset.Tables("myTable").DefaultView.ToTable(False, columnsToSelect) Try in above way Hope this may help you Thanks, Srini

This post made by @Yoichi received 2 likes!

Need Regex Range Number Excel

Hi, Can you try to modify your expression in the InvokeCode activity as the following? row("Extracted Data") = System.Text.RegularExpressions.Regex.Match(row(0).ToString,“([A-Z]{4})([0-9]{6})([0-9]{1})”).Value.Insert(10,"-").Insert(4," ") The following is result of the above. [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

Date conversion topic

Hey @duaine.b , Try this DateTime.ParseExact("Thu 10 Nov 2022", "ddd dd MMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy") Output : [image] Note : Output Value is of type String Regards,

This solution provided by @Yoichi received 2 likes!

Need Regex Range Number Excel

Hi, Can you try to modify your expression in the InvokeCode activity as the following? row("Extracted Data") = System.Text.RegularExpressions.Regex.Match(row(0).ToString,“([A-Z]{4})([0-9]{6})([0-9]{1})”).Value.Insert(10,"-").Insert(4," ") The following is result of the above. [image] Regards,

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

Custom Sort Multiple Columns

Hi @Md_Hidayat , Refer to the following thread, it explains the sorting of data table based on multiple columns. 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 | 19 April 2023

Top 3 Topics with Most Views

Plz help me made by @katta_nikhil with 61 views.

Extract file name from the path made by @vinjam_likitha with 55 views.

Integration of Microsoft Teams with UiPath made by @Rajneesh_Kumar with 54 views.

Top 3 Topics with Most Replies

Validation error --- made by @Aki1111 with 23 replies.

Text Extract made by @Swetha_MN with 13 replies.

After switching to StudioX loss the profile change option from setting menu and can not go back to Studio made by @Latif with 12 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 45 posts!

@vishal.kp made 19 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 5 likes!

Plz help me

@katta_nikhil , Right("YourVariable".Replace("-",""),10) Output : [image] Regards,

This post made by @Gokul_Jayakumar received 2 likes!

Plz help me

@katta_nikhil Also, Try regex replace System.Text.RegularExpressions.Regex.Replace(YourString,"^\+91|^0|-","").Tostring.Trim [image] [image]

This post made by @supermanPunch received 2 likes!

How to Filter Datatable with Multiple Arrays

Hi @benjiherb , Maybe you could try the below expression : FilteredDt = OriginalDt.AsEnumerable.Where(function (x) Array1.Any(function(y) x("ColumnA").ToString.Contains(y)) orElse Array2.Any(function(y) x("ColumnA").ToString.Contains(y)) orElse Array3.Any(function(y) x("ColumnB").ToString.Contains(y))).CopyToDatatable

Top 3 Most Liked Solutions

This solution provided by @Gokul_Jayakumar received 2 likes!

Plz help me

@katta_nikhil Also, Try regex replace System.Text.RegularExpressions.Regex.Replace(YourString,"^\+91|^0|-","").Tostring.Trim [image] [image]

This solution provided by @Jennifer_Serrao received 2 likes!

Trigger use case

Hey @vishal_nachankar , While adding the trigger in the Orchestrator, Please select “advanced” option Put this cron Expresion in cron expression 0 30 6,8,10,12,14 ? * * * [image] It will trigger at 6.30AM,8.30AM,10.30AM,12.30AM,2.30PM Everyday Regards,

This solution provided by @Yoichi received 2 likes!

Split & Join List using Regex

Hi, How about the following? listStr = listStr.SelectMany(Function(s) System.Text.RegularExpressions.Regex.Replace(s,"[^A-Za-z0-9 ]","").Split({" "c})).ToList [image] Sample20230419-2aL.zip (2.4 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.

[system]

Daily Forum Report | 20 April 2023

Top 3 Topics with Most Views

How to move latest pdf files made by @Suraj_Gaikwad_Nuvama_Grou with 57 views.

Dynamic way to read latest text file made by @Priyesh_Shetty1 with 48 views.

How both dates matching or not made by @Sanket_RPA with 47 views.

Top 3 Topics with Most Replies

I value matches with variable click link in another column made by @MEGHA_cs with 22 replies.

How do i read a specific column in web and click on the hyperlink to download the files? made by @monicaong0609 with 22 replies.

How to move latest pdf files made by @Suraj_Gaikwad_Nuvama_Grou with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 72 posts!

@Srini84 made 38 posts!

@supermanPunch made 34 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How to parse data?

@ani_panch , USe a for each row activity for the input excel and inside the Loop 2. Use assign activity and provide RequiredValue= Split(CurrentRow("paid").ToString,"Paid")(1) Then you can type into the output USD 528.00 Regards,

This post made by @Jithesh_R received 3 likes!

https://botsdna.com/MeeSevaContacts/

@Sohil_bagwan1 , 1.Using Find Children I have got all the Persons Details One By one 2. In that for each loop of children am adding all those details into a list 3.Then again Using For each loop for that list am doing the rest of the Actions 4.You can see in the Type Into (Selector)I have passed the “Code” as dynamic variable (ColName ) I hope this will help you Regards,

This post made by @Jithesh_R received 3 likes!

How to move latest pdf files

@Suraj_Gaikwad_Nuvama_Grou , Did you try with that? Is it working fine now?

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How to parse data?

@ani_panch , USe a for each row activity for the input excel and inside the Loop 2. Use assign activity and provide RequiredValue= Split(CurrentRow("paid").ToString,"Paid")(1) Then you can type into the output USD 528.00 Regards,

This solution provided by @Jithesh_R received 3 likes!

https://botsdna.com/MeeSevaContacts/

@Sohil_bagwan1 , 1.Using Find Children I have got all the Persons Details One By one 2. In that for each loop of children am adding all those details into a list 3.Then again Using For each loop for that list am doing the rest of the Actions 4.You can see in the Type Into (Selector)I have passed the “Code” as dynamic variable (ColName ) I hope this will help you Regards,

This solution provided by @Jithesh_R received 3 likes!

How to move latest pdf files

@Suraj_Gaikwad_Nuvama_Grou , Did you try with that? Is it working fine now?

---

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

Top 3 Topics with Most Views

Need linq query for multiple filter made by @RAKESH_KUMAR_Tiwari with 64 views.

Syntax result in string for List array of string with Invoke Method Add made by @YangYang with 56 views.

Update ServiceNow Record made by @gary.cobden with 54 views.

Top 3 Topics with Most Replies

Need linq query for multiple filter made by @RAKESH_KUMAR_Tiwari with 27 replies.

Compare Excel files to get matching rows based on a specific column made by @MEGHA_cs with 22 replies.

How to check the queue item based on the condition? made by @Vrishchik with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 79 posts!

@Srini84 made 34 posts!

@supermanPunch made 23 posts!

Top 3 Most Liked Posts

This post made by @Ricchch received 2 likes!

Saving an excel with one extension type to another type

Thank you to all, I will work on that today… and then i come back to you . really appreciated your advices. Ric

This post made by @marian.platonov received 2 likes!

Python Scope: Error initializing Python engine - Can't RUn python script

If you are using Python 3.11.x it will not work in UiPath Studio at this moment. I tested with a Python 3.10.10 64-bit and it is working. In order to check your Python version, you can run in cmd.exe the python --version command.

This post made by @Anil_G received 2 likes!

LINQ query to extract lyperlinks from excel

@Ray_Sha1 Please try as @supermanPunch mentioned My bad that I just checked and I dont see url being extracted And you can try this formula as well =MID(FORMULATEXT(A2),13,FIND("""",FORMULATEXT(A2),13)-13) cheers

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

Python Scope: Error initializing Python engine - Can't RUn python script

If you are using Python 3.11.x it will not work in UiPath Studio at this moment. I tested with a Python 3.10.10 64-bit and it is working. In order to check your Python version, you can run in cmd.exe the python --version command.

This solution provided by @Yoichi received 1 likes!

How to convert EXCEL table?

Hi, How about the following? dtResult = dt.AsEnumerable.SelectMany(Function(r) Enumerable.Range(1,3).Select(Function(i) dtResult.LoadDataRow({"",r("Company"),r("Code")}.Concat( r("Employee ("+i.toString+")").ToString.Split({"/"c})).ToArray,False))).Where(Function(r) Not String.IsNullOrEmpty(r("Employee Name").ToString)).CopyToDataTable [image] Sample20230421-2Lv2.zip (21.2 KB) Regards,

This solution provided by @Anil_G received 1 likes!

How to get files from all duplicates folder name and then store al files in a new foder with the same name

@sagar.raval you can use variable in place of 3211…you can have whole of this inside a loop for each crn you have… your for each folder in folder will get each folder starting with 3211 or the crn …so if there are duplicates it would loop through those folders as well If you dont have those activities then use directory.GetDirectories("Folderpath","3211*") and directory.Getfiles(currentfolder) Both of the above expressions will give you array of strings/paths…use for each activity adn change…

---

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

Top 3 Topics with Most Views

Return From A Workflow made by @himanshu_punj1 with 48 views.

Regular expressions problmm made by @katta_nikhil with 45 views.

How to use SMTP for multiple emails made by @Muhammad_Anas_Baloch with 42 views.

Top 3 Topics with Most Replies

How to use SMTP for multiple emails made by @Muhammad_Anas_Baloch with 12 replies.

Return From A Workflow made by @himanshu_punj1 with 10 replies.

Iam anable to get the matched items made by @Shiva_Nikhil with 9 replies.

Top 3 Users Who Posted The Most

@Srini84 made 13 posts!

@Nitya1 made 11 posts!

@himanshu_punj1 made 11 posts!

Top 3 Most Liked Posts

This post made by @LAKSHMI_NARAYANA_PEMMASAN received 2 likes!

Return From A Workflow

as per your details it looks like the case needs to be marked as business exception if you are using REframework that will automatically handle the case , the only thing you need to do is returning the application to initial state to take up next case Regards

This post made by @Shiva_Nikhil received 2 likes!

Iam anable to get the matched items

Thanks alot Nitya

This post made by @himanshu_punj1 received 2 likes!

Add Log Text In Multiple Lines

Thanks, that’s an optimistic approach.

Top 3 Most Liked Solutions

This solution provided by @ushu received 1 likes!

Shortcut to Center Flow Chart Activities

Hi @himanshu_punj1 - I guess there is no direct method to do this. But click on the sequence and do, ctrl+RightArrow/LeftArrow to adjust the sequences/activities. To adjust the flow decission do the same thing, click/select it then do ctrl+RightArrow/LeftArrow

This solution provided by @Gokul_Jayakumar received 1 likes!

Regular expressions problmm

Hello @katta_nikhil Try this System.Text.RegularExpressions.Regex.Matches("YourString","[A-Za-z]+(?=\sMarklist)")(0).tostring.trim -----> SSC System.Text.RegularExpressions.Regex.Matches("YourString","[A-Za-z]+(?=\sMarklist)")(1).tostring.trim -----> Provision [image]

This solution provided by @null_null received 1 likes!

How to trigger a hotkey combination i have setup to start/stop screen recording?

Just to follow up, I figure out that you have to select Classic in the Activity Filters menu in order to see Send Hotkey activity. That activity is doing the trick, thanks for all the responses.

---

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.