Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 July 2024

Top 3 Topics with Most Views

Delete last rows made by @Stef_99 with 24 views.

Nsert an picture into an Excel file made by @phuc_trinh with 22 views.

Error when publishing from studio made by @yapheming34 with 21 views.

Top 3 Topics with Most Replies

Nsert an picture into an Excel file made by @phuc_trinh with 25 replies.

Switch tabs in browser made by @RPA_NOZAMA with 15 replies.

Write text (green flag) made by @Stef_99 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 44 posts!

@vrdabberu made 23 posts!

@mkankatala made 23 posts!

Top 3 Most Liked Posts

This post made by @Krishna_Raj received 1 likes!

Monthly Forum Rewards - June 2024

Congratulations Everyone

This post made by @mkankatala received 1 likes!

How to get distinct value from Text File?

Okay @myakkhaing Try the below expression in For each activity, strEmailAddress.Cast(Of System.Text.RegularExpressions.Match)().Select(Function(X) X.ToString().ToLower().Trim).ToList().GroupBy(Function(Y) Y.ToString()).Select(Function(grp) grp.First()).toarray() Hope it helps!!

This post made by @mkankatala received 1 likes!

Question about Data Table and Add Data Row Acitivity

FileList is the array of string variable right, that’s why it was printing like that… @Pour_Medi The variables you are passing in the add data row should be in string format. Hope you understand!!

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

How to get distinct value from Text File?

Okay @myakkhaing Try the below expression in For each activity, strEmailAddress.Cast(Of System.Text.RegularExpressions.Match)().Select(Function(X) X.ToString().ToLower().Trim).ToList().GroupBy(Function(Y) Y.ToString()).Select(Function(grp) grp.First()).toarray() Hope it helps!!

This solution provided by @vrdabberu received 1 likes!

Delete last rows

Hi @Stef_99 Check the below attached screenshots for better understanding: [image] Regards

This solution provided by @vrdabberu received 1 likes!

Separate value of same cell but different row into respective cell?

