Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 August 2022

Top 3 Topics with Most Views

SAP: Selector could not be found made by @azeem_rosli with 35 views.

Merge different Arrays into a sequence and generate Email body made by @anjasing with 34 views.

Not able to get table data from desktop application made by @gg00857020 with 31 views.

Top 3 Topics with Most Replies

SAP: Selector could not be found made by @azeem_rosli with 11 replies.

Not able to get table data from desktop application made by @gg00857020 with 10 replies.

Excel formula not working made by @Pradyumn_Agrawal1 with 7 replies.

Top 3 Users Who Posted The Most

@jack.chan made 11 posts!

@Kane_Baden1 made 10 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @ahmad_sarrawi received 2 likes!

Fastest way to visualize data from Data Service in charts displayed in UiPath Apps

Hi, You can use Power BI for huge data, Also, you can use a pivot table by creating a table on specific cells and creating a chart for this table, Or use this component from the marketplace: [UiPath Chart Image Generator]

This post made by @Arvind_Kumar1 received 1 likes!

Fastest way to visualize data from Data Service in charts displayed in UiPath Apps

Hello, We have created using Power BI. You can use power PI to generate complex report and show it using iframe control into apps. Thanks, Arvind

This post made by @Irina_Butu received 1 likes!

Fastest way to visualize data from Data Service in charts displayed in UiPath Apps

Can you please detail how did you manage to link Data Service in Power BI? Thanks for your constant support

Top 3 Most Liked Solutions

This solution provided by @ahmad_sarrawi received 2 likes!

Fastest way to visualize data from Data Service in charts displayed in UiPath Apps

Hi, You can use Power BI for huge data, Also, you can use a pivot table by creating a table on specific cells and creating a chart for this table, Or use this component from the marketplace: [UiPath Chart Image Generator]

---

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 2022

Top 3 Topics with Most Views

New Random().Next(Apple,Banana,Pear) possible? made by @MikeC with 46 views.

Regular Expression for Inconsistent Multiple Spaces made by @anthonyjr with 35 views.

For each row in dt continue looping after throw? made by @lynnsong986 with 31 views.

Top 3 Topics with Most Replies

Extract table data from a list of website from an excel sheeting containing the hyperlinks made by @chuapm with 15 replies.

Excel doubt merge made by @Arya_Squares with 8 replies.

Excel automation project made by @Maneesh_Surya_Kumar with 8 replies.

Top 3 Users Who Posted The Most

@Yoichi made 23 posts!

@ushu made 12 posts!

@postwick made 9 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

For each row in dt continue looping after throw?

Hi, How about using Continue activity as the following? [image] Regards,

This post made by @Naveen_Murugesan received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello All, I am Naveenprabu and I am working as a .Net Developer . I am interested in learning RPA in UI path.

This post made by @Sajid_Ali2 received 1 likes!
https://forum.uipath.com/t/462747/17

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

For each row in dt continue looping after throw?

Hi, How about using Continue activity as the following? [image] Regards,

This solution provided by @Yoichi received 1 likes!

Regular Expression for Inconsistent Multiple Spaces

Hi, If your target string always starts with “MC” (and just after comma), the following expression will work. System.Text.RegularExpressions.Regex.Matches(strData,"(?<=,)MC.*?(?=\s{2,})",System.Text.RegularExpressions.RegexOptions.Multiline) Sample20220815-3v2.zip (3.2 KB) Regards,

This solution provided by @Yoichi received 1 likes!

Linq SelectMany ListofDictionary

