Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 May 2023

Top 3 Topics with Most Views

For Each Loop in 2023.4.1 made by @abhay-b with 48 views.

I have two different questions made by @Pujari_Manjunatha with 48 views.

Read pdf activites made by @RACHEL_PAUL with 46 views.

Top 3 Topics with Most Replies

Facing issue while using For Each Loop to retrieve email attachments made by @saleem_sheik1 with 24 replies.

How to compare data in a column if it matches with ADMN word should write same word in another column.Can anyone help me please it's Urgent made by @sandhyareddy with 20 replies.

How to get the row item which is associated with other column made by @geetanjali.nerlekar with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 91 posts!

@adiijaiin made 42 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

How to filter datatable based on Date using LINQ

Im back with one more solution to our day to day issue in RPA programming. i.e., How to filter datatable based on Date using [#LINQ] [Filter - DataTable - Based On Date | How to convert string to Date]

This post made by @mkankatala received 2 likes!

I need to know if Cv Activities need an active screen to do automation?

Hi @YashBiswakarma When will you use the UI activities in development of the program. When the bot runs the UI element has to be appear on the screen. Weather you use in citrix applications (CV activities) or any desktop applications. Hope it helps!!

This post made by @Yoichi received 2 likes!

How to use PadLeft with Replace(",","").Replace(".","") correctly

Hi, If comma is thousand separator and dot is decimal point, the following expression might be better. Math.Floor(Double.Parse(limit,System.Globalization.NumberStyles.Any)).ToString().PadLeft(9,"0"c) [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

I need to know if Cv Activities need an active screen to do automation?

Hi @YashBiswakarma When will you use the UI activities in development of the program. When the bot runs the UI element has to be appear on the screen. Weather you use in citrix applications (CV activities) or any desktop applications. Hope it helps!!

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

Try-catch activity, loop breaks when don't find a match

@rathi.sham problem is you are not catching any exception hence it will break click add new catch [image] click system.exception [image] then it should work

This solution provided by @mkankatala received 1 likes!

CV Screen Scope Error while performing CV activities

Hi @YashBiswakarma The CV Screen Scope activity is used to perform computer vision operations within a specific application or window. It requires the target application or window to be in the foreground so that it can accurately capture and interact with the elements on the screen. Hope it 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 | 19 May 2023

Top 3 Topics with Most Views

Is there anybody who can help me in that error? made by @170290064 with 65 views.

Need 516250 from the text made by @Pujari_Manjunatha with 61 views.

How I can write combine data of three columns in new column like this made by @Swarit_Goyal1 with 49 views.

Top 3 Topics with Most Replies

Is there anybody who can help me in that error? made by @170290064 with 16 replies.

I want to extract only @gmail.com and want to remove entire data. Can anyone help me please. It's Urgent made by @sandhyareddy with 15 replies.

I'm not being able to export variable values in to data table after navigating trough each url from a csv file made by @Subhani with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@arjunshenoy made 18 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Yashin_Sayed received 3 likes!

Cannot encrypt UiPath.Orchestrator.dll.config section

Hi @Lucca, We were facing a similar issue while encrypting the orchestrator.dll.config for 22.10 version. After encrypting the SecureAppSettings successfully, we were not able to encrypt ConnectionStrings. Our issue was, after initial encryption or decryption is successful, the “configsection” closing parameter position is getting misplaced in the dll.config file. So the next encryption/decryption fails saying “Object reference not set to an instance of an object” as below. [MicrosoftTeams-i…

This post made by @170290064 received 2 likes!

Is there anybody who can help me in that error?

Thanks a lot for everybody. Problem is solved Like i said i am the beginning of that journey. I appreciate all answers and huge respect for @Yoichi and thanks @Parvathy @fernando_zuluaga . I know i am new in this area but i believe that i am a quick learner. All the best with you all

This post made by @Swarit_Goyal1 received 1 likes!

How I can write combine data of three columns in new column like this

Can you guide how I can use this approach, If possible please upload xaml

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Add columns in data table

Hi, Can you try the following? [image] io_dtModifiedExtractedFile.Columns("NewRowNo").SetOrdinal(3) io_dtModifiedExtractedFile = io_dtModifiedExtractedFile.AsEnumerable.Select(Function(r) io_dtModifiedExtractedFile.Clone.LoadDataRow({r(0),r(1),r(2),Cint(r(2))+2,r(4),r(5),r(6)},False)).CopyToDataTable() Sample20230512-3.zip (15.3 KB) Regards,

This solution provided by @natanael.mendes received 1 likes!

Orchestrator doesnt load

maybe your local time is wrong and this is conflicting with your orchestrator

This solution provided by @fernando_zuluaga received 1 likes!

How to remove or no fill an excell cell color?

Hi @Suastrian_Dika Give a try using the Format Cells Activity [image] Regards

---

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

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

[system]

Daily Forum Report | 20 May 2023

Top 3 Topics with Most Views

Add Column in data table with modified value made by @ashwini.mali with 40 views.

Capture the element in the children window made by @jackie.yue with 37 views.

Read range(Settings and Constants sheets) made by @170290064 with 34 views.

Top 3 Topics with Most Replies

Add Column in data table with modified value made by @ashwini.mali with 20 replies.

Read range(Settings and Constants sheets) made by @170290064 with 17 replies.

Orchestration Process (Foreground and Background issue) made by @anusha2 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@ushu made 19 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

How to Merge cells and sum values if rows are same

Hi, Hope the following sample helps you. [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.First()(1),g.First()(2),g.Sum(Function(r) CInt(r("Amount")))},False)).CopyToDataTable Sample20230520-4L.zip (7.0 KB) Regards,

This post made by @Anil_G received 1 likes!

How to Merge cells and sum values if rows are same

@sathish_Kumar6 Read the data in to a datatable dt…now use below in the assign activity Use Build datatable activity with outdt and 4 columns as strings outdt = (From d In Dt.AsEnumerable() Group d By k=d("Name").toString.Trim Into grp = Group Let gSum =grp.Sum(function(x) CDBL(x("Amount").ToString).ToString Let ra = New Object(){k,grp.FirstOrDefault(1).ToString, grp.FirstOrDefault(2).ToString,gSum} Select r = outDt.Rows.Add(ra)).CopyToDataTable() Cheers

This post made by @Yoichi received 1 likes!

Read range(Settings and Constants sheets)

Hi, This error shows Config.xlsx is already opened. So, can you try either of the following? Use UseExcelFile and RearRangeX instead of ReadRangeWorkbook. or Close Config.xlsx before the ReadRangeWorkbook. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to Merge cells and sum values if rows are same

Hi, Hope the following sample helps you. [image] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.First()(1),g.First()(2),g.Sum(Function(r) CInt(r("Amount")))},False)).CopyToDataTable Sample20230520-4L.zip (7.0 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Could not Download Attachments from Gmail

@TienGiang Please check the retrieve attachments property in the for each email activity [IMG_5776] Hope this helps Cheers

This solution provided by @Yoichi received 1 likes!

Read range(Settings and Constants sheets)

Hi, First set empty at Range property of ReadRange [image] Next, the following OrchestratorQueueFolder data causes error. For now can you try to set empty? [image] Regards,

---

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

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

[system]

Daily Forum Report | 21 May 2023

Top 3 Topics with Most Views

Uipath sort file names based on alpha numberic names made by @mihir.s.bandodkar with 38 views.

Move file functionality failing in latest version 2023.4.1 made by @alok.verma with 37 views.

Get Current ticket sysid in uipath made by @Kalki with 32 views.

Top 3 Topics with Most Replies

Having trouble downloading zip files to my windows machine from UiPath Learning plans made by @katieward02 with 8 replies.

リスト型変数の重複削除について made by @AAAbbb with 7 replies.

Get Current ticket sysid in uipath made by @Kalki with 6 replies.

Top 3 Users Who Posted The Most

@katieward02 made 6 posts!

@Nitya1 made 5 posts!

@Kalki made 4 posts!

Top 3 Most Liked Posts

This post made by @HANACCHI received 1 likes!

リスト型変数の重複削除について

代入アクティビティ 左辺 結果を格納するlist型変数 右辺 重複削除したい変数.Distinct() でどうでしょう？

This post made by @Yoichi received 1 likes!

リスト型変数の重複削除について

こんにちは 以下お試しください listVar = listVar.Distinct().ToList()

This post made by @Nitya1 received 1 likes!

リスト型変数の重複削除について

Hi @AAAbbb Can you try this- List myList = new List { “A”, “B”, “C”, “A”, “A” }; List distinctList = myList.Distinct().ToList(); Thanks!!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

リスト型変数の重複削除について

こんにちは 以下お試しください listVar = listVar.Distinct().ToList()

---

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 May 2023

Top 3 Topics with Most Views

String Manipulations/Regex made by @JITU99 with 66 views.

How to close Background image made by @Pujari_Manjunatha with 57 views.

How to convert string to Nullable <boolean> in uipath made by @Tuannna1 with 52 views.

Top 3 Topics with Most Replies

How to add multiple column in existing data table made by @ashwini.mali with 24 replies.

How to close Background image made by @Pujari_Manjunatha with 21 replies.

Passing variable into second workflow not working made by @private_matter with 20 replies.

Top 3 Users Who Posted The Most

@Yoichi made 33 posts!

@LAKSHMI_NARAYANA_PEMMASAN made 32 posts!

@adiijaiin made 32 posts!

Top 3 Most Liked Posts

This post made by @Dana_Mustatea received 3 likes!

Rate UiPath and Get Rewarded – Let’s make This Campaign a Huge One!

Rate UiPath until June 5th, and as a thank you for your approved review you will receive a $25 Visa gift card from Gartner. Only the first 100 approved reviews will be rewarded. We encourage you to share this internally, with your colleagues– the more the merrier! Start your review Things to keep in mind: Reviews are anonymous: Your name and company will be private. Only identifying details displayed will be role, industry and organization size The…

This post made by @arjunshenoy received 1 likes!

Studio versioning and upgrade

Hi @Kumar802 You can get the required details from the following resources: https://docs.uipath.com/release-notes/other/latest https://docs.uipath.com/overview/other/latest/overview/compatibility-matrix Hope this helps, Best Regards.

This post made by @Yoichi received 1 likes!

String Manipulations/Regex

I just understood your point. How about the following? [image] [image] Sample20230522-2Lv2.zip (5.1 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

String Manipulations/Regex

I just understood your point. How about the following? [image] [image] Sample20230522-2Lv2.zip (5.1 KB) Regards,

This solution provided by @efelantti received 1 likes!

How to convert string to Nullable <boolean> in uipath

Can you try setting the message to this: <https://translate.google.com/|Google Translate>

This solution provided by @Anil_G received 1 likes!

Make "Click" selector case sensitive?

@Josh_James How much timeout did you give? Try printing straddress and check if its correct and use a ui explorer and see if it is exactly matching no extra spaces and all And you did not add casesentivie 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 | 23 May 2023

Top 3 Topics with Most Views

Regex to extract particular string value from the input String made by @srinusoft37 with 53 views.

$ reference error made by @logesh_kumar1 with 46 views.

DateTime1 made by @honey.123.631 with 46 views.

Top 3 Topics with Most Replies

Outlookメール本文にあるイメージの保存 made by @windntmd with 19 replies.

Regex to extract particular string value from the input String made by @srinusoft37 with 14 replies.

How to extract text and add it to excel starting from specific column to column made by @vnsatyasunil with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 47 posts!

@adiijaiin made 44 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 3 likes!

How to Convert your datatable into array using linq

In this session i have explained on “How to Convert your datatable into array using linq” [Convert-Datatable-To-Array | UiPath]

This post made by @Yoichi received 2 likes!

Outlookメール本文にあるイメージの保存

こんにちは 元の埋め込まれているファイル名が同一になっているのかもしれません。 原因の切り分けの一つとして、添付保存の手前で、代入アクティビティで下記を追加したときに、どのようになるか、確認可能でしょうか？ mailMessageVar.AlternateViews(0).LinkedResources(0).ContentType = New System.Net.Mime.ContentType("application/octet-stream; name=imageX.png")

This post made by @ushu received 2 likes!

Hotkey to Print Email to PDF is not working

Hi @Zulzaili - Please try the below marketplace component

Top 3 Most Liked Solutions

This solution provided by @RAKESH_KUMAR_Tiwari received 2 likes!

Specific cell format

ok, that is resolved, i put some delay before format cell activity.

This solution provided by @ppr received 1 likes!

Regex to extract particular string value from the input String

And with the US rule [grafik]

This solution provided by @Sharath_HK received 1 likes!

Use variable in the excel scope

you can try as mentioned the below [image] here rowCounter is an integer value which holds the row value of the last row.

---

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

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

[system]

Daily Forum Report | 24 May 2023

Top 3 Topics with Most Views

How to take screen Shot of Data Table in excel and Insert this Screenshot in Word File made by @Gopikrishna_S with 54 views.

Aren't we having nested if-else in uipath cross platform? made by @Riya_Bansal with 47 views.

Python scope / How to run python scope made by @sooyeon_Lim with 45 views.

Top 3 Topics with Most Replies

Need to filter Excel Data based on Date made by @Learner007 with 20 replies.

Full job works except reply to email made by @Albin_Johansson with 20 replies.

How to take screen Shot of Data Table in excel and Insert this Screenshot in Word File made by @Gopikrishna_S with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@adiijaiin made 25 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @Jeroen_van_Loon received 3 likes!

Browser Use

I work with different clients and they all use different browsers. And they all work fine with UiPath. So UiPath should not be factored in when choosing a browser. Better to choose the browser in which your site / process / application works best. If my client uses Firefox to open their stuff, then I will build the robots on that as well. So Robot and human interaction stay similair. The main advantage there is that the local IT departments do not have to cope with extra compaibility requirem…

This post made by @adiijaiin received 2 likes!

Extract unique dates from List of dates in Data table

Hi @benjamin.9052 If you need only the unique years from this datatable, here’s the workflow that you can use: Datefilter.xaml (5.4 KB) Dates.xlsx (9.5 KB) expression used here: String filteredYears= actualDates.AsEnumerable.Select(function (x) DateTime.Parse(x(“Dates”).ToString).Year.ToString ).Distinct.ToArray Hope it helps. Thanks Happy Automation!

This post made by @adiijaiin received 1 likes!

Python scope / How to run python scope

There are some things that you put wrong. Also Invoke Python Method would call a function which is created inside your Py file. And I cannot see any function created with OS name in your file. Possibly can you try with Python 3.9 There might be some incompatibility with .NET Runtime version.

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 2 likes!

Extract unique dates from List of dates in Data table

Hi @benjamin.9052 If you need only the unique years from this datatable, here’s the workflow that you can use: Datefilter.xaml (5.4 KB) Dates.xlsx (9.5 KB) expression used here: String filteredYears= actualDates.AsEnumerable.Select(function (x) DateTime.Parse(x(“Dates”).ToString).Year.ToString ).Distinct.ToArray Hope it helps. Thanks Happy Automation!

This solution provided by @fernando_zuluaga received 1 likes!

How to clone or import all arguments to another file?

Hi @lovepong66 You can just select all the arguments from the workflow you want to copy with the ctrl Key pressed and then right click and copy, then go to the secondary workflow in the arguments panel and the just press ctrl + v, this is the single copy paste as always Regards

This solution provided by @Anil_G received 1 likes!

For each row in Dt table with retry scope

@Povilas_Jonikas If the retry scope is around the for each then it will start from first again if it is inside the for each then it will retry on the same iteration and continue or error out according to the retry 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 | 25 May 2023

Top 3 Topics with Most Views

I am unable to export custom activity to UiPath made by @rameespk23 with 52 views.

Organisation Pdf files in google drive made by @noussair_prof with 49 views.

LastModifiedDate on Fileinfo gives error made by @Ninjabullen with 47 views.

Top 3 Topics with Most Replies

How to show output array of string as int32 made by @private_matter with 30 replies.

Microsoft sharepoint/ onedrive Connect Help- ASAP made by @hymasharma.vemavarapu with 18 replies.

Searching_Excel made by @Gokul_Murali with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 89 posts!

@adiijaiin made 33 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

How to add to array

@NISHITHA Please try this Arrayval = System.Text.RegularExpressions.Regex.Replace(str,"(?=[A-Z])",",").Split({","},StringSplitOptions.RemoveEmptyEntries) [image] cheers

This post made by @Yoichi received 2 likes!

'IsNothing' function no longer working in Studio

Hi, For now, can you try to add full namespace as the following? Microsoft.VisualBasic.Information.IsNothing(var) Regards,

This post made by @MEGHA_cs received 2 likes!

RE framework Error convert variable

Hi, Just clear Transaction item and retype “Nothing” or Delete the Assign activity and reassign the same. It will work.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

How to add to array

@NISHITHA Please try this Arrayval = System.Text.RegularExpressions.Regex.Replace(str,"(?=[A-Z])",",").Split({","},StringSplitOptions.RemoveEmptyEntries) [image] cheers

This solution provided by @Yoichi received 2 likes!

'IsNothing' function no longer working in Studio

Hi, For now, can you try to add full namespace as the following? Microsoft.VisualBasic.Information.IsNothing(var) Regards,

This solution provided by @MEGHA_cs received 2 likes!

RE framework Error convert variable

Hi, Just clear Transaction item and retype “Nothing” or Delete the Assign activity and reassign the same. It will work.

---

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 May 2023

Top 3 Topics with Most Views

UiPath & unattended license made by @Meli_Marco with 58 views.

How to pass transaction data in get transaction data without queues? made by @vnsatyasunil with 55 views.

[InfoSet] - LegacyToWindows Migration # Project Blueprint Overview made by @ppr with 49 views.

Top 3 Topics with Most Replies

How to pass transaction data in get transaction data without queues? made by @vnsatyasunil with 27 replies.

Orchestratorでログが表示されない made by @KITAHARA.HATSUMI with 23 replies.

Compare 2 sheets using 2 column names and get the uncommon data from 2 files made by @kambhampati_manisridhar with 22 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@raja.arslankhan made 35 posts!

@adiijaiin made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

[InfoSet] - LegacyToWindows Migration # Project Blueprint Overview

This post is currently in a preview version and will be further updated in the near future. TL:DR UiPath is based on a code platform provided by Microsoft. This code platform has been evolved by Microsoft and support for older versions will be phased out in the future. This creates the need to migrate existing code projects to a more recent version of the code platform - often referred to as Legacy-to-Windows migration. Migrations can cause uncertainties that should be planned for from the …

This post made by @Anil_G received 2 likes!

Remove empty cells, rows and columns

@Kaviyarasu_N If all rows have same number of columns data that is 4 in your case…we can try like this. (From d In dtinput.AsEnumerable() Where Not(d.itemArray.All(function(x) String.IsNullOrEmpty(x.ToString))) Let ra = d.ItemArray.Where(function(x) Not String.IsNullOrEmpty(x.ToString)).Select(function(x) x.ToString) Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Cheers

This post made by @Anil_G received 2 likes!

Copy list to specific datatable column using linq

@qwerty1 In some or the other way you have to use for each to load the data One thing you can try is to use generate datatable activity and pass the list as string concatenated with new line.this will generate a datatable with one column and all the values as rows String.Join(Environment.NewLine,strlist) Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Remove empty cells, rows and columns

@Kaviyarasu_N If all rows have same number of columns data that is 4 in your case…we can try like this. (From d In dtinput.AsEnumerable() Where Not(d.itemArray.All(function(x) String.IsNullOrEmpty(x.ToString))) Let ra = d.ItemArray.Where(function(x) Not String.IsNullOrEmpty(x.ToString)).Select(function(x) x.ToString) Select r = Dtoutput.Rows.Add(ra)).CopyToDataTable() Cheers

This solution provided by @Yoichi received 1 likes!

Rremove the space before the keyword or remove the word from an array of sentences and return the new array

All right. Can you try the following expression? arrRes.Select(Function(s) System.Text.RegularExpressions.Regex.Replace(s,"(?<=\b"+Stringvar1+") (?="+Stringvar2+"\b)| "+Stringvar2+"\b","")).ToArray Regards,

This solution provided by @Yoichi received 1 likes!

Webページからpdfファイルのみをすべてダウンロードする方法

こんにちは ForEachUiElemntを使うか、 https://docs.uipath.com/ja/activities/other/latest/user-guide/n-for-each-ui-element DataScraping(Table Extraction)で表を抽出し それをもとに動的セレクターで順次クリックしていく方法の いずれかが有力かと思います。

---

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 May 2023

Top 3 Topics with Most Views

Downloading pdf files and moving files issue made by @Priyesh_Shetty1 with 42 views.

Convert from Legacy to Windows made by @Snowman with 41 views.

privateGPT with UiPath Robot (personal ChatGPT Project) made by @TonyNudd with 31 views.

Top 3 Topics with Most Replies

Jobs are in Pending State made by @AmlanKiranPatel with 20 replies.

Downloading pdf files and moving files issue made by @Priyesh_Shetty1 with 11 replies.

Html file to pdf file conversion made by @Rounak_Kumar1 with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Nitya1 made 18 posts!

@AmlanKiranPatel made 11 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

UiPath Apps| How To Do An Image Binding in UiPath Apps

[UiPath Apps| How To Do An Image Binding in UiPath Apps]

This post made by @fernando_zuluaga received 1 likes!

Convert from Legacy to Windows

Hi @Snowman To migrate your UiPath project to Windows, you will need to install .NET 6 on your Studio machine. .NET 6 is the default framework for Windows projects in UiPath. Installing .NET 6 will ensure that you have the necessary runtime and libraries to build and run Windows projects in Studio. Regarding running the project on Unattended Robots, you will not necessarily need to install .NET 6 on each robot machine. When you publish your project, the necessary dependencies and runtime will …

This post made by @Snowman received 1 likes!

Convert from Legacy to Windows

Thank you very much for your prompt and detail explanation. Snowman

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

Convert from Legacy to Windows

Hi @Snowman To migrate your UiPath project to Windows, you will need to install .NET 6 on your Studio machine. .NET 6 is the default framework for Windows projects in UiPath. Installing .NET 6 will ensure that you have the necessary runtime and libraries to build and run Windows projects in Studio. Regarding running the project on Unattended Robots, you will not necessarily need to install .NET 6 on each robot machine. When you publish your project, the necessary dependencies and runtime will …

---

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 May 2023

Top 3 Topics with Most Views

Training classifiers and extractors from multiple processes made by @totoro84 with 39 views.

UiPath Apps, Event not triggering, tricky one? made by @Luis_Fernando with 37 views.

Getting an error as "Object reference not set to an instance of an object" made by @vignesh_S.M with 35 views.

Top 3 Topics with Most Replies

Run the whole row activities made by @Carolyna_Elsyana1 with 8 replies.

How to select/check all the items in webpage dynamically made by @rsr.chandu with 8 replies.

ReFramework - Bot keeps repeating the System Exception sequence in Set Transaction Status workflow made by @Chamath_Yapa with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 27 posts!

@Nitya1 made 21 posts!

@Chamath_Yapa made 5 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 1 likes!

Extract Checkbox value from ActiveX checkbox control

Hi @craig.norton Instead of using the “Get Text” activity, which retrieves the label of the checkbox, you can use the “Get Attribute” activity to fetch the value of the checkbox. This activity allows you to extract the value of a specific attribute of an element. Thanks!!

This post made by @Navnit_Ghadigaonkar received 1 likes!

How i get set range color activity in New Uipath Version

Gr8…thanks Its working

This post made by @HensRansen received 1 likes!

Spotify Webapi / HTTP Request Wizard: No token provided

It Works!! Thanks a lot @Anil_G !!

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 1 likes!

Extract Checkbox value from ActiveX checkbox control

Hi @craig.norton Instead of using the “Get Text” activity, which retrieves the label of the checkbox, you can use the “Get Attribute” activity to fetch the value of the checkbox. This activity allows you to extract the value of a specific attribute of an element. Thanks!!

This solution provided by @Anil_G received 1 likes!

ReFramework - Bot keeps repeating the System Exception sequence in Set Transaction Status workflow

@Chamath_Yapa As suspected there is one which is linked to itself…please delete the same [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 | 29 May 2023

Top 3 Topics with Most Views

Compare excel sheet made by @AbarnaKalaiselvam with 73 views.

I had a time in DT. How to add all time values made by @Puneet_Singh1 with 55 views.

Clicking on particular element in DataTable with For Loop made by @WilfredNg with 54 views.

Top 3 Topics with Most Replies

Compare excel sheet made by @AbarnaKalaiselvam with 36 replies.

Want date format from excel in a desired type of date format made by @ankur_kaushik2 with 24 replies.

Unable to start app from mobile made by @kunalmathkar24 with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 101 posts!

@ankur_kaushik2 made 20 posts!

@AbarnaKalaiselvam made 17 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 2 likes!

How to convert Excel to PDF using UiPath Official Packages?

Wanna learn "how to convert Excel to PDF using UiPath Official Packages ? ", check out my latest video on the same!. You can convert your excel file into PDF seamlessly. Topic discussed as follows Problem statement :point_right:Required packages to perform the task :point_right:How to use Excel Save As PDF activity :point_right:Prepare the code and run in LIVE [Convert Excel To PDF | UiPath | Excel Save As PDF Activity]

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

Variable assignment - I have 4 variables but only one variable will always have value.I want a condition in type into activity which types only that variable which has value

Hi @ravig1206 , Use the nested if statement to check if the variable has the value. Eg:- if(not string.IsNullOrEmpty(a),a,if(not string.IsNullOrEmpty(b),b,next condition if any)) Regards,

This post made by @Anil_G received 1 likes!

Take screenshot of entire window including date time stamp on the taskbar in chrome

@sankaran.33 Do not indicate anything in the classic/Modern take screenshot activity then it would take the screenshot of whole screen as you need. Here is the bot screenshot [Test] cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Use contains function in If condition

@Akshat_Sharma1 Please use this Arr1.Where(function(x) str.ToLower.Contains(x.ToLower))(0) The array basically contains only one if only one matched and you can access by index (0) Hope this helps Cheers

This solution provided by @Nikhil_Vernekar received 1 likes!

Find (" ") and replace ("") values in Excel file with 50k+ rows

Excel_Data_Trim.zip (10.3 KB) Attached is the workflow. Let me know if this helps!

This solution provided by @Anil_G received 1 likes!

How to clear excel sheet

@suraj_gaikwad Clear datatable will not work… use clear sheet or Delete file Or Use a different filename always Clear datatablew ill only clear the datatable you are writing but not the excel 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 | 30 May 2023

Top 3 Topics with Most Views

How to extract RAM, ROM, Screen Size, Camera , product name from below 2 string made by @babita with 59 views.

Read range error excel sheet made by @suraj_gaikwad with 52 views.

For Each: Unable to cast object of type “System. Char” to type “System.Net.Mail.MailMessage” made by @Kate-Ketsirin with 44 views.

Top 3 Topics with Most Replies

Covert text to json made by @Hazem_Saleh with 15 replies.

For Each: Unable to cast object of type “System. Char” to type “System.Net.Mail.MailMessage” made by @Kate-Ketsirin with 15 replies.

Need assistance with automating legacy application (Check box) in UiPath's Community forum made by @gibl.rpa with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Yoichi made 59 posts!

@postwick made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How can i delet my account in Uipath

Hi, Please access the following URL then create organization as Community. (we might be able to create it before delete current organization) https://cloud.uipath.com/portal_/register?subscriptionPlan=community&ecommerceRedirect=false Regards,

This post made by @Yoichi received 2 likes!

Help with Regex statement

Hi, Thank you for sharing. This txt file’s linebreak is CR (0x0D) (Old Mac style linebreak). So we need to use the following pattern, for example. Can you try this? System.Text.RegularExpressions.Regex.Match(strData,"(?<=Title:\s).*?(?=[\r\n])").Value Regards,

This post made by @supermanPunch received 2 likes!

Common Items among Three Arrays

Hi @PPIM_RPA , You could maybe try using the Intersect method : array1.Intersect(array2).Intersect(array3).ToArray array1, array2, array3 are variables of type Array of String. Visual : [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How can i delet my account in Uipath

Hi, Please access the following URL then create organization as Community. (we might be able to create it before delete current organization) https://cloud.uipath.com/portal_/register?subscriptionPlan=community&ecommerceRedirect=false Regards,

This solution provided by @Yoichi received 2 likes!

Help with Regex statement

Hi, Thank you for sharing. This txt file’s linebreak is CR (0x0D) (Old Mac style linebreak). So we need to use the following pattern, for example. Can you try this? System.Text.RegularExpressions.Regex.Match(strData,"(?<=Title:\s).*?(?=[\r\n])").Value Regards,

This solution provided by @Yoichi received 1 likes!

How to get all digits by specific pattern by using regex?

Hi, How about the following? [image] Sequence1.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 | 31 May 2023

Top 3 Topics with Most Views

Extract multiple file PDf in one folder to excel made by @mycroft7 with 49 views.

Regex for paragraph made by @Kuldeep_Pandey with 49 views.

No ML Skill available error in ML skill activity for Robot and Endpoint both mode made by @Aakash_Singh_Rawat with 46 views.

Top 3 Topics with Most Replies

Extract multiple file PDf in one folder to excel made by @mycroft7 with 20 replies.

Filter datatable on date range made by @adishjain with 16 replies.

No ML Skill available error in ML skill activity for Robot and Endpoint both mode made by @Aakash_Singh_Rawat with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@arjunshenoy made 24 posts!

@Yoichi made 23 posts!

Top 3 Most Liked Posts

This post made by @adiijaiin received 3 likes!

How to check the time between the 12am to 6am?

Hi @verma.vishal Welcome to the Community! You can use a flow decision or an if condition Now> DateTime.Parse(Now.toString(“MM-dd-yyyy 00:00:00”)) and Now<DateTime.Parse(Now.toString(“MM-dd-yyyy 06:00:00”)) [image]

This post made by @arjunshenoy received 2 likes!

Filter datatable on date range

Hi @adishjain Please give the following query a try: filteredDt = (From row In dt.AsEnumerable() Let documentDate = DateTime.ParseExact(row.Field(Of String)("Document Date"), "dd-MM-yyyy", CultureInfo.InvariantCulture) Where documentDate >= fromDate AndAlso documentDate <= toDate Select row).CopyToDataTable() “Document Date” is the column name of the document date column that you are referring to. Hope this helps, Best Regards.

This post made by @arjunshenoy received 2 likes!

How to check the time between the 12am to 6am?

Hi @verma.vishal, welcome to the Community. You can use the following condition to determine the above specified condition: Now.TimeOfDay >= New TimeSpan(0, 0, 0) AndAlso Now.TimeOfDay < New TimeSpan(6, 0, 0) [image] Hope this helps, Best Regards.

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 3 likes!

How to check the time between the 12am to 6am?

Hi @verma.vishal Welcome to the Community! You can use a flow decision or an if condition Now> DateTime.Parse(Now.toString(“MM-dd-yyyy 00:00:00”)) and Now<DateTime.Parse(Now.toString(“MM-dd-yyyy 06:00:00”)) [image]

This solution provided by @Yoichi received 1 likes!

アクティビティをテストするとエラー/Error when [test activity]「An item with the same key has already been added. Key: NApplicationCard_1」

こんにちは 手元の環境（23.4.1)では特段問題なくTestActivityメニューから実行できました。 となりますとStudioのバージョン要因かもしれません。(23.4でFIXされているのかも）

This solution provided by @Ganesh_Tiwari1 received 1 likes!

Need assistance with automating legacy application (Check box) in UiPath's Community forum

@gibl.rpa if you cannot check the checkbox from header try selecting all check box using while loop and tick using dynamic selectors (make table row dynamic). #CHEERS @UiPath_Community

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

@Yoichi received 72 likes for their solutions!

@Anil_G received 71 likes for their solutions!

@arjunshenoy received 18 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 June 2023

Top 3 Topics with Most Views

Need LINQ expression made by @Mr.Bug_Maker with 67 views.

Excel Unattended made by @odure with 56 views.

Excel Duplication matching made by @Gokul_Murali with 49 views.

Top 3 Topics with Most Replies

Using binary content type in HTTP client made by @aquinn with 23 replies.

Issue with sending Http post request made by @aquinn with 21 replies.

Excel Unattended made by @odure with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@Yoichi made 36 posts!

@aquinn made 27 posts!

Top 3 Most Liked Posts

This post made by @Ahmed_Nizamuddin1 received 3 likes!

I want to extract Fullname of csv file(recent give), starting with "Entity Changes" name (in Screenshot highlighted file)

Hi @Gaurav_Gore , If you’re looking to get the latest file from specific folder then you can use below code. ' Specify the directory path Dim directoryPath As String = "your_directory_path" ' Filter the files by name and extension Dim files As String() = Directory.GetFiles(directoryPath, "entitychangs*.csv").OrderByDescending(Function(f) New FileInfo(f).CreationTime).ToArray() ' Retrieve the latest file Dim latestFile As String = files.FirstOrDefault() ' Check if a file matching the criteri…

This post made by @Ahmed_Nizamuddin1 received 2 likes!

Configファイルの設定を使ってメールを送信したい

你好 @najio， 希望你一切都好。 看起来你正在尝试在主工作流程中的catch块中发送电子邮件，以便在出现异常时发送。 我想提出两种可能的解决方案。 首先，你可以考虑将"Init All Setting.xaml"文件放在"MainWorkflow.xaml"文件之外。这种分离可以更有效地处理异常。 或者，你可以在 Orchestrator 中创建一个资产来存储电子邮件地址。然后，在工作流程中使用"Get Asset"活动来直接从 Orchestrator 中检索电子邮件。 希望这些建议对你有所帮助。如果你有任何进一步的问题或需要额外的帮助，请随时告诉我。 最好的祝福，

This post made by @Yoichi received 2 likes!

How to clone (deep copy) dictionary

Hi, I think your understanding seems mostly correct. Basically, it depends variable type: Value types or Reference types. It’s unnecessary special care to copy Value types such as Int32, Double etc. However, Reference Types such as List, array etc are needed special care (Copy method etc. if they have) to copy deeply. (Without it, it will be shallow copy) Note: String type (and object type) is special type and it behaves like value type when copy even though it’s reference type. Regard…

Top 3 Most Liked Solutions

This solution provided by @Ahmed_Nizamuddin1 received 1 likes!

Preview PDF files from storage bucket isn't rendering in Action Centre (Version 2021.10.3) on-premise

Hi @dotbot , Hope you’re doing well, Firstly, I want to confirm whether you have already completed the necessary CORS steps for your On-Premises installation? These steps ensure that Cross-Origin Resource Sharing is properly configured to allow communication between different domains both (orchestrator & Action center). If you haven’t performed these steps yet, please follow below steps. To configure Orchestrator settings to accept storage bucket requests from Action Center, please follow t…

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

How to get email address without domain using regex

Hi @jrin3753 Welcome to community Check this out System.Text.RegularExpressions.Regex.Replace(yourString.Substring(0,yourString.IndexOf(“@”)),“[^A-Za-z0-9]”,“”)

This solution provided by @MadsV received 1 likes!

Manipulation and concating of data from one Excel sheet to another

I found a way by using row.Item(1).ToString.Replace(system.text.RegularExpressions.Regex.Match(row(1).ToString,“\d+”).Value,“”).Trim and then assigning it to a temporary row so I could get it later. Thanks a lot

---

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

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

[system]

Daily Forum Report | 02 June 2023

Top 3 Topics with Most Views

Active Accessibility stopped working after Chrome update made by @Yameso with 95 views.

Invoke process will not end made by @raven with 56 views.

Uipath worst automation tool made by @robo_007 with 49 views.

Top 3 Topics with Most Replies

System.NullReferenceExceptionが発生した理由 made by @gorby with 26 replies.

Excel reading error made by @suraj_gaikwad with 24 replies.

Invoke process will not end made by @raven with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 99 posts!

@Yoichi made 40 posts!

@raja.arslankhan made 31 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

What is difference between element exist and check app state

@jrin3753 One is a modern activity and other is classic Bot much of difference but one major change is …element exists cannot work for verifying the visibility of the element but check app state can be used to check the visibility of the element as well In classic for checking visibility we had to use find element activity Hope this helps Cheers

This post made by @ppr received 2 likes!

Expressão regular retornando vázio

Handling defensive Windows linebreaks \r?\n

This post made by @Yameso received 1 likes!

Active Accessibility stopped working after Chrome update

Hi, I have a big issue with Chrome Update. I have Studio 22.10.5 and using UiAutomation 22.10.5. Chrome extension is 22.10.6. I was programming some web pages with Active Accessibility option in selector. For. ex. I had to print PDF from some government web page and click button “Save”: [image] It was working with AA option, Default setting was not working at all in that case. After Chrome update extension doesn’t see element in that window. This is just one of the cases I have. Now only po…

Top 3 Most Liked Solutions

This solution provided by @LAKSHMI_NARAYANA_PEMMASAN received 1 likes!

Active Accessibility stopped working after Chrome update

not sure if you have already gave try or it will work in your case but can you give a try append --force-renderer-accessibility along with your url and check if it works Regards

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

What is difference between element exist and check app state

Hey @jrin3753 It’s actually the same, with some few minor feature difference Element exist comes in classic activities Check app state comes in modern design In classic visibility check is not possible…u have to with different activity Both output returns Boolean value and are use to check a specific element whether it exists or not

This solution provided by @Yoichi received 1 likes!

Currentfile.Tostring not working

Hi, Can you try to add () like CurrentFolder.ToString() Regards,

---

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

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

[system]

Daily Forum Report | 03 June 2023

Top 3 Topics with Most Views

Remove 3 lines from txt document made by @vfaundez with 40 views.

How to calculate the Years and Months and Days in Date made by @404_Error with 29 views.

How to stop the bot if a text doesn't exist made by @raju_alakuntla with 29 views.

Top 3 Topics with Most Replies

Uipath create single status report using 3 Bot made by @Shivam_Rana with 12 replies.

Excelファイルの保存に関して made by @Shige2018 with 10 replies.

Excel activities query made by @Suthari_RohithReddy with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@Yoichi made 14 posts!

@Nitya1 made 11 posts!

Top 3 Most Liked Posts

This post made by @raja.arslankhan received 1 likes!

Uipath create single status report using 3 Bot

@Shivam_Rana 1)Make a work flow call this workflow at End process. 2)Make an bool asset and init it with True value. 3) inside work flow get asset value. 4) put if condition and check asset value is True 5) If True then first update asset value as False (So that no other robot will not use this in case of false) 6) now get all files from folder. 7) merge one by one and move in “Processed” folder.( moving will helpful to avoid duplicates in next run) 8) after merge/collate make new in se…

