Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 August 2023

Top 3 Topics with Most Views

Spliting the data within excel with regards policy number made by @ISBS_ROBOT with 56 views.

I want a method to achieve this made by @P-A-J with 55 views.

Scrape the data in a website made by @QUY_T_TAM_8.0_IELTS with 45 views.

Top 3 Topics with Most Replies

I want a method to achieve this made by @P-A-J with 24 replies.

For some reason, Read Range is not fetching the made by @sid04 with 18 replies.

Write cell excel activity made by @bhavana_kolli with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Nguyen_Van_Luong1 made 26 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @naveenkumarr received 2 likes!

Null values getting added to queue - Bulk add queue items

thanks @mkankatala and @lrtetala

This post made by @efelantti received 2 likes!

Table Extraction: Extract URLs

Seems like this is available in UiPath.UIAutomation.Activities = 22.4.10, but not in newer versions.

This post made by @Latifa received 2 likes!

Uploading queue items

Thanks a lot @Parvathy @lrtetala and @postwick

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Sub data table

we can group the data / split it to a list of datatables Assign Activity: TableList | DataType: List(Of DataTable) = (From d in Your DataTable.AsEnumerable Group d by k=d("num_chrono").toString.Trim into grp=Group Select t = grp.CopyToDataTable).toList

This solution provided by @tazunnisa.badavide received 1 likes!

Spliting the data within excel with regards policy number

Hey ! I have attached the workflow here ,Hope it might help You. Create Excel.xaml (10.8 KB)

This solution provided by @Yoichi received 1 likes!

I want a method to achieve this

