Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 October 2022

Top 3 Topics with Most Views

Microsoft.Activities.Extensions - missing availability for projects not set to Windows - Legacy made by @Antonio_Campos1 with 44 views.

Writing Insert Query in uipath studio made by @KavinduPerera with 40 views.

Studio CE版の自動更新が失敗し22.10.1と22.4.3両方存在しアンインストールできない made by @megDonuts with 40 views.

Top 3 Topics with Most Replies

Writing Insert Query in uipath studio made by @KavinduPerera with 19 replies.

Check c drive folder made by @C99 with 16 replies.

Creating seperate excel based on dates made by @sruthesanju with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 55 posts!

@Sudharsan_Ka made 48 posts!

@supermanPunch made 32 posts!

Top 3 Most Liked Posts

This post made by @Folorunso received 3 likes!

Meet the UiPath Student Developer Champions 2022-2023!

I’m fortunate to have you as my mentor. Thank you for the great skills and knowledge you’ve imparted to me.

This post made by @Naoko_Sato received 3 likes!

【回答期限延長！！】ローカリゼーション品質満足度調査へのご協力のお願い

こんにちは！ UiPath製品のユーザーインターフェイスとドキュメントポータルの日本語化を担当している、プロダクトトランスレーションチーム（PTチーム）です。 このたび、PTチームではローカリゼーション品質満足度調査を実施することとなりました。普段UiPath製品やユーザーガイドをご利用いただく中で感じていることについて、ユーザーの皆さんの率直なご意見を大募集中です。本調査には2022年11月25日*までご回答いただけます。 *より多くの方にご回答いただくために期限を延長いたしました！お気軽にご回答ください。 また、弊社Webサイトのデベロッパーブログに私たちのチームの紹介記事も掲載しました。UiPath製品の日本語化を進める中でチームが行ってきた、業務効率化に向けたさまざまな取り組みについて綴っています。お仕事の息抜きがてら、ぜひご覧になってみてください！

This post made by @afe.araromi received 2 likes!

Meet the UiPath Student Developer Champions 2022-2023!

The #uipathcommunity keeps building lives and contributing to career development for both students and professionals around the globe. Congrats to all the Student Developer Champions!! Kudos to my mentee, @Folorunso for this special recognition.

Top 3 Most Liked Solutions

This solution provided by @Emira received 1 likes!

Group data and sum only one of the groups in excel

Hi @Lynx Try this: Datatable1.AsEnumerable.Where(Function(x) x("col1").ToString.Equals("100")).Sum(Function(y) Cint(y("col2"))) Just change col1 and col2 with your column names. [image] Let me know if that works for you

This solution provided by @RajKumar_DC received 1 likes!

How to autoincrement cell index in Excel formula for Write Cell

Hi @mavsp8, Welcome to UiPath Community Create “Index” variable in For each Excel Row activity then user that variable in write cell activity [image] If not so use below method [image] Test.xaml (7.7 KB) Thanks, Rajkumar

This solution provided by @Yoichi received 1 likes!

Studioxの繰り返し(各シート)で2つのブックのシートを交互に繰り返す方法

こんにちは いくつか方法ありそうですが、例えば、両方のワークブックのシート名をそれぞれリストに格納しておいて、それをイテレートすれば良いように思えます。以下サンプルです。 [img20221020-1] NewBlankTask18.zip (68 KB)

---

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

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

[system]

Daily Forum Report | 21 October 2022

Top 3 Topics with Most Views

Studio 2022.10 not working properly made by @mohamedalthaf with 38 views.

Under for each row made by @manoj_verma1 with 38 views.

Hi i got error made by @Halimah with 38 views.

Top 3 Topics with Most Replies

Get text in loop ans string concatenation made by @RACHEL_PAUL with 16 replies.

Job stopped with an unexpected exit code: 0xC00000FD made by @MAdona_salah with 15 replies.

How can I convert String to a Dictionary(Of String, String())? made by @bibalesecret with 14 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 38 posts!

@Gokul001 made 34 posts!

@Rahul_Unnikrishnan made 32 posts!

Top 3 Most Liked Posts

This post made by @Desiree_Gil_Corral received 2 likes!

Ciphix - RPA Developer - Rotterdam - Netherlands - Full Time

Job title: RPA Developer Job role: RPA Developer Country: Netherlands City: Rotterdam Company name: Ciphix Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Ciphix is a Rotterdam-based IT implementation company dedicated to helping organizations unlock human potential through smarter business process automation. With an integrated approach to RPA and Machine Learning, we’re able to offer our clients – including global brands and government organizations …

This post made by @Gokul001 received 2 likes!

Not able to see Bala reva packages after the latest studio update

Hi @muhamed_fasil In the targetFramework - Window Legacy you can find the Balareva Package [image] UiPath Studio Version [image] In the targetFramework - Windows I don’t see the BalaReva Package [image] Regards Gokul

This post made by @supermanPunch received 2 likes!

Not able to see Bala reva packages after the latest studio update

Hi @muhamed_fasil , As the latest updates requires all packages to be compatible with .Net 6 ,some of the packages (Even UiPath Packages) are not available. Although I do not have the updated version, but it is a common occurring issue/post in forum. Check the below post :

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Not able to see Bala reva packages after the latest studio update

Hi @muhamed_fasil In the targetFramework - Window Legacy you can find the Balareva Package [image] UiPath Studio Version [image] In the targetFramework - Windows I don’t see the BalaReva Package [image] Regards Gokul

This solution provided by @ppr received 2 likes!

How can I convert String to a Dictionary(Of String, String())?

