Forum Engagement Daily Reports

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

[system]

Daily Forum Report | 22 July 2023

Top 3 Topics with Most Views

Send Status Email made by @marina.dutta with 45 views.

Date changed after I transpose table made by @helpplease with 42 views.

How do I add headers to all my excel sheets made by @Conning with 35 views.

Top 3 Topics with Most Replies

Send Status Email made by @marina.dutta with 21 replies.

UiElement cannot be converted to 'String' Error made by @170290064 with 17 replies.

I cannot print some data while printing data made by @tolgademir with 15 replies.

Top 3 Users Who Posted The Most

@lrtetala made 16 posts!

@Vikas_M made 15 posts!

@Anil_G made 15 posts!

Top 3 Most Liked Posts

This post made by @helpplease received 1 likes!

Date changed after I transpose table

ok, thank you for the explanation.

This post made by @tolgademir received 1 likes!

I cannot print some data while printing data

I want to make a correction. When I formatted the cells in my Excel table as strings, the problem was solved without the need for other methods. Previous data format was general format [Adsız]

This post made by @fernando_zuluaga received 1 likes!

For Each Excel Row I get error

Hi @Favarelaa For Each Excel row will loop through your excel rows For Each Row in Data Table will loop through yout datatable items based on that to loop with excel you should use this expression [image] Excel.Sheet("Sheet").Range("") Regards!

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

For Each Excel Row I get error

Hi @Favarelaa For Each Excel row will loop through your excel rows For Each Row in Data Table will loop through yout datatable items based on that to loop with excel you should use this expression [image] Excel.Sheet("Sheet").Range("") Regards!

This solution provided by @Yoichi received 1 likes!

スプレッドシートの範囲を読み込み

こんにちは 「範囲」の指定が正しいか確認できますでしょうか？ プルダウンから選択しましたか？あるいは詳細エディタで入力していますか？後者の場合特に注意が必要かと思います。

---

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

Top 3 Topics with Most Views

ElementExists timed out made by @rpn_mail with 43 views.

How to fasten vlookup made by @Nur_Amin with 42 views.

Cant find the Inject JS Script Activity made by @Hugen_Dugen with 42 views.

Top 3 Topics with Most Replies

Practice - Book Sales Report made by @kimberly.lin with 27 replies.

How to fasten vlookup made by @Nur_Amin with 25 replies.

Cant find the Inject JS Script Activity made by @Hugen_Dugen with 16 replies.

Top 3 Users Who Posted The Most

@lrtetala made 26 posts!

@Anil_G made 26 posts!

@Parvathy made 11 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

Windows Exploeer: Get file path, file name and creation date from folder and all subfolders into an Excelfie

@hagen [image] [image] [image] Is it okay

This post made by @vrdabberu received 1 likes!

Can someone explain how to do lookup from one excel to another excel

@madhav_ravi Please refer the below attached xaml file it might help you. sample.xaml (67.3 KB) test (2).xlsx (10.4 KB) Hope it works!!

This post made by @Vikas_M received 1 likes!

Add Headers of Data Table in HTML Editor Send Email Activity (Adding DataTable in Email Body)

@marina.dutta While writing the data table to Excel u have to check the add headers property And while reading it from excel uncheck add headers, and check the Preserve Format Property And then pass that DT variable to HTML content , You will get headers in your output [image] [image] bELOW IS THE OUTPUT [image] Note: Dont forget to Map the New DT in your HTML content Happy Automation!

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Windows Exploeer: Get file path, file name and creation date from folder and all subfolders into an Excelfie

@hagen [image] [image] [image] Is it okay

This solution provided by @vrdabberu received 1 likes!

Can someone explain how to do lookup from one excel to another excel

@madhav_ravi Please refer the below attached xaml file it might help you. sample.xaml (67.3 KB) test (2).xlsx (10.4 KB) Hope it works!!

---

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

Top 3 Topics with Most Views

Edge Extension not working - Could not communicate made by @Daniel_H-E with 251 views.

The robots couldn't communicate with Private mode of MS Edge browser made by @Mohammed_Bakr with 98 views.

🎯 UiPath Tutorial: Using the Pick Activity made by @ManFrancko with 53 views.

Top 3 Topics with Most Replies

3 Excel Reading made by @Gokul_Murali with 43 replies.

Unable to read unread mail made by @Mathkar_kunal with 25 replies.

Write Cell: Object reference not set to an instance of an object. Error made by @HENG_JUN_YING_AARON with 23 replies.

Top 3 Users Who Posted The Most

@mkankatala made 68 posts!

@Anil_G made 57 posts!

@lrtetala made 52 posts!

Top 3 Most Liked Posts

This post made by @Vikas_M received 3 likes!

Managing Data Table columns

Hey @Luis_Fernando , If you want to add only specified columns to Orchestrator then follow below steps Input datatable snapshot [image] Filtered Datatable snapshot (I removed AGE and SALARY columns) [image] Below is the Output of Filter Datatable [image] After filtering you can add the filtered Datatable to "Bulk Add Queue Items " Below is the Workflow Snapshot [image] Hope it helps You! Happy Automation!

