Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Nitya1 made 17 posts!

@Smit_Jain made 11 posts!

Top 3 Most Liked Posts

This post made by @Cuberoot received 2 likes!

Unable to Copy the color of filter cells

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

This post made by @Shiva_Nikhil received 2 likes!

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

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

This post made by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

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

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 2 likes!

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

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

This solution provided by @Anil_G received 1 likes!

Error Downloading Monthly Report from Microsoft Edge - REF Assignment

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

This solution provided by @Vikas_M received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 10 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@Sara_Piana made 13 posts!

@Palaniyappan made 12 posts!

Top 3 Most Liked Posts

This post made by @Shubham_Varshney received 1 likes!

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

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

This post made by @lrtetala received 1 likes!

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

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

This post made by @Yoichi received 1 likes!

How to debug error using wildcard?

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

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to debug error using wildcard?

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

This solution provided by @Palaniyappan received 1 likes!

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

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

This solution provided by @Anil_G received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 11 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Palaniyappan made 43 posts!

@Nguyen_Van_Luong1 made 23 posts!

@postwick made 22 posts!

Top 3 Most Liked Posts

This post made by @Venkata_Rajendran received 11 likes!

Apps - Attended Real time Communication

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

This post made by @Ampra received 2 likes!

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

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

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

How to get count of empty columns in the excel

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

Top 3 Most Liked Solutions

This solution provided by @Jeroen_van_Loon received 1 likes!

Outlook shared mailbox synchronization takes too long

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

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

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

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

This solution provided by @Palaniyappan received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 12 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

Forms made by @Rohit_Nandwani with 10 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 56 posts!

@Palaniyappan made 33 posts!

@postwick made 30 posts!

Top 3 Most Liked Posts

This post made by @Samrat_Dutta received 2 likes!

Creating a Workday connection in Integration Service

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

This post made by @Palaniyappan received 2 likes!

UiPath Spotlight Directory: Amplify Your Presence

This is fantastic

This post made by @ppr received 1 likes!

Extract the specific value from the JSON object

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

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Update Datatable column name when it contain certain word?

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

This solution provided by @Yoichi received 1 likes!

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

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

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Tooltip in Argument Panel

Hi @irahmat , You can right click to argument then select design properties [image] [image] [image] [image]

---

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

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

[system]

Daily Forum Report | 13 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

Correct format issue made by @aya_lajili1 with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@postwick made 30 posts!

@E.T.S made 25 posts!

Top 3 Most Liked Posts

This post made by @nikhilesh578 received 6 likes!

Monthly Forum Rewards - August 2023

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

This post made by @Dinesh_Guptil received 3 likes!

Monthly Forum Rewards - August 2023

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

This post made by @Anil_G received 2 likes!

Monthly Forum Rewards - August 2023

Congratulations everyone cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Extract table of contents + Word document

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

This solution provided by @Shiva_Nikhil received 1 likes!

Read txt file and Split Each Row

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

This solution provided by @ppr received 1 likes!

The source contains no datarows fixes?

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

---

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

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

[system]

Daily Forum Report | 14 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

Addition not working made by @Kamalesh_Chunekar with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 57 posts!

@Anil_G made 33 posts!

@postwick made 28 posts!

Top 3 Most Liked Posts

This post made by @raghu30691 received 3 likes!

Monthly Forum Rewards - August 2023

Hearty Congratulations Forum Leaders… @Anil_G , @Shiva_Nikhil Cheers

This post made by @Anil_G received 3 likes!

Need to capture value from this complex JSON

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

This post made by @mukeshkala received 2 likes!

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

The UiPath emoji is awesome

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 3 likes!

Need to capture value from this complex JSON

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

This solution provided by @Anil_G received 2 likes!

Lookup data table not configured correctly

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

This solution provided by @Gokul_Jayakumar received 1 likes!

Transpose excel data

@suraj.l Refer to this Xaml file you may get some idea. Transpose.xaml (11.4 KB) [image]

---

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

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

[system]

Daily Forum Report | 15 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Palaniyappan made 44 posts!

@ppr made 29 posts!

@Praveen_Mudhiraj made 24 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 2 likes!

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

Cool features @loredana_ifrim

This post made by @LamaX received 2 likes!

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

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

This post made by @seonghyeon_pak received 2 likes!

UiPath studio 설치문의

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

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

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

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

This solution provided by @ppr received 1 likes!

