Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 April 2023

Top 3 Topics with Most Views

Too much time taken for a loop made by @Paddi with 60 views.

How to check text in the same line to identify to edit data in correct row? made by @kidssana.ch with 51 views.

Saving Attachments using Get outlook mail message activity is not working made by @Haarish_S with 47 views.

Top 3 Topics with Most Replies

Saving Attachments using Get outlook mail message activity is not working made by @Haarish_S with 21 replies.

Replace string in multiple files in powershell made by @Navya_Budagam with 20 replies.

Finding an item in the queue item array made by @redanime94 with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 61 posts!

@Palaniyappan made 47 posts!

@vishal.kp made 26 posts!

Top 3 Most Liked Posts

This post made by @ruchirmahajan received 3 likes!

Studio Web in Public Preview - 5 things you should know and 9 demos you should see

This can be game changer. The fact that there’s no need for machine setup and installation makes it more accessible and user-friendly than ever before.

This post made by @Manoj_Batra received 3 likes!

Studio Web in Public Preview - 5 things you should know and 9 demos you should see

Thanks @mircea for sharing this. This will definitely disrupt the Low-Code/No-Code market and give the automation users more power to automate their process along with super impressive integration services

This post made by @harmeet.singh1 received 2 likes!

Allianz Partners - RPA Developer - Noida - India - Full Time

Job title: RPA Developer Job role: RPA Developer Country: India City: Noida Company name: Allianz Partners Employment Type: Full Time Seniority level: Associate 3 to 5 years Job Description: Job Details • Build, design, develop and implement RPA systems. • Use of UiPath RPA tool to set up, analyze and automate processes. Key Responsibilities • Analyze the process and suggest whether the process is a good candidate or not for automation. • Designing automation processes as per the op…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

System.Activities.ValidationException

