Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 June 2023

Top 3 Topics with Most Views

THE selected item is not compatible please a screen or a element made by @krishnapriya_Anu with 27 views.

How do we get 1st day of current month made by @ganesh67921 with 26 views.

Cannot find some activities made by @harrietwang013 with 26 views.

Top 3 Topics with Most Replies

In Excel, count the rows until the row (Column New), and add the data by 18. The value of 18 is obtained from another Excel file made by @krishnapriya_Anu with 11 replies.

How to switch the workflow based on the web page content made by @felix.guan with 7 replies.

Studio uninstallation issue made by @Prasad_Ashish with 7 replies.

Top 3 Users Who Posted The Most

@Yoichi made 11 posts!

@Anil_G made 9 posts!

@argin.lerit made 5 posts!

Top 3 Most Liked Posts

This post made by @nikhil.girish received 2 likes!

How do we get 1st day of current month

Hi @ganesh67921 Check this out New DateTime(Now.Year,Now.Month,1).Tostring(“MM/dd/yyyy”)

This post made by @PrasanthManivannan received 1 likes!

Regex Pattern for Uipath (10 Basic Pattern)

Regex Pattern for UiPath (10 Basic Pattern) ====================================== Matching a date pattern in the format “YYYY-MM-DD” \d{4}-\d{2}-\d{2} Matching an email address: \w+@\w+\.\w+ Matching a URL: https?://\S+ Matching a phone number in the format “(XXX) XXX-XXXX”: \(\d{3}\) \d{3}-\d{4} Matching a social security number (SSN) in the format “XXX-XX-XXXX”: \d{3}-\d{2}-\d{4} Extracting all numbers from a string: \d+ Extracting all capitalized words from a string: \b[A-Z]+\…

This post made by @ganesh67921 received 1 likes!

How do we get 1st day of current month

Hi @nikhil.girish Thanks for your reply Will check this expression

Top 3 Most Liked Solutions

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

How do we get 1st day of current month

Hi @ganesh67921 Check this out New DateTime(Now.Year,Now.Month,1).Tostring(“MM/dd/yyyy”)

This solution provided by @ppr received 1 likes!

Simple question about "Get From Clipboard" option doenst appear

@Felipe_Linhares welcome to the forum You are working with StudioX. The Get From Clipboard Activity is an activity from Studio For getting text we can e.g. use: new UiPath.Core.Activities.ClipboardWrapper().GetText

This solution provided by @wahid_rochman received 1 likes!

How to add new Robot license to existing Orchetrator?

Hey @Anil_G , Thanks for your suggestion to contact UiPath Technical Support. Because the new license is bought for new tenant, so the proposed solution was apply the new license code to Tenant level. With this method the new license wouldn’t interrupt the existing license.

---

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

Top 3 Topics with Most Views

Error in Json Data made by @marina.dutta with 34 views.

Check sum of two values is 0 and update the status made by @Shivam_Rana with 30 views.

Check the code made by @katta_nikhil with 28 views.

Top 3 Topics with Most Replies

Error in Json Data made by @marina.dutta with 17 replies.

Check sum of two values is 0 and update the status made by @Shivam_Rana with 15 replies.

Dynamic Drop Down in Data Grid Not Working made by @Nitin_Mishra with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 16 posts!

@marina.dutta made 10 posts!

Top 3 Most Liked Posts

This post made by @iamankhandelwal1997 received 2 likes!

Unable to login to UI Path

@raja.arslankhan @Anil_G It started working now after upgrading my system.

This post made by @marina.dutta received 1 likes!

Slide Bar to Right

@argin.lerit Thanks .Will try

This post made by @Anil_G received 1 likes!

Global variable: is not declared. It may be inaccessible due to its protection level

@donghai Please try upgrading your dystem activities and check if it resolves higher to 23.2 atleast Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Problem with activites , can't find activity "image exists" in list, and i added the package

@gundam-ace In the new activities image exists is combined with check app state activity…in that please select the target method as image and indicate the image you need to search Cheers

This solution provided by @donghai received 1 likes!

Global variable: is not declared. It may be inaccessible due to its protection level

Hi @Anil_G Thanks your reply. I found there are some error tips in xaml file imports tab, after I delete it, every thing is OK. BR, Donghai

---

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

Top 3 Topics with Most Views

JSON Data Deserialize JSON: Unexpected character encountered while parsing value: O. Path '', line 0, position 0 made by @marina.dutta with 47 views.

Decimal Value in datatable made by @Kuldeep_Pandey with 46 views.

Write Cell : Failed setting the current sheet to: Sheet1 in workbook: Original error message: 0x800AC472 made by @Samraat_Maharjan1 with 46 views.

Top 3 Topics with Most Replies

Write Cell : Failed setting the current sheet to: Sheet1 in workbook: Original error message: 0x800AC472 made by @Samraat_Maharjan1 with 24 replies.

What is the Package name of Excel Range to Image activity? made by @Gopikrishna_S with 14 replies.

Unziping files and pasting the total number of pan numbers under the columns made by @Priyesh_Shetty1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Yoichi made 54 posts!

@raja.arslankhan made 23 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

Please help me out

Hi, How about the following? [image] Sample20230626-8L.zip (7.6 KB) Regards,

This post made by @ppr received 1 likes!

Time is in string format with AM and PM i need to convert time in 24 hrs format

We do see, that it is working [grafik] give a try by trimming the value Datetime.ParseExact(YourStringVar.Trim(),"h:mm tt", System.Globalization.CultureInfo.InvariantCulture).toString("HH:mm")

This post made by @Yoichi received 1 likes!

レガシで使えた「StrConv」がwindowsでは利用できません。

こんにちは 取り急ぎ名前空間付きで呼び出してもらえますでしょうか？ Microsoft.VisualBasic.Strings.StrConv(yourString,VbStrConv.Narrow,&H411) あとEncodingの関係で以下も必要になると思います。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Please help me out

Hi, How about the following? [image] Sample20230626-8L.zip (7.6 KB) Regards,

This solution provided by @ppr received 1 likes!

Time is in string format with AM and PM i need to convert time in 24 hrs format

