Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 April 2023

Top 3 Topics with Most Views

How to move latest pdf files made by @Suraj_Gaikwad_Nuvama_Grou with 57 views.

Dynamic way to read latest text file made by @Priyesh_Shetty1 with 48 views.

How both dates matching or not made by @Sanket_RPA with 47 views.

Top 3 Topics with Most Replies

I value matches with variable click link in another column made by @MEGHA_cs with 22 replies.

How do i read a specific column in web and click on the hyperlink to download the files? made by @monicaong0609 with 22 replies.

How to move latest pdf files made by @Suraj_Gaikwad_Nuvama_Grou with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 72 posts!

@Srini84 made 38 posts!

@supermanPunch made 34 posts!

Top 3 Most Liked Posts

This post made by @Jithesh_R received 4 likes!

How to parse data?

@ani_panch , USe a for each row activity for the input excel and inside the Loop 2. Use assign activity and provide RequiredValue= Split(CurrentRow("paid").ToString,"Paid")(1) Then you can type into the output USD 528.00 Regards,

This post made by @Jithesh_R received 3 likes!

https://botsdna.com/MeeSevaContacts/

@Sohil_bagwan1 , 1.Using Find Children I have got all the Persons Details One By one 2. In that for each loop of children am adding all those details into a list 3.Then again Using For each loop for that list am doing the rest of the Actions 4.You can see in the Type Into (Selector)I have passed the “Code” as dynamic variable (ColName ) I hope this will help you Regards,

This post made by @Jithesh_R received 3 likes!

How to move latest pdf files

@Suraj_Gaikwad_Nuvama_Grou , Did you try with that? Is it working fine now?

Top 3 Most Liked Solutions

This solution provided by @Jithesh_R received 4 likes!

How to parse data?

@ani_panch , USe a for each row activity for the input excel and inside the Loop 2. Use assign activity and provide RequiredValue= Split(CurrentRow("paid").ToString,"Paid")(1) Then you can type into the output USD 528.00 Regards,

This solution provided by @Jithesh_R received 3 likes!

https://botsdna.com/MeeSevaContacts/

@Sohil_bagwan1 , 1.Using Find Children I have got all the Persons Details One By one 2. In that for each loop of children am adding all those details into a list 3.Then again Using For each loop for that list am doing the rest of the Actions 4.You can see in the Type Into (Selector)I have passed the “Code” as dynamic variable (ColName ) I hope this will help you Regards,

This solution provided by @Jithesh_R received 3 likes!

How to move latest pdf files

@Suraj_Gaikwad_Nuvama_Grou , Did you try with that? Is it working fine now?

---

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

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

[system]

Daily Forum Report | 21 April 2023

Top 3 Topics with Most Views

Need linq query for multiple filter made by @RAKESH_KUMAR_Tiwari with 64 views.

Syntax result in string for List array of string with Invoke Method Add made by @YangYang with 56 views.

Update ServiceNow Record made by @gary.cobden with 54 views.

Top 3 Topics with Most Replies

Need linq query for multiple filter made by @RAKESH_KUMAR_Tiwari with 27 replies.

Compare Excel files to get matching rows based on a specific column made by @MEGHA_cs with 22 replies.

How to check the queue item based on the condition? made by @Vrishchik with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 79 posts!

@Srini84 made 34 posts!

@supermanPunch made 23 posts!

Top 3 Most Liked Posts

This post made by @Ricchch received 2 likes!

Saving an excel with one extension type to another type

Thank you to all, I will work on that today… and then i come back to you . really appreciated your advices. Ric

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

Python Scope: Error initializing Python engine - Can't RUn python script

If you are using Python 3.11.x it will not work in UiPath Studio at this moment. I tested with a Python 3.10.10 64-bit and it is working. In order to check your Python version, you can run in cmd.exe the python --version command.

This post made by @Anil_G received 2 likes!

LINQ query to extract lyperlinks from excel

