Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 May 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@kumar.varun2 made 18 posts!

@copy_writes made 10 posts!

@Harish_pavuluri made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

How to learn LINQ?

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

This post made by @ppr received 3 likes!

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

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

This post made by @prasath17 received 1 likes!

How to learn LINQ?

@kumar.varun2 - These are some of the LINQ tutorials websites suggested by ppr in this forum… https://linqsamples.com/tutorials/linq-for-beginners http://dotnetlearners.com/linq https://www.tutlane.com/tutorial/linq

Top 3 Most Liked Solutions

This solution provided by @jeevith received 1 likes!

Need ideas to develop POC

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

---

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

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

[system]

Daily Forum Report | 30 May 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@kumar.varun2 made 19 posts!

@Shubham_Varshney made 13 posts!

@Deepak_Gautam made 11 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 2 likes!

How to set file name with contains today date?

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

This post made by @Chinmaya_Dhal received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

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

This post made by @Shubham_Varshney received 1 likes!

Check Email Address in Active Directory

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

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

How to set file name with contains today date?

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

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

Check the validity of an email addrees in the active directory

Check this xaml file. It is a simple approach to check the validity of the email address in AD. Let me know if it works for you Check email ID validity in AD.xaml (6.4 KB)

---

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

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

[system]

Daily Forum Report | 31 May 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Krishna_547 made 26 posts!

@ppr made 25 posts!

@kumar.varun2 made 17 posts!

Top 3 Most Liked Posts

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

UiPath Community Learning - Survey

Completed the survey.

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

This post made by @Hemanth_Kumar3 received 2 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @kadiravan_kalidoss received 1 likes!

What is the best way to handle abbreviation?

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

This solution provided by @Shubham_Varshney received 1 likes!

Excel - moving columns

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

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

Convert data table to HTML to be included in email body

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

---

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

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

[system]

Daily Forum Report | 01 June 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@postwick made 28 posts!

@kumar.varun2 made 27 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

セレクターのaanameとは？

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

This post made by @prasath17 received 2 likes!

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

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

This post made by @Yoichi received 2 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

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

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

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

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

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

This solution provided by @prasath_S received 2 likes!

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

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

---

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

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

[system]

Daily Forum Report | 02 June 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

Unable to parse a Json String made by @Sairam_RPA with 14 replies.

Top 3 Users Who Posted The Most

@postwick made 29 posts!

@ppr made 22 posts!

@prasath_S made 22 posts!

Top 3 Most Liked Posts

This post made by @Raluca_Ilie received 4 likes!

Explore UiPath 21.4 - Instagram LIVE Session - June 3

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

This post made by @prasath_S received 3 likes!

Skipping header line

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

This post made by @Yoichi received 2 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Getting an error like input string not in correct format

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

This solution provided by @Yoichi received 1 likes!

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

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

This solution provided by @MarioHerrmann received 1 likes!

How to access mail without being logged in

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

---

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

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

[system]

Daily Forum Report | 03 June 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@postwick made 23 posts!

@Krishna_547 made 22 posts!

@Assyl_Abetayev made 11 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

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

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

This post made by @Yoichi received 2 likes!

Data table dynamic code issue

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

This post made by @prasath_S received 2 likes!

Possible to filter row by number of character

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

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Data table dynamic code issue

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

This solution provided by @prasath_S received 2 likes!

Possible to filter row by number of character

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

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

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

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

---

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

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

[system]

Daily Forum Report | 04 June 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@ppr made 19 posts!

@postwick made 12 posts!

@Pankaj.Patil made 11 posts!

Top 3 Most Liked Posts

This post made by @mz3bel received 3 likes!

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

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

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

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

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

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

API => GET Jobs not working

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

Top 3 Most Liked Solutions

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

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

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

This solution provided by @ppr received 2 likes!

How to duplicate rows with ignorecase

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

This solution provided by @J0ska received 1 likes!

How To Terminate Process in Middle of Whole Process?

