Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 December 2022

Top 3 Topics with Most Views

Building intelligent automations - adding AI to RPA workflows made by @shivaraman_shankar with 48 views.

Assign Integer Value to XML made by @ram_dhas with 43 views.

How add text in variables made by @beginnerui with 41 views.

Top 3 Topics with Most Replies

I want to read the yesterday data from master file which is in .xaml format can anyone help me on it made by @Tea_coffie_235 with 20 replies.

Question of excel made by @purnima_mandan with 15 replies.

Assign Integer Value to XML made by @ram_dhas with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 48 posts!

@Anil_G made 23 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @GT_Ropa received 1 likes!

New Dictionary(Of Srting,Srting) コンフィグファイルを読み込ませる際のエラー

@H_U お疲れ様です。 Assignのところで [image] ちょびっとデータタイプの名前を間違えました。 「Srting」ではなくて、「String」です。 それを試してみてください。 New Dictionary(Of String, String) どうぞよろしくお願いいたします。

This post made by @H_U received 1 likes!

New Dictionary(Of Srting,Srting) コンフィグファイルを読み込ませる際のエラー

ありがとうございました！ 気づくことができなかったので、とても助かりました！

This post made by @Gokul001 received 1 likes!

转换为Windows版本后input Dialog报错

Hi @cindy.zhou Welcome to uipath community Can you try to Re enter the value in the Text box. It is because if the Double Quotation issue "" Check out this thread Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @GT_Ropa received 1 likes!

New Dictionary(Of Srting,Srting) コンフィグファイルを読み込ませる際のエラー

@H_U お疲れ様です。 Assignのところで [image] ちょびっとデータタイプの名前を間違えました。 「Srting」ではなくて、「String」です。 それを試してみてください。 New Dictionary(Of String, String) どうぞよろしくお願いいたします。

This solution provided by @Gokul001 received 1 likes!

转换为Windows版本后input Dialog报错

Hi @cindy.zhou Welcome to uipath community Can you try to Re enter the value in the Text box. It is because if the Double Quotation issue "" Check out this thread Regards Gokul

This solution provided by @Yoichi received 1 likes!

Help what data type should I use when I have numbers or currency?

Hi, Can you try the following? [image] Double.Parse(yourString).ToString("N2") 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 December 2022

Top 3 Topics with Most Views

Condition to check if array is empty or null made by @Ray_Sha1 with 37 views.

How can you "kill" a certain window on an application? made by @tomato25 with 37 views.

How could I get the value of each row in this workflow? made by @pprin001 with 35 views.

Top 3 Topics with Most Replies

How to use select item activity made by @harshikakhatri269 with 10 replies.

Does Re-Framework template in C# exist? made by @wilbardmtei with 7 replies.

Count At_Kt as 1 if subject Mark is less than 40 and calculate total nos of At_Kts. Eg: If any student has less then 40 marks in 2 Subject then ATKT count is 2 ,If any student has less then 40 marks in 3 subject then ATKT count is 3 .......not get result made by @sohil_bagwan with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 13 posts!

@Gokul001 made 10 posts!

@Rahul_Unnikrishnan made 9 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

Hi @Hariram_Narayanan Welcome to the community You can try using orchestrator API’s for this [image] API Reference - API References cheers

This post made by @Hariram_Narayanan received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

Thank you Anil, that is so cool! I’m really excited to try it out.

This post made by @SrenivasanKanna received 1 likes!

AI Center Pipeline Version Accuracy Issues

Thank you so much, i got it.

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 | 04 December 2022

Top 3 Topics with Most Views

Splitting Error made by @MHarakeh with 41 views.

How to use "Build collection activity"? made by @Rawan_Ghurab with 37 views.

How to extract details from PDF to Excel made by @SURESH_P with 33 views.

Top 3 Topics with Most Replies

Empty path name is not legal in global variable made by @Riya_Bansal with 20 replies.

Problem with my automation made by @Nur_Amin with 11 replies.

For each row & Add data row : Collection was modified; enumeration operation might not execute made by @Lakshya_Garg2 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 19 posts!

@Yoichi made 16 posts!

@Swaroop_Singh_R made 7 posts!

Top 3 Most Liked Posts

This post made by @Jair_Warrior received 1 likes!

La comunidad HispanoHablante diga Hola aca!

Saludos a todos.

This post made by @Swaroop_Singh_R received 1 likes!

Condition to check if array is empty or null

Hiiii @Ray_Sha1 you can use arr1.count=0 in condition sooo that you can able to get empty array [image]

This post made by @Anil_G received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

@Hariram_Narayanan From the api reference you can see the swagger file which will have full details about the api input format and all…if that is what you are looking for Orchurl + swaager/index.html would give you the way it has to be used This is the activity where you will pass those api requests in process https://docs.uipath.com/activities/docs/orchestrator-http-request [UiPath Orchestrator API Using Orchestrator HTTP Request Activity | Part 1 | Overview & Demo] Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Click activity is not working to toggle button ON & OFF in chrome (Uipath's Orchestrator turning license ON and OFF buttons)

@Hariram_Narayanan From the api reference you can see the swagger file which will have full details about the api input format and all…if that is what you are looking for Orchurl + swaager/index.html would give you the way it has to be used This is the activity where you will pass those api requests in process https://docs.uipath.com/activities/docs/orchestrator-http-request [UiPath Orchestrator API Using Orchestrator HTTP Request Activity | Part 1 | Overview & Demo] Cheers

This solution provided by @Anil_G received 1 likes!

Reframework error#

Hi @bakrious12 Where you are reading guid from that xaml the guid should be out and where you are trying to set the guid value to queue in that xaml guid should be in In your xaml change the argument guid direction for random name make it as IN And not sure why you are trying to fill infodt twice once in both xaml. because the second one will over right the first one Is that clear? cheers

