Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 May 2022

Top 3 Topics with Most Views

Update column based on pattern made by @Harbansh_Singh with 45 views.

Excel filling made by @alexis.mendoza with 39 views.

「拡張機能を有効化する必要がある」というエラーが出る made by @sakurako_iwado with 37 views.

Top 3 Topics with Most Replies

Time Conversion Issue in Linq made by @Shyam_Pragash with 21 replies.

What kind of scraping method will work in remote desktop SQL application? made by @BlackCurrant with 20 replies.

How to select this one made by @meeraa with 19 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 64 posts!

@postwick made 34 posts!

@Nithinkrishna made 33 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Trim the string

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"\d{8}\..+$").Value Regards,

This post made by @Iulian_Marin received 2 likes!

UiPath Chrome Manifest V3 Extension Released with 2022.4 Update

UiPath Chrome Manifest V3 Extension Released with 22.4 Update Context The adoption of Manifest V3 represents one of the biggest shifts in the Google Chrome extensions platform since it launched a decade ago. Extensions using Manifest V3 will enjoy enhancements in security, privacy, and performance. The new UiPath Chrome MV3 extension We’ve implemented a completely new extension following the Manifest V3 standard released by Google. This new extension can be installed from both Studio ->Tools…

This post made by @cheez_RPA received 2 likes!

「拡張機能を有効化する必要がある」というエラーが出る

いちど、UiPathの画面からアンインストールのうえ、再インストールをしてみてください。

Top 3 Most Liked Solutions

This solution provided by @william.coulson received 1 likes!

Trim the string

Hi @happyfeat87, Try using Regex to get that item out, and then replace it with nothing: In an assign: RegexItem = In a seperate assign: Filepath = Filepath.Replace(RegexItem,"") If RegexItem is “20220511.zip”, then replacing it with nothing should give you the expected filepath. Edit: Though, if you already have the filepath, you won’t need to manipulate it? You’re already referring to it: Just assign everything before the first & to a variable.

This solution provided by @ppr received 1 likes!

Find "&" mark

please let us know when YourString.Contains(“&”) is not working for your scenario

This solution provided by @Yoichi received 1 likes!

Split string with decimal places

Hi, I don’t think it’s correct regex pattern. Does this work? If you want to extract decimal number:1000, the following will work. (?<=EB\*C\*IND\*30\*\*\*23\*)[.\d]+(?=\*+Y) Regards,

---

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

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

[system]

Daily Forum Report | 12 May 2022

Top 3 Topics with Most Views

How to connect orchestrator with a robot and deploy it made by @Sawaira_Nawaz with 37 views.

How to Check if PopUp Selector exists made by @VanjaV with 35 views.

Methods used to deploy nugets from dev environment to prod environment? made by @ydash999 with 33 views.

Top 3 Topics with Most Replies

Print excel file format country code and iban number separately made by @ertan_ay1 with 18 replies.

Methods used to deploy nugets from dev environment to prod environment? made by @ydash999 with 14 replies.

Invoke java method and pass two arguments from uipath made by @sowmya.krishna with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 56 posts!

@ppr made 20 posts!

@Nithinkrishna made 20 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

UiPath Chrome Manifest V3 Extension Released with 2022.4 Update

Hello @Iulian_Marin, These mitigation options are great to know as we are planning to upgrade our instances. Out ot curiosity Does the new extension provide additional benefits ( other than the official support period from Google) ? For others wondering how to get around this behaviour: @Werve and @Mike_Campbell have proposed a working workaround in this thread : Chrome extension malfunction after auto-update to 22.4 - Help / Studio - UiPath Community Forum

This post made by @ppr received 2 likes!

Error in Add Data Row Activity

Lets assume project is set to C#: can your try: new object[]{"test"}; kindly note the closing ;

This post made by @amithvs received 1 likes!

SFTP authentication

Hey @loginerror . Sorry for the late reply. During the time of issue UiPath support provided me with a custom SFTP package with the fix. The team confirmed it is a known issue with the SFTP package and will be resolved by next update. I haven’t tried it after the update, hopefully it’s fixed.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Error in Add Data Row Activity

Lets assume project is set to C#: can your try: new object[]{"test"}; kindly note the closing ;

This solution provided by @HarishV received 1 likes!

Add Queue Item using API

Hi @john.mari, Please verify the below mentioned format. "{""itemData"": {""Name"": ""Value1"",""Priority"": ""Value2"",""SpecificContent"": {""Data"": ""[{\""Key3\"":\""Test\"",\""Key4\"":\""TES8\"",\""Key5\"":\""Test\"",\""Key6\"":\""1234Street\""}]""}}}" Try this in the “Body” parameter of “HttpRequest” activity. Thanks

This solution provided by @Sam_Abraham received 1 likes!

How to give timeout of 40 mins in integer bcz it's giving issue while running the code? Urgent plz help

Hi @anjasing , It seems there is an additional space comming after "2400000 " . You can use trim cint(in_Config(“TimeoutUltraLongest”).ToString.trim)

---

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

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

[system]

Daily Forum Report | 13 May 2022

Top 3 Topics with Most Views

Document is invalid- Unable to open the Workflow file made by @Dhanush_Naik1 with 48 views.

Input string was not in correct format for NULL value in queue made by @Sathish_Kumar_S with 43 views.

Help me to solve made by @mu_nazza with 37 views.

Top 3 Topics with Most Replies

Create Pivot table in different sheet of same excel made by @Riya1 with 21 replies.

Document is invalid- Unable to open the Workflow file made by @Dhanush_Naik1 with 19 replies.

Filtrado excel made by @alexis.mendoza with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 74 posts!

@jack.chan made 23 posts!

@supermanPunch made 20 posts!

Top 3 Most Liked Posts

This post made by @Nithinkrishna received 2 likes!

Input string was not in correct format for NULL value in queue

Hey @Sathish_Kumar_S I’m assuming technology variable is holding the value either 80 or empty Just reverse the condition, String.IsNullOrEmpty(TechnologyVar) orElse CInt(TechnologyVar) >= 80 Hope this helps Thanks #nK

This post made by @whitestar received 1 likes!

Latest UiPath System/UiAutomation activities Issues

