Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 March 2022

Top 3 Topics with Most Views

How to get the range of data present in excel made by @jeevan.h with 50 views.

How to filter outlook email messages received "today" made by @kit2815 with 40 views.

Job running failed made by @s.swapna8 with 37 views.

Top 3 Topics with Most Replies

Job running failed made by @s.swapna8 with 18 replies.

How to get the range of data present in excel made by @jeevan.h with 16 replies.

I want to move files from one folder to another folder. The files are stored in onedrive made by @abhishek_bhide with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 33 posts!

@ashwin.ashok made 10 posts!

@nico.marucchi made 8 posts!

Top 3 Most Liked Posts

This post made by @SudhaSachi received 2 likes!

Monthly Forum rewards - February 2022

Congratulations to all of you.

This post made by @pravin_calvin received 1 likes!

Yoichi 2000th Solution Flag Celebration

Congratulations @Yoichi

This post made by @Palaniyappan received 1 likes!

Yoichi 2000th solution Flag celebration

Congrats @Yoichi Inspiring

Top 3 Most Liked Solutions

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

Parsing DateTime AM/PM Problem

this will work DateTime.ParseExact("22/02/2019 - 07:24 PM", "dd/MM/yyyy - hh:mm tt", nothing) you need to use hh instead of HH because HH is 24 hour time which doesnt work with AM / PM e.g. 15:03 AM doesnt make sense but 03:03 AM or 03:03 pm makes sense

This solution provided by @mahmoud.zaky received 1 likes!

How to split int no without seperator

Hello Naveen, you can use “Strvalue.ToCharArray” like below 1- Create Variable for your string (Str) with your value. 2- Create Array of type Char under system.char (arrstr) 3- use assign activity as arrstr–> Str.ToCharArray 4- then use for each loop on you arrstr. Screen of process: [image] Screen of Variables: [image] Screen of Output: [image]

This solution provided by @Srini84 received 1 likes!

Unable tio use Filter data Table activity in UI PAth version 2021

@varun_shinde Can you place ColumnName in " " Put Column Salary as “Salary” Hope this will help you Thanks

---

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

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

[system]

Daily Forum Report | 06 March 2022

Top 3 Topics with Most Views

Need help to edit code LINQ? made by @fairymemay with 69 views.

Disaster when Move File to a destination folder which was not exist made by @Marginalizer with 48 views.

Need help to Filter datatable made by @Aleem_Khan with 47 views.

Top 3 Topics with Most Replies

Need help to edit code LINQ? made by @fairymemay with 20 replies.

Need help to Filter datatable made by @Aleem_Khan with 10 replies.

Disaster when Move File to a destination folder which was not exist made by @Marginalizer with 9 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 35 posts!

@Aleem_Khan made 14 posts!

@fairymemay made 11 posts!

Top 3 Most Liked Posts

This post made by @vaibhavinnovation79 received 2 likes!

Monthly Forum rewards - February 2022

Congratulations to All

This post made by @ashwin.ashok received 2 likes!

How to split int no without seperator

The pattern detects the empty gaps between each number: [image] Then Where clause in the LINQ filters out empty results(Blanks) and converts the rest to Array. Kind Regards, Ashwin A.K

This post made by @Abram_Yct received 1 likes!

Unable to assign value from Datatable

Hello Mr Gustavo, i still have the same problem as this post and still cant find the way to get rid of it. Can i send you my project? thank u so much.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Convert day today to int?

Hey @fairymemay Yes it shows like the below, 0 - Sunday 1 - Monday 2 - Tuesday 3 - Wednesday 4 - Thursday 5 - Friday 6 - Saturday I guess when you ran the above code, as per your system day it would be Sunday that’s why it outputs as 0 Hope this helps Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

Need help to edit code LINQ?

Hey @fairymemay Please find the updated below, ateTime.ParseExact(x(“วันรับเล่ม”).ToString, “dd/MM/yyyy HH:mm”, System.Globalization.CultureInfo.InvariantCulture) Thanks #nK

This solution provided by @Jorge_Valbuena received 1 likes!

Different results reading a Native PDF File and Scanned PDF File with the same OCR

So, It’s seems to be an issue with the encoding of some fonts, when I set the property ForceApplyOCR to true, I get the expected results from the extraction of the data. I guess that with the proper OCR, the results will be with 100% accuracy or close to it.

---

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 2022

Top 3 Topics with Most Views

LINQ to check if item in one column of Datatable 1 is present or contains items from another column in Datatable2 made by @Ray_Sha1 with 62 views.

How can i use extract table data on web data? made by @A_Zyzz_Man with 46 views.

Round a number to the nearest 10 made by @Haltob01 with 44 views.

Top 3 Topics with Most Replies

LINQ to check if item in one column of Datatable 1 is present or contains items from another column in Datatable2 made by @Ray_Sha1 with 21 replies.

Send SMTP Mail Message new line made by @Felix_Gunawan with 21 replies.

Boolean error to replace text using Asenumberable made by @Shyam_Pragash with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 45 posts!

@ashwin.ashok made 31 posts!

@postwick made 25 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 3 likes!

Convert Timespan to the String Format

Hi @henokhbrian , Timespan might contain the keyword “Time” in it, but it has nothing to do with Dates, which is why we can’t use string implementations. Its a collection of ticks, so the only workaround for it is like so: [image] Assign → spn_variable = TimeSpan.Parse("1.03:34:23.8121360") spn_variable.Hours.ToString+":"+spn_variable.Seconds.ToString Or String.Format("{0}:{1}",spn_variable.Hours,spn_variable.Seconds) I hope that helps. Kind Regards, Ashwin A.K

This post made by @Nithinkrishna received 2 likes!

How to check if a tab still exists, without using element exist

Hey @Shinjid The below activity may help you. Thanks #nK

This post made by @fairymemay received 2 likes!

Check range another sheet excel?

Now I check value in column FYP and compare with sheet that start text config as below. and column Type_config = sheetName that found value APPLAN follow red text) [image] test.xaml (22.8 KB) Data Campaign_65 old map.xlsx (1.5 MB) But DataRow have 10K , It take time to run. Please guide me about it. (Fast) @Ramya_K can you guide me for edit code?

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

