Forum Engagement Daily Reports

[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.

[system]

Daily Forum Report | 03 August 2021

Top 3 Topics with Most Views

How to extract the data from the pdf using regex i try but i fail made by @copy_writes with 36 views.

Send SMTP Mail Message not working and getting stuck made by @trigeki with 36 views.

How do I format date to MMM-yy? made by @nicholas.harvey with 33 views.

Top 3 Topics with Most Replies

Outlook Mail error made by @venkateshcheeni09 with 28 replies.

Excel Automatiom made by @HeartCatcher with 27 replies.

Get Outlook Mail message fails sometimes made by @soorya_prasad with 18 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 42 posts!

@manish_patel made 35 posts!

@Gokul001 made 29 posts!

Top 3 Most Liked Posts

This post made by @Tory received 3 likes!

PiP内でEdgeが開きません

自レス 理由解りました！ Extentsion＝拡張機能という意味で PiPの中で手作業で1度Edgeを開き拡張機能でUiPath Web Automationを有効にする 当たり前といえばそうなんですが、気が付くまで時間かかってしまいました。

This post made by @langsem received 2 likes!

How to extract mailbody 1 line by time

Thanks this was very helpfull

This post made by @StefanSchnell received 2 likes!

Restrict Managing Activities Packages via Governance

Hello UiPath Team, a tiny question: Is it possible to restrict the managing of activities packages of the marketplace via the governance? The background is very easy: Not every RPA developer should have the ability to load any package from the marketplace. For security reasons, the packages must be checked and approved before they are used. I read the section Usage of Package Source in the Governance site, but unfortunately it is not apparent to me whether I have the possibility to restrict thi…

Top 3 Most Liked Solutions

This solution provided by @Tory received 3 likes!

PiP内でEdgeが開きません

自レス 理由解りました！ Extentsion＝拡張機能という意味で PiPの中で手作業で1度Edgeを開き拡張機能でUiPath Web Automationを有効にする 当たり前といえばそうなんですが、気が付くまで時間かかってしまいました。

This solution provided by @Yoichi received 2 likes!

データテーブルの先頭行に、一行追加したい。

こんにちは InvokeMethodアクティビティで、DataTableのDataRowCollectionに対してInsertAtメソッドを使えば可能です。以下参照ください。 [img20210803-1] 空の行が追加されますので、必要に応じてデータを追記下さい。

This solution provided by @Sudharsan_Ka received 2 likes!

How to extract the data from the pdf using regex i try but i fail

Hello @copy_writes Here is the regex for the 4th or 5th Line Link: regex101: build, test, and debug regex You can assign it by trimming it Regards Sudharsan

---

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

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

[system]

Daily Forum Report | 04 August 2021

Top 3 Topics with Most Views

Extract the value using regex made by @Lokesh_Raj_R_M with 41 views.

Error find element? made by @fairymemay with 37 views.

DateTime tryparse is returning false for 24 hour date format made by @Surya_Narayana_Korivipadu with 35 views.

Top 3 Topics with Most Replies

Extract the value using regex made by @Lokesh_Raj_R_M with 19 replies.

Splitting string error made by @HeartCatcher with 17 replies.

Error find element? made by @fairymemay with 17 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 44 posts!

@ppr made 32 posts!

@sonaliaggarwal47 made 24 posts!

Top 3 Most Liked Posts

This post made by @LevKushnir received 2 likes!

SAP in PIP maximum screen

Hi @kiko.wei Currently PiP is not DPI-aware, so for display scaling > 100% some problems might appear: blurry PiP window resolution mismatch Please try to setup the resolution of your display to 100% and see if this is the cause of the issue. Looking forward to hearing from you Best regards, Lev

This post made by @Yoichi received 2 likes!

Regex to extract a number between a dynamic number

Hi, Can you check the following pattern? System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Invoice Amount [\d.,]+ )[\d.,]+").Value or it might work if we use Matches activity with the pattern : "[\d.,]+" It returns multiple matches. Regards,

This post made by @sonaliaggarwal47 received 2 likes!

Allocote license

Hi @Amani_Boukadidaaa, Also below links might be useful to gain more understanding on licensing: https://licensing.uipath.com/ [image]UiPath Robot About Licensing About To fast-track your deployment time and easily manage activation from a centralized location, Robot licensing is available in Orchestrator, on a per tenant basis, in the License page. Here you can upload, renew, or remove a license with just a… [image]UiPath Orchestrator Licensing To fast-track your deployment time and e…

Top 3 Most Liked Solutions

This solution provided by @Michelle_Yurovsky received 2 likes!

Power BI -> Orchestrator API/SQL Server

Here’s a blog post I wrote that should help you - Intro to Logging - RPA Reporting and Analytics | UiPath Keep in mind, our marketplace solution is only for the on-prem orchestrator. For reporting from the cloud orchestrator, you can leverage the orchestrator APIs or if you’re just interested in logs, the log export feature and connect your cloud storage of choice to power BI. That being said, a lot of people find reporting via APIs to be difficult. for your on-prem orch, DEFINITELY do not con…