Hi @loginerror We are still using version 21.10.4 for our chrome extension . So it could be why some of the selector are not working anymore with older package version. Before even if we downgrade the packages version we are still able to use the activities at least until version 2021.10 packages. I will discuss together with technical support for this issue as well. Thank You

This post made by @Razvan_Dumitru received 1 likes!

Postman, Swagger showing You are not authenticated!

@Nithinkrishna Swagger Authorize button is tightly coupled with cookie to access token based authentication migration. This feature is currently in rollout phase and it will be available to all users next week.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Input string was not in correct format for NULL value in queue

Hey @Sathish_Kumar_S I’m assuming technology variable is holding the value either 80 or empty Just reverse the condition, String.IsNullOrEmpty(TechnologyVar) orElse CInt(TechnologyVar) >= 80 Hope this helps Thanks #nK

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

<Urgent> How to make a selector a variable so that it can only click on the particular date value only?

can you filter your datatable so that its only yesterdays date first? [image] do you have screenshot of what youre trying to click/?

This solution provided by @ashwini.kempraj received 1 likes!

Installing Studio on VM machines

Hi @OzogRPA, You can install uipath community version on many VMs as required. But community version has limited number of licenses - only 3 robots. Hope this helps. Thanks Ashwini Kempraj

---

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

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

[system]

Daily Forum Report | 14 May 2022

Top 3 Topics with Most Views

Option to resize the component JSON window in form designer made by @jeevith with 59 views.

Get Data before special character made by @Abang_Jamuri_Abang_Shoker with 34 views.

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName made by @Sathish_Kumar_S with 33 views.

Top 3 Topics with Most Replies

How to know if queue items are present using studio made by @ydash999 with 10 replies.

HELP PLEASE. Facing a problem with Column “qty” does not belong to table datatable made by @Kai_Xin_Kho with 9 replies.

Run query: ORA-00936: missing expression made by @sushantchanakhekar2299 with 8 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 16 posts!

@Rahul_Unnikrishnan made 15 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @Smars received 3 likes!

How to know if queue items are present using studio

“Get Queue Item” is a suitable activity, see the following link for more information:

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

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName

@Sathish_Kumar_S Main.xaml (8.8 KB) define attachmentList variable [image] [image] if not string.IsNullOrEmpty(in_Attachment) then assign attachmentList = in_Attachment.Split(","c).ToList [image] pass attachment list to send outlook mail message attachmentsCollection property [image]

This post made by @Rahul_Unnikrishnan received 2 likes!

HELP PLEASE. Facing a problem with Column “qty” does not belong to table datatable

Hello @Kai_Xin_Kho If your column name is not working you can use the column index to read the data from that particular column Like Currentrow(0).Tostring will read data from the first column. Also it would be better if you can share the screenshot of the excel which you are reading. If you are using column name, then inside the Read Range activity you have to enable “Add Headers” in the property panel. Also make sure “Qty” is a valid column name in that excel.

Top 3 Most Liked Solutions

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

Send Exchange Mail Message: Value cannot be null. Parameter name: fileName

@Sathish_Kumar_S Main.xaml (8.8 KB) define attachmentList variable [image] [image] if not string.IsNullOrEmpty(in_Attachment) then assign attachmentList = in_Attachment.Split(","c).ToList [image] pass attachment list to send outlook mail message attachmentsCollection property [image]

This solution provided by @Yoichi received 1 likes!

Get Data before special character

Hi, FYI, another solution [image] Sample20220514-1.zip (2.4 KB) Regards,

---

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

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

[system]

Daily Forum Report | 15 May 2022

Top 3 Topics with Most Views

How to automate copy selection from body from email to excel file? made by @Wilich with 39 views.

How Can i Select the particular option from menu in Notepad using Click Activity? made by @kishan.savaliya with 33 views.

How to be a junior RPA? made by @esraa_elzoghby with 33 views.

Top 3 Topics with Most Replies

Make this C# code usable in UiPath made by @Dhruvi_Arumugam with 11 replies.

Is there a way to add a Trigger button in the Tableau dashboard to launch the robot to export the dashboard pdf format? made by @Sumit_Yadav_30 with 7 replies.

Why it is showing "studio has detected that your license information is changed" below uipath studio made by @opkushwaha999 with 6 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 31 posts!

@Nithinkrishna made 7 posts!

@Riya1 made 7 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

How to know if queue items are present using studio

Hi @ydash999 and @Divyashreem, Avoid Get Transaction Item if you are only checking for existence of queue items Do not use the Get Transaction Item to check if there are queue items if you are not going to process them at the same time. Get Transaction Item will lock the item to in-progress in the queue. So it tells you there are items, but it can also remove one item from processing and edit its state. Get Queue Items is a safer activity for such checks If you want to check the queue has it…

This post made by @Rahul_Unnikrishnan received 2 likes!

How to wait till process is going on

Hello, Is it resolved?? Else can you give more insight to the requirement.

This post made by @Rahul_Unnikrishnan received 2 likes!

Why to use bulk insert activity that is coming with new database. activities?

Hello @ydash999 Bulk insert can be useful if you have a Datatable to insert into database. So just consider you are getting some values from the web page and you need to insert that to database. One approach is you can Insert to DB in each Iteration using Insert activity. So for each iteraction Uipath will call DB to insert data. But if you are looping and collecting data from webpage and inserting that to a data table. And once all the data get added to the data table you can use Bulk insert…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 3 likes!

How to know if queue items are present using studio

Hi @ydash999 and @Divyashreem, Avoid Get Transaction Item if you are only checking for existence of queue items Do not use the Get Transaction Item to check if there are queue items if you are not going to process them at the same time. Get Transaction Item will lock the item to in-progress in the queue. So it tells you there are items, but it can also remove one item from processing and edit its state. Get Queue Items is a safer activity for such checks If you want to check the queue has it…

This solution provided by @Rahul_Unnikrishnan received 2 likes!

Why to use bulk insert activity that is coming with new database. activities?

Hello @ydash999 Bulk insert can be useful if you have a Datatable to insert into database. So just consider you are getting some values from the web page and you need to insert that to database. One approach is you can Insert to DB in each Iteration using Insert activity. So for each iteraction Uipath will call DB to insert data. But if you are looping and collecting data from webpage and inserting that to a data table. And once all the data get added to the data table you can use Bulk insert…

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