Hi, Can you try the following expression? [image] subjects = listDict.Select(Function(d) d("subject")).Where(Function(s) System.Text.RegularExpressions.Regex.IsMatch(s,"\d")).ToArray() Main.xaml (6.8 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 | 16 August 2022

Top 3 Topics with Most Views

Can not Data Scraping Image when select, system prompt "cannot find pattern, elements differs by tag" made by @Lori with 53 views.

INCOMPLETE DATA FROM READ RANGE made by @Marvin_Apura with 49 views.

Which method I should use made by @Hnin_Phyu with 38 views.

Top 3 Topics with Most Replies

Am newbie i take Generate Yearly Report fail made by @thiti.th with 16 replies.

Generate JWT Token made by @mkk225 with 14 replies.

[Test Manager] Test manager not showing up in Orchestrator made by @Gabuwp with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 32 posts!

@marian.platonov made 26 posts!

@Lak_Ui made 21 posts!

Top 3 Most Liked Posts

This post made by @Robert_Schneider received 2 likes!

How to Maintain Robot Servers?

Several approaches can be taken here. First, if you’re using windows server you should look into high density robots, this allows for you to use one machine for multiple robot windows sessions, reference: High-Density Robots. This way you can disable a machine in Orchestrator conduct your maintenance and bring it back without interruption. There is also maintenance API calls to stop robots current job and place the Orchestrator into maintenance mode. This is a bigger “hammer” however, I have…

This post made by @connor.orzen received 1 likes!

String parameter too long when replacing Text

Mark this as the solution, much easier than invoking a custom workflow.

This post made by @klujeske.michael received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

We are using UiPath Studio already and are now going with Studio X for some users. Can’t wait to see what comes out of it.

Top 3 Most Liked Solutions

This solution provided by @rohith.prabhu received 1 likes!

Assign: Input string was not in a correct format (Comparing 2 Double Type Variable)

Hello @kishan.savaliya , You need to put a condition before parsing the value to double to avoid this error. You can try the below method to get it done : YourDouble_Val = If(Double.TryParse(YourStrValue,Nothing),Double.Parse(YourStrValue),0) Regards, Rohith

This solution provided by @Lak_Ui received 1 likes!

I have some data in Excel with headers how to show the Excel data in message box

use output datatable activity to convert datatable to string and print in message box

This solution provided by @marian.platonov received 1 likes!

Not able to get the access token(bearer) from UIPATH

And for refresh_token grant type, the Properties should look similar to this: [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 August 2022

Top 3 Topics with Most Views

LINQ query running for long hours made by @Dhruvi_Arumugam with 53 views.

How to convert total time into hours made by @Raina_Ocean_Sanjay with 45 views.

Row problem made by @Sabbir_Anwar with 43 views.

Top 3 Topics with Most Replies

I need help to design the regular expression syntax for a particular pattern made by @Panda_Baruna_K with 19 replies.

Row problem made by @Sabbir_Anwar with 17 replies.

Append Comma to String Value made by @korhansuren with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 29 posts!

@ppr made 24 posts!

@rohith.prabhu made 17 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

HOW write IndIA into iNDia

[grafik]

This post made by @carlosevp received 2 likes!

RPA Summer School StudioX Thread

Hi Rushi! Thanks for your message. I’ll defer to @diana.gray to review your request, tagging her here for awareness. Thanks! Carlos

This post made by @Arvind_Kumar1 received 2 likes!

How to use 'Count' function with Data service entities?

@alwin.george , Please use count(filter()) function to count it separately based on status. Please use the function as below. [image] Thanks, Arvind

Top 3 Most Liked Solutions

This solution provided by @Arvind_Kumar1 received 2 likes!

How to use 'Count' function with Data service entities?

@alwin.george , Please use count(filter()) function to count it separately based on status. Please use the function as below. [image] Thanks, Arvind

This solution provided by @Gokul001 received 2 likes!

Extract HTML Link -- Help

Hi @Anjali_Rani Have you tried with Get Attribute activity, Indicate on screen (View Button) Open the Ui Explorer of the activity (Share the screenshot) or Check the HTML Link in any of the attribute? You can select that attribute in the drop down. Create an Output variable. [image] Regards Gokul

This solution provided by @Gokul001 received 1 likes!

How to split a string with "\"

HI @gokul1904 Try this out Path.GetFileNameWithoutExtension("C:\Users\hello\Desktop\AP_\Aug 2022\AP_PDF_Invoices\GD TIP 2345 064522.1.pdf") Path.GetFileName("C:\Users\hello\Desktop\AP_\Aug 2022\AP_PDF_Invoices\GD TIP 2345 064522.1.pdf") Regards Gokul

---

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

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

[system]

Daily Forum Report | 18 August 2022

Top 3 Topics with Most Views

UiPath Apps Google Home Page with Data Service Free to use made by @Vajrang with 108 views.

How to filter a date? made by @aureolegogogo with 76 views.

[HowTo] LINQ – First Start # Any Operator made by @g.patil with 51 views.

Top 3 Topics with Most Replies

How to filter a date? made by @aureolegogogo with 17 replies.

Can't zip file which title has Chinese characters made by @N_Du with 10 replies.

Want help to build a regex expression made by @Debojyoti_chanda with 9 replies.

Top 3 Users Who Posted The Most

@Yoichi made 25 posts!

@ppr made 18 posts!

@ushu made 11 posts!

Top 3 Most Liked Posts

This post made by @g.patil received 5 likes!

[HowTo] LINQ – First Start # Any Operator

Introduction The “Any” operator is one of the quantifier operators in LINQ used to check if at least one element of a collection satisfies a given condition or not. If the condition is satisfied for at least one item within the collection, the outcome of the Any operator is true. Otherwise, the outcome from the Any operator is false. The evaluation condition must be mandatory to return a Boolean outcome. In other words: The result of the condition has to be True or False.

API Details

<a c…

This post made by @gongchangco received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello! My name is Grace. I’m learning UiPath, and working as a software developer. I like discovering new technologies and programming. I am interested in RPA and currently preparing for the UiPath certification.

This post made by @OzogRPA received 1 likes!

Extracting Radio Button from PDF

@supermanPunch Thank you very much for that. It’s working !!!

Top 3 Most Liked Solutions

This solution provided by @muhamed_fasil received 1 likes!

How to read a worksheet with a table on top into a datatable with it's headers?

Please find the xaml file it will detect the header row and will read from that row with headders ExtractTable.zip (15.0 KB)

This solution provided by @Aakash_Singh_Rawat received 1 likes!

Append Comma to String Value

You are looping on value_dt_str which is invalid in your case as this would store single character in loop variable item. You should use for each row in datatable and loop over value_dt, inside loop assign respective columns current value to a variable say temp_str; e.g. temp_str = CurrentRow(“column name or index”). then you can use insert function on temp_str; temp_str.ToString.Insert(cint(temp_str.ToString.Length)-2,”,”).ToString)

This solution provided by @Gokul001 received 1 likes!

How to generate file name series

Hi @Ishan_Shelke Have a look on the XAML file GenerateSeries.xaml (5.5 KB) Regards Gokul

---

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

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

[system]

Daily Forum Report | 19 August 2022

Top 3 Topics with Most Views

Execute a python script made by @bot11 with 43 views.

How to check if variable contains roman numerals between 1-100? made by @Rhys18 with 42 views.

Type into Java Application do not working made by @vzipperer with 38 views.

Top 3 Topics with Most Replies

Unable to remove Double quotation from API Response made by @Dharunya_Devi with 16 replies.

I have doubt on string maipulatio made by @Arya_Squares with 10 replies.

How to check if variable contains roman numerals between 1-100? made by @Rhys18 with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@ushu made 16 posts!

@Yoichi made 13 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 4 likes!

Tip: How to use the Current Version of PowerShell Core

The installation of UiPath Studio or Robot contains Microsoft PowerShell Core. On this way you can use PowerShell Core in Windows compatibility mode (x64) without additional software installation. The advantage of this approach is that the package contains all we need and we have nothing to do. UiPath delivers it and we can use it in our context. But we cannot always wait for the UiPath release updates to close known security leaks and vulnerabilities. It is our task to ensure security in our pr…

This post made by @shun received 2 likes!

Automation cloudの管理（admin）タブが見えなくなった場合

「管理」タブを表示するには「組織管理者」になる必要があります。 「組織管理者」にするには、「Administrators」を付与してください。 自分のアカウントに「Administrators」を付与するには、別の組織管理者ユーザに操作してもらう必要があります。

This post made by @ppr received 1 likes!

Adding "" To a File Path Variable

@chewyearth38 welcome to the forum Are you looking for how to set some text within quotes? [grafik] kindly note \" is visual for the escaped quote only and equivalent to Do-Command -File "C:\ABC\test.txt" OtherCode

Top 3 Most Liked Solutions

This solution provided by @shun received 2 likes!

Automation cloudの管理（admin）タブが見えなくなった場合

「管理」タブを表示するには「組織管理者」になる必要があります。 「組織管理者」にするには、「Administrators」を付与してください。 自分のアカウントに「Administrators」を付与するには、別の組織管理者ユーザに操作してもらう必要があります。

This solution provided by @ppr received 1 likes!

I have doubt on string maipulatio

it is generic and will work (you can also try by your self in your immediate panel) [grafik] As it is regex you can modify the pattern e.g restricting to only digits [grafik] and so on

This solution provided by @raja.arslankhan received 1 likes!

How to use "Retry Scope" Activity if an element does not exists?

Hi @im_sre-ps, We are using Retry when when something is giving exception. For click first Use element exist and put bool variable in it. after element exist use if condition and put click activity in then block. These activities put inside retry. In retry put bool variable. It will work

---

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

Top 3 Topics with Most Views

Regex code to find string seperated by a line break made by @6027ae06be5a67a04d29acc18 with 39 views.

Select item from dropdown by item index made by @Nirav_Gajera with 34 views.

Why this error message is coming made by @sarath_babu with 33 views.

Top 3 Topics with Most Replies

SAP Save As Dialogue won’t respond to UIPath made by @quailkatie with 20 replies.

Regex code to find string seperated by a line break made by @6027ae06be5a67a04d29acc18 with 8 replies.

Uipath Data service - Uipath Studio made by @Sukanya_Dutta with 6 replies.

Top 3 Users Who Posted The Most

@quailkatie made 11 posts!

@raja.arslankhan made 9 posts!

@Yoichi made 5 posts!

Top 3 Most Liked Posts

This post made by @vita850102 received 1 likes!

SAP錄製哪些說法是正確的？

1.開通Scripting權限 2.開通Record＆Playback權限 3.可使用startprocess進行調用 4.錄製完的code無法修改

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

SAP錄製哪些說法是正確的？

1.開通Scripting權限 2.開通Record＆Playback權限 3.可使用startprocess進行調用 4.錄製完的code無法修改

This post made by @sarath_babu received 1 likes!

Why this error message is coming

hai, can anyone please help me why this error is showing when using type into activity inside the open browser activity attaching a screenshot with this thanks in advance [Screenshot (21)]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Select item from dropdown by item index

Hi, There are some ways to achieve it. Get current options, then split it and select forth item. [image] Use Inject JS Script activity [image] "function(e,v){e.selectedIndex=3;}" Hope the above helps you. Regards,

This solution provided by @Yoichi received 1 likes!

Regex code to find string seperated by a line break

Hi, Can you try the following sample? [image] First, read Pdf file as text using Read PDF Text with PreserveForamtting option. Then, remove French part. French part always starts from 74th character in each line. Next, remove line number: 5,10,15,20,25,30 using Regex.Replace Finally extract target phrase using the above regex. Sample20220820-1.zip (35.7 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 | 21 August 2022

Top 3 Topics with Most Views

Copy, paste the table made by @lakshya_garg1 with 36 views.

Replace all the email separator with Semicolon made by @ShekharRPA with 32 views.

「Excelファイルを使用」アクティビティについて made by @gorby with 29 views.

Top 3 Topics with Most Replies

Extract multiple items details from invoice made by @Rohit_More with 6 replies.

Copy, paste the table made by @lakshya_garg1 with 5 replies.

「ダブルクリックして表示」しなくても、最初から、ダブルクリック先が表示されている設定はないでしょうか？ made by @gorby with 4 replies.

Top 3 Users Who Posted The Most

@Lakshya_Garg made 4 posts!

@gorby made 3 posts!

@ShekharRPA made 2 posts!

Top 3 Most Liked Posts

This post made by @Pravesh_Chourey received 1 likes!

Can't Get Outlook Mail Messages

@indrajit.shah Please ignore my first query, downgrading system mail activities to 1.3.0 worked for me perfectly. Thanks Anyway

This post made by @ShekharRPA received 1 likes!

Replace all the email separator with Semicolon

Hi Everyone, Is there any reusable component we have to check the email separator (Can be Any special character or blank space or comma) is semi colon or not And if not then replace it with Semi colon

This post made by @Jerry1 received 1 likes!

Replace all the email separator with Semicolon

Hi Shekhar, You can use the ‘Matches’ activity with the regex filter as email. It will give you a collection output with all the extracted email IDs. Then, you can combine those with the Join function. Refer to the attached workflow. Hope it will help you. ExtarctEmailAddress.xaml (7.0 KB)

Top 3 Most Liked Solutions

This solution provided by @Jerry1 received 1 likes!

Replace all the email separator with Semicolon

Hi Shekhar, You can use the ‘Matches’ activity with the regex filter as email. It will give you a collection output with all the extracted email IDs. Then, you can combine those with the Join function. Refer to the attached workflow. Hope it will help you. ExtarctEmailAddress.xaml (7.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 | 22 August 2022

Top 3 Topics with Most Views

How to use macro activity made by @Raina_Ocean_Sanjay with 41 views.

Find the row index based on column combination made by @Mirai with 41 views.

Click hidden menu made by @Aguirre with 36 views.

Top 3 Topics with Most Replies

How i can select date from date picker made by @Mohsin_Ali_Mohammed with 17 replies.

How to use macro activity made by @Raina_Ocean_Sanjay with 16 replies.

While moving pdf files from downloads to new flder all files except the last downloaded(like some time its two and sometime more then 2) made by @rAE_rAS with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 36 posts!

@ppr made 23 posts!

@THIRU_NANI made 19 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 3 likes!

How To Download Specific Files From A Mail – In UiPath

Mails are something that is widely used in the automation processes to receive inputs and to notify the users using the process. UiPath provides us the facility to download the attachments from particular mail. By default, it downloads all the attachments available, but what if we are planning to download only specific extension files? Let’s see how to do that!!! Filter = “.*(.xlsx|.XLSX|.xls|.pdf)” Note: Pass the EXTENSIONS according to your choice Example Let us implement a workflow…

This post made by @THIRU_NANI received 2 likes!

All about Orchestrator

Hello Everyone, Hope you all are doing great… Topic: Orchestrator Version: 2022.05.0 License: Community What is Orchestrator ? The Orchestrator is a web application that allows you to orchestrate the execution of repetitive business processes by UiPath Robots . Orchestrator manages the creation, monitoring, scheduling, and controlling of automated bots and processes. Create Cloud Account : Click Here → Cloud_URL OR Here → URL : https://cloud.uipath.com/ Open the above provided l…

This post made by @THIRU_NANI received 2 likes!

What should be done when the elements of the page change every time the page is reloaded when using typeinto activity

Hey! Welcome to community! We can achieve this in the following ways… Finetune the selectors Edit the selector and always choose the aaname=‘FieldName’ Example: We’re indicating on the firstname field the selector should be like this aaname= ‘FirstName’ Use AnchorBase activity in the classic design experience Use anchor as Find Element and action as TypeInto Use the Anchor in selector it self … We can set the anchor to that particular field… You can try any one of the approach even …

Top 3 Most Liked Solutions

This solution provided by @THIRU_NANI received 2 likes!

What should be done when the elements of the page change every time the page is reloaded when using typeinto activity

Hey! Welcome to community! We can achieve this in the following ways… Finetune the selectors Edit the selector and always choose the aaname=‘FieldName’ Example: We’re indicating on the firstname field the selector should be like this aaname= ‘FirstName’ Use AnchorBase activity in the classic design experience Use anchor as Find Element and action as TypeInto Use the Anchor in selector it self … We can set the anchor to that particular field… You can try any one of the approach even …

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

Any topics on macro

Hi @Kavya_Mahadevan [UiPath Tutorial | Uipath Execute Macro] This gives you an idea related to macros Hope this helps

This solution provided by @Veera_Raj received 1 likes!

How to split 3 movies separated by commas from an input dialog

string_var.split(","c).toarray()

---

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

Top 3 Topics with Most Views

How to convert data table rows to string using LINQ queries? made by @Mandava_Naresh with 49 views.

How to Check File Format from Folder made by @Sandhya_Gajare with 47 views.

Create Folder activity made by @Gokul001 with 44 views.

Top 3 Topics with Most Replies

How to Check File Format from Folder made by @Sandhya_Gajare with 28 replies.

How to Remove Special Characters starting with made by @Shyam_Pragash with 17 replies.

Remove ' from a column in csv made by @Abhi15 with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 55 posts!

@ppr made 33 posts!

@raja.arslankhan made 31 posts!

Top 3 Most Liked Posts

This post made by @g.patil received 2 likes!

[HowTo] LINQ – First Start # All Operator

Introduction The “All” operator is a quantifier operator in LINQ used to check if each element from the collection satisfies a given condition or not. If the condition is satisfied for each element within the collection, the outcome of the operator is true. Otherwise, the outcome is false The evaluation condition must be mandatory to return a Boolean outcome. In other words: The result of the condition has to be True or False. API Details

Summary

<a class="lightbox" href="…

This post made by @Gokul001 received 2 likes!

Compare rows but need exclude 010106 & 010107

Hi @anh.nguyen How about this expression? Use If activity Currentrow("Column Name").Tostring.Equals("010106") or Currentrow("Column Name").Tostring.Equals("010107") Regards Gokul

This post made by @postwick received 2 likes!

Extract specific text after character "-"

If it’s always going to be after the - then use Split. myVar = “[EXTERNAL]Ahadi Term Assurance –Full Name” myText = myVar.Split("-"c)(1) Split gives you an array, so the first element (index 0) will be the text before the - and the second element (index 1) will be the text after.

Top 3 Most Liked Solutions

This solution provided by @Nishant_Banka1 received 1 likes!

Even if it shows validation error in selector why it is still running

Hi @ydash999 Validation errors in Edit Selector or UiExplorer window doesn’t always mean that your selectors are incorrect. Suppose a user has created a selector for page X, but is currently on a different page, then UiPath will not be able to validate the selector since it won’t be able to find the element on this new page Also if someone is using variables in the selector (dynamic selectors), then UiPath can’t resolve this until runtime, and this will throw a validation error as well. So v…

This solution provided by @marian.platonov received 1 likes!

Download Assistant MSI installer only

You can open a case with the UiPath Technical Support Team, but the only thing that they can do for you is to raise an Enhancement Request. However, UiPath cannot provide an ETA on when this enhancement request will be taken into consideration/implemented since this type of request will go through an approval process and will be discussed internally.

This solution provided by @ppr received 1 likes!

Extract specific text after character "-"

@Lydia_Gathoni Welcome to the forum [grafik] (?<=\–|\-).* as you see we do have different types of hyphens

---

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

Top 3 Topics with Most Views

Can't access docs.uipath.com made by @beantony with 47 views.

For each or iteration doubt made by @Yoganathan_Mohanavasan with 42 views.

How to access values from DataTable within DataTable made by @Rohit_More with 38 views.

Top 3 Topics with Most Replies

I ned to check mail subject if it contains invoices then need to proceed further if any mail does not contain invoice in its subject I need to throw an error problem is I need to throw error after iterating through every email made by @Akanksha11 with 15 replies.

https://forum.uipath.com/t/467466 made by @agathiyanv with 10 replies.

The length cannot be less than zero. Length parameter made by @Ana_Patricia_Garcia with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 21 posts!

@Gokul_Jayakumar made 20 posts!

@ushu made 17 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Cron Expression: Every 30 minutes, Between 07:30-14:30 Daily

whenever we cannot specify within a single cron we can split it to multiple crons as workaround 7:30 0 30 7 ? * * * 8 - 14 icl. 14:30 0 0,30 8-14 ? * * *

This post made by @Mirza_Keco received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Emma, welcome to the community! You will find many articles placing software/process automation as top 10 jobs of the future. I believe it is mainly due to the fact that many companies/enterprises still use legacy (old, in-house solutions) software as primary solutions for their everyday business. The fact is, that kind of software is not very flexible (speaking from experience), and the architecture is quite complex (read OLD) and expensive to adjust, change and upgrade. Those companies …

This post made by @rohith.prabhu received 2 likes!

Why is it going up and down instead of sideways when using build datable?

Hello @Hnin_Phyu , Because you are adding 2 new rows hence it’s getting appended under same column but in a new row. To get the data in same Row but in 2 different columns in your 1st Add Data Row activity use the below in Array Row & delete 2nd Add Data Row activity {pjid,resultText} Regards, Rohith

Top 3 Most Liked Solutions

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

Loop for compare current row & next row1, row1 & row2, row2 & row3.... last row

@anh.nguyen try this DLV015.xaml (2.0 MB)

This solution provided by @ppr received 1 likes!

How to show each row from a data table without using any loop

in general we can use the output datatable activity for getting a string representation With LINQ we can do String.Join(Environment.newLine, dtVar.AsEnumerable.Select(Function (x) String.Join(“|”, x.ItemArray)))

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

Compare rows but need exclude 010106 & 010107

((Left(RowPhu.Item(1).ToString,6)="010106" or Left(RowPhu.Item(1).ToString,6)="010107") and (Left(DtPhu.Rows(idx+1).Item(1).ToString,6) = "010106") or Left(DtPhu.Rows(idx+1).Item(1).ToString,6) = "010107")) Or Left(RowPhu.Item(1).ToString,6)=Left(DtPhu.Rows(idx+1).Item(1).ToString,6)

---

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

Top 3 Topics with Most Views

Hi I new here, so I need to iterate through mail and check their subject if the subject is "Invoice I need to proceed further or else I need to throw an error after loop is completed I already created workflow but its not working when email subject is dif made by @Simran2 with 66 views.

Shorten Regex Pattern made by @6027ae06be5a67a04d29acc18 with 42 views.

Send mail Activity made by @Sandhya_Gajare with 42 views.

Top 3 Topics with Most Replies

Hi I new here, so I need to iterate through mail and check their subject if the subject is "Invoice I need to proceed further or else I need to throw an error after loop is completed I already created workflow but its not working when email subject is dif made by @Simran2 with 30 replies.

How to get row index if Excel has duplicate row made by @PALKUMARI_PATEL with 18 replies.

Shorten Regex Pattern made by @6027ae06be5a67a04d29acc18 with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 28 posts!

@raja.arslankhan made 25 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

Cannot bring the target application to the front because the Windows session is locked

No, there is no setting to avoid this. It’s how RDP sessions work. Users shouldn’t be logging into your bot servers at all. It interferes with Orchestrator. But yes, if anyone logs in with one of your robot accounts, they MUST SIGN OUT. Closing the RDP window leaves the session running which is explained in the popup you get when you close the RDP window. [image]

This post made by @shun received 2 likes!

ジョブ実行の際、引数を複数渡すことはできますか？

引数を複数設定するということは、 以下のように、Studio上で2個以上の引数を設定した上で、APIのパラメータを設定します。 [画像1] 一方、akaさんが設定しているものは、 「ID=1000」、「ID=2000」のように同一の引数「ID」に対して、2つの値を設定しています。 UiPathのワークフローでは、同一名称の引数は作成できないので、上記設定は間違ったやり方となります。 「ID=1000」、「ID=2000」のように引数を設定したいのであれば、1000の時と2000の時、それぞれ別々のジョブを開始する必要があります。

This post made by @marian.platonov received 2 likes!

Download attachment file of POST API response from a custom API endpoint

Check the solution from this thread Saving file using HTTP request - #7 by Jun_Wei

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Cannot bring the target application to the front because the Windows session is locked

No, there is no setting to avoid this. It’s how RDP sessions work. Users shouldn’t be logging into your bot servers at all. It interferes with Orchestrator. But yes, if anyone logs in with one of your robot accounts, they MUST SIGN OUT. Closing the RDP window leaves the session running which is explained in the popup you get when you close the RDP window. [image]

This solution provided by @shun received 2 likes!

ジョブ実行の際、引数を複数渡すことはできますか？

引数を複数設定するということは、 以下のように、Studio上で2個以上の引数を設定した上で、APIのパラメータを設定します。 [画像1] 一方、akaさんが設定しているものは、 「ID=1000」、「ID=2000」のように同一の引数「ID」に対して、2つの値を設定しています。 UiPathのワークフローでは、同一名称の引数は作成できないので、上記設定は間違ったやり方となります。 「ID=1000」、「ID=2000」のように引数を設定したいのであれば、1000の時と2000の時、それぞれ別々のジョブを開始する必要があります。

This solution provided by @ppr received 2 likes!

Shorten Regex Pattern

Can you check: [grafik] \bF(([aire]+[\s\S]*?)*?)s\b

---

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

Top 3 Topics with Most Views

Problem using Application/Browser made by @Fabrizio_Ortotti with 48 views.

How to remove empty spaces from the numbers made by @Chippy_Kolot with 47 views.

What's the difference between cloud.uipath.com and uipath.cloud.com? made by @Surya_Narayana_Korivipadu with 43 views.

Top 3 Topics with Most Replies

Problem using Application/Browser made by @Fabrizio_Ortotti with 18 replies.

Not able to select the dropdown value while doing automation in uipath made by @Chauhan_Nagesh with 15 replies.

How to add the date and time in my end of day report file? made by @dylanTana with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 29 posts!

@ppr made 22 posts!

@Yoichi made 21 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 2 likes!

How To Get The Sheet Name From Excel – In UiPath

Excel is the most used application in the business process automation. To work with it, we might sometimes want to know the sheets available in it, let us see how to find all the sheet names available in a workbook. wb as WorkbookApplication wb.GetSheets Example Implementation using UiPath : Let us implement a workflow which takes a sample excel file and displays all the sheets available in it. Step 1: Drag “Excel Application Scope” activity into the designer panel and supply the foll…

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

How to add the date and time in my end of day report file?

Hi @dylanTana This what you are doing [image] Instead concatenate the different Strings [image] Or use Path.Combine [image]

This post made by @raja.arslankhan received 2 likes!

How to add the date and time in my end of day report file?

@dylanTana get full folder path in veriable. then right Folderpath+“back slash symbol”+DateTime.Now.ToString(“yyyyMMddHHmmss”)+In_Config(“OrchestratorQueueName”).ToString string.format is used when we are trying to add string specific place and you are not mentioning that place

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

How to get top 10 queue items using Orchestrator Http request activity?

So in your case it will be https://cloud.uipath.com/odata/QueueItems?$top=10&$skip=0 (it will retrieve only the first 10 QueueItems)

This solution provided by @postwick received 1 likes!

How to add the date and time in my end of day report file?

That will result in… EODReport.xlsx\20220826 You don’t use Path.Combine to build the filename. You use it to combine the final filename with the rest of the path. So you need an assign to set the filename: myfile = “EODReport” + Now.ToString(“MMddyyyy”) + “.xlsx” Then… Path.Combine(somePathVar,myfile) to get something like… C:\temp\EODReport08262022.xlsx The point to Path.Combine is to make sure the \ are added correctly. Consider you have the following variables: myPath = “C:\temp” …

This solution provided by @THIRU_NANI received 1 likes!

How to click arrow in sap, can any one help me

Hey! Have you tried SAP expand tree activity? Reference: Regards, NaNi

---

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

Top 3 Topics with Most Views

How to continue when there is exception in sequecne made by @T_Y_Raju with 37 views.

Send Hotkey Not Actioning made by @Kalaisri_K with 32 views.

Handling API response when object may or may not be available in response made by @Teekay with 29 views.

Top 3 Topics with Most Replies

How to iterate pdf file one after another file made by @NS7799 with 17 replies.

Received date for Outlook message made by @Topias_Stromberg1 with 17 replies.

Multiple Assign Error made by @Sukanya_Dutta with 8 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 21 posts!

@Gokul001 made 8 posts!

@marian.platonov made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Handling API response when object may or may not be available in response

a null check can be done as shown below: [grafik] for a more defensive handling the existence of a JSON Property we can do: [grafik] we use this often for techniques when setting up generic extraction flows and and calculate existing properties against a list of interested properties

This post made by @Omkar_Sonawane received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone! I am Omkar from India, I work in a mobile gaming company as a Webmaster and my work is mostly in Firebase, AWS S3, FTP, and a little bit of Javascript. I got introduced to UiPath recently and wish to get certified as a Developer and explore the limits of Automation. Currently, I am preparing for certification and I want to connect with the UiPath community to a greater extent. Cheers!

This post made by @Gines_Cirera_Dona received 1 likes!

Uipath and dynamic paths

This worked, thank you so much.

Top 3 Most Liked Solutions

This solution provided by @Nishant_Banka1 received 1 likes!

Handling API response when object may or may not be available in response

Hi, I think it’s the ToString method that is throwing the error. Since we are doing a ToString on an object that doesn’t exist Can you try removing the ToString, and then try? Thanks, Nishant

---

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

Top 3 Topics with Most Views

Json to data-table made by @indrajit.shah with 40 views.

Read Text File: One or more errors occurred made by @Rawan.md with 30 views.

How do I change the Date Format From (2022-08-28) to 28 Aug 2022? made by @kishan.savaliya with 27 views.

Top 3 Topics with Most Replies

Json to data-table made by @indrajit.shah with 14 replies.

Read Text File: One or more errors occurred made by @Rawan.md with 6 replies.

CSVをExcelに貼り付ける際、先頭行を除く方法と文字化け解決法 made by @Chitose_Takematsu with 5 replies.

Top 3 Users Who Posted The Most

@indrajit.shah made 8 posts!

@raja.arslankhan made 7 posts!

@kmaddikatla made 7 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How do I change the Date Format From (2022-08-28) to 28 Aug 2022?

Hi, Hope the following helps you. [image] CDate(yourString).ToString("d MMM yyyy") Regards,

This post made by @StefanSchnell received 1 likes!

Migrating Activities to .NET 6

@Andreea_Stroe Hello Andreea, thank you very much for this very interesting and important news. Best regards Stefan

This post made by @kishan.savaliya received 1 likes!

How do I change the Date Format From (2022-08-28) to 28 Aug 2022?

Thank You Very Much @Yoichi For the Solution Its working Properly

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How do I change the Date Format From (2022-08-28) to 28 Aug 2022?

Hi, Hope the following helps you. [image] CDate(yourString).ToString("d MMM yyyy") Regards,

This solution provided by @Yoichi received 1 likes!

CSVをExcelに貼り付ける際、先頭行を除く方法と文字化け解決法

こんにちは 日本語のエンコーディングは基本的には、"shift_jisかUTF-8 かと思うので、これらを試してみてはと思います。 あと可能であれば現在組まれているワークフローのスクリーンショットを共有いただくと、良いかと思います。

---

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

Top 3 Topics with Most Views

How to extract email id from a string without using regex made by @sagar.raval with 46 views.

LINQ - Multiple CONDITIONAL Unique Identifier Matching Two Data Tables made by @anthonyjr with 45 views.

Data Scraping - Value does not fall within the expected range made by @weelip with 40 views.

Top 3 Topics with Most Replies

How to extract email id from a string without using regex made by @sagar.raval with 16 replies.

Css-Selector pass in Uipath made by @Shyam_Pragash with 15 replies.

ファイルサイズを取得 made by @autopc01 with 13 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 30 posts!

@Yoichi made 12 posts!

@Gokul001 made 12 posts!

Top 3 Most Liked Posts

This post made by @Kashi_Vishwanath received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Greetings to All !!! hope you all are doing fine. I just joined this forum and see there are giants in RPA and I look forward in learning from your rich experience. I am the VP customer success & Business Acquisition from Collective Minds Digital Solutions from India. This is my first post in this forum. I am into RPA for last 3 months. I am a plastics technologist, heading manufacturing process for various organizations for last 24 years. I was with a leading MNC for 10 years. I am currently lo…

This post made by @Bogdan_Zavera received 2 likes!

I have a component and I can not to edit

Hello Siyang, we are looking into it and will get back to you with updates in a few hours. Thank you for reaching out

This post made by @Andreea_Stroe received 2 likes!

I have a component and I can not to edit

Hi @wusiyangjia, Your listing is now in status Needs Update, so you can edit it accordingly. Thank you, Andreea

Top 3 Most Liked Solutions

This solution provided by @Andreea_Stroe received 2 likes!

I have a component and I can not to edit

Hi @wusiyangjia, Your listing is now in status Needs Update, so you can edit it accordingly. Thank you, Andreea

This solution provided by @Gokul_Jayakumar received 1 likes!

How to extract email id from a string without using regex

Hello @sagar.raval , Try this method it may help for you Split(YourString," ") You ca use the split string and loop it using for each loop , you can split each string. Within loop , use if condition for isolate the string contains “@” “.” item.ToString.Contains("@") And item.ToString.Contains(".") KIndly refer this flow of XAML file. EmailString_Manipulation.xaml (9.3 KB) [image]

This solution provided by @Yoichi received 1 likes!

ファイル名から月を取得したいが、数字のファイルがあると取得できない

こんにちは \Dを使用しているから全角数字も対象に含まれるからです。このパターンを尊重するなら “1?\d(?=[^0-9])” だと通りますが、いずれにしても半角数字が含まれると正常に動作しないと思うので あまりよくないと思います。 そのため例えば System.Text.RegularExpressions.Regex.Match(System.IO.path.GetFileNameWithoutExtension(yourFilePath),"1?\d$").Value+"月" 等の方が良いかと思います。

---

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

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

[system]

Daily Forum Report | 30 August 2022

Top 3 Topics with Most Views

Combine Duplicate row value into Single row made by @agathiyanv with 52 views.

Scheduling calendar and License utilization made by @Natalino_Mantoan with 47 views.

Select Current Month from a Drop Down Menu made by @Farah_halawani with 45 views.

Top 3 Topics with Most Replies

Select Current Month from a Drop Down Menu made by @Farah_halawani with 24 replies.

For each row - read only last 5 numeric characters made by @andrew.haworth with 19 replies.

Maintenance mode via Swagger authentication made by @Snowman with 18 replies.

Top 3 Users Who Posted The Most

@marian.platonov made 31 posts!

@ppr made 30 posts!

@Sanjit_Pal made 20 posts!

Top 3 Most Liked Posts

This post made by @Natalino_Mantoan received 6 likes!

Scheduling calendar and License utilization

Hello everyone, I would like to ask if there is a way to view all the schedules present on the tenant and the status of license occupations via monitoring, insights, or any other way. The main goal is to understand if a machine is overloaded or, on the other hand, is often free so as to better manage schedules or consider buying new licenses. I have already tried to look in Insights if information on schedules could be retrieved, but it does not seem to be possible. Also, in the Monitoring se…

This post made by @Sanjit_Pal received 4 likes!

Import Datatable From Word Document To Excel File

UiPath provides us the flexibility to export the data from the word document to excel file, here one more exciting way to achieve the result. You can create a .bat file using the below code Sub ImportWordTable(wdFileName) Dim wdDoc As Object Dim tableNo As Integer 'table number in Word Dim iRow As Long 'row index in Excel Dim iCol As Integer 'column index in Excel Dim resultRow As Long 'from which row result should be written Dim tableStart As Integer Dim tableTot As Integer On Error Resume…

This post made by @ppr received 3 likes!

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

Top 3 Most Liked Solutions

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

Data Service: Query Entity Records Best Practice

It really depends on what you are trying to achieve with your process and how you are using the entities. The typical suggestion will be to use Query activity in the process to fetch the latest data from entities when you run a process. Once the data is fetched, it remains in your process memory as variables until either the process ends or the variable is removed from scope. That’s why, any changes you do to the entity data has to be written back to Data Service using the Update, Create or Del…

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

How to run in incognito

Hi @Trisen_Jr Welcome to community There is an option in open browser activity As properties called private Kindly check that field

This solution provided by @Yoichi received 1 likes!

How to extract data of particular row using Linq?

Hi, Perhaps you should use uppercase like Contains(“TOTAL ADD ON”) becuase of ToUpper. Regards,

---

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

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

[system]

Daily Forum Report | 31 August 2022

Top 3 Topics with Most Views

Extr number from string made by @Yashas_H with 37 views.

How to extract specific data from a JSON payload using SelectToken? made by @KMota with 32 views.

Remove duplicate rows from two datatables based on a specific columns made by @hckwon5 with 29 views.

Top 3 Topics with Most Replies

Separate text and number made by @Sabbir_Anwar with 17 replies.

Argument value not provided made by @Halil_Gezer with 16 replies.

How to download all attachments apart from pdf made by @gokul1904 with 15 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 26 posts!

@postwick made 26 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to check string present in dictionay or not

we do have the ContainsKey(yourKey) / ContainsValue(YourValue) we can use LINQ we can check the keys / the values lists to get a new dictionary similiar to your output we could use LINQ Assign Activity: dictUpdated = (From x in YourOriginDict Let chk = x.Key.toUpper.Contains(YourCheckStringVar.toUpper) Let v = If(chk, "found", "Notfound") Select t = Tuple.Create(x.Key, v)).ToDictionary(Function (t) t.Item1,Function (t) t.Item2) Or (From x in YourOriginDict.Keys Let chk = x.toUpper.Contai…

This post made by @Nitya1 received 1 likes!

How to Convert an Array to List in UiPath

Converting one datatype to another is one of the most common things we do in programming. Let’s see how to convert an Array to List in UiPath. our_List = our_Array.ToList Example: Implementation using UiPath : Let us implement a workflow which converts an “Array” to “List” Step 1: Create variables as shown below [image] Step 2: Drag “Assign” activity into the design panel and initialize the Array of string type. [image] Step 3: Drag another “Assign” activity into the design panel …

This post made by @Lori received 1 likes!

I use LINQ expression should filter one column value which >-1 and <1, However, I cannot get the right data, who can help?

@kumar.varun2 Thanks for you help, seem that I made a mistake, I got the value which I want, thanks you very much!

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to check string present in dictionay or not

we do have the ContainsKey(yourKey) / ContainsValue(YourValue) we can use LINQ we can check the keys / the values lists to get a new dictionary similiar to your output we could use LINQ Assign Activity: dictUpdated = (From x in YourOriginDict Let chk = x.Key.toUpper.Contains(YourCheckStringVar.toUpper) Let v = If(chk, "found", "Notfound") Select t = Tuple.Create(x.Key, v)).ToDictionary(Function (t) t.Item1,Function (t) t.Item2) Or (From x in YourOriginDict.Keys Let chk = x.toUpper.Contai…

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

I use LINQ expression should filter one column value which >-1 and <1, However, I cannot get the right data, who can help?

Hi @Lori Could you give this a try Filter datatable where “AP Invoice Number” = Blank and “AR Invoice Number” not Blank and “Issue Type”=“Price Diff” or Blank and “Diff” column value "-1 < and < 1 ", ( From d In CSVDT.AsEnumerable _ Let APInvoiceNum = d("AP Invoice Number").ToString.Trim().ToUpper() Let ex = d("Issue Type").ToString.Trim().ToUpper() Let diff = Convert.ToDouble(d("Diff").ToString) _ Let c1 = String.IsNullOrEmpty(APInvoiceNum) Let c2 = Not d("AR Invoice Number")…

This solution provided by @Gokul001 received 1 likes!

What is execution trail and what is its use?

Hi @Rohit_More Check the below image execution trail is used to see which are in-progress, Executed, Faulted in the workflow. You must run the process in Debug Mode [image] Check out the docs for more info Debugging Actions. Regards Gokul

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

@Yoichi received 54 likes for their solutions!

@ppr received 45 likes for their solutions!

@Gokul001 received 33 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 September 2022

Top 3 Topics with Most Views

Revamped Alerts in Orchestrator made by @sebastian.ungureanu with 57 views.

How to get the 1st and last days of the Last week made by @anit.michael1 with 42 views.

Click is failing despite 100% match made by @mayowa.mike-adeogun with 39 views.

Top 3 Topics with Most Replies

Not able to understand which activity to be used made by @Sam_H with 19 replies.

When using email account as a variable in the Outlook app, it can't find the folder made by @Jayant_Kumar_Singh with 13 replies.

How to get the 1st and last days of the Last week made by @anit.michael1 with 9 replies.

Top 3 Users Who Posted The Most

@marian.platonov made 26 posts!

@postwick made 19 posts!

@Gokul001 made 19 posts!

Top 3 Most Liked Posts

This post made by @sebastian.ungureanu received 2 likes!

Revamped Alerts in Orchestrator

Hello, UiPath community! We’re excited to announce that we’ve re-worked some of the functionality in Orchestrator alerts to bring you more value, faster. Let’s look at what’s new and improved: More actionable alerts - we’re adding deep-linking to alert notifications, so you can get more details on a specific alert directly from the email alerts in your inbox or from in-Orchestrator alerts with just one click New email template – we’ve updated our Alerts email design for you to be able to …

This post made by @Gangadhar_Athili received 2 likes!

Regex string extraction

[image]

This post made by @Gokul001 received 2 likes!

Regex string extraction

Hi @Lydia_Gathoni How about this expression? System.Text.RegularExpressions.Regex.Match(YourString,"\S\S\d{4}").Tostring Or System.Text.RegularExpressions.Regex.Match(YourString,"\S{2}\d{4}").Tostring [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Neil_Ryan received 1 likes!

Change postpone date of multiple queue items

Hi @Sparrow If you use the Orchestrator REST API’s to achieve this. Get All the Queue Items https://ORCHESTRATOR_HOSTNAME/swagger/index.html#/QueueItems/QueueItems_Get 2)Look through each Queue Item returned in the results from Step1 For each queue item use the following Rest API call https://ORCHESTRATOR_HOSTNAME/swagger/index.html#/QueueItems/QueueItems_PutById Set the DeferDate field to the new value The below ticket provides some more context around the approach.

This solution provided by @Gokul001 received 1 likes!

How to assign a boolean value for a string if it contains specific texts

Hi @Ben_siu Use If condition "YourString".Contains("Yes") [image] If the String is Yes it will Go to Then part If the String is No it will Go to Else part Regards Gokul

This solution provided by @Yoichi received 1 likes!

DateTime - Option strict on disallows implicit conversions from ‘object’ to ‘string’ uipath

Hi, Can you try as the following? DateTime.Parse(BirthDates(item.ToString())) OR Set String at TypeArgument in ForEach activity. 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 | 02 September 2022

Top 3 Topics with Most Views

Unable to fetch table data from web application made by @sagarjb with 41 views.

Dynamic file name of excel file made by @Agnes_Castro_Salvador with 40 views.

Remove row from a particular string from data Table made by @taruna.mehra with 34 views.

Top 3 Topics with Most Replies

Remove row from a particular string from data Table made by @taruna.mehra with 25 replies.

Read huge excel range into a data table made by @A_Learner with 22 replies.

Could not find the user-interface (UI) element for this action - Unattended robot made by @ankur.agarawal with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 37 posts!

@Yoichi made 25 posts!

@raja.arslankhan made 23 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 4 likes!

Monthly Forum rewards - August 2022

@loginerror Thank you so much an Congratulations Everyone. I will try to give community my best.

This post made by @Veera_Raj received 3 likes!

Monthly Forum rewards - August 2022

congratulations to everyone

This post made by @StefanSchnell received 3 likes!

Monthly Forum rewards - August 2022

Congratulations to all the winners and thank you for your effort.

Top 3 Most Liked Solutions

This solution provided by @grkiran2 received 1 likes!

Need Help to understand the Code

The state is in this format: If(<condition> , <Value when condition is True> , <Value when condition is False>) In you case IF evaluates the condition CBool(in_Config("SomeImput1").ToString). if True, returns value for in_Config(“Input2”).Tostring if False, returns value for in_config(in_config(“Input3”).Tostring+“_”+in_config(“input4”).tostring+“_AppName”).ToString

This solution provided by @Gokul001 received 1 likes!

Extracting substring from a string

Hi @gokul1904 How about this expression? System.Text.RegularExpressions.Regex.Match(YourString,"(WEF\S\d+)(?=\s)|(WEF\S\d+)(?=[a-z])").Tostring [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

Issue on ascending order on table

HI, Thanks, the following will work. Can you try this? dt.AsEnumerable.Where(Function(r) Double.Parse(r("Discount").ToString)>10).OrderBy(Function(r) Double.Parse(r("Discount").ToString)).CopyToDataTable() 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.