We do see, that it is working [grafik] give a try by trimming the value Datetime.ParseExact(YourStringVar.Trim(),"h:mm tt", System.Globalization.CultureInfo.InvariantCulture).toString("HH:mm")

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

Not able to delete other package version

Hi @tanuja38 Seems permission of deleting package is missing from your end Check this out Whether you have sufficient permissions

---

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

Top 3 Topics with Most Views

Studio Web is now available for all enterprise customers made by @Magdalena_Neagu with 147 views.

Dev Dives: Unleash the full potential of your automations with Generative AI made by @zell12 with 78 views.

【新規】UiPath Studio Web ガイドの人間翻訳版公開のお知らせ (2023 年 06 月 14 日更新確認分) made by @Akiyo_Yamada with 47 views.

Top 3 Topics with Most Replies

Tristate変数の変数パネルでの定義方法 made by @gorby with 18 replies.

How to total rows present in a excel sheet? made by @ujjwal.bansal with 16 replies.

API Integration With Http Request using Datasetkey made by @Shyam_Pragash with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@Yoichi made 44 posts!

@Irene made 24 posts!

Top 3 Most Liked Posts

This post made by @Magdalena_Neagu received 4 likes!

Studio Web is now available for all enterprise customers

If you logged in to your UiPath Cloud account today, you probably noticed the latest addition to the family. A new entry available for Studio Web, our latest addition to the Studio Family. [StudioWeb live] What is Studio Web? Studio Web is a browser based automation canvas, designed with cross-platform automation projects in mind. It allows you to build automations directly in your browser, across online business apps and services. We consider it the best way to get started with automation. S…

This post made by @zell12 received 3 likes!

Dev Dives: Unleash the full potential of your automations with Generative AI

Hello UiPath Community, How can you boost your automation with generative AI? I’m Russel Alfeche, Technology Leader for RPA at qBotica, and I’m thrilled to be on the next Dev Dives episode on Wednesday, June 28th! Together with Dhruv Patel, we’ll provide you with several ideas to level up your automations with LLMs, GPT, and other generative AI or foundation models. Because we’ve seen how powerful large language models can be, whether it’s for writing professional looking essays, responding …

This post made by @Anil_G received 2 likes!

Quizzes

@Latifa Arjun is right in his answer already Cheers

Top 3 Most Liked Solutions

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

Library Usage

Start you playing with these: [image] [image] Item: JSONText.GetValue(“dependencies”) folderPath: CurrentFile.ToString arrayOfText: Split(folderPath.tostring,“\”) processVersion: arrayOfText(arrayOfText.Count-4)

This solution provided by @irahmat received 1 likes!

Some of My UiPath Activities only Show their title on the workflow

please downgrade your project dependencies to version 22.10 UiPath.system.Activities UiPath.UiAutomation.Activities.

This solution provided by @Yoichi received 1 likes!

Merge Excel files without knowing the files name from a folder

HI, How about the following sample? [image] Sample20230627-8L.zip (21.3 KB) Please un-comment delete file activity if you remove src files. 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 | 28 June 2023

Top 3 Topics with Most Views

I have to remove the unnecessary data from variable value made by @vinjam_likitha with 43 views.

Safely Close Excel Workbook made by @elliot.barling with 42 views.

How to extract table contain 15000 record and write in excel sheet made by @Abdalla with 41 views.

Top 3 Topics with Most Replies

How to extract table contain 15000 record and write in excel sheet made by @Abdalla with 18 replies.

How to set the input field empty before typing values made by @raju_alakuntla with 16 replies.

Use Application/Browser Activity Error after Studio Upgrade to 2023.6 Release made by @saurabh.goswami1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 33 posts!

@postwick made 32 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

"Expression Activity type 'VisualBasicValue`1' requires compilation in order to run" after attempt to add new column in Excel file

please check the following: the variable monthyear has a default value: today.ToString(“MMMyy”) please retype the default value and ensure that the double quotes are of type: " and not inverted

This post made by @mkankatala received 1 likes!

Automate excel web version

Hi @manasdas6224 If Your questions is How can automate the excel automation in UiPath web? In UiPath web there is no option to read the excel by using read range workbook. There is no read range workbook activity in UiPath web. You can read the google sheets in UiPath web. The UiPath web is only integrated with the cloud Google and microsoft only. Check the below attached image. [image] Hope it helps!!

This post made by @sangeethaneelavannan1 received 1 likes!

How to get the date from the below text

It worked .thanks

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

"Expression Activity type 'VisualBasicValue`1' requires compilation in order to run" after attempt to add new column in Excel file

please check the following: the variable monthyear has a default value: today.ToString(“MMMyy”) please retype the default value and ensure that the double quotes are of type: " and not inverted

This solution provided by @pravallikapaluri received 1 likes!

How to copy data from specific cell to another in Excel

Hi @mironb Excel Application Scope WorkbookPath: [Path to Excel file] Read Cell SheetName: “Sheet1” Cell: “A1” Output: cellValue Write Cell SheetName: “Sheet2” Cell: “B2” Value: cellValue End Excel Application Scope Hope it helps!!

This solution provided by @argin.lerit received 1 likes!

Inyección JavaScript

@camilo_gonzalez - Puedes tratar este código: "function(e, disponible){ let newVal = document.getElementsByClassName('string-cell editable renderable'); newVal[0]['innerHTML']=disponible; }" Y en el parameter InputParameter de la Actividad, pone la variable que contiene el valor de disponible en el código JS como asi: [image] Espero que esto es útil para ti

---

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

Top 3 Topics with Most Views

Loop through each char of string made by @satyam_verma with 44 views.

Use Excel Fileアクティビティ配下に大規模フローチャートを配置する件 made by @gorby with 44 views.

Split PDF every 2 pages made by @Gemma_Walker with 41 views.

Top 3 Topics with Most Replies

Error when opening studio automation made by @aquinn with 23 replies.

Loop through each char of string made by @satyam_verma with 21 replies.

Convert string to list made by @manasdas6224 with 14 replies.

Top 3 Users Who Posted The Most

