Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 August 2023

Top 3 Topics with Most Views

UiPath UIAutomation 23.8 Community Release made by @Bogdan_Sultana with 73 views.

【募集期間が延長されました】コミュニティ フォーラム: 新しい翻訳機能のテスト参加者を募集しています! made by @Susa with 58 views.

String manipulation and comparison made by @duaine.b with 47 views.

Top 3 Topics with Most Replies

Remove comas from data table or txt made by @E.T.S with 43 replies.

String manipulation and comparison made by @duaine.b with 19 replies.

REGEX quiz made by @Latifa with 16 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 70 posts!

@postwick made 44 posts!

@mkankatala made 43 posts!

Top 3 Most Liked Posts

This post made by @rikulsilva received 4 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I’d love to join - Brazilian Portuguese

This post made by @Bogdan_Sultana received 4 likes!

UiPath UIAutomation 23.8 Community Release

The UIAutomation 23.8 Preview package was just published with a slight delay vs. the other UiPath Preview packages. Here’s what’s new: With our latest enterprise version 23.4 we released the Trigger-based framework, a new way to build Attended Automations, with event-driven architecture. We provided support for native events monitoring through the Application Event Trigger activity for certain technologies: Web, Java, Active Accessibility. Also, we continue our story of integrating Computer Vis…

This post made by @Susa received 3 likes!

【募集期間が延長されました】コミュニティ フォーラム: 新しい翻訳機能のテスト参加者を募集しています!

以下は Fresh New Opportunity: Pilot A New Forum Feature and Get Rewarded! の抄訳です。詳しくは、元の記事をご覧ください。 UiPath コミュニティ ユーザーの皆様へ、 9 月 1 日から 9 月 24 日までの間、UiPath コミュニティ フォーラム内で、新しい翻訳プラグインのパイロット プロジェクトを実施します。つきましては、このプロジェクトにご参加いただける日本語話者のボランティア メンバーを先着 5 名で募集いたします。 ご参加いただける方は、8 月 31 日 9 月 7 日までに Fresh New Opportunity: Pilot A New Forum Feature and Get Rewarded! に対してリプライしてお申し込みください。翻訳プラグインの使用感についてご感想を提供いただける場合、40 ドル相当の UiPath グッズ バウチャーをご用意しております。 皆様のご参加を心よりお待ちしております。 UiPa…

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 2 likes!

For Each Element Properties

Hi @mango3392 To get the properties of type argument for the for each activity. Downgrade the version of UiPath.System.activities package. Then you can see the type argument properties in for each activity. But the new for each also works good, When you pass the collection variable in the condition field it will automatically changes its type argument automatically. If the condition is array variable it will automatically changes it type argument to array in the background and it works fine. H…

This solution provided by @arjunshenoy received 1 likes!

Else Ifアクティビティの条件文の計算結果をBoolean型に変換したい

Hi @gorby Could you please try the following condition: CInt(row(“number of oranges”).ToString) > 0 AND CInt(row(“number of oranges”).ToString) < 6 Hope this helps, Best Regards.

This solution provided by @Yoichi received 1 likes!

Tricky Question

