Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 July 2023

Top 3 Topics with Most Views

UiPath update failed (kindly help) made by @Yugandhara_Shirbhate with 41 views.

Using UiPath App, Upload and process one pdf file made by @Subhamay_Maity with 38 views.

Prioritise Queue Retry Mechanism made by @Jeroen_van_Loon with 33 views.

Top 3 Topics with Most Replies

Value cannot be null. (Parameter 'key') when pass it with step status activity made by @sarathic with 14 replies.

UiPath update failed (kindly help) made by @Yugandhara_Shirbhate with 13 replies.

Have an error on activity “Create folder” Absolute paths not recommended made by @kimberly.lin with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 47 posts!

@raja.arslankhan made 17 posts!

@Yugandhara_Shirbhate made 9 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

UiPath update failed (kindly help)

@Yugandhara_Shirbhate From the main page you can download by clicking on download [image] or click on the question mark symbol on top…and select downloads …even from there it cna be downloaded cheers

This post made by @Jeroen_van_Loon received 1 likes!

Prioritise Queue Retry Mechanism

Thanks for your suggestion. But as stated I know how to work around it. It’s that I don’t ‘want’ to have to work around it, in order to maintain a standard through all workflows without creating too much overhead. Therefor I would like to suggest it as an extention of the existing out-of-the-box retry mechanism of Orchestrator queues.

This post made by @Aparna_Kaushik received 1 likes!

Unable to create new processes in 2023.6.0 version

Thank you. I just restarted my system. It worked!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

reportforUiPathactivity errors dispalyed and generate balank page

@sarathic Can you please try giving the description and name also so that it would try to add them… Also make sure to remove all previously created folder or file and try it As it is 3rd party activity we have limited scope to get more details Cheers

This solution provided by @Jeroen_van_Loon received 1 likes!

Specific url click

Use wildcards. Record the selector using a click activity. Then use the uiexplorer to make sure the selector uses the correct ‘content’ to apply your businessrule. So probably the url of visible text. The change that property and change ‘blablabla | villageinfo.in’ to ‘*| villageinfo.in’ Since the selector will now find multiple results, and it defaults to the 1st it finds you are already set. So record: <webctrl tag='A' aaname='Madhopur Village in Satgawan (Kodarma) Jharkhand | villageinf…

This solution provided by @Yoichi received 1 likes!

Gmailの使用方法

