Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 March 2021

Top 3 Topics with Most Views

Announcing the 2021 UiPath MVPs! made by @Luiza with 1440 views.

Element Exists Else Skip made by @Andrew_Callaghan with 62 views.

Uipath send hotkey based on number made by @AhmedKutraphali with 48 views.

Top 3 Topics with Most Replies

Announcing the 2021 UiPath MVPs! made by @Luiza with 50 replies.

Element Exists Else Skip made by @Andrew_Callaghan with 19 replies.

RE frame work made by @prashanth_reddy with 17 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 17 posts!

@prasath17 made 15 posts!

@supermanPunch made 15 posts!

Top 3 Most Liked Posts

This post made by @Luiza received 61 likes!

Announcing the 2021 UiPath MVPs!

UiPath Community, please welcome the UiPath 2021 Most Valuable Professionals! We are beyond excited to announce our 62 top automation professionals who have been continuously making outstanding contributions to the UiPath Community with relentless passion, creativity, and drive! Throughout 2020 they have demonstrated: Strong Product expertise track record of engagement with the community innovation, leadership and RPA knowledge sh…

This post made by @NIVED_NAMBIAR received 10 likes!

Announcing the 2021 UiPath MVPs!

Congratulations guys

This post made by @FrankSchikora received 10 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to the new and returning MVP’s! Amazing to see all the new faces!

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Regex to extract the last set of dates

Hi @AhmedKutraphali - I have used the keyword “Yes” from your text… [image] If Yes will not present always please let me know, I will change the pattern

This solution provided by @prasath17 received 1 likes!

Reading dates in excel return random numbers not the date

@Macklin_J - Please check this post…(if you feel preserve format will slow down your process)

This solution provided by @ppr received 1 likes!

Add Data Column show error as already belong to another datatable

As mentioned by @supermanPunch a datacolumn from one datatable cannot be used for an direct addition to another datatable. And this is the reason why the error is shown. As an alternate you can do (Create Datacol, and transfer settings from other datacolumn) Variables [grafik] Flow: [grafik] [grafik] it also depends on your scenario details. We get also compact flows we clone datatable and a further datacolumn structre modification

---

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

Top 3 Topics with Most Views

UiPathが頻繁に立ち上がらなくなる made by @nagumo with 31 views.

Excel fetch values made by @sruthesanju with 30 views.

Strin型の変数をdatetime型に変換できない made by @rkym123456 with 29 views.

Top 3 Topics with Most Replies

UiPathが頻繁に立ち上がらなくなる made by @nagumo with 9 replies.

Can't add an unattended robot made by @PeruT with 9 replies.

Regex to extract amount after a code pattern made by @AhmedKutraphali with 8 replies.

Top 3 Users Who Posted The Most

@ksrinu070184 made 17 posts!

@PeruT made 9 posts!

@prasath17 made 9 posts!

Top 3 Most Liked Posts

This post made by @octechnologist received 3 likes!

Announcing the 2021 UiPath MVPs!

So happy to be included again this year! Hoping to help many people discover and maximize the power of UiPath.

This post made by @Lahiru.Fernando received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all the amazing minds!!! Looking forward to connecting with all of you soon!!

This post made by @jack.chan received 3 likes!

UiPath Generic Framework Template

Hi everyone, i’d like to share my new workflow template. Feel free to use it and ask any questions. This is a generic template that can be used with any process and you can build it on top of your own frameworks [image] The template contains 4 states: Initialize - For reading config / running initialization healthcheck (Makes use of the Initialization check activity available here.) . If Healthcheck pass, go to Process, otherwise go to End. Process - For copying files to working folder …

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Studio - Error during Add Data Row

@Prinal_C Does this newDT supposed to have the same columns as that of the MyDT ? If so, instead of initialising the newDT, you can clone the MyDT and assign it to the newDT in the below way : newDT = MyDT.Clone I believe then the problem should be solved, If not please explain what errors do you get and what changes have you done.

This solution provided by @prasath17 received 1 likes!

Save email attachments that has keyword "Approval" in it

@arunasan - Filter should be in Regex format…Since your attachment does not have Approval nothing fetched. [image] So, if you are looking for the word Approval or approval. please try like “(Approval|approval)” it should work. I just tested it. please see below… Before Filter [image] After Filter [image] [image]

This solution provided by @prasath17 received 1 likes!

Regex to extract amount after a code pattern

@AhmedKutraphali - Please wait, when i tested the above pattern, it is not giving the proper results… Update: Please check this… YourRegexVariaoble(0).Groups(1).tostring

---

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

Top 3 Topics with Most Views

How to add values to an already existing key in dictionary made by @franrua02 with 30 views.

For each row loop return row number made by @hughabbott with 25 views.

Table Extraction, half records Image URL, and half is not! made by @AmarBouz with 24 views.

Top 3 Topics with Most Replies

For each row loop return row number made by @hughabbott with 14 replies.

Help required to change date format made by @Anwar_Mirza with 11 replies.

マクロの呼び出しでセルがdd/mm/yyyyになる made by @katsuta with 10 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 9 posts!

@ksrinu070184 made 9 posts!

@hughabbott made 7 posts!

Top 3 Most Liked Posts

This post made by @msanthakumara received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all the MVP

This post made by @Sahil_Garg1 received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all MVP’s , great work guys.

This post made by @AMRITANShlal received 2 likes!

How to copy element in Find Children

Hey @Akaza You can do it conventional way. Assign a variable of type Array of string i.e., (String) and lets name it listFile. Then use following expression System.IO.Directory.getFiles(“Your Path”,“test”) It’ll pick only those item which contain ‘test’ Inside ForEach use ‘Move File’ activity and pass target path and path that you’ll get from above expression. I believe that’ll work.

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Write data in the first empty row

@Muthulakshmi_Thangamuthu - Read Range - call the datable as Dt Say. Assign IntRowcount = Dt.rows.count.tostring. This will give 3… So inorder to write in the first empty row…you have to “A” + (Introwcount+2).tostring or “B” + (Introwcount+2).tostring

This solution provided by @ChrisPals received 1 likes!

How to write .bat file with write text file activity

Thank You for the responses I changed my encoding to utf-8 which resolved 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.

[system]

Daily Forum Report | 07 March 2021

Top 3 Topics with Most Views

I can't find the robot icon at UIpath orchestrator at the classic folder made by @Jarrod_Stewart with 23 views.

Https://docs.uipath.com/developer/docs/robot-api made by @notLuyanda with 21 views.

My First Custom Activities Package made by @Ahmed_ELShubaky with 21 views.

Top 3 Topics with Most Replies

I can't find the robot icon at UIpath orchestrator at the classic folder made by @Jarrod_Stewart with 8 replies.

Scraping website made by @ngateno_eno with 8 replies.

Get Outlook mail message filtering issue with received time made by @Ewout with 8 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 10 posts!

@NIVED_NAMBIAR made 9 posts!

@Vrushali_Gave made 8 posts!

Top 3 Most Liked Posts

This post made by @seanrockvz13 received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations Everyone!

This post made by @Vrushali_Gave received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all MVP’s

This post made by @Shubhi received 2 likes!

Announcing the 2021 UiPath MVPs!

Thank-you Hashim @Hashim_Shamsudeen

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 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 @maz 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!

@ksrinu070184 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 V…

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!

@ksrinu070184 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 @KarunaD 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!

@ksrinu070184 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 @ksrinu070184 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 @KarunaD 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.