Hi, How about the following expression? yourString="900323" Then listStr = Enumerable.Range(0,4).Select(Function(i) yourString+i.toString+"00000").ToList [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 | 31 August 2023

Top 3 Topics with Most Views

Reading config from Asset instead of Config.Json or Excel file made by @sonaliaggarwal47 with 47 views.

How to change month to number made by @Mathkar_kunal with 47 views.

Looping over data rows, but starting with the 5th row directly made by @maria-iulia.zdrenghea with 41 views.

Top 3 Topics with Most Replies

How to change month to number made by @Mathkar_kunal with 39 replies.

Excel Formulas when assigned not working made by @P-A-J with 24 replies.

Update values DT in single row made by @Sathish_Kumar_S with 24 replies.

Top 3 Users Who Posted The Most

@Shiva_Nikhil made 65 posts!

@Anil_G made 60 posts!

@mkankatala made 51 posts!

Top 3 Most Liked Posts

This post made by @l.wang received 3 likes!

To Make Workflow analyzer rules automatically apply to all projects universally across the UiPath Studio environment

Thanks! That was what I thought. The rules are on the project level. The only way to make it shared through projects is to make a template I guess.

This post made by @HANACCHI received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Thanks for sharing the interesting initiative. I’d like to join (Japaneses language). 73 & 88

This post made by @robot.gestus received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Great, I would like to participate and help as a Brazilian Portuguese speaker.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

My studio publish is grayed out (Attended License)

Hi, Can you check the following document? Is there Robot default option? [image] https://docs.uipath.com/studio/standalone/2023.4/user-guide/about-publishing-automation-projects If we have only Attended license, we cannot publish the project. (We need Automation Developer license etc.) Regards,

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

Uipath getting freezed while

Hi @sakshi562023 Check this post Hope this might help

This solution provided by @Vikas_M received 1 likes!

Rgex other than is pattern matching

[image] Please refer above screenshot so basically it is near variables panel Hope it helps u out1

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

@Anil_G received 49 likes for their solutions!

@Yoichi received 45 likes for their solutions!

@ppr received 31 likes for their solutions!

---

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

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

[system]

Daily Forum Report | 01 September 2023

Top 3 Topics with Most Views

Thoughts after the UiPath Hyperhack 2023 made by @George_Roth with 51 views.

Can't get the correct datetime format made by @cacafundi with 46 views.

Counter with split - help made by @Ellen with 44 views.

Top 3 Topics with Most Replies

I want to convert pdf file to excel made by @office_work with 22 replies.

Counter with split - help made by @Ellen with 20 replies.

Get last value with regex made by @murat.karasoy with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@Anil_G made 36 posts!

@postwick made 31 posts!

Top 3 Most Liked Posts

This post made by @George_Roth received 6 likes!

Thoughts after the UiPath Hyperhack 2023

I had the honor to participate as a Jury member at the 2023 HyperHack AI Category Section. I didn’t see all the projects, but I saw the finalist 9. I was impressed by all these, below is the list of the finalists with what their automations do. First prize: DrSimplifAI – developed by SimplifyNext team from Singapore This is an automation app for a healthcare use case that aims to enhance the patient experience and improve doctor-patient interactions by leveraging Specialised AI and Generative…

This post made by @koreta received 5 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Hi @loredana_ifrim. I would like to participate. I speak Japanese. Thank you in advance.

This post made by @Yamasakia received 4 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I want to participate I am Japanese. Best regards.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Questions About StudioX found in Dumps of RPA Exam Questions

@Shreyas_Khorgade There would not be any studiox related question for detailed syllabus check this…this will have all info [image] and also questions would be almost at same level as the exam cheers

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

Remove vowels from string

Hi @Rishab2 Welcome to community Check this expression Have this in value stored to a variable System.Text.RegularExpressions.Regex.Replace(“yes”,“[AEIOUaeiou]”,“”)

This solution provided by @mkankatala received 1 likes!

Read Range stays pending & Date conversión issue

Hi @Luis_Fernando Instead of using read range workbook activity use the read range activity which is the modern excel activity. => Take use excel file activity and pass the excel file path. => Inside use excel file activity insert the read range activity. In the properties of read range activity, Read formatting option is there select the raw value option which holds the same format of the cells and store in a datatable. => After that use the write csv file to write the datatable to csv file…

---

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

Top 3 Topics with Most Views

Read CSV Activity made by @KuruvaJayaPrakash with 33 views.

How can I delete rows in an excel file if for example column A is empty made by @goncalo.rocha with 32 views.

Extract the filenames from a folder and save them in Excel or Notepad made by @jharmel.carmona with 29 views.

Top 3 Topics with Most Replies

Match DT data with other DT and get the email address made by @Sathish_Kumar_S with 18 replies.

Extract the filenames from a folder and save them in Excel or Notepad made by @jharmel.carmona with 10 replies.

How to convert a string to a mail message made by @P-A-J with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 14 posts!

@Anil_G made 12 posts!

@postwick made 11 posts!

Top 3 Most Liked Posts

This post made by @takashi_hashimoto received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

I am a Japanese living and working in Japan. I would love to participate.

This post made by @takashi_hashimoto received 2 likes!

Fresh New Opportunity: Pilot A New Translation Forum Feature and Get Rewarded!

Native language is Japanese

This post made by @Yoichi received 1 likes!

Need help on arg value

Hi, Unfortunately, out type argument will be blank when exit the xaml due to exception. How about using exception.Data as the following sample? Set content of yourname variable to exception.Data(“Yourname”) , then rethrow [image] we can get it using exception.Data(“yourname”) in catch state of main.xaml [image] The following is a sample of the above. BlankProcessv2.zip (6.4 KB) Regards,

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 | 03 September 2023

Top 3 Topics with Most Views

Code working in studio run but not through orchestrator made by @JOBIN_JOSE with 38 views.

Re framework automation made by @J_Crosby with 33 views.

Problem extracting Data URL made by @hiring.antiquescollectors with 32 views.

Top 3 Topics with Most Replies

How to get string after some character made by @aslam_ali1 with 13 replies.

Excel freeze Panes made by @Luffy with 13 replies.

Re framework automation made by @J_Crosby with 9 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 15 posts!

@postwick made 12 posts!

@Shiva_Nikhil made 11 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Re framework automation

Oh wow I m right It’s already discussed in forum @J_Crosby

This post made by @J_Crosby received 1 likes!

Re framework automation

@Palaniyappan @Shiva_Nikhil I saw those two questions and doubted the correct options after reading deeply on re-framework, that’s why I asked. Option B is also what I think is right from my research. I just needed a confirmation. Thanks a lot guys for your time Cheers J Crosby

This post made by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

Top 3 Most Liked Solutions

This solution provided by @Vikas_M received 1 likes!

Good evening, how to use regex in assign please

Hey @Girid , Please refer to already available questions in the forum in order to avoid recurring threads Also, to answer your question U can use System.Text.RegularExpressions.Regex.match(YourString,"\d+\d+.\d+").value Hope it helps you out!

This solution provided by @postwick received 1 likes!

Need a linq query to solve this issue

Why bother with an extra variable? Just do it all with an If expression… If(CurrentRow.ItemArray.All(Function(x) x.ToString().Equals(“NoChange”)),"OK","Error")

This solution provided by @Palaniyappan received 1 likes!

Transaction Status

It’s option B @J_Crosby

---

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

Top 3 Topics with Most Views

Errror Compare Two File made by @Muhammad_Taufik_Akbar with 52 views.

How to replace blank cell with 0 using Excel activities made by @lrtetala with 42 views.

UiPath Can't indicate SAP element made by @alvin.c.apostol26 with 40 views.

Top 3 Topics with Most Replies

Conditional formatting made by @E.T.S with 18 replies.

Unable to run app on mobile made by @Mathkar_kunal with 16 replies.

Get queue items -set transaction progress! made by @Hazem_Saleh with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@supermanPunch made 30 posts!

@ppr made 28 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This post made by @Anuj_Tiwari received 3 likes!

Migrating Legacy Listings to Windows

Hi everyone, You may already be aware that the default compatibility for new projects in latest versions of UiPath Studio is “Windows”. It’s important to know that the number of users using the Windows projects in Studio is increasing rapidly. The Legacy listings won’t support Windows so those users of latest Studio version(s) won’t be able to find and use Legacy listings under default compatibility. Therefore, we strongly ask all of you to complete the transition of your legacy listings to W…

This post made by @Pothanakar_Prabhakar received 2 likes!

How we can install uipath studio on linux server

Thanks for the resolution @Palaniyappan @arjunshenoy

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This solution provided by @Arvind_Kumar1 received 2 likes!

Passing values from one page to another

@Aditi_Jha , as you shown you are not using VB Apps. so please do below steps on legacy app. Set Value on click rule Create app variable In Set value pass the App variable and set value from your custom list. you can use app variable across other page now. Thanks, Arvind

This solution provided by @supermanPunch received 2 likes!

Write the values based on the column name in write cell activity

Hi @tharani.natarajan , Assuming that you have read the Data as a Datatable in Excel sheet, we can check with the below to convert Column Index to Column Letter : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.IndexOf("MailId")+1) Here, DT is the Datatable variable and columnLetter is a String variable.

