Forum Engagement Daily Reports

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

Reading text file (part:bottom)

Hi This loop takes lines from bootom to top: [Capture]

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.

How to check titles existing in first name variable 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.

[system]

Daily Forum Report | 09 November 2022

Top 3 Topics with Most Views

How to extract required data from text file which has duplicate values? made by @Reddy_1 with 45 views.

How to implement if condition in this activity? made by @wally.cariaga with 44 views.

Type Into or Set Text for Calender are not working? what is the solution made by @taruna.mehra with 39 views.

Top 3 Topics with Most Replies

How to implement if condition in this activity? made by @wally.cariaga with 40 replies.

Try Catch a miss "click activity" made by @hubert_leleu with 22 replies.

Type Into or Set Text for Calender are not working? what is the solution made by @taruna.mehra with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 104 posts!

@Gokul001 made 77 posts!

@postwick made 29 posts!

Top 3 Most Liked Posts

This post made by @loredana_ifrim received 2 likes!

Join Automation Education Summit 2022

It’s time for Automation Education Summit 2022 UiPath Community, in partnership with our Academic Alliance team, are happy to announce the launch of Automation Education Summit 2022, where we will gather educators and trainers from our academic alliances and partners, with the intention to develop them further as a robust community of educators in automation. Here are the details of the Summit: Date: 16-18 Nov Region: AMER - EMEA - APJ …

This post made by @Marek_Szwarczewski received 2 likes!

Invoke Workflow error after migartion from Windows_Legacy to Windows

Thank you @Yoichi ! It is worked. I will never think about edit the xaml file in text editor. I need increase my search skills as I didn’t find the topic you show me. Thank again!

This post made by @MinalGupta received 1 likes!

Document Understanding Process 22.10 now in General Availability!

@Steven_McKeering … You will still need to buy AI units. DU Framework is more like REFramework , buts its a standard framework to implement DU use cases.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Unable to use click after reusability component

Hi @Mohamed_Haseeb This is the activity create a variable for out element just go to out element and click ctrl+k and write the variable name [image] Assign hat variable to a output argument. you can create arguments from arguments at the bottom. assign out to it [image] happy Automation.

This solution provided by @Yoichi received 1 likes!

Invoke Workflow error after migartion from Windows_Legacy to Windows