How Can i Select the particular option from menu in Notepad using Click Activity?

@kishan.savaliya refer to this Main.xaml (8.7 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 | 16 May 2022

Top 3 Topics with Most Views

Get Largest number out of Array of Strings made by @esakkiappan.b with 53 views.

Delete Lines Text File Issue made by @Abang_Jamuri_Abang_Shoker with 50 views.

How to count the number of leaves,weekends and holidays in a month based on the bot running month made by @Chippy_Kolot with 46 views.

Top 3 Topics with Most Replies

Delete Lines Text File Issue made by @Abang_Jamuri_Abang_Shoker with 11 replies.

Wait Element Vanish Activity is not working Properly made by @kishan.savaliya with 11 replies.

Dependencies Error made by @leandro.medeiros with 10 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 48 posts!

@ppr made 25 posts!

@ashwini.kempraj made 24 posts!

Top 3 Most Liked Posts

This post made by @Jon_G received 2 likes!

Page doesn't load until connect to VM

I found the solution to my own problem. Hope this helps others. in Chrome go to chrome://flags and go to ‘Calculate window occlusion on Windows’ and Disable it from the dropdown box. Relaunch chrome, and it will work. The issue was that with this setting enabled, sometimes Chrome is waiting for the window to be manually ‘focused’ before loading the full page contents. This was causing issues with UiPath for this URL I was trying to navigate as a background process. Hope this hel…

This post made by @ashwini.kempraj received 1 likes!

Update data table coloum with linq

Hi @Harbansh_Singh, From that code snippet, (row(“Col2”).Tostring).Equals(“dummy”) is a condition that returns true or false. Hence it’s updating the boolean value. You may try this: (From row in dttest Let x = new object (){row(“Col1”).Tostring, “dummy”)} Select dtoutput.rows.add(x)). copytodatatable Hope this helps. Thanks, Ashwini Kempraj

This post made by @Harbansh_Singh received 1 likes!

Update data table coloum with linq

@supermanPunch Yes its worked now, instead of col2 in need to give the value which i need to update. Thanks for your explanation

Top 3 Most Liked Solutions

This solution provided by @Jon_G received 2 likes!

Page doesn't load until connect to VM

I found the solution to my own problem. Hope this helps others. in Chrome go to chrome://flags and go to ‘Calculate window occlusion on Windows’ and Disable it from the dropdown box. Relaunch chrome, and it will work. The issue was that with this setting enabled, sometimes Chrome is waiting for the window to be manually ‘focused’ before loading the full page contents. This was causing issues with UiPath for this URL I was trying to navigate as a background process. Hope this hel…

This solution provided by @ashwini.kempraj received 1 likes!

Update data table coloum with linq

Hi @Harbansh_Singh, From that code snippet, (row(“Col2”).Tostring).Equals(“dummy”) is a condition that returns true or false. Hence it’s updating the boolean value. You may try this: (From row in dttest Let x = new object (){row(“Col1”).Tostring, “dummy”)} Select dtoutput.rows.add(x)). copytodatatable Hope this helps. Thanks, Ashwini Kempraj

This solution provided by @Yoichi received 1 likes!

Remove default tittle on charts

Hi, Can you try UpdateChart activity as the following? [image] 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 | 18 May 2022

Top 3 Topics with Most Views

Can Not Type Text in Text Box of Website made by @SimonS with 43 views.

Comparing 2 columns and i am new to automation please give me the full solution made by @sunil.kumar.s.v with 39 views.

Extract data from RegEx and output to csv file made by @John133 with 38 views.

Top 3 Topics with Most Replies

Comparing 2 columns and i am new to automation please give me the full solution made by @sunil.kumar.s.v with 17 replies.

Create pivot table by choosing rows and columns made by @Riya_Sharma with 15 replies.

Persistance must be configured error made by @Andrei_Croitoru with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 51 posts!

@ppr made 44 posts!

@lakshman made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Generic value and object diff

Have a first look here: https://docs.uipath.com/studio/docs/types-of-variables

This post made by @ppr received 2 likes!

How to find the string wont contain particular string

Maybe you are in a hurry, but we would also appreciate it if you close answered topics. Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum We do see the list and also that very quickly new topics are opened. Thanks for support

This post made by @ppr received 2 likes!

Selecting items from drop down menu

lets assume following: indicate item failed with … not supported click on 1 [grafik] replace line [grafik] Save and test

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Selecting items from drop down menu

lets assume following: indicate item failed with … not supported click on 1 [grafik] replace line [grafik] Save and test

This solution provided by @Yoichi received 1 likes!

文字列を1つ目のハイフンで分割したいです

こんにちは ご参考までに別解です。 テキストを左右に分割アクティビティも使えると思います。 [image]

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

Unable to find enviroment feature in orchestrator