There is enough resources about T/C. Search and test. It is the best learning. Cheers

---

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

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

[system]

Daily Forum Report | 05 June 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Hiba_B made 11 posts!

@AndyMenon made 8 posts!

@postwick made 5 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 2 likes!

How can I perfom a write range every 100 rows

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

This post made by @cheez_RPA received 1 likes!

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

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

This post made by @ken_infield received 1 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @Chris_Bolin received 1 likes!

Problem with index on dynamic selector

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

---

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

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

[system]

Daily Forum Report | 06 June 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@kumar.varun2 made 19 posts!

@Tamar_Markowitz made 7 posts!

@111701 made 6 posts!

Top 3 Most Liked Posts

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

ChromeからPDF作成について

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

This post made by @ken_infield received 1 likes!

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

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

This post made by @salax_sunny received 1 likes!

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

@GouthamVijay Thanks for the solution.

Top 3 Most Liked Solutions

This solution provided by @ken_infield received 1 likes!

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

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

This solution provided by @ppr received 1 likes!

How to add two lists or arrays?

L1.concat(L2).tolist / toArray

---

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

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

[system]

Daily Forum Report | 07 June 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@prasath17 made 21 posts!

@ppr made 21 posts!

@Cristian_Negulescu made 20 posts!

Top 3 Most Liked Posts

This post made by @shinji received 2 likes!

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

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

This post made by @ppr received 2 likes!

How to skip columns using LINQ?

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

This post made by @ppr received 2 likes!

Convert date to year/week number format

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

Top 3 Most Liked Solutions

This solution provided by @shinji received 2 likes!

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

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

This solution provided by @ppr received 2 likes!

How to skip columns using LINQ?

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

This solution provided by @ppr received 2 likes!

Convert date to year/week number format

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

---

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

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

[system]

Daily Forum Report | 08 June 2021

Top 3 Topics with Most Views

How to run the RPA regularly? made by @karol.pang with 30 views.

Linq query show output 0 made by @fairymemay with 27 views.

How to keep the integer variable a constant number? made by @lmoham with 27 views.

Top 3 Topics with Most Replies

RPA Challenge data made by @Katherine_Ward with 19 replies.

Unable to view/create Environment in orchestrator2021.6.2 release made by @itsmegovardhan with 14 replies.

How to add Excel file Headers into another DataTable made by @nilesh.mahajan with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 22 posts!

@Pankaj.Patil made 22 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 4 likes!

Code issue to count recurring letters in a word

Hi, How about the following? [img20210608-4] Sequence1.xaml (6.8 KB) Regards,

This post made by @edavis4 received 2 likes!

Issues with remote run not finding IE

We have a bot that was running fine for an extended period of time. About a month ago our VDIs were rebuilt, and since then we are experiencing issues with one of our bots. It should be a remote bot, but any time we run it now without logging into the VDI, it experiences one of two primary errors: RemoteException wrapping UiPath.Core.BrowserOperationException: Cannot communicate with Internet Explorer browser RemoteException wrapping System.Runtime.InteropServices.COMException: Timeout reached…

This post made by @Yoichi received 2 likes!

Having trouble with the Switch Case activity