Unable to convert the Jsonobject to Json array

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

This solution provided by @Yoichi received 1 likes!

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

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

---

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

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

[system]

Daily Forum Report | 16 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Palaniyappan made 12 posts!

@divya.17290 made 12 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 1 likes!

Selectors issue on item

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

This post made by @Madhu_Maurya received 1 likes!

Captcha2

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

This post made by @raven received 1 likes!

Desktop outlook app error

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

Top 3 Most Liked Solutions

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

Difference bw studio and studio x

Hi @keerthi65a Welcome to community Check the above link

This solution provided by @Palaniyappan received 1 likes!

Replace multiples words in text file

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

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

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

Hi, You can use the following expression to convert an Excel date value (e.g., 45175) to a formatted date string: DateTime.FromOADate(CDbl(ngayhd)).ToString(“dd/MM/yyyy”) [image]

---

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

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

[system]

Daily Forum Report | 17 September 2023

Top 3 Topics with Most Views

Regarding excel calculation made by @ramshiva_reddy with 37 views.

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

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

Top 3 Topics with Most Replies

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

Downgrading Studio made by @J_Crosby with 6 replies.

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

Top 3 Users Who Posted The Most

@Palaniyappan made 13 posts!

@Anil_G made 13 posts!

@ppr made 8 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 3 likes!

Need RegEx help please

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

This post made by @Chirag12 received 2 likes!

Monthly Forum Rewards - August 2023

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

This post made by @Sudarshana_Sharma_P received 2 likes!

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

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

Top 3 Most Liked Solutions

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

Need RegEx help please

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

This solution provided by @Anil_G received 1 likes!

If activity - Message Box not popping up after user input

@OGunnarsson Welcome to the community The problem is your while condition The if condition is not placed inside the while loop…so the while loop will end only when you give the correct answer…hence the if condition is executing only correct one… Try to move your if condition into the while loop then for each loop or guess you will get the message pop up as needed Cheers

---

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

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

[system]

Daily Forum Report | 18 September 2023

Top 3 Topics with Most Views

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

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

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

Top 3 Topics with Most Replies

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

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

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

Top 3 Users Who Posted The Most

@Anil_G made 47 posts!

@Palaniyappan made 35 posts!

@ppr made 34 posts!

Top 3 Most Liked Posts

This post made by @firas received 2 likes!

Prompting for credintials while running a Query inside Excel

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

This post made by @mRob received 2 likes!

User rights - Read only access to Triggers & Logs

Thanks for the answers, il give those a go !

This post made by @Nguyen_Van_Luong1 received 1 likes!

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

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

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

AWS server instance

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

This solution provided by @Palaniyappan received 1 likes!

How open PDF file

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

This solution provided by @Anil_G received 1 likes!

User rights - Read only access to Triggers & Logs

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

---

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

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

[system]

Daily Forum Report | 19 September 2023

Top 3 Topics with Most Views

Split Excel to multiple Excels made by @praneeth.v.c with 41 views.

Read Particular column made by @Gokul_Murali with 39 views.

Need to write in excel sheet on the basis of different value in the row made by @office_use with 39 views.

Top 3 Topics with Most Replies

Having Problems Connecting my UIPath Studio to my Outlook made by @M_F with 22 replies.

Output data table - cannot get values of data table made by @E.T.S with 21 replies.

Need to write in excel sheet on the basis of different value in the row made by @office_use with 18 replies.

Top 3 Users Who Posted The Most

@postwick made 35 posts!

@Nguyen_Van_Luong1 made 33 posts!

@Anil_G made 33 posts!

Top 3 Most Liked Posts

This post made by @andreus91 received 2 likes!

Convert date to desired format

if you might have different input date formats, I recommend always using parse exact, but providing various date patterns in an input array. var_datetime = DateTime.ParseExact(Strinput.ToString, arr_formats, System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None) arr_formats = {“yyyyMMdd”, “MM/dd/yyyy”, “dd/yy”} I hope it helped you

This post made by @Dillon_Marius received 1 likes!

UiPath Certified RPA Associate (UiRPA) and UiPath Certified Advanced RPA Developer (UiARD) - Update

Hi Quick question, I’m in the middle of the taking the current curriculums and its modules. From my understanding of the above, the modules will later on take out classic related modules? cmiiw. Also, will there be additional new modules for modern design or they stay just as is? But yeah on a more high level, I’m wondering how the curriculum and modules will change. Cheers, Dillon