This post made by @Mohammed_Bakr received 2 likes!

The robots couldn't communicate with Private mode of MS Edge browser

Hi after the last update of MS Edge, there is an issue with the extension of UiPath… the extension is installed and enabled but still, the robot is not able to communicate with the browser in Private mode… I tried to: disable and enable the extension. reinstall the extensions uninstall and reinstall the studio but unfortunately same issue … after a lot of investigation, I found that when the robot is opening Edge in normal mode there is an application called (Chrome Native Messaging Hos…

This post made by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

Top 3 Most Liked Solutions

This solution provided by @Quenton_Wayne_Rebello received 2 likes!

FIlling excel using LINQ

Dim previousColumn7 As String = "" Dim previousColumn9 As String = "" For Each row As DataRow In dataTable.Rows Dim column7Value As String = If(String.IsNullOrEmpty(row("Column7").ToString()), previousColumn7, row("Column7").ToString()) Dim column9Value As String = If(String.IsNullOrEmpty(row("Column9").ToString()), previousColumn9, row("Column9").ToString()) row("Column7") = column7Value row("Column9") = column9Value previousColumn7 = column7Value previousColumn9 = col…

This solution provided by @pravallikapaluri received 1 likes!

Activities in version 2023

Hi @Pratik_Chaudhari1 Install the UiPath.excel.Activities [image] Hope it helps!!

This solution provided by @Yoichi received 1 likes!

Regex match question

Hi, According to your pattern, you want to match not only MM/dd/yyyy style but also MMMM/dd/yyyy style (such as July 25,2023) don’t you? If so, the following pattern will work. System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Statement\s+(Issued\s+)?)(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?|Sep(tember)?|Oct(ober)?|Nov(ember)?|Dec(ember)?)\s?\d+,?\d+|(\d{1,2}/\d{1,2}/\d{2,4}|\d{1,2}-(Jan(uary)?|Feb(ruary)?|Mar(ch)?|Apr(il)?|May|Jun(e)?|Jul(y)?|Aug(ust)?…

---

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

Top 3 Topics with Most Views

MV3 browser extensions are broken when starting Edge v115 with InPrivate option made by @Luiza_Surdu-Bob with 131 views.

Edge extension not working in Incognito mode made by @Oana_Georgiana_Vasile with 66 views.

Error when Open Browser in private : Cannot communicate with the browser, please check the UiPath extension made by @marc.loppion with 50 views.

Top 3 Topics with Most Replies

Excel Extension made by @Kuldeep_Pandey with 27 replies.

Delete Sheet Item made by @Shivam_Rana with 25 replies.

How to store the extracted tables data in an excel sheet made by @raju_alakuntla with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@lrtetala made 50 posts!

@mkankatala made 45 posts!

Top 3 Most Liked Posts

This post made by @Luiza_Surdu-Bob received 3 likes!

MV3 browser extensions are broken when starting Edge v115 with InPrivate option

The latest Microsoft Edge browser update to version 115.0.1901.183 introduced a bug regarding the initialization of MV3 extensions for Edge started “InPrivate” mode. This issue affects all MV3 extensions, not just the UiPath Extension for Microsoft Edge. We have reported this issue to Microsoft as an Edge bug and are waiting for their review. Observed behavior When Microsoft Edge browser is started using: the Open Browser activity with Options → Private property set to True or the Use Appl…

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

Developing a Star Rating Design using UiPath Apps

[Developing a Star Rating Design using UiPath Apps]

This post made by @Manish540 received 2 likes!

How to use Success Factor Activities

Hi @Deeipauk , Check this below link, https://docs.uipath.com/activities/other/latest/legacy-integrations/successfactors-scope Hope this might help you

Top 3 Most Liked Solutions

This solution provided by @MohammedKher_Kibabi received 1 likes!

Can't open UiPath Orchestrator - it's hanging and entering into redirect loop

Welcome @Filipe_Vitorino1 I resolved this issue by synchronize the PC Time from the control panel → time zone settings

This solution provided by @lrtetala received 1 likes!

Linq for joining 2 columns

Hi @yashchoursia25 Please try this (From d In InputFile.AsEnumerable() Group d By k1 = d(6).ToString().Trim(), k2 = d(8).ToString().Trim() Into grp = Group Let s13 = String.Join(",", grp.Select(Function(x) x(13).ToString())) Let s12 = String.Join(",", grp.Select(Function(x) x(12).ToString())) Let ra = New Object() {k1, k2, s12, s13} Select joiningDT.Rows.Add(ra)).CopyToDataTable() Regards,

This solution provided by @vrdabberu received 1 likes!

Checking Excel calculation is complete before extracting data

@clark.coleman Use the “Excel Application Scope” activity to open the Excel file and perform operations on it. After pressing F9 (manually or programmatically), use the “Send Hotkey” activity to send the F9 key to Excel. This will trigger the recalculation of the spreadsheet. Use the “Delay” activity to introduce a wait time after sending the F9 key. The duration of the delay depends on the complexity of your spreadsheet and the time it takes to finish calculating. You may need to experiment …

---

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

Top 3 Topics with Most Views

Important updates in Orchestrator roles and permissions made by @sebastian.ungureanu with 415 views.

How to get the date from a specific day till today? made by @connect360 with 49 views.

Comparing Excel Row Values made by @marina.dutta with 42 views.

Top 3 Topics with Most Replies

Group by column and add other columns accordingly made by @tharaninatarajan1901 with 38 replies.

How to get the date from a specific day till today? made by @connect360 with 27 replies.

Need only classic activities made by @T_Y_Raju with 26 replies.

Top 3 Users Who Posted The Most

@mkankatala made 55 posts!

@Anil_G made 51 posts!

@lrtetala made 49 posts!

Top 3 Most Liked Posts

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

Important updates in Orchestrator roles and permissions

Hello, UiPath community! We’ve been collecting your feedback around setting up roles and permissions in Orchestrator, and are pleased to announce a few upcoming improvements in the initial setup experience, as well as some important changes to the Automation User role. When creating a new tenant, you will notice a better separation of group roles by default. The changes to the default seeding are as follows: Updated group: Automation Users will no longer be able to access the Orchestrator UI…

This post made by @rameshrangaraj1970 received 2 likes!

How do I simulate the keystrokes of keeping the "SHIFT" button pressed and simultaneously pressing "TAB"?

Thanks much All for your very quick reply. My problem got solved. Thanks once again!

This post made by @Yoichi received 2 likes!

How to get 2 words in both sides of some word

How about the following? System.Text.RegularExpressions.Regex.Replace(yourString,"^[\s\S]*\s+(\w+)\W+овогтой\W+(\w+)[\s\S]*$","$1 $2") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to get 2 words in both sides of some word

How about the following? System.Text.RegularExpressions.Regex.Replace(yourString,"^[\s\S]*\s+(\w+)\W+овогтой\W+(\w+)[\s\S]*$","$1 $2") Regards,

This solution provided by @Yoichi received 2 likes!

Get text gives me thousand separator with coma and I need it with dot

HI, How about using Replace method as the following? PR.Replace(",","_").Replace(".",",").Replace("_",".") This assumes there is no _ in the string. Regards,

This solution provided by @ppr received 1 likes!

In a list of string identify those with 3 out of 4 characters similar to each other

maybe this Quick dirty approach can help: uncommon [grafik] common [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 | 27 July 2023

Top 3 Topics with Most Views

How do I count the number of rows with same variable? made by @helpplease with 58 views.

Column not found made by @helpplease with 53 views.

Different date format made by @helpplease with 53 views.

Top 3 Topics with Most Replies

Compare two sheets and change color in both or any one of sheets made by @Bhushan_Nagaonkar with 30 replies.

How to insert images into excel cells made by @alexis.mendoza with 30 replies.

Need to find index of array value in text file made by @Anil_Rajavarapu with 29 replies.

Top 3 Users Who Posted The Most

@mkankatala made 67 posts!

@lrtetala made 58 posts!

@vrdabberu made 50 posts!

Top 3 Most Liked Posts

This post made by @helpplease received 3 likes!

What exactly are special keys?

Thank you all for the explanations! I really appreciate them

This post made by @brian.oberman received 2 likes!

Change Scheduled Delivery of Reports to be globally and centrally set up and managed

Today, you can schedule delivery of reports via email in Insights. However, ONLY the person/user that set up the schedule and see/change their own schedules. This is a problem. First, if the person that set up the report delivery leaves your organization, you cannot change/update/view the report without UiPath assistance. (Per UiPath documentation: " Schedules are user-specific and can only be viewed by the user that created them in the Schedule/Alert Settings section." Second, it creates th…

This post made by @Felix_Rech1 received 2 likes!

Add Collection argument to 'Add Log fields' Activity

Hey UiPath Team, please consider adding a new input argument to the ‘Add Log Fields’ activity that allows users to hand in a collection Object (dictionary) as an alternative to adding the fields manually one by one, similar to how the ‘Add Queue Item’ activity allows users to supply a variable/argument of type ‘Dictionary(String,Object)’ instead of adding the required fields manually (ItemInformation vs. ItemInformationCollection). This is currently not possible with the ‘Add log Fields’ activ…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

How to saperate json

@Mathkar_kunal , Apologies as I could not get the separate term intially in your Query. The concentration was more towards the last line of the query. Even for the Expected Results provided by you, we could use the Same Expression : To retrieve results other than 1322 : jArr1 = JArray.FromObject(jArr.Where(Function(x)Not x("testExecKey").toString.Equals("TEST81313-1322"))) To retrieve results with 1322 : jArr2 = JArray.FromObject(jArr.Where(Function(x)x("testExecKey").toString.Equals("TES…

This solution provided by @pravallikapaluri received 1 likes!

Read every PDF files with OCR

Hi @Temuulen_Buyangerel [image] [image] Hope it helps!!

This solution provided by @lrtetala received 1 likes!

Round off to a decimal number

Hi @adishjain Math.Ceiling(Var1 * Math.Pow(10, Round)) / Math.Pow(10, Round) [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.