This solution provided by @ppr received 1 likes!

DateTime tryparse is returning false for 24 hour date format

use HH instead of hh

This solution provided by @Mathkar_kunal received 1 likes!

Error while installing UiPath 2021.4.4(visual studio version error)

I have installed microsoft visual studeo office runtime 2010 and checked for installation again and worked fine.

---

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

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

[system]

Daily Forum Report | 05 August 2021

Top 3 Topics with Most Views

How many time it retry in REFramework? made by @iamgeet with 63 views.

How to learn SQL fast made by @taruna.mehra with 56 views.

Filtering the date made by @HeartCatcher with 49 views.

Top 3 Topics with Most Replies

Can anybody please help me why i am getting this error? made by @ShivamDumka with 11 replies.

How to download a file as per todays date made by @Ankita_Biswas with 10 replies.

Filtering the date made by @HeartCatcher with 10 replies.

Top 3 Users Who Posted The Most

@sonaliaggarwal47 made 28 posts!

@Sudharsan_Ka made 18 posts!

@gabrielribas4 made 15 posts!

Top 3 Most Liked Posts

This post made by @RockSolid received 2 likes!

Issue - Job stopped with an unexpected exit code 0xE0434352

Hi All, So, in case somebody comes here, and none of the other options works for him/her, let me share what worked for me since I was having the same issue: I think my problem was related to the fact that all those read and write activities where inside a an invoked workflow, inside a Loop. At every second iteration of the loop, the function would throw this unexpected error. The thing that worked for me was to set the Invoke workflow as Isolated. Simple but it worked. Why it worked… Only the…

This post made by @toran received 2 likes!

Excelで罫線を含まずに最終行を取得する方法について

「データ テーブルをフィルタリング」アクティビティでIs Emptyの行を削除して DataTable変数.Rows.Countで最終行の取得ができました！ありがとうございます

This post made by @Yoichi received 2 likes!

Uipath Assistantに表示されない

こんにちは Orchestratorに接続されている場合、Orchestrator側の設定が必要になります。 大きくは OCにパッケージをパブリッシュまたは手動でアップロード ↓ プロセスの設定 になります。 （ベースとしてのユーザー設定やフォルダ・権限設定は必要になるかもしれません） おそらく、本日POSTされた以下トピックと同様の話になるかと思います。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Uipath Assistantに表示されない

こんにちは Orchestratorに接続されている場合、Orchestrator側の設定が必要になります。 大きくは OCにパッケージをパブリッシュまたは手動でアップロード ↓ プロセスの設定 になります。 （ベースとしてのユーザー設定やフォルダ・権限設定は必要になるかもしれません） おそらく、本日POSTされた以下トピックと同様の話になるかと思います。

This solution provided by @jeevith received 2 likes!

Advice on Split String [{},{}]

Hi @Cesar_Cotom, By looking at the queue item, it is clear that the disptacher has serialized a datatable into json string as value for in_Licenses key in your queue data. There is a better way to get all of the key-value pairs in_Licenses in one go instead of getting ID, AppName, Start_Data, End_Date, Quantity separately. I assume here that the number of items in the json array (length of array) will be dynamic. Approach Ensure you have the UiPath.Web.Activities package. This package al…

This solution provided by @manish_patel received 2 likes!

Job trigger in orchestrator on basis of file

you can use a queue base trigger in the loop use add queue item, whenever it got the file it will populate a queue and push output into orchestrator use queue base trigger for the process, whenever new transaction added process will automatically got triggered thanks

---

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

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

[system]

Daily Forum Report | 06 August 2021

Top 3 Topics with Most Views

Click text (wrong text) made by @Maria99 with 32 views.

Outlook MaiL message activity made by @venkateshcheeni09 with 30 views.

How to convert date format extracted in pdf in uipath made by @anonymous3 with 27 views.

Top 3 Topics with Most Replies

Outlook MaiL message activity made by @venkateshcheeni09 with 31 replies.

Click text (wrong text) made by @Maria99 with 13 replies.

How to get compare the datatable with another datatable made by @manjula_rajendran with 12 replies.

Top 3 Users Who Posted The Most

@Dawodm made 33 posts!

@sonaliaggarwal47 made 21 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Arguments issue

there is a missmatch between the arguments defined by the XAML and the used Arguments on Invoke Workflow file Activity. Just go the Invoke Workflow File Activity - click on Import Arguments and correct it

This post made by @prasath17 received 2 likes!

For each row | pdfs file in folder

@Markus3003 - Please check this… My PDF files in the “DeleteFiles” Folder [image] [image] Directory.GetFiles("YourFolderName").Select(function(d) new fileinfo(d).Name.Substring(0,6)).toarray Assign the above code to stringArray … and then use For Each loop and Search in SAP… If you use (0,4) in the substring…you will get first 4 digits…

This post made by @prasath17 received 2 likes!

For each row | pdfs file in folder

