Forum Engagement Daily Reports

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

[system]

Daily Forum Report | 22 December 2022

Top 3 Topics with Most Views

Issue in Assign: Exception has been thrown by the target of an invocation made by @_Bhagyashree with 73 views.

JIT compilation is disabled for non-Legacy projects made by @Doneparthi_Chaitanya with 58 views.

How to Merge Two Data table made by @Peace_Maker with 47 views.

Top 3 Topics with Most Replies

Issue in Assign: Exception has been thrown by the target of an invocation made by @_Bhagyashree with 29 replies.

Help on regex statement needed made by @eric.atwood with 19 replies.

Any one help me for the output error (package is missing for (package is invalid ) made by @Shubham_Bidwai with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@Yoichi made 44 posts!

@Rahul_Unnikrishnan made 38 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 4 likes!

How to Merge Two Data table

Hi, Hope the following sample helps you. [image] dtA = dtA.AsEnumerable.Zip(dtB.AsEnumerable,Function(r1,r2) dtA.Clone.LoadDataRow(r1.ItemArray.Zip(r2.ItemArray,Function(v1,v2) if(String.IsNullOrEmpty(v1.ToString),v2,v1)).ToArray,False)).CopyToDataTable Sample20221222-3aL.zip (2.9 KB) Regards,

This post made by @ppr received 2 likes!

Data extraction in the menu is not available

In Addition to above: Back stage option: [grafik] Is connfiguring for new projects Switching a project to classic / modern we do it on the project settings: [grafik]

This post made by @arivu96 received 1 likes!

Yoichi 3000th Solution Flag Celebration

Thank you for all your contributions @Yoichi.Your dedication to helping others is realy inspiring and breaking 3000 solutions is an amazing achievement.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

How to Merge Two Data table

Hi, Hope the following sample helps you. [image] dtA = dtA.AsEnumerable.Zip(dtB.AsEnumerable,Function(r1,r2) dtA.Clone.LoadDataRow(r1.ItemArray.Zip(r2.ItemArray,Function(v1,v2) if(String.IsNullOrEmpty(v1.ToString),v2,v1)).ToArray,False)).CopyToDataTable Sample20221222-3aL.zip (2.9 KB) Regards,

This solution provided by @ppr received 2 likes!

Data extraction in the menu is not available

In Addition to above: Back stage option: [grafik] Is connfiguring for new projects Switching a project to classic / modern we do it on the project settings: [grafik]

This solution provided by @amit4 received 1 likes!

JIT compilation is disabled for non-Legacy projects

Hi, For me, updating the UiPath.System.Activities to latest version helped resolve the issue which was occurring only at runtime (not while debugging) Hope this helps!

---

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

Top 3 Topics with Most Views

How to overcome the limitations of Add Data Row made by @Pravin_Mandadi with 53 views.

Take an url with specific text in it made by @Povilas_Jonikas with 42 views.

Add bulk queue items made by @sharu_priya with 42 views.

Top 3 Topics with Most Replies

Table Extraction in preview i could see data but im unable copy same to excel or messagebox made by @niranjan.kummara with 21 replies.

Xml file reading and extracting some information from it made by @RAKESH_KUMAR_Tiwari with 20 replies.

Code is not running completely with action centre made by @Learner007 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Rahul_Unnikrishnan made 61 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @uio received 2 likes!

How do I change the format of the date?

Thanks a lot. It worked.

This post made by @Rahul_Unnikrishnan received 1 likes!

Ui Interaction with Microsoft Dynamics Navision 2018

Hello @anaskhan Can you raise it as new topic and share your concern with some screenshot there. Thanks

This post made by @Lahiru.Fernando received 1 likes!

Extract Multi-Language PDF Files using Document Understanding

Hi, You can find the languages supported by DU components here:

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

安定版を選択したのにbeta版に更新される

こんにちは 残念ながら、今回(2022/12)のリリースより更新チャネルが一本化され、 必ず最新版が提供されるようになりました。そのため現時点ではCommunity版については 2022.12-betaを使う以外の選択肢はないようです。 [image]

This solution provided by @Anil_G received 1 likes!

Add AD group to have modify permission on folder

@Zehra Please try this Dim FolderInfo As IO.DirectoryInfo = New IO.DirectoryInfo(FolderPath) Dim FolderAcl As System.Security.AccessControl.DirectorySecurity = FolderInfo.GetAccessControl() FolderAcl.AddAccessRule(New System.Security.AccessControl.FileSystemAccessRule(UserAccount, System.Security.AccessControl.FileSystemRights.Modify, System.Security.AccessControl.InheritanceFlags.ContainerInherit Or System.Security.AccessControl.InheritanceFlags.ObjectInherit, System.Security.AccessControl.P…

This solution provided by @jcb received 1 likes!

Audit logs - Upload package and Update process

Hey @Damian_Schapiro This feature is available to an extent at Tenant Audit level; [image] Unfortunately it doesn’t offer as rich insights as you have requested on the summary page, IE you can only see “Updated 1 Process(es)”. You can click the info button far right to see exactly what process you have updated, but I agree it would be useful to see this info on the actual audit tab rather than having to click into each: [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 | 24 December 2022

Top 3 Topics with Most Views

Add to queue made by @Rajesh_Rao with 58 views.

Variables to add in Add Data Row activity made by @Ram_Shiva_Reddy with 42 views.

How to get windows screen scale and layout value made by @RK_0 with 34 views.

Top 3 Topics with Most Replies

The problem of web site substitution，thank made by @Uddynitjh with 8 replies.

Compare two number with tolerance in % made by @l.sambinelli with 7 replies.

Problem with Custom Activity in package manager uipath studio.Please help me to resolve made by @BReddy_m with 7 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 17 posts!

@Yoichi made 10 posts!

@Anil_G made 9 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 1 likes!

How to master VB.Net code & LINQ for implementing any type of scenarion Using UIPath?

Hello @Ritesh_Burman You can watch the video on the community session regarding the LINQ in UiPath. Also there are courses available in different portals like udemy to learn it. Thanks

This post made by @sunilch received 1 likes!

Compare two number with tolerance in %

Hi @l.sambinelli you can use the same condition how you calculate val = ((dbl_2 - dbl_1)/dbl_1)*100 maxVal = 5 If ( val < maxVal) acceptable value Else Not acceptable

This post made by @Yoichi received 1 likes!

Compare two number with tolerance in %

Hi, FYI, if your tolerance means ±5%, Math.Abs method will help you as the following. [image] 100*Math.Abs(dbl_1-dbl_2)/dbl_1<5 Regards,

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

Top 3 Topics with Most Views

Request Credentialアクティビティを使ってサイトにログインしたい made by @gorby with 38 views.

Dynemic selector write in excelfile made by @purnima_mandan with 37 views.

Select Checkbox as per excel row made by @Omkar_Shete1 with 30 views.

Top 3 Topics with Most Replies

Request Credentialアクティビティを使ってサイトにログインしたい made by @gorby with 12 replies.

How to find color in particular cell value made by @Raja.G with 8 replies.

"Select Item " activity not working made by @Sami_Rajput with 6 replies.

Top 3 Users Who Posted The Most

@gorby made 9 posts!

@Anil_G made 8 posts!

@Rahul_Unnikrishnan made 6 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Error Saving Word Document to PDF

@Nora_Almulla I beleive you are pasing extra double quotes…please remove and try it. Cheers

This post made by @sangeethaneelavannan1 received 1 likes!

"Select Item " activity not working

@Sami_Rajput As a workaround,Please use the click activity. Click on the drop and next Click the number using aaname as dynamic attribute and pass that number as variable inside the selector

This post made by @Rahul_Unnikrishnan received 1 likes!

"Select Item " activity not working

Hello @Sami_Rajput Selevt item activity will not support all the dropdowns. I hope the element that you tring to select doesnt support select item activity. Instead go with the click activity. Thanks

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

Top 3 Topics with Most Views

Minmax made by @purnima_mandan with 50 views.

Add multiple datatables into single datatable made by @Shyam_Pragash with 41 views.

Need to Extractor Amount in below text using REGEX made by @Vicky_K with 38 views.

Top 3 Topics with Most Replies

Minmax made by @purnima_mandan with 15 replies.

Options strict on disallows implicit conversions from ‘attachment’ to ‘Iresource’ made by @Vijay_Singh with 12 replies.

Checking all rows if specific column contains value of "A" if contains value of "A" it will filter the data table get all the rows that have value of "A" made by @ldiaz with 11 replies.

Top 3 Users Who Posted The Most

@sangeethaneelavannan1 made 30 posts!

@Anil_G made 29 posts!

@Rahul_Unnikrishnan made 28 posts!

Top 3 Most Liked Posts

This post made by @humvale received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone! My name is Humberto. I have a marketing background and I’m starting my journey on RPA. The Forum looks like a great collaboration tool! Looking forward to having a great experience with IiPath.

This post made by @syed.ali.hasnat06 received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Thanks for providing us with the opportunity to introduce ourselves so that we’ll know about other people. I am Hasnat from Pakistan, graduated in the field of computer science and currently, I am working as a freelance. I was searching for outlook errors then this forum appears in the search engine and I decided to get the knowledge from UiPath, this was the journey.

This post made by @cprima received 1 likes!

2022-wk51 Last week in RPA on YouTube

What happened in the #uipath channels on YouTube last week? Here are videos released from 2022-12-19 thru 2022-12-25 by various creators. Find a YouTube playlist at https://www.youtube.com/playlist?list=PLruuV36qJJXfPBFCsZATiEHLRZI2A18YV … UiPath Job Offer | UiPath Training | RPA Dev In 30 Days | Best rpa projects 21 How to Use the UiPath Attended Framework Full Tutorial 27:34 How to use UiPath Action Center - Full Tutorial 20:04 Want a UiPath Job? Solve This Job Interview…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Error Saving Word Document to PDF

@Nora_Almulla Use path.Combine(var1,var2,var3) This will combine the path…and use a log message to check if you have given it properly Cheers

This solution provided by @Rahul_Unnikrishnan received 1 likes!

Kill Process - in Windows mode not working

@VanjaV You can provide as below. [image] Thanks

This solution provided by @RajKumar_DC received 1 likes!

Palindrome Scenario Based

Hi @Harsha_S1 , Plz refer this site Thanks, Rajkumar

---

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

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

[system]

Daily Forum Report | 27 December 2022

Top 3 Topics with Most Views

Add two column in last made by @sshitol with 74 views.

Data excel made by @purnima_mandan with 49 views.

How to find whether string contains any number in it or not made by @sshitol with 45 views.

Top 3 Topics with Most Replies

Get form task returning empty made by @user928 with 22 replies.

データテーブルをフィルタで抽出 made by @autopc01 with 19 replies.

Error is displayed when trying to create 16 digit fixed length random number made by @Deepa_Madkar with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@sudheern made 33 posts!

@Yoichi made 32 posts!

Top 3 Most Liked Posts

This post made by @111860 received 2 likes!

ICollection<T>とList<T>の使い分け

ありがとうございます。 これまでぼんやり理解していたものが明確になりました。 端的にご説明いただきありがとうございます。

This post made by @Yoichi received 1 likes!

ICollection<T>とList<T>の使い分け

List<T> はICollection<T>を実装していますので、多くの場合List<T>使っておけば 問題は少ないと思います。

This post made by @muuuuuu received 1 likes!

リモートデスクトップ越しのオーケストレーターからの実行について

Thank You！ ありがとうございます！ そちらの設定にて、画面が小さくならずにアプリを起動することができました。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

ICollection<T>とList<T>の使い分け

List<T> はICollection<T>を実装していますので、多くの場合List<T>使っておけば 問題は少ないと思います。

This solution provided by @Anil_G received 1 likes!

Get Activity Name for Get Row Item

@SIM_KAI_YI If the error occurs on that specific activity then it would give the name of that activity only Exception.Source would give the details cheers

This solution provided by @J0ska received 1 likes!

DataTable match only rows with 6 digits in Column0

Better like this: dt = dt.AsEnumerable().Where(Function (row) System.Text.RegularExpressions.Regex.IsMatch(row("Column0").ToString,"[0-9]{6}$")). CopyToDataTable() And alos check this post 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.