Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 July 2021

Top 3 Topics with Most Views

Input String was not in correct format error made by @dutta.marina with 47 views.

Splitting a single string in one column made by @Pranav_KomandurPK with 38 views.

Error : HTTP Request: Invalid URI: The Uri string is too long made by @Sweety_Girl with 34 views.

Top 3 Topics with Most Replies

Input String was not in correct format error made by @dutta.marina with 35 replies.

Splitting a single string in one column made by @Pranav_KomandurPK with 19 replies.

Error : HTTP Request: Invalid URI: The Uri string is too long made by @Sweety_Girl with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 24 posts!

@dutta.marina made 21 posts!

@MarioHerrmann made 20 posts!

Top 3 Most Liked Posts

This post made by @NareshKumar_om received 2 likes!

Uipath.MicrosoftOffice365.Activites - Upload files

Hi @Nithinkrishna I have found where the problem was. even though i create a new Document library I need to create at least one folder inside the document library for it work. Sharepoint URL is -https://xxxxxxxxxxxxxx.sharepoint.com/sites/DocumentManagementSystem Drive Name - INVOICE2021 (Document Library) Folder name - 2021 then the file correctly uploading to folder 2021 [image]

This post made by @shinji received 2 likes!

Excelに罫線（横）を入れたい

InvokeCodeの引数はこんな感じで、 [image] コードはこんなイメージで。 [image] 参考までにxamlファイルです。 DrawBorder.xaml (12.2 KB) ※ 急いで作ったので、ゴミ変数が入ってました。不要部分は適当に消してくださいませ。

This post made by @shinji received 2 likes!

Excelに罫線（横）を入れたい

.NETで良いなら「InVokeCode」で自由に罫線が引けると思います。

Top 3 Most Liked Solutions

This solution provided by @NareshKumar_om received 2 likes!

Uipath.MicrosoftOffice365.Activites - Upload files

Hi @Nithinkrishna I have found where the problem was. even though i create a new Document library I need to create at least one folder inside the document library for it work. Sharepoint URL is -https://xxxxxxxxxxxxxx.sharepoint.com/sites/DocumentManagementSystem Drive Name - INVOICE2021 (Document Library) Folder name - 2021 then the file correctly uploading to folder 2021 [image]

This solution provided by @shinji received 2 likes!

Excelに罫線（横）を入れたい

InvokeCodeの引数はこんな感じで、 [image] コードはこんなイメージで。 [image] 参考までにxamlファイルです。 DrawBorder.xaml (12.2 KB) ※ 急いで作ったので、ゴミ変数が入ってました。不要部分は適当に消してくださいませ。

This solution provided by @LevKushnir received 2 likes!

Extracting the data from SAP

this is the right format [image]

---

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

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

[system]

Daily Forum Report | 15 July 2021

Top 3 Topics with Most Views

Excel Discrepancy-URGENT made by @mitul_choudhary with 106 views.

Terminal Window Maximize made by @supu123 with 79 views.

Issue with date format from csv to excel made by @Soudios with 54 views.

Top 3 Topics with Most Replies

Issue with date format from csv to excel made by @Soudios with 25 replies.

Excel Discrepancy-URGENT made by @mitul_choudhary with 21 replies.

データテーブルをフィルターアクティビティの不思議な現象について made by @111860 with 20 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 31 posts!

@kumar.varun2 made 25 posts!

@Nithinkrishna made 25 posts!

Top 3 Most Liked Posts

This post made by @dacostri received 3 likes!

Excel Automation-Urgent

I agree with this kind of response. Too many community members are simply asking questions without actually searching for an answer.

This post made by @Yoichi received 3 likes!

Grouping data and add comma

Hi, Hope the following helps you. [img20210715-5] dtResult = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("ID").ToString,r("Code").ToString,r("Usage").ToString,r("Plant Code").ToString,r("Header text").ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.key.item1,g.Key.item2,g.Key.item3,g.Key.item4,g.Key.item5,String.Join(",",g.Select(Function(r) r("doc_number").ToString)) },False)).CopyToDataTable Regards,

This post made by @Ishmeet_Bindra received 2 likes!

UiPath Cloud Masters

Yes Surya, it will be explained!

Top 3 Most Liked Solutions

This solution provided by @StefanSchnell received 2 likes!

Sap easy access issue

Hello Jack, these are different themes, the upper is the Quartz theme and the lower is the SAP Signature theme. Here an example of the differences of the UI elements of the screen 100 of the report SAPLSMTR_NAVIGATION: SAPLSMTR_NAVIGATION_100.zip (1.5 KB) As you wrote, many buttons are missing from Signature to Quartz. This is not an overlay. Check it and configure it at the beginning of your automation workflow which theme to use. Here an example how to check the using SAP theme with an Invo…

This solution provided by @Nithinkrishna received 2 likes!

What us the purpose of 'reset transaction" in edit queue item?

@Elya @ermanoj3101 Reset transaction progress - Let’s say you are retrying a failed item and it comes as New right. But we may not need the old progress messages but just to start fresh. So resetting will be the option to go for. Thanks #nK

This solution provided by @ermanoj3101 received 1 likes!

Excel Automation-Urgent