you can think of folders as environments configure folders in tenant-> folder. You can create folders by clicking [image] here i have 3 folders uat/PRD/shared . They act the same way as environments in classic folders [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 | 19 May 2022

Top 3 Topics with Most Views

Type conversion exception problem made by @Priyanka_Jharia with 41 views.

Getting error while trying to get distinct values from database table and covnert to Array made by @MitheshBolla with 38 views.

While Working on Excel Sheet I am getting time also along with Date , How to remove it? made by @Kunal_Jain with 37 views.

Top 3 Topics with Most Replies

While Working on Excel Sheet I am getting time also along with Date , How to remove it? made by @Kunal_Jain with 26 replies.

Retrieve information from an email made by @DimitriLYR with 20 replies.

Getting error while trying to get distinct values from database table and covnert to Array made by @MitheshBolla with 19 replies.

Top 3 Users Who Posted The Most

@postwick made 49 posts!

@Rahul_Unnikrishnan made 31 posts!

@muhammedyuzuak made 31 posts!

Top 3 Most Liked Posts

This post made by @ydash999 received 2 likes!

Split string and keep each character in a datatable

in column separator i only saw the given characters, i didnt try inputing the “-”, so was confused. now solved. thanks bro!

This post made by @ppr received 2 likes!

Getting error while trying to get distinct values from database table and covnert to Array

@MitheshBolla Perfect, it is working May I ask you to flag @supermanPunch for the solution. He supported you and gave you the required hint at first. Thanks

This post made by @supermanPunch received 2 likes!

Error running from orchestrator: Failed to install package. Unable to find package

Hi @jack.chan , Have you Checked the Below Post :

Top 3 Most Liked Solutions

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

Need to copy a particular excel to destination

assign filesArray (Array of string variable) = Directory.GetFiles(folderPath) assign oldestFile (string variable) = filesArray.AsEnumerable().Where(function(file) Datetime.TryParseExact(path.GetFileNameWithoutExtension(file), "dd-MMM-yyyy",nothing, nothing, nothing)).ToArray.AsEnumerable().OrderBy(function(x) cdate(Path.GetFileNameWithoutExtension(x))).first [image]

This solution provided by @supermanPunch received 1 likes!

Split string and keep each character in a datatable

Hi @ydash999 , Maybe you could also Check with Generate Datatable Activity. [image]

This solution provided by @supermanPunch received 1 likes!

Getting error while trying to get distinct values from database table and covnert to Array

Hi @MitheshBolla , Have you tried following the Steps in the Below Post : Also, Do Check if System.Linq is imported in your xaml first by checking in the imports section.

---

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

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

[system]

Daily Forum Report | 20 May 2022

Top 3 Topics with Most Views

How to divide the 2 datatables from one sheet to different sheet made by @bhanupriya.cb with 45 views.

Comparing two excel columns and updating corresponding values made by @praveenchintu374 with 43 views.

How to Use Element Exists and Excel Application Scope In parallel, for Excels with Pop-up Macro made by @Archie with 43 views.

Top 3 Topics with Most Replies

Compare two datatables and get unique value from dt1 made by @Sahil_Garg1 with 19 replies.

How to divide the 2 datatables from one sheet to different sheet made by @bhanupriya.cb with 18 replies.

Problem with Send Hotkey made by @comdatos with 13 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 52 posts!

@muhammedyuzuak made 28 posts!

@ppr made 20 posts!

Top 3 Most Liked Posts

This post made by @Praga_Vivek received 2 likes!

UiPath Forms Tutorial - Check / Uncheck All Select Boxes

Hi, Recently, I came across a customer requirement where we need to check / uncheck all select boxes in an UiPath form. I am able to come up with a working solution after doing some R&D. I wanted to share the solution for the benefit of others. Below are the steps to build Check/Uncheck All option for select boxes in an UiPath form. Create a form and add a Select box and Button component Add few values to the select boxes and rename the button component like below [formDesign] Edit t…

This post made by @joergen_moeller received 2 likes!

How to learn c#

Hi @Aleem_Khan, There are many tutorials online for C#. Keep in mind that the default language for UiPath processes are VB, because of this a majority of the documentation and syntax shared on the forums are VB. However, I believe a more advanced knowledge in C# will help you regardless as you will develop a broader understanding of the possibilities with C# and .Net. If you want advanced examples on working with Excel in UiPath you can check out this link: For a general approach to C# you c…

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

Click into Details for SAP VA01 Create Sales Order

@jmcheong7 theres a tableRow attribute in the selector [image] 0= 1st row, 1 = second row and so on… you can make it dynamic by using an integer variable e.g. [image] then update tableRow attribute in selector to this tableRow='{{tableRow}}'

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

Save subfolder name to variable

@Jack_Seven_Offsuit You can try as below to get all the folders in the path Declare a String variable let’s say as ListofFolders Use Assign activity and write as below ListofFolders = Directory.GetDirectories(“C:\users\00001”) Use For Each activity and change the TypeArgument to String in properties Inside For Each you can keep a write line message and write as Item.ToString which will give you the all the each directory it contains Hope this may help you Thanks

This solution provided by @Praga_Vivek received 1 likes!

Select all checkbox UiPath.Forms.Activities

Hi @Stephanie_Rimel / @jeevith , This can be implemented using advanced logic. Please find the attached project containing a working example. Sample Project.zip (14.1 KB) I have also created a tutorial for this feature Thanks, Praga

This solution provided by @Yoichi received 1 likes!

What I need to fill for Spreadsheet?

Hi, Can you try Spreadsheet as the following? [image] 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 | 21 May 2022

Top 3 Topics with Most Views

Linq to math round 3 decimals column of string made by @dyuonn.bakker with 41 views.

Cron Expression- Unattended Bot made by @Konda_Sai_Charan_Goud with 38 views.

How to read multiple invoices in subfolders made by @Poojitha with 34 views.

Top 3 Topics with Most Replies

How to read multiple invoices in subfolders made by @Poojitha with 8 replies.

Automated triggering of flows to decrease time gaps made by @saurabhB with 8 replies.

Linq to math round 3 decimals column of string made by @dyuonn.bakker with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 32 posts!

@Rahul_Unnikrishnan made 27 posts!

@muhammedyuzuak made 10 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

How to learn c#

Hi VB.NET CODING IN UIPATH.pdf (4.1 MB) Check this doc with all basic and advanced coding knowledge that is required to implement with UiPath Cheers @Aleem_Khan

This post made by @Palaniyappan received 2 likes!

How to read only specific row from Pivot table and write in another workbook-Sheet1?

Hi We can use GET TABLE RANGE activity where mention the range of table or row and enable Is Pivot Have a view on this for more details Cheers @Prabin_Chand

This post made by @Palaniyappan received 2 likes!

Linq to math round 3 decimals column of string

Hi Hope this expression in assign activity would help you resolve this dtData = (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) Convert.ToDecimal(x.ToString.Trim).ToString(“F3”)).toArray() Select dtCorrected.Rows.Add(ra)).CopyToDataTable() Or dtData = (From r In dtData.AsEnumerable let ra = r.ItemArray.Select(Function (x) Math.Round(Convert.ToDecimal(x.ToString.Trim),3)).toArray() Select dtCorrected.Rows.Add(ra)).CopyToDataTable() Cheers @dyuonn.bakker

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

How to learn c#

Hi VB.NET CODING IN UIPATH.pdf (4.1 MB) Check this doc with all basic and advanced coding knowledge that is required to implement with UiPath Cheers @Aleem_Khan

This solution provided by @Palaniyappan received 1 likes!

Create time trigger with two timings to run the job