Hi, We need to modify xaml file to remove key duplicate VisualBasicValue`1_1 using text editor. Please see the following post in details. Regards,

This solution provided by @William_Blech_Sister received 1 likes!

Workflow Name

Hello @Nath_Abrao , welcome to the UiPath Community!! You can try two ways: Use this custom package: Alphabet Workflow Activities - RPA Component | UiPath Marketplace Try the workflow activities You can also log the start and the end of the workflow with this option in the Invoke Workflow Activity [image] Any questions please let me know

---

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

Top 3 Topics with Most Views

StudioXで変数の型変換 made by @11159 with 40 views.

Background process: Is it possible to refresh an excel worksheet table that is connected to sharepoint? made by @davidgoderre with 39 views.

How do I identify duplicate values in an Excel column? made by @jijorhohim98 with 38 views.

Top 3 Topics with Most Replies

How to click button based on text matching in list made by @vnsatyasunil with 31 replies.

Illegal characters in path in write range activity made by @naveenkumarr with 24 replies.

In csv file there are some missing data of employee in that i have to paste the header in the place of blank data made by @purvika_jethwa with 23 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 106 posts!

@Anil_G made 103 posts!

@sangeethaneelavannan1 made 33 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 2 likes!

FilePath

HI @zhasmina.dimitrova Updated the expression to get the excel files also inside the folder Directory.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder.UserProfile)+"\Downloads\","*.xlsx") Regards Gokul

This post made by @Anil_G received 2 likes!

Illegal characters in path in write range activity

Hi @naveenkumarr Did you give double quotes in your asset? If yes then that is the issue. You should not give…Directly give the path cheers

This post made by @Gokul001 received 2 likes!

What is the filter expression for get exchange mails

Hi @sathish_Kumar6 For Date check out this expression DateTime.ParseExact(StringInput.ToString,"ddd, dd MMM yyy HH:mm:ss K",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy hh:mm:ss") [image] Check out the tutorial Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Illegal characters in path in write range activity

Hi @naveenkumarr Did you give double quotes in your asset? If yes then that is the issue. You should not give…Directly give the path cheers

This solution provided by @ppr received 2 likes!

Delete items from a list

[grafik] List1Var.Except(ArrayVar2).toList

This solution provided by @Gokul001 received 1 likes!

UIDemo.exe username password

HI @Akbar_Badhusa The username is admin and password is password. 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 | 11 November 2022

Top 3 Topics with Most Views

Read PDF FILE and get text made by @Kuldeep_Pandey with 47 views.

How can i compare two excel files? made by @aparna30 with 43 views.

How to get the numer out of this picture made by @alirida.alhalass with 38 views.

Top 3 Topics with Most Replies

Read PDF FILE and get text made by @Kuldeep_Pandey with 24 replies.

[StudioX]から[Studio]へのプロファイル切り替え方法 made by @yuai with 19 replies.

How to filter duplicate emails made by @Milo_Soderberg with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 82 posts!

@Anil_G made 53 posts!

@Yoichi made 48 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Insert a character in a string

Hi, Can you try the following expression? Double.Parse(yourString).ToString("#.00") [image] Regards,

This post made by @Yoichi received 2 likes!

File missing in nuget file after publish

HI, The above image shows RestSharp106.6.10 or higher is missing. Unfortunately, in some version of UiPath installer lacks necessary RestSharp package in the installer. So we need to add it and its dependcies package to Orchestrator or machine which robot works. Or as another lazy approach, if it works dev environment, can you try to copy all the folders %USERPROFILE%.nuget\packages to same place of machine which robot works. Regards,

This post made by @Tejaa received 1 likes!

Monthly Forum rewards - October 2022

Congratulations all! Filled out the form, don’t think I am eligible for the certification discount voucher but still would love to receive one. Even for the associate exam.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Insert a character in a string

Hi, Can you try the following expression? Double.Parse(yourString).ToString("#.00") [image] Regards,

This solution provided by @Yoichi received 1 likes!

Execute an action if len of a string in browser is more than 1

Hi, I think we can use GetText activity with proper selector. Probably we can use colName attribute. So can you try to use UiExplorer then indicate target cell? Or, as another approach, it’s also good to use DataScraping. Regards,

This solution provided by @Yoichi received 1 likes!

How to split excel row

HI, Hope the following sample helps you. LINQ case [image] dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r("Employee ID").ToString,System.Text.RegularExpressions.Regex.Match(r("Employee ID").ToString,"\S+$").Value},False)).CopyToDataTable() ForEachRow case [image] System.Text.RegularExpressions.Regex.Match(CurrentRow("Employee ID").ToString,"\S+$").Value Sample20221111-3.zip (10.4 KB) Regards,

---

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

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

[system]

Daily Forum Report | 12 November 2022

Top 3 Topics with Most Views

Could not start executor. The referenced account is currently locked out and may not be logged on to. (0x80070775) made by @jrp with 28 views.

Set of Rules required for Workflow Analyzer made by @Akhil_Raveendran with 27 views.

How to proceed further if there are 3 possible result for one action? made by @Karthikeyan_CS with 27 views.

Top 3 Topics with Most Replies

Could not start executor. The referenced account is currently locked out and may not be logged on to. (0x80070775) made by @jrp with 13 replies.

Choosing a date from a calendar by reading an image made by @Ilan_Edri with 5 replies.

Selecting Items in a List of a special application named "OKNA2000" made by @Dominic_Roggen with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@MHarakeh made 10 posts!

@jrp made 6 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

How to merge three data tables?

Hi, I think ForEach mitigates your problem. How about the following? [image] OR the following LINQ expression might help you. dtResult = {dt1,dt2,dt3}.SelectMany(Function(d) d.AsEnumerable.Select(Function(r) d.Clone.LoadDataRow({r(0)},False))).CopyToDataTable() Regards,

This post made by @Anil_G received 1 likes!

How to get item.Headers.Item("In-Reply-To").ToString in get mail Microsoft 365

Hi @sathish_Kumar6 So …you want to know if a message is replied or not… there is no direct way but you can try this… from get mails once you get your inbox …and getting the mail you can get the unique id of the mail and then use get mail from sent items and then match the id for this your in-reply-to in header will help to match.thats not straight but give it a try Cheers

This post made by @Sudharsan_Ka received 1 likes!

別プロセスからプレビューを保持したままのコピペ方法

Hi @yuai If you need the image you can see those in the folder .screenshots so while you copy the activities from one workflow to another you can copy the screenshots in the .screenshots folder too to the new project after copying them to new flow click on refresh button in the project panel and then you can see the screenshots in new project too Note : the thing is 1 you need to copy the whole screenshots of one project to another because you don’t know what is screenshot name assigned to th…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to merge three data tables?

Hi, I think ForEach mitigates your problem. How about the following? [image] OR the following LINQ expression might help you. dtResult = {dt1,dt2,dt3}.SelectMany(Function(d) d.AsEnumerable.Select(Function(r) d.Clone.LoadDataRow({r(0)},False))).CopyToDataTable() Regards,

This solution provided by @cheez_RPA received 1 likes!

別プロセスからプレビューを保持したままのコピペ方法

元のワークフローが含まれるプロジェクトフォルダにある .screenshots フォルダを、そのまま貼り付け先のワークフローが含まれるプロジェクトフォルダに上書きしてください。 補足すると、アクティビティに表示されているプレビューは、アクティビティ自体に保存されているわけではなく、そのワークフローが保存されているプロジェクトの .screenshots フォルダに保存されており、アクティビティはそのフォルダにある画像を、画像のファイル名を指定して読み込むようになっています。 そのため、アクティビティのみをコピー・貼り付けした場合は画像が移動されていないため、プレビューが利用できないということになります。

---

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

Top 3 Topics with Most Views

Donwload files from AP made by @ALI_TONGA with 33 views.

Data Table type into google form made by @Allyson_Ang with 31 views.

Phần mềm hack tài xỉu vốn 10tr húp 136tr made by @manhduc_hoang with 30 views.

Top 3 Topics with Most Replies

Add timestamp and then file extension (xlsx) to a file and move to the archive Folder made by @Sisay_Dinku with 13 replies.

Data Table type into google form made by @Allyson_Ang with 12 replies.

ワークフローTOPレベルのフローチャートの周りのシーケンスが削除できない made by @gorby with 8 replies.

Top 3 Users Who Posted The Most

@sangeethaneelavannan1 made 14 posts!

@Yoichi made 11 posts!

@Sisay_Dinku made 9 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 2 likes!

Loop all the Excel Sheet and Process

Hello @jaffer_sadiq You can use the below acitivty. For Each Excel Sheet [image] Thanks

This post made by @sangeethaneelavannan1 received 2 likes!

Loop all the Excel Sheet and Process

@jaffer_sadiq ,You could use for each excel sheet activity to read each excel sheet in workbook

This post made by @arivu96 received 1 likes!

Monthly Forum rewards - October 2022

Congratulations to all the winners

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to use group by and if activities together with linq?

Hi, Can you try the following expression? [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("MailUID").ToString()).SelectMany(Function(g) g.Where(Function(r,i) r("Status").ToString.Trim<>"Success" OrElse (i=0 AndAlso g.All(Function(r2) r2("Status").ToString.Trim="Success")))).CopyToDataTable() Sample220221113-2L.zip (2.9 KB) Regards,

This solution provided by @private_matter received 1 likes!

Cannot indicate button elements with strict selector

@Anil_G That still won’t work because checking the pending state will also need an identifier as there could be several pending buttons before which case we are looping through the exact same issue of the connect button. But forget it as I’ve come up with a clever solution that will solve both issues, whether the connect button disappears or does not disappear. What needs to be done is to use an idx=‘default variable(1)’, and upon clicking on the send button, I’ll add a check app state to chec…

---

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

Top 3 Topics with Most Views

Trouble in Append Range made by @Kelvin1 with 37 views.

Could not start executor made by @Ranganathan_M with 37 views.

パッケージを管理に「UiPath.SAP.BAPI.Activities.2.2.5」が表示されない made by @hiromi.akita with 36 views.

Top 3 Topics with Most Replies

Trouble in Append Range made by @Kelvin1 with 25 replies.

Creating folder made by @Kuldeep_Pandey with 22 replies.

Unable to allocate developer license to tenant made by @venkat4u with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 96 posts!

@Yoichi made 41 posts!

@Anil_G made 36 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 2 likes!

Adding only the last 5 rows of datatable to queue

Hi @idil.konca Before writing into the Output value, You keep the column name has a template and append the output value in that excel. After that use LINQ expression to take last 5 record from the excel. Regards Gokul

This post made by @GT_Ropa received 2 likes!

Unable to allocate developer license to tenant

When working with more than one tenant and allocating licenses you will see all of the licenses available for allocation. If there is zero, it will simply say that zero licenses are available: [image]

This post made by @ppr received 2 likes!

Regex expression for a String

to complete the series: [grafik] as * means 0 or unlimited it will also match CHG without numbers

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Adding only the last 5 rows of datatable to queue

Hi @idil.konca Before writing into the Output value, You keep the column name has a template and append the output value in that excel. After that use LINQ expression to take last 5 record from the excel. Regards Gokul

This solution provided by @ppr received 2 likes!

Regex expression for a String

to complete the series: [grafik] as * means 0 or unlimited it will also match CHG without numbers

This solution provided by @Gokul001 received 1 likes!

How to grouping data in excel and generate new file by each group?

Hi @lovepong66 How about this expression (From d In DtBuild.AsEnumerable Group d By k=d("code").toString.Trim Into grp = Group Let ra = New Object(){k,grp.First()(1),grp.First()(2)} Select r = DtClone.Rows.Add(ra)).CopyToDataTable Check out the XAML file GroupGeneratedExcelfiles.xaml (12.5 KB) [image] Note : Kindly update the Column Names 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 | 15 November 2022

Top 3 Topics with Most Views

How to calculate a particular datacolumn sum using datatable or structured format? made by @Vidhi_Patel with 52 views.

Re-Run program if any error made by @Kelvin1 with 44 views.

I want to apply regex exp made by @Kuldeep_Pandey with 36 views.

Top 3 Topics with Most Replies

I want to apply regex exp made by @Kuldeep_Pandey with 28 replies.

Error while deploying a package in orchestrator made by @Cuberoot with 22 replies.

How to calculate a particular datacolumn sum using datatable or structured format? made by @Vidhi_Patel with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 117 posts!

@Gokul001 made 98 posts!

@sangeethaneelavannan1 made 36 posts!

Top 3 Most Liked Posts

This post made by @Yushi.E received 2 likes!

"配列Aに配列Bが含まれるとき"をどう表せばいいか？

ありがとうございます！ 解決できました！

This post made by @Yoichi received 2 likes!

"配列Aに配列Bが含まれるとき"をどう表せばいいか？

こんにちは 今回は、【配列A】の中に【配列B】がすべて含まれているかどうかを判定したいと考えています。 arrC = arrB.Except(arrA).ToArray として、arrCが空（要素数が0）であれば、すべて含まれています。 arrC.Length =0

This post made by @yosuke1 received 2 likes!

繰り返し（フォルダ内の各ファイル）のアクティビティでの＊使用

皆様 無事に解決致しました！！ ありがとうございました<m(__)m> [image]

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How to get Amount and do total with from the following text?

HI @Vidhi_Patel Check Out this Updated XAML file with Sum the Amount RegexReplace.xaml (8.0 KB) [image] Regards Gokul

This solution provided by @Gokul001 received 1 likes!

How to calculate a particular datacolumn sum using datatable or structured format?

HI @Vidhi_Patel How about this expression (From d in dtData.AsEnumerable Where Not (isNothing(d(2)) OrElse String.IsNullorEmpty(d(2).toString.Trim)) Select v = CDbl(d(2).toString.Trim)).Sum(Function (x) x) Regards Gokul

This solution provided by @Yoichi received 1 likes!

Change Month format to Indonesia

HI, Can you try the following expression? Datetime.ParseExact("May 2022", "MMM yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MMM yyyy",New System.Globalization.CultureInfo("id-ID")) Regards,

---

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

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

[system]

Daily Forum Report | 16 November 2022

Top 3 Topics with Most Views

Orchestrator unable to click the unattended robot made by @g_ii with 47 views.

Is there any limit in passing values for Add DataRow activity? made by @Soundarya_Guduri with 41 views.

How to find icon in webpage and get related details? made by @Keerthana_Udayakumar with 37 views.

Top 3 Topics with Most Replies

How to move below cell row value to above cell in particular column excel made by @Raja.G with 23 replies.

Orchestrator unable to click the unattended robot made by @g_ii with 23 replies.

Get text from each column in DataTable made by @Alexander_Ward with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 53 posts!

@Anil_G made 46 posts!

@sangeethaneelavannan1 made 33 posts!

Top 3 Most Liked Posts

This post made by @Sidney_Vogel received 2 likes!

State machines VS Sequences VS Flowchart

Hi all, I have a question in regards to this UIPath DUMP question I came across on the internet. Why is the answer for this question “State Machine” instead of Sequence, as I understand State machines is for more complex automations. I would have selected Sequence as the answer. You need to collect employees data and send it by email as an Excel file. What type of workflow is the most suitable for the final part, which adds the file attachment, formats the email, and sends it? Sequence Flo…

This post made by @Vidhi_Patel received 2 likes!

How to get Amount and do total with from the following text?

Greatful for this tutorial references of tutorial and another suggested post are cool as well thanks for sharing this, Happy automation!

This post made by @postwick received 2 likes!

How to use Arguments in the Ui path studio?

You should do all the free training on the UiPath Academy site.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How can i empty data by reference by sheet name?

Hi @lovepong66 You can try with Delete Range activity In the Range try with this expression "A2:"+UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DtRead.Columns.Count)+(DtRead.Rows.Count+1).ToString Check out this XAML file DeleteRange.xaml (6.7 KB) [image] Regards Gokul

This solution provided by @tarau_bianca received 1 likes!

"An item with the same key has already been added" error on "Test Activity" action

Hi! I checked and there are no double values. But meanwhile I have found the solution! I put the activity in a sequence container and it worked. When I chose the “Test Activity” option for the whole sequence, it worked. I am not sure why, but It did. Thank you anyway for you suggestions!

This solution provided by @Gokul001 received 1 likes!

Arithmetic operation problem

HI @Shoebmd Check out this XAML file Arithmeticoperation.xaml (5.7 KB) [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 | 17 November 2022

Top 3 Topics with Most Views

Bug report: Simulate Click in Java programs doesn't finish if a modal window is shown made by @ptrobot with 38 views.

How to split one text file into multiple text files according to text content? made by @jeleona.foo with 33 views.

How to convert string to time and compare with current time? made by @lovepong66 with 32 views.

Top 3 Topics with Most Replies

How to change a sheet name in modern experience made by @Juandix with 26 replies.

How to split one text file into multiple text files according to text content? made by @jeleona.foo with 22 replies.

Type error made by @Kuldeep_Pandey with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 56 posts!

@postwick made 53 posts!

@Yoichi made 45 posts!

Top 3 Most Liked Posts

This post made by @postwick received 3 likes!

How to deal with data in excel

https://forum.uipath.com/search?q=large%20excel%20file

This post made by @sangeethaneelavannan1 received 3 likes!

How to convert multiple line string to single line string?

Try this: input = input.Replace(vbLf, “”).Replace(vbCr, “”)

This post made by @ppr received 2 likes!

How to convert string to time and compare with current time?

[grafik] Now.TimeOfDay >= Cdate("09:00").TimeOfDay And Now.TimeOfDay <= Cdate("15:30").TimeOfDay As well agreed to use Timespan as we can reduce the code chars [grafik] Now.TimeOfDay >= Timespan.Parse("09:00") And Now.TimeOfDay <= Timespan.Parse("15:30")

Top 3 Most Liked Solutions

This solution provided by @postwick received 3 likes!

How to deal with data in excel

https://forum.uipath.com/search?q=large%20excel%20file

This solution provided by @sangeethaneelavannan1 received 3 likes!

How to convert multiple line string to single line string?

Try this: input = input.Replace(vbLf, “”).Replace(vbCr, “”)

This solution provided by @ppr received 2 likes!

How to convert string to time and compare with current time?

[grafik] Now.TimeOfDay >= Cdate("09:00").TimeOfDay And Now.TimeOfDay <= Cdate("15:30").TimeOfDay As well agreed to use Timespan as we can reduce the code chars [grafik] Now.TimeOfDay >= Timespan.Parse("09:00") And Now.TimeOfDay <= Timespan.Parse("15:30")

---

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

Top 3 Topics with Most Views

Selector not available after conversion to windows made by @MateuszSzatkowski with 46 views.

Getting an error message while working with uipath made by @Rashmika_Barathan with 39 views.

Windows Legacy -> Windows: Error when compiling: Vale cannot be null. (Parameter 'key') made by @PeCour with 35 views.

Top 3 Topics with Most Replies

Orchestratorでマシンの入れ替えができない made by @jasano with 21 replies.

How to start automation made by @Nur_Amin with 19 replies.

Error getting latest file downloaded c# made by @javierdavidh with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 58 posts!

@Yoichi made 42 posts!

@Gokul001 made 28 posts!

Top 3 Most Liked Posts

This post made by @Sanjeevi received 3 likes!

Join Data Tables - Cheat Sheet

[Join DataTable]

This post made by @Yoichi received 3 likes!

Get Date of First thrusday of specific month

HI, The following expression helps you. Enumerable.Range(1,7).Select(Function(i) New DateTime(2022,2,i)).Where(Function(d) d.DayOfWeek = DayOfWeek.Thursday).Single() OR Enumerable.Range(1,7).Select(Function(i) New DateTime(2022,2,i)).Where(Function(d) d.DayOfWeek = DayOfWeek.Thursday).Single().ToString() Please modify 2022 and 2 to required year and month. Regards,

This post made by @jeevith received 3 likes!

Windows Legacy -> Windows: Error when compiling: Vale cannot be null. (Parameter 'key')

Hi @PeCour @Anil_G and @Gokul001 Windows version of projects do not look stable to me in the last two releases (2022.4.X and 2022.10.X) The error you are getting might also be that in one or other xaml file you have one of the following write to csv, read text file, write to text file, add to collection, get asset, read csv activities. These are my observations so I cannot say this is the same in your case @PeCour Many activities have been impacted. It’s a double whammy. Windows .net 6 activi…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 3 likes!

Windows Legacy -> Windows: Error when compiling: Vale cannot be null. (Parameter 'key')

Hi @PeCour @Anil_G and @Gokul001 Windows version of projects do not look stable to me in the last two releases (2022.4.X and 2022.10.X) The error you are getting might also be that in one or other xaml file you have one of the following write to csv, read text file, write to text file, add to collection, get asset, read csv activities. These are my observations so I cannot say this is the same in your case @PeCour Many activities have been impacted. It’s a double whammy. Windows .net 6 activi…

This solution provided by @Yoichi received 1 likes!

Get Date of First thrusday of specific month

Hi, Enumerable.Range(1,7) returns numbers from 1 to 7. Then, Select(Function(i) New DateTime(2022,2,i)) returns dates from 2022 Feb 1 to 2022 Feb 7 because i is applied from 1 to 7. Next, Where(Function(d) d.DayOfWeek = DayOfWeek.Thursday) filters the above dates whether Thursday. Remaining is what you need. (As return type of Where method is IEnumerable<DatatIme>, we need to extract one result using Single method.) Hope this helps you. Regards,

This solution provided by @Anil_G received 1 likes!

Unable to search text on web Ui

Hi @Riya_Bansal In your activities panel…click on filter icon on top…select show classic then you should be able to see Alternate activities for these in latest version are check app state and get text…change the scapping method…to make it work as get visible text 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 November 2022

Top 3 Topics with Most Views

How to Copy a DataTable? made by @Sanjeevi with 46 views.

Iterating radio buttons made by @philwaller with 43 views.

Open File that contains the specific name made by @lq_c with 37 views.

Top 3 Topics with Most Replies

How to Sum all the values in multiple column index using LINQ made by @Sidney_Vogel with 9 replies.

Input data given in excel need to get the total quantity made by @VB_Chel with 9 replies.

How to count variable starting from 01,02 ..... 10 and so on made by @enthusiastic with 8 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 31 posts!

@Yoichi made 18 posts!

@Rahul_Unnikrishnan made 8 posts!

Top 3 Most Liked Posts

This post made by @Sanjeevi received 2 likes!

How to Copy a DataTable?

There are two ways you can copy a DataTable with structure and data to another DataTable. You can copy a DataTable to another DataTable using Filter Data Table activity. You can add Source DataTable in the Input DataTable section and the Destination DataTable in the Filtered DataTable section. You can leave the Filter Rows and Output Columns values as it is. [Filter Data Table] You can use DataTable.Copy method in an Assign activity. [Assign Activity Copy] DataTable.Clone Method If y…

This post made by @Yoichi received 2 likes!

How to Sum all the values in multiple column index using LINQ

Hi, If you need sum value of specific column, the following help you. dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(4).ToString)) The above returns sum value of 4th column of the datatable (0-base index) Regards,

This post made by @Sidney_Vogel received 1 likes!

How to Sum all the values in multiple column index using LINQ

@Yoichi you are a genius, this worked perfectly, thank you so much for this, this is great. Is there a way to only get the value, instead of an array? I guess could add (indexnumber) at the end of the array, like this: Enumerable.Range(dt.Columns.Count-5,5).Select(Function(i) dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(i).ToString))).ToArray()(1) But is there another way to get just the individual sum of the column and not an array?

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to Sum all the values in multiple column index using LINQ

Hi, If you need sum value of specific column, the following help you. dt.AsEnumerable.Take(dt.Rows.Count-1).Sum(Function(r) Double.Parse(r(4).ToString)) The above returns sum value of 4th column of the datatable (0-base index) Regards,

This solution provided by @sangeethaneelavannan1 received 1 likes!

Is OCR of Uipath free?

@Nitiwat_Chunprapanusorn Please download the below package from manage package window and it is free [image] The UiPath Document OCR activity is optimized for usage on scanned documents and images of documents. The UiPath Screen OCR activity is optimized for the usage on-screen images.

This solution provided by @Gokul001 received 1 likes!

This message appears after I changed from Legacy to Windows compatibility

HI @Larry_Anthony_Jacobo_Zar1 Welcome to uipath community It may be the Double Quotation issue " Try to Re enter the expression again String.Join(Environment.NewLine,(From r In dt_AgrupacionAConciliar Select r.item("Nº documento"))) Check out this thread 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 | 20 November 2022

Top 3 Topics with Most Views

Uipath DataTable (Unable to get data) made by @PHS_BE with 35 views.

FInd and click text made by @Carlton_Morrissey with 33 views.

How to get exact color name of excel cell? made by @Vaishnav_Tej with 32 views.

Top 3 Topics with Most Replies

FInd and click text made by @Carlton_Morrissey with 18 replies.

How to get output as unique rows by comparing two columns using LINQ query made by @chanbhasha.p with 8 replies.

How to get exact color name of excel cell? made by @Vaishnav_Tej with 8 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 14 posts!

@Anil_G made 14 posts!

@Carlton_Morrissey made 10 posts!

Top 3 Most Liked Posts

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

Chrome migration to MV3 extension

Supported versions with Chrome MV3: 2020.10.14 + 2021.10.8 + 2022.4.4 + 2019.10.9 is out of Support completely.

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

Chrome migration to MV3 extension

The needed installer can be found here https://download.uipath.com/versions/21.10.9/UiPathStudio.msi

This post made by @Kalaisri_K received 1 likes!

Add Queue Item Activity

Thank you for your swift solution and perfectly worked.

Top 3 Most Liked Solutions

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

Chrome migration to MV3 extension

Supported versions with Chrome MV3: 2020.10.14 + 2021.10.8 + 2022.4.4 + 2019.10.9 is out of Support completely.

---

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

Top 3 Topics with Most Views

How to make uiPath program run bit fast made by @Riya_Bansal with 50 views.

How to create custom log made by @Kelvin1 with 45 views.

Simulate Type Not working In Browser made by @srinivasanma1 with 37 views.

Top 3 Topics with Most Replies

How to exclude the middle name (alphabet) and split the full name as 'First Name' and 'Last Name' on separate columns made by @Sisay_Dinku with 24 replies.

How to use regex that checks or compare the output if that words are the same in the file? made by @wally.cariaga with 17 replies.

1データの各項目を配列に追加 made by @r.nakanishi with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 94 posts!

@Yoichi made 42 posts!

@Rahul_Unnikrishnan made 15 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 2 likes!

Levenshtein distance - 가장 비슷한 텍스트 찾기

미리 정해진 텍스트 집합 안에서 주어진 텍스트와 일치하는 (또는 가장 유사한) 텍스트를 찾아야 하는 경우가 있습니다. 진료비영수증을 예로 들자면, 영수증의 항목명들을 OCR 기술로 추출한 경우 오인식/미인식이 존재하더라도 가장 유사한 항목명을 찾아야 해당 금액을 그 항목의 지출로 인식할 수 있을 겁니다. 두 텍스트의 유사도를 측정하기 위하여 Levenshtein distance를 사용할 수 있습니다. Levenshtein distance를 계산하는 원리는 이 포스팅에서 쉽게 설명하고 있으니 참고하시기 바랍니다. 한글의 경우 자소 단위로 비교하면 좀 더 세밀하게 유사도를 측정할 수 있고, 대량의 텍스트를 비교하는 경우 수행 시간을 단축하기 위하여 short-circuiting(기존의 최소 거리보다 커지면 계산을 중단함)을 도입한 python 코드를 아래에 공개해 두었습니다. Python 코드 안에 주석으로도 명시하였지만, 기본 구현은 이 포스팅을 참고하였고 short-circu…

This post made by @Gokul001 received 2 likes!

Read Range: Picture names cannot contain any of the following characters: :\/?*[]

Hi @hurmet.noka Can you try with excel application scope read range activity Regards Gokul

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

Document Understanding Process 22.10 now in General Availability!

I have wo updates to share: Regarding the Taxonomy Manager issue, if you have it, roll back to 22.10.1 - it’s an issue with Studio and a fix is actively being worked on. And yes, you need to have .net5 / 6 installed. We have also encountered a small bug in one of our arguments in Main - ActionCenter.xaml and fixed it (In_TargetFile was of type “Out” instead of “In”)

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 2 likes!

Read Range: Picture names cannot contain any of the following characters: :\/?*[]

Hi @hurmet.noka Can you try with excel application scope read range activity Regards Gokul

This solution provided by @Yoichi received 1 likes!

Delete duplicate row and original rows that duplicated

Hi, Can you try the following expression? dt.AsEnumerable.GroupBy(Function(r) r("Column A").ToString).Where(Function(g) g.Count=1).SelectMany(Function(g) g).CopyToDataTable The above check duplicated value of ColumnA. Regards,

This solution provided by @Gokul001 received 1 likes!

Activities panel unable to dock

Check out this thread @joscares 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 | 22 November 2022

Top 3 Topics with Most Views

How to input variable from input dialog into run query made by @hanungrizqi with 58 views.

System.Activities.DynamicUpdate need to add Uipath Studio(Windows) process made by @Kaviyarasu_N with 41 views.

O365 Activities - Get Mail made by @gopai with 40 views.

Top 3 Topics with Most Replies

How to input variable from input dialog into run query made by @hanungrizqi with 31 replies.

Filterdatatable convert string into Int made by @tharani.natarajan with 19 replies.

Can't convert output date from dialog box to pick automatically dates on website made by @hanungrizqi with 15 replies.

Top 3 Users Who Posted The Most

@Yoichi made 65 posts!

@Gokul001 made 49 posts!

@Anil_G made 48 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

Compare two datatables and find row index of matching data

Hi @b.forbes , I believe we could use Join Datatables Activity to get the Matched Data between the two Datatables. The Join type should be Inner Join. We could then iterate through this Output of Join Datatables Activity using a For Each Row Activity and create an index and use it for the Anchor. The above suggestion is provided based on the input statement that was given, if it does not fully satisfy your requirements, maybe you could provide more descriptive details of the process. Let us …

This post made by @Gokul_Jayakumar received 2 likes!

Compare two datatables and find row index of matching data

Hello @b.forbes You can get the Current row index by getting output from index properties as an Integer variable type. Based on current row, we can get the index in loop. [image]

This post made by @Yoichi received 2 likes!

フォルダー内の複数のCSVを取込Excelへ書き込む

こんにちは CurrentNameはファイル名しか返しませんので、相対パスとして扱われ、UiPathのプロジェクトフォルダを参照した形になります。 そのためCurrentFile.FullNameを使ってください。 その上で２の方ですが、文字コードが正しく設定されていませんので、 エンコーディングプロパティに"Shift_JIS" または”UTF-8"を設定してください（実際の文字コードに合わせてください） もしWindowsプロジェクトの場合（WIndowsレガシーではなく）エンコーディング指定の前に 一つメソッドを呼ぶ必要があるかもしれませんので、以下参照ください。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

フォルダー内の複数のCSVを取込Excelへ書き込む

こんにちは CurrentNameはファイル名しか返しませんので、相対パスとして扱われ、UiPathのプロジェクトフォルダを参照した形になります。 そのためCurrentFile.FullNameを使ってください。 その上で２の方ですが、文字コードが正しく設定されていませんので、 エンコーディングプロパティに"Shift_JIS" または”UTF-8"を設定してください（実際の文字コードに合わせてください） もしWindowsプロジェクトの場合（WIndowsレガシーではなく）エンコーディング指定の前に 一つメソッドを呼ぶ必要があるかもしれませんので、以下参照ください。

This solution provided by @jeevith received 1 likes!

UiPath Assistant (22.4) not showing string array input argument

Hi @EevaHanninen, I have not crossed checked the behaviour, but one thing I always forget is to update the package in the process within the orchestrator folder. May be this is the case? You may have updated and published the package, but could it be that the process in question is not updated to the newest package (where you have input array argument?). This way the assistant only shows you two arguments (from previous version of your package) and not three (your newest version of the package…

This solution provided by @Gokul001 received 1 likes!

Does it cause any problem to update Uipath?

HI @Peace_Maker Yes, If you need to migrate to the latest version. You have do some change inside the flow. Check out the document 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 | 23 November 2022

Top 3 Topics with Most Views

Difference result between run through orchestrator and studio made by @Kelvin1 with 45 views.

How to test the workflow on a new virtual desktop? made by @g_ii with 45 views.

Click activity fail when run from orchestrator made by @g_ii with 41 views.

Top 3 Topics with Most Replies

Click activity fail when run from orchestrator made by @g_ii with 23 replies.

Facing issues in web application made by @varunk with 16 replies.

How to match the variable value in excel sheet made by @sruthesanju with 16 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 61 posts!

@Anil_G made 54 posts!

@sangeethaneelavannan1 made 22 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to Compare two data tables with specific Column data

Hi, Can you try the following sample? [image] DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"}) Sample20221123-2aL.zip (10.6 KB) Regards,

This post made by @Jayavignesh_G received 2 likes!

How to add data row in different data table of different column using linq

@adarsh_kotagiri Datatable-> DT_1 & DT_Final and Create “Result” argument as “in/out” direction. In Total 3 Datatable will be used, DT_1 , DT_Final and Result Take Involve Code Activity, Pass the DT_1 & DT_Final argument as “in” direction. then open the Code Editor, Var query = from DT_1 in DT_1.AsEnumerable() Join DT_Final in DT_Final.AsEnumerable() on DT_1.Field(“Document Number”) equals DT_Final.Field(“Cheque.no”) select new { Date = DT_1.Field<string>("Date") …

This post made by @Jayavignesh_G received 2 likes!

Extract diffrent tables with same format per emails

@iremguner - At First Read the Outlook Mail, For Each Outlook (Apply the some filter Condition if needed) → Use HTML Content create 2.Now you may got the code of Total Body Content then Keep “Date” as Start Label and “RMK” as End Label (Hint: Use the Index Logic to find position of those label) 3.Now Write those Range value from start Label to End Label into Excel. Happy Learning !!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to Compare two data tables with specific Column data

Hi, Can you try the following sample? [image] DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"}) Sample20221123-2aL.zip (10.6 KB) Regards,

This solution provided by @Hendriyanto received 1 likes!

How to install custom activities

hello @son.dc , What is your project Version? (Windows, Legacy, or CrossPlatform), if your project compatible version is Windows, not all Costum activity is supported Cheer,

This solution provided by @Anil_G received 1 likes!

Arrived email outlook trigger

Hi @nora_ziani yes you need to configure required arguments in process and then publish it and then create integration service in orchestrator. Please check the documentation in previous post on how to create process and required arguments to get data from trigger 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 | 24 November 2022

Top 3 Topics with Most Views

How can i convert DD/MM(Months in Words) to MM/DD/YYYY format made by @sagar.raval with 42 views.

Option Strict On disallows implicit conversions from 'Object' to 'Integer' made by @Sadder with 39 views.

Unable to extract Table data which has a horizontal scroll within a webpage made by @David_Bekky with 33 views.

Top 3 Topics with Most Replies

Option Strict On disallows implicit conversions from 'Object' to 'Integer' made by @Sadder with 23 replies.

365 SharePoint made by @Ahmad_Rais with 17 replies.

How can i convert DD/MM(Months in Words) to MM/DD/YYYY format made by @sagar.raval with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 67 posts!

@Gokul001 made 63 posts!

@Yoichi made 27 posts!

Top 3 Most Liked Posts

This post made by @VirajN received 2 likes!

Monthly Forum rewards - October 2022

Congratulations @Gokul001 @Sudharsan_Ka @Yoichi and all others. Thank you all for making our lives easier with your contributions.

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

Alternate to Element Exists property?

Hi @Sami_Rajput , The Check App State (Modern Activity) works quite well in scenarios like these. It allows you to wait for an element to either appear or disappear: [image] If the element is present or disappears, it won’t wait 30 seconds - it moves on with the execution. Could you give that a try and let us know if it works out for you? Kind Regards, Ashwin A.K

This post made by @Manoj_sreekanth received 2 likes!

CLick image not working: Windows application(Studio)

thank you so much , i have almost followed the steps mentioned and it has worked for me. regards, Manoj

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Convert string to datetime error

Hi, FYI, another approach: [image] (CDate(Now.ToString("yyyy/MM/dd ")+yourString.Trim)-Now).ToString Regards,

This solution provided by @Gokul001 received 2 likes!

Uipath Studio Community Edition is Always free?

HI @ashwini.mali Check out the video link and document [Download & Install UiPath Community Edition | UiPath Tutorial For Beginners | Class 03] [2022 Latest UiPath Download Install Sign In and Connect to Orchestrator] Regards Gokul

This solution provided by @Gokul001 received 1 likes!

How can i take only the files of today in a ForeEachFile Activity loop

Hi @Imene_ZARAI You can if activity inside the For each file in folder activity Use this condition New System.IO.FileInfo(CurrentFile.ToString).CreationTime.ToString("dd.MM.yyyy") = DateTime.Now.ToString("dd.MM.yyyy") Can you check out the XAML file TodaysFileINFolder.xaml (7.7 KB) [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 | 25 November 2022

Top 3 Topics with Most Views

LINQ Query Troubleshooting made by @Mahii with 38 views.

Robot auto closed after a few second made by @mzbar with 37 views.

When we use And, Andalso, or, orelse made by @Kelvin1 with 36 views.

Top 3 Topics with Most Replies

Is there a way to extract the account no values(excluding special characters that are not numeric or alphabets)? made by @Justine with 20 replies.

Uipath studio enterprise edition made by @vivekktr with 16 replies.

Key not present in dictionary made by @Cuberoot with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Yoichi made 52 posts!

@Gokul001 made 40 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Convert all dictionary values which has array as datatype to List

A shortened one: [grafik] [grafik]

This post made by @Rafal_Walicki received 2 likes!

KSeF e-invoicing in Poland - new custom activities package

Hello UiPath community! Office Samurai team would like to announce: The package containing activities that provide integration between UiPath and Polish e-invoicing system KSeF (Krajowy System e-Faktur) is now available and ready to use: Key functionalities that simplify interactions with this system: Providing a choice for the user between all types of environments: Test, Demo and Prod. Establishing an interactive session using previously generated secret token. Sending invoices i…

This post made by @supermanPunch received 2 likes!

Convert all dictionary values which has array as datatype to List

Hi @RpaNoobMax , Could you check with the below Expression : list1 = yourDictVar.SelectMany(Function(x)x.value.Select(Function(y)y)).ToList Let us know if it doesn’t work

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

Convert all dictionary values which has array as datatype to List

Hi @RpaNoobMax , Could you check with the below Expression : list1 = yourDictVar.SelectMany(Function(x)x.value.Select(Function(y)y)).ToList Let us know if it doesn’t work

This solution provided by @Yoichi received 2 likes!

Extracting value from json after comparison?

Hi, As there are some syntax errors for json format in the above text, I fixed it as the following. { "statuses" : [ { "jobId" : "abx", "name" : "Suzan", "folder" : "abcd", "status" : "Ended Not OK" }, { "jobId" : "aby", "name" : "Pinacio", "folder" : "abcd", "status" : "Ended Not OK" }, { "jobId" : "abz", "name" : "Loren", "folder" : "abcd/pqrs", "status" : "Ended Not OK" } ], "returned" : 3, "total" : 3 } Then, can you try as the following? [image] Sample20221125-9.zip (2.6 KB) Regards

This solution provided by @Anil_G received 1 likes!

Move data from one data table to another

Hi @Cam1 Yes it is possible Use a for each row in datatable on dt1 and then use a add data row inside the loop and add the currentrow to dt2 After the loop you can use clear datatable to empty it if you want to empty it 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.