Hi, We need to use ReadCell activity instead of ReadCellFormula activity because ReadCellFormula returns empty if there is no formula (even there is data). Then you need to change type of isEmpty from String to GenericValue, (and might be modift from isEmpty to isEmpty.ToString In addition initial value of counter should be 1. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

Code issue to count recurring letters in a word

Hi, How about the following? [img20210608-4] Sequence1.xaml (6.8 KB) Regards,

This solution provided by @Yoichi received 2 likes!

Having trouble with the Switch Case activity

Hi, We need to use ReadCell activity instead of ReadCellFormula activity because ReadCellFormula returns empty if there is no formula (even there is data). Then you need to change type of isEmpty from String to GenericValue, (and might be modift from isEmpty to isEmpty.ToString In addition initial value of counter should be 1. Regards,

This solution provided by @NIVED_NAMBIAR received 2 likes!

LINQ-Get Only Columns without where

Hi @KarthikBallary another way of acheveing this is by using below assign activity suppose u had stored ur excel in dt1 then use below assign activity dt2 = dt1.DefaultView.ToTable(False,{“col1”,“col3”}) then dt2 will only contains col1 and col3 Regards, Nived N Happy Automation

---

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

Top 3 Topics with Most Views

Capgemini - UiPath Developer - Bangalore - India - Full Time made by @Vibhor.Shrivastava with 31 views.

プロシージャの呼び出し または引数が不正です made by @miwa_yamamoto with 29 views.

How to update Remark in Excel file specific column from first used cell till last used cell made by @nilesh.mahajan with 24 views.

Top 3 Topics with Most Replies

Error trying to import package into Orchestrator - invalid package details made by @postwick with 8 replies.

Directory.GetFiles with a List of Files made by @NHoe with 7 replies.

Lookup using two columns made by @MANISHA_V_ARORA with 7 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 20 posts!

@postwick made 16 posts!

@ppr made 12 posts!

Top 3 Most Liked Posts

This post made by @Michelle_Yurovsky received 2 likes!

Introducing UiPath Insights Cloud

hey @balramrv, we will be building the import/dashboard export feature. It will be coming towards the end of the year. However, the LRW dash that’s on the marketplace will not work for Cloud Insights. We will likely release a separate one specifically for cloud

This post made by @Yoichi received 2 likes!

Need to store unique values in a column

Hi, How about the following? [img20210609-8] Sample20210609-4.zip (2.6 KB) Regards,

This post made by @alexandretperez received 2 likes!

Need to pick 9 digit numeric value

Hi @Fresher You need then specify what kind of characters you can have before and after this 9 digit group. [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Need to store unique values in a column

Hi, How about the following? [img20210609-8] Sample20210609-4.zip (2.6 KB) Regards,

This solution provided by @ppr received 2 likes!

Directory.GetFiles with a List of Files

Directory.GetFiles(YourDirPath, “Test*.xlsx”) for a prefiltering Or Filtering before for each e.g. arrFiles = Directory.GetFiles(YourDirPath) arrMask = {“Test1”,“Test3”} arrFilesFiltered = arrFiles.Where(Function (x) arrMask.Any(Function (f) x.Contains(f))).toArray

This solution provided by @ppr received 1 likes!

Split string not working and throwing two errors

YourStringVar.Split(","c) [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 | 10 June 2021

Top 3 Topics with Most Views

Dictionary型の操作サンプル made by @Yoshi_Akiyama with 33 views.

UipathからのGASの実行方法に関して made by @1111047 with 27 views.

Move File with Unique Name made by @NAJAA_BAZILAH with 25 views.

Top 3 Topics with Most Replies

Click many times made by @Soudios with 16 replies.

Getting an error in Matches made by @Puneet_Singh1 with 14 replies.

Move File with Unique Name made by @NAJAA_BAZILAH with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 28 posts!

@ppr made 20 posts!

@Yoichi made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoshi_Akiyama received 4 likes!

Dictionary型の操作サンプル

API系アクティビティを使っていると、帰ってくるデータがDictionary型の場合があって、 dictionaryの中身の調べ方は少し難しいのでサンプルを作りました。 よければ使って見てください。 使って見た人の不明点に回答するために解消するためにしばらく（２営業日ぐらい？）オープンにしときます。 DictionaryEnumerationTest.zip (3.1 KB)

This post made by @NIVED_NAMBIAR received 3 likes!

Lookup using two columns

Hi @MANISHA_V_ARORA after a long testing got this code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_comp_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).…

This post made by @StefanSchnell received 2 likes!

How to Read SAP Tables with a Generic ABAP Approach from UiPath

A longer time ago I published here a solution how to use the remote enabled function module RFC_READ_TABLE with the Invoke Code activity in the SAP back-end. Here now a solution to the same with an ABAP report, which works directly in the context of the UiPath automation workflow. The first question that can be asked here is, why should I go into this trouble when I have a remote enabled function module available? Well, this approach offers a few advantages: The output size is 1024 character…

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Lookup using two columns

Hi @MANISHA_V_ARORA after a long testing got this code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_comp_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).…

This solution provided by @Yoichi received 2 likes!

Calculate all invoice amounts on a particular day/ss

Hi, Can you try the following? [img20210610-5] Sample20210610-3.zip (8.6 KB) Regards,

This solution provided by @ppr received 1 likes!

Need an example to loop Get Queue items activity after reaching 100 and should check all the items in Queue

Sorry for the reduced screenshot: ListQueueItems = new List(Of QueueItem) - Init it before usage ListQueueItems = ListQueueItems.Concat(tmpQueueItems).toList (within correct spell form)

---

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

Top 3 Topics with Most Views

UiPath Best Practices made by @Manikandan_Ckj with 186 views.

InnovSol - UiPath Solution Architects - Across India - India - Full Time made by @Manikandan_Ckj with 52 views.

URの処理実行 made by @Shuichiro_Yamashita with 28 views.

Top 3 Topics with Most Replies

Invoke Code to convert date format MM/dd/yy h:mm tt to yy-MM-dd hh:mm:ss made by @jsilvestre with 20 replies.

Click Activities does not work as expected made by @CrazyTrunk with 14 replies.

Looping through PDF files to create a txt file per pdf with their names made by @Sthefanie_Urquilla with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 27 posts!

@Srini84 made 22 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Manikandan_Ckj received 7 likes!

UiPath Best Practices

1. Organizing your project Use RE Framework to make skeleton of your process Reliable — create solid, robust workflows that can handle errors. Efficient — create a structure that: Helps to short down development time. Helps to reduce errors in production. Maintainable — create a structure that makes it easy to update when needed. Extendable — new requirements should be able to be implemented easily. Choose the right layout The main workflow works best as a Flowchart or a State Machine. Bus…

This post made by @Yoichi received 4 likes!

How to find a number and update the status as 'found' in excel without using loop

Hi, Thank you for sharing. Hope the following helps you. [img20210611-4] Sample20210611-4.zip (16.2 KB) Regards,

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

Don't miss an amazing opportunity to win UiPath DevCon T-Shirt

Don’t miss an amazing opportunity to win UiPath #DevCon T-Shirt. As UiPath MVP I have 3 Coupons to give away! Let’s play a contest to win an exciting gift from UiPath. 𝑫𝒆𝒗𝑪𝒐𝒏 𝑹𝒆𝒈𝒊𝒔𝒕𝒓𝒂𝒕𝒊𝒐𝒏 𝑳𝒊𝒏𝒌: https://bit.ly/3usY1Xd 𝐓𝐚𝐬𝐤: Re-share the LinkedIn post quoting, why would you want your connections to attend the “𝐃𝐨𝐜𝐮𝐦𝐞𝐧𝐭 𝐔𝐧𝐝𝐞𝐫𝐬𝐭𝐚𝐧𝐝𝐢𝐧𝐠” session in UiPath DevCon? 𝐖𝐢𝐧𝐧𝐢𝐧𝐠 𝐜𝐫𝐢𝐭𝐞𝐫𝐢𝐨𝐧: Most 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐟𝐮𝐥 quote of the re-shared post. 𝐂𝐨𝐧𝐝𝐢𝐭𝐢𝐨𝐧𝐬: Your post has to be re-share of the LinkedIn post A…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

How to find a number and update the status as 'found' in excel without using loop

Hi, Thank you for sharing. Hope the following helps you. [img20210611-4] Sample20210611-4.zip (16.2 KB) Regards,

This solution provided by @Srini84 received 1 likes!

Column selection based on data

@MrKezay Is it this you are trying? [image] Hope this may help you Thanks

This solution provided by @postwick received 1 likes!

Click many times

That’s correct, but NbreClick needs to be an Int32, not String. Also, you don’t really need the variable and an assign. Just directly put CInt(row.Item(“Position”)) into the “Repeat number of times” property.

---

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

Top 3 Topics with Most Views

Xebia - UIPATH Developer - Across India - India - Full Time made by @Manikandan_Ckj with 116 views.

SOAP API Post Method Integration in Uipath made by @Manikandan_Ckj with 46 views.

How to sum inside excel and I tried and getting expression expected made by @prasathsunkara with 28 views.

Top 3 Topics with Most Replies

How to sum inside excel and I tried and getting expression expected made by @prasathsunkara with 14 replies.

Regex for uppercase (capital) letters made by @EmirY with 5 replies.

Excel send hot key failure into specific cell made by @Basak_Demirel with 5 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 13 posts!

@prasathsunkara made 9 posts!

@Manikandan_Ckj made 8 posts!

Top 3 Most Liked Posts

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

UiPath Best Practices

Very useful information. Great efforts.

This post made by @Manikandan_Ckj received 1 likes!

SOAP API Post Method Integration in Uipath

Install Uipath.web.activties in Manage packages. Read Text file activity – > .xml file → properties pane – > Output → create a variable (ex name : output file) → pass into → output To → (ex name : output file) Assign activity – > call read text file’s output variable – > replace relevant fields to variables (.replace). Use http request activity. End Point – > API KEY URL?.wsdl Authentication → Simple HTTP (Valid Username and password) Click Ok Properties pane – > Input – > Method – >…

This post made by @Manikandan_Ckj received 1 likes!

Amayztech - UIPATH Developer - India - India - Full Time

Job title: UIPATH Developer Job role: RPA Developer Country: India City: India Company name: Amayztech Employment Type: Full Time Seniority level: Junior 1 to 2 years Job Description: Role : Rpa UIPATH Developer Experience : 2 years Apply here: careers@amayztech.com

Top 3 Most Liked Solutions

This solution provided by @sowndaryacse1505 received 1 likes!

Click Activities does not work as expected

Hey @CrazyTrunk Refer this

---

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

Top 3 Topics with Most Views

Adding data for every month made by @sathish_kumar3 with 30 views.

KTech Products - RPA Multiple titles, FTE, PT, Contractors, India, USA - Dallas - United States - Full Time made by @jchitkara with 27 views.

I wonder why there are no topics on merging multiple excel sheets into 1 here made by @er_bar with 26 views.

Top 3 Topics with Most Replies

Adding data for every month made by @sathish_kumar3 with 9 replies.

How to read row 2-3 only? made by @fairymemay with 7 replies.

Initialize List of Lists made by @vijithhhhh with 6 replies.

Top 3 Users Who Posted The Most

@Srini84 made 19 posts!

@prasath17 made 6 posts!

@fairymemay made 5 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Regex for uppercase (capital) letters

have alook below and unselect Ignore case option

This post made by @Srini84 received 2 likes!

How to read row 2-3 only?

@fairymemay Check as below [image] dt1.AsEnumerable.Take(Number of rows).CopyToDataTable Like as dt1.AsEnumerable.Take(2).CopyToDataTable to get first two rows In assign use the above expression Hope this may help you Thanks So it will take

This post made by @Srini84 received 1 likes!

Split text?

@fairymemay Check below for your reference [image] sampleString.Substring(0,(sampleString.IndexOf("_",sampleString.IndexOf("_")+1))) Above expression will split the text at second occurence of " _" Hope this may help you Thanks

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Regex for uppercase (capital) letters

have alook below and unselect Ignore case option

This solution provided by @Srini84 received 2 likes!

How to read row 2-3 only?

@fairymemay Check as below [image] dt1.AsEnumerable.Take(Number of rows).CopyToDataTable Like as dt1.AsEnumerable.Take(2).CopyToDataTable to get first two rows In assign use the above expression Hope this may help you Thanks So it will take

This solution provided by @Srini84 received 1 likes!

Split text?

@fairymemay Check below for your reference [image] sampleString.Substring(0,(sampleString.IndexOf("_",sampleString.IndexOf("_")+1))) Above expression will split the text at second occurence of " _" Hope this may help you Thanks

---

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

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

[system]

Daily Forum Report | 14 June 2021

Top 3 Topics with Most Views

How to edit linq query? made by @fairymemay with 35 views.

Configファイルについて made by @kojikoji with 31 views.

Lesson 7 - 7.1 Screen Scraping Practice 1 made by @CN26831 with 31 views.

Top 3 Topics with Most Replies

入力ダイアログのラジオボタンでの初期値設定。 made by @r.nakanishi with 21 replies.

Select excel cells copy and paste after url made by @mahmoud_mohamed with 18 replies.

I am caluclating the start_time end_time and total_time but i am unable to calulate the total time due the error please help me made by @praveen_sonkusare with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 43 posts!

@kumar.varun2 made 25 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

How to edit linq query?

Hi, The following will also work, without pre-build datatable, FYI. dt.AsEnumerable.Where(function(r) r("Reason Of AA").ToString()=item).CopyToDataTable().DefaultView.ToTable("NewTable",False,{"Reason Of AA"}) Regards,

This post made by @Jeremy_Tederry received 3 likes!

UIPath Post Request error after making ML Skill public

Ok we have identified the issue on our side and we will fix it. This is due to the fact that for endpoints we are handling only json string and not any string. So we are applying json.loads to your output and of course this fails. We’ll fix that bug but if you need that now you have two workaround: Use the robot connection Modify the ML Package to return a json string. In you python code something like: result = dict() result["Supplier ID"] = <supplier_id_value> result["Confidence"] = <confi…

This post made by @prasath17 received 2 likes!

Split text?

@fairymemay - Another solution… [image] "Suspend_de_20210613_175410.xlsx".Split("2"c)(0).trim("_"c) Assuming you will get 2021 always [image] "Suspend_de_20210613_175410.xlsx".Split({"2021"},StringSplitOptions.None)(0).trim("_"c) to make generalized "Suspend_de_20210613_175410.xlsx".Split({now.year.tostring},StringSplitOptions.None)(0).trim("_"c)

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

How to edit linq query?

Hi, The following will also work, without pre-build datatable, FYI. dt.AsEnumerable.Where(function(r) r("Reason Of AA").ToString()=item).CopyToDataTable().DefaultView.ToTable("NewTable",False,{"Reason Of AA"}) Regards,

This solution provided by @prasath17 received 2 likes!

Capture just the foldername from directory structure

@herman - This query will print only the folder names without the path… Directory.GetDirectories("YourFolderPath").select(Function(x) new fileinfo(x).Name).ToArray() Try and let us know… This is my folder structure [image] And this is output printing without path… [image]

This solution provided by @Yoichi received 2 likes!

Regex to extract 2 first character from different patterns

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"(?<=-)[A-Z]{2}|^[A-Z]{2}",System.Text.RegularExpressions.RegexOptions.RightToLeft).Value 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 | 15 June 2021

Top 3 Topics with Most Views

📢 Announcing UiPath HyperHack - #AutomationForGood Winners! made by @Vibhor.Shrivastava with 371 views.

Uipath Devcon made by @Manikandan_Ckj with 33 views.

Team Lease - Uipath Development and support - Pan India - India - Full Time made by @Manikandan_Ckj with 31 views.

Top 3 Topics with Most Replies

Error : String was not recognized as a valid DateTime made by @Vrushali_Gave with 13 replies.

記入したいRangeの設定方法について made by @Carmen_F with 13 replies.

Dynamic sheet name in excel formula made by @acdeleon123 with 9 replies.

Top 3 Users Who Posted The Most

@postwick made 32 posts!

@Yoichi made 23 posts!

@prasath17 made 11 posts!

Top 3 Most Liked Posts

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

Announcing UiPath HyperHack - #AutomationForGood Winners!

[A4G 3] And here we are, as every great contest reaps glory on its finish line! We embarked on this grand journey with over 350 participants on board for the 2021 UiPath HyperHack – Automation For Good! After kicking off this event in mid-April, with 10 finalists presenting in a live pitching round on June 2nd, now we’ve reached the much-awaited moment of the winners’ announcement! 2 phases and an impressive judging round later, our ‘best for good’ developers have been announce…

This post made by @ppr received 4 likes!

Compare tables based on more than one column using LINQ?

do some preperations for the target structures: Clone dt1 and add the status datacolumn to the dtReportTMPL Clone for dtOut1/2 [grafik] First LINQ: (From d1 In dt1.AsEnumerable Group Join d2 In dt2.AsEnumerable On d1("PLCNO").toString Equals d2("PLCNO").toString And d1("DDNO").toString Equals d2("DDNO").toString And d1("EML").toString Equals d2("EML").toString Into gj = Group From g In gj.DefaultIfEmpty Let status = If(isNothing(g), Nothing, g("STATUS")) Let ra = d1.ItemArray.Append(statu…

This post made by @Manikandan_Ckj received 3 likes!

Reframwork concepts

Uipath Reframework concepts Robotic Enterprise Framework is a project template based on State Machines . It is created to fit all of the best practices regarding logging, exception handling, application initialization, and others, being ready to tackle a complex business scenario. Total 4 States, Initialization Get transaction Process Transaction End Process What is Initialization? Initialization all project relevant details in config file. (Ex: Asset, Folder path, excel sheet name, queue …

Top 3 Most Liked Solutions

This solution provided by @ppr received 4 likes!

Compare tables based on more than one column using LINQ?

do some preperations for the target structures: Clone dt1 and add the status datacolumn to the dtReportTMPL Clone for dtOut1/2 [grafik] First LINQ: (From d1 In dt1.AsEnumerable Group Join d2 In dt2.AsEnumerable On d1("PLCNO").toString Equals d2("PLCNO").toString And d1("DDNO").toString Equals d2("DDNO").toString And d1("EML").toString Equals d2("EML").toString Into gj = Group From g In gj.DefaultIfEmpty Let status = If(isNothing(g), Nothing, g("STATUS")) Let ra = d1.ItemArray.Append(statu…

This solution provided by @prasath_S received 2 likes!

Read row until row blank

Hi @fairymemay Please try this dtTable.AsEnumerable.TakeWhile(Function(row) row.ItemArray.Any(function(col) not string.IsNullOrEmpty(col.ToString))).CopyToDataTable [image] [image] Thanks

This solution provided by @balupad14 received 1 likes!

How can i delete sheet in Excel

Thank you @Soudios. I think the problem solved now…

---

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

Top 3 Topics with Most Views

Read 2 GB text file and convert to DT made by @shrayud with 77 views.

データに対応したWeb上の任意の場所をクリックしたい made by @hiroshi2 with 46 views.

Expertsville@ UiPath DevCon 2021 made by @DeaTo with 39 views.

Top 3 Topics with Most Replies

要素の消滅を待つ の使い方 made by @miwa_yamamoto with 13 replies.

Delete rows below one specified one in a datatable made by @abdel with 12 replies.

Error in Convert String into int32/Double/Int64 made by @skg_161125 with 11 replies.

Top 3 Users Who Posted The Most

@postwick made 23 posts!

@ppr made 18 posts!

@Pranav_KomandurPK made 11 posts!

Top 3 Most Liked Posts

This post made by @CN26831 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone. My name is Cory and I am new to UiPath and the Forum. I teach a graduate class in accounting and I incorporated RPA for the first time. I have received assistance on three workflows already. So thankful to UiPath Forum Community for sharing their expertise!

This post made by @Geoff received 2 likes!

The new Customer Portal is rolling out!

We’re happy to announce that the UiPath Customer Portal has started onboarding for UiPath Enterprise customers! Customer Portal is a self-service portal for organizations to access UiPath products and platform-related information, and interact with UiPath teams. It’s designed to give UiPath customers all the required support via a single, modern experience, to help accelerate their automation journey. [CP-dashboard] Onboarding will be invitation-based and is split into 3 waves over the next …

This post made by @HANACCHI received 2 likes!

セレクターのハイライトがずれる

IEとCHROMEでそういった違いがあった事がありました。 CHROMEではチャンと取れる、細かいUI要素が表現できる。この状況で、後輩にロボ作ってみ！と指示だしたらどうもうまくいかない。後輩はIEで実装していました。 IEだと、細かいUI要素が取れない、ズレる。。。 今後を見据えて、CHROMEで開発してねってお願いしました。 もしかしたら、ブラウザのバージョンアップでもこのような事が起きるかもしれません。

Top 3 Most Liked Solutions

This solution provided by @Vijay_Kumar_C received 2 likes!

Adding Color to Headers

Hi @Pranav_KomandurPK, We have Set Range Color in Excel Application Scope Activity. Use Excel Application Scope activity and provide file path. Drag Set Range Color activity and provide below parameters. Color = System.Drawing.Color.Blue Range = "A1:F1" SheetName = "March 2021_temp" Please find below attached image for more information. Regards, Vijay. [HeaderColor]

This solution provided by @uiuiki received 1 likes!

データスクレイピングしたデータのエクセル反映

おはようございます。 エラー解消いたしました！適切なアドバイスをありがとうございます。

This solution provided by @ppr received 1 likes!

Regex multilne

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

Top 3 Topics with Most Views

Web Selectors for click button made by @pari_patel with 50 views.

Using Image Variable made by @Sahil_J_Patel with 47 views.

Excel data processing question made by @MF.RPA with 45 views.

Top 3 Topics with Most Replies

Move File from one folder to another in uipath studio activities made by @pari_patel with 17 replies.

Creata a datatable from a text file made by @skg_161125 with 14 replies.

Regex (Last Line txt) made by @Julian_Yamid_Torres_Torre with 11 replies.

Top 3 Users Who Posted The Most

@postwick made 36 posts!

@Srini84 made 15 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @My_Channel received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I’m just starting on my UiPath journey and so far I’m enjoying it. My goal is to become a StudioX expert and be able to teach others.

This post made by @jeevith received 2 likes!

The new Customer Portal is rolling out!

Hello @Geoff, This feature will be a great time saver for all enterprise users. One important feature in such a portal is to have access to the stable LTS versions of platform installer / robot / studio pro (.msi) installers may be also the latest preview versions as well. At the minimum, the organizational admin of the portal should have access to all relevant installers depending on the licenses purchased. We have wasted a lot of time trying to find the correct installer files and had to u…

This post made by @sa.tk received 2 likes!

PDFの印刷について

N2027さん＞ お教えいただきました、「Ctrl＋Shift＋P」ですが、「Ctrl＋P」同様うまく反応いたしませんでした。 最終的に、右クリックでメニューを表示させ、印刷（P）ボタンをクリックさせることで問題解消いたしました。 この度は、ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @postwick received 1 likes!

Web Selectors for click button

Is the applicationId always 300 in the Iframe URL? First thing I would try is to replace all the spaces in aaname with *. So… <webctrl aaname='*Retrieve*' tag='A' />

This solution provided by @prasath17 received 1 likes!

How to loop zip folder

@fairymemay - Please check this… [image] For Each Argument type is string. Note: Replace MoveFiles with your FolderName My Output [image] Hope this helps…

This solution provided by @Srini84 received 1 likes!

Orchestrator database info (Queue Items)

@Felipe_Kotinda It can be possible, but you need to understand which tables are updated As it is related to their SQL schema, and I believe UiPath will not give those details Hope this may help you Thanks

---

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

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