Hi Welcome to UiPath forum To be very simple create two normal schedules One for 8:00 and another 7:30 Let’s not complicate with cron expression here Just two triggers with two timings As simple as that Even if you want to create two schedules with CRON Then for 8:00 AM 0 0 8 ? * * * For 7:30 PM 0 30 19 ? * * * Anyhow it requires two different schedules So rather create with simple schedule Cheers @NavyaKattikireddy

This solution provided by @joergen_moeller received 1 likes!

Issue with replacing value of XML element attribute

Thank you, @Rahul_Unnikrishnan. By reading the last thread you posted I understood that you do not need to specify the schemeID within the namespace. Only refering to EndpointID is sufficient. For anyone that may experience this issue the solution is to exclude the scheme ID within the element name: DeserializedXML.Element(NsCatalogue+"Catalogue").Element(NsCac+"ContractorCustomerParty").Element(NsCac+"Party").Element(NsCbc+"EndpointID").Value

---

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

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

[system]

Daily Forum Report | 22 May 2022

Top 3 Topics with Most Views

Get similar data repeatedly in loop from within pdf file made by @Rimsha_Aizaz1 with 42 views.

Convert PDF to Excel format made by @dev_rpa with 37 views.

Cannot send email from gmail account to outlook account made by @emshihab with 36 views.

Top 3 Topics with Most Replies

How to open a Excel with a pop up msgbox? made by @JP_Chang with 11 replies.

Assignment 2 - Generate Yearly Report - The robot working fine and produces the required results-Submitted several times but the grade shows Failed made by @Sevuga_Perumal with 9 replies.

Get similar data repeatedly in loop from within pdf file made by @Rimsha_Aizaz1 with 9 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 19 posts!

@Palaniyappan made 16 posts!

@muhammedyuzuak made 16 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

How to store file names in a UiPath list variable

[grafik]

This post made by @anandji05 received 1 likes!

Hand Written Data Extraction

@opkushwaha999 You can use ABBYY Flexi Capture. This is a rich OCR tool. But it is paid. You can also integrate it with UiPath. Regards Anand

This post made by @muhammedyuzuak received 1 likes!

Assistant sign in localhost refused to connect

Hi @Pedro_Tibiletti, Go to the default web browser, clear all cookies and try again. Regards, MY

Top 3 Most Liked Solutions

This solution provided by @muhammedyuzuak received 1 likes!

Assistant sign in localhost refused to connect

Hi @Pedro_Tibiletti, Go to the default web browser, clear all cookies and try again. Regards, MY

This solution provided by @Palaniyappan received 1 likes!

How to check if a string is contains english word

Hi Hope the below steps would help you resolve this Let’s take you have a Datatable read from excel and named as dt Now use a FOR EACH ROW ACTIVITY and pass dt as input Inside that activity use a Assign activity like this str_matches = System.Text.RegularExpressions.Regex.Matches(yourRowValueString,“[a-zA-Z]+”) This will give you a list of Match objects ( IEnumerable<Match> ), let’s call it matches , with one element. Let’s call this first match match , so match = matches.FirstAnd …

This solution provided by @Palaniyappan received 1 likes!

Question regarding extracting a portion of a string

Hi There are two ways to do this Let us consider with what you have done already You can use ur current method itself where just use the above expression alone like this in assign activity str_title = System.Text.RegularExpressions.Regex.Match(outputWindow.Selector.ToString.Trim, “(?<=title=\W).*(?=\W\s)”).ToString.Trim As simple as that Another method, a First and most simple thing is with GET ATTRIBUTE activity have the use application/ browser activity and indicate on the applicatio…

---

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

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

[system]

Daily Forum Report | 23 May 2022

Top 3 Topics with Most Views

File used by another process made by @Sudharsan_Ka with 61 views.

Send email attchment with dynamic name made by @mihai.godeanu with 44 views.

Can we retry business exception in queue after it being failed? made by @ydash999 with 41 views.

Top 3 Topics with Most Replies

Can we retry business exception in queue after it being failed? made by @ydash999 with 24 replies.

Xml reading made by @JOHN_ALEXANDER_Ayure_CO with 20 replies.

Segment and Group Datatable by not grouping item with same transaction ID/item name made by @wonderingnoname with 18 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 41 posts!

@Rahul_Unnikrishnan made 41 posts!

@ppr made 39 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 1 likes!

How to roll back to a older verstion of package?

We can just make them active, any version you want @Umang_Mehta

This post made by @david.jonsson received 1 likes!

Solution Architect requirements

Totally agree with the Pre-Sales part! You need to put someone in front of the customer IT, long before you even start the project, to decide on hosting, security and possible solutions. I did put together a graphical view of how I look at it. But again, all depends on your view and your context. In my opinion uiPath have merged two roles (Solutions Architect & Technical Architect), into one “Solution Architect” [Architect perspecives - uiPath vs Others]

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

Keyboard shortcut for getting list of variables, functions in Expression Editor

ctrl+space

Top 3 Most Liked Solutions

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

Keyboard shortcut for getting list of variables, functions in Expression Editor

ctrl+space

This solution provided by @Yoichi received 1 likes!

Find First Unhidden Sheet Name Of An Excel Using Workbook Activity

Hi, Unfortunately, there is no activity to find hidden/visible sheet in Workbook activity. However, we can achieve it using ClosedXML as the following. Can you try this? [image] workbook.Worksheets.Where(Function(s) s.Visibility=ClosedXML.Excel.XLWorksheetVisibility.Visible).OrderBy(function(s) s.Position).First().Name Sample20220523-5.zip (11.3 KB) Regards,

This solution provided by @Palaniyappan received 1 likes!

Can uipath assistant display action center form tasks?

Hi No it has to be checked only with Action Center Cheers @jack.chan

---

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

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

[system]

Daily Forum Report | 24 May 2022

Top 3 Topics with Most Views

Data Scrapping from website made by @HeartCatcher with 46 views.

JSON to Datatable convert made by @ravindar.singh with 44 views.

Scroll and take screenshot in SAP & Putty made by @Sathish_Kumar_S with 37 views.

Top 3 Topics with Most Replies

Invoke Code Exception - The name 'HttpContext' does not exist in the current context made by @andre.f.pires with 21 replies.

Data Scrapping from website made by @HeartCatcher with 20 replies.