when this string from excel “New Dictionary(Of String,String())From{{“010”,{“gesperrt”,“in Erstellung”,“im Hintergrund”,“in Bearbeitung”,“fehlerhaft”,“neu”}}}” should be used as VBCode code then you are blocked as compiling cannot be bypassed How about: stroring dictionaray as JSON String "{'010':['gesperrt','in Erstellung','im Hintergrund','in Bearbeitung','fehlerhaft','neu']}" Deserializing it to a dictionary [grafik] Newtonsoft.Json.JsonConvert.DeserializeObject(Of Dictionary(of St…

This solution provided by @Sudharsan_Ka received 1 likes!

How to assign value in datetime list variable

HI @Aleem_Khan Try like this New List(of DateTime) From{DateTime.ParseExact("4/5/2022 1:02 PM","d/M/yyyy h:mm tt",nothing),DateTime.ParseExact("4/5/2022 3:39 PM","d/M/yyyy h:mm tt",nothing),DateTime.ParseExact("4/5/2022 3:28 PM","d/M/yyyy h:mm tt",nothing),DateTime.ParseExact("4/5/2022 1:15 PM","d/M/yyyy h:mm tt",nothing)} To sort use this String.Join(",",list.OrderBy(Function(s) s)) [image] Hope this helps Regards Sudharsan

---

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

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

[system]

Daily Forum Report | 22 October 2022

Top 3 Topics with Most Views

How do I replace only certain characters of a filename? made by @ayeo22 with 39 views.

Error opening Excel file made by @chuan_ming_foo_from.tp with 35 views.

Chromeのプロセス名は？ made by @gorby with 35 views.

Top 3 Topics with Most Replies

How do I replace only certain characters of a filename? made by @ayeo22 with 34 replies.

Invoke Method (Rename) renames only filename1 when two filenames are similar made by @ayeo22 with 18 replies.

Not view the System Option made by @Castillo_Luis_Peru with 12 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 42 posts!

@ayeo22 made 31 posts!

@Sudharsan_Ka made 21 posts!

Top 3 Most Liked Posts

This post made by @lynnsong986 received 2 likes!

Multiple bots processing queue items and updating same excel workbook

I found some instructions on how to do this，thank you so much for your help!

This post made by @Gokul001 received 2 likes!

Need help with Excel formatting

HI @Sami_Rajput Check Out the XAML file GroupByLinq.xaml (18.7 KB) Output [image] Regards Gokul

This post made by @supermanPunch received 2 likes!

Invoke Method (Rename) renames only filename1 when two filenames are similar

@ayeo22 , Using this Expression in the second iteration, you might be picking up the renamed file again. You Should Store the file paths or the excel and pdf file path collection in two different collection variables (Array/ List of String), then use the collection variables instead of Directory.GetFiles("") pdfFilePaths = Directory.GetFiles("C:\XXX","*.pdf").ToArray excelFilePaths = Directory.GetFiles("C:\XXX","*.xlsx").ToArray Your Parameters in Invoke Method would then be : First argum…

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Need help with Excel formatting

HI @Sami_Rajput Check Out the XAML file GroupByLinq.xaml (18.7 KB) Output [image] Regards Gokul

This solution provided by @supermanPunch received 2 likes!

Invoke Method (Rename) renames only filename1 when two filenames are similar

@ayeo22 , Using this Expression in the second iteration, you might be picking up the renamed file again. You Should Store the file paths or the excel and pdf file path collection in two different collection variables (Array/ List of String), then use the collection variables instead of Directory.GetFiles("") pdfFilePaths = Directory.GetFiles("C:\XXX","*.pdf").ToArray excelFilePaths = Directory.GetFiles("C:\XXX","*.xlsx").ToArray Your Parameters in Invoke Method would then be : First argum…

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

Excel Sheets formatting - need help

use this @Sami_Rajput Sequence7.xaml (15.6 KB) result (written to result.xlsx) [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 | 23 October 2022

Top 3 Topics with Most Views

Microsoft.Activities Package not found in any feed, NU1202 made by @mlevine with 40 views.

Set one default value for the entire fixed array made by @esraa_elzoghby with 35 views.

URL入力欄をテキストボックスに変更したい made by @gorby with 31 views.

Top 3 Topics with Most Replies

Get value from specific cell datatable1 and write it in specific datatable2 made by @ldiaz with 9 replies.

Get text save to excel is not showing made by @Siva_Ranjan with 8 replies.

Can't Use UiPathTeam.Interactive.Activities after uipath is updated made by @kunal.deshmukh with 6 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 6 posts!

@Rahul_Unnikrishnan made 6 posts!

@Sudharsan_Ka made 5 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 4 likes!

Happy and safe diwali

Hello friends and uipath family!!! Wishing you happy and safe Diwali to you and your family. Love you all… Let’s learn and let learn!! Regards Sudharsan

This post made by @ptrobot received 2 likes!

Set one default value for the entire fixed array

You could use Repeat(). myArray = Enumerable.Repeat("Mango", 10).ToArray

This post made by @Rahul_Unnikrishnan received 1 likes!

Get value from specific cell datatable1 and write it in specific datatable2

Hello @ldiaz You can use below expression to get value from first datatbale str_output = Datatable1.Rows(rowindex)(“columnname”) Below expression to write to Datatable2 Datatable2.Rows(rowindex)(“yourcolumnname”) = “str_output” Thanks

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

Set one default value for the entire fixed array

You could use Repeat(). myArray = Enumerable.Repeat("Mango", 10).ToArray

This solution provided by @ppr received 1 likes!

Random generator not so random?

@Andre_Santos Welcome to the forum give try at following: Define a variable: name: myRandom | DataType: System.Random | DefaultValue: new Random() Whenever you want to generate a random number use the following statement: myRandom.Next() Mod dtData.RowCount we just let us generate a more wide range of numbers and with the modulo operation we bring it to the restricted slot. When doing this we encountered a better distributed random result

---

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

Top 3 Topics with Most Views

Roles and Responsibilities for your RPA Resume made by @Vajrang with 162 views.

[To be solved in 22.10.3] Modern Activities Not Working if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de") made by @sava.tomov with 53 views.

Convert array string to integer made by @Aguirre with 40 views.

Top 3 Topics with Most Replies

Convert array string to integer made by @Aguirre with 22 replies.

Matches RegEx activity made by @ELISA_ARTALEJO_BARINAGA with 11 replies.

Expression activity type 'VisualBasicValue'1' requires compilation in order to run made by @Short with 11 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 28 posts!

@supermanPunch made 23 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @sava.tomov received 9 likes!

[To be solved in 22.10.3] Modern Activities Not Working if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de")

Hello, we noticed the following bug in UiPath Studio with Modern Activities. They DO NOT work properly if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo(“de-de”) is set. Any culture info that interprets comma as decimal separator has the same issue. [image] If the culture info is set to “en-us”, the same activity works properly. [image] The desribed bug is observed with the following dependencies: UiPath.System.Activities 22.10.2 + UiPath.UIAu…

This post made by @charliefik received 1 likes!

RPA Developer Foundation - Feedback Space

Data Manipulation With Lists And Dictionaries course. There are a couple of issues with this course I think The documents at the end are all about regex (theres also one link that says date time but takes you to regex page) they look like the document list from the string manipulation course. In the Practice 2 Dictionaries there is a for each loop where in the solution the loop variable type has been set to system.collections.generic.KeyValuePair without any mention of what that is in any…

This post made by @sharon.palawandram received 1 likes!

Help us answer the topics where users are still waiting for your help

excellent idea!

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Extract date from string , the date format is not specific

refer to the cheat sheet linked above maybe a regex.IsMatch is what you are searching also we do have the success property [grafik]

This solution provided by @LeviGraff received 1 likes!

How to get the last row index of a Specific column in a DT?

You could loop through each row, check if your column is null or empty with String.IsNullOrEmpty(yourRow(“YourColumn”).ToString), and if false use the index from the for loop - 1 as your row number.

This solution provided by @Kyleb91 received 1 likes!

Display Datatable in a UiPath Action Center Form

I got it! I imported Datatable type, using data grid and text fields, the field properties need to be EXACT matches to the column names… I had a couple of spaces in between header names… Thanks!

---

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

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

[system]

Daily Forum Report | 25 October 2022

Top 3 Topics with Most Views

How to retrieve specific data from a txt file? made by @Kumar_Sahu_Sameer with 51 views.

Use if condition made by @guptasweb with 51 views.

How to get the amount matches with the input made by @sruthesanju with 48 views.

Top 3 Topics with Most Replies

How to get the amount matches with the input made by @sruthesanju with 27 replies.

Use if condition made by @guptasweb with 27 replies.

HRESULT からの例外:0x80131040 made by @miwa_yamamoto with 20 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 56 posts!

@Yoichi made 22 posts!

@guptasweb made 22 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

UiPath.PDF.Activitiesがダウンロードできない

こんにちは どうやら22.10ではオフィシャルフィードが従来と異なる場所が設定されているようです。 そこに必要なパッケージが無いためインストールできなくなっています。 そこでパッケージ管理→設定で下記のURLをフィードとして追加してもらえますでしょうか？（名前はOfficial_Old等適当なものをつけて） https://www.myget.org/F/workflow/api/v3/index.json 追加し終わったらPDFパッケージを再度導入してみてください。

This post made by @GT_Ropa received 2 likes!

Get the count of column

Hi @agathiyanv Try this please. [image] dt.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Column1”).ToString)).CopyToDataTable.RowCount count is a int32 variable dt is a name of datatable Column1 is a name of the column

