Forum Engagement Daily Reports

[system]

Daily Forum Report | 31 May 2024

Top 3 Topics with Most Views

Check two strings made by @NHoe with 53 views.

Error: No connection could be made because the target machine actively refused it made by @prograsys with 53 views.

データテーブルに途中から列を追加したい。 made by @asshiyuta with 52 views.

Top 3 Topics with Most Replies

How to delete large number of columns from exel in uipath made by @T_Y_Raju with 15 replies.

Error: No connection could be made because the target machine actively refused it made by @prograsys with 13 replies.

How to sum through linq query made by @T_Y_Raju with 10 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@ashokkarale made 21 posts!

@postwick made 17 posts!

Top 3 Most Liked Posts

This post made by @muktadir received 2 likes!

REFRamework states trasition question

yes you can go to the same state based on a variable you just need to set the correct conditions in transitions [image]

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

UiPath Community 2024.4 Release

Try upgrading the robot to 24.4, they need to match with Studio version.

This post made by @J0ska received 1 likes!

UiPath Community 2024.4 Release

Thx. This would be the best indeed but not an option. I downgraded Studio to 23.10 instead This post is more to bring this to @loginerror’s attention.

Top 3 Most Liked Solutions

This solution provided by @muktadir received 2 likes!

REFRamework states trasition question

yes you can go to the same state based on a variable you just need to set the correct conditions in transitions [image]

This solution provided by @Vinit_Mhatre received 1 likes!

Help: I need readymade Re-framework template for excel Data

Hi @Random_Bot , Kindly check below video for your reference [UiPath Tutorial 25- UiPath ReFramework with Excel |UiPath Real Time Project] Also i have attached updated template hope it works you Excel_re_template.zip (949.2 KB) Regards, Vinit mhatre

This solution provided by @ashokkarale received 1 likes!

How to translate text in 2022 uipath version

@Kancharla_Mahija, You can use UiPath.Cognitive.Activities Thanks, Ashok

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

@lrtetala received 36 likes for their solutions!

@ashokkarale received 35 likes for their solutions!

@Anil_G received 29 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 2024

Top 3 Topics with Most Views

Uipath API convert made by @Ritaman_Baral with 72 views.

Find column value index number in datatable made by @domsmgtmeet22 with 43 views.

Cannot find extension in Edge, use browser and application does not have "browse url" made by @chencha.law with 41 views.

Top 3 Topics with Most Replies

How to extract specific text from invoice made by @suraj_gaikwad with 17 replies.

Find column value index number in datatable made by @domsmgtmeet22 with 16 replies.

UIPATH - DATATABLE IN TXT made by @mateo_marquez with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@vrdabberu made 18 posts!

@lrtetala made 11 posts!

Top 3 Most Liked Posts

This post made by @vrdabberu received 2 likes!

UIPATH - DATATABLE IN TXT

Hi @mateo_marquez The below process will write your entire data table into text file [image] If you want to write a single column to text file, then do below process, but remember that this will write the data of the column that you give only not entire datatable. [image] To write the entire datatable please follow the steps of first image. Regards

This post made by @Parvathy received 1 likes!

How to find a specific file with specific name?

Hi @Lynx Input: [image] latestFile = Directory.GetFiles(path_file).Where(Function(w) Path.GetFileNameWithoutExtension(w).ToLower.Contains("(tr)")).OrderByDescending(Function(f) DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension(f), "\d{2}\.\d{2}\.\d{4}").Value, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture)).FirstOrDefault() Output: [image] Hope it helps!!

This post made by @Yasir_Yaqoob received 1 likes!

UIPATH - DATATABLE IN TXT

It’s because of rewriting. Try this. → Convert Datatable into string using Output Datatable activity. Save the data in the string variable. → Write String variable in the text file. [image]

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 2 likes!

UIPATH - DATATABLE IN TXT

Hi @mateo_marquez The below process will write your entire data table into text file [image] If you want to write a single column to text file, then do below process, but remember that this will write the data of the column that you give only not entire datatable. [image] To write the entire datatable please follow the steps of first image. Regards

This solution provided by @Parvathy received 1 likes!

How to find a specific file with specific name?

Hi @Lynx Input: [image] latestFile = Directory.GetFiles(path_file).Where(Function(w) Path.GetFileNameWithoutExtension(w).ToLower.Contains("(tr)")).OrderByDescending(Function(f) DateTime.ParseExact(System.Text.RegularExpressions.Regex.Match(Path.GetFileNameWithoutExtension(f), "\d{2}\.\d{2}\.\d{4}").Value, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture)).FirstOrDefault() Output: [image] Hope it helps!!

This solution provided by @Anil_G received 1 likes!

REFramework retry

@A_Learner Basically in system exception sequence under set transaction.xaml, applications will be closed using closeallapp xaml Then retrytransaction.xaml will check if the maximum retries reached or not If not reached in config retry case the transaction number is not incremented and in queue case automatically another queue item is added … Now the control moves to initialization state where from initallapp the application will lunch again By chance if launch fails then it moces to end p…

---

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 2024

Top 3 Topics with Most Views

For While do loop activity made by @Nadim_Hossain with 49 views.

Linq query: { !<ObjectDisposedException> ... } made by @jag.guiriba with 36 views.

Hello, Need support made by @mohamed.saty2012 with 36 views.

Top 3 Topics with Most Replies

Hello, Need support made by @mohamed.saty2012 with 13 replies.

Vlookup Linq failed for two datatable made by @Akash_Javalekar1 with 12 replies.

For While do loop activity made by @Nadim_Hossain with 7 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 18 posts!

@Anil_G made 8 posts!

@Akash_Javalekar1 made 7 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

UiPath Webhook Listener - On-premise

@atomic Ideally if you want to receive data from a webhook then you cannot do it with orchestrator…as you need a middleware for it Cheers

This post made by @ashokkarale received 1 likes!

How to match Queueitem key and DatatableCoumn

@Raja.G, Here is a way you can achieve this. [image] Queue Item: [image] Input: [image] Outptu: [image] Sample Code: SampleCode.zip (17.5 KB) Thanks, Ashok

This post made by @vrdabberu received 1 likes!

For While do loop activity