@Irene made 40 posts!

@Yoichi made 34 posts!

@Anil_G made 29 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Loop through each char of string

Hi, You should output not newstr but newstring. [image] Regards,

This post made by @Jugger received 1 likes!

The project could not be opened

Hi everyone, thanks for the quick action on this matter. Much appreciated. @alexandru I’ve updated to 23.6.1 and it works fine, all good now.

This post made by @postwick received 1 likes!

2023.4.2 is unwantingly Hiding sequences

I’m curious why you want to see this extra clutter on your screen.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Convert string to list

@manasdas6224 Test.zip (141.2 KB)

This solution provided by @ptrobot received 1 likes!

Handel known pop up and messages

Have you tested the Pick / Pick Branch activities?

This solution provided by @Pedro_Vieira received 1 likes!

How to read record content - Servicenow - Integration Service - List All Records

Thank you for your attention, after I asked the question here on the forum, I saw that it was an object, and I accessed the item I needed using a for. Inside the for, I put an assing; curretitem.NameItem.ToString

---

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

Top 3 Topics with Most Views

Continuous Error in UiPath Studio After Update made by @jay.jmee with 53 views.

Is the Ask GPT activity down? (Update: It is not. The question I was asking was timing out.) made by @JOrdinas with 50 views.

How to iterate through datatables made by @Geeta with 45 views.

Top 3 Topics with Most Replies

Outlook mail folder error made by @katta_nikhil with 17 replies.

How to iterate through datatables made by @Geeta with 14 replies.

Click on empty row made by @Povilas_Jonikas with 12 replies.

Top 3 Users Who Posted The Most

@lrtetala made 32 posts!

@ppr made 26 posts!

@raja.arslankhan made 22 posts!

Top 3 Most Liked Posts

This post made by @argin.lerit received 4 likes!

Reboot work! UiPath robot-inspired trophies

Folks, excited to share this year’s champion trophy for our RPA teams’ internal Hackathon. [image] [image] [image] The theme of our internal Hackathon this year is What was not possible, IS NOW POSSIBLE. The focus is on reusable code in StudioX for our Citizen Devs, and chatbot-development for our seasoned RPA Devs. The champion team will be awarded this trophy. Always loved the cute little UiPath robots that appear at the end of the Academy training videos shouting “Reboot work!!” and s…

This post made by @Yoichi received 2 likes!

Can not regconize Advance button in Chrome browser

HI, It’s probably the following matter. Can you try to upgrade UiAutomation.Activities package to the fixed version? Regards,

This post made by @Parvathy received 2 likes!

Uipath exam question

Hi @ShivaniD Answer would be Option A. Explanation: Based on all the 4 options idx value can be modified for stable automation. Other than idx values. If the selector contains innertext, aaname these selectors are modified at most cases because will not be an stable selector. These attributes give more stable automation. Hope it helps!! Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Can not regconize Advance button in Chrome browser

HI, It’s probably the following matter. Can you try to upgrade UiAutomation.Activities package to the fixed version? Regards,

This solution provided by @Yoichi received 1 likes!

How to get index of row by searching data in JArray?

HI, Do you need to get “station” from “jimmy”? If so, the following will work. JsonArray.Where(Function(x) x("Column0").ToString="jimmy").First()("Column1") This assumes there is a item which you need. If there is possibility target does not exist, it’s necessary to add some logic. Regards,

This solution provided by @ppr received 1 likes!

While scrolling elements become visible

we asked for to have the same scenario as you are testing. When using any other criteria we do have looked at a different set. However, the next button is working. The problem is, that the Extract Data is more slow and grabs not a page complete. Therefore we do have less rows. You can try if the out-of-the-box settings allows you to better sync. Otherwise, you can remodel your approach and take more care about sync and extraction. Paging can be done with url trick as just the page number has…

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

@Yoichi received 82 likes for their solutions!

@Anil_G received 53 likes for their solutions!

@arjunshenoy received 27 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 July 2023

Top 3 Topics with Most Views

Community edition - unable to open files due to studio updated to studio X made by @sabari1 with 43 views.

How to run bot on different machine made by @suraj_gaikwad with 28 views.

reportforUiPathactivity errors dispalyed and generate balank page made by @sarathic with 25 views.

Top 3 Topics with Most Replies

Community edition - unable to open files due to studio updated to studio X made by @sabari1 with 20 replies.

DateTime Input to dd/MM/yyyy from "June 5, 2023 8:00 AM" format made by @Orchestrator_Practice with 18 replies.

Date difference showing error made by @Ashish_Tyagi with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 66 posts!

@raja.arslankhan made 27 posts!

@Orchestrator_Practice made 9 posts!

Top 3 Most Liked Posts

This post made by @Ashish_Tyagi received 2 likes!

Date difference showing error

@Anil_G Thanks.

This post made by @Anil_G received 1 likes!

Compare 2 data table

@anh.nguyen Follow the steps For each row in datatable dt1 Inside the loop use filter datatable activity on dt2 with filter on rows and with kewp and filter as "INV" equals currentRow("INV").ToString Now use assign activity with currentRow("Comparer") = (CdBL(currentRow("Total").ToString) - CDBL(dt2.Rows(0)("Total").ToString)).ToString Hope this helps Cheers

This post made by @Orchestrator_Practice received 1 likes!

DateTime Input to dd/MM/yyyy from "June 5, 2023 8:00 AM" format

[image] Thanks for your help and suggestions. The solution was to export in project using csv vs Excel and the format returned normally.

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 | 02 July 2023

Top 3 Topics with Most Views

UiPath update failed (kindly help) made by @Yugandhara_Shirbhate with 41 views.

Using UiPath App, Upload and process one pdf file made by @Subhamay_Maity with 38 views.

Prioritise Queue Retry Mechanism made by @Jeroen_van_Loon with 33 views.

Top 3 Topics with Most Replies

Value cannot be null. (Parameter 'key') when pass it with step status activity made by @sarathic with 14 replies.

UiPath update failed (kindly help) made by @Yugandhara_Shirbhate with 13 replies.