I understand your points. How about the following? dt.AsEnumerable.GroupBy(Function(r) r("ID").ToString).OrderBy(Function(g) Cint(g.Key)).Select(Function(g) dt.Clone.LoadDataRow(new object(){g.Key}.Concat(Enumerable.Range(1,dt.Columns.Count-1).Select(Function(i) String.Concat(g.Select(Function(r) r(i).ToString)))).ToArray,False)).CopyToDataTable Sample20230816-3L (5).zip (15.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 | 17 August 2023

Top 3 Topics with Most Views

Linq For 2 datatables. Inserting datat from one datatable to another using one common column made by @yash.choursia with 57 views.

Last day of the month a Sunday? made by @anh.nguyen with 50 views.

Do not have "Open Application" made by @Hood_Blah with 49 views.

Top 3 Topics with Most Replies

Find no in for each row made by @Kuldeep_Pandey with 43 replies.

Linq For 2 datatables. Inserting datat from one datatable to another using one common column made by @yash.choursia with 39 replies.

Last day of the month a Sunday? made by @anh.nguyen with 19 replies.

Top 3 Users Who Posted The Most

@postwick made 55 posts!

@Shiva_Nikhil made 30 posts!

@Anil_G made 26 posts!

Top 3 Most Liked Posts

This post made by @Vikas_M received 3 likes!

How we can compare two sheets based on one reference column and get output in new sheet

Hey @Ajinya_jorwekar , Can you please mark the right post as solution such that it would help the community to access the answer easily Also it will motivate the users to answer and help others just like @Brian_Mathew_Maben did to you Thank you in advance

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

Get row value based on column value

new.xaml (11.8 KB) Hey I have attached the workflow here! hope it might help you!

This post made by @Vikas_M received 2 likes!

How to set an Array to empty/null

Hey @SRoyi , I assume u want to create an empty array u have to initialize [image]

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 2 likes!

How to set an Array to empty/null

Hey @SRoyi , I assume u want to create an empty array u have to initialize [image]

This solution provided by @ppr received 2 likes!

Parameter has already been declared for this method

can be done directly within an assign activity: myFileNameList = New DirectoryInfo("FolderPathOrVariable").GetFiles().Select(Function (x) x.Name).toList()

This solution provided by @Quenton_Wayne_Rebello received 1 likes!

Linq For 2 datatables. Inserting datat from one datatable to another using one common column

Hey @yash.choursia, Try the below xaml for the sheets you have sent. AddAbrievation.xaml (7.3 KB) Sheets: - Book123.xlsx (281.3 KB)

---

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

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

[system]

Daily Forum Report | 18 August 2023

Top 3 Topics with Most Views

Write range workbook activity sheet error made by @ISBS_ROBOT with 50 views.

Do not support SELECT ITEM Activity made by @dkngit55 with 48 views.

Please help me with Excel hyperlinks made by @22222222asas with 46 views.

Top 3 Topics with Most Replies

Do not support SELECT ITEM Activity made by @dkngit55 with 25 replies.

How to remove  character in multiple lines from data extracted made by @Harshita_Ramesh with 15 replies.

Please help me with Excel hyperlinks made by @22222222asas with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@ppr made 22 posts!

@Shiva_Nikhil made 21 posts!

Top 3 Most Liked Posts

This post made by @vkalra received 2 likes!

Please help me with Excel hyperlinks

did you check this?

This post made by @Vikas_M received 2 likes!

Read Range Error in Excel

Hey @ajnaraya , If the excel file is empty then The read range workbook activity throws an nullReference Exception So to handle this exception , please surround your read range activity using Try Catch activity Wrap the Read Range workbook activity like below screenshot [image] Hope it helps you out

This post made by @Mark007 received 2 likes!

Unattended Automation Works When I am Logged In but not when on Screen Lock

Hi @postwick @Anil_G I wanted to write back to you to confirm that after your guidance, I managed to get this working on my spare laptop as an unattended service with the robot logging in and logging out when it is finished. I’m really please I got over this hurdle and couldn’t have done it without your help. Thanks again for your support on this! Mark

Top 3 Most Liked Solutions

This solution provided by @neha.upase received 1 likes!

Double To String in specific format

Hi, Assign Activity: Start by storing your double value in a variable. Let’s say the variable name is doubleValue and it contains the value 1238.2. Assign Activity: Convert the doubleValue to the desired format using the ToString method with a specific format string. formattedString = doubleValue.ToString(“N2”, new CultureInfo(“fr-FR”)) + " (€)" N2: This specifies that the number should be formatted with a thousands separator and two decimal places. CultureInfo(“fr-FR”): This uses the Frenc…

This solution provided by @Anil_G received 1 likes!

Help me to only et the words after spesific numbers

@StevenIsRobotOnline First use this regex to get the value…the first matched value is what you need so use as below and then you can replace all special characters and spaces [A-Z]*[ \-,]*(?=\d{4}) System.Text.regularExpressions.Regex.Replace(System.Text.regularExpressions.Regex.Match(str,"[A-Z]*[ \-,]*(?=\d{4})").Value,"[^A-Z]","") [^A-Z] - this takes care of removing extra characters [image] Hope this helps cheers

This solution provided by @rlgandu received 1 likes!

I have a collection variable and i want to remove from the datatable

@sathish_Kumar6 Assign activity: dataTable = (From row In dataTable.AsEnumerable() Where Not listVariable.Contains(row(“Column_Name”).ToString()) Select row).CopyToDataTable()

---

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

Top 3 Topics with Most Views

Cant able to read Asset Value in Read range activity made by @Aswini_mano with 40 views.

Why is showing like that? made by @Neeraj_Gupta1 with 40 views.

Object refence not set to an instance of an object while Debugging itself made by @Sree_Krishnan_vellinezhi with 40 views.

Top 3 Topics with Most Replies

Error and Warnings found in REFramework_with_queues project made by @Federico_L with 28 replies.

Why is showing like that? made by @Neeraj_Gupta1 with 13 replies.

Object refence not set to an instance of an object while Debugging itself made by @Sree_Krishnan_vellinezhi with 13 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 25 posts!

@Anil_G made 22 posts!

@Praveen_Mudhiraj made 13 posts!

Top 3 Most Liked Posts

This post made by @Jeroen_van_Loon received 2 likes!

How do I get the id of a queue?

Read it in the URL of the orchestrator when you open a queue: https://cloud.uipath.com/ … /DefaultTenant/orchestrator_/monitoring/queues/833639?tid=xxxxxxx&fid=xxxxxxx If you use an on premise Orchestrator the URL is different of course, but the location of the queue ID the same. (Although most likely a lower number)

This post made by @PPIM_RPA received 1 likes!

Replace the last letter of each string in a datatable column

Hello, In dt, there is a column “Animals” How to replace the last letter of each item as such: cows, horses, skunks, pigs > cow(s), horse(s), skunk(s), pig(s)? Thank you

This post made by @Shiva_Nikhil received 1 likes!

Get Text in a Proper Format

hi @QUY_T_TAM_8.0_IELTS I am getting this output "Da Nang (DAD) → Ho C. M. City (SGN)Wed, 13 Sep 2023 " if you want any output from the above string we can extract

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

Get Text in a Proper Format

hi @QUY_T_TAM_8.0_IELTS I am getting this output "Da Nang (DAD) → Ho C. M. City (SGN)Wed, 13 Sep 2023 " if you want any output from the above string we can extract

This solution provided by @Parvathy received 1 likes!

Cant able to read Asset Value in Read range activity

Hi @Aswini_mano While giving the path in tha asset make sure you don’t give it in double quotes and just give only the path. Regards

This solution provided by @Anil_G received 1 likes!

How do I get the id of a queue?

@muehlbauer157 You can use orchestrator api…and use get queue definitions api…which will get you the id and the name as well Cheerd

---

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

Top 3 Topics with Most Views

How to check only if first row contains required values in DT made by @Sathish_Kumar_S with 42 views.

I am facing a problem after joining tables made by @P-A-J with 39 views.

Error in Connecting unattended bot made by @sathya_auto with 38 views.

Top 3 Topics with Most Replies

I am facing a problem after joining tables made by @P-A-J with 28 replies.

Remove particular rows using LINQ made by @Kira with 16 replies.

Replace Blank\Null values on datatable made by @Adi_Lupashko with 16 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 28 posts!

@postwick made 16 posts!

@Anil_G made 14 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Remove particular rows using LINQ

On first it depends on the mutually agreed skill sets of the development team, and how / if LINQ is allowed when there is no need to touch the left side (e.g. toupper, trim) then Filter DataTable can be used When there is a need to touch the left side (eg toupper, trim) then a data cleansing is needed or can be done directly within the LINQ (we have seen abover, toupper, trim). So it depends on other factors, when to use LINQ or not

This post made by @Shiva_Nikhil received 2 likes!

Hello, all I am new to linq

@Chirag12 Use it in assign activity Leftside Datatabke variable =datatablevar.asenumerable.orderby(Function(x) x(“columnName”)).CopyToDataTable

This post made by @Kira received 1 likes!

Remove particular rows using LINQ

@postwick , @ppr , @Vikas_M , @Shiva_Nikhil , @Dinesh_Guptil , @Praveen_Mudhiraj , Which one is better , Linq or Activities I know that these kind of tasks can be done using activities, But i wanted to know why LInq then? According to me, i feel like Linq is Better than activities Please enlighten me with your knowledge

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

Build an automation to display first 10 gmail inbox unread messages in message box

@Sai_Kumar_111 no need no mention any folder. you need to click on + button, it will display all the folders which you have in the mail [forum screenshot] [forum screenshot]

This solution provided by @Shiva_Nikhil received 1 likes!

How to check only if first row contains required values in DT

@Sathish_Kumar_S no you can directly use it in the if Condition [image]

This solution provided by @Vikas_M received 1 likes!

Making of questions

Hey @Conning , Keep the condition as below image, such that the cases (Capital or small) letters do not matter [image] Apart from these it would be great if you also trim the answer The Trim function is used to remove leading and trailing whitespace (spaces, tabs, newlines) from a string. This is particularly useful to clean up user inputs, as extra spaces can inadvertently affect comparisons and operation The ToLower (or ToLowercase ) function is used to convert all characters in a string …

---

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

Top 3 Topics with Most Views

How to append two data tables with out merge activity made by @vineelag with 54 views.

Want to split the pdf file basis on text name made by @Smitesh_Aher1 with 54 views.

Regular Expression help-Regex made by @rlgandu with 52 views.

Top 3 Topics with Most Replies

Png 형식 파일 OCR 추출 질문 made by @dongbinr56 with 28 replies.

Code to extract a specific text from a Get Attribute Variable made by @yeshwanth with 22 replies.

In RE Framework, I want to add row data in a Column of Data table in each Transaction made by @Ajinya_jorwekar with 16 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 45 posts!

@Shiva_Nikhil made 42 posts!

@Parvathy made 26 posts!

Top 3 Most Liked Posts

This post made by @ramcharan863 received 3 likes!

PDF TABLE EXTRACTION date

Hello @Nikhil_Katta Please follow these steps for your output System.Text.RegularExpressions.Regex.Match(str_Pdftext,“(?<=Approved From).(?=Number of Visits)“).Value.Trim System.Text.RegularExpressions.Regex.Match(str_Pdftext,”(?<=Number of Visits).”).Value.Trim.Split(" “c)(1) System.Text.RegularExpressions.Regex.Match(str_Pdftext,”(?<=Approved Thru).*(?=DME)").Value.Trim Happy Automation [image]

This post made by @Parvathy received 2 likes!

Png 형식 파일 OCR 추출 질문

Hi @dongbinr56 => Use Load image acitvity to load the image and store the output in a variable. => Use Tesseract OCR Engine and pass the variable. Stroe the output in text. => Use Write line or Message box to print the content. Hope it helps!!

This post made by @Nguyen_Van_Luong1 received 2 likes!

Png 형식 파일 OCR 추출 질문

Hi @dongbinr56 , To get text in image PNG, you can use OCR - Japanese, Chinese, Korean with korean character, I think it will correct, I tried it with japan text is ok [image] regards, LNV

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Find the second, third day (Monday) of every month, and of second day of 3,6,9,12 Month

Hi, How about the following condition? Today.Day=2 OrElse (Today.Day=3 AndAlso Today.DayOfWeek=DayOfWeek.Monday) [image] Another action I need to check current date is the second day of March, June, Sept, Dec(3,6,9,12) {3,6,9,12}.Contains(Today.Month) AndAlso Today.Day=2 [image] Regards,

This solution provided by @sasi_poosarla received 2 likes!

Send queue details from one folder to another folder

hai @Kathiravan The Specific Queue can be move or to add to another folder by selecting MANAGE LINKS of that specific Queue… [image] After that [image] need to select the folder to which you need to move that specific Queue Hope it would Helps!!!

This solution provided by @Usha_Jyothi received 2 likes!

I am facing a problem after joining tables

Hi @P-A-J Please check the code MergeDatetebles using linq.zip (10.4 KB) let me know if that works Happy automation

---

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

Top 3 Topics with Most Views

How can i Extract the entire folder hierarchy made by @Soudios with 60 views.

How to search index of a string/value from data table but without knowing the column made by @StevenIsRobotOnline with 55 views.

BC30574: Option strict on - Binding error (for each) made by @PeCour with 50 views.

Top 3 Topics with Most Replies

How can i Extract the entire folder hierarchy made by @Soudios with 53 replies.

How can i compare 2 excel file and if there is a difference write it on an other excel file made by @Soudios with 42 replies.

How to extract the empty rows in an excel sheet made by @raju_alakuntla with 16 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 82 posts!

@Nguyen_Van_Luong1 made 55 posts!

@Soudios made 41 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Split datatable variable by Nth occurance of character

A LINQ Approach could look like this: Assign Activity: dtSplit =dtOrigVar.Clone Assign Activity: dtSplit = (From d in dtOrigVar.AsEnumerable() From sp in d(0).toString.Trim.Split(","c).Chunk(2).Select(Function (x) String.Join(",",x)) Let ra = new Object(){sp, d(1), d(2)} Select r = dtSplit.Rows.Add(ra)).CopyToDataTable

This post made by @Yoichi received 2 likes!

デスクトップ版 Outlook アプリを使用 で表を埋め込む際、表を小さくしたい

こんにちは CreateHTMLContentでhtmlのメール本文を文字列として作成しておいて table width=“100%” の部分を例えばtable width="50%"に書き換える等でしょうか。 ひな形のCSSで書き換えれれば良いのですが、表の部分は直接数字が埋め込まれているみたいなので strHtmlBody.Replace("table width=""100%""","table width=""50%""") のようにしてみかでしょうか。

This post made by @nikhil.girish received 2 likes!

Not able to publish package to orchstrator

Hi @pratyush3410 welcome to community then you might be using the wrong [robot] type, you should be using [Studio] or StudioPro and not unnatended

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

REFrame work question

@A_Learner You would not comment out anything rather you would convert ref to linear format For that you need to modify get transaction data by commenting out the activity to interqct with queue inside it and use if condition and set the transactionitem to a value only if the transactionnumber is 1 else set it to nothing For detailed flow check this [2023 | How to use UiPath RE Framework for linear process | Step by Step | Mukesh Kala UiPath] Cheers

This solution provided by @nikhil.girish received 2 likes!

Not able to publish package to orchstrator

Hi @pratyush3410 welcome to community then you might be using the wrong [robot] type, you should be using [Studio] or StudioPro and not unnatended

This solution provided by @Yoichi received 2 likes!

デスクトップ版 Outlook アプリを使用 で表を埋め込む際、表を小さくしたい

こんにちは あらかじめ別でメール本文を作っておくという意図です。 [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 | 23 August 2023

Top 3 Topics with Most Views

New Orchestrator feature - Unattended Robot Setup made by @sebastian.ungureanu with 73 views.

Yoichi 4000th Solution Flag Celebration made by @ppr with 54 views.

Skip if the Excel cell is blank help me made by @22222222asas with 53 views.

Top 3 Topics with Most Replies

Skip if the Excel cell is blank help me made by @22222222asas with 30 replies.

How to use remove data row activity made by @E.T.S with 20 replies.

Unable to apply filter to retrieve CC and BCC mails from particular sender using O365 get mail activity made by @Adarsh_Babu_Arangi with 19 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 75 posts!

@Nguyen_Van_Luong1 made 47 posts!

@postwick made 44 posts!

Top 3 Most Liked Posts

This post made by @ppr received 9 likes!

Yoichi 4000th Solution Flag Celebration

@Yoichi Congrats on this new milestone and thank you for your tireless help

This post made by @Yoichi received 5 likes!

Yoichi 4000th Solution Flag Celebration

Hi @ppr @Dinesh_Guptil Thank you very much! I’m happy to make a little contribution to the community. Let’s keep learning and doing our best. Yoichi

This post made by @sebastian.ungureanu received 4 likes!

New Orchestrator feature - Unattended Robot Setup

Hello, UiPath Community! We’re excited to announce a new feature in Orchestrator that makes setting up unattended automation a breeze! As you know, unattended automation is a powerful tool that enables tasks to be performed independently, without any human involvement. While the end result may appear simple, the setup process requires some configuration know-how. To simplify this, we have created the Unattended Robot Setup option, streamlining the process and getting you up and running faster t…

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

Comparison with two dynamic variables

Hi @chrystine.h Try this: 1. Read 'dt1' and 'dt2' using appropriate activities. 2. Create 'dt3' with the same structure as 'dt2'. 3. Use an Assign activity to filter and copy unmatched rows from 'dt2' to 'dt3' using LINQ: Assign activity: dt3 = (From rowDt2 In dt2.AsEnumerable() Where Not dt1.AsEnumerable().Any(Function(rowDt1) rowDt1.Field(Of String)("VendorName") = rowDt2.Field(Of String)("CompanyName")) Select rowDt2).CopyToDataTable() 4. Use 'Write Range' acti…

This solution provided by @tazunnisa.badavide received 2 likes!

Calculate avarege from data table

Hey Here is the output I got [image] Avg_Name.xaml (10.1 KB) Here is the xaml u can refer it Happy Automation!

This solution provided by @ppr received 2 likes!

Download VIDEO from page and Regex

As the double quotes are part of the pattern it is included [grafik] We can do: [grafik]

---

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

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

[system]

Daily Forum Report | 24 August 2023

Top 3 Topics with Most Views

Download documents made by @Nikhil_Katta with 46 views.

I need help to resolve below issue made by @Shru_6 with 45 views.

Stay on page popup while downloading the file made by @Priyesh_Shetty1 with 45 views.

Top 3 Topics with Most Replies

엑셀 공백 셀에 원하는 문자 넣는 방법 문의 made by @geuncho with 31 replies.

I need help to resolve below issue made by @Shru_6 with 24 replies.

Collect specific date of latest update on Spotify playlist (what activities to use?) made by @Chris_Balance with 20 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 48 posts!

@Nguyen_Van_Luong1 made 38 posts!

@Anil_G made 27 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to add Key Value Pair in a Dictionary variable?

HI, Can you try either of Assign activity or InvokeMethod activity as the following? [image] Regards,

This post made by @jojo11050702 received 2 likes!

How to connecting to MSSql by using DataBase activity?

Thanks @Anil_G @Parvathy for replying me. By following the thread and the article you mentioned, I connected to the server successfully.

This post made by @Anil_G received 2 likes!

How to connecting to MSSql by using DataBase activity?

@jojo11050702 First install the drivers and as per the drivers select the connection provider using connection wizard and procide db name and othe details…it would build the connection string Or verify connection strings here Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to add Key Value Pair in a Dictionary variable?

HI, Can you try either of Assign activity or InvokeMethod activity as the following? [image] Regards,

This solution provided by @nikhil.girish received 1 likes!

How do we get machine name while running a process

Hi @sakshi562023 check this out hope this helps

This solution provided by @Yoichi received 1 likes!

Did you listen for file name change activity?

Hi, If you need to process next task when the file name is changed, TriggerScope+FileChange trigger will work. [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 | 25 August 2023

Top 3 Topics with Most Views

I need to extract all the details from invoices made by @pravin_bindage with 52 views.

Value binding option missing made by @mkankatala with 46 views.

Regex code to pull text from pdf's made by @Priyesh_Shetty with 43 views.

Top 3 Topics with Most Replies

I need to extract all the details from invoices made by @pravin_bindage with 20 replies.

Regex code to pull text from pdf's made by @Priyesh_Shetty with 18 replies.

Reading a text file and extract and store the values in variables made by @kaustubh.aras28 with 14 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 26 posts!

@Nguyen_Van_Luong1 made 25 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 1 likes!

【質問】Webのプルダウンリストの値を取得する方法

@Mint_Anzu 範囲書き込みアクティビティを使用する または、以下のものを試してください [image]

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

Reading a text file and extract and store the values in variables

Hey You can also refer the below xaml Main.xaml (10.3 KB)

This post made by @supermanPunch received 1 likes!

Value binding option missing

Hi @mkankatala , A Quick check on this, when selected the Legacy version or Expression, we do get the same properties as mentioned by @Anil_G and when selected the VB version we do not have the Value binding option or is a different property (not so clear or did not find the same). Expression Language - Legacy : [image] Expression Language - VB : [image]

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 1 likes!

【質問】Webのプルダウンリストの値を取得する方法

@Mint_Anzu 範囲書き込みアクティビティを使用する または、以下のものを試してください [image]

This solution provided by @ppr received 1 likes!

CurrentRow not able to compare to string

Use following within the conditon FINALWAREHOUSE.trim.eqals(“yorcheckstring”)

This solution provided by @lrtetala received 1 likes!

The Invoke Method activity is throwing this error when passing the arguments

Hi @shenyu Please check on this thread I 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 | 26 August 2023

Top 3 Topics with Most Views

Activity for questioning made by @ydhanabalan with 33 views.

PDF split with specific file name made by @Krishnakumar_Vasudevan with 28 views.

How to round 0.565 to 0.57? made by @donghai with 27 views.

Top 3 Topics with Most Replies

Activity for questioning made by @ydhanabalan with 17 replies.

Handling multiple popup while downloading made by @Priyesh_Shetty with 17 replies.

Automating reading a range from Excel and do a search with this batch until the sheet is over made by @mahmoud_sedek with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Usha_Jyothi made 22 posts!

@postwick made 15 posts!

Top 3 Most Liked Posts

This post made by @girishankar09 received 1 likes!

Error while capturing image "Object Reference Not Set To An Instance Of An Object"

Thanks @mkankatala So I am running this on Remote Desktop/Workspace. So when I close this, it should ideally run on backend (which works on my other projects/workflows related to my bowse). Only this screenshot activity gives issues. Any suggestion or option to solve this?

This post made by @Anirudh_Tugawe received 1 likes!

Uipath Got Stuck

really?? everyone at this point facing the same issue?

This post made by @Anil_G received 1 likes!

Activity for questioning

@ydhanabalan It wont automatically as anything…you need to write your own logic…for asking questions you can use input dialog box or forms activities and create a form as well cheers

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Uipath Got Stuck

@Anirudh_Tugawe , Could you check the below post if it is the same case that you are referring to ? https://forum.uipath.com/t/log-message-activity-has-a-bug/574666/6 Also check if the Package versions are also the same as mentioned in the post. Also, Could you check your opened Application tabs (Maybe using Alt+Tab), to check if the Log Message Expression Window is still open ?

This solution provided by @mkankatala received 1 likes!

Can we export the workflows to PDF, something similar to exporting them to excel?

Hi @Shreya_Gandhi We can save the workflow as a image, after that you can make it to pdf by using online converters. If you want to save it as Image. Right click on the Main sequence and select the save as image option. It will save all the workflow as image. Hope it helps!!

This solution provided by @neha.upase received 1 likes!

How to round 0.565 to 0.57?

Yes, the approach will work for rounding any number to a specified number of decimal places, including numbers like 5.896556. Let’s go through the process step by step using the same approach: Original number: 5.896556 Adding 0.005 to the original number: 5.896556 + 0.005 = 5.901556 Rounding the adjusted number to two decimal places: Math.Round(5.901556, 2) = 5.90 So, for the input 5.896556, the code would output the rounded value 5.90, which is rounded to two decimal places as per your origi…

---

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

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

[system]

Daily Forum Report | 27 August 2023

Top 3 Topics with Most Views

Read Range Workbook does not exist made by @Anirudh_Tugawe with 34 views.

Inserting a Table in email body made by @Nikhil_Katta with 32 views.

DT Activities made by @J_Crosby with 31 views.

Top 3 Topics with Most Replies

Read Range Workbook does not exist made by @Anirudh_Tugawe with 18 replies.

Inserting a Table in email body made by @Nikhil_Katta with 11 replies.

Multiply the columns with a value made by @Kira with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@mkankatala made 11 posts!

@Vikas_M made 9 posts!

Top 3 Most Liked Posts

This post made by @Shreya_Gandhi received 2 likes!

Can we export the workflows to PDF, something similar to exporting them to excel?

Thank you so much Mahesh and Parvathy

This post made by @Nikhil_Katta received 1 likes!

Inserting a Table in email body

thanks for replying … but here iam not using outlook activites … im using only smtp

This post made by @Anil_G received 1 likes!

Win 11 Context Menu Not Selectable

@private_matter Did you try using a power shell script to extract the files? that way we can pass the filepath and everything actually happens in background cheers

Top 3 Most Liked Solutions

This solution provided by @argin.lerit received 1 likes!

Desper: API Start Job Error 404

@seyjo1 - You probably have checked already but since not mentioned in the post and want to make sure, can you share if you are using POST as the method instead of GET or anything else? [image]

This solution provided by @private_matter received 1 likes!

Win 11 Context Menu Not Selectable

Look forget it. I used a start process activity as such: Executable Path: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe Arguments: Expand-Archive -LiteralPath C:\Users\Administrator\Desktop\archive.zip -DestinationPath C:\Users\Administrator\Desktop\archive That works as well.

---

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

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

[system]

Daily Forum Report | 28 August 2023

Top 3 Topics with Most Views

How to extract the Name and DoB from PAN Card made by @raju_alakuntla with 54 views.

Orchestratorへパブリッシュができない made by @tomoya.nakagawa with 46 views.

Compare 2 sheets and get the value made by @Kunal_Jain with 44 views.

Top 3 Topics with Most Replies

How to extract the Name and DoB from PAN Card made by @raju_alakuntla with 26 replies.

Compare 2 sheets and get the value made by @Kunal_Jain with 26 replies.

Can anyone Help with RegEx Expression? made by @rodrigo.simao with 25 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@Shiva_Nikhil made 43 posts!

@Nguyen_Van_Luong1 made 35 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 2 likes!

Compare 2 sheets and get the value

@Kunal_Jain Dt1.AsEnumerable().Where(Function(row) Dt2.AsEnumerable().Any(Function(x) x(“RegionSate”).ToString.contains(row(“Region”).ToString))).CopyToDataTable Try this once

This post made by @Clintonnn received 2 likes!

Problem with parsing a Json with invalid characters

Thank worked @Yoichi! Thank you so much, you are a king

This post made by @Anil_G received 2 likes!

Need help on sending an image with variable name appended

@mb29 Can you please use a formatted text or a screenshot to show how youa re giving ideally this would work "<img src=""" + var + "_results.png"" />" cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Need help on sending an image with variable name appended

@mb29 Can you please use a formatted text or a screenshot to show how youa re giving ideally this would work "<img src=""" + var + "_results.png"" />" cheers

This solution provided by @ppr received 1 likes!

How to check IEnumerable(Match) variable through IF statement

We assume that the matches Activtiy is involved (You mentioned IEnumerable(Of Match) And not MatchCollection (output from Regex.Matches) A pattern could look like this: [grafik]

This solution provided by @Yoichi received 1 likes!

Problem with parsing a Json with invalid characters

Hi, Can you try the following expression? strJson = strJson.Trim({"@"c,""""c,Chr(10),Chr(13)}).Replace("""""","""") [image] Sample20230828-1L.zip (3.2 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 | 29 August 2023

Top 3 Topics with Most Views

Help to write Regex Pattern to find job title comes together with experience date? made by @Gowthaman_Gajakutti with 40 views.

Linq Query to Update a column depending on the value of another column made by @Amrutha.mg with 37 views.

Replace picture made by @Yogita_Gaikwad1 with 37 views.

Top 3 Topics with Most Replies

How can I rename the file and move in new excel sheet with rename with saheer name made by @suraj_gaikwad with 22 replies.

Help to write Regex Pattern to find job title comes together with experience date? made by @Gowthaman_Gajakutti with 21 replies.

How to copy mutiple rows into different excel sheets made by @anjani_priya with 19 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 70 posts!

@mkankatala made 54 posts!

@ppr made 38 posts!

Top 3 Most Liked Posts

This post made by @Lucas.Pimenta received 6 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Awesome! I would love to participate as a Brazilian Portuguese speaker Count me in!

This post made by @Yoichi received 5 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Hi @loredana_ifrim Thanks for sharing the interesting initiative. I’d like to join (Japaneses language). Regards,

This post made by @brunabruno received 5 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Yesss!!! Of course @carlosevp! I’m so excited with that…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Linq Query to Update a column depending on the value of another column

Hi, How about the following sample? dt.AsEnumerable.ToList.ForEach(Sub(r) If arrTarget.Contains(r("vendor").ToString) Then r("status")="Exact" Else r("status")="Not Exact" End If End Sub) [image] Sample20230829-1L.zip (8.4 KB) Regards,

This solution provided by @Steven_McKeering received 1 likes!

Help to write Regex Pattern to find job title comes together with experience date?

Hi Well try this pattern: (?<=\))(.+?)(?=\d|Invalid) [image] I thought you needed the date also.

This solution provided by @Riyas.Muhammed received 1 likes!

Excel lookup cell

@Karan_Chauhan , If you what to know the Cell address of the word you are looking for, you can use “LookUp Range” activity inside “Excel Application Scope”. Output result will give you the cell address. [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 | 30 August 2023

Top 3 Topics with Most Views

UiPath UIAutomation 23.8 Community Release made by @Bogdan_Sultana with 73 views.

【募集期間が延長されました】コミュニティ フォーラム: 新しい翻訳機能のテスト参加者を募集しています! made by @Susa with 58 views.

String manipulation and comparison made by @duaine.b with 47 views.

Top 3 Topics with Most Replies

Remove comas from data table or txt made by @E.T.S with 43 replies.

String manipulation and comparison made by @duaine.b with 19 replies.

REGEX quiz made by @Latifa with 16 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 70 posts!

@postwick made 44 posts!

@mkankatala made 43 posts!

Top 3 Most Liked Posts

This post made by @rikulsilva received 4 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I’d love to join - Brazilian Portuguese

This post made by @Bogdan_Sultana received 4 likes!

UiPath UIAutomation 23.8 Community Release

The UIAutomation 23.8 Preview package was just published with a slight delay vs. the other UiPath Preview packages. Here’s what’s new: With our latest enterprise version 23.4 we released the Trigger-based framework, a new way to build Attended Automations, with event-driven architecture. We provided support for native events monitoring through the Application Event Trigger activity for certain technologies: Web, Java, Active Accessibility. Also, we continue our story of integrating Computer Vis…

This post made by @Susa received 3 likes!

【募集期間が延長されました】コミュニティ フォーラム: 新しい翻訳機能のテスト参加者を募集しています!

以下は Fresh New Opportunity: Pilot A New Forum Feature and Get Rewarded! の抄訳です。詳しくは、元の記事をご覧ください。 UiPath コミュニティ ユーザーの皆様へ、 9 月 1 日から 9 月 24 日までの間、UiPath コミュニティ フォーラム内で、新しい翻訳プラグインのパイロット プロジェクトを実施します。つきましては、このプロジェクトにご参加いただける日本語話者のボランティア メンバーを先着 5 名で募集いたします。 ご参加いただける方は、8 月 31 日 9 月 7 日までに Fresh New Opportunity: Pilot A New Forum Feature and Get Rewarded! に対してリプライしてお申し込みください。翻訳プラグインの使用感についてご感想を提供いただける場合、40 ドル相当の UiPath グッズ バウチャーをご用意しております。 皆様のご参加を心よりお待ちしております。 UiPa…

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

For Each Element Properties

Hi @mango3392 To get the properties of type argument for the for each activity. Downgrade the version of UiPath.System.activities package. Then you can see the type argument properties in for each activity. But the new for each also works good, When you pass the collection variable in the condition field it will automatically changes its type argument automatically. If the condition is array variable it will automatically changes it type argument to array in the background and it works fine. H…

This solution provided by @arjunshenoy received 1 likes!

Else Ifアクティビティの条件文の計算結果をBoolean型に変換したい

Hi @gorby Could you please try the following condition: CInt(row(“number of oranges”).ToString) > 0 AND CInt(row(“number of oranges”).ToString) < 6 Hope this helps, Best Regards.

This solution provided by @Yoichi received 1 likes!

Tricky Question

Hi, How about the following expression? yourString="900323" Then listStr = Enumerable.Range(0,4).Select(Function(i) yourString+i.toString+"00000").ToList [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 | 31 August 2023

Top 3 Topics with Most Views

Reading config from Asset instead of Config.Json or Excel file made by @sonaliaggarwal47 with 47 views.

How to change month to number made by @Mathkar_kunal with 47 views.

Looping over data rows, but starting with the 5th row directly made by @maria-iulia.zdrenghea with 41 views.

Top 3 Topics with Most Replies

How to change month to number made by @Mathkar_kunal with 39 replies.

Excel Formulas when assigned not working made by @P-A-J with 24 replies.

Update values DT in single row made by @Sathish_Kumar_S with 24 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 65 posts!

@Anil_G made 60 posts!

@mkankatala made 51 posts!

Top 3 Most Liked Posts

This post made by @l.wang received 3 likes!

To Make Workflow analyzer rules automatically apply to all projects universally across the UiPath Studio environment

Thanks! That was what I thought. The rules are on the project level. The only way to make it shared through projects is to make a template I guess.

This post made by @HANACCHI received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Thanks for sharing the interesting initiative. I’d like to join (Japaneses language). 73 & 88

This post made by @robot.gestus received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Great, I would like to participate and help as a Brazilian Portuguese speaker.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

My studio publish is grayed out (Attended License)

Hi, Can you check the following document? Is there Robot default option? [image] https://docs.uipath.com/studio/standalone/2023.4/user-guide/about-publishing-automation-projects If we have only Attended license, we cannot publish the project. (We need Automation Developer license etc.) Regards,

This solution provided by @nikhil.girish received 1 likes!

Uipath getting freezed while

Hi @sakshi562023 Check this post Hope this might help

This solution provided by @Vikas_M received 1 likes!

Rgex other than is pattern matching

[image] Please refer above screenshot so basically it is near variables panel Hope it helps u out1

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

@Anil_G received 49 likes for their solutions!

@Yoichi received 45 likes for their solutions!

@ppr received 31 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 September 2023

Top 3 Topics with Most Views

Thoughts after the UiPath Hyperhack 2023 made by @George_Roth with 51 views.

Can't get the correct datetime format made by @cacafundi with 46 views.

Counter with split - help made by @Ellen with 44 views.

Top 3 Topics with Most Replies

I want to convert pdf file to excel made by @office_work with 22 replies.

Counter with split - help made by @Ellen with 20 replies.

Get last value with regex made by @murat.karasoy with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@Anil_G made 36 posts!

@postwick made 31 posts!

Top 3 Most Liked Posts

This post made by @George_Roth received 6 likes!

Thoughts after the UiPath Hyperhack 2023

I had the honor to participate as a Jury member at the 2023 HyperHack AI Category Section. I didn’t see all the projects, but I saw the finalist 9. I was impressed by all these, below is the list of the finalists with what their automations do. First prize: DrSimplifAI – developed by SimplifyNext team from Singapore This is an automation app for a healthcare use case that aims to enhance the patient experience and improve doctor-patient interactions by leveraging Specialised AI and Generative…

This post made by @koreta received 5 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Hi @loredana_ifrim. I would like to participate. I speak Japanese. Thank you in advance.

This post made by @Yamasakia received 4 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I want to participate I am Japanese. Best regards.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Questions About StudioX found in Dumps of RPA Exam Questions

@Shreyas_Khorgade There would not be any studiox related question for detailed syllabus check this…this will have all info [image] and also questions would be almost at same level as the exam cheers

This solution provided by @nikhil.girish received 1 likes!

Remove vowels from string

Hi @Rishab2 Welcome to community Check this expression Have this in value stored to a variable System.Text.RegularExpressions.Regex.Replace(“yes”,“[AEIOUaeiou]”,“”)

This solution provided by @mkankatala received 1 likes!

Read Range stays pending & Date conversión issue

Hi @Luis_Fernando Instead of using read range workbook activity use the read range activity which is the modern excel activity. => Take use excel file activity and pass the excel file path. => Inside use excel file activity insert the read range activity. In the properties of read range activity, Read formatting option is there select the raw value option which holds the same format of the cells and store in a datatable. => After that use the write csv file to write the datatable to csv file…

---

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

Top 3 Topics with Most Views

Read CSV Activity made by @KuruvaJayaPrakash with 33 views.

How can I delete rows in an excel file if for example column A is empty made by @goncalo.rocha with 32 views.

Extract the filenames from a folder and save them in Excel or Notepad made by @jharmel.carmona with 29 views.

Top 3 Topics with Most Replies

Match DT data with other DT and get the email address made by @Sathish_Kumar_S with 18 replies.

Extract the filenames from a folder and save them in Excel or Notepad made by @jharmel.carmona with 10 replies.

How to convert a string to a mail message made by @P-A-J with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 14 posts!

@Anil_G made 12 posts!

@postwick made 11 posts!

Top 3 Most Liked Posts

This post made by @takashi_hashimoto received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I am a Japanese living and working in Japan. I would love to participate.

This post made by @takashi_hashimoto received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Native language is Japanese

This post made by @Yoichi received 1 likes!

Need help on arg value

Hi, Unfortunately, out type argument will be blank when exit the xaml due to exception. How about using exception.Data as the following sample? Set content of yourname variable to exception.Data(“Yourname”) , then rethrow [image] we can get it using exception.Data(“yourname”) in catch state of main.xaml [image] The following is a sample of the above. BlankProcessv2.zip (6.4 KB) Regards,

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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

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

[system]

Daily Forum Report | 03 September 2023

Top 3 Topics with Most Views

Code working in studio run but not through orchestrator made by @JOBIN_JOSE with 38 views.

Re framework automation made by @J_Crosby with 33 views.

Problem extracting Data URL made by @hiring.antiquescollectors with 32 views.

Top 3 Topics with Most Replies

How to get string after some character made by @aslam_ali1 with 13 replies.

Excel freeze Panes made by @Luffy with 13 replies.

Re framework automation made by @J_Crosby with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 15 posts!

@postwick made 12 posts!

@Shiva_Nikhil made 11 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Re framework automation

Oh wow I m right It’s already discussed in forum @J_Crosby

This post made by @J_Crosby received 1 likes!

Re framework automation

@Palaniyappan @Shiva_Nikhil I saw those two questions and doubted the correct options after reading deeply on re-framework, that’s why I asked. Option B is also what I think is right from my research. I just needed a confirmation. Thanks a lot guys for your time Cheers J Crosby

This post made by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

This solution provided by @postwick received 1 likes!

Need a linq query to solve this issue

Why bother with an extra variable? Just do it all with an If expression… If(CurrentRow.ItemArray.All(Function(x) x.ToString().Equals(“NoChange”)),"OK","Error")

This solution provided by @Palaniyappan received 1 likes!

Transaction Status

It’s option B @J_Crosby

---

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

Top 3 Topics with Most Views

Errror Compare Two File made by @Muhammad_Taufik_Akbar with 52 views.

How to replace blank cell with 0 using Excel activities made by @lrtetala with 42 views.

UiPath Can't indicate SAP element made by @alvin.c.apostol26 with 40 views.

Top 3 Topics with Most Replies

Conditional formatting made by @E.T.S with 18 replies.

Unable to run app on mobile made by @Mathkar_kunal with 16 replies.

Get queue items -set transaction progress! made by @Hazem_Saleh with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@supermanPunch made 30 posts!

@ppr made 28 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This post made by @Anuj_Tiwari received 3 likes!

Migrating Legacy Listings to Windows

Hi everyone, You may already be aware that the default compatibility for new projects in latest versions of UiPath Studio is “Windows”. It’s important to know that the number of users using the Windows projects in Studio is increasing rapidly. The Legacy listings won’t support Windows so those users of latest Studio version(s) won’t be able to find and use Legacy listings under default compatibility. Therefore, we strongly ask all of you to complete the transition of your legacy listings to W…

This post made by @Pothanakar_Prabhakar received 2 likes!

How we can install uipath studio on linux server

Thanks for the resolution @Palaniyappan @arjunshenoy

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This solution provided by @Arvind_Kumar1 received 2 likes!

Passing values from one page to another

@Aditi_Jha , as you shown you are not using VB Apps. so please do below steps on legacy app. Set Value on click rule Create app variable In Set value pass the App variable and set value from your custom list. you can use app variable across other page now. Thanks, Arvind

This solution provided by @supermanPunch received 2 likes!

Write the values based on the column name in write cell activity

Hi @tharani.natarajan , Assuming that you have read the Data as a Datatable in Excel sheet, we can check with the below to convert Column Index to Column Letter : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.IndexOf("MailId")+1) Here, DT is the Datatable variable and columnLetter is a String variable.

---

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.