Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 November 2023

Top 3 Topics with Most Views

UiPath Solutions Management now in Public Preview made by @Raisa_Bragarea with 81 views.

Raise an alert: You are not authorised! made by @SAMANTA_COTTACKAL1 with 51 views.

Can't retrieve Windows Credentials made by @hongjoo.choi with 42 views.

Top 3 Topics with Most Replies

Blank rows Excel Automation made by @akash_javalekar3 with 19 replies.

Count the number of tickets in last X days made by @niranjan_shetty with 19 replies.

Connecting into the UiPath VM using IP made by @aquinn with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 30 posts!

@Nguyen_Van_Luong1 made 13 posts!

@superpunchypp made 12 posts!

Top 3 Most Liked Posts

This post made by @Raisa_Bragarea received 13 likes!

UiPath Solutions Management now in Public Preview

UiPath Solutions Management now in Public Preview Ever wondered how to simplify your workload when working on complex projects? Ever had issues deploying your multiple processes, assets, queues, storage buckets and other dependencies across environments? And let’s not even talk about keeping all of this up to date. That’s even more complicated. Let’s talk about Solutions You can now package everything into a Solution, a collection of “components” built & configured on the UiPath platform, that…

This post made by @Josefina_Belgrave received 1 likes!

Automation Business Analyst Series 2023

[Cert.Three]

This post made by @Pallavi_Shirodkar1 received 1 likes!

Automation Business Analyst Series 2023

Hi, It was a great session today by @Anurag_Upadhyay. Thank you for the session. Question: What is the difference between a Process Definition Document and Process Design Document? If you could please help me with this question.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

データテーブルの列加工と突合

こんにちは UIPathでのループを減らすのでしたらまずは以下が考えられます。 Main.xaml [image] あるいは以下のように書くことも可能です シーケンス.xaml [image] Dim arrStr As String() = dtB.AsEnumerable.Select(Function(r) r(0).ToString).ToArray() dtA.AsEnumerable.Where(Function(r) arrStr.Any(Function(s) r(0).ToString.Contains(s))).ToList().ForEach(Sub(r) r(1)="True" End Sub ) Sample20231113-2L_Windows.zip (5.7 KB)

This solution provided by @Yoichi received 1 likes!

In IF activity, the IF condition is false. Still the process implements the Then sequence

Hi, Can you try to use <> operator instead of isnot operator because isnot operator doesn’t compare their value. Please see the following document in details. Regards,

This solution provided by @llayla received 1 likes!

HTTPS Service Request Error - Cannot find the requested object

after many times trying and error, the issue was on IT Team who owned the service. They told me that any missed on config setting for the service. Thanks for the help @Anil_G

---

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

Top 3 Topics with Most Views

Excelファイルの列や行を非表示にしたい made by @Yamasakia with 72 views.

DataTable segrgation made by @Akash_Javalekar1 with 53 views.

「アセット値を取得」アクティビティについて made by @chiharu-kikuchi with 44 views.

Top 3 Topics with Most Replies

Reading pdfs very slow made by @cemenike with 18 replies.

Assign all of the row in one assign made by @omar_ismail with 12 replies.

DataTable segrgation made by @Akash_Javalekar1 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 30 posts!

@postwick made 17 posts!

@Nguyen_Van_Luong1 made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Excelファイルの列や行を非表示にしたい

こんにちは 例えばClosedXMLなら以下になります。 [image] Using wb As New ClosedXML.Excel.XLWorkbook(filename) Dim ws As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetName) ws.Rows(3,4).Hide() ws.Columns("C:D").Hide() wb.Save() End Using Sample Sample20231114-4L.zip (8.6 KB)

This post made by @Nguyen_Van_Luong1 received 2 likes!

Excelファイルの列や行を非表示にしたい

こんにちは。 You can use activity in this package [image] Or try Invode VB code [Hide Columns in UiPath | Hide Multiple Excel Columns in UiPath] Hope it help!

This post made by @Yoichi received 2 likes!

How can I convert "Nov" to "November" for any month?

Hi, How about the following expression? DateTime.ParseExact(yourString,"MMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM") [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Excelファイルの列や行を非表示にしたい

こんにちは 例えばClosedXMLなら以下になります。 [image] Using wb As New ClosedXML.Excel.XLWorkbook(filename) Dim ws As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetName) ws.Rows(3,4).Hide() ws.Columns("C:D").Hide() wb.Save() End Using Sample Sample20231114-4L.zip (8.6 KB)

This solution provided by @Yoichi received 2 likes!

How can I convert "Nov" to "November" for any month?

Hi, How about the following expression? DateTime.ParseExact(yourString,"MMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM") [image] Regards,

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

Could not load file or assembly ‘UiPath.IntelligentOCR, Version=6.14.1.0, Culture=neutral, PublicKeyToken=null’. The system cannot find the file specified

Updating the UiPath.IntelligentOCR.Activities also requires an update for the UiPath.UIAutomation.Activities pack and for UiPath.OCR.Activities pack if included in the project. UiPath.IntelligentOCR.Activities and UiPath.DocumentUnderstanding.Activities should not be used together in the same project. Reference: Activities - About the IntelligentOCR Activities Package

---

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

Top 3 Topics with Most Views

Unable to access Gsuite get mail activity made by @Srinath_Sharma_Thangudiga with 68 views.

I am getting a new error made by @Karthik_Krishnan1 with 50 views.

Element Exist not working as expected made by @Karthik_Krishnan1 with 48 views.

Top 3 Topics with Most Replies

I have to find particular string from my excel data table using If condition made by @shaik.muktharvalli1 with 20 replies.

Add DataColumn and copy 3 columns to it made by @hp321 with 14 replies.

Data table merge in uipath made by @AJITH_SK with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 61 posts!

@Shiva_Nikhil made 16 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

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

UiPath Assistant does not open when clicked

Try this approach: · Go to Control Panel → Programs → Apps and Features → Uninstall the UiPath Platform Installer (if exists) and UiPath Studio After the UiPath Studio/Robot uninstallation, delete the below folders if exist: · The settings in the folders %PROGRAMDATA%\UiPath, %LOCALAPPDATA%\UiPath, and %APPDATA%\UiPath · The packages folder %USERPROFILE%\.nuget\packages · The NuGet cache folder %LOCALAPPDATA%\NuGet\v3-cache · The Assistant processes folder in the Windows Start menu %APPDAT…