This post made by @Anil_G received 1 likes!

Uipath create single status report using 3 Bot

@Shivam_Rana two options Create a bot to get all status reports and merge and send update the status of all the bots to the queue only in output fields of the queue and create a process to get queue items and create a status report as needed instead of creating individual status reports cheers

This post made by @Anil_G received 1 likes!

How to use queue by Using 3 Bot on a single flow

@Shivam_Rana My bad it should be dt.AsEnumerable.Skip(assetcount).Take(100).CopyToDataTable Missed .AsEnumerable Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Get only one value from cell from datatable

Hi, How about the following? [image] Sample20230603-1aL.zip (11.7 KB) Regards,

This solution provided by @Anil_G received 1 likes!

Lookup Value in DT and delete all the rows

@Sathish_Kumar_S Use find/Replace activity and search for Cancellations… This would give the cell value as output now use delete rows activity with specific rows option and give the rows like this System.Text.RegularExpressions.Regex.Match(cellvalue,"\d+").Value + "-" + (Excel.sheet("Sheetname").RowCount+1).ToString If in datatable please try this dt.AsEnumerable.Take(dt.Rows.IndexOf(dt.AsEnumerable.Where(function(x) x(0).ToString.Contains("Cancellations"))(0))-1).CopyToDataTable 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 | 04 June 2023