---

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

Top 3 Topics with Most Views

How to hide password in the UiPath Apps made by @karthickrkumaran with 49 views.

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system made by @Yap_Derek with 42 views.

Need Regex Expression made by @Konda_Sai_Charan_Goud with 40 views.

Top 3 Topics with Most Replies

Delete existing file in download activity made by @E.T.S with 18 replies.

I want to create excel sheet on monthly basis made by @Bhushan_Nagaonkar with 15 replies.

SQL update passing variable made by @Povilas_Jonikas with 14 replies.

Top 3 Users Who Posted The Most

@ppr made 44 posts!

@Palaniyappan made 43 posts!

@postwick made 38 posts!

Top 3 Most Liked Posts

This post made by @Yap_Derek received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

Hi All, I am using the UiPathTeam.SharePoint.Activities on a windows legacy project to connect to SharePoint and I experiencing this authentication error. The bot has been running fine using this method for a long time until it failed yesterday. [image] Here are some additional details: Studio Version 2022.10.5 Robot is running on Window Server 2019 Account used does not have MFA enabled. I am using the latest version of the package which is version 1.7.0 I have doubled check and the login…

This post made by @Palaniyappan received 2 likes!

Duration process

Hi once the job run is over for a process, you can open Automation - > JOBS tab and click on " i " symbol to that run it shows the start time and end time like this [image] @Khoa_Automation-Factory

This post made by @Anil_G received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

@Yap_Derek This has been an open issue…workaround or better solution would be to move to office 365 activities Cheers

Top 3 Most Liked Solutions

This solution provided by @arjunshenoy received 2 likes!

Is it necessary to pass UiRPA before taking UiARD?

Hi @postwick If you have sufficient functional experience & knowledge of the UiPath tools, you can just skip the UiRPA & directly take up the UiARD examination, as I did. Hope this helps, Best Regards.

This solution provided by @postwick received 2 likes!

Object reference error plz solve

Check the arguments and variables. If this happens right when you try to run a process, it can mean you have something defined that doesn’t exist yet. For example, you cannot reference one variable in another variable’s default.

This solution provided by @Nitya1 received 2 likes!

Setting smart queue/time triggers

Hi @olgu Managing job triggers and ensuring that they don’t interfere with scheduled machine maintenance can be a challenging task in UiPath Orchestrator. Here are some suggestions to handle this scenario: Check Time Inside Workflow: As you mentioned, you can add logic within your workflow to check the current day and time. If it’s close to the scheduled maintenance window, you can gracefully end the job, making sure to complete any necessary cleanup tasks. Queue Trigger Time Window: W…

---

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

Top 3 Topics with Most Views

For each activity property missing made by @Jeeru_venkat_Rao with 45 views.

For Each Row in Data Table fail. Why? made by @Norbi_V with 42 views.

Multiple attribute in selector using OR operator made by @Akshat_Sharma1 with 40 views.

Top 3 Topics with Most Replies

Guide me how can i download the several file from the website made by @Akash5 with 23 replies.

Using browser in a loop error made by @Povilas_Jonikas with 15 replies.

For each activity property missing made by @Jeeru_venkat_Rao with 13 replies.

Top 3 Users Who Posted The Most

@postwick made 31 posts!

@Palaniyappan made 29 posts!

@ppr made 26 posts!

Top 3 Most Liked Posts

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

Help me with coding uipath best practices

Hi @Rishab2 Check this out Hope this helps

This post made by @Yap_Derek received 2 likes!

UiPathTeam.SharePoint.Activities Authentication exception: The sign-in name or password does not match one in the Microsoft account system

Thanks for your answer @sonaliaggarwal47. I have not upgraded to v2020.10.x recently. When I started working on UiPath projects, the studio version I work with is already version 2022.10.5 and we have been running this version for the past 7-8 months. I will look into the o356 activities as suggested. Thanks

This post made by @Akshat_Sharma1 received 1 likes!

Multiple attribute in selector using OR operator

Hi Community, Recently I came across an automation problem. I am using element exist activity using aaname to detect a text. Now in some cases with aaname its not able detect element but with visible innertext its able to detect. Is there any way we can use put both and if value matches with either aaname or visible innertext then element exist returns true value. Thanks

Top 3 Most Liked Solutions

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

Help me with coding uipath best practices

Hi @Rishab2 Check this out Hope this helps

This solution provided by @Karthik_Reddy_A received 1 likes!

For each row in Excel file

@E.T.S hi use for each row in datatable inside use two assign activities variable1=currentrow(“ColumnName”).tostring variable2=currentrow(“ColumnName”).tostring columnname you can mention your column Names cheers

This solution provided by @Vikas_M received 1 likes!

I have 2 excel with same headers

Hey @Girid Please refer below website https://docs.uipath.com/activities/other/latest/workflow/merge-data-table Also please refer below video [UiPath Tutorial | Merge Data table & Join Data tables activity | Comparison and property explanation] Hope it helps you!

---

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

Top 3 Topics with Most Views

Unable to resolve Object reference error at startup made by @theEmailRobot with 52 views.

