Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 September 2021

Top 3 Topics with Most Views

How to apply OR to regex made by @Kavya_Mamidishetti2 with 29 views.

Is it possible to read an Excel file referenced in another Excel application scope? made by @Kirigirisu_Coin with 28 views.

dt_Final.Rows(row_Number)(Column_Number) interpretation made by @lynnsong986 with 28 views.

Top 3 Topics with Most Replies

How to apply OR to regex made by @Kavya_Mamidishetti2 with 10 replies.

Using Web Controls in UiPath made by @hsendel with 9 replies.

How to Remove timestamp from DateTime Variable made by @Rajesh_Shet with 7 replies.

Top 3 Users Who Posted The Most

@prasath_S made 16 posts!

@Palaniyappan made 14 posts!

@greenlee made 12 posts!

Top 3 Most Liked Posts

This post made by @Aleem_Khan received 2 likes!

Need to do a vlookup and convert column data into Row data using LINQ

Try this for Vlookup (From a In dtSheet1.AsEnumerable() Join b In dtSheet2.AsEnumerable() On a(“Week Day”).ToString Equals b(“Week Day”).ToString Select dtSheet3.LoadDataRow (new Object() { a.Field(Of String)(“Week Day”), b.Field(Of String)(“NAME”),a.Field(Of String)(“Qty”), a.Field(Of String)(“Part Number”), },False)).CopyToDataTable

This post made by @Prem_Rao received 2 likes!

Activities Query

Hi All What is the difference between Screen scraping and Data scraping? Thanks.

This post made by @Kirigirisu_Coin received 1 likes!

Is it possible to read an Excel file referenced in another Excel application scope?

[2021-09-11 (9)] As you can see from the error in the image, I am currently reading a csv file instead of an Excel file in the Read range section. ・What I’m doing now I created a variable called ExcelWk in the output of external Excel application scope. And then, I write ExcelWk.GetSheets(0) at sheet information in Read Range. However, it failed. ・What I want to do I would like to reference Excel file. so is there any way to read an Excel file opened with an external Excel application sco…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

Is it possible to read an Excel file referenced in another Excel application scope?

That’s absolutely right I was even using excel based activities but I observed lot of stability with workbook activities in its later version So that’s why I suggested based on output I saw And For this try using a KILL PROCESS activity and mention as “EXCEL” in ProcessName propert and then use Write range activity And try to keep the above set of activities inside a TRY block of try catch activity So that even it fails it will go to CATCH block where we can use again a kill process as …

This solution provided by @Palaniyappan received 1 likes!

How To Use UiPath Apps For client that doesn't Have UiPath Acc

Hi This note on pre requisites gives a clear picture that even being attended or unattended it requires UiPath account to be tagged with the user who is running or using the app Cheers @Hendriyanto

This solution provided by @Palaniyappan received 1 likes!

dt_Final.Rows(row_Number)(Column_Number) interpretation

Hi Let’s take it one by one First left side dt_Final.Rows - this gives ienumerable of datarow which means to be simple array of rows Now in that we want specific cell value and if that is needed we need to know that row and column position So when you are trying to mention that row and column position We will be mentioning as index Index value usually starts from 0 for first row or first column So dt_Final.Rows(row number)(column number) Row number and column number here are index po…

---

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

Top 3 Topics with Most Views

Email cant be send made by @KANG_JEFF_YONG with 35 views.

Why write different between RegEx in UIPath and in web regex online? made by @Maria99 with 34 views.

I can not find Connector.Twitter.Activities package on Package Manage made by @Abdullah_Davut_Demirbilek with 33 views.

Top 3 Topics with Most Replies

Email cant be send made by @KANG_JEFF_YONG with 17 replies.

How to lookup two data tables? made by @aishwarya1 with 8 replies.

How to set up Send Hotkey to go to the next tab of my web navigator? made by @kaiji_San with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 16 posts!

@Srini84 made 12 posts!

@NIVED_NAMBIAR made 10 posts!

Top 3 Most Liked Posts

This post made by @NIVED_NAMBIAR received 3 likes!

How to lookup two data tables?

Hi @aishwarya1 u can try this assume dt1 —> sheet1 dt2 -----> sheet2 dt3_uncommon= (From r1 in dt2.AsEnumerable Where dt1.AsEnumerable().Where(Function(row) row(“Organization Name”).ToString.Trim.Equals(r1(“Organization Name”).ToString)).Count=0 Select r1).CopyToDataTable Now use append range or merge datatable to merge the dt1 and dt3_uncommon to a excel sheet. Regards, Nived N

This post made by @Srini84 received 2 likes!

How to append string variable value to excel file?

@greenlee Check below for your reference Reference Hope this may help you Thanks

This post made by @AshwinS2 received 2 likes!

Click Button, Close Windows, Close Application on Excel file closes other Excel files

Hi @Shinjid Have you tried kill process? Thanks Ashwin.S

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 3 likes!

How to lookup two data tables?

Hi @aishwarya1 u can try this assume dt1 —> sheet1 dt2 -----> sheet2 dt3_uncommon= (From r1 in dt2.AsEnumerable Where dt1.AsEnumerable().Where(Function(row) row(“Organization Name”).ToString.Trim.Equals(r1(“Organization Name”).ToString)).Count=0 Select r1).CopyToDataTable Now use append range or merge datatable to merge the dt1 and dt3_uncommon to a excel sheet. Regards, Nived N

This solution provided by @Srini84 received 2 likes!

How to append string variable value to excel file?

@greenlee Check below for your reference Reference Hope this may help you Thanks

This solution provided by @ppr received 2 likes!

Why write different between RegEx in UIPath and in web regex online?

give a try on regexstorm .NET Regex Tester - Regex Storm more close to .Net

---

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

Top 3 Topics with Most Views

Sql insert activity is not uploading data in correct order made by @WASEEM_KHAN with 41 views.

Find perticular date from string made by @ashishmani with 34 views.

How to make a trigger start after every 7 hours and 5 minutes? made by @Dam_Son with 33 views.

Top 3 Topics with Most Replies

VlookUp_Error made by @HeartCatcher with 19 replies.

Find perticular date from string made by @ashishmani with 16 replies.

Create Folder precheck? made by @atomic with 15 replies.

Top 3 Users Who Posted The Most

@Srini84 made 38 posts!

@Palaniyappan made 32 posts!

@Yoichi made 26 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 2 likes!

How to pass in a Variable in an Update query

Sorry if I read this wrong, but shouldn’t your UPDATE SQL be: UPDATE dbo.CampaignBatch SET ProcessStatusTypeId=200, YourDateColumn=@YourDateVariable where CampaignBatchId in ('value') ? Where is the column to which you are updating the date to?

This post made by @HANACCHI received 2 likes!

条件分岐についての質問

前日日付 = Now.AddDays(-1) 前日7時 ＝ New DateTime(前日日付.Year, 前日日付.Month, 前日日付.Day, 7, 0, 0) 前日22時 ＝ New DateTime(前日日付.Year, 前日日付.Month, 前日日付.Day, 22, 0, 0) 本日2時 = New DateTime(Now.Year, Now.Month, Now.Day, 2, 0, 0) を用意して、条件分岐に組み入れてみましょう。 Now.CompareTo(前日7時).Equals(1)とか、(0)とか、(-1)を組み合わせて。。。

