Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 May 2021

Top 3 Topics with Most Views

Generating Array made by @Rakesh_Sampath with 30 views.

Copy a number of rows from Datatable to clipboard made by @acdeleon123 with 29 views.

UiPath Academy上級コース 課題提出について made by @shunsuke.ogata with 26 views.

Top 3 Topics with Most Replies

Error on expression made by @Sudharsan_Ka with 20 replies.

Hello I want to split the string made by @copy_writes with 13 replies.

列番号の特定 made by @111884 with 11 replies.

Top 3 Users Who Posted The Most

@postwick made 22 posts!

@Yoichi made 20 posts!

@sarathi125 made 17 posts!

Top 3 Most Liked Posts

This post made by @AnupamModak received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello All, Thanks for the welcome mail. Looking forward for some help in automating few tasks on ServiceNow.

This post made by @Michelle_Yurovsky received 2 likes!

Introducing UiPath Insights Cloud

Cloud Insights has unlimited viewers, but comes with a limitation of 10 designer users. You can always purchase more designer users if it makes sense.

This post made by @wasea received 2 likes!

Uipath regex

Hello @Sakshi_Jain , Did you had the chance to check this megapost? Vasile.

Top 3 Most Liked Solutions

This solution provided by @Pradeep_Shiv received 2 likes!

Loop checking whether a website has been opened

Hello @MrKezay , You can try using Re-Try Scope Activity,

This solution provided by @sarathi125 received 2 likes!

Hello I want to split the string

@copy_writes , Check with this split option strInput.Substring(strInput.IndexOf(",") + 1)

This solution provided by @N2027 received 1 likes!

UiPath Academy上級コース 課題提出について

提出するファイルは評価に一切影響しません。 なので、 ACME System 1サイトでの実行結果だけをよく確認した方がいいです。 それでも、うまくいかない場合は、新しくアカウント取得して、試してみてください。 アカウント自体の不具合も想定されます。

---

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

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

[system]

Daily Forum Report | 20 May 2021

Top 3 Topics with Most Views

エクセルのシート名の変更 made by @kawagolf with 31 views.

Studioと一緒にGitを使う？ made by @gorby with 29 views.

웹브라우저에서 파일 다운로드 시 폴더 경로 지정문의 made by @111882 with 28 views.

Top 3 Topics with Most Replies

Add Data Row: Error:Input array is longer than the number of columns in this table made by @Ashwini_Patil with 21 replies.

How to log and check data/values from a dataset? made by @AhmedKutraphali with 18 replies.

How to use macro filter excel? made by @fairymemay with 10 replies.

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@prasath17 made 19 posts!

@Divyanshu_Divyanshu made 17 posts!

Top 3 Most Liked Posts

This post made by @DaliyaK received 3 likes!

Join us for the UiPath 21.4 capabilities deep dive webinar series – gear up before DevCon!

Hi everyone! We are excited to introduce you the upgraded UiPath - :tada:version 21.4 ! Over the past year we’ve been working on improving your user experience and enabling your teams with flexible, fast tools to scale automation. From May 25 to June 3 we’ll host five walkthrough webinars on the UiPath 21.4 release where our product team and invited automation experts from Wells Fargo and Firstsource will share the platform updates and new opportunities they can unveil for you. You’ll…

This post made by @Corina_Gheonea received 2 likes!

Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16

The event is free of charge. You just need to ensure you register and you enjoy the sessions: RPA Developer Conference - DevCon 2021 | UiPath

This post made by @miwa_yamamoto received 2 likes!

ファイル名可変のフルパス設定がうまくいかない

ありがとうございます！！ 完全に見落としてました！ 本当にありがとうございます！ 無事、設定出来ました。

Top 3 Most Liked Solutions

This solution provided by @shinji received 2 likes!

ロボットをアイコン化する方法

（上記のbatと同様の仕組みですが） Version21.4以降では、UiPathアシスタントから、ショートカットを作成できるようになりました。参考まで

This solution provided by @Yoichi received 2 likes!

リモート接続について

こんにちは AutomationCloud の Resource Centerからダウンロードできます。 [img20210520-2] 併せて、リモート接続される端末にもUipath（studioまたはrobot？）の購入が必要なのかも知りたいです。 端末にUiPathのrobot等を導入しないのであれば不要です。

This solution provided by @shinji received 1 likes!

ファイル名可変のフルパス設定がうまくいかない

エラーメッセージに「5月月度」と書かれています。

---

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 May 2021

Top 3 Topics with Most Views

RPA France - Vulgarisation – Episode 1 : La RPA en bref made by @Hiba_B with 47 views.

Find date? made by @fairymemay with 41 views.

プロセスとロボット（Robot）の関係 made by @gorby with 35 views.

Top 3 Topics with Most Replies

How to search by month in the expression? made by @Wendy_wendy with 42 replies.

How to Delete the Datarow from excel using For Each row made by @Vincent_Nuestro with 20 replies.

Find date? made by @fairymemay with 18 replies.

Top 3 Users Who Posted The Most

@Wendy_wendy made 21 posts!

@Eric_Wong_Test made 16 posts!

@NIVED_NAMBIAR made 14 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 6 likes!

RPA France - Vulgarisation – Episode 1 : La RPA en bref

Qu’est-ce que la RPA ? La RPA, ou robotic process automation en anglais, est par définition l’automatisation des processus robotisés. En gros, c’est l’ordinateur qui reproduit tes actions, avec les mêmes accès que toi. Pourquoi la RPA devrait m’intéresser ? Que serait une journée de travail sans effectuer à la longue ces mêmes tâches : récupérer les pièces jointes des mails et les enregistrer dans un même dossier en les renommant, sai…

This post made by @seetharaman received 2 likes!

Dotsolved Systems - RPA developer - chennai - India - Full Time

Job title: RPA developer Job role: RPA Developer Country: India City: chennai Company name: Dotsolved Systems Employment Type: Full Time Seniority level: associate-3-to-5-years Job Description: Roles and Responsibilities : You will get a chance to work with very dynamic Center of Excellence team. You will get a chance to implement RPA solutions in complex business environments. You will be responsible for End-to-End process of implementing solutions, right from Requirement gathering to …

This post made by @Eric_Wong_Test received 2 likes!

How to search by month in the expression?

no need the id for r-359

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 1 likes!

Regular expression help for segregate special character

Hi @Duleepa_Krishan you can try this regex pattern [ more precise it seems] [image] Regards, Nived N

This solution provided by @gorby received 1 likes!

キューを作成するアクティビティはありますか？