@Ray_Sha1 Please try as @supermanPunch mentioned My bad that I just checked and I dont see url being extracted And you can try this formula as well =MID(FORMULATEXT(A2),13,FIND("""",FORMULATEXT(A2),13)-13) cheers

Top 3 Most Liked Solutions

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

Python Scope: Error initializing Python engine - Can't RUn python script

If you are using Python 3.11.x it will not work in UiPath Studio at this moment. I tested with a Python 3.10.10 64-bit and it is working. In order to check your Python version, you can run in cmd.exe the python --version command.

This solution provided by @Yoichi received 1 likes!

How to convert EXCEL table?

Hi, How about the following? dtResult = dt.AsEnumerable.SelectMany(Function(r) Enumerable.Range(1,3).Select(Function(i) dtResult.LoadDataRow({"",r("Company"),r("Code")}.Concat( r("Employee ("+i.toString+")").ToString.Split({"/"c})).ToArray,False))).Where(Function(r) Not String.IsNullOrEmpty(r("Employee Name").ToString)).CopyToDataTable [image] Sample20230421-2Lv2.zip (21.2 KB) Regards,

This solution provided by @Anil_G received 1 likes!

How to get files from all duplicates folder name and then store al files in a new foder with the same name

@sagar.raval you can use variable in place of 3211…you can have whole of this inside a loop for each crn you have… your for each folder in folder will get each folder starting with 3211 or the crn …so if there are duplicates it would loop through those folders as well If you dont have those activities then use directory.GetDirectories("Folderpath","3211*") and directory.Getfiles(currentfolder) Both of the above expressions will give you array of strings/paths…use for each activity adn change…

---

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

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

[system]

Daily Forum Report | 22 April 2023

Top 3 Topics with Most Views

Return From A Workflow made by @himanshu_punj1 with 48 views.

Regular expressions problmm made by @katta_nikhil with 45 views.

How to use SMTP for multiple emails made by @Muhammad_Anas_Baloch with 42 views.

Top 3 Topics with Most Replies

How to use SMTP for multiple emails made by @Muhammad_Anas_Baloch with 12 replies.

Return From A Workflow made by @himanshu_punj1 with 10 replies.

Iam anable to get the matched items made by @Shiva_Nikhil with 9 replies.

Top 3 Users Who Posted The Most

@Srini84 made 13 posts!

@Nitya1 made 11 posts!

@himanshu_punj1 made 11 posts!

Top 3 Most Liked Posts

This post made by @LAKSHMI_NARAYANA_PEMMASAN received 2 likes!

Return From A Workflow

as per your details it looks like the case needs to be marked as business exception if you are using REframework that will automatically handle the case , the only thing you need to do is returning the application to initial state to take up next case Regards

This post made by @Shiva_Nikhil received 2 likes!

Iam anable to get the matched items

Thanks alot Nitya

This post made by @himanshu_punj1 received 2 likes!

Add Log Text In Multiple Lines

Thanks, that’s an optimistic approach.

Top 3 Most Liked Solutions

This solution provided by @ushu received 1 likes!

Shortcut to Center Flow Chart Activities

Hi @himanshu_punj1 - I guess there is no direct method to do this. But click on the sequence and do, ctrl+RightArrow/LeftArrow to adjust the sequences/activities. To adjust the flow decission do the same thing, click/select it then do ctrl+RightArrow/LeftArrow

This solution provided by @Gokul_Jayakumar received 1 likes!

Regular expressions problmm

Hello @katta_nikhil Try this System.Text.RegularExpressions.Regex.Matches("YourString","[A-Za-z]+(?=\sMarklist)")(0).tostring.trim -----> SSC System.Text.RegularExpressions.Regex.Matches("YourString","[A-Za-z]+(?=\sMarklist)")(1).tostring.trim -----> Provision [image]

This solution provided by @null_null received 1 likes!

How to trigger a hotkey combination i have setup to start/stop screen recording?

Just to follow up, I figure out that you have to select Classic in the Activity Filters menu in order to see Send Hotkey activity. That activity is doing the trick, thanks for all the responses.

---

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

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

[system]

Daily Forum Report | 23 April 2023

Top 3 Topics with Most Views

Automating Oracle ERP made by @Azru with 55 views.

Read mails through API Calls made by @Navya_Nadakuduti with 44 views.

Api -emails made by @Pavan577e7 with 42 views.

Top 3 Topics with Most Replies

Automating Oracle ERP made by @Azru with 12 replies.

Two Array in a string i.e. System.String[][] made by @YangYang with 9 replies.

Want status "Pass" or "Fail" if any blank cell available in a 2 ranges made by @Jeeru_venkat_Rao with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 18 posts!

@Palaniyappan made 13 posts!

@Srini84 made 9 posts!

Top 3 Most Liked Posts

This post made by @ppr received 1 likes!

Can I adjust the speed of Cursor Motion Type = Smooth?

for learning and tracing purposes we can do: [grafik]

This post made by @tomaz received 1 likes!

Check for windows update

Hi, is there any way to check if any Windows updates are available? some way to check using only code?

This post made by @Palaniyappan received 1 likes!

Check for windows update

Hi You can check for available Windows updates using UiPath Studio and activities by following these steps: Open UiPath Studio and create a new project. Drag and drop the “Invoke PowerShell” activity from the Activities panel onto the workflow canvas. In the “CommandText” property of the activity, enter the following PowerShell command: Get-WindowsUpdate In the “Output” property, select “Text”. Add a “Message Box” activity and connect it to the “Invoke PowerShell” activity. In the “Text” pro…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

Check for windows update

Hi You can check for available Windows updates using UiPath Studio and activities by following these steps: Open UiPath Studio and create a new project. Drag and drop the “Invoke PowerShell” activity from the Activities panel onto the workflow canvas. In the “CommandText” property of the activity, enter the following PowerShell command: Get-WindowsUpdate In the “Output” property, select “Text”. Add a “Message Box” activity and connect it to the “Invoke PowerShell” activity. In the “Text” pro…

This solution provided by @Anil_G received 1 likes!

Dynamic Selectors not choosing the correct dropdown value

@m.tan Please try this selector…You can replace data scientist with the variable you need. And also make sure to click on the dropdown before click dropdown selector(Innertext replacement can be done here as well if multiple lists are there) <html app='chrome.exe' title='Contact Details' /> <webctrl aria-role='listbox' tag='DIV' innertext='Choose*Data Analyst*' /> <html app='chrome.exe' title='Contact Details' /> <webctrl aria-role='option' tag='DIV' innertext='Data Scientist' /> <webctrl…

This solution provided by @Palaniyappan received 1 likes!

Two Array in a string i.e. System.String[][]

Fine If you would like to print inside the for each activity itself with a writeline then skip ADD TO COLLECTION activity and just mention like this in a assign activity str_output = item.ToString+”,”+LastName(Array.IndexOf(FirstName, item.ToString)).ToString Where str_output is a string variable defined in variable panel with default value as string.Empty Then use a writeline activity next to this assign and mention as str_output.ToString This can be mentioned even outside the for each loo…

---

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

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

[system]

Daily Forum Report | 24 April 2023

Top 3 Topics with Most Views

If Else Executing both then and else in a loop made by @Hammadul_Haque with 63 views.

Total cost of cloud infrastructure made by @changsheng.zhao with 60 views.

How to extract a list of text (1 column only) from each row from different table made by @sophiey with 60 views.

Top 3 Topics with Most Replies

Filter activity made by @RAKESH_KUMAR_Tiwari with 30 replies.

If Else Executing both then and else in a loop made by @Hammadul_Haque with 16 replies.

Get last row without read range activity made by @roberto.piccolli with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 88 posts!

@Srini84 made 50 posts!

@Anil_G made 42 posts!

Top 3 Most Liked Posts

This post made by @punnipah received 2 likes!

How to Click button Download Multiple on web Help

Hi, I want to Click button Download Multiple on web . If the word Download is displayed, click on all. [image] This my Flow not working : Click only once incorrect ClickDownload.xaml (16.4 KB)

This post made by @fernando_zuluaga received 2 likes!

How to Click button Download Multiple on web Help

Hi @punnipah Give a try with for each UI Element Activity, this is perfect for those kind of cases Regards

This post made by @Srini84 received 2 likes!

How to Click button Download Multiple on web Help

Hi @Anil_G That’s not the birthday, It’s anniversary where I joined the Forums Thanks, Srini

Top 3 Most Liked Solutions

This solution provided by @sharon.palawandram received 1 likes!

Failed to process document. Exception: mscorlib : Attempted to access an element as a type incompatible with the array

Hi All, The resolution for this error code was to upgrade robot and orchestrator versioning to be compatible with the persistence.activities package (I had the latest package upgraded.)

This solution provided by @Palaniyappan received 1 likes!

UiPath use case please solve this fast plese

Hi Hope the below steps would help you resolve this Step 1: Use the ‘Open Browser’ activity to open the Yahoo Finance website. Step 2: Use the ‘Click’ activity to click on the ‘Market Data’ tab on the website. Step 3: Use the ‘Click’ activity to click on the ‘World Indices’ option. Step 4: Use the ‘Data Scraping’ wizard to extract the table on the webpage as an Excel file. Save the file as a CSV file. Step 5: Use the ‘Read CSV’ activity to read the CSV file. Step 6: Use the ‘Write Range’ …

This solution provided by @arjunshenoy received 1 likes!

Total cost of cloud infrastructure

Hi @changsheng.zhao, welcome to the Community. To configure an unattended robot on the cloud, you may not need to install the Automation Suite. Regarding server configurations, it depends on the specific requirements of your automation tasks and the resources needed to execute them efficiently. If you are only using one unattended robot, you may not need a high-end server configuration. However, it is recommended to review the UiPath hardware and software requirements to ensure that your server…

---

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

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

[system]

Daily Forum Report | 25 April 2023

Top 3 Topics with Most Views

PDF Search Automation made by @Kuldeep_Pandey with 69 views.

Regext Statement Needed made by @Kuldeep_Pandey with 59 views.

Uipath.Dataservice not found in Uipath Studio made by @Ilesanmi_Tosin with 52 views.

Top 3 Topics with Most Replies

Compilation failed made by @ashwini.mali with 32 replies.

PDF Search Automation made by @Kuldeep_Pandey with 30 replies.

How to get first 11 values from a variable. It's urgent can anyone help me please made by @sandhyarani with 24 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 58 posts!

@Srini84 made 49 posts!

@Anil_G made 48 posts!

Top 3 Most Liked Posts

This post made by @ppr received 10 likes!

Anil_G 1000th Solution Flag Celebration

Let’s join @Anil_G in celebrating his 1000th Solution Flag. Congrats for this milestone.

This post made by @alejandro_rm received 4 likes!

Value cannot be null(Parameter 'source')

[imagen] I’ve had this problem for couple of hours and couldnt find a solution that worked for me. In the forum the most common answer for this problem were arguments. Through destroying and building again, the team realized that the Remove Duplicates Activity for Excel was the one causing this error. The error stopped appearing once I unchecked the box of Compare Individual Columns and now everything is working smooth. I am making this post in case someone stumbles upon this same error and i…

This post made by @Ilesanmi_Tosin received 3 likes!

Uipath.Dataservice not found in Uipath Studio

Thank you so much everyone for your help. I simply changed the way i typed the search string to data service (putting a space between the data and the service) and i was able to see it. I had already enabled it on the tenant earlier. I really appreciate the quick response on the forum. [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

String comparision without loopig

Still we do have some doubts as the requirement description does have some unspecified parts. We assume that L1-, L2- is not part of check We also cannot derive rules when String1 has more common chars as String 2 - relevant for the output position However have a look here: Common chars but ignoring the occurences: [grafik] And [grafik]

This solution provided by @Palaniyappan received 1 likes!

How to get specific number from a string

Hi Hope the below expression would help you resolve this Use a assign activity like this Str_value = System.Text.RegularExpressions.Regex.Match(str,”\d+(?=\spages|pages)”).Value Where str_value is a string variable The reason why ur expression was not working is this expression attempts to extract the rightmost 5 characters of the string “page” (which will be “page” itself), and then convert them to an integer. Since “page” cannot be parsed as an integer, this expression will throw a Form…

This solution provided by @Manju_Reddy_Kanughula received 1 likes!

Not able to "create" a template for the Form Extractor

@Timsener Check if the Form Extractor feature is enabled in your UiPath license. The Form Extractor is a premium feature and requires a valid license. If you don’t have a license or if your license does not include the Form Extractor feature, you won’t be able to create a template. Check if you have the required permissions to create templates in the Document Understanding feature. To create templates, you need to have the “Edit Templates” permission. If you don’t have this permission, contact…

---

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

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

[system]

Daily Forum Report | 26 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.