This post made by @lakshman received 2 likes!

String Split Accordingly Using Split

@Hurmet_Noka Replace Outbound Flight Information text with empty. output = input.Replace("Outbound Flight Information","")

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

String Split Accordingly Using Split

Hi you are almost done for first part use this in assign activity str_part1 = Split(Split(information, “Inbound Flight Information”)(1).ToString),“Outbound Flight Information”)(0).ToString.Replace(“-----------------------------------------”,“”) and for second part like this str_part2 = Split(Split(information, “Inbound Flight Information”)(1).ToString),“Outbound Flight Information”)(1).ToString.Replace(“-----------------------------------------”,“”) Cheers @Hurmet_Noka

This solution provided by @Srini84 received 1 likes!

Argument passing issue - NULL outcome

@Jie_Sheng_Ong Check inside the Invoke Workflow [image] you have both Aguments and Variables with the same name [image] Delete the variable used inside the invoke workflow and you are fine to go Hope this may help you Thanks

This solution provided by @Palaniyappan received 1 likes!

Create Folder precheck?

Fine lets go one by one PATH EXISTS is usually used when someone wants to validate whether a folder exists or not before creating it and it is applicable for both files and folders as well. And it depends on scenario, say for example if someone wants to fetch a file from folder once after that file is downloaded but would like to validate whther the file is there or not, there comes PATH EXISTS or if someone wants to see if folder exists first or if not will need to send a mail or need to lo…

---

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

Top 3 Topics with Most Views

How to scroll down page? made by @Maria99 with 47 views.

How to form regex for a dynamic string made by @Suraj_Das_IN with 35 views.

Excel logic problem made by @Rakesh_Tiwari with 34 views.

Top 3 Topics with Most Replies

Unable to start execution (machine key related) made by @bean with 19 replies.

How to form regex for a dynamic string made by @Suraj_Das_IN with 17 replies.

Excel logic problem made by @Rakesh_Tiwari with 16 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 80 posts!

@ppr made 37 posts!

@prasath_S made 22 posts!

Top 3 Most Liked Posts

This post made by @Gernot_Brandl received 5 likes!

Test Manager Cloud is now in Public Preview

Dear Community! We are more than excited to announce that Test Manager Cloud is now in public preview. This is your jump start to the power of the UiPath Test Suite with all the convenience of the UiPath Automation Cloud. Test Manager is the glue between UiPath Studio, Orchestrator and a wide variety of 3rd party ALM tools. It seamlessly integrates your testing efforts into your development cycle. To get a quick overview, just lean back and watch this video. Key Features Build powerful te…

This post made by @ankit.saraf received 3 likes!

What is maximum number of records in query entity records?

@05211740000055 - @lakshman explained it well. You can also look a sample workflow showing pagination example here - Using entities in projects

This post made by @lakshman received 2 likes!

What is maximum number of records in query entity records?

@05211740000055 Welcome to our UiPath community. After using Query Entity Records activity and check Total Records value. It will give output as Total number of matching records value count. If it is greater than 1000 then you can use one more Query Entity Records activity and skip first 1000 records as you already retrieved it and also append this output to previous output. [Screenshot_20210914-061038]

Top 3 Most Liked Solutions

This solution provided by @lakshman received 2 likes!

What is maximum number of records in query entity records?

@05211740000055 Welcome to our UiPath community. After using Query Entity Records activity and check Total Records value. It will give output as Total number of matching records value count. If it is greater than 1000 then you can use one more Query Entity Records activity and skip first 1000 records as you already retrieved it and also append this output to previous output. [Screenshot_20210914-061038]

This solution provided by @Srini84 received 2 likes!

Excel logic problem

@Rakesh_Tiwari Use Filter Datatable ColumnName = “Selected” [image] For Index of the rows Then use For Each row activity Declare a variable for Index Write a If ocndition as row(“Result”).Equals(“Selected”) True->Print the Value Else skip Hope this may help you Thanks

This solution provided by @prasath_S received 1 likes!

How to pass in a Variable in an Update query

Hi @achawla From what @AndyMenon said think you can use like this, "UPDATE dbo.CampaignBatch SET ProcessStatusTypeId=200, YourDateColumn= "+Datetimevariable+" where CampaignBatchId in ('357')" You can convert the datetimevariable to string And also remove the line breaks ,it should be in a single line. Ex instead of using, “Select * From table” use “Select * from table” Thanks

---

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

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

[system]

Daily Forum Report | 15 September 2021

Top 3 Topics with Most Views

Community Editionのライセンスについて made by @cccasterrr with 39 views.

Speed up the RPA run made by @HKF with 35 views.

Problem Filter Data Table not working made by @NHoe with 34 views.

Top 3 Topics with Most Replies

String was not recognized as a vaid date time made by @nisha91_2177 with 18 replies.

Problem Filter Data Table not working made by @NHoe with 12 replies.

How to download mail attachment from Exchange activity? made by @ermanoj3101 with 9 replies.

Top 3 Users Who Posted The Most

@lakshman made 36 posts!

@Palaniyappan made 34 posts!

@ppr made 32 posts!

Top 3 Most Liked Posts

This post made by @Omar_AlSuleiman received 3 likes!

Update/Renew Orchestrator Certificate Post Tasks

I would like to share one of the problems occurred in my On-Prim UIPath Platform. Our certificate has expired and needs to be renewed or replaced. After the creation of new self signed certificate from IIS i started getting below problems: Orchestrator site failed to open with below error: {“message”:”An error has occurred.”,”errorCode”:0,”resourceIds”:null} Robots cannot connect to the orchestrator, and if connected, below errors will be encountered: Get Credential: You are not aut…

This post made by @LevKushnir received 2 likes!

Detect a background color in SAP

HI @Emine_Kaya1 Please use the latest UiPath Studio, where we have Expose ColorIndex for SAP ALV Tables We have introduced a new attributes ColorIndex / ColorIntensified / ColorInverse, which allows to identify the background colour of elements. [image] Best regards, Lev

This post made by @Yoichi received 2 likes!

Excelから読み込んだ0:00を 『0時間0分』として 0:00 と表したい

こんにちは データサイズが小さければ「表示形式維持」オプションを使う。 あるいは DateTimeに変換して、ToString(“H:mm”)で文字列変換してみる あたりをまずは試してみてはと思います。

Top 3 Most Liked Solutions

This solution provided by @LevKushnir received 2 likes!

Detect a background color in SAP

HI @Emine_Kaya1 Please use the latest UiPath Studio, where we have Expose ColorIndex for SAP ALV Tables We have introduced a new attributes ColorIndex / ColorIntensified / ColorInverse, which allows to identify the background colour of elements. [image] Best regards, Lev

This solution provided by @Yoichi received 2 likes!

Excelから読み込んだ0:00を 『0時間0分』として 0:00 と表したい

こんにちは データサイズが小さければ「表示形式維持」オプションを使う。 あるいは DateTimeに変換して、ToString(“H:mm”)で文字列変換してみる あたりをまずは試してみてはと思います。

This solution provided by @Yoichi received 2 likes!

Using 'Filter' activity from StudioX in Studio - Source field

Hi, Can you try as the following? [img20210916-4] Excel.Table("TableName") 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 September 2021

Top 3 Topics with Most Views

Changing the Date Format in a excel column made by @HeartCatcher with 60 views.