[Solved] UiPath to show timestamp in message box made by @Sathish_Ashokan with 45 views.

UiPath Action Center help needed made by @Ritaman_Baral with 43 views.

Top 3 Topics with Most Replies

Unable to resolve Object reference error at startup made by @theEmailRobot with 26 replies.

Renaming file with current date and time made by @E.T.S with 18 replies.

Can i paste value in variable? made by @Samraat_Maharjan1 with 16 replies.

Top 3 Users Who Posted The Most

@postwick made 40 posts!

@Palaniyappan made 37 posts!

@ppr made 27 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This post made by @Yoichi received 1 likes!

[Solved] UiPath to show timestamp in message box

HI, What format do you need? The simplest is just Now as the following. [image] Regards,

This post made by @vinitha_yachamaneni received 1 likes!

Unattended Robot doesn't work in a different location

Hi @Carla_Munoz If your Unattended Robot is not running when your laptop is outside your home location, it’s likely because the Orchestrator is unable to connect to your laptop due to network or firewall restrictions Also Ensure that your laptop has a consistent way to be reached from Orchestrator, even when it’s outside your home network. This can be done by setting up a static IP address or configuring dynamic DNS (DDNS) if your laptop’s IP address changes when you move

Top 3 Most Liked Solutions

This solution provided by @ppr received 1 likes!

Convert HTTP Response with nested JSON to DataTable

For some dynamics we can have a look at this longer oneliner: [grafik] And can break the idea down to smaller parts and/or decompose it to essential activities myRowJOs | List(Of JObjects) = myJObject("d")("results").Cast(of JObject).Select(Function (x) new JObject(x.Properties.Where(Function (p) Not p.Name.Equals("__metadata")))) we constructed new JObjcets where we removed the __metadata property (could be extended by a block list approach as well) then we convert it to a DataTable: d…

This solution provided by @Yoichi received 1 likes!

変数に1000を掛けたい

こんにちは 変数の型をそろえる必要があるかと思います。基本的には以下の様になります。 [image] 変数A(Int型)で取得した値12.000 整数型は小数点以下を扱えませんので、代入は12になるかと思います。 エラー内容：Option Strict On で ‘String’ から ‘Double’ への暗黙の型変換はできません 型があっていないと思います。変数BがString型ではないでしょうか？ その場合、(変数A*1000).ToString の様にする必要があります。

This solution provided by @Yoichi received 1 likes!

Need to extract data from textfile