How to click the hyperlink based on variable that i set in selector made by @user123mem with 18 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 34 posts!

@supermanPunch made 28 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @lakshman received 3 likes!

Edit Selector in Debug mode

Hi Team, Currently we are not able to indicate the UiElement or change the selector in Debug mode because of that we need to stop the entire execution even if we want to change the single attribute value in the selctor. If possible please allow to reindicate the UiElement and change the selector in Debug mode. It will save lot of time to developers.

This post made by @Patrick_Kok received 2 likes!

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi Adrian, Your solution is very cools and I didn’t know it can be done this way. Something new to learn and thanks you so much for your solution and it work great! Once again thank you so much.

This post made by @bob.nims received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, My name is Bob. I am new to UiPath and have not done much coding in probably ten years so I am a rusty robot. I have done work with Coldfusion and Tableau visuals in the past. Look forward to learning the new stuff.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

From Excel Datas to E-mail Html Body

Hi @yigit.aybey , Check the Below Post which helps you in Conversion from Datatable to Html Table format : The Output would be a String which you could then use to append to the body of the mail. The Configuration of the Send Exchange Email Body Activity Should have Property IsBodyHtml Checked (Enabled).

This solution provided by @ankit.saraf received 1 likes!

Query Entity Data giving error

Thank you so much for the input and helping identify that this issue happens when one of the inputs in the list is blank or empty. We will make sure to get this correctly fixed on the backend as well!

This solution provided by @supermanPunch received 1 likes!

Datatable Check Missing Value, Check Expired Date, compare two columns

@hurmet.noka , Could you Show us your Implementation on DataColumn Expression ? This Error Maybe because of the way the date value is formatted in the datatable. Normally the format would be "MM/dd/yyyy HH:mm:ss". Hence, You could Check the Below Expression : datetime.ParseExact(CurrentRow.Item("ExpirationDate").ToString, "MM/dd/yyyy HH:mm:ss",system.Globalization.CultureInfo.InvariantCulture) < Now.AddDays(3) If the above doesn’t work, we would need to know the format of the date value Ei…

---

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

Top 3 Topics with Most Views

Filter dates made by @alan_prakash with 54 views.

Edit PDF file made by @xiaohui.ma with 44 views.

How to check if a button is enabled or disabled if aastate attribute is unavailable in Get attribute activity made by @Deepa_Madkar with 41 views.

Top 3 Topics with Most Replies

How to check if a button is enabled or disabled if aastate attribute is unavailable in Get attribute activity made by @Deepa_Madkar with 23 replies.

Filter dates made by @alan_prakash with 22 replies.

Clicking in half of the process makes a mistake made by @Ozlem_Yigit with 21 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 43 posts!

@postwick made 27 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 3 likes!

How to count the values

Hi @aayushisaxena125 , As you have already provided the Expected Output Table, we could Start by Preparing the Datatable Schema using Build Datatable Activity as shown in your post above. Next, We Perform a GroupBy and Count based on the Values Column like below using Assign Activity : OutputDT = DT.AsEnumerable.GroupBy(Function(x)x("Values").ToString).Select(Function(x)OutputDT.Rows.Add({x.First.Item("Values").ToString,x.Count})).CopyToDatatable Here, OutputDT is the datatable built using B…

This post made by @Sophia_Zhylych received 2 likes!

Feedback wanted -> ready-to-go automations

Hi Forum Users, Last year, we announced an integration between UiPath Marketplace and UiPath Assistant. It gives Assistant users easy access to ready-to-go automations from the Marketplace to help with everyday tasks like taking a screenshot or connecting to a Zoom meeting. Since then, we’ve developed (and continue developing!) dozens of ready-to-go automations that end users can instantly run from Assistant. The Center of Excellence can also download ready-to-go automations from UiPath Market…

This post made by @TimK received 2 likes!

How to get date difference between two date variables? c#

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 3 likes!

How to count the values

Hi @aayushisaxena125 , As you have already provided the Expected Output Table, we could Start by Preparing the Datatable Schema using Build Datatable Activity as shown in your post above. Next, We Perform a GroupBy and Count based on the Values Column like below using Assign Activity : OutputDT = DT.AsEnumerable.GroupBy(Function(x)x("Values").ToString).Select(Function(x)OutputDT.Rows.Add({x.First.Item("Values").ToString,x.Count})).CopyToDatatable Here, OutputDT is the datatable built using B…

This solution provided by @Yoichi received 2 likes!

How to get date difference between two date variables? c#

Hi, We can also use DateDiff in C# as the following. Microsoft.VisualBasic.DateAndTime.DateDiff("d",d1,d2,FirstDayOfWeek.Sunday,FirstWeekOfYear.System) Regards,

This solution provided by @Rahul_Unnikrishnan received 2 likes!

How to deploy project in client's server using citrix or rds?

Hello @ydash999 , You can refer to the below document. You need to install only the robot in the remote machine and need to make a connection with orchestrator.

---

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

Top 3 Topics with Most Views

Is there a way to convert datatable's row datatype? made by @wija with 60 views.

Filter data table in excel made by @Riya1 with 48 views.

[Tutorial] How to build filter query in: Get Exchange Mail Messages to get emails with attachment flag category size etc made by @Adrian_Star with 43 views.

Top 3 Topics with Most Replies

Filter data table in excel made by @Riya1 with 21 replies.

I want to send status message when a process is running in the background of uipath apps made by @Petchi_Paramasivam with 14 replies.

Checking Project for validation errors gets stuck made by @MikeStrike with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 49 posts!

@Veera_Raj made 25 posts!

@postwick made 19 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Star received 5 likes!

[Tutorial] How to build filter query in: Get Exchange Mail Messages to get emails with attachment flag category size etc

Hi, I have prepared a comprehensive compendium of knowledge on how to filter e-mails using KQL queries used in filtering e-mail messages in Get Exchange Mail Messages activity. From the following set of information you will learn how to correctly construct a query syntax. I have tested all the query properties below for correct operation on MS Office 2016 for corporate use. I have marked the ones that didn’t work in my company. The KQL language was used in the queries used, which means: Keyw…

This post made by @Himanshu_Yadav received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