This post made by @wsinten received 1 likes!

How to write text by time

hi @Nguyen_Van_Luong1 @Parvathy @Anil_G , thank you for helping. the above problem has been solved. Thank You

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

엑셀의 특정 열의 텍스트를 한꺼번에 인터넷에 조회 하는 방법

Hi @doosanhero6 , My step 1-read file to get data table [image] 2-use open browser use for each row in data table type into row value to website send hot key with key enter to down line [image] hope it help,

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

Convert date to desired format

Hi @Tanu_G Check this out Datetimevar= DateTime.ParseExact(“20230919”,“yyyyMMdd”,System.Globalization.CultureInfo.InvariantCulture). ToString(“MM/yyyy/dd”) Hope this helps

This solution provided by @Yoichi received 1 likes!

Need to remove one row or more row based on condition

Hi, How about the following? [image] dt.AsEnumerable.GroupBy(Function(r) r("ref ord no").ToString).SelectMany(Function(g) g.Select(Function(r) r).GroupBy(Function(r) r("material").ToString).SelectMany(Function(g2) if(g2.Key="Not Found in Master Regular" AndAlso g.Count>g2.Count,New DataRow() {},g2.Select(Function(r2) r2)))).CopyToDataTable() Sample20230919-1L.zip (11.5 KB) Regards,

---

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

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

[system]

Daily Forum Report | 20 September 2023

Top 3 Topics with Most Views

Hypelrink Excel Uipath made by @Ritaman_Baral with 87 views.

Enhancing Video Recording with Queue Recording made by @Adrian_Tamas with 67 views.

Date Type error, Date with year 1999 is not working but working on date with year 2000 made by @Anelisa_Bolosha1 with 66 views.

Top 3 Topics with Most Replies

Date Type error, Date with year 1999 is not working but working on date with year 2000 made by @Anelisa_Bolosha1 with 28 replies.

Hypelrink Excel Uipath made by @Ritaman_Baral with 24 replies.

https://forum.uipath.com/t/597667 made by @xxGoRpa with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Nguyen_Van_Luong1 made 45 posts!

@ppr made 28 posts!

Top 3 Most Liked Posts

This post made by @Adrian_Tamas received 9 likes!

Enhancing Video Recording with Queue Recording

Hi there, UiPath Community! On behalf of all teams involved, I’m excited to announce a new feature meant to improve your automation workflow, especially when dealing with queue item execution. We are always listening to your feedback, and we understand that identifying the root cause of failed transactions can be a real challenge. Therefore, on top of the existing video recording capabilities, we have just released Queue Recording. Queue Recording is an integrated video recording feature that …

This post made by @ppr received 2 likes!

JSON array adding new values issue

Cross reference: We do have a few options, as also mentioned in the other thread: constructing the Structure with the help of e.g. Dictionaries, Arrays… and convert it to JSON afterwards Constructing JSON by the scratch illustrating, from where the FOR EACH would be fed or what is sent in, would be helpful. Maybe a less generic sample data will let us better understand However also have a look at this: For each Activity | item in CollectionOfManyJObjects | TypeArguement: JObject Invoke…

This post made by @sebastian.ungureanu received 1 likes!

Orchestrator - Resources in Classic Folders will be removed in October 2023

Hello everyone, As we approach release 2023.10, we’d like to remind you that Classic Folders will soon be completely removed, in accordance with our previously announced deprecation plan. Starting with the 2023.10 release of the UiPath Business Automation Platform, we will remove all resources in Classic Folders. To be clear, this means that all resources not migrated to Modern Folders before release 2023.10 is deployed will no longer be available in any workflow. Automation Cloud customers ne…

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

JSON array adding new values issue

Cross reference: We do have a few options, as also mentioned in the other thread: constructing the Structure with the help of e.g. Dictionaries, Arrays… and convert it to JSON afterwards Constructing JSON by the scratch illustrating, from where the FOR EACH would be fed or what is sent in, would be helpful. Maybe a less generic sample data will let us better understand However also have a look at this: For each Activity | item in CollectionOfManyJObjects | TypeArguement: JObject Invoke…

This solution provided by @supermanPunch received 1 likes!

Negative look ahead

