Forum Engagement Daily Reports

[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!
https://forum.uipath.com/t/466787/1

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="h…

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!
https://forum.uipath.com/t/468213/1

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 @indiedev91 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 @indiedev91 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 @indiedev91 , 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!
https://forum.uipath.com/t/469292/1

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.

[system]

Daily Forum Report | 03 September 2022

Top 3 Topics with Most Views

How can I get the UiPath.Cryptography.Activities package in UiPath Studio? made by @Jcircuit13 with 41 views.

Get sheet name which is in any digit made by @sayali_rokade with 30 views.

Idx made by @447_J_U_S_SANDEEP with 28 views.

Top 3 Topics with Most Replies

Have taken 2 workflows and trying to invoke the same in main workflow but not showing the arguments of the other workflows in main(invoke activity),but selected the right workflow made by @Sai_Kumar_111 with 18 replies.

Why I always get the last row data when using "For Each" with web scaping? made by @Cheatken with 17 replies.

How to compare Datatables with values made by @smritijoshi with 14 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 29 posts!

@marian.platonov made 15 posts!

@Sai_Kumar_111 made 13 posts!

Top 3 Most Liked Posts

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

Monthly Forum rewards - August 2022

Congratulations to all the winners!!!

This post made by @Yoichi received 1 likes!

Can you please let me know why i am repeatedly getting this error,but i have passed the arguments right and data table is also good.Thanks for any help

Hi, For now, can you check if variable DT is null in Locals panel when exception occurs? Regards,

This post made by @sandeep13 received 1 likes!

Can you please let me know why i am repeatedly getting this error,but i have passed the arguments right and data table is also good.Thanks for any help

@Sai_Kumar_Pothuganti could you please check DT is initialise or not.? This type of error occurred when we access the variable without Initialisation. Thanks

Top 3 Most Liked Solutions

This solution provided by @sandeep13 received 1 likes!

Can you please let me know why i am repeatedly getting this error,but i have passed the arguments right and data table is also good.Thanks for any help

@Sai_Kumar_Pothuganti could you please check DT is initialise or not.? This type of error occurred when we access the variable without Initialisation. Thanks

This solution provided by @lakshman received 1 likes!

How to Use UIBrowser with Use Application/browser activity

@Sidney_Vogel Use Application/Browser activity will give output of type UiElement whether it is application or browser. Create one variable of type UiElement and set to Output Element field. Later if you want to use it then pass above output UiElement variable to Input Element of Use Application/Browser activity.

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

Have taken 2 workflows and trying to invoke the same in main workflow but not showing the arguments of the other workflows in main(invoke activity),but selected the right workflow

@Sai_Kumar_111 ok great but I think we should not wait for tomorrow. Before running all the files should be close which you are using in process. Two process can’t open a same file at a time So please close the file and then run the process

---

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

Top 3 Topics with Most Views

How to Change Color of Specific Cells Dynamically made by @Ken_Ward with 36 views.

Data Table String removal made by @taruna.mehra with 33 views.

How to add serial numbers in particular column made by @mohamedalthaf with 32 views.

Top 3 Topics with Most Replies

Data Table String removal made by @taruna.mehra with 11 replies.

How to add serial numbers in particular column made by @mohamedalthaf with 7 replies.

To extract substring with Regex made by @gokul1904 with 6 replies.

Top 3 Users Who Posted The Most

@gokul1904 made 9 posts!

@sandeep13 made 8 posts!

@Cheatken made 8 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 1 likes!

Monthly Forum rewards - August 2022

Congratulations to all the winners🏆

This post made by @Sairam_RPA received 1 likes!

Get SAP Folder, Sub Folder Information and Use that for Automation

Hi Good afternoon, I am working with an SAP application. In this application I need to get all the folders, sub folders information and all files information. I have developed a bot that scrapes all the data from the SAP application. It uses hot keys to click down and does a CTRL+C to get the file name’s and sends a right key to open the folders. My question is I am unable to indentify which one is a folder which one is a file from the data I get. Is there a way UiPath Can Identify this infor…

This post made by @FAIZANKHAN_PATHAN received 1 likes!

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

I was impressed with the banking example where he has to copy every value and paste in different place,it was he best example to explain rpa.

Top 3 Most Liked Solutions

This solution provided by @Areej_fatima received 1 likes!

For each와 selector 변수 활용 질문

Hi You can use wild cards in your selector for make selectors dynamic Thanks

This solution provided by @Nishant_Banka1 received 1 likes!

How to add serial numbers in particular column

Hi, Initialize an int32 variable counter with value 1, then loop through your datatable and for each row, set the value with column name ‘#’ to the counter. Increment the counter on each loop. [image] Finally write the datatable back to the Excel Thanks, Nishant

This solution provided by @ppr received 1 likes!

To extract substring with Regex

[grafik] (?<=\().*?(?=\))

---

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

Top 3 Topics with Most Views

Schedule a process to run continuously 24/7 forever made by @NotFranmax with 47 views.

Find match for rows in excel made by @gokul1904 with 45 views.

How to extract the specified data from the text file? made by @jamunatj with 44 views.

Top 3 Topics with Most Replies

Find match for rows in excel made by @gokul1904 with 17 replies.

Schedule a process to run continuously 24/7 forever made by @NotFranmax with 14 replies.

How to extract the specified data from the text file? made by @jamunatj with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 26 posts!

@Yoichi made 21 posts!

@Sanjit_Pal made 20 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

Basic concept of Macros

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the expressions related to Macro How to Run the Macro Here are the steps to run the macros Go to the Developer tab Click on Macros In the Macro dialog box, select the macro you want to run. Click on Run button. [image] [image] Unhide All Worksheets Except the Active Sheet User needs to unhide all the workbook at one go, try to execute macros. Sub UnhideAllWoksheets() Dim ws As Worksheet For E…

This post made by @ppr received 3 likes!

Schedule a process to run continuously 24/7 forever

vs. [grafik]

This post made by @Sanjit_Pal received 2 likes!

How Do I Remove the Spcae From the Datatable Cloumn header?

Hey @kishan.savaliya, You can do it using the below method. [image] Thanks, Sanjit

Top 3 Most Liked Solutions

This solution provided by @Gangadhar_Athili received 1 likes!

How Do I Remove the Spcae From the Datatable Cloumn header?

Read Sheet Without Headers (DT) DT.Asenumerable.First().itemarray.Select(function(v) v.Trim).Toarray Now Take For Each inside that Assign DT.Columns(idx).ColumnName=item put idx variable in For each output at the end write the data into excel without add headers.

This solution provided by @Yoichi received 1 likes!

Copy Paste Range with variable

Hi, How about the following? range1+":"+range2 Regards,

This solution provided by @ppr received 1 likes!

Find match for rows in excel

have a check at: [grafik] (From d In dtData.AsEnumerable Let sc = strCUR.Trim.Substring(0,2).toUpper Let sa = strACC.Trim.Substring(strACC.Trim.Length - 4).toUpper Let rm = d("Remit_ID").toString.Trim.toUpper Where rm.StartsWith(sc) Or rm.EndsWith(sa) Let cm2 = Convert.ToInt32(rm.StartsWith(sc)).toString Let cm1 = Convert.ToInt32( rm.EndsWith(sa)).toString Let msk = CInt(cm1 & cm2) Where msk > 0 Order By msk Descending Select v = d("Supplier_ID").toString).DefaultIfEmpty("No record found").Fi…

---

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

Top 3 Topics with Most Views

Add header row to top of existing data datatable made by @Jcircuit13 with 46 views.

Advanced RPA Certification Question made by @sainandini.mannava with 45 views.

Cannot publish library with flowchart activity used made by @kaydine.santuyo with 43 views.

Top 3 Topics with Most Replies

Merge multiple rows in one made by @ravindar.singh with 17 replies.

Assign - the source contains no data row - problem with extracting data from empty datatable made by @Olivera_Kalinic with 17 replies.

How to add key & value to the dictionary from the text file? made by @jamunatj with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 38 posts!

@Sanjit_Pal made 21 posts!

@Shubham_Dutta made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

How to add key & value to the dictionary from the text file?

@jamunatj [grafik] Feel free to decompose the oneliner to part steps File.ReadAllLines(strFilePath) .Skip(1) .Where(Function (x) Not String.IsNullorEmpty(x.Trim)) .Select(Function (x) Regex.Split(x.Trim,"\s{2,}")) .toDictionary(Function (x) x.First(),Function (x) x.Last())

This post made by @qbrandon received 2 likes!

UiPathのアクティビティではどのようなVB.NET Codeが実行されるか確認できないでしょうか？

恐れ入りますがUiPathのオフィシャルなActivityのソースコードは基本非公開です。 マーケットプレースのパッケージは物によってgithubで公開されているコードがたまにあります。 ちなみに、ほとんどのアクティビティがC#で実装されています。

This post made by @Yoichi received 2 likes!

Regex Help Is not Match

Hi, How about using Regex.Replace as the following? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=\r\n)(.+?)(?= \d{4,5} (?:[\w]+: |Documents))(?:[^a-zA-Z]+)([^\s]+)\s(.+)(?= [A-Z0-9]+ /) (.+)(?=/ \d{2}/\d{2}/\d{4})(?:.*)(?<=\d{2}:\d{2}:\d{2}\s)([\d]+)","") Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Regex Help Is not Match