How to check if a tab still exists, without using element exist

Hey @Shinjid The below activity may help you. Thanks #nK

This solution provided by @Gokul001 received 2 likes!

How to click the button of excel?

HI @yu_anan Welcome to community! Can you try to use Click Image activity If possible share the excel file Regards Gokul

This solution provided by @ppr received 2 likes!

Check column name if found header same

---

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 2022

Top 3 Topics with Most Views

【UiPathアカデミー】新規コースのお知らせ made by @yuko.tanaka with 52 views.

How can we get the modified Date from a file in Sharepoint? made by @jmeier with 46 views.

Sum of a column based on index made by @karthik_kulkarni1 with 42 views.

Top 3 Topics with Most Replies

Regex based extractor extracting all value from all the pages of the pdf made by @shrey.shah with 25 replies.

How to replace all the spaces of Headers with "_" made by @Sirimalla_Karthik_Chandra with 23 replies.

How to click on the ok or cancel button within the chrome alert box? made by @Riya_Sharma with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 40 posts!

@ashwin.ashok made 35 posts!

@ppr made 31 posts!

Top 3 Most Liked Posts

This post made by @yuko.tanaka received 3 likes!

【UiPathアカデミー】新規コースのお知らせ

平素より、UiPathアカデミー をご愛顧いただき誠にありがとうございます。 このたび、「 Studio による UI 操作の自動化 」コースを新たにリリースしましたのでお知らせいたします。 このコースでは、モダン エクスペリエンスとクラシック エクスペリエンスの両方を使用して、UI 操作の自動化の概念について学習します。 ※アカデミーにログイン後、リンクが遷移しない場合は、ブラウザーを一度閉じクッキーとキャッシュをクリアしてください。 UiPath 製品に関する知識の拡充にお役に立てればと思います。 ぜひ、UiPath アカデミーをご活用くださいませ。 引き続きよろしくお願いいたします。

This post made by @Gokul001 received 3 likes!

Advanced scheduling using Cron Expression

What is Cron Expression? Cron expressions are used to configure instances of Cron Trigger, a subclass of Trigger. Cron expression is a string consisting of six or seven subexpressions (fields) that describe individual details of the schedule. Quartz implements 7 field cron-expressions Seconds Minutes Hours Day-of-Month Month Day-of-Week Year (optional field)

1. Cron expression to trigger the process for Every month & day between 7th and 13th at 7:30