This post made by @supermanPunch received 2 likes!

Regex Error Ui

@d.ulutas , Try updating to the below Expression : (?<=Supplier Item no\r?\n).*

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

UiPath.PDF.Activitiesがダウンロードできない

こんにちは どうやら22.10ではオフィシャルフィードが従来と異なる場所が設定されているようです。 そこに必要なパッケージが無いためインストールできなくなっています。 そこでパッケージ管理→設定で下記のURLをフィードとして追加してもらえますでしょうか？（名前はOfficial_Old等適当なものをつけて） https://www.myget.org/F/workflow/api/v3/index.json 追加し終わったらPDFパッケージを再度導入してみてください。

This solution provided by @GT_Ropa received 2 likes!

Get the count of column

Hi @agathiyanv Try this please. [image] dt.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Column1”).ToString)).CopyToDataTable.RowCount count is a int32 variable dt is a name of datatable Column1 is a name of the column

This solution provided by @supermanPunch received 2 likes!

Regex Error Ui

@d.ulutas , Try updating to the below Expression : (?<=Supplier Item no\r?\n).*

---

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

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

[system]

Daily Forum Report | 26 October 2022

Top 3 Topics with Most Views

Compare two excel sheet and get the data as per coondition made by @lokeshkumar.k with 39 views.

Regex Equation Help made by @amruta_George with 36 views.

How can I split Excel Data into multiple workbooks/files based on rows in Excel? made by @Israel_Silva with 35 views.

Top 3 Topics with Most Replies

Need to append datatable if the next value is already present made by @sruthesanju with 19 replies.

Read all file excel in folder and write range made by @gilang_ramadhan123 with 19 replies.

UiPath How to loop through rows and columns in Excel sort search inputbox made by @Pru with 17 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 57 posts!

@Sudharsan_Ka made 44 posts!

@anon88744563 made 20 posts!

Top 3 Most Liked Posts

This post made by @Pamela_Sibaja received 2 likes!

Compare two excel sheet and get the data as per coondition

Hi Lokeshkumar, In mi case, I used the LINQ query to match the correct comment. Do you need this result for the data table named Test1? [image] Example: DATA PROCESSING.xaml (9.2 KB) Have a great day! Please let me know if you need anything else.

This post made by @Gokul001 received 2 likes!

UiPath How to loop through rows and columns in Excel sort search inputbox

Hi @Pru Welcome to Uipath community As @Tapan_Behera1 Suggestion You can use For Each Row in DataTable activity to loop through all the row. Regards Gokul

This post made by @WYTham received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi all, I’m from Kuala Lumpur, Malaysia. I’ve been doing UiPath for half a year and happy to get alot of solutions from this forum. I’m here to learn more from the peers and get some feedback or solutions. One day hopefully I can also contribute to the answers to new peers. Cheers.

Top 3 Most Liked Solutions

This solution provided by @tudor.carean received 1 likes!

UiPath.DocumentUnderstanding.Persistence.OrchestratorException document understanding

The error message is not helpful at all unfortunately, and that will be fixed in a future version. It’s just how the .net httpClient behaves when you interrupt it while processing a response. It’s a strange kind of timeout caused by too much parallelism. The executor was doing too much work and didn’t manage to process a response that probably came in time. This can be easily fixed by setting a higher TimeoutMs value on the Create Validation Action activity, OR you could get rid of that Paralle…

This solution provided by @Roxana_Irinei received 1 likes!

[To be solved in 22.10.3] Modern Activities Not Working if System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de")

Hello! This will be fixed with the upcoming version 22.10.3 of the UIAutomations package

This solution provided by @Gokul001 received 1 likes!

Help for understand selectors

Hi @mateo.drouillard Both are same, there is no any different between bot aaname tag is now mandatory for every website, it’s used to uniquely identify an element by Assistive Technologies. aaname stands for Active Accessibility name innertext tag is used to select the sample element in web page Check out the Documentation https://docs.uipath.com/studio/docs/about-selectors#:~:text=One%20of%20the%20ways%20in,shape%20of%20an%20XML%20fragment. [UiPath Selectos Tutorial | Full Tutori…