Hi @Nadim_Hossain => Use Input Dialog Box acitvity Dialog Title: "Enter a number" Input Label: "Please enter the number" Input Type: Text Box Value Entered: create a veriable usserInput => Use below syntax in Assign activity: Assign -> counter = 1 Assign -> resultString = "" => Use While loop and give below condition: While counter <= CInt(userInput) Assign -> resultString = resultString+counter.ToString Assign -> counter = counter + 1 End While => Outside While loop use Write Line…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

How to match Queueitem key and DatatableCoumn

@Raja.G, Here is a way you can achieve this. [image] Queue Item: [image] Input: [image] Outptu: [image] Sample Code: SampleCode.zip (17.5 KB) Thanks, Ashok

This solution provided by @mohamed.saty2012 received 1 likes!

Hello, Need support

i have just updated the UiPath studio version from 23.4 to 24.4.0 and the problem has been fixed.

---

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 2024

Top 3 Topics with Most Views

I want to Rotate my Pdf file into 90 degree made by @Melbin_Antu with 61 views.

How to use 'for each ui element' activity to upload data in excel into web made by @z1185399190 with 52 views.

Substring and regex made by @Arvind1 with 48 views.

Top 3 Topics with Most Replies

要素の有無を検出誤作動 どうしたらいいでしょうか？ made by @k.sakaguchi0804 with 22 replies.

Loop made by @meenyi with 17 replies.

How to get the access token in the postman web application? made by @Kumar_Sahu_Sameer with 16 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 35 posts!

@Yoichi made 30 posts!

@lchirathapudi made 16 posts!

Top 3 Most Liked Posts

This post made by @Makiko_Tsuda received 2 likes!

日本語版 テスト オートメーション エンジニア プロフェッショナル認定資格試験のご紹介

コミュニティの皆さん、こんにちは UiPath Certified Professional プログラムよりお知らせです。 2024年6月18日に、日本語版の テスト オートメーション エンジニア プロフェッショナル (UiPath-TAEPv1_JPN) 試験が配信開始されます。 テスト オートメーション エンジニア プロフェッショナル認定資格は、UiPath Test Manager、UiPath Studio、UiPath Robots、UiPath Orchestrator を使用してエンドツーエンドのテスト ワークフローをオーケストレーションおよび自動化するための幅広い知識とスキルを証明します。 出題トピックや試験に関するその他の詳細を確認しましょう。 テスト オートメーション エンジニア プロフェッショナル 試験概要 練習問題を解いて出題形式に慣れましょう。 テスト オートメーション エンジニア プロフェッショナル 模擬テスト なお、新テスト オートメーション エンジニア プロフェッショナル認定資格の発表を記念し、6月18日から8月31日まで同試験の受験料 …

This post made by @Duarte_Valente received 2 likes!

UiPath Foundationq

[image] Found this typo on the second option: Anchor Elment

This post made by @Yoichi received 1 likes!

How to use 'for each ui element' activity to upload data in excel into web

Hi, It depends your requirement. If you need to input text in order, it’s good to use ForEachUiElement. First choose the textbox in Wizard of ForEachUiElement, then add extra column which is necessary to get the content. Regards,

Top 3 Most Liked Solutions

This solution provided by @Krishna_Raj received 1 likes!

I have a issue With Queue item in Reframework

@RahamathImran 1.check your orchestator login and studio profile as same as it is 2.check the folder name where you the queue connected to studio

This solution provided by @jawagarraja123 received 1 likes!

Insert custom datatable format from excel to word

Read Range: Use an appropriate activity to read the data table from your chosen source. Specify the range of cells you want to read from. Copy Image: Manually select the image you want to copy. Use the keyboard shortcut (e.g., Ctrl + C) to copy the image to the clipboard. Paste Image: Select the target cell or range where you want to paste the image. Use the keyboard shortcut (e.g., Ctrl + V) to paste the image from the clipboard. Ensure the cell is empty before pasting. Save Image: …

This solution provided by @vrdabberu received 1 likes!

How to extract specific text from invoice