Hi @A_Learner , I believe there must be a slight change in the Expression : ((?<!Payment(s)?\s*)Received)(((\b(?:[A-Za-z]{3,9} \d{1,2}, \d{4})\b)|(\s?\d+/\d+/\d+))(?=(.*)?)) [image] As it should be a Negative Look behind not ahead.

This solution provided by @Anil_G received 1 likes!

Date Type error, Date with year 1999 is not working but working on date with year 2000

@Anelisa_Bolosha1 As per message box this is what you need to use inceptiondt2 = Datetime.ParseExact(inceptiondate,"MM/dd/yyyy HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy") 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 | 21 September 2023

Top 3 Topics with Most Views

Dev Dives: Mastering AI-powered Document Understanding made by @Lahiru.Fernando with 48 views.

Problem with IfElseIf activity made by @Robert.Oslanec with 40 views.

Run uipath process from cmd line made by @parvathi_ayanala with 39 views.

Top 3 Topics with Most Replies

Excel Automation> Comparing 2 column and write final value in another column made by @anjasing with 20 replies.

Join datatable activity error made by @chandrakala.productanalys with 20 replies.

Send 10 outlook mails made by @anjani_priya with 19 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 51 posts!

@Nguyen_Van_Luong1 made 33 posts!

@Anil_G made 24 posts!

Top 3 Most Liked Posts

This post made by @Lahiru.Fernando received 5 likes!

Dev Dives: Mastering AI-powered Document Understanding

Hi UiPath Community, Are you eager to supercharge your document processing with the powerful duo of automation and AI? If so, mark your calendars for September 28 because you won’t want to miss the next Dev Dives episode! I’m Lahiru Fernando, Country Director/ RPA Lead (APAC)/ Practice Lead for Document Understanding & AI at Boundaryless Group and UiPath MVP. I’m excited about the upcoming Dev Dives session, where I’ll be sharing my insights and experiences with Document Understanding. Togeth…

This post made by @jjes received 3 likes!

Enhancing Video Recording with Queue Recording

A minute ago this didn’t exist, and now I can’t live without it

This post made by @Praveen_Mudhiraj received 2 likes!

UiPath - Flex - Attended - Named User

H! @Ankit_shukla If you purchase the “UiPath - Flex - Attended - Named User” license, you can use UiPath Studio to create automation workflows using C# and run attended automation processes. This license is suitable for users who actively participate in the automation development process and execute attended automations.

Top 3 Most Liked Solutions

This solution provided by @Praveen_Mudhiraj received 2 likes!

UiPath - Flex - Attended - Named User

H! @Ankit_shukla If you purchase the “UiPath - Flex - Attended - Named User” license, you can use UiPath Studio to create automation workflows using C# and run attended automation processes. This license is suitable for users who actively participate in the automation development process and execute attended automations.

This solution provided by @Praveen_Mudhiraj received 2 likes!

Excel matching data from another excel file

HI ! Can you try this Xaml…for your process hope it may help for you Xaml : - Excel matching data from another excel file.zip (2.4 KB) let me know its working or not @ISBS_ROBOT

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

Remove a certain column from excel

hi @Tanu_G kindly use remove data column activity and give the name you want to remove …and then write the data to excel

---

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

Top 3 Topics with Most Views

How to fetch specific values in excel file using LINQ? made by @Soundarya_Guduri1 with 49 views.

Excel Automation writing sheets data into a single sheet made by @Suthari_RohithReddy with 49 views.

マシンフリーズ時の対応方法 made by @h.yasuda with 47 views.

Top 3 Topics with Most Replies

Excel Automation writing sheets data into a single sheet made by @Suthari_RohithReddy with 25 replies.

Argument passing in python script made by @devanshi with 15 replies.

How to fetch specific values in excel file using LINQ? made by @Soundarya_Guduri1 with 12 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@Praveen_Mudhiraj made 30 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @Praveen_Mudhiraj received 2 likes!

How to share the Studio Process to client?

@yeshwanth To share a UiPath automation with a client without providing them with the Studio project file, you can publish the project to Orchestrator and then share it with the client. Here are the steps to do this: Publish the Project to Orchestrator: A. Click on the “Publish” button in the Studio ribbon. B. Choose your Orchestrator instance from the list (you should be connected to Orchestrator). C. Configure the publishing settings, such as the package version and release notes. D. Cli…

This post made by @Praveen_Mudhiraj received 2 likes!

How to share the Studio Process to client?

