Forum Engagement Daily Reports

[system]

Daily Forum Report | 21 February 2024

Top 3 Topics with Most Views

Can we write multiple lines in assign activity made by @Ulhas_Guttikar with 58 views.

How to add 8 business working days in uipath i want to exclude sat and sunday made by @T_Y_Raju with 54 views.

Regular Expressions in UiPath made by @Ankit_Chauhan with 53 views.

Top 3 Topics with Most Replies

Send outlook Activity error made by @Rakesh_Tiwari with 23 replies.

How to add 8 business working days in uipath i want to exclude sat and sunday made by @T_Y_Raju with 21 replies.

How to make Dynamic Selectors made by @Mohammad_Allan with 19 replies.

Top 3 Users Who Posted The Most

@Parvathy made 29 posts!

@ppr made 26 posts!

@rlgandu made 20 posts!

Top 3 Most Liked Posts

This post made by @Vinit_Kawle received 3 likes!

UiPath Community MVP 2024 announcement!

Congratulations everyone!

This post made by @pikorpa received 3 likes!

Converting Cell value

@Naman_Arora here you will find example workflow. BlankProcess111.zip (8.8 KB) It is correct expression: Newtonsoft.Json.Linq.JArray.Parse(currentRow("YourColumnName").ToString)(0)("value").ToString() [image]

This post made by @iamNairda received 2 likes!

Share your experience with UiPath Assistant

Thanks for the tag, filled the survey

Top 3 Most Liked Solutions

This solution provided by @postwick received 1 likes!

Get Full Text selector is dynamic

You can’t wildcard aaname. That means the selector will match ANY UI Element. You have to give it a specific value for aaname. Why did you put * for aaname?

---

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

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

[system]

Daily Forum Report | 22 February 2024

Top 3 Topics with Most Views

Value of string cannot be converted made by @dipon1112000 with 73 views.

Several errors after upgrade made by @echthard with 45 views.

How to check date is one month previous made by @sruthesanju with 42 views.

Top 3 Topics with Most Replies

I want a linq query where first rount of the column1 value and subtract the value from column 2 with column 1 and paste the value to column 3 made by @Melbin_Antu1 with 25 replies.

How to get every monday date number from assign activity made by @shaik.muktharvalli1 with 18 replies.

Value of string cannot be converted made by @dipon1112000 with 13 replies.

Top 3 Users Who Posted The Most

@srinivasmarneni made 28 posts!

@Parvathy made 27 posts!

@Yoichi made 27 posts!

Top 3 Most Liked Posts

This post made by @Matt67 received 2 likes!

String Interpolation

Hello, as a former c# developer it’s a big comfort to have string interpolation in UiPath, thanks for this information! However, I always thought it wasn’t working for a simple reason, we don’t have intellisense enabled inside brackets. I would have expected same behavior as visual studio, everything inside brakets should be in white and should enable intellisense. Do you know if anything is on backlog to implement this ? Have a nice day !

This post made by @ptrobot received 2 likes!

Comparing the present data with the previously data from the excel

If you are using REFramework, you can insert the following logic in the Process Transaction state: previousEmail = If (TransactionNumber = 1, "", dt_TransactionData(TransactionNumber-2)("username").ToString) If (dt_TransactionData(TransactionNumber-1)("username").ToString().Equals(previousEmail)) Then ' code for same email Else ' code for new email

This post made by @ashokkarale received 2 likes!

Date is present or not in datatable

@sruthesanju , Probably you are looking for this. [image] Replace dt with your DataTable variable & StartDate with your end date's present in DataTable Column Name Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Orchestrator version question

Hi, The following page regarding compatibility will help you. [image] Do classic folders exist in all versions? No. At least, the latest 2023.10 or automation cloud doesn’t have it. Regards,

This solution provided by @mkankatala received 1 likes!

Studio vs StudioX in the community version

Hi @a-ioannidis Welcome to the UiPath Community!! The Community edition will allows you to use both profiles Studio and Studio X for free. No need to use the Enterprise edition, for enterprise edition some of the features may added in the Orchestrator like AI Center, Task mining and number of robots, machines will be added. For now, you Orchestrator is saying you are using Community edition. With out any doubt you can use the Studio and StudioX for free. You can switch between both profiles, …

This solution provided by @Anil_G received 1 likes!

Mass automation for an organization or team

@youssef169886 Offline availability of studio is not available as of now… Cheers

---

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

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

[system]

Daily Forum Report | 23 February 2024

Top 3 Topics with Most Views

Update values datatable using linq made by @aqiffm with 54 views.

Issues with conditional statements in New version made by @Hari_kumar_reddy with 52 views.

From the amazon website I want to extract only the Apple i phone product details only i want to neglect the other phones product details please let me know is there any condition can be provided when we are extracting our data from amazon website made by @THASARATHA_PRANAV_K with 44 views.

Top 3 Topics with Most Replies

Dictionary..-- made by @Pushpendra_kowthavarapu with 17 replies.

Cannot assign from type 'System.Object' to type 'System.Data.DataTable' in Assign activity ' made by @Mohan_Reddy with 16 replies.

Update values datatable using linq made by @aqiffm with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 44 posts!

@pravallikapaluri made 28 posts!

@ashokkarale made 21 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Python Code running endlessly

@Shreya_Rao2 Install .net runtime 5.0 Cheers

This post made by @ashokkarale received 2 likes!

How to convert .tif file into .text file using Uipath

@Baby123 , Follow below steps. Drag “Load Image” activity available under the UI Automation section into the designer panel and supply the Image file path to it. … Drag “Tesseract OCR” activity(use your desired OCR engine i. … Drag “Message Box” activity to display the extracted OCR output. [image] Regards, Ashok )

This post made by @lrtetala received 2 likes!

Data table how to remove duplicate rows

@AJITH_SK Can you try the below [image] DT.AsEnumerable() _ .GroupBy(Function(row) row.Field(Of String)("Name") & row.Field(Of Integer)("Age") & row.Field(Of String)("City")) _ .Select(Function(Group) Group.First()) _ .CopyToDataTable() Output: [image] Cheers!!

Top 3 Most Liked Solutions

This solution provided by @rlgandu received 1 likes!

About error occur when open or creating new file or project

@Srinivasan_Devan Please restart your UiPath studio

This solution provided by @rlgandu received 1 likes!

REGEX match 5/6/7/8/9 numbers from a string

@Anelisa_Bolosha1 “\b\d{7,}\b” Please try this