HI, How about the following expression? This extract numeric characters which exists at the end of the next line of “PO NUMBER” (Because I guess it’s PO NUMBER) [image] System.Text.RegularExpressions.Regex.Match(strData,"(?<=PO NUMBER[\s\S]+?)\d+(?=\r?\n|$)").Value Sample20230907-3L.zip (14.4 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 | 08 September 2023

Top 3 Topics with Most Views

https://forum.uipath.com/t/580731 made by @wwls with 42 views.

https://forum.uipath.com/t/580901 made by @Kunal_Jain with 41 views.

https://forum.uipath.com/t/580691 made by @Tri_Vu with 41 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/580836 made by @E.T.S with 20 replies.

https://forum.uipath.com/t/580834 made by @rishiathawale with 16 replies.

https://forum.uipath.com/t/580954 made by @E.T.S with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Palaniyappan made 25 posts!

@postwick made 24 posts!

Top 3 Most Liked Posts

This post made by @Kartheek_Battu received 3 likes!
https://forum.uipath.com/t/580715/4

This post made by @Shiva_Nikhil received 2 likes!
https://forum.uipath.com/t/580718/4

This post made by @mpraveen1902 received 2 likes!
https://forum.uipath.com/t/580715/3

Top 3 Most Liked Solutions

This solution provided by @mpraveen1902 received 2 likes!
https://forum.uipath.com/t/580715/3

This solution provided by @Parvathy received 1 likes!
https://forum.uipath.com/t/580678/4

This solution provided by @Shiva_Nikhil received 1 likes!
https://forum.uipath.com/t/580718/2

---

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

Top 3 Topics with Most Views

DataRow Item Array Convert into Datatable made by @Shyam_Pragash with 38 views.

Error Downloading Monthly Report from Microsoft Edge - REF Assignment made by @Vishnu_Vardhan_Addagada with 31 views.

Error in variable when placed as integer in scope made by @Smit_Jain with 31 views.

Top 3 Topics with Most Replies

Error in variable when placed as integer in scope made by @Smit_Jain with 18 replies.

Unable to Copy the color of filter cells made by @Cuberoot with 13 replies.

How to Delete the folder which has yesterday's date in lt made by @Girid with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Nitya1 made 17 posts!

@Smit_Jain made 11 posts!

Top 3 Most Liked Posts

This post made by @Cuberoot received 2 likes!

Unable to Copy the color of filter cells

input file is in Sheet1 and output file is in Sheet2. Thanks

This post made by @Shiva_Nikhil received 2 likes!

Have created an automation to add data row to data table but showing some error,thanks for any help

@Sai_Kumar_111 Hi [image] [image] [image] cheers

This post made by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

@Vishnu_Vardhan_Addagada Are you not able to indicate? If so did you happen to try changing the mode to active accessibility and try? Ideally you should get some selector like below <wnd app=‘msedge.exe’ cls=‘Chrome_WidgetWin_1’ title=‘* Microsoft​ Edge’ /> <ctrl name='Save As' role=‘push button’ /> Cheers

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 2 likes!

Have created an automation to add data row to data table but showing some error,thanks for any help

@Sai_Kumar_111 Hi [image] [image] [image] cheers

This solution provided by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

@Vishnu_Vardhan_Addagada Are you not able to indicate? If so did you happen to try changing the mode to active accessibility and try? Ideally you should get some selector like below <wnd app=‘msedge.exe’ cls=‘Chrome_WidgetWin_1’ title=‘* Microsoft​ Edge’ /> <ctrl name='Save As' role=‘push button’ /> Cheers

This solution provided by @Vikas_M received 1 likes!

How to Delete the folder which has yesterday's date in lt

@Girid , Please refer below file BlankProcess.zip (8.5 KB) Hope it helps you!

---

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

Top 3 Topics with Most Views

Regex and Delay not working made by @Ritaman_Baral with 38 views.

I get this error “Excel Application Scope” after I clicked “Run”? made by @Sara_Piana with 36 views.

Build your first automation studio made by @Vincent_Shoshin with 31 views.

Top 3 Topics with Most Replies

I get this error “Excel Application Scope” after I clicked “Run”? made by @Sara_Piana with 15 replies.

Regex and Delay not working made by @Ritaman_Baral with 12 replies.

About extraction of invoice details using document understanding made by @Nithin_Thatikonda with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@Sara_Piana made 13 posts!

@Palaniyappan made 12 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Varshney received 1 likes!

Wipro - UiPath Test Suite - Across Country - India - Full Time

Job title: UiPath Test Suite Job role: RPA Developer Country: India City: Across Country Company name: Wipro Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Looking for 2-8 years of person with Experience in UiPath Test Suite. Preference to short notice period Candidates Apply here: shubham2712@gmail.com

This post made by @lrtetala received 1 likes!

I get this error “Excel Application Scope” after I clicked “Run”?

Hi @Sara_Piana Please check on this thread it might be helps you

This post made by @Yoichi received 1 likes!

How to debug error using wildcard?

Hi, Can you try to replace unfixed string with asterisk in SendHotKey activity as same as AttachWindow? name='*File_*.txt - Notepad' [image] Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to debug error using wildcard?

Hi, Can you try to replace unfixed string with asterisk in SendHotKey activity as same as AttachWindow? name='*File_*.txt - Notepad' [image] Regards,

This solution provided by @Palaniyappan received 1 likes!

Hi, I have some big values to save and process like -10,00,00,00,30,29,601 (+ve as well as -Ve) and -118.1966670 (with high decimal precision) which data type I should use to process such data?

Hi For large values, you should use the Int64 data type. The Int64 data type can store values up to 9,223,372,036,854,775,807. This is more than enough to store the values you mentioned. For values with high decimal precision, you should use the Double data type. The Double data type can store values up to 15 decimal places. This is enough to store the value -118.1966670. If you are not sure which data type to use, you can always use the String data type. The String data type can store any ty…

This solution provided by @Anil_G received 1 likes!

Creating an automation for some process and getting error while assigning to variables

@Sai_Kumar_111 Ideally it would work…i hope this is inside for each row in datatable activity…sometimes the columns are casted as objects…and at that time we need to add .ToString Hope this helps Cheers

---

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

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

[system]

Daily Forum Report | 11 September 2023

Top 3 Topics with Most Views

Apps - Attended Real time Communication made by @Venkata_Rajendran with 176 views.

How to combine 2 rows(with header) into a single row header? made by @angush.st with 66 views.

How to Split the Rows in a Data Table into multiple Data Tables? made by @Vishnu_Vardhan_Addagada with 51 views.

Top 3 Topics with Most Replies

Write Cell Workbook not allowing me to update Excel without closing it first made by @Ampra with 25 replies.

I want to take first row data column 3 to column 12 other all below data will be delete which has duplicate ID and Duplicate Address value made by @Garyy with 14 replies.

How to Run SAP scripting made by @Learner007 with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 43 posts!

@Nguyen_Van_Luong1 made 23 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Venkata_Rajendran received 11 likes!

Apps - Attended Real time Communication

We are very excited to release our latest feature of Apps- Attended Robot real-time communication. This capability allows you to communicate between Apps and attended robots in real time. With this feature, we will be solving the performance issue of starting a new process every time, there is a need to communicate between Apps and Attended robots. Using this capability, an App can start a process and communicate with the process any number of times by invoking various XAMLs in the process. Th…

This post made by @Ampra received 2 likes!

Write Cell Workbook not allowing me to update Excel without closing it first

I was able to apply the fix!! I can now write to the file I wanted I just want to say- I am terribly sorry for how drawn-out this became. I am trying to follow along in the UiPath course but the version in the videos are outdated and different from mine. It is making this process of learning very difficult, but your support has been the only thing keeping me going. Thank you so very much for your patience and advice with help. You are truly rockstars <3 @Parvathy @Palaniyappan -Ampr…

This post made by @neha.upase received 2 likes!

How to get count of empty columns in the excel

Hi, Try this emptyRowCount = YourDataTable.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row.Field(Of String)(“ColumnA”)) AndAlso String.IsNullOrEmpty(row.Field(Of String)(“ColumnC”))).Count()

Top 3 Most Liked Solutions

This solution provided by @Jeroen_van_Loon received 1 likes!

Outlook shared mailbox synchronization takes too long

Common problem indeed. A few tips I’ve used in the past in different environments: you can leave outlook open if your VDI’s are persisten validate the status bar, and look for something like ‘all folders up to date’ and wait for that dynamically when opening outlook. When you use your get mail messages activities, be sure that it is set up to get enough messages. Know that if you use filters in this activity, the filters are applied ‘after’ getting the messages. Example: your mailbox contain…

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

How to Split the Rows in a Data Table into multiple Data Tables?

Hi, @Vishnu_Vardhan_Addagada my code Main.xaml (21.9 KB) my input Test.xlsx (9.9 KB) my output in csv output.zip (1.3 KB) full path Split Data.zip (24.5 KB) regards,

This solution provided by @Palaniyappan received 1 likes!

How to copy a text from a textbox and paste it to another textbox using UiPath StudioX?