This solution provided by @Yoichi received 1 likes!

Get outlook mail messages activity not found

Hi, All right. For now can you try to turn on “ShowDeveloper” at Filter in Activities panel? Then we can use GetOutllokMailMessages activity as the following. [image] 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 | 05 December 2022

Top 3 Topics with Most Views

What do we need to get a job in UiPath made by @Vajrang with 76 views.

How can I copy name, email, and phone number from excel into outlook contact WITHOUT ForEach? made by @Lior_Shamir with 51 views.

Finding the similar columns between two different sheets made by @Rawan_Ghurab with 46 views.

Top 3 Topics with Most Replies

Finding the similar columns between two different sheets made by @Rawan_Ghurab with 21 replies.

What do we need to get a job in UiPath made by @Vajrang with 19 replies.

How can I copy name, email, and phone number from excel into outlook contact WITHOUT ForEach? made by @Lior_Shamir with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 78 posts!

@Gokul001 made 53 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 19 likes!

What do we need to get a job in UiPath

you can post questions that you are asked in the interview. post any challenges that you are asked to solve in the program

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - November 2022

Congrats to all the winner

This post made by @Sudharsan_Ka received 3 likes!

Monthly Forum rewards - November 2022

Congrats to all

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Can we declare global variables for invoke code in Uipath

Hi @Riya_Bansal Assigning a global variable to arguments in invoke code is not working? If so you can try assigning to local Variable and use assign activity next to assign that to global variable Cheers

This solution provided by @Yoichi received 1 likes!

エクセルのドロップダウンリストを選択する方法について

こんにちは データの入力規則の機能によるドロップダウンでしょうか？ セル書き込みアクティビティを使えば、任意の値を書き込めますので、 選択する予定の値を直接書き込んでみてください。 [image]

This solution provided by @Gokul001 received 1 likes!

How to Contains Help

Hi @punnipah Try with this expression if(System.Text.RegularExpressions.Regex.Replace(Currentitem.Subject.Tostring,"\W","").Contains("SubjectLCMS"),"S") 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 | 06 December 2022

Top 3 Topics with Most Views

Please provide me code that accepts user input and displays input along with welcome message made by @Vajrang with 83 views.

Definition & Execution of Business Rules for Fields (mandatory, possible values & fixed format rules) made by @Monica_Secelean with 61 views.

row.item().ToString に関して made by @wataru.K with 43 views.

Top 3 Topics with Most Replies

How do I isolate these values as within a PDF? made by @dr1992 with 26 replies.

Excel Application Scope Error but It Doesn't Have This Error Before made by @BBCC_0000 with 21 replies.

How to divaded one number to digits and save every digit in variable made by @mironb with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 116 posts!

@Rahul_Unnikrishnan made 59 posts!

@Yoichi made 38 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 12 likes!

Please provide me code that accepts user input and displays input along with welcome message

Task 1, Sequence Task: Based on the input we should get the welcome message Step: 1 Add Input Dialog Box and give the input Step 2: Add Message box to display a message Projects Deploy it in orchestrator Execute from orchestrator

This post made by @Monica_Secelean received 8 likes!

Definition & Execution of Business Rules for Fields (mandatory, possible values & fixed format rules)

In order to paint the full picture of a Document Type, together with information which is not necessarily available in the document itself, we have added the ability to provide additional information about it. In this effort, I’m happy to report, we started enriching the Document Type with Business Rules, on a Field Level, staring with the Intelligent OCR package version 6.6.0-preview. These rules need to be respected by the extracted field values, in order for the extraction to be consi…

This post made by @StefanSchnell received 4 likes!

Monthly Forum rewards - November 2022

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

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Database activity 2022.10.3

Hi @Sandhya_Gajare Executes a SQL statement on a database, For Update, Insert delete statement we can use Run command activity Run Query will returns the query result in a DataTable

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

Is there any way i can identify the name of the current test case during run time

yep this works. Thanks much !!!

This solution provided by @Anil_G received 1 likes!

Combine two Google Sheets into one?

Hi @Josh_James create a second datatable and after retreiving the data using read range do a merge datatable on to the second datatable in the loop. So that the second time the first dt gets over written and the merge will merge it with the previous data which is already present in it This is how it looks [image] I added dt1.clone when the loop starts or for the first iteration because we need to give a structure to the second dt2 before performing merge Hope this is clear cheers

---

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

Top 3 Topics with Most Views

How to Add data column with values made by @Abdul_Khaliq1 with 39 views.

Extract Data from Browser made by @Pravin_S with 35 views.

Community版をインストールしているはずなのにEnterprise版になってしまう made by @emi.h8gj.nakajima with 34 views.

Top 3 Topics with Most Replies

Community版をインストールしているはずなのにEnterprise版になってしまう made by @emi.h8gj.nakajima with 17 replies.

How to Add data column with values made by @Abdul_Khaliq1 with 13 replies.

VBAのエラークリック made by @chiikawausagi with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 86 posts!

@Yoichi made 25 posts!

@sangeethaneelavannan1 made 15 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Community版をインストールしているはずなのにEnterprise版になってしまう

こんにちは Enterprise のFreeプランですので、利用可能なライセンスはAutoamtion Expressだけになります。 StduioXは使用できますが、Studioは使えないので、Studioを使いたいならCommunityプランが 必要になると思います。（あるいはProを購入するかですが．．．．） 基本的に、StudioがCEかEnterpriseになるかはご推察の通り、AutomationCloud上のプランに依存しますので、今の組織を削除→再作成か、あるいは別のメールアドレスがあるなら、新たに作り直した方が早いかもしれません。

This post made by @Lior_Shamir received 1 likes!