Simple… [image] Directory.GetFiles("YourFolderName").Select(function(d) "5555"+ new fileinfo(d).Name.Substring(0,6)).ToArray

Top 3 Most Liked Solutions

This solution provided by @ShivamDumka received 1 likes!

Can anybody please help me why i am getting this error?

Thank you all for helping me, So i did some changes(was just doing experiment to the statement in the 1st assign activity ) and as soon as i removed (.toString) from Directory.Getfiles(“path”),it worked because what i was doing was,trying to assign this string to a 1-dimensional array of objects which is not possible with string Thought to update you all coz you all were helping me. Thanks Shivam

This solution provided by @Yoichi received 1 likes!

Click text (wrong text)

Hi, Thank you for sharing. Can you modify as the following? First, Click “Indicate on screen” of Click Activity and select whole desktop (not your application) The selector will be as the following, for example. "<wnd app='explorer.exe' cls='Progman' title='Program Manager' /><wnd cls='SysListView32' title='FolderView' />" Then, modify CursorPosition- OffsetX, OffsetY and Position as the following image [img20210806-7] Regards,

This solution provided by @Dawodm received 1 likes!

How to read excel by rows fastest?

Then try this statment: dt.Select(“ID=”+NumFile.ToString).CopyToDataTable Sequence23.xaml (6.4 KB) Please let me know if it works for you

---

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

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

[system]

Daily Forum Report | 07 August 2021

Top 3 Topics with Most Views

WEBの要素数が知りたい made by @196006 with 28 views.

There are 2 to 3 href link in web pages. How to get one of them? made by @Smruti_Smita_Samal with 27 views.

Scenario based question made by @Rakesh_Tiwari with 27 views.

Top 3 Topics with Most Replies

There are 2 to 3 href link in web pages. How to get one of them? made by @Smruti_Smita_Samal with 12 replies.

Data tables made by @adirb with 7 replies.

How to make like these type instructions? made by @Deepak_Gautam with 7 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 11 posts!

@Arif_Kilic made 9 posts!

@Dawodm made 8 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 2 likes!

Joining 2 string arrays to one singe array with unique values

@Pradeep.Robot - Please check this… [image]

This post made by @Pradeep.Robot received 1 likes!

Joining 2 string arrays to one singe array with unique values

Thanks @prasath17 . It works

This post made by @florent.mathey received 1 likes!

CompressFiles Activity filename issue - the first letters of files are deleted

I’ve switched to the Zip activity of the Balareva.External library

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Joining 2 string arrays to one singe array with unique values

@Pradeep.Robot - Please check this… [image]

This solution provided by @Yoichi received 1 likes!

Extracting Data from Excel using Column Alphabet instead

Hi, But I just need help if there is a way to extract the data by typing in the column alphabet for example column B from excel to be “B” into the input dialog instead of keying in “2”. Can you try to use the following expression? UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(ColumnLetter) ConvertColumnLetterToColumnIndex method returns index number of the column like R1C1 style. For example, if you set "B" in the above expression, it returns "2". Regards,

This solution provided by @sonaliaggarwal47 received 1 likes!

Robot Creation -- Help

Hi @Anjali_Rani, It happens bcoj of modern folders enablement. There will be no Robots and environments tabs at folder level. Also, Robot creation is different in this case. Go to machines at tenant level, create a standard machine or machine template, connect that machine to user at folder level. Once connection is made, you will automatically see your robot getting created under robots folders at tenant level. To verify that folder is a modern folder, go to tenant → folder → navigate to y…

---

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

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

[system]

Daily Forum Report | 08 August 2021

Top 3 Topics with Most Views

Error in using DateTime.Parse method in assign activity made by @tushar.tripathi with 27 views.

Comparing 2 dataTable and filtering according to row values made by @Arif_Kilic with 25 views.

DateTime.ParseExact always gives me date in dd/MM/yyyy, even though my string is in yyyy/MM/dd made by @guilherme.rebordao with 25 views.

Top 3 Topics with Most Replies

Click Activities in web browser made by @SH_94 with 10 replies.

How to enter the delay in minutes by variables? made by @Deepak_Gautam with 9 replies.

How to make automatic detetcr for media files? made by @Deepak_Gautam with 9 replies.

Top 3 Users Who Posted The Most

@Deepak_Gautam made 21 posts!

@Dawodm made 10 posts!

@SH_94 made 10 posts!

Top 3 Most Liked Posts

This post made by @Turab_Haider received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

HI All Turab here from Pakistan. I am an accountant by profession and new to RPA. My objective is to automate daily routine accounting tasks so we as accountant focus on analysis and value addition for our clients rather than doing routine adhoc tasks which RPA can do. I hope you all are there to help ne in my issue

This post made by @prasath17 received 1 likes!

For each row | pdfs file in folder

@Markus3003 - You have used incorrect activity…Instead of using “For Each” , you have used “For Each Row” which should have used for Datatable/datarow etc… [image]

This post made by @Yoichi received 1 likes!