Top 3 Topics with Most Views

Pdf Automation AI Center On-Prem Orchestrator Learning Help made by @Iswarya_P1 with 50 views.

REFramework Global Variables made by @ivette_lugo with 44 views.

How to handle unexpected pop up in automation made by @babita with 37 views.

Top 3 Topics with Most Replies

Pdf Automation AI Center On-Prem Orchestrator Learning Help made by @Iswarya_P1 with 9 replies.

How to handle unexpected pop up in automation made by @babita with 8 replies.

How to replace date format quickly for two columns in data table variable? made by @sathish_Kumar6 with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 11 posts!

@Yoichi made 10 posts!

@Nitya1 made 5 posts!

Top 3 Most Liked Posts

This post made by @Nitya1 received 2 likes!

Restrict orchestrator API calls per user

Hi @Camila_Caldas To restrict API calls per user in Orchestrator: 1.Define roles with specific permissions that align with the desired level of API access for each user. You can assign these roles to users or groups in Orchestrator. 2.Set up Role-Based Access Control in Orchestrator. RBAC allows you to control what users or roles can do within Orchestrator, including API access. Assign the appropriate roles to each user based on their responsibilities and required level of API access. User…

This post made by @nogamikim received 1 likes!

WinActortonoと比較したマーケティングの失敗

