Forum Engagement Daily Reports

[system]

Daily Forum Report | 21 April 2024

Top 3 Topics with Most Views

REframework datatables to queues question made by @A_Learner with 49 views.

Error in creating Derived Columns made by @Babjee.Vangipurapu with 45 views.

Taxonomy is not working in my studio? made by @naveen5 with 42 views.

Top 3 Topics with Most Replies

Taxonomy is not working in my studio? made by @naveen5 with 13 replies.

Error in creating Derived Columns made by @Babjee.Vangipurapu with 12 replies.

Excel append range made by @0bb4628e217fd43ac86ac9294 with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 10 posts!

@naveen5 made 6 posts!

@meenyi made 6 posts!

Top 3 Most Liked Posts

This post made by @Vineet_Joshi received 2 likes!

Level up your automation beginner journey: #1 Beginner Challenge awaits you!

Hi Everyone Hope you all are doing awesome, Thanks @loredana_ifrim for extending the challenge date Here is my solution, PFA "Your Age is :- "+(cint(Now.Year) - cint(lv_Date)).ToString Challenge1.zip (2.4 KB) Best Regards Vineet Joshi

This post made by @Valli_Viswa_Varshini received 2 likes!

Level up your automation beginner journey: #1 Beginner Challenge awaits you!

Hi @pradeep_ch , @AutomationX_by_Kiran, @pathrudu and @loredana_ifrim Thanks for organizing this challenge. PFA my solution for Challenge 1 Main.xaml (14.3 KB) With Regards, Valli Viswa Varshini M

This post made by @ppr received 1 likes!

Select a Date range using LINQ with Method Syntax