This post made by @Yoichi received 1 likes!

Deserializing a XML help needed

Hi, It’s necessary to consider XML namespace. Can you try the following sample? [image] Sample Sample20231115-1.zip (3.7 KB) Regards,

This post made by @mukeshkala received 1 likes!

Automation Business Analyst Series 2023

Process Definition Document (PDD): Purpose: Typically created during the initial phase of the RPA development process. Focus: It focuses on understanding and documenting the existing manual process in detail. This includes a thorough analysis of the steps involved, inputs, outputs, decision points, and exceptions. Content: Contains a narrative description of the process, detailing each step and decision. It also includes information about the expected inputs, outputs, business rules, and any…

Top 3 Most Liked Solutions

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

UiPath Assistant does not open when clicked

Try this approach: · Go to Control Panel → Programs → Apps and Features → Uninstall the UiPath Platform Installer (if exists) and UiPath Studio After the UiPath Studio/Robot uninstallation, delete the below folders if exist: · The settings in the folders %PROGRAMDATA%\UiPath, %LOCALAPPDATA%\UiPath, and %APPDATA%\UiPath · The packages folder %USERPROFILE%\.nuget\packages · The NuGet cache folder %LOCALAPPDATA%\NuGet\v3-cache · The Assistant processes folder in the Windows Start menu %APPDAT…

This solution provided by @Yoichi received 1 likes!

Deserializing a XML help needed

Hi, It’s necessary to consider XML namespace. Can you try the following sample? [image] Sample Sample20231115-1.zip (3.7 KB) Regards,

This solution provided by @Arvind_Kumar1 received 1 likes!

Populate a Textbox using Lookup

Hello @hgaber105 , Please have a look at video, i have covered the set default values and all [Fetching Single Value in UiPath Apps]

---

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

Top 3 Topics with Most Views

How to explain my process made by @superpunchypp with 53 views.

How to split this string? made by @Kumar_Sahu_Sameer with 50 views.

If statement with drive item made by @E.T.S with 45 views.

Top 3 Topics with Most Replies

How to explain my process made by @superpunchypp with 27 replies.

How to put a replace existing file in rename file activity made by @superpunchypp with 25 replies.

How to fix the creating file error made by @superpunchypp with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 51 posts!

@superpunchypp made 33 posts!

@ppr made 33 posts!

Top 3 Most Liked Posts

This post made by @AJ_Ask received 1 likes!

Send smtp mail message activity error

Hi @Mohammad.Fuad This generally occurs when you are passing any variable (As argument) whose value has not been initialized. Request you to kindly cross check the values of the variables. Before the send SMTP Mail Message put a log message for screenshotPath this will give us correct idea

This post made by @Yogeesh_G received 1 likes!

What is this error message?