Hi @Michael_L Please check the below xaml: Sequence40.xaml (29.7 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 July 2024

Top 3 Topics with Most Views

'Config' is not declared. It may be inaccessible due to its protection level made by @jacomien.bekker with 29 views.

条件分岐で、最初の文字列が小文字の数字なら made by @kiki1 with 20 views.

Click text activity problems made by @Povilas_Jonikas with 18 views.

Top 3 Topics with Most Replies

Chrome browser API made by @AsadPathan2665 with 18 replies.

Activity to check whether check box is checked or not made by @amanda.gondim with 13 replies.

'Config' is not declared. It may be inaccessible due to its protection level made by @jacomien.bekker with 11 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 26 posts!

@mkankatala made 25 posts!

@Yoichi made 22 posts!

Top 3 Most Liked Posts

This post made by @DimitriLYR received 2 likes!

Up-to-date on the latest of the UiPath Platform? Check with our Quiz! Win your Badge!

[image]

This post made by @adiijaiin received 1 likes!

Monthly Forum Rewards - June 2024

Congratulations Everyone.

This post made by @mkankatala received 1 likes!

Monthly Forum Rewards - June 2024

Congratulations Each and Everyone…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

コミュニティ版のUiPath Studioがインストールできません。

事象が以下に類似していますので一旦同様の方法で解消できないか確認いただけないでしょうか？

This solution provided by @lrtetala received 1 likes!

Error Could not load file or assembly

Hi @Stef_99 Can you try to upgrade UiPath.System.Activities Package Regards,

This solution provided by @ppr received 1 likes!

Syntax help in linq

never ommit AsEnumerable give a retry at (From row in dtInput.AsEnumerable Group row by k=row("Trade Date").toString.Trim into grp=Group Select r=grp.First()).CopyToDataTable

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

@mkankatala received 43 likes for their solutions!

@ashokkarale received 31 likes for their solutions!

@bavyaravu133 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 August 2024

Top 3 Topics with Most Views

How to extract specific value made by @Smitesh_Aher2 with 31 views.

How to use URL made by @mint with 30 views.

Problem With Modern Application activities made by @vinni_s1 with 27 views.

Top 3 Topics with Most Replies

Excel Filter and CurrentIndex out of Sync made by @related-robot with 19 replies.

Delete row by condition made by @Stef_99 with 16 replies.

Compare and merge datatables using linq made by @Raju23c with 14 replies.

Top 3 Users Who Posted The Most

@ppr made 21 posts!

@lrtetala made 21 posts!

@Anil_G made 18 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 2 likes!

Monthly Forum Rewards - June 2024

Congratulations to all the winners

This post made by @0502kmnmzsrski received 2 likes!

コミュニティ版のUiPath Studioがインストールできません。

タスクスケジューラを確認し該当箇所を削除したところ、無事にインストールすることができました。 ありがとうございました。

This post made by @pravallikapaluri received 1 likes!

Delete row by condition

Hi @Stef_99 [image] or [image] Excel.Sheet("Sheet1").Range("A3:C" + (Excel.Sheet("Sheet1").RowCount + 1).ToString()) Hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Help Convert sql query into linq

Hi @TUSHAR_DIWASE Try this: dtResult = (From internalRow In internalTable.AsEnumerable() Join qualityRow In qualityTable.AsEnumerable() On internalRow.Field(Of String)("Name") Equals qualityRow.Field(Of String)("Name") And internalRow.Field(Of DateTime)("trade date").ToString("MM/dd/yyyy") Equals qualityRow.Field(Of DateTime)("trade date").ToString("MM/dd/yyyy") Where internal…

This solution provided by @lrtetala received 1 likes!

Install UiPath Studio in Mac

Hi @Dutta_Mainak Check the below thread Regards,

This solution provided by @ppr received 1 likes!

How can we pass boolean variable into http request body(JSON Format)?

"{""empid"":""123"",""‘isemployee"": " + YourBoolVar.ToString.ToLower + "}" UPD1 - JSON Approach hint: For sure we can parse the JSON String / Json Template … into JOBject and set the value by a variable with using JSON API e.g. Newtonsoft

---

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 August 2024

Top 3 Topics with Most Views

How to split multiple value in a cell to multiple cells? made by @yangyq10 with 28 views.

Migration from windows to legacy made by @amruthageorge58 with 26 views.

HTTP要求を使ってpresignedUrlをエンドポイントに添付ファイルをPOSTしたい made by @Junya_Koyama with 16 views.

Top 3 Topics with Most Replies

How to split multiple value in a cell to multiple cells? made by @yangyq10 with 19 replies.

Getting file error-The source file does not exist made by @marina.dutta with 17 replies.

Migration from windows to legacy made by @amruthageorge58 with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 18 posts!

@mkankatala made 16 posts!

@ashokkarale made 15 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

IMAP Invalid Credentials Error Despite Correct Configuration

Hi @Aakash_Sharma4 Check the below thread Regards,

This post made by @Anil_G received 2 likes!

Captcha extraction

@Prasaanth_S2 The main idea of captcha is to make robots not pass it…better not to try read it as it would be unsuccessful or with a very low successrate Instead try to have a human intervention in between may be by creating an action or sending email to reaolve and then continue accordingly Much better would be to ask the application team for service account if that is a viable case Cheers

This post made by @nithya received 1 likes!

How to upload files to AWS S3 Bucket

Hi, I am new to this scenario. Could you please help me in the process how to upload files to AWS S3 Bucket. I have following details with me -->S3 Bucket, Service User,Service User Access Key Id,Service User Secret Access Key Thanks in advance.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 2 likes!

IMAP Invalid Credentials Error Despite Correct Configuration

Hi @Aakash_Sharma4 Check the below thread Regards,

This solution provided by @pravallikapaluri received 1 likes!

Validation_Both_Tables

Hi @Balachander_Pandian ' Step 1: Read the Excel sheets into DataTables dtSheet1 = Read Range activity to read "Sheet1" dtSheet2 = Read Range activity to read "Sheet2" ' Step 2: Calculate the sums using LINQ SumSheet1 = dtSheet1.AsEnumerable().Sum(Function(row) Convert.ToDecimal(row("Total Amount"))) SumSheet2 = dtSheet2.AsEnumerable().Sum(Function(row) Convert.ToDecimal(row("Total Amount"))) ' Step 3: Compare the sums If SumSheet1 = SumSheet2 Then ' Continue with the next workflow Else …

This solution provided by @ppr received 1 likes!

Where to find string icon?

maybe check for a different version, when icons are supported by the forms

---

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 August 2024

Top 3 Topics with Most Views

"Break" activity in loop (Excel) made by @Chris_Balance with 15 views.

How can I extract the specific string "Below Average" from an image using OCR, given that it consistently appears near the phrase "Earning Potential"? made by @Nasar with 14 views.

How to hide Uipath Extenstion notifications from Chrome? made by @ajay.daule with 12 views.

Top 3 Topics with Most Replies

"Break" activity in loop (Excel) made by @Chris_Balance with 11 replies.

Excel As Database without column header made by @Sharanabasava with 10 replies.

UI Edge clicks made by @A_Learner with 7 replies.

Top 3 Users Who Posted The Most

@mkankatala made 13 posts!

@pravallikapaluri made 6 posts!

@shivanipawar made 6 posts!

Top 3 Most Liked Posts

This post made by @rlgandu received 1 likes!

UI Edge clicks

@A_Learner Then use Retry Activity ,In the retry scope put the Click activity

This post made by @ajay.daule received 1 likes!

How to hide Uipath Extenstion notifications from Chrome?

Wow, It’s working now. Thank You so much for you help. @mkankatala

This post made by @pravallikapaluri received 1 likes!

How to hide Uipath Extenstion notifications from Chrome?

Hi @ajay.daule Check the below thread Hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

How to hide Uipath Extenstion notifications from Chrome?

Hi @ajay.daule The best way I found without going to PowerShell/command prompt is to just navigate to Home → Tools → UiPath Extensions → (Change from current user to) Group Policy Online. You will not see the debugging pop-up anymore. Hope it helps!!

This solution provided by @pravallikapaluri received 1 likes!

Install Packages - run time rule

Hi @A_Learner The Strict runtime rule is the default state for dependencies added upon process creation, and for activities packages installed from the Manage Packages window. It means that only the specified version of the package is used at runtime to execute the parent process. The Strict rule is marked in the Project panel, under Dependencies by the [image] sign next to the package version. The Lowest Applicable Version runtime rule means that if the target package isn’t found, the next hi…

This solution provided by @Nawazish_Ahmad received 1 likes!

Outlook Mail Datw

Hi @SP_Bot Follow this: Hope it helps!! Happy Automation

---

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 August 2024

Top 3 Topics with Most Views

Uipath for each made by @Pavan_kumar_Bendadi with 19 views.

How to create the summary report? made by @naveen.s with 17 views.

Help with LINQ Query to Group and Sum Data in DataTable made by @Islam_ISmail with 15 views.

Top 3 Topics with Most Replies

Hello, i need some help with Microsoft Outlook made by @mohamed.saty2012 with 11 replies.

Uipath for each made by @Pavan_kumar_Bendadi with 9 replies.

Help with LINQ Query to Group and Sum Data in DataTable made by @Islam_ISmail with 8 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 15 posts!

@mohamed.saty2012 made 6 posts!

@postwick made 4 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 2 likes!

Help with LINQ Query to Group and Sum Data in DataTable

@Islam_ISmail, Don’t have the data to test but can you try this. Dim resultTable As DataTable = dtDepGrouped.AsEnumerable() _ .GroupBy(Function(row) row("GroupColumn").ToString()) _ .Select(Function(grp) Dim firstRow = grp.First() Dim sumValueColumn = grp.Sum(Function(r) Convert.ToDouble(r("ValueColumn"))) dtDepGrouped.Rows.Add({ firstRow("IDColumn").ToString(), firstRow("CategoryColumn").ToString()…

This post made by @Niranjan_Mahtole received 2 likes!

How to convert ilocalResource to IResource

You can use below function to convert the File into LocalResource LocalResource.FromPath(“C:\Users\niranjan\Downloads\[Untitled].pdf”)

This post made by @ashokkarale received 1 likes!

Hello, i need some help with Microsoft Outlook

@mohamed.saty2012, It seems there is one additional step we will have to take here. We will have to get the Email through Id and then pass that email as object to the Move Email activity like this. [image] Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Hello, i need some help with Microsoft Outlook

@mohamed.saty2012, It seems there is one additional step we will have to take here. We will have to get the Email through Id and then pass that email as object to the Move Email activity like this. [image] Thanks, Ashok

This solution provided by @ashokkarale received 1 likes!

How to create the summary report?

@naveen.s, Follow this approach. Build a datatable to store all the transaction items data in Init First time run. Here I have repurposed the the predefined dt_TransactionData variable available in ReFramework Template. [image] [image] Now Datatable to store transaction details is ready, lets add logic to add transaction details. We will be using 3 Add Data Row activity to add the transaction data. A. Success: Process Transaction State here [image] Add Row [image] B. Business …

---

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 August 2024

Top 3 Topics with Most Views

Close Popup activity without Use Application/Browser made by @jjes with 26 views.

Linq Help to Convert SQL made by @TUSHAR_DIWASE with 23 views.

A method to count numbers made by @PARK_Bin with 21 views.

Top 3 Topics with Most Replies

I'm getting an error message when invoking ACME_Open workflow made by @Andrew_Spence with 15 replies.

UI PATH APPS - How to use Contains Function in Ui path APPS made by @sayali.p with 12 replies.

Which technology UiPath use under the hood for Web Automation? made by @indiedev91 with 12 replies.

Top 3 Users Who Posted The Most

@postwick made 20 posts!

@mkankatala made 17 posts!

@ashokkarale made 16 posts!

Top 3 Most Liked Posts

This post made by @katta_nikhil received 1 likes!

Need regex or string manipulations or logic

hi team, i have a address like 3508 S LaFountain St Kokomo, IN 46902 above string is the address … so every time the address will change based on the user… so i need a output like - 3508 S LaFountain St which is before comma(“,”) i need to avoid … can i get the solution please

This post made by @naveen.s received 1 likes!

V22 Test automation

@A_Learner, Try below: UiPath Test Suite Overview - Test Automation in UiPath You can also refer in Udemy as well

This post made by @naveen.s received 1 likes!

Which technology UiPath use under the hood for Web Automation?

@indiedev91 UiPath depends heavily on the Microsoft UI Automation framework (part of the .NET framework) for interacting with and automating Windows desktop applications. This library provides a rich set of APIs to work with UI elements and controls programmatically.

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Segregate file with equal/almost same quantity

dtData = your DataTableVar BotCount = 3 RowCount = DataTableVar.Rows.Count Assign Activity: TableList | List(Of DataTable) = dtData.AsEnumerable.Chunk(CInt(Math.Ceiling(RowCount / BotCount))).Select(function (x) x.CopytoDataTable).toList [grafik] [The image shows a code output of a list containing three data tables where the first two tables are expanded to show rows of sequential numbers in a single column, and the third table is empty. (Captioned by AI)] Then loop over TableList and …

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

Pagination in Orchestrator

$top This clause helps you limit the amount of data you retrieve. It has an upper cap that is determined by the endpoint you are making calls to and the number of such resources that exist on you Orchestrator instances. For example, this request /odata/Environments?$top=10 returns the first 10 environments available in the Community Edition of Orchestrator. However, if only 5 environments exist, only those are retrieved. For most of the API endpoints, the limit is 100 due to performance issue…

This solution provided by @Parvathy received 1 likes!

Sixth digit from the sequence

Hi @sullivanne Try this: sequence = "123456789" sixthDigit = sequence.Substring(5, 1) [image] 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 | 06 August 2024

Top 3 Topics with Most Views

Separate value of same cell but different row into matching cell? made by @Michael_L with 30 views.

Get Excel worksheet names without using Excel made by @Clintonnn with 30 views.

How to convert webpage to pdf? made by @VENKATESH2 with 27 views.

Top 3 Topics with Most Replies

Changing account in Getoutlookmailmessage made by @kehew54078 with 13 replies.

Get input from excel sheet and select the check box activity in website made by @Santhosh_Perumal with 12 replies.

Get Outlook Mail Messages: Cannot parse condition. Error at "@SQL=(( urn:schemas:httpmail:subject LIK..." made by @schoi with 11 replies.

Top 3 Users Who Posted The Most

@lrtetala made 31 posts!

@postwick made 22 posts!

@ashokkarale made 18 posts!

Top 3 Most Liked Posts

This post made by @Innomen received 2 likes!

Dead link in the beginner thing

Beginner FAQ located here: Forum FAQ - About Categories contains this dead link: https://forum.uipath.com/c/discover/133 Just trying to help. This is my first post XD

This post made by @postwick received 2 likes!

Uipath for each

It still needs to go back to the old way where we specify the datatype. Making it automatic doesn’t work well. We need control, not to be controlled.

This post made by @Yoichi received 2 likes!

How to get text inside a url?

こんにちは いくつか方法が考えられますが、以下2案いかがでしょうか？ 案１ １．当該ページに遷移 ２．GetTextで対象のテキストをすべて取得（抽出モード等チューニングが必要かもしれません） ３．以下の正規表現で必要な値を抽出 System.Text.RegularExpressions.Regex.Match(yourString,"(?<=ドル,USD,)[\d.]+").value 案２ １．リンクの属性から対象のURLを特定 ２．ファイルをURLからダウンロードアクティビティを用いて、対象をダウンロード ３．ダウンロードしたファイルをReadTextFileアクティビティで読み込み ４．以下の正規表現で対象を抽出 System.Text.RegularExpressions.Regex.Match(yourString,"(?<=ドル,USD,)[\d.]+").value

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Get input from excel sheet and select the check box activity in website

Hi @Santhosh_Perumal Follow the below steps, Use the For each row in datatable activity to iterate the each row in the datatable. Inside for each insert the If condition to check weather it will empty or not. Inside Then block insert Assign activity to store the value in a variable. After Assign activity drag and drop an Click activity and indicate on the First option then open the selector option. Then open the Ui explorer and Check the aaname or visibleinnertext attribute. Then you can pass…

This solution provided by @Yoichi received 1 likes!

カレンダーで一日前の日付を選択する方法について

こんにちは 基本的にはクリックアクティビティを使います。 実際にセレクターを取得してみないと確かなことは言えませんが、昨日の日付を算出してそのあたいを例えばaaname属性に動的に指定することになると思います。 月をまたぐとき（当日が1日の場合）は、その前に前月への遷移ボタンをクリックします。

This solution provided by @ppr received 1 likes!

Extract Date out of text

Regex for the value: [grafik] Assign Activity: strDate = System.Text.RegularExpressions.Regex.Match(yourStringVar,"\d{4}-\d{2}-\d{2}").Value Parsing into datetime: DateTime.ParseExact(strDate,"yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)

---

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

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

[system]

Daily Forum Report | 07 August 2024

Top 3 Topics with Most Views

How to Run a UiPath Process on Another Computer Without Sharing Studio Credentials made by @Aakash_Sharma4 with 26 views.

Excel data formatting automatically made by @MEGHA_cs with 23 views.

エラーになったアクティビティの表示名(DisplayName)をログ出力したい made by @chantee with 21 views.

Top 3 Topics with Most Replies

I need support for how to download spacific attahc file and ignor the aothers made by @mohamed.saty2012 with 22 replies.

UiPathから別製品で用意されたdllのAPIを呼び出したいです made by @sect_123 with 12 replies.

Writing Data to an Open Excel File Using UiPath made by @Aakash_Sharma4 with 10 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 28 posts!

@postwick made 20 posts!

@lrtetala made 18 posts!

Top 3 Most Liked Posts

This post made by @maria.josephina received 2 likes!

Classic to modern folder migration | Set Asset: You are not authorized! Error code: 0

Thankyou all for your suggestions @Anil_G @Jon_Smith @aravindbalineni123

This post made by @postwick received 1 likes!

Retry Scope property should be named "number of attempts" not "number of retries"

Logically speaking, a retry is an additional attempt after the first attempt. So 1 retry should mean 2 attempts. 2 retries would mean 3 attempts. However, the “number of retries” property isn’t really the number of retries it’s the total number of attempts. Also, it would be great if this activity had a built-in CurrentIndex like other activities do.

This post made by @Aakash_Sharma4 received 1 likes!

How to Run a UiPath Process on Another Computer Without Sharing Studio Credentials

Hi everyone, I have created a process in UiPath Studio where the robot extracts data from PDFs in Gmail and converts it into an Excel file. I have successfully built and tested this process on my computer using UiPath Studio. Now, I want my senior to be able to run this process on his computer whenever he wants, but without sharing my Studio credentials. Is this possible? If so, what are the steps or best practices to achieve this? Thanks in advance for your help!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Read Text File line by line

Hi @parnalmahavir.patni Check the below syntax: stringArray = inputString.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries) stringArray is of DataType Array(System.String). Hope it helps!!

This solution provided by @Yoichi received 1 likes!

UiPathから別製品で用意されたdllのAPIを呼び出したいです

こんにちは DMの方でも返しましたが、以下の様に設定してみてください。 （なおさらにその先の参照も同梱しないといけないかもしれませんので、そのあたりは調整ください） [image] [image]

This solution provided by @vrdabberu received 1 likes!

Invoke Code For Each Loop "Option Strict On Disallows Late Binding At Line 7"

Hi @Brian_Biggio Try the below code in Invoke Code: Dim columnlist As New List(Of String) From {"A", "B", "C"} Dim xl As New Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook = xl.Workbooks.Open(excel_file_path) Dim ws As Microsoft.Office.Interop.Excel.Worksheet = CType(wb.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet) Dim column_range As Microsoft.Office.Interop.Excel.Range = ws.Columns column_range.EntireColumn.Hidden = True For Each c As…

---

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

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

[system]

Daily Forum Report | 08 August 2024

Top 3 Topics with Most Views

Error after moving packages to Production made by @DGA with 25 views.

How to get Source of error on Use application/Browser made by @jnfantasy4 with 25 views.

False Positive for String Variables made by @PPIM_RPA with 24 views.

Top 3 Topics with Most Replies

Questions about UI made by @Dingkun_Yang with 15 replies.

Studio Publish made by @A_Learner with 13 replies.

Renaming file using a table in Excel made by @audra.swope with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 30 posts!

@mkankatala made 25 posts!

@lrtetala made 19 posts!

Top 3 Most Liked Posts

This post made by @jjes received 4 likes!

GenAI Activities in Studio for Desktop

Here’s a short introduction (Part 1) to using the GenAI activity pack in UiPath Studio. (Can’t remove the spelling error in the thumbnail, sorry) [Dive into GenAI Activities in UiPath Studio - Part 1]

This post made by @SorenB received 2 likes!

Up-to-date on the latest of the UiPath Platform? Check with our Quiz! Win your Badge!

Great way to get to know the new features [image]

This post made by @sect_123 received 2 likes!

UiPathから別製品で用意されたdllのAPIを呼び出したいです

返答が遅くなり申し訳ございません。 結果、無事にUiPath上で利用することができました。本当にありがとうございます。 実施したこと Yoichi様から受領した nupkg でUiPath Studio上で正常に動作することを確認しました。 いただいた Nuget Package Explorer の設定画像をもとに私の方でも nupkg を作成し、こちらも正常に動作することを確認しました。 私の nupkg が動作しなかった理由 Nuget Package Explorerでの設定が正しくなかったためです。 (libフォルダ や net6.0 フォルダなどを作成せずに、直下にDLLファイルを配置していました。) 無事解消されたため、本質問は解決とさせていただきます。 アドバイスのみにとどまらず nupkg 作成などまでしていただき、ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @irahmat received 2 likes!

Log messages are not displayed on Assistant

Hi, you can try use Report Status Activity [image]

This solution provided by @lrtetala received 1 likes!

I need support for how to download spacific attahc file and ignor the aothers

@mohamed.saty2012 FilteredMails = RetrievedMails.Where(Function(msg) msg.SenderEmailAddress.Equals("MailAddress")).ToList() [image]

This solution provided by @Yoichi received 1 likes!

How to remove rows unexpected data found

HI, Can you try the following sample? [image] arrDr = dt.AsEnumerable.Where(Function(r) Double.TryParse(r("BB").ToString,Nothing)).ToArray() Sample Sample20240808-3.zip (9.6 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 | 09 August 2024

Top 3 Topics with Most Views

How to use for each activity to copy 2-3 rows in one group and paste to another file made by @yangyq10 with 29 views.

ReFramework Possible Improvement made by @HansG with 19 views.

Enquiries on how to configure the robot to click based on dynamic selector made by @dvkc91 with 19 views.

Top 3 Topics with Most Replies

Not making unread outlook emails after reading made by @mohamed.saty2012 with 11 replies.

Get id from a paragraph made by @sruthesanju with 9 replies.

Slackの字体が斜体になってしまう原因について made by @m-kawahara with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 17 posts!

@postwick made 15 posts!

@lrtetala made 13 posts!

Top 3 Most Liked Posts

This post made by @Cristian_Negulescu received 1 likes!

How ChatGPT & UiPath Robots Revolutionize Decision-Making in Jira | AI in Action

How ChatGPT & UiPath Robots Revolutionize Decision-Making in Jira | AI in Action [How ChatGPT & UiPath Robots Revolutionize Decision-Making in Jira | AI in Action] 0:40 Use-case 1 find Issue with High Priority send email to owner 3:00 Use-case 2 Add new Issue in Jira 4:45 Use-case 3 Assign a user to Issue 4:45 Use-case 4 Displays a similar Issue 7:30 Configuration on ChatGPT 9:40 Logic of the UiPath workflow

This post made by @ppr received 1 likes!

How to move excel value to other sheets base on rows quantity?

in additional to above: We can have a flow like: [The image shows a workflow sequence in UiPath where a DataTable is converted to a list of DataTables and iterated through, writing each table to a separate workbook with a dynamic name. (Captioned by AI)] with for each details: [grafik] we can seperate the into groups based on Billing Document then we want to group again based on the group Member account This we can achieve with a second grouping From this aggregated groups we return th…

This post made by @ashokkarale received 1 likes!

Hi to all ,i am new to uipath ,plz help me to solve below error

@JK_MECH, I faced the same recently and found a solution. It’s weird and don’t know why it works Move your excel file somewhere outside of the OneDrive folder. I tested on other drive than C drive like D:\Temp\Sample.xlsx Once done, then try using activities like Click, Type Into. This should work. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

How to move excel value to other sheets base on rows quantity?

in additional to above: We can have a flow like: [The image shows a workflow sequence in UiPath where a DataTable is converted to a list of DataTables and iterated through, writing each table to a separate workbook with a dynamic name. (Captioned by AI)] with for each details: [grafik] we can seperate the into groups based on Billing Document then we want to group again based on the group Member account This we can achieve with a second grouping From this aggregated groups we return th…

This solution provided by @logesh_svelu received 1 likes!

Excel Online - Microsoft 365

Hi @marcella The datatype of Read Range property is infact a datatable. Please see the example below- [image] Hope this helps, but please do let me know if you have any questions.

This solution provided by @Krishna_Raj received 1 likes!

Selectors types and uses

@Arivu selector is composed of several nodes and each node has one or more attributes associated with it. Modifications to the attributes can be done as required. For example, if the title of the window is not constant, the value of the attribute can be changed to make it dynamic. This is done to correctly identify the target elements UiPath Studio wants to access. for more info check this document its provide by UiPath [How to use Selectors in UiPath (Live Build with Tutorials by…

---

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

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

[system]

Daily Forum Report | 10 August 2024

Top 3 Topics with Most Views

How to get text of a super long URL in SAP made by @yangyq10 with 17 views.

Sum_Multiple Data_Rows_LINQ made by @Balachander_Pandian with 15 views.

How to set a variable to save rows for a specific value in excel? made by @yangyq10 with 14 views.

Top 3 Topics with Most Replies

Get a property from selector made by @Yasir_Yaqoob with 17 replies.

How to get text of a super long URL in SAP made by @yangyq10 with 8 replies.

How to set a variable to save rows for a specific value in excel? made by @yangyq10 with 4 replies.

Top 3 Users Who Posted The Most

@lrtetala made 12 posts!

@ashokkarale made 9 posts!

@Yasir_Yaqoob made 8 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

How to set a variable to save rows for a specific value in excel?

Hi @yangyq10 Please try this [The image shows a workflow that reads an Excel workbook, processes its data into tables, iterates through each table, and writes the tables back to the workbook. (Captioned by AI)] GenerateInvoice.xaml (12.1 KB) Regards,

This post made by @lrtetala received 1 likes!

Show Excel Cell value in table

Hi @muhammet.sezer2 Please try this Sequence15.xaml (23.3 KB) Regards,

This post made by @lrtetala received 1 likes!

How to remove the blank lines from output?

@pratiksha_gulhane Try this Input.ReplaceLineEndings(“”) Regards,

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

How to set a variable to save rows for a specific value in excel?

Hi @yangyq10 Please try this [The image shows a workflow that reads an Excel workbook, processes its data into tables, iterates through each table, and writes the tables back to the workbook. (Captioned by AI)] GenerateInvoice.xaml (12.1 KB) Regards,

This solution provided by @lrtetala received 1 likes!

Show Excel Cell value in table

Hi @muhammet.sezer2 Please try this Sequence15.xaml (23.3 KB) Regards,

This solution provided by @ra.systems received 1 likes!

Unable to click Print in Print Dialog box (Chrome)

Yes, finally I changed the UI Framework to Active Accessibility and it worked perfectly.

---

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

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

[system]

Daily Forum Report | 11 August 2024

Top 3 Topics with Most Views

Can't save attachments from outlook made by @yangyq10 with 13 views.

Dates made by @James_Yakupt with 12 views.

Practice with ReFramework - Evaluation Issue made by @Gautham_Pattabiraman with 12 views.

Top 3 Topics with Most Replies

Hello, need to upload excel file to orchestrator queue made by @mohamed.saty2012 with 21 replies.

Can't save attachments from outlook made by @yangyq10 with 11 replies.

Practice with ReFramework - Evaluation Issue made by @Gautham_Pattabiraman with 10 replies.

Top 3 Users Who Posted The Most

@mohamed.saty2012 made 10 posts!

@shashank.singh made 9 posts!

@vijug made 6 posts!

Top 3 Most Liked Posts

This post made by @AJ_Ask received 1 likes!

Master Amazon S3 Bucket with UiPath: Create, Manage, and Automate Bucket Operations

Welcome to our in-depth tutorial on managing Amazon S3 buckets using UiPath! In this video, I’ll guide you step-by-step through automating various S3 bucket operations with UiPath. Whether you’re looking to create, retrieve, empty, or delete buckets, or handle objects by uploading, downloading, or moving them—this tutorial has got you covered! What You’ll Learn: Setting up UiPath with AWS credentials Creating a new Amazon S3 bucket Retrieving bucket information Emptying an S3…

This post made by @shashank.singh received 1 likes!

Verification of two or more strings

Use if condition and you put the same details for validation Var property Name.contains("My property name") AND var property Value.contains("my property value") Alternate way Var property Name.equal("My property name") AND var property Value.equal("my property value") Then condition you can put as true and else as false.

This post made by @ashokkarale received 1 likes!

Hello, need to upload excel file to orchestrator queue

@mohamed.saty2012, We can’t upload file to queue but we can have filepath which we can use to open it in performer part. Other approach would be using Storage bucket. Let me know if you are open to this approach so I can explain you more about this one. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Hello, need to upload excel file to orchestrator queue

@mohamed.saty2012, We can’t upload file to queue but we can have filepath which we can use to open it in performer part. Other approach would be using Storage bucket. Let me know if you are open to this approach so I can explain you more about this one. Thanks, Ashok

---

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 August 2024

Top 3 Topics with Most Views

🎉 Enhance your productivity with Autopilot™ for developers , join us on Dev Dives! made by @Aditi_Goyal with 26 views.

How to generate access token with client ID & Secret key provided by the business made by @RPA24 with 25 views.

How to validate Invoice excel file and Po excel file and write in new excel file? made by @Naveen_Kanike with 23 views.

Top 3 Topics with Most Replies

How to validate Invoice excel file and Po excel file and write in new excel file? made by @Naveen_Kanike with 13 replies.

How to search a "string" text in XML file in UiPath made by @Manish_Bedi with 11 replies.

Different Dates made by @Shravan_Pintu with 9 replies.

Top 3 Users Who Posted The Most

@ppr made 18 posts!

@lrtetala made 16 posts!

@mkankatala made 15 posts!

Top 3 Most Liked Posts

This post made by @Aditi_Goyal received 3 likes!

Enhance your productivity with Autopilot™ for developers , join us on Dev Dives!

Hello UiPath Community! Excited to see the new AutopilotTM for Developers in action? Join us on August 29 to watch how Autopilot enables you to quickly create automations, apps, and expressions in UiPath Studio and Apps. I, Aditi Goyal, am a Software Engineer @UiPath. Together with Anusha Gunda, a TAM @UiPath, we will showcase how Autopilot helps developers in their day-to-day work. Join the next Dev Dives session on August 29 and discover: · Text to workflow: simply describe an automation i…

This post made by @sven.wullum1 received 2 likes!

Unattended setup Problem

Hi! You need to allocate a Runtime license to your machine. Navigate to Tenant - Machines, then edit your machine and add licenses. [image]

This post made by @afe.araromi received 1 likes!

Kickstart for Automation Student Developers

Thanks to @Emmanuel, @Joe_Osubu, @Sodiq_Bakare, @Folorunso, and @Razak_Moazu for joining me through five Saturdays to make the Office Hour sessions happen. And also to our awesome host @cristina.vidu I also appreciate our regular participants: @ebelechukwu.umezude (class rep), @DeGreenguy, @Anthony_Mulweye, and @Olakunle_Owolabi; this is wishing your success on your automation & certification journey.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

How to contain keyword to contain in particular column

@Raja.G Try like below [This image displays a sequence in UiPath workflow, where data is read from an Excel workbook, processed based on a condition, and then written back to the workbook. (Captioned by AI)] arrDr = DT.AsEnumerable().Where(Function(row) queueKey.Contains(row("BB").ToString)).ToArray Sequence16.xaml (26.7 KB) Regards,

This solution provided by @lrtetala received 1 likes!

Different Dates

@Shravan_Pintu [This image shows a UiPath sequence that reads a workbook, assigns the count of enumerable items from a DataTable to two variables, and displays these counts in two message boxes. (Captioned by AI)] Input: [image] Output: [image]

This solution provided by @ashokkarale received 1 likes!

How to add new case in flow switch activity

@JK_MECH, Hover over the Slow switch and you will get option. [The image shows a screenshot of a flowchart in a robotics process automation (RPA) software interface, featuring a Flow Switch with three form of Assign activities, highlighted by red exclamation marks indicating errors or issues. (Captioned by AI)] Thanks, Ashok

---

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 August 2024

Top 3 Topics with Most Views

Fetching Values from given text made by @aronama with 34 views.

How to click a button for every 10 sec made by @anjani_priya with 28 views.

How can i copy and paste a specific text from pdf to a cell in excel made by @mdaffakhairy with 28 views.

Top 3 Topics with Most Replies

Fetching Values from given text made by @aronama with 13 replies.

Filter data table? made by @domsmgtmeet22 with 13 replies.

Difference between .toString and convert.toString() made by @Gokula_Krishnan_S with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 21 posts!

@ppr made 18 posts!

@singh_sumit made 16 posts!

Top 3 Most Liked Posts

This post made by @naveen.s received 2 likes!

How to click a button for every 10 sec

@anjani_priya , You can use the while condition with your condition While -->Condition = True` Click–> (Configure selector to target refresh button) Delay–>Duration = 00:00:10`

This post made by @Jon_Smith received 1 likes!

Extract Structured Data not working in C# project

This feels like an LLM response, especially with the random link to mediafire. The forum guidelines request that any use of an LLM, whilst totally permitted, is also noted in the response, so please add that you generated this response using an LLM, I also think its discouraged to take topics that are years old (this one being 5 years old) and post replies like this since the issue is most likely long dead and buried. (Edit: if anyone is wondering, @loginerror is coming for the LLM spam and th…

This post made by @AbhayaDoshi received 1 likes!

Mettler-Toledo GBSI - The candidate will work with Business Analysts to develop, configure, deploy, and support process automation using UiPath - Mumbai - India - Full Time

Job title: The candidate will work with Business Analysts to develop, configure, deploy, and support process automation using UiPath Job role: RPA Developer Country: India City: Mumbai Company name: Mettler-Toledo GBSI Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Role and Responsibility: Create, test, and deploy efficient bots to meet the needs of various business processes. Maintain and support existing RPA solutions within the organization. Lear…

Top 3 Most Liked Solutions

This solution provided by @naveen.s received 2 likes!

How to click a button for every 10 sec

@anjani_priya , You can use the while condition with your condition While -->Condition = True` Click–> (Configure selector to target refresh button) Delay–>Duration = 00:00:10`

This solution provided by @Yoichi received 1 likes!

新しいタグを開く方法を教えてください。

こんにちは アプリケーションブラウザを使用アクティビティを新しいウインドウに対して使うと操作できると思いますので、一度お試しください。

This solution provided by @pradeep931 received 1 likes!

Difference between .toString and convert.toString()

Hi @Gokula_Krishnan_S → Use .ToString() when you are sure that the object is not null → Use Convert.ToString() when there’s a possibility that the object might be null, and you want to avoid NullReferenceException while safely converting the object to a string.

---

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 August 2024

Top 3 Topics with Most Views

We are experiencing Orchestrator outages in EEA. Anybody else? made by @Andrei_Tuturuga with 161 views.

Unable to access Orchestrator - Today 14 August 2024 made by @simone.trenta with 119 views.

Orchestrator Outage Issues made by @singh_sumit with 44 views.

Top 3 Topics with Most Replies

We are experiencing Orchestrator outages in EEA. Anybody else? made by @Andrei_Tuturuga with 24 replies.

I keep getting this error on Orchestrator but not while running manually made by @rodrigo.simao with 13 replies.

Need to create commands made by @sruthesanju with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 22 posts!

@postwick made 14 posts!

@simone.trenta made 12 posts!

Top 3 Most Liked Posts

This post made by @simone.trenta received 9 likes!

Unable to access Orchestrator - Today 14 August 2024

The UiPath team has officially confirmed that there are issues UiPath Status - Orchestrator outage for customers in EU region

This post made by @Andrei_Tuturuga received 4 likes!

We are experiencing Orchestrator outages in EEA. Anybody else?

We have access to the cloud platform, but no matter the tenant when we try to access the Orchestrator area we get a message stating “Seem like you don’t have access on Orchestrator. Please check with your administrator!” [The image displays a message indicating that the user does not have access to the Orchestrator and should check with their administrator, accompanied by a padlock icon, Home button, and a "See help" link. (Captioned by AI)]

This post made by @simone.trenta received 4 likes!

We are experiencing Orchestrator outages in EEA. Anybody else?

The UiPath team has officially confirmed that there are issues UiPath Status - Orchestrator outage for customers in EU region

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

How to resolve the Python Scope Error

@kishan.savaliya1, Try this sample solution. PythonTest.zip (11.9 KB) Thanks, Ashok

This solution provided by @pravallikapaluri received 1 likes!

How to find Correct column in Data Table Variable?

Hi @rama_krishna_Rao Use CurrentRow("ColumnName").tostring For example "SF_Extract_Quote Lines Data Row by Row : -->PART NUMBER :" + CurrentRow("PartNumberColumnName").ToString + Environment.NewLine + "SF_Quote Lines Quantity " + CurrentRow("QuantityColumnName").ToString + Environment.NewLine + "SF_Quote Lines Net Unit Price: " + CurrentRow("NetUnitPriceColumnName").ToString + Environment.NewLine + "SF_Quote Lines ATP Date: " + CurrentRow("ATPDateColumnName").ToString + Environment.NewLine + …

This solution provided by @ppr received 1 likes!

Sending Email Body without applying CSS

Additional to above we also recommend ensure when specifying a rule for an element (do not use . before element name) when specifying a rule for a class Also keep in mind that some css rules are not supported by outlook / email clients At least with some modifications we received: [undefined]

---

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 August 2024

Top 3 Topics with Most Views

UIpath verification with underlying opinionated software made by @it17 with 17 views.

Fetch middle name from full name made by @Riya1 with 17 views.

How can I share my UiPath process so my friend can run it on their computer? made by @Aakash_Sharma4 with 16 views.

Top 3 Topics with Most Replies

UIpath verification with underlying opinionated software made by @it17 with 15 replies.

Fetch middle name from full name made by @Riya1 with 13 replies.

How can I share my UiPath process so my friend can run it on their computer? made by @Aakash_Sharma4 with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 24 posts!

@Yoichi made 16 posts!

@ppr made 9 posts!

Top 3 Most Liked Posts

This post made by @Steven_McKeering received 1 likes!

I want to fetch only Net Weight amount from pdf with Find Matching Patters?

Hello Try this Regex pattern - preview it here: (?<=Net Weight:\s*)[\d.,]+ Insert the following into an Assign: system.Text.RegularExpressions.Regex.Match(yourString, “(?<=Net Weight:\s*)[\d.,]+”).ToString [A Regex Tester on REGEX STORM.NET successfully matches the pattern "(?<=Net Weight:*)[.]+", highlighting the value "104.54" in the input text. (Captioned by AI)] Cheers Steve

This post made by @postwick received 1 likes!

BC30574 Option Strict On disallows late binding

You could just set the activity not to show the Excel window. There are other settings that enhance performance also. [image]

This post made by @yangyq10 received 1 likes!

How to copy some rows from one file to the dynamic last row of another file?

@ashokkarale Done [image]

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 1 likes!

I want to fetch only Net Weight amount from pdf with Find Matching Patters?

Hello Try this Regex pattern - preview it here: (?<=Net Weight:\s*)[\d.,]+ Insert the following into an Assign: system.Text.RegularExpressions.Regex.Match(yourString, “(?<=Net Weight:\s*)[\d.,]+”).ToString [A Regex Tester on REGEX STORM.NET successfully matches the pattern "(?<=Net Weight:*)[.]+", highlighting the value "104.54" in the input text. (Captioned by AI)] Cheers Steve

This solution provided by @postwick received 1 likes!

BC30574 Option Strict On disallows late binding

You could just set the activity not to show the Excel window. There are other settings that enhance performance also. [image]

This solution provided by @Parvathy received 1 likes!

PiP with browser error

Hi @A_Learner Check the below thread 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 August 2024

Top 3 Topics with Most Views

How to crack the slider CAPTCHA？？？？ help！！！ made by @chrisjiyiwei with 22 views.

I am facing issues with one automation, Can anyone help me please made by @Chandini_Roy with 21 views.

Can you find full file path with just excel file name made by @Eylul_C with 18 views.

Top 3 Topics with Most Replies

How to crack the slider CAPTCHA？？？？ help！！！ made by @chrisjiyiwei with 8 replies.

I am facing issues with one automation, Can anyone help me please made by @Chandini_Roy with 8 replies.

Sort Data Table by first digit made by @Murat with 7 replies.

Top 3 Users Who Posted The Most

@singh_sumit made 16 posts!

@lrtetala made 12 posts!

@Chandini_Roy made 6 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 1 likes!

I am facing issues with one automation, Can anyone help me please

@Chandini_Roy, It’s very generic and high level use case. If you are seeking help regarding any specific step or error you are getting, ask question to that specific. Due to time constraint no one would be able to help you with full solution on this. Thanks, Ashok

This post made by @chrisjiyiwei received 1 likes!

How to crack the slider CAPTCHA？？？？ help！！！

hey sumit, thanks a lot could you give me demo code(xaml.file) ?

This post made by @Nguyen_Van_Luong1 received 1 likes!

Help Needed: Stuck with 5/100 Score on Calculate Client Security Hash Project

hi @nevesisabela963 , Are you studing at UiPath academy , developer pro cert You can check Calculate Client Security Hash - Upload Assignment answer - #2 by arjunshenoy Hope you can pass it Regards,

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Help Needed: Stuck with 5/100 Score on Calculate Client Security Hash Project

hi @nevesisabela963 , Are you studing at UiPath academy , developer pro cert You can check Calculate Client Security Hash - Upload Assignment answer - #2 by arjunshenoy Hope you can pass it Regards,

This solution provided by @lrtetala received 1 likes!

Can you find full file path with just excel file name

Hi @Eylul_C Try this way Assign (filePaths = Directory.GetFiles("C:\YourRootDirectory", "*YourFileName.xlsx*", SearchOption.AllDirectories).ToList()) If Activity - Condition: filePaths.Count > 0 - Then: - Assign (filePath = filePaths.First()) - Use filePath in further activities (e.g., Open Excel Application, Read Range) - Else: - Handle the case when the file is not found (e.g., Log message, throw exception) Regards,

This solution provided by @lrtetala received 1 likes!

Sort Data Table by first digit

Hi @Murat Try this dtSorted = dtInput.AsEnumerable(). OrderBy(Function(row) row("Operator Voucher").ToString(), StringComparer.Ordinal). CopyToDataTable() 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 August 2024

Top 3 Topics with Most Views

Replace values if header is equals to specific name made by @Jeeru_venkat_Rao with 16 views.

Is this correct, please check it, can we add variables through local panel made by @Ayatulla_Middya with 15 views.

Variables output and other made by @Ritaman_Baral with 14 views.

Top 3 Topics with Most Replies

I am unable to properly set the dynamic selector in one of the portal made by @Ayesha_Ijaz with 8 replies.

Is this correct, please check it, can we add variables through local panel made by @Ayatulla_Middya with 6 replies.

Replace values if header is equals to specific name made by @Jeeru_venkat_Rao with 5 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 10 posts!

@Ayesha_Ijaz made 5 posts!

@Ayatulla_Middya made 3 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

I am unable to properly set the dynamic selector in one of the portal

Hi @Ayesha_Ijaz Method1 Use For each ui element activity in that use Get attribute activity and then if activity check the cell is empty or not, in then block use click activity. Method2 Use Extract Tabledata activity and then use For each row in datatable activity in that use if activity then check currentrow(“Your column”). Tostring is empty or not in then block use Click activity. Regards,

This post made by @ashokkarale received 1 likes!

I am unable to properly set the dynamic selector in one of the portal

@Ayesha_Ijaz, Kindly share the selectors of the click activity. Thanks, Ashok

This post made by @ashokkarale received 1 likes!

How to upgrade a package for "Windows" Compatibility?

@baoutah999, You cannot upgrade these packages until and unless you have there source code. If don’t have it, You got two options, Wait till the developer upgrades the packages and releases for Windows compatibility Use windows legacy project till its allowed by UiPath to edit it. Thanks, Ashok

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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

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

[system]

Daily Forum Report | 18 August 2024

Top 3 Topics with Most Views

How to find unique count in excel column range made by @Jeeru_venkat_Rao with 12 views.

CV Extract Table Issue made by @Vaibhav_Shukla with 10 views.

In Process State of Reframework not getting in_TranscationItem made by @prashant_maghade with 10 views.

Top 3 Topics with Most Replies

In Process State of Reframework not getting in_TranscationItem made by @prashant_maghade with 5 replies.

CV Extract Table Issue made by @Vaibhav_Shukla with 3 replies.

Terminate the current iteration if it is taking too long made by @Yasir_Yaqoob with 3 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 10 posts!

@yukka_88 made 5 posts!

@singh_sumit made 5 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 1 likes!

Why I don't have the Custom option in Publish to section?

@Tudor_Gavriliuc, From Personal Feed also it’s similar steps. [Download Package Personal Feed] Thanks, Ashok

This post made by @lrtetala received 1 likes!

How to pass current workflow application url pass to Next workflow in application?

Hi @rama_krishna_Rao Check the below thread Regards,

This post made by @rama_krishna_Rao received 1 likes!

How to pass current workflow application url pass to Next workflow in application?

Thanks a lot Ashok, It’s working.

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Why I don't have the Custom option in Publish to section?

@Tudor_Gavriliuc, From Personal Feed also it’s similar steps. [Download Package Personal Feed] Thanks, Ashok

---

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.