Ensure that you have the necessary permissions to view and manage environments. Orchestrator permissions are typically assigned by administrators, so contact them if you believe you should have access. @yeshwanth

This post made by @h.yasuda received 1 likes!

マシンフリーズ時の対応方法

URを使用しエラーが出た場合Orchestratorにアラート追加を行いたいと考えております。 その中でマシンがフリーズした場合どのような動作になるのか教えていただきたいです。 ①アクティビティのタイムアウトは機能しますでしょうか？ ②Orchestratorのプロセスタイムアウトの設定以外の方法ありますでしょうか？

Top 3 Most Liked Solutions

This solution provided by @Praveen_Mudhiraj received 1 likes!

.ByField in Excel Question

1.In UiPath’s “Excel Automation” activities, the .ByField property is used to specify how you want to filter or select specific cells or ranges within an Excel sheet. The term “field” here does indeed refer to individual cells or ranges in the Excel worksheet, not necessarily the same as a database field. 2.When you set the .ByField property to a specific value, you’re telling UiPath which criteria to use for selecting cells or ranges. It allows you to interact with Excel data more precisely. T…

This solution provided by @supermanPunch received 1 likes!

How to keep data and the blank rows between data

@Suastrian_Dika , In that case, Maybe you could check the below : DT = DT.AsEnumerable.Skipwhile(Function(x)String.IsNullOrWhiteSpace(x(0).ToString)).CopyToDatatable DT = DT.AsEnumerable.Reverse.Skipwhile(Function(x)String.IsNullOrWhiteSpace(x(0).ToString)).Reverse.CopyToDatatable Debug Panel : [image]

This solution provided by @Yoichi received 1 likes!

マシンフリーズ時の対応方法

こんにちは UiPathが動作しているマシンがフリーズしている状況でしょうか？ ①アクティビティのタイムアウトは機能しますでしょうか？ 期待しない方が良いかと思います。（状況によっては動作するかもしれませんが） ②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 | 23 September 2023

Top 3 Topics with Most Views

Add Column Headers to Existing Datatable made by @poojan.shah1 with 45 views.

String manipulation is not working if I try to write into excel made by @rajeshmushini312 with 38 views.

Need to remove the Dot(.) in the middle name? made by @SND0912 with 38 views.

Top 3 Topics with Most Replies

Need to remove the Dot(.) in the middle name? made by @SND0912 with 15 replies.

Read the next excel inside for each row made by @omar_ismail with 11 replies.

Add Column Headers to Existing Datatable made by @poojan.shah1 with 7 replies.

Top 3 Users Who Posted The Most

@Praveen_Mudhiraj made 31 posts!

@Palaniyappan made 16 posts!

@Anil_G made 13 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 1 likes!

Add Column Headers to Existing Datatable

@poojan.shah1 Hi Try with append range activity Use excel application scope inside use read range activity for reading the data which has data Below read range use append range activity and pass the read range output This will work if the two sheets are in same excel file. Cheers

This post made by @Praveen_Mudhiraj received 1 likes!

Regex to get only numbers.?

HI welcome @Sagar_Sukla you can use this regex expression you will get the output : 8900 System.Text.RegularExpressions.Regex.Match(str_Input,“[0-9]+”).Value for your reference : [image]

This post made by @Praveen_Mudhiraj received 1 likes!

Document Understand confidences

HI @Sagar_Sukla if you need the confidence scores in DU you can try this expression to get the exact output strExtractionResults=“Data Extraction Scope” activtiy output dt_ConfidencScore = strExtractionResults.AsDataSet(true,true).Tables(0).DefaultView.ToTable OutPut: it will get both confidence and ocr confidence score [image]

Top 3 Most Liked Solutions

This solution provided by @Praveen_Mudhiraj received 1 likes!

Regex to get only numbers.?

HI welcome @Sagar_Sukla you can use this regex expression you will get the output : 8900 System.Text.RegularExpressions.Regex.Match(str_Input,“[0-9]+”).Value for your reference : [image]

This solution provided by @Praveen_Mudhiraj received 1 likes!

Document Understand confidences

HI @Sagar_Sukla if you need the confidence scores in DU you can try this expression to get the exact output strExtractionResults=“Data Extraction Scope” activtiy output dt_ConfidencScore = strExtractionResults.AsDataSet(true,true).Tables(0).DefaultView.ToTable OutPut: it will get both confidence and ocr confidence score [image]

This solution provided by @Palaniyappan received 1 likes!