How can I copy name, email, and phone number from excel into outlook contact WITHOUT ForEach&ReadRange - when the excel file is closed?

@gustavo.cervelin Gustavo, you are the best! Thank you for all the help and the good vibes. You did a lot for me Waiting for you in Israel and hope Brazil win the world cup!!

This post made by @Koushik_tatikondawar received 1 likes!

How to execute just 1 time the for each row based on comparing the first "for each" value with the second "For each"

Hello @pprin001, " (CurrentRow(“Nombres”).ToString).Contains((CurrentRow1(“Nombres”).toString).substring(5))" CurrentRow(“Nombres”).ToString = “Planillas_BcoBci20" CurrentRow1(“Nombres”).toString = "Banco BCI” Reference - Str1.Contains(Str2) The expected output for the above code snippet is False, because the .Contains method checks if the entire string “Str2” occurs within “Str2”. I guess you are assuming it would also be checking if all the possible substrings of “Str2” will also be check…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Community版をインストールしているはずなのにEnterprise版になってしまう

こんにちは Enterprise のFreeプランですので、利用可能なライセンスはAutoamtion Expressだけになります。 StduioXは使用できますが、Studioは使えないので、Studioを使いたいならCommunityプランが 必要になると思います。（あるいはProを購入するかですが．．．．） 基本的に、StudioがCEかEnterpriseになるかはご推察の通り、AutomationCloud上のプランに依存しますので、今の組織を削除→再作成か、あるいは別のメールアドレスがあるなら、新たに作り直した方が早いかもしれません。

This solution provided by @Koushik_tatikondawar received 1 likes!

How to execute just 1 time the for each row based on comparing the first "for each" value with the second "For each"

Hello @pprin001, " (CurrentRow(“Nombres”).ToString).Contains((CurrentRow1(“Nombres”).toString).substring(5))" CurrentRow(“Nombres”).ToString = “Planillas_BcoBci20" CurrentRow1(“Nombres”).toString = "Banco BCI” Reference - Str1.Contains(Str2) The expected output for the above code snippet is False, because the .Contains method checks if the entire string “Str2” occurs within “Str2”. I guess you are assuming it would also be checking if all the possible substrings of “Str2” will also be check…

This solution provided by @Lior_Shamir received 1 likes!

Invoke VBA - Write to cell

Hi @Anil_G @gustavo.cervelin The problem was the date.Now.ToString So, the correct way is: Function DateAndTime(RowToRead as string) Sheet1.Range(“F”+RowToRead).Value = Now End Function 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 | 08 December 2022

Top 3 Topics with Most Views

Send Exchange Mail Message: No server address provided error made by @julian_ho with 63 views.

Get marks count with percentage made by @Vajrang with 58 views.

Studio 22.10 Microsoft.Activities.Extensions Add To Dictionary defaulting to Dictionary(of Object, Object) at compile made by @GT_Ropa with 47 views.

Top 3 Topics with Most Replies

Send Exchange Mail Message: No server address provided error made by @julian_ho with 28 replies.

How to get row index based on location? made by @JustZaffan with 24 replies.

Excel write range :current date and time made by @Kuldeep_Pandey with 21 replies.

Top 3 Users Who Posted The Most

@Anil_G made 119 posts!

@Yoichi made 37 posts!

@sangeethaneelavannan1 made 32 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 7 likes!

Get marks count with percentage

please give me code to get total for each person Names RollNo English Maths Hindi Science Social Total Percentage Kiran 1 20 21 23 20 21 Akhil 2 21 22 24 21 22 Ani 3 19 20 22 19 20 Sri 4 14 15 17 14 15 Jaya 5 13 14 16 13 14 Kavya 6 22 23 25 22 23

This post made by @Emira received 3 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

Great News!

This post made by @nikhilesh578 received 3 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

Great News

Top 3 Most Liked Solutions

This solution provided by @Naveen_Mohandas received 2 likes!

Get marks count with percentage

inputDt.Columns(“Total”).Expression=“English+Maths+Hindi+Science+Social”

This solution provided by @Anil_G received 1 likes!

Im getting total 12 matches numbers from the regex but i only want the even number

Hi @sathish_Kumar6 Loop through the 12 matches in a for loop in the for loop properties there is property index create a int32 type variable(var1) and assign to it Then use a if condition inside (Var1 mod 2) = 0 On then side You will have all odd set On else side You will have all even set Cheers

This solution provided by @Anil_G received 1 likes!

User defined package sources is not showing in Manage Packages

Hi @anil_shaw Is the package developed in Windows Legacy ? and current is your project on Windows? then you won’t see the package Open a New project and select Windows Legacy and then check the packages [image] cheers

---

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

Top 3 Topics with Most Views

How to convert a string to date made by @Chendoran_M with 49 views.

Comparacion de tablas con mas de 100.000 registros made by @RPA_Trgasa with 44 views.

Wanted to Add to Queue Items in orchestrator from Data table made by @Sisay_Dinku with 38 views.

Top 3 Topics with Most Replies

How to convert a string to date made by @Chendoran_M with 11 replies.

Matching id with ignoring 1 character made by @ldiaz with 11 replies.

How to get only date from the complete date? made by @harshikakhatri269 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 83 posts!

@Gokul001 made 35 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 2 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

It looks Awesome

This post made by @nikhil.girish received 2 likes!

UiPath is launching a new initiative: UiPath Digital Credentials

That’s a great news!!!

This post made by @BReddy_m received 2 likes!

How to retrieve all successful transaction items from orchestrator Queue?

I have queue and completed all transactions some or failed and other items are succeeded, I need the report only for successful transaction items and send in the excel sheet to business people, Can please anyone help on this.?

Top 3 Most Liked Solutions

This solution provided by @raja_ias received 2 likes!

Send hotkey for Space?