Excelアプリケーションスコープの高速化

こんにちは あくまで一般論ですが、ファイルIOはメモリ上の動作にくらべてかなり低速です。 そのため、ファイルへの書き込みを複数回行うよりも、メモリ上の操作を複数回して ファイル書き込みを１回にするほうがパフォーマンスは高くなるケースが多いです。 上記の場合は、アクティビティの数が1つ増えるだけ（ワークブック保存）のように 見えますので、やはり最後に保存するほうがパフォーマンスの面では有利かと思います。

Top 3 Most Liked Solutions

This solution provided by @Dawodm received 1 likes!

Help with data table issue

Add Read Range Activity and save the data in variable ExcelDT for example Add For Each Row activity Add Assign acitivty in it: row(“Product_Price”) = row(“Product_Price”).ToString.Replace(“$”,“”) Instead of $ set your currency See the attached file Sequence25.xaml (6.1 KB) Best regards Mahmoud

---

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

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

[system]

Daily Forum Report | 09 August 2021

Top 3 Topics with Most Views

How to match values in excel with values in a dictionary key made by @Mpumi_Setshedi with 35 views.

Add data from column 3 to column 1 made by @nirmalya.sarkar with 34 views.

Need helps with creating if condition made by @Khanh_Nguyen with 30 views.

Top 3 Topics with Most Replies

Add data from column 3 to column 1 made by @nirmalya.sarkar with 12 replies.

How to save multiple variable value in excel/csv made by @Smruti_Smita_Samal with 9 replies.

How to break captcha from GST site made by @THIRU_NANI with 9 replies.

Top 3 Users Who Posted The Most

@sonaliaggarwal47 made 20 posts!

@AndyMenon made 15 posts!

@Gokul001 made 14 posts!

Top 3 Most Liked Posts

This post made by @ranjith received 2 likes!

How to filter the column if cell contains specific keyword?

Hi @Dorothy_lee You can use linq query to achieve your requirement. (from x as DataRow in dtInptut where x("Name").ToString.Contains("joy") select x ).CopyToDataTable

This post made by @copy_writes received 2 likes!

How to filter the column if cell contains specific keyword?

Hi Dawodm if use like this i hope you are not get the out put because bot will search only joy so if the row (name ) = joy means it will search only joy not joydema she is asking joy or joydema she want to filter those things so use like this row(“name”).Contains(“joy”) I hope you understood what am try to say Thanks Chethan P

This post made by @Dawodm received 2 likes!

How to filter the column if cell contains specific keyword?

Hi @copy_writes Ah ok thanks for the feedback. I didn’t see it. I though she searches for joy. row(“name”).Contains(“joy”) Works if it is no matter where is the joy keyword. But @Dorothy_lee if you search for only joy at the beginning you have to set it so: row(“Name”).ToString.Substring(0,3) = “joy” → Here you check only the first three characters. Best regards Mahmoud

Top 3 Most Liked Solutions

This solution provided by @T0Bi received 2 likes!

Copy and Pasting data within the same excel sheet

Use the Read Range Activity to read the data and the Append Range Activity to add it to the end of your range. If this has helped you, please mark this answer as the solution.

This solution provided by @sonaliaggarwal47 received 2 likes!

Computer Vision activities on On Premise Orchestrator

Hi @alvaro.j.nobre, Per my understanding, CV feature is not available on on-prem orchestrator unless you specifically setup a server for same. Same goes with AI/ML features. Regards Sonali

This solution provided by @prasath17 received 1 likes!

For each row | pdfs file in folder

@Markus3003 - In that case, change your logic as shown below… For Each code should be Directory.GetFiles(“YourFolderName”) Here Each File will give you the path name and next “5555” + path.GetFileName(Eachfile).Substring(0,6) will give you the invoice #… [image]

---

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

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

[system]

Daily Forum Report | 10 August 2021

Top 3 Topics with Most Views

Stuck at Restoring Dependency and unable to find Uipath.pdf.activities package made by @Ankit_Kanjilal with 43 views.

How to use regex? made by @Maria99 with 41 views.

Unknown exception made by @ILYA_KUBYSHIN with 37 views.

Top 3 Topics with Most Replies

IE error made by @HeartCatcher with 26 replies.

Stuck at Restoring Dependency and unable to find Uipath.pdf.activities package made by @Ankit_Kanjilal with 16 replies.

How to get a dynamic folder path created at run time? made by @Andre_Vieira with 13 replies.

Top 3 Users Who Posted The Most

@sonaliaggarwal47 made 50 posts!

@ppr made 22 posts!

@Srini84 made 14 posts!

Top 3 Most Liked Posts

This post made by @Surya_Narayana_Korivipadu received 3 likes!

Connected unlicensed

@Forum_Staff I’ve a feedback here. Can you please get someone from UiPath to document all possible problems while connecting studio to orchestrator? Also can you ask them to document solutions as well. I’ve seen many users facing this issue and everyone has a different problem which caused this issue. Or else, this should be an easy process to connect studio to orchestrator. It shouldn’t trouble many users with different causes and same error. I’ve seen many posts in the same forum regarding …