Hi, How about using Regex.Replace as the following? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=\r\n)(.+?)(?= \d{4,5} (?:[\w]+: |Documents))(?:[^a-zA-Z]+)([^\s]+)\s(.+)(?= [A-Z0-9]+ /) (.+)(?=/ \d{2}/\d{2}/\d{4})(?:.*)(?<=\d{2}:\d{2}:\d{2}\s)([\d]+)","") Regards,

This solution provided by @ppr received 2 likes!

Regex to filter on first occurrence of 3 or 4 digits in a sting

ok bold did mislead us [grafik]

This solution provided by @Gokul001 received 2 likes!

Merge multiple rows in one

HI @ravindar.singh How about this expression? (From d In BuildDT.AsEnumerable Group d By k=d("Booking No").toString.Trim Into grp = Group Let nj = String.Join(" ",grp.Select(Function (n) n("Leading passenger 1").toString.Trim)) Let ra = New Object(){k,grp.First()(1),grp.First()(2),nj,grp.First()(4)} Select r = DtOutput.Rows.Add(ra)).CopyToDataTable 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 | 07 September 2022

Top 3 Topics with Most Views

Python Activity : Invoke Python Method made by @Sukanya_Dutta with 55 views.

Is there a way to get all the variable names and store it in String array? made by @_waysi with 49 views.