How to get specified string from a sentence made by @HeartCatcher with 44 views.

Write Range: two datatable to one Excel made by @Astor with 44 views.

Top 3 Topics with Most Replies

Changing the Date Format in a excel column made by @HeartCatcher with 23 replies.

Order processing queue made by @jlemon with 15 replies.

Splitting a String1 made by @HeartCatcher with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 54 posts!

@ppr made 27 posts!

@lakshman made 27 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 3 likes!

From 32-bit to 64-bit with 2021.8

Hello Studio Developer Team, in the context of my question about dotNET Core Release Support it is also very interesting to know about your plans of x86 and x64 architecture support. As far as I can see supports Windows-net461 only x86 architecture … [image] … and Windows-net5.0 only x64 architecture. [image] Here my code: Console.WriteLine("dotNET version: " + Environment.Version.ToString()); if (Environment.Is64BitProcess == true) { Console.WriteLine("64-bit Architecture"); } else { …

This post made by @ppr received 3 likes!

Changing the Date Format in a excel column

we can do it with followoing activities [grafik] ensure that this is done out side any Excel Application Scopes. Another option could be to do it with a macro executed by UiPath

This post made by @Gopal_Tewari1 received 2 likes!

I cant find users icon on orchestrator

Hi Anders, Now you can find the users inside the Manage Access Options Hope this will resolve your issue . Cheers

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

How to get specified string from a sentence

No worries if these value are in each row one after the another then you can pass the datatable to a FOR EACH ROW activity and inside that loop use this assign activity like this Str_output = Split(row(“yourcolumnname”).ToString.Trim,” “)(1).ToString.Trim If all of them are in one cell like if this is a single value with multiple lines it Then the activity used will be —use a assign activity like this Arr_line = Split(str_input.ToString,Environment.Newline.ToArray()) Where arr_line is a …

This solution provided by @Palaniyappan received 2 likes!

Getting the Day Minus one

Hi Hope this expression would help you resolve this If the input is in a string variable named str_input Then in a assign activity str_output = Datetime.ParseExact(str_input.ToString,”dd/MMM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).AddDays(-1).ToString(“yyyyMMdd”) This will give the day -1 as you expect Cheers @HeartCatcher

This solution provided by @Yoichi received 2 likes!

Searching a specific word and getting all the strings in a line with a condition

Hi, Hope the following helps you. [img20210916-5] System.Text.RegularExpressions.Regex.Matches(yourString,"[A-Za-z ]*(University|College)[A-Za-z ]*") Sequence3.xaml (6.8 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 | 17 September 2021

Top 3 Topics with Most Views

重い動作の時の対応 made by @lukatopdesrlat with 42 views.

Send Hot Key Activity made by @venkateshcheeni09 with 42 views.

Execute Macro Output Query made by @Kyleb91 with 41 views.

Top 3 Topics with Most Replies

Execute Macro Output Query made by @Kyleb91 with 26 replies.

Type Into: Index and length must refer to a location within the string. Parameter name: length made by @tkiran with 14 replies.

重い動作の時の対応 made by @lukatopdesrlat with 13 replies.

Top 3 Users Who Posted The Most

@lakshman made 27 posts!

@Palaniyappan made 26 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Replace the set of characters simultaneously

[grafik] we can doit with the help of locals and format patterns Ensure that System.Globalization is impoted to namespaces (down, tab close to variables)

This post made by @pthfs1 received 2 likes!

「ブラウザを開く」を制御するパッケージについて

遅くなりすみません。。 バージョンアップは何かとトラブルが起こりやすいので注意が必要ですね UiPath.Automation.Activitiesのバージョンを上げるとうまくいきました この度はありがとうございました

This post made by @lukasziebold received 2 likes!

How to open Outlook mail attachment (Excel) without saving

Hi, is there a good reason why you don’t want to (temporarily) save the attachment? Typically UiPath can read files (Excel/Csv/Txt/Word/Pdf/etc) very easily with specific activities once you have downloaded them. Seems like a big effort to open a file to read it. It is much less complicated to just read it in the background. I recommend saving every attachment (temporarily) to read it. Decide if you want to move the files to a more permanent location or delete the files again if you don’t wan…

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Replace the set of characters simultaneously

[grafik] we can doit with the help of locals and format patterns Ensure that System.Globalization is impoted to namespaces (down, tab close to variables)

This solution provided by @Yoichi received 2 likes!

パブリッシュ先が表示されない

こんにちは パブリッシュするときのオプション設定どのようになっていますか？ パブリッシュ先をカスタムにすると任意の場所にパブリッシュできると思うのでそちらを使うか、 Orchestartorにパブリッシュしている場合は、それを他のPCで使えるように OC側を設定するか、ダウンロードするかになると思います。 [img20210917-4]

This solution provided by @prasath_S received 1 likes!

How to filter DT if it contains no rows. Errors "source contains no DataRows"

Hi @Shinjid You can put an assign activity inside the if activity in_DT_Money.AsEnumerable.Where(Function(x)x("Date").ToString.Equals(item.ToString)AND x("MoneyType").ToString.Equals("USD")).Count > 0 And if the count is greater than 0, then use the assign activity you are referring inside the then, else do nothing and continue with the loop. Or of you want to put the assign before if activity,use assign inside the try catch activity. Thanks

---

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

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

[system]

Daily Forum Report | 18 September 2021

Top 3 Topics with Most Views

CSVデータの保存 made by @kksb.0141 with 42 views.

Mathes Emails with certain domen made by @YoungFave with 41 views.

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen made by @13051156620 with 36 views.

Top 3 Topics with Most Replies

CSVデータの保存 made by @kksb.0141 with 10 replies.

Find these files using reference made by @Luan_Carvalho_Da_Conceica with 7 replies.

Why does the input box become inactive in a loop? made by @Dguam with 7 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 24 posts!

@ppr made 10 posts!

@Pradeep.Robot made 9 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 1 likes!

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen

Hi Did we try with WORKBOOK activities Search as workbook in activity panel and try with READ RANGE under that This doesn’t require excel to be installed So it will work in all scenarios Hope this would help you resolve this Cheers @13051156620

This post made by @13051156620 received 1 likes!

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen

@Palaniyappan Thanks for the response, I tried WORKBOOK->Read Range,it worked well at develop machine. I’ll come back after dempolay the problem on the formal environment. runas /user:adminstrator works fine on my computer,I guess it’s an environment problem with the administrator account. Best wishes

This post made by @13051156620 received 1 likes!

Error opening workbook. If Excel is installed, run the ‘Repair Tool for Microsoft Office Interop’ from the Tools tab on the Home screen

Hi, It solved my problem. Cheers

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

How to loop multiple rows

Hi Hope these steps would help you resolve this Use a FOR EACH ROW loop and pass the dt variable as input Inside the loop use a assign activity like This Counter = 0 Where counter is a variable of type int32 with default value as 0 created in variable panel Followed by this assign use a WHILE LOOP inside the loop and pass the condition like this counter < dt.Columns.Count Inside this while loop use a TYPE INTO Activity like this with the inlut dt.Rows(dt.Rows.IndexOf(row))(co…

This solution provided by @Yoichi received 1 likes!

データテーブルを検索して見つかった行を取り出す方法

こんにちは 数値と文字列がそれぞれ異なる列にあるなら、 DataRowを抽出したければ dr = dt.AsEnumerable.OrderBy(Function(r) Decimal.Parse(r("数値列").ToString())).First() 新しい(1行だけの)DataTableとして扱いたければ newDt ={dt.AsEnumerable.OrderBy(Function(r) Decimal.Parse(r("数値列").ToString())).First()}.CopyToDataTable() あたりを試してもらえればと思います。

This solution provided by @aanandsanraj received 1 likes!

Mathes Emails with certain domen

@YoungFave Try this regex [A-Za-z0-9._%+-]+@yandex.ru

---

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

Top 3 Topics with Most Views

Convert String To Int in DataTable made by @rangga.waskita with 49 views.

UiPath 上級デベロッパー試験 キューの実行順序について made by @11159 with 36 views.

Assign 2 variable with array of string as the type into 2 columns in datatable made by @newuser1 with 36 views.

Top 3 Topics with Most Replies

How to get the values of specific row and store it in variable made by @newuser1 with 13 replies.

Assign 2 variable with array of string as the type into 2 columns in datatable made by @newuser1 with 12 replies.

Convert String To Int in DataTable made by @rangga.waskita with 10 replies.

Top 3 Users Who Posted The Most

@lakshman made 19 posts!

@ppr made 12 posts!

@newuser1 made 12 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Assign 2 variable with array of string as the type into 2 columns in datatable

its a combination of LINQ and .Net. For LINQ have a look here:

This post made by @Yoichi received 2 likes!

Assign 2 variable with array of string as the type into 2 columns in datatable

Hi, Zip method provides function to iterate 2 collections. SE.Zip(UrlList, Function(x,y) means iterate SE and UrlList and assign x to each item of SE and y to each item of UrlList at same index number. Then, LoadDataRow returns datarow which items are {x,y}. As a result, we can get datatable from them. Hope this helps you. Regards,

This post made by @To_Paulo received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello everyone, I just started a program here in UiPath this week and decided to join this forum in case I need some help, or maybe provide some. Thank you!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to merge same type of different excel file (excel is extracted from mail attachment) into one excel sheets

Hi, We need to read datatable to be merged in MergeDataTable in advance. So, the following sample helps you. [img20210919-1] Sample20210919-1.zip (32.9 KB) Regards,

This solution provided by @prasath_S received 1 likes!

Convert String To Int in DataTable

Hi @rangga.waskita Please try below steps, Read the excel sheet data or use build datatable and store the data in the datatable variable name dt. Drag and drop the invoke code activity. In edit arguments, create a variable dt, set direction as in/out and pass value as dt. In edit code type the following, dt.asenumerable.tolist.foreach(sub(row) row(“Yourcolumnname”)= cint(row(“Yourcolumnname”))) Write the datatable back into the excel using write range activity. Or We can use balareva ac…

This solution provided by @lakshman received 1 likes!

Select File dialog - StudioX

@Serban I guess we don’t have kind of Select File activity in Studio here.

---

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

Top 3 Topics with Most Views

Extract specific data from .html file made by @ovidiu_2088 with 89 views.

Extract Table from Web Page but some rows could have embedded links with information made by @ceceliaa34 with 61 views.

How to get number of occurencies of specific element in IEnumerable made by @Olivera_Kalinic with 56 views.

Top 3 Topics with Most Replies

Extract Table from Web Page but some rows could have embedded links with information made by @ceceliaa34 with 22 replies.

Compare Excel dates (dd/MM/yyyy) to Today's date (dd/MM/yyyy) made by @j8zel with 17 replies.

How to generate difference of two dates by reading data from excel and generating the difference dates to new excel file made by @Sirimalla_Karthik_Chandra with 17 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 31 posts!

@lakshman made 17 posts!

@postwick made 17 posts!

Top 3 Most Liked Posts

This post made by @rizistt received 2 likes!

Unlock Linux automation with 21.8 Robot!

Hi @erghe, Re-installation of Docker Desktop did the trick. To be on the safe side, I updated the self-signed certificate and created a new image (as you mentioned above), and it worked. [image] I’m sure Linux + RPA will open so many new doors. Excited!! Thank you!

This post made by @RyanBoone received 2 likes!

UiPath Integration Service Public Preview is Now Available!

We’re excited for you to experience the new preview of the Integration Service for Automation Cloud, which brings managed integration with a robust catalog of Connectors for UiPath Automation Cloud. Read more about the Integration Service here. The new Integration Service brings: Connectors - Rapidly growing list of new Connectors every month to connect to the systems you use the most. Each Connector in the catalog will also have a related Activity Pack. Read more about it here. Connection…

This post made by @jeevith received 2 likes!

Palaniyappan 2000th Solution Flag Celebration

We would like to thank @Palaniyappan for his valuable contribution to this community! I think the 2000th solution was : [Search name after ] this backet - Help / Activities - UiPath Community Forum](Search name after ] this backet - #15 by ashishmani) Thank you again @Palaniyappan. We all have learned a lot from you and we appreciate your work. Cheers!

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

Take screenshot of Outlook Mail

Hi @Santan_Barnwal Please give a try, Read the mail messages using get outlook mail message and store it in the Variable lstMail, type - list(mailmessage) Loop the mail messages using for each activity,set type argument as system.net.mail.mailmessage and pass value as lstMail. Inside for each activity use save mail message activity and save the mail in .eml format. After saving use start process activity and pass the file path of the previously saved file.(it will open the mail) …

This solution provided by @lakshman received 1 likes!

上級デベロッパー試験 データテーブルのフィルタリングについて

@11159 If Department is equal to either IT or Finance and Salary less than 30000 then 4th option will be correct one.

This solution provided by @Yoichi received 1 likes!

Create excel Table with Dynamic datas - "@" character issue

Hi, If Colcount is 27, Convert.ToChar(Convert.ToUInt32("A"C)+Colcount-1) will return not "@" but "[". Can you share your expressions after the above? Or, I recommend to use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter method. This returns column letter from R1C1 style column index. For example UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(27) returns "AA" 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 September 2021

Top 3 Topics with Most Views

Dynamically change the HTML Tables TD background color made by @Deepak_Andriod with 51 views.

How to get latest file from ftp without looping made by @sunilch with 47 views.

Problem with date picker made by @Geoffroy_Pantegnies with 43 views.

Top 3 Topics with Most Replies

Want to get the data based on filter condition made by @Rakesh_Tiwari with 22 replies.

Dynamically change the HTML Tables TD background color made by @Deepak_Andriod with 18 replies.

データの状態によらず、セレクターの属性値の取得について made by @VitaminJapan2 with 18 replies.

Top 3 Users Who Posted The Most

@lakshman made 41 posts!

@ppr made 26 posts!

@postwick made 18 posts!

Top 3 Most Liked Posts

This post made by @DeaTo received 8 likes!

Community Contributor of the Month

We also want to proudly mention our contributors from June, July, August and September. June: Priya Darshini - Senior Technical Consultant @ Machina, 2021 UiPath Community MVP and events speaker - @PD2 July: Hiba Beldi - Chapter Leader for Paris Chapter - @Hiba_B August: Shubham Varshney - Senior RPA Consultant at Xebia, UiPath Forum contributor, added 5 use cases in the fields of HR, Finance, Operations and Compliance - @Shubham_Varshney September: This month we celebrated more than on…

This post made by @DeaTo received 5 likes!

Community Contributor of the Month

Starting June we launched a Community Newsletter with the objective of staying close to you, our dear UiPath Community members, and bringing more awareness about UiPath Community programs, platforms and initiatives in general. Every month, at the end of the newsletter, we mention a community member who has contributed in extraordinary ways to scale automation adoption among their peers through their knowledge and collaboration. What is it about? Starting from the beginning of J…

This post made by @sneha_p1 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone, I am sneha , beginner in RPA and started learning UiPath today. Looking forward to learn how we can help organizations resolve real time complex problems using Ui Path.

Top 3 Most Liked Solutions

This solution provided by @grosner received 1 likes!

UIPath not working with OpenJDK 11

Thank you for the test and the confirmations. Ultimately, to get UIPath to work with the OpenJDK SunAwt app: Populate c:\UiPath with: UiPathBridge.jar UiPathJavaBridgeV8.dll UIPathJavaBridgeV8_x64.dll UiPathJavaServiceProvider.jar Add the following to the app’s .vmoptions file: -classpath C:\UiPath\UiPathBridge.jar;C:\UiPath\UiPathJavaServiceProvider.jar Verify the application’s appname\jre\conf\accessibility.properties file contains: assistive_technologies=UiPath.UiPathBridge …

This solution provided by @Priyanka_Ramesh received 1 likes!

Fetch the row value of One column of Excel A Sheet with Sheet Excel B who has same column

Hi @Sudhir_P , The first 2 sheets can be read using read range and then using join datatable the 2 datatable can be merged with the condition of name = name . The output to be written in sheet3. JoinDatatable.xaml (8.0 KB)

This solution provided by @postwick received 1 likes!

Truncate all values in a UIPath datatable

No you wouldn’t. You could just have multiple assigns inside the For Each Row loop. Assign row.Item(0) = Left(row.Item(0).ToString,100) Assign row.Item(1) = Left(row.Item(1).ToString,100) …etc Of course, it would mean less code if you did do a For Each inside the For Each Row. [image] The expression on the left is CurrentRow.Item(columnName)

---

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

Top 3 Topics with Most Views

How to make [ ] as optional in regex made by @Kavya_Mamidishetti2 with 37 views.

Scraping data from body of E-mail made by @Radha_Ganesan with 34 views.

Update MainDT using filtered rows made by @Omkar_Deshmukh with 32 views.

Top 3 Topics with Most Replies

Display List of strings as Input option in Input dialog Box, using config file made by @Dimple_Mandal with 19 replies.

Update MainDT using filtered rows made by @Omkar_Deshmukh with 16 replies.

Scraping data from body of E-mail made by @Radha_Ganesan with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 46 posts!

@ppr made 21 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @erghe received 4 likes!

Unlock Linux automation with 21.8 Robot!

We are proud to announce that the following UiPath IT Automation activity packages are now available for the Robot on Linux: Amazon Web Services (AWS) AWS Workspaces Azure Azure Virtual Desktop Azure Active Directory Google Cloud (GCP) Citrix Hypervisor The cross-platform UiPath IT Automation activities enable you to build automations for Cloud resources provisioning and management, ITSM and User Management, Desktop and App Virtualization, Server Virtualization. Stay tuned for updated exampl…

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

Date Picker always displays wrong date (1 day before selection)

Hi, I’d like to report the same bug, where the app appears to be subtracting an hour and putting the date back one!

This post made by @Palaniyappan received 2 likes!

Regex to get any 4 Digit or Character or Both, Inside a Double Qoute

Hi Hope this expression helps you resolve this Use Matches activity and mention this expression (?<=CODE\W\W\s\W).*(?=\W,) This will get all the values of CODE of any type Be it character or number Cheers @Shinjid

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

Regex to get any 4 Digit or Character or Both, Inside a Double Qoute

Hi Hope this expression helps you resolve this Use Matches activity and mention this expression (?<=CODE\W\W\s\W).*(?=\W,) This will get all the values of CODE of any type Be it character or number Cheers @Shinjid

This solution provided by @Palaniyappan received 2 likes!

Separating string in an excel column

Hi Hope these steps would help you resolve this —use a excel application scope and pass the file path as input and get the output as dt with read range activity —now use a BUILD DATATABLE ACTIVITY with two columns we want and get the output as dt_final —use a CLEAR datatable activity and pass the above dt_final as input —then use a FOR EACH ROW activity and pass dt as input —inside the loop use a assign activity like this Intcount = Split(row(0).ToString,” “).Count Where intcount is a va…

This solution provided by @Palaniyappan received 2 likes!

Excel questions

Hi Mention in cell range as “A11” and enable add headers This will read all the records from A11 inspite of dynamic number of rows after that Cheers @Matthew2

---

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

Top 3 Topics with Most Views

Filter date column in datatable made by @Deepa_Madkar with 54 views.

Write date with dot as separator made by @WASEEM_KHAN with 44 views.

Build Data Table with headers made by @NHoe with 44 views.

Top 3 Topics with Most Replies

SMTP Mail Images in mail body are not displaying in Gmail app made by @Vivek_Ananth with 15 replies.

Filter date column in datatable made by @Deepa_Madkar with 14 replies.

How to stop While activity for Element Exists made by @jjtubon with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 32 posts!

@lakshman made 26 posts!

@Gokul001 made 24 posts!

Top 3 Most Liked Posts

This post made by @cheez_RPA received 3 likes!

他のロボットを実行させたいです

利用する環境によりますが、簡単に実現できる方法はありません。 Orchestrator + Unattended Robotをお使いの環境であれば、指定したプロセスのジョブを実行するよう指示できます。ジョブは、実行を指示したジョブが終わるまで保留されて、終わり次第開始されます。 それ以外の環境ですと、同時に複数のプロセスを起動することが出来ないため、実現できないはずです。 お試しになった「プロセスを開始」アクティビティは、指定したファイルを開くのと同じものと捉えてください（指定したプロセスをRobotで実行するものではありません）。

This post made by @Palaniyappan received 2 likes!

Is there any way to cut all rows to the bottom of excel?

Hi We can skip or take the records we want with this method Dt = Dt.Asenumerable().Take(number of rows in count you want).CopyToDataTable() If you want to remove last row alone then Dt = Dt.Asenumerable().Take(dt.rows.count - 1).CopyToDataTable() Or If you know the range of data to be extracted dt from a excel then we can mention the range as well while reading the excel with READ RANGE activity Hope this would help you resolve this @Kirigirisu_Coin

This post made by @lukasziebold received 2 likes!

? operator vbnet

I don’t think you can use it in Studio. If I understand correctly, null-conditional operators are a thing in C#, Visual Basic and VBA, but somehow not in Vb.Net. Correct me if I’m wrong

Top 3 Most Liked Solutions

This solution provided by @cheez_RPA received 3 likes!

他のロボットを実行させたいです

利用する環境によりますが、簡単に実現できる方法はありません。 Orchestrator + Unattended Robotをお使いの環境であれば、指定したプロセスのジョブを実行するよう指示できます。ジョブは、実行を指示したジョブが終わるまで保留されて、終わり次第開始されます。 それ以外の環境ですと、同時に複数のプロセスを起動することが出来ないため、実現できないはずです。 お試しになった「プロセスを開始」アクティビティは、指定したファイルを開くのと同じものと捉えてください（指定したプロセスをRobotで実行するものではありません）。

This solution provided by @Palaniyappan received 2 likes!

Is there any way to cut all rows to the bottom of excel?

Hi We can skip or take the records we want with this method Dt = Dt.Asenumerable().Take(number of rows in count you want).CopyToDataTable() If you want to remove last row alone then Dt = Dt.Asenumerable().Take(dt.rows.count - 1).CopyToDataTable() Or If you know the range of data to be extracted dt from a excel then we can mention the range as well while reading the excel with READ RANGE activity Hope this would help you resolve this @Kirigirisu_Coin

This solution provided by @lukasziebold received 2 likes!

? operator vbnet

I don’t think you can use it in Studio. If I understand correctly, null-conditional operators are a thing in C#, Visual Basic and VBA, but somehow not in Vb.Net. Correct me if I’m wrong

---

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

Top 3 Topics with Most Views

How to use group by and get sum? made by @aapostol with 40 views.

How to join the string in every 3 rows and make and write in one cell? made by @Ru_eL with 40 views.

How to perform Conditional Format using Uipath made by @HeartCatcher with 37 views.

Top 3 Topics with Most Replies

Excel Formula adding @ at the beginning made by @fabio.r.mendes with 19 replies.

How to perform Conditional Format using Uipath made by @HeartCatcher with 12 replies.

How to use only two digits after . in decimal made by @copy_writes with 11 replies.

Top 3 Users Who Posted The Most

@lakshman made 23 posts!

@Yoichi made 20 posts!

@Soudios made 17 posts!

Top 3 Most Liked Posts

This post made by @FranciscoAraujo received 4 likes!

Workflow Analyzer - Access to project folder path

Hello! I want to drop a question related to the “Workflow Analyzer - Build Custom Rules”. Is it possible to get the folder path of the project that is being analyzed? In this case, I want to validate some info in the Config file and get the project name from .json file. Any help? [image] MessageBox 1: [image] MessageBox 2: [image] MessageBox 3: [image] Thanks! Francisco

This post made by @NIVED_NAMBIAR received 3 likes!

How to use only two digits after . in decimal

Hi @copy_writes Try like this Math.Round(CDBl(taxval),2).ToString Or Math.Round(Convert.ToDecimal("12.000"),2).ToString Just adding one more way as well

This post made by @Yohann_Marmonier received 2 likes!

Tutorial : Start a job via the Orchestrator API on Microsoft SQL Server

Hello community ! In this tutorial I’ll explain how to start jobs on SQL under MSSQL but you can easily adapt the code to perform any kind of Orchestrator api requests from MSSQL. This tutorial with a detailed wiki (soon for wiki) is available here too. You’ll need two steps : Register an external app on Orchestrator Run the SQL Code At the end, you’ll be able to start a job with only this type of commands : EXEC [RPA_OrchestratorAPI_StartJob] @processName = N'YOUR_PROCESS_NAME', …

Top 3 Most Liked Solutions

This solution provided by @codemonkee received 2 likes!

Unable to integrate Minio "HTTPS" with Orchestrator. Package publish failed

After some trial and error, I dug through UiPath’s Minio DLL files (UiPath.Storage.Minio.dll and Minio.dll) I searched for properties/text such as “Secure”, “SSL”, “Https” and after trying a few properties from Minio.dll such as ;Secure as this is the property that sets the HTTPS flag in the Client (but failed), ended up locating a Boolean SslEnabled in the UiPath.Storage.Minio MinioStorageClientOptions [image] Updating the Storage.Location connection string with SslEnabled=true<add key="St…

This solution provided by @masatomix received 1 likes!

Orchestrator APIを用いたジョブの実行ログ取得ついて

こんにちは。 たしか、上限1000件だったような気がします。 Swaggerで取得してみましたが、 { "@odata.context": "https://[OCサーバ名]/odata/$metadata#Jobs", "@odata.count": 1307, "value": [ {.... と返ってきつつ、実際のJSON配列は1000件でした。 Swagger(https://[OCサーバ名]/swagger) を見てみると、$topのパラメタ説明も Limits the number of items returned from a collection. The maximum value is 1000. となっていますし、コレを1001とかにしたらエラーになりましたし、多分上限1000件ではないかと。それ以上を取得したい場合は、他のパラメタ $skip などでオフセットしながら何回かに分けて取ることになると思います 期間については、SQLサーバにデータが入っている限り、取得可能だと思います。 よろしくお願いします。

This solution provided by @prasath_S received 1 likes!

Invoke code: Exception has been thrown by the target of an invocation / 2-digits-after-the-decimal-point

Hi @Soudios Please try this, dt.asenumerable.Where(function(row) not String.IsNullOrEmpty(row("Somme de Ratio").ToString)).ToList().ForEach(Sub(row) row(“Somme de Ratio”)= Math.round(cdbl(row(“Somme de Ratio”)),2)) It is similar to this one, Thanks

---

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

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

[system]

Daily Forum Report | 25 September 2021

Top 3 Topics with Most Views

UiPath app not running job made by @Surya_Narayana_Korivipadu with 43 views.

How to make condition to check which URL address is exist made by @Dam_Son with 37 views.

Merging multiple rows made by @Bhanu_Rathore with 37 views.

Top 3 Topics with Most Replies

日付でフィルタリング（今日から〇日前の間） made by @nagumo with 7 replies.

Merging multiple rows made by @Bhanu_Rathore with 6 replies.

Read specific items in a CSV file made by @RojemMolina with 6 replies.

Top 3 Users Who Posted The Most

@lakshman made 12 posts!

@NIVED_NAMBIAR made 8 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Updating excel reframework

Yeah this should be fine but at the same time make sure you are updating the relevant queue item with a transaction status using Set Transaction status activity And while we are trying to go for next run make sure the one which got failed is reconsidered Also use reference for each queue item which will help you avoid duplicate records in queue item Cheers @Satish_Ch

This post made by @NIVED_NAMBIAR received 2 likes!

Cyrillic + Latin + Digits regex

Hi @NotFranmax Try this [^\s\p{IsCyrillic}A-Za-z0-9,.-]+

This post made by @hatakora received 1 likes!

Where we have to give Form data in HTTP Request activity

Hi @Cristian_Negulescu thank you for the response. How do i adjust this to take Cookie value as authentication instead

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Cyrillic + Latin + Digits regex

Hi @NotFranmax Try this [^\s\p{IsCyrillic}A-Za-z0-9,.-]+

This solution provided by @pravin_calvin received 1 likes!

How to make condition to check which URL address is exist

hi @Dam_Son Check with get attribute activity and getting the URL attribute! Regards

This solution provided by @Yoichi received 1 likes!

Filtering Datatable Column with another Datatable Multiple Columns with Linq

Hi, Hope the following helps you. [img20210925-3] dtResult = DT1.AsEnumerable.Where(Function(r) filteredDT2.AsEnumerable.Any(Function(r2) r("Vendor").ToString=r2("Vendor").ToString AndAlso r("Document currency").ToString=r2("Document currency").ToString)).CopyToDataTable Sample20210925-3.zip (7.9 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 | 26 September 2021

Top 3 Topics with Most Views

Cannot communicate to the extension made by @Seetharaman_T_J with 44 views.

Linq/Query unite arrays made by @YoungFave with 35 views.

Http request activity response in stream format made by @WASEEM_KHAN with 35 views.

Top 3 Topics with Most Replies

Cannot communicate to the extension made by @Seetharaman_T_J with 14 replies.

Http request activity response in stream format made by @WASEEM_KHAN with 13 replies.

Linq/Query unite arrays made by @YoungFave with 9 replies.

Top 3 Users Who Posted The Most

@WASEEM_KHAN made 17 posts!

@jeevith made 15 posts!

@Seetharaman_T_J made 9 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

Get the key Values From Transaction item

Hi @Karam_Abulawii, Then you just use the keys from the dictionary. FirstSevenKeys = string.Join(", ", in_TransactionItem.SpecificContent.Keys.ToArray.Take(7)) string.Join joins the array values with ", " as seperator (a single space after comma to make the output pretty) in_TransactionItem.SpecificContent.Keys gets you all the keys in the specific content in_TransactionItem.SpecificContent.Keys.ToArray converts dictionary keys to an array in_TransactionItem.SpecificContent.Keys.ToArra…

This post made by @cheez_RPA received 2 likes!

アセットによる繰り返し処理は可能でしょうか？

可能かと思います。 10人分のID・パスワードをアセットに保存します。 上記で保存したアセットの名称を、Excelで作成した設定ファイルなどに入力します。 上記の設定ファイルをデータテーブルとして読み込み、繰り返しを作成します。 繰り返しの中で、読み込んでいる行からアセットの名称を取得し、アセットを呼び出します。 呼び出したID・パスワードを用いて処理を行います。

This post made by @ppr received 2 likes!

Linq/Query unite arrays

@YoungFave Variables: [grafik] Flow: [grafik] LINQ: (From a In {arr1,arr2,arr3} Select ta = a.Select(Function (x,i) Tuple.Create(i,x)) From t In ta Group t By t.Item1 Into grp=Group Let ga = grp.Select(Function (g) g.Item2).toArray Select grs = ga).toList done with the help of position tuples created by an indexed select Check: [grafik]

Top 3 Most Liked Solutions

This solution provided by @jeevith received 3 likes!

Get the key Values From Transaction item

Hi @Karam_Abulawii, Then you just use the keys from the dictionary. FirstSevenKeys = string.Join(", ", in_TransactionItem.SpecificContent.Keys.ToArray.Take(7)) string.Join joins the array values with ", " as seperator (a single space after comma to make the output pretty) in_TransactionItem.SpecificContent.Keys gets you all the keys in the specific content in_TransactionItem.SpecificContent.Keys.ToArray converts dictionary keys to an array in_TransactionItem.SpecificContent.Keys.ToArra…

This solution provided by @cheez_RPA received 2 likes!

アセットによる繰り返し処理は可能でしょうか？

可能かと思います。 10人分のID・パスワードをアセットに保存します。 上記で保存したアセットの名称を、Excelで作成した設定ファイルなどに入力します。 上記の設定ファイルをデータテーブルとして読み込み、繰り返しを作成します。 繰り返しの中で、読み込んでいる行からアセットの名称を取得し、アセットを呼び出します。 呼び出したID・パスワードを用いて処理を行います。

This solution provided by @ppr received 2 likes!

Linq/Query unite arrays

for doing the above the grouping will not serve, as with different length arrays, shorter ones need to be filled up on common length [grafik] (From i In Enumerable.Range(0,{arr1,arr2,arr3}.Max(Function (a) a.Length)) Let ra = {arr1,arr2,arr3}.Select(Function (x) If(x.Length <= i,"",x(i))).toArray Select r=ra).toList [grafik] Feel free to combine {arr1,arr2,arr3} into a variable and will use later this within the LINQ

---

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

Top 3 Topics with Most Views

Split String basde on a new line made by @Karam_Abulawii with 44 views.

LINQ Code Explanation made by @Tanzill_Ahsan with 42 views.

Remove "NULL" word from excel made by @syaheed22 with 39 views.

Top 3 Topics with Most Replies

Remove "NULL" word from excel made by @syaheed22 with 19 replies.

Split String basde on a new line made by @Karam_Abulawii with 14 replies.

If IsMatch, then wirte in Data Table made by @NHoe with 14 replies.

Top 3 Users Who Posted The Most

@Yoichi made 36 posts!

@pravin_calvin made 11 posts!

@NIVED_NAMBIAR made 10 posts!

Top 3 Most Liked Posts

This post made by @Anna_Hotsa received 4 likes!

Task Capture 2021.10 Preview Release

Task Capture 2021.10 Preview Release Hello, Community! We’re happy and excited to share with you incredible updates and improvements of Task Capture in the 2021.10 preview version! Walkthrough the list of updates below, give it a try and feel free to share the feedback What’s new? Detect and merge same-screen actions By default, the Task Capture recorder captures all actions you perform, such as mouse clicks, keyboard i…

This post made by @Christopher_p received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi all, I’m a beginner with Studio X (soon Studio) and i’m from Lyon. I came here because the community looks great and the helpfulness is great. I hope found answers for my questions and help others ! Thanks et have a nice day

This post made by @axel.zielinski received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, I’m Axel Zielinski, a french developer. I have already worked with another RPA software. And now I’m here to learn to use UI Path with the academy and this forum. Thanks

Top 3 Most Liked Solutions

This solution provided by @Shuichiro_Yamashita received 2 likes!

Assistant設定にWindows管理者権限が必要か？

回答ありがとうございました！ その後、どなたからも回答がなかったので、そもそも質問自体が適切でなかったかと思い、その時は諦めました。 回答いただいた内容は、その通りでした。サービスモードにしており、Windowsの管理者権限が必要でした。今の時点では解決しましたが、Brandonさんの指摘は適切でした。 とても急いていたので、すぐにシステム管理者にWIndows管理者権限を与えてもらい、それによって解決しました。お礼が遅くなりすみません。

This solution provided by @aanandsanraj received 1 likes!

Checking combinations of conditions

Hi @daqc In your case you can use Switch activity instead of nested if below links will help you

This solution provided by @Yoichi received 1 likes!

Get End of expression expected error when write cell with formula

Hi, Can you try the following? "=IF(ISNUMBER(SERACH(""-2146826246"",J2)),K2,J2)" Note: Doublequote should be expressed as "" in String literal (VB.net) 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 | 28 September 2021

Top 3 Topics with Most Views

NEW! UiPath Academy learning plan: The new RPA Starter made by @Masli with 54 views.

Put all text in one column made by @prititit with 40 views.

Given key is not present in dictionary made by @syedirfan_uddin with 36 views.

Top 3 Topics with Most Replies

I have a table dt1, dt1 has many attribute columns and many rows, I want to know what judgment conditions can quickly determine any cell in the table has a null value. What is the most concise way to write a conditional judgment? made by @491979546 with 20 replies.

EdgeのSave Asボタンのクリックアクティビティが動作しない made by @nosawa with 19 replies.

Convert PDF (thai language) to write text file? made by @Maria99 with 11 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 55 posts!

@lakshman made 16 posts!

@sonaliaggarwal47 made 14 posts!

Top 3 Most Liked Posts

This post made by @Masli received 6 likes!

NEW! UiPath Academy learning plan: The new RPA Starter

The new RPA Starter released on UiPath Academy We are excited to have released this new version of what has been the first step in everybody’s learning journey with RPA since 2019. Just as before, this learning plan: answers the most important questions about RPA and automation: What is RPA? What is automation? Why UiPath? How are RPA robots built? combines illustrations and simple explanations of concepts with the hands-on experience of automating using StudioX. One of the…

This post made by @vishal.kp received 2 likes!

How to remove unwanted characters at the end of the string?

Here you go SKC2.xaml (5.7 KB)

This post made by @T0Bi received 1 likes!

Error when training object detection - AI Center

Nope unfortunately not

Top 3 Most Liked Solutions

This solution provided by @vishal.kp received 2 likes!

How to remove unwanted characters at the end of the string?

Here you go SKC2.xaml (5.7 KB)

This solution provided by @Palaniyappan received 1 likes!

Retry Scope for Timeout Error

Hi Hope the below steps helps you resolve this —use a assign activity like this bool_response = True Where bool_response is a variable of type Boolean —now use a WHILE LOOP activity where mention the condition as bool_response = TRUE —now this condition is currently true so it will enter the loop —inside the loop use a HTTP REQUEST activity and in that activity get the output of StatusCode which is of integer type named int_code If your http request is successful then it will return 200…

This solution provided by @kershawn.edwards received 1 likes!

Error trying to run process in PiP

Hi seems like it started working after I restarted my machine. Thanks for any time you spent on it.

---

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

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

[system]

Daily Forum Report | 29 September 2021

Top 3 Topics with Most Views

Update your community profile and connect more made by @Oana_Chicioroaga with 49 views.

Extract Data Table works sometimes made by @jaco with 38 views.

LINQ syntax filter and update lines made by @drago47 with 36 views.

Top 3 Topics with Most Replies

Is there a way to move all files at one go from folder to folder made by @Krithi1 with 12 replies.

Edit Data Grid: Edited data is not saved to datatable made by @PeCour with 10 replies.

オーケストレータで管理しているライブラリ（WF部品）の一斉更新 made by @Quinone with 9 replies.

Top 3 Users Who Posted The Most

@Yoichi made 29 posts!

@lakshman made 27 posts!

@1111223 made 12 posts!

Top 3 Most Liked Posts

This post made by @Oana_Chicioroaga received 6 likes!

Update your community profile and connect more

Hello, As (we hope) you already know and feel, each of you is very important for the whole UiPath ecosystem - you are one of 1,500,000, and without you, the community would not be the same. We are always grateful for the time, energy, and care each of you invest in the product, in asking and answering questions, in offering feedback, creating content contributing to the RPA field in general. We are always looking for ways to foster collaboration, networki…

This post made by @TonyNudd received 2 likes!

Virtual/Augmented Reality + RPA?

hey - you asked about UiPath & VR - I am playing with a Occulus Quest 2 and built out this concept site … works on PC and mobile without headset set too … static at moment, but I will use robot to capture and refresh the Orchestrator and Process Mining 360-images so you get almost live images as the dashboards change … use your mobile to visit public site here: YouTube version with Robot Activation (RobotJS)… [UiPath Bots Create Dynamic VR Environment]

This post made by @Priyanka_Ramesh received 2 likes!

How to convert Negative amount value to positive amount value

Hi , The Write cell can be used with formula =ABS (number).

Top 3 Most Liked Solutions

This solution provided by @Priyanka_Ramesh received 2 likes!

How to convert Negative amount value to positive amount value

Hi , The Write cell can be used with formula =ABS (number).

This solution provided by @prasath17 received 2 likes!

Need to Remove Empty Space from a middle of a string and the half of the string will be in new line

Hi @maddy99 … Please try this… [image] To use Regex.Replace please import system.text.regularexpressions or use it as system.text.regularexpressions.regex.replace

This solution provided by @cheez_RPA received 1 likes!

指定した画像のパス名から画像を自動選択したい

web上に画像をアップロードするとき、「画像をアップロードする」ボタンを押すとPCのファイルが自動的に開きます。 ファイルを選択するウィンドウが表示されているのかと思いますが、そのウィンドウの下部に存在すると思われるファイル名を指定するボックスに対して、「テキストを設定」で画像のパスを入力し、その右側のボタンを押下することで実現できるのではないかと思います。

---

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

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

[system]

Daily Forum Report | 30 September 2021

Top 3 Topics with Most Views

How to get all the sheet names of excel without opening excel made by @anishakotian400 with 56 views.

Developer Opinion about UiPath Studio made by @rsaquicela with 54 views.

Assign Activity Error--URGENT made by @mitul_choudhary with 49 views.

Top 3 Topics with Most Replies

How to read duplicate cells in excel made by @Funky_Monks with 16 replies.

Assign Activity Error--URGENT made by @mitul_choudhary with 10 replies.

How to get the list of fields(keys) in the Queue Item? made by @Bandi_Vinay_Kumar with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 26 posts!

@lakshman made 23 posts!

@NIVED_NAMBIAR made 18 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

Developer Opinion about UiPath Studio

Hi @rsaquicela, Excellent to see that you being the end user have taken to love automation and are willing to upskill. If those developers who are negative towards UiPath have still managed to make you believe in RPA, imagine what you can develop when you do use UiPath the correct way You know where this post is going! The below is my opinion and stems from hands-on automating for close to 5 years in different tools / programming languages both as a professional and as a weekend autom…

This post made by @Yoichi received 2 likes!

IE11 BOM Explorerのデバッガーに表示される ソースコードの全テキストを取得したい

こんにちは 時間のかかっているアクティビティの[ターゲット]-[準備完了まで待機]プロパティをNONEにして試してみてはと思います。

This post made by @cheez_RPA received 2 likes!

オーケストレータで管理しているライブラリ（WF部品）の一斉更新

はい。 前者についてはそのようなイメージと（ドキュメントを読む範囲で）理解していますが、実際の挙動はお試しいただければと思います。 後者ですが、フォルダに対して適用可能な単位での権限設定になります。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

IE11 BOM Explorerのデバッガーに表示される ソースコードの全テキストを取得したい

こんにちは 時間のかかっているアクティビティの[ターゲット]-[準備完了まで待機]プロパティをNONEにして試してみてはと思います。

This solution provided by @jeevith received 2 likes!

Elastic search kibana and uipath orchestrator

Hi @Varun_Dharni, You can learn more on how to call different endpoints in the Orchestrator API here: UiPath Connector Guide I could not find a good enough video on youtube which shows you how to get robot logs. But I recommend you refer to @Cristian_Negulescu, ( for example, Start UiPath Process from Postman ON Premise (Orchestrator API) - YouTube) he goes into details on how to use both Cloud and On-Premises orchestrator APIs using Postman and Python. Learning how to use the API is a good i…

This solution provided by @Yoichi received 1 likes!

データスクレイピングが出来ない

こんにちは 取り急ぎ、データテーブルを出力アクティビティあたりにブレークポイントを設定して デバッグ実行→データテーブルを出力アクティビティで停止しますので、 その時の変数をローカルパネルで確認（ExtractDataTable) 問題なければF11キーまたはStep Intoで処理を１つ進めて、この処理が正しくできているかを ローカルパネルで確認(variable1の内容の確認） といった具合に、何が問題かを順を追って確認した方が良いかと思います。

---

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.