Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 February 2021

Top 3 Topics with Most Views

Document Understanding : How to Extract Invoice Fields not Supported by Builtin ML Model made by @Tooba_Faroki with 57 views.

AIFabric_Demo made by @Varun_Dharni with 34 views.

Copy sheet error UIPath made by @AhmedKutraphali with 32 views.

Top 3 Topics with Most Replies

AIFabric_Demo made by @Varun_Dharni with 26 replies.

Unable to get credentials from orchestrator made by @Reuben_Kekana with 19 replies.

Resetting Excel Sheet to blank page at the end of each for loop made by @seongchan_cho with 18 replies.

Top 3 Users Who Posted The Most

@ksrinu070184 made 25 posts!

@Varun_Dharni made 24 posts!

@Cristian_Negulescu made 19 posts!

---

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

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

[system]

Daily Forum Report | 25 February 2021

Top 3 Topics with Most Views

How to filter excel? made by @fairymemay with 30 views.

English text classification dataset made by @Varun_Dharni with 29 views.

プロセスを強制終了でPDFファイルを閉じたい made by @Tatsu.H with 28 views.

Top 3 Topics with Most Replies

My Robot appears as "Disconnected" made by @APEXRPAROBOT with 23 replies.

랜덤으로 발생하는 레이어 팝업을 닫고 싶습니다 made by @Moolog with 22 replies.

English text classification dataset made by @Varun_Dharni with 21 replies.

Top 3 Users Who Posted The Most

@prasath17 made 20 posts!

@Varun_Dharni made 20 posts!

@NIVED_NAMBIAR made 17 posts!

Top 3 Most Liked Posts

This post made by @enriquediaz received 4 likes!

¿Problems hiding Internet Explorer? ¡Light Browser for hidden automations is here to help!

Let me announce you the release in the WPFInteractive of a new feature called Light Browser. It’s an embedded IE that supports all Internet Explorer versions from 7 to 11, you can choose which one to use. [image] This Light Browser adds the feature of a real hidden and non-intefering browser window navigation if all your navigation can be made via Simulate or Send Windows Messages. We have seen in some of our customers that the normal IE with the property Hidden set to true can be interfered …

This post made by @Yoichi received 3 likes!

How to simplify multiple for each loops while using regex match activity and add them datatable

Hi @MiaS @prasath17 , I just wrote the following sample. Hope this helps you. [img20210225-2] Sample20210225-2.zip (14.7 KB) Regards,

This post made by @ptrobot received 3 likes!

Send Hotkey based on the counts of rows in excel file

If your target control works with Type Into, you can also use Enumerable.Repeat(). String.Join("", Enumerable.Repeat("[k(down)]", 160)) [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 | 26 February 2021

Top 3 Topics with Most Views

If activity and check box made by @Tanu.Sharma with 35 views.

ERROR: Training Job failed, error: Expecting value: line 1 column 1 (char 0) made by @Maciej_Adamczyk with 33 views.

How to copy 10 rows from one column? made by @rsr.chandu with 27 views.

Top 3 Topics with Most Replies

If activity and check box made by @Tanu.Sharma with 27 replies.

How to copy 10 rows from one column? made by @rsr.chandu with 8 replies.

How to send hotkey to an excel file for decreasing decimal button for specific columns made by @Alperen_Tac with 7 replies.

Top 3 Users Who Posted The Most

@Hwang made 12 posts!

@Tanu.Sharma made 12 posts!

@NIVED_NAMBIAR made 11 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

UiPath Studio 64-bit Community Installer

@Pablito Hello Pawel, thank you very much for this interesting exciting news. Do you remember our short discussion about the preferred platform for custom activities, x86 or x64? If I am not mistaken, custom activities compiled with x86 flag will then no longer work. Only with the platform flag AnyCPU and x64. The use of your SAP BAPI activity will then explicitly require the installation of SAP NCo x64, not x86 as you described in your installation prerequsites, this depends on the UiPath v…

This post made by @Yoichi received 3 likes!

How To Get Last Three from List

Hi, Can you try the following expression? listA.Skip(listA.Count-3).ToList Regards,

This post made by @gheorghestan received 2 likes!

UiPath Community 21.2 Preview Activities Release

Hi @StefanSchnell . The documentation writing is in progress, planned to be released with 21.4 FTS, thus we don’t have anything formal as of now. However, I can provide some more information on these two new features: Shadow DOM is a virtual DOM created under the regular html page’s DOM, technique used by some of the newest web technologies like Angular or React, to apply their own styles, completely isolated from the original DOM. Example: [image] The UIAutomation driver is able now, to …

Top 3 Most Liked Solutions

This solution provided by @kwoxer received 2 likes!

Use Browser is missing settings like “Private” & “NewSession” in the Modern Design

Interesting but absolutely confusing. So maybe give the possibility to change those settings on the OR object would solve any issue and everyone is happy. WDYT?

This solution provided by @Manish540 received 2 likes!

How to calculate number of weekdays without SAT/SUN between two dates

Check this below code, @7387023380 TotalDays = 1 + ((Cdate(“02/14/2021”) - Cdate(“02/01/2021”)).TotalDays * 5 - (CDate(“02/01/2021”).DayOfWeek - Cdate(“02/14/2021”).DayOfWeek) * 2) / 7. And code is in the form of, TotalDays = 1 + (EndDate - StartDate).TotalDays * 5 - (StartDate.DayOfWeek - EndDate .DayOfWeek) * 2) / 7. EndDate and StartDate should be in - “MM/dd/yyyy” format This will give you the total days excluding the Saturday and Sunday. Hope this may help you