---

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

Top 3 Topics with Most Views

What's wrong with this dynamic selector? made by @pprin001 with 45 views.

Learning Regex made by @Teck_Hwee_Goh with 42 views.

Round of decimals in string to 2 places made by @gokul1904 with 39 views.

Top 3 Topics with Most Replies

"message": "For each row: Collection was modified; enumeration operation might not execute." made by @gilang_ramadhan123 with 36 replies.

Exception has been thrown by the target of an invocation. assign activity made by @ldiaz with 15 replies.

How can I click on one bottom line in excel? made by @burak with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 53 posts!

@Sudharsan_Ka made 46 posts!

@Yoichi made 33 posts!

Top 3 Most Liked Posts

This post made by @MAZO_YENDE received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I am Mazo. I joined this forum because i am currently working on a school’s project. Looking forward to growing from learning from everyone.

This post made by @pratik.santani received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Everyone, I am Pratik, a UiARD certified developer with experience of 3 years as UiPath Developer and 5 years as Web application developer using Java, Spring. I am here to share my knowledge and learnings with people who need it.

This post made by @ppr received 2 likes!

"Select type" popup not shown after use the "Add to dictionary" activity

@Arabic_Medical_ServiceVTN Welcome to the forum there are some issues / confusions onthis part caused by different reasons Instead add to dictionary you can do: Assign Activity YourDictVar(YourKey) = YourValue

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 2 likes!

While I'm trying to print the whole array value with help of a message box it's showing an empty message only

Hi @Kumar_Sahu_Sameer You should assign a array like {“Cat”,“Dog”,“Cow”,“Monkey”} Each should be seperated you are using inside single double quotes Use this Expression String.join(",",str_Array) Rrgards Sudharsan

This solution provided by @supermanPunch received 1 likes!

Extract Specific numbers from PDF

Hi @Justine , Could you try using the Regex Expression below : (?<=PAID-UP\s+,ORDINARY\s+SINGAPORE, DOLLARS\s+)[\d.,]+ [image] Expression : System.Text.RegularExpressions.Regex.Match(pdfText,"(?<=PAID-UP\s+,ORDINARY\s+SINGAPORE, DOLLARS\s+)[\d.,]+",RegexOptions.IgnoreCase).Value Let us know if this doesn’t work.

This solution provided by @Robert_Lansbergen received 1 likes!

Reframework settings

Hi @pauloengenharia5, [2022-10-27 20_56_10-RoboticEnterpriseFramework4_Windows - UiPath Studio Community] Check your Get TransactionItem activity in GetTransactionData.xaml in: [2022-10-27 20_55_17-Window] How do you retrieve your TransactionItem? Kind regards, Robert

---

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

Top 3 Topics with Most Views

How to give datatable as input to append range activity? made by @RpaNoobMax with 42 views.

Http Request got excel format response, how to convert? made by @372402124 with 42 views.

Regex problem : working on regexr.com but not in UI path made by @Florent_Delage with 42 views.

Top 3 Topics with Most Replies

Http Request got excel format response, how to convert? made by @372402124 with 18 replies.

I want to scrap my page made by @Kuldeep_Pandey with 18 replies.

How to join two data table based on particular column made by @Raja.G with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 93 posts!

@supermanPunch made 30 posts!

@Sudharsan_Ka made 27 posts!

Top 3 Most Liked Posts

This post made by @Manoj_Batra received 2 likes!

How to find element at a specific position from XML using LINQ in UiPath

Problem statement — We have an XML data file and need to extract the element at a specific position entered by the user in a dialog box [image] Import system.xml and system.xml.linq to the project. Now, add 2 assign activities to the workflow area and write the following code. [image] Query to Load xml file Now, write the query to get the element at a specific position [image] Here InputNumber is the integer variable entered by the user. As the numbering starts from 0 that is why we s…

This post made by @Gokul001 received 2 likes!

How to join two data table based on particular column

HI @Raja.G Check out the XAML file TwoDTJoinDataTable.xaml (16.0 KB) [image] Regards Gokul

This post made by @Raja.G received 2 likes!

How to join two data table based on particular column

@Gokul001 , @supermanPunch Thanks guys

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Regex expression to extract numbers

@Justine , Maybe a Correction in the expression would work : (?<=PAID-UP ,ORDINARY\s+UNITED STATES OF\s+)[\d.,]+ System.Text.RegularExpressions.Regex.Match(yourText,"(?<=PAID-UP ,ORDINARY\s+UNITED STATES OF\s+)[\d.,]+").Value

This solution provided by @Gokul001 received 1 likes!

How to join two data table based on particular column

Hi @Raja.G How about this expression? (From data1 In Dt1.AsEnumerable() Join data2 In Dt2.AsEnumerable() On data1("XX no") Equals data2("XX no") Select DtClone.Rows.Add({ data2("XX no"),data1("Name"),data2("Status"),data2("Comment"),data2("Date")})).copytodatatable Check out the XAML file TwoDTJoinDataTable.xaml (12.4 KB) [image] Output [image] Hope it will helps Regards Gokul

This solution provided by @Gokul001 received 1 likes!

Choose current month dynamically

Hi @Justine How about this expression? Year = Now.Year.Tostring Monthnum =DateTime.Now.ToString("MM") MonthMMM = DateTime.Now.ToString("MMM") “V:\Finance\Systems-Risk-ERM\OrderToCash\C2C\ACRA Biz Profile\"+Year+"\"+Monthnum+". "+MonthMMM [image] 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 | 29 October 2022

Top 3 Topics with Most Views

Extract address made by @Nissy_Ruth_Prabhu with 35 views.

Uipath 22.10.3 control java application made by @mawei2 with 29 views.

スクリーンショットを作成⇒画像を保存アクティビティに関する質問 made by @gorby with 29 views.

Top 3 Topics with Most Replies

Uipath 22.10.3 control java application made by @mawei2 with 13 replies.

サブルーチンでエラーが発生してスローした後のCatchハンドラでの「メッセージをログ」の書き方 made by @gorby with 8 replies.

スクリーンショットを作成⇒画像を保存アクティビティに関する質問 made by @gorby with 7 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 30 posts!

@gorby made 13 posts!

@supermanPunch made 13 posts!