Hi Welcome to UiPath forum hope the below steps would help you resolve this use GET ATTRIBUTE activity to get the text VALUE of an attribute https://docs.uipath.com/activities/other/latest/ui-automation/get-attribute#:~:text=Retrieves%20the%20value%20of%20a,the%20aastate%20attribute%2C%20for%20example. then use TYPE INTO ACTIVITY and indicate the field where you want to paste it along with the value obtained from above activity mention the variable and then press PLUS button to include…

---

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

Top 3 Topics with Most Views

Creating a Workday connection in Integration Service made by @Samrat_Dutta with 69 views.

How to update the status made by @anjani_priya with 46 views.

How to Install Teams Packages made by @wsinten with 43 views.

Top 3 Topics with Most Replies

How to update the status made by @anjani_priya with 12 replies.

How to Install Teams Packages made by @wsinten with 11 replies.

Forms made by @Rohit_Nandwani with 10 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 56 posts!

@Palaniyappan made 33 posts!

@postwick made 30 posts!

Top 3 Most Liked Posts

This post made by @Samrat_Dutta received 2 likes!

Creating a Workday connection in Integration Service

Step One: Create an Integration System User (ISU) In your Workday portal, log into the Workday tenant. In the Search field, type Create Integration System User. Select the Create Integration System User task. [image] On the Create Integration System User page, in the Account Information section, enter a user name, and enter and confirm a password. Click OK. [image] Note: due to xml encoding, “&”, “<”, and “>” cannot be included in the password. Note: Make sure Require New P…

This post made by @Palaniyappan received 2 likes!

UiPath Spotlight Directory: Amplify Your Presence

This is fantastic

This post made by @ppr received 1 likes!

Extract the specific value from the JSON object

in Addition to above: [grafik] output - myJObject | DataType: JObject [grafik] Kindly note: the property keys are case sensitive when using it

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Update Datatable column name when it contain certain word?

Hi @winnie_toh , You can use if check contains then assign yourDT.Columns(index).ColumnName = “New Column Name” can you share your file and conditions regards,

This solution provided by @Yoichi received 1 likes!

Data table filter wizard unable to filter column name that contain line breaks

Hi, How about the following? [image] "Sep TTL"+vblf+"Allo" OR "Sep TTL"+vbcrlf+"Allo" Sample workflow Sample20230912-1L.zip (8.3 KB) Regards,

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Tooltip in Argument Panel