Expression : 0 30 7 7-13 * ? * [ima…

This post made by @Gokul001 received 3 likes!

Pic download

Hi @kamini Welcome back to community Instead of passing the title You can use “*” Asterisk Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

Pic download

Hi @kamini Welcome back to community Instead of passing the title You can use “*” Asterisk Regards Gokul

This solution provided by @Sadmim_Hossain1 received 2 likes!

Check dup by column

Hello, For this problem, you can First flag the rows that are duplicates and later delete them from excel with an Insert/Delete Rows activity to delete the rows that are flagged. I have created a solution, you can have a look, and do let me know if you have any further queries. ExcelDupicateDelete.xaml (35.4 KB)

This solution provided by @ashwin.ashok received 2 likes!

When I Assign the datarow to select the column of datatable there's cannot find

Hi @HuaiYe , It seems as though the Data Scrapping was performed unsuccessfully. Could you try using the Data Scrapping Wizard? [image] The Modern Design Experience has to be disabled for this option to be available. [image] You can use the Extract Table Data Activity as well if Modern Design Experience is enabled like so: [image] ExtractDataFromWeb.xaml (11.8 KB) Kind Regards, Ashwin A.K

---

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 2022

Top 3 Topics with Most Views

Celebrating 5️⃣ anniversary with UiPath Forum made by @lakshman with 56 views.

Extract certain string between "|" made by @Ionut_Frincu with 49 views.

Read multiple invoice format made by @mayachoy with 42 views.

Top 3 Topics with Most Replies

How to run "Start Job" for designated Robot made by @Lori with 17 replies.

Celebrating 5️⃣ anniversary with UiPath Forum made by @lakshman with 14 replies.

Extract certain string between "|" made by @Ionut_Frincu with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 47 posts!

@Palaniyappan made 17 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @lakshman received 16 likes!

Celebrating anniversary with UiPath Forum

Hey Guys, As the cake near my name says, today is my year anniversary since I joined the UiPath Forum [Screenshot_20220309-093859] I have learnt a lot from forum during these years especially from @ppr (Linq query expert), @Yoichi (Regex expert), @StefanSchnell (SAP automation expert), @balupad14 (Excel automation expert) and also made a lot of friends like @Lahiru.Fernando, @Palaniyappan, @nerlichman, @Divyashreem, @prasath_S etc… I…

This post made by @lakshman received 3 likes!

Celebrating anniversary with UiPath Forum

@prasath_S @Yoichi @nikhil.girish Thanks to you as well for your continuous support to the UiPath community. Keep up the good work

This post made by @lakshman received 2 likes!

Celebrating anniversary with UiPath Forum

Thanks to you @Gokul001 & @Sudharsan_Ka as well for your continuous support to the UiPath community. Keep up the good work.

Top 3 Most Liked Solutions

This solution provided by @Sadmim_Hossain1 received 2 likes!

Delete rows excel (loop)

Hello, I hope this works for you DeleteRowsExcelLoop.xaml (13.2 KB)

This solution provided by @Gokul001 received 1 likes!

C# or vba?

Hi @ankur.kaushik Welcome to community Have a look on the thread Regards Gokul

This solution provided by @ashwin.ashok received 1 likes!

How to check if one column is equal another colum in excel and add a new column

Hi @siteltower , Could you try and see if the logic performs the operation as expected? (From row In dt_masterData.AsEnumerable() Let upd = dt_updateData.AsEnumerable().Where(Function(w) w("ID").ToString.Trim.Equals(row("ID").ToString)).ToArray() Let ra = New Object(){row("ID"),row("Service Type"),row("Assets SN"), upd.First().Item("Status"),upd.First().Item("Issue"),row("Name"),row("Project")} Select dt_result.Rows.add(ra)).CopyToDataTable() CheckIfColumnsAreSame.xaml (7.8 KB) Kind Regards, …

---

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

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

[system]

Daily Forum Report | 10 March 2022

Top 3 Topics with Most Views

How to get the Max and Min value from excel and write it to another excel made by @Krystal with 52 views.

Need a help on Group By made by @Marian_B with 51 views.

Insert header into Data table made by @Olivera_Kalinic with 47 views.

Top 3 Topics with Most Replies

Insert header into Data table made by @Olivera_Kalinic with 18 replies.

Unable to get column value in excel made by @shuklarchana001 with 14 replies.

How to get the Max and Min value from excel and write it to another excel made by @Krystal with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 62 posts!

@ashwin.ashok made 40 posts!

@Gokul001 made 39 posts!

Top 3 Most Liked Posts

This post made by @Ovidiu_Constantin received 3 likes!

Log times to contain milliseconds

Added to the backlog.

This post made by @Gokul001 received 3 likes!

How to set flow condition?

HI @fairymemay Have a look on the skeleton Flowchart.xaml (11.4 KB) [image] Regards Gokul

This post made by @postwick received 2 likes!

Whole data table as single item into an orchestrator queue

Queue Items can’t be complex datatypes. Your best option is to save the data to Excel or CSV and then reference the file path as a string in the Queue Item. It is possible to convert a datatable to JSON and put the JSON into the Queue Item as a string, but I don’t know the limitations on how much data you can do that with.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

How to set flow condition?

HI @fairymemay Have a look on the skeleton Flowchart.xaml (11.4 KB) [image] Regards Gokul

This solution provided by @postwick received 2 likes!

Whole data table as single item into an orchestrator queue

Queue Items can’t be complex datatypes. Your best option is to save the data to Excel or CSV and then reference the file path as a string in the Queue Item. It is possible to convert a datatable to JSON and put the JSON into the Queue Item as a string, but I don’t know the limitations on how much data you can do that with.

This solution provided by @ashwin.ashok received 2 likes!

How to get particular date of every month from current year?

Hi @NervousTuber , Is this what you were looking for? [image] [image] Assign → int_day = 16 int_year = 2022 Enumerable.Range(1,12).Select(Function(s) New DateTime(int_year,s,int_day).ToString("dd/MM/yyyy")).ToArray() Kind Regards, Ashwin A.K

---

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 2022

Top 3 Topics with Most Views

Measuring Bot Execution Time made by @anmita with 56 views.

Else condition pass to CATCH? made by @fairymemay with 55 views.

Moving collumns made by @Atharv_Madne with 52 views.

Top 3 Topics with Most Replies

Else condition pass to CATCH? made by @fairymemay with 18 replies.

Smtp errror made by @poojaskyrathore with 17 replies.

Moving collumns made by @Atharv_Madne with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 35 posts!

@ashwin.ashok made 33 posts!

@nikhil.girish made 24 posts!

Top 3 Most Liked Posts

This post made by @nikhil.girish received 2 likes!

Post GET API Request

Hi @karina_mota try downgrading the package and see if issue still persist ? Thanks

This post made by @Yoichi received 2 likes!

Is it possible to create a code where it behaves like a scientific calculator?

Hi, Unfortunately, Vb or C# doesn’t have a function like eval(), we need to approach by other ways. ● DataTable.Compute method strExpression = "((10-5)*(2+2))*5" dt = New DataTable() Then dt.Compute(strExpression, "").ToString ● Inject JS script activity strExpression = "((10-5)*(2+2))*5" Inject JS Script activity Indicate an element in any browser. Input Parameter : strExpression ScriptCode "function(e,v) { return eval(v); }" ScriptOutput : strResult ●Use 3rd party library. Per…

This post made by @karina_mota received 1 likes!

Post GET API Request

Hi Thank you very much, I created a new project and re-installs activity in an older version. The error is gone. Now I will try the procedure that the @dokumentor suggested. very grateful [Capturar]

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 2 likes!

Post GET API Request

Hi @karina_mota try downgrading the package and see if issue still persist ? Thanks

This solution provided by @Yoichi received 2 likes!

Is it possible to create a code where it behaves like a scientific calculator?

Hi, Unfortunately, Vb or C# doesn’t have a function like eval(), we need to approach by other ways. ● DataTable.Compute method strExpression = "((10-5)*(2+2))*5" dt = New DataTable() Then dt.Compute(strExpression, "").ToString ● Inject JS script activity strExpression = "((10-5)*(2+2))*5" Inject JS Script activity Indicate an element in any browser. Input Parameter : strExpression ScriptCode "function(e,v) { return eval(v); }" ScriptOutput : strResult ●Use 3rd party library. Per…

This solution provided by @suraj.setty received 1 likes!

Adding Values of column

Hi @mohamedalthaf Please have a look. [Uipath Sum of Column in Excel] Hope this helps to solve. 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 | 12 March 2022

Top 3 Topics with Most Views

How to count Special 3 character in one String made by @Sweety_Nagar with 73 views.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 56 views.

Regex help capturing total amount made by @MaxDS1 with 42 views.

Top 3 Topics with Most Replies

How to count Special 3 character in one String made by @Sweety_Nagar with 14 replies.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 13 replies.

Excel to Sap Business one made by @badal_patel with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@Gokul001 made 19 posts!

@fairymemay made 14 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 If you need the whole text try this expression System.Text.RegularExpression.Regex.match("InputString","(I\salt\s)(\d.+)|(Saldo\s)(\d.+)|(Saldo\svor\sfavør\n)(\d.+)|(Ultimosaldo\sI\salt DKK\s)(\d.+)|(I\salt\sDKK\s)(\d.+)|(Beløb\sSkyldig\nkr\s)(\d.+)").Tosting.Trim [image] Regards Gokul

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 Try this Regex Expression System.Text.RegularExpression.Regex.match("InputString","(?<=I\salt\s)(\d.+)|(?<=Saldo\s)(\d.+)|(?<=Saldo\svor\sfavør\n)(\d.+)|(?<=Ultimosaldo\sI\salt DKK\s)(\d.+)|(?<=I\salt\sDKK\s)(\d.+)|(?<=Beløb\sSkyldig\nkr\s)(\d.+)").Tosting Regards Gokul

This post made by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

This solution provided by @Palaniyappan received 1 likes!

Throw, Rethrow and Global Exception handler

Hi I appreciate your interest and passion to know the activity and it’s properties But by next Pls be clear with the query you want to get clarified On a note that these are EXCEPTION handling methods / activities used in UiPath There are five activities for handling exception Try catch Throw Rethrow Global exception handler Retry scope Rethrow is used when you want activities to occur before the exception is thrown. Throw activity is used when you want to throw error before the execut…

This solution provided by @ashwin.ashok received 1 likes!

For Loop append string

Hi @fairymemay , If you are using a For Each Loop, then here is a sample sequence to get you started: [image] [image] [image] I’m using a Substring Method to get rid of the comma that gets appended towards the start when we first start assigning the items to our string variable. CombineStrings.xaml (6.4 KB) Kind Regards, Ashwin A.K

---

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 2022

Top 3 Topics with Most Views

Activities if made by @pl.rusinov with 47 views.

How to store multiple extracted PDF data through DU into excel made by @sai_krishna6 with 43 views.

Copy values from one excel to another made by @Sathish_Kumar_S with 41 views.

Top 3 Topics with Most Replies

Compare values from different excel made by @aqiff with 10 replies.

How to store multiple extracted PDF data through DU into excel made by @sai_krishna6 with 10 replies.

Copy values from one excel to another made by @Sathish_Kumar_S with 8 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 16 posts!

@Palaniyappan made 15 posts!

@Nithinkrishna made 9 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Does Deserialize Contain XML Value?

we would recommend to do a first check on only local name. So we do not have handle unknown namespaces. [grafik] xdoc.Descendants().Any(Function (x) x.Name.LocalName.tolower.equals(strElementNameVar.toLower))

This post made by @anmita received 1 likes!

Using Widget for Execution Time in Insight

If we have the transaction duration in Seconds for bot then how can I find the Bot Processing Time in hour format using formula in widget ? (Example in 1 hr how much time does it execute needs to be found)

This post made by @Sathish_Kumar_S received 1 likes!

Copy values from one excel to another

How to copy the Value of the each header in file 1 to file 2 ? File 1: [image] File 2: [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Does Deserialize Contain XML Value?

we would recommend to do a first check on only local name. So we do not have handle unknown namespaces. [grafik] xdoc.Descendants().Any(Function (x) x.Name.LocalName.tolower.equals(strElementNameVar.toLower))

---

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 2022

Top 3 Topics with Most Views

Data scrapping On multiple pages made by @vijay_allena with 74 views.

How to use Inject .NET Code? made by @donghai with 55 views.

Chrome Download made by @cury with 53 views.

Top 3 Topics with Most Replies

Could not extract proper text made by @Sirisha_Siri with 24 replies.

Data scrapping On multiple pages made by @vijay_allena with 23 replies.

What type of input method should we use for Keyboard shotcuts in modern design? made by @divya.paul with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 54 posts!

@Palaniyappan made 41 posts!

@ashwin.ashok made 30 posts!

Top 3 Most Liked Posts

This post made by @ordo received 3 likes!

Error while executing SAP BAPI_REQUISITION_CHANGE From Uipath Activities

Hi @pmexilinx, the problem is the data structure of the BAPIs you are using. The BAPI_REQUISITION_GETDETAIL uses a table of type BAPIEBAN where BAPI_REQUISITION_CHANGE uses data type BAPIEBANV for the requisition items. First columns of BAPIEBAN [image] First columns of BAPIEBANV [image] Therefore just copying the data table will not work. You need to map the individual columns. You can either use transaction SE37 in the SAP GUI to check the structure of the parameters or use “Export P…

This post made by @Sudharsan_Ka received 2 likes!

Write excel data in word template

HI @Katrina Can You tell exactly how you created your workflow if possible share the screenshot of the flow? You can try this if you not done before Fill alphabets in the each column in the word document like A1,B1,C1 like this here is the document updated [image] Q2 Revenue.docx (35.7 KB) Now read range and store in a var Assign a counter =1 where counter is integer datatype. Loop through all the rows Kill Process “Word” and check the continue on error Delay for 2 secs Word Scope Use…

This post made by @Palaniyappan received 2 likes!

Extract only dates from a string using Matches activity

Hi Try with this expression (\d){1,2}\W(\d){1,2}\W(\d){1,4} [image] Hope this would help you resolve this Cheers @Harsha_Vemula

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 2 likes!

Write excel data in word template

HI @Katrina Can You tell exactly how you created your workflow if possible share the screenshot of the flow? You can try this if you not done before Fill alphabets in the each column in the word document like A1,B1,C1 like this here is the document updated [image] Q2 Revenue.docx (35.7 KB) Now read range and store in a var Assign a counter =1 where counter is integer datatype. Loop through all the rows Kill Process “Word” and check the continue on error Delay for 2 secs Word Scope Use…

This solution provided by @Palaniyappan received 2 likes!

Extract only dates from a string using Matches activity

Hi Try with this expression (\d){1,2}\W(\d){1,2}\W(\d){1,4} [image] Hope this would help you resolve this Cheers @Harsha_Vemula

This solution provided by @Nithinkrishna received 2 likes!

How to use Inject .NET Code?

Hey @donghai Kindly check the below once, Thanks #nK

---

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 2022

Top 3 Topics with Most Views

Assign: The source contains no DataRows? made by @fairymemay with 45 views.

Rowcount after filtering made by @Sirisha_Siri with 43 views.

How to Fetch files from a folder based on the timestamp in filename? made by @Sirimalla_Karthik_Chandra with 42 views.

Top 3 Topics with Most Replies

How to Fetch files from a folder based on the timestamp in filename? made by @Sirimalla_Karthik_Chandra with 15 replies.

How to make filters with regex from array or from variables with conditionals? made by @Lynx with 13 replies.

Extract Firstname and Last name from the string after specific text format made by @benjamin.9052 with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 51 posts!

@Palaniyappan made 29 posts!

@ushu made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Group String in Array and Json

after deserialization will look like this: [grafik] you will lose some values. We can achieve it by grouping the values, but need the detail input string. Maybe you can share it as txt file with us? Thanks

This post made by @supermanPunch received 2 likes!

Group String in Array and Json

Hi @Pablo_Sanchez , Try Replacing the Regular expression Pattern in Matches Activity with the below : \[(\d+)\](.*?)\/\/ Let us know if it doesn’t work

This post made by @ppr received 2 likes!

Group String in Array and Json

@Pablo_Sanchez With the help of Regex we can split the string [grafik] refering to the groups (we will trim later) [grafik] For regex learning have a look here: With following flow we can achieve the result: [grafik] [grafik] [grafik] The main idea is about: use regex to as mentioned above Regex.Matches(strText, strPattern, RegexOptions.IgnoreCase) group the matches and create JProperties, return all as an array (From m In myMatches.Cast(Of Match).toList Group m By k=m.Gro…

Top 3 Most Liked Solutions

This solution provided by @MirceaGolban received 2 likes!

Pre-defined ML Packages

Hi @Vicky_Fegan1 We know about the download issue and a fix is in the works. In the meantime, please use the attached schemas. schemas.zip (16.2 KB) Thank you

This solution provided by @Soudios received 1 likes!

I would like the bot to write to the last empty line in Excel

i tried an other solution that’s you count the number of row on the excel and you add +1

This solution provided by @supermanPunch received 1 likes!

Group String in Array and Json

Hi @Pablo_Sanchez , I was able to Get the Data into the Json as Needed. Although there might be a better method than this. First we have to identify the group of values in the input String. We could use the below Regex for that : \[(\d+)\](\w+) [image] We can then use the Matches Activity with the above pattern to get the resultant matched values. Here onwards, the data I have converted to a Datatable for ease in grouping the values. [image] Next, Group the data based on Number and iter…

---

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

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

[system]

Daily Forum Report | 16 March 2022

Top 3 Topics with Most Views

How to count the number of blank items in a datatable? made by @Pruthvi.G with 62 views.

Split text ,? made by @fairymemay with 60 views.

Invoke workflow & Terminate workflow? made by @vivek_sinha with 56 views.

Top 3 Topics with Most Replies

Date question made by @cury with 29 replies.

Dynamic File Name made by @Futurised with 20 replies.

How to use right click or crtl +s in new browser tabs? made by @Rodrigo_Buch with 17 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 50 posts!

@ashwin.ashok made 38 posts!

@Palaniyappan made 34 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to handle periodically missing item from the dropdown menu when using Select Item activity?

Depending on the type of dropdown an element exists with dynamic selector to the option element from the dropdown select element could be an alternate to find children. A benefit of find children is that we do have more control when evaluating the found children. Keep in mind that find children will return uielements. So an evaluation on the value could look like this (check on innertext attribute) FindChildrenOutPut.Any(Function (x) x.Get("innertext").toString.Trim.Equals(YourSearchValue)) …

This post made by @Palaniyappan received 2 likes!

How to count the number of blank items in a datatable?

Hi If you want to delete the empty rows considering the whole DATATABLE then DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Or If you want to delete empty rows based on one column DatatableName = DataTableName.Select("Convert(column3, System.String)< >''").CopyToDataTable() or Datatablename = DataTableName.Select("column3< >''").CopyToDataTable() Cheers @Pruthvi.G

This post made by @komal.v.konduru received 2 likes!

Cannot select the pop up

@Palaniyappan Thanks, Sir. Those really helped me. @nikhil.girish @Gokul001 Thanks mates your valuable messages helped me a lot.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to handle periodically missing item from the dropdown menu when using Select Item activity?

Depending on the type of dropdown an element exists with dynamic selector to the option element from the dropdown select element could be an alternate to find children. A benefit of find children is that we do have more control when evaluating the found children. Keep in mind that find children will return uielements. So an evaluation on the value could look like this (check on innertext attribute) FindChildrenOutPut.Any(Function (x) x.Get("innertext").toString.Trim.Equals(YourSearchValue)) …

This solution provided by @Palaniyappan received 1 likes!

Pass variable to array?

Mention like this if the variable name is Strinput Enumerable.Range(0,dt_configRate.RowCount).Select(Function(s) dt_configRate.Rows(s)(Convert.ToInt32(Strinput.ToString)).ToString).ToArray() Cheers @fairymemay

This solution provided by @ppr received 1 likes!

How to count the number of blank items in a datatable?

find starter help here: Check_dtHasBlanksInAnyCol.xaml (6.9 KB)

---

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

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

[system]

Daily Forum Report | 17 March 2022

Top 3 Topics with Most Views

How to loop Through Multi made by @Ishan_Shelke1 with 45 views.

Which regex expression pattern to use if I want to select the number after 2 words? made by @mce with 44 views.

What is the difference between Boolean ? and Boolean made by @kkpatel with 41 views.

Top 3 Topics with Most Replies

Close outlook window made by @A_Learner with 14 replies.

Compare dates and identify date formats made by @kavya.s16 with 13 replies.

Questions about dynamic selectors made by @Uddynitjh with 11 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 27 posts!

@ushu made 24 posts!

@Gokul001 made 23 posts!

Top 3 Most Liked Posts

This post made by @diana.gray received 3 likes!

The Reboot Work Festival registration is live

April 12, 2022 Register for this one day event; **“The Reboot Work Festival” ** Participate in a festival of ideas and a celebration of automation! Register now - https://festival.uipath.com/

This post made by @diana.gray received 2 likes!

Join Us - "Become an RPA Citizen Developer" - March 29th

Join Us on March 29 at 1:00 EDT, for this exclusive UiPath sponsored session with Glenn Hoorman, Executive Vice President of eAlliance. Glenn will cover the following topics: The new workforce, new work model and automation New tools and technologies to empower and engage the workforce A proven way for non-IT users to build their own automations using robotic process automation (RPA) Examples and demonstrations of RPA automations built by RPA Citizen Developers Register Here: See Become an R…

This post made by @Palaniyappan received 2 likes!

Excel Activity -- COM

Hi When you are using excel file for multiple times in short span of time within the process then there are two ways to handle this Use workbook activities instead of excel application scope and other excel activities Search as workbook and you can see same set of excel activities which actually doesn’t rely on excel application which is why you get this error on being used frequently along the process Or use multiple delay Activity and KILL PROCESS activity with ProcessName property as”Ex…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

Excel Activity -- COM

Hi When you are using excel file for multiple times in short span of time within the process then there are two ways to handle this Use workbook activities instead of excel application scope and other excel activities Search as workbook and you can see same set of excel activities which actually doesn’t rely on excel application which is why you get this error on being used frequently along the process Or use multiple delay Activity and KILL PROCESS activity with ProcessName property as”Ex…

This solution provided by @Palaniyappan received 1 likes!

Can i train my own ML models in AI Center

Hi Have a view on this document for more guidance If you are looking for out of box models Check this up for model training guidance Cheers @jack.chan

This solution provided by @ashwin.ashok received 1 likes!

Need to convert scraped string into double, the number is in German format

Hi @manjesh_kumar , Here is a sequence I have developed based on a similar thread which discusses this problem: [image] Basically, you have to play around with the CultureInfo to get what you want. In this scenario, you are dealing with Portugal Numbers, so you have to implicitly specify what the formats are before referencing the Culture Info. For that, first create a variable of type System.Globalization.CultureInfo and initialize it using this → New CultureInfo("pt-PT") Next, use two …

---

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

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

[system]

Daily Forum Report | 18 March 2022

Top 3 Topics with Most Views

Datarow throwing error made by @kavya.s16 with 43 views.

エンコード"shift_jis"はサポートされていませんというエラーの解消方法について made by @UedaKorai with 42 views.

LINQ "not in" datatable made by @ajh with 41 views.

Top 3 Topics with Most Replies

Error Job stopped with an unexpected exit code made by @fairymemay with 25 replies.

Merge column 2 column to one column? made by @fairymemay with 19 replies.

How to click on each name of web page made by @siteltower with 17 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 31 posts!

@Gokul001 made 24 posts!

@fairymemay made 21 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

Match and remove first linebreak from string

Seems like I was a little too late. Fantastic solutions by @Mr_JDavey though! I’ll just leave what I’ve found here in case you are interested: [image] System.Text.RegularExpressions.Regex.Replace(str_txtData,"(?<=^.*)\r?\n"," ") Kind Regards, Ashwin A.K

This post made by @Mr_JDavey received 2 likes!

Match and remove first linebreak from string

Hi there @Ninjabullen, I trust you are having a fantastic day! You should be able to achieve this via Strings.Replace: Strings.Replace(String, String, String, Int32, Int32, CompareMethod) Method (Microsoft.VisualBasic) | Microsoft Docs You can configure it as: YourString= Strings.Replace(YourString, VBCRLF, String.Empty, 1, 1) This will ultimately say, replace the first instance of VBCRLF in the String value. Example below: [image] Please let me know if you have any questions. Thanks …

This post made by @ppr received 2 likes!

How to write cell in a column exceeding the range A to Z

[grafik]

Top 3 Most Liked Solutions

This solution provided by @Mr_JDavey received 2 likes!

Match and remove first linebreak from string

Hi there @Ninjabullen, I trust you are having a fantastic day! You should be able to achieve this via Strings.Replace: Strings.Replace(String, String, String, Int32, Int32, CompareMethod) Method (Microsoft.VisualBasic) | Microsoft Docs You can configure it as: YourString= Strings.Replace(YourString, VBCRLF, String.Empty, 1, 1) This will ultimately say, replace the first instance of VBCRLF in the String value. Example below: [image] Please let me know if you have any questions. Thanks …

This solution provided by @ppr received 2 likes!

How to write cell in a column exceeding the range A to Z

[grafik]

This solution provided by @Steven_McKeering received 2 likes!

Which regex expression pattern to use if I want to select the number after 2 words?

Hi @mce Thank you for the Sample, the expected Output. But I think we need more information on the Pattern and any extra requirements you have. There are many talented people on the UiPath Community forums who can help with a pattern and have contributed a reply (@ppr and @Gokul001) but they need as much information as possible to make a strong pattern This information should be in the first post. 1 Minute invested in Original Post = 2+ Minutes saved later …

---

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

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

[system]

Daily Forum Report | 19 March 2022

Top 3 Topics with Most Views

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 48 views.

Read range error? made by @fairymemay with 40 views.

Combine several excel files and create pivot made by @vkrivenko with 39 views.

Top 3 Topics with Most Replies

How can I make the Instagram like button dynamic? made by @ridvanucok with 9 replies.

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 9 replies.

Read range error? made by @fairymemay with 9 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 14 posts!

@Shikhar_Tandon made 5 posts!

@fairymemay made 5 posts!

Top 3 Most Liked Posts

This post made by @Thanu_Matheesha1 received 1 likes!

Combine several excel files and create pivot

There are pre-build activities to combine excel files such as merge and to create a pivot table there is an activity called to create a pivot table. Use those pre-built activities to build your work flow

This post made by @vkrivenko received 1 likes!

Combine several excel files and create pivot

Hello, I have given several Excel files with reports. I’ve need to combine them all and create a pivot table. Please, help

This post made by @Lynx received 1 likes!

How to negate a regex?

itis works great!! thank very much @Steven_McKeering

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 1 likes!

How To Prnt Key values pairs from an dictionary

Hi @Sidney_Vogel , You could also try looping through the Keys and reference the Values using the dictionary itself For Each-> Key In in_exceldata.Keys So could you give this a try instead? [image] key+ " " + in_exceldata(key).ToString Also, I’ve changed the ArgumentType to String → [image] BlankProcess1_v1.zip (5.6 KB) Kind Regards, Ashwin A.K

This solution provided by @nikhil.girish received 1 likes!

Need to stop excel and chrome

Hi @Bhjanga_Prabhu I would recommend you to use kill process activity for both EXCEL and Chrome in start of your process Drag 2 kill process activities and in properties just mention process name as excel and Chrome Also make continue on error property as TRUE Thanks

This solution provided by @fernando_zuluaga received 1 likes!

Read range error?

Can you try converting or saving your excel to an CSV file then using the read csv file, it should work and in less time Regards

---

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

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

[system]

Daily Forum Report | 20 March 2022

Top 3 Topics with Most Views

Problems with the dynamic selector made by @appleikmek with 41 views.

AI Center not opening in Community Version of Cloud Orchestrator made by @Sainath_S1 with 30 views.

Linq Filter DataTable and rename Columns made by @NHoe with 30 views.

Top 3 Topics with Most Replies

Problems with the dynamic selector made by @appleikmek with 8 replies.

Write cell beyond a to z range in Gsuite - Google Sheets? made by @Pruthvi.G with 7 replies.

How to extract and update account number if account code from code column foun made by @Mansi_Mhatre with 7 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 10 posts!

@ashwin.ashok made 6 posts!

@appleikmek made 5 posts!

Top 3 Most Liked Posts

This post made by @Steven_McKeering received 1 likes!

How to do conditional "or" in regex?

Hi @Lynx The pipe symbol “|” represents Or in Regex. Take a look at this Regex Pattern I have created for you. [image] I have used an achor on the text “OP. GRAVADA” and then inserted some brackets which will find either “S/” or “$” (note that “$” must be escaped “\$” like this to mean it literally instead of the end of a line). Just be aware that Regex101.com is great for learning and for ‘basic’ Regex Patterns but I strongly recommend using RegexStorm as it is 100% compatible with UiPath …

This post made by @Lynx received 1 likes!

How to do conditional "or" in regex?

Thanks a lot @Steven_McKeering

This post made by @ridvanucok received 1 likes!

How to Scan QR code in scanned pdf's

@adarsh_kotagiri I can’t share it because it’s a workflow I made for a company. However, if I am available during the day, I can create an external workflow and share it with you.

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 1 likes!

How to do conditional "or" in regex?

Hi @Lynx The pipe symbol “|” represents Or in Regex. Take a look at this Regex Pattern I have created for you. [image] I have used an achor on the text “OP. GRAVADA” and then inserted some brackets which will find either “S/” or “$” (note that “$” must be escaped “\$” like this to mean it literally instead of the end of a line). Just be aware that Regex101.com is great for learning and for ‘basic’ Regex Patterns but I strongly recommend using RegexStorm as it is 100% compatible with UiPath …

This solution provided by @nice-guy received 1 likes!

データスクレイピング時の型変換エラー

Yoichi さん、回答ありがとうございました。別スレットを立てて質問しますので、よろしくお願いします。

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

Filter column by condition?

Use my sequence for reference TestA.xaml (13.0 KB) read config and input to configDt and inputDt datatables [image] loop configDt, in each iteration, filter input Dt so that APAPDT >=APAPDT1 and <= APAPDT2 and output filtered table to filterdDt write filteredDt to FileName.xlsx [image] Result Report1.xlsx [image] Report2.xlsx [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 | 21 March 2022

Top 3 Topics with Most Views

Copy specific column from one excel to another excel last row with specific column made by @mashy2 with 44 views.

How to get Particular file From directory made by @Anand_Designer with 44 views.

"SMTP Mail" fails on one computer and works on another made by @Aguirre with 44 views.

Top 3 Topics with Most Replies

How to get Particular file From directory made by @Anand_Designer with 17 replies.

Assign: An item with the same key has already been added made by @Sirisha_Siri with 16 replies.

Unable to Scrap the text using Matches Activity made by @Omkar_Deshmukh with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@ppr made 28 posts!

@ashwin.ashok made 23 posts!

Top 3 Most Liked Posts

This post made by @Debakanta_Mahanta received 2 likes!

Combo-Dropdown - Web Automation

Hi Swapnil, You can directly navigate to the url assigned to Ruling by MahaRERA href=“https://maharerait.mahaonline.gov.in/searchlist/SearchJudgements?MenuID=1072” [image] Thank you Debakanta

This post made by @ashwin.ashok received 2 likes!

Change picture/icon in Assistant

Hi @Timsener , It looks like its still a work in progress as detailed in this thread by UiPath → Kind Regards, Ashwin A.K

This post made by @ashwin.ashok received 2 likes!

Write cell beyond a to z range in Gsuite - Google Sheets?

Hi @Pruthvi.G , I understand that, but you wanted the range, correct? This snippet of code with allow you to compute the range, which you can them pass into the range like so → [image] UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(32) + int_index.ToString Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 2 likes!

Change picture/icon in Assistant

Hi @Timsener , It looks like its still a work in progress as detailed in this thread by UiPath → Kind Regards, Ashwin A.K

This solution provided by @ppr received 2 likes!

Regex or String manipulation needed in order to insert a new line before a value

[grafik] (\d+ [\d\/]{10})

This solution provided by @Yoichi received 1 likes!

Remove Odd items from Array

Hi, Hope the following helps you. Remove even: arrVar = arrVar.Where(Function(x,i) i mod 2 =1).ToArray() Remove odd: arrVar = arrVar.Where(Function(x,i) i mod 2 =0).ToArray() 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 | 22 March 2022

Top 3 Topics with Most Views

How to train same custom DU model multiple times? made by @shrey.shah with 50 views.

How to copy sheet from Excel to another with a new sheet name made by @Archie with 50 views.

Problems with selectors made by @Pavel_Shlykevich with 46 views.

Top 3 Topics with Most Replies

How to copy sheet from Excel to another with a new sheet name made by @Archie with 21 replies.

How to add date in google forms throgh excel sheet? made by @guptasweb with 20 replies.

Get date value as a string made by @Pradumn_Chavan with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 43 posts!

@fernando_zuluaga made 27 posts!

@ppr made 25 posts!

Top 3 Most Liked Posts

This post made by @Tuan_Nguyen1 received 2 likes!

Performance Desktop Triggers

Thanks, this is very helpful. I’ll take a look and discuss what we can do with the team.

This post made by @nikhil.girish received 2 likes!

Type into letters skipping

Hi @Rahul_54 We have a property called delay between keys So kindly use this property where set it 200 ms Note :Adjust as per your website behaviour Thanks

This post made by @ashwin.ashok received 2 likes!

Add amounts Found using Regex

Hi @spemur01 , There are two way to sum up the values, and I have detailed both in this workflow. Please have a look and let me know if it is as expected. Single Step → [image] matches.Cast(Of Match).Sum(Function(s) Convert.ToDouble(s.ToString.Replace(",",""))) Using For Each ->(TypeArgument: System.Text.RegularExpressions.Match) [image] doub_sumLoop= doub_sumLoop+Convert.ToDouble(match.ToString.Replace(",","")) MatchandSum.xaml (7.1 KB) Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 2 likes!

Type into letters skipping

Hi @Rahul_54 We have a property called delay between keys So kindly use this property where set it 200 ms Note :Adjust as per your website behaviour Thanks

This solution provided by @ashwin.ashok received 2 likes!

Add amounts Found using Regex

Hi @spemur01 , There are two way to sum up the values, and I have detailed both in this workflow. Please have a look and let me know if it is as expected. Single Step → [image] matches.Cast(Of Match).Sum(Function(s) Convert.ToDouble(s.ToString.Replace(",",""))) Using For Each ->(TypeArgument: System.Text.RegularExpressions.Match) [image] doub_sumLoop= doub_sumLoop+Convert.ToDouble(match.ToString.Replace(",","")) MatchandSum.xaml (7.1 KB) Kind Regards, Ashwin A.K

This solution provided by @supermanPunch received 1 likes!

Combo-Dropdown - Web Automation

Hi @Swapnil_Pawar , We should be able to Hover over the Dropdowns and Click the "Rulings By MahaRERA" option. Hover over Downloads, then Hover Over Maharashtra and Perform a Click on Rulings By MahaRERA Check the Below Workflow and Let us know if it doesn’t work : Dropdown_Click.xaml (14.3 KB)

---

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

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

[system]

Daily Forum Report | 23 March 2022

Top 3 Topics with Most Views

LINQ query for filtering made by @A_Learner with 57 views.

Needed Uipath Activities for Text document(Notepad) made by @arunprasanth_m with 51 views.

Using Refresh Browser in a Loop until Element appears made by @djkmod83 with 47 views.

Top 3 Topics with Most Replies

Send hotkey is not supporting, while trying to scroll down in excel made by @shuklarchana001 with 24 replies.

Not able to use Type Into and Set Text activity to fill out a web form made by @harmeet_kaur with 20 replies.

Specific Text Extraction from SAP Page made by @Tarif_Mohammad with 18 replies.

Top 3 Users Who Posted The Most

@ppr made 28 posts!

@fernando_zuluaga made 27 posts!

@postwick made 26 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

How to automate in a survey a number of answers for option 1 and another number of answers for option 2? (it also contains multiple answers to be checked)

Hi @robertcostache , Could You Explain what do you mean by these Percentages? Is it the Percentage of times the Option is Selected out of 900 times ?

This post made by @THIRU_NANI received 2 likes!

Assistant is not working

Hi! delete the json folder in the file explorer and run the studio again! Regards, Nani

This post made by @suraj.setty received 2 likes!

How to train same custom DU model multiple times?

Hi @shrey.shah I would suggest to follow the document as per the best practice , I think my method may not work every time. You can select the Minor version as 0 as suggested in the article. Thanks .

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to make a replace in a string irrespective of string length?

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=^.{6}).*(?=.{4}$)",Function(m) New String("X"c, m.Value.Length)) Regards,

This solution provided by @Jeroen_van_Loon received 1 likes!

How to write a if statement based on percentage

Your if then else reults are swithced around. You state if resultstwo > 0,8 then writeline less than 80. > means greater then… so switch the then and else sub-sequences around and you have it correct.

This solution provided by @Gokul001 received 1 likes!

Needed Uipath Activities for Text document(Notepad)

I n this workflow, Just update the date in the Type Into Activity DateTime.Now.ToString("yyyyMMdd") DateTime.Now.AddDays(-1).ToString("yyyyMMdd") [image] Regards Gokul

---

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

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

[system]

Daily Forum Report | 24 March 2022

Top 3 Topics with Most Views

Yang Miss,请赐教 made by @bigpeng with 54 views.

Unable to browser attach in ForEachRow made by @SJJ with 47 views.

How to append the data into excel using Add Data row activity made by @mayankjha986 with 46 views.

Top 3 Topics with Most Replies

Find exact Match and replace the tex file made by @Shagoul_Hameed with 17 replies.

Yang Miss,请赐教 made by @bigpeng with 16 replies.

How to append the data into excel using Add Data row activity made by @mayankjha986 with 15 replies.

Top 3 Users Who Posted The Most

@ushu made 33 posts!

@fernando_zuluaga made 31 posts!

@Gokul001 made 25 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

Copying from one list to another

Hi @Igor_Wolny , Here is another way to approach the problem. I hope it gets you thinking in creative ways → lst_masterSet = New List(Of String) From {"Ai123", "Ai243", "Bi344", "Bi3443", "Ci24244", "Ci48484"} lst_searchCriterias = lst_masterSet.Select(Function(s) s.Substring(0,2)).Distinct().ToList() dict_items = lst_searchCriterias.ToDictionary(Function(k) k, Function(v) lst_masterSet.Where(Function(w) w.StartsWith(v)).ToList()) ListExercise.xaml (5.9 KB) Kind Regards, Ashwin A.K

This post made by @JFletch100 received 1 likes!

How to set execution target for 'Queue' trigger type?

Is there a fix for this issue or are they hoping that by ignoring it, the issue will go away?

This post made by @andrewjames received 1 likes!

Bug Report - System.Activities.statements.Assign activity throws Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)

I had the same issue today with a multiple assign in 2021.10.5 To fix it I opened the XAML into notepad, and changed the “object” references to “string” and this fixed the issue. Unfortunately I can’t remember the steps I used when creating the multiple assign.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How to convert Json to data table

Hi @red_yan Welcome to community Look into the documentation Regards Gokul

This solution provided by @ppr received 1 likes!

V2.11.4 excel process scope

[grafik] And with index [grafik]

This solution provided by @postwick received 1 likes!

Copying from one list to another

Use Debug instead of Run. Then right-click your activities and set breakpoints. It’ll pause at each breakpoint and then you can look at the debug panels on the left to see the realtime values of each variable/list.

---

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.