Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 May 2021

Top 3 Topics with Most Views

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 35 views.

Filter table by 2 Columns made by @markosc with 35 views.

Retrieving Conversation ID from mail box made by @rakshitha.shetty with 34 views.

Top 3 Topics with Most Replies

Publish error: Regex.Match non declared made by @Danny_Gi with 18 replies.

Move PDFs based on Name in specific Folders made by @Yudhisteer_Chintaram1 with 17 replies.

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 12 replies.

Top 3 Users Who Posted The Most

@Yudhisteer_Chintaram1 made 19 posts!

@josephatomwanzia made 17 posts!

@Adrian_Star made 16 posts!

Top 3 Most Liked Posts

This post made by @AndersJensen received 3 likes!

Filter data By Strikethrough In Excel?

Hey @Aaron_Ko For sure. I’ve created a simple VBA script for you, which does the job (checks if there is a Strikethrough). If yes, write “1” in the next column. We invoke it with an “Invoke VBA” activity inside an “Excel Application Scope” activity. Everything is attached. The simple Excel dataset (attached as Book1.xlsx) [image] The VBA code to invoke (attached as StrikeThrough.txt) Sub StrikeThrough() For n = 1 To Rows.Count If Range("A" + CStr(n)).Font.StrikeThrough Then Range("B…

This post made by @Steven_McKeering received 3 likes!

Regex for date

Hi A full list of your expected date formats is needed to build a robust Regex pattern. In the meantime, try this pattern:

This post made by @ppr received 2 likes!

Manually creating a TransactionItem/QueueItem w/o an Orchestrator queue

the prepared Dictionary has to be assigned on YourTransactionItemVar.SpecificContent Property

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Linq Query, Please Help!

@kantheshm give a try on following prepare an empty datatable with build datatable reflecting the target datacolumn strucutre: Col1 – Col2 - Col3 Variable: dtResult then use an assign activity left side: dtResult right side: (From d in dtData.AsEnumerable Group d by k1=d(“Col3”).toString.Trim,k2=d(“Col4”).toString.Trim into grp=Group Let s = grp.Sum(Function (x) CInt(x(“Col2”).toString.Trim)) Ler ra = new Object(){k1,s,k2} Select dtResult.Rows.Add(ra)).CopyToDataTable Also have a loo…

This solution provided by @AndersJensen received 1 likes!

Difficulty with modern folders

Hey @tainan.ramos Creating unattended robots in the new Modern Folder Orchestrator environment was the question I got the single-most. I’ve created this “get started” guide Feedback is very welcome. [🤖 Unattended Robots in Uipath Orchestrator (Full Tutorial)]

This solution provided by @Hiba_B received 1 likes!

Write full Date Format in Excel column

Hi @Yudhisteer_Chintaram1 ! Here is a suggestion: Date_conversion.xaml (9.7 KB) Beware, there is a strange date format at the end. I took care of it in the code through Try Catch but I wanted to let you know if it’s a forbidden/forgotten date format: [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 | 06 May 2021

Top 3 Topics with Most Views

Document Understanding - Data Manager Public Preview in Automation Cloud made by @alexcabuz with 56 views.

【UiPathアカデミー】新規コースリリース＆【UiPath 認定資格】日本語版バウチャーストアリリース made by @Taeko_UiPath with 52 views.

Help in HTML pls made by @evan.joy.celino with 38 views.

Top 3 Topics with Most Replies

Help in HTML pls made by @evan.joy.celino with 26 replies.

How to Append file excel 2 sheet? made by @fairymemay with 25 replies.

Data type for combination of text and numbers made by @evan.joy.celino with 17 replies.

Top 3 Users Who Posted The Most

@Yoichi made 26 posts!

@prasath17 made 19 posts!

@evan.joy.celino made 18 posts!

Top 3 Most Liked Posts

This post made by @Taeko_UiPath received 5 likes!

【UiPathアカデミー】新規コースリリース＆【UiPath 認定資格】日本語版バウチャーストアリリース

平素より、UiPathアカデミーをご愛顧いただき誠にありがとうございます この度新たに2つのコースをリリースいたしました UI操作を伴わない処理の自動化 コース 個人用ワークスペースの活用 コース UiPath 製品に関する知識の拡充にお役に立てればと思います ぜひご活用くださいませ また、UiPath認定資格 日本語版受験チケット用バウチャーストアがリリースされました 受験チケットをまとめてご購入が可能となるため、 複数人や団体でのご受験の計画・管理する際にお役立ていただけます ※試験言語（日本語または英語）により購入ページが異なります 英語版にて受験をご希望される方は、こちらよりご購入いただけます 引き続きUiPath をよろしくお願いいたします

This post made by @alexcabuz received 5 likes!

Document Understanding - Data Manager Public Preview in Automation Cloud

We are happy to announce the public preview release of the Document Understanding Data Manager version for Automation Cloud! Data Manager is the key tool used to build datasets for training Document Understanding ML Models in AI Center, but it was only publicly available on premises until now. Starting today, we have brought the convenience and ease of use of Automation Cloud to Data Manager. If you have AI Center in the Cloud, then you have Data Manager! The vers…

This post made by @Eric_Wong_Test received 2 likes!

Selector issue with Outlook

Esign*

Top 3 Most Liked Solutions

This solution provided by @Eric_Wong_Test received 2 likes!

Selector issue with Outlook

Esign*

This solution provided by @ppr received 2 likes!

ForEach Segment RowSets

we assume that you are meaning: 19 - Rows Count, 250 Segment Size it is working withour error: [grafik] Maybe you can share some more details on your implementation. Especially on the part where the Random is used. Thanks

This solution provided by @tlano received 1 likes!

Box Integration Activities - Now in Public Preview!

Thanks! Very helpful

---

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

Top 3 Topics with Most Views

指定文字数未満の行を削除したい made by @miwa_yamamoto with 37 views.

How to add watermark to word automatically to word file using uipath made by @Gowtham_Srinivasan with 31 views.

How To Select a TAB in Forms Based on Certain Condition? made by @hsendel with 30 views.

Top 3 Topics with Most Replies

How To Select a TAB in Forms Based on Certain Condition? made by @hsendel with 12 replies.

Using Regex With Different Text Format made by @Sahil_J_Patel with 11 replies.

Data scaping only in 1 page made by @Tharusha_Fernando with 10 replies.

Top 3 Users Who Posted The Most

@prasath17 made 17 posts!

@Yoichi made 17 posts!

@Hiba_B made 14 posts!

Top 3 Most Liked Posts

This post made by @Zrinko_Zalik received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello. Thank you for the warm welcome. I’m sort of new in UiPath, I had some experience in it about a year and a half ago but starting this monday I’m a full time RPA DevOp so going trough the academy and finding solutions here on the forum helps a lot. I hope that I will contribute to the community.

This post made by @prasath17 received 2 likes!

Match file name and move

Hi @Beatriz_Eugenia_Duqu - Below one line copy all the .pdf and .xml files to the destination [image] array.ForEach(Directory.GetFiles("DeleteFiles\", “*”, SearchOption.AllDirectories).Where(Function(s) s.EndsWith(".pdf") Or s.EndsWith(".xml")).ToArray,Sub(x) File.Copy(x,"MoveFiles\"+ Path.GetFileName(x))) Above code copy the files from DeleteFiles folder to MoveFiles folder…

This post made by @Yoichi received 2 likes!

Can't get value when using Matches activities

Hi, Can you try the following sample? Sample20210507-2.zip (2.9 KB) The pattern will be (?<name>.*)\r?\n\r?\n(?<Role>.*)\r?\n\r?\nDOB:\s+(?<DOB>\d{2}-\w{3}-\d{4})\r?\n\r?\nEmail:\s+(?<Email>.*)\r?\n\r?\nMattermost:\s+(?<Mattermost>.*)\r?\n\r?\nSkype:\s+(?<Skype>.*) Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Can't get value when using Matches activities

Hi, Can you try the following sample? Sample20210507-2.zip (2.9 KB) The pattern will be (?<name>.*)\r?\n\r?\n(?<Role>.*)\r?\n\r?\nDOB:\s+(?<DOB>\d{2}-\w{3}-\d{4})\r?\n\r?\nEmail:\s+(?<Email>.*)\r?\n\r?\nMattermost:\s+(?<Mattermost>.*)\r?\n\r?\nSkype:\s+(?<Skype>.*) Regards,

This solution provided by @JayakumarSanthanam received 2 likes!

Data scaping only in 1 page

There is chance that there’s difference in page 2 element layouts. Try making another scraping selector for page 2 onwards and test if it works going forward. If this works, you need to first identify page 2 before proceeding to the specific scraping Thanks

This solution provided by @jvanmarion received 1 likes!

How we can schedule the task by using Orchestrator

You can use triggers for that. Take a look here.

---

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

Top 3 Topics with Most Views

Copy data from one excel sheet to Another made by @abhide with 27 views.

Scraping linkedin post from a certain profile made by @Basak_Demirel with 26 views.

How can I extract an embedded PDF from an XML file? made by @Reginald with 26 views.

Top 3 Topics with Most Replies

How to convert feedback input into equivalent grade (number) made by @raymond_barlis with 6 replies.

Copy data from one excel sheet to Another made by @abhide with 5 replies.

How can I extract an embedded PDF from an XML file? made by @Reginald with 5 replies.

Top 3 Users Who Posted The Most

@wasea made 18 posts!

@Mikolaj_Zielinski made 5 posts!

@sunny_singh made 5 posts!

Top 3 Most Liked Posts

This post made by @kchang received 1 likes!

Problem with unattended robot and browser

On the UIPath forum I’ve seen a post regarding using tscon to disconnect from an RDP session but leave the GUI active. UiRobot run in Remote desktop I’ve see a similar post here for different use case Disconnecting From Remote Desktop While Running Automated Tests | TestComplete Documentation What I tried was from cmd as administrator, I ran “query session” to get my Session Name. Then ran " %windir%\System32\tscon.exe RDP-Tcp# NNN /dest:console" substituting my Session Name for “RDP-Tcp#NNN”…

This post made by @Gayathri_Ramanathan received 1 likes!
https://forum.uipath.com/t/312905/4

This post made by @StefanSchnell received 1 likes!

How to use Java Selenium in Combination with UiPath

Based on my approach about the using of JShell (Java REPL) here, an integration scenario of Java source code into UiPath, now an use case to integrate Java Selenium regression automation tests. Selenium is a portable framework for testing web applications. In business exists many sources which uses Selenium client and web driver language bindings in Java language. With this approach the existing automations can be used furthermore. Preparation Besides the OpenJDK I built two other packages. T…

Top 3 Most Liked Solutions

This solution provided by @Shraddha_Gore received 1 likes!

Copy data from one excel sheet to Another

Hi, use Merge Data Activity to get expected output. Your final Data Table will have following columns : ID, Import, Export, WW10, WW11, WW12, WW13, WW14, WW15, Unnamed Column. Remove Unnamed Column. Then write this final Data Table to excel sheet.

---

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

Top 3 Topics with Most Views

How to use for each row when the variable is at the column instead of row made by @cxx with 34 views.

Try Catch: Catch portion not working made by @anonymous3 with 30 views.

【Googleマップ】到着時間の設定について made by @owlhr with 29 views.

Top 3 Topics with Most Replies

Can i make look up with separator and return value by same sequance made by @rpa13 with 18 replies.

DefaultView.ToTable(true, がうまく使えない made by @miwa_yamamoto with 11 replies.

Can I send Outlook e-mail based on excel data condition? made by @Dorothy_lee with 9 replies.

Top 3 Users Who Posted The Most

@prasath_S made 12 posts!

@rpa13 made 8 posts!

@Dorothy_lee made 5 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 3 likes!

Can I send Outlook e-mail based on excel data condition?

@Dorothy_lee - Another option would be filter the data first (this will avoid the if condition) and then read filtered data in the foreach loop for sending the email… DtFiltered = (From r In Dtout.AsEnumerable Where r("Feedback").toString.Contains("FALSE") Select r).CopyToDataTable Here dtfilterted is of variable Datatable. For Dynamic body, Please try like this…(Copy paste the right hand side value to your body) [image] Make sure to check - isBodyHtml Checkbox in the property… Hope this …

This post made by @prasath_S received 2 likes!

Write to text file with a complex given format

Hi @Tharusha_Fernando Please try these steps, Write the text to text file using write text fil activity. Varname + environment.newline + varAc + environment.newline + varAge + environment.newline +varIncome +environment.newline + environment.newline + varSply+ environment.newline + varsplyarea + environment.newline + varTrl After this use start process activity and open the text file that’s just created. Using clicks or hotkeys to enter the format in the note pad file , save the file a…

This post made by @prasath_S received 2 likes!

How to dynamically read an specific cell from a large number of data

Hi @Shraddha_Gore I think it should be first row and then column , Balance = YourDT(YourDT.Rows.Count - 1)(“Balance”)

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

How to dynamically read an specific cell from a large number of data

Hi @Shraddha_Gore I think it should be first row and then column , Balance = YourDT(YourDT.Rows.Count - 1)(“Balance”)

This solution provided by @prasath_S received 1 likes!

How to delete specific column?

@Dorothy_lee lets assume your datatable is dtTable1, please try this {dtTable1.Columns(2).ColumnName.ToString,dtTable1.Columns(3).ColumnName.ToString,dtTable1.Columns(4).ColumnName.ToString,dtTable1.Columns(5).ColumnName.ToString} give this in the column names

This solution provided by @Rajesh.Attada01 received 1 likes!

Unable to Convert the Date format to Required Date format

Took Substring of 11 characters Jan 2 2020 Wrote if statement to find if 5 character is a whitespace if yes → following MMM d yyyy format if no → following MMM dd yyyy format This worked. Happy Face

---

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

Top 3 Topics with Most Views

Orchestrator Community - Scheduled Maintenance Downtime made by @Bianca_Duminica with 247 views.

Copy data from html and focus paste into new excel made by @CoolRobot with 32 views.

ファイル内の更新日時取得について made by @nara1 with 31 views.

Top 3 Topics with Most Replies

Substring: How to remove last two element from a string? made by @Tanzill_Ahsan with 23 replies.

How to extract particular string from text? made by @sambulkar with 22 replies.

Ready PDF and get only the specific value between double quotes made by @Gowtham_Srinivasan with 19 replies.

Top 3 Users Who Posted The Most

@prasath17 made 36 posts!

@postwick made 16 posts!

@NIVED_NAMBIAR made 14 posts!

Top 3 Most Liked Posts

This post made by @Bianca_Duminica received 9 likes!

Orchestrator Community - Scheduled Maintenance Downtime

We will be performing infrastructure changes for Orchestrator running on our Automation Cloud - Community instance. Scheduled downtime window for 1 hour: May 13, 19:00 - 20:00 UTC During this maintenance window: some Orchestrator tenants will become unavailable; connected robots will appear as disconnected; the API will return an error code; schedules will not be executed; the user interface will be replaced by a static web page. We’ll keep this topic updated with progress…

This post made by @Priyanka_Bhalere received 2 likes!

Our new look for Orchestrator is here!

Explored the Apollo Design System and its really cool. Specially quick actions and Tenant header color. And can’t stop myself from making a video on it😁 Have a look UiPath Orchestrator Update 2021.5 || Apollo Design System || New Look -Priyanka

This post made by @Geoff received 2 likes!

Release: Automation Cloud Migration Tool

We’re excited to announce that the UiPath Automation Cloud Migration Tool is now live! This freely downloadable tool makes it much easier to move an Orchestrator tenant (or tenants) to Automation Cloud for enterprise from an on-premises installation – it does most of the work for you. [image] If you are considering a migration from on-prem to Automation Cloud for enterprise, this should further reduce the time and effort required. It’s also a great way to start prototyping or evaluating Autom…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

ファイル内の更新日時取得について

こんにちは 繰り返しの中で System.IO.File.GetLastWriteTime(item.ToString) で取得できると思います。DateTime型で返るので、適切な型・フォーマットに変換すると良いかと思います。

This solution provided by @ppr received 2 likes!

Dynamically Adding Columns to DataTable Using LINQ

@ashwin.ashok we can interpretate the case as a certain kind of transponation. Lets assume following sample input: [grafik] we prepare the target Datacolumn structre by a build datatable for the name column and do add the ordered country columns [grafik] with one go we also do create an array with the country names - newColNames Finaly we following LINQ dtData will be transposed accordingly the case requirement (flag with *) [grafik] Result: [grafik] Find starter help here: Transpo…

This solution provided by @prasath_S received 1 likes!

Can i make look up with array

if you mark it as solution, than after 3 days with no replies it will automatically get closed…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 | 11 May 2021

Top 3 Topics with Most Views

Get Latest Date with Max function from list (of Match) made by @Sakshi_Jain with 29 views.

How do you deploy the code from one machine to another without studio? made by @aparna3010 with 28 views.

RPA Developer - BANGALORE - India - Full Time - UiPath made by @Vibhor.Shrivastava with 27 views.

Top 3 Topics with Most Replies

Text Error on Excel after write operation made by @Tanzill_Ahsan with 14 replies.

Checking if Column Name exists C# made by @lmoham with 13 replies.

Get Latest Date with Max function from list (of Match) made by @Sakshi_Jain with 13 replies.

Top 3 Users Who Posted The Most

@prasath17 made 37 posts!

@NIVED_NAMBIAR made 30 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @judylee received 4 likes!

Hear first-hand from our CEO Daniel Dines at UiPath Live: The 21.4 Release Show

Hi UiPath Community! After listening to community feedback and evaluating your biggest needs, we’re excited to announce the launch of UiPath 21.4. Discover the latest and greatest features of this release in our upcoming UiPath Live: The 21.4 Release Show on: OPTION 1: 2021-05-20T15:00:00Z (UTC) OPTION 2: 2021-05-21T03:30:00Z (UTC) Watch live as UiPath CPO Param Kahlon introduces new products like Automation Ops and UiPath CEO Daniel Dines shares his view of …

This post made by @rlove received 4 likes!

How to gain deep understanding of automation concepts?

I would recommend attending Devcon to hear from peers in the space. RPA Developer Conference - DevCon 2021 | UiPath. You might also consider participating in the HyperHack (See HyperHack - Automation for Good at UiPath Hackathons) to work on an advanced use case with a group.

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

RPA Developer - BANGALORE - India - Full Time - UiPath

Job title: RPA Developer Job role: RPA Developer Country: India City: BANGALORE Company name: UiPath Employment Type: Full Time Seniority level: Associate, 3 to 5 years Job Description: :pushpin:This is what you’ll do at UiPath:- As a RPA developer you will provide solution design’s to customers throughout the deployment and involve in testing and delivering technical training to the clients. Provide solution design’s to customers throughout the deployment of new deals, during POCs and…

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

How to fetch the regex output and write into excel file

Hi @chaithanya_kumar_M Please try this Build datatable output is dtTable1 Matches output is matchColl [image] [image] in add data row activity give Arrayrow as {item.ToString} and Datatable as dtTable1 and in write range give datatable as dtTable1 [image] Thanks

This solution provided by @MikkelNielsen received 2 likes!

UiPath still can't handle emails properly in REF?

UPDATE - THIS WORKS NOW - SEE BELOW Lets talk this through then. This is how we use the REF: I have the Init phase, in which I will extract all the relevant information from each mail, and add this data to the Queue. So this is where I have my For Each, enumerating all the e-mails. Then I got the Process phase that processes each transaction from the Queue. At the end of my Process, I ultimately need to move the mail in question to another outlook/exchange folder. In case the processing of …

This solution provided by @Yoichi received 1 likes!

How to remove a duplicates values from the array and list

Hi, Sorry. I might have misunderstanding. If your expected result is {“value1”,“value2”,“value4”} ,the following Union method works. arrString.Union(arrString).ToArray The above expression : arrString.Where(Function(x) arrString.Count(function(y) y=x)=1).ToArray returns {“value2”,“value4”} 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 | 12 May 2021

Top 3 Topics with Most Views

How to remove leading zeros from data table column made by @roysupriya21 with 37 views.

Get queue items pushed in last 1 Hour made by @Sahil_Garg1 with 35 views.

ワークフローを終了と強制終了の違い made by @196006 with 34 views.

Top 3 Topics with Most Replies

Read Range : Couldnt read range [Excel] made by @AS07 with 14 replies.

Open browser activity not working made by @ad2000 with 14 replies.

How to remove leading zeros from data table column made by @roysupriya21 with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 14 posts!

@postwick made 10 posts!

@NIVED_NAMBIAR made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Formating a variable

@Jose_Pedro_Mendes Welcome to the forum PadLeft will help us: [grafik]

This post made by @postwick received 2 likes!

Get queue items pushed in last 1 Hour

Get all the Queue Items and then when processing, check if it was created in the last hour. If not, skip it.

This post made by @ppr received 2 likes!

Linq query to filter using between operator in Datatable

give a try on: [grafik] [grafik] (From x In {"02"} Let dl = dtData.AsEnumerable.toList Let fi = dl.FindIndex(Function (d) d(0).toString.Equals(x)) Let li = dl.FindLastIndex(Function (d) d(0).toString.Equals(x)) From r In dtData.AsEnumerable.Skip(fi).Take(li-fi + 1) Select r).toList then branch: drResult.CopyToDataTable

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Extract the last word using regex

Hi, Can you try the following pattern? \S+$ Regards,

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to remove leading zeros from data table column

Hi @roysupriya21 for this we had to do some modifications in same code as i told above Modified code dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Depost”)= If(row(“Depost”).ToString.Length<=6,CInt(row(“Depost”).ToString),row(“Depost”))) Try this and let me know if it works Regards, Nived N Happy Automation

This solution provided by @prasath_S received 1 likes!

How to copy selected rows from one excel to another empty excel file

@WASEEM_KHAN if you can mark this as solution, for others it will be helpful. [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 | 13 May 2021

Top 3 Topics with Most Views

データテーブルで横に並んだ情報を縦に整理する made by @kaori.horiuchi with 33 views.

Linq Query on Group By and Sum made by @tmond with 32 views.

Remove &ZeroWidthSpace Unicode character from a string made by @phaniraj.raichooti with 30 views.

Top 3 Topics with Most Replies

Get Index of First Empty Row made by @tilarapiyush with 18 replies.

Cannot Automate a desktop application made by @Penganimation with 11 replies.

Need help with dynamic process made by @ShengChao_Soh with 11 replies.

Top 3 Users Who Posted The Most

@Pankaj.Patil made 9 posts!

@ashwini.magar92 made 8 posts!

@ppr made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to remove datatable1 form datatable2 (datatable2 contains datatable1)

give a try on Assign activity: left side: drResult | Datatype: List(of DataRows) right side: datatable2.Except(datatable1, DataRowComparer.Default).toList If activity: Condition: drResult.Count > 0 then: dtFiltered = drResult.CopyToDataTable else: dtFiltered = datatable2.CopyToDataTable dtFiltered is of datatype: DataTable

This post made by @ppr received 2 likes!

Linq Query on Group By and Sum

@tmond Welcome to the forum We can do it with folloing flow: [grafik] (From d In dtData.AsEnumerable Group d By k=d("Col3").toString.Trim Into grp=Group Let gs = grp.Sum(Function (x) CInt(x("Col2").toString)) Let raa = grp.Select(Function (g,i) If(i=0,g.ItemArray.Append(gs).toArray,g.ItemArray.Append(Nothing).toArray)).toarray From m In raa Select dtResult.Rows.Add(m)).CopyToDataTable And will get: [grafik] Find starter help here: GroupBy_1Col_AddSumToFirstMember.xaml (9.0 KB) Also have…

This post made by @mdiaz2307 received 1 likes!

Generic Value not availalble

Cheers mate.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Linq Query on Group By and Sum

@tmond Welcome to the forum We can do it with folloing flow: [grafik] (From d In dtData.AsEnumerable Group d By k=d("Col3").toString.Trim Into grp=Group Let gs = grp.Sum(Function (x) CInt(x("Col2").toString)) Let raa = grp.Select(Function (g,i) If(i=0,g.ItemArray.Append(gs).toArray,g.ItemArray.Append(Nothing).toArray)).toarray From m In raa Select dtResult.Rows.Add(m)).CopyToDataTable And will get: [grafik] Find starter help here: GroupBy_1Col_AddSumToFirstMember.xaml (9.0 KB) Also have…

This solution provided by @StefanSchnell received 1 likes!

SAP Read ICDataFlowCtrl (interactive flowchart)

@jack.chan Hello Jack, this control is embedded in an SAP docking control and it is not supported by the SAP GUI Scripting. Best regards Stefan

This solution provided by @prasath17 received 1 likes!

Write range, append function not working

@Dennon_Seet - I was able to achieve it using the counter … [image] Workflow file: WriteRange_Append.zip (159.4 KB) Note: Save for Later activity is available in the version starting 20.10.6 i guess… Hope this helps…

---

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

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

[system]

Daily Forum Report | 14 May 2021

Top 3 Topics with Most Views

📢 Announcing Use Cases Repository on our Forum made by @Vibhor.Shrivastava with 164 views.

Amazon - Automation Program Manager - Hyderabad - India - Full Time made by @dhyani_bhangre with 66 views.

Xebia - Depends on Work Exp - Delhi - India - Full Time made by @Shubham_Varshney with 37 views.

Top 3 Topics with Most Replies

In between time data filter made by @Harish_pavuluri with 23 replies.

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails made by @sreekanta_yogesh_krishna with 9 replies.

Can any one please help with this..its bit urgent made by @Seema_S with 8 replies.

Top 3 Users Who Posted The Most

@prasath_S made 9 posts!

@Yoichi made 9 posts!

@prasath17 made 8 posts!

Top 3 Most Liked Posts

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

Announcing Use Cases Repository on our Forum

[UiPath-LinkedIn-14May21.usecase] Happy to announce we now have the Use Cases Repository. This will enable you to learn from others and share Use Cases specific to Domains, Products & Skills wise. Well-written use case works as an invaluable guidebook to gain learning experience. Community members, be it a student, a citizen developer, an advanced user, or a beginner in the RPA field - are always looking for a guide that can help them gain RPA experience for their ca…

This post made by @mukeshkala received 2 likes!

We need YOU ...Influence Our Next Big Thing

Registered , Looking Forward for the connect

This post made by @StefanSchnell received 2 likes!

Tip: How to Find the Correct SAP Table

The RFM Code Generator offers the possibility to create code to read data from SAP transparent tables or views, via the SAP standard RFM RFC_READ_TABLE. But when data is to be loaded from an SAP system, the question very often arises in which tables can be found in. A very good approach is to start the transaction code (TAC) and to take a look at the selection screen. In our example the TAC VA03, Display Sales Order. [image] Select the field of interest, in our example Order, and press key F1.…

Top 3 Most Liked Solutions

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

Changing and merging the names of more than one attachment from the email

Yes, you will get… // Create empty datatable that store all files data each time loop executes. Dim datatableFinal as Datatable = New Datatable() strFileArray = Directory.GetFiles(“your_Files_Path”, “*.excel”) — please explore more on google. for each file in strFileArray { // Perform above steps given. // Provide datatableFinal to output property of Merge datatable activity. }

This solution provided by @shinji received 1 likes!

メッセージボックスのボタン選択で処理を分岐させる

条件欄に IF( 選択 = "Yes", True, False) または 選択 = "Yes" と書けば出来ると思います。 IFで書くのは「三項演算子」と言って、IF分岐を1行で記述する方法ですが、色々応用が出来ます。 例） メッセージをログアクティビティでメッセージに IF( 実行フラグ, “実行するよ”, “実行しないよ”) と指定する

This solution provided by @Eric_Wong_Test received 1 likes!

It is possible to set default value via parameter in Uipath Form Activities?

If you want have default value in text field, make sure the value name is same with field key [Screenshot 2021-05-14 165255] [Screenshot 2021-05-14 165314] [Screenshot 2021-05-14 165344]

---

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

Top 3 Topics with Most Views

Extract table from raw text made by @rameezimtiaz with 30 views.

UiPath Robot Error: Cannot Create Unknown Type made by @ShengChao_Soh with 24 views.

Multiple lookups made by @abhide with 24 views.

Top 3 Topics with Most Replies

Multiple lookups made by @abhide with 22 replies.

Error: “Assign: Object reference not set to an instance of an object” while running Client Security Hash main.xaml file made by @Svitlana with 19 replies.

Extract table from raw text made by @rameezimtiaz with 16 replies.

Top 3 Users Who Posted The Most

@copy_writes made 29 posts!

@wasea made 22 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

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

UiPath - RPA Pre-sales Engineer - BANGALORE - India - Full Time

Job title: RPA Pre-sales Engineer Job role: Other Role Country: India City: BANGALORE Company name: UiPath Employment Type: Full Time Seniority level: Junior, 1 to 2 years Job Description: This is what you will be doing at UiPath: Build and deliver custom made industry specific demos for new prospects and clients. Create powerful POC’s (Proof Of Concepts) for prospects and customers. Be an evangelist of UiPath automation tools by identifying customer needs and showcasing the best solut…

This post made by @copy_writes received 2 likes!

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails

Ok buddy Hear is the solution [image] [image] SendMiailToStudents.zip (15.2 KB) If you get the solution mark as the solution and close the topic if have any drought in this above topic ping me I will help you Note: Student ID should be unique and in both Excel file ID of the Student Should be same example Student Chethan ID is 1 In DT1 and in The DT2 Also Same ID for Chethan I Use Message Box you replace and use mail activity regards Chethan P

This post made by @sreekanta_yogesh_krishna received 1 likes!

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails

thank you very much for your kind and detailed reply yeah please share the sample XML file, Thank you once again.

Top 3 Most Liked Solutions

This solution provided by @copy_writes received 2 likes!

PLEASE HELP me for project completion tags: Excel files, sending Dynamic mails

Ok buddy Hear is the solution [image] [image] SendMiailToStudents.zip (15.2 KB) If you get the solution mark as the solution and close the topic if have any drought in this above topic ping me I will help you Note: Student ID should be unique and in both Excel file ID of the Student Should be same example Student Chethan ID is 1 In DT1 and in The DT2 Also Same ID for Chethan I Use Message Box you replace and use mail activity regards Chethan P

This solution provided by @prasath17 received 1 likes!

DateDiff always returns 0

@Alex_Tee - Can you please as below DateDiff(dateinterval.Day,Convert.todatetime(Start_Date),Convert.todatetime(End_Date)) Sample Input and 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 | 16 May 2021

Top 3 Topics with Most Views

Move the file to respective folder using excel reference made by @vijayabhaskar1987 with 36 views.

How to sum values in different excel sheets made by @chickennuggets with 35 views.

Question for excel made by @anon with 29 views.

Top 3 Topics with Most Replies

Move the file to respective folder using excel reference made by @vijayabhaskar1987 with 21 replies.

Please help with reading specific range without sheet number made by @jing_jing with 8 replies.

Chrome Tab Unique Identifier/Scraping - Uipath Scrapes the 1st tab instead of the 2nd made by @Daniel-F with 8 replies.

Top 3 Users Who Posted The Most

@copy_writes made 34 posts!

@prasath17 made 10 posts!

@259_Utkarsh_Tripathi made 9 posts!

Top 3 Most Liked Posts

This post made by @copy_writes received 2 likes!

How to keep open excel file until entire project execute

Simple Use excel scope application inside that you automate [image] if you need to open the application you have use open application activity. excel application scope is read the excel file and if excel file is open it wont through error i Hope you get the solution and please mark it as solution and close the thread Regards Chethan P

This post made by @prasath17 received 2 likes!

Regex extraction from html

@Druidtier3 - Please try this… [image] Regex Pattern = https:.+(?=\”\>here. This link will expire in 1 hour.) Sample workflow with output [image]

This post made by @Srini84 received 2 likes!

Move the file to respective folder using excel reference

@vijayabhaskar1987 check below, This should in For Each row activity [image] Hope this may help you Thanks

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Regex extraction from html

@Druidtier3 - Please try this… [image] Regex Pattern = https:.+(?=\”\>here. This link will expire in 1 hour.) Sample workflow with output [image]

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

The output of mail.body

please try href=\W(.*?(?=\W\Where\. This link will expire in 1 hour)) [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 | 17 May 2021

Top 3 Topics with Most Views

One Page You Should Bookmark - RPA Use Case Repository Guide made by @Lahiru.Fernando with 241 views.

Get multiple Files in Folder and send it In Email made by @Vincent_Nuestro with 57 views.

Click the list based on the three letter code made by @Sudharsan_Ka with 44 views.

Top 3 Topics with Most Replies

Click the list based on the three letter code made by @Sudharsan_Ka with 18 replies.

Regex to fetch table data from text file made by @rameezimtiaz with 18 replies.

Check digit number of a column made by @jntrk with 15 replies.

Top 3 Users Who Posted The Most

@prasath17 made 43 posts!

@copy_writes made 20 posts!

@Sakshi_Jain made 19 posts!

Top 3 Most Liked Posts

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

One Page You Should Bookmark - RPA Use Case Repository Guide

Learning is a process that never stops. Every journey we get on board starts by learning. Learning gives you the knowledge, and applying the knowledge you gained gives you experience. UiPath Academy is a great resource to learn the basics and advanced functionalities of the UiPath platform and RPA as a whole. Have you ever wondered where we can find resources to apply the knowledge to gain experience in the world of RPA? Finally… that resource we all were waiting for is now available… U…

This post made by @iulian.mircea received 2 likes!

Timeout property if the SAP session has hang or disconnected

Hi all, Thanks for your feedback! Can you please tell me which statement better describes your situation? The activity (SAP.ReadStatusBar or other, like a Click which triggers a time-consuming operation in SAP) would succeed if you gave it enough time. But you still want it to fail, if it takes longer than a precise amount of time. Eg: the activity succeeds in 31 seconds, but you want it to fail if timeout is set to 30 seconds. The activity has no chance to succeed, no matter how big the…

This post made by @prasath17 received 2 likes!

SAP Download Data

@Markus3003 - For Each type should be string… Inside the For Each add write Line and just print ‘file’ and check whether its reading all the files… Looks like this is off the topic from what you initially enquired, could you please open a new topic and discuss about this… Kindly close this thread, if you already received a solution from Stefan.

Top 3 Most Liked Solutions

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

How to select a outlook account

@Tharusha.fernando, You can set accounts as default by following weblink as below, How to Make Outlook Open to a Specific Default Account.

This solution provided by @Yoichi received 2 likes!

配列をランダムに並び替えるには？

こんにちは 以下でいかがでしょうか？ [img20210517-7] 本番で利用するときは、Randomクラスに適当なseedを与えてください。

This solution provided by @prasath17 received 2 likes!

While reading excel data for time base it is throwing error

Hi @GouthamVijay - Initial query provided by me in his previous post works like a charm…The reason why it is failing is Time Column has a blank data. So i just used another LINQ query to filter the Non Blank and ran the same code previous used and it ran successfully. [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 | 18 May 2021

Top 3 Topics with Most Views

How to loop date? made by @fairymemay with 35 views.

今日の日付を元に表より値を取得したい made by @miwa_yamamoto with 33 views.

⭐ Rate UiPath on G2 and get rewarded! - ended made by @Dana_Mustatea with 29 views.

Top 3 Topics with Most Replies

LOOP Creation on UiAutomation made by @Tanzill_Ahsan with 27 replies.

Condition for the list made by @Sudharsan_Ka with 26 replies.

Need to get the count of string in application region made by @Sudharsan_Ka with 23 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 38 posts!

@Sudharsan_Ka made 30 posts!

@Tanzill_Ahsan made 21 posts!

Top 3 Most Liked Posts

This post made by @DeaTo received 3 likes!

Join the UiPath Community Mentorship Program!

[1200x627_02] Join the UiPath Mentorship Program! We are thrilled to inform you that UiPath just launched a new program carefully crafted especially for RPA enthusiasts who are at the beginning of their automation journey: UiPath Community Mentorship. We put all our passion into building this Program because, as you know, you know we’re all about learning and growth, ours, as well as our Community Members’. We hope it will bring even more diversity and that it will build on yo…

This post made by @NIVED_NAMBIAR received 3 likes!

Update Excel Report

Hi @Vincent_Nuestro this is the logic i had implemented [image] Read the excel file and store in dt1 Use Invoke code activity with dt1 as In/Out argument with below code dt1.AsEnumerable().Where(Function(row) row(“Status”).ToString.Equals("")).ToList.ForEach(Sub(row) row(“Status”)=“Active”) Use the below assign activities to filter the datatables having status column as Active or other as follows For filtering rows having Active Status column use the assign activity dt2= dt1.As…

This post made by @Siddalinga_Sg received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Team, Happy to join UiPath forum… I am Siddalinga. I am very interested in RPA. You know I want to build my career as a Advanced RPA Developer. Hope i will complete certifications and move towards my goal. Thank you team for this technology and forum. You are awesome

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Update Excel Report

Hi @Vincent_Nuestro this is the logic i had implemented [image] Read the excel file and store in dt1 Use Invoke code activity with dt1 as In/Out argument with below code dt1.AsEnumerable().Where(Function(row) row(“Status”).ToString.Equals("")).ToList.ForEach(Sub(row) row(“Status”)=“Active”) Use the below assign activities to filter the datatables having status column as Active or other as follows For filtering rows having Active Status column use the assign activity dt2= dt1.As…

This solution provided by @LevKushnir received 1 likes!

SAP scripting enabling

all information can be found here About SAP WinGUI Automation

This solution provided by @copy_writes received 1 likes!

How to use OCR if the PDF format different?

Use document understanding in UiPath [UiPath Document Understanding - Invoice Data Extraction (Full Tutorial)] If you get the solution Mark as Solved Regards Chethan p

---

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

Top 3 Topics with Most Views

Generating Array made by @Rakesh_Sampath with 30 views.

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

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

Top 3 Topics with Most Replies

Error on expression made by @Sudharsan_Ka with 20 replies.

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

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

Top 3 Users Who Posted The Most

@postwick made 22 posts!

@Yoichi made 20 posts!

@sarathi125 made 17 posts!

Top 3 Most Liked Posts

This post made by @AnupamModak received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

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

This post made by @Michelle_Yurovsky received 2 likes!

Introducing UiPath Insights Cloud

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

This post made by @wasea received 2 likes!

Uipath regex

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

Top 3 Most Liked Solutions

This solution provided by @Pradeep_Shiv received 2 likes!

Loop checking whether a website has been opened

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

This solution provided by @sarathi125 received 2 likes!

Hello I want to split the string

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

This solution provided by @N2027 received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 20 May 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@prasath17 made 19 posts!

@Divyanshu_Divyanshu made 17 posts!

Top 3 Most Liked Posts

This post made by @DaliyaK received 3 likes!

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

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

This post made by @Corina_Gheonea received 2 likes!

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

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

This post made by @miwa_yamamoto received 2 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @shinji received 2 likes!

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

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

This solution provided by @Yoichi received 2 likes!

リモート接続について

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

This solution provided by @shinji received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 21 May 2021

Top 3 Topics with Most Views

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

Find date? made by @fairymemay with 41 views.

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

Top 3 Topics with Most Replies

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

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

Find date? made by @fairymemay with 18 replies.

Top 3 Users Who Posted The Most

@Wendy_wendy made 21 posts!

@Eric_Wong_Test made 16 posts!

@NIVED_NAMBIAR made 14 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 6 likes!

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

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

This post made by @seetharaman received 2 likes!

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

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

This post made by @Eric_Wong_Test received 2 likes!

How to search by month in the expression?

no need the id for r-359

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 1 likes!

Regular expression help for segregate special character

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

This solution provided by @gorby received 1 likes!

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

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

This solution provided by @ppr received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 22 May 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@prasath17 made 11 posts!

@NIVED_NAMBIAR made 10 posts!

@rpa13 made 10 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 3 likes!

Add columns if certain rules are met

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

This post made by @prasath17 received 2 likes!

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

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

This post made by @Adrian_Star received 2 likes!

Condition on excel sheet

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

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

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

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

This solution provided by @AndyMenon received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 23 May 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Nithin_P made 18 posts!

@prasath17 made 17 posts!

@PRASHANT_GABHANE made 15 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 3 likes!

How to convert string variable to integer

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

This post made by @NIVED_NAMBIAR received 3 likes!

Data manipulation in excel table having Parent and Child columns

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

This post made by @Sarmad_Nadeem received 2 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

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

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

This solution provided by @Yoichi received 1 likes!

Regex to extrac text between (multi-lines)

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

This solution provided by @prasath17 received 1 likes!

Count number of files with variable

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

---

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

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

[system]

Daily Forum Report | 24 May 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@prasath17 made 24 posts!

@Divyanshu_Divyanshu made 22 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @Divyanshu_Divyanshu received 4 likes!

Multiply two columns using Linq Query

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

This post made by @amalmarella received 2 likes!

Multiply two columns using Linq Query

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

This post made by @Yoichi received 2 likes!

How to fill a specific column's cells

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

Top 3 Most Liked Solutions

This solution provided by @Divyanshu_Divyanshu received 4 likes!

Multiply two columns using Linq Query

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

This solution provided by @kadiravan_kalidoss received 1 likes!

How to fill a specific column's cells

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

This solution provided by @Divyanshu_Divyanshu received 1 likes!

Regex to get middle initial or the only letter

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

---

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

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