we highly recommend to check on how the dates are present within datatable as described below and also mentioned that it presence does not have the mandatory same format as in the excel file A LINQ could look like this: (From d In dtData.AsEnumerable Let ds = d("OrderDate").toString.Trim Let dp =DateTime.ParseExact(ds,"dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).Date Where dp > (#02/13/2024#).Date Where dp < (#05/15/2024#).Date Select r=d).CopyToDataTable() we can dynamiz…

Top 3 Most Liked Solutions

This solution provided by @nanmishra received 1 likes!

AI Center - Error in Evaluation Pipeline

Thanks a lot. I am able to run the evaluation pipeline successfully now. The issue was with the minor version. I had to update it to the latest version.

---

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 2024

Top 3 Topics with Most Views

ダウンロードができなくなりました。 made by @naozumi_ogawa with 86 views.

Make Process More Efficient, Clean and Effective made by @Haseeb_Farrukh with 55 views.

How to take action base on whether the specific excel cell is null or not? made by @yangyq10 with 52 views.

Top 3 Topics with Most Replies

How to check If the record has been processed made by @pabaleloh with 20 replies.

How to take action base on whether the specific excel cell is null or not? made by @yangyq10 with 18 replies.

Uipathアカデミー 提出課題２ レポートダウンロード.xaml made by @chantee with 13 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 32 posts!

@Anil_G made 29 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @Aditi_Indoriya received 2 likes!

Winners Announcement: Beginners Learning Challenges in the UiPath Community

Dear UiPath MVPs & Team, I wanted to take a moment to express my deepest appreciation for your unwavering dedication, remarkable expertise, and outstanding support that have propelled us towards success, especially in overcoming challenges. Once again, I would like to express my sincere gratitude to @AutomationX_by_Kiran, @pradeep_ch, @pathrudu, and @loredana_ifrim for this incredible opportunity. Best Regards, Aditi Indoriya

This post made by @aravindbalineni123 received 1 likes!

How top Downgrade Uipath Community edition

Hi @shalu.mittal Assume you want to downgrade to 23.10.5 then download the studio from this link. Uninstall the latest studio and reinstall downloaded. https://download.uipath.com/versions/23.10.5/UiPathStudio.msi Note: As its community edition you would always be prompted to upgrade. So do the below steps to disable auto-update Open Task Manager. In the Details tab, find the UiPath Studio Update Service process. Right-click on the process and select End task. Regards, Aravind

This post made by @SenzoD received 1 likes!

CRON Expression-Orchestrator Trigger

Hi there Why not keep it simple and set up two time based triggers one to run at 10am daily and one to run at 14:45.

Top 3 Most Liked Solutions

This solution provided by @aravindbalineni123 received 1 likes!

How top Downgrade Uipath Community edition

Hi @shalu.mittal Assume you want to downgrade to 23.10.5 then download the studio from this link. Uninstall the latest studio and reinstall downloaded. https://download.uipath.com/versions/23.10.5/UiPathStudio.msi Note: As its community edition you would always be prompted to upgrade. So do the below steps to disable auto-update Open Task Manager. In the Details tab, find the UiPath Studio Update Service process. Right-click on the process and select End task. Regards, Aravind

This solution provided by @SenzoD received 1 likes!

CRON Expression-Orchestrator Trigger

Hi there Why not keep it simple and set up two time based triggers one to run at 10am daily and one to run at 14:45.

This solution provided by @Vinit_Mhatre received 1 likes!

LINQ Query to Convert Data Column Values to List

Hi @Random_Bot , You can do this as below Assign ----> Name as List [System.Collections.Generic.List] : (From row In dt_input.AsEnumerable() Select Convert.Tostring(row("Name")) ).ToList() Regards, Vinit Mhatre

---

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

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

[system]

Daily Forum Report | 23 April 2024

Top 3 Topics with Most Views

Copy the exact text to the indicated blank space made by @vignesh.maruthappan with 57 views.

Need expressions for Calculate Client Security Hash without RE Framework made by @ATHEEQ_UR-RAHMAN with 55 views.

Concatanate Value to Column made by @NISHITHA with 48 views.

Top 3 Topics with Most Replies

Need expressions for Calculate Client Security Hash without RE Framework made by @ATHEEQ_UR-RAHMAN with 26 replies.

Copy the exact text to the indicated blank space made by @vignesh.maruthappan with 20 replies.

I have a excel pivot table and i need to unselect/uncheck some filters in column, Please suggest how can i unfilter some values in pivot table made by @manjunath.m1 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 30 posts!

@Ajay_Mishra made 22 posts!

@pravallikapaluri made 17 posts!

Top 3 Most Liked Posts

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

Level up your automation beginner journey: #2 Beginner Challenge awaits you!

Thanks for presenting the challenge @pradeep_ch , @pathrudu and @AutomationX_by_Kiran Here i am attaching the solution. ListOfNames.zip (48.3 KB)

This post made by @Kancharla_Mahija received 2 likes!

Level up your automation beginner journey: #2 Beginner Challenge awaits you!

hello all Challenge2.zip (3.3 KB) [image]

This post made by @Anil_G received 2 likes!

Uipathで読み取り専用Excelを使用して保存するには

@Teru1228 Manually are you able to change it from readonly? If copy paste is allowed…copy the file to different location…make edits and then paste back…but ideally even if you do anything exact still in the properties of the file there would be a log that you edited the file Cheers

Top 3 Most Liked Solutions

This solution provided by @AJ_Ask received 1 likes!

I need to filter date column in a excel.I used filter data table it is not working

Hi @sathish_moorthy You can achieve is by using filter activity Click on configure filter then add these 2 conditions one for date & other for blanks [image] Hope this helps

This solution provided by @Ajay_Mishra received 1 likes!

Manage try catch

Hey @Stef_99 This is a demo scenario as yours! As Mentioned in below screenshot take a Try Catch Activtity in Foreach Row in Datatable & put all the activities in it and in catch part take Add data row activity for adding that Error row in Exception table. Screenshot for your reference: [image] Attaching .xaml for your reference: TryCatch_Sequence.xaml (13.9 KB) Regards, Ajay Mishra

This solution provided by @mrohan.senapaty received 1 likes!

Error in attended robot

Hello, Please navigate to Preferences → Orchestrator Settings and sign out. Afterward, sign in using the service URL. Attached is a screenshot for your reference. [image] After that you will get the connect page. [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 | 24 April 2024

Top 3 Topics with Most Views

Hi, I need to covert date to a particular format. Consider a string "06-23-3" which is in format MM-yyyy-dd . but the robo is reading the date as 23/06/2003 which is wrong made by @Aswin_Sutheesh17 with 58 views.

What is the cron expression for this? made by @mlellison with 49 views.

Specific JSON Schema violation made by @denisse.olsen with 47 views.

Top 3 Topics with Most Replies

Iterating dynamic Table made by @Gabriele_Radici with 14 replies.

RegEx and word document made by @mma with 13 replies.

Bulk item with unique ref made by @Hazem_Saleh with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 33 posts!

@Anil_G made 31 posts!

@Yoichi made 11 posts!

Top 3 Most Liked Posts

This post made by @Yomi_Oluwadara received 3 likes!

Help needed with writing new col Excel and DataTable manipulation

@Anil_G @lrtetala and @vrdabberu Thank you all for the insights. Appreciate it.

This post made by @AJ_Ask received 2 likes!

How to integrate GUI Python script to

You need to install For Windows projects, the Python Scope activity requires you to install the .NET Desktop Runtime 5.0.17

This post made by @ashokkarale received 2 likes!

Bulk item with unique ref

@Hazem_Saleh, Didn’t find exactly for bulk queue item but here is one as starter for you. Search for more you will get it or understanding this one you can do it yourself. [How to add a Queue Item through orchestrator API calls via postman - Part 9] Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

How to integrate GUI Python script to

@sesa499170, I don’t think you would require any other activities than Run Python Script for this. Here is my working sample for you to test. Python 3.12 [image] .Net Runtime 6.0.28 [image] Here is Python Scope configuration: [image] [image] Output: [image] Try this solution if it’s working or not. Main.xaml (7.5 KB) Thanks, Ashok

This solution provided by @mkankatala received 1 likes!

Hi, I need to covert date to a particular format. Consider a string "06-23-3" which is in format MM-yyyy-dd . but the robo is reading the date as 23/06/2003 which is wrong

I have made a small mistake in expression, check the below one… @Aswin_Sutheesh17 - Assign -> InputDate = "06-23-3" - Assign -> OutputDate = DateTime.Parseexact(InputDate.toString, "MM-yy-d", System.Globalization.Cultureinfo.InvariantCulture).toString("dd/MM/yyyy") Hope you understand!!

This solution provided by @avejr748 received 1 likes!

I can't able to fiter empty column

Do a for each row of your datatable then reassign all cells to themselves with trim. For example, inside for each row of datatable Currentrow(0) = Currentrow(0).ToString.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 | 25 April 2024

Top 3 Topics with Most Views

How to use Excel as database in uipath made by @abianbu28 with 51 views.

HTTP Request Activity not working made by @Asfaque with 45 views.

Delete all content in Excel sheet made by @TD_Learner with 45 views.

Top 3 Topics with Most Replies

Unable click on Button made by @Thumu_Suresh with 13 replies.

BOT Stoppign without reason made by @omar_ismail with 12 replies.

並列処理内で発生したエラーのハンドリング方法 made by @curry with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 42 posts!

@lrtetala made 16 posts!

@postwick made 15 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 2 likes!

Level up your automation beginner journey: #3 Beginner Challenge awaits you!

Hi @loredana_ifrim Thanks for presenting the challenge @pradeep_ch , @pathrudu and @AutomationX_by_Kiran Here is my submission Challenge3.zip (45.8 KB) Regards, Lakshman Reddy

This post made by @treesa.maria received 2 likes!

Level up your automation beginner journey: #3 Beginner Challenge awaits you!

Hi @pradeep_ch, @AutomationX_by_Kiran, @pathrudu Thank you for conducting this challenge. Please find the attached solution Challenge3_CSV_Operations.zip (4.3 KB) Best wishes everyone

This post made by @Gautham_Pattabiraman received 2 likes!

Level up your automation beginner journey: #3 Beginner Challenge awaits you!

Hi @loredana_ifrim , Thank you for presenting the last challenge of the series. @AutomationX_by_Kiran ,@pathrudu and @pradeep_ch Thank you for creating the last challenge of the series. Adding my Submission Challenge3_CSV.zip (4.0 KB) Awaiting the results on 29th …! Best wishes to everyone.! Thanks, Gautham

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

Sum Aggregate report

@qwerty1, Use this LINQ query dt1.AsEnumerable() _ .GroupBy(Function(row) New With { _ Key .Level = row.Field(Of String)("Level"), _ Key .Subject = row.Field(Of String)("Subject") _ }) _ .Select(Function(Group) New With { _ .Level = Group.Key.Level, _ .Subject = Group.Key.Subject, _ .Pass = Group.Sum(Function(row) If(row.Field(Of String)("Result") = "Pass", row.Field(Of Integer)("Grade"), 0)), _ .Fail = Group.Sum(Fun…

This solution provided by @Ajay_Mishra received 1 likes!

Open chome in foreground

Hey @Stef_99 Just goto the Chrome browser → Three Dots(Top Right)–> Settings → Downloads → Change the Default location path & turn off Ask Where to Save option! Screenshot for your reference: [image] Now you are good to go!, the file will be saved in your destination location. Regards, Ajay Mishra

This solution provided by @Ajay_Mishra received 1 likes!

Append data more columns?

Hey @Stef_99 If you have these many conditions, I suggest you take some time and use the below-mentioned query, Assign Activity: dt_Input = dt_Input.DefaultView.ToTable(False,{"All Column Names", "According", "to your requirements"}).AsEnumerable.OrderBy(Function(r) r("Start")).CopyToDataTable Note: In the above query pass column names according to your arrangement. This will be easy and you can manage the position for any column! Below I’m providing you with all the column names that you…

---

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

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

[system]

Daily Forum Report | 26 April 2024

Top 3 Topics with Most Views

DataRowに特定の値が含まれていないデータ行の抽出について made by @gorby with 57 views.

String to double error made by @0bb4628e217fd43ac86ac9294 with 54 views.

How to get specific value from outlook mail made by @Smitesh_Aher2 with 51 views.

Top 3 Topics with Most Replies

Help -- Unable to publish package, Operation has timed out made by @Luis_Fernando with 16 replies.

UiPath and Assistant won´t sign in anymore made by @simonkolb with 15 replies.

How to concatenate the value in uipath made by @anjani_priya with 12 replies.

Top 3 Users Who Posted The Most

@mukesh.singh made 33 posts!

@ashokkarale made 24 posts!

@lrtetala made 17 posts!

Top 3 Most Liked Posts

This post made by @Akash_Javalekar1 received 2 likes!

Level up your automation beginner journey: #3 Beginner Challenge awaits you!

Hi @loredana_ifrim @pradeep_ch @pathrudu Thank you so much for organizing this challenge i would say this is really something show our skills where we can implement our skills it helps me lot to boost up my knowledge AutomationChallenge3.zip (3.6 KB) . Please find attached solution. Looking forward for your feedback. Regards, Akash Javalekar

This post made by @Prasanna_Jarapala received 2 likes!

Level up your automation beginner journey: #3 Beginner Challenge awaits you!

Hi Team, @pradeep_ch @AutomationX_by_Kiran @pathrudu @loredana_ifrim Thank you For the Knowledge Gaining Series, i will be waiting for the next Series of Challenges. Please find the attached solution submitted below Challenge3_ReadingCSV.zip (47.3 KB)

This post made by @Vinit_Mhatre received 2 likes!

Level up your automation beginner journey: #3 Beginner Challenge awaits you!

Hi @loredana_ifrim Thanks for presenting the challenge @pradeep_ch , @pathrudu and @AutomationX_by_Kiran Here is my submission Input: [image] Workflow: String.Join(Environment.NewLine, (From row In Out_DT.AsEnumerable() Select String.Join(",", row.ItemArray.Select(Function(x) x.ToString()))).ToArray()) [image] Output: [image] Challenge3_ReadingCSV.zip (3.4 KB) Regards, Vinit Mhatre

Top 3 Most Liked Solutions

This solution provided by @rajneesh94 received 1 likes!

Which Out Of Box Ml Package should i use for this usecase

@indiedev91 I believe you can give InvoicesIndia package a try, but since your fields are too specific, you can do a labelling session in Data Manager for your documents and retrain this model for your documents. If you would like to build fields and train model only on your documents, you can go for the DocumentUnderstanding package via the same Data Manager labeling approach. Cheers

This solution provided by @Gautham_Pattabiraman received 1 likes!

How to open each file in a folder.one by one

Hi @vignesh.maruthappan , It would open one by one only. At the end of the loop you can add a step to close. Thanks Gautham.

This solution provided by @Yoichi received 1 likes!

Googlechromeで指定のアカウントログインができない

最初の部分ですが、 ハイフン２つにしていますでしょうか？例えば以下のようになると思います。 "--profile-directory=""Profile 2"""

---

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

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

[system]

Daily Forum Report | 27 April 2024

Top 3 Topics with Most Views

Custom Activity - No compatible version with Windows projects made by @RobotUi with 42 views.

Output Of the queue made by @Deeksha with 40 views.

AI Document understanding licensing made by @THodgson with 38 views.

Top 3 Topics with Most Replies

AI Document understanding licensing made by @THodgson with 12 replies.

How can I invoke foreground xaml in a backgound xaml using windows framework? made by @donfeng91 with 8 replies.

UI Automation on Linux made by @class_materials with 6 replies.

Top 3 Users Who Posted The Most

@Anil_G made 15 posts!

@mukesh.singh made 12 posts!

@ashokkarale made 11 posts!

Top 3 Most Liked Posts

This post made by @mukesh.singh received 1 likes!

Monthly Forum Rewards - March 2024

Thanks every one for support

This post made by @Larss received 1 likes!

Add Queue Item - dynamic default values

I had no idea about the JSON schema - that worked perfectly. Thank you!

This post made by @mukesh.singh received 1 likes!

Unable to load DLL 'Microsoft.Data.SqlClient.SNI.dll' or one of its dependencies

The error you’re encountering, “Unable to load DLL ‘Microsoft.Data.SqlClient.SNI.dll’ or one of its dependencies”, arises when your custom activity for Sql Server Bulk Insert cannot locate the required DLL file or its dependent files. Here’s a breakdown of the potential causes and solutions: 1. Missing NuGet Package: Scenario: You haven’t included the Microsoft.Data.SqlClient.SNI NuGet package in your custom activity project. Solution: Add the Microsoft.Data.SqlClient.SNI package using the Nu…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Not Getting correct result

@SACHIN_BILE1, Sorry don’t have time to go through your code but reset your data on Acme website and try this code I have developed. This should work. CalculateClientSecurityHash.zip (1.0 MB) Thanks, Ashok

---

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 2024

Top 3 Topics with Most Views

Questions around Invoke Workflow activity - advanced section made by @NIVED_NAMBIAR with 48 views.

While loop excel made by @meenyi with 46 views.

How to read the decimal 0(zero) in excel? made by @naveen.s with 41 views.

Top 3 Topics with Most Replies

While loop excel made by @meenyi with 19 replies.

Read a word document then change information in a word document template using Reg Ex made by @Sira with 9 replies.

How does Uipath orchestrator handle receiving more than two runs from different users at same time? made by @sesa499170 with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 19 posts!

@Baskar_Gurumoorthy made 7 posts!

@meenyi made 6 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

How does Uipath orchestrator handle receiving more than two runs from different users at same time?

@sesa499170 There is no conflict in this…the robot can run on multiple systems at the same time under their machines Only thing you need to make sure is if usinng any common assets then use value per bot…and using any common files make sure you write with either of them only…or hve copy for each if that is feasible Cheers

This post made by @Anil_G received 1 likes!

How does Uipath orchestrator handle receiving more than two runs from different users at same time?

@sesa499170 there wont be any conflict…who ever start first it will run for them…and the other will be in pendign state waiting for the first one to complete cheers

This post made by @Anil_G received 1 likes!

Questions around Invoke Workflow activity - advanced section

@NIVED_NAMBIAR the out arguments does pass but because of the dictionary it wont be assigned to variable you give to check do this…create a dict as variable and assign the variable in invoke…and then check the dict(“out argument key”) you would see value getting passed out [image] Now coming to isolated, it would either be runnign under same process…like when you check task manager each workflow will be under same ui path process if you selected isolated there will be multiple created …

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

How does Uipath orchestrator handle receiving more than two runs from different users at same time?

@sesa499170 there wont be any conflict…who ever start first it will run for them…and the other will be in pendign state waiting for the first one to complete cheers

This solution provided by @Ajay_Mishra received 1 likes!

Remove Hyperlink with regex

Hey @Anelisa_Bolosha1 Regex: \b(?:https?|ftp|file)://\S+ Use below mentioned query in assign activity to replace all the Urls: str_Input = System.Text.RegularExpressions.Regex.Replace(str_Input, "\b(?:https?|ftp|file)://\S+","") Note: str_Input will be the input string that stores the values. Screenshot for your reference: [image] Regards, Ajay Mishra

This solution provided by @Anil_G received 1 likes!

Questions around Invoke Workflow activity - advanced section

@NIVED_NAMBIAR We do haqve exceptional handling but while trying to know unhandled exceptions in the event viewer logs and all you would see the isolated workflow name instead of main name…this helps where exactly it happened. I would agree that logs would help…but sometimes logs also wont be uploaded completely and the process stops …for thsoe unforseen situations it would help 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 | 29 April 2024

Top 3 Topics with Most Views

Convert Project(Windows) to Project(Legacy) error made by @Stef_99 with 68 views.

Help needed to terminate SAP long execution made by @ellie.liu with 64 views.

For each UI element not clicking made by @Gabriele_Radici with 53 views.

Top 3 Topics with Most Replies

Convert Project(Windows) to Project(Legacy) error made by @Stef_99 with 23 replies.

I am having 2 pdf with different values i have to specially extract those two values made by @Badda_Hemantha with 11 replies.

For each UI element not clicking made by @Gabriele_Radici with 10 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 27 posts!

@Anil_G made 24 posts!

@Baskar_Gurumoorthy made 23 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 1 likes!

Trigger scope is working at the beggining

@sesa499170, Here is sample code for you which will run a tikinter demo script which will wait for 1440 minutes for user input before timeout. As soon as use click on Quit next remaining code will resume. [Python demo] Sample Code: Main.xaml (8.3 KB) Thanks, Ashok

This post made by @ashokkarale received 1 likes!

Trigger scope is working at the beggining

By name it’s designed for triggering the workflow so it should be start of the workflow. If you want to ask for user input, you can use Input Dialogue. Thanks, Ashok

This post made by @ashokkarale received 1 likes!

Trigger scope is working at the beggining

@sesa499170, As per my understanding If you ate using Python Scope to execute python script, bot will wait for timeout of the python scope or completion of script run. I think you won’t require any additional logic for this. Try this. Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

Trigger scope is working at the beggining

@sesa499170, Here is sample code for you which will run a tikinter demo script which will wait for 1440 minutes for user input before timeout. As soon as use click on Quit next remaining code will resume. [Python demo] Sample Code: Main.xaml (8.3 KB) Thanks, Ashok

This solution provided by @J0ska received 1 likes!

Convert Project(Windows) to Project(Legacy) error

only changes in the <activity> XML tag described above In the original XAML file find in <activity> tag VisualBasic.Settings="{x:Null}" and change it to mva:VisualBasic.Settings="{x:Null}" and add xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities" all XML schemas that refer to assembly System.Private.CoreLib e.g. xmlns:s="clr-namespace:System;assembly=System.Private.CoreLib" must be changed to refer to assembly mscorlib e.g. xmlns:s="clr-namespace:Sys…

This solution provided by @nisarga received 1 likes!

Problem to create some Dynamic charts

@jjlof1 Sorry for the delay, here is the modified code and template ModifiedDataAnalysis.zip (86.8 KB) hope it helps you,let me know if it is not working 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 | 30 April 2024

Top 3 Topics with Most Views

UiPath Community 2024.4 Release - Document Understanding Activities made by @Monica_Secelean with 97 views.

Pop-up Problem made by @Angel_Meseguer_piqueras with 52 views.

Write extracted data in to 1 excel sheet made by @xiangyun.koh with 49 views.

Top 3 Topics with Most Replies

Pop-up Problem made by @Angel_Meseguer_piqueras with 18 replies.

「Object reference not set to an instance of an object.」 made by @jasano with 11 replies.

.xls issue while reading the data made by @vishal_nachankar with 9 replies.

Top 3 Users Who Posted The Most

@Baskar_Gurumoorthy made 32 posts!

@Yoichi made 25 posts!

@ppr made 21 posts!

Top 3 Most Liked Posts

This post made by @Monica_Secelean received 5 likes!

UiPath Community 2024.4 Release - Document Understanding Activities

We’re happy to announce the latest we’ve brought to activities and hope they improve the experience for you & for the business users, validating documents! The new release comes with the following enhancements: Validate Document Classification in the new cross-platform Activities The newest DocumentUnderstanding.Activities package provides 3 new activities: Create Classification Validation Task Create Classification Validation Task and Wait Wait for …

This post made by @Jon_Smith received 1 likes!

Start Job activity arguments getting wiped out

I see you going over a bunch of my old posts I did my due dilligence and did report this through the customer portal back in December The case number is Case #:02317985 and it got turned into an internal bug as SPM-4478 so if you want to see where it is in the development pipeline that should give you some clues. I’d be interested to know if it got stuck/lost along the way if its still not being worked on and how we can work better to get the bugs through in the future so f…

This post made by @tolgademir received 1 likes!

Get Data from WebPage To Excel

Hi, You can do this with the open browser activity. You can use dynamic selectors, you should look into that. With Data Scraping, you can scrape the data and print it to an excel file.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

How to use Excel Auto Fill (NOT "Auto Fill Range")

Hi @FINNNNNNNN You can find an example in below thread Cheers!!

This solution provided by @Gautham_Pattabiraman received 1 likes!

Pop-up Problem

Hi @Angel_Meseguer_piqueras, Can you try on element appears activity with click inside that, Also open the UiExplorer, indicate the pop up. Once you get a valid selector can you please share then snap from UiExplorer and the selector as text here.? Thanks, Gautham.

This solution provided by @Yoichi received 1 likes!

「セルに書き込み」で数字と式を入力する場合

26,697,000はエクセルで数値と見なされないので、カンマが千の区切り文字であるなら、これを除去する必要があります。 具体的には例えば "=" + 変数.Replace(",","") + "/1.1" としてみてください

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

@Ajay_Mishra received 44 likes for their solutions!

@Anil_G received 30 likes for their solutions!

@ashokkarale received 30 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 2024

Top 3 Topics with Most Views

Linq Query Instead Of For Each Loop made by @marina.dutta with 56 views.

Infinite System Exception made by @marina.dutta with 54 views.

DataColumnCollection型の変数を使用した条件分岐の式を教えて欲しいです。 made by @Tatsuya.d with 47 views.

Top 3 Topics with Most Replies

How to type into various UI elements made by @hwessels with 10 replies.

Check values in website made by @Priyesh_Shetty with 9 replies.

Linq Query Instead Of For Each Loop made by @marina.dutta with 9 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 20 posts!

@pravallikapaluri made 8 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @postwick received 1 likes!

How to delete second page from PDF?

You don’t need the Write Line, it’s just for logging the page count to the Output panel. In general when you want to do that you should use Log Message. You don’t need the splitting logic others have suggested. You don’t even need the Get PDF Page Count. The Extract PDF Page Range activity will accept a value such as "1, 3-End" which will do what you need. However, I’m not sure what it’ll do if you put “1, 3-End” for a document that only has two pages. If it faults then keep the Get PDF Pa…

This post made by @muktadir received 1 likes!

How do i Analyze document with the custom model using API?

@kishan.savaliya POST rquest to https://myendpoint.cognitiveservices.azure.com/formrecognizer/documentModels/customModel:analyze?api-version=2023-07-31 can you try with this.

This post made by @eric.leung received 1 likes!

SAP VA01 Input Material Detail

thanks, Tested OK with using Type into Activity with delay 0.4ms

Top 3 Most Liked Solutions

This solution provided by @postwick received 1 likes!

How to delete second page from PDF?

You don’t need the Write Line, it’s just for logging the page count to the Output panel. In general when you want to do that you should use Log Message. You don’t need the splitting logic others have suggested. You don’t even need the Get PDF Page Count. The Extract PDF Page Range activity will accept a value such as "1, 3-End" which will do what you need. However, I’m not sure what it’ll do if you put “1, 3-End” for a document that only has two pages. If it faults then keep the Get PDF Pa…

This solution provided by @muktadir received 1 likes!

How do i Analyze document with the custom model using API?

@kishan.savaliya POST rquest to https://myendpoint.cognitiveservices.azure.com/formrecognizer/documentModels/customModel:analyze?api-version=2023-07-31 can you try with this.

---

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 2024

Top 3 Topics with Most Views

Need to modify the column format in .xls file made by @vishal_nachankar with 56 views.

How to remove the empty columns made by @anjani_priya with 51 views.

How to find a word in a PDF as a Whole word made by @chauhan.rachita30 with 51 views.

Top 3 Topics with Most Replies

Date conversion issue using uipath made by @shilpashree.mohanty with 29 replies.

Need to modify the column format in .xls file made by @vishal_nachankar with 29 replies.

Can anyone please help me with this? made by @Pujitha_Ande with 17 replies.

Top 3 Users Who Posted The Most

@Baskar_Gurumoorthy made 44 posts!

@ppr made 37 posts!

@Anil_G made 25 posts!

Top 3 Most Liked Posts

This post made by @pradeep_ch received 3 likes!

Beginner Challenges Winners Announcement

Congratulations all the winners

This post made by @vrdabberu received 2 likes!

Beginner Challenges Winners Announcement

Congratulations everyone Keep rocking!!

This post made by @Parvathy received 2 likes!

Beginner Challenges Winners Announcement

Congratulations everyone

Top 3 Most Liked Solutions

This solution provided by @Krishna_Raj received 1 likes!

How can we clear Orchestrator logs?

@annet_mdamugade check this reference instread of enable you can off the logs

This solution provided by @Baskar_Gurumoorthy received 1 likes!

How to verify/ Validate multiple filed if it's changing everytime

Hi @ankita1999chaudhari after used to Type into or set text activity, you can get the same field text using GET Text activity. then you can use if condition to validate enter text is correct or not. then you can use retry activity to perform the step again until expected results. please refer the below sequence for reference. Sequence2.xaml (15.8 KB) Hope it helps!!!

This solution provided by @ppr received 1 likes!

Generate new queue items

then you are working on a project with compatibility set to Legacy? In such case we would rewrite to: (From d In dtOrigin.AsEnumerable Let idt = d("idTransport") Let ars = d("Deliveries").toString.Trim.Split(";"c) Let sgc = CInt(Math.Ceiling(ars.Length / 200)) From sgm In Enumerable.Range(0,sgc).Select(Function (c) ars.Skip(c*200).Take(200) ) Let ra = New Object(){idt, String.Join(";", sgm)} Select r = dtResult.Rows.Add(ra)).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.

[system]

Daily Forum Report | 03 May 2024

Top 3 Topics with Most Views

Terminate workflow but it not stop process made by @Stef_99 with 60 views.

How the robot do calculation at this case made by @Happydayyy with 56 views.

How to convert JSON to DataTable? made by @kishan.savaliya with 53 views.

Top 3 Topics with Most Replies

My input data issue for automation made by @Fab_Bucket with 20 replies.

Terminate workflow but it not stop process made by @Stef_99 with 17 replies.

In sap automation, how to put the condition like if the popup is visible then it should do click action to that popup or else if should go to next step made by @anjani_priya with 15 replies.

Top 3 Users Who Posted The Most

@Baskar_Gurumoorthy made 38 posts!

@ppr made 32 posts!

@mukesh.singh made 29 posts!

Top 3 Most Liked Posts

This post made by @nikhilesh578 received 2 likes!

Beginner Challenges Winners Announcement

Hearty Congratulations​:tada: to all the winners

This post made by @chethan.dinnupati received 2 likes!

Beginner Challenges Winners Announcement

Thanks @loredana_ifrim , @pradeep_ch , @AutomationX_by_Kiran & @pathrudu. Looking forward to contribute more to the community. Congratulations to all the winners Cheers!!!

This post made by @Aditi_Indoriya received 2 likes!

Beginner Challenges Winners Announcement

Congratulations to all the winners Cheers

Top 3 Most Liked Solutions

This solution provided by @Baskar_Gurumoorthy received 1 likes!

How to run a JOB when a user receives a specific email

Hi @esongi_park please refer the below thread. for specific email received. refer the below video for reference. [How to Loop through emails and read mail in UiPath Studio X] Hope it helps!!!

This solution provided by @Baskar_Gurumoorthy received 1 likes!

How to save the filtered data in a variable

yes, if you use filter data table activity to filter total column with zero value. it will be stored as with name column value with hyte and total column with zero . again on another filter data table you can filter the value using with help of foreach datatable activity ( currentrow(“name”).tostring"

This solution provided by @lrtetala received 1 likes!

How to convert Get text string variable into integer and spilt the same

Hi @ankita1999chaudhari Try this [image] Regards,

---

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

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

[system]

Daily Forum Report | 04 May 2024

Top 3 Topics with Most Views

Want this solution made by @Rahul_power with 40 views.

Delay in Copy and Pasting Activities made by @_Fm with 39 views.

UiPath Log setting from assistant made by @Ritaman_Baral with 35 views.

Top 3 Topics with Most Replies

Converting a column of negative numbers into positive numbers in excel made by @Rule_Outlaw with 9 replies.

SAP Selector Issue using type into made by @shashank_dullu with 8 replies.

Attach browser error could not find the ui element made by @Rule_Outlaw with 6 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 20 posts!

@KevinE made 11 posts!

@Anil_G made 9 posts!

Top 3 Most Liked Posts

This post made by @lrtetala received 1 likes!

Converting a column of negative numbers into positive numbers in excel

Hi @Rule_Outlaw Can you try the below [image] Input: [image] Output: [image] Cheers!!

This post made by @lrtetala received 1 likes!

Converting a column of negative numbers into positive numbers in excel

@Rule_Outlaw Try this CurrentRow("Credit Amount").ToString.Replace("-","")

This post made by @Rule_Outlaw received 1 likes!

Converting a column of negative numbers into positive numbers in excel

Oh my god it worked, thank you so much my assignment is due 10 minutes your a life saver.

Top 3 Most Liked Solutions

This solution provided by @lrtetala received 1 likes!

Converting a column of negative numbers into positive numbers in excel

@Rule_Outlaw FYI, there is another approach [image] dt.AsEnumerable.ToList.ForEach(Sub(r) r("Credit Amount")=r("Credit Amount").ToString.Replace("-","") End Sub ) [image] Cheers!!

---

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

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

[system]

Daily Forum Report | 05 May 2024

Top 3 Topics with Most Views

Throw Business Exception made by @A_Learner with 49 views.

Need help to define LinQ query made by @Logesh_Ekeshwara_Rao with 41 views.

Need clarification to create LinQ query made by @Logesh_Ekeshwara_Rao with 40 views.

Top 3 Topics with Most Replies

Upload Activities in SharePoint made by @quick_123 with 12 replies.

Throw Business Exception made by @A_Learner with 5 replies.

How to achieve this below excel data manipulation? made by @Ritesh_Burman with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 24 posts!

@ashokkarale made 8 posts!

@quick_123 made 7 posts!

Top 3 Most Liked Posts

This post made by @grosner received 1 likes!

Unable to Save Main Sequence Annotations

I can also confirm this is now working. Thank you!

This post made by @ashokkarale received 1 likes!

Unable to Save Main Sequence Annotations

@alexandru, It’s Fixed! Thanks for the follow up. Thanks, Ashok

This post made by @Rule_Outlaw received 1 likes!

Attach browser error could not find the ui element

This worked thanks, sorry if im bothering you but can you add on of how to remove rows if a certain column is empty for excel and how to use string for flow decision? Thanks!

Top 3 Most Liked Solutions

This solution provided by @muktadir received 1 likes!

Throw Business Exception

@A_Learner In debug mode the bot will stop at the throw activity and you will have to click on continue. This will not happen if run normally. Also, in debug mode you can enable Continue on Exception. So that execution odes not stop there. [image]

This solution provided by @Anil_G received 1 likes!

Downloads window is disappearing

@A_Learner You can directlt pass the file location to start process or use application/browser and open it Cheers

This solution provided by @Siam_Rahman received 1 likes!

The Click activity keeps downloading the old version of an updated file

I was able to fix it. The blob link embedded in the button was not updating. So found a way to make that work. Just had to move around on the page. I don’t know why it worked but it did. Thank you for your time!

---

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 2024

Top 3 Topics with Most Views

Clear white space made by @xiangyun.koh with 51 views.

Asset read but not stored in argument made by @justinkxc with 51 views.

How to check each row from column if continuously dropping less than 3 then break the loop and send exception mail made by @shaik.muktharvalli1 with 50 views.

Top 3 Topics with Most Replies

How to check each row from column if continuously dropping less than 3 then break the loop and send exception mail made by @shaik.muktharvalli1 with 25 replies.

Extract urls along with the text made by @Sailaja_Pasupuleti with 13 replies.

Trim Not Working With File made by @anon97 with 12 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 36 posts!

@Anil_G made 35 posts!

@ppr made 30 posts!

Top 3 Most Liked Posts

This post made by @didac.elgueta received 2 likes!

Error in the Python Scope Activity

Hi @ashokkarale Thanks for your reply. I needed to install .NET 6.0

This post made by @pere received 2 likes!

Studio allows me to set a default "Nothing" value for non-nullable types, yet later it complains when I try to make use of it

And do I have to infere that “Nothing” in an Int32 variable means “zero”? Then don’t allow it to accept “Nothing” as value, and only allow it to accept “0”.

This post made by @postwick received 1 likes!

In Debug, after exception, continue past remaining instances of the same exception

I think either of these options would work: A setting to control whether the continue button stops at each “bubble up” or not A separate button (ie continue would still stop at each bubble up, but the new button would skip to the next non-exception activity

Top 3 Most Liked Solutions

This solution provided by @ByteBreaker received 1 likes!

Python process scope gets stuck, no error just nothing runs

Hi @Anil_G and @mukesh.singh, thank you for pointing in the right direction, I should have checked there before. It was pointed out that “HostFxr.dll” was missing and even after re-installing the Python package, the issue was not resolved. Further, I tried to install windowsdesktop-runtime-6.0.29-win-x64 and dotnet-runtime-6.0.29-win-x64 (UiPath documentation slightly seems to be mentioning it is included in the tool installation) but in my case, installing these resolved the issue and I am abl…

This solution provided by @ppr received 1 likes!

How to convert String with Space to integer

an integer is a number without decimal part. So 25 26 27 could represent 252627 but maybe you are looking for something different. Can you elaborate more on your use case and what is to achieve in detail? Thanks we assume that not an int32 Array is needed otherwise we would do: arrInts = strVar.Split(" "c).Select(Function (x) CInt(x)).ToArray

This solution provided by @ppr received 1 likes!

Split an excel field into blocks of 200

We guess that we already had answered here: it is maybe only a variation on the structure which has to be incorporated: (From d In dtOrigin.AsEnumerable Let ars = d("Deliveries").toString.Trim.Split(";"c) Let sgc = CInt(Math.Ceiling(ars.Length / 200)) From sgm In Enumerable.Range(0,sgc).Select(Function (c) ars.Skip(c*200).Take(200) ) Let ra1 = d.ItemArray.Take(4).Append(String.Join(";",sgm)) Let ra2 = d.ItemArray.Skip(5) Let ra = ra1.Concat(ra2).Cast(Of Object).ToArray Select r = dtResult.Row…

---

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 2024

Top 3 Topics with Most Views

Execution end right start execution start made by @xiangyun.koh with 66 views.

How to schedule process in UiPath Studio? Not from orchestrator made by @mlellison with 63 views.

How to end process in sub catch made by @Stef_99 with 56 views.

Top 3 Topics with Most Replies

Execution end right start execution start made by @xiangyun.koh with 20 replies.

Difficulty to login to uipath community edition studio made by @Gebrekidan_Zemichael with 15 replies.

Data Table : logic to process data made by @soundarya_A1 with 12 replies.

Top 3 Users Who Posted The Most

@mukesh.singh made 25 posts!

@ppr made 23 posts!

@Anil_G made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 1 likes!

Find the first and last day of the previous month

Hi, Can you try as the following? [image] Sample NewBlankTask20240507-1 (2).zip (50.1 KB) Regards,

This post made by @Yoichi received 1 likes!

Execution end right start execution start

Hi, Is there possibility the filter expression is not correct? To isolate cause, what if filter condition is empty? Regards,

This post made by @postwick received 1 likes!

Usage of -Max # of retries -

The retry in the queue just means the queue item is marked as status Retried, and a New queue item is created. For example, if you have it set to max 3 retries, and they all fail, you’ll have three queue items marked as Retried, and one as Failed. If you look at the details of the queue items, on the history tab you’ll see this progression as the queue items are linked. It has nothing to do with any XAML files. It just results in a new queue item that will then be processed by the automation…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Type Into not typing error

Hi, Can you share error message if exists? If it types nothing without error, can you try set HardwareEvent at InputMethod? And also turn on HighlightsElements then check which element is highlighted. [image] Regards,

This solution provided by @Yoichi received 1 likes!

DU Modern Experience

Hi, The following official document will help you. Regards,

This solution provided by @pravallikapaluri received 1 likes!

How to Kill process process uipath

@Stef_99 Check the below thread

---

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 2024

Top 3 Topics with Most Views

How to filter with the List of values in a column made by @anjani_priya with 65 views.

Bot is running fine in studio but continuously failing when running through Orchestrator made by @Tanya_Verma with 51 views.

How to split Dynamic Campany Name from notepad made by @Sayed_Tabrez2 with 50 views.

Top 3 Topics with Most Replies

How to filter with the List of values in a column made by @anjani_priya with 26 replies.

How to split Dynamic Campany Name from notepad made by @Sayed_Tabrez2 with 15 replies.

Seeing "Cannot serialize the DataTable. DataTable name is not set " Error even after setting datatable name made by @benjiherb with 11 replies.

Top 3 Users Who Posted The Most

@mukesh.singh made 27 posts!

@ashokkarale made 20 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @udit.chandna received 1 likes!

Announcements : New Feature Release - Custom List support in VB Apps and Lookup Panel

RELEASE ANNOUNCEMENT HEY EVERYONE We’re thrilled to announce the exciting new features available in the latest UiPath Apps update! This May release equips citizen developers with powerful tools and streamlines app creation for all users. Introducing the Custom List Control The all-new Custom List control in VB Apps empowers you to generate dynamic, data-driven interfaces. This versatile feature allows you to: Display grouped controls using templates, with the number of elements automaticall…

This post made by @lee.yeh.ching received 1 likes!

Unable to Identify UI Element for Pop Up Window

Helllo, i would like to get some advice regarding managing pop ups for UiPath. I have a script whereby i have to click a button, and then click the “ok” in the pop up window. The pop up window is not exactly a window because there is no “x” button to close the window… (not sure if this is the reason why UiPath cant see it). So i have been failing at the click “ok” step for quite some time. Have tried web recording and error message said that no ui element was detected. tried delay → retry sco…

This post made by @ashokkarale received 1 likes!

How to use for loop in my situation

@MD_Farhan1, For this you can declare a datatable variable outside of For Each File activity scope [image] And inside the loop after extractor add condition like this to merge current document data into previous all documents datatable. [image] Now to write it into single excel file use write range activity outside of For each file loop and pass dtFinal Datatable which will contain data of all the documents. Final solution would be like this. [image] Thanks, Ashok

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

How to use for loop in my situation

@MD_Farhan1, For this you can declare a datatable variable outside of For Each File activity scope [image] And inside the loop after extractor add condition like this to merge current document data into previous all documents datatable. [image] Now to write it into single excel file use write range activity outside of For each file loop and pass dtFinal Datatable which will contain data of all the documents. Final solution would be like this. [image] Thanks, Ashok

This solution provided by @lrtetala received 1 likes!

How to split Dynamic Campany Name from notepad

Hi @Sayed_Tabrez2 Try this [image] Sequence14.xaml (14.3 KB) Output: [image] Cheers!!

This solution provided by @Yoichi received 1 likes!

配列の内容をリストに追加したい。

こんにちは 結果プロパティに結果を収納する変数を設定していますでしょうか？ あるいは代入アクティビティで varList = varList.Concat(varArr).ToList() のようにしても追加できると思います。

---

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 2024

Top 3 Topics with Most Views

I have a excel and need to find the string is present on not made by @vineelag with 58 views.

外字を含む全角半角混在文字の全角変換について made by @k-miya with 52 views.

Logic to distribute data made by @soundarya_A1 with 49 views.

Top 3 Topics with Most Replies

I have a excel and need to find the string is present on not made by @vineelag with 19 replies.

How to extract the all data from multiple pages? made by @Kumar_Sahu_Sameer with 11 replies.

Add users in UiPath Orchestrator made by @Shreesh_Bhardwaj with 11 replies.

Top 3 Users Who Posted The Most

@mukesh.singh made 24 posts!

@Yoichi made 21 posts!

@ashokkarale made 21 posts!

Top 3 Most Liked Posts

This post made by @ashokkarale received 2 likes!

Unused files

@A_Learner, Here is inbuilt solution in Studio to remove unused workflows. [image] Thanks, Ashok

This post made by @lrtetala received 2 likes!

Copy text into a variable even if the field is empty

Hi @sullivanne Try this (?<=:)(.*) [image] [image] [image] Regards,

This post made by @SenzoD received 2 likes!

Copy text into a variable even if the field is empty

I would suggest you separate your variables create a string variable for Name and use assign activity like below: System.Text.RegularExpressions.Regex.Match(strInputText, "(?<=Name:\s).*").ToString [image] Do the same for surname, address and phone number, You only need to change the anchor on the regex eg for surname it will be System.Text.RegularExpressions.Regex.Match(strInputText, "(?<=Surname:\s).*").ToString this way its simple and easier to maintain.

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 2 likes!

Unused files

@A_Learner, Here is inbuilt solution in Studio to remove unused workflows. [image] Thanks, Ashok

This solution provided by @lrtetala received 2 likes!

Copy text into a variable even if the field is empty

Hi @sullivanne Try this (?<=:)(.*) [image] [image] [image] Regards,

This solution provided by @Yoichi received 1 likes!

データテーブルの特定の列に入った値によって判断処理を加えたい。

「現在の繰り返しをスキップ」は次のアイテムの処理に移るだけですので、ループを抜けることはできません。 「繰り返しを終了」でループを抜けることができますが、基本的には最も内側のループを抜けることになります。 上記サンプルですとファイルをイテレートするループは無いように見えますが、それがある前提ということでしょうか？

---

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 2024

Top 3 Topics with Most Views

An internal error occurred. It is recommended to restart Uipath studio made by @Janaiah_D with 57 views.

Read range between texts made by @E.T.S with 47 views.

Extract email by current day and previous day and specific subject made by @xiangyun.koh with 46 views.

Top 3 Topics with Most Replies

Read range between texts made by @E.T.S with 12 replies.

I have a complex string value and I want to remove the part between two words made by @HaticeKubraYilmaz with 8 replies.

An internal error occurred. It is recommended to restart Uipath studio made by @Janaiah_D with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 43 posts!

@mukesh.singh made 24 posts!

@ashokkarale made 21 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Identify and Extract Dynamic section from long document (pdf)

@barissecen welcome to the community section cannot be extracted via regex also?mostly with explaination I might think no…but just to confirm also did we happen to try with ai center and trainign any existing model as Chatgpt connector is not working…if you have your own subscription then try to use http request and call those services directly cheers

This post made by @xiangyun.koh received 1 likes!

Extract email by current day and previous day and specific subject

does anyone know how can i write the expression for the filter if i want to filter it by current day and the previous day with a specific subject . Currently i have something like this as my filter by it not fetching email from the current day but only the previous day . “@SQL=urn:schemas:httpmail:datereceived >= '” +Today.AddDays(-1).ToUniversalTime.ToString(“‘yyyy/MM/dd HH:mm’”)+ “’ AND urn:schemas:httpmail:subject LIKE ‘%VDM%’”

This post made by @ignasi.peiris received 1 likes!

I have a complex string value and I want to remove the part between two words

Hi @HaticeKubraYilmaz , I’m thinking on possibly using Regex Replace to find the string between your 2 keywords, and then replacing it with a String.Empty, should look something like this: System.Text.RegularExpressions.Regex.Replace(strTest,“(?<=DİPNOT).*(?=PASİF)”,String.Empty,System.Text.RegularExpressions.RegexOptions.Singleline) [image] [image] Edit: If you also want the 2 keywords to be deleted, you can modify a bit the regex expression: System.Text.RegularExpressions.Regex.Replac…

Top 3 Most Liked Solutions

This solution provided by @ignasi.peiris received 1 likes!

I have a complex string value and I want to remove the part between two words

Hi @HaticeKubraYilmaz , I’m thinking on possibly using Regex Replace to find the string between your 2 keywords, and then replacing it with a String.Empty, should look something like this: System.Text.RegularExpressions.Regex.Replace(strTest,“(?<=DİPNOT).*(?=PASİF)”,String.Empty,System.Text.RegularExpressions.RegexOptions.Singleline) [image] [image] Edit: If you also want the 2 keywords to be deleted, you can modify a bit the regex expression: System.Text.RegularExpressions.Regex.Replac…

This solution provided by @Anil_G received 1 likes!

SMS OTP for Customer verification for UiPath Apps

@csajal You can ask for mobile number on page 1 and on click on continue …trigger a process and in process use a random generation and generate a number and we can use twillo api to send messages and also give the number generated back to process…and when the number is entered on screen compare it with the otp sent to mobile and if it matches perform the login Cheers

This solution provided by @lrtetala received 1 likes!

How to get the sub-folder path from a File-path

Hi @chauhan.rachita30 Can you try the below str_Input="C:\Users\svcUpChtPreDSHS\Desktop\FakeSharedDrive\Process\CHET\11.15.2023 Nurse DONE\MF NO\Peterson.pdf" str_Output=Path.GetDirectoryName(Path.GetDirectoryName(str_Input)) [image] Cheers!!

---

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

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