This solution provided by @Parvathy received 1 likes!

Json object - before fetching value particular key found or not, need bool value

Hi @AJITH_SK Consider the below for the JsonObject Bool_Var = JObject("data")("out_value")(0).Value(Of String)("abcd") IsNot Nothing 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 | 24 February 2024

Top 3 Topics with Most Views

Write cell issue on output sheet made by @Happydayyy with 47 views.

Excel and Microsoft form automation made by @Sandhana_Murali with 42 views.

Fixing the datatable issue made by @Happydayyy with 42 views.

Top 3 Topics with Most Replies

Want to apply filter in my existing excel made by @Gopi_Krishna1 with 13 replies.

Table Extraction-Activate activities not working after being published to Orchestrator made by @DamilolaAdeogun with 11 replies.

Writtng in excel made by @Satyam_Shrivastava with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 10 posts!

@Happydayyy made 10 posts!

@vrdabberu made 8 posts!

Top 3 Most Liked Posts

This post made by @Satyam_Shrivastava received 2 likes!

Writtng in excel

I am having a Doubt i am reading excel file… With for each activity i am looping through each cell of column “Name” and “Salary” i want a Flow that if name repeating>1… then sum of the same name salary.

This post made by @pravallikapaluri received 2 likes!

Writtng in excel