Hi did this help u to resolve this Would recommend to have a view on this [UiPath Error Message#1 An extension of type 'UiPath.Activities.Contracts.Persistence..IPersistence..] Cheers @arjunshenoy

This solution provided by @Anil_G received 1 likes!

Virtual Machine Robot (Monitor issue)

@Laimis Welcome to the community First while bot is running if you close it will stop…while running you should not close…you can signout before start so that bot logs in For bot to run in unattended you need service mode installation and unattended license … https://docs.uipath.com/robot/docs/robot-service Also for running in minimized check this https://docs.uipath.com/robot/docs/executing-tasks-in-a-minimized-rdp-window Cheers

This solution provided by @Manju_Reddy_Kanughula received 1 likes!

Debugging starts in PiP

@VanjaV Disable “Picture in Picture” in the debug ribbon. [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 | 27 April 2023

Top 3 Topics with Most Views

Spinning wheel made by @A_Learner with 54 views.

How to set the download path? made by @Vrishchik with 47 views.

Unattended bot schedule in orchestrator made by @shyamala_shyamu with 47 views.

Top 3 Topics with Most Replies

Highlighting a specific text with any color made by @Priyesh_Shetty1 with 28 replies.

Unattended bot schedule in orchestrator made by @shyamala_shyamu with 17 replies.

String manuplation in data table made by @RACHEL_PAUL with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 90 posts!

@vishal.kp made 30 posts!

@Manju_Reddy_Kanughula made 28 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How to set the download path?

Hey @Vrishchik , Give a try to this Environment.GetFolderPath(Environment.SpecialFolder.UserProfile)+"\Downloads" Regards,

This post made by @Manju_Reddy_Kanughula received 2 likes!

How to set the download path?

@Vrishchik In the chrome you can set it up [image] Or else try with this expression for dynamic Environment.GetFolderPath(Environment.SpecialFolder.UserProfile)+"\Downloads"

This post made by @RACHEL_PAUL received 2 likes!

String manuplation in data table

This worked. Thank you vishal and jitesh.

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How to set the download path?

Hey @Vrishchik , Give a try to this Environment.GetFolderPath(Environment.SpecialFolder.UserProfile)+"\Downloads" Regards,

This solution provided by @Anil_G received 1 likes!

Replace string in multiple files in powershell

@Navya_Budagam My Bad…I have modified the old one…please check this $directory = "C:\Users\Desktop\powershell" $searchpattern = "*.*" $oldstring1 = 'runAs="India"' $newstring1 = 'runAs="America"' $oldstring2 = 'runAsGuid="India"' $newstring2 = 'runAsGuid="America"' $modifiedfiles = @() Get-ChildItem -LiteralPath $directory -Include $searchpattern -Exclude *.atr -Recurse | ForEach-Object { if($_.GetType().Name -eq "FileInfo") { $content = Get-Content -LiteralPath $_.FullName …

This solution provided by @kumar.varun2 received 1 likes!

How to store the string value like as column wise in excel

Hi @Anbumani Try this approach StoreStrinValueAsColumns.xaml (8.0 KB)

---

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

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

[system]

Daily Forum Report | 28 April 2023

Top 3 Topics with Most Views

I want to read specific text from pdf . How should I read it made by @Bhushan_Nagaonkar with 63 views.

How to replace alternate value of Dictionary from the List made by @siddhi.rani with 50 views.

Change Name of Environment made by @Volker_Hofheinz1 with 47 views.

Top 3 Topics with Most Replies

I want to read specific text from pdf . How should I read it made by @Bhushan_Nagaonkar with 22 replies.

Count data rows including the NextLinkSelector made by @ANGE with 14 replies.

Getting the value of a particular column from datatable without using for each row made by @Kunal_Jain with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 53 posts!

@Yoichi made 28 posts!

@supermanPunch made 21 posts!

Top 3 Most Liked Posts

This post made by @vishal.kp received 2 likes!

Remove duplicates in excel using time

Hi @Praveen_Vs , -Keep preserve formatting true while reading the Excel Try the following: (From row In dt.AsEnumerable() Group By policy = row("Policy").ToString() Into policyGroup = Group Let latestEntry = policyGroup.OrderByDescending(Function(r) DateTime.Parse(r("Time").ToString())).FirstOrDefault() Select latestEntry).OrderBy(Function(r) DateTime.Parse(r("Time").ToString())).CopyToDataTable() Regards,

This post made by @Jithesh_R received 2 likes!

Remove duplicates in excel using time

Hey @Praveen_Vs , To do this you can follow these steps. 1.Initially Read your Input Using "Read range workbook " activity 2. Sort the input datatable in descending order (Using “Time” Column) 3. Now all the recent timings will come first . 4. Then you can group the data By taking the first value(That is ignoring the duplicate values) Please find the attached workflow RemoveDuplicateUsingTime.zip (1.7 KB) Output: [image] Regards,

This post made by @balupad14 received 2 likes!

Unable to install Bala Reva easy excel packages

Hi All, Now you have a new version 23.0.0. It is compatibility with windows legacy and windows. Thank you Balamurugan.S

Top 3 Most Liked Solutions

This solution provided by @vishal.kp received 2 likes!

Remove duplicates in excel using time

Hi @Praveen_Vs , -Keep preserve formatting true while reading the Excel Try the following: (From row In dt.AsEnumerable() Group By policy = row("Policy").ToString() Into policyGroup = Group Let latestEntry = policyGroup.OrderByDescending(Function(r) DateTime.Parse(r("Time").ToString())).FirstOrDefault() Select latestEntry).OrderBy(Function(r) DateTime.Parse(r("Time").ToString())).CopyToDataTable() Regards,

This solution provided by @Jithesh_R received 2 likes!

Preencher um dataTable atraves de uma string com valores separados por virgulas

@devrpa746 , Please check this workflow StringTest.zip (2.1 KB) Output : [image] Regards,

This solution provided by @supermanPunch received 2 likes!

I want to read specific text from pdf . How should I read it

Hi @Bhushan_Nagaonkar , We will not be able to provide a proper regex if the Sample data format is not provided, However check the below regex : (?<=social security number.*\s*)[\d-]+ [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 | 29 April 2023

Top 3 Topics with Most Views

Windows to cross-platform framework conversion made by @jack.chan with 38 views.

Error 1706. An installation package for the product UiPath Studio cannot be found made by @Suastrian_Dika with 36 views.

tableRow property not showing in button - Video Demo made by @dorellana with 36 views.

Top 3 Topics with Most Replies

Issue with 2023.4.0: Unable to run code on robot machine: "Could not load file or assembly 'UiPath.System.Activities, Version=23.4.2.0" made by @oscar with 16 replies.

How to Copy link address and store it into the Excel Sheet made by @Muhammad_Anas_Baloch with 12 replies.

正規表現ビルダーでTrue判定された文字列が処理ではFalse判定される made by @sa197853 with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 51 posts!

@r0818 made 10 posts!

@Nitya1 made 10 posts!

Top 3 Most Liked Posts

This post made by @Muhammad_Anas_Baloch received 2 likes!

Condition in an If statement is not returning the correct output

The solution is Series_Label was getting the whole text from the string at once instead of one by one I just changed the For Each Ui Element to extract table and it works for me. Thank you all for your time.

This post made by @supermanPunch received 2 likes!

How to try to extract the first 2 digits from a string?

@lean0919 , The Regex Pattern can be adjusted to \d{2} as already provided above. Regex.Match("The date 10112023 today","\d{2}").Value.Trim [image] Without the Group too, we should be able to fetch it.

This post made by @AndresMDU received 2 likes!

Wich activity could find a message box as a result of a macro

Thank you very much @uKisuke and @Anil_G. Indeed, i am new in UiPath and i am using old activities that i have watched in tutorials, I will try the modern activities and come back with a feedback.

Top 3 Most Liked Solutions

This solution provided by @Muhammad_Anas_Baloch received 2 likes!

Condition in an If statement is not returning the correct output

The solution is Series_Label was getting the whole text from the string at once instead of one by one I just changed the For Each Ui Element to extract table and it works for me. Thank you all for your time.

This solution provided by @arjunshenoy received 1 likes!

How to try to extract the first 2 digits from a string?

Hi @lean0919 You can use the following RegEx pattern to extract the date part from the given string: \b\d{2}\b [image] Syntax: System.Text.RegularExpressions.Regex.Match(yourString,"\b\d{2}\b").Value Hope this helps, Best Regards.

This solution provided by @Anil_G received 1 likes!

How to Copy link address and store it into the Excel Sheet

@Muhammad_Anas_Baloch You can try using table extraction(Data Scrapping) it would extract urls as well 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 | 30 April 2023

Top 3 Topics with Most Views

On-Premises UiPath Infrastructure - Creating a Dev Environment made by @Joel_Medeiros with 213 views.

VB.NET code with class made by @Mohit_Sagar1 with 38 views.

Integration service made by @A_Learner with 36 views.

Top 3 Topics with Most Replies

Get table row number value from datatable made by @Sathish_Kumar_S with 17 replies.

How to extract data from standard after using pdf to text activity made by @rajat.jain with 10 replies.

Excel Activities First row of each element question made by @kawtar.ettayarssouti with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@Bhushan_Nagaonkar made 16 posts!

@supermanPunch made 15 posts!

Top 3 Most Liked Posts

This post made by @Joel_Medeiros received 9 likes!

On-Premises UiPath Infrastructure - Creating a Dev Environment

Creating a separate development environment for UiPath can offer several advantages, including: Isolation: By creating a separate development environment for UiPath, you can isolate the development work from the testing and production environments, ensuring that any changes or updates made during development won’t impact the stability or performance of the production environment. Besides, the data isolation plays a vital role since bots can deal with sensitive data. Therefore, having separate…

This post made by @Anil_G received 2 likes!

Create/update Boolean asset using Orchestrator API

@Pinky_AG Value is missing in the payload…please try with this …it is working as expected { "Name": "testbool2", "CanBeDeleted": true, "ValueScope": "Global", "ValueType": "Bool", "Value": "true", "BoolValue": true } Cheers

This post made by @earldantedumayag received 2 likes!

Workflow runs smoothly when ran in itself. However, it encounters an error when ran via 'Invoke Workflow File'

So it does seem that it’s due to the unmatched package versions of my workflow and the one that invokes this. After alignment and adjustments, all went well. Thanks @Nitya1 and @Anil_G for the guidance!

Top 3 Most Liked Solutions

This solution provided by @earldantedumayag received 2 likes!

Workflow runs smoothly when ran in itself. However, it encounters an error when ran via 'Invoke Workflow File'

So it does seem that it’s due to the unmatched package versions of my workflow and the one that invokes this. After alignment and adjustments, all went well. Thanks @Nitya1 and @Anil_G for the guidance!

This solution provided by @vishal.kp received 1 likes!

I want to read specific text from pdf . How should I read it

Hi @Bhushan_Nagaonkar , Try this, using a for each loop you can get all the social security number matched: System.Text.RegularExpressions.Regex.Matches(InputText,"(\d{3}-\d{2}-\d{4})").Item(0).Groups(1) [image] Regards,

This solution provided by @LAKSHMI_NARAYANA_PEMMASAN received 1 likes!

ExcelからExcelへの転記を繰り返し行う方法

can you check copy/paste range activity if the requirement is for all sheet data to be transferred if you want to do on specific cell by validations then use for each row activity of excel this will iterate through all the rows of excel so by currentrow property is available any how if you clarify on the exact requirement somebody can provide you a proper solution Regards

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

@Jithesh_R received 77 likes for their solutions!

@Anil_G received 73 likes for their solutions!

@Yoichi received 57 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 May 2023

Top 3 Topics with Most Views

Chatgpt Api made by @federico.apfelbaum with 44 views.

How to compare and match string arrays? made by @dla0313 with 39 views.

Replace comma with dot made by @Kuldeep_Pandey with 38 views.

Top 3 Topics with Most Replies

How to handle the try cath exception:No open windows found。 made by @jackie.yue with 19 replies.

繰り返し処理 Webサイトの追加したテーブルにデータを出力する方法 made by @kai.kato with 15 replies.

How to compare and match string arrays? made by @dla0313 with 13 replies.

Top 3 Users Who Posted The Most

@Yoichi made 29 posts!

@Anil_G made 22 posts!

@kai.kato made 10 posts!

Top 3 Most Liked Posts

This post made by @Joel_Medeiros received 1 likes!

On-Premises UiPath Infrastructure - Creating a Dev Environment

Hi @A_Learner , Well, in that case you would need a multi-node design with High Availability Add-on. This would guarantee that the Orchestrator APP is always up. But please, don’t forget your SQL Server. If you have a single node SQL Server, your orchestrator can goes down if the DB crashes. For a more reliable environment, you would also add a SQL Cluster if at least 2 nodes. But all these items add up on your bill, so you really need to think about it and know how much you want/can spend. I …

This post made by @Jeroen_van_Loon received 1 likes!

UiPath Community 2023.4 Stable Release - various Activities

The ‘hide else’ option has been available since 21.10 I think, when they were still next to eachother. tbh I prefere the side by side over the top to bottom approach for if-then-else. I like to think of it as a crossroads where I decide to go left or right. I see both exits in one overview. If they are beneath eachother all I see is left. And after all the code for left is exhausted, right becomes visible. I am aware that with proper coding, smaller sequences and collapsable containers…

This post made by @oscar received 1 likes!

Issue with 2023.4.0: Unable to run code on robot machine: "Could not load file or assembly 'UiPath.System.Activities, Version=23.4.2.0"

Thanks guys for the responses. I made a discovery which you might find interesting! I deleted the latest version of Studio (23.4.0) and installed 22.10.7. I made no changes to the project and published it again to Orchestrator. Now the package works just fine, and it runs perfectly on my development PC as well as my Robot PC. The only thing that changed was my version of UiPath Studio. 23.4.0 does not work when publishing the package. But 22.10.7 does work. So there is definitely something…

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

How to use Extract Table for the extraction of few columns

Hi @Muhammad_Anas_Baloch in the extract table activity, in each column exist a trash icon, near to the settings icon, just click on it and it will delete the column [image] Regards!

This solution provided by @Yoichi received 1 likes!

How to compare and match string arrays?

Hi, Do you need to convert to each other? If so, can you try the following? dict = ExtractDataTable.AsEnumerable.Skip(1).GroupBy(Function(r) r(2).ToString).ToDictionary(Function(g) g.Key,Function(g) g.First().Item(0).ToString) dict2 = ExtractDataTable.AsEnumerable.Skip(1).GroupBy(Function(r) r(0).ToString).ToDictionary(Function(g) g.Key,Function(g) g.First().Item(2).ToString) Then String.Join(" ",yourAddress.Split({" "c}).Select(Function(s) if(dict.ContainsKey(s.ToUpper.TrimEnd("."c)), dict…

This solution provided by @Sanjit_Pal received 1 likes!

Can i see logs in orchestrator?

Yes, you can see the logs in the orchestrator.

---

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

Top 3 Topics with Most Views

Split the text made by @Demo_User with 54 views.

How to get latest download files made by @Suraj_Gaikwad_Nuvama_Grou with 44 views.

How to get over all count of a queue items? made by @Vrishchik with 44 views.

Top 3 Topics with Most Replies

Split the text made by @Demo_User with 22 replies.

How to read ExtractedData in inverse made by @Muhammad_Anas_Baloch with 15 replies.

Two level subfolders help made by @Ricchch with 13 replies.

Top 3 Users Who Posted The Most

@Yoichi made 33 posts!

@Anil_G made 33 posts!

@Srini84 made 27 posts!

Top 3 Most Liked Posts

This post made by @dla0313 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

Thanks, yes I increased the timeout to 60 seconds and its working now.

This post made by @Srini84 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

@dla0313 You better increase the timeout of the Execute Query activity and see As the default activity timeout is 30 seconds and if the Query is taking more time then you can see this type of errors You can place some delays as well if this is still not working Hope this may help you Thanks, Srini

This post made by @vishal.kp received 2 likes!

Compare a list of mails, using subjects with list of subjects stored in list of string

Hi @Karan_Zaveri , Try this: listMailMessage.AsEnumerable().Where(Function(mail) listSubjects.Any(Function(x) mail.Subject.ToString.ToLower.Trim.Contains(x.ToString.ToLower))).ToList Regards,

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

@dla0313 You better increase the timeout of the Execute Query activity and see As the default activity timeout is 30 seconds and if the Query is taking more time then you can see this type of errors You can place some delays as well if this is still not working Hope this may help you Thanks, Srini

This solution provided by @vishal.kp received 2 likes!

Compare a list of mails, using subjects with list of subjects stored in list of string

Hi @Karan_Zaveri , Try this: listMailMessage.AsEnumerable().Where(Function(mail) listSubjects.Any(Function(x) mail.Subject.ToString.ToLower.Trim.Contains(x.ToString.ToLower))).ToList Regards,

This solution provided by @Srini84 received 1 likes!

How to remove empty row in excel for some specific columns

@sathish_Kumar6 You can use Filter Datatable activity and mention your column for example F->“campaign” and put is not empty Then you will get all the values wth the campaign which is not empty Now use Read Range activity to write it back to a new excel Hope this may help you Thanks, Srini

---

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

Top 3 Topics with Most Views

How can I add two numbers and add those two numbers before enter into captcha? made by @Samraat_Maharjan1 with 56 views.

Not getting the desired values made by @ajindal with 54 views.

Need to check if a IEnumerable argument has any value stored and return is as a bool made by @goncalo.rocha with 50 views.

Top 3 Topics with Most Replies

How can I add two numbers and add those two numbers before enter into captcha? made by @Samraat_Maharjan1 with 29 replies.

UiPath studio is not installing made by @Learner007 with 24 replies.

Error in GetIMAP Activity made by @ashwini.mali with 22 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@supermanPunch made 22 posts!

@arjunshenoy made 16 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How to get data from web without using scrapping

Hey @Suraj_Gaikwad_Nuvama_Grou , Please check this wokflow .Iam able to get the output using find children and Get attribute. Main.zip (4.6 KB) Output: [image]

This post made by @arjunshenoy received 2 likes!

How to get data from web without using scrapping

@Suraj_Gaikwad_Nuvama_Grou As I already mentioned, it is possible to extract the data from the visible page using Find Children & Get Attribute. You can refer to the workflow @Jithesh_R just shared using the same concept. But, your data is spanning across 50 pages & you might have to implement a click activity or something similar to change the page every time before the find children get executed. Best Regards.

This post made by @V_Vasanth_Kumar received 2 likes!

How to copy data to text file by checking if column having specific value after data scraping?

hi @vnsatyasunil Please refer the below flow, [image] [image] Regards, V Vasanth Kumar

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How to get data from web without using scrapping

Hey @Suraj_Gaikwad_Nuvama_Grou , Please check this wokflow .Iam able to get the output using find children and Get attribute. Main.zip (4.6 KB) Output: [image]

This solution provided by @Srini84 received 1 likes!

Can we deploy multiple bots from different accounts on the same server machine having different users?

@piyush.g Welcome to forums To my knoweldge it’s possible to setup in 5 different users in one windows Server Now, for installation, you can logging to Admin account and install for every User, this will install the setup file But you need to login manually to each user and you have configure the assistant to connect to Orchestrator Also, you need to have different licenses for each user Hope this may help you Thanks, Srini

This solution provided by @supermanPunch received 1 likes!

How to update the blank and Zero row in DT

@chandans , Could you try changing the Direction of in_CELL_Value_AF to In and check if you are able to resolve the issue. Also change the type to string as I believe it is a String type 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 | 04 May 2023

Top 3 Topics with Most Views

CLI for interacting with UiPath services made by @thschmitt with 64 views.

What are the reasons for choosing UiPath for RPA instead of using JavaScript or Python? made by @sagar.raval with 56 views.

Extract the multi row value in excel file made by @Le_Vo_Tien_Phat_KHCM with 53 views.

Top 3 Topics with Most Replies

Extract the multi row value in excel file made by @Le_Vo_Tien_Phat_KHCM with 12 replies.

Regex activity issue made by @BlueBird1 with 11 replies.

How to copy column data from excel and paste in a web browser in single line format made by @Naman_Arora with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 20 posts!

@Anil_G made 17 posts!

@vishal.kp made 13 posts!

Top 3 Most Liked Posts

This post made by @thschmitt received 6 likes!

CLI for interacting with UiPath services

Command Line Interface (CLI) for interacting with UiPath Services uipathcli provides a unified command line interface for accessing UiPath resources. You can use the CLI to execute commands from a terminal, either interactively or automated through scripts. The CLI makes it easy to get started using UiPath Service APIs and allows you to set up resources and automate small tasks. uipathcli works on all major platforms (Windows, Linux, MacOS) and architectures (x86/x64 and ARM). Getting Starte…

This post made by @vishal.kp received 2 likes!

How enter yesterday date example today is 04/05/2023 I have to enter 04/04/2023. What is the expression can we use?

Hi @Zuber_Shaikh , Datetime.Now.adddays(-1).tostring("dd/MM/yyyy") Regards,

This post made by @Umadevi_Sanjeevi received 2 likes!

How enter yesterday date example today is 04/05/2023 I have to enter 04/04/2023. What is the expression can we use?

Hi @Zuber_Shaikh , Can you confirm which value you have to enter. 04/04/2023 or 03/05/2023. Input = 04/05/2023 Get yesterday date Now.AddDays(-1).ToString("dd/MM/yyyy") Output is 03/05/2023 Get Last month yesterday date from the current date Now.AddMonths(-1).AddDays(-1).ToString("dd/MM/yyyy") Output: 03/04/2023 Thanks!

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

Linq query to remove a particular string from a particular column

Hi @taruna.mehra Give a try with the following [image] In the invoke code use this dtInput.AsEnumerable().ToList().ForEach(Sub(r) r("Column name -session Id")= r("Column name -session Id").ToString().Trim().Replace("#ADA#", String.Empty)) Make sure to replace the exact column name within the double quotes Regards!

This solution provided by @AmlanKiranPatel received 1 likes!

Published Automation Not Showing in Uipath Assistant

Hi @vishal.kp , It’s Solved. Actually, I was Publishing it to “Orchestrator Tenant Process Feed” Instead of “Orchestrator Personal WorkSpace Feed”.(Just a silly mistake that takes me 3Hr to Solve. Ha Ha )

This solution provided by @arjunshenoy received 1 likes!

Get value from a List of Dictionary based on a Key value

Hi @Himanshu_Punj You can use the following query: dictList.Where(Function(dict) dict("Age").ToString() = "25").Select(Function(dict) dict("Name").ToString()).FirstOrDefault() Hope this helps, Best Regards.

---

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

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

[system]

Daily Forum Report | 05 May 2023

Top 3 Topics with Most Views

How do i update different Excel Sheet tab base on the file name? made by @monicaong0609 with 57 views.

While extracting data through data scraping,column names are getting as data instead of column names made by @vnsatyasunil with 56 views.

DataTables activities made by @BlueBird1 with 46 views.

Top 3 Topics with Most Replies

While extracting data through data scraping,column names are getting as data instead of column names made by @vnsatyasunil with 13 replies.

Split com regras made by @devrpa746 with 11 replies.

Problem with SAP version migrating from version 750 to 760 made by @Juanjo_Fernandez with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 48 posts!

@vnsatyasunil made 12 posts!

@mkankatala made 11 posts!

Top 3 Most Liked Posts

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

How do I Install UiPath Robot in Service Mode or User Mode | UiPath Service Mode | UiPath User Mode

[How do I Install UiPath Robot in Service Mode or User Mode | UiPath Service Mode | UiPath User Mode]

This post made by @AlexGabriel97 received 2 likes!

SPLIT STRING DOUBT

You could use “.replace”. string.Replace(“:”,“”)

This post made by @PALKUMARI_PATEL received 1 likes!

How to get the file from sharepoint and drop the file on sharepoint?

Thanks @Anil_G For helping on the issue. Working absolutely fine.

Top 3 Most Liked Solutions

This solution provided by @AlexGabriel97 received 2 likes!

SPLIT STRING DOUBT

You could use “.replace”. string.Replace(“:”,“”)

This solution provided by @Anil_G received 1 likes!

Extract Year from a date

@renjutom Please try this Datetime.ParseExact("Jan 25","MMM yy",System.Globalization.CultureInfo.InvariantCulture).Year cheers

This solution provided by @Anil_G received 1 likes!

Insert/Delete row issue

@kawtar.ettayarssouti I guess the position start from 1…if you want to remove first teo then position is 1 and number of rows is 2 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 | 06 May 2023

Top 3 Topics with Most Views

Error for UiPath Apps: The UiPath Assistant is Required to Complete this action made by @RAKESH_KUMAR_BEHERA with 40 views.

HTTP Error 400. The size of the request headers is too long made by @everluo with 37 views.

Supports Persistence Missed made by @xiaotingyan98 with 35 views.

Top 3 Topics with Most Replies

How to read range with colors and do write range with colors made by @Gomathi_Ganesan with 12 replies.

Runtime Execution Error_application arguments Change made by @jackie.yue with 11 replies.

Schedule bot in 2 machine made by @logesh_kumar1 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 28 posts!

@jackie.yue made 8 posts!

@Gomathi_Ganesan made 7 posts!

Top 3 Most Liked Posts

This post made by @_pjflo received 1 likes!

How to do versioning of package

Thanks for explaining, @Anil_G! Greatly helped

This post made by @LAKSHMI_NARAYANA_PEMMASAN received 1 likes!

Buscar imagen y click en boton o continuar

if you are using Modern activities use Check App State [image] if image found then actions on target appears other wise on does not appear side Classic Use element exists activity which will give you boolen value (true or false ) [image] now use if activity with the result from above [image] Hope this helps Regards

This post made by @pruebaxx454 received 1 likes!

Buscar imagen y click en boton o continuar

Thank you very much

Top 3 Most Liked Solutions

This solution provided by @LAKSHMI_NARAYANA_PEMMASAN received 1 likes!

Buscar imagen y click en boton o continuar

if you are using Modern activities use Check App State [image] if image found then actions on target appears other wise on does not appear side Classic Use element exists activity which will give you boolen value (true or false ) [image] now use if activity with the result from above [image] Hope this helps 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 May 2023

Top 3 Topics with Most Views

How to install Abbyy OCR in UiPath the latest community version made by @Kakooza-Allan-Klaus with 41 views.

Resolution problems in unattended Mode made by @JoSom with 41 views.

Zipping the file will save the contents in the project folder itself and not getting saved in the given folder location. Why? made by @vignesh_S.M with 39 views.

Top 3 Topics with Most Replies

Zipping the file will save the contents in the project folder itself and not getting saved in the given folder location. Why? made by @vignesh_S.M with 15 replies.

Excelシート名の取得方法 made by @sayaka.y with 9 replies.

How to install Abbyy OCR in UiPath the latest community version made by @Kakooza-Allan-Klaus with 8 replies.

Top 3 Users Who Posted The Most

@Nitya1 made 20 posts!

@Anil_G made 18 posts!

@LAKSHMI_NARAYANA_PEMMASAN made 12 posts!

Top 3 Most Liked Posts

This post made by @Jon_Smith received 1 likes!

After updates cannot open any projects (..23.4.0.nupkg denied)

This is a poor fix. Don’t do it. The issue is due to some bug related to the new release, for some reason the packages in the install folder do not have the correct permissions. Go to that packages folder and set it and all the files into it to Full Control for all users. Your projects will open correctly again after that. There are other topics on this discussing this including one that has replies from a UiPath staff member who also shows how to do it via command line.

This post made by @vishal.kp received 1 likes!

Convert String datetime type

Hi @Radhika_Lohar1 , Cdate("05/15/2023") Regards,

This post made by @Radhika_Lohar1 received 1 likes!

Convert String datetime type

It worked! Thanks.

Top 3 Most Liked Solutions

This solution provided by @vishal.kp received 1 likes!

Convert String datetime type

Hi @Radhika_Lohar1 , Cdate("05/15/2023") Regards,

This solution provided by @Anil_G received 1 likes!

How to install Abbyy OCR in UiPath the latest community version

@Kakooza-Allan-Klaus This is just a warning not an error…windows legacy is being removed and also support for it is removed from april… And to use abby as of now UiPath does not support it [image] https://docs.uipath.com/activities/other/latest/user-guide/release-notes-uipath-abbyy-activities Cheers

This solution provided by @Jon_Smith received 1 likes!

Error While Debugging

Your problem is clear. Its your Get Temperature activity. You are trying to set the value (assign it) to an expression. In this case Temperature.ToString(). Temperature.ToString() is an expression. You need to change it to simply be Temperature.

---

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

Top 3 Topics with Most Views

LINQ to update columns in data table made by @besakkiappan46 with 66 views.

How to split any string with text as keyword made by @Swarit_Goyal1 with 58 views.

Data Base query to excel File made by @Jay_Chaudhary with 58 views.

Top 3 Topics with Most Replies

How to split any string with text as keyword made by @Swarit_Goyal1 with 23 replies.

Regular expression not working made by @neha.verma with 23 replies.

Data Base query to excel File made by @Jay_Chaudhary with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 34 posts!

@supermanPunch made 30 posts!

@Shubham_Kinge made 23 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 5 likes!

Monthly Forum rewards - April 2023

Congratulations to all the winners

This post made by @Anil_G received 3 likes!

Monthly Forum rewards - April 2023

Congratulations … Keep up the good work

This post made by @vishal.kp received 2 likes!

Monthly Forum rewards - April 2023

Congrats team

Top 3 Most Liked Solutions

This solution provided by @Nitya1 received 2 likes!

If activity with OR expression

Hi @rathi.sham Try this LINQ function to filter the array and return only the items that do not match those two values. Use an Assign activity to create a new filtered array:- filteredArray = myarray.Where(Function(fruit) Not fruit.Equals(“Kiwi”) AndAlso Not fruit.Equals(“Plum”)).ToArray() Use an If activity to check if the original array contains “Kiwi” or “Plum”: myarray.Intersect({“Kiwi”, “Plum”}).Any() This expression returns True if the original array contains any of the values …

This solution provided by @arjunshenoy received 2 likes!

LINQ to update columns in data table

Hi @besakkiappan46, welcome to the Community. Please use the following query in the Invoke Code activity: C#: { yourDt.AsEnumerable.ToList.ForEach(row => { row("TIN") = System.Text.RegularExpressions.Regex.Match(row("TIN").ToString().Trim(), @"(\d{3})(\d{2})(\d{3})").Groups[1].ToString() + "-" + System.Text.RegularExpressions.Regex.Match(row("TIN").ToString().Trim(), @"(\d{3})(\d{2})(\d{3})").Groups[2].ToString() + "-" + System.Text.RegularExpressions.Regex.Match(row("TIN").To…

This solution provided by @Shubham_Kinge received 1 likes!

Help with activity Save as Excel fil

Hello @Ricchch Here you can do, dont provide hardcoded path. provide folder to store the file. then use for each file in folder which contains *.csv,*xls different condition. and then provide that file path to use file activity using currentfile. Hope this 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 | 09 May 2023

Top 3 Topics with Most Views

I want to use right cell activity using counter mechanism made by @Bhushan_Nagaonkar with 59 views.

Unable extract the all the rows from web data table made by @rchin with 53 views.

Missing Excel Pross Scope made by @TOOKT with 47 views.

Top 3 Topics with Most Replies

I want to use right cell activity using counter mechanism made by @Bhushan_Nagaonkar with 23 replies.

Regex Doubt1 made by @RpaUi02 with 23 replies.

How to grouping excel data to send to API made by @Raja.G with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Srini84 made 35 posts!

@supermanPunch made 20 posts!

Top 3 Most Liked Posts

This post made by @Raluca_Ilie received 3 likes!

Rate UiPath on G2 and Get Rewarded

Until May 15th, you can review UiPath on G2 and get rewarded with a 25$ Visa Gift Card. IMPORTANT: If your review will be approved, you will receive the gift card directly from the G2 team as a Thank You for contributing with a detailed, balanced, complete review The UiPath team is not involved in the G2 approval process for your reviews or issuing the gift cards. Please be sure to use your LinkedIn or your business email for validation. This is required by G2 to help verify your experience …

This post made by @Yoichi received 3 likes!

How can i remove this anoying message?

Hi, FYI, if you can upgrade UiPath to 23.4, the following message will be shown and we can choose “Don’t show again” [image] Regards,

This post made by @Jithesh_R received 2 likes!

Monthly Forum rewards - April 2023

Congratulations All

Top 3 Most Liked Solutions

This solution provided by @Mohammad_Irfan received 1 likes!

End of expression expected while using linq in assign

@Karthik23 write the condition in the same line

This solution provided by @supermanPunch received 1 likes!

How to select a sheet of an excel based on regex pattern

Hi @Karthik23 , From the given statements, we can understand that the word mapping appears in both sheetnames and it is in the beginning. But do we need to have a Regex ? We could also go with StartsWith. YourWbSheets.Where(Function(x)x.ToLower.StartsWith("mapping")).FirstOrDefault Do you maybe have some other sheetnames or examples where you believe regex would be more benficial ?

This solution provided by @arjunshenoy received 1 likes!

I want to save the file dynamically

Hi @Shubham_Kinge By the usage of relative path & datetime properties, you can make the file be saved dynamically by the combination of these methods: → currentDirectory = Environment.CurrentDirectory → relativePath = "Data\Output" → fileName = "yourFileName_"+Now.ToString("dd_MM_yyyy")+".yourFileExtension" → savingLocation = Path.Combine(currentDirectory, relativePath, fileName) Hope this helps, Best 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 | 10 May 2023

Top 3 Topics with Most Views

製品ドキュメントの人間翻訳版公開のお知らせ (2023 年 5 月 4 日更新確認分) made by @Naoko_Sato with 70 views.

How to convert date format from dd-mm-yyyy to MM-dd-yyyy in excel made by @sathish_Kumar6 with 48 views.

You can now use the UiPath CI/CD Pipelines made by @alexandru.iordan with 47 views.

Top 3 Topics with Most Replies

Published package not visible on UiPath assistant made by @neha.verma with 32 replies.

Write in excel sheet made by @ajindal with 21 replies.

Date format problem made by @BlueBird1 with 17 replies.

Top 3 Users Who Posted The Most

@Srini84 made 49 posts!

@neha.verma made 33 posts!

@Anil_G made 32 posts!

Top 3 Most Liked Posts

This post made by @Naoko_Sato received 4 likes!

製品ドキュメントの人間翻訳版公開のお知らせ (2023 年 5 月 4 日更新確認分)

以下のユーザー ガイドの人間翻訳版が公開されました。(2023 年 5 月 4 日更新確認分) UiPath 概要ガイド

This post made by @pavithra_pavi received 3 likes!

UiPath - Download Attachments From .Msg File | VbScript

I’m back with one more interesting topic. the topic covers handshake between #UiPath and #vbscript . Have you ever wondered how to download attachments from .Msg files.? . Check out my latest video on “How to download attachments from .MSG files” [UiPath - Download Attachments From .Msg File | VbScript]

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

You can now use the UiPath CI/CD Pipelines

Automation Ops - Pipelines is now in Public Preview You can now use the UiPath CI/CD engine to automate your automations. Given you have the automation source code under source control (currently GitHub), you can set up CI/CD pipelines (as simple as building an UiPath project) to streamline your development process. Imagine the following scenario: Automation is developed in a Development environment and needs to meet certain quality checks before reaching the Production environment. The q…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

トリガースコープを複数同時に使用したい

こんにちは 例えばクリックトリガーを２つ並べて、Actionのセクションで、args.TriggerName の内容に応じて処理を振り分ければ良いかと思います。 [image]

This solution provided by @Harshith_Adyanthaya received 1 likes!

How to get values from Get Transaction Item

@mohamedalthaf Try this. Test1_Que.SpecificContent.GetValueOrDefault(“Name”).ToString Hope it helps.

This solution provided by @ppr received 1 likes!

How to get numbers before % in string using Reg Ex

regex simple: [grafik] Anchored [grafik] Assign Activity: myDouble = CDbl(System.Text.RegularExprressions.Regex.Match(strText, strPattern).Value.Trim)

---

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

Top 3 Topics with Most Views

Filter Date column from data table made by @sneha_arbole with 48 views.

IF Object Reference not set to an instance of an object made by @jokakeekian with 46 views.

Machine unavailable made by @SA64 with 46 views.

Top 3 Topics with Most Replies

Uipath file is unable to open.. Whats the reason for this made by @Bhushan_Nagaonkar with 19 replies.

Index was outside the bounds of the array using string variables made by @guilherme_melato with 17 replies.

IF Object Reference not set to an instance of an object made by @jokakeekian with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 80 posts!

@mkankatala made 30 posts!

@arjunshenoy made 24 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

Modern click activity is not supporting in out of open browser why?

No you don’t. You should leave the application open (don’t set Use App/Browser to close it), output the app object to a variable, and use that variable as the input for another Use App/Browser in the process state. By the way, it sounds like you’re using REFramework. I recommend you don’t. It’s not for beginners. Have you taken the free training on the UiPath Academy web site?

This post made by @Anil_G received 2 likes!

Read file .msg

@andreus91 Please check this for detailed step by step guide Cheers

This post made by @Yoichi received 1 likes!

Unable to use Exchange mail activity in Windows compatability

Hi, Can you try UseOutlook365 which is included in Mail activities package? Its activities name is exchange-application-card and is designed for exchange online. https://docs.uipath.com/activities/other/latest/user-guide/exchange-application-card Regards,

Top 3 Most Liked Solutions

This solution provided by @pavithra_pavi received 1 likes!

Unable to use Exchange mail activity in Windows compatability

Here you go with screenshot [image] [image]

This solution provided by @Yoichi received 1 likes!

How to generate 25 rand numbers between 50 5000

HI, Hope the following helps you. rnd = New Random() arrRndNumber = Enumerable.Range(0,25).Select(Function(i) rnd.Next(50,5001)).ToArray() Then Sum of even numbers arrRndNumber.Where(Function(i) i mod 2 =0).Sum() Sum of odd numbers arrRndNumber.Where(Function(i) i mod 2 <>0).Sum() [image] Regards,

This solution provided by @natanael.mendes received 1 likes!

Write Cell in Google Spreadsheet for each row

This is happening because you are referencing only the column, currentrow.tostring will not bring a number. You need to put a counter to be able to increment the data insertion for each line. Counter=Counter+1 and put “B”+Counter.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 | 12 May 2023

Top 3 Topics with Most Views

Multiple AND Conditions made by @dutta.marina with 71 views.

Cannot modify the data type in Foreach activity made by @vishnugopal with 55 views.

Can you please help me with a project? made by @Suthari_RohithReddy with 53 views.

Top 3 Topics with Most Replies

Multiple AND Conditions made by @dutta.marina with 18 replies.

How to scrape zip code from address made by @Bot_Learner with 15 replies.

Cannot modify the data type in Foreach activity made by @vishnugopal with 13 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 29 posts!

@adiijaiin made 24 posts!

@Yoichi made 20 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 3 likes!

Read-Subject-And-Body-FromMsgFile

Im back with another video (extended session of fetching details from MSG files). In this video, i have explained how to Read Email Subject, address, body from MSG file. Check out the link below [Read-Subject-And-Body-FromMsgFile]

This post made by @Kirti_Lohokare received 2 likes!

Is it possible to create form task in foreach loop and then let user approve or reject in action center

Hi the issue has been resolved. I have converted data table into the array . Now looping through array. Meanwhile i have downgraded my packages versions. It is working fine

This post made by @Charlie_Greenberg received 2 likes!

Dev Dives: Rapidly automate APIs and build custom connectors

The Integration Service product team is happy to invite all to our May 31st, Dev Dives presentation and demos. Most Integration Service demos begin with an amazing collection of accelerators, or the contents of the Connector Catalog. Here you’ll find approximately 60 prebuilt cross-industry connectors. All API-based connectors are immediately available to help automate workflows across applications such as Salesforce, SAP, Microsoft Office 365, ServiceNow and Adobe Document Services, to name j…

Top 3 Most Liked Solutions

This solution provided by @natanael.mendes received 1 likes!

Orchestrator Queue Page Error (#199 - No Language Found.)

You can try clearing your browser’s cache, it might work.

This solution provided by @pravupada received 1 likes!

Filter Date column from data table

Hello @sneha_arbole Try this, It may help. dt.AsEnumerable.Where(Function(r) CInt(CDate(r(“Date”).ToString).DayOfWeek)>2 AndAlso CDate(r(“Date”).ToString)>DateTime.Now.AddDays(-5) AndAlso CDate(r(“Date”).ToString)<= DateTime.Now ).ToArray.copytodatatable Thanks.

This solution provided by @pcman21 received 1 likes!

Invalid HTTP request to Wedos WAPI (request is empty)

Problem solved: I had to add “request=” before and then put the JSON. I also had to add header Content-Type: application/x-www-form-urlencoded header “request={”“request”“: {”“user”“: ““pcman21@seznam.cz””, ““auth””: ““202b62bc4646281f97d225db1249840c8452dd8f””, ““command””: ““domain-create””, ““clTRID””: ““a44B””, ““data””: {”“name”“: ““example.cz””, ““period””: 1, ““dns””: “””“, ““owner_c””: ““CONTACT””, ““admin_c””: ““CONTACT””}, ““test””: 1}}” Thank you for your help.

---

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

Top 3 Topics with Most Views

Try Catch Stucks Indefinitely made by @Axel_Albert with 74 views.

Need help with "how to click multiple checkboxes based on values in an array " made by @rathi.sham with 45 views.

How to add string data in data table made by @Aditya10989 with 42 views.

Top 3 Topics with Most Replies

Try Catch Stucks Indefinitely made by @Axel_Albert with 19 replies.

Need help with "how to click multiple checkboxes based on values in an array " made by @rathi.sham with 14 replies.

How to add string data in data table made by @Aditya10989 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@Nitya1 made 27 posts!

@Axel_Albert made 10 posts!

Top 3 Most Liked Posts

This post made by @Camila_Caldas received 2 likes!

Restrict data service entity access per folder

Thanks @Nitya1 I found a solution for what I need! Basically I want to segregate access based on entities and I realize that is possible to create a role and specify for which entity this role applies. Then you just need to assign this role to a specific user or group. I think this is a new possibility UiPath make available because last time I search for this was not there. [image]

This post made by @AndyMenon received 1 likes!

Dataservice units explanation

Hi @Camila_Caldas , It should be visible to you already. Login to Automation Cloud and: Click the Admin Icon on the left navigation bar Click the Licenses Tile on the right Click Robots & Services Tab And you should be able to see the DSU and the DSU limits. Here is a screen grab from the Automation Cloud CE. [image] I hope this helps. thanks

This post made by @AndyMenon received 1 likes!

Dataservice units explanation

I hope I have understood your question correctly. The DSU is a Service license. It can be used not just with automations but with Apps and APIs as well. If you want to know more, you can go to this page (I posted in my earlier response) and check the Services section on that page. You will see Units for all different types of Service Licenses. [image] thanks

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Dropdown Search and Select Asset Values In Orchrestrator

@private_matter You can create a UiPath app and give them instead of updating in assets that way…you can give a drop down as well In string type to give a value…there can be any value that we might want to type…restriction can be done in apps as needed for any asset you need Hope this helps Cheers

This solution provided by @Anil_G received 1 likes!

Try Catch Stucks Indefinitely

@Axel_Albert Yes mostly looks like…thats what I wanted to confirm if its stuck on sequence of throw… Glad that your issue is resolved 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 | 14 May 2023

Top 3 Topics with Most Views

Send attached files by mail problem made by @kawtar.ettayarssouti with 52 views.

Pasting X rows of data into SAP transaction made by @UI_SF with 38 views.

What is the fastest and stable solution for writing datatable to excel made by @mlellison with 38 views.

Top 3 Topics with Most Replies

Send attached files by mail problem made by @kawtar.ettayarssouti with 14 replies.

What is the fastest and stable solution for writing datatable to excel made by @mlellison with 10 replies.

Во вложении xlsx файл. Написать робота, который найдет в нем дублирующие строки, удалит одну из них, добавит строку «Итого» и запишет в ней сумму по оставшимся строкам made by @nikolajageev538 with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 14 posts!

@Nitya1 made 13 posts!

@kawtar.ettayarssouti made 9 posts!

Top 3 Most Liked Posts

This post made by @Ritaman_Baral received 1 likes!

Library

Who can upgrade a previously published library? When and where to use Global exception handler ? Please explain the concept also Can I use fuzzy selector on title name ? What are usage of different attributes of a selector such as idx,wbctrl etc. Please share any available link Thanks, Ritaman.

This post made by @rathi.sham received 1 likes!

Need help with "how to click multiple checkboxes based on values in an array "

Thanks to everybody for helping me out. I was going insane… Thanks again.

This post made by @rathi.sham received 1 likes!

Need help with "how to click multiple checkboxes based on values in an array "

Yes…you saved the day, I was about to lose it… Thank you so much.

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 | 15 May 2023

Top 3 Topics with Most Views

String manipulation using split function made by @RAKESH_KUMAR_Tiwari with 57 views.

Want to Compare two excel file and fill the data into this excel file but the Problem is Headings are Dynamic from one row to another how to overcome this made by @Gopikrishna_S with 55 views.

How to use LINQ different data table made by @miftah with 51 views.

Top 3 Topics with Most Replies

String manipulation using split function made by @RAKESH_KUMAR_Tiwari with 25 replies.

How do you Assign Multiple Variables from a Data Table? made by @jdavis7 with 16 replies.

Dynamic String Manipulation - Required help made by @Swetha_V with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 63 posts!

@Yoichi made 24 posts!

@LAKSHMI_NARAYANA_PEMMASAN made 23 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 4 likes!

How to initialize queueitemm and assign value

Hi @gopal_ram , please try below logic TransactionItem = new QueueItem() TransactionItem.SpecificContent = New Dictionary(Of String, Object)() From {{"<your queueitem field","its value"}} NOTE : TransactionItem is of type queueitem **example : ** [image]

This post made by @pavithra_pavi received 2 likes!

Remove rows from DT which have date later than a provide date

Hello @TyraS , Try below logic. Hope it helps (From p In dt.Select() Where (From q In dt.Select() Where DateTime.ParseExact(q("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)<(DateTime.ParseExact(p("Column1").tostring,"ddMMyyyy",System.Globalization.CultureInfo.InvariantCulture)) Select q).toArray.count>1 Select p).ToArray.copyTodatatable() **NOTE : ** dt : is variable of type datatable “Column1” : is your date column

This post made by @arisarnado received 1 likes!

How to Use ComputerVision and OCR in an offline environment

Background: We are currently trying to use ComputerVision and OCR in an offline environment (not connected to Orchestrator). We tried to use the following guide but we were not able to make it work: UiPath version: 2022.10.07 (Enterprise License) Questions: Are there missing steps in the guide above? Is there a separate guide for setting up offline OCR?

Top 3 Most Liked Solutions

This solution provided by @pavithra_pavi received 4 likes!

How to initialize queueitemm and assign value

Hi @gopal_ram , please try below logic TransactionItem = new QueueItem() TransactionItem.SpecificContent = New Dictionary(Of String, Object)() From {{"<your queueitem field","its value"}} NOTE : TransactionItem is of type queueitem **example : ** [image]

This solution provided by @arjunshenoy received 1 likes!

Input string was not in a correct format -Get text activity

Hi @Paddi The error occurs in Activity 4 because the grant variable might not always contain a valid integer value. This issue can arise if the regular expression pattern doesn’t match any digits or if there are leading or trailing whitespaces in the extracted value. Try this to tackle the issue: For Activity 3 → Assign grant = System.Text.RegularExpressions.Regex.Match(page, "\d+(?=page)").Value.Trim() Before proceeding with the Activity 4, use an If condition to check the RegEx outcome: …

This solution provided by @ppr received 1 likes!

Error converting Int to String with LINQ

with the Field method and to String it is double converted, give a try at: DT.AsEnumerable().GroupBy(Function(r) r("Column A value").toString.ToUpper.Trim).Select(Function(s) s.First()).CopyToDataTable

---

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.