UiPathが優れている製品であることは、理解していますが、RPAの内容も知らないBigginerにプロセスの自動化のための高邁なお説教を延々ときかされても、なにもメリットを感じないはずです。改善は現場の人間が行うことが最も必要なハズですが、そこを見落として、アカデミーのプログラムを作成をしていると思います。 トヨタやTOCというコンセプトを理解してから、Marketing戦略を組む必要があると思います。

This post made by @Anil_G received 1 likes!

カーソルの移動方法を教えてください

@allbran If you want to only move the mouse pointer to some location then use hover activity and set input mode to hardware events If you want to perform a click also then you can use click activity and again with input mode as hardwareevents Cheers

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 2 likes!

Restrict orchestrator API calls per user

Hi @Camila_Caldas To restrict API calls per user in Orchestrator: 1.Define roles with specific permissions that align with the desired level of API access for each user. You can assign these roles to users or groups in Orchestrator. 2.Set up Role-Based Access Control in Orchestrator. RBAC allows you to control what users or roles can do within Orchestrator, including API access. Assign the appropriate roles to each user based on their responsibilities and required level of API access. User…

This solution provided by @Yoichi received 1 likes!

カーソルの移動方法を教えてください

こんにちは そうであればホーバーアクティビティを使い、入力モードをハードウェアイベントにします。必要に応じてカーソルの動きの種類を設定。より細かい座標を指定するときは、クリックのオフセットを有効にして、設定を行います。 [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 | 05 June 2023

Top 3 Topics with Most Views

Edgeブラウザで名前を付けて保存が選べない made by @minami with 91 views.

Not able to click on Save As pop up in edge browser made by @vishal_nachankar with 79 views.

Selectors inside inspect element stopped working after new chrome update made by @manojj.yadav with 54 views.

Top 3 Topics with Most Replies

Quick Question! made by @170290064 with 24 replies.

Hi please help me with extract types of clauses using regex in the given word made by @praveena.nadi with 20 replies.

Filter Data Table: the value for argument 'Column Name' is not set or is invalid, filter table issue made by @lakshmi.mp with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 86 posts!

@raja.arslankhan made 27 posts!

@Yoichi made 24 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

@minami Open ui explorer and change the framework to active accessibility and then try to indicate the element [image] you can as well check the visual tree on the left to see if the element is identified or not…sometimes if if not identified it would be available in visual tree and you can select from there right click and use set as target element… cheers

This post made by @Yoichi received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

もう少し深堀してみたところ、 最初はダウンロードの枠のみしか選択できない →そのまま枠をターゲット要素として選択 →アンカー選択時に内部の各要素を選択できるようになる →一旦アンカー含めて確定する →再度要素を取り直すと、以降は問題ないようです。 一度21.10の環境でも試してみてはと思います。

This post made by @Anil_G received 2 likes!

Ask where to save each file before downloading button isn't working anymore in google chrome

@Ush_Dhar Keep the activity which download the file inside a wait for downlod activity…and wait for download has a output which will give the file which is downloaded… [image] Also I have checked and you can use this selector change framework from ui explorer and it is working [image] <wnd app='chrome.exe' cls='Chrome_WidgetWin_1' title='Settings - Downloads - Google Chrome' /> <ctrl name='Settings - Downloads' role='document' /> <ctrl name='Ask where to save each file before downloading…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

@minami Open ui explorer and change the framework to active accessibility and then try to indicate the element [image] you can as well check the visual tree on the left to see if the element is identified or not…sometimes if if not identified it would be available in visual tree and you can select from there right click and use set as target element… cheers

This solution provided by @arjunshenoy received 1 likes!

Relationship between the number of documents and the training time

Hi @Konrad_Mierzwa The number of data used in training a pipeline seems to be a factor that significantly increases the training time. Since the default epoch value is set to 100, some more factors such as the complexity of the document, its digitization & number of labels also make some impact. Using GPU will reduce this time but is gonna consume a lot of AI units depending upon your use case. Hope this helps, Best Regards.

This solution provided by @arjunshenoy received 1 likes!

How to get the datarow with the lowest value from datatable

Hi @richardvh, welcome to the Community. You can try this expression: DriverRow = dt_F1.AsEnumerable().OrderBy(Function(row) CInt(row("Points"))).First() The First() method to retrieve the first row from the sorted DataTable, which will be the DataRow with the lowest value in the Points column. Finally, we assign the result to the variable DriverRow. Edit: Output will be like- [image] Hope this helps, Best 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 | 06 June 2023

Top 3 Topics with Most Views

Broken selectors after Chrome/Edge update to version 114.0.1823.37 made by @Luiza_Surdu-Bob with 235 views.

UiPath Edge Extension can no longer sense or interact with the Save As Button within Edge PDF Viewer made by @taxguy33 with 88 views.

Active Accessibility(AA) is not available Suddenly made by @Kathiravan with 88 views.

Top 3 Topics with Most Replies

Problem with Browser Automation made by @Julian3 with 13 replies.

配列ないの値を分割したい made by @natsumikan with 12 replies.

Need to click the dynamic data on scroll box made by @sandhya.govindharam with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 60 posts!

@Yoichi made 38 posts!

@argin.lerit made 14 posts!

Top 3 Most Liked Posts

This post made by @Luiza_Surdu-Bob received 8 likes!

Broken selectors after Chrome/Edge update to version 114.0.1823.37

The latest Chrome and Edge updates (114.0.1823.37) introduced a breaking change to the way support for Active Accessibility is enabled. This causes automation processes to fail when trying to interact with the following browser screens: Print popup PDF viewer Observed behavior Following the browser update, it is no longer possible to identify web elements using Active Accessibility (AA) mode with UIAutomation activities. Example of selector that no longer works because of this issue: <wnd…

This post made by @karanpvsr received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone, Good to be in the community, I am an IT Professional with 6+ years of work experience on various products alongside Solution Architecture of RPA (Robotic Process Automation) specifically in UiPath. I have graduate in my Masters in Management Information Systems at University at Buffalo Recently and I am looking for new opportunities where I can employ my expertise to create and contribute to automations based on UiPath in an organization. I hope I can learn and contribute furt…

This post made by @manojj.yadav received 3 likes!

Selectors inside inspect element stopped working after new chrome update

Hi, Just contacted UiPath support and they mentioned that after recent update for Google Chrome/Microsoft Edge (from old version to114.x.x.x) the selector which contains “< wnd >” and “< ctrl >” tags have stopped working. Then this means Active Accessibility support is broken and issue is from Chrome side. We can use --force-renderer-accessibility along with your URL or provide it as an argument to access those tags again in dev region. But the issue is, there are already running bots in produc…

Top 3 Most Liked Solutions

This solution provided by @postwick received 2 likes!

Get Email Query Categories

This solution provided by @Yoichi received 2 likes!

Edgeブラウザで名前を付けて保存が選べない

FYI 本件に関するナレッジベース公開された模様です。

This solution provided by @postwick received 1 likes!

How to convert the text file data to datatable or excel file?

Read Text File into a string variable. Split on VbCrLf + VbCrLf (basically split on every blank line) Now you have an array of the records. Then you can For Each through the array and split each one on VbCrLf. Using Add Data Row, your array(0) will be Name and array(1) will be Age. You can just use Replace to get rid of "Name " and "Age " each time.

---

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.