キューをOrchestratorの画面以外から作成したいからこのような質問をした訳ではありません。Orchestratorを勉強していてキューが気になったので、キューを勉強しているだけです。あまり気にしないでください。

This solution provided by @ppr received 1 likes!

Index out of bounds of the array: Add data row activity

it looks to me that issue comes just from a saml confusion. just take a small break and then approach the implementation a little bit with distance to keep the overview: a datatable has columns, columns has datatypes - eg. Col1 (String),Col2 (Int32),Col3 (String) when adding a datarow we create the RowArray position in the array maps to corresponding DataColumn (0-Col1, 1-Col2 …etc) value is what we want to store Eg. var1 = “ABC” | Datatype: String, var2 = 34 | Datatype: Int32, var3 = “EFG” …

---

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 May 2021

Top 3 Topics with Most Views

Condition on excel sheet made by @rpa13 with 31 views.

Count number of files with variable made by @Saurabh_Grover with 27 views.

KintoneのHTTP要求(POST)の作成方法について made by @Timmy0303 with 25 views.

Top 3 Topics with Most Replies

Condition on excel sheet made by @rpa13 with 23 replies.

KintoneのHTTP要求(POST)の作成方法について made by @Timmy0303 with 12 replies.

If we select on the any type of browser its should open it our system ,if not in your system it shows the app is not there made by @kowshik with 11 replies.

Top 3 Users Who Posted The Most

@prasath17 made 11 posts!

@NIVED_NAMBIAR made 10 posts!

@rpa13 made 10 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 3 likes!

Add columns if certain rules are met

Hi @abhide ! Yes you can exchange it by index values. I have assumed that you treat only with integers. So I changed the conversion + changed with index instead of column names: [image] Here is a suggestion that could work with your case: Cumulate_numbers.xaml (6.9 KB)

This post made by @prasath17 received 2 likes!

Match two excel columns and write to new column( advanced)

@Duleepa_Krishan - Here you go… [image] My Sample Output [image] Here’s how you have to code it… [image] If Condition CurrentRow("comment").ToString.Contains("_") Inside Then Condition CurrentRow("comment") = System.Text.RegularExpressions.Regex.Match(CurrentRow("comment").ToString,"\d+(?=_)").Value Inside the Else write an another if condition(This will check if first 2 characters are alphabets) system.Text.RegularExpressions.regex.Match(CurrentRow("comment").ToString,"^[A-z]{2}"…

This post made by @Adrian_Star received 2 likes!

Condition on excel sheet

I checked the flow of @Hiba_B and it works well. When working with Sheet4, you need to customize the column names in the workflow. Column order_number to order. Column sku to *product [image]

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Match two excel columns and write to new column( advanced)

@Duleepa_Krishan - Here you go… [image] My Sample Output [image] Here’s how you have to code it… [image] If Condition CurrentRow("comment").ToString.Contains("_") Inside Then Condition CurrentRow("comment") = System.Text.RegularExpressions.Regex.Match(CurrentRow("comment").ToString,"\d+(?=_)").Value Inside the Else write an another if condition(This will check if first 2 characters are alphabets) system.Text.RegularExpressions.regex.Match(CurrentRow("comment").ToString,"^[A-z]{2}"…

This solution provided by @AndyMenon received 1 likes!

UiPathRobot.js - I have the localhost page running. But there is no reaction from page

SOLVED! The path to the script in the Boiler plate application is obsolete. This line in the index.html file must be replaced with the one pointing to download.uipath.com <script src="https://uipathrobot.azureedge.net/Latest/UiPathRobot.js"></script> (Obsolete!) <script src="https://download.uipath.com/js/1.2.1/UiPathRobot.js"></script> (Valid)

---

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 May 2021

Top 3 Topics with Most Views

Data manipulation in excel table having Parent and Child columns made by @mansi.garg with 41 views.

Remove Duplicates Range is not working correctly made by @rrenu59 with 29 views.

How to save the attachment in a specific folder? made by @Wendy_wendy with 26 views.

Top 3 Topics with Most Replies

Filter mail outlook? made by @fairymemay with 17 replies.

Data manipulation in excel table having Parent and Child columns made by @mansi.garg with 15 replies.

Select query in a data table where column name is integer made by @Surya_Narayana_Korivipadu with 13 replies.

Top 3 Users Who Posted The Most

@Nithin_P made 18 posts!

@prasath17 made 17 posts!

@PRASHANT_GABHANE made 15 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 3 likes!

How to convert string variable to integer

@Rabi Welcome to forums That should be as CInt(Row(“Salary”).ToString)>10000 It should not be in {} it should be in () Hope this may help you Thanks

This post made by @NIVED_NAMBIAR received 3 likes!

Data manipulation in excel table having Parent and Child columns

Hi @mansi.garg I think this way can work Read the excel using read range by specifying Range as “A5” and store in dt1 Now use the below assign activitiy to get the list of columns who name doesn’t strated with cases column_arr= (From dc in dt1.Columns.Cast(Of String) Where Not dc.ColumnName.ToString.StartsWith(“Cases”) select dc.ColumnName.ToString).ToArray Now u will get the array of columns names in column_arr variable. Now loop through each element and use remove column activity…

This post made by @Sarmad_Nadeem received 2 likes!

How to sum all rows into a total column without a set number of columns?

Please mark solved if it answers your questions. Datatable.AsEnumerable().Sum(Function(row) row.Field(Of Integer)(“Values”)) Additional information: You have to make sure that the Column is set as type Integer or Decimal. [image]

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Checking whether the first two digits of a string value is alphanumeric

@MrKezay - Are you looking something like this? [image] You can see first two lines are selected whereas the third did not match the criteria… ^[A-z0-9]{2}

This solution provided by @Yoichi received 1 likes!

Regex to extrac text between (multi-lines)

Hi, Hope the following helps you. Regex to extract firstname which is between “Your first name and middle initial”____Last name Output : Jaul A System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Your first name and middle initial).*?(?=Last name)").Value Regex to extract text or string between “Last name” _____“your social security number” Output : Staffer System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Last name).*?(?=Your social security number)").Value Regex t…

This solution provided by @prasath17 received 1 likes!

Count number of files with variable

@Saurabh_Grover - You would like to merge two pdfs from different folder with the name of B_STRORDER_134 right?? If yes then please try like this in the Join PDF File activity FileList = directory.Getfiles(YourFolder1,"*.pdf").Concat(Directory.GetFiles(YourFolder2,"*.pdf")).ToArray Output File Name = "B_STRORDER_134.pdf" Hope this helps… Note: Instead of *.pdf , you can adjust it to your requirement