Use " "=> in the key field

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

How to retrieve all successful transaction items from orchestrator Queue?

Hi @BReddy_m Use an activity called Get queue item And there in properties kindly pass your queue name and select your desired state ( successful) U can select the queue item status from the properties and select the successful item only which gives you the list of queue items which are processed successfuly

This solution provided by @Anil_G received 1 likes!

How to extract two zip file and determine the difference of each text inside on a config file?

Hi @wally.cariaga Use unzip activity to unzip it extracts everything out…Now use for each file folder which has an option to include files in sub folders as well and you will be able to get all the sub folder related files as well Then use Directory.Getfiles for second zip file contents and give the filter as the file name required if found then read the file and split the extracted string using new lien character and compare both the arrays …if there are difference print them [image] [ima…

---

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

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

[system]

Daily Forum Report | 10 December 2022

Top 3 Topics with Most Views

How to add semicolon after each value in email address column made by @vielesh with 56 views.

Add 0 in the beginning of a mobile number if the mobile number only has 9 digits and starts with 4 made by @ammohan with 54 views.

Need to remove duplicates on single column made by @manojmanu.rpa with 51 views.

Top 3 Topics with Most Replies

How to remove special characters in excel data table like for one sheet made by @sathish_Kumar6 with 6 replies.

Need to remove duplicates on single column made by @manojmanu.rpa with 6 replies.

I have a excel in which after opening the sheet user will find the grade which is “F19,010” and under this grade it will find the location as “Mumbai” and fetch the value for the same grade under Mumbai City made by @Prathamesh_Chavan with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@Yoichi made 12 posts!

@Rahul_Unnikrishnan made 11 posts!

Top 3 Most Liked Posts

This post made by @shesherao.patil received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Its working thanks a lot for your fine solution

This post made by @Yoichi received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Hi, Can you try to add .Replace(" “,”") as the following? strSelect = options.Split(vbCrLf.ToCharArray,StringSplitoptions.RemoveEmptyEntries).Where(Function(s) s.ToLower.Replace(" ","")=strTarget.ToLower.Replace(" ","")).FirstOrDefault Regards,

This post made by @Anil_G received 1 likes!

How to remove special characters in excel data table like for one sheet

Hi @sathish_Kumar6 Perform a for each row in excel and then use currentRow("Columnname") = System.Text.RegularExpressions.Regex.Replace(currentRow("Columnname").ToString,"[^a-zA-Z0-9\s]","") This will replace all values except the specified which are alphabets numbers and spaces Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Hi, Can you try to add .Replace(" “,”") as the following? strSelect = options.Split(vbCrLf.ToCharArray,StringSplitoptions.RemoveEmptyEntries).Where(Function(s) s.ToLower.Replace(" ","")=strTarget.ToLower.Replace(" ","")).FirstOrDefault Regards,

This solution provided by @Anil_G received 1 likes!

How to remove special characters in excel data table like for one sheet

Hi @sathish_Kumar6 So in the regex cap is for ignore the next characters and what characters i gave are alphabets(a-z and A-Z) , numbers (0-9) , any space characters(\s) .so ignoring these characters all other characters will be replaced [image] If you wnat to do for all columns then i would suggest read the data into a datatable and then use for loop on row and another loop on column inside the row loop and replace it Then write back the data Other way is to do with linq queries but aga…

This solution provided by @Yoichi received 1 likes!

画像の合成処理を代入で処理

こんにちは 返り値がないメソッドを呼ぶときはInvoke Method(メソッド呼び出し）アクティビティを使用する必要があります。 例えば以下になります。 [image] なおGraphics.DrawImageには上記の組み合わせの引数はないと思いますので、 コールする内容は見直したほうが良いように思えます。 詳しくは以下を参照ください。

---

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

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

[system]

Daily Forum Report | 11 December 2022

Top 3 Topics with Most Views

Type into element can't execute made by @mironb with 48 views.

How to delete rows excel that contain unwanted data made by @Nur_Amin with 36 views.

Do I need to have an Unattended bot to use start job and get reference? made by @testbb with 31 views.

Top 3 Topics with Most Replies

How to do Nested For Each Excel Row made by @YUDISTIRO_Evan with 9 replies.

Type into element can't execute made by @mironb with 8 replies.

How to delete rows excel that contain unwanted data made by @Nur_Amin with 6 replies.

Top 3 Users Who Posted The Most

@Yoichi made 11 posts!

@Anil_G made 11 posts!

@purnima_mandan made 6 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Varshney received 1 likes!

Your Automation Community Journey 2022 in Review

Submitted

This post made by @Pravin_S received 1 likes!

Auto iterate through each column

Thanks @Anil_G & @Yoichi

This post made by @testbb received 1 likes!

How To filter Not Null vaulue in dt.select

thank you!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

画像のトリミング

こんにちは このエラーの意味はRectangleが System.Drawing.Rectangle DocumentFormat.OpenXml.Vml.Rectangle のどちらか特定できない旨の内容になります。 解消方法としては New System.Drawing.Rectangle(139, 90, 1024, 1599) と名前空間付きで表記し、どちらのクラスかを明確化すると 良いかと思います。

---

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

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

[system]

Daily Forum Report | 12 December 2022

Top 3 Topics with Most Views

How can i get this? made by @aparna30 with 63 views.

Is there any way to check if there are same file name existing in different zip file? made by @fniedez with 40 views.

Cannot find Add To Dictionary activity made by @Rakshith_VM with 40 views.

Top 3 Topics with Most Replies

Error for Filter DataTable made by @I_am_Praj with 24 replies.

Is there any way to check if there are same file name existing in different zip file? made by @fniedez with 18 replies.

Sort highest IEnumerable RegexMatch made by @uiStijn with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 73 posts!

@Yoichi made 36 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 4 likes!

How can i get this?

Hi @aparna30 I will gave simple solution for this. The first one make as list. The list contains list= new List(of string)(new string(){“Apple_Fruit”,“Grapes”,"Banana”}) The second value make it as string datatype. it contains str = “Apple”. You need use this function list.contains(str) The result is false Please refer the below image [image] Hope you got the answer

This post made by @fniedez received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am new to UiPath, I am trying to do create a basic exercise and I am having some difficulty, so I decided to check out the forum. Thanks, France

This post made by @Kaviyarasu_N received 2 likes!

Your Automation Community Journey 2022 in Review

Submitted

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How to add array to datatable

Hi @pravin_bindage I hope both array are of same length then directly us the below Use for each with in argument as enumerable.range(0,array1.count()-1).toarray and chnage type argument to int32 Use add datarow with array as {array1(currentitem),array2(currentitem)} Cheers

This solution provided by @Yoichi received 1 likes!

Regex match in one group

Hi, What is your expected output? Is it Mr? If so the following works [image] System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Driver\s+)\w+").Value If Mr TEST TESTING, the following will work. [image] System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Driver\s+).+").Value Regards,

This solution provided by @AkshaySandhu received 1 likes!

Get text activity in a parallel

@Povilas_Jonikas in array row use {stringTable,stringTable1}

---

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

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

[system]

Daily Forum Report | 13 December 2022

Top 3 Topics with Most Views

How to convert data variable get from "for each ui element" into datatable for database insertion? made by @hjie30 with 43 views.

Need help in sending API request made by @Learner007 with 41 views.

Compare string with excel column values made by @pravin_bindage with 39 views.

Top 3 Topics with Most Replies

Need help in sending API request made by @Learner007 with 24 replies.

How to convert data variable get from "for each ui element" into datatable for database insertion? made by @hjie30 with 18 replies.

Adding data into data table made by @Abdul_Khaliq1 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 104 posts!

@Yoichi made 37 posts!

@sangeethaneelavannan1 made 30 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Selectors are not editable

Hi, It’s because you use this inside OpenBrowser or AttachBrowser activity and top level selector is inherited from the activity. if you need to edit this, can you try to put the activity outside OpenBrowser or AttachBrowser, and indicate the target element, then edit. Regards,

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

Document understanding error while copying to a stream

i tried using machine learning extractor on a 27-page pdf and it threw this exception after a minute of waiting [image] but it works fine for smaller pdfs e.g. 1-10 pages

This post made by @Anil_G received 1 likes!

Document understanding error while copying to a stream

Hi @jack.chan It has some limitations. Please check this [image] cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Document understanding error while copying to a stream

@jack.chan Please check this…This can be thrown when the size is huge as well And also there is a per page pixel limit which might be exceeded as well. if you are getting the same exception multiple times …then try checking with lesser pages .That would give you an idea on the limit… If it occurred only once there might be some connection issues cheers

This solution provided by @Anil_G received 1 likes!

How to get numbers in correct format

Hi @mohamedalthaf Please check this cheers

This solution provided by @Anil_G received 1 likes!

Repeated files when using ForEachFileX activity

@camilacalderon I guess Include sub folders is checked both in foreachFolderX and in foreachfileX which makes each folder traverse twice…Please uncheck Include subfolders in FOreachFolderx loop and if you need check it only in the FOrEachFileX that way each folder is traversed only once [image] This the case where multiple files are coming cheers

---

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

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

[system]

Daily Forum Report | 14 December 2022

Top 3 Topics with Most Views

Get all against unique value in row made by @sshitol with 41 views.

How to get Specific value using Matches activity? made by @Vaishnav_Tej with 38 views.

How to automate Captcha made by @Sankaraveni_M with 38 views.

Top 3 Topics with Most Replies

Each excel row activity made by @Nur_Amin with 18 replies.

OmniPage package error: made by @krishna_priya with 17 replies.

Get all against unique value in row made by @sshitol with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 81 posts!

@Yoichi made 41 posts!

@Gokul001 made 29 posts!

Top 3 Most Liked Posts

This post made by @Gokul_Jayakumar received 2 likes!

How to get Specific value using Matches activity?

Dowload the packages from manage packages UiPath.pdf.activities [image]

This post made by @Anil_G received 2 likes!

Is this available to automate this kind of workflow?

Hi @pprin001 Yes it is possible You can use table extraction to extract all the data as is from the website into a datatable Read the excel data into another datatble Run a loop on website datatable(dtweb)(in arguments assign index variable) Check if the index < dtexcel.rowcount-1 On then side check if data is present in excel daatatable by using if condition to check currentrow(0).tostring.trim.equals(dtexcel.rows(index).tostring this condition is for checking first column similarly you can…

This post made by @Anshdeep_Tyagi received 1 likes!

Activity Creator with .NET 6 Support is now released

Hi @mdiv Thankyou it is working fine now.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Is this available to automate this kind of workflow?

Hi @pprin001 Yes it is possible You can use table extraction to extract all the data as is from the website into a datatable Read the excel data into another datatble Run a loop on website datatable(dtweb)(in arguments assign index variable) Check if the index < dtexcel.rowcount-1 On then side check if data is present in excel daatatable by using if condition to check currentrow(0).tostring.trim.equals(dtexcel.rows(index).tostring this condition is for checking first column similarly you can…

This solution provided by @Gokul_Jayakumar received 1 likes!

How to get Specific value using Matches activity?

Hello @Vaishnav_Tej Based on your input, we need to frame the regex condition. The document also should be in the desired format. For Regex need, share your input and expected output, it help us to provide you a better solution Kindly refer to this link, it may help you

This solution provided by @Anil_G received 1 likes!

Convert Word Files into PDFs without using Word Application Scope

Hi @DarDarSara Try using this [image] Dim MyApp As New Microsoft.Office.Interop.Word.Application MyApp.Visible = False Dim MyDoc As Microsoft.Office.Interop.Word.Document = MyApp.Documents.Open(InputFile.ToString) Mydoc.SaveAs(OutputFile.ToString, Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatPDF) Mydoc.Close(Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges) MyApp.Quit() If you have all the word docs in Same folder and the destination filename is same as source filena…

---

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

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

[system]

Daily Forum Report | 15 December 2022

Top 3 Topics with Most Views

How to file type made by @manoj_verma1 with 48 views.

Scarping data from table made by @Shubham_Bidwai with 43 views.

No xaml files available when extracting from the nupkg package made by @Karthikeyan_CS with 41 views.

Top 3 Topics with Most Replies

Scarping data from table made by @Shubham_Bidwai with 24 replies.

ERROR HRESULT: 0x800700c1. open java application made by @Aguirre with 22 replies.

How to file type made by @manoj_verma1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@sangeethaneelavannan1 made 36 posts!

@Gokul001 made 33 posts!

Top 3 Most Liked Posts

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

UiPath is launching a new initiative: UiPath Digital Credentials

Saw many badges on LinkedIn and it looks awesome, another great initiative done!

This post made by @Anca_Bolca received 1 likes!

Definition & Execution of Business Rules for Fields (mandatory, possible values & fixed format rules)

Hello @sharon.palawandram Next to the search box you have a filter icon and from what I notice the “Include Prerelease” is not selected for you. Once you tick that filter you should be able to see and use our preview packages

This post made by @KavinduPerera received 1 likes!

UiPath Dev Dives - 2023 webinar series for developers

Cheers Very Excited to Join

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 1 likes!

Converting Word File To PDF without using Word Application Scope

Hi @chilled_lad , Only those two option is there to convert word to pdf. you can create custom activity also but again the same code you are going to use to convert the word to pdf file. Regards, Arivu

This solution provided by @arivu96 received 1 likes!

How to find/match specific values in notepad?

Hi @Muralikrishna_Surve , Please use below xaml to extract the value. MultiplefilesRegex.xaml (7.6 KB) [image] Regards, Arivu

This solution provided by @Yoichi received 1 likes!

DTの集約について（任意の列の文字列が一致する行の合計）

こんにちは 空欄を0扱いにしてよいなら dt.AsEnumerable.GroupBy(Function(r) r("果物").ToString()).Select(Function(g) dt.Clone.LoadDataRow({cobj(g.Key)}.Concat(dt.Columns.Cast(Of DataColumn).Skip(1).Select(Function(dc) cobj(g.Sum(Function(r) if(Int32.TryParse(r(dc.ColumnName).ToString, new int32),CInt(r(dc.ColumnName).ToString),0))))).ToArray,False)).CopyToDataTable() になります。ただし上記はシート上０と表示されます。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 | 16 December 2022

Top 3 Topics with Most Views

Plz check screen shot made by @Shubham_Bidwai with 46 views.

Uipath Studio is not opening made by @Vaishnav_Tej with 43 views.

Bulk Add Queue Items - squares the number of Queue items made by @Sisay_Dinku with 39 views.

Top 3 Topics with Most Replies

How to mail the scraping data through SMTP made by @Shubham_Bidwai with 19 replies.

Plz check screen shot made by @Shubham_Bidwai with 18 replies.

Getting the Error for a null value for drive item made by @Kunal_Jain with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 51 posts!

@Yoichi made 39 posts!

@Rahul_Unnikrishnan made 35 posts!

Top 3 Most Liked Posts

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

Check App State and Statements to retry

actually if you simply want to retry this click activity if it fails you dont have to do all that simply do this enable verify result in click activity [image] indicate verification target, this is the element robot needs to see to verify that the click is successful, in your case you can select a button you see after login is successful [image] change the properties so that retry = True and timeout = “3” meaning if robot doesnt see verification target in 3 seconds, it will retry …

This post made by @TheSupremeRobot received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Brand new Robo Jurney starts here. I am so excited to grow and solve problems without human touch. The future waits for all of us.

This post made by @Gokul_Jayakumar received 1 likes!

DateTime.now command help

Hello @Povilas_Jonikas ., Try this DateTime.Now.Adddays(-3).ToString(“yyyy.MM.dd”)

Top 3 Most Liked Solutions

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

Check App State and Statements to retry

actually if you simply want to retry this click activity if it fails you dont have to do all that simply do this enable verify result in click activity [image] indicate verification target, this is the element robot needs to see to verify that the click is successful, in your case you can select a button you see after login is successful [image] change the properties so that retry = True and timeout = “3” meaning if robot doesnt see verification target in 3 seconds, it will retry …

This solution provided by @Gokul001 received 1 likes!

DateTime.now command help

Hi @Povilas_Jonikas Try this expression DateTime.Now.AddDays(-3).ToString("yyyy.MM.dd") Regards Gokul

This solution provided by @postwick received 1 likes!

Command to connect Robot to Orchestrator

No. You’re configuring a setting. The setting stays configured.

---

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

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

[system]

Daily Forum Report | 17 December 2022

Top 3 Topics with Most Views

Anyway to find out made by @manoj_verma1 with 38 views.

Try Catch and Debug mode made by @philwaller with 37 views.

Unattended SAP Process - Hotkey in background made by @moon_amlet with 32 views.

Top 3 Topics with Most Replies

SharePoint issu made by @Cuberoot with 9 replies.

How to enable or create Unattend robot made by @BNK with 9 replies.

LINQ expression for Data Table agregation made by @SONYC with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@Rahul_Unnikrishnan made 9 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 12 likes!

Yoichi 3000th Solution Flag Celebration

@Yoichi Congratulations on reaching the 3000th Solution Flag. We would like to say thank you for your valuable work and support. Especially we would like to mention your help with the migration from Legacy to Windows Target framework. Let’s celebrate this milestone together

This post made by @Yoichi received 5 likes!

Yoichi 3000th Solution Flag Celebration

@ppr @jeevith @kirankumar.mahanthi1 Thank you for your kind messages. I’m happy to be able to contribute some my activities to this great community. As UiPath is one of the rapid evolving platform, collective knowledge by the community is important more and more, I think. Let’s keep to do our best. Best regards, Yoichi

This post made by @jeevith received 4 likes!

Yoichi 3000th Solution Flag Celebration

Thank you @Yoichi for your dedication and efforts. We learn a lot from your answers. We wish you good health and continued success. Thank you @ppr for the thread

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Anyway to find out

Hi, Can you try the following sample? [image] Jo("Store")(0)("enduser").Count OR ja = CType(Jo("Store")(0)("enduser"),JArray) Then ja.Count Sample20221215-6v4.zip (3.4 KB) Regards,

This solution provided by @Anil_G received 1 likes!

How to merge the duplicate values and unique values of same duplicate no

@smarthari1997 In place of x("Date").ToString() please use x("Date").ToString.Trim.Split({" "},stringsplitoptions.RemoveEmptyEntries)(0) Cheers

This solution provided by @Anil_G received 1 likes!

Compilation Error in Studio

Hi @tilarapiyush It typically is a corrupted project file…it gets recreated if removed… so i asked you to rename so that you have a backup (project.json.old)…you can delete it now… project.json is enough now…this is what you need Hope this helps Cheers

---

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

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

[system]

Daily Forum Report | 18 December 2022

Top 3 Topics with Most Views

Uipath not open made by @Ma_athir_AL-Saidi with 33 views.

Use For Each Row made by @anmita with 32 views.

Search Complete Data table and get first Column Data made by @CGhoST with 31 views.

Top 3 Topics with Most Replies

Excel and word files are not working made by @Ravi_Rawal with 14 replies.

Googledriveにあるファイルのループ処理 made by @r-takagi with 13 replies.

Word Application Scope: Error opening document, make sure Word application is installed. If already installed made by @Ravi_Rawal with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@Rahul_Unnikrishnan made 8 posts!

@Ravi_Rawal made 5 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 3 likes!

Yoichi 3000th Solution Flag Celebration

Congratulations @Yoichi , You are a true inspiration to all the community members. Thank you @ppr for sharing this. Thanks

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

Yoichi 3000th Solution Flag Celebration

congrats @Yoichi you are an inspiration

This post made by @Yoichi received 1 likes!

Yoichi 3000th Solution Flag Celebration

@Rahul_Unnikrishnan @loginerror @jack.chan Thank you!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

GraphQL API Query Syntax Error when using filter

@Oscar_Ram_Kalia I guess this is what is valid json…can you try this please. Escaped "(double quotes) with \(backslash) { "query": "query {recentTransactions(last: 100, filter: {createdAt_gte: \"2022 - 12 - 12 T00: 00: 00\"}) {edges {node {createdAt transactionHeader {postedDate transactionNumber}text account {code}amount}}}}" } cheers

---

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

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

[system]

Daily Forum Report | 19 December 2022

Top 3 Topics with Most Views

How to save the extracted dynamic match values into excel sheet made by @_Bhagyashree with 56 views.

Error When Writing Directory.GetFiles in Assign Activity 'Directory' is ambiguous, imported from the namespaces or types 'System.IO, Microsoft.Graph' made by @hb61 with 42 views.

For Each: Specified cast is not valid. While using For Each made by @zaid.ahmad with 42 views.

Top 3 Topics with Most Replies

How to save the extracted dynamic match values into excel sheet made by @_Bhagyashree with 31 replies.

For Each: Specified cast is not valid. While using For Each made by @zaid.ahmad with 27 replies.

Check string to see if it DOES NOT start with "x" Check string to see if it DOES NOT start with "x" made by @nmjvk with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 49 posts!

@sangeethaneelavannan1 made 36 posts!

@Gokul001 made 23 posts!

Top 3 Most Liked Posts

This post made by @Daniel_Caldararu received 2 likes!

Invoke PowerShell with ActiveDirectory module not working

I’ve checked again. Sorry. The first one I’ve put the script under quotation marks. My bad. I’ve ran it again and surprise. It works! Can’t believe after massively googling this issue and a lot of people complaining finally found a solution. It’s a bit disappointing that in order to get the same result as in Windows Legacy where you just input the powershell command, here you need to input additional steps to make it work. Maybe this issue can go to development team to understand it and make i…

This post made by @Yoichi received 1 likes!

Yoichi 3000th Solution Flag Celebration

@ShumpeiWatanabe ありがとうございます！

This post made by @ptrobot received 1 likes!

Invoke PowerShell with ActiveDirectory module not working

Ok, that’s strange. Have you tested to add “Set-ExecutionPolicy” to your ps1-file? E.g. test1.ps4: Set-ExecutionPolicy Unrestricted -Scope CurrentUser get-ADUser -filter {employeeid -eq 0000} -Properties * | select employeeid, mail | Export-Csv C:\Test\output.csv -NoTypeInformation

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Orchestrator scheduling working inappropriately

@Riya_Bansal Give only one machine to it…then the second job will wait for the first one to complete and then start. And debug time is more than execution time from orchestrator…but while running feom orchestrator it takes some time for login to machine as well And what do you mean two broswers…botht he bots wont run at the same time on same machine unless it is a background job Cheers

This solution provided by @Sudharsan_Ka received 1 likes!

Orchestrator Scenario Based Concept

Hi @Harsha_S1 We can able to do that . We can able to start the attended robot from only Assistant. Regards Sudharsan

This solution provided by @ppr received 1 likes!

Substring manipulation of path

One of many options: [grafik] new DirectoryInfo(YourFolderPathVar).Parent.Parent.FullName

---

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

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

[system]

Daily Forum Report | 20 December 2022

Top 3 Topics with Most Views

Add a manipulated datatable to a dataset made by @sharon.palawandram with 56 views.

UiPath Perth EOY Customer Connect made by @Andrew_Rosson with 48 views.

Check every column in data table if a cell contains letters made by @nmjvk with 45 views.

Top 3 Topics with Most Replies

After table extraction and send through gamil made by @Shubham_Bidwai with 34 replies.

How to check if the filename is same on the other filename in the other folder? made by @fniedez with 27 replies.

Check every column in data table if a cell contains letters made by @nmjvk with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Rahul_Unnikrishnan made 34 posts!

@Shubham_Bidwai made 28 posts!

Top 3 Most Liked Posts

This post made by @VanjaV received 2 likes!

UiPath Windows based - write line item(0).toString

Thank you very much: @Gokul001 / @Anil_G / @Yoichi / @Rahul_Unnikrishnan it is working both ways: [image] Kind Regards, Vanja

This post made by @Supercastor received 1 likes!

How to use a nupkg file in my Studio project ?

Test : If I create a Windows-Legacy project, then I see all packages from the marketplace and local repo. Many Thanks Hiba, you pointed out the reason. Best regards

This post made by @xoduzen received 1 likes!

Delete Duplicate Rows that and keeping the row with the newest date

Hello There, You can try adjusting the following. It worked for me. dtRaw.AsEnumerable.GroupBy(Function(r) r(“Name”).ToString).Select(Function(g) g.OrderBy(Function(r) DateTime.ParseExact(r(“Date”).ToString, “MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture )).Last).CopyToDataTable() Best, Ozzy

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

UiPath Windows based - write line item(0).toString

HI @VanjaV have you tried like this row("Column name").tostring Regards Gokul

This solution provided by @Yoichi received 1 likes!

ファイルが破損している、ファイルが既に別のプロセスで使用されている、またはファイルを開く権限がない。

こんにちは Excelアプリケーションスコープはプロセスの制御が下手なので、可能であれば モダンエクセルのエクセルプロセススコープをループの外側において、 ループの内側、エクセルアプリケーションスコープの代わりに エクセルファイルを使用アクティビティを使う方が良いかと思います。 なお実行までにexcelのゾンビプロセスがいるかもしれませんので タスクマネージャーの詳細画面から不要なexcelを削除する（あるいはOSの再起動）等を しておいた方が良いかもしれません。

This solution provided by @Yoichi received 1 likes!

Add a manipulated datatable to a dataset

Hi, in this case, we need to use InvokeMethod activity as the following. [image] Can you try this? Regards,

---

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

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

[system]

Daily Forum Report | 21 December 2022

Top 3 Topics with Most Views

Give me list of all activities in uipath made by @Vajrang with 100 views.

How does StudioX treat files added to a folder during execution of its "For each file in a folder" made by @murray.trim with 47 views.

Issue with datarow adding made by @Learner007 with 47 views.

Top 3 Topics with Most Replies

Give me list of all activities in uipath made by @Vajrang with 74 replies.

Issue with datarow adding made by @Learner007 with 22 replies.

Not able to run process using orchestrator made by @RAKESH_KUMAR_Tiwari with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Kaviyarasu_N made 36 posts!

@sangeethaneelavannan1 made 29 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 2 likes!

DATTABLE / EXCEL Add column with value

Hi @Manikandasamy To add a new column in an Excel file using UiPath, you can use the Add Data Column activity. Here’s an example of how to use this activity: First, drag and drop the Add Data Column activity from the Activities panel onto the Designer panel. Next, specify the input for the activity by setting the properties in the Properties panel. In the DataTable property, specify the data table that you want to add the new column to. In the ColumnName property, specify the name of the ne…

This post made by @AhmedEmad2024 received 1 likes!

Yoichi 3000th Solution Flag Celebration

Congratulations @Yoichi I wish you more and more .

This post made by @Kaviyarasu_N received 1 likes!

PNG to TIFF image converting

Hi @Jerry1 Drag and drop the “Save Image” activity into the designer panel. In the “InputImage” field, specify the file path and name of the PNG image that you want to convert. For example, “C:\Images\Input.png” In the “OutputImage” field, specify the file path and name of the TIFF image that you want to create. For example, “C:\Images\Output.tiff” Run the workflow and the PNG image will be converted to TIFF and saved at the specified location.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to initialize array of Datatables

Hi, How about DataSet and DataTableCollection class? We can iterate multiple DataTables as the following. [image] Sample20221221-2aL.zip (3.0 KB) Regards,

This solution provided by @Sudharsan_Ka received 1 likes!

How to avoid alphanumeric and pick only numeric using regex

HI @Raja.G Checkout this expression System.Text.Regex.RegularExpression.Match(YourString,"(?<=\S\s)\d+(?=\s\S)").Tostring [image] Regards Sudharsan

This solution provided by @Kaviyarasu_N received 1 likes!

SharePoint Upload file Size - Office 365 Activities

Hi @AdityaVN There is a file size limit for uploading files to SharePoint using the O365 activities in UiPath. The maximum file size that can be uploaded to SharePoint using the O365 activities is 15 GB. If you are trying to upload a file that is larger than 15 GB, you will need to use a different method to upload the file. If you are experiencing timeouts when uploading files to SharePoint using the O365 activities, there could be a few reasons for this. Here are some things you can try to t…

---

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.