Top 3 Most Liked Posts

This post made by @Manoj_Batra received 1 likes!

How to get the first few Elements from XML based on user input using LINQ in UiPath

Problem statement — We have an XML data file and need to extract the first few elements entered by the user in a dialog box [image] Import system.xml and system.xml.linq to the project. Now, add 2 assign activities to the workflow area and write the following code. [image] Query to Load XML file Now, write the query to get the element the elements [image] Here InputNumber is the integer variable entered by the user and the query will pick the number of elements entered by the user Le…

This post made by @supermanPunch received 1 likes!

How can I find the name of all tables in Excel?

Hi @ekseri , Make sure you have given the Direction of the list argument as Out in Invoke Code Activity.

This post made by @Gokul_Jayakumar received 1 likes!

Extract address

@Nissy_Ruth_Prabhu You can use regex to extract the specific part from the string. for example Address: XXX. YYYY, ZZZZ-01235 System.Text.RegularExpressions.Regex.Match(YourString,"(?<=Address:)[A-Za-z\W\n0-9]+").tostring.trim. [image] Based on your requirement, regex conditions can develop

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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

Top 3 Topics with Most Views

Issue in Appending data made by @mittal.abhishek with 36 views.

Write cell activity Object reference is not set to an instance of an object in the second iteration! made by @Rawan.md with 28 views.

Error in state machine workflow made by @rajyavardhansr with 24 views.

Top 3 Topics with Most Replies

Write cell activity Object reference is not set to an instance of an object in the second iteration! made by @Rawan.md with 10 replies.

Issue while Capturing Table from PDF made by @bhupeshsingh with 9 replies.

Error in state machine workflow made by @rajyavardhansr with 9 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 10 posts!

@Sudharsan_Ka made 9 posts!

@supermanPunch made 9 posts!

Top 3 Most Liked Posts

This post made by @MHarakeh received 2 likes!

Sorting Files based on Name & Creating new folders

@supermanPunch I used the mentioned and it worked THANK YOU SO MUCH @supermanPunch @Sudharsan_Ka Much appreciated

This post made by @Arpit_Saxena received 1 likes!

How Can I scrape the phone number from Just Dial Website

@Nandhuba & @Asheesh_Tiwari I came across the same problem as my client asked me to scrape mobile numbers from Justdial as I checked number on Justdial are converted into SVG format as they have no text value what so ever, than I tried to reverse engineer the website and found that we can define the svg values with the reference of their script defining them in the first place at the time of loading. I have already tried and it works just fine but as it is of no use for me anymore I m not going…

This post made by @Arijit_Sarkar received 1 likes!

How to add items to a list?

Appreciate your detail description. It was helpful. You are awesome

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 1 likes!

Write cell activity Object reference is not set to an instance of an object in the second iteration!

Then you can try this @Rawan.md In assign activity Left side - CurrentRow(“Status”) Right side - your status value Now the iteration happens and the status will be updated in the datatable After looping all the rows write range the value after for each row activity and you can see the status appropriate to the rows Regards Sudharsan

---

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

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

[system]

Daily Forum Report | 31 October 2022

Top 3 Topics with Most Views

https://forum.uipath.com/t/485762 made by @Soundarya_Guduri with 51 views.

Sorting Alphanumeric strings made by @shreyaank with 44 views.

Building an automation bot made by @Alfred_Gan with 42 views.

Top 3 Topics with Most Replies

Get the date , month , Year from get text in different format made by @PALKUMARI_PATEL with 21 replies.

Assign: String was not recognized as a valid DateTime please let me know how to fix this? made by @sathish_Kumar6 with 18 replies.

Compress Zip made by @Prasanth_98 with 16 replies.

Top 3 Users Who Posted The Most

@Yoichi made 34 posts!

@supermanPunch made 33 posts!

@Rahul_Unnikrishnan made 20 posts!

Top 3 Most Liked Posts

This post made by @Sergiu.Wittenberger received 3 likes!

A "wonderful" day after the latest Studio update... (Document Understanding Template)

Hi @Roman_hruska, Studio 22.10 needs DU Process 22.10.1 for it to work. The DocumentRejectedByUserException was a change made in the IOCR package which is fixed in our latest 22.10.1 version. It was a breaking change, and if you do migrations, you will have to add a new namespace UiPath.IntelligentOCR.Exceptions in the SetTransactionStatus workflow. Regarding the 2nd Workflow validation error, that is a bug that is being actively worked on. It doesn’t impact the runtime of the workflow, so if …

This post made by @ashwin.ashok received 2 likes!

Fetching Test Manager Screenshots through APIs or Other Means

Hi Everyone, I’ve built around 13 test cases which feeds assertion screenshots back to Test Manager. I was hoping if anyone could guide me on how to fetch and compile these screenshots into a Word/HTML document. I am aware that this question has been asked before, but the responses I’ve seen so far are to use the Take Screenshot Activity and then compile them into word. I didn’t want to do this because I already had the assertions in place, and adding another activity seemed redundant, so I …

This post made by @Gokul001 received 2 likes!

How to remove zeros between 2 digits?