Hi This is from open ai please go through if this is helpful. The error message you’re encountering in UiPath suggests a problem with connecting to the host “account.uipath.com” over HTTPS. Let’s break down the error message: requests.exceptions.ConnectionError: This indicates that there is an issue with establishing a connection. HTTPSConnectionPool(host='account.uipath.com', port=443): The error is related to attempting to establish an HTTPS connection to the specified host (“account.uipat…

This post made by @efelantti received 1 likes!

Get queue items - QueueItemStates not working

Can you update UiPath.System.Activities and see if it makes a difference? Can you post a screenshot of which QueueItemStatuses you have ticked? Have you verified the Orchestrator folder which you are running from in Studio?

Top 3 Most Liked Solutions

This solution provided by @AJ_Ask received 1 likes!

Send smtp mail message activity error

Hi @Mohammad.Fuad This generally occurs when you are passing any variable (As argument) whose value has not been initialized. Request you to kindly cross check the values of the variables. Before the send SMTP Mail Message put a log message for screenshotPath this will give us correct idea

This solution provided by @efelantti received 1 likes!

Retry splitting on REF

If you want to use Orchestrator retries, something like this would work: [image] This way if the item is retried from Orchestrator, it will start processing from correct place. Note the Assign on transactionItem.Progress, it’s important as Set Transaction Progress activity does not update the transaction property on the item (only in Orchestrator).

This solution provided by @Anil_G received 1 likes!

Problem with saving images in UiPath Assistant automation

@GPfebve Try to use a log message and print the path and check 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 | 17 November 2023

Top 3 Topics with Most Views

How to create and replace the old docx with new rename made by @superpunchypp with 60 views.

How to check the content of a folder for specific made by @goncalo.rocha with 44 views.

Environment.CurrentDirectory made by @SAMANTA_COTTACKAL1 with 43 views.

Top 3 Topics with Most Replies

How to create and replace the old docx with new rename made by @superpunchypp with 43 replies.

How to merge different excel files into single excel file made by @anjani_priya with 32 replies.

How to merge different excel files into single file as different sheets made by @anjani_priya with 20 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 38 posts!

@Anil_G made 36 posts!

@superpunchypp made 34 posts!

Top 3 Most Liked Posts

This post made by @Ghanashyam received 13 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

** Congratulations to the New UiPath Student Developer Champions! ** Your journey to this point is a testament to your commitment and passion for innovation. You are not just champions by title, but leaders and inspirations to your peers. Your diverse backgrounds, from different countries and fields of study, enrich our community and bring fresh, transformative perspectives to the world of automation. Eagerly looking forward to the ideas, projects, and contributions you will br…

This post made by @SWEATHA received 3 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

Hello everyone! I am absolutely honored to be selected as a Student Developer Champion by UiPath, representing Rajalakshmi Engineering College. I am excited to contribute and collaborate with the vibrant UiPath community, with the aim of promoting automation. Connect with me on LinkedIn (https://www.linkedin.com/in/sweatha-r-1877b6230) as I embark on this journey to drive the advancement of automation. I look forward to interact with passionate minds in the field!

This post made by @tazunnisa.badavide received 3 likes!

Delete Excel File after 14 days

[image] @Chetan_Wagh can u try with this And also refer this thread : Delete file with yesterdays date - Help - UiPath Community Forum

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 2 likes!

Delete Excel File after 14 days

Hi @Chetan_Wagh , You can get file after 14 days by date created [image] if you need get all file date = now -14 file.CreationTime.Date.ToString = DateTime.Today.AddDays(-14).ToString if you need get all file date is more than 14 days. file.CreationTime.Date.ToString < DateTime.Today.AddDays(-14).ToString hope it help,

This solution provided by @copy_writes received 1 likes!

How to Upload any file to the specific folder using Phyton code in uipath

The below Code work import os import shutil def move_files(source_path, destination_path): try: # Check if the source directory exists if not os.path.exists(source_path): return "Source directory does not exist" # List all files in the source directory files = os.listdir(source_path) # Filter files with specified extensions valid_files = [file for file in files if file.lower().endswith(('.pdf', '.png', '.jpg', '.jpeg'))] …

This solution provided by @Yoichi received 1 likes!

Convert Present Month Year(28/04/2023) To Financial Year(202401)

How about the following? CurrentRow("Calendar Month (Manual)") = CDate(CurrentRow("Start").ToString).AddMonths(9).ToString("yyyyMM") Sample Sample20231117-1L (2).zip (84.5 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 | 18 November 2023

Top 3 Topics with Most Views

In an excel if a cell contains data empty, how to delete entire row. Can anyone help me with this please made by @PriyaReddy with 33 views.

Couldn't find "System.IO.File.GetAccessControl" Function made by @aeklikit with 32 views.

メール添付ファイルからパスワードを外したのち、フォルダへ保存したい made by @wggcs044 with 31 views.

Top 3 Topics with Most Replies

In an excel if a cell contains data empty, how to delete entire row. Can anyone help me with this please made by @PriyaReddy with 27 replies.

How to change csv file format to xlsx format made by @anjani_priya with 14 replies.

Index was outside the bounds of the array! made by @170290064 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 78 posts!

@Nguyen_Van_Luong1 made 18 posts!

@170290064 made 16 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 2 likes!

Get values from in_config to outlook

@Meu_Eu_Nando You can pass the values to these arguments By using assign activity Or in the imports where this workflow invoked In this way In_SmeEmail=Config(“key”).tostring Or in_Config(“key”).tostring Key is which you have given in the config file

This post made by @170290064 received 2 likes!

Queue Items Issues

How stupid i am I couldnT see the typo Thanks for the answer

This post made by @Meu_Eu_Nando received 2 likes!

Get values from in_config to outlook

Thank you. Both solution works. I just needed to add the config argument inside the send email flow but I tested before what you said and worked. Many thanks guys

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 2 likes!

Get values from in_config to outlook

@Meu_Eu_Nando You can pass the values to these arguments By using assign activity Or in the imports where this workflow invoked In this way In_SmeEmail=Config(“key”).tostring Or in_Config(“key”).tostring Key is which you have given in the config file

This solution provided by @rajneesh94 received 1 likes!

Extract Specific text from multiple Pdf's

Hi @rsr.chandu, You can extract the selected values using Regex. Use Read PDF Activity and store the extracted text in a variable like strExtractedText. For extracting Total value use an assign activity in the following way: strTotal = System.Text.RegularExpressions.Regex.Match(strExtractedText, "(?:\s*|^)(\$\s*\d+(?:,\d+)*\.\d+)\s*(?:$|\s)").Groups(1).Value Same for Invoice Date: strInvoiceDate = System.Text.RegularExpressions.Regex.Match(strExtractedText, "\s*(0?[1-9]|1[0-2])\/(0?[1-9]|…

This solution provided by @Anil_G received 1 likes!

How to change csv file format to xlsx format

@anjani_priya Just so that you know …a little googling also will help [image] now coming to c hanging all use a loop around [image] cheer

---

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

Top 3 Topics with Most Views

Data Extraction for Specific data made by @CHAN_Hiu_Fung_Victor_Stud with 36 views.

Cannot find the excel file in test environment while i can see the bot is saving the file in dev environment made by @aslam_ali1 with 33 views.

Get items from queue but having some errrors made by @170290064 with 31 views.

Top 3 Topics with Most Replies

How to write remarks for system exception made by @Gokul_Murali with 14 replies.

【質問】メールトリガーと条件分岐の組み合わせ方法について made by @Yamaguchi_00 with 10 replies.

Cannot find the excel file in test environment while i can see the bot is saving the file in dev environment made by @aslam_ali1 with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@rikulsilva made 16 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @Noel_Medina received 1 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

I’m Noel Medina from Nicaragua, It’s an honor to express my sincere gratitude for being selected as an UiPath Student Developer Champion in this year. I am thrilled and committed to making the most of this opportunity to contribute to technological growth, inspire my peers, and lead positive changes in in the world. Thank you for trusting me to be part of this exciting initiative!

This post made by @erkanceylan received 1 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

Congratulations everyone

This post made by @Xue_Qi received 1 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

Hello everyone! I’m Xue Qi, currently pursuing IT System & Network at ITE College West, and I’m thrilled to be part of the UiPath Student Championship. Thanks to UiPath for this incredible opportunity! Wishing my fellow champions success as we dive into this thrilling experience together. My LinkedIn: https://www.linkedin.com/in/ngor-xue-qi-692666250/

Top 3 Most Liked Solutions

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

Can we access the Orchestrator Queue database and Insights Database?

The customers don’t have access to the product databases in cloud. You will be able to access the information only with API calls or the Export tools already available in UI.

This solution provided by @AJ_Ask received 1 likes!

Data Extraction for Specific data

Hi @CHAN_Hiu_Fung_Victor_Stud You can remove the unwanted columns by using filter activity [image] find attached flow for your ref Report_Filter New.zip (15.9 KB) Hope this helps

This solution provided by @Shiva_Nikhil received 1 likes!

Get items from queue but having some errrors

@170290064 inTransactionitem.SpecificContent.GetValueOrDefault(“keyname”).ToString Can you try this once

---

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

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

[system]

Daily Forum Report | 20 November 2023

Top 3 Topics with Most Views

How to get the value in the particular cell dynamically made by @anjani_priya with 50 views.

Automation with notepad file made by @JITU99 with 48 views.

Invoke Code to read excel - VB Net error made by @Ana_Patricia with 43 views.

Top 3 Topics with Most Replies

How to get the value in the particular cell dynamically made by @anjani_priya with 32 replies.

How to solve the error that column doesn't exist made by @anjani_priya with 19 replies.

Error (Assign: The source contains no DataRows) made by @Lee4216 with 17 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 41 posts!

@sanjay3 made 28 posts!

@rikulsilva made 26 posts!

Top 3 Most Liked Posts

This post made by @rikulsilva received 2 likes!

Cannot find the excel file in test environment while i can see the bot is saving the file in dev environment

in this case, the Excel file is not been saving in your test environment. Are you running you bot from orchestrator ? I totally agree with @AJ_Ask, it much better you define a common location for your files that is equal for all your environment or you can change it from asset, for example But if you want to do more troubleshooting, you can add the Write Range activity inside a Try Catch activity and in Catches block, you add log to see with something going wrong when bot is saving the Excel …

This post made by @Josefina_Belgrave received 1 likes!

Automation Business Analyst Series 2023

Unfortunately, I am still not able to upload my completed training certificates, So I am posting them here.

This post made by @matt.theisen received 1 likes!

Complex Filter for Directory Files

Saw this question here but unfortunately nobody was able to provide a good solution and I was not able to respond to the question with an alternative solution. My suggestion is to use a regular expresion (regex) - you can test your regex here. Regex can be a bit confusing at first but it is a great skill to learn. This code also uses Linq (the part of the code which says .Where(…)) which is a very powerful method of doing inline code. The structure in the package would go as follows: 1. Assig…

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Equal & not equal with LINQ

Hi @anh.nguyen Try this: (From d1 In dtARR13.AsEnumerable() Let lid = d1(0).ToString().Trim() Where dtDeposit.AsEnumerable().Any(Function(d2) d2(0).ToString().Trim().Equals(lid)) AndAlso Not dtSum.AsEnumerable().Any(Function(d3) d3(0).ToString().Trim().Equals(lid)) Select r = d1).ToList() Hope it helps!!

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

Run performer without using orchestrator

Hi @Vincent2 Since you are not going with orchestrator One method I can recommend is to use invoke process within the dispatcher, so tht it would trigger performer

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

Not able to access Associate course

Hi @Rishab2 Check this out

---

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

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

[system]

Daily Forum Report | 21 November 2023

Top 3 Topics with Most Views

How to Skip the step when UI element not found made by @Niranjan_k with 64 views.

Worksheet quick handle is not a member of string() made by @YangYang with 53 views.

Download and Move made by @Anirudh_Tugawe with 45 views.

Top 3 Topics with Most Replies

Unbale to fetch confidence score for extracted data made by @vivekrb131 with 17 replies.

How do I change this column into Int after data scraping made by @Lee4216 with 16 replies.

Worksheet quick handle is not a member of string() made by @YangYang with 15 replies.

Top 3 Users Who Posted The Most

@rikulsilva made 51 posts!

@Yoichi made 28 posts!

@AJ_Ask made 17 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Srinivas received 2 likes!

Connect to database: Unable to find the requested .Net Framework Data Provider. It may not be installed

Thanks That helped.!

This post made by @ppr received 2 likes!

Populate new data table by headers

find some starter help: [grafik]

This post made by @jinal.shah received 1 likes!

Automation Business Analyst Series 2023

Here are the steps: Navigate to Convert PDF to JPG. Extract images from a PDF. Select PDF files or drag and drop the PDFs. Upload the selected PDFs. On the right-side panel bar, click on “Extract Images.” Click on the “Convert to JPG” button. The PDF has been successfully converted to JPG images and is displayed. Click on the “Download JPG Images” button on the display. Now, all images are downloaded in your designated folder. Create and zip the JPG images. Upload the zip files to the Google F…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Unbale to fetch confidence score for extracted data

HI, Can you try to check it in advance as the following. [image] Regards,

This solution provided by @Yoichi received 1 likes!

範囲を読み込みアクティビティで Excelの名前付き範囲を名前で指定する方法？

こんにちは 単純に範囲プロパティに範囲名を指定すれば取得できると思います。 [image]

This solution provided by @Yoichi received 1 likes!

Adding data to build datatable issue

HI, Can you try as the following? First create empty datatable using BuildDataTable (Let’s say dtResult) Next use MergeDataTable : src is ExtractDataTable, dist is dtResult Finally use Append range. [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 | 22 November 2023

Top 3 Topics with Most Views

Add One Excel Data To another Excel made by @vineelag with 62 views.

For Each Excel Row to read blank in modern design made by @YangYang with 50 views.

"Installation Access Token" menu missing made by @sumitd with 40 views.

Top 3 Topics with Most Replies

Add One Excel Data To another Excel made by @vineelag with 29 replies.

Excel and display message box made by @meli with 17 replies.

For Each Excel Row to read blank in modern design made by @YangYang with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@Nguyen_Van_Luong1 made 30 posts!

@rikulsilva made 26 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Add One Excel Data To another Excel

Hi, Can you try MergeDataTable with Ignore in MissingSchema property [image] Sample Sample20231122-4.zip (14.6 KB) Regards,

This post made by @moenk received 2 likes!

Uipath login/logon SAP not working

It’s obsolete now because UiPath offers great activities for SAP now

This post made by @Jorge_Tou received 1 likes!

Automation Business Analyst Series 2023

Hi folks the form didnt work for me due to access registration. I recommend for better tracking to have your D&A team to get access to the learning plans report in your database and Query based on the users on this BA Series and connect that report to looker. We avoid doing this, and you have more visibility realtime with time stamp of the trainees progress and their % of completation. I shared the credentials so far: [Fundamentals]

Top 3 Most Liked Solutions

This solution provided by @efelantti received 1 likes!

Wait for loading bar to disappear

I’d propose to handle it like this: [image] First timeout should be something short, the maximum value you expect for the loading bar to appear. The second timeout should be the maximum value you expect for the loading bar to disappear. If the loading bar can appear in many places of the flow, extract this to a separate workflow and invoke it in the places where the loading bar may appear.

This solution provided by @Shiva_Nikhil received 1 likes!

Logic or LINQ required for below Question

@Vicky_K use this expression in another assign activity below the above expression finaldt=dt1.DefaultView.ToTable(False,"ColumnName","ColumnName2") you can add columnNames which ever columns you want

This solution provided by @Yoichi received 1 likes!

Add One Excel Data To another Excel

HI, Can you try the following? Sample20231122-5L (2).zip (40.0 KB) Book2.xlsx will be updated. 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 | 23 November 2023

Top 3 Topics with Most Views

Error in Publishing a Package to Orchestrator in UIPath made by @Wall_E with 48 views.

Help with for each datarow loop made by @adrian_sullivan with 47 views.

Type into activity disabling the textbox after typing value once while automating desktop application made by @Parmar_Snehal_Cognizant with 41 views.

Top 3 Topics with Most Replies

How to move existing folder to a folder that needs to be created in UIPATH made by @meli with 19 replies.

How to create a data column at specific location dynamically made by @anjani_priya with 16 replies.

Downgrade made by @Anelisa_Bolosha1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 43 posts!

@rikulsilva made 26 posts!

@Nguyen_Van_Luong1 made 20 posts!

Top 3 Most Liked Posts

This post made by @Michael.Vornes received 2 likes!

How to find out the IP of an external URL

Hi, I think you could use “ping” to get the IP address. In UiPath you need to instance a ping variable and a ping reply variable and then just use method .Send(“YOUR URL HERE”) and store it in the ping reply. Then you can easily get the IP Address using property .Address [image] Here is the UiPath project in case you want to test it IP_Address_Test.zip (2.3 KB)

This post made by @hp321 received 2 likes!

Filter DataTable-The output row count is the same as input

Thanks @supermanPunch , @ppr , @Shiva_Nikhil The sheet was not deleted after each run, that’s why it seemed like the filter was not working properly…

This post made by @Michael.Vornes received 1 likes!

Delete shift cells up in excel but need to do in studio x

Hi, here is a suggestion on how to solve your problem Explanation: If you want to delete the entire row or entire column you can use “Delete Rows” and “Delete Column” activities and indicate row index or column name [image] **Note that it will delete entire row or column [image] But per my understanding you are trying to delete only cell J1 and shift the remaining cells up in that column. Solution I would use (it needs a little bit of logic since there is no “shift cell up…

Top 3 Most Liked Solutions

This solution provided by @rikulsilva received 1 likes!

Json 파일에서 특정 항목을 string 으로 추출하고 싶습니다

@1111057 Take a look in attached solution DeserializeJsonSolution.zip (148.1 KB)

This solution provided by @Anil_G received 1 likes!

How to send the mail when an exception occurs using Gmail

@Vrishchik No catch block you have a business exception and exception…in exception you can place it You cna also do it inside system exception seuqence inside your set transaction status as well Cheers

This solution provided by @ppr received 1 likes!

VLookup in Linq

we can do it e.g. with the help of a LookUpDict dictLK | Dictionary(Of String, String) = dtData.asEnumerable.ToDictionary(function (x) x("Amount").toString.Trim, function (x) x("VendoName").toString.Trim) then a dictLK (“300”) will return Deva. But keep in mind: Amounts has to be unique or we would need a different logic As an alternate we would implement a LINQ filter or Join case

---

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

Top 3 Topics with Most Views

Faulted Process in Orchestrator - The Main.xaml workflow cannot be found. Make sure that it is part of the project made by @Anirudh_Tugawe with 53 views.

If there are identical numbers in Excel, display only one Help me made by @22222222asas with 47 views.

Linq Query To Get Mismatch Rows made by @Prateek_Gulab_Pathak with 46 views.

Top 3 Topics with Most Replies

Linq Query To Get Mismatch Rows made by @Prateek_Gulab_Pathak with 17 replies.

Getting errors while running Email Automation made by @Hallgrimur_Ingolfsson_HI with 17 replies.

If there are identical numbers in Excel, display only one Help me made by @22222222asas with 14 replies.

Top 3 Users Who Posted The Most

@Yoichi made 39 posts!

@Anil_G made 39 posts!

@Nguyen_Van_Luong1 made 28 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 4 likes!

UiPath Remote RunTime: UiPath Extensions | UiPath Automation Developer Professional Exam Preparation

Don’t miss this essential content! Get ready for the UiPath Automation Developer Professional Exam with key insights into UiPath Remote Runtime & Extensions! Explore how to leverage these crucial elements with in-depth insights and practical know-how. Elevate your exam prep with clear guidance and ace the certification! uipath #AutomationDeveloper #ExamPrep [UiPath Remote RunTime: UiPath Extensions | UiPath Automation Developer Professional Exam Preparati…

This post made by @Yoichi received 2 likes!

Send Outlook Mail Message Popups

HI, As another workaround, can you try UiAutomation (Click etc) using parallel activity with isolate mode to check and click “Allow” of this dialog? In one of my environments, as we cannot change group policy, this way solves the matter. Regards,

This post made by @Sami_Rajput received 2 likes!

Dynamic selector becomes invalid in 2nd,3rd or 4th run

Thanks @Yoichi @NervousTuber @Anil_G

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

How to check if 1 col value is available in other column

Hi @8b6861dc5e0c9f7008548ca66 Check out the below zip file as hope this meets your requirement. BlankProcess8.zip (50.5 KB) Input: Sheet1 [image] Output: Sheet2 [image] Hope it helps!! Regards,

This solution provided by @Yoichi received 1 likes!

Run Spreadsheet Macro Pass Parameter

Hi, Can you try to set each parameter in each MacroArgument as the following? [image] Regards,

This solution provided by @NervousTuber received 1 likes!

Dynamic selector becomes invalid in 2nd,3rd or 4th run

Your Selector is: Title: var - Turrnaround Actual Selector is: Var - Turnaround Kindly check the Turnaround spelling or add Wildcard after passing the varriable title = ' {{VarResult}}*' Thanks, 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 | 25 November 2023

Top 3 Topics with Most Views

Project opening Issue made by @thanuship with 42 views.

PDF file extraction and edit the file made by @learning_sourav with 40 views.

How to get the file names made by @Gayathri_Mk with 39 views.

Top 3 Topics with Most Replies

Project opening Issue made by @thanuship with 11 replies.

How to change the excel column (Due Date) format from MM/dd/yyyy to yyyy/MM/dd made by @ahmed4566 with 7 replies.

How to get the file names made by @Gayathri_Mk with 5 replies.

Top 3 Users Who Posted The Most

@Mohan_Reddy made 9 posts!

@Nguyen_Van_Luong1 made 9 posts!

@Anil_G made 8 posts!

Top 3 Most Liked Posts

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

HELP: Unable to read data from the transport connection : An established connection was aborted by the software in your host machine

Provide these details from the impacted machine: Open a powershell.exe console and provide the result for this command: [System.Net.WebRequest]::GetSystemWebProxy().GetProxy("https://cloud.uipath.com") In which mode did you install the impacted Studio/Robot (User Mode or Service Mode)? If you don’t know, open a cmd.exe console and run the below command: FOR /F %i IN ('"C:\Program Files\UiPath\Studio\UiRobot.exe" --version') DO set RobotVersion=%i sc query "UiRobotSvc" | find /i "failed" 2>…

This post made by @Anil_G received 2 likes!

Publishing package operation is taking too much time

@nikhil.chandre Check if the package size is huge and delete the unnecessary files like exception screenshots and screenshots folders etc Cheers

This post made by @Omar404Ahmed received 1 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

Hello UiPath Community, thank you for your warm welcome! This is Omar, a computer science student at Jamia Hamdard. I am looking forward to this incredible opportunity as one of the chosen UiPath Student Developer Champion and I can’t wait to meet you all. Get connected with me on LinkedIn. https://www.linkedin.com/in/omar-ahmed-77500222b

Top 3 Most Liked Solutions

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

---

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

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

[system]

Daily Forum Report | 26 November 2023

Top 3 Topics with Most Views

Use Application/Browser activity opens the same pdf file in loop (open file in folder)) made by @goodtipsteam with 40 views.

Reusable RE FRAMEWORK made by @Anirudh_Tugawe with 36 views.

Create Workflow made by @Sahil_Pattiwar with 36 views.

Top 3 Topics with Most Replies

How to get files from user shred path made by @suraj_gaikwad with 12 replies.

Crosscheck 2 excel fiels and output made by @Yudhisteer_Chintaram1 with 11 replies.

Use Application/Browser activity opens the same pdf file in loop (open file in folder)) made by @goodtipsteam with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@rikulsilva made 20 posts!

@mountie made 7 posts!

Top 3 Most Liked Posts

This post made by @rikulsilva received 2 likes!

Crosscheck 2 excel fiels and output

Following a sample solution using the steps mentioned by @Anil_G CompareExcelFile.zip (56.9 KB)

This post made by @Anil_G received 1 likes!

あるデータテーブルの指定した列に、別のデータテーブルの列を追加したい

@house.of.nf.ssk if you are asking about in add data row how to add to specific column then use below {"","","Third","Fourth","","","","","","Ten"} this will add data in the respective columns with other columns being empty here you need to build a table with 10 columns Hope this helps if you want to add to already existing datatable then you need to loop through that table or lookup on that table with a unique column and get the row id and then use assign dt.Rows(LookedupID)("ColumnName")…

This post made by @Yoichi received 1 likes!

How to convert a Dictionary (Of String, String) into a CSV?

Hi, Can you try the following sample? [image] dt = dict.Select(Function(kv) dt.LoadDataRow({kv.Key,kv.Value},False)).CopyToDataTable() Sample20231127-1aL.zip (2.9 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @rikulsilva received 2 likes!

Crosscheck 2 excel fiels and output

Following a sample solution using the steps mentioned by @Anil_G CompareExcelFile.zip (56.9 KB)

This solution provided by @Anil_G received 1 likes!

How to add process to current project at StudioX?

@mountie If in every process you need to invoke another process then yes you need to Cheers

This solution provided by @rikulsilva received 1 likes!

Unable to disable Slim View

Could you try to downgrade the UiPath.System.Activities to 22.4.4 and see if it works? Also if the Studio was installed in User Mode, you can try remove this 2 folders: C:\Users\your windows user account\AppData\Local\UiPath\.cache C:\Users\your windows user account\.nuget\packages feel free to make a backup for both before the clear This will force the Studio to download the packages again 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 November 2023

Top 3 Topics with Most Views

How to Rename csv File name made by @NISHITHA with 55 views.

Selector not getting identified and validated made by @Santa_Krish with 53 views.

How to extract financial pdf document and save it to excel without using Document Understanding made by @Lalitha_Selvaraj with 46 views.

Top 3 Topics with Most Replies

How to move cell value using studio made by @Nur_Amin with 21 replies.

How to extract financial pdf document and save it to excel without using Document Understanding made by @Lalitha_Selvaraj with 18 replies.

Time out is much longer than the default 30 seconds - System exception made by @atomic with 14 replies.

Top 3 Users Who Posted The Most

@rikulsilva made 34 posts!

@Anil_G made 31 posts!

@Nguyen_Van_Luong1 made 25 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

[FirstAid] - Topic Catalogue

This topic indexes the various [FirstAid] topics. It is also updated when new [FirstAid] topics are published. FirstAid List Data Table Summary Link Keywords This FirstAid tutorial describes how to handle the EXCPTION: "The source contains no data rows" FirstAid DataTable, Exception, This FirstAid Tutorial describes how to analyze and handle DateTime parsing issues FirstAid DataTable, DateTime, Parsing, Invalid Date, Analysis Activities Summary Link Keywords This FirstAi…

This post made by @rikulsilva received 2 likes!

Count no of files in inside folders

Hi @shashank_dullu Try this Directory.GetFiles("Data\Downloading_files\BP41693","*", SearchOption.AllDirectories).Count The * is a wildcard tha you can use for filter file by extension, name etc *.pdf *.xlsx *.txt *.csv invoice*.pdf *2023.xlsx * alone = all files

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

Introduction to UiPath Remote Runtime | UiPath Automation Developer Professional Exam Preparation

[Introduction to UiPath Remote Runtime | UiPath Automation Developer Professional Exam Preparation]

Top 3 Most Liked Solutions

This solution provided by @rikulsilva received 2 likes!

Count no of files in inside folders

Hi @shashank_dullu Try this Directory.GetFiles("Data\Downloading_files\BP41693","*", SearchOption.AllDirectories).Count The * is a wildcard tha you can use for filter file by extension, name etc *.pdf *.xlsx *.txt *.csv invoice*.pdf *2023.xlsx * alone = all files

This solution provided by @Yoichi received 1 likes!

Join 2 data tables by referencing 1 column

Hi, How about the following? [image] Sample Sample2023112702L.zip (12.7 KB) Regards,

This solution provided by @Anived_Mishra received 1 likes!

How to pick data from an unstructured excel?

Hey all, I got a work around. I got the row number for the Gl and the value above that ow will correspond to the previous Gl and the last GL would be the last row in the excel so it’s all good now. Closing this topic as this has been solved :). Thanks for your responses @Nguyen_Van_Luong1 @Anil_G

---

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

Top 3 Topics with Most Views

Excelファイル(マスタ)のA列を全角→半角にしたい made by @once10201029 with 46 views.

Vlookup Save to(?) how? made by @Thanakorn_Kanjiropas with 42 views.

How to split a long string into two line item made by @roysupriya21 with 40 views.

Top 3 Topics with Most Replies

Getting action object variable (DocumentValidationActionData) using Get Task Data Activity made by @Asanka with 30 replies.

Excelファイル(マスタ)のA列を全角→半角にしたい made by @once10201029 with 20 replies.

Gmailに画像を貼り付けて送信したい made by @FSP with 16 replies.

Top 3 Users Who Posted The Most

@Yoichi made 31 posts!

@rikulsilva made 29 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

実行する曜日で条件分岐したい

以下になります。 [image] （Invoke Workflowにしていますが、そのまま処理を記述してもOKです） 以下Sequence.xaml参照ください Sample20231128-1 (2).zip (10.1 KB)

This post made by @Geoffroy_Pantegnies received 1 likes!

Assistant: no such host is known

Hello everyone, I’m getting this error message when I try to connect to Orchestrator via Assistant: [image] The licence is attached to the machine, the URL is good so I don’t understand the problem. I tried closing Studio, log off etc but still got this message. Ps: this is a non production licence. Any help is welcome ! Have a nice day,

This post made by @Gokul_Jayakumar received 1 likes!

Excel copy-paste issue help

Hello @22222222asas Could you be more Specific? Do you need to Autofit your columns? Refer to the below thread you may get some idea [#AutofitColumn How can we autofit Excel sheet column using VBA in UiPath #RPA #UiPath] If Modern Excel, try Autofit Range activity in Excel scope. [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

実行する曜日で条件分岐したい

こんにちは 他のアプローチとして以下のようにすると条件分岐無しで、動的に異なる処理を呼び出せます。 dict = New Dictionary(Of String,String)From{{"Sunday","A.xaml"},{"Saturday","B.xaml"},{"Tuesday","C.xaml"},{"Wednesday","C.xaml"}} としておいて dict(DateTime.Now.DayOfWeek.ToString) をワークフロー呼び出しアクティビティで呼び出します。 [20231128-3-2] [20231128-4] なお23.4までのWindowsプロジェクトではうまく動作しませんのでご注意ください。

This solution provided by @Parvathy received 1 likes!

Change the month to a different language

Hi @sullivanne Try this: yourPolishDateString = DateTime.Now.ToString( "dd-MMMMM-yyyy", New System.Globalization.CultureInfo("pl-PL")) Hope it helps!!

This solution provided by @Shiva_Nikhil received 1 likes!

LinQ Query to Update Specific column value for Specific row

@avinash_ghanwat1 use this in assign activity datatablevar.rows(0).item("Address")="India" or datatablevar.rows(0).item(1)="India"

---

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

Top 3 Topics with Most Views

Convert to datetime format Error: Length cannot be less than zero (Parameter'length') made by @YangYang with 58 views.

Error madness with variable type made by @pere with 50 views.

REST APIを利用したアクティビティの時間ズレ made by @h.yasuda with 44 views.

Top 3 Topics with Most Replies

マクロを動かした際に出てくる【アラーム発生情報】を見て情報が一致したものにメールを送信したい made by @once10201029 with 31 replies.

Error when applying formula to Excel help made by @22222222asas with 20 replies.

Excel cell made by @Pushpendra_kowthavarapu with 15 replies.

Top 3 Users Who Posted The Most

@rikulsilva made 37 posts!

@Yoichi made 36 posts!

@ppr made 25 posts!

Top 3 Most Liked Posts

This post made by @YangYang received 1 likes!

Convert to datetime format Error: Length cannot be less than zero (Parameter'length')

Hi there, i have this pivot table and i need to convert it to datetime format to “MM/dd/yyyy” this is my syntax that is not working anymore. Assign variable ExtractedRowDate as System.DateTime = DateTime.ParseExact(row(0).tostring.Substring(0,row(0).ToString.IndexOf(" "c)).Trim,“MM/dd/yyyy”,System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat) Error Length parameter cannot be less than zero the result is -1 i would like to read only the date row and convert it to datetime forma…

This post made by @22222222asas received 1 likes!

How to cut characters according to a rule

I want to trim a cell’s input to 25 characters, and if there’s a space at the 25th position, cut it off. If there isn’t a space, find the nearest space, move frontward, and cut it off. The remaining characters should then move to the next row, and the process repeats. If the last row has characters that are less than or equal to 25, the robot should end. I’ve tried using length, trim, and replace, but it didn’t work. Is there a way to achieve this? The question is insufficient, so I explain it…

This post made by @pravallikapaluri received 1 likes!

Error when applying formula to Excel help

@22222222asas Excel.Sheet("Sheet1").Cell("B2")+" "+Excel.Sheet("Sheet1").Cell("C2") [image]

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Error when applying formula to Excel help

Hi @22222222asas If you use classic activity [image] [image] regards,

This solution provided by @Yoichi received 1 likes!

Split a string for the double quote character "

HI, How about the following expression? variable.split({""""c,ChrW(&H201C),ChrW(&H201D)}) Regards,

This solution provided by @efelantti received 1 likes!

Error madness with variable type

Easiest imo would be to change the definition of the string, like I already suggested. Then it’s a valid JSON list/array and can be deserialized as such. Otherwise you need to either transform it in code to a proper format or do some splitting manually.

---

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

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

[system]

Daily Forum Report | 30 November 2023

Top 3 Topics with Most Views

How To Make Dynamic Table Row made by @marina.dutta with 57 views.

UiPath Studio Enterprise Editionインストール時の不明点 made by @gorby with 47 views.

For Each Row In DataTable (Body)is not appearing made by @mbercianop with 40 views.

Top 3 Topics with Most Replies

How To Make Dynamic Table Row made by @marina.dutta with 35 replies.

Issue in selection from dropdown on web made by @Smitesh_Aher2 with 15 replies.

How to open pdf file made by @Niranjan_k with 12 replies.

Top 3 Users Who Posted The Most

@Yoichi made 38 posts!

@Anil_G made 25 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 2 likes!

Advent 2023 in the UiPath Forum Community

@loredana_ifrim Nice one and looking forwad to participate Thanks for the wonderful challenge

This post made by @pravallikapaluri received 2 likes!

How to cut characters according to a rule

Hi @22222222asas initially go to the imports panel and import the below System.Text.RegularExpressions Then Assign inputString=“Bussiness Corp.3000 UinateaMinamia city, KanaUSA 3000Phone:Fax:” Message box String.Join(Environment.NewLine, System.Text.RegularExpressions.Regex.Matches(inputString, ".{1,25}(\s|$)").Cast(Of Match)().Select(Function(m) m.Value.Trim())) The expected output shown below [image] Hope it helps!!

This post made by @MWB received 1 likes!

Advent 2023 in the UiPath Forum Community

looking forward to compete.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Change Excel file format .xls to xlsx

Hi @Anjali_Rani How about the following? [image] Hope this helps!!

This solution provided by @Anil_G received 1 likes!

Regular Expression to capture multiple line from sample text

@Isaac_Yeh try with regex options multiline and singleline check if the newline character is coming different in UiPath when read…for that open locals panel and check the value by clicking on magnifier may be new line is coming as \r\n generally to handle both cases \r?\n can be used cheers

This solution provided by @Yoichi received 1 likes!

Unable to read CSV file

Hi, Can you try as the following? First, read csv file as string using ReadTextFile activity. Next remove the first line of the string using the following expression. strCsv = System.Text.RegularExpressions.Regex.Replace(strCsv,"^.*\n","") Finally, convert it to DataTable using GenerateDataTable activity with CSV option. [image] Regards,

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

@Yoichi received 41 likes for their solutions!

@Anil_G received 31 likes for their solutions!

@rikulsilva received 25 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 December 2023

Top 3 Topics with Most Views

Need to remove old month and enter the present month made by @vineelag with 48 views.

String was not recognized as a valid DateTime - Why this error is coming suddenly? made by @Ajinya_jorwekar with 37 views.

Retry the process if any exception occured made by @Priyesh_Shetty with 36 views.

Top 3 Topics with Most Replies

String was not recognized as a valid DateTime - Why this error is coming suddenly? made by @Ajinya_jorwekar with 14 replies.

How to headers in "A1" Cell in Excel made by @Niranjan_k with 13 replies.

xmlDeserialized.Element("export").Elements("sanctionEntity") made by @prasannarayana.machavarap with 12 replies.

Top 3 Users Who Posted The Most

@ppr made 20 posts!

@Anil_G made 16 posts!

@pravallikapaluri made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Advent Challenge #1 in the UiPath Community Forum❄️

HI, Not practical, but short workflow using regex. [image] System.Text.RegularExpressions.Regex.Replace(strData,"(.+?),(.+?),(.+?),(.+?)(\r\n|$)","$1,$4,$2,$3$5") AdventChallenge2023-1withDoc.zip (3.4 KB) Regards,

This post made by @Anil_G received 2 likes!

Where i can get the 2022.10 uipath studio version installer?

@PhitoPerrot Just rememeber trail version has expiry of 60 days and after that you would move to free version and not community as well In 2023.10 you can select the activities panel-> click on filter icon-> select classic and you would see old activities as well if they are being explained in course And most if the activities are same from 22.10 to 23.10…so better to learn the latest as well All the best Cheers

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

Known Issues and Limitations of Webdriver Protocol | UiPath Automation Developer Professional Exam P

[Known Issues and Limitations of Webdriver Protocol | UiPath Automation Developer Professional Exam P]

Top 3 Most Liked Solutions

This solution provided by @pravallikapaluri received 1 likes!

How to cut characters according to a rule

@22222222asas str_in="Bussiness Corp.3000 UinateaMinamia city, KanaUSA 3000Phone:Fax:" inputString=System.Text.RegularExpressions.Regex.Matches(str_in, ".{1,25}(\s|$)") Counter=1 [image] Hope it helps!!

This solution provided by @rikulsilva received 1 likes!

Another Certification?

Hi @aquesada Take I look here in this announcement Publicação | Feed | LinkedIn

This solution provided by @pravallikapaluri received 1 likes!

Excel Append range missunderstandings

Hi @Povilas_Jonikas Try by using read range and clear datatable, process the data(Append new data) and then write range 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 | 02 December 2023

Top 3 Topics with Most Views

Help in Excel column data matching made by @Learner007 with 38 views.

Set environment agnostic Settings in Config.xlsx (REFramework) made by @aaguirrearanguren with 33 views.

Data1 made by @hanviprebday with 30 views.

Top 3 Topics with Most Replies

Send list tof Attachments to Outlook made by @Yudhisteer_Chintaram1 with 11 replies.

Using Excel spredsheet to create invoices made by @Hallgrimur_Ingolfsson_HI with 11 replies.

Help in Excel column data matching made by @Learner007 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@rikulsilva made 10 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to get Min and max from this array of string using uipath

Hi, Can you try the following expression? Max strArray.Where(Function(s) Double.TryParse(s,New Double)).Max(Function(s) Double.Parse(s)) Min strArray.Where(Function(s) Double.TryParse(s,New Double)).Min(Function(s) Double.Parse(s)) [image] Regards,

This post made by @Mr.Sanket received 1 likes!

How to get Min and max from this array of string using uipath

Thank You So much Yolchi. It works​:hugs:

This post made by @Parvathy received 1 likes!

How to add color to Excel cells(A2)

@Niranjan_k Input: [image] Output: [image] Code Text file used: Input.txt (94 Bytes) Check out the workflow file for better understanding Sequence7.xaml (7.1 KB) Hope it helps!!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to get Min and max from this array of string using uipath

Hi, Can you try the following expression? Max strArray.Where(Function(s) Double.TryParse(s,New Double)).Max(Function(s) Double.Parse(s)) Min strArray.Where(Function(s) Double.TryParse(s,New Double)).Min(Function(s) Double.Parse(s)) [image] Regards,

This solution provided by @Yoichi received 1 likes!

Help in Excel column data matching

Can you check the following sample? (Workbook activities are used because excel is not installed in my current environment) CompanyNameMatchV2.zip (10.7 KB)

---

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.