Have an error on activity “Create folder” Absolute paths not recommended made by @kimberly.lin with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 47 posts!

@raja.arslankhan made 17 posts!

@Yugandhara_Shirbhate made 9 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

UiPath update failed (kindly help)

@Yugandhara_Shirbhate From the main page you can download by clicking on download [image] or click on the question mark symbol on top…and select downloads …even from there it cna be downloaded cheers

This post made by @Jeroen_van_Loon received 1 likes!

Prioritise Queue Retry Mechanism

Thanks for your suggestion. But as stated I know how to work around it. It’s that I don’t ‘want’ to have to work around it, in order to maintain a standard through all workflows without creating too much overhead. Therefor I would like to suggest it as an extention of the existing out-of-the-box retry mechanism of Orchestrator queues.

This post made by @Aparna_Kaushik received 1 likes!

Unable to create new processes in 2023.6.0 version

Thank you. I just restarted my system. It worked!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

reportforUiPathactivity errors dispalyed and generate balank page

@sarathic Can you please try giving the description and name also so that it would try to add them… Also make sure to remove all previously created folder or file and try it As it is 3rd party activity we have limited scope to get more details Cheers

This solution provided by @Jeroen_van_Loon received 1 likes!

Specific url click

Use wildcards. Record the selector using a click activity. Then use the uiexplorer to make sure the selector uses the correct ‘content’ to apply your businessrule. So probably the url of visible text. The change that property and change ‘blablabla | villageinfo.in’ to ‘*| villageinfo.in’ Since the selector will now find multiple results, and it defaults to the 1st it finds you are already set. So record: <webctrl tag='A' aaname='Madhopur Village in Satgawan (Kodarma) Jharkhand | villageinf…

This solution provided by @Yoichi received 1 likes!

Gmailの使用方法

こんにちは 繰り返し（各メール）アクティビティとそのフィルターを使うと良いかと思います。具体的には以下のようになると思います。 [image]

---

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

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

[system]

Daily Forum Report | 03 July 2023

Top 3 Topics with Most Views

Splitting a datacolumn from a datatable into the correct columns made by @TyraS with 52 views.

How to input excel formula into excel cell from write cell activity made by @zaffan.isa with 47 views.

Multiple excel reading made by @Gokul_Murali with 47 views.

Top 3 Topics with Most Replies

Question about sequence to create conditionnal phrase etc made by @Ricchch with 25 replies.

Splitting a datacolumn from a datatable into the correct columns made by @TyraS with 21 replies.

I am having time in two variable. Want to add both variable made by @Puneet_Singh1 with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 85 posts!

@raja.arslankhan made 41 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

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

Monthly Forum Rewards - June 2023

@loredana_ifrim Thank you. Congratulations everyone for great efforts to maintain active community.

This post made by @Anil_G received 4 likes!

Monthly Forum Rewards - June 2023

Congrats everyone . Keep up the good work. Nice race @Yoichi

This post made by @Gokul_Murali received 3 likes!

Date_Format_Issue

@Anil_G @lrtetala @raja.arslankhan @aanandsanraj @Sahil_Tomar Guys i used an activity called Date formatter under the package “NovigoSolution.DataTableDateFormatter.Activity”. Now it is working fine, irrespective of excel row format.

Top 3 Most Liked Solutions

This solution provided by @Gokul_Murali received 3 likes!

Date_Format_Issue

@Anil_G @lrtetala @raja.arslankhan @aanandsanraj @Sahil_Tomar Guys i used an activity called Date formatter under the package “NovigoSolution.DataTableDateFormatter.Activity”. Now it is working fine, irrespective of excel row format.

This solution provided by @Anil_G received 1 likes!

Excel more complex Vlookups

@robin.thakur Create a combined column like first concatenate column company and entity code and perform the lookup on the combined column Cheers

This solution provided by @Anil_G received 1 likes!

Value cannot be null. (Parameter 'key') when pass it with step status activity

@sarathic If the error is coming on step status…then first check the variable values you are passing in the step status to see if any of those values are null…for that you can leverage locals panel… Apart from that you missed giving test id etc …check if giving those would resolve… Then assign varibles for output values like status and all and see what it gives may be it can provide more info… Also its worth checking exception details ,that might contain more info Cheers

---

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

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

[system]

Daily Forum Report | 04 July 2023

Top 3 Topics with Most Views

Value of type 'String' cannot be converted to 'UiPath.Database.DatabaseConnection made by @Aditya10989 with 47 views.

Error "Object reference not set to an instance of an object" due to adding "On Element Appear" made by @ret_valkering with 44 views.

Issue in add item to array made by @anmita with 44 views.

Top 3 Topics with Most Replies

Compare two different excel columns and matched remove data in second excel sheet made by @Sachin_Sunny with 19 replies.

Invoking arguments into a coded workflow made by @aquinn with 16 replies.

Excelの表の読み込みについて made by @y.c with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@raja.arslankhan made 36 posts!

@mkankatala made 30 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Where is the latest video tutorial and activities

@Parker The latest videos are yet to be updated in the UiPath academy pages…for now ypu can check few youtube tutorials whoch have activities related to the modern design The activities that you are seeing in older version had been upgraded to a new design called modern…if you want to see only activities you can switch off modern design from the studio settings page…or go to activities panel on left → click filter icon → select classic…now you would be able to see classic activities as welll…f…

This post made by @Parker received 2 likes!

Where is the latest video tutorial and activities

It’s very useful for me! Thanks for your help.

This post made by @Sachin_Sunny received 1 likes!

Compare two different excel columns and matched remove data in second excel sheet

Thank you, It worked!!!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Where is the latest video tutorial and activities

@Parker The latest videos are yet to be updated in the UiPath academy pages…for now ypu can check few youtube tutorials whoch have activities related to the modern design The activities that you are seeing in older version had been upgraded to a new design called modern…if you want to see only activities you can switch off modern design from the studio settings page…or go to activities panel on left → click filter icon → select classic…now you would be able to see classic activities as welll…f…

This solution provided by @raja.arslankhan received 1 likes!

Can i Move file after my UI activities got error(exception) cant find element or something exception