This is Himanshu Yadav, I work as a Global RPA Engineer and always try to find new interesting topic and UiPath Forum is the best place to find new topics as UiPath Developers keep posting new issues/solutions they faces during their development. which is the best way to learn new things. So that’s the reason I am here to learn and share my knowledge with you all Thanks and Happy Automation

This post made by @yigit.aybey received 2 likes!

Get Date in Input Dialog And Control of Date

Thanks for your help guys (@Lak_Ui, @lakshman and @ushu), i appreciate your effort and guidance.

Top 3 Most Liked Solutions

This solution provided by @lakshman received 1 likes!

Get Date in Input Dialog And Control of Date

@yigit.aybey You can mention the required date format to be entered by the user in Label field of Input Dialog activity. Assign the Input Dialog activity output to one string variable named strDate. And then check below conditions to validate whether entered date is correct or not. CInt(strDate.Trim.Split("."c)(0)) > 0 AND CInt(strDate.Trim.Split("."c)(0)) <= 31 CInt(strDate.Trim.Split("."c)(1)) > 0 AND CInt(strDate.Trim.Split("."c)(1)) <=12

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

How to itterate alphabet?

do this instead UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(number) where number is integer variable e.g. number=1 will return A number = 26 returns Z number = 100 returns CV number = 1000 returns ALL and so on…

This solution provided by @StefanSchnell received 1 likes!

Two different selectors for the same SAP element when captured in different PCs

@jack.chan Hello Jack, it seems that the network settings of your Environment 1 is low speed LAN connection. Square brackets in the IDs are a typical sign of this. Let us know your result. Best regards Stefan

---

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

Top 3 Topics with Most Views

https://forum.uipath.com/t/443086 made by @anh.nguyen with 58 views.

Read digits in PDF + Cross reference in Excel + Copy & Rename file made by @amenoufy with 54 views.

Click ‘DIV’: Cannot send input to UI element because it is outside of screen bounds made by @yigit.aybey with 46 views.

Top 3 Topics with Most Replies

Click ‘DIV’: Cannot send input to UI element because it is outside of screen bounds made by @yigit.aybey with 20 replies.

Read digits in PDF + Cross reference in Excel + Copy & Rename file made by @amenoufy with 17 replies.

Highlight is valid but not visible made by @yigit.aybey with 16 replies.

Top 3 Users Who Posted The Most

@Lak_Ui made 35 posts!

@yigit.aybey made 24 posts!

@ushu made 22 posts!

Top 3 Most Liked Posts

This post made by @arnab received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Really excited after joining this forum

This post made by @Yoichi received 2 likes!

How to check if all the charactersof a string are same?

Hi, Can you try the following condition? yourString.Distinct().Count()=1 Regards,

This post made by @Yoichi received 2 likes!

How to check if all the charactersof a string are same?

Hi, How about the following? System.Text.RegularExpressions.Regex.IsMatch(yourString,"[^A]") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to check if all the charactersof a string are same?

Hi, How about the following? System.Text.RegularExpressions.Regex.IsMatch(yourString,"[^A]") Regards,

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

How to resolve the given key was not present in the dictionary?

there might be hidden whitespace characters in the value fields try copy them to a notepad and see if any whitespace characters are showing e.g. if you copy in_Config("TotalInvoicePath").ToString to notepad it might show in_Config("TotalInvoicePath ").ToString [image]

This solution provided by @Yoichi received 1 likes!

How can I use a Window Handle with an Application/Browser Card?

Hi, We can achieve it using Input Element property with the following expression, for example. Can you try this? new UiPath.Core.UiElement(new UiPath.Core.Window(winHandle)) In general, we can set appWindow variable at InputElement property in the above image, to operate at same window. 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 | 28 May 2022

Top 3 Topics with Most Views

exception.Message not working now? made by @wija with 41 views.

How to output data with 1 correct condition? made by @Rhys18 with 38 views.

To Rename Downloaded Excel File made by @anmita with 38 views.

Top 3 Topics with Most Replies

Robot is getting Stuck in Orchestrator made by @Priyambada_Panda with 13 replies.

Wild card not working made by @mail4bobbysam with 12 replies.

How to output data with 1 correct condition? made by @Rhys18 with 9 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 21 posts!

@muhammedyuzuak made 17 posts!

@jpbelchote made 7 posts!

Top 3 Most Liked Posts

This post made by @jpbelchote received 1 likes!

What programming language should be learned with RPA

Hey I’m struggling with the same question, but I went to linkedin and other job websites and searched for RPA Jobs. Some of them requires some knowledge in database and its languages (mostly SQL), API and AS-IS/TO-BE documenting (suponho que você é brasileira, mas como o fórum é geral em inglês, acho válido deixar o comentário pra ajudar quem vier)

This post made by @jpbelchote received 1 likes!

What programming language should be learned with RPA

Sou sim hehehe, vejo muito pouca coisa boa em português sobre RPA. Tô aprendendo o que se usa no UiPath na marra mesmo. Tô inventando uns projetos e me virando pra buscar como resolve

This post made by @muhammedyuzuak received 1 likes!

Regex that finds the first word in a string

Hi @danielP, i hope it solves the problem. extractFirstWord.xaml (6.5 KB) Regards, MY

Top 3 Most Liked Solutions

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

Allow Only numeric in Input dialog Activity