This post made by @prasath17 received 3 likes!

Multiple If Statements for Values in PDF document

@jorisveldt - We can try with Regex’s OR condition as shown below… [image]

This post made by @kiko.wei received 2 likes!

SAP in PIP maximum screen

okay well noted. Thanks Lev!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to use regex?

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"(?<=_)\d+").Value Regards,

This solution provided by @HANACCHI received 1 likes!

予期しない終了コードでジョブが停止されました: 0xE0434352

③の所で結合した結果が巨大になる事がありますね。 例えば、あるキー1行に対して、入力データテーブル2側のキーが10行あるとしたら、結合後の行は10行となります。 ですので、 １）双方で、処理に使わない行は予め削除しておく。 ２）入力テーブル1を更にデータ行を分割してから結合し、範囲へ書き込みし、 次の結合結果を展開する際に、範囲の指定を先の書き込みの次のセルに なるようにする なかなか骨がおれますね。 ※かつて、Dtでのこちゃこちゃするのが大変だったので、一度CSVに出力させてロボ分割した事もあります。Hi

This solution provided by @Srini84 received 1 likes!

Check if a date expired or not

@Andre_Vieira Check below for your reference [image] You can remove .ToString from the convert.Datetime Hope this helps you Thanks

---

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

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

[system]

Daily Forum Report | 11 August 2021

Top 3 Topics with Most Views

New layout for the Uipath studio made by @SH_94 with 32 views.

How to filter the excel row with dynamic key words? made by @Dorothy_lee with 30 views.

Adding new row to excel from multiple xlsx/csv made by @Vi_ciel with 29 views.

Top 3 Topics with Most Replies

Getting certain part of a long strict from an Outlook Email made by @Saltukhan_Dura with 17 replies.

Extracted pdf invoice file need to move to other folder made by @chaitanyaKumar with 16 replies.

How to share a post in facebook groups? made by @lelouch with 15 replies.

Top 3 Users Who Posted The Most

@SHAF_MAIRAJ made 38 posts!

@Yoichi made 17 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Custom inputアクティビティのブラウザ変更

こんにちは このアクティビティはブラウザを開いているのではなく、IEコンポーネントを利用していると 思いますので、別ブラウザで開く等はできないと思います。 直近で類似のトピックが上がっていますので、以下も参照いただくと良いかもしれません。

This post made by @prasath17 received 2 likes!

How to filter the excel row with dynamic key words?

@Dorothy_lee - You can try like this… First Read the column where you have the keywords to an String Array using the below code… Dt2_HSBC_001.AsEnumerable().Select(Function (a) a.Field(of string)("Column Name").ToString).ToArray After that use the below code to check whether Name column contains any value in the array… (from x as DataRow in Dt2_HSBC_001 where Array.Contains(x("Name").ToString) select x ).CopyToDataTable Hope this helps.

This post made by @aito received 2 likes!

エクセルファイルのデータをウェブページの欄へコピペする方法

N2027さま ご教示くださり、ありがとうございます。私は、StudioX 2021.4.4 Community Licenceを使っています。アクティビティーに[クリップボードに設定]と[ホットキーを押下]が見当たらなかったため、代用できそうなもの、具体的には[セルの値を読み込み]と[キーボードショートカット]を使ってみました。その結果、自分の思うように出来上がりました。ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Custom inputアクティビティのブラウザ変更

こんにちは このアクティビティはブラウザを開いているのではなく、IEコンポーネントを利用していると 思いますので、別ブラウザで開く等はできないと思います。 直近で類似のトピックが上がっていますので、以下も参照いただくと良いかもしれません。

This solution provided by @poorna_nayak07 received 1 likes!

How to filter the excel row with dynamic key words?