@Harpoon Mark click property continue on error as yes so it will ignore error and go in next file.

This solution provided by @AutomationX_by_Kiran received 1 likes!

Value of type 'String' cannot be converted to 'UiPath.Database.DatabaseConnection

Hi @Aditya10989 , You are getting the connection string from json right pass it in the Connect database Then u will get the output as dbconnection variable . Pass that variable in the disconnect database . So what ever you are getting in json don’t pass in disconnect database

---

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

Top 3 Topics with Most Views

String Variable comparison made by @Karan_Chauhan with 43 views.

Selector issue! made by @aya.lajili with 41 views.

Change Font Size in word made by @MEGHA_cs with 39 views.

Top 3 Topics with Most Replies

条件分岐でnullがうまく分岐されなくなりました made by @7ffdf30161e05b3796f42f977 with 21 replies.

Compilation error while displaying Get transaction item output made by @Parameswari with 21 replies.

Regex multiple lines made by @Dion with 15 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 45 posts!

@lrtetala made 34 posts!

@mkankatala made 31 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

Get Cc receipients from Outlook Mails

CC Property will return a System.Net.Mail.MailAddressCollection [grafik] So we can check e.g. within the addresses with [grafik] YourMailVar.CC.Any(Function (x) x.Address.Contains("cashin")) ToString() will return for an MailAddressCollection (with only 1 ID contained) [grafik] we got the name (red) and the address (blue)

This post made by @arjunshenoy received 1 likes!

Argument issue

Hi @suraj_gaikwad If you have already deleted the argument & still able to see the same, please save the workflows & close the application. Open it again, and check if you get the same thing again. Hope this helps, Best Regards.

This post made by @ppr received 1 likes!

How to sort data within the same datatable with oldest to newest?

Order by CDate(sp).Date, CInt(np) refer to the updated LINQ

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Get Cc receipients from Outlook Mails

CC Property will return a System.Net.Mail.MailAddressCollection [grafik] So we can check e.g. within the addresses with [grafik] YourMailVar.CC.Any(Function (x) x.Address.Contains("cashin")) ToString() will return for an MailAddressCollection (with only 1 ID contained) [grafik] we got the name (red) and the address (blue)

This solution provided by @raja.arslankhan received 1 likes!

Empty filed in browser

@sullivanne Write exact String.IsNullOrWhiteSpace(EmptyField.ToString) don’t put any space

This solution provided by @ppr received 1 likes!

String Variable comparison

Assign: arrWeak | String Array = str_Weaknesses.Split(“,”).Select(Function (x) x.Trim).toArray Assign: arrResist | String Array = str_Ressistence.Split(“,”).Select(Function (x) x.Trim).toArray Assign arrUncommons | String Array = arrWeak.Except(arrResist).toArray Assign str_UnCommons = String.Join(", ", arrUncommons )

---

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

Top 3 Topics with Most Views

処理中にString引数の値がnullになる現象 made by @ryoko with 46 views.

UiPath Assistant Challenges made by @kelvin_Aliche with 44 views.

Get Name which has minimum Marks made by @Garyy with 43 views.

Top 3 Topics with Most Replies

How to find the 6 months date difference between two dates made by @sruthesanju with 20 replies.

Data manipulation assing activity made by @omar_ismail with 16 replies.

Deployment error from devops to orchestrator made by @santiago_Alvarez with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@lrtetala made 35 posts!

@raja.arslankhan made 29 posts!

Top 3 Most Liked Posts

This post made by @prateek.mehandiratta9 received 2 likes!

Is it possible to distinguish whether a human executed it directly or through a trigger?

HI, You could use Orchestrator api for that and extract the source information from Get Jobs Api, please follow the below thread: Is it possible to know which user triggered/started the job from Orchestrator? - Help / Orchestrator - UiPath Community Forum Thanks.

This post made by @rlgandu received 1 likes!

Is it possible to distinguish whether a human executed it directly or through a trigger?

Hi, In UiPath, it is possible to distinguish whether a process was executed directly or through a trigger by accessing the information available in Orchestrator. The “Source” column in the Jobs menu of Orchestrator provides this information. However, within the program execution itself, there is no built-in feature to directly retrieve the “Source” value. The source information is specific to Orchestrator and is not exposed to the process during runtime. To determine whether a process was exe…

This post made by @ppr received 1 likes!

How to find the 6 months date difference between two dates

we hope you agree on: in 2022 JAN,FEB,MAR,APR,MAI,JUN = 6 Months then 31+28+31+30+31+30 = 181 In Leap Years + 1 As month do have different counts we would avoid to general Month=30days factors when the exactr result is needed

Top 3 Most Liked Solutions

This solution provided by @prateek.mehandiratta9 received 2 likes!

Is it possible to distinguish whether a human executed it directly or through a trigger?

HI, You could use Orchestrator api for that and extract the source information from Get Jobs Api, please follow the below thread: Is it possible to know which user triggered/started the job from Orchestrator? - Help / Orchestrator - UiPath Community Forum Thanks.

This solution provided by @Anil_G received 1 likes!

Deployment error from devops to orchestrator

@santiago_Alvarez Account name needs to be provided…if you see the comment below…for cloud orchestrator it is mandatory You can get it from api access page in your admin page …services Cheers

This solution provided by @supriya117 received 1 likes!

How to manipulate a string in a file Path

Hi @Carla_Munoz Try this for without extension: filename = System.IO.Path.GetFileNameWithoutExtension(“path”) For with extension: filename = path.GetFileName(“path”) or filename = System.IO.Path.GetFileName(“path”) 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 | 07 July 2023

Top 3 Topics with Most Views

https://forum.uipath.com/t/561134 made by @xxGoRpa with 69 views.

Click hyperlink from the table data made by @premkumar.rengarajan with 50 views.

An item key had already been added Key: Project location\"codedworkflow.cs" made by @Ahead_Engineering with 46 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/561134 made by @xxGoRpa with 23 replies.

Click hyperlink from the table data made by @premkumar.rengarajan with 14 replies.

Clipping region - Take screenshot made by @MEGHA_cs with 12 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 57 posts!