This solution provided by @jeevith received 1 likes!

Iterating through Jobject

@Cormac, Could you share / paste the contents of the json file? It makes it easier to debug

---

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

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

[system]

Daily Forum Report | 27 February 2021

Top 3 Topics with Most Views

Academy Videos 504 Gateway Time-out made by @eboolean with 43 views.

Use Regex to remove items made by @Sana_Afreen with 28 views.

Updating a Data Table - output from an Excel file made by @Rachita_Chauhan with 28 views.

Top 3 Topics with Most Replies

Academy Videos 504 Gateway Time-out made by @eboolean with 14 replies.

REFramework without Queue or without data table made by @AhmedKutraphali with 10 replies.

Invoke GetAppcredentials workflow: Object reference not set to an instance of an object made by @Dinesh_Babu_S with 9 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 10 posts!

@jeevith made 6 posts!

@Dinesh_Babu_S made 5 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 4 likes!

Info: How Excel PDF Exported Files Stores Table Data

In many discussions and posts it is very often assumed that PDF files, exported from Excel, store the table data they contain as structured data. Just as often, posts describes solutions for turning tables, stored in PDF, back into structured data. You can find excellent examples here Regex to extract data from @prasath17 How to Extract Table from PDF from @Cristian_Negulescu In all these cases the text of the PDF is restructured into a table. This shows us a key insight: PDF files sto…

This post made by @rtimani received 1 likes!

Academy Videos 504 Gateway Time-out

The same thing with me 504 Gateway Time-out

This post made by @rkelchuri received 1 likes!

ReCaptcha Resolved

Team, Please find this post on solving ReCaptcha. [image]

Top 3 Most Liked Solutions

This solution provided by @rkelchuri received 1 likes!

Captcha Reading

@Anjali_Rani , Solving Captcha is a possible with API key. But it is a paid third party service. If you are just trying to experiment then try with Free Captcha Solving APIs from google search. If you are working for an application of a client then you need to buy license AntiCaptcha and include AntiCaptcha API code in your Robot Workflow. Please watch this video from LinkedIn. Please find AntiCaptcha site as follows: Hope my inputs are useful.

This solution provided by @jeevith received 1 likes!

Invoke GetAppcredentials workflow: Object reference not set to an instance of an object

Hi @Dinesh_Babu_S The reason can be Your arguments value sent to GetAppCredemtials.xaml file in invoke workflow activity is empty The orchestrator, I am assuming your cloud orchestrator has a different name for the credentials asset you are trying to poll. You have spaces in your arguments string Your orchestrator asset is empty or asset is in a different Tennant Try and check these possible reasons. The error essentially occurs in many uipath activities when a required input to…

This solution provided by @jeevith received 1 likes!

Invoke GetAppcredentials workflow: Object reference not set to an instance of an object