Hi @makboga You can try with Regex Expression System.Text.RegularExpressions.Regex.Replace(YourString,"(?<=TA)0+","").Tostring [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Sergiu.Wittenberger received 3 likes!

A "wonderful" day after the latest Studio update... (Document Understanding Template)

Hi @Roman_hruska, Studio 22.10 needs DU Process 22.10.1 for it to work. The DocumentRejectedByUserException was a change made in the IOCR package which is fixed in our latest 22.10.1 version. It was a breaking change, and if you do migrations, you will have to add a new namespace UiPath.IntelligentOCR.Exceptions in the SetTransactionStatus workflow. Regarding the 2nd Workflow validation error, that is a bug that is being actively worked on. It doesn’t impact the runtime of the workflow, so if …

This solution provided by @Gokul001 received 2 likes!

How to remove zeros between 2 digits?

Hi @makboga You can try with Regex Expression System.Text.RegularExpressions.Regex.Replace(YourString,"(?<=TA)0+","").Tostring [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

Assign: String was not recognized as a valid DateTime please let me know how to fix this?

Can you try to replace the following red rectangle part with the above expression? [image] DateTime.ParseExact(todt,"d-M-yyyy",System.Globalization.CultureInfo.InvariantCulture) Regards,

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

@Yoichi received 72 likes for their solutions!

@Gokul001 received 53 likes for their solutions!

@Sudharsan_Ka received 42 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 November 2022

Top 3 Topics with Most Views

https://forum.uipath.com/t/486077 made by @srujana13a5 with 51 views.

Merging monthly reports not working made by @Sami_Rajput with 49 views.

How can i check the existance of new file in a ftp server every given period made by @Imene_ZARAI with 45 views.

Top 3 Topics with Most Replies

How can i check the existance of new file in a ftp server every given period made by @Imene_ZARAI with 16 replies.

I am downloading Uipath community edition but everytime it is installing enterprise edition so please help made by @veronica16128 with 16 replies.

Merging monthly reports not working made by @Sami_Rajput with 10 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 32 posts!

@Nithinkrishna made 24 posts!

@postwick made 23 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

繰り返し（コレクションの各要素）にinとitemがない

こんにちは まず23.4にてWindows-Legacyは新規作成できなくなりますが、引き続き実行・編集は可能な予定です。そのため特段の理由が無ければ急いでWindowsプロジェクトに変換する必要はないかと思います。 上記の対応ですが、System.Activities Package22.4.4以下を使っている場合は、22.4.5または22.10.3にアップグレードしてみてください。

This post made by @chokota0326 received 2 likes!

繰り返し（コレクションの各要素）にinとitemがない

ありがとうございます！ System.Activities Packageを22.4.5にしましたらwindowsレガシの時にあったエラーも消えましたので、レガシで実行することにしました。 windowsプロジェクト内のforeachもitemとinが出ました！

This post made by @RajKumar_DC received 2 likes!

How can i check the existance of new file in a ftp server every given period

Hi @Imene_ZARAI , What about below workflow [image] Sequence.xaml (9.9 KB) Thanks

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

繰り返し（コレクションの各要素）にinとitemがない

こんにちは まず23.4にてWindows-Legacyは新規作成できなくなりますが、引き続き実行・編集は可能な予定です。そのため特段の理由が無ければ急いでWindowsプロジェクトに変換する必要はないかと思います。 上記の対応ですが、System.Activities Package22.4.4以下を使っている場合は、22.4.5または22.10.3にアップグレードしてみてください。

This solution provided by @RajKumar_DC received 2 likes!

How can i check the existance of new file in a ftp server every given period

Hi @Imene_ZARAI , What about below workflow [image] Sequence.xaml (9.9 KB) Thanks

This solution provided by @muhamed_fasil received 1 likes!

Getting Error While trying Automation on Word File

@Arijit_Sarkar , Can you try relaunching the studio

---

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

Top 3 Topics with Most Views

Web勤怠システムにExcelシートのデータを転記したい。 made by @gorby with 42 views.

Interview Question: types of ways to add queue items made by @Vajrang with 39 views.

HOW TO CHECK CSV HAVE VALUE OR NOT made by @Kelvin1 with 38 views.

Top 3 Topics with Most Replies

Interview Question: types of ways to add queue items made by @Vajrang with 16 replies.

I Need To filter excel data column by using LINQ query made by @Ankit_Chauhan with 14 replies.

In extracted string, i am getting 4string variables which has value or empty.How to get string names whose value is empty made by @vnsatyasunil with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 29 posts!

@Nithinkrishna made 16 posts!

@supermanPunch made 16 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 4 likes!

Interview Question: types of ways to add queue items

Can anyone tell me how many ways we can add items to orchestrator queue?

This post made by @Gokul001 received 2 likes!

How can i create a business exception if an argument contains letters?

HI @andres.alvarez You can try with Throw activity AccountNumber.ToString.IsNumeric New BusinessRuleException("Your text here!!") [image] [image] Regards Gokul

This post made by @michaelyuen received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, I join the forum and expect to find solutions from the community, and share my insights if any.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

How can i create a business exception if an argument contains letters?

HI @andres.alvarez You can try with Throw activity AccountNumber.ToString.IsNumeric New BusinessRuleException("Your text here!!") [image] [image] Regards Gokul

This solution provided by @wilbardmtei received 1 likes!

Copy Excel Chart to Image | Error: 0x8002000B (DISP_E_BADINDEX)

I managed to get a VB.NET code [image] [image]

This solution provided by @TIRUMALA_RAO_GUDLA received 1 likes!

Interview Question: types of ways to add queue items

@Vajrang 1.Add queue item Create queue item with new state Will upload only one item 2.Bulk upload queue items Create queue item with new state Can upload multiple items We will be able to add references when there is a column name “reference” and update all uniqueids for every row. And references need not be unique if queue is not set for unique items 3.Add transaction item Create queue item with inprogress state Can upload only one item 4.Upload queue items directly from orchestra…

---

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

Top 3 Topics with Most Views

Do you have any questions on Orchestrator ask it here made by @Vajrang with 54 views.

How to IF and Else activity use? made by @Alfred_Gan with 43 views.

Orchestrator trigger problem made by @Povilas_Jonikas with 37 views.

Top 3 Topics with Most Replies

Web上のデータを編集したい（データスクレイピングは利きませんでした） made by @miwa_yamamoto with 22 replies.

Value error made by @Ali_Mustafayev with 15 replies.

Reframe worK Initallsettings error made by @Immanuel_George with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 68 posts!

@ppr made 21 posts!

@Nithinkrishna made 20 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 2 likes!

How do i publish a marketplace component that works with both Legacy and Windows frameworks?

I too would be very interested in this. I played around with it last week and made my Visiual Studio project target both frameworks but it didnt result in a nuget package with both compatibilites. A quick knowledge resource on this would be great.

This post made by @Gokul001 received 2 likes!

Orchestrator trigger problem

Hi @Povilas_Jonikas Please follow the below steps 1.Tenant->Manage Access->Select your account->Edit->Robot Setup provide the following Domain/Username Win+R → TYPE whoami->copy the code and provide it in Domain/Username Credential store Orchestrator Database Password Your windows password Credential type Windows credentials Then click on save. Check out this tutorial Regards Gokul

This post made by @mjuriga received 1 likes!

Can't filter files with for each file in folder activity according to file's extensions

Another option is to simply leave the “Filter by” form field blank… or no filtering… or everything. Not every form needs to be filled. UiPath’s user interface can be very trying at times.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Get tenant name during runtime

Hey @jacchr Of course yes, using the odata/GetCurrentUser endpoint. Here is the sample attached - nmnithinkrishna_FindCurrentTenant.zip (2.4 KB) Hope this helps. Thanks #nK

This solution provided by @Gokul001 received 1 likes!

Orchestrator trigger problem

Hi @Povilas_Jonikas Go to Tenant → machine → Edit machine [image] [image] [image] Check do you have Production (Unattended) in it. Regards Gokul

This solution provided by @omer.ozturk received 1 likes!

Write Cell Activity adds an ' to my formular

Hi @bibalesecret, Maybe language difference can cause this. Please check this topic. Uipath add simple quotes on an excel formula Regards Ömer

---

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

Top 3 Topics with Most Views

Rate UiPath On Gartner and get rewarded! ONLY 47 Gift cards left! made by @Dana_Mustatea with 50 views.

How to remove unwanted header in excel made by @Raja.G with 46 views.

Speed up queue trigger made by @J0ska with 43 views.

Top 3 Topics with Most Replies

Speed up queue trigger made by @J0ska with 24 replies.

Can not find “Add to dictionary" made by @gauthamRPA with 14 replies.

There is no option to choose connection on uipath made by @Kelvin1 with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 52 posts!

@Yoichi made 24 posts!

@Nithinkrishna made 18 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 2 likes!

Change DateTime Format from Various Inputs

Hi @sidb You can try with this expression DateTime.ParseExact(YourString,{"yyyy-dd-MM","MM/dd/yy","MM/dd-yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy") Regards Gokul

This post made by @Dana_Mustatea received 2 likes!

Rate UiPath On Gartner and get rewarded! ONLY 47 Gift cards left!

Share your experience with UiPath RPA on Gartner and get rewarded! Guidelines / Please read this carefully You can write your review here Deadline: Nov 15th Rewards: ONLY 47 Gift Cards Left – so hurry up to grab your 25USD Visa Gift Card Your gift card will be automatically issued by the Gartner team once your review gets approved

This post made by @Emira received 2 likes!

Speed up queue trigger

Hi @J0ska The default check interval is 30 minutes, and you’re right, the condition for instantly triggering a new job is a transaction with “New” status. Unprocessed transactions (including retried ones) need to wait for the 30 minutes interval. [image] Now for on premise Orchestrator, The “Queue.ProcessActivationSchedule” parameter can be used to adjust the default 30-minute check interval (with values between 0 and 59). This value is set within the “UiPath.Orchestrator.dll.config” file (y…

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Change DateTime Format from Various Inputs

Hi @sidb You can try with this expression DateTime.ParseExact(YourString,{"yyyy-dd-MM","MM/dd/yy","MM/dd-yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy") Regards Gokul

This solution provided by @Emira received 2 likes!

Speed up queue trigger

Hi @J0ska The default check interval is 30 minutes, and you’re right, the condition for instantly triggering a new job is a transaction with “New” status. Unprocessed transactions (including retried ones) need to wait for the 30 minutes interval. [image] Now for on premise Orchestrator, The “Queue.ProcessActivationSchedule” parameter can be used to adjust the default 30-minute check interval (with values between 0 and 59). This value is set within the “UiPath.Orchestrator.dll.config” file (y…

This solution provided by @Yoichi received 1 likes!

Web上のデータを編集したい（データスクレイピングは利きませんでした）

こんにちは 以下POST以下の内容を確認してみてください。基本的にはGetVisibleTextやNGetTextのNativeモード等で文字列と座標情報を取得して、それを利用すると良いかと思います。

---

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

Top 3 Topics with Most Views

Delete empty rows in excel made by @Aregala_Yedukondalu with 31 views.

Excel operation on dynamic sheet name made by @Md_Saiful_Khaleque with 30 views.

待機アクティビティは無くなった？ made by @gorby with 28 views.

Top 3 Topics with Most Replies

Delete empty rows in excel made by @Aregala_Yedukondalu with 15 replies.

FTP Scope Activity - Folder getting copied instead of PDF files in the folder made by @Karunamurthy with 11 replies.

Connect Studio CE to Enterprise Orchestrator made by @Snowman with 9 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 21 posts!

@supermanPunch made 15 posts!

@Yoichi made 13 posts!

Top 3 Most Liked Posts

This post made by @adamrussell8ubs received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

I work as a management application developer. In Toulouse, I work for a computer services company. I’ve been looking into UiPath for almost a month at the request of a sales manager. I’d like to take possession of the tool. However, this requires extensive training. I am delighted to be a member of the UiPath community. I am a newbie to RPA. I’m hoping to find the knowledge I need in this forum to advance my knowledge of UiPath. Thanks.

This post made by @Gokul001 received 1 likes!

Update row item missing in Studio 2022.4.3

Hi @Javier_Kan Welcome to uipath community Try to update the Uipath.System.Activities and check it [image] [image] Regards Gokul

This post made by @Javier_Kan received 1 likes!

Update row item missing in Studio 2022.4.3

God bless you Gokul, You resolved my issue within minutes, now I can continue to code

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

Update row item missing in Studio 2022.4.3

Hi @Javier_Kan Welcome to uipath community Try to update the Uipath.System.Activities and check it [image] [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

Need help to understand timezone concept

Hi, Because this method is case sensitive. Regards,

This solution provided by @Joe_Matuch received 1 likes!

After Windows Conversion: "Unable to start execution: An item with the same key has already been added. Key: VisualBasicValue `1_1 "

SOLUTION! Took a while to dig into this, but I found that after converting a project from the Legacy framework to the Windows framework, it would not compile the Main.xaml any longer. Eventually, I found that the “VisualBasicValue1_1" key was being used for 2 different transitions. (In addition, "VisualBasicValue1_2” was also being used twice.) The new Windows framework did not like the fact that two transitions were being assigned the same key. (See below.) All I did to fix it was change one…

---

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

Top 3 Topics with Most Views

Passed the UiARD! Wahoo! But now the 5 day wait for the badge begins made by @Wanaka_Digital with 41 views.

Invoke Code OutArgument made by @K_Morgan with 34 views.

[HELP] Invoke Powershell Error made by @KB9191 with 30 views.

Top 3 Topics with Most Replies

ScrapTable from PDF Image into Data table made by @MHarakeh with 10 replies.

Intermittent Click on Save As button works made by @ayeo22 with 9 replies.

Error while Opening Studio - object reference not set to an instance of an object made by @Pramod_Nannaka with 9 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 11 posts!

@Yoichi made 10 posts!

@Nithinkrishna made 10 posts!

Top 3 Most Liked Posts

This post made by @Aleem_Khan received 1 likes!

Can't filter files with for each file in folder activity according to file's extensions

You mean to say assign activity would be place in do section Can you share screenshot please appreciate Thanks in Advance

This post made by @sheelusplsubramanian received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone, I am Sheelaa and i was creating automation processes for a bank in Singapore. Currently I am looking for better opportunities I have a plan to appear for UiARD certification program. I have submitted my REFramework process in Practice REFramework academy. But i am yet to receive my grades and since it is pending i am unable to start my next process. What is the maximum time for receiving the grade?

This post made by @nahueldelacruz received 1 likes!

Exchange mail activities are missing - Studio 2022.10.3

Hi @Yoichi, thanks for your reply. You’re right! It seems there is a problem with Windows compatibility. I can use Windows-Legacy. it’s a pity I cannot convert my project to Windows-Legacy easily. Thanks for your help!

Top 3 Most Liked Solutions

This solution provided by @Konrad_Mierzwa received 1 likes!
https://forum.uipath.com/t/487633/2

This solution provided by @Yoichi received 1 likes!

How to extract Photo numbers into Notepad or Excel?

Hi, Can you try GetFileNameWithoutExtension method and AppendLine activity as the following? [image] Regards,

This solution provided by @Jon_Smith received 1 likes!

Should I go for RE Framework for my project?

This seems more like a linear process rather than a transactional process. A transactional process would be having a list of files to download and the process will iterate over that list and download each one (each file would be considered a transaction). You can just make a simple linear process for this and skip the REFramework if you aren’t familiar with how it works.

---

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

Top 3 Topics with Most Views

Regex pattern to extract address from string made by @MasterOfLogic with 41 views.

Not able to click on a text made by @Kuldeep_Pandey with 41 views.

https://forum.uipath.com/t/487754 made by @srujana13a5 with 38 views.

Top 3 Topics with Most Replies

Not able to click on a text made by @Kuldeep_Pandey with 22 replies.

Datetime format in datatable made by @Kumar802 with 21 replies.

I am Unable Extract Data from Web Page made by @Relangi_Siva with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 85 posts!

@Yoichi made 29 posts!

@Nithinkrishna made 22 posts!

Top 3 Most Liked Posts

This post made by @Sudharsan_Ka received 5 likes!

Monthly Forum rewards - October 2022

Congrats All ! Regards Sudharsan

This post made by @Gokul001 received 5 likes!

Monthly Forum rewards - October 2022

Congrats for all the winner Regards,

This post made by @Rahul_Unnikrishnan received 3 likes!

Monthly Forum rewards - October 2022

Congratulations

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

Verify the Difference between two dates

Check out this XAML file @shruthi_arali Main.xaml (6.6 KB) [image]

This solution provided by @Cristian_Bardas received 1 likes!

Array of Strings - How to stipulate when you are on the last one

Use if index = splitpages.count -1 to figure out if you are on the last array element.

This solution provided by @Gokul_Jayakumar received 1 likes!

Data not getting extracted

Hello @Harish_R1 You have to select the correct indicator of correlated data. Try to indicate at middle of the page, Maybe the 1st-row of data in the website occurs advertisement. Kindly refer to the attached XAML file, You may get some Idea Main.xaml (40.2 KB) [image]

---

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

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

[system]

Daily Forum Report | 08 November 2022

Top 3 Topics with Most Views

Document Understanding Process 22.10 now in General Availability! made by @Sergiu.Wittenberger with 222 views.

Get specified text from String made by @prerna.gupta with 65 views.

How to Iterate through Data column value in for each activity? made by @Vidhi_Patel with 53 views.

Top 3 Topics with Most Replies

Get specified text from String made by @prerna.gupta with 54 replies.

How to convert csv file to dictionary in uipath made by @Monali_Vekariya with 25 replies.

Total number of rows made by @Cuberoot with 22 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 87 posts!

@Anil_G made 47 posts!

@Tapan_Behera1 made 28 posts!

Top 3 Most Liked Posts

This post made by @Sergiu.Wittenberger received 6 likes!

Document Understanding Process 22.10 now in General Availability!

Hello everyone! We are very excited to announce the General Availability release of the Document Understanding Process version 22.10! It can be downloaded from the Official template feed. To get started, simply create a new project in UiPath Studio and select it. [711fcd2-DU_Process_1] [ccad7f6-DU_Process_2] [1e319d5-DU_Process_3] We recommend to carefully read the enclosed User Guide, even if you’re already familiar with the solution. The latest guide…

This post made by @muhamed_fasil received 3 likes!

Monthly Forum rewards - October 2022

Congrats to all the winners

This post made by @StefanSchnell received 3 likes!

Monthly Forum rewards - October 2022

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

Top 3 Most Liked Solutions

This solution provided by @Gokul_Jayakumar received 1 likes!

Get Dynamic DateTime Format

@Rawan.md Try this DATEVAR=DateTime.ParseExact("2022-04-29 12:00:13 م","yyyy-MM-dd hh:mm:ss t",System.Globalization.CultureInfo.GetCultureInfo("ar")) Where, DATEVAR is variable type of syste.DateTime [image] PM [image] AM [image] You can convert it to desired string as DATEVAR.tostring(“yyyy-MM-dd”)

This solution provided by @GT_Ropa received 1 likes!

インデックスおよび長さは文字列内の場所を参照しなければなりません

お疲れ様です。 100%ではないですが、このエラーの元は多分Substringからきます。Substring(1,1)は二つ目の文字を取ります。最初の1は0に変えてみてください。 右辺：元dt.AsEnumerable.GroupBy(Function(r) r(“重複検索列タイトル”).ToString).Select(Function(g) 元dt.Clone.LoadDataRow(g.OrderBy(Function(r) r(“dt左端列タイトル”).ToString.Substring(0,1)).First().ItemArray,False)).CopyToDataTable よろしくお願いいたします。

This solution provided by @Dawodm received 1 likes!

How to Add String Variable values(scrapped values) from for each Datatable loop can be added as colmnn of datatable?

Hi @Vidhi_Patel You can use add DataRow activity inside your loop. Then you can use the variable of the loop (e.g. CurrentRow) and the name of the table you want to store in. These are to be added to the activity: Add Data Row

---

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.