Hi @mitul_choudhary , You can use below code. I have attached output of this code. test.xaml (10.1 KB) Test.xlsx (7.2 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 July 2021

Top 3 Topics with Most Views

Document Understanding Process - New Studio Template made by @Alexandru-Luca with 107 views.

Regex Extraction Text made by @Mohamed_Hassan1 with 39 views.

Please help. Cannot connect robot to Orchestrator made by @Tony101 with 33 views.

Top 3 Topics with Most Replies

Regex Extraction Text made by @Mohamed_Hassan1 with 22 replies.

Source Contains No Data Rows || Link Query made by @prerna.gupta with 12 replies.

Count folders and files by date modified made by @pmistry with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 23 posts!

@sonaliaggarwal47 made 23 posts!

@Palaniyappan made 22 posts!

Top 3 Most Liked Posts

This post made by @Alexandru-Luca received 10 likes!

Document Understanding Process - New Studio Template

Hello everyone! We are very excited to announce the new studio template for Document Understanding. You can find the Document Understanding Process template on the Official template feed - make sure Include Prerelease is checked. To get started, simply create a new project in UiPath Studio and select it. [IncludePrerelease] [image] We recommend to carefully read the enclosed User Guide, even if you’re already familiar with the solution. The Guide can be…

This post made by @kmisko11 received 2 likes!

UiPath Cloud Masters

Great idea! Hope to gain a lot of knowledge from all the participants. It would be great if you could upload all the solutions somewhere, not only the winning ones

This post made by @Kristen received 2 likes!

Bulk Insert Uipath

I know this response is a bit delayed, but I had the same issues and I couldn’t find a good solution on these forums. I was able to get it working using the following: Add the ‘Invoke Code’ Activity Add the following Import: System.Data.SqlClient Add the following arguments: ConnectionString - In - String - "DB CONNECTION STRING" TargetTable - In - String - "TARGET TABLE NAME" DataToInsert - In - DataTable - DTVARIABLE Add the following code: Using SQLConnection As SqlConnection = New SqlC…

Top 3 Most Liked Solutions

This solution provided by @qbrandon received 2 likes!

Does 'Orchestrator HTTP request' activity use OAuth or does it need OAuth feature in future?

The Robot is already authenticated with Orchestrator (to send logs, etc…) The Orchestrator HTTP request is simply re-using this identity (Token) to leverage the Orchestrator API. Robot accounts are not relying on the external application OAuth implementation, but from a security perspective, this is basically equivalent. Of course, the authentication being already taken care of, it is much more convenient to use the Orchestrator HTTP request than not. Please do not worry about the Orchestrat…

This solution provided by @T0Bi received 2 likes!

How to check if any transaction item already exist in the queue

The easiest way is to enforce a unique transaction reference when setting up your queue [image] If this has helped you, please mark this answer as the solution.

This solution provided by @sai_krishna_somisetty received 1 likes!

Dynamic gmail body

[image]

---

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

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

[system]

Daily Forum Report | 17 July 2021

Top 3 Topics with Most Views

How to extract PDF Bank statements to Excel made by @Aditya91 with 44 views.

How to calculate rows and add to in Total column made by @THIRU_NANI with 37 views.

What is alternative for delay activity? made by @ashwini.magar92 with 33 views.

Top 3 Topics with Most Replies

How to calculate rows and add to in Total column made by @THIRU_NANI with 19 replies.

How to get text before the amount from Regex? made by @ermanoj3101 with 12 replies.

Exception is not catched made by @Sus_Mi with 11 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 38 posts!

@Palaniyappan made 14 posts!

@THIRU_NANI made 10 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

What is Difference between Global Exception Handler and try-catch block?

Hi @ashwini.magar92, Exception handling in UiPath / RPA tools are a way to catch exceptions at source or the workflows invoking a source workflow. Think of an try catch exception in a project as a layer of an Onion. A project may contain many workflows and therefore many protection layers may be required. As you build your project, a workflow may fail and by using the catch sequence and exception message and exception can be forwarded to a parent workflow and you can keep doing this as many t…

This post made by @Rahul_Tomar1 received 1 likes!

Datatable column transformation

The data is coming from csv file. I tried you [image] [image] It is showing column A is not blong to datatable [image]

This post made by @sruthesanju received 1 likes!

How to find the value in excel

Yes it’s working…thanks

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

What is Difference between Global Exception Handler and try-catch block?

Hi @ashwini.magar92, Exception handling in UiPath / RPA tools are a way to catch exceptions at source or the workflows invoking a source workflow. Think of an try catch exception in a project as a layer of an Onion. A project may contain many workflows and therefore many protection layers may be required. As you build your project, a workflow may fail and by using the catch sequence and exception message and exception can be forwarded to a parent workflow and you can keep doing this as many t…

This solution provided by @prasath17 received 1 likes!

How to get text before the amount from Regex?

@ermanoj3101 - Please check this…Only Opening Balance is not correct. See if you can use string manipulation/regex to replace that value… https://regex101.com/r/aNzpnt/3/ I will also try…

---

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

Top 3 Topics with Most Views

Read file by regex? made by @fairymemay with 42 views.

Save a file in count form made by @Guilherme_Silva with 36 views.

Data Loss- While writing data in Excel made by @Harshad_Jadhav with 35 views.

Top 3 Topics with Most Replies

Save a file in count form made by @Guilherme_Silva with 24 replies.

Drop-Down Field - Click made by @PaulMo with 14 replies.

Bot is not sending the mail made by @sneha_arbole with 11 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@ermanoj3101 made 28 posts!

@hsendel made 13 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Convert String()() to String() In Vb.Net

Hi, Can you try the following expression? arrStr = arrArrStr.SelectMany(Function(a) a).ToArray Note: arrStr is String[] type. arrArrStr is String[][] type. Regards,

This post made by @ppr received 3 likes!

Column Transpose with Condition on its Cells' Values

@hsendel we can do it dynamicly with the help of groupBy, dictionary and LINQ Variables: [grafik] Grouping the data by the the first two letters into a dictionary: [grafik] retrieving the max length for the longest group: [grafik] Preparing the result datatable columnstructure: [grafik] Build datatable with first column (ColName: Key), then we do add the other columns: [grafik] Finaly we use following LINQ for populating the target DataTable: [grafik] LINQ iterates over the Group…

This post made by @StefanSchnell received 2 likes!

A new UI Automation input method: the ChromiumAPI - highlights

@gheorghestan Sounds excellent Gheorghe.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Convert String()() to String() In Vb.Net

Hi, Can you try the following expression? arrStr = arrArrStr.SelectMany(Function(a) a).ToArray Note: arrStr is String[] type. arrArrStr is String[][] type. Regards,

This solution provided by @ppr received 3 likes!

Column Transpose with Condition on its Cells' Values

@hsendel we can do it dynamicly with the help of groupBy, dictionary and LINQ Variables: [grafik] Grouping the data by the the first two letters into a dictionary: [grafik] retrieving the max length for the longest group: [grafik] Preparing the result datatable columnstructure: [grafik] Build datatable with first column (ColName: Key), then we do add the other columns: [grafik] Finaly we use following LINQ for populating the target DataTable: [grafik] LINQ iterates over the Group…

This solution provided by @Palaniyappan received 2 likes!

Log Message function

Hi @SH_94 Logging is important for three reasons Logs writes the specified diagnostic message at the specified level. Say for example you are using excel activities to read a excel file and you are keeping a log message activity right after the excel activities mentioning as “EXCEL FILE IS READ SUCCESSFULLY” now when bot is executed and if you want to validate whether excel file is read successfully or not, you can check the output panel or the execution log files whether the LOG MESSAGE AC…

---

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

Top 3 Topics with Most Views

「チェック」「クリック」アクティビティについて made by @111561 with 35 views.

Check if today is twentieth working day made by @markosc with 35 views.

Split text from string? made by @fairymemay with 34 views.

Top 3 Topics with Most Replies

Need to open the last file in my Folder made by @Soudios with 25 replies.

Checkbox selectors made by @pari_patel with 18 replies.

Read range:Your Stream was neither an OLE2 stream, nor an OOXML Stream made by @Jayavignesh_G with 16 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 48 posts!

@Palaniyappan made 38 posts!

@prasath17 made 23 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

Need to open the last file in my Folder

Hi @Soudios, I would advice you do either draw a simple folder structure schematic OR even better Make a zip of your folder structure (without your required file name and type) This way @prasath17 can guide you easily. A side note : @prasath17 i wonder how many Regex expressions are hidden in that RegexPractice folder of yours!

This post made by @Palaniyappan received 2 likes!

How can I iterate through a dropdown in a desktop application eg. notepad script dropdown

Hi I believe some of the application won’t allow the select that drop down with SELECT ITEM activity due to uielement node attribute and it’s value or missing of SELECT TAG Is there any option to type in that field instead of scrolling and searching for a text So if you have the text to be searched and clicked we can rather type in that text using TYPE INTO activity which is another workaround Cheers @lertsak.n

This post made by @Nithinkrishna received 2 likes!

Excel Discrepancy-URGENT

Hey @ermanoj3101 Great help. @mitul_choudhary I was little away from forum, so not seen your post to help. Sorry for it #nK

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Need to open the last file in my Folder

@Soudios - Below will a array…and your assign statement is string… [image] please read the below again and add .first at the end…

This solution provided by @NIVED_NAMBIAR received 2 likes!

Type into question!

Hi @Dorothy_lee Best way is to Chr(34) to get " see this example i used as input in type into activity [image] Try this way Regards Nived N

This solution provided by @Yoichi received 2 likes!

「チェック」「クリック」アクティビティについて

こんにちは タイミングの問題であれば、対象要素の状態を確認する等の手もありますが、 より全体としての動作を確実にするためには、チェックあるいはクリック等の操作後 その操作が正しく行われたかのチェックを行うことです。 チェックボックスであればGet Attributeアクティビティを ボタンのクリックであれば、次に現れるであろう要素の有無確認 等を使います。 なおリトライスコープを使うとこのあたりの実装を省力化できると思います。 https://docs.uipath.com/activities/lang-ja/docs/retry-scope

---

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

Top 3 Topics with Most Views

Link problem made by @sedayngl_sedayngl33 with 42 views.

How to access each item dynamicaaly in Datatable made by @debosree with 35 views.

Excel Reconciliation -URGENT made by @mitul_choudhary with 34 views.

Top 3 Topics with Most Replies

How to sort value in a Cell? made by @Rakesh_Yadav with 18 replies.

Link problem made by @sedayngl_sedayngl33 with 13 replies.

JOB STATE is FAULTED made by @liran.levin with 13 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 36 posts!

@Palaniyappan made 25 posts!

@ganesh4 made 23 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

Comment Out Clarification

Hi @SH_94, It will run the workflow if there are no errors in the first invoked workflow in your case the Try Catch_Updated_Chage. But I see there is an warning message in the Try Catch_Updated_Chage workflow. Since there is a warning sign the robot will not run. Normal Behaviour By default any commented out code will be ignored by UiPath. Only code which is uncommented and linked to the flowchart will be executed at run time.

This post made by @Vinay_Swarnkar received 2 likes!

Taking screen shot and saving to a cell corresponding to web search

hello guys , I would be thankful to you guys , if you can help in checking and suggesting me some steps to do the below task , Reading column A , Open browser - pasting value in search box and enter. (This is working fine) Now need to take screenshot of attachment there in last on the opened page , and save to corresponding column and this activity will loop in may be infinite times until the all column A items end. i have done the process , only problem is Invoke method (copying image…

This post made by @Palaniyappan received 2 likes!

Taking screen shot and saving to a cell corresponding to web search

Hi Use Insert Image at Cell activity under Balareva.Excel.Activities package to do this. Cheers @Vinay_Swarnkar

Top 3 Most Liked Solutions

This solution provided by @jeevith received 2 likes!

Comment Out Clarification

Hi, Not sure what the workflow has within it. You will have to open it and check what the workflow does yourself. If there is some complex logic you can post a screenshot of it in the forum. But by just looking at the workflow we can’t say what it does.

This solution provided by @Joe.Matuch received 2 likes!

Cannot sign into Orchestrator or Studio anymore

It looks like this issue is resolved. When I tried signing into Orchestrator today, I did not have a robot configured. I went to Tenant → Users → clicked on the 3 dots next to my name → Edit → Optional Robot Settings → Clicked to automatically configure an Attended Robot (which also resulted in creating a workspace) Then, when I went to open a .xaml file, Studio had me sign in and choose the version of Studio. Once the file had loaded, it showed that I was connected. I know I had tried this a…

This solution provided by @jeevith received 2 likes!

Delete Empty Excel in Folder

Hi @Yudhisteer_Chintaram1, So you get a NullReferenceException. Do mention what kind of error message you get in your question, it helps a lot to resolve an issue in the forum. All you have to do is to use try-catch activity and look for NullReferenceException type of error. If the error exists then delete file, if not read the content. Here is how you can achieve it. Offcourse, you have to adapt it to your scenario: [image] CheckForEmpySheet.xaml (8.0 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 | 21 July 2021

Top 3 Topics with Most Views

If value is not null made by @mitul_choudhary with 36 views.

Get Exact Date format in Excel made by @Vincent_Nuestro with 31 views.

How to extract the data using regex made by @copy_writes with 29 views.

Top 3 Topics with Most Replies

How to extract the data using regex made by @copy_writes with 31 replies.

If value is not null made by @mitul_choudhary with 20 replies.

How to call a HSQLDB stored procedure in Execute query activity? made by @Tamilarasanaccet with 17 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 47 posts!

@ermanoj3101 made 24 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

Vote Data Service API - Part 3 | Entity Data Operations

Hello again Community! And here is Part 3 video on getting started with UiPath #dataservice #api on the #rpavanguard channel! [UiPath Data Service APIs - Part 3 | Basic Entity Data Operations] Picking up from where we left off in Part 2, this video will: Confirm that the Refresh token can be used to quickly get a new API Access token Demonstrate the basic Data operations using the Delete, Add and Update API endpoints Show how a token can be refreshed when it expires midway durin…

This post made by @Sathesh_Paramasivam received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I am currently working as a RPA Developer in Berlin, Having profound experience in Data and Automation Field. Would love to discuss innovative ideas, bug fixes and see if i can be of any help to the community.

This post made by @Alexandru-Luca received 2 likes!

Document Understanding Process - New Studio Template

@carlacarnevali - processing 1 queue item at a time is precisely the intended behaviour; you need to create your own dispatcher mechanism. Please check out the documentation. @RPAForEveryone - Yes. You also need to disable Persistence. Please check out chapter Settings for Attended Processes in the User Guide. @ctutu We played around with various scenarios involving multiple DU queues - including the one you mentioned. We found that debugging/managing/scaling become a nightmare very quickly. S…

Top 3 Most Liked Solutions

This solution provided by @AdityaVN received 2 likes!

How to count the the numbers in the excel cell

Hi @copy_writes If you are holding these numbers (12345678 AND 1234567) in a variable lets say Digits_count Digits_count.ToString.Length will give the number of digits in the number and use IF condition to control the flow in the way it is required Hope this is helpful

This solution provided by @prasath17 received 2 likes!

Getting numbered files with For Each and how to get it in order instead of by the first character

Here you go… Directory.GetFiles("YourFolderName","*.pdf").OrderBy(Function(d) cint(path.GetFileNameWithoutExtension(d))).toarray

This solution provided by @AkshaySandhu received 1 likes!

If value is not null

issue is with your excel file… column B and column D is having negative numbers with the whole column formatted as date. which is overflow change your column type to General.

---

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

Top 3 Topics with Most Views

String Manipulation with Split(item, " ")(1).ToString made by @Andre_Vieira with 57 views.

How to get text from dynamic elements made by @SVa with 56 views.

Add 0 to Column in Excel made by @Yudhisteer_Chintaram1 with 49 views.

Top 3 Topics with Most Replies

Clicking multiple excel files in a attach browser made by @Pranav_KomandurPK with 25 replies.

How to sort datatable based on column which has percentage and it is generic value datatype made by @Mohammed_Nawazuddin with 22 replies.

String Manipulation with Split(item, " ")(1).ToString made by @Andre_Vieira with 21 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 35 posts!

@ppr made 25 posts!

@ermanoj3101 made 24 posts!

Top 3 Most Liked Posts

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

Add 0 to Column in Excel

@Yudhisteer_Chintaram1 "0" + colValue.ToString

This post made by @prasath17 received 3 likes!

Add 0 to Column in Excel

@Yudhisteer_Chintaram1 - Please check this… “50000521978”.Substring(0,6).Contains(“50000”) true or we can use Regex.ismatch to check the value at the start… [image]

This post made by @GersonTun received 2 likes!

Image in the signature in the body of the email

Write the full signature in HTML and insert the images in base64 only where needed. For example, this code: <h3>Your name</h3> <p>Job Title <br> Department</p> <img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD//gAgQ29tcHJlc3NlZCBieSBqcGVnLXJlY29tcHJlc3MA/9sAhAAFBQUFBgUGBwcGCQkICQkNDAsLDA0TDg8ODw4THRIVEhIVEh0aHxkXGR8aLiQgICQuNS0qLTVAOTlAUU1RamqOAQUFBQUGBQYHBwYJCQgJCQ0MCwsMDRMODw4PDhMdEhUSEhUSHRofGRcZHxouJCAgJC41LSotNUA5OUBRTVFqao7/wgARCADhAu4DASIAAhEBAxEB/8QAHAABAAIDAQEBAAAAAAAAAAAA…

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 3 likes!

Add 0 to Column in Excel

@Yudhisteer_Chintaram1 - Please check this… “50000521978”.Substring(0,6).Contains(“50000”) true or we can use Regex.ismatch to check the value at the start… [image]

This solution provided by @GersonTun received 2 likes!

Image in the signature in the body of the email

Write the full signature in HTML and insert the images in base64 only where needed. For example, this code: <h3>Your name</h3> <p>Job Title <br> Department</p> <img src="data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD//gAgQ29tcHJlc3NlZCBieSBqcGVnLXJlY29tcHJlc3MA/9sAhAAFBQUFBgUGBwcGCQkICQkNDAsLDA0TDg8ODw4THRIVEhIVEh0aHxkXGR8aLiQgICQuNS0qLTVAOTlAUU1RamqOAQUFBQUGBQYHBwYJCQgJCQ0MCwsMDRMODw4PDhMdEhUSEhUSHRofGRcZHxouJCAgJC41LSotNUA5OUBRTVFqao7/wgARCADhAu4DASIAAhEBAxEB/8QAHAABAAIDAQEBAAAAAAAAAAAA…

This solution provided by @Yoichi received 2 likes!

Wierd. Yes Button can not be clicked on a close application dialog box

Hi, It might be not have completed Close Application activity. For now, can you try to use Parallel activity as the following? [img20210722-1] 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 | 23 July 2021

Top 3 Topics with Most Views

UiPath Automation Awards 2021 for CEE & Turkey made by @cristina.vidu with 38 views.

How to refresh my excel file with Uipath ? made by @Nightowl_music with 34 views.

Extract number from string made by @Bhageswar_Yadav with 32 views.

Top 3 Topics with Most Replies

How to extract the address number(store no) using regex made by @copy_writes with 16 replies.

How to refresh my excel file with Uipath ? made by @Nightowl_music with 15 replies.

An Empty file gets downloaded inbetween data extraction made by @kaavya with 14 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 65 posts!

@ppr made 21 posts!

@prasath17 made 19 posts!

Top 3 Most Liked Posts

This post made by @Ishmeet_Bindra received 3 likes!

UiPath Cloud Masters

Get ready for Azure Challenge. Here is the guide you can follow for your learning/Implementation purpose- Why Cloud? - https://www.youtube.com/watch?v=dsKIpLKo8AE Azure Basics - https://www.youtube.com/watch?v=xNbVUMvqtt8 Azure Database Service - https://www.javatpoint.com/azure-database-service Azure DevOps - https://www.youtube.com/watch?v=1xyBUj72Uh4 Azure AI - https://www.youtube.com/watch?v=qJGRd34Hnl0 and https://www.youtube.com/watch?v=gRQtyfP3sTw Azure Storage - https://www.youtube…

This post made by @jeevith received 3 likes!

Dispatcher + Performer, How to organize Execution on Orchestrator, Please Advise

Hi @Hurmet_Noka, Here I am assuming your perfomer takes no longer than 3 hours and 45 minutes Lets take the Dispatcher first. If your queue items are added quite quickly you can schedule your performer to run after a static time delay. Say if your dispatcher starts at 10:00 am and takes 10 minutes, your perform can be scheduled to run at 10:15 with a 5 minute buffer. Dispatcher runs again at 14:00 and Performer at 14:15 and this can continue. You can use cron expression on both the dispatch…

This post made by @cristina.vidu received 2 likes!

UiPath Automation Awards 2021 for CEE & Turkey

UiPath Automation Awards 2021 for CEE & Turkey Under Vargha Moayed’s leadership, the UiPath Automation Awards are created to support the development of innovative business ideas, to foster the capacity to scale of brilliant teams and entrepreneurs in the Central, Eastern Europe & Turkey region and to enrich the automation ecosystem we play in. Winners of the awards will receive financial, sales and marketing support and the deadline for applications is 1 Sept. Are you one of those innovative …

Top 3 Most Liked Solutions

This solution provided by @jeevith received 3 likes!

Dispatcher + Performer, How to organize Execution on Orchestrator, Please Advise

Hi @Hurmet_Noka, Here I am assuming your perfomer takes no longer than 3 hours and 45 minutes Lets take the Dispatcher first. If your queue items are added quite quickly you can schedule your performer to run after a static time delay. Say if your dispatcher starts at 10:00 am and takes 10 minutes, your perform can be scheduled to run at 10:15 with a 5 minute buffer. Dispatcher runs again at 14:00 and Performer at 14:15 and this can continue. You can use cron expression on both the dispatch…

This solution provided by @ppr received 2 likes!

Needed Explanation

Its a LINQ within Method syntax: dtExported.Rows.Cast(Of DataRow)() Similar to dtExported.asEnumerable - makes the datarows available for the LINQ .Where - filtering (Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”) Filter expression: All Column Values from the looped datarow are not blank )).CopyToDataTable()** us the datarows passed the filter and copy it to a datatable Rewritten to Query Syntax: (From d in dtExported.AsEnumerable Where d…

This solution provided by @Yoichi received 2 likes!

XOR Operation not working

Hi, Xor operator evaluates both expressions. So, in the above condition, String.IsNullOrEmpty(Array2items(2).ToString) is always evaluated even if the number of items is 2 or less. Perhaps you should use short-circuiting logical operator as the following. Array2Items.Count<3 OrElse String.IsNullOrEmpty(Array2Items(2).ToString) 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 | 24 July 2021

Top 3 Topics with Most Views

Inter Process Communication Overview made by @Gopal_Tewari1 with 31 views.

Html image problem made by @sedayngl_sedayngl33 with 29 views.

RE frameworks made by @ashish_negi with 29 views.

Top 3 Topics with Most Replies

Html image problem made by @sedayngl_sedayngl33 with 13 replies.

Take screenshot questions made by @Matthew2 with 8 replies.

How to automate this? made by @taruna.mehra with 6 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 16 posts!

@sedayngl_sedayngl33 made 8 posts!

@ganesh4 made 7 posts!

Top 3 Most Liked Posts

This post made by @Gopal_Tewari1 received 3 likes!

Inter Process Communication Overview

IPC Activities allow us to pass messages between running processes and established the communication between two running processes. Using IPC activities one Process can tells another process that an event has occurred. These activities work only for the processes running on the same Robot (same user, same machine). How to Use it – Install IPC Activities in both the Processes using UiPath manage packages Official tab. [image] Note : - Please make sure that IPC.Activities package version re…

This post made by @ermanoj3101 received 2 likes!

Take screenshot questions

Hi @Matthew2 , It’s better if you use screenshot activity without selectors as it will capture any screen appearing at that time. Thanks.

This post made by @Hafeez received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Greetings from Switzerland. I am very new to UiPath. I am working in cancer research and just started learning UiPath. My goal is to see how my organization can benefit from this interesting tool. Hafeez

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Comparing to variables

Hi, There might be some whitespace except " "(0x20) character. Can you try the following steps? First, normalize whitespace in both variables using Assign activities. strNomeClienteInput = System.Text.RegularExpressions.Regex.Replace(NomeClienteInput.ToString,"\s+"," ").Trim strNomeOutput = System.Text.RegularExpressions.Regex.Replace(NomeOutput.ToString,"\s+"," ").Trim Then, check with the following expression strNomeOutput.Equals(strNomeClienteInput) Regards,

This solution provided by @prasath17 received 1 likes!

Is it Possible to Delete Rows ( Words) Which Contains Successive Consonants or Vowels?

@hsendel - I misread your requirement. Apologize… Please check this… FilterWords_Fixed.zip (83.0 KB)

This solution provided by @NIVED_NAMBIAR received 1 likes!

Take screenshot questions

Css selectors are type of selectors which is constructed by using unqiue attribute in element to learn more about it refer @Anmol_Yadav video on it [Dynamic Selectors in UiPath - CSS Selectors | How to create and use it? | UiPath | Anmol] Regards, Nived N

---

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

Top 3 Topics with Most Views

Unable to move files from one folder to other folder made by @raghu_raj with 32 views.

Send Bulk Emails with Uipath made by @balaji.S with 31 views.

Issue in splitting a string made by @Jiban_Kumar_Das with 29 views.

Top 3 Topics with Most Replies

Select datatable + Substring made by @ccrespo9669 with 14 replies.

Issue in splitting a string made by @Jiban_Kumar_Das with 7 replies.

Unable to move files from one folder to other folder made by @raghu_raj with 7 replies.

Top 3 Users Who Posted The Most

@ccrespo9669 made 9 posts!

@kumar.varun2 made 7 posts!

@NIVED_NAMBIAR made 7 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

Read PDF with regions

@TP2B Hallo Tobias, nope, DU is not the only way. You can very easy extract information from form based PDF. First step is to convert PDF to JPG, second step is to exctract the image section which contains the information you need and the third step is to use Tesseract OCR to get the data you need. The output CroppedImage is the input of Tesseract OCR. Step zero is to add the UiPath.PDF.Activities library to your workflow. [image] Here an example, which extracts side 1: [image] Here the …

This post made by @onebitty received 1 likes!

Unable to click on sub menu on hovering

Managed to get it done at the end using the below flow: [image]

This post made by @manson_ew2 received 1 likes!

Parsing an unknown file type

It looks like protobuf text format. If you don’t have a schema definition - you may create your own, based on the output and use TextFormat parser from protobuf library (or convert to json, etc)

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Html image problem

Hey @sedayngl_sedayngl33 Good day. Please find the workaround for you. EmbedImageInMail.zip (11.4 KB) Thanks #nK

This solution provided by @NIVED_NAMBIAR received 1 likes!

HOW TO MERGE DATA WHILE READ RANGE ACTIVITY

Hi @Shagoul_Hameed I had updated your workflow to meet your requirements Kindly check this merge.zip (22.8 KB) Regards, Nived N

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

Issue in splitting a string

@Jiban_Kumar_Das [image] if you’ll try like this → ipstr1.Substring(ipstr1.IndexOf("14"), 7) it will work to make it more dynamic use this ipstr1.Substring(ipstr1.IndexOf("14"), ipstr1.Length-ipstr1.IndexOf("14")-4) For your Reference

---

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

Top 3 Topics with Most Views

Webでの複写登録について made by @s-ito with 34 views.

Adavanced scheduling of Robot made by @JITU99 with 25 views.

Only getting last value of an array made by @Tadas with 25 views.

Top 3 Topics with Most Replies

Not able to run the bot made by @mitul_choudhary with 24 replies.

In this text field I want to search for "ITEM NUMBER" and select the actual item number A061P694(a pattern of [A-Z]\d{3}\[A-Z]\d{3} it follows). I failed to search for it. Please give me some proper solution for this made by @Ankit_Kanjilal with 16 replies.

Need help with Get Text activity for arbitrary text box made by @Aimon_Flaherty with 16 replies.

Top 3 Users Who Posted The Most

@jeevith made 26 posts!

@postwick made 25 posts!

@Gokul001 made 21 posts!

Top 3 Most Liked Posts

This post made by @Ishmeet_Bindra received 3 likes!

UiPath Cloud Masters

Hi All, We have our Week 1 (Google Cloud Edition) winner. Congratulations @devashish1989 for winning last week’s challenge. Details about his submission - :cloud:Idea - 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐭 𝐈𝐦𝐚𝐠𝐞 𝐒𝐞𝐚𝐫𝐜𝐡: Search images based upon content in them e.g. it would be tedious to get pictures having sunset from a plethora of 300-500 pictures collection. The solution helps you search images using 𝑮𝒐𝒐𝒈𝒍𝒆 𝑪𝒍𝒐𝒖𝒅 𝑽𝒊𝒔𝒊𝒐𝒏 𝑳𝒂𝒃𝒆𝒍 𝑫𝒆𝒕𝒆𝒄𝒕𝒊𝒐𝒏 and stores the image path along with labels for lookup in 𝑮𝒐𝒐𝒈𝒍𝒆 𝑺𝒉𝒆𝒆𝒕𝒔 and al…

This post made by @111860 received 3 likes!

リモートデスクトップで見えない項目を選択する方法

ありがとうございます。 最初はホットキーの繰り返しを入れていたのですが、前後の待機を0秒にしても次の押下まで２秒くらいかかってしまい、20項目下がるのに時間がかかりすぎたため諦めました。 こちらでうまくいきました！ありがとうございます。

This post made by @AndyMenon received 2 likes!

Data Service API - Part 4 | Entity File Operations

Hello Community! This is Part 4 of the UiPath Data Service API video tutorial series. [UiPath Data Service APIs - Part 4 | Entity File Operations] This video will cover the API Endpoints that will help us perform file based operations against our Data Service Entities. We start with the basic step of adding a “File Type” field to an Entity We then focus on the Upload File endpoint and learn how to use it with Postman and Talend API Clients We follow that up by learning how to do…

Top 3 Most Liked Solutions

This solution provided by @N2027 received 2 likes!

リモートデスクトップで見えない項目を選択する方法

Enumerable.Repeatよりは、「ホットキーを押下」の繰り返しで前後の待機秒数を注意して、実装した方が動作安定する気がします。 また、Endキーで最後の項目が選択できます。 選択項目の「1文字目」を入力すると、当該項目が選択できます。

This solution provided by @jeevith received 2 likes!

Extracting value from JSON file

Hi @tainan.ramos, A very rudamentary way is to read the json file as text file by using the Read Text File activity. This returns a string. Then you can determine if that text string has “x-cod” by using If condition = TextStringReadFromFile.contains("x-cod") If true, Then extract value. Before extracting the value in the Then block you can use DeserializeJson activity to extract value of Json using Some helper code for json parsing / value extraction in UiPath : Iterating through Jobject …

This solution provided by @jeevith received 1 likes!

Adavanced scheduling of Robot

Hi @JITU99, Background UiPath uses Quartz implementation of Cron expressions and is a little limited when compared to cron expressions in Linux. So you can trust this website to give you the extact expressions UiPath Orchestrator supports : Free Online Cron Expression Generator and Describer - FreeFormatter.com Sadly your query cannot be implemented in a single query. You will need two cron expressions (two dedicated triggers). Here I assume that you will run the bot at 00:00:00 hours / 12:00:…

---

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

Top 3 Topics with Most Views

We are launching the RPA Summer School program! made by @cristina.vidu with 45 views.

Sort data (VBA)? made by @fairymemay with 37 views.

UiPathTeam.SharePoint.Activitiesでファイルをダウンロードしたい made by @kana612 with 36 views.

Top 3 Topics with Most Replies

Send hot key (ctrl+v) in web automation executing but not pasting made by @Saravanan_Murugan with 26 replies.

Change xml value from excel sheet made by @Majunu09 with 20 replies.

How to check if given time string variable is within the time range? made by @ciaramkm with 16 replies.

Top 3 Users Who Posted The Most

@ppr made 29 posts!

@ermanoj3101 made 27 posts!

@T0Bi made 20 posts!

Top 3 Most Liked Posts

This post made by @cristina.vidu received 3 likes!

We are launching the RPA Summer School program!

Hello summer! Hello RPA! Today UiPath Community is launching the RPA Summer School program! [RPA Summer School (2)] This year the UiPath Community encourages all absolute RPA starters to breeze through automation by kicking off the RPA Summer School program! With no previous RPA knowledge needed, this flexible, live, or self-paced, program is the perfect opportunity to mix easy learning with your relaxed holiday schedules. Throughout the rest of summer, within a …

This post made by @patent-atanaka received 2 likes!

Task Capture 2021.7 Preview Release

Hi @Anna_Hotsa , I often use Task Capture for my own business automation on a 4K monitor with 5 vertical sides. I feel that ’ Efficiently combine different processes documentation into one project’ is very useful for utilizing existing documents. After utilizing the existing documents, the function i want is the function to replace the text in the title and description.

This post made by @Yoichi received 2 likes!

システムのテーブルについて

こんにちは いくつかのアプローチが考えられますが、例えばこのテーブルをデータスクレイピングで取得 →内容を確認して、何行目が対象のボタンかを把握しておいて、それを指定してクリック することが考えられます。 システム内の赤線で隠したところから探して隣のメールボタンを押す、ということはできるのでしょうか。 相対セレクターで実現できると思いますが、複数ある場合は例えば上記のような工夫が必要になると思います。

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 1 likes!

For Each Row Loop Creation

@Tanzill_Ahsan If I understand you clearly, you want to do as below Type the Customer Number and If the message box appears then you need to go to next customer number If Customer Number Ends with 788 then you need not to execute and go to next entry For this In For Each row place a IF condition and write as row(“Customer Number”).ToString.Endswith(“788”) keep then as blank and in Else you can place Element exist and scrape the Message box Now place If condition and check If Element exist …

This solution provided by @Yoichi received 1 likes!

Add a new item into a dictinary<String,Int32> with "Invoke Method" has failed

Hi, Can you check settings of Parameters as the following? [img20210727-3] Regards,

This solution provided by @vinithareddyk123 received 1 likes!

How to count duplicate rows in a column of the same excel sheet and write it to the new excel file

Hi @enthusiastic You can try below workflow. CountValuesInAColumn.xaml (11.6 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 | 28 July 2021

Top 3 Topics with Most Views

How to print only year from a DataTable(Excel) made by @THIRU_NANI with 38 views.

Replace values of a column of datatable with another value made by @WASEEM_KHAN with 36 views.

https://forum.uipath.com/t/332942 made by @mitul_choudhary with 34 views.

Top 3 Topics with Most Replies

Choosing a single string from an array of strings with dropdown list in Assign Activity made by @private_matter with 35 replies.

I am getting an errorr while i am using split manipulation made by @venkateshcheeni09 with 30 replies.

Use split activity with argument - Error made by @Soudios with 24 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 79 posts!

@prasath17 made 27 posts!

@venkateshcheeni09 made 23 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 6 likes!
https://forum.uipath.com/t/332942/9

This post made by @ppr received 2 likes!

Making the Bot fast-Excel Automation

we would assume that not the LINQ is doing the slow execution. Set Range color will need its time and will take a particular portion from the execution time a possible optimatzation strategy is to do all filtering / dataacrbatics in advance with the outcomde of row index information. So only rows needed to be colored will be colored

This post made by @ermanoj3101 received 2 likes!

Making the Bot fast-Excel Automation

But in that case also lopping will work as their is not always a sequence of row that can be highlighted, the rows can be at any place.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

2019.10.1で作成したRobotでEdgeが使えない

こんにちは 2019.10.1ですと、legacyのEdgeにしか対応していなかったと思うので、UiAutomation Activities PackageもChromium Edgeには対応していないかもしれません。 一度2019.10で作成したプロジェクトのUiAutomationパッケージのバージョンを最新にしてみて試してみてはと思います。

This solution provided by @ppr received 2 likes!

Selectively retrieving data from DataTable

as an alternate Lets assume that strJOBCode / strLocationCode are string Variables which we use for filterings (From d In dtData.AsEnumerable Group d By k=d("Location Code").toString Into grp=Group Where k.Equals(strLocationCode) Let embr = grp.Where(Function (x) IsNothing(x("Job Code")) OrElse String.IsNullOrEmpty(x("Job Code").toString.Trim)) Let fmbr = grp.Where(Function (y) y("Job Code").ToString.Trim.Split(","c).Contains(strJobCode)) Let res = If(fmbr.Count > 0, fmbr, embr) Let ret = If(r…

This solution provided by @qbrandon received 1 likes!

How to get jobs from all folders using Orchestrator HTTP request activity?

if I make direct API calls(without Orchestrator HTTP request activity) and mention foldername in headers, will it return me data from other folders? Yes, you would be able to make it. The reason is that you would be using a direct authentication (user/password or OAuth) rather than relying on the Robot token (which is what the Orchestrator HTTP request uses) Unfortunately this means you will need to handle the auth mechanism yourself. Can I use OAuth for UiPath orchestrator version 2019.10…

---

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

Top 3 Topics with Most Views

Select some fields extracted by screen made by @Aguirre with 48 views.

You want to add a separate sysdate column when using 'data scraping' to send data to db using 'insert activity'. Is there a way? made by @S_Sim with 46 views.

Understanding Ways of Designing RPA Solutions — UiPath made by @Lahiru.Fernando with 40 views.

Top 3 Topics with Most Replies

Select some fields extracted by screen made by @Aguirre with 14 replies.

UiPath Forms Isssue made by @Arun_Kumar4 with 12 replies.

ファイル名から文字列抜き出し 文字列を含むファイル数を取得したい made by @M_H with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 18 posts!

@ppr made 14 posts!

@Akash_N_Jain made 14 posts!

Top 3 Most Liked Posts

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

Understanding Ways of Designing RPA Solutions — UiPath

Robotic Process Automation (RPA) enables the business to automate manual, high-volume processes by introducing a virtual workforce. The processes that we automate may range from low to high complexity, depending on the business process. Hence, it is important to ensure that the design of the automation solution is easy to manage and scale. The following article explains some of the approaches we can take to design a good automation solution. Hope your find this interesting!! Special thanks to…

This post made by @ppr received 3 likes!

Filter datatable using the known start and end values

Assign Acitvity: startIndex (Int32) = dtData.AsEnumerable.toList.FindIndex(Function (x) x("Primary Number").toString.trim.Equals("March 2021")) Assign Acitvity: endIndex(Int32) = dtData.AsEnumerable.toList.FindIndex(Function (x) x("Primary Number").toString.trim.Equals("April 2021")) Assign Activity: dtResult | DataType: DataTable = dtData.AsEnumerable.Skip(startIndex + 1).Take(endindex - startindex - 1).CopyToDataTable

This post made by @ReneSchue received 2 likes!

Monitoring: Queues overview

Please try the following steps: Logon to your orchestrator Navigate to queues-overview Filter for the queue View Transactions Set the filters: status=failed | revision=none | exception=application Select the queue item(s) Click on ‘Mark as verified’ The queue should be green now in the monitoring If you make sure that only verified items are in the queue after they have been finalized, you can make sure that the operations have been properly processed or rightly outsourced. If you and your c…

Top 3 Most Liked Solutions

This solution provided by @ReneSchue received 2 likes!

Monitoring: Queues overview

Please try the following steps: Logon to your orchestrator Navigate to queues-overview Filter for the queue View Transactions Set the filters: status=failed | revision=none | exception=application Select the queue item(s) Click on ‘Mark as verified’ The queue should be green now in the monitoring If you make sure that only verified items are in the queue after they have been finalized, you can make sure that the operations have been properly processed or rightly outsourced. If you and your c…

This solution provided by @dmendgudli received 1 likes!

Orchestrator License change through APi

Hi @Mr.StarLord_AO I looked into the API and I think it can be done using {Patch}/odata/Machines by partially updating machine. There we have a field called Slots (like UnattendedSlots, NonProduction Slots). We can give the required value i.e your run time count there. [image] [image]

This solution provided by @manish_patel received 1 likes!

Continue on error on Get text activity

[image] In properties panel go to the Target and give time in milisecond it will reduce waiting time for getting text

---

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

Top 3 Topics with Most Views

How to achieve format with preceding 10 zeros to any digit in excel? made by @ermanoj3101 with 42 views.

How to get the first file stored in a folder? made by @Andre_Vieira with 40 views.

Will uipath continue after throw made by @pramod_kumar2 with 39 views.

Top 3 Topics with Most Replies

How to get the first file stored in a folder? made by @Andre_Vieira with 30 replies.

Fetching the data from pdf files made by @HeartCatcher with 21 replies.

How to achieve format with preceding 10 zeros to any digit in excel? made by @ermanoj3101 with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 28 posts!

@prasath17 made 18 posts!

@ermanoj3101 made 16 posts!

Top 3 Most Liked Posts

This post made by @ermanoj3101 received 4 likes!

Data table - club Release name column and also calculate time

Hi @Surya_Narayana_Korivipadu , Tried to create linq but it’s only calculating seconds, needs some modification. Check once and let me know how exactly you need data in Total Time. Please mention example. (From r In dtInput.AsEnumerable Group r By k = r(“ReleaseName”).tostring Into grp = Group Let sumstart = grp.Sum(Function (x) x.Field(Of Date)(“StartTime”).TimeOfDay.TotalSeconds) Let sumend = grp.Sum(Function (x) x.Field(Of Date)(“EndTime”).TimeOfDay.TotalSeconds) Let subtract = CInt…

This post made by @Emmanuel received 2 likes!

We are launching the RPA Summer School program!

Excited about this. My two great people, @Nidhi_Chaturvedi and @afe.araromi, are trainers for the program.

This post made by @Anna_Hotsa received 2 likes!

Task Capture 2021.7 Preview Release

Thanks, @patent-atanaka - we’ll check it and get back to you in case we’ll need any clarification

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Not able to enable ignored Activities

Could you please navigate to parent sequence first and then right-click enable

This solution provided by @Gokul001 received 1 likes!

Regex Extraction Digits

Hi @Yudhisteer_Chintaram1 Here is the sample workflow securestring.xaml (6.0 KB) Try this and let me know

This solution provided by @prasath17 received 1 likes!

How to get the first file stored in a folder?

@Andre_Vieira - Please read my post again…i have provided solution for both …See the third one here… [image] Reason why the post is dragging is You have to pay attention and understand what we are showing and telling…if not issue will never get solved…

---

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

Top 3 Topics with Most Views

How to reduce File size(.pdf files) if greater than 5MB? made by @Murli_Manohar with 32 views.

Passing a variable of type string/generic( with data table name as its value) in for each row in data table made by @Pranam_Rai with 32 views.

Excel column data extraction made by @Varunkumar_Saikumar with 32 views.

Top 3 Topics with Most Replies

How to timeout input dialog activity made by @Addy_619 with 8 replies.

Matching values from 2 datatable ( same structure ) without loop row made by @Mr.H with 8 replies.

Image background made by @Amani_Boukadidaaa with 8 replies.

Top 3 Users Who Posted The Most

@jeevith made 13 posts!

@ermanoj3101 made 10 posts!

@NIVED_NAMBIAR made 9 posts!

Top 3 Most Liked Posts

This post made by @iamgeet received 2 likes!

Get Outlook Mail Messages : About Filters, Top, SenderEmailAddress, MailMessage, MutlipleAccount

******************* Get Outlook Mail Messages ******************* Get Outlook Mail Messages Activity : Retrieve the emails from your outlook mailbox. Package : UiPath.Mail.Outlook Properties : 1. Account: Enter the Outlook Email Id. You can also Leave it Empty. In this case, it consider the default email id of Outlook Mailbox. Remember : At a time it can read only one email id of Outlook Mailbox. Multiple Outlook Email Account Available in the Outlook If you wish to access multiple em…

This post made by @supriyo3098 received 2 likes!

How to timeout input dialog activity

Hi Best way to overcome this is to use a parallel activity. Use parallel activity in one side keep Input Dialog Activity and another side keep some Delay (delay within click activity properties) then click activity ( which will click OK or CANCEL on the Input Dialog popup, based on your requirement) You can give condition as well in parallel activity. Hope this idea helps. Note: You can use UiExplorer to capture the input dialog window’s selector. [image] Thanks.

This post made by @jeevith received 2 likes!
https://forum.uipath.com/t/334106/3

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 1 likes!

Matching values from 2 datatable ( same structure ) without loop row

Hi @Mr.H Apart from using join I think this query can help in dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Scope”)= If(dt2.AsEnumerable().Where(Function(r) r(“Name”).ToString.Equals(row(“Name”).ToString)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“Name”).ToString.Equals(row(“Name”).ToString))(0)(“Scope”).ToString, Nothing)) Use this code in invoke code with dt1 as in/out argument and dt2 as in argument here I am assuming that dt1 is Input Table dt2 is Output Table Hope it helps …

---

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

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

[system]

Daily Forum Report | 01 August 2021

Top 3 Topics with Most Views

Insert a value in DataTable made by @Lior_Ben_Naim with 36 views.

Multiple links and extract the particular element made by @nirmalya.sarkar with 30 views.

Update Object Properties: An error has occurred: Access is denied made by @Mohammed_Bakr with 30 views.

Top 3 Topics with Most Replies

"Comma separator in numeric value" transfer from MS excel to MS word document made by @Sojol_Hamid with 11 replies.

Document Understanding excel export error made by @GaneshPalaniappan with 8 replies.

Sending result to set transaction state made by @SudhaT with 6 replies.

Top 3 Users Who Posted The Most

@Srini84 made 11 posts!

@ermanoj3101 made 11 posts!

@GaneshPalaniappan made 5 posts!

Top 3 Most Liked Posts

This post made by @Srini84 received 2 likes!

Transfering excel update to SAP

@Khat Let us know how you are updating the excel file? As @ermanoj3101 said you can have a status column and there while updating the excel file mark the status column as Updated So in the workflow you can filter the datatable as updated records there you can use for each row activity and inside that place your activities to update in SAP system Once it is done you can Change the column status to Success Hope this may help you Thanks

This post made by @it.be.kn received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi! I’m Zen from India. I’m a beginner at RPA, learning to automate processes to reduce the time taken for repetitive manpower. Hope this forum can help to solve some of my issues and concerns. Also, i came here knowing someone in the mentor group to get mentorship.

This post made by @ermanoj3101 received 1 likes!

How to timeout input dialog activity

You can check continue on error property for click.

Top 3 Most Liked Solutions

This solution provided by @supriyo3098 received 1 likes!

How to timeout input dialog activity

Check the property continue on error. under click activity. Also tweak the Time-out value from default (30sec) to some lower number to reduce the waiting time. Mark this answer as solved, if your problem resolves.

---

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

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

[system]

Daily Forum Report | 02 August 2021

Top 3 Topics with Most Views

If activity string variable condition made by @JeffNZ1 with 38 views.

How to delete duplicate and keep only the last row in duplicate entries? made by @Alvin_Apostol1 with 36 views.

Athamas Technologies Pvt Ltd - UiPath Developer - Bangalore - India - Full Time made by @vidyananda.v with 33 views.

Top 3 Topics with Most Replies

Stop the process after catch activity made by @Soudios with 17 replies.

How to find count of a value? made by @taruna.mehra with 12 replies.

How to delete duplicate and keep only the last row in duplicate entries? made by @Alvin_Apostol1 with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 27 posts!

@Yoichi made 24 posts!

@ermanoj3101 made 19 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

Can run multiple lines of query in uipath 'excute query activity'?

Hi @S_Sim, If you decide to use the 2nd method suggested by @RPAForEveryone, then you can refer to solutions in this thread SQL Stored procedure Passing Parameters To fetch particular records to execute your Stored-Procedure via UiPath and get the DataTable from th Database.

This post made by @Moreshwar_Gosavi received 2 likes!

Brilliant platform

Course feedback- I am really very impressed with the overall UiPath platform, the easy access to the academy to learn. Easy to understand language that even a semi-technical/ non-technical person like me also understands the concept. Keep it up!

This post made by @Yoichi received 2 likes!

Help with Regex Expression- To fetch Alpha numeric and numeric values only

Hi, How about the following pattern? [A-Za-z0-9]{4}\d|[A-Za-z0-9]\d[A-Za-z0-9]{3}|[A-Za-z0-9]{2}\d[A-Za-z0-9]{2}|[A-Za-z0-9]{3}\d[A-Za-z0-9]|\d[A-Za-z0-9]{4} Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Help with Regex Expression- To fetch Alpha numeric and numeric values only

Hi, How about the following pattern? [A-Za-z0-9]{4}\d|[A-Za-z0-9]\d[A-Za-z0-9]{3}|[A-Za-z0-9]{2}\d[A-Za-z0-9]{2}|[A-Za-z0-9]{3}\d[A-Za-z0-9]|\d[A-Za-z0-9]{4} Regards,

This solution provided by @postwick received 2 likes!

If activity string variable condition

You should be using Get Workbook Sheets to get the sheets (and their names).

This solution provided by @fostercarly received 1 likes!

UiPath Forms - convert json output result of Date to another format

JSON does not know anything about dates. What .NET does is a non-standard hack/extension. The problem with dates in JSON and really JavaScript in general – is that there’s no equivalent literal representation for dates. In JavaScript following Date constructor straight away converts the milliseconds since 1970 to Date as follows: var jsonDate = new Date(1297246301973); Then let’s convert it to js format: var date = new Date(parseInt(jsonDate.substr(6))); The substr() function takes out the /…

---

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.