Hi @irahmat , You can right click to argument then select design properties [image] [image] [image] [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 | 13 September 2023

Top 3 Topics with Most Views

Filter Data Table from excel made by @ainaasyhda with 51 views.

Extract table of contents + Word document made by @Sairam_RPA with 44 views.

繰り返し(並列)アクティビティについて made by @norihiko.okubo0201 with 41 views.

Top 3 Topics with Most Replies

Lookup data table not configured correctly made by @E.T.S with 49 replies.

Read txt file and Split Each Row made by @prerna.gupta with 15 replies.

Correct format issue made by @aya_lajili1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@postwick made 30 posts!

@E.T.S made 25 posts!

Top 3 Most Liked Posts

This post made by @nikhilesh578 received 6 likes!

Monthly Forum Rewards - August 2023

Hearty Congratulations Everyone Well done @Anil_G , @Shiva_Nikhil , @mkankatala , @Usha_Jyothi , @neha.upase …keep going Cheers, Nikhilesh Sathyavarapu

This post made by @Dinesh_Guptil received 3 likes!

Monthly Forum Rewards - August 2023

Hi @loredana_ifrim @UiPath_Community Can you please confirm with the proper name of 5th candidate that is actually @Shiva_Nikhil Regards, Dinesh

This post made by @Anil_G received 2 likes!

Monthly Forum Rewards - August 2023

Congratulations everyone cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Extract table of contents + Word document

Hi, How about the following sample? [image] Sample20230913-2L.zip (15.5 KB) Regards,

This solution provided by @Shiva_Nikhil received 1 likes!

Read txt file and Split Each Row

@prerna.gupta taskforum.zip (2.8 KB) check this

This solution provided by @ppr received 1 likes!

The source contains no datarows fixes?

General pattern to handle it defensive: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

---

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

Top 3 Topics with Most Views

In Chrome and Edge v117 the Active Accessibility support is broken for IFRAMEs and PDFs made by @Luiza_Surdu-Bob with 107 views.

Extracting Post code from address made by @duaine.b with 40 views.

Error appear regarding use excel file made by @Nur_Amin with 39 views.

Top 3 Topics with Most Replies

Pick out unique email addresses from 2 columns and paste the unique email addresses in the BCC field of send smtp activity made by @ayushi_jain3 with 20 replies.

Regex to find first word that contains number made by @Suastrian_Dika with 15 replies.

Addition not working made by @Kamalesh_Chunekar with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 57 posts!

@Anil_G made 33 posts!

@postwick made 28 posts!

Top 3 Most Liked Posts

This post made by @raghu30691 received 3 likes!

Monthly Forum Rewards - August 2023

Hearty Congratulations Forum Leaders… @Anil_G , @Shiva_Nikhil Cheers

This post made by @Anil_G received 3 likes!

Need to capture value from this complex JSON

@c3f1e68294fdcf4a1f0a817ca first use a deserialize json activity and then from output use for for loop jobj("users")(0)("memberships").Cast(Of JObject) and inside loop use currentJObject("status").ToString currentJObject("permission_profile")("id").ToString currentJObject("permission_profile")("name").ToString Implementation [image] output [image] Hope this helps cheers

This post made by @mukeshkala received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

The UiPath emoji is awesome

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 3 likes!

Need to capture value from this complex JSON

@c3f1e68294fdcf4a1f0a817ca first use a deserialize json activity and then from output use for for loop jobj("users")(0)("memberships").Cast(Of JObject) and inside loop use currentJObject("status").ToString currentJObject("permission_profile")("id").ToString currentJObject("permission_profile")("name").ToString Implementation [image] output [image] Hope this helps cheers

This solution provided by @Anil_G received 2 likes!

Lookup data table not configured correctly

@E.T.S If you need the whole row use thsi dt.AsEnumerable.Where(function(x) Regex.Replace(x(0).ToString,"(\r?\n)*","").ToLower.Contains(Regex.Replace(YourStringVariable,"(\r?\n)*","").ToLower)).FirstOrDefault And if you need it as datatable and all the matched rows if there are multiple…then bettern first check if any thing is matching using if and then use copyto datatable To check matched dt.AsEnumerable.Where(function(x) Regex.Replace(x(0).ToString,"(\r?\n)*","").ToLower.Contains(Regex.Re…

This solution provided by @Gokul_Jayakumar received 1 likes!

Transpose excel data

@suraj.l Refer to this Xaml file you may get some idea. Transpose.xaml (11.4 KB) [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 | 15 September 2023

Top 3 Topics with Most Views

How to insert data dynamically into column in excel made by @panguluri_saritha with 51 views.

Unable to convert the Jsonobject to Json array made by @srinusoft37 with 40 views.

Orchestrator webhook not sending Notification to Microsoft team channel made by @mallikarjun411 with 40 views.

Top 3 Topics with Most Replies

Content placeholder in add to text slide PowerPoint activity made by @E.T.S with 18 replies.

Can anyone help me how to download pdf uipath associate certificate from CertMetrics account made by @PriyaReddy with 17 replies.

How to insert data dynamically into column in excel made by @panguluri_saritha with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 44 posts!

@ppr made 29 posts!

@Praveen_Mudhiraj made 24 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

Cool features @loredana_ifrim

This post made by @LamaX received 2 likes!

How to use project's folder without using hard code?

This is a very cool expression. I just mentionned the folder name like “Initialisation” in the ‘path field’ and he recognized it as a folder and used it as a full path. It’s amazing. Thank you also @Palaniyappan and @ppr !

This post made by @seonghyeon_pak received 2 likes!

UiPath studio 설치문의

좌측 하단을 보니… 계정이 커뮤니티 라이선스인지… 확인이 필요할 것 같습니다. cloud.UiPath.com으로 이동하시면 좌측에 버튼이 있을 겁니다. 누르시면 아래와 같은 화면이 나올텐데요 [image] 관리자 혹은 admin 선택해주시고 아래와 같이 license 창 아래에 커뮤니티 플랜인지 먼저 확인해주세요. [image] 만약, 커뮤니티 플랜이 아니라면 커뮤니티 계정을 새로 만드시는 것이 좋을 것 같습니다. 가입을 누르시면 아래와 같이 좌측에 창이 나올 텐데요 [image] 바로 가입을 하지 마시고 커뮤니티용 automation cloud 사용하기를 눌러서 아래와 같은 창이 나올 때 가입을 진행해주시면 됩니다. [image] 가입을 하시면 studio에 새로운 아이디를 연결하셔야할텐데… studio 우측 상단에 보시면 자기 계정의 이니셜 모양의 버튼이 있을 겁니다. [image] 로그아웃 해주시고 새로 연결해주시면 되겠습니다.

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

I have csv file data i want to duplicate row according to duplicate ID and Member only take one row of one duplicate id and member column

@suyog79 Try this Dt.AsEnumerable.GroupBy(function(x) x(0).ToString+x(1).ToString+x(5).ToString).Select(function(x) x.First).GroupBy(function(x) x(0).ToString+x(1).ToString).SelectMany(function(x) If(x.Count>1,x.Where(function(y) Not String.IsNullOrEmpty(y(5).ToString)),x)).CopyToDataTable Hope this helps Cheers

This solution provided by @ppr received 1 likes!

Unable to convert the Jsonobject to Json array

we could do directly: [grafik] Can iterate dynamically over all Properties: [grafik] Maybe you can tell more about the final goal / use case

This solution provided by @Yoichi received 1 likes!

リトライスコープで、BusinessRuleExceptionの場合だけ、リトライせずにスローしたい

こんにちは 例えば リトライスコープ内部でTryCatchを配置 CatchでBusinessRuleExceptionはその内容だけを外に渡せるようにして、正常終了させる その他のExceptionはRethrow でいかがでしょうか？以下実装イメージです。 [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 | 16 September 2023

Top 3 Topics with Most Views

Selectors issue on item made by @vineelag with 38 views.

String was not recognized as a valid DateTime like "45175" made by @anh.nguyen with 37 views.

How to export data from Orchestrator Queue made by @divya.17290 with 37 views.

Top 3 Topics with Most Replies

Match skills using chatgpt made by @ydhanabalan with 14 replies.

How to convert iEnumerable into datatable made by @divya.17290 with 10 replies.

Is it possible deserialize json from excel made by @divya.17290 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Palaniyappan made 12 posts!

@divya.17290 made 12 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 1 likes!

Selectors issue on item

Hi You can try with Regex selector Here in your selector mention instead of idx attribute mention like this Idx=‘(11|12)’ matching:idx=‘regex’ Refer this doc for more details https://docs.uipath.com/studio/standalone/2023.10/user-guide/regex-search Cheers @vineelag

This post made by @Madhu_Maurya received 1 likes!

Captcha2

[image] [image] hello all, see in first image actually i am trying to scrap name and then click refresh and from the next page again ,I want to scrap name but in between captcha come(see in second image) so how to deal with captcha and go next page and scrap again name, plz guide me

This post made by @raven received 1 likes!

Desktop outlook app error

“Use Desktop Outlook App” activity and inside “Send Email” activity. When “Save as draft” is checked no account is selected in Outlook (it just states “Outlook” and manually I have to select the account). When “Save as draft” is not selected I get the error System.Runtime.InteropServices.COMException. So for some reason the choosen account in the dropdown from “Use Desktop Outlook App” activity is not working. I have tried searching the Forum for solutions but nothing works. I do not understand …

Top 3 Most Liked Solutions

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

Difference bw studio and studio x

Hi @keerthi65a Welcome to community Check the above link

This solution provided by @Palaniyappan received 1 likes!

Replace multiples words in text file

Hi Use read text file activity and get the output as a string named Strinput Now use a assign activity like this Strinput = Strinput.ToString.Replace(“_Name”,”your new word”).Replace(“TicketNumber”, “your new number”) If you want to make it dynamic u can place a placeholder in those places in the text file Refer this for more idea on that Cheers @Kumar_Sahu_Sameer

This solution provided by @neha.upase received 1 likes!

String was not recognized as a valid DateTime like "45175"

Hi, You can use the following expression to convert an Excel date value (e.g., 45175) to a formatted date string: DateTime.FromOADate(CDbl(ngayhd)).ToString(“dd/MM/yyyy”) [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 | 17 September 2023

Top 3 Topics with Most Views

Regarding excel calculation made by @ramshiva_reddy with 37 views.

Need RegEx help please made by @chrystine.h with 34 views.

I cannot go beyond the For Each DataTable activity in the REF template made by @tolgademir with 33 views.

Top 3 Topics with Most Replies

Issue with Shift_F5 on As-400 Application? made by @Salman_Faries with 9 replies.

Downgrading Studio made by @J_Crosby with 6 replies.

I cannot go beyond the For Each DataTable activity in the REF template made by @tolgademir with 6 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 13 posts!

@Anil_G made 13 posts!

@ppr made 8 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 3 likes!

Need RegEx help please

Hi There is a knowledge base in UiPath forum on all functionalities of datatable Have a view on this for more insights For your scenario This is with normal IsNullOrEmpty method dt1 = dt1.AsEnumerable().Where(Function(a) NOT String.IsNullOrEmpty(a(“Email”).ToString.Trim) ).CopyToDatatable() If you want to remove with the Regex dt1 = dt1.AsEnumerable().Where(Function(a) NOT System.Text.RegularExpressions.Regex.IsMatch(a(“Email”).ToString.Trim, “[\W|\w]").CopyToDatatable() Hope this helps …

This post made by @Chirag12 received 2 likes!

Monthly Forum Rewards - August 2023

Thank you @Anil_G and @Vikas_M , You both have been helping me a lot lately Well deserved!

This post made by @Sudarshana_Sharma_P received 2 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

Awesome. I like all the smiley’s. Good effort to enhance the conversations

Top 3 Most Liked Solutions

This solution provided by @neha.upase received 1 likes!

Need RegEx help please

Use an “Assign” activity to create a new data table that contains only the rows you want to keep. Let’s call this new data table filteredDt. In the “Value” field of the “Assign” activity, use LINQ to filter the rows of dt1 based on the condition that the “Email” column is not null or whitespace. You can use the Where method with a lambda expression to achieve this. Here’s the code for the “Value” field: filteredDt = dt1.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Emai…

This solution provided by @Anil_G received 1 likes!

If activity - Message Box not popping up after user input

@OGunnarsson Welcome to the community The problem is your while condition The if condition is not placed inside the while loop…so the while loop will end only when you give the correct answer…hence the if condition is executing only correct one… Try to move your if condition into the while loop then for each loop or guess you will get the message pop up as needed 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 | 18 September 2023

Top 3 Topics with Most Views

Get form tasks activity made by @Aditi_Jha with 45 views.

Uipath use regex to extract first string from each line made by @voxter with 37 views.

Downloading file from a website made by @Priyesh_Shetty with 36 views.

Top 3 Topics with Most Replies

Get form tasks activity made by @Aditi_Jha with 28 replies.

Downloading file from a website made by @Priyesh_Shetty with 15 replies.

Select Item activity won't work made by @Anelisa_Bolosha1 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 47 posts!

@Palaniyappan made 35 posts!

@ppr made 34 posts!

Top 3 Most Liked Posts

This post made by @firas received 2 likes!

Prompting for credintials while running a Query inside Excel

Thank you @Roman-Routinuum , @Palaniyappan and @Anil_G I will review those great suggestion and see which one will better work on my project I really appreciate your prompt assistance!

This post made by @mRob received 2 likes!

User rights - Read only access to Triggers & Logs

Thanks for the answers, il give those a go !

This post made by @Nguyen_Van_Luong1 received 1 likes!

Exciting News: Introducing New Improvements to our UiPath Community Forum Platform!

Awesome @loredana_ifrim I like UiPath emoji search bar and similar topic help me find solution faster to help your self and other developer Thanks !

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

AWS server instance

Though haven’t tried I have seen my infra team working on this it is possible to install 4 copies of UiPath on an AWS server instance with 4 user profiles. Each user profile will have its own copy of UiPath installed. Create 4 user profiles on the AWS server instance. Connect to each user profile using a remote desktop connection. On each user profile, download and install UiPath. Configure UiPath on each user profile. Once you have completed these steps, you will have 4 copies of UiPath in…

This solution provided by @Palaniyappan received 1 likes!

How open PDF file

Fine then Developer option is not enabled I believe In use application activity mention the filepath in this property Arguments - If the application is not a web browser, you can specify parameters to pass to the target application at startup. You can use this property to open a specific file with the application. For example, if the target application is Acrobat Reader, you can open a specific workbook by providing the full path to the file. To open the file C:\Sample.pdf, enter "C:\Sample.p…

This solution provided by @Anil_G received 1 likes!

User rights - Read only access to Triggers & Logs

@mRob Welcome to the community Please create roles that you need as per the access you need. Always its better to create the roles as you need…specifically you need view on logs and triggers…which can be created…the predefined roles are some basic ones which will help you understand how to bifurcate [image] [image] 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.