How to copy entire row in one excel and paste in to excel made by @Baby123 with 42 views.

Top 3 Topics with Most Replies

Python Activity : Invoke Python Method made by @Sukanya_Dutta with 22 replies.

REGEX look ahaed to another word made by @adrian_sullivan with 18 replies.

Is there a way to get all the variable names and store it in String array? made by @_waysi with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 41 posts!

@Sanjit_Pal made 21 posts!

@Gokul_Jayakumar made 20 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

How To Generate an Pivot using Macros

Hello Everyone, Hope you are doing well I would like to present this post who are looking for the expressions related to Create an Pivot using VBA script Creating the Pivot using VBA Option Explicit Sub CreateNewSheet() ' ' CreateNewSheet Macro ' ' Dim wb As Workbook Dim ws As Worksheet Dim Name As String Dim SourceR As Range Dim TableName As String Set wb = ThisWorkbook Set SourceR = Range("A1").CurrentRegion TableName = "NewTable" Set ws = ActiveSheet With wb …

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

Debug incomign API requests

If you don’t have a Network engineer internally that may help you, you may install Fiddler in the Orchestrator machine and in the machine that is performing the requests. How to Collect Fiddler logs? Download the version for your system Download Fiddler Web Debugging Tool for Free by Telerik Extract the files Double Click on Fiddler to open and install. Configure Fiddler to decrypt HTTPS traffic Within Fiddler, click Tools → Fiddler Options Select the HTTPS tab Check the checkbox to Decrypt …

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

【UiPathアカデミーよりお知らせ】

平素よりUiPathアカデミーをご利用いただきありがとうございます。 この度「RPAスタータープログラム」が、v2021.10対応の新学習プランとして「RPAスターター」にリニューアルいたしました。 「RPAスターター」は、2つの新しいコース「RPAと自動化入門」と「StudioX による初めてのオートメーション開発」で構成されており、RPAやUiPathに関する疑問に対してお答えすると共に、UiPath StudioXを使用した初めてのオートメーション開発を行います。 現在「RPAスタータープログラム」をご受講中の方は、恐れ入りますが2022年9月14日までに修了いただきますようお願い申し上げます。 なお「RPAスタータープログラム」修了済みの方は、9月14日以降も修了証明書の発行*は可能です。 また、2022年7月19日より「RPAデベロッパー基礎プログラム」も、v2020.10対応の「RPAデベロッパー基礎」としてリニューアルいたしております。 旧プログラムを既に修了されている方は今後も修了証明書の発行*は可能ですが、ぜひ「RPAデベロッパー基礎」もご受講ください。 …

Top 3 Most Liked Solutions

This solution provided by @Sanjit_Pal received 1 likes!

My Final statement runs every time in my flow and i want this to be run if bots fails

Keep you final statement workflow in the catch block inside the exception object in this way it wont execute for each iteration, it will be executed for the iteration if the iteration will throw the error

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

How do I pass the column values to another column in Excel in the same sheet in this scenario?

[image] for columnFecha you need to specify the range e.g. I333 to i350 if you only specify I333 it will only copy the value of I333

This solution provided by @ppr received 1 likes!