こんにちは 繰り返し（各メール）アクティビティとそのフィルターを使うと良いかと思います。具体的には以下のようになると思います。 [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 | 03 July 2023

Top 3 Topics with Most Views

Splitting a datacolumn from a datatable into the correct columns made by @TyraS with 52 views.

How to input excel formula into excel cell from write cell activity made by @zaffan.isa with 47 views.

Multiple excel reading made by @Gokul_Murali with 47 views.

Top 3 Topics with Most Replies

Question about sequence to create conditionnal phrase etc made by @Ricchch with 25 replies.

Splitting a datacolumn from a datatable into the correct columns made by @TyraS with 21 replies.

I am having time in two variable. Want to add both variable made by @Puneet_Singh1 with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 85 posts!

@raja.arslankhan made 41 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 5 likes!

Monthly Forum Rewards - June 2023

@loredana_ifrim Thank you. Congratulations everyone for great efforts to maintain active community.

This post made by @Anil_G received 4 likes!

Monthly Forum Rewards - June 2023

Congrats everyone . Keep up the good work. Nice race @Yoichi

This post made by @Gokul_Murali received 3 likes!

Date_Format_Issue

@Anil_G @lrtetala @raja.arslankhan @aanandsanraj @Sahil_Tomar Guys i used an activity called Date formatter under the package “NovigoSolution.DataTableDateFormatter.Activity”. Now it is working fine, irrespective of excel row format.

Top 3 Most Liked Solutions

This solution provided by @Gokul_Murali received 3 likes!

Date_Format_Issue

@Anil_G @lrtetala @raja.arslankhan @aanandsanraj @Sahil_Tomar Guys i used an activity called Date formatter under the package “NovigoSolution.DataTableDateFormatter.Activity”. Now it is working fine, irrespective of excel row format.

This solution provided by @Anil_G received 1 likes!

Excel more complex Vlookups

@robin.thakur Create a combined column like first concatenate column company and entity code and perform the lookup on the combined column Cheers

This solution provided by @Anil_G received 1 likes!

Value cannot be null. (Parameter 'key') when pass it with step status activity

@sarathic If the error is coming on step status…then first check the variable values you are passing in the step status to see if any of those values are null…for that you can leverage locals panel… Apart from that you missed giving test id etc …check if giving those would resolve… Then assign varibles for output values like status and all and see what it gives may be it can provide more info… Also its worth checking exception details ,that might contain more info 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 | 04 July 2023

Top 3 Topics with Most Views

Value of type 'String' cannot be converted to 'UiPath.Database.DatabaseConnection made by @Aditya10989 with 47 views.

Error "Object reference not set to an instance of an object" due to adding "On Element Appear" made by @ret_valkering with 44 views.

Issue in add item to array made by @anmita with 44 views.

Top 3 Topics with Most Replies

Compare two different excel columns and matched remove data in second excel sheet made by @Sachin_Sunny with 19 replies.

Invoking arguments into a coded workflow made by @aquinn with 16 replies.

Excelの表の読み込みについて made by @y.c with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@raja.arslankhan made 36 posts!

@mkankatala made 30 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Where is the latest video tutorial and activities

@Parker The latest videos are yet to be updated in the UiPath academy pages…for now ypu can check few youtube tutorials whoch have activities related to the modern design The activities that you are seeing in older version had been upgraded to a new design called modern…if you want to see only activities you can switch off modern design from the studio settings page…or go to activities panel on left → click filter icon → select classic…now you would be able to see classic activities as welll…f…

This post made by @Parker received 2 likes!

Where is the latest video tutorial and activities

It’s very useful for me! Thanks for your help.

This post made by @Sachin_Sunny received 1 likes!

Compare two different excel columns and matched remove data in second excel sheet

Thank you, It worked!!!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Where is the latest video tutorial and activities

@Parker The latest videos are yet to be updated in the UiPath academy pages…for now ypu can check few youtube tutorials whoch have activities related to the modern design The activities that you are seeing in older version had been upgraded to a new design called modern…if you want to see only activities you can switch off modern design from the studio settings page…or go to activities panel on left → click filter icon → select classic…now you would be able to see classic activities as welll…f…

This solution provided by @raja.arslankhan received 1 likes!

Can i Move file after my UI activities got error(exception) cant find element or something exception

@Harpoon Mark click property continue on error as yes so it will ignore error and go in next file.

This solution provided by @AutomationX_by_Kiran received 1 likes!

Value of type 'String' cannot be converted to 'UiPath.Database.DatabaseConnection

Hi @Aditya10989 , You are getting the connection string from json right pass it in the Connect database Then u will get the output as dbconnection variable . Pass that variable in the disconnect database . So what ever you are getting in json don’t pass in disconnect database

---

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 | 05 July 2023

Top 3 Topics with Most Views

String Variable comparison made by @Karan_Chauhan with 43 views.

Selector issue! made by @aya.lajili with 41 views.

Change Font Size in word made by @MEGHA_cs with 39 views.

Top 3 Topics with Most Replies

条件分岐でnullがうまく分岐されなくなりました made by @7ffdf30161e05b3796f42f977 with 21 replies.

Compilation error while displaying Get transaction item output made by @Parameswari with 21 replies.

Regex multiple lines made by @Dion with 15 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 45 posts!

@lrtetala made 34 posts!

@mkankatala made 31 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

Get Cc receipients from Outlook Mails

CC Property will return a System.Net.Mail.MailAddressCollection [grafik] So we can check e.g. within the addresses with [grafik] YourMailVar.CC.Any(Function (x) x.Address.Contains("cashin")) ToString() will return for an MailAddressCollection (with only 1 ID contained) [grafik] we got the name (red) and the address (blue)

This post made by @arjunshenoy received 1 likes!

Argument issue

Hi @suraj_gaikwad If you have already deleted the argument & still able to see the same, please save the workflows & close the application. Open it again, and check if you get the same thing again. Hope this helps, Best Regards.

This post made by @ppr received 1 likes!

How to sort data within the same datatable with oldest to newest?

Order by CDate(sp).Date, CInt(np) refer to the updated LINQ

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Get Cc receipients from Outlook Mails

CC Property will return a System.Net.Mail.MailAddressCollection [grafik] So we can check e.g. within the addresses with [grafik] YourMailVar.CC.Any(Function (x) x.Address.Contains("cashin")) ToString() will return for an MailAddressCollection (with only 1 ID contained) [grafik] we got the name (red) and the address (blue)

This solution provided by @raja.arslankhan received 1 likes!

Empty filed in browser

@sullivanne Write exact String.IsNullOrWhiteSpace(EmptyField.ToString) don’t put any space

This solution provided by @ppr received 1 likes!

String Variable comparison

Assign: arrWeak | String Array = str_Weaknesses.Split(“,”).Select(Function (x) x.Trim).toArray Assign: arrResist | String Array = str_Ressistence.Split(“,”).Select(Function (x) x.Trim).toArray Assign arrUncommons | String Array = arrWeak.Except(arrResist).toArray Assign str_UnCommons = String.Join(", ", arrUncommons )

---

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

Top 3 Topics with Most Views

処理中にString引数の値がnullになる現象 made by @ryoko with 46 views.

UiPath Assistant Challenges made by @kelvin_Aliche with 44 views.

Get Name which has minimum Marks made by @Garyy with 43 views.

Top 3 Topics with Most Replies

How to find the 6 months date difference between two dates made by @sruthesanju with 20 replies.

Data manipulation assing activity made by @omar_ismail with 16 replies.

Deployment error from devops to orchestrator made by @santiago_Alvarez with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@lrtetala made 35 posts!

@raja.arslankhan made 29 posts!

Top 3 Most Liked Posts

This post made by @prateek.mehandiratta9 received 2 likes!

Is it possible to distinguish whether a human executed it directly or through a trigger?

HI, You could use Orchestrator api for that and extract the source information from Get Jobs Api, please follow the below thread: Is it possible to know which user triggered/started the job from Orchestrator? - Help / Orchestrator - UiPath Community Forum Thanks.

This post made by @rlgandu received 1 likes!

Is it possible to distinguish whether a human executed it directly or through a trigger?

Hi, In UiPath, it is possible to distinguish whether a process was executed directly or through a trigger by accessing the information available in Orchestrator. The “Source” column in the Jobs menu of Orchestrator provides this information. However, within the program execution itself, there is no built-in feature to directly retrieve the “Source” value. The source information is specific to Orchestrator and is not exposed to the process during runtime. To determine whether a process was exe…

This post made by @ppr received 1 likes!

How to find the 6 months date difference between two dates

we hope you agree on: in 2022 JAN,FEB,MAR,APR,MAI,JUN = 6 Months then 31+28+31+30+31+30 = 181 In Leap Years + 1 As month do have different counts we would avoid to general Month=30days factors when the exactr result is needed

Top 3 Most Liked Solutions

This solution provided by @prateek.mehandiratta9 received 2 likes!

Is it possible to distinguish whether a human executed it directly or through a trigger?

HI, You could use Orchestrator api for that and extract the source information from Get Jobs Api, please follow the below thread: Is it possible to know which user triggered/started the job from Orchestrator? - Help / Orchestrator - UiPath Community Forum Thanks.

This solution provided by @Anil_G received 1 likes!

Deployment error from devops to orchestrator

@santiago_Alvarez Account name needs to be provided…if you see the comment below…for cloud orchestrator it is mandatory You can get it from api access page in your admin page …services Cheers

This solution provided by @supriya117 received 1 likes!

How to manipulate a string in a file Path

Hi @Carla_Munoz Try this for without extension: filename = System.IO.Path.GetFileNameWithoutExtension(“path”) For with extension: filename = path.GetFileName(“path”) or filename = System.IO.Path.GetFileName(“path”) 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 July 2023

Top 3 Topics with Most Views

https://forum.uipath.com/t/561134 made by @xxGoRpa with 69 views.

Click hyperlink from the table data made by @premkumar.rengarajan with 50 views.

An item key had already been added Key: Project location\"codedworkflow.cs" made by @Ahead_Engineering with 46 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/561134 made by @xxGoRpa with 23 replies.

Click hyperlink from the table data made by @premkumar.rengarajan with 14 replies.

Clipping region - Take screenshot made by @MEGHA_cs with 12 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 57 posts!

@Anil_G made 27 posts!

@supriya117 made 19 posts!

Top 3 Most Liked Posts

This post made by @Luis_Fernando received 2 likes!

Is it possible to extract just a specific file from a ZIP?

Hello Friends @prateek.mehandiratta9 , @supriya117 and @Jithesh_R Problem is solved I asked Chat GPT for VB.Net expression that searched for the path of the files that met a condition. The result was this Imports System.IO Dim folderPath As String = “C:\YourFolderPath” ’ Specify the folder path where the files are located Dim searchTerm As String = “Manifiesto” ’ Specify the search term ’ Get all files in the folder that match the condition Dim files As String() = Directory.GetFiles(fold…

This post made by @Yoichi received 2 likes!

Help Me to get spesific value from string

Hi, Can you try as the following? m = System.Text.RegularExpressions.Regex.Match(yourString,"\b(\d{4})(\d{2})(\d{2})\b") Then m.Groups(3).Value+m.Groups(2).Value+m.Groups(1).Value [image] Sample20230707-2.zip (2.6 KB) Regards,

This post made by @Anil_G received 1 likes!
https://forum.uipath.com/t/561134/13

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Help Me to get spesific value from string

Hi, Can you try as the following? m = System.Text.RegularExpressions.Regex.Match(yourString,"\b(\d{4})(\d{2})(\d{2})\b") Then m.Groups(3).Value+m.Groups(2).Value+m.Groups(1).Value [image] Sample20230707-2.zip (2.6 KB) Regards,

This solution provided by @Yoichi received 1 likes!

セルの値が空なら同じ行のある値を持ってくる

こんにちは たとえば以下データテーブルをフィルターアクティビティを使った例です。 いかがでしょうか？ [image] Sample20230707-1.zip (7.5 KB)

This solution provided by @lrtetala received 1 likes!

How to perform browser based ui automation in Serverless cloud

Hi @Sridhar_Aswin Check on this document https://docs.uipath.com/orchestrator/automation-cloud/latest/user-guide/automation-cloud-robots-serverless https://forum.uipath.com/t/introducing-automation-cloud-robot-serverless-limitless-robot-power-with-zero-infrastructure/410022?u=lrtetala 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 | 08 July 2023

Top 3 Topics with Most Views

Continue browser in a new sequence after clicking a button in old sequence made by @Vivian_Thian with 39 views.

Using flowchart inside for each row made by @Vivian_Thian with 36 views.

How to Remove odd rows in the datatable made by @Pujari_Manjunatha with 35 views.

Top 3 Topics with Most Replies

Wait element vanish activity not working made by @Iswarya_P1 with 19 replies.

https://forum.uipath.com/t/561495 made by @xxGoRpa with 15 replies.

Using flowchart inside for each row made by @Vivian_Thian with 13 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 32 posts!

@lrtetala made 20 posts!

@Anil_G made 18 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

Indicate Question!

Hi @170290064 https://docs.uipath.com/activities/other/latest/ui-automation/n-check-state Give like this [image] Regards,

This post made by @Anil_G received 1 likes!

Indicate Question!

@170290064 To be precise you can indicate on verify you are robot …that would come only when it is asked for… So the basic rules is…how you differentiate visually or through any parameters is what you need to take in consideration so that when you choose a selector it would be unique for a scenario along with a page or for different pages as per your need… In this case any captcha so concentrate on the button or text which would definitely be present only on this site Hope this helps Cheers …

This post made by @xxGoRpa received 1 likes!
https://forum.uipath.com/t/561570/9

Top 3 Most Liked Solutions

This solution provided by @raja.arslankhan received 1 likes!

Indicate Question!

@170290064 When using the “Check App State” modern activity in UiPath and encountering a captcha on a website, it is typically recommended to select the specific part inside the window where the captcha appears. This allows the activity to focus specifically on that area and perform the necessary checks. Here’s the general process for indicating the area when using the “Check App State” activity: Open the website in a web browser within the “Use Application/Browser”,“Open Browser” or “Attach…

This solution provided by @pravallikapaluri received 1 likes!
https://forum.uipath.com/t/561495/14

This solution provided by @Anil_G received 1 likes!

How to get/select Duplicated Row in Excel Data Table

@Harpoon If you just need to know which data is duplicate then please follow this Read the data from excel into dataTable dt Use assign activity with dt = dt.AsEnumerable.GroupBy(function(x) x("itemNo").ToString).Where(function(x) x.Count>1).Select(function(x) x.First).CopyToDataTable Cheers

---

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

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

[system]

Daily Forum Report | 09 July 2023

Top 3 Topics with Most Views

How to extract words in different lines (Regex)? made by @helpplease with 52 views.

Getting this error in date made by @katta_nikhil with 35 views.

Separate part of a path on Excel made by @omar_ismail with 35 views.

Top 3 Topics with Most Replies

How to Resolve UI-DBP-006 and what is top leave selector made by @Ankit_shukla with 16 replies.

How to extract words in different lines (Regex)? made by @helpplease with 14 replies.

Separate part of a path on Excel made by @omar_ismail with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 18 posts!

@lrtetala made 15 posts!

@mkankatala made 13 posts!

Top 3 Most Liked Posts

This post made by @Bureau_G received 2 likes!

Why isn't my API endpoint not accepted?

Thanks for your replies. I tried the Endpoint with and without quotes. In both cases I received the error message. Also when I used a variable as endpoint. But it is the same as going to the doctor: A week long your back is hurting like h*ll, but after you made an appointment with the docter the pain is gone. In this case after your answers the endpoint with quotes works just fine. Again: thanks for the replies!!!

This post made by @mkankatala received 2 likes!

Data Scraping - Item Selection

Hi @Conning You are using the extraction wizard for data extraction it was the classic activities. Use the modern activities to scrap the data from this type of websites. It was the pattern extraction. First enable the modern design activities for the project. Take the Use application\browser activities then indicate the website application that you are automating. In that use the extract datatable activity to extract the data as a datatable. When you are indicating there is table settings opti…

This post made by @mrymn received 2 likes!

Unable to launch prchestrator

Able to open orchestrator now. turns out my clock is not correctly set. Thank you!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

メールの添付ファイルを保存の条件

こんにちは 繰り返し（メール）でのフィルターで90日くらいで指定しておいて 条件分岐で必要な日付だけを処理をする手もあります。下記参照ください。 当月初日（１日）の処理が少々不明確かと思いますので、下記では当月１日は前月分を処理しています。 [image] previsousDay = Today.AddDays(-1) CurrentMail.DateAsDateTime>=New DateTime(previousDay.Year,previousDay.Month,1) AndAlso CurrentMail.DateAsDateTime<=previousDay

This solution provided by @lrtetala received 1 likes!

How to extract words in different lines (Regex)?

@helpplease SIN Output [image] DXB Output [image]

This solution provided by @pravallikapaluri received 1 likes!
https://forum.uipath.com/t/561570/11

---

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

Top 3 Topics with Most Views

Date formatting issue occurred made by @suraj_gaikwad with 58 views.

Split the File name made by @Priyesh_Shetty1 with 57 views.

Regex to check if a string separated by pipeline contains a certain keyword made by @mnlatam with 53 views.

Top 3 Topics with Most Replies

Use Application Browser - Input Element made by @170290064 with 24 replies.

Split the File name made by @Priyesh_Shetty1 with 21 replies.

Error writing excel formula with " " made by @atarantino with 19 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 51 posts!

@Anil_G made 33 posts!

@lrtetala made 31 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Help me to get the folder name from a file path

@StevenIsRobotOnline As this is a path…it would be good to use path related commands Path.GetFileName(Path.GetDirectoryName("YourPath")) or new DirectoryInfo(System.IO.Path.GetDirectoryName("YourPath")).Name cheers

This post made by @zeynepnaz.yardim received 1 likes!

Uipath Consolidate 8 different "Google Sheets" in one Excel sheet

Hello, I would like to consolidate 8 different but same formatted tables that are made in 8 different “Google sheets” into one Excel sheet by using UiPath. As the row numbers of each sheet differs from both each-other and not fixed, it totally depends on the person who fills the sheet, I could not understand how should I write the range as “A2:?” in UiPath. I would be very happy if you could help me on both of these questions. Thank you in advance. Best regards.

This post made by @lrtetala received 1 likes!

Take action if there is text in the field

Hi @sullivanne Try like this Not String.IsNullorEmpty(CurrentRow("YourColumn").ToString) [image]

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

PDF extraction using Regex exp

Hi @praveena.nadi Try using the below expressions Omkumar Tolani ------------ (?<=\n)[A-Z]+\s*[A-Z]+(?=\s*[A-Z]+.[A-Z]+\s*: ) DOC.No ----------------- (?<=[A-Z]+.?[A-Z]+\s*:\s*)[A-Z]+\d+-?\d+(?=\s*[A-Z]+[a-z]+\s*: ) Policy/Cert No ----------------------- (?<=[A-Z]+[a-z]+.\s*:\s*)[A-Z]+-\d+-?\d+-?\d+-?\d+(?=\s*[A-Z]+\s*[A-Z]+) Being Policy Premium ----------------------------- (?<=[A-Z]+-\s*)\d+,?\d+.?\d+(?=\s) Tax -------------------------- (?<=TAX\s*)\d+%?(?=\s*\d+.?\d+) Total ------…

This solution provided by @Anil_G received 1 likes!

Dynamic Selector Activity Problem!

@170290064 Can you try with simulate… also the selector photos you gave look different in two pictures also can you confirm if you are getting error or is it just not clicking an moving ahead? cheers

This solution provided by @Steven_McKeering received 1 likes!

Question on delays and timeout property

Hello @A_Learner If the element is not found, the amount equals: Delay_before + Timeout. If the element is found: delay_before + delay_after + ‘the amount of time taken to click’ based upon WaitFor setting. (WaitForReady.None, WaitForReady.Interactive and WaitForReady.Complete) The default settings are: 30 seconds is the default timeout. WaitForReady.Interactive is default WaitForReady setting (aka blank). These can be configured in the project. Does this make sense? Cheers Steve

---

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

Top 3 Topics with Most Views

New Group Alerts feature gradually rolling out in Orchestrator made by @sebastian.ungureanu with 89 views.

Studio 2023.6.1 Error made by @Danables with 60 views.

Can anyone give me RPAChallange with best practices file made by @hikumar with 53 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/562219 made by @nithish.dhanabal1 with 29 replies.

Bot unable to run in unattended mode to enter the dropdown field for M1 , M2..below screen made by @divya.17290 with 25 replies.

In_Config ERROR Assign: Object reference not set to an instance of an object. IN INITALLAPPLICATION made by @krishnapriya_Anu with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@supriya117 made 45 posts!

@raja.arslankhan made 44 posts!

Top 3 Most Liked Posts

This post made by @hikumar received 6 likes!

Can anyone give me RPAChallange with best practices file

Can some one please give RPAChallange XML file all done with best practices, and can someone verify if any other best practices can be implemented

This post made by @supermanPunch received 2 likes!

How do I change values of a table in extraction results?

Hi @sharon.palawandram , I was able to check on the modification to be done by using Json Serialize and Deserialize Methods. Inspecting the Extraction Results Json : First off, our taxonomy would always be fixed, this would also mean that the Table columns defined would also be fixed. Keeping that in mind, we can at the beginning check the extractionResults value by Serializing it to a String, so right after the Data Extraction Scope (I performed it in Extraction Rules Check workflow of DU F…

This post made by @raja.arslankhan received 2 likes!

Installation of multiple robots on one windows server

@DamilolaAdeogun Yes it is possible when you have mutilple users on one windows server. Suppose I have Window server and 20 users can login in that server then you can configure 20 Robots. Install UiPath Orchestrator: UiPath Orchestrator is a web application that provides centralized management and control for your robots. Install UiPath Orchestrator on the Windows Server by following the installation guide provided by UiPath. Configure UiPath Orchestrator: Once Orchestrator is installed, con…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

How do I change values of a table in extraction results?

Hi @sharon.palawandram , I was able to check on the modification to be done by using Json Serialize and Deserialize Methods. Inspecting the Extraction Results Json : First off, our taxonomy would always be fixed, this would also mean that the Table columns defined would also be fixed. Keeping that in mind, we can at the beginning check the extractionResults value by Serializing it to a String, so right after the Data Extraction Scope (I performed it in Extraction Rules Check workflow of DU F…

This solution provided by @Yoichi received 1 likes!

Is there a better way to write strings that contain quotes?

Hi, Can you try to use JObject as the following? [image] Regards,

This solution provided by @raja.arslankhan received 1 likes!

Dynamic Selector can't find the item!

@170290064 Before click or check state print the value? I suggest use minimum variable in selector, one or 2 is enough. second Check spaces aside value.

---

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

Top 3 Topics with Most Views

Unable to run nupkg file made by @zeesh19791 with 46 views.

Can you run uipath automation from browser made by @sara.andonova with 39 views.

Illegal characters in path when using Directory.GetFiles on WebDav made by @Joachim with 38 views.

Top 3 Topics with Most Replies

I have the output excel in the Initialize All Applications I want to read the excel pass the argument as a data row to the Process state made by @krishnapriya_Anu with 39 replies.

Duplicate / Move sheet from Excel B to Excel A made by @SyafiqKCS with 25 replies.

Sheet name modification made by @T_Y_Raju with 24 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 73 posts!

@Anil_G made 57 posts!

@supriya117 made 46 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 2 likes!

State of the Automation Professional report 2023 is here!

@Oana_Chicioroaga Wao Amazing

This post made by @raja.arslankhan received 2 likes!

State of the Automation Professional report 2023 is here!

@Oana_Chicioroaga Thanks for kind words. Being a developer I always try to learn from every plarform and share knowledge to convert it into wisdom.

This post made by @Yoichi received 2 likes!

Windows 10で別のモニタにウィンドウを移動する方法

こんにちは １．MoveWindowで座標(0,0)に移動でいかがでしょうか？ [image] ２．ショートカット操作でいかがでしょうか？ [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Windows 10で別のモニタにウィンドウを移動する方法

こんにちは １．MoveWindowで座標(0,0)に移動でいかがでしょうか？ [image] ２．ショートカット操作でいかがでしょうか？ [image]

This solution provided by @Yoichi received 2 likes!

Illegal characters in path when using Directory.GetFiles on WebDav

Hi, It seems your path string ends with 0x00 (special character). So can you try to remove it OR use Trim(chr(0)) as the following? "your path string".Trim(chr(0)) [image] Regards,

This solution provided by @Yoichi received 1 likes!

.nupkgをbatファイルで起動した場合Excelアクティビティが正常に実行できない。

よくあるケースとして、対象ファイルを相対パスで記述している場合は、 書き込んだ（と思っている）ファイルが異なるケースがあります。 nupkgを指定した場合、プロジェクトフォルダは c:\Users\ユーザー名\.nuget\パッケージ名\バージョン 以下の深いところになりますので、そちらのファイルが更新されていないか 確認してみてはと思います。

---

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 | 13 July 2023

Top 3 Topics with Most Views

Authentication failed because the remote party sent a TLS alert: ‘DecodeError’ made by @shreyash_shirbhate with 48 views.

Finding Index of Duplicate Entries using linq query made by @yash.choursia with 47 views.

Get the total count of files and paste that in excel made by @Priyesh_Shetty1 with 47 views.

Top 3 Topics with Most Replies

How can i run studio's scripts using Studio X made by @rania.mohamed1 with 37 replies.

Illegal Path Error made by @marina.dutta with 30 replies.

Get the total count of files and paste that in excel made by @Priyesh_Shetty1 with 27 replies.

Top 3 Users Who Posted The Most

@supriya117 made 57 posts!

@raja.arslankhan made 52 posts!

@Anil_G made 51 posts!

Top 3 Most Liked Posts

This post made by @supriya117 received 2 likes!

How to check whether the string in datatable is completely included?

Hi @Bosch If you want to check whether the person name present in the datatable or not then you can use this linq query. nameExists = dataTable.AsEnumerable().Any(Function(row) row.Field(Of String)("Name") = personName) Here personName is a string variable contains the person name.

This post made by @pravallikapaluri received 1 likes!

Line break

Hi @DimitriLYR Use Trim function In the Place of Fruits give Columnname CurrentRow(“Fruits”).ToString.Trim [image] Hope it helps!!

This post made by @postwick received 1 likes!

Comparison between String and Dictionary's Key Value

This needs to be CDbl(dictVar(“No1”).ToString) And they don’t want to compare No1 to No2. They want to see if the value 5 is in the dictionary.

Top 3 Most Liked Solutions

This solution provided by @raja.arslankhan received 1 likes!

How to pass Multiple Values to Attributes of Element Exists Activity

@Bhavesh_Batra Documentation: https://docs.uipath.com/studio/standalone/2023.4/user-guide/regex-search With one element exist approach is not reliable in case of two different selectors. I prefer solve it through regex selector and use one element exist.

This solution provided by @drbuddepu received 1 likes!

Cannot indicate the Extract Table Data Activity

@170290064 Extend the target in properties and copy the whole strict selectors. Open the fuzzy selectors and clear the selectors and paste the strict selectors and hit on save. In targeting method uncheck the strict selector and check the fuzzy selectors and save the program. [MicrosoftTeams-image] Hope it helps!!

This solution provided by @supermanPunch received 1 likes!

How to check whether the string in datatable is completely included?

Hi @Bosch , From the data available and results mentioned, we can understand that if all the words in the name are present in the Datatable column values, then it is an acceptable case. Hence, we can first split the Name with Space, so we get the array of words. Then we check if all the words are present in the column cell and then mark the result accordingly. Splitting of the word to an Array : wordsInNameArray = Split(Name).ToArray Here, wordsInNameArray is a variable of type Array of S…

---

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

Top 3 Topics with Most Views

For each fails on one process but executes on another process made by @nmjvk with 48 views.

I need some guidance to complete this task made by @Tengku_Aliff with 47 views.

Invoice Automation challenge failed made by @kowsi with 40 views.

Top 3 Topics with Most Replies

Issue in Reading Regex value from excel made by @hansen_Lobo with 27 replies.

How to insert a very large string into a table in SQL made by @nmjvk with 22 replies.

The name 'Split' does not exist in the current context made by @cemenike with 21 replies.

Top 3 Users Who Posted The Most

@Anil_G made 103 posts!

@mkankatala made 57 posts!

@raja.arslankhan made 48 posts!

Top 3 Most Liked Posts

This post made by @Rohit_Radhakrishnan received 4 likes!

UiPath Platform Infrastructure Series

To all the platform Infrastructure engineers in #UiPathCommunity we got great news!!! We’re back with UiPath Platform Infrastructure series with a great line-up of topics led by our Technical Account Management team! Register Now for all sessions and block your seats! :next_track_button:Standalone UiPath Orchestrator Upgrade (IAAS/PAAS) Registration Link :spiral_calendar:Date & Time: July 18, 6.30pm IST onwards :next_track_button:Orchestrator Insights (looker) Installation Re…

This post made by @Yoichi received 2 likes!

Studio起動時ウィンドウのデフォルトサイズの設定方法

こんにちは 最大化か通常サイズかは、終了時の状態が保持されないでしょうか？ あるいは C:\Users\ユーザー名\AppData\Roaming\UiPath にあるUiStudio.v2.Settingsの <profile key="Development">配下の d2p1:MainWindowState要素の値をMaximizedにすると 最大化で開きます。 [image]

This post made by @JennZabba received 2 likes!

Depending on the content of an excel file - insert rows

It works thank you sir.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Depending on the content of an excel file - insert rows

Hi, Can you try the following sample? [image] NewBlankTask20230714-1.zip (66.1 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Filter QueueItems on Specific Content via API

@toke.jacobsen Queue item fields are not exposed this way …you need to use it like this with contains contains(SpecificData,'"Key1":"value1"') odata/QueueItems?%24filter=contains(SpecificData,'"Key1":"value1"') Hope this helps cheers

This solution provided by @jabbar18243 received 1 likes!

How to Use Chrome Console in Uipath

Please refer below Attachment with solution. Chrome Console.zip (3.0 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 | 15 July 2023

Top 3 Topics with Most Views

I can't click on the print dialog made by @Natan_Crespo with 48 views.

How to transfer value from one excel workbook to another excel workbook? made by @helpplease with 41 views.

Click activity not working in Selector Issues made by @marina.dutta with 39 views.

Top 3 Topics with Most Replies

How to transfer value from one excel workbook to another excel workbook? made by @helpplease with 30 replies.

I can't click on the print dialog made by @Natan_Crespo with 22 replies.

API - DeSerialize JSON -UiPath Studio made by @Salman_Faries with 19 replies.

Top 3 Users Who Posted The Most

@lrtetala made 32 posts!

@vrdabberu made 29 posts!

@raja.arslankhan made 17 posts!

Top 3 Most Liked Posts

This post made by @Ameeruddin_Syed received 2 likes!

I am just entering Details in sequence and I am confronting these erroes

Thank you forum members for giving replies with love. At first I’m afraid that I would be scolded alike in StackOverflow. I am delighted that this forum treats rookies with respect…

This post made by @mkankatala received 1 likes!

I can't click on the print dialog

Hi @Natan_Crespo For click activity that you are using to click on save button make the input mode to hardware events, you can find the input mode option in click activity properties. Why because when you click on print it will open a window which is the desktop application for the desktop applications we have to use the hardware events as input mode of any UI activity. Hope it helps!!

This post made by @ty4 received 1 likes!

Lesson2_DoubleUIについて(動画1:34)

@lrtetala Thank you for your kind attention! It’s done, and I appreciate it! [image]

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

How to open Outlook

Hi @siddhi Use the start process activity and pass the path as mentioned and it will open the outlook automatically [image] Regards

This solution provided by @lrtetala received 1 likes!

API - DeSerialize JSON -UiPath Studio

@Salman_Faries Newtonsoft.Json.Linq.Jobject [image]

This solution provided by @EarlA received 1 likes!

No Row At Position 0

My suspicion that UiPath was attempting to create the variable at the beginning of the sequence before the table has been created was correct. I added an If activity to the sequence which I used to work with the first and second cells in the table and it worked properly. Just part of learning the ropes. I have managed to complete my first fully functional script. @raja.arslankhan and @postwick, thank you for your assistance.

---

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

Top 3 Topics with Most Views

UI questions made by @Latifa with 42 views.

Acme-test.uipath.com is not responding made by @Diana_Dinh-Andrus with 37 views.

Process Next Transaction Item In Case Of Business Rule Exception made by @marina.dutta with 35 views.

Top 3 Topics with Most Replies

Cannot communicate with browser u made by @Yazan_Otaibi with 27 replies.

Process Next Transaction Item In Case Of Business Rule Exception made by @marina.dutta with 22 replies.

Acme-test.uipath.com is not responding made by @Diana_Dinh-Andrus with 14 replies.

Top 3 Users Who Posted The Most

@lrtetala made 37 posts!

@Anil_G made 27 posts!

@mkankatala made 23 posts!

Top 3 Most Liked Posts

This post made by @170290064 received 2 likes!

How to change Queue reference?

[image] Done [image] I’m still at the basic level. Thanks for answers. I appreciate you all. @lrtetala @Anil_G @supermanPunch @vrdabberu @Parvathy

This post made by @lrtetala received 1 likes!

Extraction of table data from pdf

@Amit_Kumar_Charde Can you provide sample pdf how it looks then we will understand how to do. Try with Document Understanding

This post made by @Anil_G received 1 likes!

Performer n Dispatcher

@Latifa Think like this whatever needs to happen till adding queue items generally happen in the fispatcher part…So thinking on these lines decide your answer…As you wanted help only in thinking I am not giving you the answer. Hope this helps Cheers

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Performer n Dispatcher

Hi @Latifa The answer would be Option A It will retrieve the mails from Outlook account and extract the rental reservation data from current mail and add it to queue, Regards

This solution provided by @lrtetala received 1 likes!

Issue with preview on HTTP Request Activity

@Salman_Faries 1.Once upgrade the package then try 2.Ensure that you are using the latest version of UiPath Studio and any relevant packages related to HTTP activities. Updating to the latest version may resolve any known issues or bugs. 3.Check the internet connection: Ensure that your computer has a stable internet connection. Test accessing other websites or resources to confirm that your internet connection is working properly. 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 | 17 July 2023

Top 3 Topics with Most Views

Replying to problem made by @dolx with 55 views.

Bot failing in RDP session made by @logesh_kumar1 with 55 views.

Convert Datetime to Date made by @ManjunathReddy with 52 views.

Top 3 Topics with Most Replies

Replying to problem made by @dolx with 41 replies.

Transaction item failed? made by @170290064 with 36 replies.

How to move/copy latest downloaded excel files? made by @Muhamad_Izwan_Bin_Hamran with 27 replies.

Top 3 Users Who Posted The Most

@Anil_G made 140 posts!

@mkankatala made 68 posts!

@vrdabberu made 51 posts!

Top 3 Most Liked Posts

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

What are the usecase of Orchastrotor on premisse

Both are the same product. The difference is on-prem Orchestrator needs to be deployed on your own server which you will need to configure and prepare from scratch. Cloud one is already deployed and you just need to set it up for your company and allow the traffic to go through it so robots can work like they should. More details can be found here: https://docs.uipath.com/overview/other/latest/overview/orchestrator-differences On-Premise and Cloud Orchestrators both have their own advantages …

This post made by @Povilas_Jonikas received 2 likes!

Http request Wizard parameters with the same name

Both @Anil_G and @lrtetala were crucial with their knowlage towards my problem. Both of u guys are legends. Thanks!

This post made by @pere received 1 likes!

How to Identify whether Windows application already running or not

Hi, I’d wish to know what’s that “element exist activity” you’re talking about, as I can’t find any activity with that name. Thanks

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Http request Wizard parameters with the same name

Hi @Povilas_Jonikas To construct the URL-encoded query string, you can use the String.Format method or string concatenation to build the body as a string. Here’s an example: "username=signeda" + "&password=" + Uri.EscapeDataString("aaaaaaaaaaa") + "&user_token=" + Uri.EscapeDataString("aaaaaaaaaaaaaaaa") + "&car_id=" + Uri.EscapeDataString(CurrentRow.Item("car_id").ToString) + "&category_id=" + Uri.EscapeDataString(CurrentRow.Item("category_id").ToString) + "&quality=" + Uri.EscapeDataString(C…

This solution provided by @Irene received 1 likes!

Extracting and Saving Multiple IDs from a Single Cell in UiPath

Hi, if you’re expecting a fixed number of variables, then you can just keep it simple and use a multi-assign statement instead, in which you can set the variables as: ID1 = arrValue (0) ID2 = arrValue (1) ID3 = arrValue (2) I don’t see the benefit of using a loop if ultimately you always have a fixed amount of values. The loop makes sense if you want to make your procedure more dynamic (for example, if the number of values changes, or if you want to apply the same exact behavior in the b…

This solution provided by @mkankatala received 1 likes!

Variable or argument is not defined in the current scope- while making selector dynamic

@Sami_Rajput bro delete that activity and place the activity, then indicate the element and pass the variable in the attributes in selector options window. Make sure to check the override default value option when pass variable to selector. It’s working when doing this, already tried this it worked

---

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

Top 3 Topics with Most Views

Excel Filter Question! made by @170290064 with 54 views.

I want to loop through and log message check or uncheck made by @Bhushan_Nagaonkar with 53 views.

Questions about UiPath Pro made by @aquinn with 53 views.

Top 3 Topics with Most Replies

I want to loop through and log message check or uncheck made by @Bhushan_Nagaonkar with 39 replies.

Excel Filter Question! made by @170290064 with 37 replies.

How to work with Remote debugging made by @divya.17290 with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@mkankatala made 53 posts!

@Vikas_M made 51 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Data Group and Filter Problem

Hi, How about the following sample? [image] Sample20230718-1aL.zip (21.0 KB) Regards,

This post made by @Anil_G received 1 likes!

Get Attribute: Attribute not supported by the current UiNode in dropdown select (Help)

@gustavo.souza What is the selector ? and what are you trying to get? if it is the select item value…then may be in your selector you are using some aaname or innertext which changes for each select cheers

This post made by @Quenton_Wayne_Rebello received 1 likes!

Comparing values and adding data to one data table

yes it will give both matched and unmatched as per the sheet given

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to convert String to dictionary

HI, How about the following? [image] dict = System.Text.RegularExpressions.Regex.Matches(yourString,"(?<={"")([^{}]*?)"",""([^{}]*?)(?=""})").Cast(Of System.Text.RegularExpressions.Match).ToDictionary(Function(m) m.Groups(1).Value,Function(m) m.Groups(2).Value) Sample20230817-4L.zip (2.6 KB) Regards,

This solution provided by @raja.arslankhan received 1 likes!

Parsing question

@A_Learner Try Through Regex: [image]

This solution provided by @Anil_G received 1 likes!
https://forum.uipath.com/t/564088/4

---

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

Top 3 Topics with Most Views

Anyone knows why I am experiencing this? made by @attkren1 with 61 views.

LINQ query error made by @yash.choursia with 53 views.

Find largest prime number in a given set of numbers . Can anyone help me please how to do made by @sandhyareddy with 46 views.

Top 3 Topics with Most Replies

How to solve this error issue? made by @attkren1 with 28 replies.

Loop through all excel workbook sheets and write data in to each subfolders sheet by sheet made by @POOJA_MARUTI_BALIGIDE with 25 replies.

I am getting this error, please help me , how to made by @munichandra_kuppani with 23 replies.

Top 3 Users Who Posted The Most

@supriya117 made 76 posts!

@mkankatala made 63 posts!

@lrtetala made 55 posts!

Top 3 Most Liked Posts

This post made by @Quenton_Wayne_Rebello received 3 likes!

Excel Filter Question!

To get the data in the format mentioned you can use the linq, (From row In dtInput.AsEnumerable() Group row By ModelPrefix = If(row(“Model”).ToString().Length >= 4, row(“Model”).ToString().Substring(0, 4), row(“Model”).ToString()) Into Group Let GroupedYıl = String.Join(“,”, Group.Select(Function(r) r(“Yıl”).ToString())) Let GroupedKM = String.Join(“,”, Group.Select(Function(r) r(“KM”).ToString())) Let GroupedFiyat = String.Join(“,”, Group.Select(Function(r) r(“Fiyat”).ToString())) Select …

This post made by @supermanPunch received 2 likes!

Regex everything between 9 digit numbers

Hi @JenJen , Could you check with the below Regex Expression : (?<=\d{9})[\s\S]+?(?=\d{9}|Page) [image] Here, An assumption is also made that the Page keyword will always be present after the last address data. Let us know if it is not the case, we can identify a separate limiter.

This post made by @supriya117 received 2 likes!

Copy the data from body of the browser outlook & save it in a variable

@Somanath_Somu Use the “Send Hotkey” activity to simulate pressing Ctrl+A (select all) Use the “Send Hotkey” activity again to simulate pressing Ctrl+C (copy) Use the “Get from Clipboard” activity to retrieve the copied text from the clipboard and store it in a variable.

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 3 likes!

Excel Filter Question!

To get the data in the format mentioned you can use the linq, (From row In dtInput.AsEnumerable() Group row By ModelPrefix = If(row(“Model”).ToString().Length >= 4, row(“Model”).ToString().Substring(0, 4), row(“Model”).ToString()) Into Group Let GroupedYıl = String.Join(“,”, Group.Select(Function(r) r(“Yıl”).ToString())) Let GroupedKM = String.Join(“,”, Group.Select(Function(r) r(“KM”).ToString())) Let GroupedFiyat = String.Join(“,”, Group.Select(Function(r) r(“Fiyat”).ToString())) Select …

This solution provided by @supermanPunch received 2 likes!

Regex everything between 9 digit numbers

Hi @JenJen , Could you check with the below Regex Expression : (?<=\d{9})[\s\S]+?(?=\d{9}|Page) [image] Here, An assumption is also made that the Page keyword will always be present after the last address data. Let us know if it is not the case, we can identify a separate limiter.

This solution provided by @supriya117 received 2 likes!

Copy the data from body of the browser outlook & save it in a variable

@Somanath_Somu Use the “Send Hotkey” activity to simulate pressing Ctrl+A (select all) Use the “Send Hotkey” activity again to simulate pressing Ctrl+C (copy) Use the “Get from Clipboard” activity to retrieve the copied text from the clipboard and store it in a 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.

[system]

Daily Forum Report | 20 July 2023

Top 3 Topics with Most Views

Unable to Trigger made by @sathya_auto with 43 views.

Add Data Column Error like in the following made by @170290064 with 42 views.

バッググラウンド実行でのChromeの印刷について made by @y.c with 42 views.

Top 3 Topics with Most Replies

I am trying to copy CSV file into excel file? How can I do? made by @Samraat_Maharjan1 with 49 replies.

Rename File: Could not find a part of the path made by @gustavo.souza with 30 replies.

Clicking next on Dynamic selector and extract data for each "Name" made by @Irfan_Musa with 21 replies.

Top 3 Users Who Posted The Most

@mkankatala made 60 posts!

@lrtetala made 55 posts!

@postwick made 53 posts!

Top 3 Most Liked Posts

This post made by @B_H_Akshatha_Pai received 2 likes!

Clicking next on Dynamic selector and extract data for each "Name"

@Irfan_Musa try deleting the content of aaname in the selector , also keep the text as “ignore text”

This post made by @B_H_Akshatha_Pai received 2 likes!

Scope of Read Range Excel Activity

Hey there ! Just change the scope of the variable in the variable pannel such that it is available in the entire scope [Screenshot (10)] Keep the scope to the lower most process Regards,

This post made by @mkankatala received 2 likes!

Type into: Indicate in Excel failed, cannot attach to document

Hi @jan.alemany Use the two read range workbook activity to read the two sheets in the excel. In first read range workbook give the sheet name of first sheet name, store it to dt1 and in second read range workbook give the sheet name of second sheet, store it to dt2. Use for each row in datatable activity to iterate the dt1 inside this activity use another for each row in datatable activity to iterate the dt2. Inside second for each take If activity in that activity write the condition which…

Top 3 Most Liked Solutions

This solution provided by @B_H_Akshatha_Pai received 2 likes!

Scope of Read Range Excel Activity

Hey there ! Just change the scope of the variable in the variable pannel such that it is available in the entire scope [Screenshot (10)] Keep the scope to the lower most process Regards,

This solution provided by @mkankatala received 2 likes!

Type into: Indicate in Excel failed, cannot attach to document

Hi @jan.alemany Use the two read range workbook activity to read the two sheets in the excel. In first read range workbook give the sheet name of first sheet name, store it to dt1 and in second read range workbook give the sheet name of second sheet, store it to dt2. Use for each row in datatable activity to iterate the dt1 inside this activity use another for each row in datatable activity to iterate the dt2. Inside second for each take If activity in that activity write the condition which…

This solution provided by @vrdabberu received 1 likes!

Regex Date help

@A_Learner You can use the below regex if you want to avoid the open date ([A-Z]+[a-z]+\s?\d+\,?\s+\d+)|(\d{2}\/\d+\/\d+) [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 | 21 July 2023

Top 3 Topics with Most Views

Assistantでロボットインストールエラーについて made by @kimjinseong with 51 views.

If activity Suggestion made by @yeshwanth with 50 views.

Deleting rows of a datatable using starting index and ending index made by @yash.choursia with 46 views.

Top 3 Topics with Most Replies

If activity Suggestion made by @yeshwanth with 27 replies.

How to find max and min price in the table with linQ method? made by @170290064 with 22 replies.

Excel appears to be busy - but I have kill actvity before made by @anon40731888 with 20 replies.

Top 3 Users Who Posted The Most

@lrtetala made 50 posts!

@Anil_G made 41 posts!

@supriya117 made 36 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

Deleting rows of a datatable using starting index and ending index

Hi @yash.choursia Use Remove Data Row activity to remove rows [image] If you want to delete the columns use Remove Data Column activity [image] or use [image] I hope it helps!!

This post made by @Yoichi received 2 likes!

Gmail のメールのリストを取得アクティビテイ

こんにちは 一番手っ取り早い方法は、当該プロパティを選択して編集状態にして Ctrl+Kとして変数名を入力すると、自動的にその型の変数が生成されます。 あるいは変数パネルでBrowseForTypeを選択し、まずはList<と入力し、表示されるプルダウンから再度BrowseForTypeを選択してから、GmailMEssageを選択してください。 [image]

This post made by @nicklys received 1 likes!

UiPath Community HyperHack 2023 is LIVE! Register Now!

Thank you very much, it has been approved. Please have a nice day.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Gmail のメールのリストを取得アクティビテイ

こんにちは 一番手っ取り早い方法は、当該プロパティを選択して編集状態にして Ctrl+Kとして変数名を入力すると、自動的にその型の変数が生成されます。 あるいは変数パネルでBrowseForTypeを選択し、まずはList<と入力し、表示されるプルダウンから再度BrowseForTypeを選択してから、GmailMEssageを選択してください。 [image]

This solution provided by @B_H_Akshatha_Pai received 1 likes!
https://forum.uipath.com/t/565279/3

This solution provided by @supriya117 received 1 likes!

How to pick each one value from an array

@Sudheer_Kumar_S If it’s an array try like this: res = MyArray.Last If it’s string: res = MyStr.Split(" ").Reverse()(0)

---

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.