Hi @Dorothy_lee , Follow below steps. [image] Read KeyWord Excel into one datatable(KeyWordDT) and convert it to Array of Keywords as below KeyWordArr=KeyWordDT.AsEnumerable().Select(Function (a) a.Field(of string)("Column Name").ToString).ToArray Read target excel into Datatable (InputDT). Assign ResDT=InputDT.Clone Use below expression in assign activity. ResDt=(From row in InputDT.Asenumerable Where KeyWordArr.AsEnumerable.Where(Function(x) row("ColName").ToString.Trim.Conta…

This solution provided by @Yoichi received 1 likes!

What is the difference of Host based licensing vs. Tenant based licensing?

Hi, Do you use on-premise OC? Which is better to use, host-based licensing or tenant-based licensing? It depends on your requirement. If you need to move license from a tenant to other, host-base license (One License per Multiple Tenants) is better. In the license tab in tenant host under Unattended it is displaying “12 runtimes of 12”. Does this mean we have 12 unattended licenses available which are already allocated and are not expired? This is just for confirming, as I am having a dou…

---

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

Top 3 Topics with Most Views

How can i match with 2 values in pdf using uipath made by @anonymous3 with 53 views.

No selector. How to click? made by @jeyekij306 with 52 views.

Extract data from Yahoo Finance made by @kkarbassian with 50 views.

Top 3 Topics with Most Replies

Couldn't extract the correct text from browser made by @JacelynLok08 with 22 replies.

In AI center, ML skilled deployed but giving error made by @Monika_Neeboriya with 19 replies.

How can i match with 2 values in pdf using uipath made by @anonymous3 with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 22 posts!

@Yoichi made 21 posts!

@ppr made 14 posts!

Top 3 Most Liked Posts

This post made by @sunny_singh received 2 likes!

UiPath Cloud Masters

thank you @Vibhor.Shrivastava @Ishmeet_Bindra @loginerror @Syed_Pasha and entire community thank you heaps guys

This post made by @Ishmeet_Bindra received 2 likes!

UiPath Cloud Masters

Hi All, We have our Week 3 (AWS Cloud Edition) winner. Congratulations @sunny_singh for winning last week’s challenge. Details about his submission - Idea - 𝐌𝐞𝐝𝐢𝐜𝐚𝐥 𝐈𝐃 𝐆𝐞𝐧𝐞𝐫𝐚𝐭𝐨𝐫: This project will help in the generation of ICD-1-CM codes and entities and Traits for Clinical studies. Generally, this takes a lot of time as generating such codes is a tedious task. We implemented a solution that uses AWS Comprehend to generate codes quickly and can be a lifesaver in some cases. …

This post made by @Tatsuya899 received 2 likes!

Edgeでwebから名前を付けて保存

Chromeブラウザかと思っていました。 セレクターを変更して、クリックをシュミレート解除したら上手くいきました。 ありがとうございます。

Top 3 Most Liked Solutions

This solution provided by @MMoura received 1 likes!

"Indicate Element" doesn't work with Default UiEngine for Desktop Applications

Thanks for the reply @ClaytonM I managed to solve it in a different way. There was no need to update the .net framework, but I had to modify all registry values mentioned here (Repairing Active Accessibility Support) to {03022430-ABC4-11D0-BDE2-00AA001A1953} in the ProxyStubClsid32 sub-key. I also had to delete all “TypeLib” subkeys in the mentioned registry keys. My main concern is that the solution mentioned by UiPath haven’t worked, so I had to improvise a bit, other than that, it’s fine.…

This solution provided by @RPAForEveryone received 1 likes!

Read and download 1 email at the time

Hi @Andre_Vieira It’s hard to assess from your workflow which mail activity you’re using to retrieve email. But all ‘Get Mail’ activities have some way of limiting the number of emails retrieved at one time. Checkout the Top option under the Options section here: https://docs.uipath.com/activities/lang-en/docs/get-outlook-mail-messages#options Get Exchange Mail Messages Top -The number of messages to be retrieved, starting from either the newest or the oldest, depending on the OrderByDa…

This solution provided by @Yoichi received 1 likes!

Need Help for Sum of the first "n" odd-valued elements

Hi, Can you try to add index variable in index property of ForEach and modify condition as the following? [img20210812-8] Note: index of ForEach is 0-based. So even number of the index is odd number as we count it 1 based. Sequence3.xaml (8.1 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 | 13 August 2021

Top 3 Topics with Most Views

Excel tables made by @pari_patel with 33 views.

Difficult situation in uipath in real time? made by @Pavani_Vankayala with 32 views.

Detect download button in the browser made by @SH_94 with 31 views.

Top 3 Topics with Most Replies

My uipath studio not working? made by @Deepak_Gautam with 10 replies.

Group Excel Cells made by @luan.quirino1 with 9 replies.

Get Text not working in Anchor Base made by @tilarapiyush with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 17 posts!

@Deepak_Gautam made 13 posts!

@Monika_Neeboriya made 10 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

Where can we learn Orchestrator's database Data Model?

@CosminV Hello George, I know this is an old post, but here a business use case where it is necessary to know the Orchestrator’s data model: Let’s say in a company all audit data of all applications, which are in use, are collected centrally. The collection of this type of data is not uncommon for large companies, as it is required for revision purposes, e.g. in insurance and banking. As @loginerror wrote here, UiPath Orchestrator doesn’t offer the possibility to redirect this kind of data. H…

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

This post made by @postwick received 2 likes!

Detect download button in the browser

Use Find Children

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Detect download button in the browser

Use Find Children

This solution provided by @T0Bi received 1 likes!

Different outputs and results between the Studio and the robot

But you’re always creating a new Random object which resets the seed. Try creating the Random object outside of your loop rand = new Random() and then use .Next() in your loop randomInt = rand.Next(89)

This solution provided by @ppr received 1 likes!

I am getting eror into syudio?

ensure that feeds are enabled by following: [grafik] Also check if machine is ready to fetch packages from internet (maybe blocked by firewall rules)

---

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

Top 3 Topics with Most Views

Uploading a file with a FORM made by @Andre_Vieira with 30 views.

UIPath Click Toolbar - Indicate on screen doesn't recognize made by @Tiago_Dias with 24 views.

How to iterate over all the values of a table to check a condition made by @Josep with 23 views.

Top 3 Topics with Most Replies

Transactions keep repeating after finishing once made by @clumsily with 11 replies.

Remove email attachment of excel from outlook email and add new excel attachment made by @Suresh_reddy2 with 9 replies.

Uploading a file with a FORM made by @Andre_Vieira with 8 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 14 posts!

@Dawodm made 10 posts!

@clumsily made 7 posts!

Top 3 Most Liked Posts

This post made by @Andre_Vieira received 2 likes!

Uploading a file with a FORM

Hi again @NIVED_NAMBIAR job done. [image] [image] Thank you

This post made by @NIVED_NAMBIAR received 2 likes!

Uploading a file with a FORM

Can u try to deserialize the json and then extract the file path and see if it is working for your case

This post made by @StefanSchnell received 1 likes!

Interacting with Multiple SAP Windows

@Karoweiss Hello Karoweiss, please look at this interesting SAP presentation about SAP GUI Scripting API at slide 20 et seq. about the object model. To differentiate between two equal SAP sessions via the session number you can use the attribute sapSession. [image] Add it to your selector and it should work. Best regards Stefan

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Uploading a file with a FORM

Can u try to deserialize the json and then extract the file path and see if it is working for your case

This solution provided by @tilarapiyush received 1 likes!

Get Text not working in Anchor Base

Hi, I got the solution doing below steps. Used ‘Indicate anchor’ function in UiExplorer (as suggested by @Ryba ) and then selected the CSS Selector attribute. Also I unchecked few attributes and used wild characters to make my selector more dynamic. Thanx everyone for help.

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to Replace Words In a Text File

Hi @Ajit_Chowdary Answer for your solution is here Main.xaml (9.8 KB) Mark it as solution if it helps you 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 | 15 August 2021

Top 3 Topics with Most Views

I need to read multiple file paths from an excel and delete files which are more than 30 days made by @kushal.vetsa with 25 views.

How can we convert pdf document into word document made by @Durvesh_Bendale with 25 views.

How to write log in excel? made by @Maria99 with 25 views.

Top 3 Topics with Most Replies

I need to read multiple file paths from an excel and delete files which are more than 30 days made by @kushal.vetsa with 11 replies.

Problem On Excel made by @nirmalya.sarkar with 9 replies.

Loop through Columns and pasting the data into a web page made by @Bhanu_Rathore with 5 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 14 posts!

@NIVED_NAMBIAR made 10 posts!

@kumar.varun2 made 8 posts!

Top 3 Most Liked Posts

This post made by @whelandexter received 2 likes!

This question seems incorrect, can someone confirm?

Feedback about the Data Manipulation Academy course. Please type your feedback below. [image] this question seems to indicate that ‘generate data table’ is the answer but ‘output data table’ is the action you would use to put data from a datatable into a string. Can someone confirm?

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

Sort datatable data based on one column

Hi @clumsily Another way to achieve the same. [image] dt.AsEnumerable.OrderBy(Function (r) r("Brand").ToString).CopyToDataTable.DefaultView.ToTable(False, {"Brand", "Name", "Price"}) Finally you can write dt in excel file using Write Range

This post made by @Bachali received 1 likes!

Component for Data Table activities

Hi Lahiru, Could you please let me know the exact package name where we can calculating SUM, AVG, MIN, MAX, COUNT, STANDARD DEVIATION AND VARIANCE Thanks in advance . Regards, Akhil B

Top 3 Most Liked Solutions

This solution provided by @Durvesh_Bendale received 1 likes!

Invoke Workflow

Hi @Amani_Boukadidaaa I guess you wanted to show email subject in message box. for this you need to change out_email argument direction to ‘in’ because you are passing email value to subject workflow.

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

How to use the last element of a list of integers in uipath?

@gh_lzm Try This CutPage.AsEnumerable.Reverse.Take(2).Last.ToString

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

I need to read multiple file paths from an excel and delete files which are more than 30 days

@kushal.vetsa For the input excel file like below [image] Check the updated xaml file read multiple file paths from an excel and delete files which are more than 30 days.xaml (8.7 KB) This can further be optimized by using the root directory path which contains all the folders. For that I would suggest to explore the Directory.GetFiles() method.

---

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

Top 3 Topics with Most Views

Object reference not set to an instance of an object eror made by @Duygu_Ozdemir with 44 views.

Excel activity in UiPath made by @Sojol_Hamid with 28 views.

Multiple Assign activity error made by @venkateshcheeni09 with 28 views.

Top 3 Topics with Most Replies

Multiple Assign activity error made by @venkateshcheeni09 with 31 replies.

Object reference not set to an instance of an object eror made by @Duygu_Ozdemir with 18 replies.

Please Help. Could not find of part the path, Unattended made by @Hurmet_Noka with 17 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@pravin_calvin made 23 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

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

This question seems incorrect, can someone confirm?

@whelandexter Yes, you are correct. The answer to the question is wrong. It should be Output Data Table.

This post made by @Yoichi received 2 likes!

データテーブル内のレコードを自然順に並べ替えたい

こんにちは エクスプローラーと全く同じ挙動を実現するにはそれなりに実装や他のライブラリが必要になると思います。 もし特定の条件下での並べ替えだけでよければ、その仕様を共有いただけると、それ用の式は書けるかもしれません。

This post made by @StefanSchnell received 2 likes!

How to Realize a Local Web Environment

If you develop automation workflows in restricted environments, e.g. which have no access to the internet, so it is necessary to provide a web server with the all needed content locally. In this guide I will describe how to realize a local web environment easily. First step is to download all necessary programs and data, which are then transferred to the restricted environment. These programs are needed: UiPath Studio Google Chrome Offline Installer for Windows x64 Baby Web Server a simple …

Top 3 Most Liked Solutions

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

This question seems incorrect, can someone confirm?

@whelandexter Yes, you are correct. The answer to the question is wrong. It should be Output Data Table.

This solution provided by @ppr received 2 likes!

Regex "after and before word"

[grafik] and group: [grafik]

This solution provided by @ppr received 2 likes!

Split String with a maximum of 40 characters and end with full words/characters

@thorem99 [grafik] [grafik] Find starter help here: Regex_SplitParts_MaxCharLength_NoWordBreak.xaml (9.5 KB)

---

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

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

[system]

Daily Forum Report | 17 August 2021

Top 3 Topics with Most Views

How to use Linq? made by @Maria99 with 41 views.

(Modern) Combining all the recorders into one was a mistake made by @postwick with 39 views.

Regex to check if subject format was followed made by @mnlatam with 36 views.

Top 3 Topics with Most Replies

Group matching rows together made by @RPA-botDev with 15 replies.

Click Link in WebPage Based on Keyword made by @hsendel with 11 replies.

Studio Extension not appearing in Edge store made by @Automater999 with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 21 posts!

@pravin_calvin made 16 posts!

@RPA-botDev made 10 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

動作の際、よく起こるエラーの改善案があればアドバイスください。

こんにちは 取り急ぎ下記確認させてください。 １．テキストエディタを立ち上げてそこに貼り付け、とのことですが この方法で行っている理由があるのでしょうか？ なおUiPathではクリップボードの内容を読み込んで、そのまま テキストファイルに出力することができます。 ２．Win+Rで何かを打ち込んで起動していますが、Use Applciation やOpen Applciation、Start Process等を使わない理由は何かあるのでしょうか？

This post made by @DaliyaK received 2 likes!

CoE Summit | September 7-16 - Everything you want to know about an RPA center of excellence!

Hi everyone! There’s been a lot of questions around the automation center of excellence and we decided to address them at the upcoming CoE Summit From September 7 to 16 we’ll host four webinars where automation leaders of AGL Energy (Australia), NOS (Portugal), Ingram Micro (USA), and our own RPA CoE will discuss the importance of a dedicated automation team at your company, and answers some questions like: How to prioritize automation ideas? Which automations are built by the…

This post made by @shunsuke.ogata received 2 likes!

データテーブル内のレコードを自然順に並べ替えたい

皆様 お世話になっております。 大変恐縮なのですが、 以下の内容を参考に実装を行ったところ、無事に解決いたしました。 解決に尽力いただきましてありがとうございました。 またわからないことが出た際にはご質問させてください。

Top 3 Most Liked Solutions

This solution provided by @shunsuke.ogata received 2 likes!

データテーブル内のレコードを自然順に並べ替えたい

皆様 お世話になっております。 大変恐縮なのですが、 以下の内容を参考に実装を行ったところ、無事に解決いたしました。 解決に尽力いただきましてありがとうございました。 またわからないことが出た際にはご質問させてください。

This solution provided by @ppr received 2 likes!

Compare two columns from different datatable

Lets assume that dt1, dt2 have the same row count Create a report DataTable with build datatable activity Cols: C1, C2, Result - dtReport Assign activty: Left Side: dtResult Right side: (From i in Enumerable.Range(0, dt1.Rows.Count) Let chk = dt1.Rows(i)(0).toString.Trim.Equals(dt2.Rows(i)(0).toString.Trim) Let rs = IF(chk,"Correct","InCorrect") Let ra = new Object(){dt1.Rows(i)(0),dt2.Rows(i)(0),chk} Select r=dtReport.Rows.Add(ra)).CopyToDataTable i case of you need a different output / …

This solution provided by @Steven_McKeering received 1 likes!

Remove text before a word

Hey You can use Regex to achieve this! Try using this link to preview/play with the result. In UiPath Studio - use an Assign activity like this. Str_Variable = System.Text.RegularExpressions.Regex.Replace(YOURINPUTSTRING, “[\s\S]*(?=IMPORTANT)”, “”) GIve it a go

---

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.