Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 March 2021

Top 3 Topics with Most Views

Email Extractioin with out using Regex made by @saritha with 33 views.

StudiXでCSVデータをexcelシートに張付け made by @lunaluna with 31 views.

Getting connection error though uipath assistant any suggestion about that? made by @Biswabhusan_Mohapatra with 30 views.

Top 3 Topics with Most Replies

Write cell the regex output made by @AhmedKutraphali with 20 replies.

StudiXでCSVデータをexcelシートに張付け made by @lunaluna with 18 replies.

Element Exist Looping made by @m0e91 with 14 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 25 posts!

@Yoichi made 21 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @rajaneesh received 4 likes!

Announcing the 2021 UiPath MVPs!

Many thanks to UiPath and the entire UiPath Community for selecting me again as an MVP! Congratulation to all MVP’s 2021 ! Looking forward for another great year!! Warm Regards, Raj UiPath MVP Sydney, Australia

This post made by @nisargkadam23 received 3 likes!

Announcing the 2021 UiPath MVPs!

So happy to be included in the List of MVP 2021. Congratulations to all the MVP’s.

This post made by @alexandru received 2 likes!

The activity and project auto hide is not working

Thank you for reporting this. It will be fixed soon.

Top 3 Most Liked Solutions

This solution provided by @Ewout received 2 likes!

Get Outlook mail message filtering issue with received time

@NIVED_NAMBIAR with some further trial and error i resolved it. Get outlook mail message accepted it in this format: dd/MM/yyyy HH:mm . For everyone encountering this issue: Exclude seconds from your time format to get it to work! Credits to Nived

This solution provided by @ppr received 2 likes!

Regex to extract the last amount including the negative

its already included: [grafik] you can test / develop regex e.g. with regex101.com Also have a look here:

This solution provided by @thayane.ribeiro received 2 likes!

Read Large excel file

Thanks, everyone! I changed my file extension to CSV and now it’s reading in less than one minute!

---

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

Top 3 Topics with Most Views

Check for downloading file extension using Regex made by @Sahil_Garg1 with 32 views.

Regex to remove entire lines between 2 specifc identifiers made by @DewanjeeS with 26 views.

Click Activity doesn't work in web application made by @Gugu_Khoza_Lubanzi_ICT_Co with 26 views.

Top 3 Topics with Most Replies

Check for downloading file extension using Regex made by @Sahil_Garg1 with 18 replies.

New column in a data table by concatenating to existing columns made by @shrayud with 16 replies.

Write empty fields in Excel made by @crazyronny with 14 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 23 posts!

@NIVED_NAMBIAR made 23 posts!

@songoel made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

文字入力中にアクティブが外れてしまう

こんにちは 文字を入力（Type Into)のデフォルトモードやSendWindowMessagesは状況によっては 周囲の影響を受けやすいため、このようなケースは １．「入力をシミュレート」モードを試す。 ２．１がNGの場合は、一度クリップボードに文字列を移してから、Ctrl＋vで貼り付ける。 等で対処します。 また文字列が正確に入力できたかを確認し、誤りがある場合は再入力を行う等の手法もよくとられます。

This post made by @Yoichi received 3 likes!

Count of character duplicates in a string

Hi, Hope the following helps you. dict = "abcdab".GroupBy(Function(c) c).ToDictionary(Function(g) g.Key,Function(g) g.Count) Note: dict is Dictionary<Char, Int32> type. [img20210310-1]

This post made by @BasiReddy received 2 likes!

Announcing the 2021 UiPath MVPs!

Congratulations Everyone

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

文字入力中にアクティブが外れてしまう

こんにちは 文字を入力（Type Into)のデフォルトモードやSendWindowMessagesは状況によっては 周囲の影響を受けやすいため、このようなケースは １．「入力をシミュレート」モードを試す。 ２．１がNGの場合は、一度クリップボードに文字列を移してから、Ctrl＋vで貼り付ける。 等で対処します。 また文字列が正確に入力できたかを確認し、誤りがある場合は再入力を行う等の手法もよくとられます。

This solution provided by @NIVED_NAMBIAR received 2 likes!

Add data column activity, how to set default value with other column value?

Hi @dywan219 welcome to forum You can try like to add values to the col3 After adding col3 column , you can use the following query in invoke code with datatable argument dt1 as In/out dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“col3”)= row(“col1”).ToString) Hope it helps you Mark it as solution if it works Regards, Nived N Happy Automation

This solution provided by @ptrobot received 2 likes!

Regex to remove entire lines between 2 specifc identifiers

Thanks for the explanation but Regex can’t find '#end and go up. What it does is to find ); and then go down until it finds '#end. If we don’t want xx in between we need to use (?!xx) to tell it not to match xx. I hope it’s right this time: \);((?!\);)[\s\S])*?'#end [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 | 10 March 2021

Top 3 Topics with Most Views

How to filter datatable from linq query made by @Gopikrishna with 32 views.

[Gsuite]既存スプレッドシートへのシート追加方法 made by @Akattyan with 26 views.

Orchestrator logging report is empty - no logging visible made by @gjm with 25 views.

Top 3 Topics with Most Replies

Problem when copying formula in excel cell made by @Nestor_Escobar_SIS with 15 replies.

How to sort IEnumerable <match>? made by @Jay_Chacko with 14 replies.

How to filter datatable from linq query made by @Gopikrishna with 13 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 22 posts!

@prasath17 made 17 posts!

@Pravin_Patil1 made 13 posts!

Top 3 Most Liked Posts

This post made by @Bill_Richardson received 2 likes!

Orchestrator parameters do not work with UiPath Assistant

Is there any update on this issue? I am using 20.10.6 and notice that the argument values must be edited in Assistant before they “take” are and get used when you run the automation. This is confusing to users as we must explain to all Assistant users that they need to go edit the displayed value of the argument (add a space at the end, or whatever) before it will actually be used when they run the automation.

This post made by @Yoichi received 2 likes!

ファイル名取得ができなくなった

こんにちは 既に解決済みですが、直接の原因は、名前空間の設定状況により、DirectoryがMicrosoft.Graph以下のものなのか、System.IO以下のものなのかが判別できない状態になっていることにあります。 最新版CEですと名前空間の設定の削除ができますので、Microsoft.Graph上で右クリックして削除してみてください。 [img20210310-3] 少し前のバージョンですと、Studioから削除できなかったかと思うので、その場合は、非保証の 方法になりますが、xamlファイルをメモ帳等で開き、 TextExpression.NamespacesForImplementation要素の中のMicrosoft.Graphの記述の ある行を削除してみてください。 [img20210310-2]

This post made by @Yoichi received 2 likes!

Excelの新規ファイル作成後開くとファイルが壊れてると出る