like this Main3.xaml (10.0 KB) [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 | 29 May 2022

Top 3 Topics with Most Views

I Want to saparate with new line made by @Yogeshwar_Singh with 36 views.

How do I save the int type data in the data table and send it to Excel? made by @oneman0922 with 35 views.

How to set reminder date made by @Rhys18 with 33 views.

Top 3 Topics with Most Replies

How to set reminder date made by @Rhys18 with 10 replies.

Reading Multiple Excel files from a Folder as Data using REFRAMEWORK made by @Sanghamitra_Sahoo with 7 replies.

How to compare SAP value with pdf value made by @Chippy_Kolot with 7 replies.

Top 3 Users Who Posted The Most

@Lak_Ui made 10 posts!

@Rhys18 made 8 posts!

@Vaibhav_Rajpoot_17 made 8 posts!

Top 3 Most Liked Posts

This post made by @ushu received 2 likes!

How to Read Specific Range Data from One column at Runtime?

@kishan.savaliya Try the below one Take read range in an excel scope Within the range field pass the exp as "A"+StartingIndex +":A"+ EndingIndex StartingIndex is the variable of type string, it contains the starting index value (i.e 10) *EndingIndex is the variable of type string, it contains the starting index value (i.e 41) [Capture]

This post made by @jpbelchote received 1 likes!

What programming language should be learned with RPA

Muito grato pela indicação! Vou conferir sim os vídeos dele

This post made by @Talita_Pimenta received 1 likes!

What programming language should be learned with RPA

Por nada! Qualquer dúvida só chamar!

Top 3 Most Liked Solutions

This solution provided by @ushu received 2 likes!

How to Read Specific Range Data from One column at Runtime?

@kishan.savaliya Try the below one Take read range in an excel scope Within the range field pass the exp as "A"+StartingIndex +":A"+ EndingIndex StartingIndex is the variable of type string, it contains the starting index value (i.e 10) *EndingIndex is the variable of type string, it contains the starting index value (i.e 41) [Capture]

---

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

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

[system]

Daily Forum Report | 30 May 2022

Top 3 Topics with Most Views

Don't want loop duplicate row at For Each Row (big) made by @anh.nguyen with 60 views.

Document Understanding - 2022.5 Community Preview made by @Monica_Secelean with 48 views.

Input data on table row on browser made by @Felix_Gunawan with 48 views.

Top 3 Topics with Most Replies

Input data on table row on browser made by @Felix_Gunawan with 26 replies.

How to add an array data into datatable made by @Kunal_Jain with 20 replies.

Don't want loop duplicate row at For Each Row (big) made by @anh.nguyen with 18 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 34 posts!

@Lak_Ui made 27 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 4 likes!

Document Understanding - 2022.5 Community Preview

Greetings, UiPath Community! It’s been a while since we shared our updates - but now we’re ready to share our latest & greatest! To improve the life of users validating the extracted data from documents, we have continued the series of improvements on the Validation Station. In this sense, we have introduced: OCR & Extraction Confidence Scores in the Validation Station With the latest update, the Validation Station provides the ability of users to see both OCR (for the engines repor…

This post made by @ptrobot received 2 likes!

Html Body Content

You get the error because you replaced #name in the first iteration. In the second iteration there’s no #name anymore. To fix the bug, create a new string variable, e.g. CurrentMailBody = HtmlSave.Replace("#name", CurrentRow("Name").ToString) And use CurrentMailBody in the Send Outlook Mail Message instead.

This post made by @Vaibhav_Rajpoot_17 received 2 likes!

Getting text from pdf

@mounir.mohsen Use the expression - System.text.RegularExpressions.Regex.Match(PDF_test,"(?<=Long-Term Debt +)[\d\.\,.]+").ToString

Top 3 Most Liked Solutions

This solution provided by @Vaibhav_Rajpoot_17 received 2 likes!

Getting text from pdf

@mounir.mohsen Use the expression - System.text.RegularExpressions.Regex.Match(PDF_test,"(?<=Long-Term Debt +)[\d\.\,.]+").ToString

This solution provided by @Steven_McKeering received 1 likes!

Instead of using Flow Decision in FlowChart why can't we use If Else condition?

Do you have any further questions that I or (someone else could) answer? Otherwise mark as complete to help other users find the solution in the future

This solution provided by @Yoichi received 1 likes!

Regex to recognize words regardless of whether these are uppercase or lowercase

Hi, How about the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"Prestamos?",System.Text.RegularExpressions.RegexOptions.IgnoreCase) 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 | 31 May 2022

Top 3 Topics with Most Views

Chrome extension update (versions 18.3 to 21.4) made by @Cosin with 67 views.

Unable to pass get transaction made by @taruna.mehra with 43 views.

Assigning User Role in On-Premise Orchestrator made by @afiqah_ibrahim with 38 views.

Top 3 Topics with Most Replies

Unable to pass get transaction made by @taruna.mehra with 21 replies.

I need to extract the text and it's format using data scraping made by @Rudhresh_AppInno with 15 replies.

Unable to open the property panel in My system made by @HeartCatcher with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 50 posts!

@MitheshBolla made 22 posts!

@ppr made 20 posts!

Top 3 Most Liked Posts

This post made by @Cosin received 4 likes!

Chrome extension update (versions 18.3 to 21.4)

A new Chrome extension is planned to be published in the Chrome Web Store on June 7th 2022. The update will apply only for the Chrome extension used by following UiPath versions: 18.3, 18.4, 19.4, 19.10, 20.4, 20.10, 21.4 and is needed for compliance with Google Web Store policies. Chrome browser behavior Once published, at the first start/restart only, the Chrome browser will auto-update the UiPath Chrome extension. Depending on network performance, this operation might take Chrome browser a…

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

Find text position

system.Text.RegularExpressions.Regex.Replace(txt, "(?m)(Mainstep)[\s]", modifyValue) where txt = Mainstep_EWMA Mainstep Mainstep_0102 Mainstep_0304

This post made by @J0ska received 2 likes!

How to record only last "x" seconds before process finish

This post might be handy for anybody who wants to record last couple of seconds before the process finish, e.g. to investigate the reason of process failure. Note the workflow is using “DesktopVideoRecorder” package and “ffmpeg.exe” utility. Cheers recording.xaml (11.4 KB)

Top 3 Most Liked Solutions

This solution provided by @gustavo.cervelin received 1 likes!

VBScript does not run

Hi @Filipe_Vitorino1 , It seems to me that there is a slight difference between the two scripts. Could you remove the (1) from the .maximize on line 21 and see if it works, please?

This solution provided by @Yoichi received 1 likes!

Parsing a hard DateTime

Hi, Can you try the following expression? DateTime.ParseExact(System.Text.RegularExpressions.Regex.Replace("Sep 4th 2007","(?<=\d+)[A-Za-z]+",""), "MMM d yyyy", System.Globalization.CultureInfo.InvariantCulture) Regards,

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

Action Click Print after finish Each Loop have some DLV condition

try this! DLV015 - Copy (3) (1) (1) (1) (1).xaml (1.2 MB)

[Previous Month] Top 3 Users with the most likes on their solutions

@Yoichi received 59 likes for their solutions!

@ppr received 47 likes for their solutions!

@jack.chan received 40 likes for their solutions!

---

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.