---

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 May 2021

Top 3 Topics with Most Views

How to compare string and ignore white space and cases? made by @AhmedKutraphali with 58 views.

How to fill a specific column's cells made by @Arif_Kilic with 50 views.

Read Range: Failed setting current sheet to made by @RobertoEwaldo with 45 views.

Top 3 Topics with Most Replies

Store Values from Matches made by @rameezimtiaz with 21 replies.

How to compare string and ignore white space and cases? made by @AhmedKutraphali with 20 replies.

Bulk update of a data table column in one go made by @MANISHA_V_ARORA with 19 replies.

Top 3 Users Who Posted The Most

@prasath17 made 24 posts!

@Divyanshu_Divyanshu made 22 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @Divyanshu_Divyanshu received 4 likes!

Multiply two columns using Linq Query

var_DT.AsEnumerable().ToList().ForEach(Function (r) r.SetField(“yourColumnName”,r.Field(“FirstColumn”)*r.Field(“SecondColumn”))) Use this one

This post made by @amalmarella received 2 likes!

Multiply two columns using Linq Query

Thanks Ankur & divaynshu it is working , Thanks nived for your response

This post made by @Yoichi received 2 likes!

How to fill a specific column's cells

Hi, Hope the following helps you. [img20210524-4] Sample20210524-2.zip (10.3 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @Divyanshu_Divyanshu received 4 likes!

Multiply two columns using Linq Query

var_DT.AsEnumerable().ToList().ForEach(Function (r) r.SetField(“yourColumnName”,r.Field(“FirstColumn”)*r.Field(“SecondColumn”))) Use this one

This solution provided by @kadiravan_kalidoss received 1 likes!

How to fill a specific column's cells

Hi @Arif_Kilic , Try this also without using linq: ExcelFillCells.xaml (11.8 KB) Sample output: interests.xlsx (10.8 KB) Thanks!

This solution provided by @Divyanshu_Divyanshu received 1 likes!

Regex to get middle initial or the only letter

Please find the below regex: \s[A-Z]$

---

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 May 2021

Top 3 Topics with Most Views

➡ UiPath Community Learning - Survey made by @Vibhor.Shrivastava with 33 views.

How to Write Security Relevant Information of Adminstration Events in Windows Event Log made by @StefanSchnell with 31 views.

How to delete only specific character and the end of a string made by @Hakim_Asyraf with 29 views.

Top 3 Topics with Most Replies

Removing word made by @Balan with 18 replies.

Get last weekday made by @niro with 15 replies.

What is the efficient way to log transaction in excel using reframework? made by @AhmedKutraphali with 13 replies.

Top 3 Users Who Posted The Most

@PRASHANT_GABHANE made 25 posts!

@prasath17 made 17 posts!

@Divyanshu_Divyanshu made 15 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 3 likes!

UiPath Community Learning - Survey

[UiPath-LinkedIn-25May21_take_the_survey] Hello UiPath Community , We continuously explore ways to bring more value to you in your automation projects and journey. Here is a short survey to understand your learning needs and requirements when it comes to UiPath Community events and programs. Your answers will help us better plan our meetups and community content. We invite you to take a moment and tell us: “What would you want to see, learn, read and have a hands-on session in com…

This post made by @Isabo received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, my name is Carmen Cecilia, I’m BA and I’m working in a RPA Project for 5 months. I like RPA automation so much and I’m here to keep learning about UIPATH and also improve my BA skill. So, please if you have information to share with me, I’d be grateful. God bless you all!

This post made by @StevePark received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Greetings from South Korea. I’m Steve Park who work for SK Telecom. I have a lot of questions for UI Path Automation Cloud. I need your generous help. thank you in advance!

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

For Each Row in Data Table - Problem looping through each record

lets assume following: For each row Activity lets use row as variable of for the looped row (instead of item) lets use in open browser - row(YourColNameOrIndex).toString

This solution provided by @Shubham_Varshney received 2 likes!

Is there a stopwatch or timer activity in UIPath?

Please find the XAML. Hope this clarifies Sequence.xaml (6.2 KB)

This solution provided by @prasath17 received 1 likes!

How to delete only specific character and the end of a string

@Hakim_Asyraf - Please try this System.text.RegularExpressions.Regex.Replace("000734|000143|012392|643221|213331|","\|$",string.Empty) System.text.RegularExpressions.Regex.Replace(YourString","\|$",string.Empty) Output [image] Hope this helps…

---

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

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

[system]

Daily Forum Report | 26 May 2021

Top 3 Topics with Most Views

United Health Group (Optum) - Uipath RPA Developer - Hyderabad - India - Full Time made by @Gouse_Pasha with 46 views.

Sphinx Solutions Pvt. Ltd - RPA- UiPath Developer - Pune - India - Full Time made by @Gouse_Pasha with 39 views.

SPI Global - RPA Developer - Chennai - India - Full Time made by @Taruna with 35 views.

Top 3 Topics with Most Replies

Implicit conversion error in email Automation made by @shubham_dubey with 15 replies.

Regex is match OR condition in a single line? made by @Nathan with 11 replies.

Having trouble with Click OCR Text made by @postwick with 10 replies.

Top 3 Users Who Posted The Most

@PRASHANT_GABHANE made 19 posts!

@Pankaj.Patil made 12 posts!

@AMRITANShlal made 12 posts!

Top 3 Most Liked Posts

This post made by @Michelle_Yurovsky received 2 likes!

Insights Not Populating with Data

Hey @ashwin.ashok, we figured out exactly what happened here. Bottom line is, you brought an important issue to our attention and we will be fixing it so that no one else runs into it. We can get it fixed for you as soon as tomorrow, we just need the URL of the orchestrator tenant you tried to enable Insights on. If you at your earliest convenience would be able to email that URL to me at michelle.yurovsky@uipath.com we’ll get you up and running.

This post made by @Sathanand received 2 likes!

Error in getting the current date from Orchestrator asset

Thank you both… @alexandretperez @Pankaj.Patil Now I feel free, As I was breaking my head that why I can’t find a direct solution for that. But anyways, I have coded a workaround which is similar to @alexandretperez approach. What I did is, Like you said add a blank value, I added Today in the text value of the asset, And an if condtion in my project to which it checks for the keyword Today. If found, the then part has the Date.now.tostring(“dd-MM-yyyy”) or it goes to the else …

This post made by @kadiravan_kalidoss received 2 likes!

How to create tomorrow's date (should be weekdays) according to weekend and holidays

Hi @Arif_Kilic, I have taken 2021 holidays list in excel - Holidays2021.xlsx (9.9 KB) Try this xaml - GetTomorrowDateWorkingDay.xaml (11.7 KB) This will return tomorrows date as next working day by validating weekends as well as holidays list in excel. Thanks!

Top 3 Most Liked Solutions

This solution provided by @PRASHANT_GABHANE received 2 likes!

Arrange excel data table after copy to new sheet

[image] [image]

This solution provided by @alexandretperez received 1 likes!

Error in getting the current date from Orchestrator asset

Hi @Sathanand It does not work like this. Assets can store Text, Integer, Bool and Credential types. You are trying to evaluate a .NET code from the asset. What you can do is set the date value like 2021-05-26 and in your code if the asset contains value you convert it to a date object using DateTime.Parse(yourAssetValue), otherwise, if the asset has a blank value, then you use DateTime.Now (hard-coded).

This solution provided by @NIVED_NAMBIAR received 1 likes!

How extract different fromat PDFs

Hi @Tharusha_Fernando can u try with document understanding ?

---

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 May 2021

Top 3 Topics with Most Views

Accelirate - Automation Engineer - Pune / Remote - India - Full Time made by @VirajN with 86 views.

Extracting table from txt file made by @sayali_rokade with 36 views.

Regular Expressions with Asset made by @Balan with 32 views.

Top 3 Topics with Most Replies

Saving File with different name if the file name already exist? made by @kumar.varun2 with 26 replies.

Extracting table from txt file made by @sayali_rokade with 22 replies.

Outlookメッセージを移動：指定したフォルダは存在しません made by @tom1 with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 45 posts!

@ppr made 25 posts!

@Shubham_Varshney made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Select item based on current month

in the most case we use find children to retrieve the available items from the dropdown. Based on this we can evaluate if to select item or not we suggest to go for such a clear implementation instead of surrounding it with a try catch. Lets assume following: IMP: Try catch on select item Bot selects item in case of exception, Bot is flowing with intention of item is not present in dropdown Scenario: UI is changing, selector of dopdown is changed, but it was not recognized and adopted E…

This post made by @pedro.cavadas received 2 likes!

Learn how to create a Document Understanding flow using Machine Learning

Hi All, Learn how to create a Document Understanding flow using Machine Learning on UiPath, watch our videos in the playlist https://www.youtube.com/playlist?list=PL0pU2MMOTVvhT29Pam7BPX5KJTOYLSHj7 There are 9 videos with step-by-step instructions to create a DU flow from scratch, with taxonomy, digitization, classification, extraction, validation, export and retraining. You will also be able to download the complete project on our github at GitHub - HDB-Systems-Videos/DocumentUnderstanding-S…

This post made by @ppr received 2 likes!

Extracting date in particular format

if this string is send to parseExcact, sure it is not recognized. Maybe cleansing with regex can help [grafik]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Extracting date in particular format

if this string is send to parseExcact, sure it is not recognized. Maybe cleansing with regex can help [grafik]

This solution provided by @ppr received 2 likes!

String operation find letter in a word that are repeating

@ravig1206 We can count the repeating chars by following: [grafik] [grafik] we did an uppercase, just for egalizing the chars for being case insensitive with a split mentioned by @Shubham_Varshney you are prepared to handle multiple words if it is needed. For this also we would suggest to adopt the flow and let produce a report table e.g. with following cols: Word, RepeatedChars Madam, MA

This solution provided by @Yoichi received 1 likes!

任意の文字列の場所を取得したい（複数条件）

こんにちは 以前の応用で 結果が単独で必要な場合は、 dt.AsEnumerable.Select(Function(r,i) if(r("メニュー").ToString="オムライス" AndAlso r("番号").ToString="3",i,-1)).Where(Function(i) i>=0).First() あるいは、リストで取得したい場合は dt.AsEnumerable.Select(Function(r,i) if(r("メニュー").ToString="オムライス" AndAlso r("番号").ToString="3",i,-1)).Where(Function(i) i>=0).ToList() でいかがでしょうか？

---

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

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

[system]

Daily Forum Report | 28 May 2021

Top 3 Topics with Most Views

Reframework check end process if there is exception made by @AhmedKutraphali with 105 views.

Is it possible to convert a dictionary to a data table with multiple columns? made by @Piotr_Kunkowski with 32 views.

What's new on UiPath Marketplace in 21.4 made by @Sophia_Zhylych with 31 views.

Top 3 Topics with Most Replies

How to read the specific data in pdf made by @Harish_pavuluri with 31 replies.

Send Email from Outlook With Attachment and Folder Location Based on Date made by @jaroldizquierdo with 15 replies.

Extract ac no from text file and save in excel made by @sayali_rokade with 13 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 29 posts!

@postwick made 24 posts!

@Krishna_547 made 17 posts!

Top 3 Most Liked Posts

This post made by @Sophia_Zhylych received 7 likes!

What's new on UiPath Marketplace in 21.4

What’s new on UiPath Marketplace in 21.4 Hello UiPath Community, One of the biggest UiPath releases – 21.4 – is here and we’ve made a variety of enhancements to UiPath Marketplace that we’d like to share with you. Below you can get a glimpse of hero features and functionalities added to the Marketplace between the 20.10 and 21.4 release. Robust, enterprise-grade Marketplace is live at marketplace.uipath.com We hope all of you have had a chance to play with our upgraded Marketplace and it…

This post made by @reda received 3 likes!

RPA France - Vulgarisation – Episode 2 : Découvrir l’écosystème UiPath et ses avantages

L’épisode 2 tant attendu est là !!! Tu t’es déjà demandé pourquoi UiPath est sympa à utiliser ? Cet article est fait pour toi ! Si tu as raté l’épisode 1, tu peux retrouver le lien au bas de cet article La plateforme UiPath UiPath est l’une des principales plateformes de RPA et a été reconnue comme un leader du Magic Quadrant par Gartner en 2019 et 2020. Pour maintenir sa place de référence dans le secteur, …

This post made by @sarathi125 received 3 likes!

Get substrings between two predifined words into array

@Olivera_Kalinic , Try with Regex.Matches with this pattern - (?<=Naziv:\s).*?(?=\sAdresa) This will give you all the matches from that string between those two keywords.

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Saving File with different name if the file name already exist?

Hi @kumar.varun2 You can try this assign activitiy around file_name= If(Directory.GetFiles(folderpath).Where(Function(file) Path.GetFileName(file).ToString.Contains(Now.ToString(“yyyyMMdd”))).Count=0, Now.ToString(“yyyyMMdd”), Now.ToString(“yyyyMMdd”)+“_”+ Directory.GetFiles(folderpath).Where(Function(file) Path.GetFileName(file).ToString.Contains(Now.ToString(“yyyyMMdd”))).Count.ToString)+“.xlsx” This will give u the file name too But if it is complex in way if understanding, then u can nor…

This solution provided by @Surya_Narayana_Korivipadu received 2 likes!

Reframework check end process if there is exception

Points to remember: The system exception variable gets reset for every failed transaction(Because the robot moves to initialization state when a system exception is encountered. Observe that there is a system exception transition between process transaction and initialization state. In the initialization state, the first activity sets system exception to nothing. ). [image] The system exception value is retained only when there’s an exception in the initialization state(Observe that there’s …

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

Send Outlook Message: Given key was not present in the dictionary error

because you keep re-initializing the Config dictionary in each iteration of foreach, this assign should be BEFORE the “for each row” sequence, NOT inside it [image] like this [image]

---

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

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

[system]

Daily Forum Report | 29 May 2021

Top 3 Topics with Most Views

Need ideas to develop POC made by @Anitha_Rk with 37 views.

HELP - Not able to loop through child elements made by @Rajesh_Shet with 30 views.

I need to extract the table made by @copy_writes with 29 views.

Top 3 Topics with Most Replies

Need ideas to develop POC made by @Anitha_Rk with 10 replies.

How to find if entire row contains specific value in any of its columns? made by @nabeelu with 8 replies.

Date Selection problem In calender made by @arj with 7 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 18 posts!

@copy_writes made 10 posts!

@Harish_pavuluri made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

How to learn LINQ?

currently I am bringing a LINQ starter tutorial from draft to final status.

This post made by @ppr received 3 likes!

[HowTo] - First Start with LINQ (VB.Net)

LINQ is part of the .NET framework and offers capabilities for interacting with data, objects or other sources within a particular syntax. This HowTo introduces on starting with LINQ (Language-Integrated Query). Current Version of this topic is DRAFT and will be finalized / enhanced soon Introduction Typical tasks for implementing parts of an automation project are interacting with e.g. with data in a datatable or items from collections. LINQ can help to implement it into a compact and standa…

This post made by @prasath17 received 1 likes!

How to learn LINQ?

@kumar.varun2 - These are some of the LINQ tutorials websites suggested by ppr in this forum… http://dotnetlearners.com/linq

Top 3 Most Liked Solutions

This solution provided by @jeevith received 1 likes!

Need ideas to develop POC

Hi @Anitha_Rk, I suggest you start from a problem which either you or anyone you know is having. Even better go to a random shop and ask them what kind of repetitive backoffice jobs they do and convince them that you can help automate the process at no cost to them. UiPath community license can be used by them (if they are 250 employees or less) even after you are finished with the project. I can assure you anything you do to help solve a real life problem will speak for itself in an interview…

---

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

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

[system]

Daily Forum Report | 30 May 2021

Top 3 Topics with Most Views

How to set file name with contains today date? made by @Dorothy_lee with 21 views.

Data Scraping is not scrapping URL and missing few data made by @Rajesh_Shet with 21 views.

Combine excel multiple file? made by @fairymemay with 20 views.

Top 3 Topics with Most Replies

How to add formated text typeinto? made by @Deepak_Gautam with 14 replies.

Getting macro error in uipath?How to run excel macros in uipath? made by @lk_18 with 14 replies.

Check the validity of an email addrees in the active directory made by @nourchene.ben-elouehma with 11 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 19 posts!

@Shubham_Varshney made 13 posts!

@Deepak_Gautam made 11 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 2 likes!

How to set file name with contains today date?

@Dorothy_lee - Please try this… Directory.GetFiles(YourFolderpath,"AISTMTPRINT*.xlsx").where(function(d) new FileInfo(d).Name.Contains(now.tostring("yyyy-MM-dd")))(0) [image] My date is still 29 , so I have created file with May 29th date and it fetched correctly…

This post made by @Chinmaya_Dhal received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi there! My name is Chinmay Dhal. I have recently started with UiPath Studiox and have built a BOT that works locally on my machine. I need the community help in sorting the below: A. I am having issues in deploying it globally within my organization. B. Also, wanted to understand how can I create configuration file within Studiox for the BOT I have built? Thanks for helping me in resolving this. Regards Chinmay

This post made by @Shubham_Varshney received 1 likes!

Check Email Address in Active Directory

Hi @nourchene.ben-elouehma , The active directory is to be used under active directory scope It all mattes with the unique distinguished value under Active Directory scope… that will help a lot in these cases… Hope this clarifies

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

How to set file name with contains today date?

@Dorothy_lee - Please try this… Directory.GetFiles(YourFolderpath,"AISTMTPRINT*.xlsx").where(function(d) new FileInfo(d).Name.Contains(now.tostring("yyyy-MM-dd")))(0) [image] My date is still 29 , so I have created file with May 29th date and it fetched correctly…

This solution provided by @kumar.varun2 received 1 likes!

Check the validity of an email addrees in the active directory

Check this xaml file. It is a simple approach to check the validity of the email address in AD. Let me know if it works for you Check email ID validity in AD.xaml (6.4 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 | 31 May 2021

Top 3 Topics with Most Views

【UiPathアカデミー】5月分新規コースのお知らせ made by @Taeko_UiPath with 72 views.

How to take screenshot of specific area on webpage? made by @Mathkar_kunal with 61 views.

テキストファイル抽出 made by @111884 with 57 views.

Top 3 Topics with Most Replies

Unable to read the data from XML made by @chaithanya_kumar_M with 16 replies.

How to take screenshot of specific area on webpage? made by @Mathkar_kunal with 15 replies.

テキストファイル抽出 made by @111884 with 12 replies.

Top 3 Users Who Posted The Most

@Krishna_547 made 26 posts!

@ppr made 25 posts!

@kumar.varun2 made 17 posts!

Top 3 Most Liked Posts

This post made by @kumar.varun2 received 2 likes!

UiPath Community Learning - Survey

Completed the survey.

This post made by @StefanSchnell received 2 likes!
https://forum.uipath.com/t/319169/1

This post made by @Hemanth_Kumar3 received 2 likes!

Innovsol System Technologies - UiPath Developer - Bangalore - India - Full Time

Job title: UiPath Developer Job role: RPA Developer Country: India City: Bangalore Company name: Innovsol System Technologies Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Experience in RE Framework Perform excel operations UI Automation Queue operations Uipath orchestrator Good hands on experience in UiPath Good logical experience Apply here: hemanth.kumar@innovsystech.in

Top 3 Most Liked Solutions

This solution provided by @kadiravan_kalidoss received 1 likes!

What is the best way to handle abbreviation?

Hi @AhmedKutraphali, I have Abbreviation info in this excel: AddrAbbre.xlsx (11.3 KB) Added 3 rows. Please add others if required Xaml: HandleAddrAbbreviation.xaml (8.4 KB) Pass your input 2 variable to this xaml and Test it. Thanks!

This solution provided by @Shubham_Varshney received 1 likes!

Excel - moving columns

Please find the updated xaml for reference. Main (5).xaml (12.8 KB) Thanks, Shuabham

This solution provided by @kumar.varun2 received 1 likes!

Convert data table to HTML to be included in email body

Use Create HTML Content Activity. First Design the mail format in MS Word and then copy paste it into the activity. If you want the table values to be dynamic then there is option of mapping values to the variables in the activity. Refer the screenshots below. [image] [image] It is a new activity. It is added in the latest package of UiPath.Mail.Activities 1.10.4 You can directly copy tables from excel and paste it into the editor of this activity and then the data values can be mapped eas…

---

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

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

[system]

Daily Forum Report | 01 June 2021

Top 3 Topics with Most Views

How to use spilt or regex? Please guide me made by @Reddy_1 with 39 views.

Webブラウザ(Edge)からのデータ取得方法 made by @sho.oikawa with 37 views.

Any way to have Similar function as Text Filter function in excel made by @li.yu with 35 views.

Top 3 Topics with Most Replies

Unable to click proper selector on ie made by @Mathkar_kunal with 30 replies.

Filter excel rows based on a date range made by @MANISHA_V_ARORA with 18 replies.

How to use spilt or regex? Please guide me made by @Reddy_1 with 17 replies.

Top 3 Users Who Posted The Most

@postwick made 28 posts!

@kumar.varun2 made 27 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

セレクターのaanameとは？

前に以下のように回答していました。 確か英語版フォーラムでも、他の人が「Active Accessibility」だよって言ってた気がします。

This post made by @prasath17 received 2 likes!

Format date from dd/mm/yyyy HH:MM AM/PM to yyyy-mm-dd

mm means Minutes. It should be coded as "(“yyyy-MM-dd”) For your reference

This post made by @Yoichi received 2 likes!

How to process group of records in data table once instead of individually?

Hi, Hope the following sample helps you. [img20210601-3] Sample20210601-2.zip (3.0 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Format date from dd/mm/yyyy HH:MM AM/PM to yyyy-mm-dd

mm means Minutes. It should be coded as "(“yyyy-MM-dd”) For your reference

This solution provided by @h-fujiwara received 2 likes!

プロキシ環境下でCommunity Editionのインストールができない件について

認証プロキシ環境であることが原因のようですので、 認証を必要としないプロキシ環境に切り替え、 「サインイン」以降の処理を行うことができました。 本件、クローズさせていただきます。

This solution provided by @prasath_S received 2 likes!

Any way to have Similar function as Text Filter function in excel

Please find the reference Sub filter() Range("A1:H" & Cells(Rows.Count, 1).End(xlUp).Row).AutoFilter Field:=4, Criteria1:="<>" End Sub it will filter in 4th column change column number as you want, [image] Thanks

---

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

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

[system]

Daily Forum Report | 02 June 2021

Top 3 Topics with Most Views

EY (Ernst and Young) - Associate Consultant - Delhi-Chennai-Bangalore- Mumbai - India - Full Time made by @srishti.gupta with 63 views.

Explore UiPath 21.4 - Instagram LIVE Session - June 3 made by @Raluca_Ilie with 41 views.

長時間実行中のジョブを検知する方法はあるか？ made by @rfu with 25 views.

Top 3 Topics with Most Replies

Download and upload images trough api made by @langsem with 16 replies.

Dt①から新しいdt②へデータを転記したい made by @miwa_yamamoto with 15 replies.

https://forum.uipath.com/t/319923 made by @Sairam_RPA with 14 replies.

Top 3 Users Who Posted The Most

@postwick made 29 posts!

@ppr made 22 posts!

@prasath_S made 22 posts!

Top 3 Most Liked Posts

This post made by @Raluca_Ilie received 4 likes!

Explore UiPath 21.4 - Instagram LIVE Session - June 3

3, 2, 1… we’re going LIVE on Instagram! Our special guests, Tejus Venkatesh and UiPath MVP Juveria Siddiqui will share their experience with UiPath 21.4 and how the new products & features can help each #RPA user in their #automation journey. Tune in tomorrow, June 3! [Juveria Instagram LIVE 1] [Tejus Instagram LIVE 2]

This post made by @prasath_S received 3 likes!

Skipping header line

Hi @Pranav_KomandurPK Please try this steps, Read the excel and Store in a datatable variable name dtTable. Use remove datarow activity and remove the first row, https://docs.uipath.com/activities/docs/remove-data-row OR In Assign activity dtTable = dtTable.asenumerable.skip(1).copytodatatable If you want to skip actuall headers you can tick addHeader property in read range. Thanks

This post made by @Yoichi received 2 likes!

How to process group of records in data table once instead of individually?

Hi @Bobby_J Actually, I didn’t understand it at first. In my case, I deepened my understanding by reading basic LINQ expressions and actually writing and running repeatedly. Now @ppr is working on making documents for LINQ (as the following, for example), and it will help us better understanding LINQ, I think. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Getting an error like input string not in correct format

Hi, Sorry, I had misunderstanding. It’s because DEBIT AMOUNT column is set as Int32 type in Build DataTable activity. So, can you try to modify Int32 to Double in it? Regards,

This solution provided by @Yoichi received 1 likes!

データテーブルの任意の列を全角→半角にしたい

こんにちは ありがとうございます。 ワークフロー側のDataTable変数は、Value側に設定する必要があります。そのため下記のようになります。（他の部分はdtのままでも動作しました。変更いただいても問題はありませんが。） [img20210602-3] データ量が多いので、もしデータ量が問題でInvokeCode内で落ちるようでしたら、 以下のInvokeCodeに差し替えてもらった方が良いかもしれません。 Sample20210601-1-v2.zip (2.8 KB)

This solution provided by @MarioHerrmann received 1 likes!

How to access mail without being logged in

you can try to get mails with the IMAP or Exchange Activity. But you need the password for the Emailaccount.

---

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 June 2021

Top 3 Topics with Most Views

Possible to filter row by number of character made by @Anneng with 31 views.

Replacing text in Document doesn't work with string which contains "\r\n" made by @Assyl_Abetayev with 24 views.

Element Exist property.. understanding question made by @Latif with 22 views.

Top 3 Topics with Most Replies

Replacing text in Document doesn't work with string which contains "\r\n" made by @Assyl_Abetayev with 20 replies.

Converting String To Date In Desired Format made by @ashwin.ashok with 14 replies.

Possible to filter row by number of character made by @Anneng with 8 replies.

Top 3 Users Who Posted The Most

@postwick made 23 posts!

@Krishna_547 made 22 posts!

@Assyl_Abetayev made 11 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

長時間実行中のジョブを検知する方法はあるか？

ジョブのロングラン監視機能ほしいですよね。 OrchestratorはWebサーバーでイベント発生で動くので、現状、自分でタイマー実行が出来ない気がします。 監視用のロボットフローを作って、Orchestratorのスケジュール設定で実行させて、API叩いて検出するのが王道な気もしますが、 以下のような方法でも可能だと思います。 1）SQLServerのエージェントジョブで、ジョブテーブルから実行中で一定時間経過したものを抽出し、通知する（メールなど） 2）SQLServerまたはOrchestratorのタスクスケジューラトリガーで、SQLServerのジョブテーブルからSQLCMDまたはPowershell等からSQLで・・・同上 3）Orchestratorのタスクスケジューラトリガーで、OrchestratorのAPIから実行中で一定時間経過した・・・同上 4）他のマシンのタスクスケジューラトリガーで、OrchestratorのAPIから・・・同上 5）AzureFunction等のサーバーレスアプリで、OrchestratorのAPIから・・・同上 「2」は…

This post made by @Yoichi received 2 likes!

Data table dynamic code issue

Hi, How about the following? [img20210603-4] Main.xaml (8.6 KB) Regards,

This post made by @prasath_S received 2 likes!

Possible to filter row by number of character

Hi @Anneng Please try this dtTable - datatable dtTable = dtTable.asenumerable.where(function(d) d(“comments”).tostring.length <5).copytodatatable Thanks

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Data table dynamic code issue

Hi, How about the following? [img20210603-4] Main.xaml (8.6 KB) Regards,

This solution provided by @prasath_S received 2 likes!

Possible to filter row by number of character

Hi @Anneng Please try this dtTable - datatable dtTable = dtTable.asenumerable.where(function(d) d(“comments”).tostring.length <5).copytodatatable Thanks

This solution provided by @aitor.bengoetxea received 1 likes!

(DOCUMENT UNDERSTANDING)Export Extraction Result activitie Doesn´t work in orchestrator background process

I got the solution! The problem was not the Extraction Result activitie…The problem was because I have a realtive path on the “Wait” activitie. I have changed the path to this one and it works perfect: [image] Thanks @Lahiru.Fernando for your help!!

---

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 June 2021

Top 3 Topics with Most Views

I want to retrieve data from a table present in mail Body in outlook? it would be better if we can retrieve that table from mail in DataTable format made by @anjasing with 28 views.

How To Terminate Process in Middle of Whole Process? made by @hsendel with 25 views.

Format date in excel made by @fairymemay with 25 views.

Top 3 Topics with Most Replies

vbCrLf, Environment.NewLine doesn't work on Outlook made by @Wing_Ben_Wong with 16 replies.

How To Terminate Process in Middle of Whole Process? made by @hsendel with 12 replies.

I want to retrieve data from a table present in mail Body in outlook? it would be better if we can retrieve that table from mail in DataTable format made by @anjasing with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 19 posts!

@postwick made 12 posts!

@Pankaj.Patil made 11 posts!

Top 3 Most Liked Posts

This post made by @mz3bel received 3 likes!

RPA France - Vulgarisation – Episode 3 : Comment faire ses premiers pas sur UiPath?

L’épisode 3 tant attendu est là !!! Comment faire ses premiers pas sur UiPath ? Comme pour tout langage informatique, crée ton premier “Hello, World” Si tu as raté l’épisode 2, tu peux retrouver le lien au bas de cet article Qu’est-ce que UiPath et pourquoi est-il utilisé ! L’un des outils d’automatisation les plus populaires, UiPath, est un outil d’automatisation de processus robotique utilisé pour l’automati…

This post made by @Pankaj.Patil received 2 likes!

I need to append date and time to the file name dynamically while using the move activity

@manjesh_kumar, Can you try with below? DestinationFolder+Path.GetFileNameWithoutExtension(SourceFolder)+“_”+Now.ToString(“dd.MM.yyyy”)+“.txt”

This post made by @vasile.bujac received 2 likes!

API => GET Jobs not working

The order in which jobs are returned from odata/Jobs endpoint without any OData parameters isn’t technically defined. If you’d like to find out the status of the last job that was run, try ordering by StartTime desc or EndTime desc, for example /odata/Jobs?$top=1&$orderby=StartTime desc should return the last job that has started. Use StartTime if you’d like to include running jobs which do not have an EndTime property set. If you’re interested in completed jobs only, successful or failed, use E…

Top 3 Most Liked Solutions

This solution provided by @Pankaj.Patil received 2 likes!

I need to append date and time to the file name dynamically while using the move activity

@manjesh_kumar, Can you try with below? DestinationFolder+Path.GetFileNameWithoutExtension(SourceFolder)+“_”+Now.ToString(“dd.MM.yyyy”)+“.txt”

This solution provided by @ppr received 2 likes!

How to duplicate rows with ignorecase

@fightblue give a try on: Assign activity Left side: dtCleansed | Datatype: Datatable Right side: (From d in YourDataTableVar.AsEnumerable Group d by k1=d(“city”)toString.Trim.ToUpper, k2=d(“ammount”).toString into grp=Group Select grp.First()).CopyToDataTable Kindly note: Cross check the column names on spellings and ensure that the LINQ statement is using the names as in your real data

This solution provided by @J0ska received 1 likes!

How To Terminate Process in Middle of Whole Process?

There is enough resources about T/C. Search and test. It is the best learning. 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 | 05 June 2021

Top 3 Topics with Most Views

How can I perfom a write range every 100 rows made by @4751203118d5c62d58b6be22a with 28 views.

Help with for each in excel made by @NHoe with 24 views.

How to trigger a workflow when a new row is added in Excel file made by @salax_sunny with 21 views.

Top 3 Topics with Most Replies

How can I perfom a write range every 100 rows made by @4751203118d5c62d58b6be22a with 8 replies.

Format date in excel not match file original? made by @fairymemay with 8 replies.

BOT is not able to login to acmetest website made by @Rakesh_Tiwari with 7 replies.

Top 3 Users Who Posted The Most

@Hiba_B made 11 posts!

@AndyMenon made 8 posts!

@postwick made 5 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 2 likes!

How can I perfom a write range every 100 rows

Hi @4751203118d5c62d58b6be22a You can give cell address in write range as A101,A201 etc it will start writing from that cell. Or You can use append range activity for appending the datatable to excel. Thanks

This post made by @cheez_RPA received 1 likes!

プロジェクトにロックをかけたい

UiPath自体にはそのような仕組みはありません。

This post made by @ken_infield received 1 likes!

ブラウザ拡張機能のブラウザごとの差異と途中で変更したときの影響

こんにちは。 １、サイトからのデータダウンロードがものすごく違います。 他にも動作の違いはあるのではないでしょうか。 ２、セレクタの修正は必須だと思います。 IEのサポート切れ非常に気になり、ChromiumEdgeの IEモードを試してみました。 設定はこちらを参考に セレクタの修正はやはり必須ですが、IEと同じ動作をする（と思う）ので IEモードで動作させるのが一番修正の手間が少ないと感じました。

Top 3 Most Liked Solutions

This solution provided by @Chris_Bolin received 1 likes!

Problem with index on dynamic selector

I did something similar. Although the dt that is extracted is not a true datatable, I was able to determine the number of times the word “Download” appeared using Match. For each single “Download” view, the table showed 2 so it is a 2 to 1 relationship so I divided by 2 and got the number of “rows” the bot would need to get a download from. I then had a counter run through a get attribute looking for the idx of each of the items according to the number of times “Download” appeared and allowed…

---

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 June 2021

Top 3 Topics with Most Views

プログラムを編集者以外は編集不可にする方法 made by @111131 with 22 views.

Add Data Row Object reference not set to an instance of an object made by @himanshur with 22 views.

Invoke Method -What possible functions? -Method NAME made by @Tamar_Markowitz with 21 views.

Top 3 Topics with Most Replies

Invoke Method -What possible functions? -Method NAME made by @Tamar_Markowitz with 16 replies.

検索サイトのウェブスクレーピング結果を更新する方法 made by @111701 with 7 replies.

How do i split this string from get full text activity? made by @nicholas.harvey with 7 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 19 posts!

@Tamar_Markowitz made 7 posts!

@111701 made 6 posts!

Top 3 Most Liked Posts

This post made by @dawn.andromeda received 1 likes!

ChromeからPDF作成について

お返事が遅くなってしまい申し訳ございません。Windows側の印刷で行いましたらできました。ありがとうございました！

This post made by @ken_infield received 1 likes!

ブラウザ拡張機能のブラウザごとの差異と途中で変更したときの影響

こんにちは。 １、IEの通知バーの振る舞いはIE=EdgeIEモード で変わりませんでした。 ２、修正は必須と書きましたが、私の場合絶対セレクタを使用しているところがあり、 すべて見直しましたが、相対セレクタを使用しているアクティビティーは ブラウザにアタッチの使用ブラウザをEdgeに変更して、セレクターを変更するだけで 動作するかもしれません。

This post made by @salax_sunny received 1 likes!

How to trigger a workflow when a new row is added in Excel file

@GouthamVijay Thanks for the solution.

Top 3 Most Liked Solutions

This solution provided by @ken_infield received 1 likes!

ブラウザ拡張機能のブラウザごとの差異と途中で変更したときの影響

こんにちは。 １、IEの通知バーの振る舞いはIE=EdgeIEモード で変わりませんでした。 ２、修正は必須と書きましたが、私の場合絶対セレクタを使用しているところがあり、 すべて見直しましたが、相対セレクタを使用しているアクティビティーは ブラウザにアタッチの使用ブラウザをEdgeに変更して、セレクターを変更するだけで 動作するかもしれません。

This solution provided by @ppr received 1 likes!

How to add two lists or arrays?

L1.concat(L2).tolist / toArray

---

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 June 2021

Top 3 Topics with Most Views

Regex for 2 different conditions made by @AhmedKutraphali with 69 views.

How to get the first item in matchcollection uipath without loop? made by @AhmedKutraphali with 43 views.

Unable to extract data from pdf as it contains AVL_AVView made by @sayali.suyal with 42 views.

Top 3 Topics with Most Replies

Regex for 2 different conditions made by @AhmedKutraphali with 17 replies.

How to get the first item in matchcollection uipath without loop? made by @AhmedKutraphali with 13 replies.

Get Date text from excel made by @Vincent_Nuestro with 11 replies.

Top 3 Users Who Posted The Most

@prasath17 made 21 posts!

@ppr made 21 posts!

@Cristian_Negulescu made 20 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

プログラムを編集者以外は編集不可にする方法

Winactorのシナリオ編集・閲覧・実行パスワードのような機能ですよね。 UiPathには基本的にはパスワード保護の機能は無いみたいです。 nupkg署名という形で、改ざんされていないことを証明する機能はあり、UiRobotの設定ファイルで「正しい署名が付いてないと実行させない」という設定にさせることは出来るようですが。 使っている現場を見聞きしたことが有りません。。。

This post made by @ppr received 2 likes!

How to skip columns using LINQ?

not mandatory removing the last column we can do: filterdatatable activity -col settings - remove - index: dtData.Columns.Count - 1 Working with DataTableVar.DefaultView.toTable(False, arrColSet) arrColSet can be done by DataTableVar.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName.Except({“Col1”,“Col4”,“Col34”}).toArray

This post made by @ppr received 2 likes!

Convert date to year/week number format

[grafik] [grafik] ensure System.Globalization is imported to namespaces [grafik]

Top 3 Most Liked Solutions

This solution provided by @shinji received 2 likes!

プログラムを編集者以外は編集不可にする方法

Winactorのシナリオ編集・閲覧・実行パスワードのような機能ですよね。 UiPathには基本的にはパスワード保護の機能は無いみたいです。 nupkg署名という形で、改ざんされていないことを証明する機能はあり、UiRobotの設定ファイルで「正しい署名が付いてないと実行させない」という設定にさせることは出来るようですが。 使っている現場を見聞きしたことが有りません。。。

This solution provided by @ppr received 2 likes!

How to skip columns using LINQ?

not mandatory removing the last column we can do: filterdatatable activity -col settings - remove - index: dtData.Columns.Count - 1 Working with DataTableVar.DefaultView.toTable(False, arrColSet) arrColSet can be done by DataTableVar.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName.Except({“Col1”,“Col4”,“Col34”}).toArray

This solution provided by @ppr received 2 likes!

Convert date to year/week number format

[grafik] [grafik] ensure System.Globalization is imported to namespaces [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.