こんにちは ファイルを作成アクティビティは単に空のファイルを作成するだけですので、この場合は使う必要はありません。 単に書き込みたいファイル名でエクセルアプリケーションスコープ（ファイルが無いときは新規作成オプションをオン）を配置しその中で範囲書き込み、またはシステム－ファイル－ワークブック以下の範囲書き込みを用いると、自動的に中身のあるファイルを生成してくれます。

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Sort a datatable by count of duplicate

with selectmany we flattens the grp.toList (A list of datatrows) into one sequence. Happy to hear about that it is working. May we ask you on flagging the solving post as solution after you have done with the final testings. Thanks

This solution provided by @LevKushnir received 1 likes!

Bridge between UIPATH -> SAP

HI @josesgar The solution is here. SAP behaves differently (human-being vs automation) for some windows, to resolve this problem please use Dialog (modal) display options Best regards, Lev @loginerror thanks for bringing this topic to my attention. No need for support ticket in this case

This solution provided by @ppr received 1 likes!

How to filter datatable from linq query

@Gopikrishna give a try on following LINQ (From d in dtData.AsEnumerable Group d by k=d("Username").toString into grp=Group let check = grp.Select(Function (x) x("Last_Name").toString.Trim & x("First_Name").toString.Trim).Distinct().Count Where check > 1 Select grp.toList).SelectMany(Function (s) s).CopyToDataTable We can assume that also an empty result will be returned. So apply following pattern for handling this as well: [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 | 11 March 2021

Top 3 Topics with Most Views

【UiPathアカデミー】UiPath StudioX 開発系のコースが新しくなりました！ made by @Taeko_UiPath with 62 views.

Outlook メールメッセージファイルの読み込み made by @Z15 with 61 views.

アクティビティ内でホットキーを検索しても出てきません。 made by @111817 with 51 views.

Top 3 Topics with Most Replies

How to click calendar from text made by @fairymemay with 17 replies.

How does read range works on date columns in excel? made by @Robotman with 12 replies.

Chrome: Automate "Close all tabs to the right" made by @herman with 12 replies.

Top 3 Users Who Posted The Most

@prasath17 made 15 posts!

@Yoichi made 12 posts!

@fairymemay made 11 posts!

Top 3 Most Liked Posts

This post made by @Raviteja_N received 4 likes!

Announcing the 2021 UiPath MVPs!

many wishes to all the MVP’s

This post made by @Taeko_UiPath received 4 likes!

【UiPathアカデミー】UiPath StudioX 開発系のコースが新しくなりました！

平素より、UiPathアカデミーをご利用くださいまして誠にありがとうございます 掲題の通り、UiPath StudioX 開発プログラム が2021年3月11日にリリースされました 【UiPath StudioX 開発プログラムについて】 UiPath StudioX 開発プログラムには、 UiPath StudioX 基礎コース・UiPath StudioX 活用コースが含まれます 今回新たにリリースされた、UiPath StudioX 活用コースでは、より実践的な内容を学習できます 【(旧) UiPath StudioX 開発コース受講済みの方へ】 UiPath StudioX 基礎コースは、（旧）UiPath StudioX 開発コースに相当します そのため、（旧）UiPath StudioX 開発コースを受講済みの方は、UiPath StudioX 基礎コース受講済みとみなされます 「基礎コース」は、「Excel作業の自動化」のレッスンに、[最終行を確認]アクティビティのハンズオンの追加や、プロジェクトノートブックのメリットが実感できる内容に改善されましたので…

This post made by @tainan.ramos received 3 likes!

I want to split the text

Hi @praveen_sonkusare You can try to do it using regular expression. Follow the example. Variabel texto = "EmployeeID:E102 ManagerID:E088 From Date:25/01/2021 To Date: 20/02/2021" Regular Expression System.Text.RegularExpressions.Regex.Match(texto,"(?<=EmployeeID:)\w+") System.Text.RegularExpressions.Regex.Match(texto,"(?<=ManagerID:)\w+") System.Text.RegularExpressions.Regex.Match(texto,"(?<=From Date:)\w+\/\w+\/\w+") System.Text.RegularExpressions.Regex.Match(texto,"(?<=To Date: )\w+\/\w…

Top 3 Most Liked Solutions

This solution provided by @gheorghestan received 1 likes!

Extract data from a SAP ALV-Grid into a UiPath DataTable variable

@Marcelo_Vina , UIAutomation.Activities 21.2-preview comes with support for scraping SAP ALV Grid tables. Please give it a try and let me know your feedback! Thanks. Gheorghe

This solution provided by @songoel received 1 likes!

Pop up Message during process working

See, for each would contain a sequence of steps that you are performing (in a loop) during which at any point in time the pop up may appear. Incase the sequence of steps is not iterative and it occurs just once, you can use a simple Try - Catch. Use the element exists in catch block and handle it there. Other major steps you can mention in the Finally block. If you have a set of items for which you are performing the actions specified in the for each loop, then go for the loop. In the parall…

This solution provided by @Z15 received 1 likes!

Outlook メールメッセージファイルの読み込み

shinji様 本件とは別のエラーにも返信頂き、誠にありがとうございました。 勉強になりました。感謝致します。 また、本件のメール情報の取得、以下の通り（今回は、本文のみ取得） 本文を「メールメッセージ送信」の本文へ変数（Arg_HTMLBODY)を与えてメール送信ができることが確認できました。 誠にありがとうございました！ [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 | 12 March 2021

Top 3 Topics with Most Views

Make your package compatible with Studio 21.4 made by @Sophia_Salo with 80 views.

Merging 3 datatable into one with different column name made by @Sumit_D with 35 views.

Extraction in Invoice Problem made by @badal_patel with 34 views.

Top 3 Topics with Most Replies

Extraction in Invoice Problem made by @badal_patel with 24 replies.

Please Help me made by @vjsolomons with 9 replies.

How to move files with the same format from a folder to another one? I got the problem with the Expressionwith made by @Nguy_n_Th_y with 8 replies.

Top 3 Users Who Posted The Most

@prasath17 made 21 posts!

@badal_patel made 11 posts!

@Yoichi made 9 posts!

Top 3 Most Liked Posts

This post made by @Sophia_Salo received 7 likes!

Make your package compatible with Studio 21.4

We would like to inform you about the latest Studio changes as our purpose is to make sure your activities will continue to work smoothly with our latest 21.2 Community Preview release and the upcoming 21.4 FTS release. Starting from 21.2 Community Preview edition of UiPath Studio, there might be compatibility issues between existing activity packages and upcoming Studio versions. This is because Studio 21.2 (or higher) is multi-process as opposed to single-process. For instructions on how to u…

This post made by @badal_patel received 3 likes!

Extraction in Invoice Problem

Beneficiary Account, Amount, Payment Date, Remarks

This post made by @StefanSchnell received 2 likes!

SAP Activities Tutorial

@LevKushnir Excellent presentation Lev SAP with StudioX is great, this makes it even easier for business experts to automate SAP.

Top 3 Most Liked Solutions

This solution provided by @StefanSchnell received 2 likes!

SAP Application scope TypeInitializationException error

@Haretoke Hello Haretoke, you installed .NET Connector 3.0 for .NET 2.0 x64, but it is necessary to install .NET Connector 3.0 for .NET 4.0 x86. Best regards Stefan

This solution provided by @NIVED_NAMBIAR received 2 likes!

How to write cell start from cell A2?

Hi @Aditya_Nugroho Welcome to forum First u can a intialise a counter variable with intial value of 2 Then use for each row to loop through each row of the datatable Inside the loop, do the following: Use write cell activitiy with cell value as "A"+counter.ToString Then increment the counter by one using assign activitiy counter=counter+1 Regards Nived N Happy Automation

This solution provided by @anon54029271 received 2 likes!

No response from the UiPath sales form

I’ve just received an e-mail from the sales team.

---

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

Top 3 Topics with Most Views

Email attachments are not saving to local folder made by @Deepika_Ajith with 25 views.

Pivot and write excel made by @fairymemay with 24 views.

Pause Automation on a slow website made by @shrayud with 22 views.

Top 3 Topics with Most Replies

Appending data into Data table made by @shekhawat.arjun1307 with 16 replies.

StudioX - Calculate using spreadsheet issue made by @Prinal_C with 15 replies.

I need to identify the value of text in text document but that text occur multiple time made by @Puneet_Singh1 with 9 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 11 posts!

@prasath17 made 11 posts!

@Srini84 made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

I need to identify the value of text in text document but that text occur multiple time

@Puneet_Singh1 give a try with regex: [grafik]

This post made by @moenk received 2 likes!

Pause Automation on a slow website

Sounds as if you like to use this activity:

This post made by @Marius_Puscasu received 2 likes!

Map data excel

Hi @fairymemay , One simple solution is to use the Lookup Data Table activity (https://docs.uipath.com/activities/docs/lookup-data-table ) as within the following example: [Sol] This is the helper file: MapDataExcel.xaml (7.6 KB) Hope this helps! Best regards, Marius

Top 3 Most Liked Solutions

This solution provided by @Marius_Puscasu received 2 likes!

Map data excel

Hi @fairymemay , One simple solution is to use the Lookup Data Table activity (https://docs.uipath.com/activities/docs/lookup-data-table ) as within the following example: [Sol] This is the helper file: MapDataExcel.xaml (7.6 KB) Hope this helps! Best regards, Marius

This solution provided by @prasath17 received 2 likes!

StudioX - Calculate using spreadsheet issue

@Prinal_C - Here you go… [image] Idea I have used here is : First trying to find the last row of any columns…which gives me the output: 4 [image] Using this value, i can set my range for the column F… Say : F2: F4 Excel.Sheet(“Sheet1”).Range(“F2:F” + Saved.Values(Of Int32)(“Last Data Row”).ToString) Here: Saved.Values(Of Int32)(“Last Data Row”).ToString) ==> has the value of 4… In the what to write = I am giving the formula as E2*2.5 That’s it here is my output [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 | 14 March 2021

Top 3 Topics with Most Views

Input a data or parameter to uipath from other softwares made by @Mingyu_Yan with 25 views.

Generic Value: Cannot add System.Int32 to System.String made by @Anggara_Rahmadhani with 22 views.

Dynamic selector for diffrent user made by @ashishmani with 21 views.

Top 3 Topics with Most Replies

Incrementing count of a column in excel based on value of other table made by @shekhawat.arjun1307 with 11 replies.

Data Service Entities got deleted after reactivating Enterprise Trial license made by @jamesjacobsydney with 8 replies.

Compare in a database made by @IOrlando with 7 replies.

Top 3 Users Who Posted The Most

@Sahil_Garg1 made 10 posts!

@shekhawat.arjun1307 made 10 posts!

@RPAForEveryone made 6 posts!

Top 3 Most Liked Posts

This post made by @wasea received 3 likes!

Where can someone verify the certificate issued by uipath?

Uithout login, if you provide the verification code, someone can look here: https://www.certmetrics.com/uipath/public/verification.aspx I hope it helps… Vasile

This post made by @ppr received 2 likes!

Insert first day of the last month and last day of the last month in a worklow (SAP)

@Markus3003 define the variables (both of datatype string) strFirstDayLMOnth strLastDayLMonth use an assign for setting the values e.g. strFirstDayLMOnth = new DateTime(now.Year,now.Month, 1).AddMonths(-1).toString("dd.MM.yyyy") strLastDayLMonth = new DateTime(now.Year,now.Month, 1).AddDays(-1).toString("dd.MM.yyyy") for setting the dates in SAP giva try on using a Type Into activity along writing the corresponding variable e.g. strFirstDayLMOnth

This post made by @Sharal_DCosta1 received 1 likes!

Announcing the 2021 UiPath MVPs!

Congratulations everyone!

Top 3 Most Liked Solutions

This solution provided by @wasea received 3 likes!

Where can someone verify the certificate issued by uipath?

Uithout login, if you provide the verification code, someone can look here: https://www.certmetrics.com/uipath/public/verification.aspx I hope it helps… Vasile

This solution provided by @ken_infield received 1 likes!

Csv読み込み後の上書き（更新）方法？

こんな感じでどうでしょう CSV_UPDATE.zip (2.7 キロバイト)

This solution provided by @Nadia_GHOUFA received 1 likes!

How to output classification results?

Hello @yourubl, Hope this helps. [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 | 15 March 2021

Top 3 Topics with Most Views

⭐ Rate UiPath on Gartner and get a 25 USD Visa Gift Card made by @Dana_Mustatea with 46 views.

Compare two numbers from website made by @boursikoteur with 31 views.

Need assist in REframework (unique reference) made by @Jesmine with 30 views.

Top 3 Topics with Most Replies

Read data from pdf and store that data into excel made by @Swetha_V with 26 replies.

Extract data a week from now made by @lmoham with 17 replies.

Need assist in REframework (unique reference) made by @Jesmine with 15 replies.

Top 3 Users Who Posted The Most

@prasath17 made 26 posts!

@Pravin_Patil1 made 25 posts!

@Sahil_Garg1 made 15 posts!

Top 3 Most Liked Posts

This post made by @PrankurJoshi received 4 likes!

Announcing the 2021 UiPath MVPs!

Many Many Congratulations All the MVPs!

This post made by @Dana_Mustatea received 4 likes!

Rate UiPath on Gartner and get a 25 USD Visa Gift Card

Hi folks, I’m back with a new rewards campaign, this time on Gartner Your experience with UiPath helped a lot of peers to find the best RPA solution out there, so big thanks for that! Rate UiPath on Gartner and get a 25 USD Visa Gift Card (directly rewarded by the Gartner team after your review it’s approved) Guidelines / Please read this carefully You can write your review here: https://gtnr.io/pdLJDggTU Deadline: March 26 Rewards: The first 70 reviewers of UiPath will get a $25 …

This post made by @NIVED_NAMBIAR received 3 likes!

Studio - How to get the dynamic Column from Excel

Hi @Prinal_C Use this code to find the column name Convert.ToChar(65+DT.columns.IndexOf(“Qty”)) Regards, Nived N Happy Automation

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Studio - How to get the dynamic Column from Excel

Hi @Prinal_C Use this code to find the column name Convert.ToChar(65+DT.columns.IndexOf(“Qty”)) Regards, Nived N Happy Automation

This solution provided by @NIVED_NAMBIAR received 2 likes!

How to get previous date?

u can use like this sample_date.ToString.Equals(datetime.now.AddDays(-1).ToString(“yyMMdd”)) Regards, Nived N Happy Automation

This solution provided by @prasath17 received 2 likes!

Get Latest Excel File Created from a folder

Hi @ramvashista85 - Please try this below code…this will give the recent file created in the folder. StrFileName = Path.GetFileName(Directory.GetFiles(YourFolderPath,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).creationtime).First) OR (If in case, the above code does not fetching the right file then use the below) StrFileName = Path.GetFileName(Directory.GetFiles(YourFolderPath,“*.xlsx”).OrderByDescending(Function(d) New FileInfo(d).LastWriteTime).First) StrFileName is of String T…

---

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

Top 3 Topics with Most Views

How to ignore 2nd delimiter in a data table made by @KavipriyaMoorthy with 39 views.

UiPath changing ":" to ";" made by @Kamalen_Reddy with 31 views.

SAP Logon : Return login window is null exception [Urgent] made by @AS07 with 29 views.

Top 3 Topics with Most Replies

How to ignore 2nd delimiter in a data table made by @KavipriyaMoorthy with 31 replies.

Get file extension with for each row made by @cteixeira with 22 replies.

Date conversion error coming while processing made by @ranaprathap928 with 20 replies.

Top 3 Users Who Posted The Most

@prasath17 made 39 posts!

@Hiba_B made 29 posts!

@Pravin_Patil1 made 26 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 3 likes!

Regular Expression to get only number from sentence

@Yoichi - I was typing the same thing …you beat me

This post made by @prasath17 received 3 likes!

Advanced text file data extraction

@Duleepa_Krishan - Glad it worked…Happy to assist always… Best video in youtube - From where I learned …and still learning the rest from the forum… Please take a look at this post for the starter help…

This post made by @andreiT received 3 likes!

Assistant - robot is unlicensed

Yes We are partly to blame here because of the bad feedback we are giving in assistant for unattended robots. Le me try to explain what is going on, but it’s a bit complicated, I will not blame anyone for failing to understand, it was hard for me too. I’ll start with the TLDR: with unattended robots only use machine key connection and uncheck the ENFORCE SIGN-IN from Tenant > Settings Security if you want to see processes in Assistant with attended robots - you can use both ma…

Top 3 Most Liked Solutions

This solution provided by @andreiT received 3 likes!

Assistant - robot is unlicensed

Yes We are partly to blame here because of the bad feedback we are giving in assistant for unattended robots. Le me try to explain what is going on, but it’s a bit complicated, I will not blame anyone for failing to understand, it was hard for me too. I’ll start with the TLDR: with unattended robots only use machine key connection and uncheck the ENFORCE SIGN-IN from Tenant > Settings Security if you want to see processes in Assistant with attended robots - you can use both ma…

This solution provided by @Hiba_B received 2 likes!

Read Range help

Would that help you ? Sequence.xaml (10.5 KB)

This solution provided by @Hiba_B received 2 likes!

CALCULATING VALUES OF COLUMN A AND COLUMN B AND WRITING TO COLUMN C USING WRITE CELL

What are your options with headers in the read and the write range ? Read range should not add headers, same goes with write range. Try to remove the 3rd column and give it a try again

---

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

Top 3 Topics with Most Views

For each row of a datatable made by @Markus3003 with 30 views.

Automation Cloud(tm) Previews: Azure AD Integration for enterprise and OAuth 2.0 for 3rd party apps made by @Geoff with 29 views.

Excelのセルに順番に書き込んでいく方法を知りたい made by @mm.mm with 28 views.

Top 3 Topics with Most Replies

Como convertir multiples extensiones a PDF (Pido Ayuda) made by @IOrlando with 25 replies.

For each row of a datatable made by @Markus3003 with 20 replies.

Move emails from one folder to another in outlook made by @Minol_Pamosha with 16 replies.

Top 3 Users Who Posted The Most

@Hiba_B made 38 posts!

@Srini84 made 30 posts!

@Pravin_Patil1 made 30 posts!

Top 3 Most Liked Posts

This post made by @ankit.saraf received 6 likes!

Introducing Open API support for Data Service

I am happy to announce release of Data Service Open API endpoints which allow you to access your Data Service entities from an external application. The APIs allow same functionality as Data Service Studio activities and create, upload, delete, or retrieve data from any entity you have read and/or write permissions in Data Service. You will need to register an external application in UiPath Automation Cloud, and grant any of the supported scopes to the external application: DataService.Schema…

This post made by @Geoff received 2 likes!

Automation Cloud(tm) Previews: Azure AD Integration for enterprise and OAuth 2.0 for 3rd party apps

Comprehensive RPA platform governance and management have been a key focus for us here at UiPath from our first releases. Continuing this commitment, we introduce two new preview capabilities that deliver even better enterprise-scale TCO and compliance outcomes by more deeply integrating UIPath Automation Cloud™ with the core management technologies many of our customers are already using - Azure AD and OAuth 2.0. Our new previews offer: Comprehensive integration with Azure AD for Automatio…

This post made by @mm.mm received 2 likes!

取得した文をサイトに貼り付けると、変な文章になる

ありがとうございます。まさに翻訳サイトだったので、下記の方法で直りました。 ＞ * 【文字を入力】のプロパティで、「入力をシミュレート」をTrueにして動作するか、確認してみてください。 大変助かりました。

Top 3 Most Liked Solutions

This solution provided by @cheez_RPA received 1 likes!

取得した文をサイトに貼り付けると、変な文章になる

おそらく、Webサイト側で入力をリアルタイムに翻訳するような動きが入っていて、1文字入力されるごとに入力位置が変動していることが原因のように思います。 【文字を入力】のプロパティで、「入力をシミュレート」をTrueにして動作するか、確認してみてください。 動作しなければ、文字列をクリップボードに保存 → 【ホットキーを送信】で、テキストボックスに文字列を貼り付け、とすると解決するかと思います。

This solution provided by @LevKushnir received 1 likes!

Automating SAP SuccessFactors

pHI @ashwin.ashok I was able to reproduce and understand the issue, you have described. So, follow me: The good news is, that SAP SuccessFactors is using SAP FIORI interface and we are able to understand/automate each and every SAP FIORI controls in very stable manner. The bad news is, that in SAP SuccessFactors there is some kind of “extension layer” on top of FIORI, which does not allow us to get to the SAP FIORI layer during “Selection on screen” BUT The good news is, that we can overcom…

This solution provided by @ppr received 1 likes!

Data table Aggregation for dates

@prasath17 Many thanks for this cross check I did update the statement let mdt = grp.OrderBy(Function (x) CDate(x(1).toString)).Last()(1) bold part was ommited - we want to fetch the col value. Thanks for cross checking and enhancement GroupBy_1Col_TakeLastMonth.xaml (7.5 KB) the original data was without leading 0 in the month part but both are working

---

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

Top 3 Topics with Most Views

DataTable filter conditions made by @MLT with 50 views.

Close PDF made by @Markus3003 with 47 views.

Issue with Read range - variable already set made by @Danny_Gi with 43 views.

Top 3 Topics with Most Replies

Close PDF made by @Markus3003 with 26 replies.

Dynamically insert datatable in Excel table or resize the table size as soon as data is added made by @AS07 with 17 replies.

指定列の空白セルを見付け、そこから処理再開したい made by @miwa_yamamoto with 15 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 36 posts!

@Adrian_Star made 35 posts!

@Hiba_B made 33 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 4 likes!

String manipulation for file path

Hi, Another solution : System.Text.RegularExpressions.Regex.Match(System.IO.Path.GetFileNameWithoutExtension(filepath),"\d+").Value It’s no problem even parent directories have numeric character(s). Regards,

This post made by @chaitanya.kulkarni received 3 likes!

Most Active Users - New community feature

This is indeed very encouraging… Glad to spot myself on the list😁

This post made by @Yoichi received 3 likes!

DataTable filter conditions

Hi, Can you try the following? dt.AsEnumerable.Where(Function(row) DateTime.FromOADate(Double.Parse(row("Start Date").ToString)).Date=Today).ToArray Sequence.xaml (6.1 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

String manipulation for file path

Hi, Another solution : System.Text.RegularExpressions.Regex.Match(System.IO.Path.GetFileNameWithoutExtension(filepath),"\d+").Value It’s no problem even parent directories have numeric character(s). Regards,

This solution provided by @Yoichi received 2 likes!

Int.Parseでエラーになる

こんにちは 元々はデータテーブルの列”塗装面積” で、数値が ０ もしくは、 0.000のものだけを抽出したく、 フィルタで抽出しようとしておりました。 以下のような感じでできると思います。（細かいエラー処理は追加する必要がありますが） newDt = dt.AsEnumerable.Where(Function(r) Double.Parse(r("塗装面積").ToString)=0).CopyToDataTable()

This solution provided by @Yoichi received 2 likes!

Uipath Activity Creator-File Path Control

Hi, The following is my blog post about activity creator and it contains content for file path control. Unfortunately, as it’s Japanese page, please use auto translate service to get it. Hope this helps you. Regards,

---

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

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

[system]

Daily Forum Report | 19 March 2021

Top 3 Topics with Most Views

範囲に書き込みのアクティビティについて made by @watame with 39 views.

Get index of element from collection made by @Danny_Gi with 34 views.

How to delete files in folder made by @Rashidi_Ahmad with 32 views.

Top 3 Topics with Most Replies

Regex, extraction problem made by @joseantonio with 21 replies.

Get index of element from collection made by @Danny_Gi with 15 replies.

Getting "Connected Unlicensed" with Uipath Assistant for new community orchestrator(no Default folder, having only shared folder)(Confusion in machine configuration) made by @Stalin_R with 13 replies.

Top 3 Users Who Posted The Most

@prasath17 made 26 posts!

@NIVED_NAMBIAR made 24 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @Karuna received 3 likes!

Most Active Users - New community feature

Good feature.

This post made by @Ani_Ma received 3 likes!

How to get first month of previous quarter

Thank you all for your replies! Based on the link from @prasath17 I found a solution: Var1 = now .AddMonths(-3).Month-1 Var2 = CInt(Math.Floor(Var1 /3)) *3 +1 In my first step I thought there would be a solution in 1 formula and that does not work very well for me. Now I splitted it in 2 variable and it worked.

This post made by @Yameso received 2 likes!

For each row of a datatable

It you want to replace text (folder) with value in row cell “Referenz” it should be: String.Replace(“string”,row(“Referenz”).toString) in () there should be comma, beetwen two strings.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

StudioX-How to convert a text file into CSV

Hi, Can you try Write Text File activity？ [img20210319-5] Regards,

This solution provided by @Lakshay_Verma received 1 likes!

DataTable filter conditions

What @Yoichi said is right. I just re-did what she have done. Follow steps Assign this in new DT dt = (From dr As datarow In dt Where DateTime.FromOADate(Double.Parse(dr.item("Start Date").ToString)).Date=Today AndAlso DateTime.FromOADate(Double.Parse(dr.Item("Approved On").ToString)).Date<=Today AndAlso DateTime.FromOADate(Double.Parse(dr.Item("Approved On").ToString)).Date>=New Date(Now.Year,Now.Month,1).AddMonths(-1) Select dr).copytodatatable Once you have new dt 'use for each row an…

This solution provided by @ncrescente received 1 likes!

Unattended Robot does not perform under locked screen / minimized RDP-Session

Dear all, the problem is solved - we adjusted the robo setting “Login to Console” to “Yes” in Orchestrator. Kind regards

---

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

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

[system]

Daily Forum Report | 20 March 2021

Top 3 Topics with Most Views

Issue in filtering date time column made by @Muthulakshmi_Thangamuthu with 36 views.

How to delete 1st row in excel files made by @Rashidi_Ahmad with 28 views.

Free UiPath for POC made by @Danish_Shaikh with 27 views.

Top 3 Topics with Most Replies

Issue in filtering date time column made by @Muthulakshmi_Thangamuthu with 13 replies.

How to read a text files with today's date in folder made by @Bhavya_Amala_Kosana with 13 replies.

How to split a random text containing numbers and print the last 9 digits made by @Bhavya_Amala_Kosana with 6 replies.

Top 3 Users Who Posted The Most

@Yameso made 13 posts!

@NIVED_NAMBIAR made 11 posts!

@Srini84 made 8 posts!

Top 3 Most Liked Posts

This post made by @saritha received 2 likes!

Most Active Users - New community feature

Great Feature and very good encouragement for learners…

This post made by @Yameso received 2 likes!

Most Active Users - New community feature

Another thing which makes it “almost” perfect is scale compare to resolution. For my monitor: AOC 24" 1920x1200 and Chrome 88.0.4324.190 with zoom 100% it looks like this: [image] The same thing is going on with app forum - opened chrome app by this link: [image] When I changed zoom to 90% then it’s looking perfect

This post made by @Lakshay_Verma received 2 likes!

How to split a random text containing numbers and print the last 9 digits

It is easy. Take it in variable for ex Var testString testString=testString.trim testString.Substring(testString.Count-9).ToString That’s all

Top 3 Most Liked Solutions

This solution provided by @Lakshay_Verma received 2 likes!

How to split a random text containing numbers and print the last 9 digits

It is easy. Take it in variable for ex Var testString testString=testString.trim testString.Substring(testString.Count-9).ToString That’s all

This solution provided by @Yameso received 1 likes!

Add in new collection if files size sum is 20 MB

Other way to do different names is add number to the file name. Then before for each loop create var: Int_FileZip = 1 And inside else ( in the right side of if activity) place this values: Str_fileZip = "zip_"+Int_FileZip.toString+".zip" Archive this collection to zip. Clear collection ( new list(of String)) Int_Size = int_FileSize add path to cleared collection Int_FileZip = Int_FileZip+1 In that case zip files will have shorter name and it would be zip_1.zip, zip_2.zip etc. …

This solution provided by @noufalahammed received 1 likes!

Issue in filtering date time column

Please use the below query, modify the condition if necessary (from i in sampleDt where DateTime.FromOADate(cdbl(i("Sales Date"))).Date = now.date or DateTime.FromOADate(cdbl(i("Sales Date"))).Date <= now.date AndAlso DateTime.FromOADate(cdbl(i("Sales Date"))).Date >= now.AddDays(-1).Date select i).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 | 21 March 2021

Top 3 Topics with Most Views

UiPath Certified Advanced RPA Developer (UiARD) made by @pragya_neekhra with 24 views.

Input duplicate data into row made by @Yudhisteer_Chintaram1 with 24 views.

Can I open excel file based on current Month information? made by @Dorothy_lee with 24 views.

Top 3 Topics with Most Replies

Can you please explain email regex in UiPath matches activity? made by @Surya_Narayana_Korivipadu with 12 replies.

Convert a string column to double made by @padmapadh1895 with 10 replies.

Input duplicate data into row made by @Yudhisteer_Chintaram1 with 10 replies.

Top 3 Users Who Posted The Most

@Cristian_Negulescu made 12 posts!

@Yameso made 11 posts!

@Pravin_Patil1 made 9 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 2 likes!

Filter option in excel

@ahamed_mansoor Welcome to forums Check below for your reference Hope this may help you Thanks

This post made by @Cristian_Negulescu received 1 likes!

PowerPointスライドにgraphを連続で貼付けたい その２

Hello Shinji, In this video, I have multiple use cases of UiPath working with POWERPOINT via VB.NET: [Multiple use-cases of PowerPoint Automation with UiPath] I have a lot of VB.NET Code that maybe you can reuse on your projects: startUiPathFromSalesforce/PowerPointCODE.txt at master · cristinegulescu/startUiPathFromSalesforce · GitHub Thanks, Cristian Negulescu

This post made by @Dorothy_lee received 1 likes!

[Date Inquiry] Can I set specific day of the week?

Thank you so much… !!! It’s working perfectly:)))) I’ll utilize for other function ! Happy Automation !!!

Top 3 Most Liked Solutions

This solution provided by @Yameso received 1 likes!

Convert a string column to double

It is not returning anythig because there is no data for today! I added those values to .xlsx: [image] And with the same workflow as you did i got: [image]

This solution provided by @Karuna received 1 likes!

Adding a robot to a machine

@Ignacio_Joaquin_Castro Yes, You need to connect your robot to orchestractor. The robot status is disconnected because your robot is not connected to orchestractor. Once its connected, The Status will be available. Screenshots are for your reference, How to connect your robot to orchestractor. Robot_Connection.zip (358.8 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 | 22 March 2021

Top 3 Topics with Most Views

Connected, Unlicensed same error made by @GovardhanReddy with 42 views.

Queues explanation made by @HomaDzz with 37 views.

DataTableから特定の列を抽出したい made by @nagumo with 34 views.

Top 3 Topics with Most Replies

How to use URLDownloadToFile in CodeActivity in UiPath made by @Vijay_Kumar_C with 16 replies.

Connected, Unlicensed same error made by @GovardhanReddy with 16 replies.

Sort dates output in IEnumerable<Match> made by @AhmedKutraphali with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 21 posts!

@Pravin_Patil1 made 19 posts!

@Hiba_B made 18 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

Make your package compatible with Studio 21.4

@Sophia_Salo Hello Sophia, thanks for your hint about the internal changes. This is very important for Custom Activity developers. Here the status of my activities: SAP GUI Info updated to SAP GUI 7.70 and successfully tested with UiPath 21.2 ABAP Runner updated and successfully tested with UiPath 21.2 UnRAR updated and successfully tested with with UiPath 21.2 AutoIt successfully tested with UiPath 21.2 All activities are now prepared to use it in x86 and x64 environments, they are al…

This post made by @StefanSchnell received 3 likes!

An Approach how to Implement Unit Tests in UiPath

For some time now I have been working on the topic of how unit tests can be implemented in UiPath. Unit tests are very important elements in automation for me. In my case I want to realize manual executed black-box tests, to ensure that my automations deliver the expected result. I look at this from the perspective of an RPA developer who is in the development process. Here an example: I have a Main process which invokes an SAP BAPI call. Here I add an empty sequence. [image] In the next step…

This post made by @prasath17 received 3 likes!

Filling Up Blank Cloumn-DT

@shrayud - As an alternate if you have more rows and then you want to avoid “For each” - you can try like this…In the “Invoke Code” Activity… dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Test”)= “New”) [image] My Output(I tried to write “New” in my Test Column… [image]

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 3 likes!

Filling Up Blank Cloumn-DT

@shrayud - As an alternate if you have more rows and then you want to avoid “For each” - you can try like this…In the “Invoke Code” Activity… dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Test”)= “New”) [image] My Output(I tried to write “New” in my Test Column… [image]

This solution provided by @prasath17 received 2 likes!

How to sort date column

@Vinutha_L - Please try like this… (From r In DT Order By DateTime.ParseExact(r.Item(“YourColumnName”).ToString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Descending Select r).CopyToDataTable

This solution provided by @Yameso received 2 likes!

Zip folder not visible while attaching it in web

Are you uploading files? Do you need to choose file in the window like this? [image] If thats yes then dont type into your Path_ varaible into: [image] Type it in: [image] after type into use sent hotkey with enter on the same selector.

---

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

Top 3 Topics with Most Views

Split excel into Unique and Duplicate Rows made by @Yudhisteer_Chintaram1 with 35 views.

引数の使い方 made by @0st0eDSep9 with 31 views.

Log message return NULL exception with UiPath.MicrosoftTeams.Activities made by @q.gio with 29 views.

Top 3 Topics with Most Replies

引数の使い方 made by @0st0eDSep9 with 18 replies.

Retrieve all Rows of a particular column from Datatable and assign it to an DataRow[] made by @Jadeja_Chandravijaysinh with 15 replies.

Sum of column where row is of a certain type made by @atomic with 14 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 34 posts!

@Yoichi made 31 posts!

@Hiba_B made 27 posts!

Top 3 Most Liked Posts

This post made by @Pravin_Patil1 received 4 likes!

Pause Automation

Better idea to take an element exist or wait element to appear activity and increase timeout property to 30 min… Just for information, If you want to do it in attended mode as one time activity then In UiRobot section we have an option to pasue… Refer below… [image]

This post made by @seanrockvz13 received 3 likes!

Most Active Users - New community feature

Cool Feature Pablito!

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

Techgig Code Gladiators 2021 virtual hackathon is live

Code Gladiators is the largest and annual coding battle in India and UiPath is an exclusive automation partner, 3rd year in a row for the 2021 Techgig Code Gladiators virtual hackathon. All RPA enthusiasts worldwide are invited to participate and showcase their skills. So, what are you waiting for? Create your team or participate individually by Registering HERE Think of your next big idea, we are looking forward to seeing ideas & solutions based on the following categories Category # 1 : Aut…

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Sum of column where row is of a certain type

Hi @atomic to calculate the sum of RA use the below linq query dt1.AsEnumerable().Where(Function(row) row(“Type”).ToString.Equals(“RA”)).Sum(Function(row) Cint(row(“Amount”).ToString)) use the same way for other values too apart from RA Try this Regards, Nived N Happy Automation

This solution provided by @ppr received 2 likes!

Join data table activity - left Join not working as expected

we do see that 123 occurs twice. So the nature of join will create follwoing: take first 123 from dt1 join it with 123-pen from dt2 123-pen from dt2 take the second 123 from dt1 join it with 123-pen from dt2 123-pen from dt2 thats why th 4 rows are found. In such cases removing duplicates e.g in dt2 or custom join logic can help. here is just to rule when left 123 is picked up by which rule the both 123 rows from dt2 are to select for the pairing.

This solution provided by @Yoichi received 2 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 | 24 March 2021

Top 3 Topics with Most Views

Robot.js로 로봇이 구동되지 않을 때 확인할 사항 made by @Minoh_Kang with 52 views.

Data scrapping / This control does not support data extraction made by @Soudios with 27 views.

Uipath StudioのOrchestratorへの接続設定 made by @Chiu_Haoyu with 27 views.

Top 3 Topics with Most Replies

Data scrapping / This control does not support data extraction made by @Soudios with 15 replies.

Issue with Use Application: Global Protect made by @Kinga_Formela with 14 replies.

Need Help on RegEx issue made by @Debartha_Mitra_DE with 13 replies.

Top 3 Users Who Posted The Most

@Lakshay_Verma made 30 posts!

@NIVED_NAMBIAR made 23 posts!

@Adrian_Star made 17 posts!

Top 3 Most Liked Posts

This post made by @AndersJensen received 2 likes!

BLOG: My name is Anders and I’m allergic to manual work

Hey Blog. I received one of the UiPath Most Valued Professional awards this year. Why did I get such a nice award when I’m an average technical RPA developer? I don’t exactly know the jury’s thoughts, but I’ll share how I see it in the next blog posts here. Long story short: There are other just as important aspects to being a UiPath MVP (and a good RPA developer). Hard skills + Soft skills + fast learner = A great RPA developer Stay tuned! Can you find me? [MVP4]

This post made by @ppr received 2 likes!

How to click the row which is highlited with green color?

@krishnareddy maybe it can be solved by dynamizing the selector:

This post made by @Pradeep_Shiv received 2 likes!

I need to extract the name from the email address using regex

Try this System.Text.RegularExpressions.Regex.Split(“Cheery123@gmail.com”,“\d{0,}@”)

Top 3 Most Liked Solutions

This solution provided by @Pradeep_Shiv received 2 likes!

I need to extract the name from the email address using regex

Try this System.Text.RegularExpressions.Regex.Split(“Cheery123@gmail.com”,“\d{0,}@”)

This solution provided by @Srini84 received 2 likes!

Finding Unique Values and Summing them from an Array Using LINQ

@ashwin.ashok Check as below [image] Use ArrayVariable.Distinct().ToArray.Sum(Function (r) Double.Parse(r.ToString)) Mark as solution if this help you Thanks

This solution provided by @prasath17 received 2 likes!

DT is blank

hi @shrayud …Dttable.clone method does not copy all the records to other datatable. it’s just copies the schema to the new dt. See the below screenshot, I have cloned dtIn to dtcorrected and printed the dtcorrected which just shows the column names… [image] So, if you want to a backup use datatable.copy method…see below… [image] Here is the reference:

---

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

Top 3 Topics with Most Views

Structure of Loops made by @Yudhisteer_Chintaram1 with 38 views.

How to check if item exist in array? made by @AhmedKutraphali with 29 views.

There are no Available licence comunity version made by @davron20 with 28 views.

Top 3 Topics with Most Replies

Structure of Loops made by @Yudhisteer_Chintaram1 with 24 replies.

Convert cell or range value from text to number [Excel][Vb] made by @AS07 with 22 replies.

フォルダ内のテキストファイルの起動について made by @kawagolf with 19 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 34 posts!

@prasath17 made 33 posts!

@NIVED_NAMBIAR made 26 posts!

Top 3 Most Liked Posts

This post made by @GBK received 3 likes!

How to give default value for regex iendurable<Match>

@copy_writes - you can try to assign a variable in if activity based on match response like below matched_string = Regex.Match(regex); if(matched_string == null) { matched_string = "default"; }

This post made by @prasath17 received 3 likes!

Get text after string and ignore any spaces

@JeffNZ1 - You can try this Regex pattern… Assumption: After the Last Name there will be usermenu always.. [image] StrFNLN= Regex.Match(“JS Jeff ShumUserMenu”,“(?<=\s*)\w+\s*?\w+(?=UserMenu)”).value Import : System.text.regularexpressions (if Regex.Match did not recognize) [image]

This post made by @Berke received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, My name is Berke, I am 17 years old and studying in the informatics department. I’m trying to learn more about Rpa and improve myself as much as possible on these issues.

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Structure of Loops

Hi @Yudhisteer_Chintaram1 Have a look at that workflow Main.xaml (14.0 KB) You can look at the workflow comments which i had put to get the logic how we can execute the workflow I am preffering a while loop here to do the process @copy_writes please have a look on that too Regards, Nived N Happy Automation

This solution provided by @Cristian_Negulescu received 2 likes!

Unable to update description in jira , but able to update summery

Please Check the movie on minute 1:52 to see how I define variables you need to write new JObject() . I also have a movie dedicated how to create JSON with details: [UiPath Tutorial for JSON Parsing and Creation | 8 UseCase]

This solution provided by @ppr received 2 likes!

Excel rows, create list only from integer numbers of rows

@Danny_Gi we do feel that a list with 1,2,3 will not help your case Also a list with all number will not add a value. Looking on this from another viewpoint we do see the chance to form groups based on main and sub items. for this we can use a group by approach: and if we do the grouping by logic like bring e.g. 1 and 1.1,1.2 … etc together we can segment the data for a further processing. Here following statement will help for defining the group key: [grafik] Let us know if you want to…

---

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

Top 3 Topics with Most Views

How to read email and save in data table? made by @praveen_sonkusare with 31 views.

How to skip the first row of a foreach loop in C#? made by @lmoham with 31 views.

Limitations of uipath tool made by @srividhya.r with 29 views.

Top 3 Topics with Most Replies

Send path from UIPath to macro made by @fairymemay with 15 replies.

フィルタのように、特定のものだけのDTを作りたい made by @miwa_yamamoto with 12 replies.

How to skip the first row of a foreach loop in C#? made by @lmoham with 10 replies.

Top 3 Users Who Posted The Most

@Kah_Liang made 19 posts!

@Srini84 made 19 posts!

@prasath17 made 18 posts!

Top 3 Most Liked Posts

This post made by @Chio_f received 3 likes!

UiPath Marketplace ガイド の日本語翻訳が完了しました！

こんにちは。Marketplaceからお知らせです。 UiPath Marketplaceガイドについて、この度日本語の翻訳が完了し、新しく生まれ変わりました。 https://docs.uipath.com/marketplace/lang-ja ようやく日本語版としてご案内できることを嬉しく思います。 皆様のMarketplace利用に役立てていただくことができれば何よりです。 新しいコンテンツも随時、英語から日本語へ変更されていく予定ですので、どうぞ日本語版もご参考ください！

This post made by @ppr received 3 likes!

Need suggestion on filename's regex

As an alternate also with case ignore flag, but control on space and underscore: [grafik]

This post made by @Yoshi_Akiyama received 2 likes!

Kill processes from server ONLY for current user

Hi, We added an option in kill process activity to kill process per user, and per session(useful for PiP, since user is same from parent session). This is from 21.4 System Activity pack. 21.4-beta is already available in the official feed.

Top 3 Most Liked Solutions

This solution provided by @vignesh.ks received 1 likes!

Possible to count the number of '+' appearing in an excel column?

Hi @lmoham Please use the below method. System.Text.RegularExpressions.Regex.Matches(yourVariable,“[+]”).count Feel free to reach us at any time if you have doubts. Thanks. Happy Automation

This solution provided by @prasath17 received 1 likes!

How to Append file excel

@fairymemay - Fixed now…Your workflow is perfect other than you had duplicated ‘dt’ variable. Run this below file “As is” you will see the output.xlsx gets created in the project folder… Append Files_Noona.zip (58.0 KB)

This solution provided by @Kah_Liang received 1 likes!

フィルタのように、特定のものだけのDTを作りたい

Hi @miwa_yamamoto Yes you definitely can. Just start from creating a variable, let’s say “Month” dt = dt.AsEnumerable.Where(Function(r) r(“Month”).ToString = Month).CopyToDataTable You can try to call the variable by pressing ctrl+space at r(“Month”).ToString = HERE Also, for you information there are many different ways to filter datatable you can learn them here and use different one for different scenario. Regards, Kah Liang

---

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

Top 3 Topics with Most Views

Starts a process only when a new data is added to database made by @Alamyr_Junior with 25 views.

Hello How to replace text in text file made by @copy_writes with 22 views.

Regex pattern to extract date format ddMMMyyyy made by @MasterOfLogic with 20 views.

Top 3 Topics with Most Replies

Excel 2 different sheet in same excel made by @vishal22landge with 11 replies.

Data scrapping multiple pages made by @xyzxyz_123 with 8 replies.

Starts a process only when a new data is added to database made by @Alamyr_Junior with 7 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 7 posts!

@copy_writes made 6 posts!

@prasath17 made 6 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 1 likes!

IIS에서 Let's Encrypt 인증서를 발급받는 방법

Azure에 있는 윈도우즈 VM에서 사용할 인증서를 Let’s Encrypt에서 무료로 발급받는 방법을 공유합니다. 해당 머신의 웹서버는 IIS인 경우입니다. Let’s Encrypt 인증서 발급을 도와주는 RCL Client for Let’s Encrypt 서비스를 사용합니다. Let’s Encrypt 인증서는 무료이지만, 이 서비스는 free trial이 만료되면 유료로 전환되는 점에 주의하시기 바랍니다. Azure에서 이 서비스를 찾아 가입하고 계정을 활성화하면 아래와 같이 Let’s Encrypt 인증서 발급을 시작할 수 있습니다. [image] 용도에 맞는 적합한 옵션을 선택하여 "Select"를 클릭하면 아래와 같이 필요한 정보를 입력하게 됩니다. Azure VM에 부여한 도메인명(FQDN)이 myweb.koreacentral.cloudapp.azure.com이라면 아래와 같이 입력해야 합니다. Let’s Encrypt가 인증서를 발급하기 전에 해당 도메인의 소유자…

This post made by @Alamyr_Junior received 1 likes!

Starts a process only when a new data is added to database

Hi, I have a process that I need to run just when new data is added to a database, is there a way to link that database to orchestrator and make it starts only with new data? Regards, Alamyr

This post made by @NIVED_NAMBIAR received 1 likes!

Starts a process only when a new data is added to database

Hi @Alamyr_Junior Try webhooks for it to trigger a Uipath process when a new entry is added to database

Top 3 Most Liked Solutions

This solution provided by @Sahil_Garg1 received 1 likes!

Hello How to replace text in text file

Hey, You can user String.Format method. For example: SampleString = Hi {0} , Welcome to {1}. In Bot: String.Format(SampleString,“Copy_Writes”,“UiPath”) Output : Hi Copy_Writes, Welcome to UiPath. Give index value in your text whereever you wants specific word, and extract word from excel it will replace it in the string. Let me know in case of any concern. Regards, Sahil

This solution provided by @Rachita_Chauhan received 1 likes!

Communication between UiPath Studio and the Taxonomy Manager ended unexpectedly

I saw many posts on this but no solution. I found the Package that is responsible for this error. Its this package: [image] it fixed the issue.

---

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.