How to check if a element/node exist in the xml to perform the next actions

One of a few options Xdoc.Root.Descendants(Xns + “Supplier_Invoice_Reference”).Count > 0

---

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

Top 3 Topics with Most Views

Data table extraction made by @Prasanth_98 with 39 views.

How to Split Date from Text made by @kaveri_satpute with 36 views.

Change QueueItem Status made by @sacad with 35 views.

Top 3 Topics with Most Replies

Reading all the files inside for each files in folder activity made by @Vidhi_Patel with 23 replies.

Data table extraction made by @Prasanth_98 with 22 replies.

How do I check for adjacent characters and if they match, delete one? made by @Vlad_Svitelskyi with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 31 posts!

@raja.arslankhan made 29 posts!

@muthuraman.g made 21 posts!

Top 3 Most Liked Posts

This post made by @Domo_Arigato received 2 likes!

Revamped Alerts in Orchestrator

Wish we could adjust time daily alert is sent. Living in UTC +10 the email arrives at 17:00 (17:03 to be exact) Information is too old to be useful when reading email following morning for events which happened >24 hours prior. The only documentation to change this indicates on-premises only.

This post made by @Bogdan_Doaga1 received 2 likes!

Revamped Alerts in Orchestrator

Hi, Eeva! Yes. These improvements will be included in Orchestrator 22.10 on-prem release

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

Error UIPath Opened In anoter studio

Hi @MUHAMED_HUSSAIN_BIN_HITHA , There is multiple reasons associated with this error. I have provided all the troubleshooting steps below. Which is worked for me. Try restarting UiPath Studio Try rebooting the workstation/ server/ computer Ensure no other User does not maintain any access to the files specific to the current project Temporarily disable the anti-virus and firewall and try publishing the project Open task manager – check for presence of any project specific Process/Task and clo…

Top 3 Most Liked Solutions

This solution provided by @muthuraman.g received 2 likes!

Error UIPath Opened In anoter studio

Hi @MUHAMED_HUSSAIN_BIN_HITHA , There is multiple reasons associated with this error. I have provided all the troubleshooting steps below. Which is worked for me. Try restarting UiPath Studio Try rebooting the workstation/ server/ computer Ensure no other User does not maintain any access to the files specific to the current project Temporarily disable the anti-virus and firewall and try publishing the project Open task manager – check for presence of any project specific Process/Task and clo…

This solution provided by @Gokul001 received 1 likes!

How remove duplicates character in string variable?

Hi @Vlad_Svitelskyi Welcome to UiPath community String.Join("",StringInput.Distinct) Check out the XAML file Remove DuplicateCharacter.xaml (4.8 KB) [image] Regards Gokul

This solution provided by @ppr received 1 likes!

Comparing Excel columns

A multi code handling could look like this [grafik]

---

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

Top 3 Topics with Most Views

How can I concatenate the rows in excel made by @HeartCatcher with 45 views.

Deleting multi-column filtering results made by @nilesay with 35 views.

Date Compare Issue made by @Robotics with 35 views.

Top 3 Topics with Most Replies

Regex pattern to remove any html code from a data made by @Fahad_Sheji with 26 replies.

How can I concatenate the rows in excel made by @HeartCatcher with 24 replies.

Date Compare Issue made by @Robotics with 22 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 35 posts!

@Gokul001 made 30 posts!

@Gokul_Jayakumar made 26 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 3 likes!

How To use Arithmetic operator using LINQ

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the expressions related to Arithmetic operator Min | Max | Sum | Average Introduction Aggregate expressions are used to make calculations over a specific set of records. For example, to calculate the total Quantity of all records, or the total number of records in the dataset. Sum operator SUM function can be extremely useful to calculate the sum of the items in a list/Collection LINQ Expression …

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

Error UIPath Opened In anoter studio

Hi @MUHAMED_HUSSAIN_BIN_HITHA Its not orchestrator or studio issues. No need to compare with other bots/process. Give a try to follow the above steps, it actually fixed my issues. Also as @Gokul001 suggested check your Project.json location. There will be a chance you have copied your projects in multiple locations.

This post made by @Zishan_Sk received 1 likes!

How to change date format?

thanks this is the shortest and prettiest way to define date and conversion

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Cannot split the word set between 2 word sets

Hi, The above expression works in my environment as the following. Can you check the following sample? [image] Sample20220909-3.zip (3.3 KB) Regards,

This solution provided by @Gokul001 received 1 likes!

Cannot count the outlook mails using the count although there are emails in outlook inbox

Have you logged into the Outlook App [image] I think you are using it in the Online Outlook, So switch to configure the Outlook App in you PC and try it 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.