Getting an error while creating a Machine Template!have just given a random machine template name and provision button is still blocked!Thanks for any help!

Hi It’s indicating that when you create a machine template in UiPath Orchestrator, you need to allocate at least one execution slot to that machine template. This execution slot represents the capacity for running automation processes on the machine associated with the template. So you can allocate at least one execution slot by specifying the number of runtimes or capacity for that machine. In any of these fields The exact location and wording may vary depending on your Orchestrator versio…

---

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

Top 3 Topics with Most Views

Regex to get date made by @Swathi_Raju with 39 views.

I want to get the last word by splitting made by @vinjam_likitha with 39 views.

Deserialize the json file made by @suresh_kumar9 with 35 views.

Top 3 Topics with Most Replies

Does Automation process work when user is logged off? made by @imsre008 with 16 replies.

Outlookメールメッセージを取得アクティビティのフィルターについて made by @h.yasuda with 12 replies.

For each activity(Argument type) made by @J_Crosby with 11 replies.

Top 3 Users Who Posted The Most

@Praveen_Mudhiraj made 45 posts!

@Palaniyappan made 17 posts!

@Parvathy made 12 posts!

Top 3 Most Liked Posts

This post made by @Swathi_Raju received 2 likes!

Regex to get date

Thanks everyone it’s working

This post made by @suresh_kumar9 received 2 likes!

Deserialize the json file

Thank you… I got the output

This post made by @imsre008 received 1 likes!

Does Automation process work when user is logged off?

This is very much insightful. Thank you very much for sharing. Will try to install and follow this approach. Hopefully it works in the VM with unattended functions. Will give feedback after if it works or not .

Top 3 Most Liked Solutions

This solution provided by @Praveen_Mudhiraj received 1 likes!

I can't see excel application scope

maybe enable Filter for Classic in the Activities Panel and check. Refer the below post : Hope it will help for you @Swathi_Raju

This solution provided by @Praveen_Mudhiraj received 1 likes!

Argument ‘To’: BC30451:’inputError” is not declared

hi @Sara_Piana you can change the variable type you can see as image [image]

This solution provided by @Praveen_Mudhiraj received 1 likes!

Unble to find Packages

you see this steps hope it will help Check Your Published Package: *Make sure you have successfully published the project that contains your Main.xaml. Double-check the project.json file to ensure that the necessary files are included in the project. Check Your Publish Settings: When publishing the project, ensure that you have selected the right process and version. You should see the Main.xaml file listed as one of the files included in the package. Refresh Your Packages: After publis…

---

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

Top 3 Topics with Most Views

RegEx for Text File made by @prerna.gupta with 71 views.

Getting source does not contain any data row made by @Pogboom with 45 views.

Red exclamation mark in workflow made by @nien_shan_thai with 38 views.

Top 3 Topics with Most Replies

RegEx for Text File made by @prerna.gupta with 44 replies.

Getting source does not contain any data row made by @Pogboom with 22 replies.

Red exclamation mark in workflow made by @nien_shan_thai with 20 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 91 posts!

@Anil_G made 85 posts!

@Praveen_Mudhiraj made 66 posts!

Top 3 Most Liked Posts

This post made by @sagar.raval received 2 likes!

How to increment variable position in an array at the time of the creation

Im sorry for asking duplicate question about the same topic , but i want a answer to this problem and i really dont understand linq , im still learning (actually just started ), so thats why maybe if i ask any dumb question regarding linq, please forgive me and thank you so much for the people answering my question and helping me out @Anil_G @Palaniyappan @ppr and many more thank you for the solutions you provided , not just to this thread but too all of my previous threads , really apprec…

This post made by @maki received 2 likes!

Connect Automation Cloud API to PowerBI

@Anil_G @Palaniyappan thank you for your help. changed the Base URL and got the same error as the first one. I will create external application and check if the API endpoint is correct. Let me contact when these are done.

This post made by @marquezd received 2 likes!

Add a new value to a data table column

Tnks, it works I appreciate your help

Top 3 Most Liked Solutions

This solution provided by @marquezd received 2 likes!

Add a new value to a data table column

Tnks, it works I appreciate your help

This solution provided by @Palaniyappan received 1 likes!

How to upgrade 2019 and older versions of Robot and studio to 2022.10 version