@Anil_G made 27 posts!

@supriya117 made 19 posts!

Top 3 Most Liked Posts

This post made by @Luis_Fernando received 2 likes!

Is it possible to extract just a specific file from a ZIP?

Hello Friends @prateek.mehandiratta9 , @supriya117 and @Jithesh_R Problem is solved I asked Chat GPT for VB.Net expression that searched for the path of the files that met a condition. The result was this Imports System.IO Dim folderPath As String = “C:\YourFolderPath” ’ Specify the folder path where the files are located Dim searchTerm As String = “Manifiesto” ’ Specify the search term ’ Get all files in the folder that match the condition Dim files As String() = Directory.GetFiles(fold…

This post made by @Yoichi received 2 likes!

Help Me to get spesific value from string

Hi, Can you try as the following? m = System.Text.RegularExpressions.Regex.Match(yourString,"\b(\d{4})(\d{2})(\d{2})\b") Then m.Groups(3).Value+m.Groups(2).Value+m.Groups(1).Value [image] Sample20230707-2.zip (2.6 KB) Regards,

This post made by @Anil_G received 1 likes!
https://forum.uipath.com/t/561134/13

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Help Me to get spesific value from string

Hi, Can you try as the following? m = System.Text.RegularExpressions.Regex.Match(yourString,"\b(\d{4})(\d{2})(\d{2})\b") Then m.Groups(3).Value+m.Groups(2).Value+m.Groups(1).Value [image] Sample20230707-2.zip (2.6 KB) Regards,

This solution provided by @Yoichi received 1 likes!

セルの値が空なら同じ行のある値を持ってくる

こんにちは たとえば以下データテーブルをフィルターアクティビティを使った例です。 いかがでしょうか？ [image] Sample20230707-1.zip (7.5 KB)

This solution provided by @lrtetala received 1 likes!

How to perform browser based ui automation in Serverless cloud

Hi @Sridhar_Aswin Check on this document https://docs.uipath.com/orchestrator/automation-cloud/latest/user-guide/automation-cloud-robots-serverless https://forum.uipath.com/t/introducing-automation-cloud-robot-serverless-limitless-robot-power-with-zero-infrastructure/410022?u=lrtetala I 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 | 08 July 2023

Top 3 Topics with Most Views

Continue browser in a new sequence after clicking a button in old sequence made by @Vivian_Thian with 39 views.

Using flowchart inside for each row made by @Vivian_Thian with 36 views.

How to Remove odd rows in the datatable made by @Pujari_Manjunatha with 35 views.

Top 3 Topics with Most Replies

Wait element vanish activity not working made by @Iswarya_P1 with 19 replies.

https://forum.uipath.com/t/561495 made by @xxGoRpa with 15 replies.

Using flowchart inside for each row made by @Vivian_Thian with 13 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 32 posts!

@lrtetala made 20 posts!

@Anil_G made 18 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

Indicate Question!

Hi @170290064 https://docs.uipath.com/activities/other/latest/ui-automation/n-check-state Give like this [image] Regards,

This post made by @Anil_G received 1 likes!

Indicate Question!

@170290064 To be precise you can indicate on verify you are robot …that would come only when it is asked for… So the basic rules is…how you differentiate visually or through any parameters is what you need to take in consideration so that when you choose a selector it would be unique for a scenario along with a page or for different pages as per your need… In this case any captcha so concentrate on the button or text which would definitely be present only on this site Hope this helps Cheers …

This post made by @xxGoRpa received 1 likes!
https://forum.uipath.com/t/561570/9

Top 3 Most Liked Solutions

This solution provided by @raja.arslankhan received 1 likes!

Indicate Question!

@170290064 When using the “Check App State” modern activity in UiPath and encountering a captcha on a website, it is typically recommended to select the specific part inside the window where the captcha appears. This allows the activity to focus specifically on that area and perform the necessary checks. Here’s the general process for indicating the area when using the “Check App State” activity: Open the website in a web browser within the “Use Application/Browser”,“Open Browser” or “Attach…

This solution provided by @pravallikapaluri received 1 likes!
https://forum.uipath.com/t/561495/14

This solution provided by @Anil_G received 1 likes!

How to get/select Duplicated Row in Excel Data Table

@Harpoon If you just need to know which data is duplicate then please follow this Read the data from excel into dataTable dt Use assign activity with dt = dt.AsEnumerable.GroupBy(function(x) x("itemNo").ToString).Where(function(x) x.Count>1).Select(function(x) x.First).CopyToDataTable Cheers

---

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

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

[system]

Daily Forum Report | 09 July 2023

Top 3 Topics with Most Views

How to extract words in different lines (Regex)? made by @helpplease with 52 views.

Getting this error in date made by @katta_nikhil with 35 views.

Separate part of a path on Excel made by @omar_ismail with 35 views.

Top 3 Topics with Most Replies

How to Resolve UI-DBP-006 and what is top leave selector made by @Ankit_shukla with 16 replies.

How to extract words in different lines (Regex)? made by @helpplease with 14 replies.

Separate part of a path on Excel made by @omar_ismail with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 18 posts!

@lrtetala made 15 posts!

@mkankatala made 13 posts!

Top 3 Most Liked Posts

This post made by @Bureau_G received 2 likes!

Why isn't my API endpoint not accepted?

Thanks for your replies. I tried the Endpoint with and without quotes. In both cases I received the error message. Also when I used a variable as endpoint. But it is the same as going to the doctor: A week long your back is hurting like h*ll, but after you made an appointment with the docter the pain is gone. In this case after your answers the endpoint with quotes works just fine. Again: thanks for the replies!!!

This post made by @mkankatala received 2 likes!

Data Scraping - Item Selection

Hi @Conning You are using the extraction wizard for data extraction it was the classic activities. Use the modern activities to scrap the data from this type of websites. It was the pattern extraction. First enable the modern design activities for the project. Take the Use application\browser activities then indicate the website application that you are automating. In that use the extract datatable activity to extract the data as a datatable. When you are indicating there is table settings opti…

This post made by @mrymn received 2 likes!

Unable to launch prchestrator

Able to open orchestrator now. turns out my clock is not correctly set. Thank you!

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

メールの添付ファイルを保存の条件

こんにちは 繰り返し（メール）でのフィルターで90日くらいで指定しておいて 条件分岐で必要な日付だけを処理をする手もあります。下記参照ください。 当月初日（１日）の処理が少々不明確かと思いますので、下記では当月１日は前月分を処理しています。 [image] previsousDay = Today.AddDays(-1) CurrentMail.DateAsDateTime>=New DateTime(previousDay.Year,previousDay.Month,1) AndAlso CurrentMail.DateAsDateTime<=previousDay

This solution provided by @lrtetala received 1 likes!

How to extract words in different lines (Regex)?

@helpplease SIN Output [image] DXB Output [image]

This solution provided by @pravallikapaluri received 1 likes!
https://forum.uipath.com/t/561570/11

---

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

Top 3 Topics with Most Views

Date formatting issue occurred made by @suraj_gaikwad with 58 views.

Split the File name made by @Priyesh_Shetty1 with 57 views.

Regex to check if a string separated by pipeline contains a certain keyword made by @mnlatam with 53 views.

Top 3 Topics with Most Replies

Use Application Browser - Input Element made by @170290064 with 24 replies.

Split the File name made by @Priyesh_Shetty1 with 21 replies.

Error writing excel formula with " " made by @atarantino with 19 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 51 posts!

@Anil_G made 33 posts!

@lrtetala made 31 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Help me to get the folder name from a file path

@StevenIsRobotOnline As this is a path…it would be good to use path related commands Path.GetFileName(Path.GetDirectoryName("YourPath")) or new DirectoryInfo(System.IO.Path.GetDirectoryName("YourPath")).Name cheers

This post made by @zeynepnaz.yardim received 1 likes!

Uipath Consolidate 8 different "Google Sheets" in one Excel sheet

Hello, I would like to consolidate 8 different but same formatted tables that are made in 8 different “Google sheets” into one Excel sheet by using UiPath. As the row numbers of each sheet differs from both each-other and not fixed, it totally depends on the person who fills the sheet, I could not understand how should I write the range as “A2:?” in UiPath. I would be very happy if you could help me on both of these questions. Thank you in advance. Best regards.

This post made by @lrtetala received 1 likes!

Take action if there is text in the field

Hi @sullivanne Try like this Not String.IsNullorEmpty(CurrentRow("YourColumn").ToString) [image]

Top 3 Most Liked Solutions

This solution provided by @vrdabberu received 1 likes!

PDF extraction using Regex exp

Hi @praveena.nadi Try using the below expressions Omkumar Tolani ------------ (?<=\n)[A-Z]+\s*[A-Z]+(?=\s*[A-Z]+.[A-Z]+\s*: ) DOC.No ----------------- (?<=[A-Z]+.?[A-Z]+\s*:\s*)[A-Z]+\d+-?\d+(?=\s*[A-Z]+[a-z]+\s*: ) Policy/Cert No ----------------------- (?<=[A-Z]+[a-z]+.\s*:\s*)[A-Z]+-\d+-?\d+-?\d+-?\d+(?=\s*[A-Z]+\s*[A-Z]+) Being Policy Premium ----------------------------- (?<=[A-Z]+-\s*)\d+,?\d+.?\d+(?=\s) Tax -------------------------- (?<=TAX\s*)\d+%?(?=\s*\d+.?\d+) Total ------…

This solution provided by @Anil_G received 1 likes!

Dynamic Selector Activity Problem!

@170290064 Can you try with simulate… also the selector photos you gave look different in two pictures also can you confirm if you are getting error or is it just not clicking an moving ahead? cheers

This solution provided by @Steven_McKeering received 1 likes!

Question on delays and timeout property

Hello @A_Learner If the element is not found, the amount equals: Delay_before + Timeout. If the element is found: delay_before + delay_after + ‘the amount of time taken to click’ based upon WaitFor setting. (WaitForReady.None, WaitForReady.Interactive and WaitForReady.Complete) The default settings are: 30 seconds is the default timeout. WaitForReady.Interactive is default WaitForReady setting (aka blank). These can be configured in the project. Does this make sense? Cheers Steve

---

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

Top 3 Topics with Most Views

New Group Alerts feature gradually rolling out in Orchestrator made by @sebastian.ungureanu with 89 views.

Studio 2023.6.1 Error made by @Danables with 60 views.

Can anyone give me RPAChallange with best practices file made by @hikumar with 53 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/562219 made by @nithish.dhanabal1 with 29 replies.

Bot unable to run in unattended mode to enter the dropdown field for M1 , M2..below screen made by @divya.17290 with 25 replies.

In_Config ERROR Assign: Object reference not set to an instance of an object. IN INITALLAPPLICATION made by @krishnapriya_Anu with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@supriya117 made 45 posts!

@raja.arslankhan made 44 posts!

Top 3 Most Liked Posts

This post made by @hikumar received 6 likes!

Can anyone give me RPAChallange with best practices file

Can some one please give RPAChallange XML file all done with best practices, and can someone verify if any other best practices can be implemented

This post made by @supermanPunch received 2 likes!

How do I change values of a table in extraction results?

Hi @sharon.palawandram , I was able to check on the modification to be done by using Json Serialize and Deserialize Methods. Inspecting the Extraction Results Json : First off, our taxonomy would always be fixed, this would also mean that the Table columns defined would also be fixed. Keeping that in mind, we can at the beginning check the extractionResults value by Serializing it to a String, so right after the Data Extraction Scope (I performed it in Extraction Rules Check workflow of DU F…

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

Installation of multiple robots on one windows server

@DamilolaAdeogun Yes it is possible when you have mutilple users on one windows server. Suppose I have Window server and 20 users can login in that server then you can configure 20 Robots. Install UiPath Orchestrator: UiPath Orchestrator is a web application that provides centralized management and control for your robots. Install UiPath Orchestrator on the Windows Server by following the installation guide provided by UiPath. Configure UiPath Orchestrator: Once Orchestrator is installed, con…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

How do I change values of a table in extraction results?

Hi @sharon.palawandram , I was able to check on the modification to be done by using Json Serialize and Deserialize Methods. Inspecting the Extraction Results Json : First off, our taxonomy would always be fixed, this would also mean that the Table columns defined would also be fixed. Keeping that in mind, we can at the beginning check the extractionResults value by Serializing it to a String, so right after the Data Extraction Scope (I performed it in Extraction Rules Check workflow of DU F…

This solution provided by @Yoichi received 1 likes!

Is there a better way to write strings that contain quotes?

Hi, Can you try to use JObject as the following? [image] Regards,

This solution provided by @raja.arslankhan received 1 likes!

Dynamic Selector can't find the item!

@170290064 Before click or check state print the value? I suggest use minimum variable in selector, one or 2 is enough. second Check spaces aside value.

---

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

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

[system]

Daily Forum Report | 12 July 2023

Top 3 Topics with Most Views

Unable to run nupkg file made by @zeesh19791 with 46 views.

Can you run uipath automation from browser made by @sara.andonova with 39 views.

Illegal characters in path when using Directory.GetFiles on WebDav made by @Joachim with 38 views.

Top 3 Topics with Most Replies

I have the output excel in the Initialize All Applications I want to read the excel pass the argument as a data row to the Process state made by @krishnapriya_Anu with 39 replies.

Duplicate / Move sheet from Excel B to Excel A made by @SyafiqKCS with 25 replies.

Sheet name modification made by @T_Y_Raju with 24 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 73 posts!

@Anil_G made 57 posts!

@supriya117 made 46 posts!

Top 3 Most Liked Posts

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

State of the Automation Professional report 2023 is here!

@Oana_Chicioroaga Wao Amazing

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

State of the Automation Professional report 2023 is here!

@Oana_Chicioroaga Thanks for kind words. Being a developer I always try to learn from every plarform and share knowledge to convert it into wisdom.

This post made by @Yoichi received 2 likes!

Windows 10で別のモニタにウィンドウを移動する方法

こんにちは １．MoveWindowで座標(0,0)に移動でいかがでしょうか？ [image] ２．ショートカット操作でいかがでしょうか？ [image]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Windows 10で別のモニタにウィンドウを移動する方法

こんにちは １．MoveWindowで座標(0,0)に移動でいかがでしょうか？ [image] ２．ショートカット操作でいかがでしょうか？ [image]

This solution provided by @Yoichi received 2 likes!

Illegal characters in path when using Directory.GetFiles on WebDav

Hi, It seems your path string ends with 0x00 (special character). So can you try to remove it OR use Trim(chr(0)) as the following? "your path string".Trim(chr(0)) [image] Regards,

This solution provided by @Yoichi received 1 likes!

.nupkgをbatファイルで起動した場合Excelアクティビティが正常に実行できない。

よくあるケースとして、対象ファイルを相対パスで記述している場合は、 書き込んだ（と思っている）ファイルが異なるケースがあります。 nupkgを指定した場合、プロジェクトフォルダは c:\Users\ユーザー名\.nuget\パッケージ名\バージョン 以下の深いところになりますので、そちらのファイルが更新されていないか 確認してみてはと思います。

---

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

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

[system]

Daily Forum Report | 13 July 2023

Top 3 Topics with Most Views

Authentication failed because the remote party sent a TLS alert: ‘DecodeError’ made by @shreyash_shirbhate with 48 views.

Finding Index of Duplicate Entries using linq query made by @yash.choursia with 47 views.

Get the total count of files and paste that in excel made by @Priyesh_Shetty1 with 47 views.

Top 3 Topics with Most Replies

How can i run studio's scripts using Studio X made by @rania.mohamed1 with 37 replies.

Illegal Path Error made by @marina.dutta with 30 replies.

Get the total count of files and paste that in excel made by @Priyesh_Shetty1 with 27 replies.

Top 3 Users Who Posted The Most

@supriya117 made 57 posts!

@raja.arslankhan made 52 posts!

@Anil_G made 51 posts!

Top 3 Most Liked Posts

This post made by @supriya117 received 2 likes!

How to check whether the string in datatable is completely included?

Hi @Bosch If you want to check whether the person name present in the datatable or not then you can use this linq query. nameExists = dataTable.AsEnumerable().Any(Function(row) row.Field(Of String)("Name") = personName) Here personName is a string variable contains the person name.

This post made by @pravallikapaluri received 1 likes!

Line break

Hi @DimitriLYR Use Trim function In the Place of Fruits give Columnname CurrentRow(“Fruits”).ToString.Trim [image] Hope it helps!!

This post made by @postwick received 1 likes!

Comparison between String and Dictionary's Key Value

This needs to be CDbl(dictVar(“No1”).ToString) And they don’t want to compare No1 to No2. They want to see if the value 5 is in the dictionary.

Top 3 Most Liked Solutions

This solution provided by @raja.arslankhan received 1 likes!

How to pass Multiple Values to Attributes of Element Exists Activity

@Bhavesh_Batra Documentation: https://docs.uipath.com/studio/standalone/2023.4/user-guide/regex-search With one element exist approach is not reliable in case of two different selectors. I prefer solve it through regex selector and use one element exist.

This solution provided by @drbuddepu received 1 likes!

Cannot indicate the Extract Table Data Activity

@170290064 Extend the target in properties and copy the whole strict selectors. Open the fuzzy selectors and clear the selectors and paste the strict selectors and hit on save. In targeting method uncheck the strict selector and check the fuzzy selectors and save the program. [MicrosoftTeams-image] Hope it helps!!

This solution provided by @supermanPunch received 1 likes!

How to check whether the string in datatable is completely included?

Hi @Bosch , From the data available and results mentioned, we can understand that if all the words in the name are present in the Datatable column values, then it is an acceptable case. Hence, we can first split the Name with Space, so we get the array of words. Then we check if all the words are present in the column cell and then mark the result accordingly. Splitting of the word to an Array : wordsInNameArray = Split(Name).ToArray Here, wordsInNameArray is a variable of type Array of S…

---

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.