Hi @Satyam_Shrivastava Follow the below approch. Assign activity: nameSalaries = New Dictionary(Of String, Double) For Each Row activity (ForEachRow in dt): If activity: Condition: nameSalaries.ContainsKey(row("Name").ToString()) Then: Assign activity: nameSalaries(row("Name").ToString()) += CDbl(row("Salary").ToString()) Else: Assign activity: nameSalaries(row("Name").ToString()) = CDbl(row("Salary").ToSt…

This post made by @supermanPunch received 1 likes!

Write cell issue on output sheet

Hi @Happydayyy , Could you check with the below modified workflow : WriteCell_Output.zip (34.3 KB) To make it clear, I believe the problem was with the Input data that you were using. Empty spaces were found in the 2.1 Summary sheet at the end. I deleted the empty rows found in that sheet and that particular issue was resolved (assumed it was a typo error in the sheet). In addition to the above, I made a correction in the workflow by removing a For Each Row loop as I thought it was not neces…

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

WHILE inside FOR EACH activity

There’s no need for a while loop. You just need a variable that keeps track of the previous invoice number and then compare it with the current invoice number in the For Each Row loop. If-condition: CurrentRow("Num_Invoice").ToString.Equals(previousInvoice) [image]

This solution provided by @suraj.setty received 2 likes!

I can't find Close book activity for Excel

Hi @IPIX , Close Workbook activity belongs to Classic Activities, you can use it by enabling “Show Classic” from the Filter. [image] If you are using modern activities , the excel will be Closed Automatically when you use the Scope.

This solution provided by @rikulsilva received 1 likes!

Would need solution for the same topic

Hi @anjasing UiPath Integrarion for Azure DevOps was updated and you need update the tasks version in your pipelines to windows project build properly. To do this, In your pipeline, before UiPath Pack task, add UiPath Install Platform task and choose a windows cli. Update all UiPath task to 4.* version You don’t need update the extension itself

---

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

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

[system]

Daily Forum Report | 25 February 2024

Top 3 Topics with Most Views

The given key was not present in the dictionary in process transaction successful made by @Mesut_Can with 43 views.

Outlookの連携がうまくいきません。ライブラリのコンパイルプロセス中に予期しないエラー made by @Fujiki_Yu with 39 views.

Wordの変更履歴を自動ですべて反映させたい made by @711 with 39 views.

Top 3 Topics with Most Replies

If Statement not recognizing condition made by @Faded with 17 replies.

The given key was not present in the dictionary in process transaction successful made by @Mesut_Can with 15 replies.

I want to copy a Column from A3 to end until data is their and paste using the value option in the excel made by @Gopi_Krishna1 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@vrdabberu made 11 posts!

@efelantti made 7 posts!

Top 3 Most Liked Posts

This post made by @Gopi_Krishna1 received 2 likes!

I want to copy a Column from A3 to end until data is their and paste using the value option in the excel

Proceed in that way you told

This post made by @efelantti received 2 likes!

The given key was not present in the dictionary in process transaction successful

It’s possible for newer versions Setting the Output property for failed transactions is only possible when connected to a 2022.10 and newer versions of Orchestrator. The Set Transaction Status activity now has both Output and Analytics data present in Orchestrator even when the status of the item is Failed.

This post made by @supermanPunch received 2 likes!

The given key was not present in the dictionary in process transaction successful

Hi @Mesut_Can , Have you tried performing it in Debug Mode with a Complete new Queue (Delete and Recreate Queue and Add Items) ? This should give us a direction on the error that’s occurring. With Debug Mode and new Queue Items, if the Activity gets an Error, we can then simply check the currentItem value in Immediate Panel. We will be able to understand to what Queue Item it belongs to and if the necessary Output data is present in it.

Top 3 Most Liked Solutions

This solution provided by @rmorgan received 1 likes!

How to make Dynamic Selectors

so using UiExplorer from studio and a blank form, you need to look into one of the text entry boxes . I have made a simple for in html to demonstrate [image] In the below image of uiexplorer when clicking on the text entry I can see that the text entry is currently on row 2. However when youve added a row this will increment each time a row is added. meaning that the selector for the type into will need to change each time a row is added [image] Now I have added a row of data, you can see …

This solution provided by @pravallikapaluri received 1 likes!

Get ocr text not working in second pdf

Hi @dipon1112000 1.Use Read PDF with Ocr,Store the output in the string var 2.Use Find Matching Patterns activity,Pass the Regular expression Pattern to extract the value,String var in Text to be search in,Store the output in the FirstMatch as you have only one output. The below screenshots will help you out [image] [image] Hope it helps!!

This solution provided by @Yoichi received 1 likes!

シーケンスを出ると変数の中身が空になる

こんにちは まずは変数のスコープの確認と、同名の引数の有無の確認をいただくのが良いかと思います。

---

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

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

[system]

Daily Forum Report | 26 February 2024

Top 3 Topics with Most Views

Exclude Holidays,Saturday and Sunday from Calender made by @yashashwini2322 with 51 views.

Regexエラーの原因 made by @gorby with 49 views.

How to filter the data in a text file to required format. Can anyone help me please made by @PriyaReddy with 48 views.

Top 3 Topics with Most Replies

繰り返し（各UI要素）のエラーについて made by @ando0403.primal with 16 replies.

Taxonomy Manager is Not Opening made by @MD_Farhan1 with 14 replies.

How to filter the data in a text file to required format. Can anyone help me please made by @PriyaReddy with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@rlgandu made 20 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @Arvind_Kumar1 received 2 likes!

Announcement - Apps For Action Center On Cloud - Preview Release

@Vishal_Kalra @ruchirmahajan Check this if you want to learn more. [How to Build Powerful UiPath Apps with Action Center: A Step-by-Step Guide]

This post made by @Nawazish_Ahmad received 2 likes!

Hash/de-hash text

Hi @simone.trenta Hash Text activity is not suitable for this purpose because it is used for hashing, which is a one-way cryptographic function and cannot be reversed. Instead of this you can use Encrypt Text & Decrypt Text Activity.

This post made by @pere received 1 likes!

UiPath.Workday.Activities package - Unable to find package ActiproSoftware.Wpf

Thanks for further clarification. Around the same time I was opening a ticket and that’s on par with the explanations there. Cheers!

Top 3 Most Liked Solutions

This solution provided by @postwick received 1 likes!

Computer vision in standalone environment

You don’t have to deploy a server like that. You can just use the UiPath.ComputerVision.LocalServer dependency. Then in Project Settings set Computer Vision to local server.

This solution provided by @jose.ordonez1 received 1 likes!

Comparing the present data with the previously data from the excel

Hi Adithyeshwar_goud, Please check this demo project with the sollution. Demo.zip (3.5 KB) Cheers!

This solution provided by @Nawazish_Ahmad received 1 likes!

Value of string cannot be converted

Hi @dipon1112000 Try this in Assign Activity Change = Change.Concat({Account}).ToArray Hope it will 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 | 27 February 2024

Top 3 Topics with Most Views

Package is removed, yet its activities are still being shown in the available list made by @pere with 74 views.

Update to Integration Service Activities completely breaks functionality of Microsoft Teams Get Record made by @pere with 66 views.

How to bold header in file excel by processed from Uipath? made by @bayu.herlambang with 56 views.

Top 3 Topics with Most Replies

Convert HTML String to Datatable made by @yashashwini2322 with 15 replies.

データテーブル同士の日付型を合わせたい made by @111860 with 11 replies.

How do we check the data is available in the XML file? made by @Nandhish_Srinivas with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 40 posts!

@rlgandu made 28 posts!

@ashokkarale made 25 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 2 likes!

I have lost my account, how to find out it?

@jmy , Welcome back to UiPath community! I have highlighted this to community moderators in background. They would be help you soon. Thanks, Ashok

This post made by @Parvathy received 2 likes!

How to bold header in file excel by processed from Uipath?

Hi @bayu.herlambang Use the below Macros code to make A1:F1 bold. Place the Invoke VBA acitvity after the first Set Range Color activity: Sub BoldHeaders() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet's name With ws.Range("A1:F1").Font .Bold = True End With End Sub [image] Properties of Invoke VBA [image] Text file path: Macos Code.txt (211 Bytes) Hope it helps!!

This post made by @Sandeep_Alexander_Goni received 2 likes!

UiPath Community Forum product release: Explore your new user experience with our latest developments

This is awesome will definitely try this

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

How to convert .tif file into .text file using Uipath

@Baby123 , Follow below steps. Drag “Load Image” activity available under the UI Automation section into the designer panel and supply the Image file path to it. … Drag “Tesseract OCR” activity(use your desired OCR engine i. … Drag “Message Box” activity to display the extracted OCR output. [image] Regards, Ashok )

This solution provided by @pravallikapaluri received 1 likes!

Taxonomy manager is not working throwing .net missing Error

@kishan.savaliya Try check by downgrading the Package One by one and update as below.At some Version,you cannot find the error. [image] Hope it helps!!

This solution provided by @Lak_Ui received 1 likes!

How to activate AI Centre in Pro Trial Version?

Go to DefaultTenant-> Services and then enable

---

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

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

[system]

Daily Forum Report | 28 February 2024

Top 3 Topics with Most Views

日本語版 オートメーション デベロッパー資格試験のご紹介 made by @Makiko_Tsuda with 122 views.

Get Form Tasks not retrieving existing Task IDs made by @Ankit_Jain3 with 50 views.

Image type PDF made by @abivanth.r with 43 views.

Top 3 Topics with Most Replies

How To Check grater date in a column using FilterDataTable activity? made by @RobotUi with 24 replies.

Issue with Positive look ahead made by @devasaiprasad_K with 15 replies.

Expresion con Contains que me da error made by @lily.RPA with 15 replies.

Top 3 Users Who Posted The Most

@Parvathy made 33 posts!

@ashokkarale made 30 posts!

@vrdabberu made 28 posts!

Top 3 Most Liked Posts

This post made by @LukeTolchard received 3 likes!

Sort 'Triggers' List by next run time

Hi everyone, Please consider allowing users to sort the “Triggers” page on Orchestrator by “Next Run Time”, or allowing us to search for triggers on specific robots. As an organisation we manage several hundred processes and it is becoming increasingly difficult to identify free windows on our machines. As the majority of columns in this table are sortable, this seems like a strange omission. Is there a technical reason this cannot be done? [image]

This post made by @mini9301 received 2 likes!

Looking for Image Activities

I got it from your explanation. Thank you…

This post made by @Yoichi received 2 likes!

やなやらやはゆ

すでにPDFファイルがあって、何らかのツールでそれを別のPDFに変換しているということでしょうか？ 現在どのようなツール・アプリケーションを使用しているのでしょうか？ それともソースはEXCELやWORDがあり、それをPDF化するということでしょうか？

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Write cell issue on output sheet

Hi @Happydayyy , Could you check with the below modified workflow : WriteCell_Output.zip (34.3 KB) To make it clear, I believe the problem was with the Input data that you were using. Empty spaces were found in the 2.1 Summary sheet at the end. I deleted the empty rows found in that sheet and that particular issue was resolved (assumed it was a typo error in the sheet). In addition to the above, I made a correction in the workflow by removing a For Each Row loop as I thought it was not neces…

This solution provided by @Anil_G received 1 likes!

I want to check weather any data is presnt in queues in orchestrater

@Adithyeshwar_goud you can first use get queue items and get only new stattus…in the retunred variable check qulistitems.count>0 on then side you have items on else side you dont cheers

---

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

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

[system]

Daily Forum Report | 29 February 2024

Top 3 Topics with Most Views

Solutions Management GA Announcement made by @Alexandru_Szoke with 80 views.

User guide for diagnostic tool is not specifying the binary name made by @pere with 58 views.

Total madness with variable list when using the "Remove Unused" with variables made by @pere with 56 views.

Top 3 Topics with Most Replies

Use assign for write data but not write? made by @fairymemay with 16 replies.

Merging cells made by @Pogboom with 16 replies.

Unattended robot is working but some activities failed made by @VelanDev with 16 replies.

Top 3 Users Who Posted The Most

@Yoichi made 28 posts!

@lrtetala made 23 posts!

@rlgandu made 23 posts!

Top 3 Most Liked Posts

This post made by @Alexandru_Szoke received 11 likes!

Solutions Management GA Announcement

We’re finally ready to launch Solutions Management. It’s been more than half a year working on it, but with this enterprise release, everyone will be able to manage a lifecycle of solutions, once built. We’d like to thank everyone involved in the preview program that gave us feedback on insider.uipath.com – You rock! What is UiPath Solutions Management A new way to package, export and deploy automations bundling various UiPath components across multiple environments. We call them solutions. L…

This post made by @Mr.sharma received 5 likes!

UiPath Studio Compilation Error: Resolve 'System.InvalidOperationException' by Explicitly Referencing UiPath.CodedWorkflows Package

Error : - 23.10.3+Branch.support-v23.10.Sha.ceeb2a4c480c2b7a4d12600ae5d39a26b6930830 Compilation failed or was cancelled. Error: System.InvalidOperationException: In order for projects containing coded workflows to be compiled, the UiPath.CodedWorkflows package must be referenced explicitly if none of the imported packages already depend on it., HResult -2146233079 Solution: - 1.Navigate to UiPath Package Manager in UiPath Studio, 2.Under All Packages section search UiPath.CodedWorkflows a…

This post made by @vrdabberu received 2 likes!

How to remove empty values row in datatable?

Hi @saninfo273 Try this in Assign activity: Save To: dt Value To Save: dt.AsEnumerable().Where(Function(row) Not row.ItemArray.Skip(1).All(Function(cell) cell Is DBNull.Value OrElse String.IsNullOrWhiteSpace(cell.ToString()))).CopyToDataTable() Regards

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How take Multiple screenshots

@Harish_Ghadage Your process would be like this Use application /browser and provide the website to open Inside that use for loop with enumerable.Range(0,20) Inside loop use take screenshot After that save the image to word using add image activity(use word scope activity to open word) Next use a mouse scroll with distance and give 1 and check if it is scrolling fullpage else try with other number Hope this helps Cheers

This solution provided by @FerdinanAlberto received 1 likes!

Problem of database /

[image] [image] Main MU-bias.xaml (26.1 KB)

This solution provided by @FerdinanAlberto received 1 likes!

Copy from one excel datatable format to another datatable formart

You wnat Output Like This? [image] If Yes here the xaml you can use, but first just let the Destination sheet Empty. CopyExcel.xaml (12.8 KB)

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

@Anil_G received 36 likes for their solutions!

@mkankatala received 35 likes for their solutions!

@Yoichi received 31 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 March 2024

Top 3 Topics with Most Views

Automation Ops - Pipelines GA announcement made by @alexandru.iordan with 66 views.

Dev Dives: Master advanced authentication and performance in Productivity Activities made by @nisargkadam23 with 64 views.

LinQ query help regarding duplicates made by @Biswas_Ishan with 55 views.

Top 3 Topics with Most Replies

How to check all the required columns are present in the excel made by @Gopi_Krishna1 with 27 replies.

Output of Match Activity made by @devasaiprasad_K with 26 replies.

Challenge! How to extract Hidden rows i datatable made by @copy_writes with 23 replies.

Top 3 Users Who Posted The Most

@Parvathy made 38 posts!

@rlgandu made 27 posts!

@vrdabberu made 27 posts!

Top 3 Most Liked Posts

This post made by @nisargkadam23 received 4 likes!

Dev Dives: Master advanced authentication and performance in Productivity Activities

Hello UiPath Community! Are you ready to explore the setup of Microsoft 365 and Google Workspace authentications? Want to learn new strategies to optimize batching capabilities? I have great news for you! I am Nisarg Kadam, UiPath MVP and Technology Architect at SimplifyNext, and alongside Alexandru Crijman (@AlexCrijman), my fellow Product Manager at UiPath, we invite you to the next Dev Dives episode on March 28th! For this session, we’ll talk about Google Workspace and Microsoft 365 Scopes…

This post made by @alexandru.iordan received 2 likes!

Automation Ops - Pipelines GA announcement

Automation Ops - Pipelines - GA Release Announcement We are thrilled to announce the General Availability of Automation Ops Pipelines! This release introduces UiPath’s built-in CI/CD engine, designed to streamline the automation development lifecycle. Crafting your Pipeline is a breeze; simply create your automation using your preferred tool: Studio or Studio Web. With Automation Ops Pipelines, each new version of your automation undergoes a series of essential steps, including s…

This post made by @Biswas_Ishan received 2 likes!

LinQ query help regarding duplicates

Yes!!! Now it finally works [image]

Top 3 Most Liked Solutions

This solution provided by @Nawazish_Ahmad received 2 likes!

Hash/de-hash text

Hi @simone.trenta Hash Text activity is not suitable for this purpose because it is used for hashing, which is a one-way cryptographic function and cannot be reversed. Instead of this you can use Encrypt Text & Decrypt Text Activity.

This solution provided by @rlgandu received 1 likes!

I Got Error During Run the Automation?

@MD_Farhan1 Delete the UiPath.IntelligentOCR.Activities package and Download the Package From manage package Runtime Rule:Lowest applicable Version

This solution provided by @ashokkarale received 1 likes!

Taxonomy Manager is Not Opening

@MD_Farhan1 , If you can use Enterprise Trial, you have option to downgrade. Register for a 60-day UiPath Studio Enterprise trial license. Log into the UiPath Automation Cloud hub. Click on the Help link in the lower left hand corner. [image] Click Downloads tab Click Other Versions [image] Download the specific UiPath Studio version you wish to install. [image] 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 | 02 March 2024

Top 3 Topics with Most Views

In my project , they are asking for a presentation on the new advanced features of uipath made by @Ragavi_Rajasekar with 31 views.

Can someone suggest for practicing API's in Uiapth made by @devasaiprasad_K with 29 views.

Unable to get enterprise license trial key to activate offline made by @ng.zijian with 29 views.

Top 3 Topics with Most Replies

Append Column made by @amitha.aenugula with 6 replies.

Check if the web form contains a specific text made by @starterui with 5 replies.

Gsuite Application Scope - How to over come the token refresh made by @BharathKamalapur with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 14 posts!

@Parvathy made 12 posts!

@Gopi_Krishna1 made 8 posts!

Top 3 Most Liked Posts

This post made by @Ellie.Smith received 1 likes!

Selector taking a really long time to load for popup window, and always failed to find the element in debug runs

Hi, I am learning UiPath with the provided training, in one exercise, I am trying to add a “click” activity to close the pop up windows which appears after clicking “Add Account”. [image] However, the UI selector always took a very long time to load when the popup window is present. When I finally add the target element with 100% validation score, it still failed with a timeout when debugging the process. Any ideas for why it happens? - I compared the given solution and my own target/anchor…

This post made by @amitha.aenugula received 1 likes!

Append Column

Hi all, I got a question, I have two excels Excel1 and Excel2. I want to append the data of ColumnA of Excel1 with ColumnC of Excel2 Same way ColumnB of Excel1 with ColumnD of Excel2 and ColumnC of Excel1 with ColumnE of Excel2. Note :Both the excels has different Column Names. Can anyone help me on this? Appreciate your help.

This post made by @amitha.aenugula received 1 likes!

Append Column

Excel 1 |Column 1 | Column 2 | Column 3 | Column 4| |786 | abc | 12345 | cc| |456 | cfg | 7865 | cc| |678 | uyr | 9865 | cc| |675 | adf | 56787 | cc| Excel 2| |Date | CUCC | Name | ACC| |10-12-2024 | 673 | rty | 86| |28-02-2024 | 332 | uyt | 85| |28-02-2024 | 4576 | hgf | 34| |28-02-2024 | 567 | kjh | 56| Output |Date | CUCC | Name | ACC| |10-12-2024 | 673 | rty | 86| |28-02-2024 | 332 | uyt | 85| |28-02-2024 | 4576 | hgf | 34| |28-02-2024 | 567 | kjh | 56| |Empty | 7…

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

How to bold header in file excel by processed from Uipath?

Hi @bayu.herlambang Use the below Macros code to make A1:F1 bold. Place the Invoke VBA acitvity after the first Set Range Color activity: Sub BoldHeaders() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet's name With ws.Range("A1:F1").Font .Bold = True End With End Sub [image] Properties of Invoke VBA [image] Text file path: Macos Code.txt (211 Bytes) Hope it helps!!

This solution provided by @postwick received 2 likes!

Package is removed, yet its activities are still being shown in the available list

It’s how it’s designed. You see the activities so you can use them, and if you use them the dependency is automatically installed. If you don’t need the activity, why would you search for it? If you go to Settings/Design there is a setting named “Show activities available for install” and you can turn it off. This setting is described in the documentation. https://docs.uipath.com/studio/standalone/2023.4/user-guide/configuring-studio-settings

This solution provided by @Prateek_Gulab_Pathak received 1 likes!

How to Compare Column 1 quantity to column 2 quantity i.e column 1 values is less than or equal to column 2

thanks for the solution It worked!!!

---

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

Top 3 Topics with Most Views

Not able to send image in Emailbody using SMTP made by @Bandi_Vinay_Kumar with 44 views.

Hi, how to get name based on code made by @mohamed.saty2012 with 38 views.

How to write data to the first blank line? made by @muhammet.sezer2 with 38 views.

Top 3 Topics with Most Replies

Not able to send image in Emailbody using SMTP made by @Bandi_Vinay_Kumar with 14 replies.

Excel mapping1 made by @0bb4628e217fd43ac86ac9294 with 12 replies.

Hi, how to get name based on code made by @mohamed.saty2012 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@vrdabberu made 15 posts!

@Parvathy made 11 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 1 likes!

Write Range Problem in Save Excel File as

Hi @CHAN_Hiu_Fung_Victor_Stud Give Write Range Workbook outside Use Excel File and pass the new file name which you give in Save Excel File activity in Write Range Workbook. Regards

This post made by @teslyak9437 received 1 likes!

Specify the dates that were on Friday, Saturday and Sunday

Which active should I use? And where should I put the if condition? And what should it look like?

This post made by @omar_ismail received 1 likes!

Record a video with a trigger

thank you for sharing the above however i need an activity to record what is happening in the screen for the user not for the BOT

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

1st date and last date of every month in an order

Hi @Samje Check the below xaml file. Sequence11.xaml (9.1 KB) Output: [image] Please let me know if the workflow doesn’t open. Regards

This solution provided by @postwick received 1 likes!

Please help-sql query error

The NULLs are probably the issue. It has been a long time since I’ve worked with SQL so I can’t remember how to handle this. Maybe… Where [Product Code] = 1920 AND [Campaign Code] IS NOT NULL AND [Campaign Code] 'HCCFUNNP519'

This solution provided by @lrtetala received 1 likes!

How to pass date and fix time in Get Queue item Activity?

Hi @Sanket_Shinde1 Try this currentDate = DateTime.Now.Date fromDate = currentDate toDate = currentDate.AddHours(23).AddMinutes(59).AddSeconds(59) Get Queue Items activity: From: fromDate To: toDate 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 March 2024

Top 3 Topics with Most Views

Read Range Workbook: Index was outside the bounds of the array made by @Hemant_Deshmukh with 52 views.

Filter datatable fetched from SAP ,future date should be present made by @jain.priti26 with 52 views.

How to use assign activity for following case made by @NISHITHA with 50 views.

Top 3 Topics with Most Replies

How to extract the exact value from the other sheets without rounding the decimals made by @anjani_priya with 23 replies.

Filter datatable fetched from SAP ,future date should be present made by @jain.priti26 with 22 replies.

How to compare two data table made by @copy_writes with 19 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 37 posts!

@Yoichi made 22 posts!

@mkankatala made 22 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

UiPath Excel error with Office 365

Hi @A_Learner Check the below thread, Hope it helps!!

This post made by @Parvathy received 2 likes!

Whats the Difference Between uipathActivites

Hi @devasaiprasad_K dt.columnscount: This property is used with UiPath Database activities like the “Execute Query” activity. It’s accessed directly as a property of the DataTable variable. It returns an integer representing the number of columns in the DataTable. dt.columns.Count: This property is used with standard DataTable operations in UiPath, such as manipulating DataTables using VB.NET. It’s accessed through the Columns property of the DataTable variable, which returns a collectio…

This post made by @Biswajeet_kumar received 2 likes!

Getting issue while Substracting extracted dates

Hi @madhavraichur25 Welcome to the community! This can be achieved using an assign instead of three with following steps: create a variable named No_Of_days as Int64 by selecting browse for types. In the value use this expression DateDiff(DateInterval.Day,CDate(now.ToString(“MM/dd/yyyy”)),Cdate(DateTime.ParseExact(your_date_String_Var.Trim,“dd/MM/yy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”))) Cheers! Biswajeet Kumar

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

How to remove duplicate values

Hi @Chippy_Kolot Try this [image] DT1.AsEnumerable() _ .GroupBy(Function(row) New With { _ Key .Name = row.Field(Of String)("Name"), _ Key .Phno = row.Field(Of Double)("Phno") _ }) _ .Select(Function(Group) Group.First()) _ .CopyToDataTable() Test (6).xlsx (9.2 KB) Regards,

This solution provided by @tazunnisa.badavide received 1 likes!

Linq for Full outer join

UiPath | LINQ Join Function | Inner Join | Left Outer Join | Right Outer Join | Full Outer Join - YouTube

This solution provided by @Anil_G received 1 likes!

Help related to choose right UI path License for my use case

@hvishwaradhya yes you can if the process is background 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 | 05 March 2024

Top 3 Topics with Most Views

Cannot see the processes in UiPath Assistant for an Unattended robot made by @Gokul_Murali with 61 views.

How to print File size? made by @Smitesh_Aher2 with 52 views.

ブラウザの操作中にポップアップが表示された際にそのポップアップに対してアクションをしたい made by @nakajima-sa with 51 views.

Top 3 Topics with Most Replies

How to print File size? made by @Smitesh_Aher2 with 16 replies.

Please help in getting the second word (dynamic word which varies in each run) in a line using regex match made by @Nancy29 with 12 replies.

How to obtain data from multiple Columns in data table made by @arturo.ayala with 12 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 37 posts!

@mkankatala made 24 posts!

@Parvathy made 22 posts!

Top 3 Most Liked Posts

This post made by @pathrudu received 3 likes!

Studio Web Community Quiz challenge: put your automation skills to the test and have a chance to win prizes!

Hello @loredana_ifrim Below are my observations: Options provided for 24th Question option are given same for 28 and 24 and the question is correct at 28th. For Question 28th Option provided is Removes the characters starting from the 6th character and onwards but it removes the characters from index 6 or we can say after 6th character. Question 14 - Select Actions > Add Annotations and enter the annotations in annotation field as we don’t have option under rename but options provided Select A…

This post made by @postwick received 2 likes!

No working directory in Use Application/Browser, output variable wrong type for Open Application

Classic activities shouldn’t be gone. Go to the Activities pane and click the filter icon at the top. Check Classic: [image] You can freely mix classic and modern activities in your project.

This post made by @mkankatala received 2 likes!

Send Outlook mail Message is not working

Hi @Harshita_Chhabra Send Outlook Mail Message activity and Outlook activities will work when the Outlook application is installed in your machine. For using Outlook activities definitely you have to install Outlook application, If not installed yet do install it. If already installed then update the Ms Office applications, this may sort. Suggestion : If you are not able to install Outlook application then use the Send SMTP Mail Message activity, by this activity not required to install Outl…

Top 3 Most Liked Solutions

This solution provided by @ptrobot received 2 likes!

How to serialize an exception?

exception.ToString should give you the entire message, not just an error type. But you can always access the individual properties with: exception.Message exception.Source exception.StackTrace And if there’s an InnerException: exception.InnerException.ToString

This solution provided by @ashokkarale received 1 likes!

<VBA> How to pass Array into VBA Script parameters

@anjali123 , Please find the updated code here. I have added below logics ProjectVBA.zip (277.7 KB) Get Unique AG’s to filter into an array of string [image] Convert and pass array to string and pass to VBA. [image] VBA Code [image] Thanks, Ashok

This solution provided by @Parvathy received 1 likes!

How to choose file instead of using directory.get files

Hi @lakshmi.mp If you want to manually select the folder, use Browse For File. This will open a pop up where you can select the required file. [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 | 06 March 2024

Top 3 Topics with Most Views

AI-OCRはオフライン環境で利用可能？ made by @gorby with 62 views.

Regex multiline selection made by @Chethan_M1 with 60 views.

Dispatcher related question made by @naveen.s with 60 views.

Top 3 Topics with Most Replies

Remove the duplicates in Excel based on two column values made by @Vineet_Joshi with 24 replies.

Error of assigning the filter table made by @Happydayyy with 23 replies.

Macro to filter and put vlookup formula in following rows made by @Gopi_Krishna1 with 21 replies.

Top 3 Users Who Posted The Most

@Parvathy made 31 posts!

@ppr made 26 posts!

@ashokkarale made 25 posts!

Top 3 Most Liked Posts

This post made by @Kanak_Lata_Singh received 2 likes!

Studio Web Community Quiz challenge: put your automation skills to the test and have a chance to win prizes!

Hi , Thank you for the quiz . Have taken it . Waiting for the results now. Regards

This post made by @ashokkarale received 2 likes!

Append range workbook changes =TODAY()+14 function

@MarkusI, Append Range will write plain text values. If you want to keep the formula, you will have to use excel scope and update the cell formula accordingly. Thanks, Ashok

This post made by @vrdabberu received 2 likes!

Reframework Conection : Want to create a final squenece after the process is run in End Process state

Hi @samantha_shah Create a Argument in_Config as in Argument inside Close All Applications.xaml. And configure it with Config which is present as variable in End Process in the Invoke Arguments section. [image] [image] In the same way you can access ExcelFilePath too. Regards

Top 3 Most Liked Solutions

This solution provided by @healsko_ho received 1 likes!

Help with getting value of Uielement and storing it without using Get text

You’re right. When the index of ‘Past Due’ is changed someday, you’re still getting that value of past due. More specific attributes will make your automation more accurate.

This solution provided by @Nikhil_V received 1 likes!

Error when modifying the Extraction Result before sending it to validation station

Found a solution by connecting with UiPath Technical Team. io_ExtractionResults.ResultsDocument.Fields(7).SetValue(new ResultsValue(" ",nothing,0,0)) Here, last two variables 0,0 used for Confidence and OCR Confidence and we need to use the filter in the action center. [image] Regards, Nikhil.

---

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

Top 3 Topics with Most Views

Handling multiple delimiters made by @NILESH.BOT369 with 47 views.

How do i extract last character from a string made by @sophiey with 47 views.

Fuzzy Selector editing experience on par with Strict Selector editing experience made by @Cedrik with 46 views.

Top 3 Topics with Most Replies

Handling multiple delimiters made by @NILESH.BOT369 with 18 replies.

Understanding the Difference made by @devasaiprasad_K with 18 replies.

Excel formular question made by @Happydayyy with 18 replies.

Top 3 Users Who Posted The Most

@mkankatala made 53 posts!

@Yoichi made 30 posts!

@pravallikapaluri made 25 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

Handling multiple delimiters

Hi, Can you try the following sample? dtResult = dt.AsEnumerable.Select(Function(r) dtResult.LoadDataRow({r(1),System.Text.RegularExpressions.Regex.Match(r(3).ToString,"\d+").Value,System.Text.RegularExpressions.Regex.Match(r(3).ToString,"\d+$").Value},False)).CopyToDataTable [image] Sample Sample20240307-3.zip (9.4 KB) Regards,

This post made by @nisargkadam23 received 3 likes!

Compilation Errors with UiPath Studio Version v2023.10.4

Hi @fernando_zuluaga, Thank you so much for the suggestions. The second solution worked for me, I donwgraded the UiPath Studio to version 2022.10.13 the latest previous LTS version of UiPath Studio. This helped me to immediately publish and compile the code.

This post made by @gRao received 2 likes!

Studio Web Community Quiz challenge: put your automation skills to the test and have a chance to win prizes!

Hi @pathrudu , I agree with you and have the same observations.

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Write Range Problem in Save Excel File as

Hi @CHAN_Hiu_Fung_Victor_Stud Give Write Range Workbook outside Use Excel File and pass the new file name which you give in Save Excel File activity in Write Range Workbook. Regards

This solution provided by @Anil_G received 1 likes!

Gsuite Application Scope - How to over come the token refresh

@BharathKamalapur If you use client id and secret it would not ideally Cheers

This solution provided by @Parvathy received 1 likes!

How to overwrite the file for every time run the robot

Hi @CHAN_Hiu_Fung_Victor_Stud Use Delete File activity before Write Range Workbook as Write Range Workbook will create a file during runtime. So the extracted data is written to excel. Hope you understand!!

---

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

Top 3 Topics with Most Views

Can't open saved msg files made by @b.forbes with 58 views.

Can not assign made by @dipon1112000 with 49 views.

How to fetch queue data base on timestamp? made by @Sanket_Shinde1 with 40 views.

Top 3 Topics with Most Replies

How to fetch queue data base on timestamp? made by @Sanket_Shinde1 with 16 replies.

Can't open saved msg files made by @b.forbes with 15 replies.

I have to get each network nodes global title number range using regular expression made by @shaik.muktharvalli1 with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 24 posts!

@Parvathy made 20 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Write cell issue if no data

Hi, As there is no row in “Type of sample” column, lastrow variable will be -1 and it causes this exception. How about set “First empty row”? [image] Regards,

This post made by @mkankatala received 2 likes!

Write cell issue if no data

Hi @Happydayyy I have modified the Workflow for this, → insert the Write cell activity and give the below expression in What to write field, "='MU-bias (Within Range)'!T2" Check the below workflow for better understanding, [image] Main MU-bias (combined count (mainsheet).xaml (65.1 KB) Output: [image] Hope it helps!!

This post made by @Happydayyy received 2 likes!

Write cell issue if no data

thanks you so much. the issue is fixed!!

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 2 likes!

Whats the Difference Between uipathActivites

Hi @devasaiprasad_K dt.columnscount: This property is used with UiPath Database activities like the “Execute Query” activity. It’s accessed directly as a property of the DataTable variable. It returns an integer representing the number of columns in the DataTable. dt.columns.Count: This property is used with standard DataTable operations in UiPath, such as manipulating DataTables using VB.NET. It’s accessed through the Columns property of the DataTable variable, which returns a collectio…

This solution provided by @Biswajeet_kumar received 2 likes!

Getting issue while Substracting extracted dates

Hi @madhavraichur25 Welcome to the community! This can be achieved using an assign instead of three with following steps: create a variable named No_Of_days as Int64 by selecting browse for types. In the value use this expression DateDiff(DateInterval.Day,CDate(now.ToString(“MM/dd/yyyy”)),Cdate(DateTime.ParseExact(your_date_String_Var.Trim,“dd/MM/yy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”))) Cheers! Biswajeet Kumar

This solution provided by @Vinit_Mhatre received 2 likes!

How to generate random password without using Custom Activity?

Hi @Random_Bot , Try with below, hope its help you. char as string = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ" randomtext as string = New String(Enumerable.Repeat(characters, 9).Select(Function(s) s((New Random()).Next(s.Length))).ToArray()) output as string = String.Format("{0}@{1}", System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(randomText), New Random().Next(10000).ToString("D4")) [image] Regards, Vinit Mhatre

---

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

Top 3 Topics with Most Views

Invoice Numbers to pick 1, 2,3,4,5....103 made by @Raks_K with 40 views.

Number write cell issue made by @Happydayyy with 37 views.

Compare Two Data Table and find Only the UnMatch Column made by @marina.dutta with 35 views.

Top 3 Topics with Most Replies

Compare Two Data Table and find Only the UnMatch Column made by @marina.dutta with 14 replies.

Copy row to new sheet by LINQ made by @fairymemay with 11 replies.

Extract value before and after a line break that starts with a specific value made by @LagunaAJ with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@vrdabberu made 20 posts!

@Jayesh_678 made 13 posts!

Top 3 Most Liked Posts

This post made by @Ravi_Rawal received 3 likes!

List of string variable

How can a list of string variables be utilized within the body of an email and i want to add comma(,) separated.

This post made by @Biswajeet_kumar received 3 likes!

List of string variable

Hi @Ravi_Rawal Welcome to the community! As I understand from the above that you have a list of string and you want to concat all the items present in the list in a string variable and use it in your email body. For this you can follow few steps: Create string variable say Joined_string Use a assign activity to save the value in Joined_string by using the expression String.Join(", ",ListOfString) Use the Joined_string in your email body. [string 1] Let me know if this works for you! Chee…

This post made by @LagunaAJ received 2 likes!

Extract value before and after a line break that starts with a specific value

Thanks @Anil_G! Just a question, what app are you using with the screenshot you used?

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Delete Duplikates

Hi @NicoB24 Try this [image] DT.AsEnumerable() _ .GroupBy(Function(row) row.Item(0).ToString()) _ .SelectMany(Function(Group) If(Group.Skip(1).Any(), Group.Skip(1), Group.Take(1))) _ .CopyToDataTable() Input: [image] Output: [image] Regards,

This solution provided by @lrtetala received 1 likes!

Uipath Pivot table find in a excel file

@learning_sourav [image]

This solution provided by @ashokkarale received 1 likes!

Send Outlook mail Message is not working

Hi @Harshita_Chhabra, Welcome to the UiPath Community! As mentioned by @mkankatala, it seems Outlook installation issue or not installed on the machine issue to me. If you should be using Outlook then you will have to get the Outlook fixed/Installed else you have below options. To Get/Read Emails: Get IMAP Mail Messages MicrosoftOffice365 Activity Get Mail To Send Emails: Send SMTP Mail Message MicrosoftOffice365 Activity Send Mail/Reply To Mail 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 | 10 March 2024

Top 3 Topics with Most Views

Array COnversion made by @devasaiprasad_K with 45 views.

Error when trying to open the taxonomy manager made by @Nathan_Goel with 45 views.

Unable to convert pdf files to datatable made by @joscares with 39 views.

Top 3 Topics with Most Replies

Removing new line in regex not working made by @joscares with 15 replies.

Array COnversion made by @devasaiprasad_K with 14 replies.

Error on reading range using workbook made by @joscares with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@joscares made 17 posts!

@marina.dutta made 11 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

How to Store UiPath Test Verification Output Message as a Variable?

[How to Store UiPath Test Verification Output Message as a Variable?]

This post made by @Happydayyy received 2 likes!

Can anyone help me cope with this problem

Thank you so much, I am trying to add something based on my task, if I encounter some problem later, can you help me as well? HAHAHAHA… Many thankssss!!

This post made by @Anil_G received 2 likes!

How to get match column names and unmatch column names from two data tables using linq

@marina.dutta break down For each row of dt1 select and load the data into dt3… dt1.AsEnumerable.Select(function(x) dt3.Clone.LoadDataRow First column to be quote number ({x(“Quote Number”).ToString, From the matching row in dt2 with quote number in dt1…get the row as itemarray String.Join(“,”,dt2.AsEnumerable.First(function(y) y(“Quote Number”).ToString.Equals(x(“Quote Number”).ToString)).ItemArray. For each item in the array check if the value in dt2 and dt1 are matching then dont get …

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

Append range workbook changes =TODAY()+14 function

@MarkusI, Append Range will write plain text values. If you want to keep the formula, you will have to use excel scope and update the cell formula accordingly. Thanks, Ashok

This solution provided by @Yoichi received 1 likes!

I have to get only Today's Pdf files from particular folder

HI, How about the following expression? todayFiles = System.IO.Directory.GetFiles("yourFolder","*.pdf").Where(Function(s) System.IO.File.GetCreationTime(s).Date=DateTime.Today).ToArray() note: todayFiles is string array type. The above identifies today’s file by creation time from file system. If it doesn’t work for you, can you share how to identify today’s file. Regards,

This solution provided by @Anil_G received 1 likes!

Needed template of Outlook in Reframework

@Vinit_Mhatre here is a sample it is same for any type other than queueitem…you just need toc hange the transactionitem get items using transactionumber RoboticEnterpriseFramework2.zip (956.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 | 11 March 2024

Top 3 Topics with Most Views

（「ファイル移動」のアクティビティ）/ （スラッシュ)は\ （バックスラッシュ）になってしまった made by @Buibui with 55 views.

How to read one by one row of excel? made by @Smitesh_Aher2 with 50 views.

Invoke VBScript bug made by @Anil_G with 46 views.

Top 3 Topics with Most Replies

I have to get each network nodes global title number range in for each loop using regex made by @shaik.muktharvalli1 with 25 replies.

Filter by linq made by @fairymemay with 19 replies.

実行版の挙動がおかしい、選択要素がずれる made by @m-takeda1 with 12 replies.

Top 3 Users Who Posted The Most

@mkankatala made 38 posts!

@Anil_G made 33 posts!

@Jayesh_678 made 30 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

（「ファイル移動」のアクティビティ）/ （スラッシュ)は\ （バックスラッシュ）になってしまった

こんにちは スラッシュはファイル名やフォルダ名に使用できない文字です [image] 最終的に実現したいことは何になりますでしょうか？

This post made by @adrian_sullivan received 2 likes!

Split coulmn on data table based on "," an dkeep data in data table

[image] so i need to split the column(3) based on the “,” then add a new row with all the original data except for what is before the “,” to end up with something like this [image] thanks Adrian Split dataTable.xlsx (11.3 KB)

This post made by @Yoichi received 2 likes!

（「ファイル移動」のアクティビティ）/ （スラッシュ)は\ （バックスラッシュ）になってしまった

name変数の中身はどのように生成されましたでしょうか？中の文字列中のスラッシュが半角になっていませんでしょうか？もし半角になっていたら全角にしてみてください。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

時刻の抽出についてのご相談

これが入力ですと正規表現は以下を試してみてはと思います。4の方はそのままでも通るように思えます。 System.Text.RegularExpressions.Regex.Match(期間,"(午前|午後)?\d+時(\d+分)?").Value

This solution provided by @Buibui received 1 likes!

（「ファイル移動」のアクティビティ）/ （スラッシュ)は\ （バックスラッシュ）になってしまった

問題が解きました。 移行する前に、/を半角から全角にしました。

This solution provided by @m-takeda1 received 1 likes!

実行版の挙動がおかしい、選択要素がずれる

本件、解決いたしました。 誤作動を起こしていたPCのedgeの設定が通常画面サイズ100%のところなぜか110%に設定されており、100%に設定し直したところ問題なく動くようになりました。 画像ではしておらず、厳密セレクターのみ要素で指定していても画面サイズに動作が引っ張られるものなのですね。 勉強になりました。 ありがとございます。

---

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.