Hi @Dinesh_Babu_S, I tested the get credentials workflow and the place where you invoke it (Initialization) where the asset name is polled from in_Config(“credentials”).ToString In both cases, I do get the Credentials from my cloud Orchestrator as below: [image] [image] Your config.xlsx file has the correct value (“ACMELogin”) for the “credentials” key without extra spaces. So in_Config("credentials").ToString is going to work fine. But in the future you can also use in_Config("credential…

---

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

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

[system]

Daily Forum Report | 28 February 2021

Top 3 Topics with Most Views

Uipath Academy videos are not playing made by @melvincjoy1 with 29 views.

MessageBox value will store on Excel sheet made by @Anjali_Rani with 28 views.

Sort column within an open application in chrome made by @joshua.reynolds with 23 views.

Top 3 Topics with Most Replies

Unable to Read PDf Files due o pdf viewer made by @Karan28 with 11 replies.

Filter Datatable by current date made by @Muthulakshmi_Thangamuthu with 8 replies.

MessageBox value will store on Excel sheet made by @Anjali_Rani with 8 replies.

Top 3 Users Who Posted The Most

@Cristian_Negulescu made 24 posts!

@NIVED_NAMBIAR made 18 posts!

@Anjali_Rani made 6 posts!

Top 3 Most Liked Posts

This post made by @cosminSimion received 5 likes!

Academy Videos 504 Gateway Time-out

Hey everyone, The problem has been flagged. Our video streaming services is down. We should get this back ASAP. More details to follow. Thanks

This post made by @ayesha.siddiqa received 3 likes!

Academy Videos 504 Gateway Time-out

Now available! Thanks Team!!

This post made by @ugki received 2 likes!

Academy Videos 504 Gateway Time-out

still error 504. Damn it’s now week-end the only moment I have to study. Please fix it asap thanks!

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Filter Datatable by current date

Hi @Muthulakshmi_Thangamuthu U can filter the excel by date as follows dt1 = dt1.AsEnumerable().Where(Function(row) row(“Initiared On”).ToString.Contains(Now.ToString(“yyyy-MMM-dd”)).CopyToDataTable where the dt1 is the datatable obtained by read range Or u can use filter datatable activity to filter the column “Initiared On” Contains CDate(Now.ToString(“yyyy-MMM-dd”)) (while read range (Check the preserve format option)) Regards Nived N Happy Automation

This solution provided by @NIVED_NAMBIAR received 1 likes!

파일실행 기간설정 가능한지 알고 싶어요

오케 스트레이터의 일정 옵션을 사용하여 특정 날짜 범위까지 프로세스를 예약 할 수 있습니다. @jhwoo

This solution provided by @ppr received 1 likes!

Add data row error dimentioanl array

use the other field: [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 | 01 March 2021

Top 3 Topics with Most Views

A new way of governing: UiPath Automation Ops is now available in Public Preview! made by @Paul_Boulescu with 81 views.

MailList内の受信日時をを古い順から取得し、書き出したい made by @11159 with 29 views.

How to generate invoice number made by @copy_writes with 28 views.

Top 3 Topics with Most Replies

How to perform Sort (not using Asc or Desc) made by @caduque with 24 replies.

How to compare and find not matching item in two data tables? made by @AnnaDewitt with 14 replies.

Outlook - Filter emails based on subject date made by @Dinesh_Babu_S with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 25 posts!

@Cristian_Negulescu made 17 posts!

@Yoichi made 14 posts!

Top 3 Most Liked Posts

This post made by @Paul_Boulescu received 8 likes!

A new way of governing: UiPath Automation Ops is now available in Public Preview!

UiPath Automation Ops is now available in Public Preview! As automations became more engrained in a company’s day to day operations, we received more and more signs from our customers about the need to properly govern and manage their flows, to set up rules and frameworks in which all the people contributing to the automation process can safely develop and publish their work. Where 3 years ago we had 2-3 people in one department developing in Studio, we now have hundreds of RPA developers and C…

This post made by @Yoichi received 3 likes!

Hi there, i have a question about How to get the CC's display name

Hi, MailMessage.CC property returns MailAddressCollection class. So we need to handle it as the following. [img20210301-1] Note: item is MailMessage type and cc is MailAdress type. Regards,

This post made by @Yoichi received 2 likes!

How to remove header text (like - Select one:) while fetching options from Drop-down list

Hi, How about the following? yourString.Replace("Select one:,","") or System.Text.RegularExpressions.Regex.Replace(yourString,"^[^,]*,","") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Hi there, i have a question about How to get the CC's display name

Hi, MailMessage.CC property returns MailAddressCollection class. So we need to handle it as the following. [img20210301-1] Note: item is MailMessage type and cc is MailAdress type. Regards,

This solution provided by @Yoichi received 2 likes!

How to remove header text (like - Select one:) while fetching options from Drop-down list

Hi, How about the following? yourString.Replace("Select one:,","") or System.Text.RegularExpressions.Regex.Replace(yourString,"^[^,]*,","") Regards,

This solution provided by @Manish540 received 2 likes!

How send mail to multiple recipients at onces by a mail list

Check this below code, @Tharusha_Fernando String.Join(";", EmailListVariable) - Pass this to the “To” part of the Send Outlook Mail activity. Hope this may help you

---

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

Top 3 Topics with Most Views

実行環境からOrchestratorにパブリッシュする方法 made by @1117 with 32 views.

セレクタの属性によって安定感が異なる？ made by @196006 with 26 views.

Studio doesn't work properly since a few days made by @FautVoir with 25 views.

Top 3 Topics with Most Replies

For each loop, run item & path at the same time in For each loop made by @Nightowl_music with 9 replies.

セレクタの属性によって安定感が異なる？ made by @196006 with 9 replies.

Expression Doesn't Produce a Value made by @Shaik.Yezdani with 9 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 23 posts!

@Yoichi made 20 posts!

@ppr made 16 posts!

Top 3 Most Liked Posts

This post made by @alexandru received 4 likes!

UiPath Studio 64-bit Community Installer

@StefanSchnell even if Studio is 64-bit the runtime is flexible: Runtime 32-bit: Studio supports x86 runtime for .NET Framework based activities and workflows. Runtime 64-bit: Studio will support x64 runtime for .NET Core based activities and workflows in a future version. Please let me know if this answers your concers.

This post made by @gjs received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am a researcher in digital innovation at Stockholm University Sweden. Trying to learn more about RPA in general and hyperautomation more specifically. Gustaf

This post made by @Pooja_Jain received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, Thank you for informative training. I just started from yesterday and joined rpa developer role. i started with basic introduction. as i see video quality cannot be changed when i was viewing video on phone urls and other stuff is clearly visible but information is enough to understand concepts. other than that very thankful

Top 3 Most Liked Solutions

This solution provided by @Sachin_Jadhav received 1 likes!

Facing Issue while taking difference between date and then multiply it by integer value

Thank you solution worked.

This solution provided by @tkiran received 1 likes!

How to extra filenames and check these files exists in excel if not it should enter file name in the excel

File extract.xaml (18.7 KB) Can you pls correct in this if possible or send me your above code in uipath screenshot.

This solution provided by @tkiran received 1 likes!

How to extra filenames and check these files exists in excel if not it should enter file name in the excel

WOW… Superb… thank you so much it works perfectly…

---

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

Top 3 Topics with Most Views

Oulook made by @Swetha_V with 36 views.

Calculate the average price using Original Price in the excel file made by @Anggara_Rahmadhani with 30 views.

[UiPath Live] Learn how AI and RPA can unlock unlimited potential for your work 🚀 made by @judylee with 27 views.

Top 3 Topics with Most Replies

Oulook made by @Swetha_V with 21 replies.

How to add row value in the specific column made by @Vrushali_Gave with 13 replies.

Copying files from one folder and moving to another folder made by @shekhawat.arjun1307 with 11 replies.

Top 3 Users Who Posted The Most

@prasath17 made 26 posts!

@NIVED_NAMBIAR made 19 posts!

@Liji made 18 posts!

Top 3 Most Liked Posts

This post made by @judylee received 3 likes!

[UiPath Live] Learn how AI and RPA can unlock unlimited potential for your work

Hello UiPath Community Imagine a world in which all your back-office tasks are invisible. Imagine a world where work is more fulfilling, valuable, and strategic. It is possible. Join us on March 24th for the first UiPath Live of 2021! Sign up now and we’ll show you how UiPath can bring AI into every facet of your work and unlock human creativity and ingenuity. Learn from and interact with industry experts, and get educated on the four key pillars that define the fully…

This post made by @ppr received 3 likes!

To extract string from a text file

@Nani_Kumar as you requested a case insensitive matching go for following (RegEx) [grafik] System.Text.RegularExpressions.Regex.Replace(YourStringVar,“ABC”,“BCD”,RegexOptions.IgnoreCase) Help for Regex have a look here:

This post made by @NIVED_NAMBIAR received 2 likes!

To extract string from a text file

Hi @Nani_Kumar try this code using assign activitiy Assuming u had stored ur string in input varaible Then use the below code input = System.Text.RegularExpressions.Regex.Replace(input,“ABC”,“BCD”) Regards Nived N Happy Automation

Top 3 Most Liked Solutions

This solution provided by @aalaghbari received 1 likes!

Remove First Special character “,” in a string

Hi @Nithinkrishna I found the solution var = var.TrimStart({","c}) Thanks a lot.

This solution provided by @poke received 1 likes!

Wordからexcelへのコピペ

こんにちは。 Wordのテキストを読み込み replaceでvbtabをカンマに変換 データテーブルを生成 Excelに書き込みしました。 データテーブルを生成ってこういう時に使うんですね。勉強になりました。

This solution provided by @LevKushnir received 1 likes!

SAP Automation WITH UiPath regarding

HI @Preeti yes no Please join my SAP Training to learn more about SAP Automation see links below Completely new SAP Academy course , to help you to learn the automation techniques and the best practices for SAP WinGUI automation Completely new SAP documentation , to cover all your information needs around SAP automation Best regards, Lev

---

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

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

RE frame work made by @prashanth_reddy with 17 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 17 posts!

@prasath17 made 15 posts!

@supermanPunch made 15 posts!

Top 3 Most Liked Posts

This post made by @Luiza received 61 likes!

Announcing the 2021 UiPath MVPs!

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

This post made by @NIVED_NAMBIAR received 10 likes!

Announcing the 2021 UiPath MVPs!

Congratulations guys

This post made by @FrankSchikora received 10 likes!

Announcing the 2021 UiPath MVPs!

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

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Regex to extract the last set of dates

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

This solution provided by @prasath17 received 1 likes!

Reading dates in excel return random numbers not the date

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

This solution provided by @ppr received 1 likes!

Add Data Column show error as already belong to another datatable

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

---

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

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

[system]

Daily Forum Report | 05 March 2021

Top 3 Topics with Most Views

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

Excel fetch values made by @sruthesanju with 30 views.

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@ksrinu070184 made 17 posts!

@PeruT made 9 posts!

@prasath17 made 9 posts!

Top 3 Most Liked Posts

This post made by @octechnologist received 3 likes!

Announcing the 2021 UiPath MVPs!

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

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

Announcing the 2021 UiPath MVPs!

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

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

UiPath Generic Framework Template

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

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Studio - Error during Add Data Row

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

This solution provided by @prasath17 received 1 likes!

Save email attachments that has keyword "Approval" in it

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

This solution provided by @prasath17 received 1 likes!

Regex to extract amount after a code pattern

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

---

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

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

[system]

Daily Forum Report | 06 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 9 posts!

@ksrinu070184 made 9 posts!

@hughabbott made 7 posts!

Top 3 Most Liked Posts

This post made by @msanthakumara received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all the MVP

This post made by @Sahil_Garg1 received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all MVP’s , great work guys.

This post made by @AMRITANShlal received 2 likes!

How to copy element in Find Children

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

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Write data in the first empty row

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

This solution provided by @ChrisPals received 1 likes!

How to write .bat file with write text file activity

Thank You for the responses I changed my encoding to utf-8 which resolved the issue.

---

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

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

[system]

Daily Forum Report | 07 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

Scraping website made by @ngateno_eno with 8 replies.

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

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 10 posts!

@NIVED_NAMBIAR made 9 posts!

@Vrushali_Gave made 8 posts!

Top 3 Most Liked Posts

This post made by @seanrockvz13 received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations Everyone!

This post made by @Vrushali_Gave received 3 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all MVP’s

This post made by @Shubhi received 2 likes!

Announcing the 2021 UiPath MVPs!

Thank-you Hashim @Hashim_Shamsudeen

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 08 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

Element Exist Looping made by @m0e91 with 14 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 25 posts!

@Yoichi made 21 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @rajaneesh received 4 likes!

Announcing the 2021 UiPath MVPs!

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

This post made by @nisargkadam23 received 3 likes!

Announcing the 2021 UiPath MVPs!

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

This post made by @alexandru received 2 likes!

The activity and project auto hide is not working

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

Top 3 Most Liked Solutions

This solution provided by @Ewout received 2 likes!

Get Outlook mail message filtering issue with received time

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

This solution provided by @ppr received 2 likes!

Regex to extract the last amount including the negative

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

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

Read Large excel file

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

---

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

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

[system]

Daily Forum Report | 09 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 23 posts!

@NIVED_NAMBIAR made 23 posts!

@songoel made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

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

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

This post made by @Yoichi received 3 likes!

Count of character duplicates in a string

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

This post made by @BasiReddy received 2 likes!

Announcing the 2021 UiPath MVPs!

Congratulations Everyone

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

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

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

This solution provided by @NIVED_NAMBIAR received 2 likes!

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

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

This solution provided by @ptrobot received 2 likes!

Regex to remove entire lines between 2 specifc identifiers

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

---

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

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

[system]

Daily Forum Report | 10 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 22 posts!

@prasath17 made 17 posts!

@Pravin_Patil1 made 13 posts!

Top 3 Most Liked Posts

This post made by @Bill_Richardson received 2 likes!

Orchestrator parameters do not work with UiPath Assistant

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

This post made by @Yoichi received 2 likes!

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

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

This post made by @Yoichi received 2 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Sort a datatable by count of duplicate

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

This solution provided by @LevKushnir received 1 likes!

Bridge between UIPATH -> SAP

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

This solution provided by @ppr received 1 likes!

How to filter datatable from linq query

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

---

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

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

[system]

Daily Forum Report | 11 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@prasath17 made 15 posts!

@Yoichi made 12 posts!

@fairymemay made 11 posts!

Top 3 Most Liked Posts

This post made by @Raviteja_N received 4 likes!

Announcing the 2021 UiPath MVPs!

many wishes to all the MVP’s

This post made by @Taeko_UiPath received 4 likes!

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

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

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

I want to split the text

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

Top 3 Most Liked Solutions

This solution provided by @gheorghestan received 1 likes!

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

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

This solution provided by @songoel received 1 likes!

Pop up Message during process working

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

This solution provided by @Z15 received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 12 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

Please Help me made by @vjsolomons with 9 replies.

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

Top 3 Users Who Posted The Most

@prasath17 made 21 posts!

@badal_patel made 11 posts!

@Yoichi made 9 posts!

Top 3 Most Liked Posts

This post made by @Sophia_Salo received 7 likes!

Make your package compatible with Studio 21.4

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

This post made by @badal_patel received 3 likes!

Extraction in Invoice Problem

Beneficiary Account, Amount, Payment Date, Remarks

This post made by @StefanSchnell received 2 likes!

SAP Activities Tutorial

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

Top 3 Most Liked Solutions

This solution provided by @StefanSchnell received 2 likes!

SAP Application scope TypeInitializationException error

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

This solution provided by @NIVED_NAMBIAR received 2 likes!

How to write cell start from cell A2?

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

This solution provided by @maz received 2 likes!

No response from the UiPath sales form

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

---

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

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

[system]

Daily Forum Report | 13 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 11 posts!

@prasath17 made 11 posts!

@ksrinu070184 made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

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

@Puneet_Singh1 give a try with regex: [grafik]

This post made by @moenk received 2 likes!

Pause Automation on a slow website

Sounds as if you like to use this activity:

This post made by @Marius_Puscasu received 2 likes!

Map data excel

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

Top 3 Most Liked Solutions

This solution provided by @Marius_Puscasu received 2 likes!

Map data excel

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

This solution provided by @prasath17 received 2 likes!

StudioX - Calculate using spreadsheet issue

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

---

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

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

[system]

Daily Forum Report | 14 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Sahil_Garg1 made 10 posts!

@shekhawat.arjun1307 made 10 posts!

@RPAForEveryone made 6 posts!

Top 3 Most Liked Posts

This post made by @wasea received 3 likes!

Where can someone verify the certificate issued by uipath?

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

This post made by @ppr received 2 likes!

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

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

This post made by @Sharal_DCosta1 received 1 likes!

Announcing the 2021 UiPath MVPs!

Congratulations everyone!

Top 3 Most Liked Solutions

This solution provided by @wasea received 3 likes!

Where can someone verify the certificate issued by uipath?

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

This solution provided by @ken_infield received 1 likes!

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

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

This solution provided by @Nadia_GHOUFA received 1 likes!

How to output classification results?

Hello @yourubl, Hope this helps. [image]

---

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

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

[system]

Daily Forum Report | 15 March 2021

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@prasath17 made 26 posts!

@Pravin_Patil1 made 25 posts!

@Sahil_Garg1 made 15 posts!

Top 3 Most Liked Posts

This post made by @PrankurJoshi received 4 likes!

Announcing the 2021 UiPath MVPs!

Many Many Congratulations All the MVPs!

This post made by @Dana_Mustatea received 4 likes!

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

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

This post made by @NIVED_NAMBIAR received 3 likes!

Studio - How to get the dynamic Column from Excel

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

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

Studio - How to get the dynamic Column from Excel

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

This solution provided by @NIVED_NAMBIAR received 2 likes!

How to get previous date?

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

This solution provided by @prasath17 received 2 likes!

Get Latest Excel File Created from a folder

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

---

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

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