Fine let’s go one by one For studio / Robots, you need to ensure that you are using a version compatible with Orchestrator 2022.10.6 or slightly ahead of your Orchestrator version is fine as well https://docs.uipath.com/robot/standalone/2022.10/user-guide/updating-the-robot https://docs.uipath.com/studio/standalone/2022.10/user-guide/update-studio Robot versions from 2018.4.4 onwards and versions up to 2020.4 can communicate with Orchestrator using the Long Polling communication method. Lo…

This solution provided by @Palaniyappan received 1 likes!

Can anyone explain "isolated" property of "invoke workflow" activity?

Fine I don’t have a code handy but to explain on scenarios Here you go If Isolated = True Scenario 1: You are using an activity to interact with a database. The database is located on a remote server, and the connection to the database is sometimes unreliable. You can set the Isolated property to True to prevent the main UiPath Studio process from crashing if the connection to the database fails. Scenario 2: You are using an activity to click on a button on a web page. The web page is som…

---

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

Top 3 Topics with Most Views

Splitting the characters made by @anjani_priya with 51 views.

Why robot still run old package although already publish/up latest version made by @anis.syafrina with 42 views.

「メールを送信」アクティビティについて教えてください made by @chiharu-kikuchi with 40 views.

Top 3 Topics with Most Replies

Splitting the characters made by @anjani_priya with 26 replies.

How can i kill process before using excel application scope made by @Soudios with 24 replies.

Delete rows from workbook if 2 columns contains "Y" made by @ayushi_jain3 with 21 replies.

Top 3 Users Who Posted The Most

@Anil_G made 75 posts!

@Praveen_Mudhiraj made 69 posts!

@Palaniyappan made 60 posts!

Top 3 Most Liked Posts

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

How to Enable backward compatibility after upgrading our orchestrator?

Check these documentations: https://docs.uipath.com/overview/other/latest/overview/orchestrator-upgrade-paths https://docs.uipath.com/overview/other/latest/overview/compatibility-matrix

This post made by @odure received 2 likes!

UiPath Bot Error

[MicrosoftTeams-image] Good day Friends - I hope we are well.I am trying to run a bot but it keeps stating failed to install the package. Please find attached the screenshot of the error. Many thanks. [MicrosoftTeams-image (3)]

This post made by @SURESH_P received 2 likes!

If any error while running sequence then i want run next loop

Hi All, I want to run the bot in a for each loop if an element is not found even though the Bot should run for the next iteration and should not fail. How can we do this.

Top 3 Most Liked Solutions

This solution provided by @tazunnisa.badavide received 1 likes!

Leer PDFc

(?<=(44. Documento de transporte).\s+.(?=\d{10}))\d{10} [image] (?<=(. 37. Declaración de Exportación ).[A-Za-z\s]+\d{1}\s).(?=\d)\d [image] (?<=(40.).[\sA-Za-z]+.\n+)[A-Z]+ [image] Let me know if it works

This solution provided by @Yoichi received 1 likes!

Send multiple email with different attachment

HI, Regarding the second question, can you try as the following? [image] listAttchement = CurrentRow.ItemArray.Skip(3).Select(Function(o) o.ToString).Where(Function(s) not String.IsNullOrEmpty(s)).ToList() Mock sample Sample20230927-3L.zip (11.4 KB) Regards,

This solution provided by @Praveen_Mudhiraj received 1 likes!

Splitting the words