HI @suraj_gaikwad Please use the below formate in the assign activity and also i have uploaded the updated xaml as per your requirement: DateTime.ParseExact(Date_Extracted,{"d-M-yyyy","d-MMM-yyyy"}, System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None).ToString("dd MMM yyyy") Xaml: Sequence9.xaml (14.1 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 | 04 June 2024

Top 3 Topics with Most Views

How to get Ranges from Highlighted text using regular expression made by @shaik.muktharvalli1 with 59 views.

【質問】データテーブル同士の結合 made by @ando0403.primal with 59 views.

データテーブルの複数カラムの合算 made by @ando0403.primal with 52 views.

Top 3 Topics with Most Replies

How to get Ranges from Highlighted text using regular expression made by @shaik.muktharvalli1 with 15 replies.

Replace regex made by @Sira with 15 replies.

【質問】データテーブル同士の結合 made by @ando0403.primal with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 39 posts!

@Yoichi made 37 posts!

@postwick made 18 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

How to Handle Multiple Scenarios? Using Switch Activity?

Hi, If my understanding is correct, How about the following? [image] dt_forBU2and4.AsEnumerable.Sum(Function(r) CInt(r("ColumnName"))) Note: The above is assumed that there are 2, 1 or 0 rows in the datatable and the row uniquely has value “2” or “4”. Regards,

This post made by @vrdabberu received 1 likes!

【質問】データテーブル同士の結合

Hi @ando0403.primal FYI, Another Approach resultTable = (From row1 In dt1.AsEnumerable() Join row2 In dt2.AsEnumerable() On row1.Field(Of String)("担当者名") Equals row2.Field(Of String)("担当者名") Select resultTable.Rows.Add(row1.Field(Of String)("担当者名"), row1.Field(Of String)("担当Gr"), Convert.ToDouble(row2.Field(Of Object)("金額")))).CopyToDataTable() Check the below workflow for better understanding Sample Process 7.zip (36.2 KB) Regards

This post made by @Yoichi received 1 likes!

How to get Ranges from Highlighted text using regular expression

Hi, How about the following sample? [image] Sample Sample20240604-2.zip (10.9 KB) Please check Sheet1 and Sheet2 in result.xlsx because there seems 2 table in the text. Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to get Ranges from Highlighted text using regular expression

Hi, How about the following sample? [image] Sample Sample20240604-2.zip (10.9 KB) Please check Sheet1 and Sheet2 in result.xlsx because there seems 2 table in the text. Regards,

This solution provided by @Anil_G received 1 likes!

How to use the foreachlistitemconnections?

@Aniesah_Malong this is how you can get and use [image] here Col1, Col2 , Col3 are the column names cheer

This solution provided by @vrdabberu received 1 likes!

Substring and regex

Hi @Arvind1 Check the below xaml for refernce: Sequence10.xaml (8.3 KB) Regex: (\d+\.\d+)(?=\s*\d+\.\d+\s*\d+\.\d+$) 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 | 05 June 2024

Top 3 Topics with Most Views

Multiple Excel made by @muhammet.sezer2 with 57 views.

How to sum 3 columns and divide by 100 in excel through Linq Query made by @T_Y_Raju with 55 views.

Null状態のDataRow引数に文字列代入してエラー made by @gorby with 54 views.

Top 3 Topics with Most Replies

How to sum 3 columns and divide by 100 in excel through Linq Query made by @T_Y_Raju with 15 replies.

Null状態のDataRow引数に文字列代入してエラー made by @gorby with 11 replies.

Multiple Excel made by @muhammet.sezer2 with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@ashokkarale made 16 posts!

@postwick made 11 posts!

Top 3 Most Liked Posts

This post made by @muhammet.sezer2 received 1 likes!

Multiple Excel

Hi, I have 3 excels (Excel 1, Excel 2 and Excel 3) All of these Excels have the same design. We need some information between lines 7 - 10. Each Excel has a different sheet name. The output I want to have will be like the output Excel. The page name should be ‘Info’. [image] Input : [image] Output : [image]

This post made by @Jyoti_Raghav received 1 likes!

Dev Dives Mining your data with AI-powered Continuous Discovery

Hello UiPath Community! Ready to discover how AI and Continuous Discovery can uncover impactful automation opportunities? Excited to learn how you can identify the highest ROI areas for process automation and improvement? Tune in to the next Dev Dives webinar. I am Jyoti Raghav, Sr. Technical Enablement Engineer @UiPath, and I will show how to Discover and Automate high ROI opportunities with the UiPath Business Automation Platform: on the next episode of Dev Dives on June 27th! Join me to di…

This post made by @Lorant received 1 likes!

Récupération des fichiers créés lors de lautomatisation

Merci cela fonctionne !!!

Top 3 Most Liked Solutions

This solution provided by @lchirathapudi received 1 likes!

Multiple Excel

@muhammet.sezer2 If you want only 3 columns try below [image] Output: [image] Regards, Regards,

This solution provided by @SenzoD received 1 likes!

Error of version

I do not know what could be causing this issue. But make sure to uncheck the “Include Prerelease” [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 | 06 June 2024

Top 3 Topics with Most Views

Github error:git unable to push to configured remote made by @jnfantasy4 with 62 views.

How to eliminate the values that ends with 11 in a column made by @anjani_priya with 57 views.

How to Create a Queue Item with Multiple Attachment File Paths in UiPath made by @Avyan.Sharma with 53 views.

Top 3 Topics with Most Replies

Email attachment issue made by @Jezna_Jose1 with 17 replies.

How to eliminate the values that ends with 11 in a column made by @anjani_priya with 14 replies.

How to authenticate orchestrator API in latest version made by @Sumit_Ghosh1 with 14 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 30 posts!

@postwick made 22 posts!

@ppr made 16 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 2 likes!

Elegant approach for identifying a desktop based application

@sreekanth.ennam, I would suggest to have it standard path somewhere as prerequisite instead of spending bot’s time to locating the .exe. It’s totally a non value added step in your process. May be you will have to get the process optimized first before automating for better return on investment. Thanks, Ashok

This post made by @Oscar_Carrera received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello dear Community, I am OscarC, a System Engineer working with computers almost since the punching card era :). Currently working as Business Analyst, but fully interested on UiPath as developer as well, and starting this journey with the same amazed eyes that I had, when I saw my first mainframe.

This post made by @lrtetala received 1 likes!

Github error:git unable to push to configured remote

Hi @jnfantasy4 Please check this Regards,

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

How to Create a Queue Item with Multiple Attachment File Paths in UiPath

@Avyan.Sharma, You don’t need to iterate really. See here. I’m using Get Outlook Mail’s for reference. Yours could be different source like .eml file as you mentioned. After that I’m Saving the Attachments using Save Attachments activity which will give me a IEnum We are just using String.Join to join this IEnum into a single string using this assign: strAttachments = String.Join(";",lstAttachments) Sample: [image] Code: Attachment Demo.xaml (9.3 KB) Hope this is more understandable an…

This solution provided by @ashokkarale received 1 likes!

Getting error at python scope activity

@victoryv4569, Is your python path added to environment variable? Check this once. Try this sample code. It’s on higher version but try changing it as per your setup. PythonTest.zip (3.3 KB) 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 | 07 June 2024

Top 3 Topics with Most Views

IF condition with double variables not comparing properly made by @Caitlin_Shaughnessy with 53 views.

Get text in word docs made by @Sira with 47 views.

I want to Update the datatable which having duplicate rows and update the Value in Datatable made by @Melbin_Antu with 43 views.

Top 3 Topics with Most Replies

IF condition with double variables not comparing properly made by @Caitlin_Shaughnessy with 22 replies.

How to write concatenated string to text file made by @sachin_RAMPURE with 10 replies.

Adding the Excel columns data dianamically made by @T_Y_Raju with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 34 posts!

@Anil_G made 16 posts!

@postwick made 15 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

Help with a data table split

The solution proposed by @Gbenga_Odelade will solve your problem, and is the most efficient - but for posterity’s sake here is what’s causing the “already belongs to another” error. When you try to Add Data Row and just pass the row itself, that’s an object. It’s not going to copy the data into a new datarow object and then add it to the datatable. It’s trying to add the datarow object to the datatable. But that datarow object already belongs to a datatable. To help clarify, instead of fil…

This post made by @Yasir_Yaqoob received 2 likes!

Learning plan status is completed but credentials still locked

[image] This gets updated when you receive an email.

This post made by @victoryv4569 received 1 likes!

Getting error at python invoke activity

Hi Every one, I am getting error at invoke python activity. where i am trying to extract the text from image and packages got installed and the script.py given output in python but getting error at UiPath only. [image] any kind guidance would be appreciated. Thank you!!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Get text in word docs

@Sira read the whole doc and then split with new line and get last str.Split({"\n","\n\r",Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Last cheers

This solution provided by @postwick received 1 likes!

Switch Case with OR Condition

Switch doesn’t work that way. Use the Else If activity instead. Also, a better way to do the expression, instead of “intMonth = 1 or intMonth = 2 or intMonth = 3” just do… {1,2,3}.Contains(intMonth)

---

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

Top 3 Topics with Most Views

How to retry if the transaction failed in reframework made by @suraj_gaikwad with 42 views.

How to compare new file with response file in excel automation made by @ahmed4566 with 36 views.

UiPath Document Understanding - Taxonomy - Rules - How to define a rule in Taxonomy for a field that it can have a null or any other value made by @SVC with 33 views.

Top 3 Topics with Most Replies

How to retry if the transaction failed in reframework made by @suraj_gaikwad with 6 replies.

Get Column Name and Paste Data to Another Excel File Column made by @Shoji with 5 replies.

How to validate columns in an editGrid? made by @Aniesah_Malong with 3 replies.

Top 3 Users Who Posted The Most

@Anil_G made 6 posts!

@lchirathapudi made 4 posts!

@Gbenga_Odelade made 4 posts!

Top 3 Most Liked Posts

This post made by @gorby received 1 likes!

パッケージをアンインストールできません

こんにちは。 UiPath Studio 2024.4.0 Community editionのユーザです。 パッケージを管理で下記のパッケージ [無題] をアンインストールー保存をしようとしたら下記のエラーが出てアンインストールできません。 どうしたらアンインストールできますか？ 新規プロセスを作成し、WFをコピーした方が速いでしょうか？ [error] 24.4.0-beta.16568+Branch.release-v24.4.0.Sha.2580fa6cf8d62c2ce32ffb80535a02af198eb1da.2580fa6cf8d62c2ce32ffb80535a02af198eb1da ファイル名、ディレクトリ名、またはボリューム ラベルの構文が間違っています。 : ‘C:\Users***) .Mapper.json’ エラー: System.IO.IOException: ファイル名、ディレクトリ名、またはボリューム ラベルの構文が間違っています。 : ‘C:\Users*********) .Mapper.json’ at Micro…

This post made by @lchirathapudi received 1 likes!

Get Column Name and Paste Data to Another Excel File Column

Hi @Shoji Try this [image] Sequence2.xaml (14.1 KB) Output: [image] Regards,

This post made by @lchirathapudi received 1 likes!

Get Column Name and Paste Data to Another Excel File Column

@Shoji How about the following? [image] Sequence2.xaml (15.4 KB) Output: [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @lchirathapudi received 1 likes!

Get Column Name and Paste Data to Another Excel File Column

@Shoji How about the following? [image] Sequence2.xaml (15.4 KB) Output: [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 | 09 June 2024

Top 3 Topics with Most Views

I want to make a resume screening project made by @Kia1 with 52 views.

Feature request: Autopilot "workspace"-awareness made by @cprima with 39 views.

Platform configuration readiness script for Orchestrator upgrade shows error made by @subinoodathil with 37 views.

Top 3 Topics with Most Replies

Getting Error when reading column data in excel made by @T_Y_Raju with 15 replies.

データテーブルをフィルターして特定の列の値を一括更新したい made by @vgmadtg with 12 replies.

Text file into another text file made by @Sira with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@T_Y_Raju made 11 posts!

@vrdabberu made 8 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

データテーブルをフィルターして特定の列の値を一括更新したい

こんにちは これはNoが重複していなければ、何も記入しないという理解であっていますでしょうか？ この場合重複のカウントをするためにグルーピング等が必要になりますので少々複雑になります。 例えば以下のようになります [image] dt.AsEnumerable.GroupBy(Function(r) r("No").ToString).Where(Function(g) g.Count>1).SelectMany(Function(g) g).Where(Function(r) r("状況") IsNot Nothing AndAlso (String.IsNullOrEmpty(r("状況").ToString) OrElse r("状況").ToString="待ち")).ToList.ForEach(Sub(r) r("結果")="未定" End Sub ) Sample20240610-1.zip (17.5 KB)

This post made by @vrdabberu received 1 likes!

Text file into another text file

Hi @Sira Check the below workflow. It is done with the given inputs SampleProcess8.zip (41.2 KB) FLOW: [image] OUTPUT: [image] Regards

This post made by @vrdabberu received 1 likes!

Text file into another text file

Hi @Sira Below is the modified workflow. This will give you exact output. [image] SampleProcess8.zip (41.3 KB) Regards

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

Text file into another text file

Hi @Sira Below is the modified workflow. This will give you exact output. [image] SampleProcess8.zip (41.3 KB) Regards

This solution provided by @Parvathy received 1 likes!

Trim Column Name in Data Table

Hi @Shoji The below workflow will trim the spaces in Destination.xlsx file and copy the data from referecne file to destination file. Check the below workflow: Destination.xlsx (7.9 KB) Reference.xlsx (8.3 KB) Sequence49.xaml (10.2 KB) FLOW: [image] Regards

This solution provided by @lrtetala received 1 likes!

Regex pattern that can be modify for invoice

@Affan_Basar Manually i am writing [image] [image] Sequence3.xaml (8.5 KB) 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 | 10 June 2024

Top 3 Topics with Most Views

Else If activity showing condition not supplied made by @Biswajeet_kumar with 62 views.

Transpose the datatable made by @SunnyJha with 59 views.

Git Commit & Push issue made by @Joy_Ballav1 with 54 views.

Top 3 Topics with Most Replies

Get Informative ScreenShot made by @eQueX with 17 replies.

I want to rotate my PDF files made by @Melbin_Antu with 16 replies.

Error with find children made by @Siwar_Ferjeni with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 35 posts!

@Yoichi made 31 posts!

@postwick made 17 posts!

Top 3 Most Liked Posts

This post made by @postwick received 3 likes!

When you accidentally set the Retry Scope to 5.00:00:00 instead of 00:00:05

When you accidentally set the Retry Scope to 5.00:00:00 instead of 00:00:05 … [image]

This post made by @Biswajeet_kumar received 2 likes!

Else If activity showing condition not supplied

After the latest update in studio the else if activity is not accepting the conditions even after providing it properly. PFB the Screen-shot [image] It automatically get resolved if we try taking new else if or re copying pasting the same condition again or Try clicking Add Else If and delete the added Else If.

This post made by @Yoichi received 1 likes!

Add data row based on date check

HI, How about the following sample? [image] Sample Sample20240610-2.zip (10.6 KB)

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Add data row based on date check

HI, How about the following sample? [image] Sample Sample20240610-2.zip (10.6 KB)

This solution provided by @lchirathapudi received 1 likes!

Unable to find DU API key on cloud license section for Enterprise Trial

Hi @ImPratham45 , Besides Robots&Services , can you check if there is a tab for consumables, can you check the DU Key in consumables Admin >> License >> Consumables >> AI Units Thanks, Pallavi.

This solution provided by @vrdabberu received 1 likes!

Argument 'Text': BC30311: Value of type 'SecureString' cannot be converted to 'String'. The selected value is incompatible with the property type

Hi @Shravan_Pintu 4 Use the below syntax: conversion of securestring to string New System.Net.NetworkCredentials(String.Empty,password).Password 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 | 11 June 2024

Top 3 Topics with Most Views

Convert a CURL command to run as HTTP Request made by @simon.powell with 58 views.

Need help-type into got stuck made by @Anelisa_Bolosha1 with 56 views.

Screen Resolution conflict made by @krishbcd with 52 views.

Top 3 Topics with Most Replies

Convert a CURL command to run as HTTP Request made by @simon.powell with 14 replies.

Issue with Flow Decision in New UiPath Studio Version: Connections Lost and Object Reference Error made by @Eduardo_Mazzochi with 13 replies.

Date Format Issue in one machine but working in other machines made by @logesh_kumar1 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@ppr made 31 posts!

@vrdabberu made 21 posts!

Top 3 Most Liked Posts

This post made by @Sami_Rajput received 2 likes!

Not able to click on a drop-down (when a new chrome tab opens)

Thanks @Luciano_Gjinaj adding a delay worked

This post made by @Krishna_Raj received 2 likes!

How to check the classic and modern design in updated version of UiPath

@Shravan_Pintu check this reference

This post made by @Joe_Matuch received 2 likes!

Error in Studio 2024.10.0 - Display Name Duplication

Thanks, @postwick. No one is saying that the message itself is an error. It’s an error/bug in Studio that the warning message is appearing in the Error List. When your code is reviewed for Display Name Duplication warnings and more, it’s not great when your reviewer sees 40 warnings, 2/3 of which are erroneous. Then, they have to check whether they are legitimate warnings or due to this bug. If your COE governance policy decides which warnings are raised and which are ignored, then you can’t ju…

Top 3 Most Liked Solutions

This solution provided by @Nawazish_Ahmad received 1 likes!

Problem in Dictionary

Hi @SP_Bot Use Read Range Activity (Here I’m using Build DataTable) & Store in Variable DT Use Assign Activity and use below expression Note: Dictionary(of String, Object) Type DT.AsEnumerable.ToDictionary(Function(x) x("Key").ToString, Function(y) y("Value")) [image] [image] Hope it’ll helps you Cheers!!

This solution provided by @vrdabberu received 1 likes!

I want to rotate my PDF files

Hi @Melbin_Antu https://api.nuget.org/v3/index.json Place the above URL in the URL Field mentioned in the above screenshot and give the name as mentioned and then click on add andalso once it is added close the studio ad reopen it then you can find the packages. [image] Regards

This solution provided by @Parvathy received 1 likes!

Find values from 2 datatables

Hi @SunnyJha [image] Please check the below workflow: Sequence56.xaml (10.0 KB) Input.xlsx (10.3 KB) DT1 and DT2 sheets are two inputs and Output is the output sheet. [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 | 12 June 2024

Top 3 Topics with Most Views

How to get required values from my text file made by @shaik.muktharvalli1 with 81 views.

Downloaded Excel made by @A_Learner with 56 views.

Recaptcha V2 - Captcha Solving Automation made by @raja_sarathkumar with 55 views.

Top 3 Topics with Most Replies

How to get required values from my text file made by @shaik.muktharvalli1 with 41 replies.

Recaptcha V2 - Captcha Solving Automation made by @raja_sarathkumar with 21 replies.

Select date 1 made by @yogitagaikwad2206 with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 55 posts!

@ashokkarale made 27 posts!

@vrdabberu made 23 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 3 likes!

How to get password visible from orchestrator

Hi @sruthesanju Use Get Credential Activity and save the output in two variables say UserName and Password => Use below syntax in Assign activity strOutput = New System.Net.NetworkCredential(String.Empty, Password).Password strOutput is of DataType System.String. Now, your password will be visible in Message box. Hope it helps!!

This post made by @A_Learner received 2 likes!

Insert row in Excel question

This is a great solution! Thank you, @Anil_G Thank you for the great answer! @ashokkarale

This post made by @f-nnn received 1 likes!

カレンダーの日付選択（表示されていない月）について

画像のようなwebサイトのカレンダーから日付を選択したいです。 当月のものは選択できるのですが、表示されていない月の日付が選択できません。 当月以外のものを選択する方法はあるのでしょうか？ よろしくお願いします。 [image]

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Excelのシートを選択したい(前面化させたい)

Hi @m-takeda1 You have to use the Modern Excel and Ui activities to achieve the flow. Here I am giving the outline process steps for your understnading, → Use the For each file in folder activity to iterate the each file in a folder. Output-CurrentFile → Inside for each insert the Excel Process scope activity. → Inside of it Insert the Use excel file activity, and pass the CurrentFile.toString in Excel file field. → Inside Use excel file activity insert the Click activity and hit on i…

This solution provided by @lrtetala received 1 likes!

ANDとORを併用した条件分岐を教えてください

Hi @m-minami Try this Assign: FLG1 = 1 Assign: FLG2 = 0 If: ((FLG1 = 1 And FLG2 = 0) Or (FLG1 = 1 And FLG2 = 4) Or (FLG1 = 2 And FLG2 = 0) Or (FLG1 = 2 And FLG2 = 3)) Then: Message Box: "Proceed to Then" Else: Message Box: "Proceed to Else" Regards,

This solution provided by @mkankatala received 1 likes!

How to Use the Activity "Save Excel File"?

Hi @Shoji Use the Use excel file activity inside of that activity insert this Save Excel file activity. The output of Use excel file is Excel, pass that to the Save excel file activity. 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 | 13 June 2024

Top 3 Topics with Most Views

How to append JSON Object in another File made by @shivkumar with 62 views.

Convert text file to excel file without formatting made by @Tengku_Aliff with 53 views.

ElementatorDefaultについて made by @ml.system with 53 views.

Top 3 Topics with Most Replies

How to append JSON Object in another File made by @shivkumar with 23 replies.

ElementatorDefaultについて made by @ml.system with 19 replies.

FilterDatatableアクティビティの設定方法をご教示ください。 made by @gorby with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 56 posts!

@postwick made 31 posts!

@shivkumar made 18 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 2 likes!

Monthly Forum Rewards - May 2024

Congratulations everyone

This post made by @lrtetala received 2 likes!

Monthly Forum Rewards - May 2024

Hearty congratulations everyone …Keep up the great work!!

This post made by @Ajay_Mishra received 2 likes!

Monthly Forum Rewards - May 2024

Congratulations Everyone!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

UiPath Academyのコンテンツについて「Automation Developer Associate Training」

こんにちは 類似事象として以下ありますが、いかがでしょうか？

This solution provided by @postwick received 2 likes!

UiPath image search

For Each File in Folder – Load Image – Find Image Matches (set Image to ImageTarget and Target to null, then use the variable from Load Image in the Image property of Find Image Matches

This solution provided by @ppr received 1 likes!

Group and combine data with comma seperator

In general we would suggest to get familar with the different options of Grouping Data (LINQ, NoN-LINQ) [HowTo] Overview on different options for grouping data and processing the groups - News / Tutorials - UiPath Community Forum Adressing: Yes, thats why we mentioned A few parts are unclear of the modified description: But in general we address it, by extending the grouping criteria e.g. with a second column used for group by: (From d in dtOrig.AsEnumerable Group d by k1=d("Region").to…

---

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

Top 3 Topics with Most Views

How to remove extra row from build data table activity made by @Vishal_Kumar4 with 63 views.

LInq Query through Error made by @pawanrajpurohit with 62 views.

Unable to Extract text from Word using Get Full text activity made by @KishoreC with 46 views.

Top 3 Topics with Most Replies

LInq Query through Error made by @pawanrajpurohit with 23 replies.

Data in Excel with no header columns made by @A_Learner with 20 replies.

繰り返し（データテーブルの各行）の代入について made by @ml.system with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@Parvathy made 24 posts!

@vrdabberu made 20 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

How to set Default date in Create form task that need to be visible only?

Hi @Kunal_Jain Use the Create form task activity, click on form data option it will show the arguments. Then give the PresentDate in key field and give the DateTime.Now.ToString(“dd/MM/yyyy”) in the value field, select the In option in the Direction dropdown. Check the below image for arguments passage, [image] Click on save. After that click on the Open Form Designer then it automatically create a text field. When you click on preview it will show the present date everytime. After creati…

This post made by @rezart_mersini received 1 likes!

Assistance with Assign, create data table, write range workbook

I think I have it somewhat like this…thanks for the assistance. But I will double check…just in case.

This post made by @Anil_G received 1 likes!

Assistance with Assign, create data table, write range workbook

@rezart_mersini Writing you can do it at once after the loop Move the build also before the loop so that datatable is created and data gets added as rows into table and at the end we can write cheers

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

How to set Default date in Create form task that need to be visible only?

Hi @Kunal_Jain Use the Create form task activity, click on form data option it will show the arguments. Then give the PresentDate in key field and give the DateTime.Now.ToString(“dd/MM/yyyy”) in the value field, select the In option in the Direction dropdown. Check the below image for arguments passage, [image] Click on save. After that click on the Open Form Designer then it automatically create a text field. When you click on preview it will show the present date everytime. After creati…

This solution provided by @ppr received 1 likes!

Add data to a specific column using an array of string values

we are depended on the col structures assumption: Project set to Windows Variable: arr_locations = {“A”,“B”,“C”,“D”,“E”,“F”} Assign Activity: dtResult = dtOrig.Clone Assign activity: dtResult = (From d in dtOrig.AsEnumerable From lo in arr_locations Let ra = d.ItemArray.SkipLast(1).Append(lo).Cast(Of Object).toArray Order by lo Select r = dtResult.Rows.Add(ra)).CopyToDataTable UPD1 - Bracket Fix UPD2 - Beautified it with an adtional ordering [grafik]

This solution provided by @Nawazish_Ahmad received 1 likes!

Split values from Data table and update it in another new columns

Hi @Sathish_Kumar_S Try this: Forum.zip (2.5 KB) Hope it’ll helps you 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 | 15 June 2024

Top 3 Topics with Most Views

Package version issue made by @A_Learner with 51 views.

アカデミーREFramework made by @chantee with 40 views.

Read excel1 made by @yogitagaikwad2206 with 40 views.

Top 3 Topics with Most Replies

Package version issue made by @A_Learner with 19 replies.

Data Table Extract not working made by @dutta.marina with 15 replies.

Read excel1 made by @yogitagaikwad2206 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@vrdabberu made 17 posts!

@ashokkarale made 15 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 1 likes!

Package version issue

Downgrade the package and save the package. Again open Manage Packages select the latest version and give Runtime Rule as Lowest As Applicable. Regards

This post made by @Bramma_Vani received 1 likes!

How to write the values of write line text values in the text file?

I have created for loop and append line and it gives me the expected result. Thank you so much for the guidance. For each item in pdf2 (values) Append line item and save it in a txt file Break for loop activity This goes and appended until all the text values are copied in txt file.

This post made by @vrdabberu received 1 likes!

条件によってデータテーブルの特定列の値を更新したい

Hi @vgmadtg Check the below workflow: [image] XAML: Sequence75.xaml (9.6 KB) Output: data.xlsx (10.6 KB) Input is the Input Sheet and Output is the Output Sheet. Regards

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

条件によってデータテーブルの特定列の値を更新したい

Hi @vgmadtg Check the below workflow: [image] XAML: Sequence75.xaml (9.6 KB) Output: data.xlsx (10.6 KB) Input is the Input Sheet and Output is the Output Sheet. Regards

This solution provided by @vrdabberu received 1 likes!

アカデミーのクイズREFramework

Hi @chantee The answer would be First option In the initialization state of a UiPath process, if all required applications have been initialized and the necessary settings for the process have been loaded successfully, the next logical step is to proceed to the step where the process retrieves the transaction data using Get Transaction Data. Therefore, the correct transition would be: Transition 1: Success Next state: Retrieving transaction data Hope you understand!!

This solution provided by @Anil_G received 1 likes!

アカデミーREFramework

@chantee As per scenario no exception is being thrown or is mentioned as such…just to confuse a extra line of threshold details are given…but it need not necessarily mean you have a bus exception thrown there 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 | 16 June 2024

Top 3 Topics with Most Views

データテーブルの各行を繰り返す、で重複行の場合は次の行を処理したい made by @vgmadtg with 43 views.

半角数字から全角数字への変換について made by @ml.system with 38 views.

Can't find package for microsoft.activities.extension for dictionary activities,thanks for any help! made by @Sai_Kumar_111 with 36 views.

Top 3 Topics with Most Replies

テキスト位置を探すについて made by @ml.system with 14 replies.

半角数字から全角数字への変換について made by @ml.system with 13 replies.

Need to extract values/numbers based on rules and add them made by @8b6861dc5e0c9f7008548ca66 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@lrtetala made 13 posts!

@vrdabberu made 8 posts!

Top 3 Most Liked Posts

This post made by @Indranil_Dey received 1 likes!

Monthly Forum Rewards - May 2024

Congratulations to all winners

This post made by @588b97c268cd7dd244bd4707e received 1 likes!

Convert dynamic values to date

Learning platform UI Path Description Hi I am new to UI path I have a doubt. I am getting values(dates) from excel in MM/dd/yyyy as string. I want it to be stored as date format. Because I need to compare two date. Date which I read from excel and current date. I tried this : DateTime.ParseExact( One , “d-M-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”) where one is the variable in string which values I am getting from excel ex: 7/2/2024. Can someone please…

This post made by @lrtetala received 1 likes!

Need to extract values/numbers based on rules and add them

Hi @8b6861dc5e0c9f7008548ca66 Try this MRValues = (From row In dt.AsEnumerable() Let line = row(0).ToString() Where System.Text.RegularExpressions.Regex.IsMatch(line, "(IND|DBA|STA|GJK) \d+-MR") Select Convert.ToInt32(System.Text.RegularExpressions.Regex.Match(line, "\d+").Value)).Sum() MPValues = (From row In dt.AsEnumerable() Let line = row(0).ToString() Where System.Text.RegularExpressions.Regex…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Data Table Extract not working

@dutta.marina As mentioned if idx is increasing for each transaction just use a variable and incrmenet If that is not the case them we need to find another attribute which is unique to your target table…and get that…may be selecting a intermediate row in the ui explorer center top window will help…check the same to restrict the selector to the tab you need Cheers

This solution provided by @lrtetala received 1 likes!

Need to extract values/numbers based on rules and add them

@8b6861dc5e0c9f7008548ca66 To handle cases with varying spaces between the prefix and the number, and to capture both alphabet and alphanumeric suffixes accurately, MRValues = (From row In dt.AsEnumerable() Let line = row(0).ToString() Where System.Text.RegularExpressions.Regex.IsMatch(line, "(IND|DBA|STA|GJK)\s+\d+(\.\d+)?\s*-MR") Select Convert.ToDouble(System.Text.RegularExpressions.Regex.Match(line, "\d+(\.\d+)?").Value)).Sum() MPVa…

---

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

Top 3 Topics with Most Views

Creating several Global variables made by @ymshin0421 with 48 views.

Net Weaver Portal - Server not connected issue made by @anjali123 with 48 views.

How to get the specific Row Number in excel? made by @z1185399190 with 47 views.

Top 3 Topics with Most Replies

Extract specific text from HTML code with Regex made by @Maxime_LAUGIER with 15 replies.

How to get the specific Row Number in excel? made by @z1185399190 with 11 replies.

Problem with CV Scope/Click/attach Window not recognizing elements in Desktop application! made by @rohan.dhole with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 41 posts!

@Anil_G made 37 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Variable selector

@A_Learner [image] hope this clarifies cheers

This post made by @ppr received 2 likes!

How to reorder the column

A formal reminder on the method signature: [grafik] So we are using an array

This post made by @ppr received 2 likes!

How to compare two lists(String)?

@Guru_Koli21 LINQ learning resources:

Top 3 Most Liked Solutions

This solution provided by @lchirathapudi received 1 likes!

How to get the specific Row Number in excel?

Hi @z1185399190 Try this String.IsNullOrEmpty(CurrentRow.ByField("ColumnName").ToString) Or String.IsNullOrWhiteSpace(CurrentRow.ByField("ColumnName").ToString) [image] Thanks, Pallavi

This solution provided by @vrdabberu received 1 likes!

Issue in finding the date difference

Hi @mint Try the below syntax systemDate = DateTime.ParseExact("06-17-2024", "MM-dd-yyyy", System.Globalization.CultureInfo.InvariantCulture) sharepointDate = DateTime.ParseExact("14-06-2024", "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture) differenceInDays = (systemDate - sharepointDate).Days systemDate: System.DateTime sharepointDate: System.DateTime differenceInDays: System.Int32 Regards

This solution provided by @ashokkarale received 1 likes!

How to compare two lists(String)?

@Guru_Koli21, Use this LINQ allContained = L1.All(Function(item) L2.Contains(item)) Here, allContained is a Boolean variable that will be True if all elements in L1 are present in L2 and False otherwise. Input: L1 = New List(Of String) From {"A", "B", "C", "D"} L2 = New List(Of String) From {"A", "B", "C", "D", "E", "F"} Logic: [image] Output: [image] Sample Workflow: Workflow1.xaml (7.5 KB) 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 | 18 June 2024

Top 3 Topics with Most Views

📢 Announcing the upcoming GA of UiPath GenAI Activities made by @Scott_Schoenberger with 72 views.

Loop for excels in a folder made by @ymshin0421 with 71 views.

Chrome window is contracting in Unattended automation made by @anjali123 with 68 views.

Top 3 Topics with Most Replies

PDF in Edge, shortcut Ctrl-Shift-S made by @VanjaV with 18 replies.

Fetch the data from JSON made by @Riya1 with 16 replies.

Multipage single PDF file document Processing Page detection Error for specific page exaction keys made by @Nabisab_NabiNadeel with 10 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 21 posts!

@ppr made 20 posts!

@postwick made 17 posts!

Top 3 Most Liked Posts

This post made by @Scott_Schoenberger received 2 likes!

Announcing the upcoming GA of UiPath GenAI Activities

We’re very excited to announce the imminent GA release of UiPath GenAI Activities. This collection of activities available as a first-party Integration Service Connector allows you to interact directly with popular large language models from various vendors internally managed by UiPath via the AI Trust Layer. No subscription to 3rd party Cloud services is necessary and UiPath takes the guess work out of prompting by offering quality-controlled, common RPA tasks in the form of easy-to-use Studi…

This post made by @Parvathy received 2 likes!

How to filter the current date using linq

Hi @lakshmi.mp Try this Linq: filteredDt = (From row In dt Let PublishedDate = row("Published Date").ToString Let RecentPublishedDate = row("Recent Published Date").ToString Where PublishedDate.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) AndAlso RecentPublishedDate.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) Select dt.Clone.Rows.Add(row.ItemArray)).CopyToDataTable() filteredDt is of DataType System.Data.DataTable() OUTPUT: [image] Hope it helps!!

This post made by @ashokkarale received 2 likes!

SAP .xls file export interrupted

@ext-o, Are you closing the SAP right after exporting the data? if so you can add some delay. I think UiPath don’t wait for sap extraction to be finish. Hope you are extracting the data same way we manually extracts. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

How to filter the current date using linq

Hi @lakshmi.mp Try this Linq: filteredDt = (From row In dt Let PublishedDate = row("Published Date").ToString Let RecentPublishedDate = row("Recent Published Date").ToString Where PublishedDate.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) AndAlso RecentPublishedDate.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) Select dt.Clone.Rows.Add(row.ItemArray)).CopyToDataTable() filteredDt is of DataType System.Data.DataTable() OUTPUT: [image] Hope it helps!!

This solution provided by @Yoichi received 1 likes!

教えてください StudioXでクリップボード不可能 OpenClipboard に失敗しました (0x800401D0 (CLIPBRD_E_CANT_OPEN))

こんにちは このエラーが出ても、値は正しくセットされているケースもあるようなので 取り急ぎその変数の値を設定アクティビティを直接トライキャッチで囲ってみて 一旦例外を回避しておいて、その後値がクリップボードに正しくセットされているかを 確認してみてはと思います。

This solution provided by @Anil_G received 1 likes!

How to achieve 2 different " for each" at the same time?

@z1185399190 Read the data into datatable dt Inside for each ui element use dt.Rows(index)("ColumnName").atoString Index is present in the properties of for eqch ui element…if not currentindex will be available as direct variable Cheers

---

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

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

[system]

Daily Forum Report | 19 June 2024

Top 3 Topics with Most Views

system.collections.generic.IEnumerable<system.text.regularexpressions.match> not taken my varibale scope made by @shaik.muktharvalli1 with 52 views.

How to compare 2 excel file and store data into another file made by @lakshmi.mp with 51 views.

Exception has been thrown by the target of an invocation in SmartSheet activity made by @Venkatraj_WaMDS with 45 views.

Top 3 Topics with Most Replies

system.collections.generic.IEnumerable<system.text.regularexpressions.match> not taken my varibale scope made by @shaik.muktharvalli1 with 34 replies.

How to apply multifilter at the same tile in datatable made by @T_Y_Raju with 19 replies.

Exception has been thrown by the target of an invocation in SmartSheet activity made by @Venkatraj_WaMDS with 14 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 31 posts!

@Anil_G made 30 posts!

@anilkupatnaik made 23 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 2 likes!

How to filter the current date using linq

Hi @lakshmi.mp Check the below workflow: First Assign: Bool_dt = If((From row In dt.AsEnumerable() Where row("Published Date").ToString.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) AndAlso row("Recent Published Date").ToString.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) Select row).Count() = 0, True, False) Bool_dt is of DataType System.Boolean Assign inside in If: filtered_dt = (From row In dt Where row("Published Date").ToString.Contains(DateTime.Now.ToString("MMM-dd-yyyy"))…

This post made by @Sai_chnadrika_Kopparapu received 2 likes!

How to remove [ ] from column in excel

@lakshmi.mp [image] [image] Output: [image] Regards,

This post made by @anilkupatnaik received 2 likes!

Need to get queue count through LINQ

Hi @JITU99 If date1 and date2 are fixed and if you want to use the excel data, then you can use the process suggested by @Anil_G If you want to get the data directly from the orchestrator, then use the get queue items and lets take the output of that activity as queueItems and pass the from and to dates in the properties panel of the Get Queue Items and it works!! After getting the queue data use the below syntax in using assign activity and you can get the success count. successCount = queu…

Top 3 Most Liked Solutions

This solution provided by @Sai_chnadrika_Kopparapu received 2 likes!

How to remove [ ] from column in excel

@lakshmi.mp [image] [image] Output: [image] Regards,

This solution provided by @Anil_G received 1 likes!

How to compare the data and append the extra data

@anjani_priya You can use linq for the same to find extra rows and then use append range with the output Use if condition with Dt2.AsEnumerable.Any(function(x) dt1.AsEnumerable.All(function(y) Not y("CodeColumn).ToString.Equals(x("CodeColumn").ToString)) Then on the then side use assign with Dt2 = Dt2.AsEnumerable.Where(function(x) dt1.AsEnumerable.All(function(y) Not y("CodeColumn).ToString.Equals(x("CodeColumn").ToString)).CopyToDataTable On else side no unmatched rows are there Edit: c…

This solution provided by @Yoichi received 1 likes!

Merging Two Dictionaries - but keep second values as priority

HI, All right, can you try the following? dictFinal = dict1.AsEnumerable.Where(Function(kv) not dict2.Keys.Contains(kv.Key)).Concat(dict2.AsEnumerable).ToDictionary(Function(kv) kv.Key, Function(kv)kv.Value) [image] Sample Sample20240619-1 (3).zip (2.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.