HI @Pradeep_Kalyan you can try this way str_input = “8903 i am an RPA Developer” str_input.Split({" "},StringSplitOptions.None).Last [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 September 2023

Top 3 Topics with Most Views

Download files based on time made by @Anil_Rajavarapu1 with 55 views.

Not able to Install the Uipath studio after uninstall it made by @Rahul_Manu with 51 views.

Split the values from Data table cell and create new columns made by @Sathish_Kumar_S with 47 views.

Top 3 Topics with Most Replies

Download files based on time made by @Anil_Rajavarapu1 with 25 replies.

Create linear (single transaction) process with ReFramework using queue data made by @Newbie_23 with 21 replies.

Try catch not catching anything! made by @Mark007 with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 85 posts!

@Praveen_Mudhiraj made 70 posts!

@Anil_G made 51 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Split the values from Data table cell and create new columns

HI, How about the following sample? [image] dtResult = dt.AsEnumerable.Select(Function(r) dtResult.LoadDataRow({System.Text.RegularExpressions.Regex.Match(r(0).ToString,"(?<=Created\D+)\d+/\d+/\d+").Value,System.Text.RegularExpressions.Regex.Match(r(0).ToString,"(?<=Auto Process Date\D+)\d+/\d+/\d+").Value,r(1),r(2)},False)).OrderByDescending(Function(r) CDate(r("Created").ToString)).CopyToDataTable() Sample20230927-6L (2).zip (9.8 KB) Regards,

This post made by @Smitesh_Aher1 received 2 likes!

Is it possible to encrypt the json decrypted value?

Sorry i was putting wrong variable on writeline activity. so, it was giving me wrong output. Thanks @Palaniyappan & @Anil_G replying me.

This post made by @Praveen_Mudhiraj received 2 likes!

Split the words

Hi @vikas_Kumar1 You can try this way [image] (?<=Id[\s*]:)(?:\s)?[A-Z0-9]{10}

Top 3 Most Liked Solutions

This solution provided by @Praveen_Mudhiraj received 2 likes!

Split the words

Hi @vikas_Kumar1 You can try this way [image] (?<=Id[\s*]:)(?:\s)?[A-Z0-9]{10}

This solution provided by @Praveen_Mudhiraj received 2 likes!

Regex expression for "Method claim was submitted"

You can try this [image] @avinash_ghanwat1

This solution provided by @Palaniyappan received 1 likes!

Question s

Hi let me clarify one by one [image] [image] Hope this helps Cheers @Swathi_Raju

---

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

Top 3 Topics with Most Views

Where to start on SAP Automation made by @joscares with 45 views.

I need sort Date wise Ascending order in column of ALLOTMENTDATE made by @Balachander_Pandian with 42 views.

How can i Do? made by @Neeraj_Gupta1 with 41 views.

Top 3 Topics with Most Replies

Queue item status is failed need to retry the same activity and change the status back to successful made by @Ajith209 with 26 replies.

TypeInto activity won't type in 500 (integer) into website made by @tech2 with 24 replies.

How to remove delimiters made by @anjani_priya with 22 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 72 posts!

@Praveen_Mudhiraj made 64 posts!

@Anil_G made 35 posts!

Top 3 Most Liked Posts

This post made by @satishprasad14 received 2 likes!

How to avoid retries when working on queue and framework

Thanks @nikhil.girish @Palaniyappan

This post made by @Hara_Gopal received 2 likes!

How to update UiPath assistant?

Hi There, we have unattended Robots running on a few remote machines, the Studio was recently updated to 2023.4.4. How do i update the UiPath assitant version ? Does it come with studio or is it a standalone ? We curently don’t have Orchestrator, therefore the Assistant is always in offline mode Thanks Hara

This post made by @hocdvauto received 1 likes!

Monthly Forum Rewards - August 2023

Congratulations everyone

Top 3 Most Liked Solutions

This solution provided by @Parvathy received 1 likes!

Date and string

Hi @kaurM currentQuarter= If (DateTime.Now.Month >= 4, "Q1", If (DateTime.Now.Month >= 7, "Q2", If (DateTime.Now.Month >= 10, "Q3", "Q4"))) previousQuarter= If (currentQuarter = "Q1", "Q4", If (currentQuarter = "Q2", "Q1", If (currentQuarter = "Q3", "Q2", "Q3"))) fiscalYear= If (DateTime.Now.Month >= 4, DateTime.Now.Year, DateTime.Now.Year - 1) Message Box=> "Output: " & previousQuarter & "-xyz-F" & (fiscalYear Mod 100).ToString("00") Note: fiscalYear is of DataType …

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

Select item activity not performing

hi @Praveen_Sood ideally u can follow a diff approach you should be possible to use the click activity, only thing is your selector should be dynamic. Use two click activities ,one two expand the dropdown… the other click activity to click on the item you need…

This solution provided by @vinitha_yachamaneni received 1 likes!

How to upload a mailing list to an orchestrator queue?

Hi @alexis.mendoza You can try this Steps: Get Email Data (Subject and Body) Create a Queue in Orchestrator Note down Queue Name For Each email in MailingList Add Queue Item Queue Name: (Specify Queue Name) ItemInformation: “Subject” => email.Subject “Body” => email.Body Priority, DeferDate, DueDate, etc. as needed ItemInformation: Create a Dictionary variable where you can add the subject and body as key-value pairs. For example: Key: “Subject”, Value: (Subject of the email) K…

---

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.